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

Line 181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:
181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
184:
185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

Line 182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:
181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
184:
185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed

Line 183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:
181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
184:
185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

Line 185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
184:
185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
188:
189: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;

Line 186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed

182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
184:
185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
188:
189: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
190:

Line 187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;

183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
184:
185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
188:
189: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
190:
191: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;

Line 189: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;

185: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
186: FND_FILE.PUT_LINE( FND_FILE.LOG, l_params_pass_prmpt) ; --Parameters Passed
187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
188:
189: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
190:
191: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
192:
193:

Line 191: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;

187: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ') ;
188:
189: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_award_year_pmpt, 40) || ' : '|| p_alternate_code ) ;
190:
191: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
192:
193:
194: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
195: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

Line 194: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;

190:
191: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
192:
193:
194: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
195: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
196: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
197: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
198:

Line 195: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

191: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_batch_num_prmpt, 40) || ' : '|| p_batch_num || '-' || l_batch_desc ) ;
192:
193:
194: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
195: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
196: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
197: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
198:
199: END log_input_params ;

Line 196: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

192:
193:
194: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
195: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
196: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
197: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
198:
199: END log_input_params ;
200:

Line 197: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

193:
194: FND_FILE.PUT_LINE( FND_FILE.LOG, RPAD( l_delete_flag_prmpt, 40) || ' : '|| l_yes_no ) ;
195: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
196: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
197: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
198:
199: END log_input_params ;
200:
201: PROCEDURE print_message(p_igf_sl_message_table IN igf_sl_message_table) AS

Line 219: fnd_file.put_line(fnd_file.log,p_igf_sl_message_table(indx).msg_text);

215: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
216: IF p_igf_sl_message_table.COUNT<>0 THEN
217: FOR indx IN p_igf_sl_message_table.FIRST..p_igf_sl_message_table.LAST
218: LOOP
219: fnd_file.put_line(fnd_file.log,p_igf_sl_message_table(indx).msg_text);
220: END LOOP;
221: END IF;
222: EXCEPTION
223: WHEN others THEN

Line 229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);
226: END IF;
227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');
229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
230:
231: RAISE IMPORT_ERROR;
232:
233: END print_message;

Line 1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);
1065: END IF;
1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1069:
1070: RAISE IMPORT_ERROR;
1071:
1072: END validate_loan_disb;

Line 1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);
1651: END IF;
1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1655:
1656: RAISE IMPORT_ERROR;
1657:
1658: END validate_loan_orig_int;

Line 1700: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1699: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_INSERT_ROW');
1700: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1701:
1702: RAISE IMPORT_ERROR;
1703: END loans_insert_row;
1704:

Line 1872: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1871: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_INSERT_ROW');
1872: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1873:
1874: RAISE IMPORT_ERROR;
1875: END loans_orig_insert_row;
1876:

Line 2213: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2209: EXCEPTION
2210: WHEN OTHERS THEN
2211: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2212: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_LOC_INSERT_ROW');
2213: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2214:
2215: RAISE IMPORT_ERROR;
2216:
2217: END loans_orig_loc_insert_row;

Line 2255: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2254: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_RESP_INSERT_ROW');
2255: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2256:
2257: RAISE IMPORT_ERROR;
2258:
2259: END lor_resp_insert_row;

Line 2295: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2294: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_CRRESP_INSERT_ROW');
2295: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2296:
2297: RAISE IMPORT_ERROR;
2298:
2299: END lor_crresp_insert_row;

Line 2334: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2330: EXCEPTION
2331: WHEN OTHERS THEN
2332: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2333: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_RESP_INSERT_ROW');
2334: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2335:
2336: RAISE IMPORT_ERROR;
2337:
2338: END pnote_resp_insert_row;

Line 2505: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_INSERT_ROW');
2505: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2506:
2507: RAISE IMPORT_ERROR;
2508:
2509: END pnote_insert_row;

Line 2567: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2566: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DISB_RESP_INSERT_ROW');
2567: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2568:
2569: RAISE IMPORT_ERROR;
2570:
2571: END disb_resp_insert_row;

Line 2650: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2646: EXCEPTION
2647: WHEN OTHERS THEN
2648: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2649: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DB_AWD_DISB_UPDATE_ROW');
2650: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2651:
2652: RAISE IMPORT_ERROR;
2653:
2654: END db_awd_disb_update_row;

Line 2687: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2686: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_SEND_INSERT_ROW');
2687: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2688:
2689: RAISE IMPORT_ERROR;
2690:
2691: END dl_chg_send_insert_row;

Line 2727: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2723: EXCEPTION
2724: WHEN OTHERS THEN
2725: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2726: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_RESP_INSERT_ROW');
2727: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2728:
2729: RAISE IMPORT_ERROR;
2730:
2731: END dl_chg_resp_insert_row;

Line 2814: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2810: EXCEPTION
2811: WHEN OTHERS THEN
2812: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2813: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_BATCH_INSERT_ROW');
2814: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2815:
2816: RAISE IMPORT_ERROR;
2817:
2818: END dl_batch_insert_row;

Line 2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);

2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);
2991: END IF;
2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');
2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
2995:
2996: RAISE IMPORT_ERROR;
2997:
2998: END delete_context_records;

Line 3065: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

3061: EXCEPTION
3062: WHEN OTHERS THEN
3063: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3064: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_RECORDS');
3065: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3066: RAISE IMPORT_ERROR;
3067:
3068: END insert_context_records;
3069:

Line 3094: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3093: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_DISB_RECORDS');
3094: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3095:
3096: RAISE IMPORT_ERROR;
3097:
3098: END insert_context_disb_records;

Line 3383: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3379: l_chk_profile := igf_ap_gen.check_profile;
3380:
3381: IF l_chk_profile = 'N' THEN
3382: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
3383: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3384: RETURN;
3385: END IF;
3386:
3387: -- Check If the Batch Entered is Valid or Not. If not Valid then error out

Line 3393: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3389: IF NVL(l_batch_valid,'N') <> 'Y' THEN
3390: -- Bug # 4008991
3391: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');
3392: fnd_message.set_token('BATCH_ID',p_batch_id);
3393: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3394: RETURN;
3395: END IF;
3396:
3397: -- Check If the Award Year Entered is Valid or Not. If not Valid then error out

Line 3402: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3398: OPEN c_award_det(l_cal_type,l_seq_number);
3399: FETCH c_award_det INTO l_award_det;
3400: IF c_award_det%NOTFOUND THEN
3401: fnd_message.set_name('IGF','IGF_AP_AWD_YR_NOT_FOUND');
3402: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3403: CLOSE c_award_det;
3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN
3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');

Line 3408: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN
3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
3407: fnd_message.set_token('AWARD_STATUS',l_award_det.status);
3408: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3409: CLOSE c_award_det;
3410: RETURN;
3411: ELSE
3412: CLOSE c_award_det;

Line 3452: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_person_number||' '||l_interface.person_number);

3448: -- Initialize lb_write_log for writing into debug log table
3449: IF fnd_log.TEST(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG') THEN
3450: lb_write_log := TRUE;
3451: END IF;
3452: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_person_number||' '||l_interface.person_number);
3453: fnd_file.new_line(fnd_file.log,1);
3454: -- check if person exists in oss
3455: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
3456: l_debug_str := l_debug_str ||' Processing for person number ' || l_interface.person_number;

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

3449: IF fnd_log.TEST(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG') THEN
3450: lb_write_log := TRUE;
3451: END IF;
3452: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_person_number||' '||l_interface.person_number);
3453: fnd_file.new_line(fnd_file.log,1);
3454: -- check if person exists in oss
3455: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
3456: l_debug_str := l_debug_str ||' Processing for person number ' || l_interface.person_number;
3457: IF lv_person_id IS NULL THEN

Line 3459: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3455: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
3456: l_debug_str := l_debug_str ||' Processing for person number ' || l_interface.person_number;
3457: IF lv_person_id IS NULL THEN
3458: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3459: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3460: l_valid_for_dml := 'N' ;
3461: l_error_flag := TRUE;
3462: END IF;
3463: l_debug_str := l_debug_str || 'check if person exists in oss- completed';

Line 3468: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3464: -- check if Base record exists in oss
3465:
3466: IF lv_base_id IS NULL THEN
3467: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
3468: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3469: l_valid_for_dml := 'N' ;
3470: l_error_flag := TRUE;
3471: END IF;
3472:

Line 3475: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_loan_id_msg||' '||l_interface.loan_number_txt);

3471: END IF;
3472:
3473: l_debug_str := l_debug_str || 'check if Base record exists in oss - completed';
3474: l_debug_str := l_debug_str || 'Processing for loan number '|| l_interface.loan_number_txt ;
3475: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_loan_id_msg||' '||l_interface.loan_number_txt);
3476: fnd_file.new_line(fnd_file.log,1);
3477:
3478: -- FA 149 Enhancements
3479: -- Check if the award year is COD-XML or not

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

3472:
3473: l_debug_str := l_debug_str || 'check if Base record exists in oss - completed';
3474: l_debug_str := l_debug_str || 'Processing for loan number '|| l_interface.loan_number_txt ;
3475: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_loan_id_msg||' '||l_interface.loan_number_txt);
3476: fnd_file.new_line(fnd_file.log,1);
3477:
3478: -- FA 149 Enhancements
3479: -- Check if the award year is COD-XML or not
3480: IF (igf_sl_dl_validation.check_full_participant(l_cal_type,l_seq_number,'DL')) THEN

Line 3484: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3480: IF (igf_sl_dl_validation.check_full_participant(l_cal_type,l_seq_number,'DL')) THEN
3481: -- Incase of COD-XML award year support loans with ready to send status
3482: IF l_interface.loan_status_code <> 'G' THEN
3483: fnd_message.set_name('IGF','IGF_SL_STATUS_NOT_RDY');
3484: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3485: l_valid_for_dml := 'N' ;
3486: l_error_flag := TRUE;
3487: END IF;
3488:

Line 3493: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3489: -- Attending and Reporting Pell entity ids must not be null and their combination should be valid
3490:
3491: IF (l_interface.atd_entity_id_txt IS NULL) OR (l_interface.rep_entity_id_txt IS NULL ) THEN
3492: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');
3493: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3494: l_valid_for_dml := 'N' ;
3495: l_error_flag := TRUE;
3496:
3497: ELSE

Line 3504: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3500: FETCH c_atd_rep_comb INTO atd_rep_comb_rec;
3501:
3502: IF c_atd_rep_comb%NOTFOUND THEN
3503: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');
3504: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3505: l_valid_for_dml := 'N' ;
3506: l_error_flag := TRUE;
3507: END IF;
3508: CLOSE c_atd_rep_comb;

Line 3515: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3511: -- Transaction number must have a not null value between 1 and 99
3512: IF (l_interface.transaction_num IS NULL) OR (l_interface.transaction_num < 1 ) OR (l_interface.transaction_num > 99) THEN
3513: fnd_message.set_name('IGF','IGF_AP_TRANS_NUM_INVLD');
3514: fnd_message.set_token('TRNM',l_interface.transaction_num);
3515: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3516: l_valid_for_dml := 'N' ;
3517: l_error_flag := TRUE;
3518: ELSE
3519: -- Person should have an ISIR with the said transaction number

Line 3526: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3522:
3523: IF c_chk_isir_dtls%NOTFOUND THEN
3524: fnd_message.set_name('IGF','IGF_AP_ISIR_DTLS_NOT_FOUND');
3525: fnd_message.set_token('STUD',l_interface.person_number);
3526: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3527: l_valid_for_dml := 'N' ;
3528: l_error_flag := TRUE;
3529: END IF;
3530:

Line 3544: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3540: FETCH c_award_ref INTO l_award_ref;
3541: IF (c_award_ref%NOTFOUND) THEN
3542: CLOSE c_award_ref;
3543: fnd_message.set_name('IGF','IGF_SL_CL_LI_NO_AW_REF');
3544: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3545: l_valid_for_dml := 'N' ;
3546: l_error_flag := TRUE;
3547: ELSE
3548: CLOSE c_award_ref;

Line 3552: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3548: CLOSE c_award_ref;
3549: l_award_id := l_award_ref.award_id;
3550: IF l_award_ref.award_status = 'CANCELLED' THEN
3551: fnd_message.set_name('IGF','IGF_SL_TERMINATED_LOAN');
3552: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3553: l_valid_for_dml := 'N' ;
3554: l_error_flag := TRUE;
3555: l_award_id := l_award_ref.award_id;
3556: ELSE

Line 3571: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3567: FETCH c_act_isir INTO l_act_isir;
3568: IF (c_act_isir%NOTFOUND) THEN
3569: CLOSE c_act_isir;
3570: fnd_message.set_name('IGF','IGF_AP_PAY_ISIR_EXCEED_ONE');
3571: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3572: l_valid_for_dml := 'N' ;
3573: l_error_flag := TRUE;
3574: ELSE
3575: CLOSE c_act_isir;

Line 3587: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3583: FETCH c_fed_fund_code INTO l_fed_fund_code;
3584: CLOSE c_fed_fund_code;
3585: IF l_fed_fund_code.fed_fund_code IS NULL OR l_fed_fund_code.fed_fund_code NOT IN ('DLP','DLU','DLS') THEN
3586: fnd_message.set_name('IGF','IGF_SL_CL_INV_FED_FND_CD');
3587: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3588: l_valid_for_dml := 'N' ;
3589: l_error_flag := TRUE;
3590: ELSE
3591: lv_fed_fund_code := l_fed_fund_code.fed_fund_code ;

Line 3600: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3596:
3597: IF l_fed_fund_code.fed_fund_code = 'DLP' THEN
3598: IF l_interface.borr_person_number IS NULL THEN
3599: fnd_message.set_name('IGF','IGF_SL_CL_BOR_NUM_REQD');
3600: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3601: l_valid_for_dml := 'N' ;
3602: l_error_flag := TRUE;
3603: ELSE
3604: OPEN c_relationship(l_interface.person_number,l_interface.borr_person_number);

Line 3609: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3605: FETCH c_relationship INTO l_relationship;
3606:
3607: IF (c_relationship%NOTFOUND) THEN
3608: fnd_message.set_name('IGF','IGF_SL_CL_INV_BOR_REL');
3609: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3610: l_valid_for_dml := 'N' ;
3611: l_error_flag := TRUE;
3612:
3613: -- Fetch the Borrow person ID to check if party exists

Line 3619: fnd_file.put_line(fnd_file.log, RPAD(l_error,12) || g_error_string|| ' ' || 'BORR_PERSON_NUMBER' ||' ' ||fnd_message.get);

3615: FETCH c_person_id INTO l_b_person_id;
3616: CLOSE c_person_id;
3617: IF l_b_person_id IS NULL THEN
3618: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3619: fnd_file.put_line(fnd_file.log, RPAD(l_error,12) || g_error_string|| ' ' || 'BORR_PERSON_NUMBER' ||' ' ||fnd_message.get);
3620: END IF;
3621:
3622: CLOSE c_relationship;
3623: ELSE

Line 3635: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3631: END IF;
3632: ELSE
3633: IF l_interface.borr_person_number IS NOT NULL THEN
3634: fnd_message.set_name('IGF','IGF_SL_CL_BORW_NOT_REQD');
3635: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3636: l_valid_for_dml := 'N' ;
3637: l_error_flag := TRUE;
3638: END IF;
3639: END IF;

Line 3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3683: l_error_flag := TRUE;
3684: fnd_message.set_name('IGF','IGF_SL_DISB_SEQ_NO_EXIST');
3685: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3686: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3688: p_d_status := FALSE;
3689: p_d_status2 := FALSE;
3690: ELSE
3691: -- Validate Disbursement record

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

3695:
3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');
3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3699: fnd_file.put_line(fnd_file.log, fnd_message.get);
3700: fnd_file.new_line(fnd_file.log,1);
3701: validate_loan_disb( l_disb_interface,l_award_id, p_d_status,g_igf_sl_message_table);
3702:
3703: IF p_d_status = FALSE THEN

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

3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');
3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3699: fnd_file.put_line(fnd_file.log, fnd_message.get);
3700: fnd_file.new_line(fnd_file.log,1);
3701: validate_loan_disb( l_disb_interface,l_award_id, p_d_status,g_igf_sl_message_table);
3702:
3703: IF p_d_status = FALSE THEN
3704: p_d_status2 := FALSE;

Line 3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3730: l_error_flag := TRUE;
3731: fnd_message.set_name('IGF','IGF_SL_AC_DISB_SEQ_NO_EXIST');
3732: fnd_message.set_token('DISB_NUM',l_int_disb_rec.disb_num);
3733: fnd_message.set_token('SEQ_NUM',l_int_disb_rec.disb_seq_num);
3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3735: ELSE
3736: CLOSE c_int_disb_rec;
3737: END IF;
3738: END IF;

Line 3751: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3747: FETCH c_chk_loan INTO l_chk_loan;
3748: CLOSE c_chk_loan;
3749: IF l_chk_loan.award_id <> l_award_id THEN
3750: fnd_message.set_name('IGF','IGF_SL_DUP_LOAN');
3751: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3752: l_error_flag := TRUE;
3753: END IF;
3754:
3755: IF NOT l_error_flag THEN

Line 3764: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3760: -- check loan exists
3761: IF (c_chk_loan_exist%NOTFOUND) THEN
3762: CLOSE c_chk_loan_exist;
3763: fnd_message.set_name('IGF','IGF_AP_ORIG_REC_NOT_FOUND');
3764: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3765: l_error_flag := TRUE;
3766: ELSE
3767: CLOSE c_chk_loan_exist;
3768: lv_loan_id := l_chk_loan_exist.loan_id;

Line 3775: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3771: l_legacy_flag := l_chk_loan_exist.legacy_record_flag;
3772: -- if record exists and legacy flag is not set then error out
3773: IF (lv_flag_lo = TRUE) AND (NVL(l_legacy_flag,'N') = 'N') THEN
3774: fnd_message.set_name('IGF','IGF_SL_CL_UPD_OPEN');
3775: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3776: l_error_flag := TRUE;
3777: ELSE
3778:
3779: delete_context_records(lv_loan_id,lv_loan_num,lv_rowid);

Line 3799: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3795: FETCH c_chk_loan_exist INTO l_chk_loan_exist;
3796: IF (c_chk_loan_exist%FOUND) THEN
3797: CLOSE c_chk_loan_exist;
3798: fnd_message.set_name('IGF','IGF_SL_CL_RECORD_EXIST');
3799: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3800: l_error_flag := TRUE;
3801: ELSE
3802: CLOSE c_chk_loan_exist;
3803: lv_loan_id := l_chk_loan_exist.loan_id;

Line 3823: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);

3819: EXCEPTION
3820: WHEN IMPORT_ERROR THEN
3821: l_error_flag := TRUE;
3822: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');
3823: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3824: fnd_file.new_line(fnd_file.log,1);
3825: ROLLBACK TO sp1;
3826:
3827: WHEN OTHERS THEN

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

3820: WHEN IMPORT_ERROR THEN
3821: l_error_flag := TRUE;
3822: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');
3823: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3824: fnd_file.new_line(fnd_file.log,1);
3825: ROLLBACK TO sp1;
3826:
3827: WHEN OTHERS THEN
3828: RAISE;

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

3885: l_debug_str := l_debug_str || ' After update of interface table : status I ';
3886: END IF;
3887: l_success_record_cnt := l_success_record_cnt + 1;
3888: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');
3889: fnd_file.put_line(fnd_file.log, fnd_message.get);
3890:
3891: END IF;
3892: fnd_file.new_line(fnd_file.log,1);
3893: -- Write debug messages

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

3888: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');
3889: fnd_file.put_line(fnd_file.log, fnd_message.get);
3890:
3891: END IF;
3892: fnd_file.new_line(fnd_file.log,1);
3893: -- Write debug messages
3894: IF lb_write_log THEN
3895: IF g_request_id IS NULL THEN
3896: g_request_id := fnd_global.conc_request_id;

Line 3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);

3904: IF l_total_record_cnt = 0 THEN
3905: fnd_message.set_name('IGF','IGF_SL_DL_LI_NO_RECORDS');
3906: fnd_message.set_token('AID_YR', l_alternate_code);
3907: fnd_message.set_token('BATCH_ID',p_batch_id);
3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3909: RETURN;
3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.
3912:

Line 3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));

3909: RETURN;
3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.
3912:
3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));
3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));
3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));
3916:
3917:

Line 3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));

3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.
3912:
3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));
3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));
3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));
3916:
3917:
3918: EXCEPTION

Line 3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));

3911: -- Print in the out put file the total number of records successfully imported.
3912:
3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));
3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));
3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));
3916:
3917:
3918: EXCEPTION
3919:

Line 3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);

3921: ROLLBACK;
3922: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str || SQLERRM,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');
3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
3926: retcode := 2;
3927: errbuf := fnd_message.get;
3928: igs_ge_msg_stack.conc_exception_hndl;
3929: END run;