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

Line 32: * HZ_UTILITY_V2PUB.enable_debug

28: * DESCRIPTION
29: * Turn on debug mode.
30: *
31: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
32: * HZ_UTILITY_V2PUB.enable_debug
33: *
34: * MODIFICATION HISTORY
35: *
36: * 07-23-2001 Jianying Huang o Created.

Line 50: hz_utility_v2pub.enable_debug;

46: IF g_debug_count = 1 THEN
47: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
48: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
49: THEN
50: hz_utility_v2pub.enable_debug;
51: g_debug := TRUE;
52: END IF;
53: END IF;
54:

Line 65: * hz_utility_v2pub.disable_debug

61: * DESCRIPTION
62: * Turn off debug mode.
63: *
64: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
65: * hz_utility_v2pub.disable_debug
66: *
67: * MODIFICATION HISTORY
68: *
69: * 07-23-2001 Jianying Huang o Created.

Line 81: hz_utility_v2pub.disable_debug;

77: IF g_debug THEN
78: g_debug_count := g_debug_count - 1;
79:
80: IF g_debug_count = 0 THEN
81: hz_utility_v2pub.disable_debug;
82: g_debug := FALSE;
83: END IF;
84: END IF;
85:

Line 162: hz_utility_v2pub.debug(p_message=>'validate_credit_ratings (+)',

158: --enable_debug;
159:
160: -- Debug info.
161: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
162: hz_utility_v2pub.debug(p_message=>'validate_credit_ratings (+)',
163: p_prefix=>l_debug_prefix,
164: p_msg_level=>fnd_log.level_procedure);
165: END IF;
166:

Line 359: HZ_UTILITY_V2PUB.validate_lookup (

355: )
356: )
357: THEN
358:
359: HZ_UTILITY_V2PUB.validate_lookup (
360: p_column => 'suit_ind',
361: p_lookup_type => 'YES/NO',
362: p_column_value => p_credit_ratings_rec.suit_ind,
363: x_return_status => x_return_status);

Line 366: hz_utility_v2pub.debug(p_message=>'suit_ind should be in lookup YES/NO. ' ||

362: p_column_value => p_credit_ratings_rec.suit_ind,
363: x_return_status => x_return_status);
364:
365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'suit_ind should be in lookup YES/NO. ' ||
367: 'x_return_status = ' || x_return_status,
368: p_prefix =>l_debug_prefix,
369: p_msg_level=>fnd_log.level_statement);
370: END IF;

Line 391: HZ_UTILITY_V2PUB.validate_lookup (

387: )
388: )
389: THEN
390:
391: HZ_UTILITY_V2PUB.validate_lookup (
392: p_column => 'lien_ind',
393: p_lookup_type => 'YES/NO',
394: p_column_value => p_credit_ratings_rec.lien_ind,
395: x_return_status => x_return_status);

Line 398: hz_utility_v2pub.debug(p_message=>'lien_ind should be in lookup YES/NO. ' ||

394: p_column_value => p_credit_ratings_rec.lien_ind,
395: x_return_status => x_return_status);
396:
397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug(p_message=>'lien_ind should be in lookup YES/NO. ' ||
399: 'x_return_status = ' || x_return_status,
400: p_prefix =>l_debug_prefix,
401: p_msg_level=>fnd_log.level_statement);
402: END IF;

Line 423: HZ_UTILITY_V2PUB.validate_lookup (

419: )
420: )
421: THEN
422:
423: HZ_UTILITY_V2PUB.validate_lookup (
424: p_column => 'judgement_ind',
425: p_lookup_type => 'YES/NO',
426: p_column_value => p_credit_ratings_rec.judgement_ind,
427: x_return_status => x_return_status);

Line 430: hz_utility_v2pub.debug(p_message=>'judgement_ind should be in lookup YES/NO. ' ||

426: p_column_value => p_credit_ratings_rec.judgement_ind,
427: x_return_status => x_return_status);
428:
429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'judgement_ind should be in lookup YES/NO. ' ||
431: 'x_return_status = ' || x_return_status,
432: p_prefix =>l_debug_prefix,
433: p_msg_level=>fnd_log.level_statement);
434: END IF;

Line 455: HZ_UTILITY_V2PUB.validate_lookup (

451: )
452: )
453: THEN
454:
455: HZ_UTILITY_V2PUB.validate_lookup (
456: p_column => 'bankruptcy_ind',
457: p_lookup_type => 'YES/NO',
458: p_column_value => p_credit_ratings_rec.bankruptcy_ind,
459: x_return_status => x_return_status);

Line 462: hz_utility_v2pub.debug(p_message=>'bankruptcy_ind should be in lookup YES/NO. ' ||

458: p_column_value => p_credit_ratings_rec.bankruptcy_ind,
459: x_return_status => x_return_status);
460:
461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
462: hz_utility_v2pub.debug(p_message=>'bankruptcy_ind should be in lookup YES/NO. ' ||
463: 'x_return_status = ' || x_return_status,
464: p_prefix =>l_debug_prefix,
465: p_msg_level=>fnd_log.level_statement);
466: END IF;

Line 487: HZ_UTILITY_V2PUB.validate_lookup (

483: )
484: )
485: THEN
486:
487: HZ_UTILITY_V2PUB.validate_lookup (
488: p_column => 'no_trade_ind',
489: p_lookup_type => 'YES/NO',
490: p_column_value => p_credit_ratings_rec.no_trade_ind,
491: x_return_status => x_return_status);

Line 494: hz_utility_v2pub.debug(p_message=>'no_trade_ind should be in lookup YES/NO. ' ||

490: p_column_value => p_credit_ratings_rec.no_trade_ind,
491: x_return_status => x_return_status);
492:
493: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
494: hz_utility_v2pub.debug(p_message=>'no_trade_ind should be in lookup YES/NO. ' ||
495: 'x_return_status = ' || x_return_status,
496: p_prefix =>l_debug_prefix,
497: p_msg_level=>fnd_log.level_statement);
498: END IF;

Line 518: HZ_UTILITY_V2PUB.validate_lookup (

514: )
515: )
516: THEN
517:
518: HZ_UTILITY_V2PUB.validate_lookup (
519: p_column => 'prnt_hq_bkcy_ind',
520: p_lookup_type => 'PRNT_HQ_IND',
521: p_column_value => p_credit_ratings_rec.prnt_hq_bkcy_ind,
522: x_return_status => x_return_status );

Line 525: hz_utility_v2pub.debug(p_message=>'prnt_hq_bkcy_ind should be in lookup PRNT_HQ_IND. ' ||

521: p_column_value => p_credit_ratings_rec.prnt_hq_bkcy_ind,
522: x_return_status => x_return_status );
523:
524: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
525: hz_utility_v2pub.debug(p_message=>'prnt_hq_bkcy_ind should be in lookup PRNT_HQ_IND. ' ||
526: 'x_return_status = ' || x_return_status,
527: p_prefix =>l_debug_prefix,
528: p_msg_level=>fnd_log.level_statement);
529: END IF;

Line 550: HZ_UTILITY_V2PUB.validate_lookup (

546: )
547: )
548: THEN
549:
550: HZ_UTILITY_V2PUB.validate_lookup (
551: p_column => 'credit_score_override_code',
552: p_lookup_type => 'FAILURE_SCORE_OVERRIDE_CODE',
553: p_column_value => p_credit_ratings_rec.credit_score_override_code,
554: x_return_status => x_return_status );

Line 557: hz_utility_v2pub.debug(p_message=>'credit_score_override_code should be in lookup FAILURE_SCORE_OVERRIDE_CODE. ' ||

553: p_column_value => p_credit_ratings_rec.credit_score_override_code,
554: x_return_status => x_return_status );
555:
556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
557: hz_utility_v2pub.debug(p_message=>'credit_score_override_code should be in lookup FAILURE_SCORE_OVERRIDE_CODE. ' ||
558: 'x_return_status = ' || x_return_status,
559: p_prefix =>l_debug_prefix,
560: p_msg_level=>fnd_log.level_statement);
561: END IF;

Line 581: HZ_UTILITY_V2PUB.validate_lookup (

577: )
578: )
579: THEN
580:
581: HZ_UTILITY_V2PUB.validate_lookup (
582: p_column => 'debarment_ind',
583: p_lookup_type => 'YES/NO',
584: p_column_value => p_credit_ratings_rec.debarment_ind,
585: x_return_status => x_return_status);

Line 588: hz_utility_v2pub.debug(p_message=>'debarment_ind should be in lookup YES/NO. ' ||

584: p_column_value => p_credit_ratings_rec.debarment_ind,
585: x_return_status => x_return_status);
586:
587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
588: hz_utility_v2pub.debug(p_message=>'debarment_ind should be in lookup YES/NO. ' ||
589: 'x_return_status = ' || x_return_status,
590: p_prefix =>l_debug_prefix,
591: p_msg_level=>fnd_log.level_statement);
592: END IF;

Line 613: HZ_UTILITY_V2PUB.validate_lookup (

609: )
610: )
611: THEN
612:
613: HZ_UTILITY_V2PUB.validate_lookup (
614: p_column => 'credit_score_commentary',
615: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
616: p_column_value => p_credit_ratings_rec.credit_score_commentary,
617: x_return_status => x_return_status);

Line 620: hz_utility_v2pub.debug(p_message=>'credit_score_commentary is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

616: p_column_value => p_credit_ratings_rec.credit_score_commentary,
617: x_return_status => x_return_status);
618:
619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'credit_score_commentary is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
621: 'x_return_status = ' || x_return_status,
622: p_prefix =>l_debug_prefix,
623: p_msg_level=>fnd_log.level_statement);
624: END IF;

Line 646: HZ_UTILITY_V2PUB.validate_lookup (

642: )
643: )
644: THEN
645:
646: HZ_UTILITY_V2PUB.validate_lookup (
647: p_column => 'credit_score_commentary2',
648: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
649: p_column_value => p_credit_ratings_rec.credit_score_commentary2,
650: x_return_status => x_return_status);

Line 653: hz_utility_v2pub.debug(p_message=>'credit_score_commentary2 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

649: p_column_value => p_credit_ratings_rec.credit_score_commentary2,
650: x_return_status => x_return_status);
651:
652: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
653: hz_utility_v2pub.debug(p_message=>'credit_score_commentary2 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
654: 'x_return_status = ' || x_return_status,
655: p_prefix =>l_debug_prefix,
656: p_msg_level=>fnd_log.level_statement);
657: END IF;

Line 678: HZ_UTILITY_V2PUB.validate_lookup (

674: )
675: )
676: THEN
677:
678: HZ_UTILITY_V2PUB.validate_lookup (
679: p_column => 'credit_score_commentary3',
680: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
681: p_column_value => p_credit_ratings_rec.credit_score_commentary3,
682: x_return_status => x_return_status);

Line 685: hz_utility_v2pub.debug(p_message=>'credit_score_commentary3 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

681: p_column_value => p_credit_ratings_rec.credit_score_commentary3,
682: x_return_status => x_return_status);
683:
684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
685: hz_utility_v2pub.debug(p_message=>'credit_score_commentary3 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
686: 'x_return_status = ' || x_return_status,
687: p_prefix =>l_debug_prefix,
688: p_msg_level=>fnd_log.level_statement);
689: END IF;

Line 710: HZ_UTILITY_V2PUB.validate_lookup (

706: )
707: )
708: THEN
709:
710: HZ_UTILITY_V2PUB.validate_lookup (
711: p_column => 'credit_score_commentary4',
712: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
713: p_column_value => p_credit_ratings_rec.credit_score_commentary4,
714: x_return_status => x_return_status);

Line 717: hz_utility_v2pub.debug(p_message=>'credit_score_commentary4 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

713: p_column_value => p_credit_ratings_rec.credit_score_commentary4,
714: x_return_status => x_return_status);
715:
716: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
717: hz_utility_v2pub.debug(p_message=>'credit_score_commentary4 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
718: 'x_return_status = ' || x_return_status,
719: p_prefix =>l_debug_prefix,
720: p_msg_level=>fnd_log.level_statement);
721: END IF;

Line 742: HZ_UTILITY_V2PUB.validate_lookup (

738: )
739: )
740: THEN
741:
742: HZ_UTILITY_V2PUB.validate_lookup (
743: p_column => 'credit_score_commentary5',
744: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
745: p_column_value => p_credit_ratings_rec.credit_score_commentary5,
746: x_return_status => x_return_status);

Line 749: hz_utility_v2pub.debug(p_message=>'credit_score_commentary5 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

745: p_column_value => p_credit_ratings_rec.credit_score_commentary5,
746: x_return_status => x_return_status);
747:
748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
749: hz_utility_v2pub.debug(p_message=>'credit_score_commentary5 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
750: 'x_return_status = ' || x_return_status,
751: p_prefix =>l_debug_prefix,
752: p_msg_level=>fnd_log.level_statement);
753: END IF;

Line 774: HZ_UTILITY_V2PUB.validate_lookup (

770: )
771: )
772: THEN
773:
774: HZ_UTILITY_V2PUB.validate_lookup (
775: p_column => 'credit_score_commentary6',
776: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
777: p_column_value => p_credit_ratings_rec.credit_score_commentary6,
778: x_return_status => x_return_status);

Line 781: hz_utility_v2pub.debug(p_message=>'credit_score_commentary6 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

777: p_column_value => p_credit_ratings_rec.credit_score_commentary6,
778: x_return_status => x_return_status);
779:
780: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
781: hz_utility_v2pub.debug(p_message=>'credit_score_commentary6 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
782: 'x_return_status = ' || x_return_status,
783: p_prefix =>l_debug_prefix,
784: p_msg_level=>fnd_log.level_statement);
785: END IF;

Line 806: HZ_UTILITY_V2PUB.validate_lookup (

802: )
803: )
804: THEN
805:
806: HZ_UTILITY_V2PUB.validate_lookup (
807: p_column => 'credit_score_commentary7',
808: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
809: p_column_value => p_credit_ratings_rec.credit_score_commentary7,
810: x_return_status => x_return_status);

Line 813: hz_utility_v2pub.debug(p_message=>'credit_score_commentary7 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

809: p_column_value => p_credit_ratings_rec.credit_score_commentary7,
810: x_return_status => x_return_status);
811:
812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
813: hz_utility_v2pub.debug(p_message=>'credit_score_commentary7 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
814: 'x_return_status = ' || x_return_status,
815: p_prefix =>l_debug_prefix,
816: p_msg_level=>fnd_log.level_statement);
817: END IF;

Line 838: HZ_UTILITY_V2PUB.validate_lookup (

834: )
835: )
836: THEN
837:
838: HZ_UTILITY_V2PUB.validate_lookup (
839: p_column => 'credit_score_commentary8',
840: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
841: p_column_value => p_credit_ratings_rec.credit_score_commentary8,
842: x_return_status => x_return_status);

Line 845: hz_utility_v2pub.debug(p_message=>'credit_score_commentary8 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

841: p_column_value => p_credit_ratings_rec.credit_score_commentary8,
842: x_return_status => x_return_status);
843:
844: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug(p_message=>'credit_score_commentary8 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
846: 'x_return_status = ' || x_return_status,
847: p_prefix =>l_debug_prefix,
848: p_msg_level=>fnd_log.level_statement);
849: END IF;

Line 870: HZ_UTILITY_V2PUB.validate_lookup (

866: )
867: )
868: THEN
869:
870: HZ_UTILITY_V2PUB.validate_lookup (
871: p_column => 'credit_score_commentary9',
872: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
873: p_column_value => p_credit_ratings_rec.credit_score_commentary9,
874: x_return_status => x_return_status);

Line 877: hz_utility_v2pub.debug(p_message=>'credit_score_commentary9 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

873: p_column_value => p_credit_ratings_rec.credit_score_commentary9,
874: x_return_status => x_return_status);
875:
876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
877: hz_utility_v2pub.debug(p_message=>'credit_score_commentary9 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
878: 'x_return_status = ' || x_return_status,
879: p_prefix =>l_debug_prefix,
880: p_msg_level=>fnd_log.level_statement);
881: END IF;

Line 902: HZ_UTILITY_V2PUB.validate_lookup (

898: )
899: )
900: THEN
901:
902: HZ_UTILITY_V2PUB.validate_lookup (
903: p_column => 'credit_score_commentary10',
904: p_lookup_type => 'CREDIT_SCORE_COMMENTARY',
905: p_column_value => p_credit_ratings_rec.credit_score_commentary10,
906: x_return_status => x_return_status);

Line 909: hz_utility_v2pub.debug(p_message=>'credit_score_commentary10 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||

905: p_column_value => p_credit_ratings_rec.credit_score_commentary10,
906: x_return_status => x_return_status);
907:
908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
909: hz_utility_v2pub.debug(p_message=>'credit_score_commentary10 is lookup code in lookup type CREDIT_SCORE_COMMENTARY. ' ||
910: 'x_return_status = ' || x_return_status,
911: p_prefix =>l_debug_prefix,
912: p_msg_level=>fnd_log.level_statement);
913: END IF;

Line 933: HZ_UTILITY_V2PUB.validate_lookup (

929: p_credit_ratings_rec.failure_score_commentary <> NVL(l_credit_score_commentary, fnd_api.g_miss_char)
930: )
931: )
932: THEN
933: HZ_UTILITY_V2PUB.validate_lookup (
934: p_column => 'failure_score_commentary',
935: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
936: p_column_value => p_credit_ratings_rec.failure_score_commentary,
937: x_return_status => x_return_status);

Line 940: hz_utility_v2pub.debug(p_message=>'failure_score_commentary is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

936: p_column_value => p_credit_ratings_rec.failure_score_commentary,
937: x_return_status => x_return_status);
938:
939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
940: hz_utility_v2pub.debug(p_message=>'failure_score_commentary is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
941: 'x_return_status = ' || x_return_status,
942: p_prefix =>l_debug_prefix,
943: p_msg_level=>fnd_log.level_statement);
944: END IF;

Line 965: HZ_UTILITY_V2PUB.validate_lookup (

961: )
962: )
963: THEN
964:
965: HZ_UTILITY_V2PUB.validate_lookup (
966: p_column => 'failure_score_commentary2',
967: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
968: p_column_value => p_credit_ratings_rec.failure_score_commentary2,
969: x_return_status => x_return_status);

Line 972: hz_utility_v2pub.debug(p_message=>'failure_score_commentary2 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

968: p_column_value => p_credit_ratings_rec.failure_score_commentary2,
969: x_return_status => x_return_status);
970:
971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'failure_score_commentary2 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
973: 'x_return_status = ' || x_return_status,
974: p_prefix =>l_debug_prefix,
975: p_msg_level=>fnd_log.level_statement);
976: END IF;

Line 997: HZ_UTILITY_V2PUB.validate_lookup (

993: )
994: )
995: THEN
996:
997: HZ_UTILITY_V2PUB.validate_lookup (
998: p_column => 'failure_score_commentary3',
999: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1000: p_column_value => p_credit_ratings_rec.failure_score_commentary3,
1001: x_return_status => x_return_status);

Line 1004: hz_utility_v2pub.debug(p_message=>'failure_score_commentary3 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1000: p_column_value => p_credit_ratings_rec.failure_score_commentary3,
1001: x_return_status => x_return_status);
1002:
1003: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1004: hz_utility_v2pub.debug(p_message=>'failure_score_commentary3 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1005: 'x_return_status = ' || x_return_status,
1006: p_prefix =>l_debug_prefix,
1007: p_msg_level=>fnd_log.level_statement);
1008: END IF;

Line 1029: HZ_UTILITY_V2PUB.validate_lookup (

1025: )
1026: )
1027: THEN
1028:
1029: HZ_UTILITY_V2PUB.validate_lookup (
1030: p_column => 'failure_score_commentary4',
1031: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1032: p_column_value => p_credit_ratings_rec.failure_score_commentary4,
1033: x_return_status => x_return_status);

Line 1036: hz_utility_v2pub.debug(p_message=>'failure_score_commentary4 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1032: p_column_value => p_credit_ratings_rec.failure_score_commentary4,
1033: x_return_status => x_return_status);
1034:
1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1036: hz_utility_v2pub.debug(p_message=>'failure_score_commentary4 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1037: 'x_return_status = ' || x_return_status,
1038: p_prefix =>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_statement);
1040: END IF;

Line 1061: HZ_UTILITY_V2PUB.validate_lookup (

1057: )
1058: )
1059: THEN
1060:
1061: HZ_UTILITY_V2PUB.validate_lookup (
1062: p_column => 'failure_score_commentary5',
1063: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1064: p_column_value => p_credit_ratings_rec.failure_score_commentary5,
1065: x_return_status => x_return_status);

Line 1068: hz_utility_v2pub.debug(p_message=>'failure_score_commentary5 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1064: p_column_value => p_credit_ratings_rec.failure_score_commentary5,
1065: x_return_status => x_return_status);
1066:
1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1068: hz_utility_v2pub.debug(p_message=>'failure_score_commentary5 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1069: 'x_return_status = ' || x_return_status,
1070: p_prefix =>l_debug_prefix,
1071: p_msg_level=>fnd_log.level_statement);
1072: END IF;

Line 1093: HZ_UTILITY_V2PUB.validate_lookup (

1089: )
1090: )
1091: THEN
1092:
1093: HZ_UTILITY_V2PUB.validate_lookup (
1094: p_column => 'failure_score_commentary6',
1095: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1096: p_column_value => p_credit_ratings_rec.failure_score_commentary6,
1097: x_return_status => x_return_status);

Line 1100: hz_utility_v2pub.debug(p_message=>'failure_score_commentary6 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1096: p_column_value => p_credit_ratings_rec.failure_score_commentary6,
1097: x_return_status => x_return_status);
1098:
1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1100: hz_utility_v2pub.debug(p_message=>'failure_score_commentary6 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1101: 'x_return_status = ' || x_return_status,
1102: p_prefix =>l_debug_prefix,
1103: p_msg_level=>fnd_log.level_statement);
1104: END IF;

Line 1125: HZ_UTILITY_V2PUB.validate_lookup (

1121: )
1122: )
1123: THEN
1124:
1125: HZ_UTILITY_V2PUB.validate_lookup (
1126: p_column => 'failure_score_commentary7',
1127: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1128: p_column_value => p_credit_ratings_rec.failure_score_commentary7,
1129: x_return_status => x_return_status);

Line 1132: hz_utility_v2pub.debug(p_message=>'failure_score_commentary7 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1128: p_column_value => p_credit_ratings_rec.failure_score_commentary7,
1129: x_return_status => x_return_status);
1130:
1131: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'failure_score_commentary7 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1133: 'x_return_status = ' || x_return_status,
1134: p_prefix =>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_statement);
1136: END IF;

Line 1157: HZ_UTILITY_V2PUB.validate_lookup (

1153: )
1154: )
1155: THEN
1156:
1157: HZ_UTILITY_V2PUB.validate_lookup (
1158: p_column => 'failure_score_commentary8',
1159: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1160: p_column_value => p_credit_ratings_rec.failure_score_commentary8,
1161: x_return_status => x_return_status);

Line 1164: hz_utility_v2pub.debug(p_message=>'failure_score_commentary8 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1160: p_column_value => p_credit_ratings_rec.failure_score_commentary8,
1161: x_return_status => x_return_status);
1162:
1163: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1164: hz_utility_v2pub.debug(p_message=>'failure_score_commentary8 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1165: 'x_return_status = ' || x_return_status,
1166: p_prefix =>l_debug_prefix,
1167: p_msg_level=>fnd_log.level_statement);
1168: END IF;

Line 1189: HZ_UTILITY_V2PUB.validate_lookup (

1185: )
1186: )
1187: THEN
1188:
1189: HZ_UTILITY_V2PUB.validate_lookup (
1190: p_column => 'failure_score_commentary9',
1191: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1192: p_column_value => p_credit_ratings_rec.failure_score_commentary9,
1193: x_return_status => x_return_status);

Line 1196: hz_utility_v2pub.debug(p_message=>'failure_score_commentary9 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1192: p_column_value => p_credit_ratings_rec.failure_score_commentary9,
1193: x_return_status => x_return_status);
1194:
1195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1196: hz_utility_v2pub.debug(p_message=>'failure_score_commentary9 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1197: 'x_return_status = ' || x_return_status,
1198: p_prefix =>l_debug_prefix,
1199: p_msg_level=>fnd_log.level_statement);
1200: END IF;

Line 1221: HZ_UTILITY_V2PUB.validate_lookup (

1217: )
1218: )
1219: THEN
1220:
1221: HZ_UTILITY_V2PUB.validate_lookup (
1222: p_column => 'failure_score_commentary10',
1223: p_lookup_type => 'FAILURE_SCORE_COMMENTARY',
1224: p_column_value => p_credit_ratings_rec.failure_score_commentary10,
1225: x_return_status => x_return_status);

Line 1228: hz_utility_v2pub.debug(p_message=>'failure_score_commentary10 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||

1224: p_column_value => p_credit_ratings_rec.failure_score_commentary10,
1225: x_return_status => x_return_status);
1226:
1227: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1228: hz_utility_v2pub.debug(p_message=>'failure_score_commentary10 is lookup code in lookup type FAILURE_SCORE_COMMENTARY. ' ||
1229: 'x_return_status = ' || x_return_status,
1230: p_prefix =>l_debug_prefix,
1231: p_msg_level=>fnd_log.level_statement);
1232: END IF;

Line 1264: hz_utility_v2pub.debug(p_message=>'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||

1260: x_return_status := fnd_api.g_ret_sts_error;
1261: END;
1262:
1263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1264: hz_utility_v2pub.debug(p_message=>'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||
1265: 'x_return_status = ' || x_return_status,
1266: p_prefix =>l_debug_prefix,
1267: p_msg_level=>fnd_log.level_statement);
1268: END IF;