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_API

Line 302: x_return_status := fnd_api.g_ret_sts_success;

298: --
299: -- Reset return status and messages
300: --
301:
302: x_return_status := fnd_api.g_ret_sts_success;
303:
304: --
305: -- Get the territory code of the location.
306: -- for address formatting.

Line 318: RAISE fnd_api.g_exc_error;

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;
322:

Line 400: IF x_return_status <> fnd_api.g_ret_sts_success THEN

396: x_msg_data => x_msg_data,
397: x_style_format_code => l_style_format_code
398: );
399: END IF;
400: IF x_return_status <> fnd_api.g_ret_sts_success THEN
401: RAISE fnd_api.g_exc_error;
402: END IF;
403: END IF;
404:

Line 401: RAISE fnd_api.g_exc_error;

397: x_style_format_code => l_style_format_code
398: );
399: END IF;
400: IF x_return_status <> fnd_api.g_ret_sts_success THEN
401: RAISE fnd_api.g_exc_error;
402: END IF;
403: END IF;
404:
405: IF l_style_format_code IS NULL THEN

Line 408: RAISE fnd_api.g_exc_error;

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: --
412: -- Make the context information available to external functions

Line 454: RAISE fnd_api.g_exc_error;

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: --
458: -- Create a dynamic SQL query to get the address elements

Line 518: WHEN fnd_api.g_exc_error THEN

514:
515:
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,

Line 519: x_return_status := fnd_api.g_ret_sts_error;

515:
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

Line 521: p_encoded => fnd_api.g_false,

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

Line 527: x_return_status := fnd_api.g_ret_sts_unexp_error;

523: p_data => x_msg_data
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: );

Line 534: p_encoded => fnd_api.g_false,

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

Line 609: x_return_status := fnd_api.g_ret_sts_success;

605: --
606: -- Reset return status
607: --
608:
609: x_return_status := fnd_api.g_ret_sts_success;
610:
611:
612: --
613: -- Determine/Default the Context Information

Line 693: IF x_return_status <> fnd_api.g_ret_sts_success THEN

689: x_msg_data => x_msg_data,
690: x_style_format_code => l_style_format_code
691: );
692: END IF;
693: IF x_return_status <> fnd_api.g_ret_sts_success THEN
694: RAISE fnd_api.g_exc_error;
695: END IF;
696: END IF;
697:

Line 694: RAISE fnd_api.g_exc_error;

690: x_style_format_code => l_style_format_code
691: );
692: END IF;
693: IF x_return_status <> fnd_api.g_ret_sts_success THEN
694: RAISE fnd_api.g_exc_error;
695: END IF;
696: END IF;
697:
698: IF l_style_format_code IS NULL THEN

Line 701: RAISE fnd_api.g_exc_error;

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: --
705: -- Make the context information available to external functions

Line 767: RAISE fnd_api.g_exc_error;

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: --
771: -- Copy attribute values from parameter table to layout table

Line 809: WHEN fnd_api.g_exc_error THEN

805:
806:
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,

Line 810: x_return_status := fnd_api.g_ret_sts_error;

806:
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

Line 812: p_encoded => fnd_api.g_false,

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

Line 818: x_return_status := fnd_api.g_ret_sts_unexp_error;

814: p_data => x_msg_data
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: );

Line 825: p_encoded => fnd_api.g_false,

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

Line 895: x_return_status := fnd_api.g_ret_sts_success;

891: --
892: -- Reset return status
893: --
894:
895: x_return_status := fnd_api.g_ret_sts_success;
896:
897:
898: --
899: -- Determine/Default the Context Information

Line 979: IF x_return_status <> fnd_api.g_ret_sts_success THEN

975: x_msg_data => x_msg_data,
976: x_style_format_code => l_style_format_code
977: );
978: END IF;
979: IF x_return_status <> fnd_api.g_ret_sts_success THEN
980: RAISE fnd_api.g_exc_error;
981: END IF;
982: END IF;
983:

Line 980: RAISE fnd_api.g_exc_error;

976: x_style_format_code => l_style_format_code
977: );
978: END IF;
979: IF x_return_status <> fnd_api.g_ret_sts_success THEN
980: RAISE fnd_api.g_exc_error;
981: END IF;
982: END IF;
983:
984: IF l_style_format_code IS NULL THEN

Line 987: RAISE fnd_api.g_exc_error;

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: --
991: -- Make the context information available to external functions

Line 1053: RAISE fnd_api.g_exc_error;

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: --
1057: -- Copy attribute values from parameter table to layout table

Line 1095: WHEN fnd_api.g_exc_error THEN

1091:
1092:
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,

Line 1096: x_return_status := fnd_api.g_ret_sts_error;

1092:
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

Line 1098: p_encoded => fnd_api.g_false,

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

Line 1104: x_return_status := fnd_api.g_ret_sts_unexp_error;

1100: p_data => x_msg_data
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: );

Line 1111: p_encoded => fnd_api.g_false,

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

Line 1179: x_return_status := fnd_api.g_ret_sts_success;

1175: --
1176: -- Reset return status and messages
1177: --
1178:
1179: x_return_status := fnd_api.g_ret_sts_success;
1180:
1181: --
1182: -- Get the territory code of the location.
1183: -- for address formatting.

Line 1195: RAISE fnd_api.g_exc_error;

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;
1199:

Line 1277: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1273: x_msg_data => x_msg_data,
1274: x_style_format_code => l_style_format_code
1275: );
1276: END IF;
1277: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1278: RAISE fnd_api.g_exc_error;
1279: END IF;
1280: END IF;
1281:

Line 1278: RAISE fnd_api.g_exc_error;

1274: x_style_format_code => l_style_format_code
1275: );
1276: END IF;
1277: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1278: RAISE fnd_api.g_exc_error;
1279: END IF;
1280: END IF;
1281:
1282: IF l_style_format_code IS NULL THEN

Line 1285: RAISE fnd_api.g_exc_error;

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: --
1289: -- Make the context information available to external functions

Line 1332: RAISE fnd_api.g_exc_error;

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: --
1336: -- Create a dynamic SQL query to get the address elements

Line 1376: WHEN fnd_api.g_exc_error THEN

1372: END IF;
1373:
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,

Line 1377: x_return_status := fnd_api.g_ret_sts_error;

1373:
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

Line 1379: p_encoded => fnd_api.g_false,

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

Line 1385: x_return_status := fnd_api.g_ret_sts_unexp_error;

1381: p_data => x_msg_data
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: );

Line 1392: p_encoded => fnd_api.g_false,

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

Line 1468: x_return_status := fnd_api.g_ret_sts_success;

1464: --
1465: -- Reset return status
1466: --
1467:
1468: x_return_status := fnd_api.g_ret_sts_success;
1469:
1470:
1471: --
1472: -- Determine/Default the Context Information

Line 1552: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1548: x_msg_data => x_msg_data,
1549: x_style_format_code => l_style_format_code
1550: );
1551: END IF;
1552: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1553: RAISE fnd_api.g_exc_error;
1554: END IF;
1555: END IF;
1556:

Line 1553: RAISE fnd_api.g_exc_error;

1549: x_style_format_code => l_style_format_code
1550: );
1551: END IF;
1552: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1553: RAISE fnd_api.g_exc_error;
1554: END IF;
1555: END IF;
1556:
1557: IF l_style_format_code IS NULL THEN

Line 1560: RAISE fnd_api.g_exc_error;

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: --
1564: -- Make the context information available to external functions

Line 1667: RAISE fnd_api.g_exc_error;

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: --
1671: -- Copy attribute values from parameter table to layout table

Line 1691: WHEN fnd_api.g_exc_error THEN

1687: END IF;
1688:
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,

Line 1692: x_return_status := fnd_api.g_ret_sts_error;

1688:
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

Line 1694: p_encoded => fnd_api.g_false,

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

Line 1700: x_return_status := fnd_api.g_ret_sts_unexp_error;

1696: p_data => x_msg_data
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: );

Line 1707: p_encoded => fnd_api.g_false,

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

Line 1764: x_return_status := fnd_api.g_ret_sts_success;

1760: --
1761: -- Reset return status and messages
1762: --
1763:
1764: x_return_status := fnd_api.g_ret_sts_success;
1765:
1766: --
1767: -- Determine/Default the Context Information
1768: --

Line 1827: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1823: x_msg_data => x_msg_data,
1824: x_style_format_code => l_style_format_code
1825: );
1826: END IF;
1827: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1828: RAISE fnd_api.g_exc_error;
1829: END IF;
1830: END IF;
1831:

Line 1828: RAISE fnd_api.g_exc_error;

1824: x_style_format_code => l_style_format_code
1825: );
1826: END IF;
1827: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1828: RAISE fnd_api.g_exc_error;
1829: END IF;
1830: END IF;
1831:
1832:

Line 1836: RAISE fnd_api.g_exc_error;

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: --
1840: -- Make the context information available to external functions

Line 1883: RAISE fnd_api.g_exc_error;

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: --
1887: -- Create a dynamic SQL query to get the name elements

Line 1945: WHEN fnd_api.g_exc_error THEN

1941:
1942: END IF;
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,

Line 1946: x_return_status := fnd_api.g_ret_sts_error;

1942: END IF;
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

Line 1948: p_encoded => fnd_api.g_false,

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

Line 1954: x_return_status := fnd_api.g_ret_sts_unexp_error;

1950: p_data => x_msg_data
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: );

Line 1961: p_encoded => fnd_api.g_false,

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

Line 2023: x_return_status := fnd_api.g_ret_sts_success;

2019: --
2020: -- Reset return status and messages
2021: --
2022:
2023: x_return_status := fnd_api.g_ret_sts_success;
2024:
2025: --
2026: -- Determine/Default the Context Information
2027: --

Line 2086: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2082: x_msg_data => x_msg_data,
2083: x_style_format_code => l_style_format_code
2084: );
2085: END IF;
2086: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2087: RAISE fnd_api.g_exc_error;
2088: END IF;
2089: END IF;
2090:

Line 2087: RAISE fnd_api.g_exc_error;

2083: x_style_format_code => l_style_format_code
2084: );
2085: END IF;
2086: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2087: RAISE fnd_api.g_exc_error;
2088: END IF;
2089: END IF;
2090:
2091:

Line 2095: RAISE fnd_api.g_exc_error;

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: --
2099: -- Make the context information available to external functions

Line 2166: RAISE fnd_api.g_exc_error;

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: --
2170: -- Copy attribute values from parameter table to layout table

Line 2208: WHEN fnd_api.g_exc_error THEN

2204:
2205:
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,

Line 2209: x_return_status := fnd_api.g_ret_sts_error;

2205:
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

Line 2211: p_encoded => fnd_api.g_false,

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

Line 2217: x_return_status := fnd_api.g_ret_sts_unexp_error;

2213: p_data => x_msg_data
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: );

Line 2224: p_encoded => fnd_api.g_false,

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

Line 2315: x_return_status := fnd_api.g_ret_sts_success;

2311: --
2312: -- Reset return status and messages
2313: --
2314:
2315: x_return_status := fnd_api.g_ret_sts_success;
2316:
2317: --
2318: -- Validate the object code
2319: --

Line 2326: RAISE fnd_api.g_exc_error;

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: --
2330: -- Determine/Default the Context Information

Line 2390: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2386: x_msg_data => x_msg_data,
2387: x_style_format_code => l_style_format_code
2388: );
2389: END IF;
2390: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2391: RAISE fnd_api.g_exc_error;
2392: END IF;
2393: END IF;
2394:

Line 2391: RAISE fnd_api.g_exc_error;

2387: x_style_format_code => l_style_format_code
2388: );
2389: END IF;
2390: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2391: RAISE fnd_api.g_exc_error;
2392: END IF;
2393: END IF;
2394:
2395:

Line 2399: RAISE fnd_api.g_exc_error;

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: --
2403: -- Make the context information available to external functions

Line 2473: RAISE fnd_api.g_exc_error;

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: --
2477: -- Create a dynamic SQL query to get the name elements

Line 2531: WHEN fnd_api.g_exc_error THEN

2527: END IF;
2528:
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,

Line 2532: x_return_status := fnd_api.g_ret_sts_error;

2528:
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

Line 2534: p_encoded => fnd_api.g_false,

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

Line 2540: x_return_status := fnd_api.g_ret_sts_unexp_error;

2536: p_data => x_msg_data
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: );

Line 2547: p_encoded => fnd_api.g_false,

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: );
2551: END format_data;

Line 2611: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2607: x_formatted_lines_cnt => l_tbl_cnt,
2608: x_formatted_address_tbl => l_tbl
2609: );
2610: -----Bug No.4145590
2611: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2612: return NULL;
2613: END IF;
2614:
2615: RETURN l_formatted_address;

Line 2699: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2695: x_formatted_lines_cnt => l_tbl_cnt,
2696: x_formatted_address_tbl => l_tbl
2697: );
2698: -----Bug No.4145590
2699: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2700: return NULL;
2701: END IF;
2702: RETURN l_formatted_address;
2703:

Line 2770: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2766: x_formatted_name_tbl => l_formatted_name_tbl
2767: );
2768:
2769: -----Bug No.4145590
2770: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2771: return NULL;
2772: END IF;
2773: RETURN l_formatted_name;
2774:

Line 2904: x_return_status := fnd_api.g_ret_sts_success;

2900: --
2901: -- Reset return status and messages
2902: --
2903:
2904: x_return_status := fnd_api.g_ret_sts_success;
2905:
2906:
2907: --
2908: -- Look for a match on both

Line 2979: x_return_status := fnd_api.g_ret_sts_error;

2975:
2976: FETCH c_def_style_format INTO l_style_format_code;
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;

Line 2992: p_encoded => fnd_api.g_false,

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

Line 3000: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 3007: p_encoded => fnd_api.g_false,

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

Line 3783: p_parm_value <> fnd_api.g_miss_char

3779: ) IS
3780:
3781: BEGIN
3782: IF p_parm_value IS NOT NULL AND
3783: p_parm_value <> fnd_api.g_miss_char
3784: THEN
3785: x_loaded_rows_cnt := x_loaded_rows_cnt + 1;
3786: x_parm_tbl(x_loaded_rows_cnt).parm_name := p_parm_name;
3787: x_parm_tbl(x_loaded_rows_cnt).parm_value := p_parm_value;