DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on MTL_INTERFACE_ERRORS

Line 107: INSERT INTO MTL_INTERFACE_ERRORS

103: l_msg_name := 'EGO_TRANS_TYPE_INVALID';
104: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
105: l_msg_text := FND_MESSAGE.GET;
106:
107: INSERT INTO MTL_INTERFACE_ERRORS
108: (
109: TRANSACTION_ID
110: ,UNIQUE_ID
111: ,ORGANIZATION_ID

Line 191: INSERT INTO MTL_INTERFACE_ERRORS

187: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
188: l_msg_text := FND_MESSAGE.GET;
189:
190:
191: INSERT INTO MTL_INTERFACE_ERRORS
192: (
193: TRANSACTION_ID
194: ,UNIQUE_ID
195: ,ORGANIZATION_ID

Line 267: INSERT INTO MTL_INTERFACE_ERRORS

263: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
264: l_msg_text := FND_MESSAGE.GET;
265:
266:
267: INSERT INTO MTL_INTERFACE_ERRORS
268: (
269: TRANSACTION_ID
270: ,UNIQUE_ID
271: ,ORGANIZATION_ID

Line 349: INSERT INTO MTL_INTERFACE_ERRORS

345: ---
346: --- Insert for versioning interface table
347: ---
348:
349: INSERT INTO MTL_INTERFACE_ERRORS
350: (
351: TRANSACTION_ID
352: ,UNIQUE_ID
353: ,ORGANIZATION_ID

Line 455: INSERT INTO MTL_INTERFACE_ERRORS

451: ---- Validate some of the bare essential columns for
452: ---- every interface table
453:
454:
455: INSERT INTO MTL_INTERFACE_ERRORS
456: (
457: TRANSACTION_ID
458: ,UNIQUE_ID
459: ,ORGANIZATION_ID

Line 555: INSERT INTO MTL_INTERFACE_ERRORS

551:
552:
553: IF p_entity = G_ENTITY_ICC_AG_ASSOC THEN
554:
555: INSERT INTO MTL_INTERFACE_ERRORS
556: (
557: TRANSACTION_ID
558: ,UNIQUE_ID
559: ,ORGANIZATION_ID

Line 630: INSERT INTO MTL_INTERFACE_ERRORS

626: END IF ; -- ag assoc
627:
628: IF p_entity = G_ENTITY_ICC_FN_PARAM_MAP THEN
629:
630: INSERT INTO MTL_INTERFACE_ERRORS
631: (
632: TRANSACTION_ID
633: ,UNIQUE_ID
634: ,ORGANIZATION_ID

Line 729: INSERT INTO MTL_INTERFACE_ERRORS

725:
726:
727: --- Versioning interface columns
728: ---
729: INSERT INTO MTL_INTERFACE_ERRORS
730: (
731: TRANSACTION_ID
732: ,UNIQUE_ID
733: ,ORGANIZATION_ID

Line 800: INSERT INTO MTL_INTERFACE_ERRORS

796:
797:
798: --- Versioning interface columns
799: ---
800: INSERT INTO MTL_INTERFACE_ERRORS
801: (
802: TRANSACTION_ID
803: ,UNIQUE_ID
804: ,ORGANIZATION_ID

Line 876: INSERT INTO MTL_INTERFACE_ERRORS

872:
873:
874: --- Insert errors for ICC Name
875: ---
876: INSERT INTO MTL_INTERFACE_ERRORS
877: (
878: TRANSACTION_ID
879: ,UNIQUE_ID
880: ,ORGANIZATION_ID

Line 1032: --- insert into mtl_interface_errors

1028: ;
1029:
1030: write_debug (l_proc_name, '2');
1031:
1032: --- insert into mtl_interface_errors
1033: ---
1034:
1035: l_msg_name := 'EGO_ITEMCATALOG_INVALID';
1036: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

Line 1043: INSERT INTO MTL_INTERFACE_ERRORS

1039: write_debug (l_proc_name, '3');
1040:
1041: --- Insert errors for ICC Name
1042: ---
1043: INSERT INTO MTL_INTERFACE_ERRORS
1044: (
1045: TRANSACTION_ID
1046: ,UNIQUE_ID
1047: ,ORGANIZATION_ID

Line 1148: --- insert into mtl_interface_errors

1144: ;
1145:
1146: write_debug (l_proc_name, '7');
1147:
1148: --- insert into mtl_interface_errors
1149: ---
1150:
1151: l_msg_name := 'EGO_ICC_PARENT_INVALID';
1152: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

Line 1158: INSERT INTO MTL_INTERFACE_ERRORS

1154:
1155: write_debug (l_proc_name, '8');
1156: --- Insert errors for ICC Name
1157: ---
1158: INSERT INTO MTL_INTERFACE_ERRORS
1159: (
1160: TRANSACTION_ID
1161: ,UNIQUE_ID
1162: ,ORGANIZATION_ID

Line 1304: --- insert into mtl_interface_errors

1300: ;
1301:
1302: write_debug (l_proc_name, '14');
1303:
1304: --- insert into mtl_interface_errors
1305: ---
1306:
1307: l_msg_name := 'EGO_ITEMCATALOG_INVALID';
1308: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

Line 1311: INSERT INTO MTL_INTERFACE_ERRORS

1307: l_msg_name := 'EGO_ITEMCATALOG_INVALID';
1308: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
1309: l_msg_text := FND_MESSAGE.GET;
1310:
1311: INSERT INTO MTL_INTERFACE_ERRORS
1312: (
1313: TRANSACTION_ID
1314: ,UNIQUE_ID
1315: ,ORGANIZATION_ID

Line 1368: INSERT INTO MTL_INTERFACE_ERRORS

1364: l_msg_text2 := FND_MESSAGE.GET;
1365:
1366: write_debug (l_proc_name, '16');
1367:
1368: INSERT INTO MTL_INTERFACE_ERRORS
1369: (
1370: TRANSACTION_ID
1371: ,UNIQUE_ID
1372: ,ORGANIZATION_ID

Line 1665: --- insert into mtl_interface_errors

1661: ;
1662:
1663:
1664: write_debug (l_proc_name, '28');
1665: --- insert into mtl_interface_errors
1666: ---
1667:
1668: l_msg_name := 'EGO_ITEMCATALOG_INVALID';
1669: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

Line 1696: INSERT INTO MTL_INTERFACE_ERRORS

1692:
1693: write_debug (l_proc_name, '30');
1694: --- Insert errors for ICC Name
1695: ---
1696: INSERT INTO MTL_INTERFACE_ERRORS
1697: (
1698: TRANSACTION_ID
1699: ,UNIQUE_ID
1700: ,ORGANIZATION_ID

Line 1747: INSERT INTO MTL_INTERFACE_ERRORS

1743: ( efpmi.set_process_id = G_SET_PROCESS_ID)
1744: );
1745:
1746: write_debug (l_proc_name, '31');
1747: INSERT INTO MTL_INTERFACE_ERRORS
1748: (
1749: TRANSACTION_ID
1750: ,UNIQUE_ID
1751: ,ORGANIZATION_ID

Line 1798: INSERT INTO MTL_INTERFACE_ERRORS

1794: ( efpmi.set_process_id = G_SET_PROCESS_ID)
1795: );
1796:
1797: write_debug (l_proc_name, '32');
1798: INSERT INTO MTL_INTERFACE_ERRORS
1799: (
1800: TRANSACTION_ID
1801: ,UNIQUE_ID
1802: ,ORGANIZATION_ID

Line 1853: INSERT INTO MTL_INTERFACE_ERRORS

1849: write_debug (l_proc_name, '33');
1850: ---
1851: --- Function name errors
1852: ---
1853: INSERT INTO MTL_INTERFACE_ERRORS
1854: (
1855: TRANSACTION_ID
1856: ,UNIQUE_ID
1857: ,ORGANIZATION_ID

Line 1905: INSERT INTO MTL_INTERFACE_ERRORS

1901: )
1902: ;
1903:
1904: write_debug (l_proc_name, '34');
1905: INSERT INTO MTL_INTERFACE_ERRORS
1906: (
1907: TRANSACTION_ID
1908: ,UNIQUE_ID
1909: ,ORGANIZATION_ID

Line 2022: --- insert into mtl_interface_errors

2018: ;
2019:
2020: write_debug(l_proc_name, 'updated id');
2021: --commit;
2022: --- insert into mtl_interface_errors
2023: ---
2024:
2025: l_msg_name := 'EGO_ICC_ID_INVALID';
2026: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

Line 2032: INSERT INTO MTL_INTERFACE_ERRORS

2028:
2029:
2030: --- Insert errors for ICC Name
2031: ---
2032: INSERT INTO MTL_INTERFACE_ERRORS
2033: (
2034: TRANSACTION_ID
2035: ,UNIQUE_ID
2036: ,ORGANIZATION_ID