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