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

Line 150: hz_utility_v2pub.debug

146:
147: BEGIN
148: -- FND Logging for debug purpose
149: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
150: hz_utility_v2pub.debug
151: (p_message => 'Begin procedure validate_input_values_proc(+)',
152: p_prefix => l_debug_prefix,
153: p_msg_level => fnd_log.level_procedure,
154: p_module_prefix => l_module_prefix,

Line 173: hz_utility_v2pub.debug

169: IF (l_country_geo_id IS NOT NULL) THEN
170:
171: -- FND Logging for debug purpose
172: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
173: hz_utility_v2pub.debug
174: (p_message => 'Fetched country geography id. It is:'||l_country_geo_id,
175: p_prefix => l_debug_prefix,
176: p_msg_level => fnd_log.level_statement,
177: p_module_prefix => l_module_prefix,

Line 446: hz_utility_v2pub.debug

442: --ns_debug.put_line('Success Level='||l_success_geo_level);
443:
444: -- FND Logging for debug purpose
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
446: hz_utility_v2pub.debug
447: (p_message => 'Record Count Flag is:'||l_rec_count_flag||
448: '. Level is:'||l_level||'. Success Geo Level is:'||l_success_geo_level,
449: p_prefix => l_debug_prefix,
450: p_msg_level => fnd_log.level_statement,

Line 465: hz_utility_v2pub.debug

461: l_not_validated_geo_type := get_geo_type_list(l_geo_struct_tbl, l_success_geo_level+1, 'USAGE');
462:
463: -- FND Logging for debug purpose
464: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
465: hz_utility_v2pub.debug
466: (p_message => 'For passed in values we have 1 record at level:'||l_success_geo_level,
467: p_prefix => l_debug_prefix,
468: p_msg_level => fnd_log.level_statement,
469: p_module_prefix => l_module_prefix,

Line 492: hz_utility_v2pub.debug

488: END IF;
489:
490: -- FND Logging for debug purpose
491: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
492: hz_utility_v2pub.debug
493: (p_message => 'For passed in values we have multiple records at level:'||l_success_geo_level||
494: '. Geo Type not validated for msg:'||l_not_validated_geo_type,
495: p_prefix => l_debug_prefix,
496: p_msg_level => fnd_log.level_statement,

Line 506: hz_utility_v2pub.debug

502: END IF;
503:
504: -- FND Logging for debug purpose
505: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
506: hz_utility_v2pub.debug
507: (p_message => 'For Record Count Flag = 0, l_success_rec_count='||l_success_rec_count
508: ||', geo type not validated is :'||l_not_validated_geo_type,
509: p_prefix => l_debug_prefix,
510: p_msg_level => fnd_log.level_statement,

Line 527: hz_utility_v2pub.debug

523: IF (l_not_validated_geo_type IS NULL AND l_level > 0) THEN
524:
525: -- FND Logging for debug purpose
526: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
527: hz_utility_v2pub.debug
528: (p_message => 'Everthing passed is valid, but may not be complete, i.e. 1. rec found but it is not complete for geo usage',
529: p_prefix => l_debug_prefix,
530: p_msg_level => fnd_log.level_statement,
531: p_module_prefix => l_module_prefix,

Line 545: hz_utility_v2pub.debug

541: l_not_validated_geo_type := get_missing_input_fields(l_geo_struct_tbl);
542: --ns_debug.put_line('All geo elements passed are valid, use missing elements for geo');
543: -- FND Logging for debug purpose
544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
545: hz_utility_v2pub.debug
546: (p_message => 'All geo elements passed are valid, try reporting missing elements for geo',
547: p_prefix => l_debug_prefix,
548: p_msg_level => fnd_log.level_statement,
549: p_module_prefix => l_module_prefix,

Line 575: hz_utility_v2pub.debug

571: l_not_validated_geo_type := get_geo_type_list(l_geo_struct_tbl,l_temp_level,l_temp_usage);
572:
573: -- FND Logging for debug purpose
574: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
575: hz_utility_v2pub.debug
576: (p_message => 'All required input fields were populated, '||
577: 'very tough to figure out wrong components. '||
578: 'Report invalid comp for which multiple rec found for : '||
579: l_temp_usage||' : '||l_not_validated_geo_type,

Line 600: hz_utility_v2pub.debug

596: l_not_validated_geo_type := get_geo_type_list(l_geo_struct_tbl,l_temp_level,'USAGE');
597:
598: -- FND Logging for debug purpose
599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
600: hz_utility_v2pub.debug
601: (p_message => 'All required geo elements are not passed. Start the list from '||
602: 'next level :'||l_not_validated_geo_type,
603: p_prefix => l_debug_prefix,
604: p_msg_level => fnd_log.level_statement,

Line 614: hz_utility_v2pub.debug

610: END IF;
611:
612: -- FND Logging for debug purpose
613: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
614: hz_utility_v2pub.debug
615: (p_message => 'Everthing passed is valid, but not complete. '||
616: 'Following geo type not validated :'||l_not_validated_geo_type,
617: p_prefix => l_debug_prefix,
618: p_msg_level => fnd_log.level_statement,

Line 637: hz_utility_v2pub.debug

633: END IF; -- country found check
634:
635: -- FND Logging for debug purpose
636: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
637: hz_utility_v2pub.debug
638: (p_message => 'End procedure validate_input_values_proc(-)',
639: p_prefix => l_debug_prefix,
640: p_msg_level => fnd_log.level_procedure,
641: p_module_prefix => l_module_prefix,

Line 650: hz_utility_v2pub.debug

646: EXCEPTION WHEN OTHERS THEN
647: --ns_debug.put_line('Exception occured in validate_input_values_proc:'||SQLERRM);
648: -- FND Logging for debug purpose
649: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
650: hz_utility_v2pub.debug
651: (p_message => 'Error in validate_input_values_proc:'||
652: SUBSTR(SQLERRM,1,200),
653: p_prefix => l_debug_prefix,
654: p_msg_level => fnd_log.level_exception,

Line 1790: hz_utility_v2pub.debug

1786: BEGIN
1787:
1788: -- FND Logging for debug purpose
1789: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1790: hz_utility_v2pub.debug
1791: (p_message => 'Trying to fetch Parents for Multi Parent record for Geo id:'||
1792: ll_geo_id||' and geo type '||ll_geo_type ,
1793: p_prefix => l_debug_prefix,
1794: p_msg_level => fnd_log.level_statement,

Line 1880: hz_utility_v2pub.debug

1876:
1877: -----------------debug statements---------------+
1878: -- FND Logging for debug purpose
1879: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1880: hz_utility_v2pub.debug
1881: (p_message => 'Total NULL cols appended:'||l_total_null_cols_mp,
1882: p_prefix => l_debug_prefix,
1883: p_msg_level => fnd_log.level_statement,
1884: p_module_prefix => l_module_prefix,

Line 1891: hz_utility_v2pub.debug

1887: END IF;
1888:
1889: -- FND Logging for debug purpose
1890: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1891: hz_utility_v2pub.debug
1892: (p_message => 'Multiparent Query :'||l_sql_stmt_mp ,
1893: p_prefix => l_debug_prefix,
1894: p_msg_level => fnd_log.level_statement,
1895: p_module_prefix => l_module_prefix,

Line 2115: hz_utility_v2pub.debug

2111: END IF;
2112:
2113: -- FND Logging for debug purpose
2114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2115: hz_utility_v2pub.debug
2116: (p_message => 'Done with Multi Parent Case...' ,
2117: p_prefix => l_debug_prefix,
2118: p_msg_level => fnd_log.level_statement,
2119: p_module_prefix => l_module_prefix,

Line 2129: hz_utility_v2pub.debug

2125: WHEN INCONSISTENT_DATATYPE THEN
2126: NULL;
2127: -- FND Logging for debug purpose
2128: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2129: hz_utility_v2pub.debug
2130: (p_message => 'INCONSISTENT_DATATYPE Exception in multiple_parent_proc.'||
2131: 'This has occured because HZ_HIERARCHY_NODES data is not '||
2132: 'correctly setup for geography id:'||ll_geo_id ,
2133: p_prefix => l_debug_prefix,

Line 2144: hz_utility_v2pub.debug

2140: WHEN OTHERS THEN
2141: NULL;
2142: -- FND Logging for debug purpose
2143: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2144: hz_utility_v2pub.debug
2145: (p_message => SUBSTR('Exception OTHERS in multiple_parent_proc.'||
2146: 'HZ_HIERARCHY_NODES data is not '||
2147: 'correctly setup for geography id:'||ll_geo_id||':'||SQLERRM,1,255),
2148: p_prefix => l_debug_prefix,

Line 2348: hz_utility_v2pub.debug

2344: l_bind_counter := TO_NUMBER(pp_bind_table.COUNT);
2345:
2346: -- FND Logging for debug purpose
2347: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2348: hz_utility_v2pub.debug
2349: (p_message => 'Search Type:'||pp_search_type||
2350: ', No. of Bind Values:'||TO_CHAR(l_bind_counter),
2351: p_prefix => l_debug_prefix,
2352: p_msg_level => fnd_log.level_statement,

Line 3809: hz_utility_v2pub.debug

3805:
3806: BEGIN
3807: -- FND Logging for debug purpose
3808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3809: hz_utility_v2pub.debug
3810: (p_message => 'Begin procedure check_exact_match_del_rest(+)',
3811: p_prefix => l_debug_prefix,
3812: p_msg_level => fnd_log.level_procedure,
3813: p_module_prefix => l_module_prefix,

Line 3827: hz_utility_v2pub.debug

3823: IF (geo_struct_tbl.COUNT > 0 AND geo_suggest_tbl.COUNT > 0) THEN
3824:
3825: -- FND Logging for debug purpose
3826: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3827: hz_utility_v2pub.debug
3828: (p_message => 'Geo_struct_tbl and geo_suggest_tbl count greater than 0',
3829: p_prefix => l_debug_prefix,
3830: p_msg_level => fnd_log.level_statement,
3831: p_module_prefix => l_module_prefix,

Line 3841: hz_utility_v2pub.debug

3837: IF (geo_struct_tbl(i).v_param_value IS NULL) THEN
3838:
3839: -- FND Logging for debug purpose
3840: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3841: hz_utility_v2pub.debug
3842: (p_message => 'Input value for '||geo_struct_tbl(i).v_tab_col||' is null '||
3843: 'No use proceeding with input out put match. Exiting procedure.',
3844: p_prefix => l_debug_prefix,
3845: p_msg_level => fnd_log.level_statement,

Line 3858: hz_utility_v2pub.debug

3854: END LOOP;
3855: ELSE
3856: -- FND Logging for debug purpose
3857: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3858: hz_utility_v2pub.debug
3859: (p_message => 'Geo_struct_tbl and geo_suggest_tbl count is less than 0.'||
3860: 'No use proceeding with input out put match. Exiting procedure.',
3861: p_prefix => l_debug_prefix,
3862: p_msg_level => fnd_log.level_statement,

Line 3876: hz_utility_v2pub.debug

3872: IF (l_check_next_row = 'Y') THEN
3873:
3874: -- FND Logging for debug purpose
3875: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3876: hz_utility_v2pub.debug
3877: (p_message => 'All params passed. Start matching input values with fetched data',
3878: p_prefix => l_debug_prefix,
3879: p_msg_level => fnd_log.level_statement,
3880: p_module_prefix => l_module_prefix,

Line 3905: hz_utility_v2pub.debug

3901: IF (l_exact_row_match_found = 'Y') THEN
3902:
3903: -- FND Logging for debug purpose
3904: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3905: hz_utility_v2pub.debug
3906: (p_message => 'Exact match found. Copying that row into '||
3907: 'final suggest tbl and deleting rest of suggestions',
3908: p_prefix => l_debug_prefix,
3909: p_msg_level => fnd_log.level_statement,

Line 3933: hz_utility_v2pub.debug

3929: END IF;
3930:
3931: -- FND Logging for debug purpose
3932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3933: hz_utility_v2pub.debug
3934: (p_message => 'Completed procedure check_exact_match_del_rest(-)',
3935: p_prefix => l_debug_prefix,
3936: p_msg_level => fnd_log.level_procedure,
3937: p_module_prefix => l_module_prefix,

Line 4066: hz_utility_v2pub.debug

4062: IF (l_match = 2) THEN
4063:
4064: -- FND Logging for debug purpose
4065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4066: hz_utility_v2pub.debug
4067: (p_message => 'Input values not exactly same as fetched values for usage',
4068: p_prefix => l_debug_prefix,
4069: p_msg_level => fnd_log.level_statement,
4070: p_module_prefix => l_module_prefix,

Line 4080: hz_utility_v2pub.debug

4076: ELSE
4077:
4078: -- FND Logging for debug purpose
4079: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4080: hz_utility_v2pub.debug
4081: (p_message => 'Input values matches fetched values',
4082: p_prefix => l_debug_prefix,
4083: p_msg_level => fnd_log.level_statement,
4084: p_module_prefix => l_module_prefix,

Line 4178: hz_utility_v2pub.debug

4174: l_postal_code := hz_gnr_util_pkg.postal_code_to_validate(p_country_code,p_postal_code);
4175:
4176: -- FND Logging for debug purpose
4177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4178: hz_utility_v2pub.debug
4179: (p_message => 'Postal Code at build_geo_struct_tbl_pvt : '||l_postal_code,
4180: p_prefix => l_debug_prefix,
4181: p_msg_level => fnd_log.level_statement,
4182: p_module_prefix => l_module_prefix,

Line 4199: hz_utility_v2pub.debug

4195: END IF;
4196:
4197: -- FND Logging for debug purpose
4198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4199: hz_utility_v2pub.debug
4200: (p_message => 'Address Style passed is :'||l_address_style,
4201: p_prefix => l_debug_prefix,
4202: p_msg_level => fnd_log.level_statement,
4203: p_module_prefix => l_module_prefix,

Line 4226: hz_utility_v2pub.debug

4222: IF (geo_struct_tbl.COUNT = 0) THEN
4223:
4224: -- FND Logging for debug purpose
4225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4226: hz_utility_v2pub.debug
4227: (p_message => 'Either address style is NULL or mapping for passed address style not found.'||
4228: ' Trying with NULL address style.',
4229: p_prefix => l_debug_prefix,
4230: p_msg_level => fnd_log.level_statement,

Line 4276: hz_utility_v2pub.debug

4272: END IF;
4273:
4274: -- FND Logging for debug purpose
4275: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4276: hz_utility_v2pub.debug
4277: (p_message => 'Mapped structure count :'||TO_CHAR(geo_struct_tbl.COUNT),
4278: p_prefix => l_debug_prefix,
4279: p_msg_level => fnd_log.level_statement,
4280: p_module_prefix => l_module_prefix,

Line 4393: hz_utility_v2pub.debug

4389: END LOOP;
4390:
4391: -- FND Logging for debug purpose
4392: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4393: hz_utility_v2pub.debug
4394: (p_message => SUBSTR('Mapped Columns:'||l_mapped_column_list,1,255),
4395: p_prefix => l_debug_prefix,
4396: p_msg_level => fnd_log.level_statement,
4397: p_module_prefix => l_module_prefix,

Line 4404: hz_utility_v2pub.debug

4400: END IF;
4401:
4402: -- FND Logging for debug purpose
4403: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4404: hz_utility_v2pub.debug
4405: (p_message => SUBSTR('Mapped Geo Types:'||l_mapped_geo_type_list,1,255),
4406: p_prefix => l_debug_prefix,
4407: p_msg_level => fnd_log.level_statement,
4408: p_module_prefix => l_module_prefix,

Line 4415: hz_utility_v2pub.debug

4411: END IF;
4412:
4413: -- FND Logging for debug purpose
4414: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4415: hz_utility_v2pub.debug
4416: (p_message => SUBSTR('Passed Param Values'||l_passed_param_values,1,255),
4417: p_prefix => l_debug_prefix,
4418: p_msg_level => fnd_log.level_statement,
4419: p_module_prefix => l_module_prefix,

Line 4426: hz_utility_v2pub.debug

4422: END IF;
4423:
4424: -- FND Logging for debug purpose
4425: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4426: hz_utility_v2pub.debug
4427: (p_message => 'Max Mapped Element Column Value:'||TO_CHAR(l_max_mapped_element_col_value),
4428: p_prefix => l_debug_prefix,
4429: p_msg_level => fnd_log.level_statement,
4430: p_module_prefix => l_module_prefix,

Line 4437: hz_utility_v2pub.debug

4433: END IF;
4434:
4435: -- FND Logging for debug purpose
4436: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4437: hz_utility_v2pub.debug
4438: (p_message => 'Max Geo Usage Element Col Value:'||TO_CHAR(l_max_usage_element_col_value),
4439: p_prefix => l_debug_prefix,
4440: p_msg_level => fnd_log.level_statement,
4441: p_module_prefix => l_module_prefix,

Line 4448: hz_utility_v2pub.debug

4444: END IF;
4445:
4446: -- FND Logging for debug purpose
4447: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4448: hz_utility_v2pub.debug
4449: (p_message => 'Max Geo Type for which Geo usage is marked: '||l_lowest_usage_geo_type,
4450: p_prefix => l_debug_prefix,
4451: p_msg_level => fnd_log.level_statement,
4452: p_module_prefix => l_module_prefix,

Line 4459: hz_utility_v2pub.debug

4455: END IF;
4456:
4457: -- FND Logging for debug purpose
4458: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4459: hz_utility_v2pub.debug
4460: (p_message => 'Lowest Geo Type for which Geo usage is marked and value is passed: '||l_last_geo_type_usg_val_psd,
4461: p_prefix => l_debug_prefix,
4462: p_msg_level => fnd_log.level_statement,
4463: p_module_prefix => l_module_prefix,

Line 4682: hz_utility_v2pub.debug

4678: -- This will be based on the order of mapping fo components.
4679: ---------------------------------------------------------------------+
4680: -- FND Logging for debug purpose
4681: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4682: hz_utility_v2pub.debug
4683: (p_message => 'Building Suggestion list for Java APIs: build_suggestion_list(+)',
4684: p_prefix => l_debug_prefix,
4685: p_msg_level => fnd_log.level_procedure,
4686: p_module_prefix => l_module_prefix,

Line 4704: HZ_UTILITY_V2PUB.DEBUG

4700: END LOOP;
4701:
4702: -- FND LOGGING FOR DEBUG PURPOSE
4703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4704: HZ_UTILITY_V2PUB.DEBUG
4705: (P_MESSAGE => 'Begin procedure quick_sort_suggestion_list(+)',
4706: P_PREFIX => L_DEBUG_PREFIX,
4707: P_MSG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4708: P_MODULE_PREFIX => L_MODULE_PREFIX,

Line 4717: hz_utility_v2pub.debug

4713: -- do sorting on geo_suggest_tbl based on suggestion_list column
4714: quick_sort_suggestion_list(geo_suggest_tbl.FIRST, geo_suggest_tbl.LAST, geo_suggest_tbl);
4715:
4716: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4717: hz_utility_v2pub.debug
4718: (p_message => 'End procedure quick_sort_suggestion_list(-)',
4719: p_prefix => l_debug_prefix,
4720: p_msg_level => fnd_log.level_procedure,
4721: p_module_prefix => l_module_prefix,

Line 4735: hz_utility_v2pub.debug

4731: IF (geo_suggest_tbl.COUNT = 1) THEN
4732:
4733: -- FND Logging for debug purpose
4734: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4735: hz_utility_v2pub.debug
4736: (p_message => 'Only 1 row in Suggestion list. Its value is:'||geo_suggest_tbl(1).suggestion_list,
4737: p_prefix => l_debug_prefix,
4738: p_msg_level => fnd_log.level_procedure,
4739: p_module_prefix => l_module_prefix,

Line 4750: hz_utility_v2pub.debug

4746: geo_suggest_tbl.DELETE(1);
4747:
4748: -- FND Logging for debug purpose
4749: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4750: hz_utility_v2pub.debug
4751: (p_message => 'Since value in suggestion list is NULL or of 0 length,'||
4752: 'deleting the row from geo_suggest_tbl',
4753: p_prefix => l_debug_prefix,
4754: p_msg_level => fnd_log.level_procedure,

Line 4765: hz_utility_v2pub.debug

4761: END IF;
4762:
4763: -- FND Logging for debug purpose
4764: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4765: hz_utility_v2pub.debug
4766: (p_message => 'Completed building Suggestion list for Java APIs: build_suggestion_list(-)',
4767: p_prefix => l_debug_prefix,
4768: p_msg_level => fnd_log.level_procedure,
4769: p_module_prefix => l_module_prefix,

Line 4831: hz_utility_v2pub.debug

4827: l_msg_token_name VARCHAR2(100);
4828: BEGIN
4829: -- FND Logging for debug purpose
4830: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4831: hz_utility_v2pub.debug
4832: (p_message => 'BEGIN: process_output_data_proc(+)',
4833: p_prefix => l_debug_prefix,
4834: p_msg_level => fnd_log.level_procedure,
4835: p_module_prefix => l_module_prefix,

Line 4848: hz_utility_v2pub.debug

4844: IF (l_addr_val_level = 'ERROR') THEN
4845:
4846: -- FND Logging for debug purpose
4847: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4848: hz_utility_v2pub.debug
4849: (p_message => 'Validation Level : ERROR',
4850: p_prefix => l_debug_prefix,
4851: p_msg_level => fnd_log.level_statement,
4852: p_module_prefix => l_module_prefix,

Line 4862: hz_utility_v2pub.debug

4858: IF ((HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NOT NULL) AND -- this is 2nd attempt
4859: (l_success = 'Y')) THEN
4860: -- FND Logging for debug purpose
4861: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4862: hz_utility_v2pub.debug
4863: (p_message => 'Geo Validated Address is complete, return code=0(ADDRESS_COMPLETE)',
4864: p_prefix => l_debug_prefix,
4865: p_msg_level => fnd_log.level_statement,
4866: p_module_prefix => l_module_prefix,

Line 4884: hz_utility_v2pub.debug

4880:
4881: -- FND Logging for debug purpose
4882: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4883:
4884: hz_utility_v2pub.debug
4885: (p_message => 'Records count is 0, return code= -1(ADDRESS_INVALID)',
4886: p_prefix => l_debug_prefix,
4887: p_msg_level => fnd_log.level_statement,
4888: p_module_prefix => l_module_prefix,

Line 4927: hz_utility_v2pub.debug

4923: IF (do_input_output_match_check) THEN
4924:
4925: -- FND Logging for debug purpose
4926: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4927: hz_utility_v2pub.debug
4928: (p_message => 'Address is complete, return code=0(ADDRESS_COMPLETE)',
4929: p_prefix => l_debug_prefix,
4930: p_msg_level => fnd_log.level_statement,
4931: p_module_prefix => l_module_prefix,

Line 4945: hz_utility_v2pub.debug

4941:
4942: ELSE
4943: -- FND Logging for debug purpose
4944: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4945: hz_utility_v2pub.debug
4946: (p_message => 'input output match check failed, return code=1(ADDRESS_VALID)',
4947: p_prefix => l_debug_prefix,
4948: p_msg_level => fnd_log.level_statement,
4949: p_module_prefix => l_module_prefix,

Line 4978: hz_utility_v2pub.debug

4974: ((geo_suggest_tbl.COUNT > 1) AND (l_geo_data_count > l_max_fetch_count)) THEN
4975:
4976: -- FND Logging for debug purpose
4977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4978: hz_utility_v2pub.debug
4979: (p_message => 'more than 55 records, return code=1000(TOO_MANY_ROWS)',
4980: p_prefix => l_debug_prefix,
4981: p_msg_level => fnd_log.level_statement,
4982: p_module_prefix => l_module_prefix,

Line 5012: hz_utility_v2pub.debug

5008: ELSE -- between 2 and 55
5009:
5010: -- FND Logging for debug purpose
5011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5012: hz_utility_v2pub.debug
5013: (p_message => 'No. of records between 2 and 55, return code=1(ADDRESS_VALID)',
5014: p_prefix => l_debug_prefix,
5015: p_msg_level => fnd_log.level_statement,
5016: p_module_prefix => l_module_prefix,

Line 5047: hz_utility_v2pub.debug

5043: IF (l_addr_val_level = 'WARNING') THEN
5044:
5045: -- FND Logging for debug purpose
5046: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5047: hz_utility_v2pub.debug
5048: (p_message => 'Validation Level : WARNING',
5049: p_prefix => l_debug_prefix,
5050: p_msg_level => fnd_log.level_statement,
5051: p_module_prefix => l_module_prefix,

Line 5060: hz_utility_v2pub.debug

5056: IF (geo_suggest_tbl.COUNT = 0) THEN
5057:
5058: -- FND Logging for debug purpose
5059: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5060: hz_utility_v2pub.debug
5061: (p_message => 'No. of records 0, return code=1(ADDRESS_VALID)',
5062: p_prefix => l_debug_prefix,
5063: p_msg_level => fnd_log.level_statement,
5064: p_module_prefix => l_module_prefix,

Line 5083: hz_utility_v2pub.debug

5079: IF (do_input_output_match_check) THEN
5080:
5081: -- FND Logging for debug purpose
5082: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5083: hz_utility_v2pub.debug
5084: (p_message => 'No. of records 1, exact match, return code=0(ADDRESS_COMPLETE)',
5085: p_prefix => l_debug_prefix,
5086: p_msg_level => fnd_log.level_statement,
5087: p_module_prefix => l_module_prefix,

Line 5099: hz_utility_v2pub.debug

5095: ELSE -- input output match check failed
5096:
5097: -- FND Logging for debug purpose
5098: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5099: hz_utility_v2pub.debug
5100: (p_message => 'No. of records 1, input output match check failed, '||
5101: 'return code=1(ADDRESS_VALID)',
5102: p_prefix => l_debug_prefix,
5103: p_msg_level => fnd_log.level_statement,

Line 5121: hz_utility_v2pub.debug

5117: ((geo_suggest_tbl.COUNT > 1) AND (l_geo_data_count > l_max_fetch_count)) THEN
5118:
5119: -- FND Logging for debug purpose
5120: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5121: hz_utility_v2pub.debug
5122: (p_message => 'No. of records more than 55, '||
5123: 'return code=1000(TOO_MANY_ROWS)',
5124: p_prefix => l_debug_prefix,
5125: p_msg_level => fnd_log.level_statement,

Line 5144: hz_utility_v2pub.debug

5140: ELSE -- between 2 and 55
5141:
5142: -- FND Logging for debug purpose
5143: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5144: hz_utility_v2pub.debug
5145: (p_message => 'No. of records between 2 and 55, '||
5146: 'return code=1(ADDRESS_VALID)',
5147: p_prefix => l_debug_prefix,
5148: p_msg_level => fnd_log.level_statement,

Line 5167: hz_utility_v2pub.debug

5163: IF (l_addr_val_level = 'MINIMUM') THEN
5164:
5165: -- FND Logging for debug purpose
5166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5167: hz_utility_v2pub.debug
5168: (p_message => 'Validation Level : MINIMUM',
5169: p_prefix => l_debug_prefix,
5170: p_msg_level => fnd_log.level_statement,
5171: p_module_prefix => l_module_prefix,

Line 5183: hz_utility_v2pub.debug

5179: IF (l_miss_min_geo_type IS NOT NULL) THEN -- minimum check failed
5180:
5181: -- FND Logging for debug purpose
5182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5183: hz_utility_v2pub.debug
5184: (p_message => 'Minimum check failed, '||
5185: 'return code=-1(ADDRESS_INVALID)',
5186: p_prefix => l_debug_prefix,
5187: p_msg_level => fnd_log.level_statement,

Line 5202: hz_utility_v2pub.debug

5198: ELSE -- minimum check passed
5199:
5200: -- FND Logging for debug purpose
5201: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5202: hz_utility_v2pub.debug
5203: (p_message => 'Minimum check passed, '||
5204: 'return code=0(ADDRESS_COMPLETE)',
5205: p_prefix => l_debug_prefix,
5206: p_msg_level => fnd_log.level_statement,

Line 5221: hz_utility_v2pub.debug

5217:
5218: IF (l_addr_val_level = 'NONE') THEN
5219: -- FND Logging for debug purpose
5220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5221: hz_utility_v2pub.debug
5222: (p_message => 'Validation Level : NONE, return code=0(ADDRESS_COMPLETE)',
5223: p_prefix => l_debug_prefix,
5224: p_msg_level => fnd_log.level_statement,
5225: p_module_prefix => l_module_prefix,

Line 5236: hz_utility_v2pub.debug

5232: END IF; -- validation level = MINIMUM
5233:
5234: -- FND Logging for debug purpose
5235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5236: hz_utility_v2pub.debug
5237: (p_message => 'End: process_output_data_proc(-)',
5238: p_prefix => l_debug_prefix,
5239: p_msg_level => fnd_log.level_procedure,
5240: p_module_prefix => l_module_prefix,

Line 5382: hz_utility_v2pub.debug

5378: IF (geo_struct_tbl.COUNT > 1) THEN
5379:
5380: -- FND Logging for debug purpose
5381: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5382: hz_utility_v2pub.debug
5383: (p_message => 'Trying to fetch children for complete next level...',
5384: p_prefix => l_debug_prefix,
5385: p_msg_level => fnd_log.level_statement,
5386: p_module_prefix => l_module_prefix,

Line 5397: hz_utility_v2pub.debug

5393: -- ns_debug.put_line('MAX FETCH VALUE :'||l_max_fetched_value);
5394:
5395: -- FND Logging for debug purpose
5396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5397: hz_utility_v2pub.debug
5398: (p_message => 'l_max_fetched_value:'||l_max_fetched_value
5399: ||' l_max_mapped_element_col_value:'||l_max_mapped_element_col_value,
5400: p_prefix => l_debug_prefix,
5401: p_msg_level => fnd_log.level_statement,

Line 5413: hz_utility_v2pub.debug

5409: IF (l_max_fetched_value < l_max_mapped_element_col_value) THEN
5410:
5411: -- FND Logging for debug purpose
5412: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5413: hz_utility_v2pub.debug
5414: (p_message => 'Trying to get child data...',
5415: p_prefix => l_debug_prefix,
5416: p_msg_level => fnd_log.level_statement,
5417: p_module_prefix => l_module_prefix,

Line 5480: hz_utility_v2pub.debug

5476: l_sql_stmt_child := l_select_child||l_from_child||l_where_child;
5477:
5478: -- FND Logging for debug purpose
5479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5480: hz_utility_v2pub.debug
5481: (p_message => 'Total NULL columns appended in fetch child query :'||l_total_null_cols_child,
5482: p_prefix => l_debug_prefix,
5483: p_msg_level => fnd_log.level_statement,
5484: p_module_prefix => l_module_prefix,

Line 5491: hz_utility_v2pub.debug

5487: END IF;
5488:
5489: -- FND Logging for debug purpose
5490: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5491: hz_utility_v2pub.debug
5492: (p_message => 'Child Query :'||l_sql_stmt_child,
5493: p_prefix => l_debug_prefix,
5494: p_msg_level => fnd_log.level_statement,
5495: p_module_prefix => l_module_prefix,

Line 5787: hz_utility_v2pub.debug

5783: BEGIN
5784:
5785: -- FND Logging for debug purpose
5786: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5787: hz_utility_v2pub.debug
5788: (p_message => 'BEGIN: Address Suggestion API',
5789: p_prefix => l_debug_prefix,
5790: p_msg_level => fnd_log.level_statement,
5791: p_module_prefix => l_module_prefix,

Line 5819: hz_utility_v2pub.debug

5815: l_address_usage := 'GEOGRAPHY';
5816:
5817: -- FND Logging for debug purpose
5818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5819: hz_utility_v2pub.debug
5820: (p_message => 'Get mapping details. Call build_geo_struct_tbl_pvt(+)',
5821: p_prefix => l_debug_prefix,
5822: p_msg_level => fnd_log.level_procedure,
5823: p_module_prefix => l_module_prefix,

Line 5834: hz_utility_v2pub.debug

5830: build_geo_struct_tbl_pvt(p_country_code, p_address_style, p_table_name, l_address_usage);
5831:
5832: -- FND Logging for debug purpose
5833: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5834: hz_utility_v2pub.debug
5835: (p_message => 'Finished calling build_geo_struct_tbl_pvt(-)',
5836: p_prefix => l_debug_prefix,
5837: p_msg_level => fnd_log.level_procedure,
5838: p_module_prefix => l_module_prefix,

Line 5852: hz_utility_v2pub.debug

5848: x_validation_level := l_addr_val_level;
5849:
5850: -- FND Logging for debug purpose
5851: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5852: hz_utility_v2pub.debug
5853: (p_message => 'Validation Level:'||l_addr_val_level,
5854: p_prefix => l_debug_prefix,
5855: p_msg_level => fnd_log.level_statement,
5856: p_module_prefix => l_module_prefix,

Line 5884: hz_utility_v2pub.debug

5880: IF (l_addr_val_level = 'ERROR') THEN
5881:
5882: -- FND Logging for debug purpose
5883: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5884: hz_utility_v2pub.debug
5885: (p_message => 'Performing Geo Validation to see if it will pass or fail later with current data (+)',
5886: p_prefix => l_debug_prefix,
5887: p_msg_level => fnd_log.level_statement,
5888: p_module_prefix => l_module_prefix,

Line 5929: hz_utility_v2pub.debug

5925: l_success := 'N';
5926:
5927: -- FND Logging for debug purpose
5928: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5929: hz_utility_v2pub.debug
5930: (p_message => 'Geo Validation Failed. Perform suggestion logic.',
5931: p_prefix => l_debug_prefix,
5932: p_msg_level => fnd_log.level_statement,
5933: p_module_prefix => l_module_prefix,

Line 5946: hz_utility_v2pub.debug

5942: l_geo_validation_passed := 'Y'; -- This will be used while setting message for validation level ERROR
5943:
5944: -- FND Logging for debug purpose
5945: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5946: hz_utility_v2pub.debug
5947: (p_message => 'Even though Geo Validation Passed, it was users 1st attempt, so continue with suggestion..',
5948: p_prefix => l_debug_prefix,
5949: p_msg_level => fnd_log.level_statement,
5950: p_module_prefix => l_module_prefix,

Line 5960: hz_utility_v2pub.debug

5956: l_success := 'Y';
5957:
5958: -- FND Logging for debug purpose
5959: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5960: hz_utility_v2pub.debug
5961: (p_message => 'Geo Validation Successful. No need for suggestion.',
5962: p_prefix => l_debug_prefix,
5963: p_msg_level => fnd_log.level_statement,
5964: p_module_prefix => l_module_prefix,

Line 5979: hz_utility_v2pub.debug

5975: l_success := 'N';
5976:
5977: -- FND Logging for debug purpose
5978: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5979: hz_utility_v2pub.debug
5980: (p_message => 'Exception happend in Geo Validation API. Perform suggestion logic. '||SQLERRM,
5981: p_prefix => l_debug_prefix,
5982: p_msg_level => fnd_log.level_statement,
5983: p_module_prefix => l_module_prefix,

Line 5997: hz_utility_v2pub.debug

5993: --ns_debug.put_line('Second Pass Test Failed...');
5994:
5995: -- FND Logging for debug purpose
5996: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5997: hz_utility_v2pub.debug
5998: (p_message => 'Validation level is not ERROR...Did not go into Geo Validation check..',
5999: p_prefix => l_debug_prefix,
6000: p_msg_level => fnd_log.level_statement,
6001: p_module_prefix => l_module_prefix,

Line 6015: hz_utility_v2pub.debug

6011: IF (l_addr_val_level IN ('ERROR','WARNING') AND (l_success = 'N')) THEN
6012:
6013: -- FND Logging for debug purpose
6014: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6015: hz_utility_v2pub.debug
6016: (p_message => 'Mapped Elements Table Count:'||NVL(geo_struct_tbl.COUNT,0),
6017: p_prefix => l_debug_prefix,
6018: p_msg_level => fnd_log.level_statement,
6019: p_module_prefix => l_module_prefix,

Line 6036: HZ_UTILITY_V2PUB.DEBUG

6032: l_initcap_option := NVL(FND_PROFILE.VALUE('HZ_ADD_SUGG_AS_IS'), 'CAPITALIZE_FIRST_CHAR');
6033:
6034: -- FND Logging for debug purpose
6035: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6036: HZ_UTILITY_V2PUB.DEBUG
6037: (P_MESSAGE => 'Value for Profile HZ: County and City in Address Suggestion is:'||L_INITCAP_OPTION
6038: ||' . If it is NULL, code will use value CAPITALIZE_FIRST_CHAR ',
6039: P_PREFIX => L_DEBUG_PREFIX,
6040: p_msg_level => fnd_log.level_statement,

Line 6081: hz_utility_v2pub.debug

6077: -- exist in mapping table.
6078: -------------------------------------------------------------------+
6079: -- FND Logging for debug purpose
6080: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6081: hz_utility_v2pub.debug
6082: (p_message => 'Begin search 1 for ALL_PASSED_PARAM_SEARCH (+)',
6083: p_prefix => l_debug_prefix,
6084: p_msg_level => fnd_log.level_procedure,
6085: p_module_prefix => l_module_prefix,

Line 6096: hz_utility_v2pub.debug

6092: pt_bind_table => bind_table_1);
6093:
6094: -- FND Logging for debug purpose
6095: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6096: hz_utility_v2pub.debug
6097: (p_message => 'End of search 1 for ALL_PASSED_PARAM_SEARCH (-)',
6098: p_prefix => l_debug_prefix,
6099: p_msg_level => fnd_log.level_procedure,
6100: p_module_prefix => l_module_prefix,

Line 6140: hz_utility_v2pub.debug

6136: -- This will put data in geo_suggest_tbl also
6137:
6138: -- FND Logging for debug purpose
6139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6140: hz_utility_v2pub.debug
6141: (p_message => '1 Rec found in ALL_PASSED_PARAM_SEARCH. Performing child search (+)',
6142: p_prefix => l_debug_prefix,
6143: p_msg_level => fnd_log.level_procedure,
6144: p_module_prefix => l_module_prefix,

Line 6153: hz_utility_v2pub.debug

6149: get_next_level_children_proc;
6150:
6151: -- FND Logging for debug purpose
6152: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6153: hz_utility_v2pub.debug
6154: (p_message => 'Child search for ALL_PASSED_PARAM_SEARCH completed (-)',
6155: p_prefix => l_debug_prefix,
6156: p_msg_level => fnd_log.level_procedure,
6157: p_module_prefix => l_module_prefix,

Line 6190: hz_utility_v2pub.debug

6186: )THEN
6187:
6188: -- FND Logging for debug purpose
6189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6190: hz_utility_v2pub.debug
6191: (p_message => 'Begin search 2..l_max_passed_element_col_value='||
6192: l_max_passed_element_col_value||' l_max_mapped_element_col_value='||
6193: l_max_mapped_element_col_value,
6194: p_prefix => l_debug_prefix,

Line 6216: hz_utility_v2pub.debug

6212: IF (l_count_for_where_clause_2 = 2) THEN
6213:
6214: -- FND Logging for debug purpose
6215: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6216: hz_utility_v2pub.debug
6217: (p_message => 'For Where Clause 2...required params are passed',
6218: p_prefix => l_debug_prefix,
6219: p_msg_level => fnd_log.level_statement,
6220: p_module_prefix => l_module_prefix,

Line 6253: hz_utility_v2pub.debug

6249: -- build where clause
6250: IF (l_count_for_where_clause_3 = 2) THEN
6251: -- FND Logging for debug purpose
6252: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6253: hz_utility_v2pub.debug
6254: (p_message => 'For Where Clause 3...required params are passed',
6255: p_prefix => l_debug_prefix,
6256: p_msg_level => fnd_log.level_statement,
6257: p_module_prefix => l_module_prefix,

Line 6282: hz_utility_v2pub.debug

6278: IF ((l_count_for_where_clause_2 = 2) OR (l_count_for_where_clause_3 = 2)) THEN
6279:
6280: -- FND Logging for debug purpose
6281: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6282: hz_utility_v2pub.debug
6283: (p_message => 'Begin search 2 for LEVEL4_UNION_LEVEL5_SEARCH (+)',
6284: p_prefix => l_debug_prefix,
6285: p_msg_level => fnd_log.level_procedure,
6286: p_module_prefix => l_module_prefix,

Line 6297: hz_utility_v2pub.debug

6293: pt_bind_table => bind_table_2);
6294:
6295: -- FND Logging for debug purpose
6296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6297: hz_utility_v2pub.debug
6298: (p_message => 'End search 3 for LEVEL4_UNION_LEVEL5_SEARCH (-)',
6299: p_prefix => l_debug_prefix,
6300: p_msg_level => fnd_log.level_procedure,
6301: p_module_prefix => l_module_prefix,

Line 6310: hz_utility_v2pub.debug

6306: ELSE -- ignored LEVEL4_UNION_LEVEL5_SEARCH search
6307:
6308: -- FND Logging for debug purpose
6309: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6310: hz_utility_v2pub.debug
6311: (p_message => 'Ignored LEVEL4_UNION_LEVEL5_SEARCH because values for '||
6312: 'neither Level1+Level(n) '||
6313: 'nor Level1 + Level(n-1) are passed',
6314: p_prefix => l_debug_prefix,

Line 6328: hz_utility_v2pub.debug

6324: IF (geo_rec_tbl.COUNT = 1) THEN
6325:
6326: -- FND Logging for debug purpose
6327: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6328: hz_utility_v2pub.debug
6329: (p_message => '1 Rec found in LEVEL4_UNION_LEVEL5_SEARCH. Performing child search (+)',
6330: p_prefix => l_debug_prefix,
6331: p_msg_level => fnd_log.level_procedure,
6332: p_module_prefix => l_module_prefix,

Line 6341: hz_utility_v2pub.debug

6337: get_next_level_children_proc;
6338:
6339: -- FND Logging for debug purpose
6340: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6341: hz_utility_v2pub.debug
6342: (p_message => 'Completed child search for LEVEL4_UNION_LEVEL5_SEARCH (-)',
6343: p_prefix => l_debug_prefix,
6344: p_msg_level => fnd_log.level_procedure,
6345: p_module_prefix => l_module_prefix,

Line 6406: hz_utility_v2pub.debug

6402: IF (geo_rec_tbl.COUNT = 1) THEN
6403:
6404: -- FND Logging for debug purpose
6405: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6406: hz_utility_v2pub.debug
6407: (p_message => '1 record found for SEARCH_FROM_TOP search. Performing child search (+)',
6408: p_prefix => l_debug_prefix,
6409: p_msg_level => fnd_log.level_procedure,
6410: p_module_prefix => l_module_prefix,

Line 6419: hz_utility_v2pub.debug

6415: get_next_level_children_proc;
6416:
6417: -- FND Logging for debug purpose
6418: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6419: hz_utility_v2pub.debug
6420: (p_message => 'Completed child search for SEARCH_FROM_TOP search.(-)',
6421: p_prefix => l_debug_prefix,
6422: p_msg_level => fnd_log.level_procedure,
6423: p_module_prefix => l_module_prefix,

Line 6446: hz_utility_v2pub.debug

6442: IF ((geo_suggest_tbl.COUNT = 0) AND (geo_rec_tbl.COUNT > 0)) THEN
6443:
6444: -- FND Logging for debug purpose
6445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6446: hz_utility_v2pub.debug
6447: (p_message => 'Geo_suggest_tbl count is 0.. while geo_rec_tbl count is '
6448: ||TO_CHAR(geo_rec_tbl.COUNT),
6449: p_prefix => l_debug_prefix,
6450: p_msg_level => fnd_log.level_statement,

Line 6462: hz_utility_v2pub.debug

6458: END LOOP;
6459:
6460: -- FND Logging for debug purpose
6461: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6462: hz_utility_v2pub.debug
6463: (p_message => 'Moved records from geo_rec_tbl to geo_suggest_tbl',
6464: p_prefix => l_debug_prefix,
6465: p_msg_level => fnd_log.level_statement,
6466: p_module_prefix => l_module_prefix,

Line 6493: hz_utility_v2pub.debug

6489: ELSIF (geo_struct_tbl.COUNT = 0) THEN
6490:
6491: -- FND Logging for debug purpose
6492: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6493: hz_utility_v2pub.debug
6494: (p_message => 'No Mapping Exists for passed country code and '||
6495: 'address style combination (return code = NO_MAPPING_EXISTS)',
6496: p_prefix => l_debug_prefix,
6497: p_msg_level => fnd_log.level_statement,

Line 6516: hz_utility_v2pub.debug

6512: ELSE -- Validation level is MINIMUM or NONE
6513:
6514: -- FND Logging for debug purpose
6515: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6516: hz_utility_v2pub.debug
6517: (p_message => 'Validation Level is :'||l_addr_val_level||
6518: '. Calling procedure process_output_data_proc(+)',
6519: p_prefix => l_debug_prefix,
6520: p_msg_level => fnd_log.level_procedure,

Line 6530: hz_utility_v2pub.debug

6526: process_output_data_proc;
6527:
6528: -- FND Logging for debug purpose
6529: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6530: hz_utility_v2pub.debug
6531: (p_message => 'Completed procedure process_output_data_proc(-)',
6532: p_prefix => l_debug_prefix,
6533: p_msg_level => fnd_log.level_procedure,
6534: p_module_prefix => l_module_prefix,

Line 6543: hz_utility_v2pub.debug

6539: END IF;
6540:
6541: -- FND Logging for debug purpose
6542: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6543: hz_utility_v2pub.debug
6544: (p_message => 'END: Address Suggestion API.'||
6545: ' Value of x_return_code='||x_return_code||
6546: ', x_records_count='||x_records_count ,
6547: p_prefix => l_debug_prefix,

Line 6559: hz_utility_v2pub.debug

6555: WHEN OTHERS THEN
6556:
6557: -- FND Logging for debug purpose
6558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
6559: hz_utility_v2pub.debug
6560: (p_message => SUBSTR('SYSTEM ERROR occured in Address Suggestion API. '||
6561: SQLERRM, 1,255),
6562: p_prefix => l_debug_prefix,
6563: p_msg_level => fnd_log.level_exception,