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

Line 135: FND_MSG_PUB.initialize;

131: --l_init_msg_list := p_init_msg_list;
132:
133: IF FND_API.to_Boolean( l_init_msg_list )
134: THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:
138: l_init_msg_list := FND_API.g_false;
139:

Line 338: FND_MSG_PUB.count_and_get(

334: x_citem_ver_id := l_citem_ver_id;
335: x_return_status := l_return_status;
336: --
337: -- Standard call to get message count and if count is 1, get message info.
338: FND_MSG_PUB.count_and_get(
339: p_count => x_msg_count,
340: p_data => x_msg_data
341: );
342: --

Line 347: FND_MSG_PUB.count_and_get (

343: EXCEPTION
344: WHEN FND_API.g_exc_error THEN
345: ROLLBACK TO create_citem_for_delv_PVT;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.count_and_get (
348: p_count => x_msg_count,
349: p_data => x_msg_data,
350: p_encoded => FND_API.G_FALSE
351: );

Line 355: FND_MSG_PUB.count_and_get (

351: );
352: WHEN FND_API.g_exc_unexpected_error THEN
353: ROLLBACK TO create_citem_for_delv_PVT;
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
355: FND_MSG_PUB.count_and_get (
356: p_count => x_msg_count,
357: p_data => x_msg_data,
358: p_encoded => FND_API.G_FALSE
359: );

Line 363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

359: );
360: WHEN OTHERS THEN
361: ROLLBACK TO create_citem_for_delv_PVT;
362: x_return_status := FND_API.g_ret_sts_unexp_error;
363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
364: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
365: END IF;
366: FND_MSG_PUB.count_and_get (
367: p_count => x_msg_count,

Line 364: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

360: WHEN OTHERS THEN
361: ROLLBACK TO create_citem_for_delv_PVT;
362: x_return_status := FND_API.g_ret_sts_unexp_error;
363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
364: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
365: END IF;
366: FND_MSG_PUB.count_and_get (
367: p_count => x_msg_count,
368: p_data => x_msg_data,

Line 366: FND_MSG_PUB.count_and_get (

362: x_return_status := FND_API.g_ret_sts_unexp_error;
363: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
364: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
365: END IF;
366: FND_MSG_PUB.count_and_get (
367: p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => FND_API.G_FALSE
370: );

Line 523: FND_MSG_PUB.initialize;

519: --l_init_msg_list := p_init_msg_list;
520:
521: IF FND_API.to_Boolean( l_init_msg_list )
522: THEN
523: FND_MSG_PUB.initialize;
524: END IF;
525:
526: l_init_msg_list := FND_API.g_false;
527:

Line 737: FND_MSG_PUB.count_and_get(

733:
734: x_return_status := l_return_status;
735:
736: -- Standard call to get message count and if count is 1, get message info.
737: FND_MSG_PUB.count_and_get(
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );
741:

Line 746: FND_MSG_PUB.count_and_get (

742: EXCEPTION
743: WHEN FND_API.g_exc_error THEN
744: ROLLBACK ;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: FND_MSG_PUB.count_and_get (
747: p_count => x_msg_count,
748: p_data => x_msg_data,
749: p_encoded => FND_API.G_FALSE
750: );

Line 754: FND_MSG_PUB.count_and_get (

750: );
751: WHEN FND_API.g_exc_unexpected_error THEN
752: ROLLBACK ;
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: FND_MSG_PUB.count_and_get (
755: p_count => x_msg_count,
756: p_data => x_msg_data,
757: p_encoded => FND_API.G_FALSE
758: );

Line 762: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

758: );
759: WHEN OTHERS THEN
760: ROLLBACK ;
761: x_return_status := FND_API.g_ret_sts_unexp_error;
762: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
764: END IF;
765: FND_MSG_PUB.count_and_get (
766: p_count => x_msg_count,

Line 763: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

759: WHEN OTHERS THEN
760: ROLLBACK ;
761: x_return_status := FND_API.g_ret_sts_unexp_error;
762: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
764: END IF;
765: FND_MSG_PUB.count_and_get (
766: p_count => x_msg_count,
767: p_data => x_msg_data,

Line 765: FND_MSG_PUB.count_and_get (

761: x_return_status := FND_API.g_ret_sts_unexp_error;
762: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
764: END IF;
765: FND_MSG_PUB.count_and_get (
766: p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => FND_API.G_FALSE
769: );

Line 970: FND_MSG_PUB.initialize;

966: l_init_msg_list := p_init_msg_list;
967:
968: IF FND_API.to_Boolean( l_init_msg_list )
969: THEN
970: FND_MSG_PUB.initialize;
971: END IF;
972:
973: l_init_msg_list := FND_API.g_false;
974:

Line 1354: FND_MSG_PUB.count_and_get(

1350: px_citem_id := l_citem_id;
1351: px_citem_ver_id := l_citem_ver_id;
1352: --
1353: -- Standard call to get message count and if count is 1, get message info.
1354: FND_MSG_PUB.count_and_get(
1355: p_count => x_msg_count,
1356: p_data => x_msg_data
1357: );
1358: --

Line 1363: FND_MSG_PUB.count_and_get (

1359: EXCEPTION
1360: WHEN FND_API.g_exc_error THEN
1361: ROLLBACK TO manage_rich_content_PVT ;
1362: x_return_status := FND_API.G_RET_STS_ERROR;
1363: FND_MSG_PUB.count_and_get (
1364: p_count => x_msg_count,
1365: p_data => x_msg_data,
1366: p_encoded => FND_API.G_FALSE
1367: );

Line 1371: FND_MSG_PUB.count_and_get (

1367: );
1368: WHEN FND_API.g_exc_unexpected_error THEN
1369: ROLLBACK TO manage_rich_content_PVT ;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: FND_MSG_PUB.count_and_get (
1372: p_count => x_msg_count,
1373: p_data => x_msg_data,
1374: p_encoded => FND_API.G_FALSE
1375: );

Line 1379: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1375: );
1376: WHEN OTHERS THEN
1377: ROLLBACK TO manage_rich_content_PVT ;
1378: x_return_status := FND_API.g_ret_sts_unexp_error;
1379: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1380: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1381: END IF;
1382: FND_MSG_PUB.count_and_get (
1383: p_count => x_msg_count,

Line 1380: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1376: WHEN OTHERS THEN
1377: ROLLBACK TO manage_rich_content_PVT ;
1378: x_return_status := FND_API.g_ret_sts_unexp_error;
1379: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1380: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1381: END IF;
1382: FND_MSG_PUB.count_and_get (
1383: p_count => x_msg_count,
1384: p_data => x_msg_data,

Line 1382: FND_MSG_PUB.count_and_get (

1378: x_return_status := FND_API.g_ret_sts_unexp_error;
1379: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1380: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1381: END IF;
1382: FND_MSG_PUB.count_and_get (
1383: p_count => x_msg_count,
1384: p_data => x_msg_data,
1385: p_encoded => FND_API.G_FALSE
1386: );

Line 1513: FND_MSG_PUB.initialize;

1509: l_init_msg_list := p_init_msg_list;
1510:
1511: IF FND_API.to_Boolean( l_init_msg_list )
1512: THEN
1513: FND_MSG_PUB.initialize;
1514: END IF;
1515:
1516: l_init_msg_list := FND_API.g_false;
1517:

Line 1748: FND_MSG_PUB.count_and_get(

1744: px_citem_id := l_citem_id;
1745: px_citem_ver_id := l_citem_ver_id;
1746: --
1747: -- Standard call to get message count and if count is 1, get message info.
1748: FND_MSG_PUB.count_and_get(
1749: p_count => x_msg_count,
1750: p_data => x_msg_data
1751: );
1752: --

Line 1757: FND_MSG_PUB.count_and_get (

1753: EXCEPTION
1754: WHEN FND_API.g_exc_error THEN
1755: ROLLBACK TO manage_toc_section_PVT ;
1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: FND_MSG_PUB.count_and_get (
1758: p_count => x_msg_count,
1759: p_data => x_msg_data,
1760: p_encoded => FND_API.G_FALSE
1761: );

Line 1765: FND_MSG_PUB.count_and_get (

1761: );
1762: WHEN FND_API.g_exc_unexpected_error THEN
1763: ROLLBACK TO manage_toc_section_PVT ;
1764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1765: FND_MSG_PUB.count_and_get (
1766: p_count => x_msg_count,
1767: p_data => x_msg_data,
1768: p_encoded => FND_API.G_FALSE
1769: );

Line 1773: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1769: );
1770: WHEN OTHERS THEN
1771: ROLLBACK TO manage_toc_section_PVT ;
1772: x_return_status := FND_API.g_ret_sts_unexp_error;
1773: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1775: END IF;
1776: FND_MSG_PUB.count_and_get (
1777: p_count => x_msg_count,

Line 1774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1770: WHEN OTHERS THEN
1771: ROLLBACK TO manage_toc_section_PVT ;
1772: x_return_status := FND_API.g_ret_sts_unexp_error;
1773: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1775: END IF;
1776: FND_MSG_PUB.count_and_get (
1777: p_count => x_msg_count,
1778: p_data => x_msg_data,

Line 1776: FND_MSG_PUB.count_and_get (

1772: x_return_status := FND_API.g_ret_sts_unexp_error;
1773: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1774: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1775: END IF;
1776: FND_MSG_PUB.count_and_get (
1777: p_count => x_msg_count,
1778: p_data => x_msg_data,
1779: p_encoded => FND_API.G_FALSE
1780: );

Line 1906: FND_MSG_PUB.count_and_get(

1902: x_attribute_values := l_attributes;
1903: x_object_version_number := l_object_version_number;
1904:
1905: -- Standard call to get message count and if count is 1, get message info.
1906: FND_MSG_PUB.count_and_get(
1907: p_count => x_msg_count,
1908: p_data => x_msg_data
1909: );
1910:

Line 1915: FND_MSG_PUB.count_and_get (

1911: EXCEPTION
1912: WHEN FND_API.g_exc_error THEN
1913: ROLLBACK;
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915: FND_MSG_PUB.count_and_get (
1916: p_count => x_msg_count,
1917: p_data => x_msg_data,
1918: p_encoded => FND_API.G_FALSE
1919: );

Line 1923: FND_MSG_PUB.count_and_get (

1919: );
1920: WHEN FND_API.g_exc_unexpected_error THEN
1921: ROLLBACK;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1923: FND_MSG_PUB.count_and_get (
1924: p_count => x_msg_count,
1925: p_data => x_msg_data,
1926: p_encoded => FND_API.G_FALSE
1927: );

Line 1931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1927: );
1928: WHEN OTHERS THEN
1929: ROLLBACK;
1930: x_return_status := FND_API.g_ret_sts_unexp_error;
1931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1933: END IF;
1934: FND_MSG_PUB.count_and_get (
1935: p_count => x_msg_count,

Line 1932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

1928: WHEN OTHERS THEN
1929: ROLLBACK;
1930: x_return_status := FND_API.g_ret_sts_unexp_error;
1931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1933: END IF;
1934: FND_MSG_PUB.count_and_get (
1935: p_count => x_msg_count,
1936: p_data => x_msg_data,

Line 1934: FND_MSG_PUB.count_and_get (

1930: x_return_status := FND_API.g_ret_sts_unexp_error;
1931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1933: END IF;
1934: FND_MSG_PUB.count_and_get (
1935: p_count => x_msg_count,
1936: p_data => x_msg_data,
1937: p_encoded => FND_API.G_FALSE
1938: );

Line 2217: FND_MSG_PUB.count_and_get(

2213: x_object_version_number := l_object_version_number;
2214:
2215: -- Standard call to get message count and if count is 1, get message info.
2216:
2217: FND_MSG_PUB.count_and_get(
2218: p_count => x_msg_count,
2219: p_data => x_msg_data
2220: );
2221:

Line 2226: FND_MSG_PUB.count_and_get (

2222: EXCEPTION
2223: WHEN FND_API.g_exc_error THEN
2224: ROLLBACK;
2225: x_return_status := FND_API.G_RET_STS_ERROR;
2226: FND_MSG_PUB.count_and_get (
2227: p_count => x_msg_count,
2228: p_data => x_msg_data,
2229: p_encoded => FND_API.G_FALSE
2230: );

Line 2234: FND_MSG_PUB.count_and_get (

2230: );
2231: WHEN FND_API.g_exc_unexpected_error THEN
2232: ROLLBACK;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: FND_MSG_PUB.count_and_get (
2235: p_count => x_msg_count,
2236: p_data => x_msg_data,
2237: p_encoded => FND_API.G_FALSE
2238: );

Line 2242: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2238: );
2239: WHEN OTHERS THEN
2240: ROLLBACK;
2241: x_return_status := FND_API.g_ret_sts_unexp_error;
2242: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2243: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2244: END IF;
2245: FND_MSG_PUB.count_and_get (
2246: p_count => x_msg_count,

Line 2243: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

2239: WHEN OTHERS THEN
2240: ROLLBACK;
2241: x_return_status := FND_API.g_ret_sts_unexp_error;
2242: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2243: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2244: END IF;
2245: FND_MSG_PUB.count_and_get (
2246: p_count => x_msg_count,
2247: p_data => x_msg_data,

Line 2245: FND_MSG_PUB.count_and_get (

2241: x_return_status := FND_API.g_ret_sts_unexp_error;
2242: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2243: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2244: END IF;
2245: FND_MSG_PUB.count_and_get (
2246: p_count => x_msg_count,
2247: p_data => x_msg_data,
2248: p_encoded => FND_API.G_FALSE
2249: );

Line 2390: FND_MSG_PUB.initialize;

2386: --l_init_msg_list := p_init_msg_list;
2387:
2388: IF FND_API.to_Boolean( l_init_msg_list )
2389: THEN
2390: FND_MSG_PUB.initialize;
2391: END IF;
2392:
2393: l_init_msg_list := FND_API.g_false;
2394:

Line 2411: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for IMAGE');

2407: FETCH c_delv_details INTO l_start_date, l_end_date;
2408: CLOSE c_delv_details;
2409: --
2410: -- push this data to FND_Messages so that we see it in the JSPs as well.
2411: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for IMAGE');
2412: IF p_attr_types_image IS NOT NULL
2413: AND
2414: p_attr_values_image IS NOT NULL
2415: THEN

Line 2422: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for CP_IMAGE');

2418: l_err_msg := i || ' : >' || p_attr_types_image(i) || '< : >' || p_attr_values_image(i) || '<';
2419: AMS_UTILITY_PVT.debug_message(l_err_msg);
2420: END LOOP;
2421: END IF;
2422: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for CP_IMAGE');
2423: FOR i IN p_attr_types_cp_image.first .. p_attr_types_cp_image.last
2424: LOOP
2425: l_err_msg := i || ' : >' || p_attr_types_cp_image(i) || '< : >' || p_attr_values_cp_image(i) || '<';
2426: AMS_UTILITY_PVT.debug_message(l_err_msg);

Line 2758: FND_MSG_PUB.count_and_get(

2754: x_cp_image_citem_ver_id := l_citem_ver_id;
2755: x_return_status := l_return_status;
2756:
2757: -- Standard call to get message count and if count is 1, get message info.
2758: FND_MSG_PUB.count_and_get(
2759: p_count => x_msg_count,
2760: p_data => x_msg_data
2761: );
2762:

Line 2767: FND_MSG_PUB.count_and_get (

2763: EXCEPTION
2764: WHEN FND_API.g_exc_error THEN
2765: ROLLBACK TO create_cp_image_PVT ;
2766: x_return_status := FND_API.G_RET_STS_ERROR;
2767: FND_MSG_PUB.count_and_get (
2768: p_count => x_msg_count,
2769: p_data => x_msg_data,
2770: p_encoded => FND_API.G_FALSE
2771: );

Line 2775: FND_MSG_PUB.count_and_get (

2771: );
2772: WHEN FND_API.g_exc_unexpected_error THEN
2773: ROLLBACK TO create_cp_image_PVT ;
2774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2775: FND_MSG_PUB.count_and_get (
2776: p_count => x_msg_count,
2777: p_data => x_msg_data,
2778: p_encoded => FND_API.G_FALSE
2779: );

Line 2783: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2779: );
2780: WHEN OTHERS THEN
2781: ROLLBACK TO create_cp_image_PVT ;
2782: x_return_status := FND_API.g_ret_sts_unexp_error;
2783: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2784: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2785: END IF;
2786: FND_MSG_PUB.count_and_get (
2787: p_count => x_msg_count,

Line 2784: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

2780: WHEN OTHERS THEN
2781: ROLLBACK TO create_cp_image_PVT ;
2782: x_return_status := FND_API.g_ret_sts_unexp_error;
2783: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2784: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2785: END IF;
2786: FND_MSG_PUB.count_and_get (
2787: p_count => x_msg_count,
2788: p_data => x_msg_data,

Line 2786: FND_MSG_PUB.count_and_get (

2782: x_return_status := FND_API.g_ret_sts_unexp_error;
2783: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2784: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
2785: END IF;
2786: FND_MSG_PUB.count_and_get (
2787: p_count => x_msg_count,
2788: p_data => x_msg_data,
2789: p_encoded => FND_API.G_FALSE
2790: );

Line 2912: FND_MSG_PUB.initialize;

2908: --l_init_msg_list := p_init_msg_list;
2909:
2910: IF FND_API.to_Boolean( l_init_msg_list )
2911: THEN
2912: FND_MSG_PUB.initialize;
2913: END IF;
2914:
2915:
2916: l_init_msg_list := FND_API.g_false;

Line 3207: FND_MSG_PUB.count_and_get(

3203:
3204: x_return_status := l_return_status;
3205:
3206: -- Standard call to get message count and if count is 1, get message info.
3207: FND_MSG_PUB.count_and_get(
3208: p_count => x_msg_count,
3209: p_data => x_msg_data
3210: );
3211:

Line 3216: FND_MSG_PUB.count_and_get (

3212: EXCEPTION
3213: WHEN FND_API.g_exc_error THEN
3214: ROLLBACK TO update_cp_image_PVT ;
3215: x_return_status := FND_API.G_RET_STS_ERROR;
3216: FND_MSG_PUB.count_and_get (
3217: p_count => x_msg_count,
3218: p_data => x_msg_data,
3219: p_encoded => FND_API.G_FALSE
3220: );

Line 3224: FND_MSG_PUB.count_and_get (

3220: );
3221: WHEN FND_API.g_exc_unexpected_error THEN
3222: ROLLBACK TO update_cp_image_PVT;
3223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224: FND_MSG_PUB.count_and_get (
3225: p_count => x_msg_count,
3226: p_data => x_msg_data,
3227: p_encoded => FND_API.G_FALSE
3228: );

Line 3232: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3228: );
3229: WHEN OTHERS THEN
3230: ROLLBACK TO update_cp_image_PVT ;
3231: x_return_status := FND_API.g_ret_sts_unexp_error;
3232: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3233: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3234: END IF;
3235: FND_MSG_PUB.count_and_get (
3236: p_count => x_msg_count,

Line 3233: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

3229: WHEN OTHERS THEN
3230: ROLLBACK TO update_cp_image_PVT ;
3231: x_return_status := FND_API.g_ret_sts_unexp_error;
3232: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3233: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3234: END IF;
3235: FND_MSG_PUB.count_and_get (
3236: p_count => x_msg_count,
3237: p_data => x_msg_data,

Line 3235: FND_MSG_PUB.count_and_get (

3231: x_return_status := FND_API.g_ret_sts_unexp_error;
3232: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3233: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3234: END IF;
3235: FND_MSG_PUB.count_and_get (
3236: p_count => x_msg_count,
3237: p_data => x_msg_data,
3238: p_encoded => FND_API.G_FALSE
3239: );

Line 3317: FND_MSG_PUB.count_and_get(

3313: x_attribute_type_names := l_attribute_type_names;
3314: x_attributes := l_attributes;
3315:
3316: -- Standard call to get message count and if count is 1, get message info.
3317: FND_MSG_PUB.count_and_get(
3318: p_count => x_msg_count,
3319: p_data => x_msg_data
3320: );
3321:

Line 3326: FND_MSG_PUB.count_and_get (

3322: EXCEPTION
3323: WHEN FND_API.g_exc_error THEN
3324: ROLLBACK;
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: FND_MSG_PUB.count_and_get (
3327: p_count => x_msg_count,
3328: p_data => x_msg_data,
3329: p_encoded => FND_API.G_FALSE
3330: );

Line 3334: FND_MSG_PUB.count_and_get (

3330: );
3331: WHEN FND_API.g_exc_unexpected_error THEN
3332: ROLLBACK;
3333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3334: FND_MSG_PUB.count_and_get (
3335: p_count => x_msg_count,
3336: p_data => x_msg_data,
3337: p_encoded => FND_API.G_FALSE
3338: );

Line 3342: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3338: );
3339: WHEN OTHERS THEN
3340: ROLLBACK;
3341: x_return_status := FND_API.g_ret_sts_unexp_error;
3342: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3343: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3344: END IF;
3345: FND_MSG_PUB.count_and_get (
3346: p_count => x_msg_count,

Line 3343: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

3339: WHEN OTHERS THEN
3340: ROLLBACK;
3341: x_return_status := FND_API.g_ret_sts_unexp_error;
3342: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3343: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3344: END IF;
3345: FND_MSG_PUB.count_and_get (
3346: p_count => x_msg_count,
3347: p_data => x_msg_data,

Line 3345: FND_MSG_PUB.count_and_get (

3341: x_return_status := FND_API.g_ret_sts_unexp_error;
3342: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3343: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3344: END IF;
3345: FND_MSG_PUB.count_and_get (
3346: p_count => x_msg_count,
3347: p_data => x_msg_data,
3348: p_encoded => FND_API.G_FALSE
3349: );

Line 3463: FND_MSG_PUB.initialize;

3459: --l_init_msg_list := p_init_msg_list;
3460:
3461: IF FND_API.to_Boolean( l_init_msg_list )
3462: THEN
3463: FND_MSG_PUB.initialize;
3464: END IF;
3465:
3466: l_init_msg_list := FND_API.g_false;
3467:

Line 3729: FND_MSG_PUB.count_and_get(

3725:
3726: x_return_status := l_return_status;
3727:
3728: -- Standard call to get message count and if count is 1, get message info.
3729: FND_MSG_PUB.count_and_get(
3730: p_count => x_msg_count,
3731: p_data => x_msg_data
3732: );
3733:

Line 3738: FND_MSG_PUB.count_and_get (

3734: EXCEPTION
3735: WHEN FND_API.g_exc_error THEN
3736: ROLLBACK ;
3737: x_return_status := FND_API.G_RET_STS_ERROR;
3738: FND_MSG_PUB.count_and_get (
3739: p_count => x_msg_count,
3740: p_data => x_msg_data,
3741: p_encoded => FND_API.G_FALSE
3742: );

Line 3746: FND_MSG_PUB.count_and_get (

3742: );
3743: WHEN FND_API.g_exc_unexpected_error THEN
3744: ROLLBACK ;
3745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3746: FND_MSG_PUB.count_and_get (
3747: p_count => x_msg_count,
3748: p_data => x_msg_data,
3749: p_encoded => FND_API.G_FALSE
3750: );

Line 3754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3750: );
3751: WHEN OTHERS THEN
3752: ROLLBACK ;
3753: x_return_status := FND_API.g_ret_sts_unexp_error;
3754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3755: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3756: END IF;
3757: FND_MSG_PUB.count_and_get (
3758: p_count => x_msg_count,

Line 3755: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

3751: WHEN OTHERS THEN
3752: ROLLBACK ;
3753: x_return_status := FND_API.g_ret_sts_unexp_error;
3754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3755: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3756: END IF;
3757: FND_MSG_PUB.count_and_get (
3758: p_count => x_msg_count,
3759: p_data => x_msg_data,

Line 3757: FND_MSG_PUB.count_and_get (

3753: x_return_status := FND_API.g_ret_sts_unexp_error;
3754: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3755: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3756: END IF;
3757: FND_MSG_PUB.count_and_get (
3758: p_count => x_msg_count,
3759: p_data => x_msg_data,
3760: p_encoded => FND_API.G_FALSE
3761: );

Line 3842: FND_MSG_PUB.initialize;

3838: --l_init_msg_list := p_init_msg_list;
3839:
3840: IF FND_API.to_Boolean( l_init_msg_list )
3841: THEN
3842: FND_MSG_PUB.initialize;
3843: END IF;
3844:
3845: l_init_msg_list := FND_API.g_false;
3846:

Line 3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3933: AND associated_object_val1 = TO_CHAR(p_delv_id)
3934: AND association_type_code = G_CPAGE_ASSOC_TYPE_CODE;
3935:
3936: IF (SQL%NOTFOUND) THEN
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3938: THEN
3939: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3940: FND_MSG_PUB.add;
3941: END IF;

Line 3940: FND_MSG_PUB.add;

3936: IF (SQL%NOTFOUND) THEN
3937: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3938: THEN
3939: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3940: FND_MSG_PUB.add;
3941: END IF;
3942: RAISE FND_API.g_exc_error;
3943: END IF;
3944:

Line 3984: FND_MSG_PUB.count_and_get(

3980:
3981: x_return_status := l_return_status;
3982:
3983: -- Standard call to get message count and if count is 1, get message info.
3984: FND_MSG_PUB.count_and_get(
3985: p_count => x_msg_count,
3986: p_data => x_msg_data
3987: );
3988:

Line 3993: FND_MSG_PUB.count_and_get (

3989: EXCEPTION
3990: WHEN FND_API.g_exc_error THEN
3991: ROLLBACK ;
3992: x_return_status := FND_API.G_RET_STS_ERROR;
3993: FND_MSG_PUB.count_and_get (
3994: p_count => x_msg_count,
3995: p_data => x_msg_data,
3996: p_encoded => FND_API.G_FALSE
3997: );

Line 4001: FND_MSG_PUB.count_and_get (

3997: );
3998: WHEN FND_API.g_exc_unexpected_error THEN
3999: ROLLBACK ;
4000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4001: FND_MSG_PUB.count_and_get (
4002: p_count => x_msg_count,
4003: p_data => x_msg_data,
4004: p_encoded => FND_API.G_FALSE
4005: );

Line 4009: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4005: );
4006: WHEN OTHERS THEN
4007: ROLLBACK ;
4008: x_return_status := FND_API.g_ret_sts_unexp_error;
4009: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4010: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4011: END IF;
4012: FND_MSG_PUB.count_and_get (
4013: p_count => x_msg_count,

Line 4010: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

4006: WHEN OTHERS THEN
4007: ROLLBACK ;
4008: x_return_status := FND_API.g_ret_sts_unexp_error;
4009: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4010: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4011: END IF;
4012: FND_MSG_PUB.count_and_get (
4013: p_count => x_msg_count,
4014: p_data => x_msg_data,

Line 4012: FND_MSG_PUB.count_and_get (

4008: x_return_status := FND_API.g_ret_sts_unexp_error;
4009: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4010: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4011: END IF;
4012: FND_MSG_PUB.count_and_get (
4013: p_count => x_msg_count,
4014: p_data => x_msg_data,
4015: p_encoded => FND_API.G_FALSE
4016: );

Line 4110: FND_MSG_PUB.initialize;

4106: --l_init_msg_list := p_init_msg_list;
4107:
4108: IF FND_API.to_Boolean( l_init_msg_list )
4109: THEN
4110: FND_MSG_PUB.initialize;
4111: END IF;
4112:
4113: l_init_msg_list := FND_API.g_false;
4114:

Line 4280: FND_MSG_PUB.count_and_get(

4276: x_citem_id := l_citem_id;
4277: x_citem_ver_id := l_citem_ver_id;
4278: --
4279: -- Standard call to get message count and if count is 1, get message info.
4280: FND_MSG_PUB.count_and_get(
4281: p_count => x_msg_count,
4282: p_data => x_msg_data
4283: );
4284: --

Line 4289: FND_MSG_PUB.count_and_get (

4285: EXCEPTION
4286: WHEN FND_API.g_exc_error THEN
4287: ROLLBACK TO create_display_template_PVT ;
4288: x_return_status := FND_API.G_RET_STS_ERROR;
4289: FND_MSG_PUB.count_and_get (
4290: p_count => x_msg_count,
4291: p_data => x_msg_data,
4292: p_encoded => FND_API.G_FALSE
4293: );

Line 4297: FND_MSG_PUB.count_and_get (

4293: );
4294: WHEN FND_API.g_exc_unexpected_error THEN
4295: ROLLBACK TO create_display_template_PVT ;
4296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4297: FND_MSG_PUB.count_and_get (
4298: p_count => x_msg_count,
4299: p_data => x_msg_data,
4300: p_encoded => FND_API.G_FALSE
4301: );

Line 4305: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4301: );
4302: WHEN OTHERS THEN
4303: ROLLBACK TO create_display_template_PVT ;
4304: x_return_status := FND_API.g_ret_sts_unexp_error;
4305: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4306: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4307: END IF;
4308: FND_MSG_PUB.count_and_get (
4309: p_count => x_msg_count,

Line 4306: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

4302: WHEN OTHERS THEN
4303: ROLLBACK TO create_display_template_PVT ;
4304: x_return_status := FND_API.g_ret_sts_unexp_error;
4305: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4306: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4307: END IF;
4308: FND_MSG_PUB.count_and_get (
4309: p_count => x_msg_count,
4310: p_data => x_msg_data,

Line 4308: FND_MSG_PUB.count_and_get (

4304: x_return_status := FND_API.g_ret_sts_unexp_error;
4305: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4306: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4307: END IF;
4308: FND_MSG_PUB.count_and_get (
4309: p_count => x_msg_count,
4310: p_data => x_msg_data,
4311: p_encoded => FND_API.G_FALSE
4312: );

Line 4416: FND_MSG_PUB.initialize;

4412: --l_init_msg_list := p_init_msg_list;
4413:
4414: IF FND_API.to_Boolean( l_init_msg_list )
4415: THEN
4416: FND_MSG_PUB.initialize;
4417: END IF;
4418:
4419: l_init_msg_list := FND_API.g_false;
4420:

Line 4558: FND_MSG_PUB.count_and_get(

4554: x_citem_id := l_citem_id;
4555: x_citem_ver_id := l_citem_ver_id;
4556: --
4557: -- Standard call to get message count and if count is 1, get message info.
4558: FND_MSG_PUB.count_and_get(
4559: p_count => x_msg_count,
4560: p_data => x_msg_data
4561: );
4562: --

Line 4567: FND_MSG_PUB.count_and_get (

4563: EXCEPTION
4564: WHEN FND_API.g_exc_error THEN
4565: ROLLBACK TO create_basic_ques_item_PVT ;
4566: x_return_status := FND_API.G_RET_STS_ERROR;
4567: FND_MSG_PUB.count_and_get (
4568: p_count => x_msg_count,
4569: p_data => x_msg_data,
4570: p_encoded => FND_API.G_FALSE
4571: );

Line 4575: FND_MSG_PUB.count_and_get (

4571: );
4572: WHEN FND_API.g_exc_unexpected_error THEN
4573: ROLLBACK TO create_basic_ques_item_PVT ;
4574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4575: FND_MSG_PUB.count_and_get (
4576: p_count => x_msg_count,
4577: p_data => x_msg_data,
4578: p_encoded => FND_API.G_FALSE
4579: );

Line 4583: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4579: );
4580: WHEN OTHERS THEN
4581: ROLLBACK TO create_basic_ques_item_PVT ;
4582: x_return_status := FND_API.g_ret_sts_unexp_error;
4583: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4584: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4585: END IF;
4586: FND_MSG_PUB.count_and_get (
4587: p_count => x_msg_count,

Line 4584: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

4580: WHEN OTHERS THEN
4581: ROLLBACK TO create_basic_ques_item_PVT ;
4582: x_return_status := FND_API.g_ret_sts_unexp_error;
4583: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4584: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4585: END IF;
4586: FND_MSG_PUB.count_and_get (
4587: p_count => x_msg_count,
4588: p_data => x_msg_data,

Line 4586: FND_MSG_PUB.count_and_get (

4582: x_return_status := FND_API.g_ret_sts_unexp_error;
4583: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4584: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4585: END IF;
4586: FND_MSG_PUB.count_and_get (
4587: p_count => x_msg_count,
4588: p_data => x_msg_data,
4589: p_encoded => FND_API.G_FALSE
4590: );

Line 4905: FND_MSG_PUB.count_and_get(

4901: x_select_sql_statement := l_select_sql_statement ;
4902: x_bind_vars := l_bind_vars ;
4903: --
4904: -- Standard call to get message count and if count is 1, get message info.
4905: FND_MSG_PUB.count_and_get(
4906: p_encoded => FND_API.G_FALSE,
4907: p_count => x_msg_count,
4908: p_data => x_msg_data
4909: );

Line 4915: FND_MSG_PUB.count_and_get (

4911: EXCEPTION
4912: WHEN FND_API.g_exc_error THEN
4913: ROLLBACK;
4914: x_return_status := FND_API.G_RET_STS_ERROR;
4915: FND_MSG_PUB.count_and_get (
4916: p_count => x_msg_count,
4917: p_data => x_msg_data,
4918: p_encoded => FND_API.G_FALSE
4919: );

Line 4923: FND_MSG_PUB.count_and_get (

4919: );
4920: WHEN FND_API.g_exc_unexpected_error THEN
4921: ROLLBACK;
4922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4923: FND_MSG_PUB.count_and_get (
4924: p_count => x_msg_count,
4925: p_data => x_msg_data,
4926: p_encoded => FND_API.G_FALSE
4927: );

Line 4931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4927: );
4928: WHEN OTHERS THEN
4929: ROLLBACK;
4930: x_return_status := FND_API.g_ret_sts_unexp_error;
4931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4933: END IF;
4934: FND_MSG_PUB.count_and_get (
4935: p_count => x_msg_count,

Line 4932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

4928: WHEN OTHERS THEN
4929: ROLLBACK;
4930: x_return_status := FND_API.g_ret_sts_unexp_error;
4931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4933: END IF;
4934: FND_MSG_PUB.count_and_get (
4935: p_count => x_msg_count,
4936: p_data => x_msg_data,

Line 4934: FND_MSG_PUB.count_and_get (

4930: x_return_status := FND_API.g_ret_sts_unexp_error;
4931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4932: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
4933: END IF;
4934: FND_MSG_PUB.count_and_get (
4935: p_count => x_msg_count,
4936: p_data => x_msg_data,
4937: p_encoded => FND_API.G_FALSE
4938: );

Line 5058: FND_MSG_PUB.initialize;

5054: --l_init_msg_list := p_init_msg_list;
5055:
5056: IF FND_API.to_Boolean( l_init_msg_list )
5057: THEN
5058: FND_MSG_PUB.initialize;
5059: END IF;
5060:
5061: l_init_msg_list := FND_API.g_false;
5062:

Line 5308: FND_MSG_PUB.count_and_get(

5304: x_citem_id := l_citem_id;
5305: x_citem_ver_id := l_citem_ver_id;
5306: --
5307: -- Standard call to get message count and if count is 1, get message info.
5308: FND_MSG_PUB.count_and_get(
5309: p_count => x_msg_count,
5310: p_data => x_msg_data
5311: );
5312: --

Line 5317: FND_MSG_PUB.count_and_get (

5313: EXCEPTION
5314: WHEN FND_API.g_exc_error THEN
5315: ROLLBACK TO create_submit_section_PVT ;
5316: x_return_status := FND_API.G_RET_STS_ERROR;
5317: FND_MSG_PUB.count_and_get (
5318: p_count => x_msg_count,
5319: p_data => x_msg_data,
5320: p_encoded => FND_API.G_FALSE
5321: );

Line 5325: FND_MSG_PUB.count_and_get (

5321: );
5322: WHEN FND_API.g_exc_unexpected_error THEN
5323: ROLLBACK TO create_submit_section_PVT ;
5324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5325: FND_MSG_PUB.count_and_get (
5326: p_count => x_msg_count,
5327: p_data => x_msg_data,
5328: p_encoded => FND_API.G_FALSE
5329: );

Line 5333: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5329: );
5330: WHEN OTHERS THEN
5331: ROLLBACK TO create_submit_section_PVT ;
5332: x_return_status := FND_API.g_ret_sts_unexp_error;
5333: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5334: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
5335: END IF;
5336: FND_MSG_PUB.count_and_get (
5337: p_count => x_msg_count,

Line 5334: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

5330: WHEN OTHERS THEN
5331: ROLLBACK TO create_submit_section_PVT ;
5332: x_return_status := FND_API.g_ret_sts_unexp_error;
5333: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5334: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
5335: END IF;
5336: FND_MSG_PUB.count_and_get (
5337: p_count => x_msg_count,
5338: p_data => x_msg_data,

Line 5336: FND_MSG_PUB.count_and_get (

5332: x_return_status := FND_API.g_ret_sts_unexp_error;
5333: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5334: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
5335: END IF;
5336: FND_MSG_PUB.count_and_get (
5337: p_count => x_msg_count,
5338: p_data => x_msg_data,
5339: p_encoded => FND_API.G_FALSE
5340: );

Line 5436: FND_MSG_PUB.initialize;

5432: --l_init_msg_list := p_init_msg_list;
5433:
5434: IF FND_API.to_Boolean( l_init_msg_list )
5435: THEN
5436: FND_MSG_PUB.initialize;
5437: END IF;
5438:
5439: l_init_msg_list := FND_API.g_false;
5440:

Line 5534: FND_MSG_PUB.count_and_get(

5530:
5531: x_return_status := l_return_status;
5532:
5533: -- Standard call to get message count and if count is 1, get message info.
5534: FND_MSG_PUB.count_and_get(
5535: p_count => x_msg_count,
5536: p_data => x_msg_data
5537: );
5538:

Line 5543: FND_MSG_PUB.count_and_get (

5539: EXCEPTION
5540: WHEN FND_API.g_exc_error THEN
5541: ROLLBACK ;
5542: x_return_status := FND_API.G_RET_STS_ERROR;
5543: FND_MSG_PUB.count_and_get (
5544: p_count => x_msg_count,
5545: p_data => x_msg_data,
5546: p_encoded => FND_API.G_FALSE
5547: );

Line 5551: FND_MSG_PUB.count_and_get (

5547: );
5548: WHEN FND_API.g_exc_unexpected_error THEN
5549: ROLLBACK ;
5550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5551: FND_MSG_PUB.count_and_get (
5552: p_count => x_msg_count,
5553: p_data => x_msg_data,
5554: p_encoded => FND_API.G_FALSE
5555: );

Line 5559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5555: );
5556: WHEN OTHERS THEN
5557: ROLLBACK ;
5558: x_return_status := FND_API.g_ret_sts_unexp_error;
5559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
5561: END IF;
5562: FND_MSG_PUB.count_and_get (
5563: p_count => x_msg_count,

Line 5560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

5556: WHEN OTHERS THEN
5557: ROLLBACK ;
5558: x_return_status := FND_API.g_ret_sts_unexp_error;
5559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
5561: END IF;
5562: FND_MSG_PUB.count_and_get (
5563: p_count => x_msg_count,
5564: p_data => x_msg_data,

Line 5562: FND_MSG_PUB.count_and_get (

5558: x_return_status := FND_API.g_ret_sts_unexp_error;
5559: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5560: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
5561: END IF;
5562: FND_MSG_PUB.count_and_get (
5563: p_count => x_msg_count,
5564: p_data => x_msg_data,
5565: p_encoded => FND_API.G_FALSE
5566: );

Line 5744: FND_MSG_PUB.initialize;

5740: l_init_msg_list := p_init_msg_list;
5741:
5742: IF FND_API.to_Boolean( l_init_msg_list )
5743: THEN
5744: FND_MSG_PUB.initialize;
5745: END IF;
5746:
5747: l_init_msg_list := FND_API.g_false;
5748:

Line 5980: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for update');

5976:
5977: -- At this point the attribute bundle is read for setting.
5978: -- And the attachment has to be set as well.
5979:
5980: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name, 'Data for update');
5981: IF l_attribute_type_codes IS NOT NULL
5982: AND
5983: l_attributes IS NOT NULL
5984: THEN

Line 6113: FND_MSG_PUB.count_and_get(

6109: --
6110: x_return_status := l_return_status ;
6111: --
6112: -- Standard call to get message count and if count is 1, get message info.
6113: FND_MSG_PUB.count_and_get(
6114: p_count => x_msg_count,
6115: p_data => x_msg_data
6116: );
6117: --

Line 6122: FND_MSG_PUB.count_and_get (

6118: EXCEPTION
6119: WHEN FND_API.g_exc_error THEN
6120: ROLLBACK ;
6121: x_return_status := FND_API.G_RET_STS_ERROR;
6122: FND_MSG_PUB.count_and_get (
6123: p_count => x_msg_count,
6124: p_data => x_msg_data,
6125: p_encoded => FND_API.G_FALSE
6126: );

Line 6130: FND_MSG_PUB.count_and_get (

6126: );
6127: WHEN FND_API.g_exc_unexpected_error THEN
6128: ROLLBACK ;
6129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6130: FND_MSG_PUB.count_and_get (
6131: p_count => x_msg_count,
6132: p_data => x_msg_data,
6133: p_encoded => FND_API.G_FALSE
6134: );

Line 6138: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6134: );
6135: WHEN OTHERS THEN
6136: ROLLBACK ;
6137: x_return_status := FND_API.g_ret_sts_unexp_error;
6138: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6139: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
6140: END IF;
6141: FND_MSG_PUB.count_and_get (
6142: p_count => x_msg_count,

Line 6139: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

6135: WHEN OTHERS THEN
6136: ROLLBACK ;
6137: x_return_status := FND_API.g_ret_sts_unexp_error;
6138: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6139: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
6140: END IF;
6141: FND_MSG_PUB.count_and_get (
6142: p_count => x_msg_count,
6143: p_data => x_msg_data,

Line 6141: FND_MSG_PUB.count_and_get (

6137: x_return_status := FND_API.g_ret_sts_unexp_error;
6138: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6139: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
6140: END IF;
6141: FND_MSG_PUB.count_and_get (
6142: p_count => x_msg_count,
6143: p_data => x_msg_data,
6144: p_encoded => FND_API.G_FALSE
6145: );

Line 6168: FND_MSG_PUB.initialize;

6164: AMS_UTILITY_PVT.debug_message('enter erase');
6165:
6166: IF FND_API.to_Boolean( p_init_msg_list )
6167: THEN
6168: FND_MSG_PUB.initialize;
6169: END IF;
6170:
6171: x_return_status := FND_API.G_RET_STS_SUCCESS;
6172:

Line 6192: FND_MSG_PUB.count_and_get (

6188: EXCEPTION
6189: WHEN FND_API.g_exc_error THEN
6190: ROLLBACK ;
6191: x_return_status := FND_API.G_RET_STS_ERROR;
6192: FND_MSG_PUB.count_and_get (
6193: p_count => x_msg_count,
6194: p_data => x_msg_data,
6195: p_encoded => FND_API.G_FALSE
6196: );

Line 6200: FND_MSG_PUB.count_and_get (

6196: );
6197: WHEN FND_API.g_exc_unexpected_error THEN
6198: ROLLBACK ;
6199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6200: FND_MSG_PUB.count_and_get (
6201: p_count => x_msg_count,
6202: p_data => x_msg_data,
6203: p_encoded => FND_API.G_FALSE
6204: );

Line 6208: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6204: );
6205: WHEN OTHERS THEN
6206: ROLLBACK ;
6207: x_return_status := FND_API.g_ret_sts_unexp_error;
6208: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6209: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
6210: END IF;
6211: FND_MSG_PUB.count_and_get (
6212: p_count => x_msg_count,

Line 6209: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

6205: WHEN OTHERS THEN
6206: ROLLBACK ;
6207: x_return_status := FND_API.g_ret_sts_unexp_error;
6208: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6209: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
6210: END IF;
6211: FND_MSG_PUB.count_and_get (
6212: p_count => x_msg_count,
6213: p_data => x_msg_data,

Line 6211: FND_MSG_PUB.count_and_get (

6207: x_return_status := FND_API.g_ret_sts_unexp_error;
6208: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6209: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
6210: END IF;
6211: FND_MSG_PUB.count_and_get (
6212: p_count => x_msg_count,
6213: p_data => x_msg_data,
6214: p_encoded => FND_API.G_FALSE
6215: );