DBA Data[Home] [Help]

APPS.EGO_TRANSACTION_ATTRS_PVT dependencies on FND_API

Line 19: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

15: G_CURRENT_USER_ID NUMBER := FND_GLOBAL.User_Id;
16: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
17: G_APPLICATION_ID NUMBER := 431;
18:
19: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
20: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
21:
22: ---------------------------------------------------------------
23: -- API Return statuses. --

Line 20: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

16: G_CURRENT_LOGIN_ID NUMBER := FND_GLOBAL.Login_Id;
17: G_APPLICATION_ID NUMBER := 431;
18:
19: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
20: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
21:
22: ---------------------------------------------------------------
23: -- API Return statuses. --
24: ---------------------------------------------------------------

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1724: ,p_is_nls_mode => FND_API.G_FALSE

1720: ,p_owner => NULL
1721: ,p_lud => SYSDATE
1722: ,p_init_msg_list => null
1723: ,p_commit => null
1724: ,p_is_nls_mode => FND_API.G_FALSE
1725: ,p_uom_class => l_uom_class
1726: ,x_return_status => l_return_status
1727: ,x_errorcode => l_errorcode
1728: ,x_msg_count => l_msg_count

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