100:
101: IF p_entity = G_ENTITY_ICC_HEADER THEN
102:
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: (
101: IF p_entity = G_ENTITY_ICC_HEADER THEN
102:
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
183:
184: IF p_entity = G_ENTITY_ICC_AG_ASSOC THEN
185:
186: l_msg_name := 'EGO_TRANS_TYPE_INVALID';
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
184: IF p_entity = G_ENTITY_ICC_AG_ASSOC THEN
185:
186: l_msg_name := 'EGO_TRANS_TYPE_INVALID';
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: (
259:
260: IF p_entity = G_ENTITY_ICC_FN_PARAM_MAP THEN
261:
262: l_msg_name := 'EGO_TRANS_TYPE_INVALID';
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
260: IF p_entity = G_ENTITY_ICC_FN_PARAM_MAP THEN
261:
262: l_msg_name := 'EGO_TRANS_TYPE_INVALID';
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: (
338:
339: if p_entity = G_ENTITY_ICC_VERSION THEN
340:
341: l_msg_name := 'EGO_TRANS_TYPE_ICC_VER_INVALID';
342: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
343: l_msg_text := FND_MESSAGE.GET;
344:
345: ---
346: --- Insert for versioning interface table
339: if p_entity = G_ENTITY_ICC_VERSION THEN
340:
341: l_msg_name := 'EGO_TRANS_TYPE_ICC_VER_INVALID';
342: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
343: l_msg_text := FND_MESSAGE.GET;
344:
345: ---
346: --- Insert for versioning interface table
347: ---
442: write_debug (l_proc_name, 'Start of '||l_proc_name);
443: x_return_status := G_RET_STS_SUCCESS;
444:
445: l_msg_name := 'EGO_REQ_COLNS_MISSING';
446: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
447: l_msg_text := FND_MESSAGE.GET;
448:
449:
450: IF p_entity = G_ENTITY_ICC_HEADER THEN
443: x_return_status := G_RET_STS_SUCCESS;
444:
445: l_msg_name := 'EGO_REQ_COLNS_MISSING';
446: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
447: l_msg_text := FND_MESSAGE.GET;
448:
449:
450: IF p_entity = G_ENTITY_ICC_HEADER THEN
451: ---- Validate some of the bare essential columns for
718:
719: IF NOT G_P4TP_PROFILE_ENABLED THEN
720:
721: l_msg_name := 'EGO_P4T_PROFILE_DISABLED_ERROR';
722: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
723: fnd_message.set_token('ENTITY_NAME' , G_ENTITY_ICC_VERSION);
724: l_msg_text := FND_MESSAGE.GET;
725:
726:
719: IF NOT G_P4TP_PROFILE_ENABLED THEN
720:
721: l_msg_name := 'EGO_P4T_PROFILE_DISABLED_ERROR';
722: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
723: fnd_message.set_token('ENTITY_NAME' , G_ENTITY_ICC_VERSION);
724: l_msg_text := FND_MESSAGE.GET;
725:
726:
727: --- Versioning interface columns
720:
721: l_msg_name := 'EGO_P4T_PROFILE_DISABLED_ERROR';
722: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
723: fnd_message.set_token('ENTITY_NAME' , G_ENTITY_ICC_VERSION);
724: l_msg_text := FND_MESSAGE.GET;
725:
726:
727: --- Versioning interface columns
728: ---
790:
791:
792:
793: l_msg_name := 'EGO_REQ_COLNS_MISSING';
794: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
795: l_msg_text := FND_MESSAGE.GET;
796:
797:
798: --- Versioning interface columns
791:
792:
793: l_msg_name := 'EGO_REQ_COLNS_MISSING';
794: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
795: l_msg_text := FND_MESSAGE.GET;
796:
797:
798: --- Versioning interface columns
799: ---
866: ;
867:
868:
869: l_msg_name := 'EGO_ICC_VER_SEQ_NO_INVALID';
870: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
871: l_msg_text := FND_MESSAGE.GET;
872:
873:
874: --- Insert errors for ICC Name
867:
868:
869: l_msg_name := 'EGO_ICC_VER_SEQ_NO_INVALID';
870: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
871: l_msg_text := FND_MESSAGE.GET;
872:
873:
874: --- Insert errors for ICC Name
875: ---
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 );
1037: l_msg_text := FND_MESSAGE.GET;
1038:
1039: write_debug (l_proc_name, '3');
1040:
1033: ---
1034:
1035: l_msg_name := 'EGO_ITEMCATALOG_INVALID';
1036: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
1037: l_msg_text := FND_MESSAGE.GET;
1038:
1039: write_debug (l_proc_name, '3');
1040:
1041: --- Insert errors for ICC Name
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 );
1153: l_msg_text := FND_MESSAGE.GET;
1154:
1155: write_debug (l_proc_name, '8');
1156: --- Insert errors for ICC Name
1149: ---
1150:
1151: l_msg_name := 'EGO_ICC_PARENT_INVALID';
1152: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
1153: l_msg_text := FND_MESSAGE.GET;
1154:
1155: write_debug (l_proc_name, '8');
1156: --- Insert errors for ICC Name
1157: ---
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 );
1309: l_msg_text := FND_MESSAGE.GET;
1310:
1311: INSERT INTO MTL_INTERFACE_ERRORS
1312: (
1305: ---
1306:
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
1359: );
1360:
1361: write_debug (l_proc_name, '15');
1362: l_msg_name2 := 'EGO_AG_NAME_MISSING';
1363: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name2 );
1364: l_msg_text2 := FND_MESSAGE.GET;
1365:
1366: write_debug (l_proc_name, '16');
1367:
1360:
1361: write_debug (l_proc_name, '15');
1362: l_msg_name2 := 'EGO_AG_NAME_MISSING';
1363: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name2 );
1364: l_msg_text2 := FND_MESSAGE.GET;
1365:
1366: write_debug (l_proc_name, '16');
1367:
1368: INSERT INTO MTL_INTERFACE_ERRORS
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 );
1670: l_msg_text := FND_MESSAGE.GET;
1671:
1672: write_debug (l_proc_name, '29');
1673: l_msg_name2 := 'EGO_AG_NAME_MISSING';
1666: ---
1667:
1668: l_msg_name := 'EGO_ITEMCATALOG_INVALID';
1669: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
1670: l_msg_text := FND_MESSAGE.GET;
1671:
1672: write_debug (l_proc_name, '29');
1673: l_msg_name2 := 'EGO_AG_NAME_MISSING';
1674: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name2 );
1670: l_msg_text := FND_MESSAGE.GET;
1671:
1672: write_debug (l_proc_name, '29');
1673: l_msg_name2 := 'EGO_AG_NAME_MISSING';
1674: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name2 );
1675: l_msg_text2 := FND_MESSAGE.GET;
1676:
1677:
1678: l_msg_name3 := 'EGO_ATTR_NAME_MISSING';
1671:
1672: write_debug (l_proc_name, '29');
1673: l_msg_name2 := 'EGO_AG_NAME_MISSING';
1674: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name2 );
1675: l_msg_text2 := FND_MESSAGE.GET;
1676:
1677:
1678: l_msg_name3 := 'EGO_ATTR_NAME_MISSING';
1679: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name3 );
1675: l_msg_text2 := FND_MESSAGE.GET;
1676:
1677:
1678: l_msg_name3 := 'EGO_ATTR_NAME_MISSING';
1679: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name3 );
1680: l_msg_text3 := FND_MESSAGE.GET;
1681:
1682:
1683: l_msg_name4 := 'EGO_ICC_FUNCTION_INVALID';
1676:
1677:
1678: l_msg_name3 := 'EGO_ATTR_NAME_MISSING';
1679: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name3 );
1680: l_msg_text3 := FND_MESSAGE.GET;
1681:
1682:
1683: l_msg_name4 := 'EGO_ICC_FUNCTION_INVALID';
1684: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name4 );
1680: l_msg_text3 := FND_MESSAGE.GET;
1681:
1682:
1683: l_msg_name4 := 'EGO_ICC_FUNCTION_INVALID';
1684: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name4 );
1685: l_msg_text4 := FND_MESSAGE.GET;
1686:
1687:
1688: l_msg_name5 := 'EGO_ICC_FUNC_PARAM_INVALID';
1681:
1682:
1683: l_msg_name4 := 'EGO_ICC_FUNCTION_INVALID';
1684: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name4 );
1685: l_msg_text4 := FND_MESSAGE.GET;
1686:
1687:
1688: l_msg_name5 := 'EGO_ICC_FUNC_PARAM_INVALID';
1689: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name5 );
1685: l_msg_text4 := FND_MESSAGE.GET;
1686:
1687:
1688: l_msg_name5 := 'EGO_ICC_FUNC_PARAM_INVALID';
1689: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name5 );
1690: l_msg_text5 := FND_MESSAGE.GET;
1691:
1692:
1693: write_debug (l_proc_name, '30');
1686:
1687:
1688: l_msg_name5 := 'EGO_ICC_FUNC_PARAM_INVALID';
1689: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name5 );
1690: l_msg_text5 := FND_MESSAGE.GET;
1691:
1692:
1693: write_debug (l_proc_name, '30');
1694: --- Insert errors for ICC Name
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 );
2027: l_msg_text := FND_MESSAGE.GET;
2028:
2029:
2030: --- Insert errors for ICC Name
2023: ---
2024:
2025: l_msg_name := 'EGO_ICC_ID_INVALID';
2026: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
2027: l_msg_text := FND_MESSAGE.GET;
2028:
2029:
2030: --- Insert errors for ICC Name
2031: ---
5437: x_return_status := G_RET_STS_SUCCESS;
5438:
5439:
5440: l_msg_name := 'EGO_ICC_DRAFT_VERSION';
5441: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
5442: l_msg_text := FND_MESSAGE.GET;
5443: l_sysdate := SYSDATE;
5444:
5445: INSERT INTO EGO_MTL_CATALOG_GRP_VERS_B
5438:
5439:
5440: l_msg_name := 'EGO_ICC_DRAFT_VERSION';
5441: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
5442: l_msg_text := FND_MESSAGE.GET;
5443: l_sysdate := SYSDATE;
5444:
5445: INSERT INTO EGO_MTL_CATALOG_GRP_VERS_B
5446: (item_catalog_group_id,