DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on FND_MESSAGE

Line 104: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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: (

Line 105: l_msg_text := FND_MESSAGE.GET;

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

Line 187: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 188: l_msg_text := FND_MESSAGE.GET;

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: (

Line 263: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 264: l_msg_text := FND_MESSAGE.GET;

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: (

Line 342: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 343: l_msg_text := FND_MESSAGE.GET;

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: ---

Line 446: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 447: l_msg_text := FND_MESSAGE.GET;

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

Line 722: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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:

Line 723: fnd_message.set_token('ENTITY_NAME' , G_ENTITY_ICC_VERSION);

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

Line 724: l_msg_text := FND_MESSAGE.GET;

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: ---

Line 794: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 795: l_msg_text := FND_MESSAGE.GET;

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: ---

Line 870: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 871: l_msg_text := FND_MESSAGE.GET;

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: ---

Line 1036: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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:

Line 1037: l_msg_text := FND_MESSAGE.GET;

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

Line 1152: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_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

Line 1153: l_msg_text := FND_MESSAGE.GET;

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: ---

Line 1308: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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: (

Line 1309: l_msg_text := FND_MESSAGE.GET;

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

Line 1363: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name2 );

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:

Line 1364: l_msg_text2 := FND_MESSAGE.GET;

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

Line 1669: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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';

Line 1670: l_msg_text := FND_MESSAGE.GET;

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 );

Line 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';

Line 1675: l_msg_text2 := 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';
1679: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name3 );

Line 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';

Line 1680: l_msg_text3 := 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';
1684: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name4 );

Line 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';

Line 1685: l_msg_text4 := 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';
1689: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name5 );

Line 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');

Line 1690: l_msg_text5 := 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');
1694: --- Insert errors for ICC Name

Line 2026: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_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

Line 2027: l_msg_text := FND_MESSAGE.GET;

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: ---

Line 5441: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );

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

Line 5442: l_msg_text := FND_MESSAGE.GET;

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,