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_GEOCODE_PKG dependencies on FND_API

Line 98: IF x_return_status = fnd_api.g_ret_sts_error THEN

94: l_return_status IN VARCHAR2,
95: x_return_status IN OUT NOCOPY VARCHAR2
96: ) IS
97: BEGIN
98: IF x_return_status = fnd_api.g_ret_sts_error THEN
99: NULL;
100: ELSIF x_return_status = g_warning
101: AND l_return_status = fnd_api.g_ret_sts_success
102: THEN

Line 101: AND l_return_status = fnd_api.g_ret_sts_success

97: BEGIN
98: IF x_return_status = fnd_api.g_ret_sts_error THEN
99: NULL;
100: ELSIF x_return_status = g_warning
101: AND l_return_status = fnd_api.g_ret_sts_success
102: THEN
103: NULL;
104: ELSE
105: x_return_status := l_return_status;

Line 372: -- be FND_API.G_RET_STS_SUCCESS (success),

368: -- IN/OUT:
369: -- p_loc_array
370: -- OUT:
371: -- x_return_status Return status after the call. The status can
372: -- be FND_API.G_RET_STS_SUCCESS (success),
373: -- FND_API.G_RET_STS_ERROR (error),
374: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
375: -- x_msg_count Number of messages in message stack.
376: -- x_msg_data Message text if x_msg_count is 1.

Line 373: -- FND_API.G_RET_STS_ERROR (error),

369: -- p_loc_array
370: -- OUT:
371: -- x_return_status Return status after the call. The status can
372: -- be FND_API.G_RET_STS_SUCCESS (success),
373: -- FND_API.G_RET_STS_ERROR (error),
374: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
375: -- x_msg_count Number of messages in message stack.
376: -- x_msg_data Message text if x_msg_count is 1.
377: --

Line 374: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

370: -- OUT:
371: -- x_return_status Return status after the call. The status can
372: -- be FND_API.G_RET_STS_SUCCESS (success),
373: -- FND_API.G_RET_STS_ERROR (error),
374: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
375: -- x_msg_count Number of messages in message stack.
376: -- x_msg_data Message text if x_msg_count is 1.
377: --
378: -- NOTES

Line 418: x_return_status := fnd_api.g_ret_sts_error;

414: END IF;
415: END LOOP;
416:
417: -- No matching ID was found in the array: report on this.
418: x_return_status := fnd_api.g_ret_sts_error;
419: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
420: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
421: fnd_msg_pub.add;
422: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 508: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

504: p_city VARCHAR2,
505: p_postal_code VARCHAR2,
506: p_state VARCHAR2,
507: p_name VARCHAR2 DEFAULT NULL,
508: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
509: x_return_status IN OUT NOCOPY VARCHAR2,
510: x_msg_count IN OUT NOCOPY NUMBER,
511: x_msg_data IN OUT NOCOPY VARCHAR2
512: ) RETURN VARCHAR2 IS

Line 528: l_return_status := fnd_api.g_ret_sts_success;

524: notcorrectaddress EXCEPTION;
525: l_return_status VARCHAR2(10);
526: l_debug_prefix VARCHAR2(30) := '';
527: BEGIN
528: l_return_status := fnd_api.g_ret_sts_success;
529: l_country := xmlize_line(p_country);
530: l_city := xmlize_line(p_city);
531: l_postal_code := xmlize_line(p_postal_code);
532: l_state := xmlize_line(p_state);

Line 562: l_return_status := fnd_api.g_ret_sts_error;

558: p_prefix =>l_debug_prefix,
559: p_msg_level=>fnd_log.level_statement);
560: END IF;
561: ELSE
562: l_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name('AR', 'HZ_ZIP_OR_CITY_AND_STATE');
564: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
565: fnd_msg_pub.add;
566: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 597: l_return_status := fnd_api.g_ret_sts_error;

593: p_prefix =>l_debug_prefix,
594: p_msg_level=>fnd_log.level_statement);
595: END IF;
596: ELSE
597: l_return_status := fnd_api.g_ret_sts_error;
598: fnd_message.set_name('AR', 'HZ_ADDRESS_LINE_MANDATORY');
599: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
600: fnd_msg_pub.add;
601: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 630: l_return_status := fnd_api.g_ret_sts_error;

626: hz_utility_v2pub.debug(p_message=>'Country must be null or US : Error',
627: p_prefix=>'ERROR',
628: p_msg_level=>fnd_log.level_error);
629: END IF;
630: l_return_status := fnd_api.g_ret_sts_error;
631: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');
632: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
633: fnd_message.set_token('COUNTRY', l_country);
634: fnd_msg_pub.add;

Line 638: IF l_return_status <> fnd_api.g_ret_sts_success THEN

634: fnd_msg_pub.add;
635: END IF;
636:
637: us_form_str := us_form_str || '/>';
638: IF l_return_status <> fnd_api.g_ret_sts_success THEN
639: RAISE notcorrectaddress;
640: END IF;
641:
642: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 649: p_encoded => fnd_api.g_false,

645: p_msg_level=>fnd_log.level_procedure);
646: END IF;
647:
648: fnd_msg_pub.count_and_get(
649: p_encoded => fnd_api.g_false,
650: p_count => x_msg_count,
651: p_data => x_msg_data );
652:
653: RETURN us_form_str;

Line 659: p_encoded => fnd_api.g_false,

655: WHEN notcorrectaddress THEN
656: us_form_str := NULL;
657: status_handler(l_return_status, x_return_status);
658: fnd_msg_pub.count_and_get(
659: p_encoded => fnd_api.g_false,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );
663: RETURN us_form_str;

Line 703: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

699: p_county VARCHAR2,
700: p_state VARCHAR2,
701: p_province VARCHAR2,
702: p_name VARCHAR2 DEFAULT NULL,
703: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
704: x_return_status IN OUT NOCOPY VARCHAR2,
705: x_msg_count IN OUT NOCOPY NUMBER,
706: x_msg_data IN OUT NOCOPY VARCHAR2
707: ) RETURN VARCHAR2 IS

Line 728: l_return_status := fnd_api.g_ret_sts_success;

724: l_formatted_address_tbl hz_format_pub.string_tbl_type;
725: l_debug_prefix VARCHAR2(30) := '';
726: notcorrectaddress EXCEPTION;
727: BEGIN
728: l_return_status := fnd_api.g_ret_sts_success;
729: -- Fix perf bug 3669930, 4220460, remove xmlize_line function call for
730: -- some parameter. For others, check if the value is not null, then
731: -- do xmlize_line
732: l_country := p_country;

Line 768: l_return_status := fnd_api.g_ret_sts_error;

764: hz_utility_v2pub.debug(p_message=>'Country invalid',
765: p_prefix=>'ERROR',
766: p_msg_level=>fnd_log.level_error);
767: END IF;
768: l_return_status := fnd_api.g_ret_sts_error;
769: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');
770: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
771: fnd_message.set_token('COUNTRY', l_country);
772: fnd_msg_pub.add;

Line 826: IF l_return_status <> fnd_api.g_ret_sts_success THEN

822: );
823:
824: l_xml_address := l_xml_address || l_formatted_address
825: || '"/> ';
826: IF l_return_status <> fnd_api.g_ret_sts_success THEN
827: RAISE notcorrectaddress;
828: END IF;
829:
830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 838: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

834: p_prefix=>l_debug_prefix,
835: p_msg_level=>fnd_log.level_procedure);
836: END IF;
837:
838: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
839: p_count => x_msg_count,
840: p_data => x_msg_data);
841:
842: RETURN l_xml_address;

Line 848: p_encoded => fnd_api.g_false,

844: WHEN notcorrectaddress THEN
845: l_xml_address := NULL;
846: status_handler(l_return_status, x_return_status);
847: fnd_msg_pub.count_and_get(
848: p_encoded => fnd_api.g_false,
849: p_count => x_msg_count,
850: p_data => x_msg_data
851: );
852: RETURN l_xml_address;

Line 889: l_return_status := fnd_api.g_ret_sts_success;

885: xml_request := 'xml_request=' ||
886: '' ||
887: ''||FND_GLOBAL.local_chr(10);
888: FOR i IN 1..l_count LOOP
889: l_return_status := fnd_api.g_ret_sts_success;
890: l_loc_rec := p_loc_array(i);
891: l_form_us :=
892: compose_elocation_detail (
893: p_location_id => l_loc_rec.location_id,

Line 905: p_init_msg_list => fnd_api.g_true,

901: p_county => l_loc_rec.county,
902: p_state => l_loc_rec.state,
903: p_province => l_loc_rec.province,
904: p_name => p_name,
905: p_init_msg_list => fnd_api.g_true,
906: x_return_status => l_return_status,
907: x_msg_count => x_msg_count,
908: x_msg_data => x_msg_data
909: );

Line 912: IF l_return_status <> fnd_api.g_ret_sts_success THEN

908: x_msg_data => x_msg_data
909: );
910:
911: -- J. del Callar: set the error status of any offending records.
912: IF l_return_status <> fnd_api.g_ret_sts_success THEN
913: status_handler(l_return_status, x_return_status);
914: p_loc_array(i).geometry_status_code := g_error;
915: END IF;
916:

Line 944: p_encoded => fnd_api.g_false,

940: p_prefix=>l_debug_prefix,
941: p_msg_level=>fnd_log.level_procedure);
942: END IF;
943: fnd_msg_pub.count_and_get(
944: p_encoded => fnd_api.g_false,
945: p_count => x_msg_count,
946: p_data => x_msg_data );
947:
948: RETURN xml_request;

Line 1033: x_return_status := fnd_api.g_ret_sts_error;

1029: x_msg_count IN OUT NOCOPY NUMBER,
1030: x_msg_data IN OUT NOCOPY VARCHAR2)
1031: IS
1032: BEGIN
1033: x_return_status := fnd_api.g_ret_sts_error;
1034: fnd_message.set_name('AR', 'HZ_NUMBER_MANDATORY');
1035: fnd_message.set_token('VALUE',Elt_value);
1036: fnd_message.set_token('ELT',Elt_name);
1037: fnd_message.set_token('LOC_ID',TO_CHAR(p_location_id));

Line 1061: -- be FND_API.G_RET_STS_SUCCESS (success),

1057: -- x_loc_id
1058: -- x_geo
1059: -- x_geo_status
1060: -- x_return_status Return status after the call. The status can
1061: -- be FND_API.G_RET_STS_SUCCESS (success),
1062: -- FND_API.G_RET_STS_ERROR (error),
1063: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1064: -- x_msg_count Number of messages in message stack.
1065: -- x_msg_data Message text if x_msg_count is 1.

Line 1062: -- FND_API.G_RET_STS_ERROR (error),

1058: -- x_geo
1059: -- x_geo_status
1060: -- x_return_status Return status after the call. The status can
1061: -- be FND_API.G_RET_STS_SUCCESS (success),
1062: -- FND_API.G_RET_STS_ERROR (error),
1063: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1064: -- x_msg_count Number of messages in message stack.
1065: -- x_msg_data Message text if x_msg_count is 1.
1066: --

Line 1063: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1059: -- x_geo_status
1060: -- x_return_status Return status after the call. The status can
1061: -- be FND_API.G_RET_STS_SUCCESS (success),
1062: -- FND_API.G_RET_STS_ERROR (error),
1063: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1064: -- x_msg_count Number of messages in message stack.
1065: -- x_msg_data Message text if x_msg_count is 1.
1066: --
1067: -- NOTES

Line 1098: l_return_status := fnd_api.g_ret_sts_success;

1094: l_return_status VARCHAR2(10);
1095: BEGIN
1096: -- Procedure pour tester la possibilite de transformer l_recep en nombre qui soit controle
1097: -- Afin de capturer les erreurs evebntuellement de Alfa num.
1098: l_return_status := fnd_api.g_ret_sts_success;
1099:
1100: -- J. del Callar: set the geo status to success
1101: x_geo_status := g_good;
1102:

Line 1112: l_return_status := fnd_api.g_ret_sts_error;

1108: END IF;
1109:
1110: l_recep := elt_value(p_str, 'GEOCODE ID');
1111: IF l_recep IS NULL THEN
1112: l_return_status := fnd_api.g_ret_sts_error;
1113: fnd_message.set_name('AR', 'HZ_MISSING_GEOCODE_ID');
1114: fnd_msg_pub.add;
1115: status_handler(l_return_status, x_return_status);
1116: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1145: l_return_status := fnd_api.g_ret_sts_error;

1141: l_match_count_temp := elt_value(p_str, 'MATCH_COUNT');
1142:
1143: l_recep := elt_value(p_str, 'LATITUDE');
1144: IF l_recep IS NULL THEN
1145: l_return_status := fnd_api.g_ret_sts_error;
1146:
1147: -- J. del Callar: report this error to the user only if a row was
1148: -- returned. if a row was not returned, the error gets reported in a
1149: -- more meaningful way later on.

Line 1184: l_return_status := fnd_api.g_ret_sts_error;

1180: END IF;
1181:
1182: l_recep := elt_value( p_str, 'LONGITUDE');
1183: IF l_recep IS NULL THEN
1184: l_return_status := fnd_api.g_ret_sts_error;
1185:
1186: -- J. del Callar: report this error to the user only if a row was
1187: -- returned. if a row was not returned, the error gets reported in a
1188: -- more meaningful way later on.

Line 1278: l_return_status := fnd_api.g_ret_sts_error;

1274: p_prefix=>'WARNING',
1275: p_msg_level=>fnd_log.level_exception);
1276: END IF;
1277: ELSIF l_match_count = 0 THEN
1278: l_return_status := fnd_api.g_ret_sts_error;
1279: fnd_message.set_name('AR','HZ_NB_MATCHES');
1280: fnd_message.set_token('NB', l_match_count_temp);
1281: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1282: fnd_msg_pub.add;

Line 1305: IF l_return_status <> fnd_api.g_ret_sts_error THEN

1301: l_return_status, x_msg_count, x_msg_data);
1302: status_handler(l_return_status, x_return_status);
1303: END;
1304:
1305: IF l_return_status <> fnd_api.g_ret_sts_error THEN
1306: x_geo := gen_geo(p_sdo_gtype => 2001,
1307: p_sdo_srid => 8307,
1308: p_xlo => l_longitude,
1309: p_yla => l_latitude);

Line 1318: p_encoded => fnd_api.g_false,

1314: status_handler(l_return_status, x_return_status);
1315: END IF;
1316:
1317: fnd_msg_pub.count_and_get(
1318: p_encoded => fnd_api.g_false,
1319: p_count => x_msg_count,
1320: p_data => x_msg_data
1321: );
1322:

Line 1352: -- be FND_API.G_RET_STS_SUCCESS (success),

1348: -- x_loc_id
1349: -- x_geo
1350: -- x_geo_status
1351: -- x_return_status Return status after the call. The status can
1352: -- be FND_API.G_RET_STS_SUCCESS (success),
1353: -- FND_API.G_RET_STS_ERROR (error),
1354: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1355: -- x_msg_count Number of messages in message stack.
1356: -- x_msg_data Message text if x_msg_count is 1.

Line 1353: -- FND_API.G_RET_STS_ERROR (error),

1349: -- x_geo
1350: -- x_geo_status
1351: -- x_return_status Return status after the call. The status can
1352: -- be FND_API.G_RET_STS_SUCCESS (success),
1353: -- FND_API.G_RET_STS_ERROR (error),
1354: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1355: -- x_msg_count Number of messages in message stack.
1356: -- x_msg_data Message text if x_msg_count is 1.
1357: --

Line 1354: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1350: -- x_geo_status
1351: -- x_return_status Return status after the call. The status can
1352: -- be FND_API.G_RET_STS_SUCCESS (success),
1353: -- FND_API.G_RET_STS_ERROR (error),
1354: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1355: -- x_msg_count Number of messages in message stack.
1356: -- x_msg_data Message text if x_msg_count is 1.
1357: --
1358: -- NOTES

Line 1390: l_return_status := fnd_api.g_ret_sts_success;

1386: hz_utility_v2pub.debug(p_message=>'parse_responses (+)',
1387: p_prefix=>l_debug_prefix,
1388: p_msg_level=>fnd_log.level_procedure);
1389: END IF;
1390: l_return_status := fnd_api.g_ret_sts_success;
1391: i := p_tab_address.COUNT;
1392: IF i > 0 THEN
1393: FOR j IN 1..i LOOP
1394: parse_one_response(

Line 1422: p_encoded => fnd_api.g_false,

1418: END IF;
1419: END LOOP;
1420: END IF;
1421: fnd_msg_pub.count_and_get(
1422: p_encoded => fnd_api.g_false,
1423: p_count => x_msg_count,
1424: p_data => x_msg_data
1425: );
1426: -- Debug info.

Line 1641: -- be FND_API.G_RET_STS_SUCCESS (success),

1637: -- IN/OUT:
1638: -- p_loc_array
1639: -- OUT:
1640: -- x_return_status Return status after the call. The status can
1641: -- be FND_API.G_RET_STS_SUCCESS (success),
1642: -- FND_API.G_RET_STS_ERROR (error),
1643: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1644: -- x_msg_count Number of messages in message stack.
1645: -- x_msg_data Message text if x_msg_count is 1.

Line 1642: -- FND_API.G_RET_STS_ERROR (error),

1638: -- p_loc_array
1639: -- OUT:
1640: -- x_return_status Return status after the call. The status can
1641: -- be FND_API.G_RET_STS_SUCCESS (success),
1642: -- FND_API.G_RET_STS_ERROR (error),
1643: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1644: -- x_msg_count Number of messages in message stack.
1645: -- x_msg_data Message text if x_msg_count is 1.
1646: --

Line 1643: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

1639: -- OUT:
1640: -- x_return_status Return status after the call. The status can
1641: -- be FND_API.G_RET_STS_SUCCESS (success),
1642: -- FND_API.G_RET_STS_ERROR (error),
1643: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1644: -- x_msg_count Number of messages in message stack.
1645: -- x_msg_data Message text if x_msg_count is 1.
1646: --
1647: -- NOTES

Line 1664: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1660: p_http_ad IN VARCHAR2,
1661: p_proxy IN VARCHAR2 DEFAULT NULL,
1662: p_port IN NUMBER DEFAULT NULL,
1663: p_retry IN NUMBER DEFAULT 3,
1664: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1665: x_return_status OUT NOCOPY VARCHAR2,
1666: x_msg_count OUT NOCOPY NUMBER,
1667: x_msg_data OUT NOCOPY VARCHAR2
1668: ) IS

Line 1688: l_return_status := fnd_api.g_ret_sts_success;

1684: p_prefix=>l_debug_prefix,
1685: p_msg_level=>fnd_log.level_procedure);
1686: END IF;
1687:
1688: l_return_status := fnd_api.g_ret_sts_success;
1689:
1690: IF fnd_api.to_boolean(p_init_msg_list) THEN
1691: fnd_msg_pub.initialize;
1692: END IF;

Line 1690: IF fnd_api.to_boolean(p_init_msg_list) THEN

1686: END IF;
1687:
1688: l_return_status := fnd_api.g_ret_sts_success;
1689:
1690: IF fnd_api.to_boolean(p_init_msg_list) THEN
1691: fnd_msg_pub.initialize;
1692: END IF;
1693:
1694: lxml := location_xml(p_loc_array => p_loc_array,

Line 1724: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1720: err_resp => l_err_resp,
1721: x_return_status => l_return_status,
1722: x_msg_count => x_msg_count,
1723: x_msg_data => x_msg_data);
1724: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1725: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1726: hz_utility_v2pub.debug(p_message=>'hz_http_pkg.post failed',
1727: p_prefix=>'UNEXPECTED ERROR',
1728: p_msg_level=>fnd_log.level_error);

Line 1751: l_return_status := fnd_api.g_ret_sts_unexp_error;

1747:
1748: IF lresp IS NULL THEN
1749: -- The post did not succeed, even after several retries. This is an
1750: -- unrecoverable error.
1751: l_return_status := fnd_api.g_ret_sts_unexp_error;
1752: fnd_message.set_name('AR','HZ_HTTP_POST_FAILED');
1753: fnd_message.set_token('RETRY', p_retry);
1754: fnd_message.set_token('LASTMSG', NVL(l_err_resp, ''));
1755: fnd_msg_pub.add;

Line 1769: l_return_status := fnd_api.g_ret_sts_unexp_error;

1765: END IF;
1766: status_handler(l_return_status, x_return_status);
1767: ELSIF UPPER(lresp) NOT LIKE '%%' THEN
1768: -- Spatial response was not parseable. This is an unrecoverable error.
1769: l_return_status := fnd_api.g_ret_sts_unexp_error;
1770: fnd_message.set_name('AR','HZ_MALFORMED_SPATIAL_RESPONSE');
1771: -- limit the size of token to 200 characters, otherwise if lresp is too
1772: -- long, will get buffer too small error
1773: fnd_message.set_token('RESP', substrb(lresp,1,200));

Line 1823: p_encoded => fnd_api.g_false,

1819: END IF;
1820: END IF;
1821: END IF;
1822: fnd_msg_pub.count_and_get(
1823: p_encoded => fnd_api.g_false,
1824: p_count => x_msg_count,
1825: p_data => x_msg_data
1826: );
1827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN