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

Line 317: fnd_msg_pub.add;

313: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
314: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
315: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
316: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
317: fnd_msg_pub.add;
318: RAISE fnd_api.g_exc_error;
319: ELSE
320: CLOSE c_location_territory;
321: END IF;

Line 407: fnd_msg_pub.add;

403: END IF;
404:
405: IF l_style_format_code IS NULL THEN
406: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
407: fnd_msg_pub.add;
408: RAISE fnd_api.g_exc_error;
409: END IF;
410:
411: --

Line 453: fnd_msg_pub.add;

449: );
450:
451: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
452: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
453: fnd_msg_pub.add;
454: RAISE fnd_api.g_exc_error;
455: END IF;
456:
457: --

Line 520: fnd_msg_pub.count_and_get (

516: EXCEPTION
517:
518: WHEN fnd_api.g_exc_error THEN
519: x_return_status := fnd_api.g_ret_sts_error;
520: fnd_msg_pub.count_and_get (
521: p_encoded => fnd_api.g_false,
522: p_count => x_msg_count,
523: p_data => x_msg_data
524: );

Line 528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

524: );
525:
526: WHEN OTHERS THEN
527: x_return_status := fnd_api.g_ret_sts_unexp_error;
528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
529: fnd_msg_pub.add_exc_msg(
530: g_pkg_name, l_api_name
531: );
532: END IF;

Line 529: fnd_msg_pub.add_exc_msg(

525:
526: WHEN OTHERS THEN
527: x_return_status := fnd_api.g_ret_sts_unexp_error;
528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
529: fnd_msg_pub.add_exc_msg(
530: g_pkg_name, l_api_name
531: );
532: END IF;
533: fnd_msg_pub.count_and_get (

Line 533: fnd_msg_pub.count_and_get (

529: fnd_msg_pub.add_exc_msg(
530: g_pkg_name, l_api_name
531: );
532: END IF;
533: fnd_msg_pub.count_and_get (
534: p_encoded => fnd_api.g_false,
535: p_count => x_msg_count,
536: p_data => x_msg_data
537: );

Line 700: fnd_msg_pub.add;

696: END IF;
697:
698: IF l_style_format_code IS NULL THEN
699: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
700: fnd_msg_pub.add;
701: RAISE fnd_api.g_exc_error;
702: END IF;
703:
704: --

Line 766: fnd_msg_pub.add;

762:
763: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
764: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
765: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
766: fnd_msg_pub.add;
767: RAISE fnd_api.g_exc_error;
768: END IF;
769:
770: --

Line 811: fnd_msg_pub.count_and_get (

807: EXCEPTION
808:
809: WHEN fnd_api.g_exc_error THEN
810: x_return_status := fnd_api.g_ret_sts_error;
811: fnd_msg_pub.count_and_get (
812: p_encoded => fnd_api.g_false,
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );

Line 819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

815: );
816:
817: WHEN OTHERS THEN
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
820: fnd_msg_pub.add_exc_msg(
821: g_pkg_name, l_api_name
822: );
823: END IF;

Line 820: fnd_msg_pub.add_exc_msg(

816:
817: WHEN OTHERS THEN
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
820: fnd_msg_pub.add_exc_msg(
821: g_pkg_name, l_api_name
822: );
823: END IF;
824: fnd_msg_pub.count_and_get (

Line 824: fnd_msg_pub.count_and_get (

820: fnd_msg_pub.add_exc_msg(
821: g_pkg_name, l_api_name
822: );
823: END IF;
824: fnd_msg_pub.count_and_get (
825: p_encoded => fnd_api.g_false,
826: p_count => x_msg_count,
827: p_data => x_msg_data
828: );

Line 986: fnd_msg_pub.add;

982: END IF;
983:
984: IF l_style_format_code IS NULL THEN
985: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
986: fnd_msg_pub.add;
987: RAISE fnd_api.g_exc_error;
988: END IF;
989:
990: --

Line 1052: fnd_msg_pub.add;

1048:
1049: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1050: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1051: --fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1052: fnd_msg_pub.add;
1053: RAISE fnd_api.g_exc_error;
1054: END IF;
1055:
1056: --

Line 1097: fnd_msg_pub.count_and_get (

1093: EXCEPTION
1094:
1095: WHEN fnd_api.g_exc_error THEN
1096: x_return_status := fnd_api.g_ret_sts_error;
1097: fnd_msg_pub.count_and_get (
1098: p_encoded => fnd_api.g_false,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );

Line 1105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1101: );
1102:
1103: WHEN OTHERS THEN
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1106: fnd_msg_pub.add_exc_msg(
1107: g_pkg_name, l_api_name
1108: );
1109: END IF;

Line 1106: fnd_msg_pub.add_exc_msg(

1102:
1103: WHEN OTHERS THEN
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1106: fnd_msg_pub.add_exc_msg(
1107: g_pkg_name, l_api_name
1108: );
1109: END IF;
1110: fnd_msg_pub.count_and_get (

Line 1110: fnd_msg_pub.count_and_get (

1106: fnd_msg_pub.add_exc_msg(
1107: g_pkg_name, l_api_name
1108: );
1109: END IF;
1110: fnd_msg_pub.count_and_get (
1111: p_encoded => fnd_api.g_false,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );

Line 1194: fnd_msg_pub.add;

1190: fnd_message.set_name('AR','HZ_FMT_INVALID_PK');
1191: fnd_message.set_token('OBJECT_CODE',k_addr_table_name);
1192: fnd_message.set_token('COLUMN_NAME',k_addr_table_pk);
1193: fnd_message.set_token('COLUMN_VALUE',to_char(p_location_id));
1194: fnd_msg_pub.add;
1195: RAISE fnd_api.g_exc_error;
1196: ELSE
1197: CLOSE c_location_territory;
1198: END IF;

Line 1284: fnd_msg_pub.add;

1280: END IF;
1281:
1282: IF l_style_format_code IS NULL THEN
1283: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
1284: fnd_msg_pub.add;
1285: RAISE fnd_api.g_exc_error;
1286: END IF;
1287:
1288: --

Line 1331: fnd_msg_pub.add;

1327:
1328: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1329: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1330: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1331: fnd_msg_pub.add;
1332: RAISE fnd_api.g_exc_error;
1333: END IF;
1334:
1335: --

Line 1378: fnd_msg_pub.count_and_get (

1374: EXCEPTION
1375:
1376: WHEN fnd_api.g_exc_error THEN
1377: x_return_status := fnd_api.g_ret_sts_error;
1378: fnd_msg_pub.count_and_get (
1379: p_encoded => fnd_api.g_false,
1380: p_count => x_msg_count,
1381: p_data => x_msg_data
1382: );

Line 1386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1382: );
1383:
1384: WHEN OTHERS THEN
1385: x_return_status := fnd_api.g_ret_sts_unexp_error;
1386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1387: fnd_msg_pub.add_exc_msg(
1388: g_pkg_name, l_api_name
1389: );
1390: END IF;

Line 1387: fnd_msg_pub.add_exc_msg(

1383:
1384: WHEN OTHERS THEN
1385: x_return_status := fnd_api.g_ret_sts_unexp_error;
1386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1387: fnd_msg_pub.add_exc_msg(
1388: g_pkg_name, l_api_name
1389: );
1390: END IF;
1391: fnd_msg_pub.count_and_get (

Line 1391: fnd_msg_pub.count_and_get (

1387: fnd_msg_pub.add_exc_msg(
1388: g_pkg_name, l_api_name
1389: );
1390: END IF;
1391: fnd_msg_pub.count_and_get (
1392: p_encoded => fnd_api.g_false,
1393: p_count => x_msg_count,
1394: p_data => x_msg_data
1395: );

Line 1559: fnd_msg_pub.add;

1555: END IF;
1556:
1557: IF l_style_format_code IS NULL THEN
1558: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
1559: fnd_msg_pub.add;
1560: RAISE fnd_api.g_exc_error;
1561: END IF;
1562:
1563: --

Line 1666: fnd_msg_pub.add;

1662:
1663: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1664: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1665: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1666: fnd_msg_pub.add;
1667: RAISE fnd_api.g_exc_error;
1668: END IF;
1669:
1670: --

Line 1693: fnd_msg_pub.count_and_get (

1689: EXCEPTION
1690:
1691: WHEN fnd_api.g_exc_error THEN
1692: x_return_status := fnd_api.g_ret_sts_error;
1693: fnd_msg_pub.count_and_get (
1694: p_encoded => fnd_api.g_false,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );

Line 1701: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1697: );
1698:
1699: WHEN OTHERS THEN
1700: x_return_status := fnd_api.g_ret_sts_unexp_error;
1701: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1702: fnd_msg_pub.add_exc_msg(
1703: g_pkg_name, l_api_name
1704: );
1705: END IF;

Line 1702: fnd_msg_pub.add_exc_msg(

1698:
1699: WHEN OTHERS THEN
1700: x_return_status := fnd_api.g_ret_sts_unexp_error;
1701: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1702: fnd_msg_pub.add_exc_msg(
1703: g_pkg_name, l_api_name
1704: );
1705: END IF;
1706: fnd_msg_pub.count_and_get (

Line 1706: fnd_msg_pub.count_and_get (

1702: fnd_msg_pub.add_exc_msg(
1703: g_pkg_name, l_api_name
1704: );
1705: END IF;
1706: fnd_msg_pub.count_and_get (
1707: p_encoded => fnd_api.g_false,
1708: p_count => x_msg_count,
1709: p_data => x_msg_data
1710: );

Line 1835: fnd_msg_pub.add;

1831:
1832:
1833: IF l_style_format_code IS NULL THEN
1834: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
1835: fnd_msg_pub.add;
1836: RAISE fnd_api.g_exc_error;
1837: END IF;
1838:
1839: --

Line 1882: fnd_msg_pub.add;

1878:
1879: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
1880: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
1881: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
1882: fnd_msg_pub.add;
1883: RAISE fnd_api.g_exc_error;
1884: END IF;
1885:
1886: --

Line 1947: fnd_msg_pub.count_and_get (

1943: EXCEPTION
1944:
1945: WHEN fnd_api.g_exc_error THEN
1946: x_return_status := fnd_api.g_ret_sts_error;
1947: fnd_msg_pub.count_and_get (
1948: p_encoded => fnd_api.g_false,
1949: p_count => x_msg_count,
1950: p_data => x_msg_data
1951: );

Line 1955: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1951: );
1952:
1953: WHEN OTHERS THEN
1954: x_return_status := fnd_api.g_ret_sts_unexp_error;
1955: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1956: fnd_msg_pub.add_exc_msg(
1957: g_pkg_name, l_api_name
1958: );
1959: END IF;

Line 1956: fnd_msg_pub.add_exc_msg(

1952:
1953: WHEN OTHERS THEN
1954: x_return_status := fnd_api.g_ret_sts_unexp_error;
1955: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1956: fnd_msg_pub.add_exc_msg(
1957: g_pkg_name, l_api_name
1958: );
1959: END IF;
1960: fnd_msg_pub.count_and_get (

Line 1960: fnd_msg_pub.count_and_get (

1956: fnd_msg_pub.add_exc_msg(
1957: g_pkg_name, l_api_name
1958: );
1959: END IF;
1960: fnd_msg_pub.count_and_get (
1961: p_encoded => fnd_api.g_false,
1962: p_count => x_msg_count,
1963: p_data => x_msg_data
1964: );

Line 2094: fnd_msg_pub.add;

2090:
2091:
2092: IF l_style_format_code IS NULL THEN
2093: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
2094: fnd_msg_pub.add;
2095: RAISE fnd_api.g_exc_error;
2096: END IF;
2097:
2098: --

Line 2165: fnd_msg_pub.add;

2161:
2162: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
2163: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
2164: -- fnd_message.set_token('STYLE_FORMAT',l_style_format_code);
2165: fnd_msg_pub.add;
2166: RAISE fnd_api.g_exc_error;
2167: END IF;
2168:
2169: --

Line 2210: fnd_msg_pub.count_and_get (

2206: EXCEPTION
2207:
2208: WHEN fnd_api.g_exc_error THEN
2209: x_return_status := fnd_api.g_ret_sts_error;
2210: fnd_msg_pub.count_and_get (
2211: p_encoded => fnd_api.g_false,
2212: p_count => x_msg_count,
2213: p_data => x_msg_data
2214: );

Line 2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2214: );
2215:
2216: WHEN OTHERS THEN
2217: x_return_status := fnd_api.g_ret_sts_unexp_error;
2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2219: fnd_msg_pub.add_exc_msg(
2220: g_pkg_name, l_api_name
2221: );
2222: END IF;

Line 2219: fnd_msg_pub.add_exc_msg(

2215:
2216: WHEN OTHERS THEN
2217: x_return_status := fnd_api.g_ret_sts_unexp_error;
2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2219: fnd_msg_pub.add_exc_msg(
2220: g_pkg_name, l_api_name
2221: );
2222: END IF;
2223: fnd_msg_pub.count_and_get (

Line 2223: fnd_msg_pub.count_and_get (

2219: fnd_msg_pub.add_exc_msg(
2220: g_pkg_name, l_api_name
2221: );
2222: END IF;
2223: fnd_msg_pub.count_and_get (
2224: p_encoded => fnd_api.g_false,
2225: p_count => x_msg_count,
2226: p_data => x_msg_data
2227: );

Line 2325: fnd_msg_pub.add;

2321: SELECT COUNT(TABLE_ID) INTO l_tab_count
2322: FROM FND_TABLES WHERE TABLE_NAME = p_object_code;
2323: IF l_tab_count = 0 THEN
2324: fnd_message.set_name('AR','HZ_INVALID_ENTITY_NAME');
2325: fnd_msg_pub.add;
2326: RAISE fnd_api.g_exc_error;
2327: END IF;
2328:
2329: --

Line 2398: fnd_msg_pub.add;

2394:
2395:
2396: IF l_style_format_code IS NULL THEN
2397: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
2398: fnd_msg_pub.add;
2399: RAISE fnd_api.g_exc_error;
2400: END IF;
2401:
2402: --

Line 2472: fnd_msg_pub.add;

2468: );
2469:
2470: IF nvl(g_layout_tbl_cnt,0) = 0 THEN
2471: fnd_message.set_name('AR','HZ_FMT_NO_LAYOUT');
2472: fnd_msg_pub.add;
2473: RAISE fnd_api.g_exc_error;
2474: END IF;
2475:
2476: --

Line 2533: fnd_msg_pub.count_and_get (

2529: EXCEPTION
2530:
2531: WHEN fnd_api.g_exc_error THEN
2532: x_return_status := fnd_api.g_ret_sts_error;
2533: fnd_msg_pub.count_and_get (
2534: p_encoded => fnd_api.g_false,
2535: p_count => x_msg_count,
2536: p_data => x_msg_data
2537: );

Line 2541: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2537: );
2538:
2539: WHEN OTHERS THEN
2540: x_return_status := fnd_api.g_ret_sts_unexp_error;
2541: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2542: fnd_msg_pub.add_exc_msg(
2543: g_pkg_name, l_api_name
2544: );
2545: END IF;

Line 2542: fnd_msg_pub.add_exc_msg(

2538:
2539: WHEN OTHERS THEN
2540: x_return_status := fnd_api.g_ret_sts_unexp_error;
2541: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2542: fnd_msg_pub.add_exc_msg(
2543: g_pkg_name, l_api_name
2544: );
2545: END IF;
2546: fnd_msg_pub.count_and_get (

Line 2546: fnd_msg_pub.count_and_get (

2542: fnd_msg_pub.add_exc_msg(
2543: g_pkg_name, l_api_name
2544: );
2545: END IF;
2546: fnd_msg_pub.count_and_get (
2547: p_encoded => fnd_api.g_false,
2548: p_count => x_msg_count,
2549: p_data => x_msg_data
2550: );

Line 2590: -- fnd_msg_pub.initialize; /Bug 3531172/

2586:
2587: l_tbl_cnt NUMBER;
2588: l_tbl string_tbl_type;
2589: BEGIN
2590: -- fnd_msg_pub.initialize; /*Bug 3531172*/
2591: format_address (
2592: -- input parameters
2593: p_location_id => p_location_id,
2594: p_style_code => p_style_code,

Line 2622: fnd_msg_pub.add;

2618: -----Bug No.4145590
2619: WHEN OTHERS THEN
2620: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2621: fnd_message.set_token('ERROR',SQLERRM);
2622: fnd_msg_pub.add;
2623: return NULL;
2624:
2625: END format_address;
2626:

Line 2709: fnd_msg_pub.add;

2705: -----Bug No.4145590
2706: WHEN OTHERS THEN
2707: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2708: fnd_message.set_token('ERROR',SQLERRM);
2709: fnd_msg_pub.add;
2710: return NULL;
2711:
2712: END format_address_lov;
2713:

Line 2749: -- fnd_msg_pub.initialize; /Bug 3531172/

2745: l_formatted_lines_cnt NUMBER;
2746: l_formatted_name_tbl string_tbl_type;
2747:
2748: BEGIN
2749: -- fnd_msg_pub.initialize; /*Bug 3531172*/
2750: format_name (
2751: -- input parameters
2752: p_party_id => p_party_id,
2753: p_style_code => p_style_code,

Line 2780: fnd_msg_pub.add;

2776: -----Bug No.4145590
2777: WHEN OTHERS THEN
2778: fnd_message.set_name('AR','HZ_API_OTHERS_EXCEP');
2779: fnd_message.set_token('ERROR',SQLERRM);
2780: fnd_msg_pub.add;
2781: return NULL;
2782:
2783: END format_name;
2784:

Line 2981: fnd_msg_pub.add;

2977: IF c_def_style_format%NOTFOUND THEN
2978: -- Error condition... could not determine Style Format whatsoever.
2979: x_return_status := fnd_api.g_ret_sts_error;
2980: fnd_message.set_name('AR','HZ_FMT_CANNOT_GET_FORMAT');
2981: fnd_msg_pub.add;
2982: END IF;
2983: CLOSE c_def_style_format;
2984:
2985: x_style_format_code := l_style_format_code;

Line 2991: fnd_msg_pub.count_and_get (

2987: --
2988: -- Populate return message parameters with message information
2989: --
2990:
2991: fnd_msg_pub.count_and_get (
2992: p_encoded => fnd_api.g_false,
2993: p_count => x_msg_count,
2994: p_data => x_msg_data
2995: );

Line 3001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2997: EXCEPTION
2998:
2999: WHEN OTHERS THEN
3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3002: fnd_msg_pub.add_exc_msg(
3003: g_pkg_name, l_api_name
3004: );
3005: END IF;

Line 3002: fnd_msg_pub.add_exc_msg(

2998:
2999: WHEN OTHERS THEN
3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3002: fnd_msg_pub.add_exc_msg(
3003: g_pkg_name, l_api_name
3004: );
3005: END IF;
3006: fnd_msg_pub.count_and_get (

Line 3006: fnd_msg_pub.count_and_get (

3002: fnd_msg_pub.add_exc_msg(
3003: g_pkg_name, l_api_name
3004: );
3005: END IF;
3006: fnd_msg_pub.count_and_get (
3007: p_encoded => fnd_api.g_false,
3008: p_count => x_msg_count,
3009: p_data => x_msg_data
3010: );