OPM Quality Supplier Spec Validaty Rule API

apps.gmd_spec_vrs_pub.create_supplier_spec_vrs
                    ( p_api_version            => '1.0'
                    , p_init_msg_list          => 'F'
                    , p_commit                 => 'F'
                    , p_validation_level       => apps.FND_API.G_VALID_LEVEL_FULL
                    , p_supplier_spec_vrs_tbl  => l_supplier_spec_vrs_tbl
                    , p_user_name              => l_user_name
                    , x_supplier_spec_vrs_tbl  => l_supplier_spec_vrs_tbl
                    , x_return_status          => l_return_status
                    , x_msg_count              => l_msg_count
                    , x_msg_data               => l_msg_data
                    );

OPM Quality WIP Spec Validaty Rule API

 apps.gmd_spec_vrs_pub.create_wip_spec_vrs
                        ( p_api_version            =>'1.0'
                        , p_init_msg_list          => 'F'
                        , p_commit                 => 'F'
                        , p_validation_level       => apps.FND_API.G_VALID_LEVEL_FULL
                        , p_wip_spec_vrs_tbl       => l_wip_spec_vrs_tbl 
                        , p_user_name              => l_user_name
                        , x_wip_spec_vrs_tbl       => l_wip_spec_vrs_out_tbl
                        , x_return_status          => l_return_status
                        , x_msg_count              => l_msg_count
                        , x_msg_data               => l_msg_data
                        );
                       

OPM Quality Inventory Spec Validaty Rule API

 apps.gmd_spec_vrs_pub.create_inventory_spec_vrs
                                    ( p_api_version            => '1.0'
                                    , p_init_msg_list          => 'F'
                                    , p_commit                 => 'F'
                                    , p_validation_level       => apps.FND_API.G_VALID_LEVEL_FULL
                                    , p_inventory_spec_vrs_tbl => l_inventory_spec_vrs_tbl
                                    , p_user_name              => l_user_name
                                    , x_inventory_spec_vrs_tbl => l_inventory_spec_vrs_out_tbl
                                    , x_return_status          => l_return_status
                                    , x_msg_count              => l_msg_count
                                    , x_msg_data               => l_msg_data
                                    );

OPM Quality Specification Validaty Rules API

 apps.GMD_SPEC_PUB.CREATE_SPEC
                                    ( p_api_version          => 2.0
                                    , p_init_msg_list        => apps.FND_API.G_FALSE
                                    , p_commit               => apps.FND_API.G_FALSE
                                    , p_validation_level     => apps.fnd_api.g_valid_level_full
                                    , p_spec                 => l_gmd_spec_tbl 
                                    , p_spec_tests_tbl       => l_spec_tests_tbl
                                    , p_user_name            => l_user_name
                                    , x_spec                 => x_gmd_spec_tbl
                                    , x_spec_tests_tbl       => x_spec_tests_tbl
                                    , x_return_status        => l_return_status
                                    , x_msg_count            => l_msg_count
                                    , x_msg_data             => l_msg_data
                                    );

OPM Recipe API

apps.GMD_RECIPE_HEADER.CREATE_RECIPE_HEADER(
                                            p_api_version              => '1.0'       
                                           ,p_init_msg_list            => 'T'   
                                           ,p_commit                   => 'F'     
                                           ,p_called_from_forms        => 'NO'
                                           ,x_return_status            => l_return_status
                                           ,x_msg_count                => l_msg_count
                                           ,x_msg_data                 => l_msg_data
                                           ,p_recipe_header_tbl        => l_recipe_tbl
                                           ,p_recipe_header_flex       => l_recipe_flex
                                          );

OPM Operation API

 apps.gmd_operations_pub.insert_operation
                                                      (p_api_version        => '1.0',
                                                       p_init_msg_list      => TRUE,
                                                       p_commit             => FALSE,
                                                       p_operations         => l_operations_tbl,
                                                       p_oprn_actv_tbl      => l_oprn_activities_tbl_type,
                                                       x_message_count      => l_msg_count,
                                                       x_message_list       => l_msg_data,
                                                       x_return_status      => l_return_status,
                                                       p_oprn_rsrc_tbl      => l_oprn_resources_tbl_type
                                                      );

OPM Routing API

 apps.GMD_ROUTINGS_PUB.insert_routing
                                      ( p_api_version            => 1.0
                                      , p_init_msg_list          => TRUE
                                      , p_commit                 => FALSE
                                      , p_routings               => l_routings_type
                                      , p_routings_step_tbl      => l_routings_step_tab
                                      , p_routings_step_dep_tbl  => l_routings_step_dep_tab
                                      , x_message_count          => l_msg_count
                                      , x_message_list           => l_msg_data
                                      , x_return_status          => l_return_status
                                      );

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;