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
1796: , get_encumbrance_account(l_filtered_org_tbl(l_Idx))
1797: , get_sales_account(l_filtered_org_tbl(l_Idx))
1798: , get_expense_account(l_filtered_org_tbl(l_Idx))
1799: , SYSDATE
1800: , FND_GLOBAL.user_id
1801: , SYSDATE
1802: , FND_GLOBAL.user_id
1803: , FND_GLOBAL.login_id
1804: , FND_GLOBAL.conc_request_id
1798: , get_expense_account(l_filtered_org_tbl(l_Idx))
1799: , SYSDATE
1800: , FND_GLOBAL.user_id
1801: , SYSDATE
1802: , FND_GLOBAL.user_id
1803: , FND_GLOBAL.login_id
1804: , FND_GLOBAL.conc_request_id
1805: , FND_GLOBAL.prog_appl_id
1806: , FND_GLOBAL.conc_program_id
1799: , SYSDATE
1800: , FND_GLOBAL.user_id
1801: , SYSDATE
1802: , FND_GLOBAL.user_id
1803: , FND_GLOBAL.login_id
1804: , FND_GLOBAL.conc_request_id
1805: , FND_GLOBAL.prog_appl_id
1806: , FND_GLOBAL.conc_program_id
1807: , SYSDATE
1800: , FND_GLOBAL.user_id
1801: , SYSDATE
1802: , FND_GLOBAL.user_id
1803: , FND_GLOBAL.login_id
1804: , FND_GLOBAL.conc_request_id
1805: , FND_GLOBAL.prog_appl_id
1806: , FND_GLOBAL.conc_program_id
1807: , SYSDATE
1808: );
1801: , SYSDATE
1802: , FND_GLOBAL.user_id
1803: , FND_GLOBAL.login_id
1804: , FND_GLOBAL.conc_request_id
1805: , FND_GLOBAL.prog_appl_id
1806: , FND_GLOBAL.conc_program_id
1807: , SYSDATE
1808: );
1809:
1802: , FND_GLOBAL.user_id
1803: , FND_GLOBAL.login_id
1804: , FND_GLOBAL.conc_request_id
1805: , FND_GLOBAL.prog_appl_id
1806: , FND_GLOBAL.conc_program_id
1807: , SYSDATE
1808: );
1809:
1810:
1904: ,/*4 Bug 5962957 here the validation should happen so changing it to 1*/ 1
1905: ,'CREATE'
1906: ,l_set_process_id
1907: ,SYSDATE
1908: ,FND_GLOBAL.user_id
1909: ,SYSDATE
1910: ,FND_GLOBAL.user_id
1911: ,FND_GLOBAL.login_id
1912: ,FND_GLOBAL.conc_request_id
1906: ,l_set_process_id
1907: ,SYSDATE
1908: ,FND_GLOBAL.user_id
1909: ,SYSDATE
1910: ,FND_GLOBAL.user_id
1911: ,FND_GLOBAL.login_id
1912: ,FND_GLOBAL.conc_request_id
1913: ,FND_GLOBAL.prog_appl_id
1914: ,FND_GLOBAL.conc_program_id
1907: ,SYSDATE
1908: ,FND_GLOBAL.user_id
1909: ,SYSDATE
1910: ,FND_GLOBAL.user_id
1911: ,FND_GLOBAL.login_id
1912: ,FND_GLOBAL.conc_request_id
1913: ,FND_GLOBAL.prog_appl_id
1914: ,FND_GLOBAL.conc_program_id
1915: ,SYSDATE
1908: ,FND_GLOBAL.user_id
1909: ,SYSDATE
1910: ,FND_GLOBAL.user_id
1911: ,FND_GLOBAL.login_id
1912: ,FND_GLOBAL.conc_request_id
1913: ,FND_GLOBAL.prog_appl_id
1914: ,FND_GLOBAL.conc_program_id
1915: ,SYSDATE
1916: ,MTL_ITEM_REVISIONS_B_S.nextval
1909: ,SYSDATE
1910: ,FND_GLOBAL.user_id
1911: ,FND_GLOBAL.login_id
1912: ,FND_GLOBAL.conc_request_id
1913: ,FND_GLOBAL.prog_appl_id
1914: ,FND_GLOBAL.conc_program_id
1915: ,SYSDATE
1916: ,MTL_ITEM_REVISIONS_B_S.nextval
1917: );
1910: ,FND_GLOBAL.user_id
1911: ,FND_GLOBAL.login_id
1912: ,FND_GLOBAL.conc_request_id
1913: ,FND_GLOBAL.prog_appl_id
1914: ,FND_GLOBAL.conc_program_id
1915: ,SYSDATE
1916: ,MTL_ITEM_REVISIONS_B_S.nextval
1917: );
1918: