DBA Data[Home] [Help]

APPS.HZ_PARTY_INFO_VAL dependencies on FND_LOG

Line 161: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

157:
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;

Line 164: p_msg_level=>fnd_log.level_procedure);

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:
167: IF FND_PROFILE.VALUE( 'HZ_API_ERR_ON_OBSOLETE_COLUMN' ) = 'Y' THEN
168:

Line 365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

361: p_lookup_type => '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);

Line 369: p_msg_level=>fnd_log.level_statement);

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;
371: END IF;
372:
373: -------------------------

Line 397: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

393: p_lookup_type => '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);

Line 401: p_msg_level=>fnd_log.level_statement);

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;
403: END IF;
404:
405: -------------------------

Line 429: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

425: p_lookup_type => '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);

Line 433: p_msg_level=>fnd_log.level_statement);

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;
435: END IF;
436:
437: -------------------------

Line 461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

457: p_lookup_type => '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);

Line 465: p_msg_level=>fnd_log.level_statement);

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;
467: END IF;
468:
469: -------------------------

Line 493: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

489: p_lookup_type => '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);

Line 497: p_msg_level=>fnd_log.level_statement);

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;
499: END IF;
500: -------------------------
501: -- validate PRNT_HQ_BKCY_IND

Line 524: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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 );
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);

Line 528: p_msg_level=>fnd_log.level_statement);

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;
530: END IF;
531:
532: -------------------------

Line 556: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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 );
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);

Line 560: p_msg_level=>fnd_log.level_statement);

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;
562: END IF;
563: -------------------------
564: -- validate debarment_ind

Line 587: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

583: p_lookup_type => '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);

Line 591: p_msg_level=>fnd_log.level_statement);

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

Line 619: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 623: p_msg_level=>fnd_log.level_statement);

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;
625:
626: END IF;
627:

Line 652: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 656: p_msg_level=>fnd_log.level_statement);

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;
658: END IF;
659:
660: ------------------------------------

Line 684: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 688: p_msg_level=>fnd_log.level_statement);

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;
690: END IF;
691:
692: ------------------------------------

Line 716: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 720: p_msg_level=>fnd_log.level_statement);

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;
722: END IF;
723:
724: ------------------------------------

Line 748: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 752: p_msg_level=>fnd_log.level_statement);

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;
754: END IF;
755:
756: ------------------------------------

Line 780: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 784: p_msg_level=>fnd_log.level_statement);

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;
786: END IF;
787:
788: ------------------------------------

Line 812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 816: p_msg_level=>fnd_log.level_statement);

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;
818: END IF;
819:
820: ------------------------------------

Line 844: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 848: p_msg_level=>fnd_log.level_statement);

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;
850: END IF;
851:
852: ------------------------------------

Line 876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 880: p_msg_level=>fnd_log.level_statement);

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;
882: END IF;
883:
884: -------------------------------------

Line 908: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 912: p_msg_level=>fnd_log.level_statement);

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;
914: END IF;
915:
916: ------------------------------------

Line 939: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 943: p_msg_level=>fnd_log.level_statement);

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;
945: END IF;
946:
947: -------------------------------------

Line 971: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 975: p_msg_level=>fnd_log.level_statement);

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;
977: END IF;
978:
979: -------------------------------------

Line 1003: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1007: p_msg_level=>fnd_log.level_statement);

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;
1009: END IF;
1010:
1011: -------------------------------------

Line 1035: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1039: p_msg_level=>fnd_log.level_statement);

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;
1041: END IF;
1042:
1043: -------------------------------------

Line 1067: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1071: p_msg_level=>fnd_log.level_statement);

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;
1073: END IF;
1074:
1075: -------------------------------------

Line 1099: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1103: p_msg_level=>fnd_log.level_statement);

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;
1105: END IF;
1106:
1107: -------------------------------------

Line 1131: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1135: p_msg_level=>fnd_log.level_statement);

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;
1137: END IF;
1138:
1139: -------------------------------------

Line 1163: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1167: p_msg_level=>fnd_log.level_statement);

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;
1169: END IF;
1170:
1171: -------------------------------------

Line 1195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1199: p_msg_level=>fnd_log.level_statement);

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;
1201: END IF;
1202:
1203: --------------------------------------

Line 1227: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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);
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);

Line 1231: p_msg_level=>fnd_log.level_statement);

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;
1233: END IF;
1234:
1235:

Line 1263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1259: fnd_msg_pub.add;
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);

Line 1267: p_msg_level=>fnd_log.level_statement);

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;
1269:
1270: END IF;
1271: