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