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 HZ_UTILITY_V2PUB

Line 16: -- HZ_UTILITY_V2PUB.enable_debug

12: -- PRIVATE PROCEDURE enable_debug
13: -- DESCRIPTION
14: -- Turn on debug mode.
15: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
16: -- HZ_UTILITY_V2PUB.enable_debug
17: -- MODIFICATION HISTORY
18: -- 01-10-2002 Herve Yu
19: --------------------------------------
20: /*PROCEDURE enable_debug IS

Line 27: hz_utility_v2pub.enable_debug;

23: IF G_DEBUG_COUNT = 1 THEN
24: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
25: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
26: THEN
27: hz_utility_v2pub.enable_debug;
28: g_debug := TRUE;
29: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' THEN
30: g_file_debug := TRUE;
31: END IF;

Line 42: -- HZ_UTILITY_V2PUB.disable_debug

38: -- PRIVATE PROCEDURE disable_debug
39: -- DESCRIPTION
40: -- Turn off debug mode.
41: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
42: -- HZ_UTILITY_V2PUB.disable_debug
43: -- MODIFICATION HISTORY
44: -- 01-10-2002 Herve Yu
45: --------------------------------------
46: /*PROCEDURE disable_debug IS

Line 51: hz_utility_v2pub.disable_debug;

47: BEGIN
48: IF g_debug THEN
49: g_debug_count := g_debug_count - 1;
50: IF g_debug_count = 0 THEN
51: hz_utility_v2pub.disable_debug;
52: g_debug := FALSE;
53: g_file_debug := FALSE;
54: END IF;
55: END IF;

Line 98: -- hz_utility_v2pub.debug

94: -- DESCRIPTION
95: -- Utility routine for performance testing. Prints the argument with
96: -- a timestamp.
97: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
98: -- hz_utility_v2pub.debug
99: -- MODIFICATION HISTORY
100: -- 01-10-2002 J. del Callar
101: --------------------------------------
102: /*PROCEDURE time_put_line (msg IN VARCHAR2) IS

Line 109: hz_utility_v2pub.debug(TO_CHAR(SYSDATE, 'HH:MI:SS') ||

105: fnd_file.put_line(fnd_file.log,
106: TO_CHAR(SYSDATE, 'HH:MI:SS') ||
107: ': ' || SUBSTRB(msg, 1, 240));
108: ELSE
109: hz_utility_v2pub.debug(TO_CHAR(SYSDATE, 'HH:MI:SS') ||
110: ': ' || SUBSTRB(msg, 1, 240));
111: END IF;
112: END time_put_line;
113: */

Line 141: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'||

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

Line 154: hz_utility_v2pub.debug(p_message=>'No Record found : 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;
158: ELSE

Line 160: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for location_id :' ||

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

Line 238: hz_utility_v2pub.debug(p_message=>'Location successfully updated for location_id :'||TO_CHAR(p_location_id),

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;
242: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 243: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_row for 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);
247: END IF;

Line 264: hz_utility_v2pub.debug(p_message=>'hz_locations_pkg.update_geo_location for location_id :'

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

Line 277: -- hz_utility_v2pub

273: -- DESCRIPTION
274: -- Synchronized geometry in hz_locations with latitude and longitude from
275: -- Oracle's eLocation service.
276: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
277: -- hz_utility_v2pub
278: -- fnd_message
279: -- fnd_msg_pub
280: -- MODIFICATION HISTORY
281: -- 01-10-2002 H. Yu Created.

Line 528: l_request_id NUMBER := hz_utility_v2pub.request_id;

524: atleastonerow EXCEPTION;
525: msg VARCHAR2(2000);
526: l_return_status VARCHAR2(10);
527: l_set_size NUMBER;
528: l_request_id NUMBER := hz_utility_v2pub.request_id;
529: i NUMBER;
530: l_nb_retries NUMBER := NVL(p_nb_try, 3);
531: l_batch_size NUMBER := NVL(p_nb_row, hz_geocode_pkg.g_max_rows);
532: l_retcode VARCHAR2(10);

Line 545: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (+)',

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

Line 582: hz_utility_v2pub.debug(p_message=>'At least one row error.',

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;
586: RAISE atleastonerow;

Line 599: hz_utility_v2pub.debug(p_message=>'HTTP address missing',

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;
603: RAISE expect_http_ad;

Line 645: hz_utility_v2pub.debug(p_message=>'HZ_GEOCODE_WEBSITE: ' || l_http_ad,

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

Line 648: hz_utility_v2pub.debug(p_message=>l_proxy_var || ': ' || l_proxy,

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

Line 651: hz_utility_v2pub.debug(p_message=>l_port_var || ': ' || l_port,

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

Line 684: hz_utility_v2pub.debug(p_message=>'Opening cursor 1a with args:',

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'),
688: p_prefix =>l_debug_prefix,

Line 687: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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'),
691: p_prefix =>l_debug_prefix,

Line 690: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
694: p_prefix =>l_debug_prefix,

Line 693: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
697: p_prefix =>l_debug_prefix,

Line 696: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 713: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
717: p_prefix=>'WARNING',

Line 716: hz_utility_v2pub.debug(p_message=>'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;
720: EXIT;

Line 726: hz_utility_v2pub.debug(p_message=>'Opening cursor 1ac with args:',

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'),
730: p_prefix =>l_debug_prefix,

Line 729: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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

Line 732: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

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'),
736: p_prefix =>l_debug_prefix,

Line 735: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
739: p_prefix =>l_debug_prefix,

Line 738: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
742: p_prefix =>l_debug_prefix,

Line 741: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 758: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
762: p_prefix=>'WARNING',

Line 761: hz_utility_v2pub.debug(p_message=>'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;
765: EXIT;

Line 776: hz_utility_v2pub.debug(p_message=>'Opening cursor 1b with args:',

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'),
780: p_prefix =>l_debug_prefix,

Line 779: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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'),
783: p_prefix =>l_debug_prefix,

Line 782: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
786: p_prefix =>l_debug_prefix,

Line 785: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
789: p_prefix =>l_debug_prefix,

Line 788: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 805: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
809: p_prefix=>'WARNING',

Line 808: hz_utility_v2pub.debug(p_message=>'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;
812: EXIT;

Line 818: hz_utility_v2pub.debug(p_message=>'Opening cursor 1bc with args:',

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'),
822: p_prefix =>l_debug_prefix,

Line 821: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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

Line 824: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

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'),
828: p_prefix =>l_debug_prefix,

Line 827: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
831: p_prefix =>l_debug_prefix,

Line 830: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
834: p_prefix =>l_debug_prefix,

Line 833: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 850: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
854: p_prefix=>'WARNING',

Line 853: hz_utility_v2pub.debug(p_message=>'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;
857: EXIT;

Line 868: hz_utility_v2pub.debug(p_message=>'Opening cursor 2a with args:',

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'),
872: p_prefix =>l_debug_prefix,

Line 871: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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'),
875: p_prefix =>l_debug_prefix,

Line 874: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
878: p_prefix =>l_debug_prefix,

Line 877: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
881: p_prefix =>l_debug_prefix,

Line 880: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 897: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
901: p_prefix=>'WARNING',

Line 900: hz_utility_v2pub.debug(p_message=>'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;
904: EXIT;

Line 910: hz_utility_v2pub.debug(p_message=>'Opening cursor 2ac with args:',

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'),
914: p_prefix =>l_debug_prefix,

Line 913: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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

Line 916: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

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'),
920: p_prefix =>l_debug_prefix,

Line 919: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
923: p_prefix =>l_debug_prefix,

Line 922: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
926: p_prefix =>l_debug_prefix,

Line 925: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 942: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
946: p_prefix=>'WARNING',

Line 945: hz_utility_v2pub.debug(p_message=>'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;
949: EXIT;

Line 960: hz_utility_v2pub.debug(p_message=>'Opening cursor 2b with args:',

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'),
964: p_prefix =>l_debug_prefix,

Line 963: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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'),
967: p_prefix =>l_debug_prefix,

Line 966: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
970: p_prefix =>l_debug_prefix,

Line 969: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
973: p_prefix =>l_debug_prefix,

Line 972: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 989: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
993: p_prefix=>'WARNING',

Line 992: hz_utility_v2pub.debug(p_message=>'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;
996: EXIT;

Line 1002: hz_utility_v2pub.debug(p_message=>'Opening cursor 2bc with args:',

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'),
1006: p_prefix =>l_debug_prefix,

Line 1005: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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

Line 1008: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

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'),
1012: p_prefix =>l_debug_prefix,

Line 1011: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
1015: p_prefix =>l_debug_prefix,

Line 1014: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
1018: p_prefix =>l_debug_prefix,

Line 1017: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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

Line 1034: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
1038: p_prefix=>'WARNING',

Line 1037: hz_utility_v2pub.debug(p_message=>'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;
1041: EXIT;

Line 1058: hz_utility_v2pub.debug(p_message=>'Opening cursor 3a with args:',

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'),
1062: p_prefix =>l_debug_prefix,

Line 1061: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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'),
1065: p_prefix =>l_debug_prefix,

Line 1064: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
1068: p_prefix =>l_debug_prefix,

Line 1067: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
1071: p_prefix =>l_debug_prefix,

Line 1070: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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'),
1074: p_prefix =>l_debug_prefix,

Line 1073: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

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

Line 1090: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
1094: p_prefix=>'WARNING',

Line 1093: hz_utility_v2pub.debug(p_message=>'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;
1097: EXIT;

Line 1103: hz_utility_v2pub.debug(p_message=>'Opening cursor 3ac with args:',

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'),
1107: p_prefix =>l_debug_prefix,

Line 1106: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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

Line 1109: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

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'),
1113: p_prefix =>l_debug_prefix,

Line 1112: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
1116: p_prefix =>l_debug_prefix,

Line 1115: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
1119: p_prefix =>l_debug_prefix,

Line 1118: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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'),
1122: p_prefix =>l_debug_prefix,

Line 1121: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

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

Line 1138: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
1142: p_prefix=>'WARNING',

Line 1141: hz_utility_v2pub.debug(p_message=>'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;
1145: END IF;

Line 1156: hz_utility_v2pub.debug(p_message=>'Opening cursor 3b with args:',

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'),
1160: p_prefix =>l_debug_prefix,

Line 1159: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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'),
1163: p_prefix =>l_debug_prefix,

Line 1162: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
1166: p_prefix =>l_debug_prefix,

Line 1165: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
1169: p_prefix =>l_debug_prefix,

Line 1168: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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'),
1172: p_prefix =>l_debug_prefix,

Line 1171: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

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

Line 1188: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
1192: p_prefix=>'WARNING',

Line 1191: hz_utility_v2pub.debug(p_message=>'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;
1195: EXIT;

Line 1201: hz_utility_v2pub.debug(p_message=>'Opening cursor 3bc with args:',

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'),
1205: p_prefix =>l_debug_prefix,

Line 1204: hz_utility_v2pub.debug(p_message=>'site_use_type=' || NVL(p_site_use_type,'NULL'),

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

Line 1207: hz_utility_v2pub.debug(p_message=>'country=' || p_country,

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'),
1211: p_prefix =>l_debug_prefix,

Line 1210: hz_utility_v2pub.debug(p_message=>'iden_addr_only=' || NVL(p_iden_addr_only,'NULL'),

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'),
1214: p_prefix =>l_debug_prefix,

Line 1213: hz_utility_v2pub.debug(p_message=>'request_id=' || NVL(TO_CHAR(l_request_id), 'NULL'),

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'),
1217: p_prefix =>l_debug_prefix,

Line 1216: hz_utility_v2pub.debug(p_message=>'incremental=' || NVL(p_incremental, 'NULL'),

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'),
1220: p_prefix =>l_debug_prefix,

Line 1219: hz_utility_v2pub.debug(p_message=>'loc_type=' || NVL(p_loc_type, 'NULL'),

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

Line 1236: hz_utility_v2pub.debug(p_message=>'Exiting because of NOTFOUND condition',

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,
1240: p_prefix=>'WARNING',

Line 1239: hz_utility_v2pub.debug(p_message=>'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;
1243: END IF;

Line 1251: hz_utility_v2pub.debug(p_message=>'Unexpected mode encountered',

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

Line 1260: hz_utility_v2pub.debug(p_message=>'Exiting because COUNT=0',

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;
1264: EXIT;

Line 1273: hz_utility_v2pub.debug(p_message=>'Exiting because partial=' || p_all_partial,

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,
1277: p_prefix=>'WARNING',

Line 1276: hz_utility_v2pub.debug(p_message=>'cpt_update=' || cpt_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,
1280: p_prefix=>'WARNING',

Line 1279: hz_utility_v2pub.debug(p_message=>'nb_row_update=' || l_nb_row_update,

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

Line 1308: hz_utility_v2pub.debug(p_message=>'Processing location ' || l_array(cpt).location_id,

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

Line 1336: hz_utility_v2pub.debug(p_message=>'Unexpected error encountered',

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

Line 1436: hz_utility_v2pub.debug(p_message=>'Exiting due to update limit.',

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

Line 1627: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (-)',

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

Line 1645: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- expect_http_ad)',

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;
1649: --disable_debug;

Line 1664: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- port_number)',

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;
1668: --disable_debug;

Line 1682: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- nlsnumexp)',

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;
1686: --disable_debug;

Line 1700: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- atleastonerow)',

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;
1704: --disable_debug;

Line 1719: hz_utility_v2pub.debug(p_message=>g_pkg_name ||'.update_geometry (- morethanmaxrow)',

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;
1723: --disable_debug;

Line 1735: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- exchttp)',

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;
1739: --disable_debug;

Line 1747: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.update_geometry (- others)',

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),
1751: p_prefix=>'SQL ERROR',

Line 1750: hz_utility_v2pub.debug(p_message=>'msg='||SUBSTRB(msg, 1, 250),

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;
1754: --disable_debug;

Line 1766: -- hz_utility_v2pub

1762: -- Rebuilds the spatial index on HZ_LOCATIONS.GEOMETRY. Rebuilding the
1763: -- spatial index is required so that the index performs adequately and
1764: -- that queries can accurately extract the spatial data.
1765: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1766: -- hz_utility_v2pub
1767: -- fnd_message
1768: -- fnd_msg_pub
1769: -- ARGUMENTS
1770: -- IN:

Line 1893: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_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;
1897: -- Initialize the return code only if we are running as an independent

Line 1904: hz_utility_v2pub.debug(p_message=>'rebuilding with:' || l_rebuild_string,

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;
1908: EXECUTE IMMEDIATE l_rebuild_string;

Line 1930: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',

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;
1934: Close c_index;

Line 1961: hz_utility_v2pub.debug(p_message=>g_pkg_name||' Error:',

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

Line 1964: hz_utility_v2pub.debug(p_message=>SQLERRM,

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;
1968: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1969: hz_utility_v2pub.debug(p_message=>g_pkg_name||'.rebuild_location_index (-)',

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;
1973: -- bug fix 3872778 enable policy function