170: Know limitations, enhancements or remarks
171: Change History:
172: -----------------------------------------------------------------------------------
173: Who When What
174: tsailaja 15/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
175: -----------------------------------------------------------------------------------
176: */
177: PROCEDURE main ( errbuf OUT NOCOPY VARCHAR2,
178: retcode OUT NOCOPY NUMBER,
213: lv_directory VARCHAR2(300);
214: lv_filename VARCHAR2(300);
215: ln_file_line_num NUMBER;
216: BEGIN
217: igf_aw_gen.set_org_id(NULL);
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','main started');
220: END IF;
221:
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)
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);
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);
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);
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);
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;
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:
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
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
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);
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;
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
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.
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:
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
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);
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);
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:
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
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);
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);
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
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);
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);
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);
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;
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);
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;
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
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);
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
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;
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
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'
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;
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);
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;
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);
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);
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);
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);
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);
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);
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);
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);
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
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
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
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;
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);
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;
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
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);
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:
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
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;
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
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'
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;
1749: -- Know limitations, enhancements or remarks
1750: -- Change History:
1751: -----------------------------------------------------------------------------------
1752: -- Who When What
1753: -- tsailaja 15/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
1754: -----------------------------------------------------------------------------------
1755: l_chk_doc chk_doc%ROWTYPE;
1756:
1757: CURSOR get_cr_resp ( cp_doc_id VARCHAR2) IS
1820: changed_p_lname VARCHAR2(30);
1821: changed_p_dob DATE;
1822:
1823: BEGIN
1824: igf_aw_gen.set_org_id(NULL);
1825: p_doc_id := p_document_id;
1826: l_doc_rej_flg := FALSE;
1827: l_rs_rej_flg := FALSE;
1828: l_as_rej_flg := FALSE;
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
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);
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);
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);
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);
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);
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);
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);
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:
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
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.
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
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);
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);
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:
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
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');
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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;
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:
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
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)
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);
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);
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:
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
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');
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);
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);
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:
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');
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:
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