eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_AG_BULKLOAD_PVT dependencies on MTL_INTERFACE_ERRORS

Line 140: MTL_INTERFACE_ERRORS if TRANSACTION_TYPE passed is incorrect*/

136:
137: x_return_status := G_RET_STS_SUCCESS;
138:
139: /* Update the interface records with process_status 3 and insert into
140: MTL_INTERFACE_ERRORS if TRANSACTION_TYPE passed is incorrect*/
141: G_MESSAGE_NAME := 'EGO_TRANS_TYPE_INVALID';
142:
143: fnd_message.Set_name('EGO','EGO_TRANS_TYPE_INVALID');
144:

Line 151: INSERT INTO mtl_interface_errors

147: lv_smt := 1;
148:
149: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
150:
151: INSERT INTO mtl_interface_errors
152: (transaction_id,
153: unique_id,
154: organization_id,
155: column_name,

Line 212: INSERT INTO mtl_interface_errors

208: lv_smt := 2;
209:
210: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
211:
212: INSERT INTO mtl_interface_errors
213: (transaction_id,
214: unique_id,
215: organization_id,
216: column_name,

Line 273: INSERT INTO mtl_interface_errors

269: lv_smt := 3;
270:
271: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
272:
273: INSERT INTO mtl_interface_errors
274: (transaction_id,
275: unique_id,
276: organization_id,
277: column_name,

Line 369: MTL_INTERFACE_ERRORS if internal name or the display name for AG is not

365:
366: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
367:
368: /* Update the interface records with process_status 3 and insert into
369: MTL_INTERFACE_ERRORS if internal name or the display name for AG is not
370: provided in the CREATE flow*/
371: G_MESSAGE_NAME := 'EGO_AG_MANDATORY';
372:
373: fnd_message.Set_name('EGO','EGO_AG_MANDATORY');

Line 377: INSERT INTO mtl_interface_errors

373: fnd_message.Set_name('EGO','EGO_AG_MANDATORY');
374:
375: G_MESSAGE_TEXT := fnd_message.get;
376:
377: INSERT INTO mtl_interface_errors
378: (transaction_id,
379: unique_id,
380: organization_id,
381: column_name,

Line 441: MTL_INTERFACE_ERRORS if Attribute Group Type in the AG interface table is other than EGO_ITEMMGMT_GROUP*/

437:
438: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 9');
439:
440: /* Update the interface records with process_status 3 and insert into
441: MTL_INTERFACE_ERRORS if Attribute Group Type in the AG interface table is other than EGO_ITEMMGMT_GROUP*/
442: G_MESSAGE_NAME := 'EGO_AG_TYPE_INVALID';
443:
444: fnd_message.Set_name('EGO','EGO_AG_TYPE_INVALID');
445:

Line 448: INSERT INTO mtl_interface_errors

444: fnd_message.Set_name('EGO','EGO_AG_TYPE_INVALID');
445:
446: G_MESSAGE_TEXT := fnd_message.get;
447:
448: INSERT INTO mtl_interface_errors
449: (transaction_id,
450: unique_id,
451: organization_id,
452: column_name,

Line 508: MTL_INTERFACE_ERRORS if Attribute Group Type in the DL interface is other than EGO_ITEMMGMT_GROUP*/

504:
505: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 10');
506:
507: /* Update the interface records with process_status 3 and insert into
508: MTL_INTERFACE_ERRORS if Attribute Group Type in the DL interface is other than EGO_ITEMMGMT_GROUP*/
509: G_MESSAGE_NAME := 'EGO_AG_TYPE_INVALID';
510:
511: fnd_message.Set_name('EGO','EGO_AG_TYPE_INVALID');
512:

Line 515: INSERT INTO mtl_interface_errors

511: fnd_message.Set_name('EGO','EGO_AG_TYPE_INVALID');
512:
513: G_MESSAGE_TEXT := fnd_message.get;
514:
515: INSERT INTO mtl_interface_errors
516: (transaction_id,
517: unique_id,
518: organization_id,
519: column_name,

Line 575: MTL_INTERFACE_ERRORS if Attribute Group Type in the DL interface is other than EGO_ITEMMGMT_GROUP*/

571:
572: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
573:
574: /* Update the interface records with process_status 3 and insert into
575: MTL_INTERFACE_ERRORS if Attribute Group Type in the DL interface is other than EGO_ITEMMGMT_GROUP*/
576: G_MESSAGE_NAME := 'EGO_DL_MANDATORY';
577:
578: fnd_message.Set_name('EGO','EGO_DL_MANDATORY');
579:

Line 582: INSERT INTO mtl_interface_errors

578: fnd_message.Set_name('EGO','EGO_DL_MANDATORY');
579:
580: G_MESSAGE_TEXT := fnd_message.get;
581:
582: INSERT INTO mtl_interface_errors
583: (transaction_id,
584: unique_id,
585: organization_id,
586: column_name,

Line 647: MTL_INTERFACE_ERRORS if internal name is not existing in the UPDATE flow.

643:
644: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2.1');
645:
646: /* Update the interface records with process_status 3 and insert into
647: MTL_INTERFACE_ERRORS if internal name is not existing in the UPDATE flow.
648: Updates the AG interface table*/
649: G_MESSAGE_NAME := 'EGO_AG_NOT_EXIST';
650:
651: fnd_message.Set_name('EGO','EGO_AG_NOT_EXIST');

Line 655: INSERT INTO mtl_interface_errors

651: fnd_message.Set_name('EGO','EGO_AG_NOT_EXIST');
652:
653: G_MESSAGE_TEXT := fnd_message.get;
654:
655: INSERT INTO mtl_interface_errors
656: (transaction_id,
657: unique_id,
658: organization_id,
659: column_name,

Line 719: MTL_INTERFACE_ERRORS if internal name is not existing. Updates the DL

715:
716: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
717:
718: /* Update the interface records with process_status 3 and insert into
719: MTL_INTERFACE_ERRORS if internal name is not existing. Updates the DL
720: interface table*/
721: G_MESSAGE_NAME := 'EGO_AG_NOT_EXIST';
722:
723: fnd_message.Set_name('EGO','EGO_AG_NOT_EXIST');

Line 727: INSERT INTO mtl_interface_errors

723: fnd_message.Set_name('EGO','EGO_AG_NOT_EXIST');
724:
725: G_MESSAGE_TEXT := fnd_message.get;
726:
727: INSERT INTO mtl_interface_errors
728: (transaction_id,
729: unique_id,
730: organization_id,
731: column_name,

Line 799: MTL_INTERFACE_ERRORS if for the CREATE flow if there already exists an AG with

795:
796: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
797:
798: /* Update the interface records with process_status 3 and insert into
799: MTL_INTERFACE_ERRORS if for the CREATE flow if there already exists an AG with
800: the same internal attribute group name*/
801:
802: G_MESSAGE_NAME := 'EGO_EF_ATTR_GRP_EXIST';
803:

Line 808: INSERT INTO mtl_interface_errors

804: fnd_message.Set_name('EGO','EGO_EF_ATTR_GRP_EXIST');
805:
806: G_MESSAGE_TEXT := fnd_message.get;
807:
808: INSERT INTO mtl_interface_errors
809: (transaction_id,
810: unique_id,
811: organization_id,
812: column_name,

Line 879: MTL_INTERFACE_ERRORS if for the CREATE flow if there doesn't exist any DL

875:
876: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4.1');
877:
878: /* Update the interface records with process_status 3 and insert into
879: MTL_INTERFACE_ERRORS if for the CREATE flow if there doesn't exist any DL
880: in the interface table*/
881: G_MESSAGE_NAME := 'EGO_EF_DL_REQD_AG';
882:
883: fnd_message.Set_name('EGO','EGO_EF_DL_REQD_AG');

Line 887: INSERT INTO mtl_interface_errors

883: fnd_message.Set_name('EGO','EGO_EF_DL_REQD_AG');
884:
885: G_MESSAGE_TEXT := fnd_message.get;
886:
887: INSERT INTO mtl_interface_errors
888: (transaction_id,
889: unique_id,
890: organization_id,
891: column_name,

Line 961: MTL_INTERFACE_ERRORS if Data Level passed is already enabled in the system*/

957:
958: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 4.2');
959:
960: /* Update the interface records with process_status 3 and insert into
961: MTL_INTERFACE_ERRORS if Data Level passed is already enabled in the system*/
962: G_MESSAGE_NAME := 'EGO_EF_DL_AG_EXISTS';
963:
964: fnd_message.Set_name('EGO','EGO_EF_DL_AG_EXISTS');
965:

Line 968: INSERT INTO mtl_interface_errors

964: fnd_message.Set_name('EGO','EGO_EF_DL_AG_EXISTS');
965:
966: G_MESSAGE_TEXT := fnd_message.get;
967:
968: INSERT INTO mtl_interface_errors
969: (transaction_id,
970: unique_id,
971: organization_id,
972: column_name,

Line 1044: MTL_INTERFACE_ERRORS if Data Level passed is incorrect*/

1040:
1041: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
1042:
1043: /* Update the interface records with process_status 3 and insert into
1044: MTL_INTERFACE_ERRORS if Data Level passed is incorrect*/
1045: G_MESSAGE_NAME := 'EGO_DL_NOT_EXIST';
1046:
1047: fnd_message.Set_name('EGO','EGO_DL_NOT_EXIST');
1048:

Line 1051: INSERT INTO mtl_interface_errors

1047: fnd_message.Set_name('EGO','EGO_DL_NOT_EXIST');
1048:
1049: G_MESSAGE_TEXT := fnd_message.get;
1050:
1051: INSERT INTO mtl_interface_errors
1052: (transaction_id,
1053: unique_id,
1054: organization_id,
1055: column_name,

Line 1113: MTL_INTERFACE_ERRORS if the AG is of type Variant and Business entity is not ITEM or the Style to SKU is not NULL*/

1109:
1110: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 6');
1111:
1112: /* Update the interface records with process_status 3 and insert into
1113: MTL_INTERFACE_ERRORS if the AG is of type Variant and Business entity is not ITEM or the Style to SKU is not NULL*/
1114: G_MESSAGE_NAME := 'EGO_VAR_DL_SKU';
1115:
1116: fnd_message.Set_name('EGO','EGO_VAR_DL_SKU');
1117:

Line 1120: INSERT INTO mtl_interface_errors

1116: fnd_message.Set_name('EGO','EGO_VAR_DL_SKU');
1117:
1118: G_MESSAGE_TEXT := fnd_message.get;
1119:
1120: INSERT INTO mtl_interface_errors
1121: (transaction_id,
1122: unique_id,
1123: organization_id,
1124: column_name,

Line 1212: MTL_INTERFACE_ERRORS if AG is of Single Row or MultiRow Business and the business entity is not any of the below

1208:
1209: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 7');
1210:
1211: /* Update the interface records with process_status 3 and insert into
1212: MTL_INTERFACE_ERRORS if AG is of Single Row or MultiRow Business and the business entity is not any of the below
1213: ITEM_LEVEL, ITEM_REVISION_LEVEL, ITEM_ORG, ITEM_SUP, ITEM_SUP_SITE, ITEM_SUP_SITE_ORG*/
1214: G_MESSAGE_NAME := 'EGO_DL_NOT_EXIST';
1215:
1216: fnd_message.Set_name('EGO','EGO_DL_NOT_EXIST');

Line 1220: INSERT INTO mtl_interface_errors

1216: fnd_message.Set_name('EGO','EGO_DL_NOT_EXIST');
1217:
1218: G_MESSAGE_TEXT := fnd_message.get;
1219:
1220: INSERT INTO mtl_interface_errors
1221: (transaction_id,
1222: unique_id,
1223: organization_id,
1224: column_name,

Line 1290: MTL_INTERFACE_ERRORS if AG is of Single Row or MultiRow Business flag an error if the business entity and the

1286:
1287: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 8');
1288:
1289: /* Update the interface records with process_status 3 and insert into
1290: MTL_INTERFACE_ERRORS if AG is of Single Row or MultiRow Business flag an error if the business entity and the
1291: Style to SKU combination is invalid*/
1292: G_MESSAGE_NAME := 'EGO_MULROW_SKU';
1293:
1294: fnd_message.Set_name('EGO','EGO_MULROW_SKU');

Line 1298: INSERT INTO mtl_interface_errors

1294: fnd_message.Set_name('EGO','EGO_MULROW_SKU');
1295:
1296: G_MESSAGE_TEXT := fnd_message.get;
1297:
1298: INSERT INTO mtl_interface_errors
1299: (transaction_id,
1300: unique_id,
1301: organization_id,
1302: column_name,

Line 1374: MTL_INTERFACE_ERRORS if View Privilege is incorrect*/

1370:
1371: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 11');
1372:
1373: /* Update the interface records with process_status 3 and insert into
1374: MTL_INTERFACE_ERRORS if View Privilege is incorrect*/
1375: G_MESSAGE_NAME := 'EGO_VIEW_PRIV_NOT_EXIST';
1376:
1377: fnd_message.Set_name('EGO','EGO_VIEW_PRIV_NOT_EXIST');
1378:

Line 1381: INSERT INTO mtl_interface_errors

1377: fnd_message.Set_name('EGO','EGO_VIEW_PRIV_NOT_EXIST');
1378:
1379: G_MESSAGE_TEXT := fnd_message.get;
1380:
1381: INSERT INTO mtl_interface_errors
1382: (transaction_id,
1383: unique_id,
1384: organization_id,
1385: column_name,

Line 1457: MTL_INTERFACE_ERRORS if Edit Privilege is incorrect*/

1453: -- Changed the NVL condition from G_MISS_CHAR to G_MISS_NUM
1454: -- sreharih. Tue Apr 26 11:09:17 PDT 2011
1455: --
1456: /* Update the interface records with process_status 3 and insert into
1457: MTL_INTERFACE_ERRORS if Edit Privilege is incorrect*/
1458: G_MESSAGE_NAME := 'EGO_EDIT_PRIV_NOT_EXIST';
1459:
1460: fnd_message.Set_name('EGO','EGO_EDIT_PRIV_NOT_EXIST');
1461:

Line 1464: INSERT INTO mtl_interface_errors

1460: fnd_message.Set_name('EGO','EGO_EDIT_PRIV_NOT_EXIST');
1461:
1462: G_MESSAGE_TEXT := fnd_message.get;
1463:
1464: INSERT INTO mtl_interface_errors
1465: (transaction_id,
1466: unique_id,
1467: organization_id,
1468: column_name,

Line 1532: MTL_INTERFACE_ERRORS if Defaulting passed is incorrect*/

1528:
1529: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 13');
1530:
1531: /* Update the interface records with process_status 3 and insert into
1532: MTL_INTERFACE_ERRORS if Defaulting passed is incorrect*/
1533: G_MESSAGE_NAME := 'EGO_DEFAULTING_INVALID';
1534:
1535: fnd_message.Set_name('EGO','EGO_DEFAULTING_INVALID');
1536:

Line 1539: INSERT INTO mtl_interface_errors

1535: fnd_message.Set_name('EGO','EGO_DEFAULTING_INVALID');
1536:
1537: G_MESSAGE_TEXT := fnd_message.get;
1538:
1539: INSERT INTO mtl_interface_errors
1540: (transaction_id,
1541: unique_id,
1542: organization_id,
1543: column_name,

Line 1631: MTL_INTERFACE_ERRORS if AG has associations and user is trying to delete a DL*/

1627:
1628: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 14');
1629:
1630: /* Update the interface records with process_status 3 and insert into
1631: MTL_INTERFACE_ERRORS if AG has associations and user is trying to delete a DL*/
1632: G_MESSAGE_NAME := 'EGO_EF_ASSOCS_EXIST3';
1633:
1634: fnd_message.Set_name('EGO','EGO_EF_ASSOCS_EXIST3');
1635:

Line 1638: INSERT INTO mtl_interface_errors

1634: fnd_message.Set_name('EGO','EGO_EF_ASSOCS_EXIST3');
1635:
1636: G_MESSAGE_TEXT := fnd_message.get;
1637:
1638: INSERT INTO mtl_interface_errors
1639: (transaction_id,
1640: unique_id,
1641: organization_id,
1642: column_name,

Line 1706: MTL_INTERFACE_ERRORS if AG has associations and user is trying to delete the AG*/

1702:
1703: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 15');
1704:
1705: /* Update the interface records with process_status 3 and insert into
1706: MTL_INTERFACE_ERRORS if AG has associations and user is trying to delete the AG*/
1707: G_MESSAGE_NAME := 'EGO_EF_ASSOCS_EXIST1';
1708:
1709: fnd_message.Set_name('EGO','EGO_EF_ASSOCS_EXIST1');
1710:

Line 1713: INSERT INTO mtl_interface_errors

1709: fnd_message.Set_name('EGO','EGO_EF_ASSOCS_EXIST1');
1710:
1711: G_MESSAGE_TEXT := fnd_message.get;
1712:
1713: INSERT INTO mtl_interface_errors
1714: (transaction_id,
1715: unique_id,
1716: organization_id,
1717: column_name,

Line 1807: MTL_INTERFACE_ERRORS if Attribute Group Type in the Attribute interface table is other than EGO_ITEMMGMT_GROUP*/

1803:
1804: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
1805:
1806: /* Update the interface records with process_status 3 and insert into
1807: MTL_INTERFACE_ERRORS if Attribute Group Type in the Attribute interface table is other than EGO_ITEMMGMT_GROUP*/
1808: G_MESSAGE_NAME := 'EGO_AG_TYPE_INVALID';
1809:
1810: fnd_message.Set_name('EGO','EGO_AG_TYPE_INVALID');
1811:

Line 1814: INSERT INTO mtl_interface_errors

1810: fnd_message.Set_name('EGO','EGO_AG_TYPE_INVALID');
1811:
1812: G_MESSAGE_TEXT := fnd_message.get;
1813:
1814: INSERT INTO mtl_interface_errors
1815: (transaction_id,
1816: unique_id,
1817: organization_id,
1818: column_name,

Line 1874: MTL_INTERFACE_ERRORS if the attribute with the internal name is already present in the system*/

1870:
1871: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
1872:
1873: /* Update the interface records with process_status 3 and insert into
1874: MTL_INTERFACE_ERRORS if the attribute with the internal name is already present in the system*/
1875: G_MESSAGE_NAME := 'EGO_EF_INTERNAL_NAME_UNIQUE';
1876:
1877: fnd_message.Set_name('EGO','EGO_EF_INTERNAL_NAME_UNIQUE');
1878:

Line 1881: INSERT INTO mtl_interface_errors

1877: fnd_message.Set_name('EGO','EGO_EF_INTERNAL_NAME_UNIQUE');
1878:
1879: G_MESSAGE_TEXT := fnd_message.get;
1880:
1881: INSERT INTO mtl_interface_errors
1882: (transaction_id,
1883: unique_id,
1884: organization_id,
1885: column_name,

Line 1959: MTL_INTERFACE_ERRORS if Attribute group does exist in the system or

1955:
1956: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
1957:
1958: /* Update the interface records with process_status 3 and insert into
1959: MTL_INTERFACE_ERRORS if Attribute group does exist in the system or
1960: as a create flow in the AG interface table. Updates the DL interface table*/
1961: G_MESSAGE_NAME := 'EGO_AG_NOT_EXIST';
1962:
1963: fnd_message.Set_name('EGO','EGO_AG_NOT_EXIST');

Line 1967: INSERT INTO mtl_interface_errors

1963: fnd_message.Set_name('EGO','EGO_AG_NOT_EXIST');
1964:
1965: G_MESSAGE_TEXT := fnd_message.get;
1966:
1967: INSERT INTO mtl_interface_errors
1968: (transaction_id,
1969: unique_id,
1970: organization_id,
1971: column_name,

Line 2045: INSERT INTO mtl_interface_errors

2041: fnd_message.Set_name('EGO','EGO_ATTR_NOT_EXISTS');
2042:
2043: G_MESSAGE_TEXT := fnd_message.get;
2044:
2045: INSERT INTO mtl_interface_errors
2046: (transaction_id,
2047: unique_id,
2048: organization_id,
2049: column_name,

Line 2119: INSERT INTO mtl_interface_errors

2115: fnd_message.Set_name('EGO','EGO_EF_BC_SEL_EXI_VALUE');
2116:
2117: G_MESSAGE_TEXT := fnd_message.get;
2118:
2119: INSERT INTO mtl_interface_errors
2120: (transaction_id,
2121: unique_id,
2122: organization_id,
2123: column_name,

Line 2189: MTL_INTERFACE_ERRORS if AG has associations and user is trying to delete the attributes*/

2185:
2186: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
2187:
2188: /* Update the interface records with process_status 3 and insert into
2189: MTL_INTERFACE_ERRORS if AG has associations and user is trying to delete the attributes*/
2190: G_MESSAGE_NAME := 'EGO_EF_ASSOCS_EXIST2';
2191:
2192: fnd_message.Set_name('EGO','EGO_EF_ASSOCS_EXIST2');
2193:

Line 2196: INSERT INTO mtl_interface_errors

2192: fnd_message.Set_name('EGO','EGO_EF_ASSOCS_EXIST2');
2193:
2194: G_MESSAGE_TEXT := fnd_message.get;
2195:
2196: INSERT INTO mtl_interface_errors
2197: (transaction_id,
2198: unique_id,
2199: organization_id,
2200: column_name,