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 377: -- be FND_API.G_RET_STS_SUCCESS (success),

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

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

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

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

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

Line 426: x_return_status := fnd_api.g_ret_sts_error;

422: END IF;
423: END LOOP;
424:
425: -- No matching ID was found in the array: report on this.
426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
428: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
429: fnd_msg_pub.add;
430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 516: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

512: p_city VARCHAR2,
513: p_postal_code VARCHAR2,
514: p_state VARCHAR2,
515: p_name VARCHAR2 DEFAULT NULL,
516: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
517: x_return_status IN OUT NOCOPY VARCHAR2,
518: x_msg_count IN OUT NOCOPY NUMBER,
519: x_msg_data IN OUT NOCOPY VARCHAR2
520: ) RETURN VARCHAR2 IS

Line 536: l_return_status := fnd_api.g_ret_sts_success;

532: notcorrectaddress EXCEPTION;
533: l_return_status VARCHAR2(10);
534: l_debug_prefix VARCHAR2(30) := '';
535: BEGIN
536: l_return_status := fnd_api.g_ret_sts_success;
537: l_country := xmlize_line(p_country);
538: l_city := xmlize_line(p_city);
539: l_postal_code := xmlize_line(p_postal_code);
540: l_state := xmlize_line(p_state);

Line 570: l_return_status := fnd_api.g_ret_sts_error;

566: p_prefix =>l_debug_prefix,
567: p_msg_level=>fnd_log.level_statement);
568: END IF;
569: ELSE
570: l_return_status := fnd_api.g_ret_sts_error;
571: fnd_message.set_name('AR', 'HZ_ZIP_OR_CITY_AND_STATE');
572: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
573: fnd_msg_pub.add;
574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 605: l_return_status := fnd_api.g_ret_sts_error;

601: p_prefix =>l_debug_prefix,
602: p_msg_level=>fnd_log.level_statement);
603: END IF;
604: ELSE
605: l_return_status := fnd_api.g_ret_sts_error;
606: fnd_message.set_name('AR', 'HZ_ADDRESS_LINE_MANDATORY');
607: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
608: fnd_msg_pub.add;
609: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 638: l_return_status := fnd_api.g_ret_sts_error;

634: hz_utility_v2pub.debug(p_message=>'Country must be null or US : Error',
635: p_prefix=>'ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: l_return_status := fnd_api.g_ret_sts_error;
639: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');
640: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
641: fnd_message.set_token('COUNTRY', l_country);
642: fnd_msg_pub.add;

Line 646: IF l_return_status <> fnd_api.g_ret_sts_success THEN

642: fnd_msg_pub.add;
643: END IF;
644:
645: us_form_str := us_form_str || '/>';
646: IF l_return_status <> fnd_api.g_ret_sts_success THEN
647: RAISE notcorrectaddress;
648: END IF;
649:
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 657: p_encoded => fnd_api.g_false,

653: p_msg_level=>fnd_log.level_procedure);
654: END IF;
655:
656: fnd_msg_pub.count_and_get(
657: p_encoded => fnd_api.g_false,
658: p_count => x_msg_count,
659: p_data => x_msg_data );
660:
661: RETURN us_form_str;

Line 667: p_encoded => fnd_api.g_false,

663: WHEN notcorrectaddress THEN
664: us_form_str := NULL;
665: status_handler(l_return_status, x_return_status);
666: fnd_msg_pub.count_and_get(
667: p_encoded => fnd_api.g_false,
668: p_count => x_msg_count,
669: p_data => x_msg_data
670: );
671: RETURN us_form_str;

Line 711: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

707: p_county VARCHAR2,
708: p_state VARCHAR2,
709: p_province VARCHAR2,
710: p_name VARCHAR2 DEFAULT NULL,
711: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
712: x_return_status IN OUT NOCOPY VARCHAR2,
713: x_msg_count IN OUT NOCOPY NUMBER,
714: x_msg_data IN OUT NOCOPY VARCHAR2
715: ) RETURN VARCHAR2 IS

Line 736: l_return_status := fnd_api.g_ret_sts_success;

732: l_formatted_address_tbl hz_format_pub.string_tbl_type;
733: l_debug_prefix VARCHAR2(30) := '';
734: notcorrectaddress EXCEPTION;
735: BEGIN
736: l_return_status := fnd_api.g_ret_sts_success;
737: -- Fix perf bug 3669930, 4220460, remove xmlize_line function call for
738: -- some parameter. For others, check if the value is not null, then
739: -- do xmlize_line
740: l_country := p_country;

Line 776: l_return_status := fnd_api.g_ret_sts_error;

772: hz_utility_v2pub.debug(p_message=>'Country invalid',
773: p_prefix=>'ERROR',
774: p_msg_level=>fnd_log.level_error);
775: END IF;
776: l_return_status := fnd_api.g_ret_sts_error;
777: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');
778: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
779: fnd_message.set_token('COUNTRY', l_country);
780: fnd_msg_pub.add;

Line 848: IF l_return_status <> fnd_api.g_ret_sts_success THEN

844: l_xml_address := ' 845: ||' city="'||l_city||'" region=" '||NVL(l_state,l_province)||'" country="'||l_country
846: ||'" postal_code="'||l_postal_code||'" />';
847:
848: IF l_return_status <> fnd_api.g_ret_sts_success THEN
849: RAISE notcorrectaddress;
850: END IF;
851:
852: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

856: p_prefix=>l_debug_prefix,
857: p_msg_level=>fnd_log.level_procedure);
858: END IF;
859:
860: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
861: p_count => x_msg_count,
862: p_data => x_msg_data);
863:
864: RETURN l_xml_address;

Line 870: p_encoded => fnd_api.g_false,

866: WHEN notcorrectaddress THEN
867: l_xml_address := NULL;
868: status_handler(l_return_status, x_return_status);
869: fnd_msg_pub.count_and_get(
870: p_encoded => fnd_api.g_false,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: );
874: RETURN l_xml_address;

Line 913: l_return_status := fnd_api.g_ret_sts_success;

909: xml_request := 'xml_request=' ||
910: '' ||
911: ''||FND_GLOBAL.local_chr(10);
912: FOR i IN 1..l_count LOOP
913: l_return_status := fnd_api.g_ret_sts_success;
914: l_loc_rec := p_loc_array(i);
915: l_form_us :=
916: compose_elocation_detail (
917: p_location_id => l_loc_rec.location_id,

Line 929: p_init_msg_list => fnd_api.g_true,

925: p_county => l_loc_rec.county,
926: p_state => l_loc_rec.state,
927: p_province => l_loc_rec.province,
928: p_name => p_name,
929: p_init_msg_list => fnd_api.g_true,
930: x_return_status => l_return_status,
931: x_msg_count => x_msg_count,
932: x_msg_data => x_msg_data
933: );

Line 936: IF l_return_status <> fnd_api.g_ret_sts_success THEN

932: x_msg_data => x_msg_data
933: );
934:
935: -- J. del Callar: set the error status of any offending records.
936: IF l_return_status <> fnd_api.g_ret_sts_success THEN
937: status_handler(l_return_status, x_return_status);
938: p_loc_array(i).geometry_status_code := g_error;
939: END IF;
940:

Line 969: p_encoded => fnd_api.g_false,

965: p_prefix=>l_debug_prefix,
966: p_msg_level=>fnd_log.level_procedure);
967: END IF;
968: fnd_msg_pub.count_and_get(
969: p_encoded => fnd_api.g_false,
970: p_count => x_msg_count,
971: p_data => x_msg_data );
972:
973: RETURN xml_request;

Line 1058: x_return_status := fnd_api.g_ret_sts_error;

1054: x_msg_count IN OUT NOCOPY NUMBER,
1055: x_msg_data IN OUT NOCOPY VARCHAR2)
1056: IS
1057: BEGIN
1058: x_return_status := fnd_api.g_ret_sts_error;
1059: fnd_message.set_name('AR', 'HZ_NUMBER_MANDATORY');
1060: fnd_message.set_token('VALUE',Elt_value);
1061: fnd_message.set_token('ELT',Elt_name);
1062: fnd_message.set_token('LOC_ID',TO_CHAR(p_location_id));

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

1082: -- x_loc_id
1083: -- x_geo
1084: -- x_geo_status
1085: -- x_return_status Return status after the call. The status can
1086: -- be FND_API.G_RET_STS_SUCCESS (success),
1087: -- FND_API.G_RET_STS_ERROR (error),
1088: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1089: -- x_msg_count Number of messages in message stack.
1090: -- x_msg_data Message text if x_msg_count is 1.

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

1083: -- x_geo
1084: -- x_geo_status
1085: -- x_return_status Return status after the call. The status can
1086: -- be FND_API.G_RET_STS_SUCCESS (success),
1087: -- FND_API.G_RET_STS_ERROR (error),
1088: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1089: -- x_msg_count Number of messages in message stack.
1090: -- x_msg_data Message text if x_msg_count is 1.
1091: --

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

1084: -- x_geo_status
1085: -- x_return_status Return status after the call. The status can
1086: -- be FND_API.G_RET_STS_SUCCESS (success),
1087: -- FND_API.G_RET_STS_ERROR (error),
1088: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1089: -- x_msg_count Number of messages in message stack.
1090: -- x_msg_data Message text if x_msg_count is 1.
1091: --
1092: -- NOTES

Line 1126: l_return_status := fnd_api.g_ret_sts_success;

1122: l_return_status VARCHAR2(10);
1123: BEGIN
1124: -- Procedure pour tester la possibilite de transformer l_recep en nombre qui soit controle
1125: -- Afin de capturer les erreurs evebntuellement de Alfa num.
1126: l_return_status := fnd_api.g_ret_sts_success;
1127:
1128: -- J. del Callar: set the geo status to success
1129: x_geo_status := g_good;
1130:

Line 1140: l_return_status := fnd_api.g_ret_sts_error;

1136: END IF;
1137:
1138: l_recep := elt_value(p_str, 'GEOCODE ID');
1139: IF l_recep IS NULL THEN
1140: l_return_status := fnd_api.g_ret_sts_error;
1141: fnd_message.set_name('AR', 'HZ_MISSING_GEOCODE_ID');
1142: fnd_msg_pub.add;
1143: status_handler(l_return_status, x_return_status);
1144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1169: /* l_return_status := fnd_api.g_ret_sts_error;

1165: l_match_count_temp := elt_value(p_str, 'MATCH_COUNT');
1166:
1167: l_recep := elt_value(p_str, 'LATITUDE');
1168: IF l_recep IS NULL THEN
1169: /* l_return_status := fnd_api.g_ret_sts_error;
1170:
1171: -- J. del Callar: report this error to the user only if a row was
1172: -- returned. if a row was not returned, the error gets reported in a
1173: -- more meaningful way later on.

Line 1205: /*l_return_status := fnd_api.g_ret_sts_error;

1201: END IF;
1202:
1203: l_recep := elt_value( p_str, 'LONGITUDE');
1204: IF l_recep IS NULL THEN
1205: /*l_return_status := fnd_api.g_ret_sts_error;
1206:
1207: -- J. del Callar: report this error to the user only if a row was
1208: -- returned. if a row was not returned, the error gets reported in a
1209: -- more meaningful way later on.

Line 1321: /* l_return_status := fnd_api.g_ret_sts_error;

1317: p_prefix=>'WARNING',
1318: p_msg_level=>fnd_log.level_exception);
1319: END IF;
1320: ELSIF l_match_count = 0 THEN
1321: /* l_return_status := fnd_api.g_ret_sts_error;
1322: fnd_message.set_name('AR','HZ_NB_MATCHES');
1323: fnd_message.set_token('NB', l_match_count_temp);
1324: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1325: fnd_msg_pub.add;

Line 1350: IF l_return_status <> fnd_api.g_ret_sts_error THEN

1346: l_return_status, x_msg_count, x_msg_data);
1347: status_handler(l_return_status, x_return_status);
1348: END;
1349:
1350: IF l_return_status <> fnd_api.g_ret_sts_error THEN
1351: x_geo := gen_geo(p_sdo_gtype => 2001,
1352: p_sdo_srid => 8307,
1353: p_xlo => l_longitude,
1354: p_yla => l_latitude);

Line 1363: p_encoded => fnd_api.g_false,

1359: status_handler(l_return_status, x_return_status);
1360: END IF;
1361:
1362: fnd_msg_pub.count_and_get(
1363: p_encoded => fnd_api.g_false,
1364: p_count => x_msg_count,
1365: p_data => x_msg_data
1366: );
1367:

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

1393: -- x_loc_id
1394: -- x_geo
1395: -- x_geo_status
1396: -- x_return_status Return status after the call. The status can
1397: -- be FND_API.G_RET_STS_SUCCESS (success),
1398: -- FND_API.G_RET_STS_ERROR (error),
1399: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1400: -- x_msg_count Number of messages in message stack.
1401: -- x_msg_data Message text if x_msg_count is 1.

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

1394: -- x_geo
1395: -- x_geo_status
1396: -- x_return_status Return status after the call. The status can
1397: -- be FND_API.G_RET_STS_SUCCESS (success),
1398: -- FND_API.G_RET_STS_ERROR (error),
1399: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1400: -- x_msg_count Number of messages in message stack.
1401: -- x_msg_data Message text if x_msg_count is 1.
1402: --

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

1395: -- x_geo_status
1396: -- x_return_status Return status after the call. The status can
1397: -- be FND_API.G_RET_STS_SUCCESS (success),
1398: -- FND_API.G_RET_STS_ERROR (error),
1399: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1400: -- x_msg_count Number of messages in message stack.
1401: -- x_msg_data Message text if x_msg_count is 1.
1402: --
1403: -- NOTES

Line 1438: l_return_status := fnd_api.g_ret_sts_success;

1434: hz_utility_v2pub.debug(p_message=>'parse_responses (+)',
1435: p_prefix=>l_debug_prefix,
1436: p_msg_level=>fnd_log.level_procedure);
1437: END IF;
1438: l_return_status := fnd_api.g_ret_sts_success;
1439: i := p_tab_address.COUNT;
1440: IF i > 0 THEN
1441: FOR j IN 1..i LOOP
1442: parse_one_response(

Line 1472: p_encoded => fnd_api.g_false,

1468: END IF;
1469: END LOOP;
1470: END IF;
1471: fnd_msg_pub.count_and_get(
1472: p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data
1475: );
1476: -- Debug info.

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

1687: -- IN/OUT:
1688: -- p_loc_array
1689: -- OUT:
1690: -- x_return_status Return status after the call. The status can
1691: -- be FND_API.G_RET_STS_SUCCESS (success),
1692: -- FND_API.G_RET_STS_ERROR (error),
1693: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1694: -- x_msg_count Number of messages in message stack.
1695: -- x_msg_data Message text if x_msg_count is 1.

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

1688: -- p_loc_array
1689: -- OUT:
1690: -- x_return_status Return status after the call. The status can
1691: -- be FND_API.G_RET_STS_SUCCESS (success),
1692: -- FND_API.G_RET_STS_ERROR (error),
1693: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1694: -- x_msg_count Number of messages in message stack.
1695: -- x_msg_data Message text if x_msg_count is 1.
1696: --

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

1689: -- OUT:
1690: -- x_return_status Return status after the call. The status can
1691: -- be FND_API.G_RET_STS_SUCCESS (success),
1692: -- FND_API.G_RET_STS_ERROR (error),
1693: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1694: -- x_msg_count Number of messages in message stack.
1695: -- x_msg_data Message text if x_msg_count is 1.
1696: --
1697: -- NOTES

Line 1714: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1710: p_http_ad IN VARCHAR2,
1711: p_proxy IN VARCHAR2 DEFAULT NULL,
1712: p_port IN NUMBER DEFAULT NULL,
1713: p_retry IN NUMBER DEFAULT 3,
1714: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1715: x_return_status OUT NOCOPY VARCHAR2,
1716: x_msg_count OUT NOCOPY NUMBER,
1717: x_msg_data OUT NOCOPY VARCHAR2
1718: ) IS

Line 1745: l_return_status := fnd_api.g_ret_sts_success;

1741: p_module_prefix => 'HZ_GEOCODE_PKG',
1742: p_module =>'HZ');
1743: END IF;
1744:
1745: l_return_status := fnd_api.g_ret_sts_success;
1746:
1747: IF fnd_api.to_boolean(p_init_msg_list) THEN
1748: fnd_msg_pub.initialize;
1749: END IF;

Line 1747: IF fnd_api.to_boolean(p_init_msg_list) THEN

1743: END IF;
1744:
1745: l_return_status := fnd_api.g_ret_sts_success;
1746:
1747: IF fnd_api.to_boolean(p_init_msg_list) THEN
1748: fnd_msg_pub.initialize;
1749: END IF;
1750:
1751: lxml := location_xml(p_loc_array => p_loc_array,

Line 1790: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1786: err_resp => l_err_resp,
1787: x_return_status => l_return_status,
1788: x_msg_count => x_msg_count,
1789: x_msg_data => x_msg_data);
1790: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1792: hz_utility_v2pub.DEBUG
1793: (p_message=>'hz_http_pkg.post failed - UNEXPECTED ERROR',
1794: p_prefix=>l_debug_prefix,

Line 1807: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

1803: p_module =>'HZ');
1804: END IF;
1805: RAISE exchttp;
1806: END IF;
1807: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
1808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1809: hz_utility_v2pub.DEBUG
1810: (p_message=>'hz_http_pkg.post failed - EXPECTED ERROR',
1811: p_prefix=>l_debug_prefix,

Line 1824: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN

1820: p_module =>'HZ');
1821: END IF;
1822: RAISE exchttp;
1823: END IF;
1824: IF l_return_status = fnd_api.G_RET_STS_SUCCESS THEN
1825: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1826: hz_utility_v2pub.DEBUG
1827: (p_message=>'hz_http_pkg.post SUCCESS',
1828: p_prefix=>l_debug_prefix,

Line 1869: l_return_status := fnd_api.g_ret_sts_unexp_error;

1865: p_module =>'HZ');
1866: END IF;
1867: -- The post did not succeed, even after several retries. This is an
1868: -- unrecoverable error.
1869: l_return_status := fnd_api.g_ret_sts_unexp_error;
1870: fnd_message.set_name('AR','HZ_HTTP_POST_FAILED');
1871: fnd_message.set_token('RETRY', p_retry);
1872: -- limit the size of token to 200 characters, otherwise if lresp is too
1873: -- long, will get buffer too small error

Line 1918: -- l_return_status := fnd_api.g_ret_sts_unexp_error;

1914: p_module_prefix => 'HZ_GEOCODE_PKG',
1915: p_module =>'HZ');
1916: END IF;
1917: -- Spatial response was not parseable. This is an unrecoverable error.
1918: -- l_return_status := fnd_api.g_ret_sts_unexp_error;
1919: -- fnd_message.set_name('AR','HZ_MALFORMED_SPATIAL_RESPONSE');
1920: -- if the response is some special char that must be handled.
1921: BEGIN
1922: IF (LENGTH(lresp) >2) THEN

Line 2028: p_encoded => fnd_api.g_false,

2024: END IF; -- end of no of rows from get_response_lines() check
2025: END IF;-- end of lresp check
2026: END IF;-- end of lxml check
2027: fnd_msg_pub.count_and_get(
2028: p_encoded => fnd_api.g_false,
2029: p_count => x_msg_count,
2030: p_data => x_msg_data
2031: );
2032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN