786: , l_encumbrance_account
787: , l_sales_account
788: , l_expense_account
789: , SYSDATE
790: , FND_GLOBAL.user_id
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , FND_GLOBAL.login_id
794: , FND_GLOBAL.conc_request_id
788: , l_expense_account
789: , SYSDATE
790: , FND_GLOBAL.user_id
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , FND_GLOBAL.login_id
794: , FND_GLOBAL.conc_request_id
795: , FND_GLOBAL.prog_appl_id
796: , FND_GLOBAL.conc_program_id
789: , SYSDATE
790: , FND_GLOBAL.user_id
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , FND_GLOBAL.login_id
794: , FND_GLOBAL.conc_request_id
795: , FND_GLOBAL.prog_appl_id
796: , FND_GLOBAL.conc_program_id
797: , SYSDATE
790: , FND_GLOBAL.user_id
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , FND_GLOBAL.login_id
794: , FND_GLOBAL.conc_request_id
795: , FND_GLOBAL.prog_appl_id
796: , FND_GLOBAL.conc_program_id
797: , SYSDATE
798: , l_mtl_system_items_tbl(l_counter).purchasing_enabled_flag
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , FND_GLOBAL.login_id
794: , FND_GLOBAL.conc_request_id
795: , FND_GLOBAL.prog_appl_id
796: , FND_GLOBAL.conc_program_id
797: , SYSDATE
798: , l_mtl_system_items_tbl(l_counter).purchasing_enabled_flag
799: , l_mtl_system_items_tbl(l_counter).customer_order_enabled_flag
792: , FND_GLOBAL.user_id
793: , FND_GLOBAL.login_id
794: , FND_GLOBAL.conc_request_id
795: , FND_GLOBAL.prog_appl_id
796: , FND_GLOBAL.conc_program_id
797: , SYSDATE
798: , l_mtl_system_items_tbl(l_counter).purchasing_enabled_flag
799: , l_mtl_system_items_tbl(l_counter).customer_order_enabled_flag
800: , l_mtl_system_items_tbl(l_counter).internal_order_enabled_flag
894: ,l_process_flag --myerrams, Bug: 4892069
895: ,'CREATE'
896: ,l_set_process_id
897: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,SYSDATE
900: ,FND_GLOBAL.user_id
901: ,FND_GLOBAL.login_id
902: ,FND_GLOBAL.conc_request_id
896: ,l_set_process_id
897: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,SYSDATE
900: ,FND_GLOBAL.user_id
901: ,FND_GLOBAL.login_id
902: ,FND_GLOBAL.conc_request_id
903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
897: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,SYSDATE
900: ,FND_GLOBAL.user_id
901: ,FND_GLOBAL.login_id
902: ,FND_GLOBAL.conc_request_id
903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
905: ,SYSDATE
898: ,FND_GLOBAL.user_id
899: ,SYSDATE
900: ,FND_GLOBAL.user_id
901: ,FND_GLOBAL.login_id
902: ,FND_GLOBAL.conc_request_id
903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
905: ,SYSDATE
906: FROM mtl_item_revisions_b mir
899: ,SYSDATE
900: ,FND_GLOBAL.user_id
901: ,FND_GLOBAL.login_id
902: ,FND_GLOBAL.conc_request_id
903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
905: ,SYSDATE
906: FROM mtl_item_revisions_b mir
907: ,mtl_system_items_interface msi
900: ,FND_GLOBAL.user_id
901: ,FND_GLOBAL.login_id
902: ,FND_GLOBAL.conc_request_id
903: ,FND_GLOBAL.prog_appl_id
904: ,FND_GLOBAL.conc_program_id
905: ,SYSDATE
906: FROM mtl_item_revisions_b mir
907: ,mtl_system_items_interface msi
908: WHERE mir.inventory_item_id = msi.inventory_item_id
975: ,1 --myerrams, Bug: 5624219; ProcessFlag for Item Categories has to be 1 irrespective of validate items option.
976: ,'CREATE'
977: ,l_set_process_id
978: ,SYSDATE
979: ,FND_GLOBAL.user_id
980: ,SYSDATE
981: ,FND_GLOBAL.user_id
982: ,FND_GLOBAL.login_id
983: ,FND_GLOBAL.conc_request_id
977: ,l_set_process_id
978: ,SYSDATE
979: ,FND_GLOBAL.user_id
980: ,SYSDATE
981: ,FND_GLOBAL.user_id
982: ,FND_GLOBAL.login_id
983: ,FND_GLOBAL.conc_request_id
984: ,FND_GLOBAL.prog_appl_id
985: ,FND_GLOBAL.conc_program_id
978: ,SYSDATE
979: ,FND_GLOBAL.user_id
980: ,SYSDATE
981: ,FND_GLOBAL.user_id
982: ,FND_GLOBAL.login_id
983: ,FND_GLOBAL.conc_request_id
984: ,FND_GLOBAL.prog_appl_id
985: ,FND_GLOBAL.conc_program_id
986: ,SYSDATE
979: ,FND_GLOBAL.user_id
980: ,SYSDATE
981: ,FND_GLOBAL.user_id
982: ,FND_GLOBAL.login_id
983: ,FND_GLOBAL.conc_request_id
984: ,FND_GLOBAL.prog_appl_id
985: ,FND_GLOBAL.conc_program_id
986: ,SYSDATE
987: FROM mtl_category_sets_b mcs
980: ,SYSDATE
981: ,FND_GLOBAL.user_id
982: ,FND_GLOBAL.login_id
983: ,FND_GLOBAL.conc_request_id
984: ,FND_GLOBAL.prog_appl_id
985: ,FND_GLOBAL.conc_program_id
986: ,SYSDATE
987: FROM mtl_category_sets_b mcs
988: ,mtl_system_items_interface msi
981: ,FND_GLOBAL.user_id
982: ,FND_GLOBAL.login_id
983: ,FND_GLOBAL.conc_request_id
984: ,FND_GLOBAL.prog_appl_id
985: ,FND_GLOBAL.conc_program_id
986: ,SYSDATE
987: FROM mtl_category_sets_b mcs
988: ,mtl_system_items_interface msi
989: ,mtl_item_categories mic
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: x_return_message := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1070: x_return_message := x_return_message || FND_GLOBAL.NewLine || SQLCODE || ' : ' || SQLERRM;
1071:
1072: IF(g_statement_level >= g_debug_level)
1073: THEN
1074: FND_LOG.string(g_statement_level