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.IGF_SL_CL_LI_IMP_PKG dependencies on FND_LOG

Line 500: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

496:
497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
501: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_li_imp_pkg.log_parameters.exception','LOG_PARAMETERS :: ' || SQLERRM);
502: END IF;
503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
504: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.LOG_PARAMETERS');

Line 501: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_li_imp_pkg.log_parameters.exception','LOG_PARAMETERS :: ' || SQLERRM);

497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
501: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_li_imp_pkg.log_parameters.exception','LOG_PARAMETERS :: ' || SQLERRM);
502: END IF;
503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
504: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.LOG_PARAMETERS');
505: igs_ge_msg_stack.add;

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

562: BEGIN
563:
564: l_part_1 := SUBSTR(p_loan_number,1,8);
565:
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 ' || l_part_1);
568: END IF;
569:
570: OPEN c_source_or_branch_id(l_part_1, 'OPE_ID_NUM');

Line 567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 ' || l_part_1);

563:
564: l_part_1 := SUBSTR(p_loan_number,1,8);
565:
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 ' || l_part_1);
568: END IF;
569:
570: OPEN c_source_or_branch_id(l_part_1, 'OPE_ID_NUM');
571: FETCH c_source_or_branch_id INTO l_source_or_branch_id;

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

569:
570: OPEN c_source_or_branch_id(l_part_1, 'OPE_ID_NUM');
571: FETCH c_source_or_branch_id INTO l_source_or_branch_id;
572: IF (c_source_or_branch_id%NOTFOUND) THEN
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 not valid for school id' || l_part_1);
575: END IF;
576: CLOSE c_source_or_branch_id;
577: RETURN FALSE;

Line 574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 not valid for school id' || l_part_1);

570: OPEN c_source_or_branch_id(l_part_1, 'OPE_ID_NUM');
571: FETCH c_source_or_branch_id INTO l_source_or_branch_id;
572: IF (c_source_or_branch_id%NOTFOUND) THEN
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 not valid for school id' || l_part_1);
575: END IF;
576: CLOSE c_source_or_branch_id;
577: RETURN FALSE;
578: ELSE

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

584: IF l_part_2 <> '0000' THEN
585: OPEN c_source_or_branch_id(l_part_2, 'SCH_NON_ED_BRC_ID');
586: FETCH c_source_or_branch_id INTO l_source_or_branch_id;
587: IF (c_source_or_branch_id%NOTFOUND) THEN
588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 not valid for school non ed branch id' || l_part_2);
590: END IF;
591: CLOSE c_source_or_branch_id;
592: RETURN FALSE;

Line 589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 not valid for school non ed branch id' || l_part_2);

585: OPEN c_source_or_branch_id(l_part_2, 'SCH_NON_ED_BRC_ID');
586: FETCH c_source_or_branch_id INTO l_source_or_branch_id;
587: IF (c_source_or_branch_id%NOTFOUND) THEN
588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 not valid for school non ed branch id' || l_part_2);
590: END IF;
591: CLOSE c_source_or_branch_id;
592: RETURN FALSE;
593: ELSE

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

594: CLOSE c_source_or_branch_id;
595: END IF;
596: END IF;
597:
598: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 ' || l_part_2);
600: END IF;
601:
602: l_part_3 := SUBSTR(p_loan_number,12,3);

Line 599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 ' || l_part_2);

595: END IF;
596: END IF;
597:
598: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 ' || l_part_2);
600: END IF;
601:
602: l_part_3 := SUBSTR(p_loan_number,12,3);
603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 ' || l_part_2);
600: END IF;
601:
602: l_part_3 := SUBSTR(p_loan_number,12,3);
603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_3 ' || l_part_3);
605: END IF;
606: l_part3_1 := SUBSTR(l_part_3,1,1);
607: l_part3_2 := SUBSTR(l_part_3,2,1);

Line 604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_3 ' || l_part_3);

600: END IF;
601:
602: l_part_3 := SUBSTR(p_loan_number,12,3);
603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_3 ' || l_part_3);
605: END IF;
606: l_part3_1 := SUBSTR(l_part_3,1,1);
607: l_part3_2 := SUBSTR(l_part_3,2,1);
608: l_part3_3 := SUBSTR(l_part_3,3,1);

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

607: l_part3_2 := SUBSTR(l_part_3,2,1);
608: l_part3_3 := SUBSTR(l_part_3,3,1);
609:
610: IF l_part3_1 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S') THEN
611: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
612: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part3_1 ' || l_part3_1);
613: END IF;
614: RETURN FALSE;
615: ELSIF (l_part3_1 = 'S') THEN

Line 612: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part3_1 ' || l_part3_1);

608: l_part3_3 := SUBSTR(l_part_3,3,1);
609:
610: IF l_part3_1 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S') THEN
611: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
612: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part3_1 ' || l_part3_1);
613: END IF;
614: RETURN FALSE;
615: ELSIF (l_part3_1 = 'S') THEN
616: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B') THEN

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

613: END IF;
614: RETURN FALSE;
615: ELSIF (l_part3_1 = 'S') THEN
616: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B') THEN
617: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','is_valid: l_part3_2 ' || l_part3_2);
619: END IF;
620: RETURN FALSE;
621: END IF;

Line 618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','is_valid: l_part3_2 ' || l_part3_2);

614: RETURN FALSE;
615: ELSIF (l_part3_1 = 'S') THEN
616: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B') THEN
617: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','is_valid: l_part3_2 ' || l_part3_2);
619: END IF;
620: RETURN FALSE;
621: END IF;
622: ELSIF (l_part3_1 <> 'S') THEN

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

621: END IF;
622: ELSIF (l_part3_1 <> 'S') THEN
623: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
624: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
625: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
626: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_im_pkg.is_valid.debug','IS_VALID: l_part3_2 - II ' || l_part3_2);
627: END IF;
628: RETURN FALSE;
629: END IF;

Line 626: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_im_pkg.is_valid.debug','IS_VALID: l_part3_2 - II ' || l_part3_2);

622: ELSIF (l_part3_1 <> 'S') THEN
623: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
624: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
625: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
626: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_im_pkg.is_valid.debug','IS_VALID: l_part3_2 - II ' || l_part3_2);
627: END IF;
628: RETURN FALSE;
629: END IF;
630: ELSIF (l_part3_1 = 'S') AND (l_part3_2 = 'B') THEN

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

628: RETURN FALSE;
629: END IF;
630: ELSIF (l_part3_1 = 'S') AND (l_part3_2 = 'B') THEN
631: IF l_part3_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F') THEN
632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
633: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part3_3 ' || l_part3_3);
634: END IF;
635: RETURN FALSE;
636: END IF;

Line 633: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part3_3 ' || l_part3_3);

629: END IF;
630: ELSIF (l_part3_1 = 'S') AND (l_part3_2 = 'B') THEN
631: IF l_part3_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F') THEN
632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
633: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part3_3 ' || l_part3_3);
634: END IF;
635: RETURN FALSE;
636: END IF;
637: ELSIF (l_part3_1 <> 'S') OR (l_part3_2 <> 'B') THEN

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

636: END IF;
637: ELSIF (l_part3_1 <> 'S') OR (l_part3_2 <> 'B') THEN
638: IF l_part3_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
639: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part3_3 - II ' || l_part3_3);
642: END IF;
643: RETURN FALSE;
644: END IF;

Line 641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part3_3 - II ' || l_part3_3);

637: ELSIF (l_part3_1 <> 'S') OR (l_part3_2 <> 'B') THEN
638: IF l_part3_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
639: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
640: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part3_3 - II ' || l_part3_3);
642: END IF;
643: RETURN FALSE;
644: END IF;
645: END IF;

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

646:
647: l_part_4 := SUBSTR(p_loan_number,15,3);
648:
649: IF l_part_4 = '000' THEN
650: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part_4 ' || l_part_4);
652: END IF;
653: RETURN FALSE;
654: ELSE

Line 651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part_4 ' || l_part_4);

647: l_part_4 := SUBSTR(p_loan_number,15,3);
648:
649: IF l_part_4 = '000' THEN
650: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part_4 ' || l_part_4);
652: END IF;
653: RETURN FALSE;
654: ELSE
655: l_part4_1 := SUBSTR(l_part_4,1,1);

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

658:
659: IF l_part4_1 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
660: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
661:
662: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_1 ' || l_part4_1);
664: END IF;
665: RETURN FALSE;
666:

Line 663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_1 ' || l_part4_1);

659: IF l_part4_1 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
660: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
661:
662: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_1 ' || l_part4_1);
664: END IF;
665: RETURN FALSE;
666:
667: ELSIF l_part4_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',

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

665: RETURN FALSE;
666:
667: ELSIF l_part4_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
668: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
669: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_2 ' || l_part4_2);
671: END IF;
672: RETURN FALSE;
673:

Line 670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_2 ' || l_part4_2);

666:
667: ELSIF l_part4_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
668: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
669: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
670: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_2 ' || l_part4_2);
671: END IF;
672: RETURN FALSE;
673:
674: ELSIF l_part4_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',

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

672: RETURN FALSE;
673:
674: ELSIF l_part4_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
675: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
677: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_3 ' || l_part4_3);
678: END IF;
679: RETURN FALSE;
680:

Line 677: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_3 ' || l_part4_3);

673:
674: ELSIF l_part4_3 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J',
675: 'K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') THEN
676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
677: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.is_valid.debug','IS_VALID: l_part4_3 ' || l_part4_3);
678: END IF;
679: RETURN FALSE;
680:
681: END IF;

Line 1186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1182: RETURN check_passed;
1183:
1184: EXCEPTION
1185: WHEN others THEN
1186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_release.exception','Exception ' || SQLERRM);
1188: END IF;
1189: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1190: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_RELEASE');

Line 1187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_release.exception','Exception ' || SQLERRM);

1183:
1184: EXCEPTION
1185: WHEN others THEN
1186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_release.exception','Exception ' || SQLERRM);
1188: END IF;
1189: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1190: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_RELEASE');
1191:

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

1701: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1702: p_status := FALSE;
1703: ELSE
1704:
1705: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.debug','Borr Person ID ' || lv_person_id);
1707: END IF;
1708: g_p_person_id := lv_person_id;
1709:

Line 1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.debug','Borr Person ID ' || lv_person_id);

1702: p_status := FALSE;
1703: ELSE
1704:
1705: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1706: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.debug','Borr Person ID ' || lv_person_id);
1707: END IF;
1708: g_p_person_id := lv_person_id;
1709:
1710: OPEN c_relationship(p_interface.person_number,p_interface.borr_person_number);

Line 2922: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

2918: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2919: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
2920: fnd_file.put_line(fnd_file.log,fnd_message.get);
2921:
2922: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2923: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.exception','VALIDATE_LOAN_ORIG_INT ' || SQLERRM);
2924: END IF;
2925:
2926: RAISE IMPORT_ERROR;

Line 2923: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.exception','VALIDATE_LOAN_ORIG_INT ' || SQLERRM);

2919: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
2920: fnd_file.put_line(fnd_file.log,fnd_message.get);
2921:
2922: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2923: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.exception','VALIDATE_LOAN_ORIG_INT ' || SQLERRM);
2924: END IF;
2925:
2926: RAISE IMPORT_ERROR;
2927:

Line 3254: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3250: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3251: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
3252: fnd_file.put_line(fnd_file.log,fnd_message.get);
3253:
3254: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3255: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_disb.exception','Unhandled exception : '||SQLERRM);
3256: END IF;
3257: RAISE IMPORT_ERROR;
3258:

Line 3255: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_disb.exception','Unhandled exception : '||SQLERRM);

3251: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
3252: fnd_file.put_line(fnd_file.log,fnd_message.get);
3253:
3254: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3255: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_disb.exception','Unhandled exception : '||SQLERRM);
3256: END IF;
3257: RAISE IMPORT_ERROR;
3258:
3259: END validate_loan_disb;

Line 3297: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3294: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.WRITE_LOGFILE');
3295: fnd_file.put_line(fnd_file.log,fnd_message.get);
3296:
3297: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3298: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.write_logfile.exception','unhandled exception : '||SQLERRM);
3299: END IF;
3300: RAISE IMPORT_ERROR;
3301:

Line 3298: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.write_logfile.exception','unhandled exception : '||SQLERRM);

3294: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.WRITE_LOGFILE');
3295: fnd_file.put_line(fnd_file.log,fnd_message.get);
3296:
3297: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3298: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.write_logfile.exception','unhandled exception : '||SQLERRM);
3299: END IF;
3300: RAISE IMPORT_ERROR;
3301:
3302: END write_logfile;

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

3406: IF (c_lor%FOUND) THEN
3407: CLOSE c_lor;
3408: l_lor_rowid := l_lor.rowid;
3409: l_lor_orig_id := l_lor.origination_id;
3410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','DELETE_RECORDS: Before c_pnote_hist OPEN');
3412: END IF;
3413:
3414: FOR l_pnote_hist IN c_pnote_hist(p_loan_id)

Line 3411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','DELETE_RECORDS: Before c_pnote_hist OPEN');

3407: CLOSE c_lor;
3408: l_lor_rowid := l_lor.rowid;
3409: l_lor_orig_id := l_lor.origination_id;
3410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','DELETE_RECORDS: Before c_pnote_hist OPEN');
3412: END IF;
3413:
3414: FOR l_pnote_hist IN c_pnote_hist(p_loan_id)
3415: LOOP

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

3412: END IF;
3413:
3414: FOR l_pnote_hist IN c_pnote_hist(p_loan_id)
3415: LOOP
3416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.debug','DELETE_RECORDS: c_pnote_hist ROWID ' || l_pnote_hist.rowid);
3418: END IF;
3419: igf_sl_pnote_stat_h_pkg.delete_row(l_pnote_hist.rowid);
3420: END LOOP;

Line 3417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.debug','DELETE_RECORDS: c_pnote_hist ROWID ' || l_pnote_hist.rowid);

3413:
3414: FOR l_pnote_hist IN c_pnote_hist(p_loan_id)
3415: LOOP
3416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.debug','DELETE_RECORDS: c_pnote_hist ROWID ' || l_pnote_hist.rowid);
3418: END IF;
3419: igf_sl_pnote_stat_h_pkg.delete_row(l_pnote_hist.rowid);
3420: END LOOP;
3421:

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

3423: FETCH c_lor_loc INTO l_lor_loc;
3424: IF (c_lor_loc%FOUND) THEN
3425: CLOSE c_lor_loc;
3426: l_loc_rowid := l_lor_loc.rowid;
3427: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);
3429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_loc_rowid.rowid:'||l_loc_rowid);
3430: END IF;
3431: igf_sl_lor_loc_pkg.delete_row(l_loc_rowid);

Line 3428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);

3424: IF (c_lor_loc%FOUND) THEN
3425: CLOSE c_lor_loc;
3426: l_loc_rowid := l_lor_loc.rowid;
3427: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);
3429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_loc_rowid.rowid:'||l_loc_rowid);
3430: END IF;
3431: igf_sl_lor_loc_pkg.delete_row(l_loc_rowid);
3432: igf_sl_lor_pkg.delete_row(l_lor_rowid);

Line 3429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_loc_rowid.rowid:'||l_loc_rowid);

3425: CLOSE c_lor_loc;
3426: l_loc_rowid := l_lor_loc.rowid;
3427: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3428: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);
3429: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_loc_rowid.rowid:'||l_loc_rowid);
3430: END IF;
3431: igf_sl_lor_loc_pkg.delete_row(l_loc_rowid);
3432: igf_sl_lor_pkg.delete_row(l_lor_rowid);
3433: ELSE

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

3431: igf_sl_lor_loc_pkg.delete_row(l_loc_rowid);
3432: igf_sl_lor_pkg.delete_row(l_lor_rowid);
3433: ELSE
3434: CLOSE c_lor_loc;
3435: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3436: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);
3437: END IF;
3438: igf_sl_lor_pkg.delete_row(l_lor_rowid);
3439: END IF;

Line 3436: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);

3432: igf_sl_lor_pkg.delete_row(l_lor_rowid);
3433: ELSE
3434: CLOSE c_lor_loc;
3435: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3436: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_lor_rowid.rowid:'||l_lor_rowid);
3437: END IF;
3438: igf_sl_lor_pkg.delete_row(l_lor_rowid);
3439: END IF;
3440: ELSE

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

3446: OPEN c_alt_borw(p_loan_id);
3447: FETCH c_alt_borw INTO l_alt_borw;
3448: IF (c_alt_borw%FOUND) THEN
3449: CLOSE c_alt_borw;
3450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_alt_borw ROWID '|| l_alt_borw.rowid);
3452: END IF;
3453: igf_sl_alt_borw_pkg.delete_row(x_ROWID => l_alt_borw.rowid);
3454: ELSE

Line 3451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_alt_borw ROWID '|| l_alt_borw.rowid);

3447: FETCH c_alt_borw INTO l_alt_borw;
3448: IF (c_alt_borw%FOUND) THEN
3449: CLOSE c_alt_borw;
3450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_alt_borw ROWID '|| l_alt_borw.rowid);
3452: END IF;
3453: igf_sl_alt_borw_pkg.delete_row(x_ROWID => l_alt_borw.rowid);
3454: ELSE
3455: CLOSE c_alt_borw;

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

3455: CLOSE c_alt_borw;
3456: END IF;
3457:
3458: FOR l_disb_loc IN c_disb_loc(l_award_id) LOOP
3459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_disb_loc ROWID ' || l_disb_loc.rowid);
3461: END IF;
3462: igf_sl_awd_disb_loc_pkg.delete_row(x_ROWID => l_disb_loc.rowid);
3463: END LOOP;

Line 3460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_disb_loc ROWID ' || l_disb_loc.rowid);

3456: END IF;
3457:
3458: FOR l_disb_loc IN c_disb_loc(l_award_id) LOOP
3459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_disb_loc ROWID ' || l_disb_loc.rowid);
3461: END IF;
3462: igf_sl_awd_disb_loc_pkg.delete_row(x_ROWID => l_disb_loc.rowid);
3463: END LOOP;
3464:

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

3473: OPEN c_resp_r4(l_resp_r1_clrp1_id);
3474: FETCH c_resp_r4 INTO l_resp_r4;
3475: IF (c_resp_r4%FOUND) THEN
3476: CLOSE c_resp_r4;
3477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3478: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r4 ROWID ' || l_resp_r4.rowid);
3479: END IF;
3480: igf_sl_cl_resp_r4_pkg.delete_row(l_resp_r4.rowid);
3481: ELSE

Line 3478: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r4 ROWID ' || l_resp_r4.rowid);

3474: FETCH c_resp_r4 INTO l_resp_r4;
3475: IF (c_resp_r4%FOUND) THEN
3476: CLOSE c_resp_r4;
3477: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3478: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r4 ROWID ' || l_resp_r4.rowid);
3479: END IF;
3480: igf_sl_cl_resp_r4_pkg.delete_row(l_resp_r4.rowid);
3481: ELSE
3482: CLOSE c_resp_r4;

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

3482: CLOSE c_resp_r4;
3483: END IF;
3484:
3485: FOR l_resp_r8 IN c_resp_r8(l_resp_r1_clrp1_id) LOOP
3486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r8 ROWID ' || l_resp_r8.rowid);
3488: END IF;
3489: igf_sl_cl_resp_r8_pkg.delete_row(x_ROWID => l_resp_r8.rowid);
3490: END LOOP;

Line 3487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r8 ROWID ' || l_resp_r8.rowid);

3483: END IF;
3484:
3485: FOR l_resp_r8 IN c_resp_r8(l_resp_r1_clrp1_id) LOOP
3486: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r8 ROWID ' || l_resp_r8.rowid);
3488: END IF;
3489: igf_sl_cl_resp_r8_pkg.delete_row(x_ROWID => l_resp_r8.rowid);
3490: END LOOP;
3491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r8 ROWID ' || l_resp_r8.rowid);
3488: END IF;
3489: igf_sl_cl_resp_r8_pkg.delete_row(x_ROWID => l_resp_r8.rowid);
3490: END LOOP;
3491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r1 ROWID ' || l_resp_r1.rowid);
3493: END IF;
3494: igf_sl_cl_resp_r1_pkg.delete_row(x_ROWID => l_resp_r1_rowid);
3495:

Line 3492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r1 ROWID ' || l_resp_r1.rowid);

3488: END IF;
3489: igf_sl_cl_resp_r8_pkg.delete_row(x_ROWID => l_resp_r8.rowid);
3490: END LOOP;
3491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_resp_r1 ROWID ' || l_resp_r1.rowid);
3493: END IF;
3494: igf_sl_cl_resp_r1_pkg.delete_row(x_ROWID => l_resp_r1_rowid);
3495:
3496: ELSE

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

3497: CLOSE c_resp_r1;
3498: END IF;
3499:
3500: FOR l_disb_resp IN c_disb_resp(p_loan_number) LOOP
3501: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_disb_resp ROWID ' || l_disb_resp.rowid);
3503: END IF;
3504: igf_db_cl_disb_resp_pkg.delete_row(x_ROWID => l_disb_resp.rowid);
3505: END LOOP;

Line 3502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_disb_resp ROWID ' || l_disb_resp.rowid);

3498: END IF;
3499:
3500: FOR l_disb_resp IN c_disb_resp(p_loan_number) LOOP
3501: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3502: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','l_disb_resp ROWID ' || l_disb_resp.rowid);
3503: END IF;
3504: igf_db_cl_disb_resp_pkg.delete_row(x_ROWID => l_disb_resp.rowid);
3505: END LOOP;
3506:

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

3505: END LOOP;
3506:
3507: END IF;
3508:
3509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);
3511: END IF;
3512: igf_sl_loans_pkg.delete_row(p_rowid);
3513:

Line 3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);

3506:
3507: END IF;
3508:
3509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);
3511: END IF;
3512: igf_sl_loans_pkg.delete_row(p_rowid);
3513:
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);
3511: END IF;
3512: igf_sl_loans_pkg.delete_row(p_rowid);
3513:
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','Deletion Complete');
3516: END IF;
3517:
3518:

Line 3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','Deletion Complete');

3511: END IF;
3512: igf_sl_loans_pkg.delete_row(p_rowid);
3513:
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','Deletion Complete');
3516: END IF;
3517:
3518:
3519: EXCEPTION

Line 3522: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

3518:
3519: EXCEPTION
3520: WHEN OTHERS THEN
3521:
3522: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3523: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.exception','Exception ' || SQLERRM);
3524: END IF;
3525: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3526: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.DELETE_RECORDS');

Line 3523: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.exception','Exception ' || SQLERRM);

3519: EXCEPTION
3520: WHEN OTHERS THEN
3521:
3522: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3523: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.exception','Exception ' || SQLERRM);
3524: END IF;
3525: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3526: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.DELETE_RECORDS');
3527:

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

3731: lv_disb_net_amt NUMBER;
3732:
3733: BEGIN
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into loans IGF_SL_LOANS_ALL');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg..debug','Values :' ||
3738: ' Award ID ' ||
3739: p_award_id ||

Line 3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into loans IGF_SL_LOANS_ALL');

3732:
3733: BEGIN
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into loans IGF_SL_LOANS_ALL');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg..debug','Values :' ||
3738: ' Award ID ' ||
3739: p_award_id ||
3740: ' Loan Seq Number ' ||

Line 3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg..debug','Values :' ||

3733: BEGIN
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into loans IGF_SL_LOANS_ALL');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg..debug','Values :' ||
3738: ' Award ID ' ||
3739: p_award_id ||
3740: ' Loan Seq Number ' ||
3741: p_interface.loan_seq_num ||

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

3775: x_external_loan_id_txt => p_interface.external_loan_id_txt
3776:
3777: );
3778:
3779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After Insert into IGF_SL_LOANS LOAN_ID ' || ln_loan_id);
3781: END IF;
3782:
3783:

Line 3780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After Insert into IGF_SL_LOANS LOAN_ID ' || ln_loan_id);

3776:
3777: );
3778:
3779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After Insert into IGF_SL_LOANS LOAN_ID ' || ln_loan_id);
3781: END IF;
3782:
3783:
3784: IF p_fed_fund = 'FLU' THEN

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

3799: ELSE
3800: l_p_default_status := p_interface.b_default_status_flag;
3801: END IF;
3802:
3803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_LOR');
3805: END IF;
3806:
3807: lor_rowid := NULL;

Line 3804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_LOR');

3800: l_p_default_status := p_interface.b_default_status_flag;
3801: END IF;
3802:
3803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_LOR');
3805: END IF;
3806:
3807: lor_rowid := NULL;
3808: ln_origination_id := NULL;

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

3934: x_acad_end_date => NULL,
3935: x_b_alien_reg_num_txt => NULL,
3936: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
3937: );
3938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_LOR ln_origination_id ' || ln_origination_id);
3940: END IF;
3941:
3942: IF p_fed_fund = 'ALT' THEN

Line 3939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_LOR ln_origination_id ' || ln_origination_id);

3935: x_b_alien_reg_num_txt => NULL,
3936: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
3937: );
3938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_LOR ln_origination_id ' || ln_origination_id);
3940: END IF;
3941:
3942: IF p_fed_fund = 'ALT' THEN
3943:

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

3940: END IF;
3941:
3942: IF p_fed_fund = 'ALT' THEN
3943:
3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_ALT_BORW_ALL');
3946: END IF;
3947:
3948: ln_albw_id := NULL;

Line 3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_ALT_BORW_ALL');

3941:
3942: IF p_fed_fund = 'ALT' THEN
3943:
3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_ALT_BORW_ALL');
3946: END IF;
3947:
3948: ln_albw_id := NULL;
3949: alt_rowid := NULL;

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

4031: x_cs2_suffix_txt => p_interface.cs2_suffix_txt,
4032: x_cs2_years_at_address_txt => p_interface.cs2_years_at_address_txt
4033: );
4034:
4035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_ALT_BORW_ALL albw_id ' || ln_albw_id);
4037: END IF;
4038:
4039: END IF;

Line 4036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_ALT_BORW_ALL albw_id ' || ln_albw_id);

4032: x_cs2_years_at_address_txt => p_interface.cs2_years_at_address_txt
4033: );
4034:
4035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_ALT_BORW_ALL albw_id ' || ln_albw_id);
4037: END IF;
4038:
4039: END IF;
4040:

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

4079:
4080: END IF;
4081:
4082:
4083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_LOR_LOC_ALL');
4085: END IF;
4086:
4087: loc_rowid := NULL;

Line 4084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_LOR_LOC_ALL');

4080: END IF;
4081:
4082:
4083: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_LOR_LOC_ALL');
4085: END IF;
4086:
4087: loc_rowid := NULL;
4088:

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

4286: x_student_electronic_sign_flag => p_interface.stud_sign_flag,
4287: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
4288: );
4289:
4290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','After insert into IGF_SL_LOR_LOC_ALL');
4292: END IF;
4293:
4294: IF ( p_fed_fund in ('ALT','FLP','GPLUSFL') ) AND (NVL(p_interface.b_stu_indicator_flag,'X') <> 'Y') THEN

Line 4291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','After insert into IGF_SL_LOR_LOC_ALL');

4287: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
4288: );
4289:
4290: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4291: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','After insert into IGF_SL_LOR_LOC_ALL');
4292: END IF;
4293:
4294: IF ( p_fed_fund in ('ALT','FLP','GPLUSFL') ) AND (NVL(p_interface.b_stu_indicator_flag,'X') <> 'Y') THEN
4295: l_b_last_name := parent_dtl_rec.p_last_name;

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

4344: IF (chk_batch_id%NOTFOUND) THEN
4345: CLOSE chk_batch_id;
4346: clb_rowid := NULL;
4347:
4348: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH_ALL - I');
4350: END IF;
4351:
4352: igf_sl_cl_batch_pkg.insert_row (

Line 4349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH_ALL - I');

4345: CLOSE chk_batch_id;
4346: clb_rowid := NULL;
4347:
4348: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH_ALL - I');
4350: END IF;
4351:
4352: igf_sl_cl_batch_pkg.insert_row (
4353: x_rowid => clb_rowid,

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

4371: x_total_deficit_amt => NULL,
4372: x_total_net_cancel_amt => NULL,
4373: x_total_net_out_cancel_amt => NULL);
4374:
4375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH_ALL - I ln_cbth_id ' || ln_cbth_id);
4377: END IF;
4378: ELSE
4379: CLOSE chk_batch_id;

Line 4376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH_ALL - I ln_cbth_id ' || ln_cbth_id);

4372: x_total_net_cancel_amt => NULL,
4373: x_total_net_out_cancel_amt => NULL);
4374:
4375: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH_ALL - I ln_cbth_id ' || ln_cbth_id);
4377: END IF;
4378: ELSE
4379: CLOSE chk_batch_id;
4380: END IF;

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

4394: IF (chk_batch_id%NOTFOUND) THEN
4395: CLOSE chk_batch_id;
4396: clb_rowid := NULL;
4397:
4398: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_CL_BATCH_ALL');
4400: END IF;
4401:
4402: igf_sl_cl_batch_pkg.insert_row (

Line 4399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_CL_BATCH_ALL');

4395: CLOSE chk_batch_id;
4396: clb_rowid := NULL;
4397:
4398: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into IGF_SL_CL_BATCH_ALL');
4400: END IF;
4401:
4402: igf_sl_cl_batch_pkg.insert_row (
4403: x_rowid => clb_rowid,

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

4421: x_total_deficit_amt => NULL,
4422: x_total_net_cancel_amt => NULL,
4423: x_total_net_out_cancel_amt => NULL);
4424:
4425: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH_ALL ln_cbth_id ' || ln_cbth_id);
4427: END IF;
4428: ELSE
4429: CLOSE chk_batch_id;

Line 4426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH_ALL ln_cbth_id ' || ln_cbth_id);

4422: x_total_net_cancel_amt => NULL,
4423: x_total_net_out_cancel_amt => NULL);
4424:
4425: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4426: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH_ALL ln_cbth_id ' || ln_cbth_id);
4427: END IF;
4428: ELSE
4429: CLOSE chk_batch_id;
4430: END IF;

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

4429: CLOSE chk_batch_id;
4430: END IF;
4431:
4432: -- POPULATE R1 AND R4
4433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R1');
4435: END IF;
4436:
4437: l_rl_row_id := NULL;

Line 4434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R1');

4430: END IF;
4431:
4432: -- POPULATE R1 AND R4
4433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R1');
4435: END IF;
4436:
4437: l_rl_row_id := NULL;
4438:

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

4572: x_b_alien_reg_num_txt => NULL,
4573: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
4574: );
4575:
4576: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R1 l_clrp1_id ' || l_clrp1_id);
4578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4');
4579: END IF;
4580:

Line 4577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R1 l_clrp1_id ' || l_clrp1_id);

4573: x_esign_src_typ_cd => p_interface.esign_src_typ_cd
4574: );
4575:
4576: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R1 l_clrp1_id ' || l_clrp1_id);
4578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4');
4579: END IF;
4580:
4581: l_r4_row_id := NULL;

Line 4578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4');

4574: );
4575:
4576: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R1 l_clrp1_id ' || l_clrp1_id);
4578: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4');
4579: END IF;
4580:
4581: l_r4_row_id := NULL;
4582:

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

4664: x_first_csgnr_elec_sign_flag => NULL,
4665: x_second_csgnr_elec_sign_flag => NULL
4666: );
4667:
4668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4 l_clrp1_id ' || l_clrp1_id);
4670: END IF;
4671: -- THEN R8 BASED ON RECORD RETRIEVED THRU R1
4672: i := 0;

Line 4669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4 l_clrp1_id ' || l_clrp1_id);

4665: x_second_csgnr_elec_sign_flag => NULL
4666: );
4667:
4668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R4 l_clrp1_id ' || l_clrp1_id);
4670: END IF;
4671: -- THEN R8 BASED ON RECORD RETRIEVED THRU R1
4672: i := 0;
4673:

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

4670: END IF;
4671: -- THEN R8 BASED ON RECORD RETRIEVED THRU R1
4672: i := 0;
4673:
4674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4675: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8');
4676: END IF;
4677:
4678: FOR l_disb_interface IN c_disb_interface( p_interface.ci_alternate_code,

Line 4675: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8');

4671: -- THEN R8 BASED ON RECORD RETRIEVED THRU R1
4672: i := 0;
4673:
4674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4675: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8');
4676: END IF;
4677:
4678: FOR l_disb_interface IN c_disb_interface( p_interface.ci_alternate_code,
4679: p_interface.person_number,

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

4688: OPEN c_disb_det(l_disb_interface.disbursement_num);
4689: FETCH c_disb_det INTO l_disb_det;
4690: CLOSE c_disb_det;
4691:
4692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4694: END IF;
4695:
4696: igf_aw_awd_disb_pkg.update_row (

Line 4693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');

4689: FETCH c_disb_det INTO l_disb_det;
4690: CLOSE c_disb_det;
4691:
4692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4694: END IF;
4695:
4696: igf_aw_awd_disb_pkg.update_row (
4697: x_mode => 'R',

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

4741: x_payment_prd_st_date => l_disb_det.payment_prd_st_date,
4742: x_direct_to_borr_flag => l_disb_interface.direct_to_borr_flag
4743: );
4744:
4745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4746: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8 - LOOP');
4747: END IF;
4748:
4749: igf_sl_cl_resp_r8_pkg.insert_row (

Line 4746: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8 - LOOP');

4742: x_direct_to_borr_flag => l_disb_interface.direct_to_borr_flag
4743: );
4744:
4745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4746: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8 - LOOP');
4747: END IF;
4748:
4749: igf_sl_cl_resp_r8_pkg.insert_row (
4750: x_mode => 'R',

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

4765: x_layout_version_code_txt => NULL,
4766: x_record_code_txt => NULL,
4767: x_direct_to_borr_flag => l_disb_interface.direct_to_borr_flag);
4768:
4769: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4770: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8 - LOOP l_clrp1_id ' || l_clrp1_id || ' i ' || i);
4771: END IF;
4772: clb_rowid := NULL;
4773: ln_cbth_id := NULL;

Line 4770: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8 - LOOP l_clrp1_id ' || l_clrp1_id || ' i ' || i);

4766: x_record_code_txt => NULL,
4767: x_direct_to_borr_flag => l_disb_interface.direct_to_borr_flag);
4768:
4769: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4770: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_RESP_R8 - LOOP l_clrp1_id ' || l_clrp1_id || ' i ' || i);
4771: END IF;
4772: clb_rowid := NULL;
4773: ln_cbth_id := NULL;
4774:

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

4779:
4780: IF (chk_batch_id%NOTFOUND) THEN
4781: CLOSE chk_batch_id;
4782:
4783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH');
4785: END IF;
4786:
4787: ln_cbth_id := NULL;

Line 4784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH');

4780: IF (chk_batch_id%NOTFOUND) THEN
4781: CLOSE chk_batch_id;
4782:
4783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_CL_BATCH');
4785: END IF;
4786:
4787: ln_cbth_id := NULL;
4788: clb_rowid := NULL;

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

4816: IF ln_cbth_id IS NULL THEN
4817: ln_cbth_id := l_batch_id.cbth_id;
4818: END IF;
4819:
4820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH ln_cbth_id ' || ln_cbth_id);
4822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_DB_CL_DISB_RESP');
4823: END IF;
4824:

Line 4821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH ln_cbth_id ' || ln_cbth_id);

4817: ln_cbth_id := l_batch_id.cbth_id;
4818: END IF;
4819:
4820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH ln_cbth_id ' || ln_cbth_id);
4822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_DB_CL_DISB_RESP');
4823: END IF;
4824:
4825: l_rost_rowid := NULL;

Line 4822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_DB_CL_DISB_RESP');

4818: END IF;
4819:
4820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_BATCH ln_cbth_id ' || ln_cbth_id);
4822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_DB_CL_DISB_RESP');
4823: END IF;
4824:
4825: l_rost_rowid := NULL;
4826: l_cdbr_id := NULL;

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

4913: OPEN c_disb_det(l_disb_interface.disbursement_num);
4914: FETCH c_disb_det INTO l_disb_det;
4915: CLOSE c_disb_det;
4916:
4917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4919: END IF;
4920:
4921: igf_aw_awd_disb_pkg.update_row (

Line 4918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');

4914: FETCH c_disb_det INTO l_disb_det;
4915: CLOSE c_disb_det;
4916:
4917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4918: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before Update IGF_AW_AWD_DISB');
4919: END IF;
4920:
4921: igf_aw_awd_disb_pkg.update_row (
4922: x_mode => 'R',

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

4966: x_payment_prd_st_date => l_disb_det.payment_prd_st_date,
4967: x_direct_to_borr_flag => l_disb_interface.direct_to_borr_flag
4968: );
4969:
4970: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4971: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R8 - LOOP');
4972: END IF;
4973: END LOOP;
4974: END IF;

Line 4971: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R8 - LOOP');

4967: x_direct_to_borr_flag => l_disb_interface.direct_to_borr_flag
4968: );
4969:
4970: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4971: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_CL_RESP_R8 - LOOP');
4972: END IF;
4973: END LOOP;
4974: END IF;
4975:

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

4972: END IF;
4973: END LOOP;
4974: END IF;
4975:
4976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_AWD_DISB_LOC');
4978: END IF;
4979:
4980: DECLARE

Line 4977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_AWD_DISB_LOC');

4973: END LOOP;
4974: END IF;
4975:
4976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_AWD_DISB_LOC');
4978: END IF;
4979:
4980: DECLARE
4981:

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

5014: x_hold_rel_ind => tbh_rec.hold_rel_ind,
5015: x_fee_paid_1 => tbh_rec.fee_paid_1,
5016: x_fee_paid_2 => tbh_rec.fee_paid_2);
5017:
5018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5019: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug',' After insert into IGF_SL_AWD_DISB_LOC');
5020: END IF;
5021:
5022: END LOOP;

Line 5019: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug',' After insert into IGF_SL_AWD_DISB_LOC');

5015: x_fee_paid_1 => tbh_rec.fee_paid_1,
5016: x_fee_paid_2 => tbh_rec.fee_paid_2);
5017:
5018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5019: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug',' After insert into IGF_SL_AWD_DISB_LOC');
5020: END IF;
5021:
5022: END LOOP;
5023:

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

5022: END LOOP;
5023:
5024: END;
5025:
5026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','DML Complete');
5028: END IF;
5029:
5030: EXCEPTION

Line 5027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','DML Complete');

5023:
5024: END;
5025:
5026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','DML Complete');
5028: END IF;
5029:
5030: EXCEPTION
5031: WHEN OTHERS THEN

Line 5033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

5029:
5030: EXCEPTION
5031: WHEN OTHERS THEN
5032:
5033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.exception','Exception ' || SQLERRM);
5035: END IF;
5036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
5037: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.INSERT_RECORDS');

Line 5034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.exception','Exception ' || SQLERRM);

5030: EXCEPTION
5031: WHEN OTHERS THEN
5032:
5033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.exception','Exception ' || SQLERRM);
5035: END IF;
5036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
5037: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.INSERT_RECORDS');
5038:

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

5190: FETCH c_get_batch_desc INTO l_get_batch_desc;
5191: CLOSE c_get_batch_desc;
5192:
5193: l_batch_desc := p_batch_id ||' - ' || l_get_batch_desc.batch_desc ;
5194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_batch_desc ' || l_batch_desc);
5196: END IF;
5197:
5198: l_get_alternate_code := NULL;

Line 5195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_batch_desc ' || l_batch_desc);

5191: CLOSE c_get_batch_desc;
5192:
5193: l_batch_desc := p_batch_id ||' - ' || l_get_batch_desc.batch_desc ;
5194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5195: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_batch_desc ' || l_batch_desc);
5196: END IF;
5197:
5198: l_get_alternate_code := NULL;
5199:

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

5202: CLOSE c_get_alternate_code;
5203:
5204: log_parameters( l_get_alternate_code.alternate_code,p_batch_id,igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
5205:
5206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_cal_type:'||l_cal_type ||' l_seq_number:'||l_seq_number);
5208: END IF;
5209:
5210: l_chk_profile := igf_ap_gen.check_profile;

Line 5207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_cal_type:'||l_cal_type ||' l_seq_number:'||l_seq_number);

5203:
5204: log_parameters( l_get_alternate_code.alternate_code,p_batch_id,igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
5205:
5206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_cal_type:'||l_cal_type ||' l_seq_number:'||l_seq_number);
5208: END IF;
5209:
5210: l_chk_profile := igf_ap_gen.check_profile;
5211:

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

5208: END IF;
5209:
5210: l_chk_profile := igf_ap_gen.check_profile;
5211:
5212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_profile ' || l_chk_profile);
5214: END IF;
5215:
5216:

Line 5213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_profile ' || l_chk_profile);

5209:
5210: l_chk_profile := igf_ap_gen.check_profile;
5211:
5212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_profile ' || l_chk_profile);
5214: END IF;
5215:
5216:
5217: IF l_chk_profile = 'N' THEN

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

5219: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5220: RETURN;
5221: END IF;
5222:
5223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_get_alternate_code.alternate_code ' || l_get_alternate_code.alternate_code);
5225: END IF;
5226:
5227: IF (l_get_alternate_code.alternate_code IS NULL) THEN

Line 5224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_get_alternate_code.alternate_code ' || l_get_alternate_code.alternate_code);

5220: RETURN;
5221: END IF;
5222:
5223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_get_alternate_code.alternate_code ' || l_get_alternate_code.alternate_code);
5225: END IF;
5226:
5227: IF (l_get_alternate_code.alternate_code IS NULL) THEN
5228: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');

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

5230: RETURN;
5231: END IF;
5232:
5233: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'LOANS');
5234: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_batch ' || l_chk_batch);
5236: END IF;
5237:
5238: IF l_chk_batch = 'N' THEN

Line 5235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_batch ' || l_chk_batch);

5231: END IF;
5232:
5233: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'LOANS');
5234: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_batch ' || l_chk_batch);
5236: END IF;
5237:
5238: IF l_chk_batch = 'N' THEN
5239: -- Bug # 4008991

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

5273: END IF;
5274:
5275: IF (l_award_year_status = 'O') THEN
5276: lb_open_flag := TRUE;
5277: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5278: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : TRUE');
5279: END IF;
5280: ELSE
5281: lb_open_flag := FALSE;

Line 5278: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : TRUE');

5274:
5275: IF (l_award_year_status = 'O') THEN
5276: lb_open_flag := TRUE;
5277: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5278: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : TRUE');
5279: END IF;
5280: ELSE
5281: lb_open_flag := FALSE;
5282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

5278: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : TRUE');
5279: END IF;
5280: ELSE
5281: lb_open_flag := FALSE;
5282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : FALSE');
5284: END IF;
5285: END IF;
5286:

Line 5283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : FALSE');

5279: END IF;
5280: ELSE
5281: lb_open_flag := FALSE;
5282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lb_open_flag : FALSE');
5284: END IF;
5285: END IF;
5286:
5287: FOR l_interface IN c_interface(p_batch_id,l_get_alternate_code.alternate_code,'U','R') LOOP

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

5300: -- Check if person exists in OSS
5301: --
5302: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
5303:
5304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id||' lv_base_id ' || lv_base_id);
5306: END IF;
5307:
5308: IF lv_person_id IS NULL THEN

Line 5305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id||' lv_base_id ' || lv_base_id);

5301: --
5302: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
5303:
5304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id||' lv_base_id ' || lv_base_id);
5306: END IF;
5307:
5308: IF lv_person_id IS NULL THEN
5309: fnd_message.set_name('IGF','IGF_SL_LI_PERSON_NOT_FND');

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

5310: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5311: fnd_file.new_line(fnd_file.log,1);
5312: g_error_flag := TRUE;
5313: ELSE
5314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Pesron Number check passed');
5316: END IF;
5317: --
5318: -- Check if base record present

Line 5315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Pesron Number check passed');

5311: fnd_file.new_line(fnd_file.log,1);
5312: g_error_flag := TRUE;
5313: ELSE
5314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Pesron Number check passed');
5316: END IF;
5317: --
5318: -- Check if base record present
5319: --

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

5323: fnd_file.new_line(fnd_file.log,1);
5324: g_error_flag := TRUE;
5325:
5326: ELSE
5327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5328: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Base record check passed');
5329: END IF;
5330: --
5331: -- Check if corresponding award is present in the awards table

Line 5328: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Base record check passed');

5324: g_error_flag := TRUE;
5325:
5326: ELSE
5327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5328: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Base record check passed');
5329: END IF;
5330: --
5331: -- Check if corresponding award is present in the awards table
5332: --

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

5347: CLOSE c_get_award;
5348:
5349: l_award_id := l_get_award.award_id;
5350:
5351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award ID ' || l_award_id);
5353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award Reference check passed');
5354: END IF;
5355:

Line 5352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award ID ' || l_award_id);

5348:
5349: l_award_id := l_get_award.award_id;
5350:
5351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award ID ' || l_award_id);
5353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award Reference check passed');
5354: END IF;
5355:
5356: lb_isir_flag := TRUE;

Line 5353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award Reference check passed');

5349: l_award_id := l_get_award.award_id;
5350:
5351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5352: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award ID ' || l_award_id);
5353: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Award Reference check passed');
5354: END IF;
5355:
5356: lb_isir_flag := TRUE;
5357:

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

5369: lb_isir_flag := FALSE;
5370: g_error_flag := TRUE;
5371: ELSE
5372: CLOSE c_act_isir;
5373: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Active ISIR for Open Award Year check passed');
5375: END IF;
5376: END IF; -- c_act_isir IF
5377: END IF; -- lb_open_flag IF

Line 5374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Active ISIR for Open Award Year check passed');

5370: g_error_flag := TRUE;
5371: ELSE
5372: CLOSE c_act_isir;
5373: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5374: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Active ISIR for Open Award Year check passed');
5375: END IF;
5376: END IF; -- c_act_isir IF
5377: END IF; -- lb_open_flag IF
5378:

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

5377: END IF; -- lb_open_flag IF
5378:
5379: IF (lb_isir_flag = TRUE) THEN
5380:
5381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Loan status and active isir check passed');
5383: END IF;
5384: --
5385: -- Check for the fed fund code and based on this check the person borrower relationship

Line 5382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Loan status and active isir check passed');

5378:
5379: IF (lb_isir_flag = TRUE) THEN
5380:
5381: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5382: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Loan status and active isir check passed');
5383: END IF;
5384: --
5385: -- Check for the fed fund code and based on this check the person borrower relationship
5386: --

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

5384: --
5385: -- Check for the fed fund code and based on this check the person borrower relationship
5386: --
5387: l_fed_fund_cd := l_get_award.fed_fund_code;
5388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5389: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Fed Fund Code ' || l_fed_fund_cd);
5390: END IF;
5391:
5392: IF (l_fed_fund_cd IS NULL) OR (l_fed_fund_cd NOT IN ('FLP','FLS','FLU','ALT','GPLUSFL'))

Line 5389: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Fed Fund Code ' || l_fed_fund_cd);

5385: -- Check for the fed fund code and based on this check the person borrower relationship
5386: --
5387: l_fed_fund_cd := l_get_award.fed_fund_code;
5388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5389: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Fed Fund Code ' || l_fed_fund_cd);
5390: END IF;
5391:
5392: IF (l_fed_fund_cd IS NULL) OR (l_fed_fund_cd NOT IN ('FLP','FLS','FLU','ALT','GPLUSFL'))
5393: THEN

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

5394: fnd_message.set_name('IGF','IGF_SL_CL_INV_FED_FND_CD');
5395: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5396: g_error_flag := TRUE;
5397: ELSE
5398: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Person Borrower relationship check passed');
5400: END IF;
5401:
5402:

Line 5399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Person Borrower relationship check passed');

5395: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5396: g_error_flag := TRUE;
5397: ELSE
5398: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Person Borrower relationship check passed');
5400: END IF;
5401:
5402:
5403: validate_loan_orig_int(l_interface,

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

5407: l_seq_number,
5408: lb_open_flag,
5409: l_fed_fund_cd);
5410:
5411: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_orig_int');
5413: END IF;
5414: END IF; -- Fund Code IF
5415:

Line 5412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_orig_int');

5408: lb_open_flag,
5409: l_fed_fund_cd);
5410:
5411: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5412: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_orig_int');
5413: END IF;
5414: END IF; -- Fund Code IF
5415:
5416:

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

5414: END IF; -- Fund Code IF
5415:
5416:
5417: IF p_status = FALSE OR g_error_flag THEN
5418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Validation of interface record failed');
5420: END IF;
5421: g_error_flag := TRUE;
5422: write_logfile('O');

Line 5419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Validation of interface record failed');

5415:
5416:
5417: IF p_status = FALSE OR g_error_flag THEN
5418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5419: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Validation of interface record failed');
5420: END IF;
5421: g_error_flag := TRUE;
5422: write_logfile('O');
5423: ELSE

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

5464: CLOSE c_disb_det;
5465: --
5466: -- Validate disb
5467: --
5468: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before calling validate_loan_disb');
5470: END IF;
5471: validate_loan_disb( l_disb_interface,l_award_id,p_d_status);
5472: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before calling validate_loan_disb');

5465: --
5466: -- Validate disb
5467: --
5468: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before calling validate_loan_disb');
5470: END IF;
5471: validate_loan_disb( l_disb_interface,l_award_id,p_d_status);
5472: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_disb');

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

5468: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before calling validate_loan_disb');
5470: END IF;
5471: validate_loan_disb( l_disb_interface,l_award_id,p_d_status);
5472: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_disb');
5474: END IF;
5475:
5476: END IF;

Line 5473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_disb');

5469: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before calling validate_loan_disb');
5470: END IF;
5471: validate_loan_disb( l_disb_interface,l_award_id,p_d_status);
5472: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5473: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After calling validate_loan_disb');
5474: END IF;
5475:
5476: END IF;
5477:

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

5487: p_d_status := FALSE;
5488: END IF;
5489:
5490: IF p_d_status = FALSE THEN
5491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Validation of Disbursement interface record failed');
5493: END IF;
5494: g_error_flag := TRUE;
5495: ELSIF p_d_status = TRUE AND p_status = TRUE THEN

Line 5492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Validation of Disbursement interface record failed');

5488: END IF;
5489:
5490: IF p_d_status = FALSE THEN
5491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Validation of Disbursement interface record failed');
5493: END IF;
5494: g_error_flag := TRUE;
5495: ELSIF p_d_status = TRUE AND p_status = TRUE THEN
5496:

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

5554: l_chk_loan_exist.loan_number);
5555: END IF;
5556:
5557: IF NOT g_error_flag THEN
5558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Record to be updated deleted successfully');
5560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_award_id ' || l_award_id);
5561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_fed_fund_cd ' || l_fed_fund_cd);
5562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id);

Line 5559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Record to be updated deleted successfully');

5555: END IF;
5556:
5557: IF NOT g_error_flag THEN
5558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Record to be updated deleted successfully');
5560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_award_id ' || l_award_id);
5561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_fed_fund_cd ' || l_fed_fund_cd);
5562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id);
5563: END IF;

Line 5560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_award_id ' || l_award_id);

5556:
5557: IF NOT g_error_flag THEN
5558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Record to be updated deleted successfully');
5560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_award_id ' || l_award_id);
5561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_fed_fund_cd ' || l_fed_fund_cd);
5562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id);
5563: END IF;
5564:

Line 5561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_fed_fund_cd ' || l_fed_fund_cd);

5557: IF NOT g_error_flag THEN
5558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Record to be updated deleted successfully');
5560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_award_id ' || l_award_id);
5561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_fed_fund_cd ' || l_fed_fund_cd);
5562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id);
5563: END IF;
5564:
5565:

Line 5562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id);

5558: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Record to be updated deleted successfully');
5560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_award_id ' || l_award_id);
5561: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_fed_fund_cd ' || l_fed_fund_cd);
5562: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id);
5563: END IF;
5564:
5565:
5566: insert_records(l_interface,

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

5599: g_error_flag := FALSE;
5600: --
5601: -- update the legacy interface table column import_status to 'E'
5602: --
5603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status E');
5605: END IF;
5606: UPDATE
5607: igf_sl_li_orig_ints

Line 5604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status E');

5600: --
5601: -- update the legacy interface table column import_status to 'E'
5602: --
5603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status E');
5605: END IF;
5606: UPDATE
5607: igf_sl_li_orig_ints
5608: SET

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

5616: WHERE
5617: ROWID = l_interface.ROWID;
5618:
5619: g_error_record_cnt := g_error_record_cnt + 1;
5620: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status E');
5622: END IF;
5623: fnd_file.new_line(fnd_file.log,1);
5624: fnd_message.set_name('IGF','IGF_SL_LI_SKIPPING_AWD');

Line 5621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status E');

5617: ROWID = l_interface.ROWID;
5618:
5619: g_error_record_cnt := g_error_record_cnt + 1;
5620: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status E');
5622: END IF;
5623: fnd_file.new_line(fnd_file.log,1);
5624: fnd_message.set_name('IGF','IGF_SL_LI_SKIPPING_AWD');
5625: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

5627: ELSE
5628:
5629: IF p_delete_flag = 'Y' THEN
5630:
5631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before deleting disb interface table record');
5633: END IF;
5634:
5635: DELETE

Line 5632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before deleting disb interface table record');

5628:
5629: IF p_delete_flag = 'Y' THEN
5630:
5631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before deleting disb interface table record');
5633: END IF;
5634:
5635: DELETE
5636: FROM

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

5639: ci_alternate_code = l_interface.ci_alternate_code AND
5640: person_number = l_interface.person_number AND
5641: award_number_txt = l_interface.award_number_txt;
5642:
5643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before deleting orig interface table record');
5645: END IF;
5646:
5647: DELETE

Line 5644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before deleting orig interface table record');

5640: person_number = l_interface.person_number AND
5641: award_number_txt = l_interface.award_number_txt;
5642:
5643: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5644: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before deleting orig interface table record');
5645: END IF;
5646:
5647: DELETE
5648: FROM

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

5649: igf_sl_li_orig_ints
5650: WHERE
5651: ROWID = l_interface.ROWID;
5652:
5653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After deleting orig interface table record');
5655: END IF;
5656:
5657: ELSE

Line 5654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After deleting orig interface table record');

5650: WHERE
5651: ROWID = l_interface.ROWID;
5652:
5653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After deleting orig interface table record');
5655: END IF;
5656:
5657: ELSE
5658: --

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

5658: --
5659: -- update the legacy interface table column import_status to 'I'
5660: --
5661:
5662: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status I');
5664: END IF;
5665:
5666: UPDATE

Line 5663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status I');

5659: -- update the legacy interface table column import_status to 'I'
5660: --
5661:
5662: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5663: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before update of interface table : status I');
5664: END IF;
5665:
5666: UPDATE
5667: igf_sl_li_orig_ints

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

5675: program_update_date = SYSDATE
5676: WHERE
5677: ROWID = l_interface.ROWID;
5678:
5679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status I');
5681: END IF;
5682:
5683: END IF;

Line 5680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status I');

5676: WHERE
5677: ROWID = l_interface.ROWID;
5678:
5679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status I');
5681: END IF;
5682:
5683: END IF;
5684:

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

5688: fnd_file.new_line(fnd_file.log,1);
5689:
5690: END IF;
5691:
5692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before COMMIT');
5694: END IF;
5695:
5696: COMMIT;

Line 5693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before COMMIT');

5689:
5690: END IF;
5691:
5692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before COMMIT');
5694: END IF;
5695:
5696: COMMIT;
5697: fnd_file.new_line(fnd_file.log,1);

Line 5728: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

5724:
5725: WHEN others THEN
5726: ROLLBACK;
5727:
5728: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5729: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.run.exception','Exception'|| SQLERRM);
5730: END IF;
5731: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
5732: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.RUN');

Line 5729: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.run.exception','Exception'|| SQLERRM);

5725: WHEN others THEN
5726: ROLLBACK;
5727:
5728: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5729: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.run.exception','Exception'|| SQLERRM);
5730: END IF;
5731: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
5732: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.RUN');
5733: fnd_file.put_line(fnd_file.log,fnd_message.get);