DBA Data[Home] [Help]

APPS.HZ_GEOCODE_PKG dependencies on FND_MSG_PUB

Line 421: fnd_msg_pub.add;

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',
425: p_msg_level=>fnd_log.level_error);

Line 565: fnd_msg_pub.add;

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',
569: p_msg_level=>fnd_log.level_error);

Line 600: fnd_msg_pub.add;

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',
604: p_msg_level=>fnd_log.level_error);

Line 634: fnd_msg_pub.add;

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 || '/>';
638: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 648: fnd_msg_pub.count_and_get(

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

Line 658: fnd_msg_pub.count_and_get(

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

Line 772: fnd_msg_pub.add;

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

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

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

Line 943: fnd_msg_pub.count_and_get(

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

Line 1038: fnd_msg_pub.add;

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: --
1042: -- PROCEDURE parse_one_response

Line 1114: fnd_msg_pub.add;

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',
1118: p_prefix=>'ERROR',

Line 1153: fnd_msg_pub.add;

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',
1157: p_prefix=>'ERROR',

Line 1192: fnd_msg_pub.add;

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',
1196: p_prefix=>'ERROR',

Line 1233: fnd_msg_pub.add;

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
1237: -- HZ_LOCATIONS.GEOMETRY_STATUS_CODE to NOEXACTMATCH to reflect the fact

Line 1266: fnd_msg_pub.add;

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
1270: -- multiple matches were returned.

Line 1282: fnd_msg_pub.add;

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.
1286: x_geo_status := g_error;

Line 1317: fnd_msg_pub.count_and_get(

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

Line 1421: fnd_msg_pub.count_and_get(

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

Line 1691: fnd_msg_pub.initialize;

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

Line 1755: fnd_msg_pub.add;

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

Line 1774: fnd_msg_pub.add;

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

Line 1822: fnd_msg_pub.count_and_get(

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