Sunday 13 January 2013

OPM Formula API

  BEGIN
                 
                  apps.gmd_formula_pub.insert_formula
                                    (p_api_version             => '1.0',
                                     p_init_msg_list           => 'T',
                                     p_commit                  => 'T',
                                     p_called_from_forms       => 'NO',
                                     x_return_status           => l_return_status,
                                     x_msg_count               => l_msg_count,
                                     x_msg_data                => l_msg_data,
                                     p_formula_header_tbl      => l_frmla_inst_tbl,
                                     p_allow_zero_ing_qty      => 'FALSE'
                                    );
                  COMMIT;
                  apps.fnd_file.put_line (apps.fnd_file.LOG,'API RAISED ERROR: '|| SQLCODE|| '-'|| SQLERRM|| l_msg_count);
               EXCEPTION
                  WHEN OTHERS
                  THEN
                     apps.fnd_file.put_line (apps.fnd_file.LOG,'API RAISED ERROR: '|| SQLCODE|| '-'|| SQLERRM);
                     apps.fnd_file.put_line (apps.fnd_file.LOG,'TRACK 13.6' || l_return_status);
                     apps.fnd_file.put_line (apps.fnd_file.LOG,'TRACK 13.4 data:' || l_msg_data);
               END;

No comments:

Post a Comment

Note: only a member of this blog may post a comment.