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 HZ_UTILITY_V2PUB

Line 103: hz_utility_v2pub.debug

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,
107: p_module_prefix => l_module_prefix,

Line 131: hz_utility_v2pub.debug

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,
135: p_module_prefix => l_module_prefix,

Line 146: hz_utility_v2pub.debug

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,
150: p_module_prefix => l_module_prefix,

Line 161: hz_utility_v2pub.debug

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,
165: p_module_prefix => l_module_prefix,

Line 218: hz_utility_v2pub.debug

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,
222: p_module_prefix => l_module_prefix,

Line 232: hz_utility_v2pub.debug

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,
236: p_module_prefix => l_module_prefix,

Line 247: hz_utility_v2pub.debug

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,
251: p_module_prefix => l_module_prefix,

Line 267: hz_utility_v2pub.debug

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,
271: p_module_prefix => l_module_prefix,

Line 287: hz_utility_v2pub.debug

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,
291: p_module_prefix => l_module_prefix,

Line 306: hz_utility_v2pub.debug

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,
310: p_module_prefix => l_module_prefix,

Line 318: hz_utility_v2pub.debug

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,
322: p_msg_level => fnd_log.level_statement,

Line 337: hz_utility_v2pub.debug

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,
341: p_module_prefix => l_module_prefix,

Line 354: hz_utility_v2pub.debug

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,
358: p_module_prefix => l_module_prefix,

Line 371: hz_utility_v2pub.debug

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,
375: p_module_prefix => l_module_prefix,

Line 385: hz_utility_v2pub.debug

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,
389: p_module_prefix => l_module_prefix,

Line 400: hz_utility_v2pub.debug

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,
404: p_module_prefix => l_module_prefix,

Line 417: hz_utility_v2pub.debug

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,
421: p_module_prefix => l_module_prefix,

Line 431: hz_utility_v2pub.debug

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,
435: p_module_prefix => l_module_prefix,

Line 448: hz_utility_v2pub.debug

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,
452: p_module_prefix => l_module_prefix,

Line 549: hz_utility_v2pub.debug

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,
553: p_module_prefix => l_module_prefix,

Line 565: hz_utility_v2pub.debug

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,
569: p_module_prefix => l_module_prefix,

Line 581: hz_utility_v2pub.debug

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,
585: p_module_prefix => l_module_prefix,

Line 606: hz_utility_v2pub.debug

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,
610: p_module_prefix => l_module_prefix,

Line 619: hz_utility_v2pub.debug

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,
623: p_module_prefix => l_module_prefix,

Line 643: hz_utility_v2pub.debug

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,
647: p_module_prefix => l_module_prefix,

Line 663: hz_utility_v2pub.debug

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,
667: p_module_prefix => l_module_prefix,

Line 690: hz_utility_v2pub.debug

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,
694: p_module_prefix => l_module_prefix,

Line 708: hz_utility_v2pub.debug

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,
712: p_module_prefix => l_module_prefix,

Line 728: hz_utility_v2pub.debug

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,
732: p_module_prefix => l_module_prefix,

Line 760: hz_utility_v2pub.debug

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,
764: p_module_prefix => l_module_prefix,

Line 820: hz_utility_v2pub.debug

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,
824: p_module_prefix => l_module_prefix,

Line 837: hz_utility_v2pub.debug

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,
841: p_module_prefix => l_module_prefix,

Line 852: hz_utility_v2pub.debug

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,
856: p_module_prefix => l_module_prefix,

Line 872: hz_utility_v2pub.debug

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,
876: p_module_prefix => l_module_prefix,

Line 891: hz_utility_v2pub.debug

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,
895: p_module_prefix => l_module_prefix,

Line 903: hz_utility_v2pub.debug

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,
907: p_msg_level => fnd_log.level_statement,

Line 921: hz_utility_v2pub.debug

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,
925: p_module_prefix => l_module_prefix,

Line 938: hz_utility_v2pub.debug

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,
942: p_module_prefix => l_module_prefix,

Line 955: hz_utility_v2pub.debug

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,
959: p_module_prefix => l_module_prefix,

Line 970: hz_utility_v2pub.debug

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,
974: p_module_prefix => l_module_prefix,

Line 987: hz_utility_v2pub.debug

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,
991: p_module_prefix => l_module_prefix,

Line 997: hz_utility_v2pub.debug

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,
1001: p_module_prefix => l_module_prefix,

Line 1011: hz_utility_v2pub.debug

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,
1015: p_module_prefix => l_module_prefix,

Line 1037: hz_utility_v2pub.debug

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,
1041: p_module_prefix => l_module_prefix,

Line 1061: hz_utility_v2pub.debug

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,
1065: p_module_prefix => l_module_prefix,

Line 1077: hz_utility_v2pub.debug

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,
1081: p_module_prefix => l_module_prefix,

Line 1179: hz_utility_v2pub.debug

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,
1183: p_module_prefix => l_module_prefix,

Line 1195: hz_utility_v2pub.debug

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,
1199: p_module_prefix => l_module_prefix,

Line 1211: hz_utility_v2pub.debug

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,
1215: p_module_prefix => l_module_prefix,

Line 1236: hz_utility_v2pub.debug

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,
1240: p_module_prefix => l_module_prefix,

Line 1249: hz_utility_v2pub.debug

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,
1253: p_module_prefix => l_module_prefix,

Line 1273: hz_utility_v2pub.debug

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,
1277: p_module_prefix => l_module_prefix,

Line 1293: hz_utility_v2pub.debug

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,
1297: p_module_prefix => l_module_prefix,

Line 1320: hz_utility_v2pub.debug

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,
1324: p_module_prefix => l_module_prefix,

Line 1338: hz_utility_v2pub.debug

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,
1342: p_module_prefix => l_module_prefix,

Line 1358: hz_utility_v2pub.debug

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,
1362: p_module_prefix => l_module_prefix,

Line 1390: hz_utility_v2pub.debug

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,
1394: p_module_prefix => l_module_prefix,

Line 1450: hz_utility_v2pub.debug

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,
1454: p_module_prefix => l_module_prefix,

Line 1467: hz_utility_v2pub.debug

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,
1471: p_module_prefix => l_module_prefix,

Line 1482: hz_utility_v2pub.debug

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,
1486: p_module_prefix => l_module_prefix,

Line 1502: hz_utility_v2pub.debug

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,
1506: p_module_prefix => l_module_prefix,

Line 1521: hz_utility_v2pub.debug

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,
1525: p_module_prefix => l_module_prefix,

Line 1533: hz_utility_v2pub.debug

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,
1537: p_msg_level => fnd_log.level_statement,

Line 1551: hz_utility_v2pub.debug

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,
1555: p_module_prefix => l_module_prefix,

Line 1568: hz_utility_v2pub.debug

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,
1572: p_module_prefix => l_module_prefix,

Line 1585: hz_utility_v2pub.debug

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,
1589: p_module_prefix => l_module_prefix,

Line 1600: hz_utility_v2pub.debug

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,
1604: p_module_prefix => l_module_prefix,

Line 1617: hz_utility_v2pub.debug

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,
1621: p_module_prefix => l_module_prefix,

Line 1627: hz_utility_v2pub.debug

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,
1631: p_module_prefix => l_module_prefix,

Line 1641: hz_utility_v2pub.debug

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,
1645: p_module_prefix => l_module_prefix,

Line 1667: hz_utility_v2pub.debug

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,
1671: p_module_prefix => l_module_prefix,

Line 1691: hz_utility_v2pub.debug

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

Line 1707: hz_utility_v2pub.debug

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,
1711: p_module_prefix => l_module_prefix,