788: , l_encumbrance_account
789: , l_sales_account
790: , l_expense_account
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , SYSDATE
794: , FND_GLOBAL.user_id
795: , FND_GLOBAL.login_id
796: , FND_GLOBAL.conc_request_id
790: , l_expense_account
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , SYSDATE
794: , FND_GLOBAL.user_id
795: , FND_GLOBAL.login_id
796: , FND_GLOBAL.conc_request_id
797: , FND_GLOBAL.prog_appl_id
798: , FND_GLOBAL.conc_program_id
791: , SYSDATE
792: , FND_GLOBAL.user_id
793: , SYSDATE
794: , FND_GLOBAL.user_id
795: , FND_GLOBAL.login_id
796: , FND_GLOBAL.conc_request_id
797: , FND_GLOBAL.prog_appl_id
798: , FND_GLOBAL.conc_program_id
799: , SYSDATE
792: , FND_GLOBAL.user_id
793: , SYSDATE
794: , FND_GLOBAL.user_id
795: , FND_GLOBAL.login_id
796: , FND_GLOBAL.conc_request_id
797: , FND_GLOBAL.prog_appl_id
798: , FND_GLOBAL.conc_program_id
799: , SYSDATE
800: , l_mtl_system_items_tbl(l_counter).purchasing_enabled_flag
793: , SYSDATE
794: , FND_GLOBAL.user_id
795: , FND_GLOBAL.login_id
796: , FND_GLOBAL.conc_request_id
797: , FND_GLOBAL.prog_appl_id
798: , FND_GLOBAL.conc_program_id
799: , SYSDATE
800: , l_mtl_system_items_tbl(l_counter).purchasing_enabled_flag
801: , l_mtl_system_items_tbl(l_counter).customer_order_enabled_flag
794: , FND_GLOBAL.user_id
795: , FND_GLOBAL.login_id
796: , FND_GLOBAL.conc_request_id
797: , FND_GLOBAL.prog_appl_id
798: , FND_GLOBAL.conc_program_id
799: , SYSDATE
800: , l_mtl_system_items_tbl(l_counter).purchasing_enabled_flag
801: , l_mtl_system_items_tbl(l_counter).customer_order_enabled_flag
802: , l_mtl_system_items_tbl(l_counter).internal_order_enabled_flag
914: ,l_process_flag --myerrams, Bug: 4892069
915: ,'CREATE'
916: ,l_set_process_id
917: ,SYSDATE
918: ,FND_GLOBAL.user_id
919: ,SYSDATE
920: ,FND_GLOBAL.user_id
921: ,FND_GLOBAL.login_id
922: ,FND_GLOBAL.conc_request_id
916: ,l_set_process_id
917: ,SYSDATE
918: ,FND_GLOBAL.user_id
919: ,SYSDATE
920: ,FND_GLOBAL.user_id
921: ,FND_GLOBAL.login_id
922: ,FND_GLOBAL.conc_request_id
923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
917: ,SYSDATE
918: ,FND_GLOBAL.user_id
919: ,SYSDATE
920: ,FND_GLOBAL.user_id
921: ,FND_GLOBAL.login_id
922: ,FND_GLOBAL.conc_request_id
923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
925: ,SYSDATE
918: ,FND_GLOBAL.user_id
919: ,SYSDATE
920: ,FND_GLOBAL.user_id
921: ,FND_GLOBAL.login_id
922: ,FND_GLOBAL.conc_request_id
923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
925: ,SYSDATE
926: FROM mtl_item_revisions_b mir
919: ,SYSDATE
920: ,FND_GLOBAL.user_id
921: ,FND_GLOBAL.login_id
922: ,FND_GLOBAL.conc_request_id
923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
925: ,SYSDATE
926: FROM mtl_item_revisions_b mir
927: ,mtl_system_items_interface msi
920: ,FND_GLOBAL.user_id
921: ,FND_GLOBAL.login_id
922: ,FND_GLOBAL.conc_request_id
923: ,FND_GLOBAL.prog_appl_id
924: ,FND_GLOBAL.conc_program_id
925: ,SYSDATE
926: FROM mtl_item_revisions_b mir
927: ,mtl_system_items_interface msi
928: WHERE mir.inventory_item_id = msi.inventory_item_id
995: ,1 --myerrams, Bug: 5624219; ProcessFlag for Item Categories has to be 1 irrespective of validate items option.
996: ,'CREATE'
997: ,l_set_process_id
998: ,SYSDATE
999: ,FND_GLOBAL.user_id
1000: ,SYSDATE
1001: ,FND_GLOBAL.user_id
1002: ,FND_GLOBAL.login_id
1003: ,FND_GLOBAL.conc_request_id
997: ,l_set_process_id
998: ,SYSDATE
999: ,FND_GLOBAL.user_id
1000: ,SYSDATE
1001: ,FND_GLOBAL.user_id
1002: ,FND_GLOBAL.login_id
1003: ,FND_GLOBAL.conc_request_id
1004: ,FND_GLOBAL.prog_appl_id
1005: ,FND_GLOBAL.conc_program_id
998: ,SYSDATE
999: ,FND_GLOBAL.user_id
1000: ,SYSDATE
1001: ,FND_GLOBAL.user_id
1002: ,FND_GLOBAL.login_id
1003: ,FND_GLOBAL.conc_request_id
1004: ,FND_GLOBAL.prog_appl_id
1005: ,FND_GLOBAL.conc_program_id
1006: ,SYSDATE
999: ,FND_GLOBAL.user_id
1000: ,SYSDATE
1001: ,FND_GLOBAL.user_id
1002: ,FND_GLOBAL.login_id
1003: ,FND_GLOBAL.conc_request_id
1004: ,FND_GLOBAL.prog_appl_id
1005: ,FND_GLOBAL.conc_program_id
1006: ,SYSDATE
1007: FROM mtl_category_sets_b mcs
1000: ,SYSDATE
1001: ,FND_GLOBAL.user_id
1002: ,FND_GLOBAL.login_id
1003: ,FND_GLOBAL.conc_request_id
1004: ,FND_GLOBAL.prog_appl_id
1005: ,FND_GLOBAL.conc_program_id
1006: ,SYSDATE
1007: FROM mtl_category_sets_b mcs
1008: ,mtl_system_items_interface msi
1001: ,FND_GLOBAL.user_id
1002: ,FND_GLOBAL.login_id
1003: ,FND_GLOBAL.conc_request_id
1004: ,FND_GLOBAL.prog_appl_id
1005: ,FND_GLOBAL.conc_program_id
1006: ,SYSDATE
1007: FROM mtl_category_sets_b mcs
1008: ,mtl_system_items_interface msi
1009: ,mtl_item_categories mic
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: x_return_message := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);
1090: x_return_message := x_return_message || FND_GLOBAL.NewLine || SQLCODE || ' : ' || SQLERRM;
1091:
1092: IF(g_statement_level >= g_debug_level)
1093: THEN
1094: FND_LOG.string(g_statement_level