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_MESSAGE

Line 209: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

205: EXCEPTION
206: WHEN OTHERS THEN
207: x_return_status := G_STATUS_ERROR;
208: x_msg_data := 'TA_SEQUENCE_NOT_EXIST';
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;

Line 210: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

206: WHEN OTHERS THEN
207: x_return_status := G_STATUS_ERROR;
208: x_msg_data := 'TA_SEQUENCE_NOT_EXIST';
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

Line 211: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

207: x_return_status := G_STATUS_ERROR;
208: x_msg_data := 'TA_SEQUENCE_NOT_EXIST';
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

Line 212: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );

208: x_msg_data := 'TA_SEQUENCE_NOT_EXIST';
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);

Line 263: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

259: EXCEPTION
260: WHEN No_Data_Found THEN
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

Line 264: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );

260: WHEN No_Data_Found THEN
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);

Line 348: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

344: EXCEPTION
345: WHEN No_Data_Found THEN
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

Line 349: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );

345: WHEN No_Data_Found THEN
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);

Line 410: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

406: EXCEPTION
407: WHEN OTHERS THEN
408: x_return_status := G_STATUS_ERROR;
409: x_msg_data := 'TA_INSERT_FAILED';
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;

Line 411: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

407: WHEN OTHERS THEN
408: x_return_status := G_STATUS_ERROR;
409: x_msg_data := 'TA_INSERT_FAILED';
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

Line 412: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

408: x_return_status := G_STATUS_ERROR;
409: x_msg_data := 'TA_INSERT_FAILED';
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

Line 413: FND_MESSAGE.Set_Token('SQL_ERR_MSG',SQLERRM);

409: x_msg_data := 'TA_INSERT_FAILED';
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);

Line 427: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');

423: END IF;
424: EXCEPTION
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

Line 435: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');

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

Line 442: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');

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

Line 450: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DEFAULT_VALUE_NULL');

446: ,p_data => x_msg_data);
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);

Line 458: FND_MESSAGE.Set_Name('EGO', 'EGO_VALUE_SET_NOT_VERSIONED');

454: ,p_data => x_msg_data);
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);

Line 466: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');

462: ,p_data => x_msg_data);
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);

Line 475: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_AG_CREATE');

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

Line 483: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_CREATE_FAILED');

479: ,p_data => x_msg_data);
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);

Line 491: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_ASSOC_FAILED');

487: ,p_data => x_msg_data);
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);

Line 499: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_TIP');

495: ,p_data => x_msg_data);
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);

Line 507: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

503: ,p_data => x_msg_data);
504:
505: WHEN OTHERS THEN
506: x_return_status := G_STATUS_ERROR;
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;

Line 508: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

504:
505: WHEN OTHERS THEN
506: x_return_status := G_STATUS_ERROR;
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

Line 509: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

505: WHEN OTHERS THEN
506: x_return_status := G_STATUS_ERROR;
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

Line 510: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

506: x_return_status := G_STATUS_ERROR;
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);

Line 1255: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1251: x_return_status := G_STATUS_SUCCESS;
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_return_status := G_STATUS_ERROR;
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;

Line 1256: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_return_status := G_STATUS_ERROR;
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);

Line 1257: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1253: WHEN OTHERS THEN
1254: x_return_status := G_STATUS_ERROR;
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;

Line 1258: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1254: x_return_status := G_STATUS_ERROR;
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:

Line 1476: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1472: WHEN OTHERS
1473: THEN
1474: x_return_status := G_STATUS_ERROR;
1475: x_msg_data := 'TA_REC_INSERT_FAILED';
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;

Line 1477: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1473: THEN
1474: x_return_status := G_STATUS_ERROR;
1475: x_msg_data := 'TA_REC_INSERT_FAILED';
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

Line 1478: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1474: x_return_status := G_STATUS_ERROR;
1475: x_msg_data := 'TA_REC_INSERT_FAILED';
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

Line 1479: FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );

1475: x_msg_data := 'TA_REC_INSERT_FAILED';
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);

Line 1495: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');

1491: END IF;
1492: EXCEPTION
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

Line 1496: --FND_MESSAGE.Set_Token('SQL_ERR_MSG',x_msg_data );

1492: EXCEPTION
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);

Line 1503: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DEFAULT_VALUE_NULL');

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

Line 1511: FND_MESSAGE.Set_Name('EGO', 'EGO_VALUE_SET_NOT_VERSIONED');

1507: ,p_data => x_msg_data);
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);

Line 1519: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');

1515: ,p_data => x_msg_data);
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);

Line 1527: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1523: ,p_data => x_msg_data);
1524:
1525: WHEN OTHERS THEN
1526: x_return_status := G_STATUS_ERROR;
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;

Line 1528: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1524:
1525: WHEN OTHERS THEN
1526: x_return_status := G_STATUS_ERROR;
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

Line 1529: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1525: WHEN OTHERS THEN
1526: x_return_status := G_STATUS_ERROR;
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

Line 1530: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1526: x_return_status := G_STATUS_ERROR;
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);

Line 1736: FND_MESSAGE.Set_Name('EGO', 'EGO_TA_DISPLAY_NAME_UNIQUE');

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

Line 1743: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1739: ,p_count => x_msg_count
1740: ,p_data => x_msg_data);
1741: WHEN OTHERS THEN
1742: x_return_status := G_STATUS_ERROR;
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;

Line 1744: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1740: ,p_data => x_msg_data);
1741: WHEN OTHERS THEN
1742: x_return_status := G_STATUS_ERROR;
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

Line 1745: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1741: WHEN OTHERS THEN
1742: x_return_status := G_STATUS_ERROR;
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

Line 1746: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1742: x_return_status := G_STATUS_ERROR;
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);

Line 1780: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: x_return_status := G_STATUS_ERROR;
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;

Line 1781: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: x_return_status := G_STATUS_ERROR;
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

Line 1782: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1778: WHEN OTHERS THEN
1779: x_return_status := G_STATUS_ERROR;
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

Line 1783: FND_MESSAGE.Set_Token('SQL_ERR_MSG',SQLERRM);

1779: x_return_status := G_STATUS_ERROR;
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);

Line 1826: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1822:
1823: EXCEPTION
1824: WHEN OTHERS THEN
1825: x_return_status := G_STATUS_ERROR;
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;

Line 1827: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1823: EXCEPTION
1824: WHEN OTHERS THEN
1825: x_return_status := G_STATUS_ERROR;
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

Line 1828: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1824: WHEN OTHERS THEN
1825: x_return_status := G_STATUS_ERROR;
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

Line 1829: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1825: x_return_status := G_STATUS_ERROR;
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);

Line 1899: FND_MESSAGE.Set_Name('EGO', 'EGO_ICC_VER_ERROR');

1895: EXCEPTION
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);

Line 1907: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1903: ,p_data => x_msg_data);
1904: WHEN OTHERS
1905: THEN
1906: x_return_status := G_STATUS_ERROR;
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;

Line 1908: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1904: WHEN OTHERS
1905: THEN
1906: x_return_status := G_STATUS_ERROR;
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

Line 1909: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1905: THEN
1906: x_return_status := G_STATUS_ERROR;
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

Line 1910: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1906: x_return_status := G_STATUS_ERROR;
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);

Line 1957: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1953: END LOOP;
1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: x_return_status := G_STATUS_ERROR;
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;

Line 1958: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1954: EXCEPTION
1955: WHEN OTHERS THEN
1956: x_return_status := G_STATUS_ERROR;
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

Line 1959: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1955: WHEN OTHERS THEN
1956: x_return_status := G_STATUS_ERROR;
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

Line 1960: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1956: x_return_status := G_STATUS_ERROR;
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);

Line 2034: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: x_return_status := G_STATUS_ERROR;
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;

Line 2035: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: x_return_status := G_STATUS_ERROR;
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

Line 2036: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2032: WHEN OTHERS THEN
2033: x_return_status := G_STATUS_ERROR;
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

Line 2037: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2033: x_return_status := G_STATUS_ERROR;
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);

Line 2090: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2086: EXCEPTION
2087: WHEN OTHERS
2088: THEN
2089: x_return_status := G_STATUS_ERROR;
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;

Line 2091: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2087: WHEN OTHERS
2088: THEN
2089: x_return_status := G_STATUS_ERROR;
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

Line 2092: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2088: THEN
2089: x_return_status := G_STATUS_ERROR;
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

Line 2093: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2089: x_return_status := G_STATUS_ERROR;
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);