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 FND_LOG

Line 148: -- FND Logging for debug purpose

144: TYPE cur_sql_type IS REF CURSOR;
145: cv_sql cur_sql_type;
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,

Line 149: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

145: cv_sql cur_sql_type;
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,

Line 153: p_msg_level => fnd_log.level_procedure,

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,
155: p_module => l_module
156: );
157: END IF;

Line 171: -- FND Logging for debug purpose

167: CLOSE c_geo_id;
168:
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,

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

168:
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,

Line 176: p_msg_level => fnd_log.level_statement,

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,
178: p_module => l_module
179: );
180: END IF;

Line 444: -- FND Logging for debug purpose

440: --ns_debug.put_line('Record Count Flag ='||l_rec_count_flag);
441: --ns_debug.put_line('Level ='||l_level);
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,

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

441: --ns_debug.put_line('Level ='||l_level);
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,

Line 450: p_msg_level => fnd_log.level_statement,

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,
451: p_module_prefix => l_module_prefix,
452: p_module => l_module
453: );
454: END IF;

Line 463: -- FND Logging for debug purpose

459: -- If we have unique record till user entered value, tell user values from next level
460: IF (l_success_rec_count = '1') THEN
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,

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

460: IF (l_success_rec_count = '1') THEN
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,

Line 468: p_msg_level => fnd_log.level_statement,

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,
470: p_module => l_module
471: );
472: END IF;

Line 490: -- FND Logging for debug purpose

486: IF (l_not_validated_geo_type IS NULL) THEN
487: l_not_validated_geo_type := get_geo_type_list(l_geo_struct_tbl, l_success_geo_level, 'USAGE');
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,

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

487: l_not_validated_geo_type := get_geo_type_list(l_geo_struct_tbl, l_success_geo_level, 'USAGE');
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,

Line 496: p_msg_level => fnd_log.level_statement,

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,
497: p_module_prefix => l_module_prefix,
498: p_module => l_module
499: );
500: END IF;

Line 504: -- FND Logging for debug purpose

500: END IF;
501:
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,

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

501:
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,

Line 510: p_msg_level => fnd_log.level_statement,

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,
511: p_module_prefix => l_module_prefix,
512: p_module => l_module
513: );
514: END IF;

Line 525: -- FND Logging for debug purpose

521: -- i.e. 1. or more rec found but it is not complete for geo usage
522: -- l_rec_count_flag > 0
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,

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

522: -- l_rec_count_flag > 0
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,

Line 530: p_msg_level => fnd_log.level_statement,

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,
532: p_module => l_module
533: );
534: END IF;

Line 543: -- FND Logging for debug purpose

539: -- Corner case. Should not happen.
540: IF (l_success_geo_level >= lx_max_usage_element_col_value) THEN
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,

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

540: IF (l_success_geo_level >= lx_max_usage_element_col_value) THEN
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,

Line 548: p_msg_level => fnd_log.level_statement,

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,
550: p_module => l_module
551: );
552: END IF;

Line 573: -- FND Logging for debug purpose

569: END IF;
570:
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. '||

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

570:
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 : '||

Line 581: p_msg_level => fnd_log.level_statement,

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,
580: p_prefix => l_debug_prefix,
581: p_msg_level => fnd_log.level_statement,
582: p_module_prefix => l_module_prefix,
583: p_module => l_module
584: );
585: END IF;

Line 598: -- FND Logging for debug purpose

594: END IF;
595:
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,

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

595:
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,

Line 604: p_msg_level => fnd_log.level_statement,

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,
605: p_module_prefix => l_module_prefix,
606: p_module => l_module
607: );
608: END IF;

Line 612: -- FND Logging for debug purpose

608: END IF;
609:
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,

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

609:
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,

Line 618: p_msg_level => fnd_log.level_statement,

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,
619: p_module_prefix => l_module_prefix,
620: p_module => l_module
621: );
622: END IF;

Line 635: -- FND Logging for debug purpose

631: END IF; -- end of geo structure tbl > 0 count
632:
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,

Line 636: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

632:
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,

Line 640: p_msg_level => fnd_log.level_procedure,

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,
642: p_module => l_module
643: );
644: END IF;

Line 648: -- FND Logging for debug purpose

644: END IF;
645:
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),

Line 649: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

645:
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,

Line 654: p_msg_level => fnd_log.level_exception,

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,
655: p_module_prefix => l_module_prefix,
656: p_module => l_module
657: );
658: END IF;

Line 1788: -- FND Logging for debug purpose

1784: PRAGMA EXCEPTION_INIT(INCONSISTENT_DATATYPE, -932);
1785:
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 ,

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

1785:
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,

Line 1794: p_msg_level => fnd_log.level_statement,

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,
1795: p_module_prefix => l_module_prefix,
1796: p_module => l_module
1797: );
1798: END IF;

Line 1878: -- FND Logging for debug purpose

1874: -- ns_debug.put_line(l_sql_stmt_mp);
1875: -- ns_debug.put_line(' ======================');
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,

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

1875: -- ns_debug.put_line(' ======================');
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,

Line 1883: p_msg_level => fnd_log.level_statement,

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,
1885: p_module => l_module
1886: );
1887: END IF;

Line 1889: -- FND Logging for debug purpose

1885: p_module => l_module
1886: );
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,

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

1886: );
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,

Line 1894: p_msg_level => fnd_log.level_statement,

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,
1896: p_module => l_module
1897: );
1898: END IF;

Line 2113: -- FND Logging for debug purpose

2109:
2110: END IF;
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,

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

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

Line 2118: p_msg_level => fnd_log.level_statement,

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,
2120: p_module => l_module
2121: );
2122: END IF;

Line 2127: -- FND Logging for debug purpose

2123:
2124: EXCEPTION
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 '||

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

2124: EXCEPTION
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 ,

Line 2134: p_msg_level => fnd_log.level_statement,

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,
2134: p_msg_level => fnd_log.level_statement,
2135: p_module_prefix => l_module_prefix,
2136: p_module => l_module
2137: );
2138: END IF;

Line 2142: -- FND Logging for debug purpose

2138: END IF;
2139: -- ns_debug.put_line('hz_hierarchy_nodes data is not correctly setup for geography id:'||ll_geo_id);
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 '||

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

2139: -- ns_debug.put_line('hz_hierarchy_nodes data is not correctly setup for geography id:'||ll_geo_id);
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),

Line 2149: p_msg_level => fnd_log.level_statement,

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,
2149: p_msg_level => fnd_log.level_statement,
2150: p_module_prefix => l_module_prefix,
2151: p_module => l_module
2152: );
2153: END IF;

Line 2346: -- FND Logging for debug purpose

2342: END IF;
2343:
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),

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

2343:
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,

Line 2352: p_msg_level => fnd_log.level_statement,

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,
2353: p_module_prefix => l_module_prefix,
2354: p_module => l_module
2355: );
2356: END IF;

Line 3807: -- FND Logging for debug purpose

3803:
3804: END do_match;
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,

Line 3808: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3804: END do_match;
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,

Line 3812: p_msg_level => fnd_log.level_procedure,

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,
3814: p_module => l_module
3815: );
3816: END IF;

Line 3825: -- FND Logging for debug purpose

3821:
3822: -- check if user has entered all mapped columns.
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,

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

3822: -- check if user has entered all mapped columns.
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,

Line 3830: p_msg_level => fnd_log.level_statement,

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,
3832: p_module => l_module
3833: );
3834: END IF;

Line 3839: -- FND Logging for debug purpose

3835:
3836: FOR i IN geo_struct_tbl.FIRST..geo_struct_tbl.LAST LOOP
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.',

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

3836: FOR i IN geo_struct_tbl.FIRST..geo_struct_tbl.LAST LOOP
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,

Line 3845: p_msg_level => fnd_log.level_statement,

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,
3846: p_module_prefix => l_module_prefix,
3847: p_module => l_module
3848: );
3849: END IF;

Line 3856: -- FND Logging for debug purpose

3852: EXIT;
3853: END IF;
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.',

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

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

Line 3862: p_msg_level => fnd_log.level_statement,

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,
3863: p_module_prefix => l_module_prefix,
3864: p_module => l_module
3865: );
3866: END IF;

Line 3874: -- FND Logging for debug purpose

3870:
3871: -- all parameters are passed
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,

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

3871: -- all parameters are passed
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,

Line 3879: p_msg_level => fnd_log.level_statement,

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,
3881: p_module => l_module
3882: );
3883: END IF;

Line 3903: -- FND Logging for debug purpose

3899: END LOOP; -- geo_struct_tbl loop
3900:
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',

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

3900:
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,

Line 3909: p_msg_level => fnd_log.level_statement,

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,
3910: p_module_prefix => l_module_prefix,
3911: p_module => l_module
3912: );
3913: END IF;

Line 3931: -- FND Logging for debug purpose

3927: END LOOP; -- geo_suggest_tbl loop
3928:
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,

Line 3932: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3928:
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,

Line 3936: p_msg_level => fnd_log.level_procedure,

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,
3938: p_module => l_module
3939: );
3940: END IF;

Line 4064: -- FND Logging for debug purpose

4060: END IF; -- end of geo struct tbl count check
4061:
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,

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

4061:
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,

Line 4069: p_msg_level => fnd_log.level_statement,

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,
4071: p_module => l_module
4072: );
4073: END IF;

Line 4078: -- FND Logging for debug purpose

4074:
4075: RETURN FALSE;
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,

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

4075: RETURN FALSE;
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,

Line 4083: p_msg_level => fnd_log.level_statement,

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,
4085: p_module => l_module
4086: );
4087: END IF;

Line 4176: -- FND Logging for debug purpose

4172: -- ER#7240974: get Postal Code value from postal_code_to_validate Function.
4173:
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,

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

4173:
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,

Line 4181: p_msg_level => fnd_log.level_statement,

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,
4183: p_module => l_module
4184: );
4185: END IF;

Line 4197: -- FND Logging for debug purpose

4193: ELSE
4194: l_address_style := pv_address_style;
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,

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

4194: l_address_style := pv_address_style;
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,

Line 4202: p_msg_level => fnd_log.level_statement,

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,
4204: p_module => l_module
4205: );
4206: END IF;

Line 4224: -- FND Logging for debug purpose

4220:
4221: -- if no data found then, try with NULL address style (which is default address style)
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.',

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

4221: -- if no data found then, try with NULL address style (which is default address style)
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,

Line 4230: p_msg_level => fnd_log.level_statement,

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,
4231: p_module_prefix => l_module_prefix,
4232: p_module => l_module
4233: );
4234: END IF;

Line 4274: -- FND Logging for debug purpose

4270: END LOOP;
4271: END LOOP;
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,

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

4271: END LOOP;
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,

Line 4279: p_msg_level => fnd_log.level_statement,

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,
4281: p_module => l_module
4282: );
4283: END IF;

Line 4391: -- FND Logging for debug purpose

4387: END IF;
4388:
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,

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

4388:
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,

Line 4396: p_msg_level => fnd_log.level_statement,

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,
4398: p_module => l_module
4399: );
4400: END IF;

Line 4402: -- FND Logging for debug purpose

4398: p_module => l_module
4399: );
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,

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

4399: );
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,

Line 4407: p_msg_level => fnd_log.level_statement,

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,
4409: p_module => l_module
4410: );
4411: END IF;

Line 4413: -- FND Logging for debug purpose

4409: p_module => l_module
4410: );
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,

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

4410: );
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,

Line 4418: p_msg_level => fnd_log.level_statement,

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,
4420: p_module => l_module
4421: );
4422: END IF;

Line 4424: -- FND Logging for debug purpose

4420: p_module => l_module
4421: );
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,

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

4421: );
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,

Line 4429: p_msg_level => fnd_log.level_statement,

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,
4431: p_module => l_module
4432: );
4433: END IF;

Line 4435: -- FND Logging for debug purpose

4431: p_module => l_module
4432: );
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,

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

4432: );
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,

Line 4440: p_msg_level => fnd_log.level_statement,

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,
4442: p_module => l_module
4443: );
4444: END IF;

Line 4446: -- FND Logging for debug purpose

4442: p_module => l_module
4443: );
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,

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

4443: );
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,

Line 4451: p_msg_level => fnd_log.level_statement,

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,
4453: p_module => l_module
4454: );
4455: END IF;

Line 4457: -- FND Logging for debug purpose

4453: p_module => l_module
4454: );
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,

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

4454: );
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,

Line 4462: p_msg_level => fnd_log.level_statement,

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,
4464: p_module => l_module
4465: );
4466: END IF;

Line 4680: -- FND Logging for debug purpose

4676: -- Build Suggestion List for consumer teams. This is done by concatnating
4677: -- all fetched and mapped values of Final Table (geo_suggest_tbl).
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,

Line 4681: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4677: -- all fetched and mapped values of Final Table (geo_suggest_tbl).
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,

Line 4685: p_msg_level => fnd_log.level_procedure,

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,
4687: p_module => l_module
4688: );
4689: END IF;

Line 4702: -- FND LOGGING FOR DEBUG PURPOSE

4698: END IF;
4699: geo_suggest_tbl(i).suggestion_list := l_suggest_list;
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,

Line 4703: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

4699: geo_suggest_tbl(i).suggestion_list := l_suggest_list;
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,

Line 4707: P_MSG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

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,
4709: P_MODULE => L_MODULE
4710: );
4711: END IF;

Line 4716: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4712:
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,

Line 4720: p_msg_level => fnd_log.level_procedure,

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,
4722: p_module => l_module
4723: );
4724: END IF;

Line 4733: -- FND Logging for debug purpose

4729: -- then suggestion list will be null. In that case delete that country row also.
4730: -- Bug 5391120 (Nishant 21-Jul-2006)
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,

Line 4734: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4730: -- Bug 5391120 (Nishant 21-Jul-2006)
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,

Line 4738: p_msg_level => fnd_log.level_procedure,

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,
4740: p_module => l_module
4741: );
4742: END IF;

Line 4748: -- FND Logging for debug purpose

4744: IF (geo_suggest_tbl(1).suggestion_list IS NULL OR
4745: LENGTH(LTRIM(RTRIM(geo_suggest_tbl(1).suggestion_list))) = 0) THEN
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',

Line 4749: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4745: LENGTH(LTRIM(RTRIM(geo_suggest_tbl(1).suggestion_list))) = 0) THEN
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,

Line 4754: p_msg_level => fnd_log.level_procedure,

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,
4755: p_module_prefix => l_module_prefix,
4756: p_module => l_module
4757: );
4758: END IF;

Line 4763: -- FND Logging for debug purpose

4759:
4760: END IF;
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,

Line 4764: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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

Line 4768: p_msg_level => fnd_log.level_procedure,

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,
4770: p_module => l_module
4771: );
4772: END IF;

Line 4829: -- FND Logging for debug purpose

4825: l_miss_min_geo_type VARCHAR2(200);
4826: l_msg_name VARCHAR2(100);
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,

Line 4830: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4826: l_msg_name VARCHAR2(100);
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,

Line 4834: p_msg_level => fnd_log.level_procedure,

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,
4836: p_module => l_module
4837: );
4838: END IF;

Line 4846: -- FND Logging for debug purpose

4842: build_suggestion_list;
4843:
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,

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

4843:
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,

Line 4851: p_msg_level => fnd_log.level_statement,

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,
4853: p_module => l_module
4854: );
4855: END IF;

Line 4860: -- FND Logging for debug purpose

4856:
4857: -- If it is 2nd pass and geo validation success, then return ADDRESS_COMPLETE
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,

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

4857: -- If it is 2nd pass and geo validation success, then return ADDRESS_COMPLETE
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,

Line 4865: p_msg_level => fnd_log.level_statement,

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,
4867: p_module => l_module
4868: );
4869: END IF;

Line 4881: -- FND Logging for debug purpose

4877: ELSE -- do further processing to verify if record is success
4878:
4879: IF (geo_suggest_tbl.COUNT = 0) THEN
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)',

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

4878:
4879: IF (geo_suggest_tbl.COUNT = 0) THEN
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,

Line 4887: p_msg_level => fnd_log.level_statement,

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,
4889: p_module => l_module
4890: );
4891:

Line 4925: -- FND Logging for debug purpose

4921: IF (geo_suggest_tbl.COUNT =1) THEN
4922: -- check if all input values match all fetched values
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,

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

4922: -- check if all input values match all fetched values
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,

Line 4930: p_msg_level => fnd_log.level_statement,

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,
4932: p_module => l_module
4933: );
4934: END IF;

Line 4943: -- FND Logging for debug purpose

4939: -- address suggestion kickes in initially
4940: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;
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,

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

4940: HZ_GNR_PVT.G_USER_ATTEMPT_COUNT := NULL;
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,

Line 4948: p_msg_level => fnd_log.level_statement,

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,
4950: p_module => l_module
4951: );
4952: END IF;

Line 4976: -- FND Logging for debug purpose

4972:
4973: ELSIF -- more than 55
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,

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

4973: ELSIF -- more than 55
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,

Line 4981: p_msg_level => fnd_log.level_statement,

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,
4983: p_module => l_module
4984: );
4985: END IF;

Line 5010: -- FND Logging for debug purpose

5006: x_records_count := NULL;
5007:
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,

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

5007:
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,

Line 5015: p_msg_level => fnd_log.level_statement,

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,
5017: p_module => l_module
5018: );
5019: END IF;

Line 5045: -- FND Logging for debug purpose

5041: END IF; -- validation level = ERROR
5042:
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,

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

5042:
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,

Line 5050: p_msg_level => fnd_log.level_statement,

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,
5052: p_module => l_module
5053: );
5054: END IF;

Line 5058: -- FND Logging for debug purpose

5054: END IF;
5055:
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,

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

5055:
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,

Line 5063: p_msg_level => fnd_log.level_statement,

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,
5065: p_module => l_module
5066: );
5067: END IF;

Line 5081: -- FND Logging for debug purpose

5077:
5078: -- check if all input values match all fetched values
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,

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

5078: -- check if all input values match all fetched values
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,

Line 5086: p_msg_level => fnd_log.level_statement,

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,
5088: p_module => l_module
5089: );
5090: END IF;

Line 5097: -- FND Logging for debug purpose

5093: setup_msg_and_ret_code_proc(p_return_code => 0);/* ADDRESS_COMPLETE */
5094:
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)',

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

5094:
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,

Line 5103: p_msg_level => fnd_log.level_statement,

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,
5104: p_module_prefix => l_module_prefix,
5105: p_module => l_module
5106: );
5107: END IF;

Line 5119: -- FND Logging for debug purpose

5115:
5116: ELSIF -- more than 55
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)',

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

5116: ELSIF -- more than 55
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,

Line 5125: p_msg_level => fnd_log.level_statement,

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,
5126: p_module_prefix => l_module_prefix,
5127: p_module => l_module
5128: );
5129: END IF;

Line 5142: -- FND Logging for debug purpose

5138: x_records_count := NULL;
5139:
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)',

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

5139:
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,

Line 5148: p_msg_level => fnd_log.level_statement,

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,
5149: p_module_prefix => l_module_prefix,
5150: p_module => l_module
5151: );
5152: END IF;

Line 5165: -- FND Logging for debug purpose

5161: END IF; -- validation level = WARNING
5162:
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,

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

5162:
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,

Line 5170: p_msg_level => fnd_log.level_statement,

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,
5172: p_module => l_module
5173: );
5174: END IF;

Line 5181: -- FND Logging for debug purpose

5177: l_miss_min_geo_type := get_missing_input_fields (l_geo_struct_tbl => geo_struct_tbl);
5178:
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)',

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

5178:
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,

Line 5187: p_msg_level => fnd_log.level_statement,

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,
5188: p_module_prefix => l_module_prefix,
5189: p_module => l_module
5190: );
5191: END IF;

Line 5200: -- FND Logging for debug purpose

5196: p_msg_token_name => 'P_MISSING_ELEMENTS',
5197: p_msg_token_value => l_miss_min_geo_type);
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)',

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

5197: p_msg_token_value => l_miss_min_geo_type);
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,

Line 5206: p_msg_level => fnd_log.level_statement,

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,
5207: p_module_prefix => l_module_prefix,
5208: p_module => l_module
5209: );
5210: END IF;

Line 5219: -- FND Logging for debug purpose

5215: END IF; -- minimum check
5216: END IF; -- validation level = MINIMUM
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,

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

5216: END IF; -- validation level = MINIMUM
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,

Line 5224: p_msg_level => fnd_log.level_statement,

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,
5226: p_module => l_module
5227: );
5228: END IF;

Line 5234: -- FND Logging for debug purpose

5230: -- set return code and return message
5231: setup_msg_and_ret_code_proc(p_return_code => 0); /* ADDRESS_COMPLETE */
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,

Line 5235: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

5231: setup_msg_and_ret_code_proc(p_return_code => 0); /* ADDRESS_COMPLETE */
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,

Line 5239: p_msg_level => fnd_log.level_procedure,

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,
5241: p_module => l_module
5242: );
5243: END IF;

Line 5380: -- FND Logging for debug purpose

5376:
5377: l_child_map_count := 0;
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,

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

5377: l_child_map_count := 0;
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,

Line 5385: p_msg_level => fnd_log.level_statement,

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,
5387: p_module => l_module
5388: );
5389: END IF;

Line 5395: -- FND Logging for debug purpose

5391: -- get max column for which value is fetched
5392: l_max_fetched_value := get_max_fetched_value;
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,

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

5392: l_max_fetched_value := get_max_fetched_value;
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,

Line 5401: p_msg_level => fnd_log.level_statement,

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,
5402: p_module_prefix => l_module_prefix,
5403: p_module => l_module
5404: );
5405: END IF;

Line 5411: -- FND Logging for debug purpose

5407: -- does not have to execute child query if l_max_fetched_value = max mapped value
5408: -- i.e. there is no more child level
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,

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

5408: -- i.e. there is no more child level
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,

Line 5416: p_msg_level => fnd_log.level_statement,

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,
5418: p_module => l_module
5419: );
5420: END IF;

Line 5478: -- FND Logging for debug purpose

5474: END IF;
5475:
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,

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

5475:
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,

Line 5483: p_msg_level => fnd_log.level_statement,

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,
5485: p_module => l_module
5486: );
5487: END IF;

Line 5489: -- FND Logging for debug purpose

5485: p_module => l_module
5486: );
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,

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

5486: );
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,

Line 5494: p_msg_level => fnd_log.level_statement,

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,
5496: p_module => l_module
5497: );
5498: END IF;

Line 5785: -- FND Logging for debug purpose

5781: -- Main code for Search_geographies procedure
5782: ---------------------------------------------------------------------+
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,

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

5782: ---------------------------------------------------------------------+
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,

Line 5790: p_msg_level => fnd_log.level_statement,

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,
5792: p_module => l_module
5793: );
5794: END IF;

Line 5817: -- FND Logging for debug purpose

5813: -- we are exposing this parameter. (This is based on TDD review on 27 July 2005).
5814: -- l_address_usage := p_address_usage;
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,

Line 5818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

5814: -- l_address_usage := p_address_usage;
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,

Line 5822: p_msg_level => fnd_log.level_procedure,

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,
5824: p_module => l_module
5825: );
5826: END IF;

Line 5832: -- FND Logging for debug purpose

5828: -- get full mapped structure for specific address_style and
5829: -- store it in plsql table
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,

Line 5833: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

5829: -- store it in plsql table
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,

Line 5837: p_msg_level => fnd_log.level_procedure,

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,
5839: p_module => l_module
5840: );
5841: END IF;

Line 5850: -- FND Logging for debug purpose

5846: l_addr_val_level := NVL(hz_gnr_pub.get_addr_val_level(UPPER(p_country_code)),'NONE');
5847: --l_addr_val_level := 'ERROR';
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,

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

5847: --l_addr_val_level := 'ERROR';
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,

Line 5855: p_msg_level => fnd_log.level_statement,

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,
5857: p_module => l_module
5858: );
5859: END IF;

Line 5882: -- FND Logging for debug purpose

5878: ------------------------------------------------------------------------+*/
5879:
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,

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

5879:
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,

Line 5887: p_msg_level => fnd_log.level_statement,

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,
5889: p_module => l_module
5890: );
5891: END IF;

Line 5927: -- FND Logging for debug purpose

5923:
5924: IF (LX_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
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,

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

5924: IF (LX_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
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,

Line 5932: p_msg_level => fnd_log.level_statement,

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,
5934: p_module => l_module
5935: );
5936: END IF;

Line 5944: -- FND Logging for debug purpose

5940: IF (HZ_GNR_PVT.G_USER_ATTEMPT_COUNT IS NULL) THEN
5941: l_success := 'N'; -- so that we can suggest more if there is anything during 1st attempt
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,

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

5941: l_success := 'N'; -- so that we can suggest more if there is anything during 1st attempt
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,

Line 5949: p_msg_level => fnd_log.level_statement,

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,
5951: p_module => l_module
5952: );
5953: END IF;

Line 5958: -- FND Logging for debug purpose

5954:
5955: ELSE
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,

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

5955: ELSE
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,

Line 5963: p_msg_level => fnd_log.level_statement,

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,
5965: p_module => l_module
5966: );
5967: END IF;

Line 5977: -- FND Logging for debug purpose

5973: -- if any exception happens in Geo Validation API, continue with suggestion logic.
5974: EXCEPTION WHEN OTHERS THEN
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,

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

5974: EXCEPTION WHEN OTHERS THEN
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,

Line 5982: p_msg_level => fnd_log.level_statement,

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,
5984: p_module => l_module
5985: );
5986: END IF;

Line 5995: -- FND Logging for debug purpose

5991: --ns_debug.put_line('Geo Validation X_ADDR_VAL_STATUS :'||LX_ADDR_VAL_STATUS);
5992: ELSE
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,

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

5992: ELSE
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,

Line 6000: p_msg_level => fnd_log.level_statement,

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,
6002: p_module => l_module
6003: );
6004: END IF;

Line 6013: -- FND Logging for debug purpose

6009: -- get into address suggestion mode only if geo validation (2nd pass) did not
6010: -- succeed.
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,

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

6010: -- succeed.
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,

Line 6018: p_msg_level => fnd_log.level_statement,

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,
6020: p_module => l_module
6021: );
6022: END IF;

Line 6034: -- FND Logging for debug purpose

6030: -- Profile Option is not present or set in any env, code will continue to
6031: -- behave as original design i.e. InitCap the City and County values.
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 ',

Line 6035: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

6031: -- behave as original design i.e. InitCap the City and County values.
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,

Line 6040: p_msg_level => fnd_log.level_statement,

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,
6041: p_module_prefix => l_module_prefix,
6042: P_MODULE => L_MODULE
6043: );
6044: END IF;

Line 6079: -- FND Logging for debug purpose

6075: -------------------------------------------------------------------+
6076: -- SEARCH 1: Here we query for all passed parameters for which mapping
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,

Line 6080: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6076: -- SEARCH 1: Here we query for all passed parameters for which mapping
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,

Line 6084: p_msg_level => fnd_log.level_procedure,

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,
6086: p_module => l_module
6087: );
6088: END IF;

Line 6094: -- FND Logging for debug purpose

6090: l_search_type := 'ALL_PASSED_PARAM_SEARCH';
6091: search_routine_pvt (pt_search_type => l_search_type,
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,

Line 6095: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6091: search_routine_pvt (pt_search_type => l_search_type,
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,

Line 6099: p_msg_level => fnd_log.level_procedure,

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,
6101: p_module => l_module
6102: );
6103: END IF;

Line 6138: -- FND Logging for debug purpose

6134: -- ELSE
6135: -- 1.1.2. If No, Suggest 1 level down children.
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,

Line 6139: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6135: -- 1.1.2. If No, Suggest 1 level down children.
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,

Line 6143: p_msg_level => fnd_log.level_procedure,

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,
6145: p_module => l_module
6146: );
6147: END IF;

Line 6151: -- FND Logging for debug purpose

6147: END IF;
6148:
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,

Line 6152: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6148:
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,

Line 6156: p_msg_level => fnd_log.level_procedure,

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,
6158: p_module => l_module
6159: );
6160: END IF;

Line 6188: -- FND Logging for debug purpose

6184: (l_max_mapped_element_col_value-1 = l_max_passed_element_col_value)) AND
6185: (l_max_passed_element_col_value > 3)
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='||

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

6185: (l_max_passed_element_col_value > 3)
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,

Line 6195: p_msg_level => fnd_log.level_statement,

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,
6195: p_msg_level => fnd_log.level_statement,
6196: p_module_prefix => l_module_prefix,
6197: p_module => l_module
6198: );
6199: END IF;

Line 6214: -- FND Logging for debug purpose

6210: -- if l_count_for_where_clause_2 = 2 i.e. all required params passed,
6211: -- build where clause
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,

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

6211: -- build where clause
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,

Line 6219: p_msg_level => fnd_log.level_statement,

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,
6221: p_module => l_module
6222: );
6223: END IF;

Line 6251: -- FND Logging for debug purpose

6247: END LOOP;
6248: -- if l_count_for_where_clause_3 = 2 i.e. all required params passed,
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,

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

6248: -- if l_count_for_where_clause_3 = 2 i.e. all required params passed,
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,

Line 6256: p_msg_level => fnd_log.level_statement,

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,
6258: p_module => l_module
6259: );
6260: END IF;

Line 6280: -- FND Logging for debug purpose

6276:
6277: -- execute query only if any of these 2 sql queries are constructed completely
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,

Line 6281: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6277: -- execute query only if any of these 2 sql queries are constructed completely
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,

Line 6285: p_msg_level => fnd_log.level_procedure,

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,
6287: p_module => l_module
6288: );
6289: END IF;

Line 6295: -- FND Logging for debug purpose

6291: l_search_type := 'LEVEL4_UNION_LEVEL5_SEARCH';
6292: search_routine_pvt (pt_search_type => l_search_type,
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,

Line 6296: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6292: search_routine_pvt (pt_search_type => l_search_type,
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,

Line 6300: p_msg_level => fnd_log.level_procedure,

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,
6302: p_module => l_module
6303: );
6304: END IF;

Line 6308: -- FND Logging for debug purpose

6304: END IF;
6305:
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) '||

Line 6309: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6305:
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',

Line 6315: p_msg_level => fnd_log.level_procedure,

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,
6315: p_msg_level => fnd_log.level_procedure,
6316: p_module_prefix => l_module_prefix,
6317: p_module => l_module
6318: );
6319: END IF;

Line 6326: -- FND Logging for debug purpose

6322:
6323: -- Again check, if 1 row fetched, try to get child records
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,

Line 6327: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6323: -- Again check, if 1 row fetched, try to get child records
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,

Line 6331: p_msg_level => fnd_log.level_procedure,

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,
6333: p_module => l_module
6334: );
6335: END IF;

Line 6339: -- FND Logging for debug purpose

6335: END IF;
6336:
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,

Line 6340: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6336:
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,

Line 6344: p_msg_level => fnd_log.level_procedure,

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,
6346: p_module => l_module
6347: );
6348: END IF;

Line 6404: -- FND Logging for debug purpose

6400: -- 1. If 1 row is identified,
6401: -- If more than 1 rows, then just suggest them.
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,

Line 6405: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6401: -- If more than 1 rows, then just suggest them.
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,

Line 6409: p_msg_level => fnd_log.level_procedure,

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,
6411: p_module => l_module
6412: );
6413: END IF;

Line 6417: -- FND Logging for debug purpose

6413: END IF;
6414:
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,

Line 6418: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6414:
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,

Line 6422: p_msg_level => fnd_log.level_procedure,

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,
6424: p_module => l_module
6425: );
6426: END IF;

Line 6444: -- FND Logging for debug purpose

6440: -- One example is: If country is passed and there are no states setup
6441: -- for that country.
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),

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

6441: -- for that country.
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,

Line 6450: p_msg_level => fnd_log.level_statement,

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,
6451: p_module_prefix => l_module_prefix,
6452: p_module => l_module
6453: );
6454: END IF;

Line 6460: -- FND Logging for debug purpose

6456: FOR i IN geo_rec_tbl.FIRST..geo_rec_tbl.LAST LOOP
6457: move_from_geo_rec_to_suggest(i,i);
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,

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

6457: move_from_geo_rec_to_suggest(i,i);
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,

Line 6465: p_msg_level => fnd_log.level_statement,

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,
6467: p_module => l_module
6468: );
6469: END IF;

Line 6491: -- FND Logging for debug purpose

6487:
6488: --------------------no geo mapping exist --------------------------+
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)',

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

6488: --------------------no geo mapping exist --------------------------+
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,

Line 6497: p_msg_level => fnd_log.level_statement,

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,
6498: p_module_prefix => l_module_prefix,
6499: p_module => l_module
6500: );
6501: END IF;

Line 6514: -- FND Logging for debug purpose

6510:
6511: ----------------Validation level is miniumum or none -----------------+
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(+)',

Line 6515: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6511: ----------------Validation level is miniumum or none -----------------+
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,

Line 6520: p_msg_level => fnd_log.level_procedure,

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,
6521: p_module_prefix => l_module_prefix,
6522: p_module => l_module
6523: );
6524: END IF;

Line 6528: -- FND Logging for debug purpose

6524: END IF;
6525:
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,

Line 6529: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6525:
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,

Line 6533: p_msg_level => fnd_log.level_procedure,

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,
6535: p_module => l_module
6536: );
6537: END IF;

Line 6541: -- FND Logging for debug purpose

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

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

6538:
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 ,

Line 6548: p_msg_level => fnd_log.level_statement,

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,
6548: p_msg_level => fnd_log.level_statement,
6549: p_module_prefix => l_module_prefix,
6550: p_module => l_module
6551: );
6552: END IF;

Line 6557: -- FND Logging for debug purpose

6553:
6554: EXCEPTION
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),

Line 6558: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN

6554: EXCEPTION
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,

Line 6563: p_msg_level => fnd_log.level_exception,

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,
6564: p_module_prefix => l_module_prefix,
6565: p_module => l_module
6566: );
6567: END IF;