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_GNR_UTIL_PKG dependencies on HZ_UTILITY_V2PUB

Line 34: hz_utility_v2pub.enable_debug;

30: IF g_debug_count = 1 THEN
31: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
32: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
33: THEN
34: hz_utility_v2pub.enable_debug;
35: g_debug := TRUE;
36: END IF;
37: END IF;
38: END enable_debug; -- end procedure

Line 48: hz_utility_v2pub.disable_debug;

44:
45: IF g_debug THEN
46: g_debug_count := g_debug_count - 1;
47: IF g_debug_count = 0 THEN
48: hz_utility_v2pub.disable_debug;
49: g_debug := FALSE;
50: END IF;
51: END IF;
52:

Line 250: HZ_UTILITY_V2PUB

246: be used in GNR program, where it updates the location components.
247:
248: EXTERNAL PROCEDURES/FUNCTIONS ACCESSED :
249: HZ_LOCATION_V2PUB
250: HZ_UTILITY_V2PUB
251: HZ_DQM_SYNC
252: HZ_BUSINESS_EVENT_V2PVT
253: HZ_POPULATE_BOT_PKG
254:

Line 274: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;

270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2
272: ) IS
273:
274: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

Line 275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;

271: x_msg_data OUT NOCOPY VARCHAR2
272: ) IS
273:
274: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

Line 276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;

272: ) IS
273:
274: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;

Line 277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;

273:
274: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

Line 278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

274: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
282: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

Line 279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

275: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
276: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
282: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
283: l_program_update_date DATE; -- hz_utility_v2pub.program_update_date;

Line 281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

277: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
282: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
283: l_program_update_date DATE; -- hz_utility_v2pub.program_update_date;
284:
285: BEGIN

Line 282: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

278: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
282: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
283: l_program_update_date DATE; -- hz_utility_v2pub.program_update_date;
284:
285: BEGIN
286:

Line 283: l_program_update_date DATE; -- hz_utility_v2pub.program_update_date;

279: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
280: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
281: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
282: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
283: l_program_update_date DATE; -- hz_utility_v2pub.program_update_date;
284:
285: BEGIN
286:
287: -- Initialize variables (perf improvement bug 5130993)

Line 288: l_last_updated_by := hz_utility_v2pub.last_updated_by;

284:
285: BEGIN
286:
287: -- Initialize variables (perf improvement bug 5130993)
288: l_last_updated_by := hz_utility_v2pub.last_updated_by;
289: l_creation_date := hz_utility_v2pub.creation_date;
290: l_created_by := hz_utility_v2pub.created_by;
291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;

Line 289: l_creation_date := hz_utility_v2pub.creation_date;

285: BEGIN
286:
287: -- Initialize variables (perf improvement bug 5130993)
288: l_last_updated_by := hz_utility_v2pub.last_updated_by;
289: l_creation_date := hz_utility_v2pub.creation_date;
290: l_created_by := hz_utility_v2pub.created_by;
291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;

Line 290: l_created_by := hz_utility_v2pub.created_by;

286:
287: -- Initialize variables (perf improvement bug 5130993)
288: l_last_updated_by := hz_utility_v2pub.last_updated_by;
289: l_creation_date := hz_utility_v2pub.creation_date;
290: l_created_by := hz_utility_v2pub.created_by;
291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;

Line 291: l_last_update_date := hz_utility_v2pub.last_update_date;

287: -- Initialize variables (perf improvement bug 5130993)
288: l_last_updated_by := hz_utility_v2pub.last_updated_by;
289: l_creation_date := hz_utility_v2pub.creation_date;
290: l_created_by := hz_utility_v2pub.created_by;
291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;
295: l_program_application_id := hz_utility_v2pub.program_application_id;

Line 292: l_last_update_login := hz_utility_v2pub.last_update_login;

288: l_last_updated_by := hz_utility_v2pub.last_updated_by;
289: l_creation_date := hz_utility_v2pub.creation_date;
290: l_created_by := hz_utility_v2pub.created_by;
291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;
295: l_program_application_id := hz_utility_v2pub.program_application_id;
296: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

Line 293: l_program_id := hz_utility_v2pub.program_id;

289: l_creation_date := hz_utility_v2pub.creation_date;
290: l_created_by := hz_utility_v2pub.created_by;
291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;
295: l_program_application_id := hz_utility_v2pub.program_application_id;
296: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
297: l_program_update_date := hz_utility_v2pub.program_update_date;

Line 295: l_program_application_id := hz_utility_v2pub.program_application_id;

291: l_last_update_date := hz_utility_v2pub.last_update_date;
292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;
295: l_program_application_id := hz_utility_v2pub.program_application_id;
296: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
297: l_program_update_date := hz_utility_v2pub.program_update_date;
298:
299: -- update de-normalized location components in HZ_PARTIES for parties

Line 296: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

292: l_last_update_login := hz_utility_v2pub.last_update_login;
293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;
295: l_program_application_id := hz_utility_v2pub.program_application_id;
296: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
297: l_program_update_date := hz_utility_v2pub.program_update_date;
298:
299: -- update de-normalized location components in HZ_PARTIES for parties
300: -- having this location as an identifying location. There can be multiple

Line 297: l_program_update_date := hz_utility_v2pub.program_update_date;

293: l_program_id := hz_utility_v2pub.program_id;
294: l_conc_login_id := fnd_global.conc_login_id;
295: l_program_application_id := hz_utility_v2pub.program_application_id;
296: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
297: l_program_update_date := hz_utility_v2pub.program_update_date;
298:
299: -- update de-normalized location components in HZ_PARTIES for parties
300: -- having this location as an identifying location. There can be multiple
301: -- such parties.

Line 340: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||

336: EXIT WHEN c1%NOTFOUND;
337:
338: -- Debug info.
339: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
340: hz_utility_v2pub.debug(p_message=>'Denormalizing party with ID: ' ||
341: l_party_id,
342: p_prefix =>'INFO:',
343: p_msg_level=>fnd_log.level_statement);
344: END IF;

Line 402: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

398: -- SSM SST Integration and Extension
399: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
400: -- There is no need to check if the data-source is selected.
401: -- l_old_location_rec.orig_system := p_location_rec.orig_system;
402: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
403: HZ_BUSINESS_EVENT_V2PVT.update_location_event (
404: p_new_location_rec,
405: p_old_location_rec);
406: END IF;

Line 408: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

404: p_new_location_rec,
405: p_old_location_rec);
406: END IF;
407:
408: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
409: -- populate function for integration service
410: HZ_POPULATE_BOT_PKG.pop_hz_locations(
411: p_operation => 'U',
412: p_location_id => p_new_location_rec.location_id );

Line 652: hz_utility_v2pub.debug(p_message=>'bfr getMapId()',

648: */
649:
650: -- Debug info.
651: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'bfr getMapId()',
653: p_prefix =>l_debug_prefix,
654: p_msg_level=>fnd_log.level_statement);
655: END IF;
656:

Line 663: hz_utility_v2pub.debug(p_message=>'getMapId() failed',

659: -- given a mapid, get the details of the map
660: IF (x_status <> fnd_api.g_ret_sts_success) THEN
661: -- Debug info.
662: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'getMapId() failed',
664: p_prefix=>'ERROR',
665: p_msg_level=>fnd_log.level_error);
666: END IF;
667:

Line 687: hz_utility_v2pub.debug(p_message=>'in getMapRec Exception blk. No data found',

683: WHEN no_data_found THEN
684:
685: -- Debug info.
686: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
687: hz_utility_v2pub.debug(p_message=>'in getMapRec Exception blk. No data found',
688: p_prefix=>'ERROR',
689: p_msg_level=>fnd_log.level_error);
690: END IF;
691:

Line 896: -- hz_utility_v2pub.debug(p_message=>'***sql for po_vendor_sites:'||l_sql_1,

892: -- Removed PO_VENDOR_SITES_ALL from the below if condition. Bug # 4584465
893: --IF p_loctbl = 'PO_VENDOR_SITES_ALL' THEN
894: -- Debug info.
895: -- IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
896: -- hz_utility_v2pub.debug(p_message=>'***sql for po_vendor_sites:'||l_sql_1,
897: -- p_prefix =>l_debug_prefix,
898: -- p_msg_level=>fnd_log.level_statement);
899: -- END IF;
900: -- execute IMMEDIATE l_sql_1 INTO x_cntry, x_addrstyle USING IN p_locid;

Line 904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,

900: -- execute IMMEDIATE l_sql_1 INTO x_cntry, x_addrstyle USING IN p_locid;
901: IF p_loctbl = 'HZ_LOCATIONS' THEN
902: -- Debug info.
903: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
904: hz_utility_v2pub.debug(p_message=>'***sql for hz_locations'||l_sql_2,
905: p_prefix =>l_debug_prefix,
906: p_msg_level=>fnd_log.level_statement);
907: END IF;
908: execute IMMEDIATE l_sql_2 INTO x_cntry, x_addrstyle USING IN p_locid;

Line 912: hz_utility_v2pub.debug(p_message=>'***sql for HR_LOCATIONS_ALL'||l_sql_3,

908: execute IMMEDIATE l_sql_2 INTO x_cntry, x_addrstyle USING IN p_locid;
909: ELSIF p_loctbl = 'HR_LOCATIONS_ALL' THEN
910: -- Debug info.
911: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'***sql for HR_LOCATIONS_ALL'||l_sql_3,
913: p_prefix =>l_debug_prefix,
914: p_msg_level=>fnd_log.level_statement);
915: END IF;
916: execute IMMEDIATE l_sql_3 INTO x_cntry, x_addrstyle USING IN p_locid;

Line 922: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() when tbl name is invalid',

918: -- this means that the supplied table name is not supported by gnr in hz.k
919: x_status := fnd_api.G_RET_STS_ERROR;
920: -- Debug info.
921: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
922: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() when tbl name is invalid',
923: p_prefix=>'ERROR',
924: p_msg_level=>fnd_log.level_error);
925: END IF;
926: mesglog(p_locid,p_loctbl,'HZ_GEO_LOC_TABLE_INVALID', NULL, NULL, NULL, NULL);

Line 932: hz_utility_v2pub.debug(p_message=>'country code is null',

928: END IF;
929: IF (x_cntry IS NULL) THEN
930: -- Debug info.
931: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
932: hz_utility_v2pub.debug(p_message=>'country code is null',
933: p_prefix=>'ERROR',
934: p_msg_level=>fnd_log.level_error);
935: END IF;
936: x_status := fnd_api.G_RET_STS_ERROR;

Line 960: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() in no data found',

956: WHEN no_data_found THEN
957: x_status := fnd_api.G_RET_STS_ERROR;
958: -- Debug info.
959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
960: hz_utility_v2pub.debug(p_message=>'***bfr mesglog() in no data found',
961: p_prefix=>'ERROR',
962: p_msg_level=>fnd_log.level_error);
963: END IF;
964: mesglog(p_locid,p_loctbl,'HZ_GEO_NO_LOC_REC', 'LOC_ID',p_locid, 'TABLE_NAME', p_loctbl);

Line 1014: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;

1010: x_status OUT NOCOPY varchar2
1011: ) IS
1012: l_debug_prefix VARCHAR2(30) := '';
1013:
1014: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

Line 1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;

1011: ) IS
1012: l_debug_prefix VARCHAR2(30) := '';
1013:
1014: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

Line 1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;

1012: l_debug_prefix VARCHAR2(30) := '';
1013:
1014: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1020: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;

Line 1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;

1013:
1014: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1020: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1021: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

Line 1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

1014: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1020: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1021: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1022: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

Line 1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

1015: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1016: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1020: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1021: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1022: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
1023:

Line 1021: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

1017: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1020: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1021: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1022: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
1023:
1024: BEGIN
1025:

Line 1022: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

1018: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1019: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1020: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1021: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1022: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
1023:
1024: BEGIN
1025:
1026: /*

Line 1033: l_last_updated_by := hz_utility_v2pub.last_updated_by;

1029: 2. loop through the table of records and insert
1030: */
1031:
1032: -- Initialize variables (perf improvement bug 5130993)
1033: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1034: l_creation_date := hz_utility_v2pub.creation_date;
1035: l_created_by := hz_utility_v2pub.created_by;
1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;

Line 1034: l_creation_date := hz_utility_v2pub.creation_date;

1030: */
1031:
1032: -- Initialize variables (perf improvement bug 5130993)
1033: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1034: l_creation_date := hz_utility_v2pub.creation_date;
1035: l_created_by := hz_utility_v2pub.created_by;
1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;

Line 1035: l_created_by := hz_utility_v2pub.created_by;

1031:
1032: -- Initialize variables (perf improvement bug 5130993)
1033: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1034: l_creation_date := hz_utility_v2pub.creation_date;
1035: l_created_by := hz_utility_v2pub.created_by;
1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;
1039: l_conc_login_id := fnd_global.conc_login_id;

Line 1036: l_last_update_date := hz_utility_v2pub.last_update_date;

1032: -- Initialize variables (perf improvement bug 5130993)
1033: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1034: l_creation_date := hz_utility_v2pub.creation_date;
1035: l_created_by := hz_utility_v2pub.created_by;
1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;
1039: l_conc_login_id := fnd_global.conc_login_id;
1040: l_program_application_id := hz_utility_v2pub.program_application_id;

Line 1037: l_last_update_login := hz_utility_v2pub.last_update_login;

1033: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1034: l_creation_date := hz_utility_v2pub.creation_date;
1035: l_created_by := hz_utility_v2pub.created_by;
1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;
1039: l_conc_login_id := fnd_global.conc_login_id;
1040: l_program_application_id := hz_utility_v2pub.program_application_id;
1041: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

Line 1038: l_program_id := hz_utility_v2pub.program_id;

1034: l_creation_date := hz_utility_v2pub.creation_date;
1035: l_created_by := hz_utility_v2pub.created_by;
1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;
1039: l_conc_login_id := fnd_global.conc_login_id;
1040: l_program_application_id := hz_utility_v2pub.program_application_id;
1041: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1042:

Line 1040: l_program_application_id := hz_utility_v2pub.program_application_id;

1036: l_last_update_date := hz_utility_v2pub.last_update_date;
1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;
1039: l_conc_login_id := fnd_global.conc_login_id;
1040: l_program_application_id := hz_utility_v2pub.program_application_id;
1041: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1042:
1043: -- initializing the return status
1044: x_status := fnd_api.g_ret_sts_success;

Line 1041: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

1037: l_last_update_login := hz_utility_v2pub.last_update_login;
1038: l_program_id := hz_utility_v2pub.program_id;
1039: l_conc_login_id := fnd_global.conc_login_id;
1040: l_program_application_id := hz_utility_v2pub.program_application_id;
1041: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1042:
1043: -- initializing the return status
1044: x_status := fnd_api.g_ret_sts_success;
1045:

Line 1052: hz_utility_v2pub.debug(p_message=>'deleting loc id, table name combo from gnr',

1048:
1049:
1050: -- Debug info.
1051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'deleting loc id, table name combo from gnr',
1053: p_prefix =>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_statement);
1055: hz_utility_v2pub.debug(p_message=>'bfr delgnr()',
1056: p_prefix =>l_debug_prefix,

Line 1055: hz_utility_v2pub.debug(p_message=>'bfr delgnr()',

1051: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1052: hz_utility_v2pub.debug(p_message=>'deleting loc id, table name combo from gnr',
1053: p_prefix =>l_debug_prefix,
1054: p_msg_level=>fnd_log.level_statement);
1055: hz_utility_v2pub.debug(p_message=>'bfr delgnr()',
1056: p_prefix =>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_statement);
1058: END IF;
1059:

Line 1065: hz_utility_v2pub.debug(p_message=>'aft delGnr()',

1061: delgnr(p_locid,p_loctbl,x_status);
1062:
1063: -- Debug info.
1064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.debug(p_message=>'aft delGnr()',
1066: p_prefix =>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_statement);
1068: END IF;
1069:

Line 1095: hz_utility_v2pub.debug(p_message=>'error in ins gnr rec',

1091: WHEN others THEN
1092:
1093: -- Debug info.
1094: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1095: hz_utility_v2pub.debug(p_message=>'error in ins gnr rec',
1096: p_prefix=>'ERROR',
1097: p_msg_level=>fnd_log.level_error);
1098: END IF;
1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1100: hz_utility_v2pub.debug(p_message=>'loc id:'||p_locid,

1096: p_prefix=>'ERROR',
1097: p_msg_level=>fnd_log.level_error);
1098: END IF;
1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1100: hz_utility_v2pub.debug(p_message=>'loc id:'||p_locid,
1101: p_prefix =>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_statement);
1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,
1104: p_prefix =>l_debug_prefix,

Line 1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,

1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1100: hz_utility_v2pub.debug(p_message=>'loc id:'||p_locid,
1101: p_prefix =>l_debug_prefix,
1102: p_msg_level=>fnd_log.level_statement);
1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,
1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,
1107: p_prefix =>l_debug_prefix,

Line 1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,

1102: p_msg_level=>fnd_log.level_statement);
1103: hz_utility_v2pub.debug(p_message=>'loc tbl:'||p_loctbl,
1104: p_prefix =>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,
1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'loc comp geo id:'||p_maptbl(i).geography_id,
1110: p_prefix =>l_debug_prefix,

Line 1109: hz_utility_v2pub.debug(p_message=>'loc comp geo id:'||p_maptbl(i).geography_id,

1105: p_msg_level=>fnd_log.level_statement);
1106: hz_utility_v2pub.debug(p_message=>'loc comp type:'||p_maptbl(i).geography_type,
1107: p_prefix =>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_statement);
1109: hz_utility_v2pub.debug(p_message=>'loc comp geo id:'||p_maptbl(i).geography_id,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: END IF;
1113:

Line 1127: hz_utility_v2pub.debug(p_message=>'in gnrIns() excep blk',

1123: WHEN others THEN
1124:
1125: -- Debug info.
1126: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1127: hz_utility_v2pub.debug(p_message=>'in gnrIns() excep blk',
1128: p_prefix =>l_debug_prefix,
1129: p_msg_level=>fnd_log.level_statement);
1130: END IF;
1131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1132: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,

1128: p_prefix =>l_debug_prefix,
1129: p_msg_level=>fnd_log.level_statement);
1130: END IF;
1131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1133: p_prefix=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136:

Line 1181: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;

1177:
1178: l_status varchar2(1);
1179: l_debug_prefix VARCHAR2(30) := '';
1180:
1181: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

Line 1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;

1178: l_status varchar2(1);
1179: l_debug_prefix VARCHAR2(30) := '';
1180:
1181: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

Line 1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;

1179: l_debug_prefix VARCHAR2(30) := '';
1180:
1181: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1187: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;

Line 1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;

1180:
1181: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1187: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1188: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

Line 1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

1181: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1187: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1188: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1189: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

Line 1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

1182: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
1183: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1187: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1188: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1189: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
1190:

Line 1188: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

1184: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1187: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1188: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1189: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
1190:
1191: BEGIN
1192: -- Check if API is called in debug mode. If yes, enable debug.

Line 1189: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

1185: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
1186: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
1187: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
1188: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
1189: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
1190:
1191: BEGIN
1192: -- Check if API is called in debug mode. If yes, enable debug.
1193: --enable_debug;

Line 1203: l_last_updated_by := hz_utility_v2pub.last_updated_by;

1199: --
1200: -- 3. insert the record in the GNRL
1201:
1202: -- Initialize variables (perf improvement bug 5130993)
1203: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1204: l_creation_date := hz_utility_v2pub.creation_date;
1205: l_created_by := hz_utility_v2pub.created_by;
1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;

Line 1204: l_creation_date := hz_utility_v2pub.creation_date;

1200: -- 3. insert the record in the GNRL
1201:
1202: -- Initialize variables (perf improvement bug 5130993)
1203: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1204: l_creation_date := hz_utility_v2pub.creation_date;
1205: l_created_by := hz_utility_v2pub.created_by;
1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;

Line 1205: l_created_by := hz_utility_v2pub.created_by;

1201:
1202: -- Initialize variables (perf improvement bug 5130993)
1203: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1204: l_creation_date := hz_utility_v2pub.creation_date;
1205: l_created_by := hz_utility_v2pub.created_by;
1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;
1209: l_conc_login_id := fnd_global.conc_login_id;

Line 1206: l_last_update_date := hz_utility_v2pub.last_update_date;

1202: -- Initialize variables (perf improvement bug 5130993)
1203: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1204: l_creation_date := hz_utility_v2pub.creation_date;
1205: l_created_by := hz_utility_v2pub.created_by;
1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;
1209: l_conc_login_id := fnd_global.conc_login_id;
1210: l_program_application_id := hz_utility_v2pub.program_application_id;

Line 1207: l_last_update_login := hz_utility_v2pub.last_update_login;

1203: l_last_updated_by := hz_utility_v2pub.last_updated_by;
1204: l_creation_date := hz_utility_v2pub.creation_date;
1205: l_created_by := hz_utility_v2pub.created_by;
1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;
1209: l_conc_login_id := fnd_global.conc_login_id;
1210: l_program_application_id := hz_utility_v2pub.program_application_id;
1211: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

Line 1208: l_program_id := hz_utility_v2pub.program_id;

1204: l_creation_date := hz_utility_v2pub.creation_date;
1205: l_created_by := hz_utility_v2pub.created_by;
1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;
1209: l_conc_login_id := fnd_global.conc_login_id;
1210: l_program_application_id := hz_utility_v2pub.program_application_id;
1211: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1212:

Line 1210: l_program_application_id := hz_utility_v2pub.program_application_id;

1206: l_last_update_date := hz_utility_v2pub.last_update_date;
1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;
1209: l_conc_login_id := fnd_global.conc_login_id;
1210: l_program_application_id := hz_utility_v2pub.program_application_id;
1211: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1212:
1213: -- initializing the return status
1214: l_status := fnd_api.g_ret_sts_success;

Line 1211: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

1207: l_last_update_login := hz_utility_v2pub.last_update_login;
1208: l_program_id := hz_utility_v2pub.program_id;
1209: l_conc_login_id := fnd_global.conc_login_id;
1210: l_program_application_id := hz_utility_v2pub.program_application_id;
1211: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
1212:
1213: -- initializing the return status
1214: l_status := fnd_api.g_ret_sts_success;
1215:

Line 1219: hz_utility_v2pub.debug(p_message=>'in gnrl(), bfr deleting locid, tbl nm combo',

1215:
1216:
1217: -- Debug info.
1218: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1219: hz_utility_v2pub.debug(p_message=>'in gnrl(), bfr deleting locid, tbl nm combo',
1220: p_prefix =>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_statement);
1222: END IF;
1223:

Line 1234: hz_utility_v2pub.debug(p_message=>'excep when deleting locid, tbl nm combo frm gnrl tbl',

1230: WHEN others THEN
1231:
1232: -- Debug info.
1233: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'excep when deleting locid, tbl nm combo frm gnrl tbl',
1235: p_prefix =>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_statement);
1237: END IF;
1238:

Line 1257: hz_utility_v2pub.debug(p_message=>'bfr delGNR()',

1253: IF (p_mapStatus = FND_API.G_RET_STS_ERROR) THEN
1254:
1255: -- Debug info.
1256: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug(p_message=>'bfr delGNR()',
1258: p_prefix =>l_debug_prefix,
1259: p_msg_level=>fnd_log.level_statement);
1260: END IF;
1261:

Line 1266: hz_utility_v2pub.debug(p_message=>'aft delGNR()',

1262: delGNR(p_locid,p_loctbl, l_status);
1263:
1264: -- Debug info.
1265: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1266: hz_utility_v2pub.debug(p_message=>'aft delGNR()',
1267: p_prefix =>l_debug_prefix,
1268: p_msg_level=>fnd_log.level_statement);
1269: END IF;
1270:

Line 1293: hz_utility_v2pub.debug(p_message=>'unable to insert into GNRL tbl',

1289: ELSE
1290:
1291: -- Debug info.
1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'unable to insert into GNRL tbl',
1294: p_prefix=>'ERROR',
1295: p_msg_level=>fnd_log.level_error);
1296: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1297: p_prefix=>'ERROR',

Line 1296: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,

1292: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'unable to insert into GNRL tbl',
1294: p_prefix=>'ERROR',
1295: p_msg_level=>fnd_log.level_error);
1296: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1297: p_prefix=>'ERROR',
1298: p_msg_level=>fnd_log.level_error);
1299: END IF;
1300:

Line 1311: hz_utility_v2pub.debug(p_message=>'in gnrl excep blk',

1307: WHEN others THEN
1308:
1309: -- Debug info.
1310: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'in gnrl excep blk',
1312: p_prefix =>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_statement);
1314: END IF;
1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1316: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,

1312: p_prefix =>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_statement);
1314: END IF;
1315: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'sqlerrm:'||sqlerrm,
1317: p_prefix=>'ERROR',
1318: p_msg_level=>fnd_log.level_error);
1319: END IF;
1320:

Line 1732: hz_utility_v2pub.debug

1728: l_debug_prefix VARCHAR2(30);
1729: BEGIN
1730:
1731: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1732: hz_utility_v2pub.debug
1733: (p_message => 'Begin of getAddrValStatus procedure',
1734: p_prefix => l_debug_prefix,
1735: p_msg_level => fnd_log.level_procedure,
1736: p_module_prefix => l_module_prefix,

Line 1746: hz_utility_v2pub.debug

1742: l_missing_elements := NULL;
1743: -- If the map status = 'S' returm addr_val_status as 'S'
1744: IF x_map_status = 'S' then
1745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1746: hz_utility_v2pub.debug
1747: (p_message => ' Map status is S. So, return address validation status as S ',
1748: p_prefix => l_debug_prefix,
1749: p_msg_level => fnd_log.level_statement,
1750: p_module_prefix => l_module_prefix,

Line 1758: hz_utility_v2pub.debug

1754: RETURN l_addr_val_status;
1755: -- If the called from is GNR returm addr_val_status as x_return_status
1756: ELSIF p_called_from = 'GNR' then
1757: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1758: hz_utility_v2pub.debug
1759: (p_message => ' Called from is GNR. So, return address validation status and return status as S ',
1760: p_prefix => l_debug_prefix,
1761: p_msg_level => fnd_log.level_statement,
1762: p_module_prefix => l_module_prefix,

Line 1771: hz_utility_v2pub.debug

1767: RETURN l_addr_val_status;
1768: -- If the map status is 'E' and called from is <> GNR
1769: ELSE
1770: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1771: hz_utility_v2pub.debug
1772: (p_message => ' Map status is E. Check for address validation level.',
1773: p_prefix => l_debug_prefix,
1774: p_msg_level => fnd_log.level_statement,
1775: p_module_prefix => l_module_prefix,

Line 1782: hz_utility_v2pub.debug

1778: END IF;
1779: -- If validation level is NONE, return addr_val_status as 'S'
1780: IF p_addr_val_level = 'NONE' then
1781: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1782: hz_utility_v2pub.debug
1783: (p_message => ' Address validation level is NONE. So, return address validation status and return status as S',
1784: p_prefix => l_debug_prefix,
1785: p_msg_level => fnd_log.level_statement,
1786: p_module_prefix => l_module_prefix,

Line 1798: hz_utility_v2pub.debug

1794: -- If validation level is ERROR, return addr_val_status as 'E'
1795: -- also set the message with the missing parameters.
1796: ELSIF p_addr_val_level = 'ERROR' then
1797: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1798: hz_utility_v2pub.debug
1799: (p_message => ' Address validation level is ERROR.',
1800: p_prefix => l_debug_prefix,
1801: p_msg_level => fnd_log.level_statement,
1802: p_module_prefix => l_module_prefix,

Line 1823: hz_utility_v2pub.debug

1819: i := p_mdu_tbl.NEXT(i);
1820: END LOOP;
1821: END IF;
1822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1823: hz_utility_v2pub.debug
1824: (p_message => 'Please enter valid address elements : '||l_missing_elements,
1825: p_prefix => l_debug_prefix,
1826: p_msg_level => fnd_log.level_statement,
1827: p_module_prefix => l_module_prefix,

Line 1840: hz_utility_v2pub.debug

1836: -- If yes, set the addr_val_status to 'W' and return status to 'S'
1837: -- If not, set the message with the missing parameters
1838: ELSIF p_addr_val_level = 'WARNING' then
1839: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1840: hz_utility_v2pub.debug
1841: (p_message => ' Address validation level is WARNING.',
1842: p_prefix => l_debug_prefix,
1843: p_msg_level => fnd_log.level_statement,
1844: p_module_prefix => l_module_prefix,

Line 1880: hz_utility_v2pub.debug

1876: FND_MESSAGE.SET_TOKEN('P_ALL_ELEMENTS', l_invalid_elements);
1877: x_addr_warn_msg := FND_MESSAGE.get;
1878: x_status := fnd_api.g_ret_sts_success;
1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1880: hz_utility_v2pub.debug
1881: (p_message => 'These address elements are not validated : '||l_invalid_elements,
1882: p_prefix => l_debug_prefix,
1883: p_msg_level => fnd_log.level_statement,
1884: p_module_prefix => l_module_prefix,

Line 1894: -- hz_utility_v2pub.debug

1890: -- FND_MESSAGE.SET_TOKEN('P_MISSING_ELEMENTS', l_missing_elements);
1891: -- FND_MSG_PUB.ADD;
1892: -- x_status := l_addr_val_status;
1893: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1894: -- hz_utility_v2pub.debug
1895: -- (p_message => 'Please enter required address elements : '||l_missing_elements,
1896: -- p_prefix => l_debug_prefix,
1897: -- p_msg_level => fnd_log.level_statement,
1898: -- p_module_prefix => l_module_prefix,

Line 1913: hz_utility_v2pub.debug

1909: -- If yes, set the addr_val_status to 'S' and return status to 'S'
1910: -- If not, set the message with the missing parameters
1911: ELSIF p_addr_val_level = 'MINIMUM' then
1912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1913: hz_utility_v2pub.debug
1914: (p_message => ' Address validation level is MINIMUM.',
1915: p_prefix => l_debug_prefix,
1916: p_msg_level => fnd_log.level_statement,
1917: p_module_prefix => l_module_prefix,

Line 1946: hz_utility_v2pub.debug

1942: -- hk_debugl('Please enter required address elements: '|| l_missing_elements);
1943: -- hk_debugl('l_addr_val_status : '|| l_addr_val_status);
1944: x_status := l_addr_val_status;
1945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1946: hz_utility_v2pub.debug
1947: (p_message => 'Please enter required address elements : '||l_missing_elements,
1948: p_prefix => l_debug_prefix,
1949: p_msg_level => fnd_log.level_statement,
1950: p_module_prefix => l_module_prefix,

Line 2053: hz_utility_v2pub.debug

2049: l_debug_prefix VARCHAR2(30);
2050: BEGIN
2051:
2052: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2053: hz_utility_v2pub.debug
2054: (p_message => 'Begin of fill_values procedure',
2055: p_prefix => l_debug_prefix,
2056: p_msg_level => fnd_log.level_procedure,
2057: p_module_prefix => l_module_prefix,

Line 2078: hz_utility_v2pub.debug

2074: i := x_map_dtls_tbl.NEXT(i);
2075: END LOOP;
2076: END IF;
2077: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2078: hz_utility_v2pub.debug
2079: (p_message => 'End of fill_values procedure',
2080: p_prefix => l_debug_prefix,
2081: p_msg_level => fnd_log.level_procedure,
2082: p_module_prefix => l_module_prefix,

Line 2556: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;

2552: l_debug_prefix VARCHAR2(30) := p_location_id;
2553: l_retain_flag VARCHAR2(10);
2554: l_map_dtls_tbl maploc_rec_tbl_type;
2555:
2556: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

Line 2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;

2553: l_retain_flag VARCHAR2(10);
2554: l_map_dtls_tbl maploc_rec_tbl_type;
2555:
2556: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

Line 2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;

2554: l_map_dtls_tbl maploc_rec_tbl_type;
2555:
2556: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
2562: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;

Line 2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;

2555:
2556: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
2562: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
2563: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

Line 2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

2556: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
2562: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
2563: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
2564: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

Line 2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

2557: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
2558: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
2562: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
2563: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
2564: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
2565: l_api_purpose VARCHAR2(30);

Line 2563: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

2559: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
2562: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
2563: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
2564: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
2565: l_api_purpose VARCHAR2(30);
2566:
2567: -- Created below 2 cursors for performance reasons (perf team advice)

Line 2564: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

2560: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
2561: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
2562: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
2563: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
2564: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
2565: l_api_purpose VARCHAR2(30);
2566:
2567: -- Created below 2 cursors for performance reasons (perf team advice)
2568: -- to avoid DUP_VAL_ON_INDEX exception which is proving very costly

Line 2716: l_last_updated_by := hz_utility_v2pub.last_updated_by;

2712:
2713: BEGIN
2714:
2715: -- Initialize variables (perf improvement bug 5130993)
2716: l_last_updated_by := hz_utility_v2pub.last_updated_by;
2717: l_creation_date := hz_utility_v2pub.creation_date;
2718: l_created_by := hz_utility_v2pub.created_by;
2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;

Line 2717: l_creation_date := hz_utility_v2pub.creation_date;

2713: BEGIN
2714:
2715: -- Initialize variables (perf improvement bug 5130993)
2716: l_last_updated_by := hz_utility_v2pub.last_updated_by;
2717: l_creation_date := hz_utility_v2pub.creation_date;
2718: l_created_by := hz_utility_v2pub.created_by;
2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;

Line 2718: l_created_by := hz_utility_v2pub.created_by;

2714:
2715: -- Initialize variables (perf improvement bug 5130993)
2716: l_last_updated_by := hz_utility_v2pub.last_updated_by;
2717: l_creation_date := hz_utility_v2pub.creation_date;
2718: l_created_by := hz_utility_v2pub.created_by;
2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;
2722: l_conc_login_id := fnd_global.conc_login_id;

Line 2719: l_last_update_date := hz_utility_v2pub.last_update_date;

2715: -- Initialize variables (perf improvement bug 5130993)
2716: l_last_updated_by := hz_utility_v2pub.last_updated_by;
2717: l_creation_date := hz_utility_v2pub.creation_date;
2718: l_created_by := hz_utility_v2pub.created_by;
2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;
2722: l_conc_login_id := fnd_global.conc_login_id;
2723: l_program_application_id := hz_utility_v2pub.program_application_id;

Line 2720: l_last_update_login := hz_utility_v2pub.last_update_login;

2716: l_last_updated_by := hz_utility_v2pub.last_updated_by;
2717: l_creation_date := hz_utility_v2pub.creation_date;
2718: l_created_by := hz_utility_v2pub.created_by;
2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;
2722: l_conc_login_id := fnd_global.conc_login_id;
2723: l_program_application_id := hz_utility_v2pub.program_application_id;
2724: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

Line 2721: l_program_id := hz_utility_v2pub.program_id;

2717: l_creation_date := hz_utility_v2pub.creation_date;
2718: l_created_by := hz_utility_v2pub.created_by;
2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;
2722: l_conc_login_id := fnd_global.conc_login_id;
2723: l_program_application_id := hz_utility_v2pub.program_application_id;
2724: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
2725: l_api_purpose := HZ_GNR_PKG.G_API_PURPOSE;

Line 2723: l_program_application_id := hz_utility_v2pub.program_application_id;

2719: l_last_update_date := hz_utility_v2pub.last_update_date;
2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;
2722: l_conc_login_id := fnd_global.conc_login_id;
2723: l_program_application_id := hz_utility_v2pub.program_application_id;
2724: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
2725: l_api_purpose := HZ_GNR_PKG.G_API_PURPOSE;
2726:
2727: x_status := FND_API.g_ret_sts_success;

Line 2724: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

2720: l_last_update_login := hz_utility_v2pub.last_update_login;
2721: l_program_id := hz_utility_v2pub.program_id;
2722: l_conc_login_id := fnd_global.conc_login_id;
2723: l_program_application_id := hz_utility_v2pub.program_application_id;
2724: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
2725: l_api_purpose := HZ_GNR_PKG.G_API_PURPOSE;
2726:
2727: x_status := FND_API.g_ret_sts_success;
2728:

Line 2741: hz_utility_v2pub.debug

2737: l_retain_flag := retain_gnr_yn(p_location_id, p_map_status, p_map_dtls_tbl);
2738: END IF;
2739:
2740: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2741: hz_utility_v2pub.debug
2742: (p_message => 'Retain GNR Flag value l_retain_flag='||l_retain_flag,
2743: p_prefix => l_debug_prefix,
2744: p_msg_level => fnd_log.level_statement,
2745: p_module_prefix => l_module_prefix,

Line 2766: hz_utility_v2pub.debug

2762:
2763: IF (l_gnr_log_exist <> 'Y') THEN
2764:
2765: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2766: hz_utility_v2pub.debug
2767: (p_message => 'Before inserting record into hz_geo_name_reference_log with map status '||p_map_status,
2768: p_prefix => l_debug_prefix,
2769: p_msg_level => fnd_log.level_statement,
2770: p_module_prefix => l_module_prefix,

Line 2791: hz_utility_v2pub.debug

2787: l_last_update_login, l_program_id,
2788: l_conc_login_id, l_program_application_id, l_request_id);
2789:
2790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2791: hz_utility_v2pub.debug
2792: (p_message => 'After inserting record into hz_geo_name_reference_log ',
2793: p_prefix => l_debug_prefix,
2794: p_msg_level => fnd_log.level_statement,
2795: p_module_prefix => l_module_prefix,

Line 2803: hz_utility_v2pub.debug

2799:
2800: ELSE -- GNR Log already exists, we will update it
2801:
2802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2803: hz_utility_v2pub.debug
2804: (p_message => 'Before updating record into hz_geo_name_reference_log with map status '||p_map_status,
2805: p_prefix => l_debug_prefix,
2806: p_msg_level => fnd_log.level_statement,
2807: p_module_prefix => l_module_prefix,

Line 2823: hz_utility_v2pub.debug

2819: AND location_table_name = p_location_table_name
2820: AND usage_code = p_usage_code;
2821:
2822: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2823: hz_utility_v2pub.debug
2824: (p_message => 'After updating record into hz_geo_name_reference_log ',
2825: p_prefix => l_debug_prefix,
2826: p_msg_level => fnd_log.level_statement,
2827: p_module_prefix => l_module_prefix,

Line 2844: hz_utility_v2pub.debug

2840: END IF; -- end of check if l_gnr_log_exist
2841:
2842: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN -- should not hit this error anymore (bug 5929771)
2843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2844: hz_utility_v2pub.debug
2845: (p_message => 'EXCEPTION DUP_VAL_ON_INDEX during GNR Log insert/update for '||
2846: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||
2847: ' -'||SUBSTR(SQLERRM,1,100),
2848: p_prefix => l_debug_prefix,

Line 2862: hz_utility_v2pub.debug

2858:
2859: i := p_map_dtls_tbl.FIRST;
2860:
2861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2862: hz_utility_v2pub.debug
2863: (p_message => 'Before inserting records into hz_geo_name_references ',
2864: p_prefix => l_debug_prefix,
2865: p_msg_level => fnd_log.level_statement,
2866: p_module_prefix => l_module_prefix,

Line 2901: hz_utility_v2pub.debug

2897: CLOSE c_check_gnr_exist;
2898: END IF;
2899:
2900: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2901: hz_utility_v2pub.debug
2902: (p_message => 'For Location Id:'||p_location_id||',geo type:'||
2903: p_map_dtls_tbl(i).geography_type||', GNR Exists :'||l_gnr_exist,
2904: p_prefix => l_debug_prefix,
2905: p_msg_level => fnd_log.level_statement,

Line 2929: hz_utility_v2pub.debug

2925: END IF;
2926:
2927: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN -- should not hit this error anymore (bug 5929771)
2928: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2929: hz_utility_v2pub.debug
2930: (p_message => 'EXCEPTION DUP_VAL_ON_INDEX during GNR insert/update for '||
2931: 'Location Id:'||p_location_id||',geo_type:'||p_map_dtls_tbl(i).geography_type||
2932: ' -'||SUBSTR(SQLERRM,1,100),
2933: p_prefix => l_debug_prefix,

Line 2950: hz_utility_v2pub.debug

2946: i := p_map_dtls_tbl.NEXT(i);
2947: END LOOP;
2948:
2949: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2950: hz_utility_v2pub.debug
2951: (p_message => 'After inserting records into hz_geo_name_references ',
2952: p_prefix => l_debug_prefix,
2953: p_msg_level => fnd_log.level_statement,
2954: p_module_prefix => l_module_prefix,

Line 2969: hz_utility_v2pub.debug

2965: AND
2966: update_loc_yn(p_loc_components_rec,l_map_dtls_tbl) = 'Y')) THEN
2967:
2968: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2969: hz_utility_v2pub.debug
2970: (p_message => 'Before updating record into update_location ',
2971: p_prefix => l_debug_prefix,
2972: p_msg_level => fnd_log.level_statement,
2973: p_module_prefix => l_module_prefix,

Line 2981: hz_utility_v2pub.debug

2977:
2978: update_location (p_location_id, p_loc_components_rec,p_lock_flag, l_map_dtls_tbl,x_status);
2979:
2980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2981: hz_utility_v2pub.debug
2982: (p_message => 'After updating record into update_location ',
2983: p_prefix => l_debug_prefix,
2984: p_msg_level => fnd_log.level_statement,
2985: p_module_prefix => l_module_prefix,

Line 2997: hz_utility_v2pub.debug

2993:
2994: EXCEPTION WHEN OTHERS THEN
2995: x_status := fnd_api.g_ret_sts_unexp_error;
2996: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
2997: hz_utility_v2pub.debug
2998: (p_message => 'EXCEPTION during create_gnr for '||
2999: 'Location Id:'||p_location_id||',usage_code:'||p_usage_code||
3000: ' -'||SUBSTR(SQLERRM,1,100),
3001: p_prefix => l_debug_prefix,

Line 3037: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;

3033: l_usage_log_exists varchar2(1);
3034: l_geography_id number;
3035: i number;
3036:
3037: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

Line 3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;

3034: l_geography_id number;
3035: i number;
3036:
3037: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

Line 3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;

3035: i number;
3036:
3037: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
3043: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;

Line 3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;

3036:
3037: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
3043: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
3044: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

Line 3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;

3037: l_last_updated_by NUMBER; -- hz_utility_v2pub.last_updated_by;
3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
3043: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
3044: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
3045: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

Line 3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;

3038: l_creation_date DATE; -- hz_utility_v2pub.creation_date;
3039: l_created_by NUMBER; -- hz_utility_v2pub.created_by;
3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
3043: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
3044: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
3045: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
3046:

Line 3044: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;

3040: l_last_update_date DATE; -- hz_utility_v2pub.last_update_date;
3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
3043: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
3044: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
3045: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
3046:
3047: BEGIN
3048:

Line 3045: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);

3041: l_last_update_login NUMBER; -- hz_utility_v2pub.last_update_login;
3042: l_program_id NUMBER; -- hz_utility_v2pub.program_id;
3043: l_conc_login_id NUMBER; -- fnd_global.conc_login_id;
3044: l_program_application_id NUMBER; --hz_utility_v2pub.program_application_id;
3045: l_request_id NUMBER; -- NVL(hz_utility_v2pub.request_id, -1);
3046:
3047: BEGIN
3048:
3049: -- Initialize variables (perf improvement bug 5130993)

Line 3050: l_last_updated_by := hz_utility_v2pub.last_updated_by;

3046:
3047: BEGIN
3048:
3049: -- Initialize variables (perf improvement bug 5130993)
3050: l_last_updated_by := hz_utility_v2pub.last_updated_by;
3051: l_creation_date := hz_utility_v2pub.creation_date;
3052: l_created_by := hz_utility_v2pub.created_by;
3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;

Line 3051: l_creation_date := hz_utility_v2pub.creation_date;

3047: BEGIN
3048:
3049: -- Initialize variables (perf improvement bug 5130993)
3050: l_last_updated_by := hz_utility_v2pub.last_updated_by;
3051: l_creation_date := hz_utility_v2pub.creation_date;
3052: l_created_by := hz_utility_v2pub.created_by;
3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;

Line 3052: l_created_by := hz_utility_v2pub.created_by;

3048:
3049: -- Initialize variables (perf improvement bug 5130993)
3050: l_last_updated_by := hz_utility_v2pub.last_updated_by;
3051: l_creation_date := hz_utility_v2pub.creation_date;
3052: l_created_by := hz_utility_v2pub.created_by;
3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;
3056: l_conc_login_id := fnd_global.conc_login_id;

Line 3053: l_last_update_date := hz_utility_v2pub.last_update_date;

3049: -- Initialize variables (perf improvement bug 5130993)
3050: l_last_updated_by := hz_utility_v2pub.last_updated_by;
3051: l_creation_date := hz_utility_v2pub.creation_date;
3052: l_created_by := hz_utility_v2pub.created_by;
3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;
3056: l_conc_login_id := fnd_global.conc_login_id;
3057: l_program_application_id := hz_utility_v2pub.program_application_id;

Line 3054: l_last_update_login := hz_utility_v2pub.last_update_login;

3050: l_last_updated_by := hz_utility_v2pub.last_updated_by;
3051: l_creation_date := hz_utility_v2pub.creation_date;
3052: l_created_by := hz_utility_v2pub.created_by;
3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;
3056: l_conc_login_id := fnd_global.conc_login_id;
3057: l_program_application_id := hz_utility_v2pub.program_application_id;
3058: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

Line 3055: l_program_id := hz_utility_v2pub.program_id;

3051: l_creation_date := hz_utility_v2pub.creation_date;
3052: l_created_by := hz_utility_v2pub.created_by;
3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;
3056: l_conc_login_id := fnd_global.conc_login_id;
3057: l_program_application_id := hz_utility_v2pub.program_application_id;
3058: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
3059:

Line 3057: l_program_application_id := hz_utility_v2pub.program_application_id;

3053: l_last_update_date := hz_utility_v2pub.last_update_date;
3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;
3056: l_conc_login_id := fnd_global.conc_login_id;
3057: l_program_application_id := hz_utility_v2pub.program_application_id;
3058: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
3059:
3060: x_status := FND_API.g_ret_sts_success;
3061:

Line 3058: l_request_id := NVL(hz_utility_v2pub.request_id, -1);

3054: l_last_update_login := hz_utility_v2pub.last_update_login;
3055: l_program_id := hz_utility_v2pub.program_id;
3056: l_conc_login_id := fnd_global.conc_login_id;
3057: l_program_application_id := hz_utility_v2pub.program_application_id;
3058: l_request_id := NVL(hz_utility_v2pub.request_id, -1);
3059:
3060: x_status := FND_API.g_ret_sts_success;
3061:
3062: l_success := 'N';