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_ORIG_ACK dependencies on IGF_AW_GEN

Line 689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));

685: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - 2' ||' ';
686: l_loan_active := NULL;
687:
688: fnd_file.new_line(fnd_file.log,1);
689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
690: fnd_file.new_line(fnd_file.log,1);
691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)

Line 692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),

688: fnd_file.new_line(fnd_file.log,1);
689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
690: fnd_file.new_line(fnd_file.log,1);
691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)
694: );
695: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),
696: p_v_param_val => l_loan_number

Line 693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)

689: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
690: fnd_file.new_line(fnd_file.log,1);
691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)
694: );
695: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),
696: p_v_param_val => l_loan_number
697: );

Line 695: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),

691:
692: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
693: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',g_v_cl_version)
694: );
695: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),
696: p_v_param_val => l_loan_number
697: );
698: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_CHANGE_FIELDS','AWARD_AMOUNT'),40),
699: p_v_param_val => LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,190,6)))

Line 698: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_CHANGE_FIELDS','AWARD_AMOUNT'),40),

694: );
695: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),
696: p_v_param_val => l_loan_number
697: );
698: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_CHANGE_FIELDS','AWARD_AMOUNT'),40),
699: p_v_param_val => LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,190,6)))
700: );
701: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','RECORD_TYPE'),40),
702: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)

Line 701: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','RECORD_TYPE'),40),

697: );
698: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_CHANGE_FIELDS','AWARD_AMOUNT'),40),
699: p_v_param_val => LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,190,6)))
700: );
701: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','RECORD_TYPE'),40),
702: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
703: );
704: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING_TYPE'),40),
705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)

Line 702: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)

698: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_CHANGE_FIELDS','AWARD_AMOUNT'),40),
699: p_v_param_val => LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,190,6)))
700: );
701: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','RECORD_TYPE'),40),
702: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
703: );
704: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING_TYPE'),40),
705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
706: );

Line 704: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING_TYPE'),40),

700: );
701: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','RECORD_TYPE'),40),
702: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
703: );
704: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING_TYPE'),40),
705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
706: );
707: IF g_v_cl_version = 'RELEASE-5' THEN
708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),

Line 705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)

701: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','RECORD_TYPE'),40),
702: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
703: );
704: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING_TYPE'),40),
705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
706: );
707: IF g_v_cl_version = 'RELEASE-5' THEN
708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),
709: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2))))

Line 708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),

704: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING_TYPE'),40),
705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
706: );
707: IF g_v_cl_version = 'RELEASE-5' THEN
708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),
709: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2))))
710: );
711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),
712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))

Line 709: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2))))

705: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
706: );
707: IF g_v_cl_version = 'RELEASE-5' THEN
708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),
709: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2))))
710: );
711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),
712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))
713: );

Line 711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),

707: IF g_v_cl_version = 'RELEASE-5' THEN
708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),
709: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2))))
710: );
711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),
712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))
713: );
714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),
715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))

Line 712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))

708: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','GUARNT_STATUS_CODE'),40),
709: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,992,2))))
710: );
711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),
712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))
713: );
714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),
715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))
716: );

Line 714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),

710: );
711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),
712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))
713: );
714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),
715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))
716: );
717: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CREDIT_OVERRIDE'),40),
718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))

Line 715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))

711: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LEND_STATUS_CODE'),40),
712: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,994,2))))
713: );
714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),
715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))
716: );
717: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CREDIT_OVERRIDE'),40),
718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))
719: );

Line 717: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CREDIT_OVERRIDE'),40),

713: );
714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),
715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))
716: );
717: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CREDIT_OVERRIDE'),40),
718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))
719: );
720: ELSIF g_v_cl_version = 'RELEASE-4' THEN
721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),

Line 718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))

714: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PNOTE_STATUS'),40),
715: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,996,2))))
716: );
717: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CREDIT_OVERRIDE'),40),
718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))
719: );
720: ELSIF g_v_cl_version = 'RELEASE-4' THEN
721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),
722: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)

Line 721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),

717: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CREDIT_OVERRIDE'),40),
718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))
719: );
720: ELSIF g_v_cl_version = 'RELEASE-4' THEN
721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),
722: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
723: );
724: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','APPL_LOAN_PHASE_CODE'),40),
725: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_APP_PHASE_CODES',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,864,4))))

Line 722: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)

718: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,998,2))))
719: );
720: ELSIF g_v_cl_version = 'RELEASE-4' THEN
721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),
722: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
723: );
724: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','APPL_LOAN_PHASE_CODE'),40),
725: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_APP_PHASE_CODES',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,864,4))))
726: );

Line 724: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','APPL_LOAN_PHASE_CODE'),40),

720: ELSIF g_v_cl_version = 'RELEASE-4' THEN
721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),
722: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
723: );
724: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','APPL_LOAN_PHASE_CODE'),40),
725: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_APP_PHASE_CODES',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,864,4))))
726: );
727: END IF;
728: -- new message

Line 725: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_APP_PHASE_CODES',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,864,4))))

721: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CL_REC_STATUS'),40),
722: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL4_REC_ST_CODES',lv_resp_rec_type)
723: );
724: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','APPL_LOAN_PHASE_CODE'),40),
725: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_APP_PHASE_CODES',LTRIM(RTRIM(SUBSTR(Format_1_rec.record_data,864,4))))
726: );
727: END IF;
728: -- new message
729: -- if processing type is not CR then only check for loan existing in system

Line 754: ' Processing Type ' ||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)

750: fnd_file.put_line(fnd_file.log,fnd_message.get);
751: fnd_file.new_line(fnd_file.log,1);
752: log_to_fnd(p_v_module => 'process_1_records',
753: p_v_string => ' Loan number '||l_loan_number||' not found in the system '||
754: ' Processing Type ' ||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',lv_resp_prc_type)
755: );
756: IF lv_resp_prc_type <> 'CR' THEN
757: RAISE e_skip;
758: END IF;

Line 806: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ACK_REC_STATUS','IA'));

802: (lv_loan_type = 'GB' AND NVL(lv_fed_appl_form_code,'*') <> 'G')
803: ) THEN
804: l_resp_record_status := 'IA';
805: gv_debug_str := gv_debug_str || 'PROCESS_1_RECORDS - invalid fed appl form code' ||' ';
806: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_CL_ACK_REC_STATUS','IA'));
807: RAISE e_skip;
808: END IF;
809:
810: OPEN c_igf_sl_lor (cp_v_loan_number => l_loan_number);

Line 1666: title_array(1) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_STAFFORD_LOAN_DEBT'),50,' ');

1662: --
1663: -- Default array values for Lookup Desc
1664: --
1665: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 10' || ' ';
1666: title_array(1) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_STAFFORD_LOAN_DEBT'),50,' ');
1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');
1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');

Line 1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');

1663: -- Default array values for Lookup Desc
1664: --
1665: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 10' || ' ';
1666: title_array(1) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_STAFFORD_LOAN_DEBT'),50,' ');
1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');
1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');

Line 1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');

1664: --
1665: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 10' || ' ';
1666: title_array(1) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_STAFFORD_LOAN_DEBT'),50,' ');
1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');
1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');

Line 1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');

1665: gv_debug_str := gv_debug_str || 'INSERT_INTO_RESP1 - 10' || ' ';
1666: title_array(1) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_STAFFORD_LOAN_DEBT'),50,' ');
1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');
1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');

Line 1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');

1666: title_array(1) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_STAFFORD_LOAN_DEBT'),50,' ');
1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');
1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');

Line 1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');

1667: title_array(2) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FED_SLS_DEBT'),50,' ');
1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');

Line 1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');

1668: title_array(3) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HEAL_DEBT'),50,' ');
1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');

Line 1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');

1669: title_array(4) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','PERKINS_DEBT'),50,' ');
1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');

Line 1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');

1670: title_array(5) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','OTHER_DEBT'),50,' ');
1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');

Line 1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');

1671: title_array(6) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CRDT_UNDER_DIFFT_NAME'),50,' ');
1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');

Line 1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');

1672: title_array(7) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_GROSS_ANNUAL_SAL'),50,' ');
1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');

Line 1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');

1673: title_array(8) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','BORW_OTHER_INCOME'),50,' ');
1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');

Line 1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');

1674: title_array(9) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUDENT_MAJOR'),50,' ');
1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');
1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');

Line 1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');

1675: title_array(10) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','INT_RATE_OPTION'),50,' ');
1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');
1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');
1683: title_array(18) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FILE_ALT_DETAILS'),40,' ');

Line 1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');

1676: title_array(11) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','REPAYMENT_OPT_CODE'),50,' ');
1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');
1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');
1683: title_array(18) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FILE_ALT_DETAILS'),40,' ');
1684: l_title_flag:='Y';

Line 1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');

1677: title_array(12) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_HOUSING_PYMT'),50,' ');
1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');
1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');
1683: title_array(18) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FILE_ALT_DETAILS'),40,' ');
1684: l_title_flag:='Y';
1685:

Line 1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');

1678: title_array(13) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_CRDTCARD_PYMT'),50,' ');
1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');
1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');
1683: title_array(18) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FILE_ALT_DETAILS'),40,' ');
1684: l_title_flag:='Y';
1685:
1686: END IF;

Line 1683: title_array(18) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FILE_ALT_DETAILS'),40,' ');

1679: title_array(14) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_AUTO_PYMT'),50,' ');
1680: title_array(15) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_ED_LOAN_PYMT'),50,' ');
1681: title_array(16) := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','STUD_MTH_OTHER_PYMT'),50,' ');
1682: title_array(17) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_ALT_DETAILS'),80,' ');
1683: title_array(18) := LPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FILE_ALT_DETAILS'),40,' ');
1684: l_title_flag:='Y';
1685:
1686: END IF;
1687:

Line 1931: igf_aw_gen.set_org_id(NULL);

1927:
1928: gv_debug_str := 'MAIN - 1' || ' ';
1929: retcode := 0;
1930: gv_debug_str := gv_debug_str || 'MAIN - 2' || ' ';
1931: igf_aw_gen.set_org_id(NULL);
1932: gv_debug_str := gv_debug_str || 'MAIN - 3' || ' ';
1933:
1934: --
1935: -- Load the Datafile into the Interface tables.

Line 1963: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||loaded_1rec.s_ssn;

1959: fnd_message.set_token('LOAN_NUMBER', l_loan_number);
1960: fnd_file.put_line(fnd_file.log,fnd_message.get);
1961:
1962: gv_debug_str := gv_debug_str || 'MAIN - 9' || ' ';
1963: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||loaded_1rec.s_ssn;
1964: fnd_file.put_line(fnd_file.log, l_log_mesg);
1965: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1966: ||loaded_1rec.s_first_name||' '||loaded_1rec.s_last_name;
1967: fnd_file.put_line(fnd_file.log, l_log_mesg);

Line 1965: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '

1961:
1962: gv_debug_str := gv_debug_str || 'MAIN - 9' || ' ';
1963: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SSN') ||' : '||loaded_1rec.s_ssn;
1964: fnd_file.put_line(fnd_file.log, l_log_mesg);
1965: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1966: ||loaded_1rec.s_first_name||' '||loaded_1rec.s_last_name;
1967: fnd_file.put_line(fnd_file.log, l_log_mesg);
1968: --MN 16-Dec-2004 15:25 Log Borrower Name and SS as well.
1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;

Line 1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;

1965: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_FULL_NAME')||' : '
1966: ||loaded_1rec.s_first_name||' '||loaded_1rec.s_last_name;
1967: fnd_file.put_line(fnd_file.log, l_log_mesg);
1968: --MN 16-Dec-2004 15:25 Log Borrower Name and SS as well.
1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;
1970: fnd_file.put_line(fnd_file.log, l_log_mesg);
1971: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_FULL_NAME')||' : '
1972: ||loaded_1rec.b_first_name||' '||loaded_1rec.b_last_name;
1973: fnd_file.put_line(fnd_file.log, l_log_mesg);

Line 1971: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_FULL_NAME')||' : '

1967: fnd_file.put_line(fnd_file.log, l_log_mesg);
1968: --MN 16-Dec-2004 15:25 Log Borrower Name and SS as well.
1969: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_SSN') ||' : '||loaded_1rec.b_ssn;
1970: fnd_file.put_line(fnd_file.log, l_log_mesg);
1971: l_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','B_FULL_NAME')||' : '
1972: ||loaded_1rec.b_first_name||' '||loaded_1rec.b_last_name;
1973: fnd_file.put_line(fnd_file.log, l_log_mesg);
1974: --
1975: -- Delete records from Edit Report table with type="R" (Rejections) for this Loan Number

Line 2716: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DEFER_REQ_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');

2712: lv_stud_sign_ind := loaded_1rec.stud_sign_ind;
2713:
2714: IF loaded_1rec.fed_appl_form_code IN ('Q','G') THEN
2715: IF(loaded_1rec.defer_req_code IS NOT NULL) THEN
2716: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DEFER_REQ_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2717: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2718: lv_defer_req_code := NULL;
2719: END IF;
2720: IF(loaded_1rec.s_signature_code IS NOT NULL) THEN

Line 2721: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SIGNATURE_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');

2717: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2718: lv_defer_req_code := NULL;
2719: END IF;
2720: IF(loaded_1rec.s_signature_code IS NOT NULL) THEN
2721: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_SIGNATURE_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2722: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2723: lv_s_signature_code := NULL;
2724: END IF;
2725: IF(loaded_1rec.stud_sign_ind IS NOT NULL) THEN

Line 2726: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_ESIGN_IND_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');

2722: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2723: lv_s_signature_code := NULL;
2724: END IF;
2725: IF(loaded_1rec.stud_sign_ind IS NOT NULL) THEN
2726: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','S_ESIGN_IND_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2727: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2728: lv_stud_sign_ind := NULL;
2729: END IF;
2730: END IF; -- loaded_1rec.fed_appl_form_code = 'Q'

Line 2734: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DEFER_REQ_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');

2730: END IF; -- loaded_1rec.fed_appl_form_code = 'Q'
2731:
2732: IF loaded_1rec.fed_appl_form_code = 'M' THEN
2733: IF(loaded_1rec.defer_req_code IS NOT NULL) THEN
2734: lv_log_mesg := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DEFER_REQ_CODE') ||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR','502');
2735: fnd_file.put_line(fnd_file.log, lv_log_mesg);
2736: lv_defer_req_code := NULL;
2737: END IF;
2738: END IF; -- loaded_1rec.fed_appl_form_code = 'M'

Line 3458: p_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)

3454:
3455: BEGIN
3456: gv_debug_str := 'SHOW_DISB_DETAILS-1' ||' ';
3457: IF p_disb_title IS NULL THEN
3458: p_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)

Line 3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)

3455: BEGIN
3456: gv_debug_str := 'SHOW_DISB_DETAILS-1' ||' ';
3457: IF p_disb_title IS NULL THEN
3458: p_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)

Line 3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)

3456: gv_debug_str := 'SHOW_DISB_DETAILS-1' ||' ';
3457: IF p_disb_title IS NULL THEN
3458: p_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)

Line 3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)

3457: IF p_disb_title IS NULL THEN
3458: p_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)

Line 3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)

3458: p_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3466: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);

Line 3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)

3459: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3466: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3467:

Line 3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)

3460: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3466: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3467:
3468: p_disb_under_line := RPAD('-',30,'-')

Line 3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)

3461: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3466: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3467:
3468: p_disb_under_line := RPAD('-',30,'-')
3469: ||RPAD('-',30,'-')

Line 3466: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);

3462: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3463: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3464: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3465: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3466: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3467:
3468: p_disb_under_line := RPAD('-',30,'-')
3469: ||RPAD('-',30,'-')
3470: ||RPAD('-',30,'-')

Line 3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));

3476: ||RPAD('-',35,'-');
3477: END IF;
3478:
3479: fnd_file.put_line(fnd_file.log,' ');
3480: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3481: fnd_file.put_line(fnd_file.log,p_disb_title);
3482: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3483: --To show the Disbursement Details in OFA
3484:

Line 3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));

3497: END LOOP;
3498:
3499: --To show the Disbursement details in File
3500: fnd_file.put_line(fnd_file.log,' ');
3501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3502: fnd_file.put_line(fnd_file.log,p_disb_title);
3503: fnd_file.put_line(fnd_file.log,p_disb_under_line);
3504:
3505: FOR LOC_disb IN cur_new_disbursements('N')

Line 3551: l_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)

3547: counter NUMBER;
3548:
3549: BEGIN
3550: counter := 0;
3551: l_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)

Line 3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)

3548:
3549: BEGIN
3550: counter := 0;
3551: l_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)

Line 3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)

3549: BEGIN
3550: counter := 0;
3551: l_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)

Line 3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)

3550: counter := 0;
3551: l_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)

Line 3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)

3551: l_disb_title := LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NUM'),30)
3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)

Line 3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)

3552: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_DATE'),30)
3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)
3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)

Line 3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)

3553: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_GROSS_AMT'),30)
3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)
3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)
3561: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);

Line 3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)

3554: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_1'),30)
3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)
3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)
3561: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3562:

Line 3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)

3555: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_2'),30)
3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)
3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)
3561: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3562:
3563: l_disb_under_line := RPAD('-',30,'-')

Line 3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)

3556: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_1'),30)
3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)
3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)
3561: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3562:
3563: l_disb_under_line := RPAD('-',30,'-')
3564: ||RPAD('-',30,'-')

Line 3561: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);

3557: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','FEE_PAID_2'),30)
3558: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','DISB_NET_AMT'),30)
3559: ||LPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISB_STATUS'),30)
3560: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','HOLD_REL_IND'),45)
3561: ||LPAD(igf_aw_gen.lookup_desc('IGF_SL_CL_ROSTER_LOGS','DIRECT_TO_BORR_IND'),35);
3562:
3563: l_disb_under_line := RPAD('-',30,'-')
3564: ||RPAD('-',30,'-')
3565: ||RPAD('-',30,'-')

Line 3597: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS',tbh_rec.disb_status)),' '),30)

3593: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_2,0)),30)
3594: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_paid_1,0)),30)
3595: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_paid_2,0)),30)
3596: ||LPAD(TO_CHAR(NVL(tbh_rec.disb_net_amt,0)),30)
3597: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS',tbh_rec.disb_status)),' '),30)
3598: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF',tbh_rec.hold_rel_ind)),' '),45)
3599: ||LPAD(NVL(tbh_rec.direct_to_borr_flag,'N'),30);
3600:
3601: loc_disb_array(counter) := LPAD(TO_CHAR(loc_disb.clrp8_id),30)

Line 3598: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF',tbh_rec.hold_rel_ind)),' '),45)

3594: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_paid_1,0)),30)
3595: ||LPAD(TO_CHAR(NVL(tbh_rec.fee_paid_2,0)),30)
3596: ||LPAD(TO_CHAR(NVL(tbh_rec.disb_net_amt,0)),30)
3597: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS',tbh_rec.disb_status)),' '),30)
3598: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF',tbh_rec.hold_rel_ind)),' '),45)
3599: ||LPAD(NVL(tbh_rec.direct_to_borr_flag,'N'),30);
3600:
3601: loc_disb_array(counter) := LPAD(TO_CHAR(loc_disb.clrp8_id),30)
3602: ||LPAD(fnd_date.date_to_displaydate(loc_disb.disb_date),30)

Line 3609: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS',loc_disb.disb_status)),' '),30)

3605: ||LPAD(TO_CHAR(NVL(loc_disb.guarantee_fee,0)),30)
3606: ||LPAD(TO_CHAR(NVL(loc_disb.orig_fee_paid,0)),30)
3607: ||LPAD(TO_CHAR(NVL(loc_disb.guarnt_fee_paid,0)),30)
3608: ||LPAD(TO_CHAR(NVL(loc_disb.net_disb_amt,0)),30)
3609: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS',loc_disb.disb_status)),' '),30)
3610: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF', loc_disb.disb_hold_rel_ind)),' '),45)
3611: ||LPAD(NVL(loc_disb.direct_to_borr_flag,'N'),30);
3612:
3613: END IF;

Line 3610: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF', loc_disb.disb_hold_rel_ind)),' '),45)

3606: ||LPAD(TO_CHAR(NVL(loc_disb.orig_fee_paid,0)),30)
3607: ||LPAD(TO_CHAR(NVL(loc_disb.guarnt_fee_paid,0)),30)
3608: ||LPAD(TO_CHAR(NVL(loc_disb.net_disb_amt,0)),30)
3609: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DISB_STATUS',loc_disb.disb_status)),' '),30)
3610: ||LPAD(NVL(TO_CHAR(IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_HOLD_REL_IND_TF', loc_disb.disb_hold_rel_ind)),' '),45)
3611: ||LPAD(NVL(loc_disb.direct_to_borr_flag,'N'),30);
3612:
3613: END IF;
3614: END LOOP;

Line 3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));

3614: END LOOP;
3615: END LOOP;
3616: -- Display the information now
3617: fnd_file.put_line(fnd_file.log,' ');
3618: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','OFA_DISB_DETAILS'));
3619: fnd_file.put_line(fnd_file.log,l_disb_title);
3620: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3621:
3622: FOR i IN 1..counter LOOP

Line 3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));

3623: fnd_file.put_line(fnd_file.log,awd_disb_array(i));
3624: END LOOP;
3625:
3626: fnd_file.put_line(fnd_file.log,' ');
3627: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_GEN','LOC_DISB_DETAILS'));
3628: fnd_file.put_line(fnd_file.log,l_disb_title);
3629: fnd_file.put_line(fnd_file.log,l_disb_under_line);
3630:
3631: FOR i IN 1..counter LOOP

Line 5829: p_value => l_rec_resp_r1.cl_loan_type||' - ' || igf_aw_gen.lookup_desc('IGF_SL_CL_LOAN_TYPE',l_rec_resp_r1.cl_loan_type),

5825: );
5826:
5827: wf_event.addparametertolist(
5828: p_name => 'ATT_13',
5829: p_value => l_rec_resp_r1.cl_loan_type||' - ' || igf_aw_gen.lookup_desc('IGF_SL_CL_LOAN_TYPE',l_rec_resp_r1.cl_loan_type),
5830: p_parameterlist => l_wf_parameter_list_t
5831: );
5832:
5833: wf_event.addparametertolist(

Line 5841: p_value => l_rec_resp_r1.defer_req_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_DEF_REQ_CODE',l_rec_resp_r1.defer_req_code),

5837: );
5838:
5839: wf_event.addparametertolist(
5840: p_name => 'ATT_15',
5841: p_value => l_rec_resp_r1.defer_req_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_DEF_REQ_CODE',l_rec_resp_r1.defer_req_code),
5842: p_parameterlist => l_wf_parameter_list_t
5843: );
5844:
5845: wf_event.addparametertolist(

Line 5847: p_value => l_rec_resp_r1.borw_interest_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_INT_IND',l_rec_resp_r1.borw_interest_ind),

5843: );
5844:
5845: wf_event.addparametertolist(
5846: p_name => 'ATT_16',
5847: p_value => l_rec_resp_r1.borw_interest_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_INT_IND',l_rec_resp_r1.borw_interest_ind),
5848: p_parameterlist => l_wf_parameter_list_t
5849: );
5850:
5851: wf_event.addparametertolist(

Line 5853: p_value => l_rec_resp_r1.eft_auth_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_EFT_AUTH_CODE',l_rec_resp_r1.eft_auth_code),

5849: );
5850:
5851: wf_event.addparametertolist(
5852: p_name => 'ATT_17',
5853: p_value => l_rec_resp_r1.eft_auth_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_EFT_AUTH_CODE',l_rec_resp_r1.eft_auth_code),
5854: p_parameterlist => l_wf_parameter_list_t
5855: );
5856:
5857: wf_event.addparametertolist(

Line 5859: p_value => l_rec_resp_r1.b_signature_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_SIGN_CODE',l_rec_resp_r1.b_signature_code),

5855: );
5856:
5857: wf_event.addparametertolist(
5858: p_name => 'ATT_18',
5859: p_value => l_rec_resp_r1.b_signature_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_SIGN_CODE',l_rec_resp_r1.b_signature_code),
5860: p_parameterlist => l_wf_parameter_list_t
5861: );
5862:
5863: wf_event.addparametertolist(

Line 5885: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),

5881: );
5882:
5883: wf_event.addparametertolist(
5884: p_name => 'ATT_22',
5885: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),
5886: p_parameterlist => l_wf_parameter_list_t
5887: );
5888:
5889: wf_event.addparametertolist(

Line 5891: p_value => l_rec_resp_r1.b_state_of_legal_res||' - ' ||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),

5887: );
5888:
5889: wf_event.addparametertolist(
5890: p_name => 'ATT_23',
5891: p_value => l_rec_resp_r1.b_state_of_legal_res||' - ' ||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),
5892: p_parameterlist => l_wf_parameter_list_t
5893: );
5894: wf_event.addparametertolist(
5895: p_name => 'ATT_24',

Line 5902: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),

5898: );
5899:
5900: wf_event.addparametertolist(
5901: p_name => 'ATT_25',
5902: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),
5903: p_parameterlist => l_wf_parameter_list_t
5904: );
5905:
5906: wf_event.addparametertolist(

Line 5908: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),

5904: );
5905:
5906: wf_event.addparametertolist(
5907: p_name => 'ATT_26',
5908: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),
5909: p_parameterlist => l_wf_parameter_list_t
5910: );
5911:
5912: wf_event.addparametertolist(

Line 5914: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),

5910: );
5911:
5912: wf_event.addparametertolist(
5913: p_name => 'ATT_27',
5914: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),
5915: p_parameterlist => l_wf_parameter_list_t
5916: );
5917:
5918: wf_event.addparametertolist(

Line 5950: p_value => l_rec_resp_r1.s_citizenship_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),

5946: );
5947:
5948: wf_event.addparametertolist(
5949: p_name => 'ATT_33',
5950: p_value => l_rec_resp_r1.s_citizenship_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),
5951: p_parameterlist => l_wf_parameter_list_t
5952: );
5953:
5954: wf_event.addparametertolist(

Line 5956: p_value => l_rec_resp_r1.s_default_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),

5952: );
5953:
5954: wf_event.addparametertolist(
5955: p_name => 'ATT_34',
5956: p_value => l_rec_resp_r1.s_default_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),
5957: p_parameterlist => l_wf_parameter_list_t
5958: );
5959:
5960: wf_event.addparametertolist(

Line 5962: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),

5958: );
5959:
5960: wf_event.addparametertolist(
5961: p_name => 'ATT_35',
5962: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),
5963: p_parameterlist => l_wf_parameter_list_t
5964: );
5965:
5966: wf_event.addparametertolist(

Line 5985: p_value => l_rec_resp_r1.borr_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.borr_sign_ind),

5981: p_parameterlist => l_wf_parameter_list_t
5982: );
5983: wf_event.addparametertolist(
5984: p_name => 'ATT_39',
5985: p_value => l_rec_resp_r1.borr_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.borr_sign_ind),
5986: p_parameterlist => l_wf_parameter_list_t
5987: );
5988:
5989: wf_event.addparametertolist(

Line 5991: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,

5987: );
5988:
5989: wf_event.addparametertolist(
5990: p_name => 'ATT_40',
5991: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,
5992: p_parameterlist => l_wf_parameter_list_t
5993: );
5994:
5995: wf_event.addparametertolist(

Line 6009: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),

6005: );
6006: -- Bug # 4141704
6007: wf_event.addparametertolist(
6008: p_name => 'ATT_43',
6009: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),
6010: p_parameterlist => l_wf_parameter_list_t
6011: );
6012:
6013: wf_event.addparametertolist(

Line 6015: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),

6011: );
6012:
6013: wf_event.addparametertolist(
6014: p_name => 'ATT_44',
6015: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),
6016: p_parameterlist => l_wf_parameter_list_t
6017: );
6018:
6019: wf_event.addparametertolist(

Line 6027: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),

6023: );
6024:
6025: wf_event.addparametertolist(
6026: p_name => 'ATT_46',
6027: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),
6028: p_parameterlist => l_wf_parameter_list_t
6029: );
6030:
6031: wf_event.addparametertolist(

Line 6033: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),

6029: );
6030:
6031: wf_event.addparametertolist(
6032: p_name => 'ATT_47',
6033: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),
6034: p_parameterlist => l_wf_parameter_list_t
6035: );
6036:
6037: wf_event.addparametertolist(

Line 6044: p_value => l_rec_resp_r1.stud_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.stud_sign_ind),

6040: p_parameterlist => l_wf_parameter_list_t
6041: );
6042: wf_event.addparametertolist(
6043: p_name => 'ATT_49',
6044: p_value => l_rec_resp_r1.stud_sign_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_ELE_SIGN_IND',l_rec_resp_r1.stud_sign_ind),
6045: p_parameterlist => l_wf_parameter_list_t
6046: );
6047:
6048: wf_event.addparametertolist(

Line 6080: p_value => l_rec_resp_r1.prc_type_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',l_rec_resp_r1.prc_type_code),

6076: );
6077:
6078: wf_event.addparametertolist(
6079: p_name => 'ATT_55',
6080: p_value => l_rec_resp_r1.prc_type_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PRC_TYPE_CODE',l_rec_resp_r1.prc_type_code),
6081: p_parameterlist => l_wf_parameter_list_t
6082: );
6083: -- No mapping field available for ATT_56. Discussed with TD writer
6084: -- Td writer agreed upon to skip this ATT_56

Line 6088: p_value => l_rec_resp_r1.guarnt_status_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',l_rec_resp_r1.guarnt_status_code),

6084: -- Td writer agreed upon to skip this ATT_56
6085:
6086: wf_event.addparametertolist(
6087: p_name => 'ATT_57',
6088: p_value => l_rec_resp_r1.guarnt_status_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_GUARNT_STATUS',l_rec_resp_r1.guarnt_status_code),
6089: p_parameterlist => l_wf_parameter_list_t
6090: );
6091:
6092: wf_event.addparametertolist(

Line 6094: p_value => l_rec_resp_r1.lender_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',l_rec_resp_r1.lender_status_code),

6090: );
6091:
6092: wf_event.addparametertolist(
6093: p_name => 'ATT_58',
6094: p_value => l_rec_resp_r1.lender_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_LEND_STATUS',l_rec_resp_r1.lender_status_code),
6095: p_parameterlist => l_wf_parameter_list_t
6096: );
6097:
6098: wf_event.addparametertolist(

Line 6100: p_value => l_rec_resp_r1.pnote_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',l_rec_resp_r1.pnote_status_code),

6096: );
6097:
6098: wf_event.addparametertolist(
6099: p_name => 'ATT_59',
6100: p_value => l_rec_resp_r1.pnote_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_STATUS',l_rec_resp_r1.pnote_status_code),
6101: p_parameterlist => l_wf_parameter_list_t
6102: );
6103:
6104: wf_event.addparametertolist(

Line 6106: p_value => l_rec_resp_r1.credit_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',l_rec_resp_r1.credit_status_code),

6102: );
6103:
6104: wf_event.addparametertolist(
6105: p_name => 'ATT_60',
6106: p_value => l_rec_resp_r1.credit_status_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CREDIT_OVERRIDE',l_rec_resp_r1.credit_status_code),
6107: p_parameterlist => l_wf_parameter_list_t
6108: );
6109:
6110: wf_event.addparametertolist(

Line 6136: p_value => l_rec_resp_r1.act_serial_loan_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_SERIAL_LOAN_CODE',l_rec_resp_r1.act_serial_loan_code),

6132: );
6133:
6134: wf_event.addparametertolist(
6135: p_name => 'ATT_65',
6136: p_value => l_rec_resp_r1.act_serial_loan_code||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_SERIAL_LOAN_CODE',l_rec_resp_r1.act_serial_loan_code),
6137: p_parameterlist => l_wf_parameter_list_t
6138: );
6139:
6140: wf_event.addparametertolist(

Line 6148: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),

6144: );
6145:
6146: wf_event.addparametertolist(
6147: p_name => 'ATT_67',
6148: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),
6149: p_parameterlist => l_wf_parameter_list_t
6150: );
6151:
6152: wf_event.addparametertolist(

Line 6154: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),

6150: );
6151:
6152: wf_event.addparametertolist(
6153: p_name => 'ATT_68',
6154: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),
6155: p_parameterlist => l_wf_parameter_list_t
6156: );
6157:
6158: wf_event.addparametertolist(

Line 6160: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_rel_created),

6156: );
6157:
6158: wf_event.addparametertolist(
6159: p_name => 'ATT_69',
6160: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_rel_created),
6161: p_parameterlist => l_wf_parameter_list_t
6162: );
6163:
6164: END IF;

Line 6170: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),

6166: IF g_v_cl_version = 'RELEASE-4' THEN
6167:
6168: wf_event.addparametertolist(
6169: p_name => 'ATT_21',
6170: p_value => l_rec_resp_r1.b_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', l_rec_resp_r1.b_citizenship_status),
6171: p_parameterlist => l_wf_parameter_list_t
6172: );
6173:
6174: wf_event.addparametertolist(

Line 6176: p_value => l_rec_resp_r1.b_state_of_legal_res||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),

6172: );
6173:
6174: wf_event.addparametertolist(
6175: p_name => 'ATT_22',
6176: p_value => l_rec_resp_r1.b_state_of_legal_res||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_state_of_legal_res),
6177: p_parameterlist => l_wf_parameter_list_t
6178: );
6179: wf_event.addparametertolist(
6180: p_name => 'ATT_23',

Line 6187: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),

6183: );
6184:
6185: wf_event.addparametertolist(
6186: p_name => 'ATT_24',
6187: p_value => l_rec_resp_r1.b_default_status||' - ' ||igf_aw_gen.lookup_desc('IGF_SL_P_DEFAULT_STATUS',l_rec_resp_r1.b_default_status),
6188: p_parameterlist => l_wf_parameter_list_t
6189: );
6190:
6191: wf_event.addparametertolist(

Line 6193: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),

6189: );
6190:
6191: wf_event.addparametertolist(
6192: p_name => 'ATT_25',
6193: p_value => l_rec_resp_r1.b_outstd_loan_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_outstd_loan_code),
6194: p_parameterlist => l_wf_parameter_list_t
6195: );
6196:
6197: wf_event.addparametertolist(

Line 6199: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),

6195: );
6196:
6197: wf_event.addparametertolist(
6198: p_name => 'ATT_26',
6199: p_value => l_rec_resp_r1.b_indicator_code||' - '||igf_aw_gen.lookup_desc('IGF_AP_YES_NO',l_rec_resp_r1.b_indicator_code),
6200: p_parameterlist => l_wf_parameter_list_t
6201: );
6202:
6203: wf_event.addparametertolist(

Line 6235: p_value => l_rec_resp_r1.s_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),

6231: );
6232:
6233: wf_event.addparametertolist(
6234: p_name => 'ATT_32',
6235: p_value => l_rec_resp_r1.s_citizenship_status||' - '||igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT',l_rec_resp_r1.s_citizenship_status),
6236: p_parameterlist => l_wf_parameter_list_t
6237: );
6238:
6239: wf_event.addparametertolist(

Line 6241: p_value => l_rec_resp_r1.s_default_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),

6237: );
6238:
6239: wf_event.addparametertolist(
6240: p_name => 'ATT_33',
6241: p_value => l_rec_resp_r1.s_default_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_S_DEFAULT_STATUS',l_rec_resp_r1.s_default_code),
6242: p_parameterlist => l_wf_parameter_list_t
6243: );
6244:
6245: wf_event.addparametertolist(

Line 6247: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),

6243: );
6244:
6245: wf_event.addparametertolist(
6246: p_name => 'ATT_34',
6247: p_value => l_rec_resp_r1.s_signature_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_STUD_SIGN_CODE',l_rec_resp_r1.s_signature_code),
6248: p_parameterlist => l_wf_parameter_list_t
6249: );
6250:
6251: wf_event.addparametertolist(

Line 6271: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,

6267: );
6268:
6269: wf_event.addparametertolist(
6270: p_name => 'ATT_38',
6271: p_value => l_rec_resp_r1.alt_appl_ver_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE',l_rec_resp_r1.alt_appl_ver_code) ,
6272: p_parameterlist => l_wf_parameter_list_t
6273: );
6274:
6275: wf_event.addparametertolist(

Line 6289: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),

6285: );
6286: -- Bug # 4141704
6287: wf_event.addparametertolist(
6288: p_name => 'ATT_41',
6289: p_value => l_rec_resp_r1.fed_appl_form_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_APP_FORM_CODE',l_rec_resp_r1.fed_appl_form_code),
6290: p_parameterlist => l_wf_parameter_list_t
6291: );
6292:
6293: wf_event.addparametertolist(

Line 6295: p_value => l_rec_resp_r1.mpn_confirm_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_MPN_CONF_IND',l_rec_resp_r1.mpn_confirm_ind),

6291: );
6292:
6293: wf_event.addparametertolist(
6294: p_name => 'ATT_42',
6295: p_value => l_rec_resp_r1.mpn_confirm_ind||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_MPN_CONF_IND',l_rec_resp_r1.mpn_confirm_ind),
6296: p_parameterlist => l_wf_parameter_list_t
6297: );
6298:
6299:

Line 6302: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),

6298:
6299:
6300: wf_event.addparametertolist(
6301: p_name => 'ATT_43',
6302: p_value => l_rec_resp_r1.b_license_state||' - '||igf_aw_gen.lookup_desc('IGF_AP_STATE_CODES',l_rec_resp_r1.b_license_state),
6303: p_parameterlist => l_wf_parameter_list_t
6304: );
6305:
6306: wf_event.addparametertolist(

Line 6314: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),

6310: );
6311:
6312: wf_event.addparametertolist(
6313: p_name => 'ATT_45',
6314: p_value => l_rec_resp_r1.b_ref_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_CL_BORW_REF_INF',l_rec_resp_r1.b_ref_code),
6315: p_parameterlist => l_wf_parameter_list_t
6316: );
6317:
6318: wf_event.addparametertolist(

Line 6320: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),

6316: );
6317:
6318: wf_event.addparametertolist(
6319: p_name => 'ATT_46',
6320: p_value => l_rec_resp_r1.pnote_delivery_code||' - '||igf_aw_gen.lookup_desc('IGF_SL_PNOTE_DELIVERY',l_rec_resp_r1.pnote_delivery_code),
6321: p_parameterlist => l_wf_parameter_list_t
6322: );
6323:
6324: wf_event.addparametertolist(

Line 6332: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),

6328: );
6329:
6330: wf_event.addparametertolist(
6331: p_name => 'ATT_48',
6332: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_borrow_created),
6333: p_parameterlist => l_wf_parameter_list_t
6334: );
6335:
6336: wf_event.addparametertolist(

Line 6338: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),

6334: );
6335:
6336: wf_event.addparametertolist(
6337: p_name => 'ATT_49',
6338: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_student_created),
6339: p_parameterlist => l_wf_parameter_list_t
6340: );
6341:
6342: wf_event.addparametertolist(

Line 6344: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_rel_created),

6340: );
6341:
6342: wf_event.addparametertolist(
6343: p_name => 'ATT_50',
6344: p_value => igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_c_rel_created),
6345: p_parameterlist => l_wf_parameter_list_t
6346: );
6347:
6348: END IF;

Line 6515: p_value => igf_aw_gen.lookup_desc('IGF_AW_FED_FUND ',p_v_loan_type),

6511: );
6512:
6513: wf_event.addparametertolist(
6514: p_name => 'ATT_8',
6515: p_value => igf_aw_gen.lookup_desc('IGF_AW_FED_FUND ',p_v_loan_type),
6516: p_parameterlist => l_wf_parameter_list_t
6517: );
6518:
6519: wf_event.addparametertolist(

Line 6795: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));

6791: '|p_v_loan_number = ' || p_v_loan_number
6792: );
6793: l_n_clrp1_id := p_n_clrp1_id;
6794: fnd_file.new_line(fnd_file.log,2);
6795: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
6796:
6797: FOR rec_c_sl_clchsn_dtls IN c_sl_clchsn_dtls (cp_v_loan_number => p_v_loan_number) -- sl_cl_chsn_dtls rec processing
6798: LOOP
6799: -- Missing c_sl_clchrs_dtls means that the change is accepted by the processor

Line 6820: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_1_CODE'),40),

6816: rec_c_sl_clchrs_dtls.error_message_3_code IS NOT NULL OR
6817: rec_c_sl_clchrs_dtls.error_message_4_code IS NOT NULL OR
6818: rec_c_sl_clchrs_dtls.error_message_5_code IS NOT NULL ) THEN
6819: l_v_response_status_code := 'R';
6820: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_1_CODE'),40),
6821: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_1_code)
6822: );
6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),
6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)

Line 6821: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_1_code)

6817: rec_c_sl_clchrs_dtls.error_message_4_code IS NOT NULL OR
6818: rec_c_sl_clchrs_dtls.error_message_5_code IS NOT NULL ) THEN
6819: l_v_response_status_code := 'R';
6820: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_1_CODE'),40),
6821: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_1_code)
6822: );
6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),
6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)
6825: );

Line 6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),

6819: l_v_response_status_code := 'R';
6820: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_1_CODE'),40),
6821: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_1_code)
6822: );
6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),
6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)
6825: );
6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),
6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)

Line 6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)

6820: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_1_CODE'),40),
6821: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_1_code)
6822: );
6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),
6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)
6825: );
6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),
6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)
6828: );

Line 6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),

6822: );
6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),
6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)
6825: );
6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),
6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)
6828: );
6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),
6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)

Line 6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)

6823: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_2_CODE'),40),
6824: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_2_code)
6825: );
6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),
6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)
6828: );
6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),
6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)
6831: );

Line 6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),

6825: );
6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),
6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)
6828: );
6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),
6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)
6831: );
6832: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_5_CODE'),40),
6833: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_5_code)

Line 6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)

6826: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_3_CODE'),40),
6827: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_3_code)
6828: );
6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),
6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)
6831: );
6832: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_5_CODE'),40),
6833: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_5_code)
6834: );

Line 6832: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_5_CODE'),40),

6828: );
6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),
6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)
6831: );
6832: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_5_CODE'),40),
6833: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_5_code)
6834: );
6835: END IF;
6836: END IF; -- End Check for errors if any

Line 6833: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_5_code)

6829: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_4_CODE'),40),
6830: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_4_code)
6831: );
6832: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','ERROR_MSG_5_CODE'),40),
6833: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_ERROR',rec_c_sl_clchrs_dtls.error_message_5_code)
6834: );
6835: END IF;
6836: END IF; -- End Check for errors if any
6837: CLOSE c_sl_clchrs_dtls;

Line 6839: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CHG_RESP_STATUS'),40),

6835: END IF;
6836: END IF; -- End Check for errors if any
6837: CLOSE c_sl_clchrs_dtls;
6838:
6839: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CHG_RESP_STATUS'),40),
6840: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_CHG_RESP_STATUS',l_v_response_status_code)
6841: );
6842: log_to_fnd(p_v_module => 'process_change_records',
6843: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id

Line 6840: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_CHG_RESP_STATUS',l_v_response_status_code)

6836: END IF; -- End Check for errors if any
6837: CLOSE c_sl_clchrs_dtls;
6838:
6839: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CHG_RESP_STATUS'),40),
6840: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_CHG_RESP_STATUS',l_v_response_status_code)
6841: );
6842: log_to_fnd(p_v_module => 'process_change_records',
6843: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id
6844: );

Line 6891: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40));

6887:
6888: END LOOP; -- END sl_cl_chsn_dtls rec processing
6889:
6890: fnd_file.new_line(fnd_file.log,2);
6891: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RECORDS_PROCESSED'),40));
6892:
6893: END process_change_records;
6894:
6895: PROCEDURE log_parameters ( p_v_param_typ IN VARCHAR2,