1024: -- Otherwise, that record exists in the interface tables
1025: SELECT COUNT(*)
1026: INTO l_error_count
1027: FROM mtl_system_items_interface
1028: WHERE request_id = FND_GLOBAL.conc_request_id
1029: /*AND process_flag = 4; Bug 5962957 Changing this to 1 since the records are passed in as process_flag 1*/
1030: AND process_flag = 1;
1031:
1032: IF l_error_count > 0 THEN
1800: , get_encumbrance_account(l_filtered_org_tbl(l_Idx))
1801: , get_sales_account(l_filtered_org_tbl(l_Idx))
1802: , get_expense_account(l_filtered_org_tbl(l_Idx))
1803: , SYSDATE
1804: , FND_GLOBAL.user_id
1805: , SYSDATE
1806: , FND_GLOBAL.user_id
1807: , FND_GLOBAL.login_id
1808: , FND_GLOBAL.conc_request_id
1802: , get_expense_account(l_filtered_org_tbl(l_Idx))
1803: , SYSDATE
1804: , FND_GLOBAL.user_id
1805: , SYSDATE
1806: , FND_GLOBAL.user_id
1807: , FND_GLOBAL.login_id
1808: , FND_GLOBAL.conc_request_id
1809: , FND_GLOBAL.prog_appl_id
1810: , FND_GLOBAL.conc_program_id
1803: , SYSDATE
1804: , FND_GLOBAL.user_id
1805: , SYSDATE
1806: , FND_GLOBAL.user_id
1807: , FND_GLOBAL.login_id
1808: , FND_GLOBAL.conc_request_id
1809: , FND_GLOBAL.prog_appl_id
1810: , FND_GLOBAL.conc_program_id
1811: , SYSDATE
1804: , FND_GLOBAL.user_id
1805: , SYSDATE
1806: , FND_GLOBAL.user_id
1807: , FND_GLOBAL.login_id
1808: , FND_GLOBAL.conc_request_id
1809: , FND_GLOBAL.prog_appl_id
1810: , FND_GLOBAL.conc_program_id
1811: , SYSDATE
1812: );
1805: , SYSDATE
1806: , FND_GLOBAL.user_id
1807: , FND_GLOBAL.login_id
1808: , FND_GLOBAL.conc_request_id
1809: , FND_GLOBAL.prog_appl_id
1810: , FND_GLOBAL.conc_program_id
1811: , SYSDATE
1812: );
1813:
1806: , FND_GLOBAL.user_id
1807: , FND_GLOBAL.login_id
1808: , FND_GLOBAL.conc_request_id
1809: , FND_GLOBAL.prog_appl_id
1810: , FND_GLOBAL.conc_program_id
1811: , SYSDATE
1812: );
1813:
1814:
1933: ,/*4 Bug 5962957 here the validation should happen so changing it to 1*/ 1
1934: ,'CREATE'
1935: ,l_set_process_id
1936: ,SYSDATE
1937: ,FND_GLOBAL.user_id
1938: ,SYSDATE
1939: ,FND_GLOBAL.user_id
1940: ,FND_GLOBAL.login_id
1941: ,FND_GLOBAL.conc_request_id
1935: ,l_set_process_id
1936: ,SYSDATE
1937: ,FND_GLOBAL.user_id
1938: ,SYSDATE
1939: ,FND_GLOBAL.user_id
1940: ,FND_GLOBAL.login_id
1941: ,FND_GLOBAL.conc_request_id
1942: ,FND_GLOBAL.prog_appl_id
1943: ,FND_GLOBAL.conc_program_id
1936: ,SYSDATE
1937: ,FND_GLOBAL.user_id
1938: ,SYSDATE
1939: ,FND_GLOBAL.user_id
1940: ,FND_GLOBAL.login_id
1941: ,FND_GLOBAL.conc_request_id
1942: ,FND_GLOBAL.prog_appl_id
1943: ,FND_GLOBAL.conc_program_id
1944: ,SYSDATE
1937: ,FND_GLOBAL.user_id
1938: ,SYSDATE
1939: ,FND_GLOBAL.user_id
1940: ,FND_GLOBAL.login_id
1941: ,FND_GLOBAL.conc_request_id
1942: ,FND_GLOBAL.prog_appl_id
1943: ,FND_GLOBAL.conc_program_id
1944: ,SYSDATE
1945: ,MTL_ITEM_REVISIONS_B_S.nextval
1938: ,SYSDATE
1939: ,FND_GLOBAL.user_id
1940: ,FND_GLOBAL.login_id
1941: ,FND_GLOBAL.conc_request_id
1942: ,FND_GLOBAL.prog_appl_id
1943: ,FND_GLOBAL.conc_program_id
1944: ,SYSDATE
1945: ,MTL_ITEM_REVISIONS_B_S.nextval
1946: );
1939: ,FND_GLOBAL.user_id
1940: ,FND_GLOBAL.login_id
1941: ,FND_GLOBAL.conc_request_id
1942: ,FND_GLOBAL.prog_appl_id
1943: ,FND_GLOBAL.conc_program_id
1944: ,SYSDATE
1945: ,MTL_ITEM_REVISIONS_B_S.nextval
1946: );
1947: