APPS.IGF_SL_DL_CHG_ACK dependencies on IGF_AW_GEN

Line 218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));

214: -- Check if the entire batch was rejected for any reason or not
215: IF LTRIM(RTRIM(l_rec_batch_rej_code)) IS NOT NULL THEN
216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
217: fnd_message.set_token('BATCH', l_rec_batch_id);
218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
219: -- Message : Batch #BATCH was rejected. Reason : #REASON.
220: igs_ge_msg_stack.add;
221: RAISE FILE_NOT_LOADED;
222: END IF;

Line 403: igf_aw_gen.set_org_id(p_org_id);

399: l_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
400:
401: BEGIN
402:
403: igf_aw_gen.set_org_id(p_org_id);
404:
405: -- Load the Data into the Batch and Response Tables
406: dl_load_data(l_dbth_id);
407:

Line 480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));

476: -- Show "Changes for Loan ID #LOAN_NUMBER were #LOAN_CHG_STATUS" on the Log File.
477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');
478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
479: fnd_message.set_token('LOAN_STATUS',
480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));
481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
482:
483:
484: /************* Show Reject Details on the LOG File ***************/

Line 522: igf_aw_gen.lookup_desc('IGF_SL_DL_CHG_REJ_CODES', lrec.loan_ident_err_code));

518: FOR lrec IN cur_loan_err_resp(l_dbth_id, resp_rec.loan_number) LOOP
519:
520: -- Display on the LOG File.
521: fnd_file.put_line(FND_FILE.LOG,
522: igf_aw_gen.lookup_desc('IGF_SL_DL_CHG_REJ_CODES', lrec.loan_ident_err_code));
523:
524: -- Insert Loan Error Code details into the edit_report table.
525: igf_sl_edit.insert_edit(resp_rec.loan_number,
526: 'H', -- EDITS from Change Response

Line 540: l_sub_col_heading := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FIELDS'),50)

536: IF resp_rec.reject_count > 0 THEN
537:
538: -- Show a Sub-heading on the Log File, to show the reject descriptions.
539: IF l_sub_col_heading IS NULL THEN
540: l_sub_col_heading := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FIELDS'),50)
541: ||' '
542: ||RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','VALUES'),50)
543: ||' '
544: ||igf_aw_gen.lookup_desc('IGF_SL_GEN','REJ_REASON');

Line 542: ||RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','VALUES'),50)

538: -- Show a Sub-heading on the Log File, to show the reject descriptions.
539: IF l_sub_col_heading IS NULL THEN
540: l_sub_col_heading := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FIELDS'),50)
541: ||' '
542: ||RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','VALUES'),50)
543: ||' '
544: ||igf_aw_gen.lookup_desc('IGF_SL_GEN','REJ_REASON');
545: END IF;
546: fnd_file.put_line(FND_FILE.LOG, l_sub_col_heading);

Line 544: ||igf_aw_gen.lookup_desc('IGF_SL_GEN','REJ_REASON');

540: l_sub_col_heading := RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','FIELDS'),50)
541: ||' '
542: ||RPAD(igf_aw_gen.lookup_desc('IGF_SL_GEN','VALUES'),50)
543: ||' '
544: ||igf_aw_gen.lookup_desc('IGF_SL_GEN','REJ_REASON');
545: END IF;
546: fnd_file.put_line(FND_FILE.LOG, l_sub_col_heading);
547: fnd_file.put_line(FND_FILE.LOG, RPAD('-',50,'-')||' '||RPAD('-',50,'-')||' '
548: ||RPAD('-',100,'-') );

Line 555: ||igf_aw_gen.lookup_desc('IGF_SL_DL_CHG_REJ_CODES',rrec.reject_code));

551:
552: -- Display on the LOG File.
553: fnd_file.put_line(FND_FILE.LOG, RPAD(rrec.fld_desc,50) ||' '
554: ||RPAD(rrec.new_value,50)||' '
555: ||igf_aw_gen.lookup_desc('IGF_SL_DL_CHG_REJ_CODES',rrec.reject_code));
556:
557: -- Insert Reject details into the edit_report table.
558: igf_sl_edit.insert_edit(resp_rec.loan_number,
559: 'H', -- EDITS from Change Response