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.

[Home] [Help]

APPS.HZ_GEOCODE_PKG dependencies on FND_MSG_PUB

Line 429: fnd_msg_pub.add;

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
431: hz_utility_v2pub.debug(p_message=>'Location record not found',
432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);

Line 573: fnd_msg_pub.add;

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
575: hz_utility_v2pub.debug(p_message=>'City, state and postal code are null : Error',
576: p_prefix=>'ERROR',
577: p_msg_level=>fnd_log.level_error);

Line 608: fnd_msg_pub.add;

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
610: hz_utility_v2pub.debug(p_message=>'Address is not null : Error ',
611: p_prefix=>'ERROR',
612: p_msg_level=>fnd_log.level_error);

Line 642: fnd_msg_pub.add;

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;
643: END IF;
644:
645: us_form_str := us_form_str || '/>';
646: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 656: fnd_msg_pub.count_and_get(

652: p_prefix=>l_debug_prefix,
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:

Line 666: fnd_msg_pub.count_and_get(

662: EXCEPTION
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: );

Line 780: fnd_msg_pub.add;

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;
781: -- raise the error immediately and forget about processing the rest.
782: RAISE notcorrectaddress;
783: END IF;
784:

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 869: fnd_msg_pub.count_and_get(

865: EXCEPTION
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: );

Line 968: fnd_msg_pub.count_and_get(

964: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.location_xml (-)',
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:

Line 1063: fnd_msg_pub.add;

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));
1063: fnd_msg_pub.add;
1064: END non_num_handle;
1065:
1066: --
1067: -- PROCEDURE parse_one_response

Line 1142: fnd_msg_pub.add;

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

Line 1177: fnd_msg_pub.add;

1173: -- more meaningful way later on.
1174: IF l_match_count_temp <> '0' THEN
1175: fnd_message.set_name('AR', 'HZ_MISSING_LATITUDE');
1176: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1177: fnd_msg_pub.add;
1178: -- Debug info.
1179: END IF;
1180: status_handler(l_return_status, x_return_status);
1181: */ IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1213: fnd_msg_pub.add;

1209: -- more meaningful way later on.
1210: IF l_match_count_temp <> '0' THEN
1211: fnd_message.set_name('AR', 'HZ_MISSING_LONGITUDE');
1212: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1213: fnd_msg_pub.add;
1214:
1215: END IF;
1216: status_handler(l_return_status, x_return_status);
1217: */

Line 1273: fnd_msg_pub.add;

1269: IF l_street IS NULL AND l_lat_found AND l_long_found THEN
1270: /*--l_return_status := g_warning;
1271: fnd_message.set_name('AR','HZ_MISSING_STREET');
1272: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1273: fnd_msg_pub.add;
1274: status_handler(l_return_status, x_return_status);
1275:
1276: -- J. del Callar: set the status reported in
1277: -- HZ_LOCATIONS.GEOMETRY_STATUS_CODE to NOEXACTMATCH to reflect the fact

Line 1307: fnd_msg_pub.add;

1303: /*--l_return_status := g_warning;
1304: fnd_message.set_name('AR','HZ_NB_MATCHES');
1305: fnd_message.set_token('NB', l_match_count_temp);
1306: fnd_message.set_token('LOC_ID', TO_CHAR(x_loc_id));
1307: fnd_msg_pub.add;
1308:
1309: -- J. del Callar: set the status reported in
1310: -- HZ_LOCATIONS.GEOMETRY_STATUS_CODE to MULTIMATCH to reflect that
1311: -- multiple matches were returned.

Line 1325: fnd_msg_pub.add;

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;
1326:
1327: -- J. del Callar: no rows were returned by location service
1328: -- mark this as an error.
1329: */

Line 1362: fnd_msg_pub.count_and_get(

1358: x_geo := NULL;
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: );

Line 1471: fnd_msg_pub.count_and_get(

1467: p_loc_array(j).geometry_status_code := g_error;
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: );

Line 1748: fnd_msg_pub.initialize;

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,
1752: p_name => p_name,

Line 1875: fnd_msg_pub.add;

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
1874: fnd_message.set_token('LASTMSG', NVL(substrb(l_err_resp,1,200), ''));
1875: fnd_msg_pub.add;
1876:
1877: -- Set the error status for all records in this batch
1878: FOR i IN 1..p_loc_array.COUNT LOOP
1879: p_loc_array(i).geometry_status_code := g_error;

Line 1947: fnd_msg_pub.add;

1943: p_module =>'HZ');
1944: END IF;
1945: fnd_message.set_token('RESP', 'Malformed response');
1946: END; -- end of anonymous block
1947: fnd_msg_pub.add;
1948: /*
1949: If the lresp - response from the post() is not null and not a
1950: proper GEOCODE_RESPONSE and it is some other special chars, then
1951: it is safe to do add HZ_MALFORMED_SPATIAL_RESPONSE mesg to the stack

Line 1962: fnd_msg_pub.add;

1958:
1959: IF LTRIM(RTRIM(l_err_resp)) IS NOT NULL THEN
1960: fnd_message.set_name('AR','HZ_MALFORMED_SPATIAL_RESPONSE');
1961: fnd_message.set_token('RESP', nvl(substrb(l_err_resp,1,400), ''));
1962: fnd_msg_pub.add;
1963: END IF;
1964:
1965: -- Set the error status for all records in this batch
1966: FOR i IN 1..p_loc_array.COUNT LOOP

Line 2027: fnd_msg_pub.count_and_get(

2023: status_handler(l_return_status, x_return_status);
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: );