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_MESSAGE

Line 419: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');

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
423: hz_utility_v2pub.debug(p_message=>'Location record not found',

Line 420: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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
423: hz_utility_v2pub.debug(p_message=>'Location record not found',
424: p_prefix=>'ERROR',

Line 563: fnd_message.set_name('AR', 'HZ_ZIP_OR_CITY_AND_STATE');

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
567: hz_utility_v2pub.debug(p_message=>'City, state and postal code are null : Error',

Line 564: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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
567: hz_utility_v2pub.debug(p_message=>'City, state and postal code are null : Error',
568: p_prefix=>'ERROR',

Line 598: fnd_message.set_name('AR', 'HZ_ADDRESS_LINE_MANDATORY');

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
602: hz_utility_v2pub.debug(p_message=>'Address is not null : Error ',

Line 599: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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
602: hz_utility_v2pub.debug(p_message=>'Address is not null : Error ',
603: p_prefix=>'ERROR',

Line 631: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');

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

Line 632: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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

Line 633: fnd_message.set_token('COUNTRY', l_country);

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;
635: END IF;
636:
637: us_form_str := us_form_str || '/>';

Line 769: fnd_message.set_name('AR', 'HZ_SPATIAL_INVALID_COUNTRY');

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;
773: -- raise the error immediately and forget about processing the rest.

Line 770: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));

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;
773: -- raise the error immediately and forget about processing the rest.
774: RAISE notcorrectaddress;

Line 771: fnd_message.set_token('COUNTRY', l_country);

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;
773: -- raise the error immediately and forget about processing the rest.
774: RAISE notcorrectaddress;
775: END IF;

Line 1034: fnd_message.set_name('AR', 'HZ_NUMBER_MANDATORY');

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));
1038: fnd_msg_pub.add;

Line 1035: fnd_message.set_token('VALUE',Elt_value);

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));
1038: fnd_msg_pub.add;
1039: END non_num_handle;

Line 1036: fnd_message.set_token('ELT',Elt_name);

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));
1038: fnd_msg_pub.add;
1039: END non_num_handle;
1040:

Line 1037: fnd_message.set_token('LOC_ID',TO_CHAR(p_location_id));

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));
1038: fnd_msg_pub.add;
1039: END non_num_handle;
1040:
1041: --

Line 1113: fnd_message.set_name('AR', 'HZ_MISSING_GEOCODE_ID');

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
1117: hz_utility_v2pub.debug(p_message=>'No Geocode Id Found : Error',

Line 1151: fnd_message.set_name('AR', 'HZ_MISSING_LATITUDE');

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.
1150: IF l_match_count_temp <> '0' THEN
1151: fnd_message.set_name('AR', 'HZ_MISSING_LATITUDE');
1152: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1153: fnd_msg_pub.add;
1154: -- Debug info.
1155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1152: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));

1148: -- returned. if a row was not returned, the error gets reported in a
1149: -- more meaningful way later on.
1150: IF l_match_count_temp <> '0' THEN
1151: fnd_message.set_name('AR', 'HZ_MISSING_LATITUDE');
1152: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1153: fnd_msg_pub.add;
1154: -- Debug info.
1155: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'Latitude not found',

Line 1190: fnd_message.set_name('AR', 'HZ_MISSING_LONGITUDE');

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.
1189: IF l_match_count_temp <> '0' THEN
1190: fnd_message.set_name('AR', 'HZ_MISSING_LONGITUDE');
1191: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1192: fnd_msg_pub.add;
1193: -- Debug info.
1194: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1191: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));

1187: -- returned. if a row was not returned, the error gets reported in a
1188: -- more meaningful way later on.
1189: IF l_match_count_temp <> '0' THEN
1190: fnd_message.set_name('AR', 'HZ_MISSING_LONGITUDE');
1191: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1192: fnd_msg_pub.add;
1193: -- Debug info.
1194: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1195: hz_utility_v2pub.debug(p_message=>'Longitude not found',

Line 1231: fnd_message.set_name('AR','HZ_MISSING_STREET');

1227: -- spatial data provider. The message should only occur if the street is
1228: -- not found, but the latitude and longitude were found.
1229: IF l_street IS NULL AND l_lat_found AND l_long_found THEN
1230: l_return_status := g_warning;
1231: fnd_message.set_name('AR','HZ_MISSING_STREET');
1232: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1233: fnd_msg_pub.add;
1234: status_handler(l_return_status, x_return_status);
1235:

Line 1232: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));

1228: -- not found, but the latitude and longitude were found.
1229: IF l_street IS NULL AND l_lat_found AND l_long_found THEN
1230: l_return_status := g_warning;
1231: fnd_message.set_name('AR','HZ_MISSING_STREET');
1232: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1233: fnd_msg_pub.add;
1234: status_handler(l_return_status, x_return_status);
1235:
1236: -- J. del Callar: set the status reported in

Line 1263: fnd_message.set_name('AR','HZ_NB_MATCHES');

1259: l_match_count := TO_NUMBER(l_match_count_temp);
1260:
1261: IF l_match_count > 1 THEN
1262: l_return_status := g_warning;
1263: fnd_message.set_name('AR','HZ_NB_MATCHES');
1264: fnd_message.set_token('NB', l_match_count_temp);
1265: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1266: fnd_msg_pub.add;
1267:

Line 1264: fnd_message.set_token('NB', l_match_count_temp);

1260:
1261: IF l_match_count > 1 THEN
1262: l_return_status := g_warning;
1263: fnd_message.set_name('AR','HZ_NB_MATCHES');
1264: fnd_message.set_token('NB', l_match_count_temp);
1265: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1266: fnd_msg_pub.add;
1267:
1268: -- J. del Callar: set the status reported in

Line 1265: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));

1261: IF l_match_count > 1 THEN
1262: l_return_status := g_warning;
1263: fnd_message.set_name('AR','HZ_NB_MATCHES');
1264: fnd_message.set_token('NB', l_match_count_temp);
1265: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1266: fnd_msg_pub.add;
1267:
1268: -- J. del Callar: set the status reported in
1269: -- HZ_LOCATIONS.GEOMETRY_STATUS_CODE to MULTIMATCH to reflect that

Line 1279: fnd_message.set_name('AR','HZ_NB_MATCHES');

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

Line 1280: fnd_message.set_token('NB', l_match_count_temp);

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;
1283:
1284: -- J. del Callar: no rows were returned by location service

Line 1281: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));

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;
1283:
1284: -- J. del Callar: no rows were returned by location service
1285: -- mark this as an error.

Line 1752: fnd_message.set_name('AR','HZ_HTTP_POST_FAILED');

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

Line 1753: fnd_message.set_token('RETRY', p_retry);

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;
1756:
1757: -- Set the error status for all records in this batch

Line 1754: fnd_message.set_token('LASTMSG', NVL(l_err_resp, ''));

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;
1756:
1757: -- Set the error status for all records in this batch
1758: FOR i IN 1..p_loc_array.COUNT LOOP

Line 1770: fnd_message.set_name('AR','HZ_MALFORMED_SPATIAL_RESPONSE');

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));
1774: fnd_msg_pub.add;

Line 1773: fnd_message.set_token('RESP', substrb(lresp,1,200));

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));
1774: fnd_msg_pub.add;
1775:
1776: -- Set the error status for all records in this batch
1777: FOR i IN 1..p_loc_array.COUNT LOOP