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_TRANSACTION_ATTRS_PVT dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.Initialize;

98: l_is_column_indexed VARCHAR2(80);
99:
100: BEGIN
101: --Reset all global variables
102: FND_MSG_PUB.Initialize;
103: FOR i IN p_tran_attrs_tbl.first..p_tran_attrs_tbl.last
104: LOOP
105:
106: l_item_cat_group_id := p_tran_attrs_tbl(i).ItemCatalogGroupId;

Line 213: FND_MSG_PUB.Add;

209: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
210: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
211: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
212: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
213: FND_MSG_PUB.Add;
214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
215: ,p_count => x_msg_count
216: ,p_data => x_msg_data);
217: END;

Line 214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

210: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
211: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
212: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
213: FND_MSG_PUB.Add;
214: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
215: ,p_count => x_msg_count
216: ,p_data => x_msg_data);
217: END;
218:

Line 265: FND_MSG_PUB.Add;

261: x_return_status := G_STATUS_ERROR;
262: x_msg_data := 'TA_NO_DATA_LEVEL_FOUND';
263: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
264: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
265: FND_MSG_PUB.Add;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
267: ,p_count => x_msg_count
268: ,p_data => x_msg_data);
269: END ;

Line 266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

262: x_msg_data := 'TA_NO_DATA_LEVEL_FOUND';
263: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
264: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
265: FND_MSG_PUB.Add;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
267: ,p_count => x_msg_count
268: ,p_data => x_msg_data);
269: END ;
270:

Line 350: FND_MSG_PUB.Add;

346: x_return_status := G_STATUS_ERROR;
347: x_msg_data := 'TA_NO_OBJECT_ID';
348: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
349: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
350: FND_MSG_PUB.Add;
351: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
352: ,p_count => x_msg_count
353: ,p_data => x_msg_data);
354: END;

Line 351: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

347: x_msg_data := 'TA_NO_OBJECT_ID';
348: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
349: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
350: FND_MSG_PUB.Add;
351: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
352: ,p_count => x_msg_count
353: ,p_data => x_msg_data);
354: END;
355: EGO_EXT_FWK_PUB.Create_Association(

Line 414: FND_MSG_PUB.Add;

410: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
411: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
412: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
413: FND_MESSAGE.Set_Token('SQL_ERR_MSG',SQLERRM);
414: FND_MSG_PUB.Add;
415: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
416: ,p_count => x_msg_count
417: ,p_data => x_msg_data);
418: END ;

Line 415: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

411: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
412: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
413: FND_MESSAGE.Set_Token('SQL_ERR_MSG',SQLERRM);
414: FND_MSG_PUB.Add;
415: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
416: ,p_count => x_msg_count
417: ,p_data => x_msg_data);
418: END ;
419: END LOOP; /* FOR i IN p_tran_attrs_tbl.first..p_tran_attrs_tbl.last */

Line 429: FND_MSG_PUB.Add;

425: WHEN e_ta_int_name_exist THEN
426: x_return_status := G_STATUS_ERROR;
427: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');
428: /*SELECT * FROM fnd_new_messages WHERE message_name LIKE 'EGO_PLSQL_ERR%'*/
429: FND_MSG_PUB.Add;
430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
431: ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN e_ta_disp_name_exist THEN

Line 430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

426: x_return_status := G_STATUS_ERROR;
427: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');
428: /*SELECT * FROM fnd_new_messages WHERE message_name LIKE 'EGO_PLSQL_ERR%'*/
429: FND_MSG_PUB.Add;
430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
431: ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN e_ta_disp_name_exist THEN
434: x_return_status := G_STATUS_ERROR;

Line 436: FND_MSG_PUB.Add;

432: ,p_data => x_msg_data);
433: WHEN e_ta_disp_name_exist THEN
434: x_return_status := G_STATUS_ERROR;
435: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');
436: FND_MSG_PUB.Add;
437: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN e_ta_sequence_exist THEN

Line 437: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

433: WHEN e_ta_disp_name_exist THEN
434: x_return_status := G_STATUS_ERROR;
435: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');
436: FND_MSG_PUB.Add;
437: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN e_ta_sequence_exist THEN
441: x_return_status := G_STATUS_ERROR;

Line 443: FND_MSG_PUB.Add;

439: ,p_data => x_msg_data);
440: WHEN e_ta_sequence_exist THEN
441: x_return_status := G_STATUS_ERROR;
442: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');
443: FND_MSG_PUB.Add;
444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
445: ,p_count => x_msg_count
446: ,p_data => x_msg_data);
447: WHEN e_ta_default_value_null

Line 444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

440: WHEN e_ta_sequence_exist THEN
441: x_return_status := G_STATUS_ERROR;
442: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');
443: FND_MSG_PUB.Add;
444: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
445: ,p_count => x_msg_count
446: ,p_data => x_msg_data);
447: WHEN e_ta_default_value_null
448: THEN

Line 451: FND_MSG_PUB.Add;

447: WHEN e_ta_default_value_null
448: THEN
449: x_return_status := G_STATUS_ERROR;
450: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DEFAULT_VALUE_NULL');
451: FND_MSG_PUB.Add;
452: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
453: ,p_count => x_msg_count
454: ,p_data => x_msg_data);
455: WHEN e_vs_not_versioned

Line 452: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

448: THEN
449: x_return_status := G_STATUS_ERROR;
450: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DEFAULT_VALUE_NULL');
451: FND_MSG_PUB.Add;
452: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
453: ,p_count => x_msg_count
454: ,p_data => x_msg_data);
455: WHEN e_vs_not_versioned
456: THEN

Line 459: FND_MSG_PUB.Add;

455: WHEN e_vs_not_versioned
456: THEN
457: x_return_status := G_STATUS_ERROR;
458: FND_MESSAGE.Set_Name('EGO', 'EGO_VALUE_SET_NOT_VERSIONED');
459: FND_MSG_PUB.Add;
460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data);
463: WHEN e_vs_data_type

Line 460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

456: THEN
457: x_return_status := G_STATUS_ERROR;
458: FND_MESSAGE.Set_Name('EGO', 'EGO_VALUE_SET_NOT_VERSIONED');
459: FND_MSG_PUB.Add;
460: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data);
463: WHEN e_vs_data_type
464: THEN

Line 467: FND_MSG_PUB.Add;

463: WHEN e_vs_data_type
464: THEN
465: x_return_status := G_STATUS_ERROR;
466: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
467: FND_MSG_PUB.Add;
468: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471:

Line 468: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

464: THEN
465: x_return_status := G_STATUS_ERROR;
466: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
467: FND_MSG_PUB.Add;
468: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471:
472: WHEN e_ag_create

Line 476: FND_MSG_PUB.Add;

472: WHEN e_ag_create
473: THEN
474: x_return_status := G_STATUS_ERROR;
475: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_AG_CREATE');
476: FND_MSG_PUB.Add;
477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
478: ,p_count => x_msg_count
479: ,p_data => x_msg_data);
480: WHEN e_ta_create

Line 477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

473: THEN
474: x_return_status := G_STATUS_ERROR;
475: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_AG_CREATE');
476: FND_MSG_PUB.Add;
477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
478: ,p_count => x_msg_count
479: ,p_data => x_msg_data);
480: WHEN e_ta_create
481: THEN

Line 484: FND_MSG_PUB.Add;

480: WHEN e_ta_create
481: THEN
482: x_return_status := G_STATUS_ERROR;
483: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_CREATE_FAILED');
484: FND_MSG_PUB.Add;
485: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
486: ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN e_ta_association

Line 485: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

481: THEN
482: x_return_status := G_STATUS_ERROR;
483: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_CREATE_FAILED');
484: FND_MSG_PUB.Add;
485: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
486: ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN e_ta_association
489: THEN

Line 492: FND_MSG_PUB.Add;

488: WHEN e_ta_association
489: THEN
490: x_return_status := G_STATUS_ERROR;
491: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_ASSOC_FAILED');
492: FND_MSG_PUB.Add;
493: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
494: ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: WHEN e_ta_int_name_invalidchars

Line 493: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

489: THEN
490: x_return_status := G_STATUS_ERROR;
491: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_ASSOC_FAILED');
492: FND_MSG_PUB.Add;
493: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
494: ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: WHEN e_ta_int_name_invalidchars
497: THEN

Line 500: FND_MSG_PUB.Add;

496: WHEN e_ta_int_name_invalidchars
497: THEN
498: x_return_status := G_STATUS_ERROR;
499: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_TIP');
500: FND_MSG_PUB.Add;
501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
502: ,p_count => x_msg_count
503: ,p_data => x_msg_data);
504:

Line 501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

497: THEN
498: x_return_status := G_STATUS_ERROR;
499: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_TIP');
500: FND_MSG_PUB.Add;
501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
502: ,p_count => x_msg_count
503: ,p_data => x_msg_data);
504:
505: WHEN OTHERS THEN

Line 511: FND_MSG_PUB.Add;

507: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
508: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
509: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
510: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
511: FND_MSG_PUB.Add;
512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515: END Create_Transaction_Attribute;

Line 512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

508: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
509: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
510: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
511: FND_MSG_PUB.Add;
512: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515: END Create_Transaction_Attribute;
516:

Line 953: FND_MSG_PUB.Initialize;

949: ORDER BY Lev ASC ;
950:
951: BEGIN
952: --Reset all global variables
953: FND_MSG_PUB.Initialize;
954: p_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);
955: FOR i IN p_tran_attrs_tbl.first..p_tran_attrs_tbl.last
956: LOOP
957: l_item_cat_group_id := p_tran_attrs_tbl(i).ItemCatalogGroupId;

Line 1259: FND_MSG_PUB.Add;

1255: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1256: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1257: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1258: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1259: FND_MSG_PUB.Add;
1260: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,p_count => x_msg_count ,p_data => x_msg_data);
1261: END;
1262:
1263:

Line 1260: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,p_count => x_msg_count ,p_data => x_msg_data);

1256: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1257: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1258: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1259: FND_MSG_PUB.Add;
1260: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,p_count => x_msg_count ,p_data => x_msg_data);
1261: END;
1262:
1263:
1264:

Line 1334: FND_MSG_PUB.Initialize;

1330: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;
1331:
1332: BEGIN
1333: --Reset all global variables
1334: FND_MSG_PUB.Initialize;
1335: l_ta_metadata_tbl := EGO_TRAN_ATTR_TBL(NULL);
1336: IS_METADATA_CHANGE(p_tran_attrs_tbl,l_ta_metadata_tbl,l_return_status,l_msg_count,l_msg_data );
1337:
1338: FOR i IN l_ta_metadata_tbl.first..l_ta_metadata_tbl.last

Line 1480: FND_MSG_PUB.Add;

1476: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1477: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1478: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1479: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
1480: FND_MSG_PUB.Add;
1481: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1482: ,p_count => x_msg_count
1483: ,p_data => x_msg_data);
1484: END ;

Line 1481: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1477: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1478: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1479: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
1480: FND_MSG_PUB.Add;
1481: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1482: ,p_count => x_msg_count
1483: ,p_data => x_msg_data);
1484: END ;
1485: END IF; --BUG 8356736

Line 1497: FND_MSG_PUB.Add;

1493: WHEN e_ta_disp_name_exist THEN
1494: x_return_status := G_STATUS_ERROR;
1495: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');
1496: --FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
1497: FND_MSG_PUB.Add;
1498: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1499: ,p_count => x_msg_count
1500: ,p_data => x_msg_data);
1501: WHEN e_ta_default_value_null THEN

Line 1498: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1494: x_return_status := G_STATUS_ERROR;
1495: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');
1496: --FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );
1497: FND_MSG_PUB.Add;
1498: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1499: ,p_count => x_msg_count
1500: ,p_data => x_msg_data);
1501: WHEN e_ta_default_value_null THEN
1502: x_return_status := G_STATUS_ERROR;

Line 1504: FND_MSG_PUB.Add;

1500: ,p_data => x_msg_data);
1501: WHEN e_ta_default_value_null THEN
1502: x_return_status := G_STATUS_ERROR;
1503: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DEFAULT_VALUE_NULL');
1504: FND_MSG_PUB.Add;
1505: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1506: ,p_count => x_msg_count
1507: ,p_data => x_msg_data);
1508: WHEN e_vs_not_versioned

Line 1505: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1501: WHEN e_ta_default_value_null THEN
1502: x_return_status := G_STATUS_ERROR;
1503: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DEFAULT_VALUE_NULL');
1504: FND_MSG_PUB.Add;
1505: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1506: ,p_count => x_msg_count
1507: ,p_data => x_msg_data);
1508: WHEN e_vs_not_versioned
1509: THEN

Line 1512: FND_MSG_PUB.Add;

1508: WHEN e_vs_not_versioned
1509: THEN
1510: x_return_status := G_STATUS_ERROR;
1511: FND_MESSAGE.Set_Name('EGO', 'EGO_VALUE_SET_NOT_VERSIONED');
1512: FND_MSG_PUB.Add;
1513: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1514: ,p_count => x_msg_count
1515: ,p_data => x_msg_data);
1516: WHEN e_vs_data_type

Line 1513: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1509: THEN
1510: x_return_status := G_STATUS_ERROR;
1511: FND_MESSAGE.Set_Name('EGO', 'EGO_VALUE_SET_NOT_VERSIONED');
1512: FND_MSG_PUB.Add;
1513: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1514: ,p_count => x_msg_count
1515: ,p_data => x_msg_data);
1516: WHEN e_vs_data_type
1517: THEN

Line 1520: FND_MSG_PUB.Add;

1516: WHEN e_vs_data_type
1517: THEN
1518: x_return_status := G_STATUS_ERROR;
1519: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
1520: FND_MSG_PUB.Add;
1521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1522: ,p_count => x_msg_count
1523: ,p_data => x_msg_data);
1524:

Line 1521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1517: THEN
1518: x_return_status := G_STATUS_ERROR;
1519: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
1520: FND_MSG_PUB.Add;
1521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1522: ,p_count => x_msg_count
1523: ,p_data => x_msg_data);
1524:
1525: WHEN OTHERS THEN

Line 1531: FND_MSG_PUB.Add;

1527: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1528: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1529: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1530: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1531: FND_MSG_PUB.Add;
1532: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1533: ,p_count => x_msg_count
1534: ,p_data => x_msg_data);
1535: END Create_Inherited_Trans_Attr;

Line 1532: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1528: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1529: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1530: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1531: FND_MSG_PUB.Add;
1532: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1533: ,p_count => x_msg_count
1534: ,p_data => x_msg_data);
1535: END Create_Inherited_Trans_Attr;
1536:

Line 1600: FND_MSG_PUB.Initialize;

1596: l_ta_metadata_tbl EGO_TRAN_ATTR_TBL;
1597:
1598: BEGIN
1599: --Reset all global variables
1600: FND_MSG_PUB.Initialize;
1601: IS_METADATA_CHANGE(p_tran_attrs_tbl,l_ta_metadata_tbl,l_return_status,l_msg_count,l_msg_data );
1602: FOR i IN l_ta_metadata_tbl.first..l_ta_metadata_tbl.last
1603: LOOP
1604: l_association_id := l_ta_metadata_tbl(i).associationid;

Line 1737: FND_MSG_PUB.Add;

1733: EXCEPTION
1734: WHEN e_ta_disp_name_exist THEN
1735: x_return_status := G_STATUS_ERROR;
1736: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');
1737: FND_MSG_PUB.Add;
1738: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1739: ,p_count => x_msg_count
1740: ,p_data => x_msg_data);
1741: WHEN OTHERS THEN

Line 1738: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1734: WHEN e_ta_disp_name_exist THEN
1735: x_return_status := G_STATUS_ERROR;
1736: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');
1737: FND_MSG_PUB.Add;
1738: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1739: ,p_count => x_msg_count
1740: ,p_data => x_msg_data);
1741: WHEN OTHERS THEN
1742: x_return_status := G_STATUS_ERROR;

Line 1747: FND_MSG_PUB.Add;

1743: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1744: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1745: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1746: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1747: FND_MSG_PUB.Add;
1748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1749: ,p_count => x_msg_count
1750: ,p_data => x_msg_data);
1751:

Line 1748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1744: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1745: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1746: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1747: FND_MSG_PUB.Add;
1748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1749: ,p_count => x_msg_count
1750: ,p_data => x_msg_data);
1751:
1752: END Update_Transaction_Attribute;

Line 1770: FND_MSG_PUB.Initialize;

1766: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction_Attribute';
1767:
1768: BEGIN
1769: --Reset all global variables
1770: FND_MSG_PUB.Initialize;
1771: DELETE FROM EGO_TRANS_ATTR_VERS_B
1772: WHERE ASSOCIATION_ID= p_association_id
1773: AND ATTR_ID =p_attr_id
1774: AND ICC_VERSION_NUMBER=0;

Line 1784: FND_MSG_PUB.Add;

1780: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1781: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1782: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1783: FND_MESSAGE.Set_Token('SQL_ERR_MSG',SQLERRM);
1784: FND_MSG_PUB.Add;
1785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1786: ,p_count => x_msg_count
1787: ,p_data => x_msg_data);
1788: END Delete_Transaction_Attribute;

Line 1785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1781: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1782: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1783: FND_MESSAGE.Set_Token('SQL_ERR_MSG',SQLERRM);
1784: FND_MSG_PUB.Add;
1785: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1786: ,p_count => x_msg_count
1787: ,p_data => x_msg_data);
1788: END Delete_Transaction_Attribute;
1789:

Line 1809: FND_MSG_PUB.Initialize;

1805: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Transaction_Attribute';
1806:
1807: BEGIN
1808: --Reset all global variables
1809: FND_MSG_PUB.Initialize;
1810: FOR i IN p_tran_attrs_tbl.first..p_tran_attrs_tbl.last
1811: LOOP
1812: l_association_id := p_tran_attrs_tbl(i).associationid;
1813: l_attr_id := p_tran_attrs_tbl(i).attrid;

Line 1830: FND_MSG_PUB.Add;

1826: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1827: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1828: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1829: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1830: FND_MSG_PUB.Add;
1831: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1832: ,p_count => x_msg_count
1833: ,p_data => x_msg_data);
1834: END Delete_Transaction_Attribute;

Line 1831: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1827: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1828: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1829: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1830: FND_MSG_PUB.Add;
1831: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1832: ,p_count => x_msg_count
1833: ,p_data => x_msg_data);
1834: END Delete_Transaction_Attribute;
1835:

Line 1876: FND_MSG_PUB.Initialize;

1872: WHERE ITEM_CATALOG_GROUP_ID=l_item_cat_group_id;
1873:
1874: BEGIN
1875: --Reset all global variables
1876: FND_MSG_PUB.Initialize;
1877: FOR i IN cur_tran_attr_vers_exist
1878: LOOP
1879: l_max_ver_number:=i.maxver;
1880: END LOOP;

Line 1900: FND_MSG_PUB.Add;

1896: WHEN e_version_error
1897: THEN
1898: x_return_status := G_STATUS_ERROR;
1899: FND_MESSAGE.Set_Name('EGO', 'EGO_ICC_VER_ERROR');
1900: FND_MSG_PUB.Add;
1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1902: ,p_count => x_msg_count
1903: ,p_data => x_msg_data);
1904: WHEN OTHERS

Line 1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1897: THEN
1898: x_return_status := G_STATUS_ERROR;
1899: FND_MESSAGE.Set_Name('EGO', 'EGO_ICC_VER_ERROR');
1900: FND_MSG_PUB.Add;
1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1902: ,p_count => x_msg_count
1903: ,p_data => x_msg_data);
1904: WHEN OTHERS
1905: THEN

Line 1911: FND_MSG_PUB.Add;

1907: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1908: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1909: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1910: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1911: FND_MSG_PUB.Add;
1912: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1913: ,p_count => x_msg_count
1914: ,p_data => x_msg_data);
1915: END;

Line 1912: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1908: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1909: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1910: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1911: FND_MSG_PUB.Add;
1912: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1913: ,p_count => x_msg_count
1914: ,p_data => x_msg_data);
1915: END;
1916:

Line 1939: FND_MSG_PUB.Initialize;

1935: WHERE ITEM_CATALOG_GROUP_ID=l_item_cat_group_id
1936: AND ICC_VERSION_NUMBER =0;
1937: BEGIN
1938: --Reset all global variables
1939: FND_MSG_PUB.Initialize;
1940: FOR i IN cur_tran_attr_vers
1941: LOOP
1942: INSERT INTO EGO_TRANS_ATTR_VERS_B
1943: (association_id,attr_id,icc_version_number,attr_display_name,"SEQUENCE",value_set_id,uom_class,

Line 1961: FND_MSG_PUB.Add;

1957: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1958: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1959: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1960: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.Add;
1962: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1963: ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: END;

Line 1962: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1958: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1959: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1960: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1961: FND_MSG_PUB.Add;
1962: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1963: ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: END;
1966:

Line 2002: FND_MSG_PUB.Initialize;

1998: AND ICC_VERSION_NUMBER =0;*/
1999: BEGIN
2000: --Reset all global variables
2001: IF p_init_msg_list THEN --- BUG 9791391 added if condition
2002: FND_MSG_PUB.Initialize;
2003: END IF;
2004:
2005:
2006: IF (p_sorce_item_id IS NOT NULL AND p_source_rev_id IS NOT NULL AND p_source_org_id IS NOT NULL ) THEN

Line 2038: FND_MSG_PUB.Add;

2034: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2035: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2036: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2037: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2038: FND_MSG_PUB.Add;
2039: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2040: ,p_count => x_msg_count
2041: ,p_data => x_msg_data);
2042:

Line 2039: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2035: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2036: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2037: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2038: FND_MSG_PUB.Add;
2039: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2040: ,p_count => x_msg_count
2041: ,p_data => x_msg_data);
2042:
2043: END;

Line 2061: FND_MSG_PUB.Initialize;

2057:
2058: BEGIN
2059: --Reset all global variables
2060: IF p_init_msg_list THEN --- Bug 9791391 , added IF condition
2061: FND_MSG_PUB.Initialize;
2062: END IF;
2063:
2064:
2065: DELETE FROM EGO_TRANS_ATTR_VERS_B

Line 2094: FND_MSG_PUB.Add;

2090: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2091: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2092: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2093: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2094: FND_MSG_PUB.Add;
2095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2096: ,p_count => x_msg_count
2097: ,p_data => x_msg_data);
2098: END;

Line 2095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2091: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2092: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2093: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2094: FND_MSG_PUB.Add;
2095: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2096: ,p_count => x_msg_count
2097: ,p_data => x_msg_data);
2098: END;
2099: