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_ELOCATION_PKG dependencies on FND_LOG

Line 140: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

136: SELECT rowid
137: FROM hz_locations
138: WHERE location_id = p_location_id;
139: BEGIN
140: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
141: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'||
142: TO_CHAR(p_location_id)||'(+)',
143: p_prefix=>l_debug_prefix,
144: p_msg_level=>fnd_log.level_procedure);

Line 144: p_msg_level=>fnd_log.level_procedure);

140: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
141: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'||
142: TO_CHAR(p_location_id)||'(+)',
143: p_prefix=>l_debug_prefix,
144: p_msg_level=>fnd_log.level_procedure);
145: END IF;
146: OPEN curowid;
147: FETCH curowid INTO l_rowid;
148: IF curowid%NOTFOUND THEN

Line 153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

149: x_return_status := fnd_api.g_ret_sts_error;
150: fnd_message.set_name('AR', 'HZ_NO_LOCATION_FOUND');
151: fnd_message.set_token('LOC_ID', TO_CHAR(p_location_id));
152: fnd_msg_pub.add;
153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'No Record found : Error',
155: p_prefix=>'ERROR',
156: p_msg_level=>fnd_log.level_error);
157: END IF;

Line 156: p_msg_level=>fnd_log.level_error);

152: fnd_msg_pub.add;
153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
154: hz_utility_v2pub.debug(p_message=>'No Record found : Error',
155: p_prefix=>'ERROR',
156: p_msg_level=>fnd_log.level_error);
157: END IF;
158: ELSE
159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||

Line 159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

155: p_prefix=>'ERROR',
156: p_msg_level=>fnd_log.level_error);
157: END IF;
158: ELSE
159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
161: TO_CHAR(p_location_id)||'(+)',
162: p_prefix=>l_debug_prefix,
163: p_msg_level=>fnd_log.level_procedure);

Line 163: p_msg_level=>fnd_log.level_procedure);

159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
161: TO_CHAR(p_location_id)||'(+)',
162: p_prefix=>l_debug_prefix,
163: p_msg_level=>fnd_log.level_procedure);
164: END IF;
165: hz_locations_pkg.update_row (
166: x_rowid => l_rowid,
167: x_location_id => p_location_id,

Line 237: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

233: );
234:
235: x_count := x_count + 1;
236:
237: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
238: hz_utility_v2pub.debug(p_message=>'Location successfully updated for location_id :'||TO_CHAR(p_location_id),
239: p_prefix =>l_debug_prefix,
240: p_msg_level=>fnd_log.level_statement);
241: END IF;

Line 240: p_msg_level=>fnd_log.level_statement);

236:
237: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
238: hz_utility_v2pub.debug(p_message=>'Location successfully updated for location_id :'||TO_CHAR(p_location_id),
239: p_prefix =>l_debug_prefix,
240: p_msg_level=>fnd_log.level_statement);
241: END IF;
242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
243: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
244: TO_CHAR(p_location_id)||'(-)',

Line 242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

238: hz_utility_v2pub.debug(p_message=>'Location successfully updated for location_id :'||TO_CHAR(p_location_id),
239: p_prefix =>l_debug_prefix,
240: p_msg_level=>fnd_log.level_statement);
241: END IF;
242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
243: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
244: TO_CHAR(p_location_id)||'(-)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);

Line 246: p_msg_level=>fnd_log.level_procedure);

242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
243: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||
244: TO_CHAR(p_location_id)||'(-)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;
248:
249: -- Fix perf bug 3669930, 4220460, cache profile option value into global variable
250: IF g_cp_detail = 'Y' THEN

Line 263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

259: p_encoded => fnd_api.g_false,
260: p_count => x_msg_count,
261: p_data => x_msg_data
262: );
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'
265: || TO_CHAR(p_location_id)||'(-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);

Line 267: p_msg_level=>fnd_log.level_procedure);

263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'
265: || TO_CHAR(p_location_id)||'(-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;
269: END update_geo_location;
270:
271: --------------------------------------

Line 544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

540:
541: l_nb_update := 0;
542: l_set_size := l_batch_size * g_sets_per_commit;
543:
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (+)',
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;

Line 547: p_msg_level=>fnd_log.level_procedure);

543:
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (+)',
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;
549:
550:
551:

Line 581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

577: l_nb_row_update := TO_NUMBER(p_nb_row_update);
578: END IF;
579: IF l_nb_row_update IS NULL OR l_nb_row_update <= 0 THEN
580: time_put_line('At least one row error.');
581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'At least one row error.',
583: p_prefix=>'ERROR',
584: p_msg_level=>fnd_log.level_error);
585: END IF;

Line 584: p_msg_level=>fnd_log.level_error);

580: time_put_line('At least one row error.');
581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'At least one row error.',
583: p_prefix=>'ERROR',
584: p_msg_level=>fnd_log.level_error);
585: END IF;
586: RAISE atleastonerow;
587: END IF;
588: END IF;

Line 598: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

594: -- Get the website we're supposed to access for geospatial information.
595: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);
596: IF l_http_ad IS NULL THEN
597: time_put_line('HTTP address missing');
598: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
599: hz_utility_v2pub.debug(p_message=>'HTTP address missing',
600: p_prefix=>'ERROR',
601: p_msg_level=>fnd_log.level_error);
602: END IF;

Line 601: p_msg_level=>fnd_log.level_error);

597: time_put_line('HTTP address missing');
598: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
599: hz_utility_v2pub.debug(p_message=>'HTTP address missing',
600: p_prefix=>'ERROR',
601: p_msg_level=>fnd_log.level_error);
602: END IF;
603: RAISE expect_http_ad;
604: END IF;
605:

Line 644: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

640: fnd_file.put_line(fnd_file.output, l_port_var || ': ' || l_port);
641: fnd_file.put_line(fnd_file.output, '');
642:
643: -- repeat in debug output.
644: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'HZ_GEOCODE_WEBSITE: ' || l_http_ad,
646: p_prefix =>l_debug_prefix,
647: p_msg_level=>fnd_log.level_statement);
648: hz_utility_v2pub.debug(p_message=>l_proxy_var || ': ' || l_proxy,

Line 647: p_msg_level=>fnd_log.level_statement);

643: -- repeat in debug output.
644: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'HZ_GEOCODE_WEBSITE: ' || l_http_ad,
646: p_prefix =>l_debug_prefix,
647: p_msg_level=>fnd_log.level_statement);
648: hz_utility_v2pub.debug(p_message=>l_proxy_var || ': ' || l_proxy,
649: p_prefix =>l_debug_prefix,
650: p_msg_level=>fnd_log.level_statement);
651: hz_utility_v2pub.debug(p_message=>l_port_var || ': ' || l_port,

Line 650: p_msg_level=>fnd_log.level_statement);

646: p_prefix =>l_debug_prefix,
647: p_msg_level=>fnd_log.level_statement);
648: hz_utility_v2pub.debug(p_message=>l_proxy_var || ': ' || l_proxy,
649: p_prefix =>l_debug_prefix,
650: p_msg_level=>fnd_log.level_statement);
651: hz_utility_v2pub.debug(p_message=>l_port_var || ': ' || l_port,
652: p_prefix =>l_debug_prefix,
653: p_msg_level=>fnd_log.level_statement);
654: END IF;

Line 653: p_msg_level=>fnd_log.level_statement);

649: p_prefix =>l_debug_prefix,
650: p_msg_level=>fnd_log.level_statement);
651: hz_utility_v2pub.debug(p_message=>l_port_var || ': ' || l_port,
652: p_prefix =>l_debug_prefix,
653: p_msg_level=>fnd_log.level_statement);
654: END IF;
655:
656: IF l_port IS NOT NULL THEN
657: -- J. del Callar: set the port number and handle non-numeric values

Line 683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

679: -- and non-incremental mode.
680: IF(p_country IS NULL) THEN
681: IF NOT cu_loc1a%ISOPEN THEN
682: OPEN cu_loc1a (l_request_id);
683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
684: hz_utility_v2pub.debug(p_message=>'Opening cursor 1a with args:',
685: p_prefix =>l_debug_prefix,
686: p_msg_level=>fnd_log.level_statement);
687: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 686: p_msg_level=>fnd_log.level_statement);

682: OPEN cu_loc1a (l_request_id);
683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
684: hz_utility_v2pub.debug(p_message=>'Opening cursor 1a with args:',
685: p_prefix =>l_debug_prefix,
686: p_msg_level=>fnd_log.level_statement);
687: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
688: p_prefix =>l_debug_prefix,
689: p_msg_level=>fnd_log.level_statement);
690: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 689: p_msg_level=>fnd_log.level_statement);

685: p_prefix =>l_debug_prefix,
686: p_msg_level=>fnd_log.level_statement);
687: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
688: p_prefix =>l_debug_prefix,
689: p_msg_level=>fnd_log.level_statement);
690: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
691: p_prefix =>l_debug_prefix,
692: p_msg_level=>fnd_log.level_statement);
693: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 692: p_msg_level=>fnd_log.level_statement);

688: p_prefix =>l_debug_prefix,
689: p_msg_level=>fnd_log.level_statement);
690: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
691: p_prefix =>l_debug_prefix,
692: p_msg_level=>fnd_log.level_statement);
693: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
694: p_prefix =>l_debug_prefix,
695: p_msg_level=>fnd_log.level_statement);
696: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 695: p_msg_level=>fnd_log.level_statement);

691: p_prefix =>l_debug_prefix,
692: p_msg_level=>fnd_log.level_statement);
693: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
694: p_prefix =>l_debug_prefix,
695: p_msg_level=>fnd_log.level_statement);
696: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;

Line 698: p_msg_level=>fnd_log.level_statement);

694: p_prefix =>l_debug_prefix,
695: p_msg_level=>fnd_log.level_statement);
696: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
697: p_prefix =>l_debug_prefix,
698: p_msg_level=>fnd_log.level_statement);
699: END IF;
700: END IF;
701:
702: -- J. del Callar: fetch the next set of location information.

Line 712: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

708: -- J. del Callar: exit the loop if we've processed all records
709: IF cu_loc1a%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
710: time_put_line('Exiting because of NOTFOUND condition');
711: time_put_line('Count=' || l_location_ids.COUNT);
712: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
714: p_prefix=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 715: p_msg_level=>fnd_log.level_exception);

711: time_put_line('Count=' || l_location_ids.COUNT);
712: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
714: p_prefix=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
717: p_prefix=>'WARNING',
718: p_msg_level=>fnd_log.level_exception);
719: END IF;

Line 718: p_msg_level=>fnd_log.level_exception);

714: p_prefix=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
717: p_prefix=>'WARNING',
718: p_msg_level=>fnd_log.level_exception);
719: END IF;
720: EXIT;
721: END IF;
722: ELSE -- cu_loc1a/cu_loc1ac check p_country is null or not

Line 725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

721: END IF;
722: ELSE -- cu_loc1a/cu_loc1ac check p_country is null or not
723: IF NOT cu_loc1ac%ISOPEN THEN
724: OPEN cu_loc1ac (l_request_id);
725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
726: hz_utility_v2pub.debug(p_message=>'Opening cursor 1ac with args:',
727: p_prefix =>l_debug_prefix,
728: p_msg_level=>fnd_log.level_statement);
729: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 728: p_msg_level=>fnd_log.level_statement);

724: OPEN cu_loc1ac (l_request_id);
725: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
726: hz_utility_v2pub.debug(p_message=>'Opening cursor 1ac with args:',
727: p_prefix =>l_debug_prefix,
728: p_msg_level=>fnd_log.level_statement);
729: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
730: p_prefix =>l_debug_prefix,
731: p_msg_level=>fnd_log.level_statement);
732: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

Line 731: p_msg_level=>fnd_log.level_statement);

727: p_prefix =>l_debug_prefix,
728: p_msg_level=>fnd_log.level_statement);
729: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
730: p_prefix =>l_debug_prefix,
731: p_msg_level=>fnd_log.level_statement);
732: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
733: p_prefix =>l_debug_prefix,
734: p_msg_level=>fnd_log.level_statement);
735: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 734: p_msg_level=>fnd_log.level_statement);

730: p_prefix =>l_debug_prefix,
731: p_msg_level=>fnd_log.level_statement);
732: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
733: p_prefix =>l_debug_prefix,
734: p_msg_level=>fnd_log.level_statement);
735: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
736: p_prefix =>l_debug_prefix,
737: p_msg_level=>fnd_log.level_statement);
738: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 737: p_msg_level=>fnd_log.level_statement);

733: p_prefix =>l_debug_prefix,
734: p_msg_level=>fnd_log.level_statement);
735: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
736: p_prefix =>l_debug_prefix,
737: p_msg_level=>fnd_log.level_statement);
738: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
739: p_prefix =>l_debug_prefix,
740: p_msg_level=>fnd_log.level_statement);
741: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 740: p_msg_level=>fnd_log.level_statement);

736: p_prefix =>l_debug_prefix,
737: p_msg_level=>fnd_log.level_statement);
738: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
739: p_prefix =>l_debug_prefix,
740: p_msg_level=>fnd_log.level_statement);
741: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
742: p_prefix =>l_debug_prefix,
743: p_msg_level=>fnd_log.level_statement);
744: END IF;

Line 743: p_msg_level=>fnd_log.level_statement);

739: p_prefix =>l_debug_prefix,
740: p_msg_level=>fnd_log.level_statement);
741: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
742: p_prefix =>l_debug_prefix,
743: p_msg_level=>fnd_log.level_statement);
744: END IF;
745: END IF;
746:
747: -- J. del Callar: fetch the next set of location information.

Line 757: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

753: -- J. del Callar: exit the loop if we've processed all records
754: IF cu_loc1ac%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
755: time_put_line('Exiting because of NOTFOUND condition');
756: time_put_line('Count=' || l_location_ids.COUNT);
757: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
758: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
759: p_prefix=>'WARNING',
760: p_msg_level=>fnd_log.level_exception);
761: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 760: p_msg_level=>fnd_log.level_exception);

756: time_put_line('Count=' || l_location_ids.COUNT);
757: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
758: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
759: p_prefix=>'WARNING',
760: p_msg_level=>fnd_log.level_exception);
761: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
762: p_prefix=>'WARNING',
763: p_msg_level=>fnd_log.level_exception);
764: END IF;

Line 763: p_msg_level=>fnd_log.level_exception);

759: p_prefix=>'WARNING',
760: p_msg_level=>fnd_log.level_exception);
761: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
762: p_prefix=>'WARNING',
763: p_msg_level=>fnd_log.level_exception);
764: END IF;
765: EXIT;
766: END IF;
767: END IF; -- cu_loc1a/cu_loc1ac check p_country is null or not

Line 775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

771: -- and incremental mode.
772: IF(p_country IS NULL) THEN
773: IF NOT cu_loc1b%ISOPEN THEN
774: OPEN cu_loc1b (l_request_id);
775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug(p_message=>'Opening cursor 1b with args:',
777: p_prefix =>l_debug_prefix,
778: p_msg_level=>fnd_log.level_statement);
779: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 778: p_msg_level=>fnd_log.level_statement);

774: OPEN cu_loc1b (l_request_id);
775: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug(p_message=>'Opening cursor 1b with args:',
777: p_prefix =>l_debug_prefix,
778: p_msg_level=>fnd_log.level_statement);
779: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
780: p_prefix =>l_debug_prefix,
781: p_msg_level=>fnd_log.level_statement);
782: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 781: p_msg_level=>fnd_log.level_statement);

777: p_prefix =>l_debug_prefix,
778: p_msg_level=>fnd_log.level_statement);
779: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
780: p_prefix =>l_debug_prefix,
781: p_msg_level=>fnd_log.level_statement);
782: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
783: p_prefix =>l_debug_prefix,
784: p_msg_level=>fnd_log.level_statement);
785: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 784: p_msg_level=>fnd_log.level_statement);

780: p_prefix =>l_debug_prefix,
781: p_msg_level=>fnd_log.level_statement);
782: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
783: p_prefix =>l_debug_prefix,
784: p_msg_level=>fnd_log.level_statement);
785: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
786: p_prefix =>l_debug_prefix,
787: p_msg_level=>fnd_log.level_statement);
788: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 787: p_msg_level=>fnd_log.level_statement);

783: p_prefix =>l_debug_prefix,
784: p_msg_level=>fnd_log.level_statement);
785: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
786: p_prefix =>l_debug_prefix,
787: p_msg_level=>fnd_log.level_statement);
788: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
789: p_prefix =>l_debug_prefix,
790: p_msg_level=>fnd_log.level_statement);
791: END IF;

Line 790: p_msg_level=>fnd_log.level_statement);

786: p_prefix =>l_debug_prefix,
787: p_msg_level=>fnd_log.level_statement);
788: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
789: p_prefix =>l_debug_prefix,
790: p_msg_level=>fnd_log.level_statement);
791: END IF;
792: END IF;
793:
794: -- J. del Callar: fetch the next set of location information.

Line 804: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

800: -- J. del Callar: exit the loop if we've processed all records
801: IF cu_loc1b%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
802: time_put_line('Exiting because of NOTFOUND condition');
803: time_put_line('Count=' || l_location_ids.COUNT);
804: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
806: p_prefix=>'WARNING',
807: p_msg_level=>fnd_log.level_exception);
808: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 807: p_msg_level=>fnd_log.level_exception);

803: time_put_line('Count=' || l_location_ids.COUNT);
804: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
806: p_prefix=>'WARNING',
807: p_msg_level=>fnd_log.level_exception);
808: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
809: p_prefix=>'WARNING',
810: p_msg_level=>fnd_log.level_exception);
811: END IF;

Line 810: p_msg_level=>fnd_log.level_exception);

806: p_prefix=>'WARNING',
807: p_msg_level=>fnd_log.level_exception);
808: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
809: p_prefix=>'WARNING',
810: p_msg_level=>fnd_log.level_exception);
811: END IF;
812: EXIT;
813: END IF;
814: ELSE -- cu_loc1b/cu_loc1bc, check if p_country is null or not

Line 817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

813: END IF;
814: ELSE -- cu_loc1b/cu_loc1bc, check if p_country is null or not
815: IF NOT cu_loc1bc%ISOPEN THEN
816: OPEN cu_loc1bc (l_request_id);
817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.debug(p_message=>'Opening cursor 1bc with args:',
819: p_prefix =>l_debug_prefix,
820: p_msg_level=>fnd_log.level_statement);
821: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 820: p_msg_level=>fnd_log.level_statement);

816: OPEN cu_loc1bc (l_request_id);
817: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.debug(p_message=>'Opening cursor 1bc with args:',
819: p_prefix =>l_debug_prefix,
820: p_msg_level=>fnd_log.level_statement);
821: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
822: p_prefix =>l_debug_prefix,
823: p_msg_level=>fnd_log.level_statement);
824: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

Line 823: p_msg_level=>fnd_log.level_statement);

819: p_prefix =>l_debug_prefix,
820: p_msg_level=>fnd_log.level_statement);
821: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
822: p_prefix =>l_debug_prefix,
823: p_msg_level=>fnd_log.level_statement);
824: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
825: p_prefix =>l_debug_prefix,
826: p_msg_level=>fnd_log.level_statement);
827: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 826: p_msg_level=>fnd_log.level_statement);

822: p_prefix =>l_debug_prefix,
823: p_msg_level=>fnd_log.level_statement);
824: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
825: p_prefix =>l_debug_prefix,
826: p_msg_level=>fnd_log.level_statement);
827: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
828: p_prefix =>l_debug_prefix,
829: p_msg_level=>fnd_log.level_statement);
830: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 829: p_msg_level=>fnd_log.level_statement);

825: p_prefix =>l_debug_prefix,
826: p_msg_level=>fnd_log.level_statement);
827: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
828: p_prefix =>l_debug_prefix,
829: p_msg_level=>fnd_log.level_statement);
830: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
831: p_prefix =>l_debug_prefix,
832: p_msg_level=>fnd_log.level_statement);
833: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 832: p_msg_level=>fnd_log.level_statement);

828: p_prefix =>l_debug_prefix,
829: p_msg_level=>fnd_log.level_statement);
830: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
831: p_prefix =>l_debug_prefix,
832: p_msg_level=>fnd_log.level_statement);
833: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
834: p_prefix =>l_debug_prefix,
835: p_msg_level=>fnd_log.level_statement);
836: END IF;

Line 835: p_msg_level=>fnd_log.level_statement);

831: p_prefix =>l_debug_prefix,
832: p_msg_level=>fnd_log.level_statement);
833: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
834: p_prefix =>l_debug_prefix,
835: p_msg_level=>fnd_log.level_statement);
836: END IF;
837: END IF;
838:
839: -- J. del Callar: fetch the next set of location information.

Line 849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

845: -- J. del Callar: exit the loop if we've processed all records
846: IF cu_loc1bc%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
847: time_put_line('Exiting because of NOTFOUND condition');
848: time_put_line('Count=' || l_location_ids.COUNT);
849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
850: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
851: p_prefix=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 852: p_msg_level=>fnd_log.level_exception);

848: time_put_line('Count=' || l_location_ids.COUNT);
849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
850: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
851: p_prefix=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
854: p_prefix=>'WARNING',
855: p_msg_level=>fnd_log.level_exception);
856: END IF;

Line 855: p_msg_level=>fnd_log.level_exception);

851: p_prefix=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
854: p_prefix=>'WARNING',
855: p_msg_level=>fnd_log.level_exception);
856: END IF;
857: EXIT;
858: END IF;
859: END IF; -- cu_loc1b/cu_loc1bc, check if p_country is null or not

Line 867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

863: -- and non-incremental mode.
864: IF(p_country IS NULL) THEN
865: IF NOT cu_loc2a%ISOPEN THEN
866: OPEN cu_loc2a (l_request_id);
867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
868: hz_utility_v2pub.debug(p_message=>'Opening cursor 2a with args:',
869: p_prefix =>l_debug_prefix,
870: p_msg_level=>fnd_log.level_statement);
871: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 870: p_msg_level=>fnd_log.level_statement);

866: OPEN cu_loc2a (l_request_id);
867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
868: hz_utility_v2pub.debug(p_message=>'Opening cursor 2a with args:',
869: p_prefix =>l_debug_prefix,
870: p_msg_level=>fnd_log.level_statement);
871: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
872: p_prefix =>l_debug_prefix,
873: p_msg_level=>fnd_log.level_statement);
874: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 873: p_msg_level=>fnd_log.level_statement);

869: p_prefix =>l_debug_prefix,
870: p_msg_level=>fnd_log.level_statement);
871: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
872: p_prefix =>l_debug_prefix,
873: p_msg_level=>fnd_log.level_statement);
874: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
875: p_prefix =>l_debug_prefix,
876: p_msg_level=>fnd_log.level_statement);
877: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 876: p_msg_level=>fnd_log.level_statement);

872: p_prefix =>l_debug_prefix,
873: p_msg_level=>fnd_log.level_statement);
874: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
875: p_prefix =>l_debug_prefix,
876: p_msg_level=>fnd_log.level_statement);
877: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
878: p_prefix =>l_debug_prefix,
879: p_msg_level=>fnd_log.level_statement);
880: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 879: p_msg_level=>fnd_log.level_statement);

875: p_prefix =>l_debug_prefix,
876: p_msg_level=>fnd_log.level_statement);
877: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
878: p_prefix =>l_debug_prefix,
879: p_msg_level=>fnd_log.level_statement);
880: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
881: p_prefix =>l_debug_prefix,
882: p_msg_level=>fnd_log.level_statement);
883: END IF;

Line 882: p_msg_level=>fnd_log.level_statement);

878: p_prefix =>l_debug_prefix,
879: p_msg_level=>fnd_log.level_statement);
880: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
881: p_prefix =>l_debug_prefix,
882: p_msg_level=>fnd_log.level_statement);
883: END IF;
884: END IF;
885:
886: -- J. del Callar: fetch the next set of location information.

Line 896: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

892: -- J. del Callar: exit the loop if we've processed all records
893: IF cu_loc2a%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
894: time_put_line('Exiting because of NOTFOUND condition');
895: time_put_line('Count=' || l_location_ids.COUNT);
896: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
898: p_prefix=>'WARNING',
899: p_msg_level=>fnd_log.level_exception);
900: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 899: p_msg_level=>fnd_log.level_exception);

895: time_put_line('Count=' || l_location_ids.COUNT);
896: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
898: p_prefix=>'WARNING',
899: p_msg_level=>fnd_log.level_exception);
900: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
901: p_prefix=>'WARNING',
902: p_msg_level=>fnd_log.level_exception);
903: END IF;

Line 902: p_msg_level=>fnd_log.level_exception);

898: p_prefix=>'WARNING',
899: p_msg_level=>fnd_log.level_exception);
900: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
901: p_prefix=>'WARNING',
902: p_msg_level=>fnd_log.level_exception);
903: END IF;
904: EXIT;
905: END IF;
906: ELSE -- cu_loc2a/cu_loc2ac, check if p_country is null or not

Line 909: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

905: END IF;
906: ELSE -- cu_loc2a/cu_loc2ac, check if p_country is null or not
907: IF NOT cu_loc2ac%ISOPEN THEN
908: OPEN cu_loc2ac (l_request_id);
909: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
910: hz_utility_v2pub.debug(p_message=>'Opening cursor 2ac with args:',
911: p_prefix =>l_debug_prefix,
912: p_msg_level=>fnd_log.level_statement);
913: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 912: p_msg_level=>fnd_log.level_statement);

908: OPEN cu_loc2ac (l_request_id);
909: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
910: hz_utility_v2pub.debug(p_message=>'Opening cursor 2ac with args:',
911: p_prefix =>l_debug_prefix,
912: p_msg_level=>fnd_log.level_statement);
913: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
914: p_prefix =>l_debug_prefix,
915: p_msg_level=>fnd_log.level_statement);
916: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

Line 915: p_msg_level=>fnd_log.level_statement);

911: p_prefix =>l_debug_prefix,
912: p_msg_level=>fnd_log.level_statement);
913: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
914: p_prefix =>l_debug_prefix,
915: p_msg_level=>fnd_log.level_statement);
916: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
917: p_prefix =>l_debug_prefix,
918: p_msg_level=>fnd_log.level_statement);
919: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 918: p_msg_level=>fnd_log.level_statement);

914: p_prefix =>l_debug_prefix,
915: p_msg_level=>fnd_log.level_statement);
916: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
917: p_prefix =>l_debug_prefix,
918: p_msg_level=>fnd_log.level_statement);
919: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
920: p_prefix =>l_debug_prefix,
921: p_msg_level=>fnd_log.level_statement);
922: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 921: p_msg_level=>fnd_log.level_statement);

917: p_prefix =>l_debug_prefix,
918: p_msg_level=>fnd_log.level_statement);
919: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
920: p_prefix =>l_debug_prefix,
921: p_msg_level=>fnd_log.level_statement);
922: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
923: p_prefix =>l_debug_prefix,
924: p_msg_level=>fnd_log.level_statement);
925: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 924: p_msg_level=>fnd_log.level_statement);

920: p_prefix =>l_debug_prefix,
921: p_msg_level=>fnd_log.level_statement);
922: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
923: p_prefix =>l_debug_prefix,
924: p_msg_level=>fnd_log.level_statement);
925: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
926: p_prefix =>l_debug_prefix,
927: p_msg_level=>fnd_log.level_statement);
928: END IF;

Line 927: p_msg_level=>fnd_log.level_statement);

923: p_prefix =>l_debug_prefix,
924: p_msg_level=>fnd_log.level_statement);
925: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
926: p_prefix =>l_debug_prefix,
927: p_msg_level=>fnd_log.level_statement);
928: END IF;
929: END IF;
930:
931: -- J. del Callar: fetch the next set of location information.

Line 941: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

937: -- J. del Callar: exit the loop if we've processed all records
938: IF cu_loc2ac%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
939: time_put_line('Exiting because of NOTFOUND condition');
940: time_put_line('Count=' || l_location_ids.COUNT);
941: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
942: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
943: p_prefix=>'WARNING',
944: p_msg_level=>fnd_log.level_exception);
945: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 944: p_msg_level=>fnd_log.level_exception);

940: time_put_line('Count=' || l_location_ids.COUNT);
941: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
942: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
943: p_prefix=>'WARNING',
944: p_msg_level=>fnd_log.level_exception);
945: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
946: p_prefix=>'WARNING',
947: p_msg_level=>fnd_log.level_exception);
948: END IF;

Line 947: p_msg_level=>fnd_log.level_exception);

943: p_prefix=>'WARNING',
944: p_msg_level=>fnd_log.level_exception);
945: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
946: p_prefix=>'WARNING',
947: p_msg_level=>fnd_log.level_exception);
948: END IF;
949: EXIT;
950: END IF;
951: END IF; -- cu_loc2a/cu_loc2ac, check if p_country is null or not

Line 959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

955: -- and incremental mode.
956: IF(p_country IS NULL) THEN
957: IF NOT cu_loc2b%ISOPEN THEN
958: OPEN cu_loc2b (l_request_id);
959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
960: hz_utility_v2pub.debug(p_message=>'Opening cursor 2b with args:',
961: p_prefix =>l_debug_prefix,
962: p_msg_level=>fnd_log.level_statement);
963: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 962: p_msg_level=>fnd_log.level_statement);

958: OPEN cu_loc2b (l_request_id);
959: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
960: hz_utility_v2pub.debug(p_message=>'Opening cursor 2b with args:',
961: p_prefix =>l_debug_prefix,
962: p_msg_level=>fnd_log.level_statement);
963: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
964: p_prefix =>l_debug_prefix,
965: p_msg_level=>fnd_log.level_statement);
966: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 965: p_msg_level=>fnd_log.level_statement);

961: p_prefix =>l_debug_prefix,
962: p_msg_level=>fnd_log.level_statement);
963: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
964: p_prefix =>l_debug_prefix,
965: p_msg_level=>fnd_log.level_statement);
966: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
967: p_prefix =>l_debug_prefix,
968: p_msg_level=>fnd_log.level_statement);
969: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 968: p_msg_level=>fnd_log.level_statement);

964: p_prefix =>l_debug_prefix,
965: p_msg_level=>fnd_log.level_statement);
966: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
967: p_prefix =>l_debug_prefix,
968: p_msg_level=>fnd_log.level_statement);
969: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
970: p_prefix =>l_debug_prefix,
971: p_msg_level=>fnd_log.level_statement);
972: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 971: p_msg_level=>fnd_log.level_statement);

967: p_prefix =>l_debug_prefix,
968: p_msg_level=>fnd_log.level_statement);
969: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
970: p_prefix =>l_debug_prefix,
971: p_msg_level=>fnd_log.level_statement);
972: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
973: p_prefix =>l_debug_prefix,
974: p_msg_level=>fnd_log.level_statement);
975: END IF;

Line 974: p_msg_level=>fnd_log.level_statement);

970: p_prefix =>l_debug_prefix,
971: p_msg_level=>fnd_log.level_statement);
972: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
973: p_prefix =>l_debug_prefix,
974: p_msg_level=>fnd_log.level_statement);
975: END IF;
976: END IF;
977:
978: -- J. del Callar: fetch the next set of location information.

Line 988: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

984: -- J. del Callar: exit the loop if we've processed all records
985: IF cu_loc2b%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
986: time_put_line('Exiting because of NOTFOUND condition');
987: time_put_line('Count=' || l_location_ids.COUNT);
988: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
990: p_prefix=>'WARNING',
991: p_msg_level=>fnd_log.level_exception);
992: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 991: p_msg_level=>fnd_log.level_exception);

987: time_put_line('Count=' || l_location_ids.COUNT);
988: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
990: p_prefix=>'WARNING',
991: p_msg_level=>fnd_log.level_exception);
992: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
993: p_prefix=>'WARNING',
994: p_msg_level=>fnd_log.level_exception);
995: END IF;

Line 994: p_msg_level=>fnd_log.level_exception);

990: p_prefix=>'WARNING',
991: p_msg_level=>fnd_log.level_exception);
992: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
993: p_prefix=>'WARNING',
994: p_msg_level=>fnd_log.level_exception);
995: END IF;
996: EXIT;
997: END IF;
998: ELSE -- cu_loc2b/cu_loc2bc, check if p_country is null or not

Line 1001: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

997: END IF;
998: ELSE -- cu_loc2b/cu_loc2bc, check if p_country is null or not
999: IF NOT cu_loc2bc%ISOPEN THEN
1000: OPEN cu_loc2bc (l_request_id);
1001: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1002: hz_utility_v2pub.debug(p_message=>'Opening cursor 2bc with args:',
1003: p_prefix =>l_debug_prefix,
1004: p_msg_level=>fnd_log.level_statement);
1005: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 1004: p_msg_level=>fnd_log.level_statement);

1000: OPEN cu_loc2bc (l_request_id);
1001: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1002: hz_utility_v2pub.debug(p_message=>'Opening cursor 2bc with args:',
1003: p_prefix =>l_debug_prefix,
1004: p_msg_level=>fnd_log.level_statement);
1005: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1006: p_prefix =>l_debug_prefix,
1007: p_msg_level=>fnd_log.level_statement);
1008: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

Line 1007: p_msg_level=>fnd_log.level_statement);

1003: p_prefix =>l_debug_prefix,
1004: p_msg_level=>fnd_log.level_statement);
1005: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1006: p_prefix =>l_debug_prefix,
1007: p_msg_level=>fnd_log.level_statement);
1008: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
1009: p_prefix =>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_statement);
1011: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 1010: p_msg_level=>fnd_log.level_statement);

1006: p_prefix =>l_debug_prefix,
1007: p_msg_level=>fnd_log.level_statement);
1008: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
1009: p_prefix =>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_statement);
1011: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1012: p_prefix =>l_debug_prefix,
1013: p_msg_level=>fnd_log.level_statement);
1014: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 1013: p_msg_level=>fnd_log.level_statement);

1009: p_prefix =>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_statement);
1011: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1012: p_prefix =>l_debug_prefix,
1013: p_msg_level=>fnd_log.level_statement);
1014: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1015: p_prefix =>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_statement);
1017: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 1016: p_msg_level=>fnd_log.level_statement);

1012: p_prefix =>l_debug_prefix,
1013: p_msg_level=>fnd_log.level_statement);
1014: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1015: p_prefix =>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_statement);
1017: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1018: p_prefix =>l_debug_prefix,
1019: p_msg_level=>fnd_log.level_statement);
1020: END IF;

Line 1019: p_msg_level=>fnd_log.level_statement);

1015: p_prefix =>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_statement);
1017: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1018: p_prefix =>l_debug_prefix,
1019: p_msg_level=>fnd_log.level_statement);
1020: END IF;
1021: END IF;
1022:
1023: -- J. del Callar: fetch the next set of location information.

Line 1033: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1029: -- J. del Callar: exit the loop if we've processed all records
1030: IF cu_loc2bc%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
1031: time_put_line('Exiting because of NOTFOUND condition');
1032: time_put_line('Count=' || l_location_ids.COUNT);
1033: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1034: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1035: p_prefix=>'WARNING',
1036: p_msg_level=>fnd_log.level_exception);
1037: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 1036: p_msg_level=>fnd_log.level_exception);

1032: time_put_line('Count=' || l_location_ids.COUNT);
1033: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1034: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1035: p_prefix=>'WARNING',
1036: p_msg_level=>fnd_log.level_exception);
1037: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1038: p_prefix=>'WARNING',
1039: p_msg_level=>fnd_log.level_exception);
1040: END IF;

Line 1039: p_msg_level=>fnd_log.level_exception);

1035: p_prefix=>'WARNING',
1036: p_msg_level=>fnd_log.level_exception);
1037: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1038: p_prefix=>'WARNING',
1039: p_msg_level=>fnd_log.level_exception);
1040: END IF;
1041: EXIT;
1042: END IF;
1043: END IF; -- cu_loc2b/cu_loc2bc, check if p_country is null or not

Line 1057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1053:
1054: IF(p_country IS NULL) THEN
1055: IF NOT cu_loc3a%ISOPEN THEN
1056: OPEN cu_loc3a (l_request_id);
1057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1058: hz_utility_v2pub.debug(p_message=>'Opening cursor 3a with args:',
1059: p_prefix =>l_debug_prefix,
1060: p_msg_level=>fnd_log.level_statement);
1061: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 1060: p_msg_level=>fnd_log.level_statement);

1056: OPEN cu_loc3a (l_request_id);
1057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1058: hz_utility_v2pub.debug(p_message=>'Opening cursor 3a with args:',
1059: p_prefix =>l_debug_prefix,
1060: p_msg_level=>fnd_log.level_statement);
1061: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1062: p_prefix =>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_statement);
1064: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 1063: p_msg_level=>fnd_log.level_statement);

1059: p_prefix =>l_debug_prefix,
1060: p_msg_level=>fnd_log.level_statement);
1061: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1062: p_prefix =>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_statement);
1064: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1065: p_prefix =>l_debug_prefix,
1066: p_msg_level=>fnd_log.level_statement);
1067: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 1066: p_msg_level=>fnd_log.level_statement);

1062: p_prefix =>l_debug_prefix,
1063: p_msg_level=>fnd_log.level_statement);
1064: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1065: p_prefix =>l_debug_prefix,
1066: p_msg_level=>fnd_log.level_statement);
1067: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1068: p_prefix =>l_debug_prefix,
1069: p_msg_level=>fnd_log.level_statement);
1070: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 1069: p_msg_level=>fnd_log.level_statement);

1065: p_prefix =>l_debug_prefix,
1066: p_msg_level=>fnd_log.level_statement);
1067: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1068: p_prefix =>l_debug_prefix,
1069: p_msg_level=>fnd_log.level_statement);
1070: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1071: p_prefix =>l_debug_prefix,
1072: p_msg_level=>fnd_log.level_statement);
1073: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

Line 1072: p_msg_level=>fnd_log.level_statement);

1068: p_prefix =>l_debug_prefix,
1069: p_msg_level=>fnd_log.level_statement);
1070: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1071: p_prefix =>l_debug_prefix,
1072: p_msg_level=>fnd_log.level_statement);
1073: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1074: p_prefix =>l_debug_prefix,
1075: p_msg_level=>fnd_log.level_statement);
1076: END IF;

Line 1075: p_msg_level=>fnd_log.level_statement);

1071: p_prefix =>l_debug_prefix,
1072: p_msg_level=>fnd_log.level_statement);
1073: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1074: p_prefix =>l_debug_prefix,
1075: p_msg_level=>fnd_log.level_statement);
1076: END IF;
1077: END IF;
1078:
1079: -- swbhatna: fetch the next set of location information.

Line 1089: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1085: -- swbhatna: exit the loop if we've processed all records
1086: IF cu_loc3a%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
1087: time_put_line('Exiting because of NOTFOUND condition');
1088: time_put_line('Count=' || l_location_ids.COUNT);
1089: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1090: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1091: p_prefix=>'WARNING',
1092: p_msg_level=>fnd_log.level_exception);
1093: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 1092: p_msg_level=>fnd_log.level_exception);

1088: time_put_line('Count=' || l_location_ids.COUNT);
1089: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1090: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1091: p_prefix=>'WARNING',
1092: p_msg_level=>fnd_log.level_exception);
1093: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1094: p_prefix=>'WARNING',
1095: p_msg_level=>fnd_log.level_exception);
1096: END IF;

Line 1095: p_msg_level=>fnd_log.level_exception);

1091: p_prefix=>'WARNING',
1092: p_msg_level=>fnd_log.level_exception);
1093: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1094: p_prefix=>'WARNING',
1095: p_msg_level=>fnd_log.level_exception);
1096: END IF;
1097: EXIT;
1098: END IF;
1099: ELSE -- cu_loc3a/cu_loc3ac, check if p_country is null or not

Line 1102: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1098: END IF;
1099: ELSE -- cu_loc3a/cu_loc3ac, check if p_country is null or not
1100: IF NOT cu_loc3ac%ISOPEN THEN
1101: OPEN cu_loc3ac (l_request_id);
1102: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1103: hz_utility_v2pub.debug(p_message=>'Opening cursor 3ac with args:',
1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 1105: p_msg_level=>fnd_log.level_statement);

1101: OPEN cu_loc3ac (l_request_id);
1102: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1103: hz_utility_v2pub.debug(p_message=>'Opening cursor 3ac with args:',
1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

Line 1108: p_msg_level=>fnd_log.level_statement);

1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 1111: p_msg_level=>fnd_log.level_statement);

1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1113: p_prefix =>l_debug_prefix,
1114: p_msg_level=>fnd_log.level_statement);
1115: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 1114: p_msg_level=>fnd_log.level_statement);

1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1113: p_prefix =>l_debug_prefix,
1114: p_msg_level=>fnd_log.level_statement);
1115: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1116: p_prefix =>l_debug_prefix,
1117: p_msg_level=>fnd_log.level_statement);
1118: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 1117: p_msg_level=>fnd_log.level_statement);

1113: p_prefix =>l_debug_prefix,
1114: p_msg_level=>fnd_log.level_statement);
1115: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1116: p_prefix =>l_debug_prefix,
1117: p_msg_level=>fnd_log.level_statement);
1118: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1119: p_prefix =>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_statement);
1121: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

Line 1120: p_msg_level=>fnd_log.level_statement);

1116: p_prefix =>l_debug_prefix,
1117: p_msg_level=>fnd_log.level_statement);
1118: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1119: p_prefix =>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_statement);
1121: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1122: p_prefix =>l_debug_prefix,
1123: p_msg_level=>fnd_log.level_statement);
1124: END IF;

Line 1123: p_msg_level=>fnd_log.level_statement);

1119: p_prefix =>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_statement);
1121: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1122: p_prefix =>l_debug_prefix,
1123: p_msg_level=>fnd_log.level_statement);
1124: END IF;
1125: END IF;
1126:
1127: -- swbhatna: fetch the next set of location information.

Line 1137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1133: -- swbhatna: exit the loop if we've processed all records
1134: IF cu_loc3ac%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
1135: time_put_line('Exiting because of NOTFOUND condition');
1136: time_put_line('Count=' || l_location_ids.COUNT);
1137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1138: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1139: p_prefix=>'WARNING',
1140: p_msg_level=>fnd_log.level_exception);
1141: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 1140: p_msg_level=>fnd_log.level_exception);

1136: time_put_line('Count=' || l_location_ids.COUNT);
1137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1138: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1139: p_prefix=>'WARNING',
1140: p_msg_level=>fnd_log.level_exception);
1141: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1142: p_prefix=>'WARNING',
1143: p_msg_level=>fnd_log.level_exception);
1144: END IF;

Line 1143: p_msg_level=>fnd_log.level_exception);

1139: p_prefix=>'WARNING',
1140: p_msg_level=>fnd_log.level_exception);
1141: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1142: p_prefix=>'WARNING',
1143: p_msg_level=>fnd_log.level_exception);
1144: END IF;
1145: END IF;
1146: END IF; -- cu_loc3a/cu_loc3ac, check if p_country is null or not
1147:

Line 1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1151:
1152: IF(p_country IS NULL) THEN
1153: IF NOT cu_loc3b%ISOPEN THEN
1154: OPEN cu_loc3b (l_request_id);
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'Opening cursor 3b with args:',
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 1158: p_msg_level=>fnd_log.level_statement);

1154: OPEN cu_loc3b (l_request_id);
1155: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1156: hz_utility_v2pub.debug(p_message=>'Opening cursor 3b with args:',
1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1160: p_prefix =>l_debug_prefix,
1161: p_msg_level=>fnd_log.level_statement);
1162: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 1161: p_msg_level=>fnd_log.level_statement);

1157: p_prefix =>l_debug_prefix,
1158: p_msg_level=>fnd_log.level_statement);
1159: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1160: p_prefix =>l_debug_prefix,
1161: p_msg_level=>fnd_log.level_statement);
1162: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1163: p_prefix =>l_debug_prefix,
1164: p_msg_level=>fnd_log.level_statement);
1165: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 1164: p_msg_level=>fnd_log.level_statement);

1160: p_prefix =>l_debug_prefix,
1161: p_msg_level=>fnd_log.level_statement);
1162: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1163: p_prefix =>l_debug_prefix,
1164: p_msg_level=>fnd_log.level_statement);
1165: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1166: p_prefix =>l_debug_prefix,
1167: p_msg_level=>fnd_log.level_statement);
1168: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 1167: p_msg_level=>fnd_log.level_statement);

1163: p_prefix =>l_debug_prefix,
1164: p_msg_level=>fnd_log.level_statement);
1165: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1166: p_prefix =>l_debug_prefix,
1167: p_msg_level=>fnd_log.level_statement);
1168: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1169: p_prefix =>l_debug_prefix,
1170: p_msg_level=>fnd_log.level_statement);
1171: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

Line 1170: p_msg_level=>fnd_log.level_statement);

1166: p_prefix =>l_debug_prefix,
1167: p_msg_level=>fnd_log.level_statement);
1168: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1169: p_prefix =>l_debug_prefix,
1170: p_msg_level=>fnd_log.level_statement);
1171: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1172: p_prefix =>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_statement);
1174: END IF;

Line 1173: p_msg_level=>fnd_log.level_statement);

1169: p_prefix =>l_debug_prefix,
1170: p_msg_level=>fnd_log.level_statement);
1171: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1172: p_prefix =>l_debug_prefix,
1173: p_msg_level=>fnd_log.level_statement);
1174: END IF;
1175: END IF;
1176:
1177: -- swbhatna: fetch the next set of location information.

Line 1187: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1183: -- swbhatna: exit the loop if we've processed all records
1184: IF cu_loc3b%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
1185: time_put_line('Exiting because of NOTFOUND condition');
1186: time_put_line('Count=' || l_location_ids.COUNT);
1187: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1188: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1189: p_prefix=>'WARNING',
1190: p_msg_level=>fnd_log.level_exception);
1191: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 1190: p_msg_level=>fnd_log.level_exception);

1186: time_put_line('Count=' || l_location_ids.COUNT);
1187: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1188: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1189: p_prefix=>'WARNING',
1190: p_msg_level=>fnd_log.level_exception);
1191: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1192: p_prefix=>'WARNING',
1193: p_msg_level=>fnd_log.level_exception);
1194: END IF;

Line 1193: p_msg_level=>fnd_log.level_exception);

1189: p_prefix=>'WARNING',
1190: p_msg_level=>fnd_log.level_exception);
1191: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1192: p_prefix=>'WARNING',
1193: p_msg_level=>fnd_log.level_exception);
1194: END IF;
1195: EXIT;
1196: END IF;
1197: ELSE -- cu_loc3b/cu_loc3bc, check if p_country is null or not

Line 1200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1196: END IF;
1197: ELSE -- cu_loc3b/cu_loc3bc, check if p_country is null or not
1198: IF NOT cu_loc3bc%ISOPEN THEN
1199: OPEN cu_loc3bc (l_request_id);
1200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1201: hz_utility_v2pub.debug(p_message=>'Opening cursor 3bc with args:',
1202: p_prefix =>l_debug_prefix,
1203: p_msg_level=>fnd_log.level_statement);
1204: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

Line 1203: p_msg_level=>fnd_log.level_statement);

1199: OPEN cu_loc3bc (l_request_id);
1200: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1201: hz_utility_v2pub.debug(p_message=>'Opening cursor 3bc with args:',
1202: p_prefix =>l_debug_prefix,
1203: p_msg_level=>fnd_log.level_statement);
1204: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1205: p_prefix =>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_statement);
1207: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

Line 1206: p_msg_level=>fnd_log.level_statement);

1202: p_prefix =>l_debug_prefix,
1203: p_msg_level=>fnd_log.level_statement);
1204: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),
1205: p_prefix =>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_statement);
1207: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
1208: p_prefix =>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_statement);
1210: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

Line 1209: p_msg_level=>fnd_log.level_statement);

1205: p_prefix =>l_debug_prefix,
1206: p_msg_level=>fnd_log.level_statement);
1207: hz_utility_v2pub.debug(p_message=>'country=' || p_country,
1208: p_prefix =>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_statement);
1210: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1211: p_prefix =>l_debug_prefix,
1212: p_msg_level=>fnd_log.level_statement);
1213: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

Line 1212: p_msg_level=>fnd_log.level_statement);

1208: p_prefix =>l_debug_prefix,
1209: p_msg_level=>fnd_log.level_statement);
1210: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),
1211: p_prefix =>l_debug_prefix,
1212: p_msg_level=>fnd_log.level_statement);
1213: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1214: p_prefix =>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_statement);
1216: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

Line 1215: p_msg_level=>fnd_log.level_statement);

1211: p_prefix =>l_debug_prefix,
1212: p_msg_level=>fnd_log.level_statement);
1213: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),
1214: p_prefix =>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_statement);
1216: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1217: p_prefix =>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_statement);
1219: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

Line 1218: p_msg_level=>fnd_log.level_statement);

1214: p_prefix =>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_statement);
1216: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),
1217: p_prefix =>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_statement);
1219: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;

Line 1221: p_msg_level=>fnd_log.level_statement);

1217: p_prefix =>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_statement);
1219: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;
1223: END IF;
1224:
1225: -- swbhatna: fetch the next set of location information.

Line 1235: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1231: -- swbhatna: exit the loop if we've processed all records
1232: IF cu_loc3bc%NOTFOUND AND l_location_ids.COUNT <= 0 THEN
1233: time_put_line('Exiting because of NOTFOUND condition');
1234: time_put_line('Count=' || l_location_ids.COUNT);
1235: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1236: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1237: p_prefix=>'WARNING',
1238: p_msg_level=>fnd_log.level_exception);
1239: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,

Line 1238: p_msg_level=>fnd_log.level_exception);

1234: time_put_line('Count=' || l_location_ids.COUNT);
1235: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1236: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',
1237: p_prefix=>'WARNING',
1238: p_msg_level=>fnd_log.level_exception);
1239: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1240: p_prefix=>'WARNING',
1241: p_msg_level=>fnd_log.level_exception);
1242: END IF;

Line 1241: p_msg_level=>fnd_log.level_exception);

1237: p_prefix=>'WARNING',
1238: p_msg_level=>fnd_log.level_exception);
1239: hz_utility_v2pub.debug(p_message=>'Count=' || l_location_ids.COUNT,
1240: p_prefix=>'WARNING',
1241: p_msg_level=>fnd_log.level_exception);
1242: END IF;
1243: END IF;
1244: END IF; -- cu_loc3b/cu_loc3bc, check if p_country is null or not
1245: END IF;

Line 1250: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1246:
1247: ELSE
1248: l_return_status := fnd_api.g_ret_sts_unexp_error;
1249: time_put_line('Unexpected mode encountered');
1250: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'Unexpected mode encountered',
1252: p_prefix=>'ERROR',
1253: p_msg_level=>fnd_log.level_error);
1254: END IF;

Line 1253: p_msg_level=>fnd_log.level_error);

1249: time_put_line('Unexpected mode encountered');
1250: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'Unexpected mode encountered',
1252: p_prefix=>'ERROR',
1253: p_msg_level=>fnd_log.level_error);
1254: END IF;
1255: END IF;
1256: -- J. del Callar: exit the loop if no records were fetched the first time
1257: IF l_location_ids.COUNT = 0 THEN

Line 1259: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1255: END IF;
1256: -- J. del Callar: exit the loop if no records were fetched the first time
1257: IF l_location_ids.COUNT = 0 THEN
1258: time_put_line('Exiting because COUNT=0');
1259: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1260: hz_utility_v2pub.debug(p_message=>'Exiting because COUNT=0',
1261: p_prefix=>'WARNING',
1262: p_msg_level=>fnd_log.level_exception);
1263: END IF;

Line 1262: p_msg_level=>fnd_log.level_exception);

1258: time_put_line('Exiting because COUNT=0');
1259: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1260: hz_utility_v2pub.debug(p_message=>'Exiting because COUNT=0',
1261: p_prefix=>'WARNING',
1262: p_msg_level=>fnd_log.level_exception);
1263: END IF;
1264: EXIT;
1265: END IF;
1266:

Line 1272: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1268: IF p_all_partial <> 'ALL' AND cpt_update >= l_nb_row_update THEN
1269: time_put_line('Exiting because partial=' || p_all_partial);
1270: time_put_line('cpt_update=' || cpt_update);
1271: time_put_line('nb_row_update=' || l_nb_row_update);
1272: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1273: hz_utility_v2pub.debug(p_message=>'Exiting because partial=' || p_all_partial,
1274: p_prefix=>'WARNING',
1275: p_msg_level=>fnd_log.level_exception);
1276: hz_utility_v2pub.debug(p_message=>'cpt_update=' || cpt_update,

Line 1275: p_msg_level=>fnd_log.level_exception);

1271: time_put_line('nb_row_update=' || l_nb_row_update);
1272: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1273: hz_utility_v2pub.debug(p_message=>'Exiting because partial=' || p_all_partial,
1274: p_prefix=>'WARNING',
1275: p_msg_level=>fnd_log.level_exception);
1276: hz_utility_v2pub.debug(p_message=>'cpt_update=' || cpt_update,
1277: p_prefix=>'WARNING',
1278: p_msg_level=>fnd_log.level_exception);
1279: hz_utility_v2pub.debug(p_message=>'nb_row_update=' || l_nb_row_update,

Line 1278: p_msg_level=>fnd_log.level_exception);

1274: p_prefix=>'WARNING',
1275: p_msg_level=>fnd_log.level_exception);
1276: hz_utility_v2pub.debug(p_message=>'cpt_update=' || cpt_update,
1277: p_prefix=>'WARNING',
1278: p_msg_level=>fnd_log.level_exception);
1279: hz_utility_v2pub.debug(p_message=>'nb_row_update=' || l_nb_row_update,
1280: p_prefix=>'WARNING',
1281: p_msg_level=>fnd_log.level_exception);
1282: END IF;

Line 1281: p_msg_level=>fnd_log.level_exception);

1277: p_prefix=>'WARNING',
1278: p_msg_level=>fnd_log.level_exception);
1279: hz_utility_v2pub.debug(p_message=>'nb_row_update=' || l_nb_row_update,
1280: p_prefix=>'WARNING',
1281: p_msg_level=>fnd_log.level_exception);
1282: END IF;
1283: EXIT;
1284: END IF;
1285:

Line 1307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1303: l_array(cpt).county := l_counties(i);
1304:
1305: fnd_file.put_line(fnd_file.log,
1306: 'Processing location '||l_array(cpt).location_id);
1307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_message=>'Processing location ' || l_array(cpt).location_id,
1309: p_prefix =>l_debug_prefix,
1310: p_msg_level=>fnd_log.level_statement);
1311: END IF;

Line 1310: p_msg_level=>fnd_log.level_statement);

1306: 'Processing location '||l_array(cpt).location_id);
1307: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_message=>'Processing location ' || l_array(cpt).location_id,
1309: p_prefix =>l_debug_prefix,
1310: p_msg_level=>fnd_log.level_statement);
1311: END IF;
1312:
1313: -- execute the synchronization routine every l_batch_size, or
1314: -- if we have reached the last record to be updated, or

Line 1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1331: );
1332:
1333: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1334: time_put_line('Unexpected error encountered');
1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1336: hz_utility_v2pub.debug(p_message=>'Unexpected error encountered',
1337: p_prefix=>'ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;

Line 1338: p_msg_level=>fnd_log.level_error);

1334: time_put_line('Unexpected error encountered');
1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1336: hz_utility_v2pub.debug(p_message=>'Unexpected error encountered',
1337: p_prefix=>'ERROR',
1338: p_msg_level=>fnd_log.level_error);
1339: END IF;
1340:
1341: -- Close the open cursor (depends on the site use type and the
1342: -- update mode).

Line 1435: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1431:
1432: -- J. del Callar: exit the loop if our update limit has been exceeded.
1433: IF p_all_partial <> 'ALL' AND cpt_update >= l_nb_row_update THEN
1434: time_put_line('Exiting due to update limit.');
1435: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(p_message=>'Exiting due to update limit.',
1437: p_prefix=>'WARNING',
1438: p_msg_level=>fnd_log.level_exception);
1439:

Line 1438: p_msg_level=>fnd_log.level_exception);

1434: time_put_line('Exiting due to update limit.');
1435: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug(p_message=>'Exiting due to update limit.',
1437: p_prefix=>'WARNING',
1438: p_msg_level=>fnd_log.level_exception);
1439:
1440: END IF;
1441: EXIT;
1442: END IF;

Line 1626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1622: fnd_file.put_line(fnd_file.log,
1623: fnd_message.get_string('FND',
1624: 'CONC-CP SUCCESSFUL TERMINATION'));
1625:
1626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1627: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (-)',
1628: p_prefix=>l_debug_prefix,
1629: p_msg_level=>fnd_log.level_procedure);
1630: END IF;

Line 1629: p_msg_level=>fnd_log.level_procedure);

1625:
1626: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1627: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (-)',
1628: p_prefix=>l_debug_prefix,
1629: p_msg_level=>fnd_log.level_procedure);
1630: END IF;
1631:
1632: --disable_debug;
1633:

Line 1644: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1640: fnd_global.local_chr(10);
1641: trace_handler(msg);
1642: END LOOP;
1643: fnd_message.clear;
1644: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1645: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- expect_http_ad)',
1646: p_prefix=>'ERROR',
1647: p_msg_level=>fnd_log.level_error);
1648: END IF;

Line 1647: p_msg_level=>fnd_log.level_error);

1643: fnd_message.clear;
1644: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1645: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- expect_http_ad)',
1646: p_prefix=>'ERROR',
1647: p_msg_level=>fnd_log.level_error);
1648: END IF;
1649: --disable_debug;
1650: retcode := '2';
1651: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1663: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1659: fnd_global.local_chr(10);
1660: trace_handler(msg);
1661: END LOOP;
1662: fnd_message.clear;
1663: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- port_number)',
1665: p_prefix=>'ERROR',
1666: p_msg_level=>fnd_log.level_error);
1667: END IF;

Line 1666: p_msg_level=>fnd_log.level_error);

1662: fnd_message.clear;
1663: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- port_number)',
1665: p_prefix=>'ERROR',
1666: p_msg_level=>fnd_log.level_error);
1667: END IF;
1668: --disable_debug;
1669: retcode := '2';
1670: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1681: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1677: fnd_global.local_chr(10);
1678: trace_handler(msg);
1679: END LOOP;
1680: fnd_message.clear;
1681: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- nlsnumexp)',
1683: p_prefix=>'ERROR',
1684: p_msg_level=>fnd_log.level_error);
1685: END IF;

Line 1684: p_msg_level=>fnd_log.level_error);

1680: fnd_message.clear;
1681: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- nlsnumexp)',
1683: p_prefix=>'ERROR',
1684: p_msg_level=>fnd_log.level_error);
1685: END IF;
1686: --disable_debug;
1687: retcode := '2';
1688: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1695: fnd_global.local_chr(10);
1696: trace_handler(msg);
1697: END LOOP;
1698: fnd_message.clear;
1699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- atleastonerow)',
1701: p_prefix=>'ERROR',
1702: p_msg_level=>fnd_log.level_error);
1703: END IF;

Line 1702: p_msg_level=>fnd_log.level_error);

1698: fnd_message.clear;
1699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- atleastonerow)',
1701: p_prefix=>'ERROR',
1702: p_msg_level=>fnd_log.level_error);
1703: END IF;
1704: --disable_debug;
1705: retcode := '2';
1706: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1718: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1714: fnd_global.local_chr(10);
1715: trace_handler(msg);
1716: END LOOP;
1717: fnd_message.clear;
1718: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1719: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- morethanmaxrow)',
1720: p_prefix=>'ERROR',
1721: p_msg_level=>fnd_log.level_error);
1722: END IF;

Line 1721: p_msg_level=>fnd_log.level_error);

1717: fnd_message.clear;
1718: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1719: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- morethanmaxrow)',
1720: p_prefix=>'ERROR',
1721: p_msg_level=>fnd_log.level_error);
1722: END IF;
1723: --disable_debug;
1724: retcode := '2';
1725: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1734: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1730: fnd_global.local_chr(10);
1731: trace_handler(msg);
1732: END LOOP;
1733: fnd_message.clear;
1734: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- exchttp)',
1736: p_prefix=>'ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;

Line 1737: p_msg_level=>fnd_log.level_error);

1733: fnd_message.clear;
1734: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1735: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- exchttp)',
1736: p_prefix=>'ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;
1739: --disable_debug;
1740: retcode := '2';
1741: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1746: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1742:
1743: WHEN OTHERS THEN
1744: fnd_file.put_line(fnd_file.log, SQLERRM);
1745: msg := SQLERRM;
1746: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1747: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- others)',
1748: p_prefix=>'SQL ERROR',
1749: p_msg_level=>fnd_log.level_error);
1750: hz_utility_v2pub.debug(p_message=>'msg='||SUBSTRB(msg, 1, 250),

Line 1749: p_msg_level=>fnd_log.level_error);

1745: msg := SQLERRM;
1746: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1747: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- others)',
1748: p_prefix=>'SQL ERROR',
1749: p_msg_level=>fnd_log.level_error);
1750: hz_utility_v2pub.debug(p_message=>'msg='||SUBSTRB(msg, 1, 250),
1751: p_prefix=>'SQL ERROR',
1752: p_msg_level=>fnd_log.level_error);
1753: END IF;

Line 1752: p_msg_level=>fnd_log.level_error);

1748: p_prefix=>'SQL ERROR',
1749: p_msg_level=>fnd_log.level_error);
1750: hz_utility_v2pub.debug(p_message=>'msg='||SUBSTRB(msg, 1, 250),
1751: p_prefix=>'SQL ERROR',
1752: p_msg_level=>fnd_log.level_error);
1753: END IF;
1754: --disable_debug;
1755: retcode := '2';
1756: errbuf := fnd_message.get_string('FND', 'CONC-CHECK LOG FOR DETAILS');

Line 1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1888: EXECUTE IMMEDIATE x_drop_index;
1889: -- Create Index
1890: Create_Index;
1891: ELSE /* Index Exists and Valid */
1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1893: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (+)',
1894: p_prefix=>l_debug_prefix,
1895: p_msg_level=>fnd_log.level_procedure);
1896: END IF;

Line 1895: p_msg_level=>fnd_log.level_procedure);

1891: ELSE /* Index Exists and Valid */
1892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1893: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (+)',
1894: p_prefix=>l_debug_prefix,
1895: p_msg_level=>fnd_log.level_procedure);
1896: END IF;
1897: -- Initialize the return code only if we are running as an independent
1898: -- concurrent program. We do not want to change the value of the return
1899: -- code if it has been initialized by the calling program.

Line 1903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1899: -- code if it has been initialized by the calling program.
1900: IF p_concurrent_mode = 'Y' THEN
1901: retcode := '0';
1902: END IF;
1903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'rebuilding with:' || l_rebuild_string,
1905: p_prefix =>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_statement);
1907: END IF;

Line 1906: p_msg_level=>fnd_log.level_statement);

1902: END IF;
1903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'rebuilding with:' || l_rebuild_string,
1905: p_prefix =>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_statement);
1907: END IF;
1908: EXECUTE IMMEDIATE l_rebuild_string;
1909: END IF; /* Index Is Invalid */
1910: END IF; /* Index is Missing */

Line 1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1925: -- otherwise, just push the error onto the stack.
1926: fnd_message.set_name('AR', 'HZ_GEO_INDEX_REBUILT');
1927: fnd_msg_pub.add;
1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
1931: p_prefix=>l_debug_prefix,
1932: p_msg_level=>fnd_log.level_procedure);
1933: END IF;

Line 1932: p_msg_level=>fnd_log.level_procedure);

1928: END IF;
1929: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1930: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
1931: p_prefix=>l_debug_prefix,
1932: p_msg_level=>fnd_log.level_procedure);
1933: END IF;
1934: Close c_index;
1935: --disable_debug;
1936: -- restore previous state: re-enable previously enabled policies

Line 1960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1956: 'CONC-CHECK LOG FOR DETAILS'));
1957: ELSE
1958: fnd_msg_pub.add;
1959: END IF;
1960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>g_pkg_name||' Error:',
1962: p_prefix=>'SQL ERROR',
1963: p_msg_level=>fnd_log.level_error);
1964: hz_utility_v2pub.debug(p_message=>SQLERRM,

Line 1963: p_msg_level=>fnd_log.level_error);

1959: END IF;
1960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1961: hz_utility_v2pub.debug(p_message=>g_pkg_name||' Error:',
1962: p_prefix=>'SQL ERROR',
1963: p_msg_level=>fnd_log.level_error);
1964: hz_utility_v2pub.debug(p_message=>SQLERRM,
1965: p_prefix=>'SQL ERROR',
1966: p_msg_level=>fnd_log.level_error);
1967: END IF;

Line 1966: p_msg_level=>fnd_log.level_error);

1962: p_prefix=>'SQL ERROR',
1963: p_msg_level=>fnd_log.level_error);
1964: hz_utility_v2pub.debug(p_message=>SQLERRM,
1965: p_prefix=>'SQL ERROR',
1966: p_msg_level=>fnd_log.level_error);
1967: END IF;
1968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1969: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
1970: p_prefix=>l_debug_prefix,

Line 1968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1964: hz_utility_v2pub.debug(p_message=>SQLERRM,
1965: p_prefix=>'SQL ERROR',
1966: p_msg_level=>fnd_log.level_error);
1967: END IF;
1968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1969: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
1970: p_prefix=>l_debug_prefix,
1971: p_msg_level=>fnd_log.level_procedure);
1972: END IF;

Line 1971: p_msg_level=>fnd_log.level_procedure);

1967: END IF;
1968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1969: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',
1970: p_prefix=>l_debug_prefix,
1971: p_msg_level=>fnd_log.level_procedure);
1972: END IF;
1973: -- bug fix 3872778 enable policy function
1974: FOR l_count IN 1..l_owners.COUNT LOOP
1975: dbms_rls.enable_policy(l_owners(l_count), l_objects(l_count),