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_UPLOAD_XML dependencies on FND_FILE

Line 226: fnd_file.put_line(fnd_file.log,'File Path : '||p_file_path);

222: -- Step 1. Print the log parameters
223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
224: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','file path is: ' || p_file_path);
225: END IF;
226: fnd_file.put_line(fnd_file.log,'File Path : '||p_file_path);
227:
228: -- Step 2. Get the XML file from the file path and store it in COD_DOC_DTLS table.
229: -- Seperate directory and filename
230: l_file_path := p_file_path;

Line 364: fnd_file.put_line(fnd_file.log, fnd_message.get);

360: END IF;
361:
362: IF l_start_pos = 0 THEN
363: fnd_message.set_name('IGF','IGF_SL_COD_IB_NO_XML_DOC_ID');
364: fnd_file.put_line(fnd_file.log, fnd_message.get);
365: RETURN;
366: ELSE
367: l_doc_id := SUBSTR(MYCLOB_TEXT,(l_start_pos+12),30);
368: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 442: fnd_file.put_line(fnd_file.log,fnd_message.get);

438: );
439:
440: fnd_message.set_name('IGF','IGF_SL_COD_INBOUND_EVENT');
441: fnd_message.set_token('EVENT_KEY_VALUE',l_event_key);
442: fnd_file.put_line(fnd_file.log,fnd_message.get);
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: ROLLBACK;

Line 449: fnd_file.put_line(fnd_file.log, SQLERRM);

445: WHEN OTHERS THEN
446: ROLLBACK;
447: retcode := 2;
448: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
449: fnd_file.put_line(fnd_file.log, SQLERRM);
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','sqlerrm ' || SQLERRM);
452: END IF;
453: igs_ge_msg_stack.conc_exception_hndl;

Line 575: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS',lv_lookup_code));

571: OPEN get_records(p_id, p_level);
572: FETCH get_records INTO rec_get_records;
573: IF get_records%FOUND THEN
574: lv_lookup_code := p_level || '_EDIT_RSLTS';
575: fnd_file.put_line(fnd_file.log, igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS',lv_lookup_code));
576: END IF;
577: CLOSE get_records;
578:
579: FOR l_record IN get_records(p_id, p_level)

Line 581: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD')|| ':'||l_record.EDIT_CODE);

577: CLOSE get_records;
578:
579: FOR l_record IN get_records(p_id, p_level)
580: LOOP
581: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD')|| ':'||l_record.EDIT_CODE);
582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);
583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);

Line 582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);

578:
579: FOR l_record IN get_records(p_id, p_level)
580: LOOP
581: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD')|| ':'||l_record.EDIT_CODE);
582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);
583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);

Line 583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);

579: FOR l_record IN get_records(p_id, p_level)
580: LOOP
581: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD')|| ':'||l_record.EDIT_CODE);
582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);
583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);
587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);

Line 584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);

580: LOOP
581: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD')|| ':'||l_record.EDIT_CODE);
582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);
583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);
587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);
588: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_FIX')|| ':'||l_record.EDIT_FIX_TXT);

Line 585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);

581: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD')|| ':'||l_record.EDIT_CODE);
582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);
583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);
587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);
588: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_FIX')|| ':'||l_record.EDIT_FIX_TXT);
589: END LOOP;

Line 586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);

582: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_CD_TYP')|| ':'||l_record.EDIT_CODE_TYPE);
583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);
587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);
588: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_FIX')|| ':'||l_record.EDIT_FIX_TXT);
589: END LOOP;
590:

Line 587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);

583: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_FLD')|| ':'||l_record.RESP_ERR_FIELD);
584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);
587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);
588: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_FIX')|| ':'||l_record.EDIT_FIX_TXT);
589: END LOOP;
590:
591: EXCEPTION

Line 588: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_FIX')|| ':'||l_record.EDIT_FIX_TXT);

584: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ERR_VAL')|| ':'||l_record.RESP_ERR_VALUE);
585: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','REPT_VAL')|| ':'||l_record.REPORTED_VALUE);
586: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_MSG')|| ':'||l_record.EDIT_MESSAGE_TXT);
587: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_COND')|| ':'||l_record.EDIT_CONDITION_TXT);
588: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','EDIT_FIX')|| ':'||l_record.EDIT_FIX_TXT);
589: END LOOP;
590:
591: EXCEPTION
592: WHEN OTHERS THEN

Line 689: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DL_NUM')||':' ||l_dl_resp.LOAN_NUMBER_TXT);

685: BEGIN
686:
687: FOR l_dl_resp IN get_dl_resp(p_st_id)
688: LOOP
689: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DL_NUM')||':' ||l_dl_resp.LOAN_NUMBER_TXT);
690: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_resp.RESP_CODE );
691:
692: l_dl_rec := NULL;
693: OPEN get_dl_rec(l_dl_resp.LOAN_NUMBER_TXT,l_dl_resp.FIN_AWD_YR);

Line 690: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_resp.RESP_CODE );

686:
687: FOR l_dl_resp IN get_dl_resp(p_st_id)
688: LOOP
689: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DL_NUM')||':' ||l_dl_resp.LOAN_NUMBER_TXT);
690: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_resp.RESP_CODE );
691:
692: l_dl_rec := NULL;
693: OPEN get_dl_rec(l_dl_resp.LOAN_NUMBER_TXT,l_dl_resp.FIN_AWD_YR);
694: FETCH get_dl_rec INTO l_dl_rec;

Line 699: fnd_file.put_line(fnd_file.log,fnd_message.get);

695: CLOSE get_dl_rec;
696:
697: IF l_dl_rec.loan_id IS NULL THEN
698: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
699: fnd_file.put_line(fnd_file.log,fnd_message.get);
700:
701: -- update the status to 'N' - Processed, Not found in the System
702: UPDATE IGF_SL_DL_RESP_DTLS
703: SET STATUS_CODE = 'N'

Line 758: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DL_AMT')||':' ||l_dl_rec.LOAN_AMT_ACCEPTED );

754: END IF;
755:
756: -- compare the values in the resp record with the system record
757: IF l_dl_resp.AWARD_AMT <> l_dl_rec.LOAN_AMT_ACCEPTED THEN
758: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DL_AMT')||':' ||l_dl_rec.LOAN_AMT_ACCEPTED );
759: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DL_AMT')||':' ||l_dl_resp.AWARD_AMT );
760: END IF;
761:
762: -- 4582675. If the response document is of type RS, then update all the fields

Line 759: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DL_AMT')||':' ||l_dl_resp.AWARD_AMT );

755:
756: -- compare the values in the resp record with the system record
757: IF l_dl_resp.AWARD_AMT <> l_dl_rec.LOAN_AMT_ACCEPTED THEN
758: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DL_AMT')||':' ||l_dl_rec.LOAN_AMT_ACCEPTED );
759: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DL_AMT')||':' ||l_dl_resp.AWARD_AMT );
760: END IF;
761:
762: -- 4582675. If the response document is of type RS, then update all the fields
763: -- that would get updated if it had been CO, PN, PS or BN.

Line 767: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','END_AMT')||':' ||l_dl_resp.ENDORSER_AMT);

763: -- that would get updated if it had been CO, PN, PS or BN.
764:
765: IF p_type = 'CO' OR p_type = 'RS' THEN
766:
767: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','END_AMT')||':' ||l_dl_resp.ENDORSER_AMT);
768: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_ST')||':' ||l_dl_resp.CRDT_DECISION_STATUS);
769: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_DT')||':' ||l_dl_resp.CRDT_DECISION_DATE);
770: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_OVD')||':' ||l_dl_resp.CRDT_DECISION_OVRD_CODE);
771:

Line 768: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_ST')||':' ||l_dl_resp.CRDT_DECISION_STATUS);

764:
765: IF p_type = 'CO' OR p_type = 'RS' THEN
766:
767: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','END_AMT')||':' ||l_dl_resp.ENDORSER_AMT);
768: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_ST')||':' ||l_dl_resp.CRDT_DECISION_STATUS);
769: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_DT')||':' ||l_dl_resp.CRDT_DECISION_DATE);
770: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_OVD')||':' ||l_dl_resp.CRDT_DECISION_OVRD_CODE);
771:
772: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL

Line 769: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_DT')||':' ||l_dl_resp.CRDT_DECISION_DATE);

765: IF p_type = 'CO' OR p_type = 'RS' THEN
766:
767: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','END_AMT')||':' ||l_dl_resp.ENDORSER_AMT);
768: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_ST')||':' ||l_dl_resp.CRDT_DECISION_STATUS);
769: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_DT')||':' ||l_dl_resp.CRDT_DECISION_DATE);
770: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_OVD')||':' ||l_dl_resp.CRDT_DECISION_OVRD_CODE);
771:
772: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
773: l_tbh_cur.CREDIT_OVERRIDE := NVL(l_dl_resp.CRDT_DECISION_OVRD_CODE, l_tbh_cur.CREDIT_OVERRIDE);

Line 770: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_OVD')||':' ||l_dl_resp.CRDT_DECISION_OVRD_CODE);

766:
767: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','END_AMT')||':' ||l_dl_resp.ENDORSER_AMT);
768: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_ST')||':' ||l_dl_resp.CRDT_DECISION_STATUS);
769: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_DT')||':' ||l_dl_resp.CRDT_DECISION_DATE);
770: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CRDT_DEC_OVD')||':' ||l_dl_resp.CRDT_DECISION_OVRD_CODE);
771:
772: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
773: l_tbh_cur.CREDIT_OVERRIDE := NVL(l_dl_resp.CRDT_DECISION_OVRD_CODE, l_tbh_cur.CREDIT_OVERRIDE);
774: l_tbh_cur.CREDIT_DECISION_DATE := NVL(l_dl_resp.CRDT_DECISION_DATE, l_tbh_cur.CREDIT_DECISION_DATE);

Line 789: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ELEC_MPN_FLAG')||':' ||l_dl_resp.ELEC_MPN_FLAG);

785: END IF;
786:
787: IF p_type = 'PN' OR p_type = 'RS' OR p_type = 'CO' THEN
788:
789: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ELEC_MPN_FLAG')||':' ||l_dl_resp.ELEC_MPN_FLAG);
790: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PNOTE_MPN_ID')||':' ||l_dl_resp.PNOTE_MPN_ID);
791: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_STATUS_CODE')||':' ||l_dl_resp.MPN_STATUS_CODE);
792: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_LINK_FLAG')||':' ||l_dl_resp.MPN_LINK_FLAG);
793:

Line 790: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PNOTE_MPN_ID')||':' ||l_dl_resp.PNOTE_MPN_ID);

786:
787: IF p_type = 'PN' OR p_type = 'RS' OR p_type = 'CO' THEN
788:
789: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ELEC_MPN_FLAG')||':' ||l_dl_resp.ELEC_MPN_FLAG);
790: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PNOTE_MPN_ID')||':' ||l_dl_resp.PNOTE_MPN_ID);
791: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_STATUS_CODE')||':' ||l_dl_resp.MPN_STATUS_CODE);
792: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_LINK_FLAG')||':' ||l_dl_resp.MPN_LINK_FLAG);
793:
794: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL

Line 791: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_STATUS_CODE')||':' ||l_dl_resp.MPN_STATUS_CODE);

787: IF p_type = 'PN' OR p_type = 'RS' OR p_type = 'CO' THEN
788:
789: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ELEC_MPN_FLAG')||':' ||l_dl_resp.ELEC_MPN_FLAG);
790: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PNOTE_MPN_ID')||':' ||l_dl_resp.PNOTE_MPN_ID);
791: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_STATUS_CODE')||':' ||l_dl_resp.MPN_STATUS_CODE);
792: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_LINK_FLAG')||':' ||l_dl_resp.MPN_LINK_FLAG);
793:
794: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
795: l_tbh_cur.PNOTE_ID := NVL(l_dl_resp.PNOTE_MPN_ID, l_tbh_cur.PNOTE_ID);

Line 792: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_LINK_FLAG')||':' ||l_dl_resp.MPN_LINK_FLAG);

788:
789: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ELEC_MPN_FLAG')||':' ||l_dl_resp.ELEC_MPN_FLAG);
790: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PNOTE_MPN_ID')||':' ||l_dl_resp.PNOTE_MPN_ID);
791: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_STATUS_CODE')||':' ||l_dl_resp.MPN_STATUS_CODE);
792: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','MPN_LINK_FLAG')||':' ||l_dl_resp.MPN_LINK_FLAG);
793:
794: -- update these 4 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
795: l_tbh_cur.PNOTE_ID := NVL(l_dl_resp.PNOTE_MPN_ID, l_tbh_cur.PNOTE_ID);
796: l_tbh_cur.PNOTE_STATUS := NVL(l_dl_resp.MPN_STATUS_CODE, l_tbh_cur.PNOTE_STATUS);

Line 827: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_AMT')||':' ||l_dl_resp.PYMT_SERVICER_AMT);

823: END IF;
824:
825: IF p_type = 'PS' OR p_type = 'RS' THEN
826:
827: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_AMT')||':' ||l_dl_resp.PYMT_SERVICER_AMT);
828: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_DATE')||':' ||l_dl_resp.PYMT_SERVICER_DATE);
829:
830: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
831: -- IN LOR_ALL OLD+NEW PYMT AMOUNT

Line 828: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_DATE')||':' ||l_dl_resp.PYMT_SERVICER_DATE);

824:
825: IF p_type = 'PS' OR p_type = 'RS' THEN
826:
827: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_AMT')||':' ||l_dl_resp.PYMT_SERVICER_AMT);
828: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PYMT_SERVICER_DATE')||':' ||l_dl_resp.PYMT_SERVICER_DATE);
829:
830: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL
831: -- IN LOR_ALL OLD+NEW PYMT AMOUNT
832: l_tbh_cur1.pymt_servicer_amt := NVL(l_tbh_cur1.pymt_servicer_amt,0) + NVL(l_dl_resp.PYMT_SERVICER_AMT,0);

Line 840: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT')||':' ||l_dl_resp.BOOK_LOAN_AMT);

836: END IF;
837:
838: IF p_type = 'BN' OR p_type = 'RS' THEN
839:
840: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT')||':' ||l_dl_resp.BOOK_LOAN_AMT);
841: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT_DATE')||':' ||l_dl_resp.BOOK_LOAN_AMT_DATE);
842:
843: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL and the document_id also
844: l_tbh_cur.BOOK_LOAN_AMT := NVL(l_dl_resp.BOOK_LOAN_AMT, l_tbh_cur.BOOK_LOAN_AMT);

Line 841: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT_DATE')||':' ||l_dl_resp.BOOK_LOAN_AMT_DATE);

837:
838: IF p_type = 'BN' OR p_type = 'RS' THEN
839:
840: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT')||':' ||l_dl_resp.BOOK_LOAN_AMT);
841: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','BOOK_LOAN_AMT_DATE')||':' ||l_dl_resp.BOOK_LOAN_AMT_DATE);
842:
843: -- update these 2 cols in the tables IGF_SL_LOR_ALL, IGF_SL_LOR_LOC_ALL and the document_id also
844: l_tbh_cur.BOOK_LOAN_AMT := NVL(l_dl_resp.BOOK_LOAN_AMT, l_tbh_cur.BOOK_LOAN_AMT);
845: l_tbh_cur.BOOK_LOAN_AMT_DATE := NVL(l_dl_resp.BOOK_LOAN_AMT_DATE, l_tbh_cur.BOOK_LOAN_AMT_DATE);

Line 1210: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_dl_db_resp.disb_num);

1206:
1207: -- start the processing of Direct Loan Disbursements
1208: FOR l_dl_db_resp IN get_dl_db_resp(l_dl_resp.DL_LOAN_RESP_ID)
1209: LOOP
1210: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_dl_db_resp.disb_num);
1211: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_dl_db_resp.disb_seq_num);
1212: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_db_resp.RESP_CODE);
1213:
1214: l_dl_db_rec := NULL;

Line 1211: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_dl_db_resp.disb_seq_num);

1207: -- start the processing of Direct Loan Disbursements
1208: FOR l_dl_db_resp IN get_dl_db_resp(l_dl_resp.DL_LOAN_RESP_ID)
1209: LOOP
1210: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_dl_db_resp.disb_num);
1211: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_dl_db_resp.disb_seq_num);
1212: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_db_resp.RESP_CODE);
1213:
1214: l_dl_db_rec := NULL;
1215: OPEN get_dl_db_rec(l_dl_rec.AWARD_ID,l_dl_db_resp.disb_seq_num,l_dl_db_resp.disb_num);

Line 1212: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_db_resp.RESP_CODE);

1208: FOR l_dl_db_resp IN get_dl_db_resp(l_dl_resp.DL_LOAN_RESP_ID)
1209: LOOP
1210: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_dl_db_resp.disb_num);
1211: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_dl_db_resp.disb_seq_num);
1212: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_dl_db_resp.RESP_CODE);
1213:
1214: l_dl_db_rec := NULL;
1215: OPEN get_dl_db_rec(l_dl_rec.AWARD_ID,l_dl_db_resp.disb_seq_num,l_dl_db_resp.disb_num);
1216: FETCH get_dl_db_rec INTO l_dl_db_rec;

Line 1236: fnd_file.put_line(fnd_file.log,fnd_message.get);

1232: IF l_dl_db_resp.disb_seq_num < 66 THEN
1233: IF l_tbh_disb.disb_seq_num IS NULL THEN
1234: -- disbursement record not found in the system. Log a mesg.
1235: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1236: fnd_file.put_line(fnd_file.log,fnd_message.get);
1237:
1238: UPDATE IGF_SL_DLDB_RSP_DTL
1239: SET status_code = 'N'
1240: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;

Line 1258: fnd_file.put_line(fnd_file.log,fnd_message.get);

1254: IF l_dl_db_resp.disb_seq_num < 66 THEN
1255: IF l_tbh_disb.disb_seq_num IS NULL THEN
1256: -- disbursement record not found in the system. Log a mesg.
1257: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1258: fnd_file.put_line(fnd_file.log,fnd_message.get);
1259:
1260: -- update the status to 'N' - Processed, Not found in the System
1261: UPDATE IGF_SL_DLDB_RSP_DTL
1262: SET STATUS_CODE = 'N'

Line 1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_dl_db_rec.DISB_ACCEPTED_AMT);

1263: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;
1264: update_flag := FALSE;
1265: ELSE
1266: IF l_dl_db_rec.DISB_ACCEPTED_AMT <> l_dl_db_resp.disb_amt THEN
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_dl_db_rec.DISB_ACCEPTED_AMT);
1268: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.disb_amt);
1269: igf_gr_gen.insert_sys_holds(l_dl_rec.award_id,l_dl_db_rec.disb_num,'DL');
1270: END IF;
1271: IF l_dl_db_rec.disb_date <> l_dl_db_resp.disb_date THEN

Line 1268: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.disb_amt);

1264: update_flag := FALSE;
1265: ELSE
1266: IF l_dl_db_rec.DISB_ACCEPTED_AMT <> l_dl_db_resp.disb_amt THEN
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_dl_db_rec.DISB_ACCEPTED_AMT);
1268: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.disb_amt);
1269: igf_gr_gen.insert_sys_holds(l_dl_rec.award_id,l_dl_db_rec.disb_num,'DL');
1270: END IF;
1271: IF l_dl_db_rec.disb_date <> l_dl_db_resp.disb_date THEN
1272: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_dl_db_rec.disb_date);

Line 1272: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_dl_db_rec.disb_date);

1268: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.disb_amt);
1269: igf_gr_gen.insert_sys_holds(l_dl_rec.award_id,l_dl_db_rec.disb_num,'DL');
1270: END IF;
1271: IF l_dl_db_rec.disb_date <> l_dl_db_resp.disb_date THEN
1272: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_dl_db_rec.disb_date);
1273: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.disb_date);
1274: END IF;
1275:
1276: -- update in the table IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PREV_SEQ_NUM,STATUS

Line 1273: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.disb_date);

1269: igf_gr_gen.insert_sys_holds(l_dl_rec.award_id,l_dl_db_rec.disb_num,'DL');
1270: END IF;
1271: IF l_dl_db_rec.disb_date <> l_dl_db_resp.disb_date THEN
1272: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_dl_db_rec.disb_date);
1273: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.disb_date);
1274: END IF;
1275:
1276: -- update in the table IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PREV_SEQ_NUM,STATUS
1277: l_tbh_disb.DISB_STATUS := l_dl_db_resp.RESP_CODE;

Line 1290: fnd_file.put_line(fnd_file.log,fnd_message.get);

1286: END IF;
1287: ELSE -- implies disb_seq_num > 65
1288: IF l_dl_db_resp.DISB_SEQ_NUM < 91 THEN
1289: fnd_message.set_name('IGF','IGF_SL_COD_SCHL_ADJ');
1290: fnd_file.put_line(fnd_file.log,fnd_message.get);
1291: ELSIF l_dl_db_resp.DISB_SEQ_NUM < 100 THEN
1292: fnd_message.set_name('IGF','IGF_SL_COD_GEN_DISB');
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: END IF;

Line 1293: fnd_file.put_line(fnd_file.log,fnd_message.get);

1289: fnd_message.set_name('IGF','IGF_SL_COD_SCHL_ADJ');
1290: fnd_file.put_line(fnd_file.log,fnd_message.get);
1291: ELSIF l_dl_db_resp.DISB_SEQ_NUM < 100 THEN
1292: fnd_message.set_name('IGF','IGF_SL_COD_GEN_DISB');
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: END IF;
1295:
1296: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.DISB_AMT);
1297: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.DISB_DATE);

Line 1296: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.DISB_AMT);

1292: fnd_message.set_name('IGF','IGF_SL_COD_GEN_DISB');
1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: END IF;
1295:
1296: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.DISB_AMT);
1297: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.DISB_DATE);
1298: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_dl_db_resp.PREV_SEQ_NUM);
1299:
1300: UPDATE IGF_SL_DLDB_RSP_DTL

Line 1297: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.DISB_DATE);

1293: fnd_file.put_line(fnd_file.log,fnd_message.get);
1294: END IF;
1295:
1296: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.DISB_AMT);
1297: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.DISB_DATE);
1298: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_dl_db_resp.PREV_SEQ_NUM);
1299:
1300: UPDATE IGF_SL_DLDB_RSP_DTL
1301: SET STATUS_CODE = 'P'

Line 1298: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_dl_db_resp.PREV_SEQ_NUM);

1294: END IF;
1295:
1296: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_dl_db_resp.DISB_AMT);
1297: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.DISB_DATE);
1298: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_dl_db_resp.PREV_SEQ_NUM);
1299:
1300: UPDATE IGF_SL_DLDB_RSP_DTL
1301: SET STATUS_CODE = 'P'
1302: WHERE DISB_RESP_ID = l_dl_db_resp.DISB_RESP_ID;

Line 1447: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_PELL'));

1443:
1444:
1445: FOR l_pell_resp IN get_pell_resp(p_st_id)
1446: LOOP
1447: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_PELL'));
1448: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_resp.RESP_CODE );
1449:
1450: l_pell_rec := NULL;
1451: OPEN get_pell_rec(p_ssn,p_lname,p_dob,l_pell_resp.FIN_AWD_YR);

Line 1448: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_resp.RESP_CODE );

1444:
1445: FOR l_pell_resp IN get_pell_resp(p_st_id)
1446: LOOP
1447: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_PELL'));
1448: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_resp.RESP_CODE );
1449:
1450: l_pell_rec := NULL;
1451: OPEN get_pell_rec(p_ssn,p_lname,p_dob,l_pell_resp.FIN_AWD_YR);
1452: FETCH get_pell_rec INTO l_pell_rec;

Line 1460: fnd_file.put_line(fnd_file.log,fnd_message.get);

1456:
1457:
1458: IF l_pell_rec.origination_id IS NULL THEN
1459: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1460: fnd_file.put_line(fnd_file.log,fnd_message.get);
1461:
1462: -- Update the status to 'N' - Processed, Not found in the System
1463: UPDATE IGF_GR_RESP_DTLS
1464: SET STATUS_CODE = 'N'

Line 1483: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_PELL')||':' ||l_pell_rec.AWARD_AMT );

1479: l_tbh_pell.ORIG_ACTION_CODE := 'E';
1480: ELSIF l_pell_resp.RESP_CODE IN ('A','C') THEN
1481: -- compare the values in the resp record with the system record
1482: IF l_pell_resp.AWARD_AMT <> l_pell_rec.AWARD_AMT THEN
1483: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_PELL')||':' ||l_pell_rec.AWARD_AMT );
1484: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PELL')||':' ||l_pell_resp.AWARD_AMT );
1485: END IF;
1486: IF l_pell_resp.COA_AMT <> l_pell_rec.COA_AMT THEN
1487: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_COA')||':' ||l_pell_rec.COA_AMT);

Line 1484: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PELL')||':' ||l_pell_resp.AWARD_AMT );

1480: ELSIF l_pell_resp.RESP_CODE IN ('A','C') THEN
1481: -- compare the values in the resp record with the system record
1482: IF l_pell_resp.AWARD_AMT <> l_pell_rec.AWARD_AMT THEN
1483: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_PELL')||':' ||l_pell_rec.AWARD_AMT );
1484: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PELL')||':' ||l_pell_resp.AWARD_AMT );
1485: END IF;
1486: IF l_pell_resp.COA_AMT <> l_pell_rec.COA_AMT THEN
1487: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_COA')||':' ||l_pell_rec.COA_AMT);
1488: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_COA')||':' ||l_pell_resp.COA_AMT);

Line 1487: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_COA')||':' ||l_pell_rec.COA_AMT);

1483: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_PELL')||':' ||l_pell_rec.AWARD_AMT );
1484: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PELL')||':' ||l_pell_resp.AWARD_AMT );
1485: END IF;
1486: IF l_pell_resp.COA_AMT <> l_pell_rec.COA_AMT THEN
1487: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_COA')||':' ||l_pell_rec.COA_AMT);
1488: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_COA')||':' ||l_pell_resp.COA_AMT);
1489: END IF;
1490: IF l_pell_resp.SCHD_PELL_AMT <> l_pell_rec.SCHD_PELL_AMT THEN
1491: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_FT')||':' ||l_pell_rec.SCHD_PELL_AMT);

Line 1488: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_COA')||':' ||l_pell_resp.COA_AMT);

1484: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PELL')||':' ||l_pell_resp.AWARD_AMT );
1485: END IF;
1486: IF l_pell_resp.COA_AMT <> l_pell_rec.COA_AMT THEN
1487: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_COA')||':' ||l_pell_rec.COA_AMT);
1488: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_COA')||':' ||l_pell_resp.COA_AMT);
1489: END IF;
1490: IF l_pell_resp.SCHD_PELL_AMT <> l_pell_rec.SCHD_PELL_AMT THEN
1491: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_FT')||':' ||l_pell_rec.SCHD_PELL_AMT);
1492: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_FT')||':' ||l_pell_resp.SCHD_PELL_AMT);

Line 1491: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_FT')||':' ||l_pell_rec.SCHD_PELL_AMT);

1487: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_COA')||':' ||l_pell_rec.COA_AMT);
1488: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_COA')||':' ||l_pell_resp.COA_AMT);
1489: END IF;
1490: IF l_pell_resp.SCHD_PELL_AMT <> l_pell_rec.SCHD_PELL_AMT THEN
1491: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_FT')||':' ||l_pell_rec.SCHD_PELL_AMT);
1492: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_FT')||':' ||l_pell_resp.SCHD_PELL_AMT);
1493: END IF;
1494: IF l_pell_resp.VER_STATUS_CODE <> l_pell_rec.VER_STATUS_CODE THEN
1495: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_VER')||':' ||l_pell_rec.VER_STATUS_CODE);

Line 1492: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_FT')||':' ||l_pell_resp.SCHD_PELL_AMT);

1488: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_COA')||':' ||l_pell_resp.COA_AMT);
1489: END IF;
1490: IF l_pell_resp.SCHD_PELL_AMT <> l_pell_rec.SCHD_PELL_AMT THEN
1491: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_FT')||':' ||l_pell_rec.SCHD_PELL_AMT);
1492: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_FT')||':' ||l_pell_resp.SCHD_PELL_AMT);
1493: END IF;
1494: IF l_pell_resp.VER_STATUS_CODE <> l_pell_rec.VER_STATUS_CODE THEN
1495: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_VER')||':' ||l_pell_rec.VER_STATUS_CODE);
1496: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_VER')||':' ||l_pell_resp.VER_STATUS_CODE);

Line 1495: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_VER')||':' ||l_pell_rec.VER_STATUS_CODE);

1491: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_FT')||':' ||l_pell_rec.SCHD_PELL_AMT);
1492: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_FT')||':' ||l_pell_resp.SCHD_PELL_AMT);
1493: END IF;
1494: IF l_pell_resp.VER_STATUS_CODE <> l_pell_rec.VER_STATUS_CODE THEN
1495: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_VER')||':' ||l_pell_rec.VER_STATUS_CODE);
1496: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_VER')||':' ||l_pell_resp.VER_STATUS_CODE);
1497: END IF;
1498:
1499: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','YTD_DISB_AMT')||':' ||l_pell_resp.YTD_DISB_AMT);

Line 1496: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_VER')||':' ||l_pell_resp.VER_STATUS_CODE);

1492: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_FT')||':' ||l_pell_resp.SCHD_PELL_AMT);
1493: END IF;
1494: IF l_pell_resp.VER_STATUS_CODE <> l_pell_rec.VER_STATUS_CODE THEN
1495: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_VER')||':' ||l_pell_rec.VER_STATUS_CODE);
1496: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_VER')||':' ||l_pell_resp.VER_STATUS_CODE);
1497: END IF;
1498:
1499: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','YTD_DISB_AMT')||':' ||l_pell_resp.YTD_DISB_AMT);
1500: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ELIG_USED')||':' ||l_pell_resp.TOT_ELIG_USED);

Line 1499: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','YTD_DISB_AMT')||':' ||l_pell_resp.YTD_DISB_AMT);

1495: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_VER')||':' ||l_pell_rec.VER_STATUS_CODE);
1496: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_VER')||':' ||l_pell_resp.VER_STATUS_CODE);
1497: END IF;
1498:
1499: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','YTD_DISB_AMT')||':' ||l_pell_resp.YTD_DISB_AMT);
1500: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ELIG_USED')||':' ||l_pell_resp.TOT_ELIG_USED);
1501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','NEG_PEND_AMT')||':' ||l_pell_resp.NEG_PEND_AMT);
1502:
1503: /*SELECT THE COLUMNS YTD_DISB_AMT, TOT_ELIG_USED, SCHD_PELL_AMT, NEG_PEND_AMT, FSA_CODE_1,FSA_CODE_2,FSA_CODE_3,PELL_STATUS

Line 1500: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ELIG_USED')||':' ||l_pell_resp.TOT_ELIG_USED);

1496: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_VER')||':' ||l_pell_resp.VER_STATUS_CODE);
1497: END IF;
1498:
1499: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','YTD_DISB_AMT')||':' ||l_pell_resp.YTD_DISB_AMT);
1500: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ELIG_USED')||':' ||l_pell_resp.TOT_ELIG_USED);
1501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','NEG_PEND_AMT')||':' ||l_pell_resp.NEG_PEND_AMT);
1502:
1503: /*SELECT THE COLUMNS YTD_DISB_AMT, TOT_ELIG_USED, SCHD_PELL_AMT, NEG_PEND_AMT, FSA_CODE_1,FSA_CODE_2,FSA_CODE_3,PELL_STATUS
1504: CPS_VERIF_FLAG, HIGH_CPS_TRANS_NUM FROM IGF_GR_RESP_DTLS

Line 1501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','NEG_PEND_AMT')||':' ||l_pell_resp.NEG_PEND_AMT);

1497: END IF;
1498:
1499: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','YTD_DISB_AMT')||':' ||l_pell_resp.YTD_DISB_AMT);
1500: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ELIG_USED')||':' ||l_pell_resp.TOT_ELIG_USED);
1501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','NEG_PEND_AMT')||':' ||l_pell_resp.NEG_PEND_AMT);
1502:
1503: /*SELECT THE COLUMNS YTD_DISB_AMT, TOT_ELIG_USED, SCHD_PELL_AMT, NEG_PEND_AMT, FSA_CODE_1,FSA_CODE_2,FSA_CODE_3,PELL_STATUS
1504: CPS_VERIF_FLAG, HIGH_CPS_TRANS_NUM FROM IGF_GR_RESP_DTLS
1505: Also update the fields YTD_DISB_AMT, TOT_ELIG_USED, PENDING_AMOUNT,ORIG_aCTION_CODE in the table IGF_GR_RFMS_ALL

Line 1575: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_pell_db_resp.disb_num);

1571:
1572: -- start the processing of pell disbursements
1573: FOR l_pell_db_resp IN get_pell_db_resp(l_pell_resp.PELL_RESP_ID)
1574: LOOP
1575: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_pell_db_resp.disb_num);
1576: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_pell_db_resp.disb_seq_num);
1577: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_db_resp.RESP_CODE);
1578:
1579: l_pell_db_rec := NULL;

Line 1576: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_pell_db_resp.disb_seq_num);

1572: -- start the processing of pell disbursements
1573: FOR l_pell_db_resp IN get_pell_db_resp(l_pell_resp.PELL_RESP_ID)
1574: LOOP
1575: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_pell_db_resp.disb_num);
1576: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_pell_db_resp.disb_seq_num);
1577: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_db_resp.RESP_CODE);
1578:
1579: l_pell_db_rec := NULL;
1580: OPEN get_pell_db_rec(l_pell_rec.AWARD_ID,l_pell_db_resp.disb_seq_num,l_pell_db_resp.disb_num);

Line 1577: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_db_resp.RESP_CODE);

1573: FOR l_pell_db_resp IN get_pell_db_resp(l_pell_resp.PELL_RESP_ID)
1574: LOOP
1575: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_NUM')||':'||l_pell_db_resp.disb_num);
1576: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DISB_SEQ_NUM')||':' ||l_pell_db_resp.disb_seq_num);
1577: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')||':' ||l_pell_db_resp.RESP_CODE);
1578:
1579: l_pell_db_rec := NULL;
1580: OPEN get_pell_db_rec(l_pell_rec.AWARD_ID,l_pell_db_resp.disb_seq_num,l_pell_db_resp.disb_num);
1581: FETCH get_pell_db_rec INTO l_pell_db_rec;

Line 1602: fnd_file.put_line(fnd_file.log,fnd_message.get);

1598: IF l_pell_db_resp.disb_seq_num < 66 THEN
1599: IF l_tbh_disb.disb_seq_num IS NULL THEN
1600: -- disbursement record not found in the system. Log a mesg.
1601: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1602: fnd_file.put_line(fnd_file.log,fnd_message.get);
1603:
1604: UPDATE IGF_GR_DB_RESP_DTLS
1605: SET status_code = 'N'
1606: WHERE DISB_RESP_ID = l_pell_db_resp.DISB_RESP_ID;

Line 1623: fnd_file.put_line(fnd_file.log,fnd_message.get);

1619: IF l_pell_db_resp.disb_seq_num < 66 THEN
1620: IF l_tbh_disb.disb_seq_num IS NULL THEN
1621: -- disbursement record not found in the system. Log a mesg.
1622: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');
1623: fnd_file.put_line(fnd_file.log,fnd_message.get);
1624:
1625: -- update the status to 'N' - Processed, Not found in the System
1626: UPDATE IGF_GR_DB_RESP_DTLS
1627: SET STATUS_CODE = 'N'

Line 1640: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_pell_db_rec.DISB_ACCEPTED_AMT);

1636: IGF_AW_DISB_COD_DTLS and IGF_AW_DB_CHG_DTLS.
1637: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS*/ --dont
1638:
1639: IF l_pell_db_rec.DISB_ACCEPTED_AMT <> l_pell_db_resp.disb_amt THEN
1640: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_pell_db_rec.DISB_ACCEPTED_AMT);
1641: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.disb_amt);
1642: igf_gr_gen.insert_sys_holds(l_pell_rec.award_id,l_pell_db_rec.disb_num,'PELL');
1643: END IF;
1644: IF l_pell_db_rec.disb_date <> l_pell_db_resp.disb_date THEN

Line 1641: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.disb_amt);

1637: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS*/ --dont
1638:
1639: IF l_pell_db_rec.DISB_ACCEPTED_AMT <> l_pell_db_resp.disb_amt THEN
1640: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_pell_db_rec.DISB_ACCEPTED_AMT);
1641: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.disb_amt);
1642: igf_gr_gen.insert_sys_holds(l_pell_rec.award_id,l_pell_db_rec.disb_num,'PELL');
1643: END IF;
1644: IF l_pell_db_rec.disb_date <> l_pell_db_resp.disb_date THEN
1645: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_pell_db_rec.disb_date);

Line 1645: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_pell_db_rec.disb_date);

1641: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.disb_amt);
1642: igf_gr_gen.insert_sys_holds(l_pell_rec.award_id,l_pell_db_rec.disb_num,'PELL');
1643: END IF;
1644: IF l_pell_db_rec.disb_date <> l_pell_db_resp.disb_date THEN
1645: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_pell_db_rec.disb_date);
1646: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.disb_date);
1647: END IF;
1648: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PYMT_PER_DT')||':' ||l_pell_db_resp.PYMNT_PER_START_DATE);
1649:

Line 1646: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.disb_date);

1642: igf_gr_gen.insert_sys_holds(l_pell_rec.award_id,l_pell_db_rec.disb_num,'PELL');
1643: END IF;
1644: IF l_pell_db_rec.disb_date <> l_pell_db_resp.disb_date THEN
1645: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_pell_db_rec.disb_date);
1646: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.disb_date);
1647: END IF;
1648: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PYMT_PER_DT')||':' ||l_pell_db_resp.PYMNT_PER_START_DATE);
1649:
1650: -- UPDATE IN THE TABLE IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PYMNT_PER_START_DATE, PREV_SEQ_NUM

Line 1648: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PYMT_PER_DT')||':' ||l_pell_db_resp.PYMNT_PER_START_DATE);

1644: IF l_pell_db_rec.disb_date <> l_pell_db_resp.disb_date THEN
1645: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_pell_db_rec.disb_date);
1646: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.disb_date);
1647: END IF;
1648: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PYMT_PER_DT')||':' ||l_pell_db_resp.PYMNT_PER_START_DATE);
1649:
1650: -- UPDATE IN THE TABLE IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PYMNT_PER_START_DATE, PREV_SEQ_NUM
1651: l_tbh_disb.DISB_STATUS := l_pell_db_resp.RESP_CODE;
1652: l_tbh_disb.PYMNT_PRD_START_DATE := l_pell_db_resp.PYMNT_PER_START_DATE;

Line 1668: fnd_file.put_line(fnd_file.log,fnd_message.get);

1664: /* Print Disbursement Amount, Disbursement Date, Previous Disbursement Sequence Number
1665: and print a message -(School would have to adjust the disbursement amount as per the COD generated adjustment)
1666: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS. */ --dont
1667: fnd_message.set_name('IGF','IGF_SL_COD_SCHL_ADJ');
1668: fnd_file.put_line(fnd_file.log,fnd_message.get);
1669: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.DISB_AMT);
1670: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.DISB_DATE);
1671: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_pell_db_resp.PREV_SEQ_NUM);
1672:

Line 1669: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.DISB_AMT);

1665: and print a message -(School would have to adjust the disbursement amount as per the COD generated adjustment)
1666: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS. */ --dont
1667: fnd_message.set_name('IGF','IGF_SL_COD_SCHL_ADJ');
1668: fnd_file.put_line(fnd_file.log,fnd_message.get);
1669: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.DISB_AMT);
1670: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.DISB_DATE);
1671: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_pell_db_resp.PREV_SEQ_NUM);
1672:
1673: UPDATE IGF_GR_DB_RESP_DTLS

Line 1670: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.DISB_DATE);

1666: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS. */ --dont
1667: fnd_message.set_name('IGF','IGF_SL_COD_SCHL_ADJ');
1668: fnd_file.put_line(fnd_file.log,fnd_message.get);
1669: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.DISB_AMT);
1670: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.DISB_DATE);
1671: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_pell_db_resp.PREV_SEQ_NUM);
1672:
1673: UPDATE IGF_GR_DB_RESP_DTLS
1674: SET STATUS_CODE = 'P'

Line 1671: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_pell_db_resp.PREV_SEQ_NUM);

1667: fnd_message.set_name('IGF','IGF_SL_COD_SCHL_ADJ');
1668: fnd_file.put_line(fnd_file.log,fnd_message.get);
1669: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_AMT')||':' ||l_pell_db_resp.DISB_AMT);
1670: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.DISB_DATE);
1671: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PRV_SEQ_NUM')||':' ||l_pell_db_resp.PREV_SEQ_NUM);
1672:
1673: UPDATE IGF_GR_DB_RESP_DTLS
1674: SET STATUS_CODE = 'P'
1675: WHERE DISB_RESP_ID = l_pell_db_resp.DISB_RESP_ID;

Line 1832: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_ID')|| ':'||p_doc_id);

1828: l_as_rej_flg := FALSE;
1829: l_st_rej_flg := FALSE;
1830:
1831: -- Print the parameters passed to the procedure
1832: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_ID')|| ':'||p_doc_id);
1833: fnd_file.put_line(fnd_file.log,'');
1834:
1835: -- Check if the document is present or not.
1836: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1833: fnd_file.put_line(fnd_file.log,'');

1829: l_st_rej_flg := FALSE;
1830:
1831: -- Print the parameters passed to the procedure
1832: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_ID')|| ':'||p_doc_id);
1833: fnd_file.put_line(fnd_file.log,'');
1834:
1835: -- Check if the document is present or not.
1836: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1837: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','Checking document(' || p_doc_id || ') is present or not');

Line 1845: fnd_file.put_line(fnd_file.log,fnd_message.get);

1841: FETCH chk_doc INTO l_chk_doc;
1842: CLOSE chk_doc;
1843: IF l_chk_doc.document_id_txt IS NULL THEN
1844: fnd_message.set_name('IGF','IGF_SL_COD_INV_DOCID');
1845: fnd_file.put_line(fnd_file.log,fnd_message.get);
1846: RETURN;
1847: END IF;
1848:
1849: -- set the global doc id

Line 1939: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CR_RESP_DTLS'));

1935: CLOSE get_cr_resp;
1936:
1937: -- print CommonRecord values in log file
1938: g_process_date := l_get_cr_resp.PROCESS_DATE;
1939: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CR_RESP_DTLS'));
1940: fnd_file.put_line(fnd_file.log,'');
1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);

Line 1940: fnd_file.put_line(fnd_file.log,'');

1936:
1937: -- print CommonRecord values in log file
1938: g_process_date := l_get_cr_resp.PROCESS_DATE;
1939: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CR_RESP_DTLS'));
1940: fnd_file.put_line(fnd_file.log,'');
1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);

Line 1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);

1937: -- print CommonRecord values in log file
1938: g_process_date := l_get_cr_resp.PROCESS_DATE;
1939: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CR_RESP_DTLS'));
1940: fnd_file.put_line(fnd_file.log,'');
1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);

Line 1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);

1938: g_process_date := l_get_cr_resp.PROCESS_DATE;
1939: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CR_RESP_DTLS'));
1940: fnd_file.put_line(fnd_file.log,'');
1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);

Line 1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);

1939: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','CR_RESP_DTLS'));
1940: fnd_file.put_line(fnd_file.log,'');
1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);

Line 1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);

1940: fnd_file.put_line(fnd_file.log,'');
1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);

Line 1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);

1941: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_CR_DT')|| ':'||l_get_cr_resp.DOC_CREATED_DATE);
1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);
1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);

Line 1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);

1942: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SRC_ENT_ID')|| ':'||l_get_cr_resp.SOURCE_ENTITY_ID_TXT);
1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);
1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);
1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);

Line 1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);

1943: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DST_ENT_ID')|| ':'||l_get_cr_resp.DEST_ENTITY_ID_TXT);
1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);
1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);
1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);
1951:

Line 1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);

1944: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_PRVD')|| ':'||l_get_cr_resp.SOFT_PROVIDER);
1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);
1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);
1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);
1951:
1952: -- Check if the document is receipt document or not. If it is, then

Line 1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);

1945: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SFT_VER')|| ':'||l_get_cr_resp.SOFT_VERSION);
1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);
1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);
1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);
1951:
1952: -- Check if the document is receipt document or not. If it is, then
1953: -- log message and return. Do not process if it is receipt document.

Line 1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);

1946: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FULL_RESP_CD')|| ':'||l_get_cr_resp.FULL_RESP_CODE);
1947: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RECP_DATE')|| ':'||l_get_cr_resp.RECEIPT_DATE);
1948: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_TYPE')|| ':'||l_get_cr_resp.DOC_TYPE_CODE);
1949: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','DOC_STATUS')|| ':'||l_get_cr_resp.DOC_STATUS_CODE);
1950: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','PROC_DATE')|| ':'||l_get_cr_resp.PROCESS_DATE);
1951:
1952: -- Check if the document is receipt document or not. If it is, then
1953: -- log message and return. Do not process if it is receipt document.
1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1958: fnd_file.put_line(fnd_file.log,'receipt date is not null');

1954: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1955: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','RECEIPT_DATE is ' || l_get_cr_resp.RECEIPT_DATE);
1956: END IF;
1957: IF l_get_cr_resp.RECEIPT_DATE IS NOT NULL THEN
1958: fnd_file.put_line(fnd_file.log,'receipt date is not null');
1959: fnd_message.set_name('IGF','IGF_SL_NOT_PRC_RECEIPT_DOC');
1960: fnd_file.put_line(fnd_file.log,fnd_message.get);
1961: -- delete data from resp tables as well as from temp table(IGF_SL_COD_TEMP)
1962: rollback_resp_tables();

Line 1960: fnd_file.put_line(fnd_file.log,fnd_message.get);

1956: END IF;
1957: IF l_get_cr_resp.RECEIPT_DATE IS NOT NULL THEN
1958: fnd_file.put_line(fnd_file.log,'receipt date is not null');
1959: fnd_message.set_name('IGF','IGF_SL_NOT_PRC_RECEIPT_DOC');
1960: fnd_file.put_line(fnd_file.log,fnd_message.get);
1961: -- delete data from resp tables as well as from temp table(IGF_SL_COD_TEMP)
1962: rollback_resp_tables();
1963: RETURN;
1964: END IF;

Line 1973: fnd_file.put_line(fnd_file.log,fnd_message.get);

1969: END IF;
1970: IF NOT check_entityid(l_get_cr_resp.DEST_ENTITY_ID_TXT) THEN
1971: fnd_message.set_name('IGF','IGF_SL_COD_INV_DEST_ID');
1972: fnd_message.set_token('DEST_ENTITY_ID',l_get_cr_resp.DEST_ENTITY_ID_TXT);
1973: fnd_file.put_line(fnd_file.log,fnd_message.get);
1974:
1975: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'E'
1976: update_xml_document(l_chk_doc, 'E');
1977: -- delete data from resp tables as well as from temp table(IGF_SL_COD_TEMP)

Line 1986: fnd_file.put_line(fnd_file.log,fnd_message.get);

1982: -- Rest of the processing is to be done if this is not a receipt document.
1983: IF l_get_cr_resp.RECEIPT_DATE IS NULL THEN
1984: IF l_get_cr_resp.FULL_RESP_CODE NOT IN ('F','S','M','N') THEN
1985: fnd_message.set_name('IGF','IGF_SL_COD_INV_RES_CODE');
1986: fnd_file.put_line(fnd_file.log,fnd_message.get);
1987:
1988: -- update the IGF_SL_COD_DOC_DTLS table with the status = 'F';
1989: update_xml_document(l_chk_doc, 'F');
1990: -- delete data from resp tables as well as from temp table(IGF_SL_COD_TEMP)

Line 2027: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));

2023: -- start the processing of the Reporting School Tags
2024: FOR l_rs_resp IN get_rs_resp(p_doc_id)
2025: LOOP
2026: l_rs_rej_flg := FALSE;
2027: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);

Line 2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);

2024: FOR l_rs_resp IN get_rs_resp(p_doc_id)
2025: LOOP
2026: l_rs_rej_flg := FALSE;
2027: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2032: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);

Line 2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);

2025: LOOP
2026: l_rs_rej_flg := FALSE;
2027: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2032: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2033:

Line 2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));

2026: l_rs_rej_flg := FALSE;
2027: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2032: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2033:
2034: IF NOT check_entityid(l_rs_resp.REP_ENTITY_ID_TXT) THEN

Line 2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);

2027: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2032: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2033:
2034: IF NOT check_entityid(l_rs_resp.REP_ENTITY_ID_TXT) THEN
2035: fnd_message.set_name('IGF','IGF_SL_COD_INV_REPENTITY_ID');

Line 2032: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);

2028: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2029: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2030: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_RESP_DTLS'));
2031: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RS_ENT_ID')|| ':'|| l_rs_resp.REP_ENTITY_ID_TXT);
2032: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_rs_resp.RESP_CODE);
2033:
2034: IF NOT check_entityid(l_rs_resp.REP_ENTITY_ID_TXT) THEN
2035: fnd_message.set_name('IGF','IGF_SL_COD_INV_REPENTITY_ID');
2036: fnd_message.set_token('REPT_ENTITY_ID',l_rs_resp.REP_ENTITY_ID_TXT);

Line 2037: fnd_file.put_line(fnd_file.log,fnd_message.get);

2033:
2034: IF NOT check_entityid(l_rs_resp.REP_ENTITY_ID_TXT) THEN
2035: fnd_message.set_name('IGF','IGF_SL_COD_INV_REPENTITY_ID');
2036: fnd_message.set_token('REPT_ENTITY_ID',l_rs_resp.REP_ENTITY_ID_TXT);
2037: fnd_file.put_line(fnd_file.log,fnd_message.get);
2038: -- skip the processing for this reporting school
2039: ELSE
2040: print_edits(l_rs_resp.REP_SCHL_RESP_ID,'RS');
2041:

Line 2049: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);

2045:
2046: -- print the fin summary data from the response file
2047: FOR l_fin_smry IN get_fin_smry(l_rs_resp.REP_SCHL_RESP_ID)
2048: LOOP
2049: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);

Line 2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);

2046: -- print the fin summary data from the response file
2047: FOR l_fin_smry IN get_fin_smry(l_rs_resp.REP_SCHL_RESP_ID)
2048: LOOP
2049: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);

Line 2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);

2047: FOR l_fin_smry IN get_fin_smry(l_rs_resp.REP_SCHL_RESP_ID)
2048: LOOP
2049: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);

Line 2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);

2048: LOOP
2049: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);

Line 2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);

2049: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);

Line 2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);

2050: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);

Line 2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);

2051: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);

Line 2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);

2052: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);

Line 2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);

2053: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);

Line 2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);

2054: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);

Line 2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);

2055: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);

Line 2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);

2056: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);

Line 2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);

2057: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:

Line 2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);

2058: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);

Line 2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);

2059: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);

Line 2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);

2060: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2061: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);

Line 2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);

2062: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);

Line 2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);

2063: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);

Line 2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);

2064: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);

Line 2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);

2065:
2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);

Line 2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);

2066: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_YR')|| ':'|| l_fin_smry.FIN_AWARD_YEAR);
2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);

Line 2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);

2067: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','FIN_AWD_TYP')|| ':'|| l_fin_smry.FIN_AWARD_TYPE);
2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);

Line 2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);

2068: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ST_TAG')|| ':'|| l_fin_smry.TOT_CNT_NUM);
2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);

Line 2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);

2069: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AWD')|| ':'|| l_fin_smry.TOT_CNT_ACPT_NUM);
2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);

Line 2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);

2070: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REJ_AWD')|| ':'|| l_fin_smry.TOT_CNT_REJ_NUM);
2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);

Line 2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);

2071: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DUP_AWD')|| ':'|| l_fin_smry.TOT_CNT_DUP_NUM);
2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);

Line 2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);

2072: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_COR_AWD')|| ':'|| l_fin_smry.TOT_CNT_CORR_NUM);
2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);

Line 2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);

2073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SEL_VERIF')|| ':'|| l_fin_smry.TOT_CNT_VER_SLCTD_NUM);
2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2081: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);

Line 2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);

2074: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_SSADMIN')|| ':'|| l_fin_smry.TOT_CNT_SSADMIN_NUM);
2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2081: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2082: END LOOP;

Line 2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);

2075: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_AWD')|| ':'|| l_fin_smry.TOT_REP_AWD_AMT);
2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2081: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2082: END LOOP;
2083:

Line 2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);

2076: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_REP_DB_AMT')|| ':'|| l_fin_smry.TOT_REP_DISB_AMT);
2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2081: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2082: END LOOP;
2083:
2084: -- start the processing of the Attending School Tags

Line 2081: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);

2077: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_ACPT_AMT);
2078: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_DB_ACPT_AMT')|| ':'|| l_fin_smry.TOT_FIN_DISB_ACPT_AMT);
2079: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_FUND_DB_AMT')|| ':'|| l_fin_smry.TOT_FUND_DISB_ACPT_AMT);
2080: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_NONFUND_DB_AMT')|| ':'|| l_fin_smry.TOT_NONFUND_DISB_ACPT_AMT);
2081: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','TOT_AWD_CORR_AMT')|| ':'|| l_fin_smry.TOT_FIN_AWD_CORR_AMT);
2082: END LOOP;
2083:
2084: -- start the processing of the Attending School Tags
2085: FOR l_as_resp IN get_as_resp(l_rs_resp.REP_SCHL_RESP_ID)

Line 2088: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));

2084: -- start the processing of the Attending School Tags
2085: FOR l_as_resp IN get_as_resp(l_rs_resp.REP_SCHL_RESP_ID)
2086: LOOP
2087: l_as_rej_flg := FALSE;
2088: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);

Line 2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);

2085: FOR l_as_resp IN get_as_resp(l_rs_resp.REP_SCHL_RESP_ID)
2086: LOOP
2087: l_as_rej_flg := FALSE;
2088: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2093: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);

Line 2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);

2086: LOOP
2087: l_as_rej_flg := FALSE;
2088: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2093: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2094:

Line 2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));

2087: l_as_rej_flg := FALSE;
2088: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2093: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2094:
2095: IF NOT check_entityid(l_as_resp.ATD_ENTITY_ID_TXT) THEN

Line 2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);

2088: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2093: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2094:
2095: IF NOT check_entityid(l_as_resp.ATD_ENTITY_ID_TXT) THEN
2096: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATDENTITY_ID');

Line 2093: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);

2089: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2090: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2091: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_RESP_DTLS'));
2092: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','AS_ENT_ID')|| ':'|| l_as_resp.ATD_ENTITY_ID_TXT);
2093: fnd_file.put_line(fnd_file.OUTPUT,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_as_resp.RESP_CODE);
2094:
2095: IF NOT check_entityid(l_as_resp.ATD_ENTITY_ID_TXT) THEN
2096: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATDENTITY_ID');
2097: fnd_message.set_token('ATTD_ENTITY_ID',l_as_resp.ATD_ENTITY_ID_TXT);

Line 2098: fnd_file.put_line(fnd_file.log,fnd_message.get);

2094:
2095: IF NOT check_entityid(l_as_resp.ATD_ENTITY_ID_TXT) THEN
2096: fnd_message.set_name('IGF','IGF_SL_COD_INV_ATDENTITY_ID');
2097: fnd_message.set_token('ATTD_ENTITY_ID',l_as_resp.ATD_ENTITY_ID_TXT);
2098: fnd_file.put_line(fnd_file.log,fnd_message.get);
2099: -- skip the processing for this attending school
2100: ELSE
2101: print_edits(l_as_resp.ATD_SCHL_RESP_ID,'AS');
2102:

Line 2111: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_RESP_DTLS'));

2107: -- start the processing of the Student Tags
2108: FOR l_st_resp IN get_st_resp(l_as_resp.ATD_SCHL_RESP_ID)
2109: LOOP
2110: l_st_rej_flg := FALSE;
2111: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_RESP_DTLS'));
2112: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_SSN')|| ':'|| l_st_resp.S_SSN);
2113: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_LNAME')|| ':'|| l_st_resp.S_LAST_NAME);
2114: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_DOB')|| ':'|| l_st_resp.S_DATE_OF_BIRTH);
2115: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_st_resp.RESP_CODE);

Line 2112: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_SSN')|| ':'|| l_st_resp.S_SSN);

2108: FOR l_st_resp IN get_st_resp(l_as_resp.ATD_SCHL_RESP_ID)
2109: LOOP
2110: l_st_rej_flg := FALSE;
2111: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_RESP_DTLS'));
2112: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_SSN')|| ':'|| l_st_resp.S_SSN);
2113: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_LNAME')|| ':'|| l_st_resp.S_LAST_NAME);
2114: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_DOB')|| ':'|| l_st_resp.S_DATE_OF_BIRTH);
2115: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_st_resp.RESP_CODE);
2116:

Line 2113: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_LNAME')|| ':'|| l_st_resp.S_LAST_NAME);

2109: LOOP
2110: l_st_rej_flg := FALSE;
2111: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_RESP_DTLS'));
2112: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_SSN')|| ':'|| l_st_resp.S_SSN);
2113: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_LNAME')|| ':'|| l_st_resp.S_LAST_NAME);
2114: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_DOB')|| ':'|| l_st_resp.S_DATE_OF_BIRTH);
2115: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_st_resp.RESP_CODE);
2116:
2117: print_edits(l_st_resp.STDNT_RESP_ID,'ST');

Line 2114: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_DOB')|| ':'|| l_st_resp.S_DATE_OF_BIRTH);

2110: l_st_rej_flg := FALSE;
2111: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_RESP_DTLS'));
2112: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_SSN')|| ':'|| l_st_resp.S_SSN);
2113: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_LNAME')|| ':'|| l_st_resp.S_LAST_NAME);
2114: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_DOB')|| ':'|| l_st_resp.S_DATE_OF_BIRTH);
2115: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_st_resp.RESP_CODE);
2116:
2117: print_edits(l_st_resp.STDNT_RESP_ID,'ST');
2118:

Line 2115: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_st_resp.RESP_CODE);

2111: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_RESP_DTLS'));
2112: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_SSN')|| ':'|| l_st_resp.S_SSN);
2113: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_LNAME')|| ':'|| l_st_resp.S_LAST_NAME);
2114: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','ST_DOB')|| ':'|| l_st_resp.S_DATE_OF_BIRTH);
2115: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_ST')|| ':'|| l_st_resp.RESP_CODE);
2116:
2117: print_edits(l_st_resp.STDNT_RESP_ID,'ST');
2118:
2119: IF l_as_rej_flg = TRUE OR l_st_resp.RESP_CODE = 'R' THEN

Line 2429: fnd_file.put_line(fnd_file.log, SQLERRM);

2425: WHEN OTHERS THEN
2426: ROLLBACK;
2427: retcode := 2;
2428: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2429: fnd_file.put_line(fnd_file.log, SQLERRM);
2430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2431: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main_response.debug','sqlerrm ' || SQLERRM);
2432: END IF;
2433: igs_ge_msg_stack.conc_exception_hndl;