eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_LAR_CREATION dependencies on FND_FILE

Line 230: fnd_file.put_line(fnd_file.log,fnd_message.get || '-' || SQLERRM);

226: EXCEPTION
227: WHEN OTHERS THEN
228: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
229: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_BORROWER_PARENT_ID');
230: fnd_file.put_line(fnd_file.log,fnd_message.get || '-' || SQLERRM);
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END get_borrower_parent_id;
234:

Line 437: fnd_file.put_line(fnd_file.log,fnd_message.get || '-' || SQLERRM);

433: EXCEPTION
434: WHEN OTHERS THEN
435: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
436: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.POPULATE_COSIGNER_DATA');
437: fnd_file.put_line(fnd_file.log,fnd_message.get || '-' || SQLERRM);
438: igs_ge_msg_stack.add;
439: app_exception.raise_exception;
440: END populate_cosigner_data;
441:

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

598:
599: WHEN OTHERS THEN
600: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
601: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_DL_ENTITY_ID');
602: fnd_file.put_line(fnd_file.log,SQLERRM);
603: igs_ge_msg_stack.add;
604: app_exception.raise_exception;
605:
606: END get_dl_entity_id;

Line 727: fnd_file.new_line(fnd_file.log,1);

723: PROCEDURE log_message(p_award_id igf_aw_award.award_id%TYPE) IS
724: BEGIN
725:
726: IF g_log_start_flag = FALSE THEN
727: fnd_file.new_line(fnd_file.log,1);
728:
729: IF g_log_title IS NULL THEN
730: g_log_title := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','AWARD_ID')||' : ';
731: END IF;

Line 733: fnd_file.put_line(fnd_file.log, g_log_title||TO_CHAR(p_award_id));

729: IF g_log_title IS NULL THEN
730: g_log_title := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','AWARD_ID')||' : ';
731: END IF;
732:
733: fnd_file.put_line(fnd_file.log, g_log_title||TO_CHAR(p_award_id));
734: g_log_start_flag := TRUE;
735: END IF;
736:
737: END log_message;

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

817: END IF;
818: IF (x_return_status = 'E') THEN
819: log_message(award_rec.award_id);
820: fnd_message.set_name('IGF', x_msg_data);
821: fnd_file.put_line(fnd_file.log, fnd_message.get);
822: RAISE SKIP_THIS_RECORD;
823: END IF;
824: lv_loan_number := LPAD(l_ssn,9,'0')
825: || lv_loan_type

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

835: log_message(award_rec.award_id);
836: fnd_message.set_name('IGF','IGF_SL_SSN_IN_USE');
837: fnd_message.set_token('VALUE',award_rec.ssn);
838: fnd_message.set_token('PER_NUM',award_rec.person_number);
839: fnd_file.put_line(fnd_file.log,fnd_message.get);
840: RAISE SKIP_THIS_RECORD;
841: ELSE
842: CLOSE cur_loan_num;
843: END IF;

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

862: END IF;
863: IF (x_return_status = 'E') THEN
864: log_message(award_rec.award_id);
865: fnd_message.set_name('IGF', x_msg_data);
866: fnd_file.put_line(fnd_file.log, fnd_message.get);
867: RAISE SKIP_THIS_RECORD;
868: END IF;
869:
870: -- Bug 3102439. To get SCH_NON_ED_BRC_ID.

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

879: x_sch_non_ed_brc_cd := substr(x_ope_cd,7,2);
880: ELSE
881: log_message(award_rec.award_id);
882: fnd_message.set_name('IGF', x_msg_data);
883: fnd_file.put_line(fnd_file.log, fnd_message.get);
884: RAISE SKIP_THIS_RECORD;
885: END IF;
886: END IF;
887: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

914:
915: WHEN OTHERS THEN
916: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
917: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.RET_LOAN_NUMBER');
918: fnd_file.put_line(fnd_file.log,SQLERRM);
919: igs_ge_msg_stack.add;
920: app_exception.raise_exception;
921:
922: END ret_loan_number;

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

1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1038: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_DL_CL_STD_CODE');
1039: fnd_file.put_line(fnd_file.log,SQLERRM);
1040: igs_ge_msg_stack.add;
1041: app_exception.raise_exception;
1042: END get_dl_cl_std_code ;
1043:

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

1130:
1131: IF lv_class_standing IS NULL OR lv_program_type IS NULL THEN
1132: -- Bug # 5078693 - bvisvana - Message out that Class standing has to be defined.
1133: fnd_message.set_name('IGF','IGF_SL_NO_CLSTND');
1134: fnd_file.put_line(fnd_file.log,fnd_message.get);
1135: RAISE SKIP_THIS_RECORD;
1136: END IF;
1137: -- Call to get the dl_std_code
1138: get_dl_cl_std_code ( p_base_id,

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

1143:
1144: IF lv_dl_std_code IS NULL THEN
1145: -- Bug 5078693 - bvisvana
1146: fnd_message.set_name('IGF','IGF_SL_NO_CLSTND_GRDLVL');
1147: fnd_file.put_line(fnd_file.log,fnd_message.get);
1148: ELSE
1149: p_grd_dl := lv_dl_std_code ;
1150: END IF ;
1151:

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

1151:
1152: IF lv_cl_std_code IS NULL THEN
1153: -- Bug 5078693 - bvisvana
1154: fnd_message.set_name('IGF','IGF_SL_NO_CLSTND_GRDLVL');
1155: fnd_file.put_line(fnd_file.log,fnd_message.get);
1156: ELSE
1157: p_grd_cl := lv_cl_std_code ;
1158: END IF ;
1159:

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

1232: RAISE SKIP_THIS_RECORD;
1233: WHEN OTHERS THEN
1234: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1235: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.GET_FA_BASE_DETAILS');
1236: fnd_file.put_line(fnd_file.log,SQLERRM);
1237: igs_ge_msg_stack.add;
1238: app_exception.raise_exception;
1239: END get_fa_base_details;
1240:

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

1297:
1298: -- bvisvana - Bug 5078761
1299: IF lv_message IS NOT NULL THEN
1300: fnd_message.set_name(substr(lv_message,1,3),lv_message);
1301: fnd_file.put_line(fnd_file.log,fnd_message.get);
1302: END IF;
1303:
1304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_lor_dl_records.debug',' Acad Begin Date :' || lv_acad_begin_date);

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

1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1461: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.INSERT_LOR_DL_RECORDS');
1462: fnd_file.put_line(fnd_file.log,SQLERRM);
1463: igs_ge_msg_stack.add;
1464: app_exception.raise_exception;
1465:
1466: END insert_lor_dl_records;

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

1652: -- FACR116 Grant Loan Changes
1653: IF lv_cl_loan_type = 'AL' THEN
1654: IF award_rec.alt_loan_code IS NULL THEN
1655: fnd_message.set_name('IGF','IGF_AW_NO_ALT_LOAN_CODE');
1656: fnd_file.put_line(fnd_file.log,fnd_message.get);
1657: RAISE SKIP_THIS_RECORD;
1658: END IF;
1659: END IF;
1660:

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

1674:
1675: -- if both the rel_code and party_id is null then raise the exception SKIP_THIS_RECORD
1676: IF l_rel_code IS NULL AND l_party_id IS NULL THEN
1677: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
1678: fnd_file.put_line(fnd_file.log,fnd_message.get);
1679: RAISE SKIP_THIS_RECORD;
1680: END IF;
1681:
1682: -- get the deatils from the igf_sl_cl_setup table for this relationship code and party id

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

1706:
1707: IF (l_disb_count > 4 ) and (c_clsetup_rec.cl_version = 'RELEASE-4') THEN
1708: fnd_message.set_name('IGF','IGF_SL_CL4_NUM_OF_DISB_LOAN');
1709: fnd_message.set_token('LOAN_NUMBER',l_tbh_loans_rec.loan_number); -- bvisvana Bug # 4473160
1710: fnd_file.put_line(fnd_file.log,fnd_message.get);
1711: l_loan_status := 'N';
1712: END IF;
1713:
1714: IF award_rec.fed_fund_code IN ('FLP', 'ALT') THEN -- Check if that is plus/alt loans and get parent id for the same.

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

1972: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_lar_creation.insert_lor_cl_records.exception',SQLERRM);
1973: END IF;
1974: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1975: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.INSERT_LOR_CL_RECORDS');
1976: fnd_file.put_line(fnd_file.log,SQLERRM);
1977: igs_ge_msg_stack.add;
1978: app_exception.raise_exception;
1979:
1980: END insert_lor_cl_records;

Line 2102: fnd_file.put_line(fnd_file.log, loan_title);

2098: SAVEPOINT IGFSL01B_SP2;
2099:
2100: loan_title := igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING') || ' ' || igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', 'LOAN_NUMBER') || ' :' || cur_loan_rec.loan_number;
2101:
2102: fnd_file.put_line(fnd_file.log, loan_title);
2103:
2104: g_adplans_id := cur_loan_rec.adplans_id;
2105: g_person_id := cur_loan_rec.person_id;
2106: g_award_id := cur_loan_rec.award_id;

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

2162: --Bug# 5006583
2163: IF cur_loan_rec.loan_status = 'S' OR (cur_loan_rec.loan_chg_status = 'S') THEN
2164: lb_update := FALSE;
2165: fnd_message.set_name('IGF','IGF_SL_LOAN_UPD_FAIL_SENT');
2166: fnd_file.put_line(fnd_file.log,fnd_message.get);
2167: RAISE SKIP_THIS_RECORD;
2168:
2169: ELSIF (cur_loan_rec.loan_status IN ('C','T')) OR (cur_loan_rec.loan_chg_status IN ('C','T')) THEN
2170: lb_update := FALSE;

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

2169: ELSIF (cur_loan_rec.loan_status IN ('C','T')) OR (cur_loan_rec.loan_chg_status IN ('C','T')) THEN
2170: lb_update := FALSE;
2171: -- print updation failed mesg
2172: fnd_message.set_name('IGF','IGF_SL_LOAN_UPD_FAIL_CANCEL');
2173: fnd_file.put_line(fnd_file.log,fnd_message.get);
2174:
2175: RAISE SKIP_THIS_RECORD;
2176: ELSIF (cur_loan_rec.award_status IN ('CANCELLED')) THEN
2177: lb_update := FALSE;

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

2175: RAISE SKIP_THIS_RECORD;
2176: ELSIF (cur_loan_rec.award_status IN ('CANCELLED')) THEN
2177: lb_update := FALSE;
2178: fnd_message.set_name('IGF','IGF_SL_CL_AW_CANC_SKIP_UPD'); -- print updation failed mesg Since Award is cancelled.
2179: fnd_file.put_line(fnd_file.log, fnd_message.get);
2180:
2181: RAISE SKIP_THIS_RECORD;
2182: ELSE
2183: lb_update := TRUE;

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

2217: IF l_tbh_rec.override_grade_level_code IS NULL THEN
2218: l_tbh_rec.grade_level_code := g_grade_level_cl;
2219: ELSE
2220: fnd_message.set_name('IGF','IGF_SL_CL_GRD_LEVEL_INVALID');
2221: fnd_file.put_line(fnd_file.log, fnd_message.get);
2222: END IF;
2223: -- l_tbh_rec.enrollment_code := g_enrollment_code; -- updating enrollment_code with 'F'
2224: l_tbh_rec.cps_trans_num := gn_transaction_num;
2225: l_tbh_rec.relationship_cd := l_rel_code;

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

2313: lb_update := FALSE;
2314:
2315: -- print updation failed mesg
2316: fnd_message.set_name('IGF','IGF_SL_LOAN_UPD_FAIL');
2317: fnd_file.put_line(fnd_file.log,fnd_message.get);
2318:
2319: RAISE SKIP_THIS_RECORD;
2320: ELSE
2321: lb_update := TRUE;

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

2326:
2327: IF (l_tbh_loans_rec.loan_per_begin_date IS NULL OR l_tbh_loans_rec.loan_per_end_date IS NULL) THEN
2328: fnd_message.set_name('IGF','IGF_SL_ALL_CANCEL_DISB');
2329: fnd_message.set_token('VALUE',cur_loan_rec.award_id);
2330: fnd_file.put_line(fnd_file.log, fnd_message.get);
2331: RAISE SKIP_THIS_RECORD;
2332: END IF;
2333:
2334: IF cur_loan_rec.loan_status = 'A' then

Line 2380: fnd_file.put_line(fnd_file.log, gv_message);

2376: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.update_loan_rec.debug','The values returned from get_dl_entity_id gv_rep_entity_id_txt :' || gv_rep_entity_id_txt);
2377: END IF;
2378: IF gv_return_status = 'E' THEN
2379: log_message(cur_loan_rec.award_id);
2380: fnd_file.put_line(fnd_file.log, gv_message);
2381: RAISE SKIP_THIS_RECORD;
2382: END IF;
2383: l_tbh_rec.atd_entity_id_txt := gv_atd_entity_id_txt;
2384: l_tbh_rec.rep_entity_id_txt := gv_rep_entity_id_txt;

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

2566:
2567: EXCEPTION
2568: WHEN SKIP_THIS_RECORD THEN
2569: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2570: fnd_file.put_line(fnd_file.log, fnd_message.get);
2571: fnd_file.new_line(fnd_file.log,2);
2572: ROLLBACK TO IGFSL01B_SP2;
2573: WHEN OTHERS THEN
2574: -- Bug # 5079098 - This is to handle any exception thrown from other wrappers / proc / func / calls.

Line 2571: fnd_file.new_line(fnd_file.log,2);

2567: EXCEPTION
2568: WHEN SKIP_THIS_RECORD THEN
2569: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2570: fnd_file.put_line(fnd_file.log, fnd_message.get);
2571: fnd_file.new_line(fnd_file.log,2);
2572: ROLLBACK TO IGFSL01B_SP2;
2573: WHEN OTHERS THEN
2574: -- Bug # 5079098 - This is to handle any exception thrown from other wrappers / proc / func / calls.
2575: -- Instead of throwing exception it needs to handled, skipped and continue with further loan records

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

2574: -- Bug # 5079098 - This is to handle any exception thrown from other wrappers / proc / func / calls.
2575: -- Instead of throwing exception it needs to handled, skipped and continue with further loan records
2576: igs_ge_msg_stack.conc_exception_hndl;
2577: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2578: fnd_file.put_line(fnd_file.log, fnd_message.get);
2579: fnd_file.new_line(fnd_file.log,1);
2580: ROLLBACK TO IGFSL01B_SP2;
2581: END;
2582:

Line 2579: fnd_file.new_line(fnd_file.log,1);

2575: -- Instead of throwing exception it needs to handled, skipped and continue with further loan records
2576: igs_ge_msg_stack.conc_exception_hndl;
2577: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2578: fnd_file.put_line(fnd_file.log, fnd_message.get);
2579: fnd_file.new_line(fnd_file.log,1);
2580: ROLLBACK TO IGFSL01B_SP2;
2581: END;
2582:
2583: END LOOP;

Line 2680: fnd_file.put_line(fnd_file.log,g_process_log || ' ' || g_person_log ||' : ' || award_rec_temp.person_number);

2676: BEGIN
2677:
2678: SAVEPOINT IGFSL01B_SP1;
2679:
2680: fnd_file.put_line(fnd_file.log,g_process_log || ' ' || g_person_log ||' : ' || award_rec_temp.person_number);
2681: fnd_file.put_line(fnd_file.log,g_process_log || ' ' || g_award_log || ' : ' || award_rec_temp.award_id);
2682:
2683:
2684: IF award_rec_temp.fed_fund_code IN ('DLP','DLS','DLU') THEN

Line 2681: fnd_file.put_line(fnd_file.log,g_process_log || ' ' || g_award_log || ' : ' || award_rec_temp.award_id);

2677:
2678: SAVEPOINT IGFSL01B_SP1;
2679:
2680: fnd_file.put_line(fnd_file.log,g_process_log || ' ' || g_person_log ||' : ' || award_rec_temp.person_number);
2681: fnd_file.put_line(fnd_file.log,g_process_log || ' ' || g_award_log || ' : ' || award_rec_temp.award_id);
2682:
2683:
2684: IF award_rec_temp.fed_fund_code IN ('DLP','DLS','DLU') THEN
2685: IF NOT p_dl_setup THEN

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

2684: IF award_rec_temp.fed_fund_code IN ('DLP','DLS','DLU') THEN
2685: IF NOT p_dl_setup THEN
2686: IF lb_print_dl THEN
2687: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
2688: fnd_file.put_line(fnd_file.log,fnd_message.get);
2689: lb_print_dl := FALSE;
2690: END IF;
2691: RAISE SKIP_THIS_RECORD;
2692: END IF;

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

2695: IF award_rec_temp.fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') THEN
2696: IF NOT p_cl_setup THEN
2697: IF lb_print_cl THEN
2698: fnd_message.set_name('IGF','IGF_SL_NO_CL_SETUP');
2699: fnd_file.put_line(fnd_file.log,fnd_message.get);
2700: lb_print_cl := FALSE;
2701: END IF;
2702: RAISE SKIP_THIS_RECORD;
2703: END IF;

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

2726: --Error has occured
2727: IF l_aid = 0 THEN
2728: -- Bug 5091652 - Treating no loan limit setup for class standings combinations as error
2729: fnd_message.set_name('IGF',l_msg_name);
2730: fnd_file.put_line(fnd_file.log,fnd_message.get);
2731: RAISE SKIP_THIS_RECORD;
2732: ELSIF l_aid < 0 THEN
2733: -- Get the warning messages for the corresponding error messages. Bug 5064622
2734: -- These messages are to be treated as warnings only.

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

2746: l_msg_name := 'IGF_AW_UNSUB_LMT_WARN';
2747: END IF;
2748: fnd_message.set_name('IGF',l_msg_name);
2749: fnd_message.set_token('FUND_CODE',award_rec_temp.fed_fund_code);
2750: fnd_file.put_line(fnd_file.log,fnd_message.get);
2751: END IF ;
2752: -- RAISE SKIP_THIS_RECORD;
2753: END IF;
2754:

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

2797: IF igf_sl_gen.chk_dl_fed_fund_code(award_rec.fed_fund_code) = 'TRUE' THEN
2798: log_message(award_rec.award_id);
2799: IF gn_transaction_num IS NULL THEN
2800: fnd_message.set_name('IGF','IGF_AP_NOPAYMENT_ISIR');
2801: fnd_file.put_line(fnd_file.log, fnd_message.get);
2802: RAISE SKIP_THIS_RECORD;
2803: END IF;
2804:
2805: -- MN 29-Dec-2004 Call get entity ids Only for Full Participant

Line 2826: fnd_file.put_line(fnd_file.log, gv_message);

2822: END IF;
2823:
2824: IF gv_return_status = 'E' THEN
2825: log_message(award_rec.award_id);
2826: fnd_file.put_line(fnd_file.log, gv_message);
2827: RAISE SKIP_THIS_RECORD;
2828: END IF;
2829: END IF;
2830: IF award_rec.fund_source = 'FEDERAL' AND lv_isir_present = FALSE THEN

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

2830: IF award_rec.fund_source = 'FEDERAL' AND lv_isir_present = FALSE THEN
2831: log_message(award_rec.award_id);
2832: -- Loan application record is not created as there is no Payment ISIR record for this federal loan
2833: fnd_message.set_name('IGF','IGF_SL_FEDLOAN_NO_FABASE');
2834: fnd_file.put_line(fnd_file.log, fnd_message.get);
2835: RAISE SKIP_THIS_RECORD;
2836:
2837: END IF;
2838:

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

2840:
2841: log_message(award_rec.award_id);
2842: fnd_message.set_name('IGF','IGF_SL_NO_SSN_PRESENT');
2843: fnd_message.set_token('VALUE',award_rec.person_number);
2844: fnd_file.put_line(fnd_file.log, fnd_message.get);
2845:
2846: RAISE SKIP_THIS_RECORD;
2847: END IF;
2848:

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

2854:
2855: log_message(award_rec.award_id);
2856: fnd_message.set_name('IGF','IGF_SL_ALL_CANCEL_DISB');
2857: fnd_message.set_token('VALUE',award_rec.award_id);
2858: fnd_file.put_line(fnd_file.log, fnd_message.get);
2859:
2860: RAISE SKIP_THIS_RECORD;
2861: END IF;
2862:

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

2882: IF l_mapping ='N' THEN
2883: log_message(award_rec.award_id);
2884: fnd_message.set_token('PERSON_NUMBER',award_rec.person_number);
2885: fnd_message.set_token('AWARD_YEAR',award_rec.ci_alternate_code);
2886: fnd_file.put_line(fnd_file.log, fnd_message.get);
2887:
2888: RAISE SKIP_THIS_RECORD;
2889:
2890: END IF;

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

2907: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2908: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' g_accepted_amt is not a whole number');
2909: END IF;
2910: fnd_message.set_name('IGF','IGF_AW_ACCEPT_AMT_WHOLE_NUM');
2911: fnd_file.put_line(fnd_file.log, fnd_message.get);
2912: RAISE SKIP_THIS_RECORD;
2913: END IF;
2914:
2915: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2967: fnd_file.put_line(fnd_file.output,RPAD(g_year,40,' ')||': '||award_rec.ci_alternate_code);

2963: END IF;
2964:
2965: --Display Heading in OutputFile
2966: IF l_head <> 'Y' THEN
2967: fnd_file.put_line(fnd_file.output,RPAD(g_year,40,' ')||': '||award_rec.ci_alternate_code);
2968: fnd_message.set_name('IGF','IGF_SL_EFF_DATES');
2969: fnd_message.set_token('EFF_DATES',RPAD(award_rec.ci_start_dt,15,' ')||'-'||LPAD(award_rec.ci_end_dt,15,' '));
2970: fnd_file.put_line(fnd_file.output,fnd_message.get);
2971: fnd_file.new_line(fnd_file.output,1);

Line 2970: fnd_file.put_line(fnd_file.output,fnd_message.get);

2966: IF l_head <> 'Y' THEN
2967: fnd_file.put_line(fnd_file.output,RPAD(g_year,40,' ')||': '||award_rec.ci_alternate_code);
2968: fnd_message.set_name('IGF','IGF_SL_EFF_DATES');
2969: fnd_message.set_token('EFF_DATES',RPAD(award_rec.ci_start_dt,15,' ')||'-'||LPAD(award_rec.ci_end_dt,15,' '));
2970: fnd_file.put_line(fnd_file.output,fnd_message.get);
2971: fnd_file.new_line(fnd_file.output,1);
2972: l_head := 'Y';
2973: END IF;
2974:

Line 2971: fnd_file.new_line(fnd_file.output,1);

2967: fnd_file.put_line(fnd_file.output,RPAD(g_year,40,' ')||': '||award_rec.ci_alternate_code);
2968: fnd_message.set_name('IGF','IGF_SL_EFF_DATES');
2969: fnd_message.set_token('EFF_DATES',RPAD(award_rec.ci_start_dt,15,' ')||'-'||LPAD(award_rec.ci_end_dt,15,' '));
2970: fnd_file.put_line(fnd_file.output,fnd_message.get);
2971: fnd_file.new_line(fnd_file.output,1);
2972: l_head := 'Y';
2973: END IF;
2974:
2975: fnd_file.new_line(fnd_file.output,1);

Line 2975: fnd_file.new_line(fnd_file.output,1);

2971: fnd_file.new_line(fnd_file.output,1);
2972: l_head := 'Y';
2973: END IF;
2974:
2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);

Line 2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);

2972: l_head := 'Y';
2973: END IF;
2974:
2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);

Line 2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);

2973: END IF;
2974:
2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);
2981:

Line 2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);

2974:
2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);
2981:
2982: -- Reassign Y that loan records are found

Line 2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);

2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);
2981:
2982: -- Reassign Y that loan records are found
2983: IF l_found_loans <> 'Y' THEN

Line 2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);

2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);
2981:
2982: -- Reassign Y that loan records are found
2983: IF l_found_loans <> 'Y' THEN
2984: l_found_loans := 'Y';

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

2987: EXCEPTION
2988:
2989: WHEN SKIP_THIS_RECORD THEN
2990: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2991: fnd_file.put_line(fnd_file.log, fnd_message.get);
2992: fnd_file.new_line(fnd_file.log,2);
2993: ROLLBACK TO IGFSL01B_SP1;
2994: END;
2995:

Line 2992: fnd_file.new_line(fnd_file.log,2);

2988:
2989: WHEN SKIP_THIS_RECORD THEN
2990: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
2991: fnd_file.put_line(fnd_file.log, fnd_message.get);
2992: fnd_file.new_line(fnd_file.log,2);
2993: ROLLBACK TO IGFSL01B_SP1;
2994: END;
2995:
2996: END LOOP;

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

3000:
3001: IF l_found_loans ='Y' THEN
3002: --Loan Application Records created
3003: fnd_message.set_name('IGF','IGF_SL_LOANS_CREATED');
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);
3005: fnd_file.new_line(fnd_file.log,2);
3006: ELSIF l_found_loans ='N' THEN
3007: --Loan Application not created
3008: fnd_message.set_name('IGF','IGF_SL_NO_LOANS');

Line 3005: fnd_file.new_line(fnd_file.log,2);

3001: IF l_found_loans ='Y' THEN
3002: --Loan Application Records created
3003: fnd_message.set_name('IGF','IGF_SL_LOANS_CREATED');
3004: fnd_file.put_line(fnd_file.log,fnd_message.get);
3005: fnd_file.new_line(fnd_file.log,2);
3006: ELSIF l_found_loans ='N' THEN
3007: --Loan Application not created
3008: fnd_message.set_name('IGF','IGF_SL_NO_LOANS');
3009: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

3005: fnd_file.new_line(fnd_file.log,2);
3006: ELSIF l_found_loans ='N' THEN
3007: --Loan Application not created
3008: fnd_message.set_name('IGF','IGF_SL_NO_LOANS');
3009: fnd_file.put_line(fnd_file.log,fnd_message.get);
3010: fnd_file.new_line(fnd_file.log,2);
3011: END IF;
3012:
3013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3010: fnd_file.new_line(fnd_file.log,2);

3006: ELSIF l_found_loans ='N' THEN
3007: --Loan Application not created
3008: fnd_message.set_name('IGF','IGF_SL_NO_LOANS');
3009: fnd_file.put_line(fnd_file.log,fnd_message.get);
3010: fnd_file.new_line(fnd_file.log,2);
3011: END IF;
3012:
3013: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3014: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.insert_loan_records.debug',' End of create_loan_records ');

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

3018:
3019: WHEN OTHERS THEN
3020: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3021: fnd_message.set_token('NAME','IGF_SL_LAR_CREATION.create_loan_records');
3022: fnd_file.put_line(fnd_file.log,SQLERRM);
3023: igs_ge_msg_stack.add;
3024: app_exception.raise_exception;
3025:
3026: END create_loan_records;

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

3298: IF cur_alternate_code%NOTFOUND THEN
3299: CLOSE cur_alternate_code;
3300: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
3301: igs_ge_msg_stack.add;
3302: fnd_file.put_line(fnd_file.log,fnd_message.get);
3303:
3304: RAISE NO_DATA_FOUND;
3305: END IF;
3306: CLOSE cur_alternate_code;

Line 3331: fnd_file.new_line(fnd_file.log,2);

3327: g_process_log := l_para_rec(8);
3328: g_award_log := l_para_rec(1);
3329: g_person_log := l_para_rec(7);
3330: g_year := l_para_rec(2);
3331: fnd_file.new_line(fnd_file.log,2);
3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));

Line 3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));

3328: g_award_log := l_para_rec(1);
3329: g_person_log := l_para_rec(7);
3330: g_year := l_para_rec(2);
3331: fnd_file.new_line(fnd_file.log,2);
3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber

Line 3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);

3329: g_person_log := l_para_rec(7);
3330: g_year := l_para_rec(2);
3331: fnd_file.new_line(fnd_file.log,2);
3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);

Line 3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));

3330: g_year := l_para_rec(2);
3331: fnd_file.new_line(fnd_file.log,2);
3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));

Line 3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));

3331: fnd_file.new_line(fnd_file.log,2);
3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));
3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

Line 3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber

3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));
3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
3340: fnd_file.new_line(fnd_file.log,2);

Line 3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);

3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));
3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
3340: fnd_file.new_line(fnd_file.log,2);
3341:

Line 3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));

3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));
3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
3340: fnd_file.new_line(fnd_file.log,2);
3341:
3342:

Line 3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));

3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));
3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
3340: fnd_file.new_line(fnd_file.log,2);
3341:
3342:
3343: -- check if parameters passed are valid ot not

Line 3340: fnd_file.new_line(fnd_file.log,2);

3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));
3339: fnd_file.put_line(fnd_file.log,RPAD('-',50,'-'));
3340: fnd_file.new_line(fnd_file.log,2);
3341:
3342:
3343: -- check if parameters passed are valid ot not
3344: OPEN cur_check_fund_award(p_base_id, p_award_id, p_fund_id,p_ci_cal_type,p_ci_sequence_number);

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

3345: FETCH cur_check_fund_award INTO check_fund_award_rec;
3346: IF cur_check_fund_award%NOTFOUND THEN
3347: CLOSE cur_check_fund_award;
3348: fnd_message.set_name ('IGF','IGF_SL_NO_LOAN_AWARDS');
3349: fnd_file.put_line(fnd_file.log, fnd_message.get);
3350: fnd_file.new_line(fnd_file.log, 1);
3351: RETURN;
3352: ELSE
3353: CLOSE cur_check_fund_award;

Line 3350: fnd_file.new_line(fnd_file.log, 1);

3346: IF cur_check_fund_award%NOTFOUND THEN
3347: CLOSE cur_check_fund_award;
3348: fnd_message.set_name ('IGF','IGF_SL_NO_LOAN_AWARDS');
3349: fnd_file.put_line(fnd_file.log, fnd_message.get);
3350: fnd_file.new_line(fnd_file.log, 1);
3351: RETURN;
3352: ELSE
3353: CLOSE cur_check_fund_award;
3354: END IF;

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

3386: ( igf_gr_gen.get_per_num(p_base_id) IS NULL OR
3387: NOT check_fa_rec(p_base_id, p_ci_cal_type, p_ci_sequence_number))
3388: THEN
3389: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
3390: fnd_file.put_line(fnd_file.log, fnd_message.get);
3391: fnd_file.new_line(fnd_file.log, 1);
3392: RETURN;
3393: END IF;
3394: -- FA134

Line 3391: fnd_file.new_line(fnd_file.log, 1);

3387: NOT check_fa_rec(p_base_id, p_ci_cal_type, p_ci_sequence_number))
3388: THEN
3389: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
3390: fnd_file.put_line(fnd_file.log, fnd_message.get);
3391: fnd_file.new_line(fnd_file.log, 1);
3392: RETURN;
3393: END IF;
3394: -- FA134
3395: IF p_dyn_pid_grp IS NOT NULL THEN

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

3397: FETCH cur_chk_pidgroup INTO chk_pidgroup_rec;
3398: CLOSE cur_chk_pidgroup;
3399: IF chk_pidgroup_rec.group_id IS NULL THEN
3400: fnd_message.set_name('IGF','IGF_SL_COD_PERSID_GRP_INV');
3401: fnd_file.put_line(fnd_file.log, fnd_message.get);
3402: fnd_file.new_line(fnd_file.log, 1);
3403: RETURN;
3404: END IF;
3405: END IF;

Line 3402: fnd_file.new_line(fnd_file.log, 1);

3398: CLOSE cur_chk_pidgroup;
3399: IF chk_pidgroup_rec.group_id IS NULL THEN
3400: fnd_message.set_name('IGF','IGF_SL_COD_PERSID_GRP_INV');
3401: fnd_file.put_line(fnd_file.log, fnd_message.get);
3402: fnd_file.new_line(fnd_file.log, 1);
3403: RETURN;
3404: END IF;
3405: END IF;
3406: -- FA134

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

3408: IF p_dyn_pid_grp IS NOT NULL AND p_base_id IS NOT NULL THEN
3409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
3412: fnd_file.put_line(fnd_file.log, fnd_message.get);
3413: fnd_file.new_line(fnd_file.log, 1);
3414: RETURN;
3415: END IF;
3416:

Line 3413: fnd_file.new_line(fnd_file.log, 1);

3409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
3412: fnd_file.put_line(fnd_file.log, fnd_message.get);
3413: fnd_file.new_line(fnd_file.log, 1);
3414: RETURN;
3415: END IF;
3416:
3417: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3421: IF p_dyn_pid_grp IS NOT NULL AND p_award_id IS NOT NULL THEN
3422: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3423: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3424: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
3425: fnd_file.put_line(fnd_file.log, fnd_message.get);
3426: fnd_file.new_line(fnd_file.log, 1);
3427: RETURN;
3428: END IF;
3429: -- FA134

Line 3426: fnd_file.new_line(fnd_file.log, 1);

3422: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3423: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3424: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
3425: fnd_file.put_line(fnd_file.log, fnd_message.get);
3426: fnd_file.new_line(fnd_file.log, 1);
3427: RETURN;
3428: END IF;
3429: -- FA134
3430:

Line 3447: fnd_file.new_line(fnd_file.log, 1);

3443: IF p_dyn_pid_grp IS NOT NULL THEN
3444:
3445: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
3446: fnd_message.set_token('P_PER_GRP',get_grp_name(p_dyn_pid_grp));
3447: fnd_file.new_line(fnd_file.log, 1);
3448: fnd_file.put_line(fnd_file.log, fnd_message.get);
3449:
3450: --Bug #5021084
3451: l_list := igf_ap_ss_pkg.get_pid( p_dyn_pid_grp,lv_status,lv_group_type);

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

3444:
3445: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
3446: fnd_message.set_token('P_PER_GRP',get_grp_name(p_dyn_pid_grp));
3447: fnd_file.new_line(fnd_file.log, 1);
3448: fnd_file.put_line(fnd_file.log, fnd_message.get);
3449:
3450: --Bug #5021084
3451: l_list := igf_ap_ss_pkg.get_pid( p_dyn_pid_grp,lv_status,lv_group_type);
3452:

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

3465:
3466: IF cur_per_grp%NOTFOUND THEN
3467: CLOSE cur_per_grp;
3468: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
3469: fnd_file.put_line(fnd_file.log,fnd_message.get);
3470: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3471: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','No persons in group '|| p_dyn_pid_grp);
3472: END IF;
3473: ELSE

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

3480: IF lv_person_number IS NOT NULL THEN
3481: IF ln_base_id IS NOT NULL THEN
3482: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3483: fnd_message.set_token('STDNT',lv_person_number);
3484: fnd_file.put_line(fnd_file.log, fnd_message.get);
3485: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3486: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','PIDG base id ' || ln_base_id);
3487: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','PIDG lv_person_number ' || lv_person_number);
3488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','PIDG l_person_id ' || l_person_id);

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

3494: ELSE -- log a message and skip this person, base id not found
3495: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
3496: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
3497: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(p_ci_cal_type,p_ci_sequence_number));
3498: fnd_file.put_line(fnd_file.log,fnd_message.get);
3499: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3500: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
3501: END IF;
3502: END IF; -- base id not found

Line 3505: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);

3501: END IF;
3502: END IF; -- base id not found
3503: ELSE
3504: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3505: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
3506: END IF; -- person number not null
3507:
3508: FETCH cur_per_grp INTO l_person_id;
3509: EXIT WHEN cur_per_grp%NOTFOUND;

Line 3512: fnd_file.new_line(fnd_file.log, 1);

3508: FETCH cur_per_grp INTO l_person_id;
3509: EXIT WHEN cur_per_grp%NOTFOUND;
3510: END LOOP;
3511: IF NOT lb_record_exist THEN
3512: fnd_file.new_line(fnd_file.log, 1);
3513: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_AWARDS');--
3514: fnd_file.put_line(fnd_file.log, fnd_message.get);
3515: fnd_file.new_line(fnd_file.log, 1);
3516: RETURN;

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

3510: END LOOP;
3511: IF NOT lb_record_exist THEN
3512: fnd_file.new_line(fnd_file.log, 1);
3513: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_AWARDS');--
3514: fnd_file.put_line(fnd_file.log, fnd_message.get);
3515: fnd_file.new_line(fnd_file.log, 1);
3516: RETURN;
3517: END IF;
3518: CLOSE cur_per_grp;

Line 3515: fnd_file.new_line(fnd_file.log, 1);

3511: IF NOT lb_record_exist THEN
3512: fnd_file.new_line(fnd_file.log, 1);
3513: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_AWARDS');--
3514: fnd_file.put_line(fnd_file.log, fnd_message.get);
3515: fnd_file.new_line(fnd_file.log, 1);
3516: RETURN;
3517: END IF;
3518: CLOSE cur_per_grp;
3519: END IF; -- group found

Line 3543: fnd_file.new_line(fnd_file.log, 1);

3539: IF p_dyn_pid_grp IS NOT NULL THEN
3540:
3541: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
3542: fnd_message.set_token('P_PER_GRP',get_grp_name( p_dyn_pid_grp));
3543: fnd_file.new_line(fnd_file.log, 1);
3544: fnd_file.put_line(fnd_file.log, fnd_message.get);
3545:
3546: --Bug #5021084
3547: l_list := NULL;

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

3540:
3541: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
3542: fnd_message.set_token('P_PER_GRP',get_grp_name( p_dyn_pid_grp));
3543: fnd_file.new_line(fnd_file.log, 1);
3544: fnd_file.put_line(fnd_file.log, fnd_message.get);
3545:
3546: --Bug #5021084
3547: l_list := NULL;
3548: lv_group_type := NULL;

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

3563:
3564: IF cur_per_grp%NOTFOUND THEN
3565: CLOSE cur_per_grp;
3566: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
3567: fnd_file.put_line(fnd_file.log,fnd_message.get);
3568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3569: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','No persons in group '|| p_dyn_pid_grp);
3570: END IF;
3571: ELSE

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

3578: IF lv_person_number IS NOT NULL THEN
3579: IF ln_base_id IS NOT NULL THEN
3580: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3581: fnd_message.set_token('STDNT',lv_person_number);
3582: fnd_file.put_line(fnd_file.log, fnd_message.get);
3583: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','PIDG base id ' || ln_base_id);
3585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','PIDG lv_person_number ' || lv_person_number);
3586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','PIDG l_person_id ' || l_person_id);

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

3592: ELSE -- log a message and skip this person, base id not found
3593: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
3594: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
3595: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(p_ci_cal_type,p_ci_sequence_number));
3596: fnd_file.put_line(fnd_file.log,fnd_message.get);
3597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
3599: END IF;
3600: END IF; -- base id not found

Line 3603: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);

3599: END IF;
3600: END IF; -- base id not found
3601: ELSE
3602: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3603: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
3604: END IF; -- person number not null
3605:
3606: FETCH cur_per_grp INTO l_person_id;
3607: EXIT WHEN cur_per_grp%NOTFOUND;

Line 3610: fnd_file.new_line(fnd_file.log, 1);

3606: FETCH cur_per_grp INTO l_person_id;
3607: EXIT WHEN cur_per_grp%NOTFOUND;
3608: END LOOP;
3609: IF NOT lb_record_exist THEN
3610: fnd_file.new_line(fnd_file.log, 1);
3611: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_AWARDS');--
3612: fnd_file.put_line(fnd_file.log, fnd_message.get);
3613: fnd_file.new_line(fnd_file.log, 1);
3614: RETURN;

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

3608: END LOOP;
3609: IF NOT lb_record_exist THEN
3610: fnd_file.new_line(fnd_file.log, 1);
3611: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_AWARDS');--
3612: fnd_file.put_line(fnd_file.log, fnd_message.get);
3613: fnd_file.new_line(fnd_file.log, 1);
3614: RETURN;
3615: END IF;
3616: CLOSE cur_per_grp;

Line 3613: fnd_file.new_line(fnd_file.log, 1);

3609: IF NOT lb_record_exist THEN
3610: fnd_file.new_line(fnd_file.log, 1);
3611: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_AWARDS');--
3612: fnd_file.put_line(fnd_file.log, fnd_message.get);
3613: fnd_file.new_line(fnd_file.log, 1);
3614: RETURN;
3615: END IF;
3616: CLOSE cur_per_grp;
3617: END IF; -- group found

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

3629: WHEN OTHERS THEN
3630: ROLLBACK;
3631: retcode :=2;
3632: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
3633: fnd_file.put_line(fnd_file.log,SQLERRM);
3634: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3635: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_lar_creation.main.debug','SLQERRM ' || SQLERRM);
3636: END IF;
3637: igs_ge_msg_stack.conc_exception_hndl;