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.EC_CODE_CONVERSION_PVT dependencies on FND_MSG_PUB

Line 182: FND_MSG_PUB.initialize;

178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean(p_init_msg_list) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 379: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

375: end if;
376:
377:
378: -- Standard call to get message count and if count is 1, get message info.
379: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
380: p_data => p_msg_data);
381:
382: if EC_DEBUG.G_debug_level >= 2 then
383: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_ext_to_int');

Line 389: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
388: p_return_status := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
390: p_data => p_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
393: p_return_status := FND_API.G_RET_STS_ERROR;

Line 394: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

390: p_data => p_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
393: p_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
395: p_data => p_msg_data);
396: WHEN OTHERS THEN
397: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
398: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

397: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
398: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
399: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
403: END IF;
404: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
405: p_data => p_msg_data);

Line 402: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

398: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
399: -- ROLLBACK TO Convert_from_ext_to_int_PVT;
400: p_return_status := FND_API.G_RET_STS_ERROR;
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
403: END IF;
404: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
405: p_data => p_msg_data);
406: END Convert_from_ext_to_int;

Line 404: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

400: p_return_status := FND_API.G_RET_STS_ERROR;
401: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
402: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
403: END IF;
404: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
405: p_data => p_msg_data);
406: END Convert_from_ext_to_int;
407:
408: PROCEDURE Convert_from_int_to_ext

Line 589: FND_MSG_PUB.initialize;

585: END IF;
586:
587: -- Initialize message list if p_init_msg_list is set to TRUE.
588: IF FND_API.to_Boolean(p_init_msg_list) THEN
589: FND_MSG_PUB.initialize;
590: END IF;
591:
592: -- Initialize API return status to success
593: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 814: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,p_data => p_msg_data);

810: COMMIT WORK;
811: END IF;
812: */
813: -- Standard call to get message count and if count is 1, get message info.
814: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,p_data => p_msg_data);
815:
816: if EC_DEBUG.G_debug_level >= 2 then
817: EC_DEBUG.POP('EC_Code_Conversion_PVT.Convert_from_int_to_ext');
818: end if;

Line 823: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

819: EXCEPTION
820: WHEN FND_API.G_EXC_ERROR THEN
821: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
822: p_return_status := FND_API.G_RET_STS_ERROR;
823: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
824: p_data => p_msg_data);
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
827: p_return_status := FND_API.G_RET_STS_ERROR;

Line 828: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

824: p_data => p_msg_data);
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
827: p_return_status := FND_API.G_RET_STS_ERROR;
828: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
829: p_data => p_msg_data);
830: WHEN OTHERS THEN
831: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
832: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

831: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
832: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
833: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
834: p_return_status := FND_API.G_RET_STS_ERROR;
835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
836: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
837: END IF;
838: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
839: p_data => p_msg_data);

Line 836: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

832: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
833: -- ROLLBACK TO Convert_from_int_to_ext_PVT;
834: p_return_status := FND_API.G_RET_STS_ERROR;
835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
836: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
837: END IF;
838: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
839: p_data => p_msg_data);
840:

Line 838: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

834: p_return_status := FND_API.G_RET_STS_ERROR;
835: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
836: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
837: END IF;
838: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
839: p_data => p_msg_data);
840:
841: END Convert_from_int_to_ext;
842:

Line 925: FND_MSG_PUB.initialize;

921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE.
924: IF FND_API.to_Boolean(p_init_msg_list) THEN
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Initialize API return status to success
929: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1177: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1173: COMMIT WORK;
1174: END IF;
1175:
1176: -- Standard call to get message count and if count is 1, get message info.
1177: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1178: p_data => p_msg_data);
1179:
1180: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
1181: then

Line 1192: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1188: EXCEPTION
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: ROLLBACK TO populate_plsql_tbl_PVT;
1191: p_return_status := FND_API.G_RET_STS_ERROR;
1192: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1193: p_data => p_msg_data);
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO populate_plsql_tbl_PVT;
1196: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1197: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1193: p_data => p_msg_data);
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: ROLLBACK TO populate_plsql_tbl_PVT;
1196: p_return_status := FND_API.G_RET_STS_ERROR;
1197: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1198: p_data => p_msg_data);
1199: WHEN OTHERS THEN
1200: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1204: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1200: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: ROLLBACK TO populate_plsql_tbl_PVT;
1203: p_return_status := FND_API.G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1205: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
1206: END IF;
1207: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1208: p_data => p_msg_data);

Line 1205: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

1201: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: ROLLBACK TO populate_plsql_tbl_PVT;
1203: p_return_status := FND_API.G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1205: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
1206: END IF;
1207: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1208: p_data => p_msg_data);
1209:

Line 1207: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1203: p_return_status := FND_API.G_RET_STS_ERROR;
1204: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1205: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
1206: END IF;
1207: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1208: p_data => p_msg_data);
1209:
1210: END populate_plsql_tbl_with_extval;
1211:

Line 1294: FND_MSG_PUB.initialize;

1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN
1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297: -- Initialize API return status to success
1298: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1570: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1566: COMMIT WORK;
1567: END IF;
1568:
1569: -- Standard call to get message count and if count is 1, get message info.
1570: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1571: p_data => p_msg_data);
1572:
1573: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
1574: then

Line 1585: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: ROLLBACK TO populate_plsql_tbl_PVT;
1584: p_return_status := FND_API.G_RET_STS_ERROR;
1585: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1586: p_data => p_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: ROLLBACK TO populate_plsql_tbl_PVT;
1589: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1590: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1586: p_data => p_msg_data);
1587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1588: ROLLBACK TO populate_plsql_tbl_PVT;
1589: p_return_status := FND_API.G_RET_STS_ERROR;
1590: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1591: p_data => p_msg_data);
1592: WHEN OTHERS THEN
1593: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1594: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1593: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1594: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1595: ROLLBACK TO populate_plsql_tbl_PVT;
1596: p_return_status := FND_API.G_RET_STS_ERROR;
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
1599: END IF;
1600: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1601: p_data => p_msg_data);

Line 1598: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

1594: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1595: ROLLBACK TO populate_plsql_tbl_PVT;
1596: p_return_status := FND_API.G_RET_STS_ERROR;
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
1599: END IF;
1600: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1601: p_data => p_msg_data);
1602:

Line 1600: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

1596: p_return_status := FND_API.G_RET_STS_ERROR;
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1598: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
1599: END IF;
1600: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
1601: p_data => p_msg_data);
1602:
1603: END populate_plsql_tbl_with_extval;
1604:

Line 1690: FND_MSG_PUB.initialize;

1686: END IF;
1687:
1688: -- Initialize message list if p_init_msg_list is set to TRUE.
1689: IF FND_API.to_Boolean(p_init_msg_list) THEN
1690: FND_MSG_PUB.initialize;
1691: END IF;
1692:
1693: -- Initialize API return status to success
1694: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2010: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2006: COMMIT WORK;
2007: END IF;
2008:
2009: -- Standard call to get message count and if count is 1, get message info.
2010: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2011: p_data => p_msg_data);
2012:
2013: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
2014: then

Line 2025: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2021: EXCEPTION
2022: WHEN FND_API.G_EXC_ERROR THEN
2023: ROLLBACK TO populate_plsql_tbl_PVT;
2024: p_return_status := FND_API.G_RET_STS_ERROR;
2025: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2026: p_data => p_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO populate_plsql_tbl_PVT;
2029: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2030: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2026: p_data => p_msg_data);
2027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2028: ROLLBACK TO populate_plsql_tbl_PVT;
2029: p_return_status := FND_API.G_RET_STS_ERROR;
2030: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2031: p_data => p_msg_data);
2032: WHEN OTHERS THEN
2033: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2034: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 2037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2033: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2034: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2035: ROLLBACK TO populate_plsql_tbl_PVT;
2036: p_return_status := FND_API.G_RET_STS_ERROR;
2037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2038: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
2039: END IF;
2040: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2041: p_data => p_msg_data);

Line 2038: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

2034: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2035: ROLLBACK TO populate_plsql_tbl_PVT;
2036: p_return_status := FND_API.G_RET_STS_ERROR;
2037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2038: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
2039: END IF;
2040: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2041: p_data => p_msg_data);
2042: END populate_plsql_tbl_with_intval;

Line 2040: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2036: p_return_status := FND_API.G_RET_STS_ERROR;
2037: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2038: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
2039: END IF;
2040: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2041: p_data => p_msg_data);
2042: END populate_plsql_tbl_with_intval;
2043:
2044: PROCEDURE populate_plsql_tbl_with_intval

Line 2132: FND_MSG_PUB.initialize;

2128: END IF;
2129:
2130: -- Initialize message list if p_init_msg_list is set to TRUE.
2131: IF FND_API.to_Boolean(p_init_msg_list) THEN
2132: FND_MSG_PUB.initialize;
2133: END IF;
2134:
2135: -- Initialize API return status to success
2136: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2488: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2484: COMMIT WORK;
2485: END IF;
2486:
2487: -- Standard call to get message count and if count is 1, get message info.
2488: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2489: p_data => p_msg_data);
2490:
2491: if l_return_status = EC_Code_Conversion_PVT.G_XREF_NOT_FOUND
2492: then

Line 2503: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2499: EXCEPTION
2500: WHEN FND_API.G_EXC_ERROR THEN
2501: ROLLBACK TO populate_plsql_tbl_PVT;
2502: p_return_status := FND_API.G_RET_STS_ERROR;
2503: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2504: p_data => p_msg_data);
2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2506: ROLLBACK TO populate_plsql_tbl_PVT;
2507: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2508: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2504: p_data => p_msg_data);
2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2506: ROLLBACK TO populate_plsql_tbl_PVT;
2507: p_return_status := FND_API.G_RET_STS_ERROR;
2508: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2509: p_data => p_msg_data);
2510: WHEN OTHERS THEN
2511: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2512: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 2515: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2511: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
2512: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2513: ROLLBACK TO populate_plsql_tbl_PVT;
2514: p_return_status := FND_API.G_RET_STS_ERROR;
2515: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2516: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
2517: END IF;
2518: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2519: p_data => p_msg_data);

Line 2516: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);

2512: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
2513: ROLLBACK TO populate_plsql_tbl_PVT;
2514: p_return_status := FND_API.G_RET_STS_ERROR;
2515: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2516: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
2517: END IF;
2518: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2519: p_data => p_msg_data);
2520: END populate_plsql_tbl_with_intval;

Line 2518: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,

2514: p_return_status := FND_API.G_RET_STS_ERROR;
2515: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2516: FND_MSG_PUB.Add_Exc_Msg(G_FILE_NAME, G_PKG_NAME, l_api_name);
2517: END IF;
2518: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count,
2519: p_data => p_msg_data);
2520: END populate_plsql_tbl_with_intval;
2521:
2522: END EC_Code_Conversion_PVT;