DBA Data[Home] [Help]

APPS.EGO_PAGES_BULKLOAD_PVT dependencies on MTL_INTERFACE_ERRORS

Line 113: MTL_INTERFACE_ERRORS if TRANSACTION_TYPE passed is incorrect*/

109:
110: x_return_status := G_RET_STS_SUCCESS;
111:
112: /* Update the interface records with process_status 3 and insert into
113: MTL_INTERFACE_ERRORS if TRANSACTION_TYPE passed is incorrect*/
114: G_MESSAGE_NAME := 'EGO_TRANS_TYPE_INVALID';
115:
116: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_TRANS_TYPE_INVALID');
117:

Line 124: INSERT INTO mtl_interface_errors

120: lv_smt := 1;
121:
122: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
123:
124: INSERT INTO mtl_interface_errors
125: (transaction_id,
126: unique_id,
127: organization_id,
128: column_name,

Line 185: INSERT INTO mtl_interface_errors

181: lv_smt := 2;
182:
183: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
184:
185: INSERT INTO mtl_interface_errors
186: (transaction_id,
187: unique_id,
188: organization_id,
189: column_name,

Line 1376: MTL_INTERFACE_ERRORS if the ICC name passed is invalid*/

1372:
1373: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1.1');
1374:
1375: /* Update the interface records with process_status 3 and insert into
1376: MTL_INTERFACE_ERRORS if the ICC name passed is invalid*/
1377: G_MESSAGE_NAME := 'EGO_ICC_ID_INVALID';
1378:
1379: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_ICC_ID_INVALID');
1380:

Line 1383: INSERT INTO mtl_interface_errors

1379: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_ICC_ID_INVALID');
1380:
1381: G_MESSAGE_TEXT := fnd_message.get;
1382:
1383: INSERT INTO mtl_interface_errors
1384: (transaction_id,
1385: unique_id,
1386: organization_id,
1387: column_name,

Line 1443: MTL_INTERFACE_ERRORS if the page does not exist for update and delete flow*/

1439:
1440: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1.1');
1441:
1442: /* Update the interface records with process_status 3 and insert into
1443: MTL_INTERFACE_ERRORS if the page does not exist for update and delete flow*/
1444: G_MESSAGE_NAME := 'EGO_EF_ATTR_PAGE_NOT_FOUND';
1445:
1446: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_EF_ATTR_PAGE_NOT_FOUND');
1447:

Line 1450: INSERT INTO mtl_interface_errors

1446: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_EF_ATTR_PAGE_NOT_FOUND');
1447:
1448: G_MESSAGE_TEXT := fnd_message.get;
1449:
1450: INSERT INTO mtl_interface_errors
1451: (transaction_id,
1452: unique_id,
1453: organization_id,
1454: column_name,

Line 1512: MTL_INTERFACE_ERRORS if the page with the internal name already exists in the system*/

1508:
1509: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1.1');
1510:
1511: /* Update the interface records with process_status 3 and insert into
1512: MTL_INTERFACE_ERRORS if the page with the internal name already exists in the system*/
1513: G_MESSAGE_NAME := 'EGO_INTERNAL_NAME_EXISTS';
1514:
1515: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_INTERNAL_NAME_EXISTS');
1516:

Line 1519: INSERT INTO mtl_interface_errors

1515: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_INTERNAL_NAME_EXISTS');
1516:
1517: G_MESSAGE_TEXT := fnd_message.get;
1518:
1519: INSERT INTO mtl_interface_errors
1520: (transaction_id,
1521: unique_id,
1522: organization_id,
1523: column_name,

Line 1587: MTL_INTERFACE_ERRORS if SEQUENCE IS already existing for the ICC*/

1583:
1584: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
1585:
1586: /* Update the interface records with process_status 3 and insert into
1587: MTL_INTERFACE_ERRORS if SEQUENCE IS already existing for the ICC*/
1588: G_MESSAGE_NAME := 'EGO_PG_SEQ_DUP';
1589:
1590: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_PG_SEQ_DUP');
1591:

Line 1594: INSERT INTO mtl_interface_errors

1590: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_PG_SEQ_DUP');
1591:
1592: G_MESSAGE_TEXT := fnd_message.get;
1593:
1594: INSERT INTO mtl_interface_errors
1595: (transaction_id,
1596: unique_id,
1597: organization_id,
1598: column_name,

Line 1690: MTL_INTERFACE_ERRORS if flow is UPDATE or DELETE and the page entry does not exist*/

1686:
1687: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
1688:
1689: /* Update the interface records with process_status 3 and insert into
1690: MTL_INTERFACE_ERRORS if flow is UPDATE or DELETE and the page entry does not exist*/
1691: G_MESSAGE_NAME := 'EGO_PG_ENT_NOT_EXIST';
1692:
1693: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_PG_ENT_NOT_EXIST');
1694:

Line 1697: INSERT INTO mtl_interface_errors

1693: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_PG_ENT_NOT_EXIST');
1694:
1695: G_MESSAGE_TEXT := fnd_message.get;
1696:
1697: INSERT INTO mtl_interface_errors
1698: (transaction_id,
1699: unique_id,
1700: organization_id,
1701: column_name,

Line 1767: MTL_INTERFACE_ERRORS if SEQ already exists in the page*/

1763:
1764: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
1765:
1766: /* Update the interface records with process_status 3 and insert into
1767: MTL_INTERFACE_ERRORS if SEQ already exists in the page*/
1768: G_MESSAGE_NAME := 'EGO_PAGE_ENTRY_SAME_SEQ';
1769:
1770: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_PAGE_ENTRY_SAME_SEQ');
1771:

Line 1774: INSERT INTO mtl_interface_errors

1770: fnd_message.Set_name(G_EGO_APPLICATION_ID, 'EGO_PAGE_ENTRY_SAME_SEQ');
1771:
1772: G_MESSAGE_TEXT := fnd_message.get;
1773:
1774: INSERT INTO mtl_interface_errors
1775: (transaction_id,
1776: unique_id,
1777: organization_id,
1778: column_name,