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

Line 102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

98: l_type5 VARCHAR2(30);
99:
100: BEGIN
101:
102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
103: hz_utility_v2pub.debug
104: (p_message => 'Begin of Validate for Map',
105: p_prefix => l_debug_prefix,
106: p_msg_level => fnd_log.level_procedure,

Line 106: p_msg_level => fnd_log.level_procedure,

102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
103: hz_utility_v2pub.debug
104: (p_message => 'Begin of Validate for Map',
105: p_prefix => l_debug_prefix,
106: p_msg_level => fnd_log.level_procedure,
107: p_module_prefix => l_module_prefix,
108: p_module => l_module
109: );
110: END IF;

Line 130: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

126:
127: IF HZ_GNR_UTIL_PKG.getLocCompCount(L_MAP_DTLS_TBL) = 0 THEN
128: --hk_debugl('HZ_GNR_UTIL_PKG.getLocCompCount = 0');
129:
130: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
131: hz_utility_v2pub.debug
132: (p_message => ' HZ_GNR_UTIL_PKG.getLocCompCount = 0 ',
133: p_prefix => l_debug_prefix,
134: p_msg_level => fnd_log.level_statement,

Line 134: p_msg_level => fnd_log.level_statement,

130: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
131: hz_utility_v2pub.debug
132: (p_message => ' HZ_GNR_UTIL_PKG.getLocCompCount = 0 ',
133: p_prefix => l_debug_prefix,
134: p_msg_level => fnd_log.level_statement,
135: p_module_prefix => l_module_prefix,
136: p_module => l_module
137: );
138: END IF;

Line 145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

141: --Following call will try to derive missing lower level compoents
142: IF HZ_GNR_UTIL_PKG.fix_child(L_MAP_DTLS_TBL) = FALSE THEN
143: x_cause := 'MISSING_CHILD';
144:
145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
146: hz_utility_v2pub.debug
147: (p_message => ' x_cause : '||x_cause,
148: p_prefix => l_debug_prefix,
149: p_msg_level => fnd_log.level_statement,

Line 149: p_msg_level => fnd_log.level_statement,

145: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
146: hz_utility_v2pub.debug
147: (p_message => ' x_cause : '||x_cause,
148: p_prefix => l_debug_prefix,
149: p_msg_level => fnd_log.level_statement,
150: p_module_prefix => l_module_prefix,
151: p_module => l_module
152: );
153: END IF;

Line 160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

156: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
157: RETURN;
158: ELSE
159:
160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
161: hz_utility_v2pub.debug
162: (p_message => ' Derived the missing lower level compoents ',
163: p_prefix => l_debug_prefix,
164: p_msg_level => fnd_log.level_statement,

Line 164: p_msg_level => fnd_log.level_statement,

160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
161: hz_utility_v2pub.debug
162: (p_message => ' Derived the missing lower level compoents ',
163: p_prefix => l_debug_prefix,
164: p_msg_level => fnd_log.level_statement,
165: p_module_prefix => l_module_prefix,
166: p_module => l_module
167: );
168: END IF;

Line 217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

213: l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MAP_DTLS_TBL,x_status);
214: --hk_debugl('The SQL query');
215: --hk_debugl(l_sql);
216:
217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
218: hz_utility_v2pub.debug
219: (p_message => ' The SQL query : '||l_sql,
220: p_prefix => l_debug_prefix,
221: p_msg_level => fnd_log.level_statement,

Line 221: p_msg_level => fnd_log.level_statement,

217: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
218: hz_utility_v2pub.debug
219: (p_message => ' The SQL query : '||l_sql,
220: p_prefix => l_debug_prefix,
221: p_msg_level => fnd_log.level_statement,
222: p_module_prefix => l_module_prefix,
223: p_module => l_module
224: );
225: END IF;

Line 231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

227: OPEN c_getGeo FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id
228: ,l_type2,l_value2,l_type3,l_value3,l_type4,l_value4,l_type5,l_value5,l_geography_type;
229: --hk_debugl('Before the first fetch');
230:
231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
232: hz_utility_v2pub.debug
233: (p_message => ' Before the first fetch',
234: p_prefix => l_debug_prefix,
235: p_msg_level => fnd_log.level_statement,

Line 235: p_msg_level => fnd_log.level_statement,

231: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
232: hz_utility_v2pub.debug
233: (p_message => ' Before the first fetch',
234: p_prefix => l_debug_prefix,
235: p_msg_level => fnd_log.level_statement,
236: p_module_prefix => l_module_prefix,
237: p_module => l_module
238: );
239: END IF;

Line 246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

242: FETCH c_getGeo INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
243: ,L_MAP_DTLS_TBL(2).GEOGRAPHY_ID,L_MAP_DTLS_TBL(3).GEOGRAPHY_ID,L_MAP_DTLS_TBL(4).GEOGRAPHY_ID,L_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
244: IF c_getGeo%NOTFOUND THEN
245:
246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
247: hz_utility_v2pub.debug
248: (p_message => ' NOT FOUND of the first fetch',
249: p_prefix => l_debug_prefix,
250: p_msg_level => fnd_log.level_statement,

Line 250: p_msg_level => fnd_log.level_statement,

246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
247: hz_utility_v2pub.debug
248: (p_message => ' NOT FOUND of the first fetch',
249: p_prefix => l_debug_prefix,
250: p_msg_level => fnd_log.level_statement,
251: p_module_prefix => l_module_prefix,
252: p_module => l_module
253: );
254: END IF;

Line 266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

262: x_status := FND_API.G_RET_STS_ERROR;
263: ELSE
264: --Fetching once more to see where there are multiple records
265:
266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
267: hz_utility_v2pub.debug
268: (p_message => ' Fetching once more to see where there are multiple records ',
269: p_prefix => l_debug_prefix,
270: p_msg_level => fnd_log.level_statement,

Line 270: p_msg_level => fnd_log.level_statement,

266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
267: hz_utility_v2pub.debug
268: (p_message => ' Fetching once more to see where there are multiple records ',
269: p_prefix => l_debug_prefix,
270: p_msg_level => fnd_log.level_statement,
271: p_module_prefix => l_module_prefix,
272: p_module => l_module
273: );
274: END IF;

Line 286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

282: l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MAP_DTLS_TBL,x_status);
283: OPEN c_getGeo1 FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id
284: ,l_type2,l_value2,l_type3,l_value3,l_type4,l_value4,l_type5,l_value5,l_geography_type;
285:
286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
287: hz_utility_v2pub.debug
288: (p_message => 'Before the fetch of the query with identifier type as NAME after multiple match found',
289: p_prefix => l_debug_prefix,
290: p_msg_level => fnd_log.level_statement,

Line 290: p_msg_level => fnd_log.level_statement,

286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
287: hz_utility_v2pub.debug
288: (p_message => 'Before the fetch of the query with identifier type as NAME after multiple match found',
289: p_prefix => l_debug_prefix,
290: p_msg_level => fnd_log.level_statement,
291: p_module_prefix => l_module_prefix,
292: p_module => l_module
293: );
294: END IF;

Line 305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

301: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
302: ,L_MAP_DTLS_TBL(2).GEOGRAPHY_ID,L_MAP_DTLS_TBL(3).GEOGRAPHY_ID,L_MAP_DTLS_TBL(4).GEOGRAPHY_ID,L_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
303: IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)
304:
305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
306: hz_utility_v2pub.debug
307: (p_message => 'MAP-Able to found a unique record or a record with multiple parent flag = Y with identifier type as NAME',
308: p_prefix => l_debug_prefix,
309: p_msg_level => fnd_log.level_statement,

Line 309: p_msg_level => fnd_log.level_statement,

305: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
306: hz_utility_v2pub.debug
307: (p_message => 'MAP-Able to found a unique record or a record with multiple parent flag = Y with identifier type as NAME',
308: p_prefix => l_debug_prefix,
309: p_msg_level => fnd_log.level_statement,
310: p_module_prefix => l_module_prefix,
311: p_module => l_module
312: );
313: END IF;

Line 317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

313: END IF;
314:
315: ELSE -- Not able to find a unique record with identifier type as NAME
316:
317: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
318: hz_utility_v2pub.debug
319: (p_message => 'MAP-Not able to find a record with with identifier type as NAME. '||
320: ' More than 1 rec exists with same STANDARD NAME',
321: p_prefix => l_debug_prefix,

Line 322: p_msg_level => fnd_log.level_statement,

318: hz_utility_v2pub.debug
319: (p_message => 'MAP-Not able to find a record with with identifier type as NAME. '||
320: ' More than 1 rec exists with same STANDARD NAME',
321: p_prefix => l_debug_prefix,
322: p_msg_level => fnd_log.level_statement,
323: p_module_prefix => l_module_prefix,
324: p_module => l_module
325: );
326: END IF;

Line 336: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

332:
333: ELSE -- Not able to found a unique record with identifier type as NAME
334: x_cause := 'MULTIPLE_MATCH';
335:
336: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
337: hz_utility_v2pub.debug
338: (p_message => ' Not able to find a record with with identifier type as NAME. x_cause : '||x_cause,
339: p_prefix => l_debug_prefix,
340: p_msg_level => fnd_log.level_statement,

Line 340: p_msg_level => fnd_log.level_statement,

336: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
337: hz_utility_v2pub.debug
338: (p_message => ' Not able to find a record with with identifier type as NAME. x_cause : '||x_cause,
339: p_prefix => l_debug_prefix,
340: p_msg_level => fnd_log.level_statement,
341: p_module_prefix => l_module_prefix,
342: p_module => l_module
343: );
344: END IF;

Line 353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

349: CLOSE c_getGeo1;
350:
351: ELSE -- a unique record or a record with multiple parent flag = Y is found
352:
353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
354: hz_utility_v2pub.debug
355: (p_message => ' A unique record or a record with multiple parent flag = Y is found ',
356: p_prefix => l_debug_prefix,
357: p_msg_level => fnd_log.level_statement,

Line 357: p_msg_level => fnd_log.level_statement,

353: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
354: hz_utility_v2pub.debug
355: (p_message => ' A unique record or a record with multiple parent flag = Y is found ',
356: p_prefix => l_debug_prefix,
357: p_msg_level => fnd_log.level_statement,
358: p_module_prefix => l_module_prefix,
359: p_module => l_module
360: );
361: END IF;

Line 370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

366: IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,L_MAP_DTLS_TBL) = TRUE THEN
367: NULL; -- a unique record is found
368: ELSE -- Multiple parent case not able to find a unique record
369:
370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
371: hz_utility_v2pub.debug
372: (p_message => ' Multiple parent case not able to find a unique record',
373: p_prefix => l_debug_prefix,
374: p_msg_level => fnd_log.level_statement,

Line 374: p_msg_level => fnd_log.level_statement,

370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
371: hz_utility_v2pub.debug
372: (p_message => ' Multiple parent case not able to find a unique record',
373: p_prefix => l_debug_prefix,
374: p_msg_level => fnd_log.level_statement,
375: p_module_prefix => l_module_prefix,
376: p_module => l_module
377: );
378: END IF;

Line 384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

380: x_cause := 'MULTIPLE_PARENT';
381: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
382: x_status := FND_API.G_RET_STS_ERROR;
383:
384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
385: hz_utility_v2pub.debug
386: (p_message => ' x_cause : '||x_cause,
387: p_prefix => l_debug_prefix,
388: p_msg_level => fnd_log.level_statement,

Line 388: p_msg_level => fnd_log.level_statement,

384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
385: hz_utility_v2pub.debug
386: (p_message => ' x_cause : '||x_cause,
387: p_prefix => l_debug_prefix,
388: p_msg_level => fnd_log.level_statement,
389: p_module_prefix => l_module_prefix,
390: p_module => l_module
391: );
392: END IF;

Line 399: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

395: END IF;
396:
397: ELSE -- a unique record is found
398:
399: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
400: hz_utility_v2pub.debug
401: (p_message => 'A unique record is found ',
402: p_prefix => l_debug_prefix,
403: p_msg_level => fnd_log.level_statement,

Line 403: p_msg_level => fnd_log.level_statement,

399: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
400: hz_utility_v2pub.debug
401: (p_message => 'A unique record is found ',
402: p_prefix => l_debug_prefix,
403: p_msg_level => fnd_log.level_statement,
404: p_module_prefix => l_module_prefix,
405: p_module => l_module
406: );
407: END IF;

Line 416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

412:
413: CLOSE c_getGeo;
414:
415:
416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
417: hz_utility_v2pub.debug
418: (p_message => ' Calling fix_child. This call will try to derive missing lower level compoents.',
419: p_prefix => l_debug_prefix,
420: p_msg_level => fnd_log.level_statement,

Line 420: p_msg_level => fnd_log.level_statement,

416: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
417: hz_utility_v2pub.debug
418: (p_message => ' Calling fix_child. This call will try to derive missing lower level compoents.',
419: p_prefix => l_debug_prefix,
420: p_msg_level => fnd_log.level_statement,
421: p_module_prefix => l_module_prefix,
422: p_module => l_module
423: );
424: END IF;

Line 430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

426: --Following call will try to derive missing lower level compoents
427: IF HZ_GNR_UTIL_PKG.fix_child(L_MAP_DTLS_TBL) = FALSE THEN
428: x_cause := 'MISSING_CHILD';
429:
430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
431: hz_utility_v2pub.debug
432: (p_message => ' x_cause : '||x_cause,
433: p_prefix => l_debug_prefix,
434: p_msg_level => fnd_log.level_statement,

Line 434: p_msg_level => fnd_log.level_statement,

430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
431: hz_utility_v2pub.debug
432: (p_message => ' x_cause : '||x_cause,
433: p_prefix => l_debug_prefix,
434: p_msg_level => fnd_log.level_statement,
435: p_module_prefix => l_module_prefix,
436: p_module => l_module
437: );
438: END IF;

Line 447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

443: END IF;
444:
445: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
446:
447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
448: hz_utility_v2pub.debug
449: (p_message => 'End of Validate for Map',
450: p_prefix => l_debug_prefix,
451: p_msg_level => fnd_log.level_procedure,

Line 451: p_msg_level => fnd_log.level_procedure,

447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
448: hz_utility_v2pub.debug
449: (p_message => 'End of Validate for Map',
450: p_prefix => l_debug_prefix,
451: p_msg_level => fnd_log.level_procedure,
452: p_module_prefix => l_module_prefix,
453: p_module => l_module
454: );
455: END IF;

Line 548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

544: L_MDU_TBL := G_MDU_TBL10000;
545: L_MAP_DTLS_TBL := G_MAP_DTLS_TBL;
546: l_get_addr_val := 'N';
547:
548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
549: hz_utility_v2pub.debug
550: (p_message => 'Begin of validation for '||L_USAGE_CODE,
551: p_prefix => l_debug_prefix,
552: p_msg_level => fnd_log.level_procedure,

Line 552: p_msg_level => fnd_log.level_procedure,

548: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
549: hz_utility_v2pub.debug
550: (p_message => 'Begin of validation for '||L_USAGE_CODE,
551: p_prefix => l_debug_prefix,
552: p_msg_level => fnd_log.level_procedure,
553: p_module_prefix => l_module_prefix,
554: p_module => l_module
555: );
556: END IF;

Line 564: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

560: IF HZ_GNR_UTIL_PKG.check_GNR_For_Usage(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,
561: L_USAGE_CODE,L_MDU_TBL,x_status) = TRUE THEN
562: --hk_debugl('After check_GNR_For_Usage with status :- '||x_status);
563:
564: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
565: hz_utility_v2pub.debug
566: (p_message => 'There is already a procedded success record in GNR log table.',
567: p_prefix => l_debug_prefix,
568: p_msg_level => fnd_log.level_statement,

Line 568: p_msg_level => fnd_log.level_statement,

564: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
565: hz_utility_v2pub.debug
566: (p_message => 'There is already a procedded success record in GNR log table.',
567: p_prefix => l_debug_prefix,
568: p_msg_level => fnd_log.level_statement,
569: p_module_prefix => l_module_prefix,
570: p_module => l_module
571: );
572: END IF;

Line 580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

576: RETURN;
577: END IF;
578: END IF;
579:
580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
581: hz_utility_v2pub.debug
582: (p_message => 'Not able to find an existing success record in GNR log table.',
583: p_prefix => l_debug_prefix,
584: p_msg_level => fnd_log.level_statement,

Line 584: p_msg_level => fnd_log.level_statement,

580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
581: hz_utility_v2pub.debug
582: (p_message => 'Not able to find an existing success record in GNR log table.',
583: p_prefix => l_debug_prefix,
584: p_msg_level => fnd_log.level_statement,
585: p_module_prefix => l_module_prefix,
586: p_module => l_module
587: );
588: END IF;

Line 605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

601: --hk_debugl(' value of X_CALL_MAP : '||X_CALL_MAP);
602: IF X_CALL_MAP = 'Y' THEN
603: LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
604:
605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
606: hz_utility_v2pub.debug
607: (p_message => 'Before calling validate for Map ',
608: p_prefix => l_debug_prefix,
609: p_msg_level => fnd_log.level_statement,

Line 609: p_msg_level => fnd_log.level_statement,

605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
606: hz_utility_v2pub.debug
607: (p_message => 'Before calling validate for Map ',
608: p_prefix => l_debug_prefix,
609: p_msg_level => fnd_log.level_statement,
610: p_module_prefix => l_module_prefix,
611: p_module => l_module
612: );
613: END IF;

Line 618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

614:
615: validateForMap(L_LOC_COMPONENTS_REC,LL_MAP_DTLS_TBL,l_cause,x_status);
616: --hk_debugl('Back from Validate for Map with status :- '||x_status||'.. and case :'||l_cause);
617:
618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
619: hz_utility_v2pub.debug
620: (p_message => 'Back from Validate for Map with status : .'||x_status||'.. and case :'||l_cause,
621: p_prefix => l_debug_prefix,
622: p_msg_level => fnd_log.level_statement,

Line 622: p_msg_level => fnd_log.level_statement,

618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
619: hz_utility_v2pub.debug
620: (p_message => 'Back from Validate for Map with status : .'||x_status||'.. and case :'||l_cause,
621: p_prefix => l_debug_prefix,
622: p_msg_level => fnd_log.level_statement,
623: p_module_prefix => l_module_prefix,
624: p_module => l_module
625: );
626: END IF;

Line 642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

638: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN
639: -- hk_debugl('COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success');
640: x_status := FND_API.g_ret_sts_success;
641:
642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
643: hz_utility_v2pub.debug
644: (p_message => 'COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success',
645: p_prefix => l_debug_prefix,
646: p_msg_level => fnd_log.level_statement,

Line 646: p_msg_level => fnd_log.level_statement,

642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
643: hz_utility_v2pub.debug
644: (p_message => 'COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success',
645: p_prefix => l_debug_prefix,
646: p_msg_level => fnd_log.level_statement,
647: p_module_prefix => l_module_prefix,
648: p_module => l_module
649: );
650: END IF;

Line 662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

658: -- Set the address validation status to success since x_statusis success
659: X_ADDR_VAL_STATUS := x_status;
660: IF P_LOCATION_ID IS NOT NULL THEN
661:
662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
663: hz_utility_v2pub.debug
664: (p_message => ' Location id is not null. Call fill_values, create_gnr and Return back.',
665: p_prefix => l_debug_prefix,
666: p_msg_level => fnd_log.level_statement,

Line 666: p_msg_level => fnd_log.level_statement,

662: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
663: hz_utility_v2pub.debug
664: (p_message => ' Location id is not null. Call fill_values, create_gnr and Return back.',
665: p_prefix => l_debug_prefix,
666: p_msg_level => fnd_log.level_statement,
667: p_module_prefix => l_module_prefix,
668: p_module => l_module
669: );
670: END IF;

Line 689: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

685: --hk_debugl('Usage Map Table With loc comp values');
686: --hk_debugt(L_MDU_TBL);
687: IF HZ_GNR_UTIL_PKG.do_usage_val(l_cause,L_MAP_DTLS_TBL,L_MDU_TBL,LL_MAP_DTLS_TBL,l_status) = FALSE THEN
688:
689: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
690: hz_utility_v2pub.debug
691: (p_message => ' No usage level validation is required. Call create_gnr with the map status',
692: p_prefix => l_debug_prefix,
693: p_msg_level => fnd_log.level_statement,

Line 693: p_msg_level => fnd_log.level_statement,

689: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
690: hz_utility_v2pub.debug
691: (p_message => ' No usage level validation is required. Call create_gnr with the map status',
692: p_prefix => l_debug_prefix,
693: p_msg_level => fnd_log.level_statement,
694: p_module_prefix => l_module_prefix,
695: p_module => l_module
696: );
697: END IF;

Line 707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

703: -- This below call is to derive the address validation status and set the message
704: X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,'E',x_status);
705: --hk_debugl('Calling create_gnr With Map_status "E"');
706:
707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: hz_utility_v2pub.debug
709: (p_message => ' Calling create_gnr with map status E.',
710: p_prefix => l_debug_prefix,
711: p_msg_level => fnd_log.level_statement,

Line 711: p_msg_level => fnd_log.level_statement,

707: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
708: hz_utility_v2pub.debug
709: (p_message => ' Calling create_gnr with map status E.',
710: p_prefix => l_debug_prefix,
711: p_msg_level => fnd_log.level_statement,
712: p_module_prefix => l_module_prefix,
713: p_module => l_module
714: );
715: END IF;

Line 727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

723: -- This below call is to derive the address validation status and set the message
724: X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,'S',x_status);
725: --hk_debugl('Calling create_gnr With Map_status "S"');
726:
727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
728: hz_utility_v2pub.debug
729: (p_message => ' Calling create_gnr with map status S.',
730: p_prefix => l_debug_prefix,
731: p_msg_level => fnd_log.level_statement,

Line 731: p_msg_level => fnd_log.level_statement,

727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
728: hz_utility_v2pub.debug
729: (p_message => ' Calling create_gnr with map status S.',
730: p_prefix => l_debug_prefix,
731: p_msg_level => fnd_log.level_statement,
732: p_module_prefix => l_module_prefix,
733: p_module => l_module
734: );
735: END IF;

Line 759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

755: END IF;
756:
757: IF L_MDU_TBL.COUNT = 1 THEN
758:
759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
760: hz_utility_v2pub.debug
761: (p_message => ' This means country is the only required mapped column for validation. Call create_gnr with map status S',
762: p_prefix => l_debug_prefix,
763: p_msg_level => fnd_log.level_statement,

Line 763: p_msg_level => fnd_log.level_statement,

759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
760: hz_utility_v2pub.debug
761: (p_message => ' This means country is the only required mapped column for validation. Call create_gnr with map status S',
762: p_prefix => l_debug_prefix,
763: p_msg_level => fnd_log.level_statement,
764: p_module_prefix => l_module_prefix,
765: p_module => l_module
766: );
767: END IF;

Line 819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

815: l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);
816: --hk_debugl('The SQL query');
817: --hk_debugl(l_sql);
818:
819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
820: hz_utility_v2pub.debug
821: (p_message => ' The SQL query : '||l_sql,
822: p_prefix => l_debug_prefix,
823: p_msg_level => fnd_log.level_statement,

Line 823: p_msg_level => fnd_log.level_statement,

819: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
820: hz_utility_v2pub.debug
821: (p_message => ' The SQL query : '||l_sql,
822: p_prefix => l_debug_prefix,
823: p_msg_level => fnd_log.level_statement,
824: p_module_prefix => l_module_prefix,
825: p_module => l_module
826: );
827: END IF;

Line 836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

832: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
833: IF c_getGeo%NOTFOUND THEN
834: --hk_debugl('No Match found for the usage level search');
835:
836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
837: hz_utility_v2pub.debug
838: (p_message => ' No Match found for the usage level search ',
839: p_prefix => l_debug_prefix,
840: p_msg_level => fnd_log.level_statement,

Line 840: p_msg_level => fnd_log.level_statement,

836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
837: hz_utility_v2pub.debug
838: (p_message => ' No Match found for the usage level search ',
839: p_prefix => l_debug_prefix,
840: p_msg_level => fnd_log.level_statement,
841: p_module_prefix => l_module_prefix,
842: p_module => l_module
843: );
844: END IF;

Line 851: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

847: x_status := FND_API.G_RET_STS_ERROR;
848: ELSE
849: --Fetching once more to see where there are multiple records
850:
851: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
852: hz_utility_v2pub.debug
853: (p_message => ' Fetching once more to see where there are multiple records ',
854: p_prefix => l_debug_prefix,
855: p_msg_level => fnd_log.level_statement,

Line 855: p_msg_level => fnd_log.level_statement,

851: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
852: hz_utility_v2pub.debug
853: (p_message => ' Fetching once more to see where there are multiple records ',
854: p_prefix => l_debug_prefix,
855: p_msg_level => fnd_log.level_statement,
856: p_module_prefix => l_module_prefix,
857: p_module => l_module
858: );
859: END IF;

Line 871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

867: l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);
868: OPEN c_getGeo1 FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id
869: ,l_type2,l_value2,l_type3,l_value3,l_type4,l_value4,l_geography_type;
870:
871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
872: hz_utility_v2pub.debug
873: (p_message => 'Before the fetch of the query with identifier type as NAME after multiple match found',
874: p_prefix => l_debug_prefix,
875: p_msg_level => fnd_log.level_statement,

Line 875: p_msg_level => fnd_log.level_statement,

871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
872: hz_utility_v2pub.debug
873: (p_message => 'Before the fetch of the query with identifier type as NAME after multiple match found',
874: p_prefix => l_debug_prefix,
875: p_msg_level => fnd_log.level_statement,
876: p_module_prefix => l_module_prefix,
877: p_module => l_module
878: );
879: END IF;

Line 890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

886: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
887: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
888: IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)
889:
890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
891: hz_utility_v2pub.debug
892: (p_message => 'GEO-Able to find a unique record or a record with multiple parent flag = Y with identifier type as NAME',
893: p_prefix => l_debug_prefix,
894: p_msg_level => fnd_log.level_statement,

Line 894: p_msg_level => fnd_log.level_statement,

890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
891: hz_utility_v2pub.debug
892: (p_message => 'GEO-Able to find a unique record or a record with multiple parent flag = Y with identifier type as NAME',
893: p_prefix => l_debug_prefix,
894: p_msg_level => fnd_log.level_statement,
895: p_module_prefix => l_module_prefix,
896: p_module => l_module
897: );
898: END IF;

Line 902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

898: END IF;
899:
900: ELSE -- Not able to find a unique record with identifier type as NAME
901:
902: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
903: hz_utility_v2pub.debug
904: (p_message => 'GEO-Not able to find a record with with identifier type as NAME. '||
905: ' More than 1 rec exists with same STANDARD NAME',
906: p_prefix => l_debug_prefix,

Line 907: p_msg_level => fnd_log.level_statement,

903: hz_utility_v2pub.debug
904: (p_message => 'GEO-Not able to find a record with with identifier type as NAME. '||
905: ' More than 1 rec exists with same STANDARD NAME',
906: p_prefix => l_debug_prefix,
907: p_msg_level => fnd_log.level_statement,
908: p_module_prefix => l_module_prefix,
909: p_module => l_module
910: );
911: END IF;

Line 920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

916: END IF;
917:
918: ELSE -- Not able to found a unique record with identifier type as NAME
919:
920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
921: hz_utility_v2pub.debug
922: (p_message => ' Not able to find a record with with identifier type as NAME. ',
923: p_prefix => l_debug_prefix,
924: p_msg_level => fnd_log.level_statement,

Line 924: p_msg_level => fnd_log.level_statement,

920: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
921: hz_utility_v2pub.debug
922: (p_message => ' Not able to find a record with with identifier type as NAME. ',
923: p_prefix => l_debug_prefix,
924: p_msg_level => fnd_log.level_statement,
925: p_module_prefix => l_module_prefix,
926: p_module => l_module
927: );
928: END IF;

Line 937: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

933: CLOSE c_getGeo1;
934:
935: ELSE -- a unique record or a record with multiple parent flag = Y is found
936:
937: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
938: hz_utility_v2pub.debug
939: (p_message => ' A unique record or a record with multiple parent flag = Y is found ',
940: p_prefix => l_debug_prefix,
941: p_msg_level => fnd_log.level_statement,

Line 941: p_msg_level => fnd_log.level_statement,

937: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
938: hz_utility_v2pub.debug
939: (p_message => ' A unique record or a record with multiple parent flag = Y is found ',
940: p_prefix => l_debug_prefix,
941: p_msg_level => fnd_log.level_statement,
942: p_module_prefix => l_module_prefix,
943: p_module => l_module
944: );
945: END IF;

Line 954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

950: IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MAP_DTLS_TBL) = TRUE THEN
951: NULL;
952: ELSE -- Multiple parent case not able to find a unique record
953:
954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
955: hz_utility_v2pub.debug
956: (p_message => ' Multiple parent case not able to find a unique record',
957: p_prefix => l_debug_prefix,
958: p_msg_level => fnd_log.level_statement,

Line 958: p_msg_level => fnd_log.level_statement,

954: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
955: hz_utility_v2pub.debug
956: (p_message => ' Multiple parent case not able to find a unique record',
957: p_prefix => l_debug_prefix,
958: p_msg_level => fnd_log.level_statement,
959: p_module_prefix => l_module_prefix,
960: p_module => l_module
961: );
962: END IF;

Line 969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

965: END IF;
966:
967: ELSE -- a unique record is found
968:
969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970: hz_utility_v2pub.debug
971: (p_message => ' A unique record is found ',
972: p_prefix => l_debug_prefix,
973: p_msg_level => fnd_log.level_statement,

Line 973: p_msg_level => fnd_log.level_statement,

969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970: hz_utility_v2pub.debug
971: (p_message => ' A unique record is found ',
972: p_prefix => l_debug_prefix,
973: p_msg_level => fnd_log.level_statement,
974: p_module_prefix => l_module_prefix,
975: p_module => l_module
976: );
977: END IF;

Line 986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

982:
983: --hk_debugl('Return STatus after first fetch : '||x_status);
984: --Following call will try to derive missing lower level compoents
985:
986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
987: hz_utility_v2pub.debug
988: (p_message => ' Return Status after first fetch : '||x_status,
989: p_prefix => l_debug_prefix,
990: p_msg_level => fnd_log.level_statement,

Line 990: p_msg_level => fnd_log.level_statement,

986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
987: hz_utility_v2pub.debug
988: (p_message => ' Return Status after first fetch : '||x_status,
989: p_prefix => l_debug_prefix,
990: p_msg_level => fnd_log.level_statement,
991: p_module_prefix => l_module_prefix,
992: p_module => l_module
993: );
994: END IF;

Line 996: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

992: p_module => l_module
993: );
994: END IF;
995:
996: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
997: hz_utility_v2pub.debug
998: (p_message => ' Calling fix_child. This call will try to derive missing lower level compoents.',
999: p_prefix => l_debug_prefix,
1000: p_msg_level => fnd_log.level_statement,

Line 1000: p_msg_level => fnd_log.level_statement,

996: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
997: hz_utility_v2pub.debug
998: (p_message => ' Calling fix_child. This call will try to derive missing lower level compoents.',
999: p_prefix => l_debug_prefix,
1000: p_msg_level => fnd_log.level_statement,
1001: p_module_prefix => l_module_prefix,
1002: p_module => l_module
1003: );
1004: END IF;

Line 1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1006: IF HZ_GNR_UTIL_PKG.fix_child(LL_MAP_DTLS_TBL) = FALSE THEN
1007: x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL);
1008: END IF;
1009:
1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1011: hz_utility_v2pub.debug
1012: (p_message => ' Return status after fix_child '||x_status,
1013: p_prefix => l_debug_prefix,
1014: p_msg_level => fnd_log.level_statement,

Line 1014: p_msg_level => fnd_log.level_statement,

1010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1011: hz_utility_v2pub.debug
1012: (p_message => ' Return status after fix_child '||x_status,
1013: p_prefix => l_debug_prefix,
1014: p_msg_level => fnd_log.level_statement,
1015: p_module_prefix => l_module_prefix,
1016: p_module => l_module
1017: );
1018: END IF;

Line 1036: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1032: END IF;
1033:
1034: IF P_LOCATION_ID IS NOT NULL THEN
1035:
1036: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1037: hz_utility_v2pub.debug
1038: (p_message => ' Calling create_gnr with map status S.',
1039: p_prefix => l_debug_prefix,
1040: p_msg_level => fnd_log.level_statement,

Line 1040: p_msg_level => fnd_log.level_statement,

1036: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1037: hz_utility_v2pub.debug
1038: (p_message => ' Calling create_gnr with map status S.',
1039: p_prefix => l_debug_prefix,
1040: p_msg_level => fnd_log.level_statement,
1041: p_module_prefix => l_module_prefix,
1042: p_module => l_module
1043: );
1044: END IF;

Line 1060: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1056: END IF;
1057:
1058: IF P_LOCATION_ID IS NOT NULL THEN
1059:
1060: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1061: hz_utility_v2pub.debug
1062: (p_message => ' Calling create_gnr with map status E.',
1063: p_prefix => l_debug_prefix,
1064: p_msg_level => fnd_log.level_statement,

Line 1064: p_msg_level => fnd_log.level_statement,

1060: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1061: hz_utility_v2pub.debug
1062: (p_message => ' Calling create_gnr with map status E.',
1063: p_prefix => l_debug_prefix,
1064: p_msg_level => fnd_log.level_statement,
1065: p_module_prefix => l_module_prefix,
1066: p_module => l_module
1067: );
1068: END IF;

Line 1076: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1072: --hk_debugl('Prceossed GNR With Status : E and returned with Status : '||l_status);
1073: END IF;
1074: END IF;
1075:
1076: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1077: hz_utility_v2pub.debug
1078: (p_message => 'End of validation for '||L_USAGE_CODE,
1079: p_prefix => l_debug_prefix,
1080: p_msg_level => fnd_log.level_procedure,

Line 1080: p_msg_level => fnd_log.level_procedure,

1076: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1077: hz_utility_v2pub.debug
1078: (p_message => 'End of validation for '||L_USAGE_CODE,
1079: p_prefix => l_debug_prefix,
1080: p_msg_level => fnd_log.level_procedure,
1081: p_module_prefix => l_module_prefix,
1082: p_module => l_module
1083: );
1084: END IF;

Line 1178: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1174: L_MDU_TBL := G_MDU_TBL10006;
1175: L_MAP_DTLS_TBL := G_MAP_DTLS_TBL;
1176: l_get_addr_val := 'N';
1177:
1178: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1179: hz_utility_v2pub.debug
1180: (p_message => 'Begin of validation for '||L_USAGE_CODE,
1181: p_prefix => l_debug_prefix,
1182: p_msg_level => fnd_log.level_procedure,

Line 1182: p_msg_level => fnd_log.level_procedure,

1178: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1179: hz_utility_v2pub.debug
1180: (p_message => 'Begin of validation for '||L_USAGE_CODE,
1181: p_prefix => l_debug_prefix,
1182: p_msg_level => fnd_log.level_procedure,
1183: p_module_prefix => l_module_prefix,
1184: p_module => l_module
1185: );
1186: END IF;

Line 1194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1190: IF HZ_GNR_UTIL_PKG.check_GNR_For_Usage(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,
1191: L_USAGE_CODE,L_MDU_TBL,x_status) = TRUE THEN
1192: --hk_debugl('After check_GNR_For_Usage with status :- '||x_status);
1193:
1194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1195: hz_utility_v2pub.debug
1196: (p_message => 'There is already a procedded success record in GNR log table.',
1197: p_prefix => l_debug_prefix,
1198: p_msg_level => fnd_log.level_statement,

Line 1198: p_msg_level => fnd_log.level_statement,

1194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1195: hz_utility_v2pub.debug
1196: (p_message => 'There is already a procedded success record in GNR log table.',
1197: p_prefix => l_debug_prefix,
1198: p_msg_level => fnd_log.level_statement,
1199: p_module_prefix => l_module_prefix,
1200: p_module => l_module
1201: );
1202: END IF;

Line 1210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1206: RETURN;
1207: END IF;
1208: END IF;
1209:
1210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1211: hz_utility_v2pub.debug
1212: (p_message => 'Not able to find an existing success record in GNR log table.',
1213: p_prefix => l_debug_prefix,
1214: p_msg_level => fnd_log.level_statement,

Line 1214: p_msg_level => fnd_log.level_statement,

1210: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1211: hz_utility_v2pub.debug
1212: (p_message => 'Not able to find an existing success record in GNR log table.',
1213: p_prefix => l_debug_prefix,
1214: p_msg_level => fnd_log.level_statement,
1215: p_module_prefix => l_module_prefix,
1216: p_module => l_module
1217: );
1218: END IF;

Line 1235: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1231: --hk_debugl(' value of X_CALL_MAP : '||X_CALL_MAP);
1232: IF X_CALL_MAP = 'Y' THEN
1233: LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
1234:
1235: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1236: hz_utility_v2pub.debug
1237: (p_message => 'Before calling validate for Map ',
1238: p_prefix => l_debug_prefix,
1239: p_msg_level => fnd_log.level_statement,

Line 1239: p_msg_level => fnd_log.level_statement,

1235: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1236: hz_utility_v2pub.debug
1237: (p_message => 'Before calling validate for Map ',
1238: p_prefix => l_debug_prefix,
1239: p_msg_level => fnd_log.level_statement,
1240: p_module_prefix => l_module_prefix,
1241: p_module => l_module
1242: );
1243: END IF;

Line 1248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1244:
1245: validateForMap(L_LOC_COMPONENTS_REC,LL_MAP_DTLS_TBL,l_cause,x_status);
1246: --hk_debugl('Back from Validate for Map with status :- '||x_status||'.. and case :'||l_cause);
1247:
1248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1249: hz_utility_v2pub.debug
1250: (p_message => 'Back from Validate for Map with status : .'||x_status||'.. and case :'||l_cause,
1251: p_prefix => l_debug_prefix,
1252: p_msg_level => fnd_log.level_statement,

Line 1252: p_msg_level => fnd_log.level_statement,

1248: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1249: hz_utility_v2pub.debug
1250: (p_message => 'Back from Validate for Map with status : .'||x_status||'.. and case :'||l_cause,
1251: p_prefix => l_debug_prefix,
1252: p_msg_level => fnd_log.level_statement,
1253: p_module_prefix => l_module_prefix,
1254: p_module => l_module
1255: );
1256: END IF;

Line 1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1268: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN
1269: -- hk_debugl('COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success');
1270: x_status := FND_API.g_ret_sts_success;
1271:
1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1273: hz_utility_v2pub.debug
1274: (p_message => 'COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success',
1275: p_prefix => l_debug_prefix,
1276: p_msg_level => fnd_log.level_statement,

Line 1276: p_msg_level => fnd_log.level_statement,

1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1273: hz_utility_v2pub.debug
1274: (p_message => 'COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success',
1275: p_prefix => l_debug_prefix,
1276: p_msg_level => fnd_log.level_statement,
1277: p_module_prefix => l_module_prefix,
1278: p_module => l_module
1279: );
1280: END IF;

Line 1292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1288: -- Set the address validation status to success since x_statusis success
1289: X_ADDR_VAL_STATUS := x_status;
1290: IF P_LOCATION_ID IS NOT NULL THEN
1291:
1292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1293: hz_utility_v2pub.debug
1294: (p_message => ' Location id is not null. Call fill_values, create_gnr and Return back.',
1295: p_prefix => l_debug_prefix,
1296: p_msg_level => fnd_log.level_statement,

Line 1296: p_msg_level => fnd_log.level_statement,

1292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1293: hz_utility_v2pub.debug
1294: (p_message => ' Location id is not null. Call fill_values, create_gnr and Return back.',
1295: p_prefix => l_debug_prefix,
1296: p_msg_level => fnd_log.level_statement,
1297: p_module_prefix => l_module_prefix,
1298: p_module => l_module
1299: );
1300: END IF;

Line 1319: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1315: --hk_debugl('Usage Map Table With loc comp values');
1316: --hk_debugt(L_MDU_TBL);
1317: IF HZ_GNR_UTIL_PKG.do_usage_val(l_cause,L_MAP_DTLS_TBL,L_MDU_TBL,LL_MAP_DTLS_TBL,l_status) = FALSE THEN
1318:
1319: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1320: hz_utility_v2pub.debug
1321: (p_message => ' No usage level validation is required. Call create_gnr with the map status',
1322: p_prefix => l_debug_prefix,
1323: p_msg_level => fnd_log.level_statement,

Line 1323: p_msg_level => fnd_log.level_statement,

1319: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1320: hz_utility_v2pub.debug
1321: (p_message => ' No usage level validation is required. Call create_gnr with the map status',
1322: p_prefix => l_debug_prefix,
1323: p_msg_level => fnd_log.level_statement,
1324: p_module_prefix => l_module_prefix,
1325: p_module => l_module
1326: );
1327: END IF;

Line 1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1333: -- This below call is to derive the address validation status and set the message
1334: X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,'E',x_status);
1335: --hk_debugl('Calling create_gnr With Map_status "E"');
1336:
1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1338: hz_utility_v2pub.debug
1339: (p_message => ' Calling create_gnr with map status E.',
1340: p_prefix => l_debug_prefix,
1341: p_msg_level => fnd_log.level_statement,

Line 1341: p_msg_level => fnd_log.level_statement,

1337: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1338: hz_utility_v2pub.debug
1339: (p_message => ' Calling create_gnr with map status E.',
1340: p_prefix => l_debug_prefix,
1341: p_msg_level => fnd_log.level_statement,
1342: p_module_prefix => l_module_prefix,
1343: p_module => l_module
1344: );
1345: END IF;

Line 1357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1353: -- This below call is to derive the address validation status and set the message
1354: X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,'S',x_status);
1355: --hk_debugl('Calling create_gnr With Map_status "S"');
1356:
1357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1358: hz_utility_v2pub.debug
1359: (p_message => ' Calling create_gnr with map status S.',
1360: p_prefix => l_debug_prefix,
1361: p_msg_level => fnd_log.level_statement,

Line 1361: p_msg_level => fnd_log.level_statement,

1357: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1358: hz_utility_v2pub.debug
1359: (p_message => ' Calling create_gnr with map status S.',
1360: p_prefix => l_debug_prefix,
1361: p_msg_level => fnd_log.level_statement,
1362: p_module_prefix => l_module_prefix,
1363: p_module => l_module
1364: );
1365: END IF;

Line 1389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1385: END IF;
1386:
1387: IF L_MDU_TBL.COUNT = 1 THEN
1388:
1389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1390: hz_utility_v2pub.debug
1391: (p_message => ' This means country is the only required mapped column for validation. Call create_gnr with map status S',
1392: p_prefix => l_debug_prefix,
1393: p_msg_level => fnd_log.level_statement,

Line 1393: p_msg_level => fnd_log.level_statement,

1389: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1390: hz_utility_v2pub.debug
1391: (p_message => ' This means country is the only required mapped column for validation. Call create_gnr with map status S',
1392: p_prefix => l_debug_prefix,
1393: p_msg_level => fnd_log.level_statement,
1394: p_module_prefix => l_module_prefix,
1395: p_module => l_module
1396: );
1397: END IF;

Line 1449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1445: l_sql := HZ_GNR_UTIL_PKG.getQuery(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);
1446: --hk_debugl('The SQL query');
1447: --hk_debugl(l_sql);
1448:
1449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1450: hz_utility_v2pub.debug
1451: (p_message => ' The SQL query : '||l_sql,
1452: p_prefix => l_debug_prefix,
1453: p_msg_level => fnd_log.level_statement,

Line 1453: p_msg_level => fnd_log.level_statement,

1449: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1450: hz_utility_v2pub.debug
1451: (p_message => ' The SQL query : '||l_sql,
1452: p_prefix => l_debug_prefix,
1453: p_msg_level => fnd_log.level_statement,
1454: p_module_prefix => l_module_prefix,
1455: p_module => l_module
1456: );
1457: END IF;

Line 1466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1462: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
1463: IF c_getGeo%NOTFOUND THEN
1464: --hk_debugl('No Match found for the usage level search');
1465:
1466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1467: hz_utility_v2pub.debug
1468: (p_message => ' No Match found for the usage level search ',
1469: p_prefix => l_debug_prefix,
1470: p_msg_level => fnd_log.level_statement,

Line 1470: p_msg_level => fnd_log.level_statement,

1466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1467: hz_utility_v2pub.debug
1468: (p_message => ' No Match found for the usage level search ',
1469: p_prefix => l_debug_prefix,
1470: p_msg_level => fnd_log.level_statement,
1471: p_module_prefix => l_module_prefix,
1472: p_module => l_module
1473: );
1474: END IF;

Line 1481: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1477: x_status := FND_API.G_RET_STS_ERROR;
1478: ELSE
1479: --Fetching once more to see where there are multiple records
1480:
1481: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1482: hz_utility_v2pub.debug
1483: (p_message => ' Fetching once more to see where there are multiple records ',
1484: p_prefix => l_debug_prefix,
1485: p_msg_level => fnd_log.level_statement,

Line 1485: p_msg_level => fnd_log.level_statement,

1481: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1482: hz_utility_v2pub.debug
1483: (p_message => ' Fetching once more to see where there are multiple records ',
1484: p_prefix => l_debug_prefix,
1485: p_msg_level => fnd_log.level_statement,
1486: p_module_prefix => l_module_prefix,
1487: p_module => l_module
1488: );
1489: END IF;

Line 1501: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1497: l_sql := HZ_GNR_UTIL_PKG.getQueryforMultiMatch(L_MAP_DTLS_TBL,L_MDU_TBL,x_status);
1498: OPEN c_getGeo1 FOR l_sql USING G_MAP_REC.COUNTRY_CODE,g_country_geo_id
1499: ,l_type2,l_value2,l_type3,l_value3,l_type4,l_value4,l_geography_type;
1500:
1501: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1502: hz_utility_v2pub.debug
1503: (p_message => 'Before the fetch of the query with identifier type as NAME after multiple match found',
1504: p_prefix => l_debug_prefix,
1505: p_msg_level => fnd_log.level_statement,

Line 1505: p_msg_level => fnd_log.level_statement,

1501: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1502: hz_utility_v2pub.debug
1503: (p_message => 'Before the fetch of the query with identifier type as NAME after multiple match found',
1504: p_prefix => l_debug_prefix,
1505: p_msg_level => fnd_log.level_statement,
1506: p_module_prefix => l_module_prefix,
1507: p_module => l_module
1508: );
1509: END IF;

Line 1520: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1516: FETCH c_getGeo1 INTO l_geography_id,l_multiple_parent_flag,L_MAP_DTLS_TBL(1).GEOGRAPHY_ID
1517: ,LL_MAP_DTLS_TBL(2).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(3).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(4).GEOGRAPHY_ID,LL_MAP_DTLS_TBL(5).GEOGRAPHY_ID;
1518: IF c_getGeo1%NOTFOUND THEN -- success (only 1 rec with same primary name exists)
1519:
1520: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1521: hz_utility_v2pub.debug
1522: (p_message => 'GEO-Able to find a unique record or a record with multiple parent flag = Y with identifier type as NAME',
1523: p_prefix => l_debug_prefix,
1524: p_msg_level => fnd_log.level_statement,

Line 1524: p_msg_level => fnd_log.level_statement,

1520: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1521: hz_utility_v2pub.debug
1522: (p_message => 'GEO-Able to find a unique record or a record with multiple parent flag = Y with identifier type as NAME',
1523: p_prefix => l_debug_prefix,
1524: p_msg_level => fnd_log.level_statement,
1525: p_module_prefix => l_module_prefix,
1526: p_module => l_module
1527: );
1528: END IF;

Line 1532: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1528: END IF;
1529:
1530: ELSE -- Not able to find a unique record with identifier type as NAME
1531:
1532: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1533: hz_utility_v2pub.debug
1534: (p_message => 'GEO-Not able to find a record with with identifier type as NAME. '||
1535: ' More than 1 rec exists with same STANDARD NAME',
1536: p_prefix => l_debug_prefix,

Line 1537: p_msg_level => fnd_log.level_statement,

1533: hz_utility_v2pub.debug
1534: (p_message => 'GEO-Not able to find a record with with identifier type as NAME. '||
1535: ' More than 1 rec exists with same STANDARD NAME',
1536: p_prefix => l_debug_prefix,
1537: p_msg_level => fnd_log.level_statement,
1538: p_module_prefix => l_module_prefix,
1539: p_module => l_module
1540: );
1541: END IF;

Line 1550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1546: END IF;
1547:
1548: ELSE -- Not able to found a unique record with identifier type as NAME
1549:
1550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1551: hz_utility_v2pub.debug
1552: (p_message => ' Not able to find a record with with identifier type as NAME. ',
1553: p_prefix => l_debug_prefix,
1554: p_msg_level => fnd_log.level_statement,

Line 1554: p_msg_level => fnd_log.level_statement,

1550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1551: hz_utility_v2pub.debug
1552: (p_message => ' Not able to find a record with with identifier type as NAME. ',
1553: p_prefix => l_debug_prefix,
1554: p_msg_level => fnd_log.level_statement,
1555: p_module_prefix => l_module_prefix,
1556: p_module => l_module
1557: );
1558: END IF;

Line 1567: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1563: CLOSE c_getGeo1;
1564:
1565: ELSE -- a unique record or a record with multiple parent flag = Y is found
1566:
1567: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1568: hz_utility_v2pub.debug
1569: (p_message => ' A unique record or a record with multiple parent flag = Y is found ',
1570: p_prefix => l_debug_prefix,
1571: p_msg_level => fnd_log.level_statement,

Line 1571: p_msg_level => fnd_log.level_statement,

1567: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1568: hz_utility_v2pub.debug
1569: (p_message => ' A unique record or a record with multiple parent flag = Y is found ',
1570: p_prefix => l_debug_prefix,
1571: p_msg_level => fnd_log.level_statement,
1572: p_module_prefix => l_module_prefix,
1573: p_module => l_module
1574: );
1575: END IF;

Line 1584: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1580: IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MAP_DTLS_TBL) = TRUE THEN
1581: NULL;
1582: ELSE -- Multiple parent case not able to find a unique record
1583:
1584: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1585: hz_utility_v2pub.debug
1586: (p_message => ' Multiple parent case not able to find a unique record',
1587: p_prefix => l_debug_prefix,
1588: p_msg_level => fnd_log.level_statement,

Line 1588: p_msg_level => fnd_log.level_statement,

1584: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1585: hz_utility_v2pub.debug
1586: (p_message => ' Multiple parent case not able to find a unique record',
1587: p_prefix => l_debug_prefix,
1588: p_msg_level => fnd_log.level_statement,
1589: p_module_prefix => l_module_prefix,
1590: p_module => l_module
1591: );
1592: END IF;

Line 1599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1595: END IF;
1596:
1597: ELSE -- a unique record is found
1598:
1599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1600: hz_utility_v2pub.debug
1601: (p_message => ' A unique record is found ',
1602: p_prefix => l_debug_prefix,
1603: p_msg_level => fnd_log.level_statement,

Line 1603: p_msg_level => fnd_log.level_statement,

1599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1600: hz_utility_v2pub.debug
1601: (p_message => ' A unique record is found ',
1602: p_prefix => l_debug_prefix,
1603: p_msg_level => fnd_log.level_statement,
1604: p_module_prefix => l_module_prefix,
1605: p_module => l_module
1606: );
1607: END IF;

Line 1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1612:
1613: --hk_debugl('Return STatus after first fetch : '||x_status);
1614: --Following call will try to derive missing lower level compoents
1615:
1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1617: hz_utility_v2pub.debug
1618: (p_message => ' Return Status after first fetch : '||x_status,
1619: p_prefix => l_debug_prefix,
1620: p_msg_level => fnd_log.level_statement,

Line 1620: p_msg_level => fnd_log.level_statement,

1616: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1617: hz_utility_v2pub.debug
1618: (p_message => ' Return Status after first fetch : '||x_status,
1619: p_prefix => l_debug_prefix,
1620: p_msg_level => fnd_log.level_statement,
1621: p_module_prefix => l_module_prefix,
1622: p_module => l_module
1623: );
1624: END IF;

Line 1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1622: p_module => l_module
1623: );
1624: END IF;
1625:
1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1627: hz_utility_v2pub.debug
1628: (p_message => ' Calling fix_child. This call will try to derive missing lower level compoents.',
1629: p_prefix => l_debug_prefix,
1630: p_msg_level => fnd_log.level_statement,

Line 1630: p_msg_level => fnd_log.level_statement,

1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1627: hz_utility_v2pub.debug
1628: (p_message => ' Calling fix_child. This call will try to derive missing lower level compoents.',
1629: p_prefix => l_debug_prefix,
1630: p_msg_level => fnd_log.level_statement,
1631: p_module_prefix => l_module_prefix,
1632: p_module => l_module
1633: );
1634: END IF;

Line 1640: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1636: IF HZ_GNR_UTIL_PKG.fix_child(LL_MAP_DTLS_TBL) = FALSE THEN
1637: x_status := HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL);
1638: END IF;
1639:
1640: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1641: hz_utility_v2pub.debug
1642: (p_message => ' Return status after fix_child '||x_status,
1643: p_prefix => l_debug_prefix,
1644: p_msg_level => fnd_log.level_statement,

Line 1644: p_msg_level => fnd_log.level_statement,

1640: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1641: hz_utility_v2pub.debug
1642: (p_message => ' Return status after fix_child '||x_status,
1643: p_prefix => l_debug_prefix,
1644: p_msg_level => fnd_log.level_statement,
1645: p_module_prefix => l_module_prefix,
1646: p_module => l_module
1647: );
1648: END IF;

Line 1666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1662: END IF;
1663:
1664: IF P_LOCATION_ID IS NOT NULL THEN
1665:
1666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1667: hz_utility_v2pub.debug
1668: (p_message => ' Calling create_gnr with map status S.',
1669: p_prefix => l_debug_prefix,
1670: p_msg_level => fnd_log.level_statement,

Line 1670: p_msg_level => fnd_log.level_statement,

1666: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1667: hz_utility_v2pub.debug
1668: (p_message => ' Calling create_gnr with map status S.',
1669: p_prefix => l_debug_prefix,
1670: p_msg_level => fnd_log.level_statement,
1671: p_module_prefix => l_module_prefix,
1672: p_module => l_module
1673: );
1674: END IF;

Line 1690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1686: END IF;
1687:
1688: IF P_LOCATION_ID IS NOT NULL THEN
1689:
1690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1691: hz_utility_v2pub.debug
1692: (p_message => ' Calling create_gnr with map status E.',
1693: p_prefix => l_debug_prefix,
1694: p_msg_level => fnd_log.level_statement,

Line 1694: p_msg_level => fnd_log.level_statement,

1690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1691: hz_utility_v2pub.debug
1692: (p_message => ' Calling create_gnr with map status E.',
1693: p_prefix => l_debug_prefix,
1694: p_msg_level => fnd_log.level_statement,
1695: p_module_prefix => l_module_prefix,
1696: p_module => l_module
1697: );
1698: END IF;

Line 1706: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1702: --hk_debugl('Prceossed GNR With Status : E and returned with Status : '||l_status);
1703: END IF;
1704: END IF;
1705:
1706: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1707: hz_utility_v2pub.debug
1708: (p_message => 'End of validation for '||L_USAGE_CODE,
1709: p_prefix => l_debug_prefix,
1710: p_msg_level => fnd_log.level_procedure,

Line 1710: p_msg_level => fnd_log.level_procedure,

1706: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1707: hz_utility_v2pub.debug
1708: (p_message => 'End of validation for '||L_USAGE_CODE,
1709: p_prefix => l_debug_prefix,
1710: p_msg_level => fnd_log.level_procedure,
1711: p_module_prefix => l_module_prefix,
1712: p_module => l_module
1713: );
1714: END IF;