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_DB_CL_ROSTER dependencies on IGF_DB_CL_ROSTER

Line 1: PACKAGE BODY igf_db_cl_roster AS

1: PACKAGE BODY igf_db_cl_roster AS
2: /* $Header: IGFDB04B.pls 120.5 2006/08/08 06:29:38 ridas noship $ */
3:
4: -----------------------------------------------------------------------------------
5: -- Created By : sjadhav

Line 277: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','cl_load_data Entry ');

273:
274: -- Check for a proper header
275:
276: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
277: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','cl_load_data Entry ');
278: END IF;
279:
280: OPEN c_header;
281: FETCH c_header INTO

Line 296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','cl_load_data Header fetch');

292: l_recipient_id,
293: l_recip_non_ed_brc_id;
294:
295: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','cl_load_data Header fetch');
297: END IF;
298: IF c_header%NOTFOUND THEN
299: CLOSE c_header;
300: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

Line 315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','Got Batch g_cl_version,g_cl_file_type,l_file_ident_name ,l_file_ident_code '

311: LTRIM(RTRIM(l_file_ident_name)), -- File_Ident_Name
312: g_cl_version, g_cl_file_type);
313:
314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','Got Batch g_cl_version,g_cl_file_type,l_file_ident_name ,l_file_ident_code '
316: || g_cl_version ||' : ' || g_cl_file_type||' : ' || l_file_ident_name||' : ' || l_file_ident_code);
317: END IF;
318:
319: IF g_cl_file_type = 'CL_DISB_ROSTER' THEN

Line 329: fnd_message.set_name('IGF','IGF_DB_CL_ROSTER_FILE');

325: END IF;
326:
327: -- File is a valid Disbursement Roster File. It should be processed.
328:
329: fnd_message.set_name('IGF','IGF_DB_CL_ROSTER_FILE');
330: fnd_file.put_line(fnd_file.log,fnd_message.get);
331:
332: --Check whether file has been transmitted completely or not
333:

Line 349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug',' got trailer record ');

345: END IF;
346: CLOSE c_trailer;
347:
348: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
349: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug',' got trailer record ');
350: END IF;
351:
352:
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record');

350: END IF;
351:
352:
353: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
354: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record');
355: END IF;
356:
357: l_rowid := NULL;
358:

Line 361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record for Release-5');

357: l_rowid := NULL;
358:
359: IF g_cl_version = 'RELEASE-5' THEN
360: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
361: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record for Release-5');
362: END IF;
363:
364: igf_sl_cl_batch_pkg.insert_row(
365: x_rowid => l_rowid,

Line 388: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','After inserting batch record for Release-5');

384: x_total_net_cancel_amt => l_tot_net_cancel_amt ,
385: x_total_net_out_cancel_amt => l_tot_net_out_cancel_amt
386: );
387: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
388: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','After inserting batch record for Release-5');
389: END IF;
390:
391:
392: ELSIF g_cl_version = 'RELEASE-4' THEN

Line 394: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record for Release-4');

390:
391:
392: ELSIF g_cl_version = 'RELEASE-4' THEN
393: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
394: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','before inserting batch record for Release-4');
395: END IF;
396:
397: igf_sl_cl_batch_pkg.insert_row(
398: x_rowid => l_rowid,

Line 422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after inserting batch record for Release-4');

418: x_total_net_out_cancel_amt => l_tot_net_out_cancel_amt
419: );
420:
421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after inserting batch record for Release-4');
423: END IF;
424:
425: END IF;
426:

Line 461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after print header');

457: fnd_file.new_line(fnd_file.output,1);
458:
459:
460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
461: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after print header');
462: END IF;
463:
464: OPEN c_get_trailer_parameters;
465: LOOP

Line 512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after print trailer');

508:
509:
510:
511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','after print trailer');
513: END IF;
514: --Insert records into IGF_DB_CL_DISB_RESP
515: OPEN cur_roster_logs;
516: LOOP

Line 585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','begin data processing ');

581: END LOOP;
582: CLOSE cur_roster_logs;
583:
584: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','begin data processing ');
586: END IF;
587:
588: fnd_file.new_line(fnd_file.output,1);
589: fnd_file.put_line(fnd_file.output, lv_disb);

Line 736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','Esign src typ code in roster = '||lv_esign_roster_data);

732:
733: -- FA 161 CL4 Updates build.
734: lv_esign_roster_data := LTRIM(RTRIM(SUBSTR(db_rec.record_data, 473, 9)));
735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','Esign src typ code in roster = '||lv_esign_roster_data);
737: END IF;
738:
739: IF LENGTH(lv_esign_roster_data) > 0 THEN
740: OPEN cur_lor_data(l_loan_number);

Line 747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','Esign src typ code in system = '||NVL(rec_lor_data.esign_src_typ_cd,'*'));

743: CLOSE cur_lor_data;
744: RAISE SKIP_THIS_RECORD;
745: ELSE
746: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
747: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.cl_load_data.debug','Esign src typ code in system = '||NVL(rec_lor_data.esign_src_typ_cd,'*'));
748: END IF;
749: IF NVL(rec_lor_data.esign_src_typ_cd,'*') <> lv_esign_roster_data THEN
750: igf_sl_lor_pkg.update_row (
751: X_Mode => 'R',

Line 908: fnd_message.set_token('NAME','IGF_DB_CL_ROSTER.CL_LOAD_DATA');

904: WHEN CLSETUP_NOT_FOUND THEN
905: RAISE;
906: WHEN OTHERS THEN
907: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
908: fnd_message.set_token('NAME','IGF_DB_CL_ROSTER.CL_LOAD_DATA');
909: fnd_file.put_line(fnd_file.log,SQLERRM);
910: igs_ge_msg_stack.add;
911: app_exception.raise_exception;
912:

Line 1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','Calling Load Data');

999: retcode := 0;
1000: -- Load the data into the Batch and Response Table
1001:
1002: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1003: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','Calling Load Data');
1004: END IF;
1005:
1006: cl_load_data(l_cbth_id);
1007:

Line 1009: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','After Load Data, Batch ID ' || l_cbth_id);

1005:
1006: cl_load_data(l_cbth_id);
1007:
1008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1009: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','After Load Data, Batch ID ' || l_cbth_id);
1010: END IF;
1011:
1012: -- Select all the records from IGF_DB_CL_DISB_RESP table
1013: -- with status = 'N' for the batch id returned by load process.

Line 1087: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','Start processing disb response rec 1 l_loan_number,l_disb_num ' || l_loan_number||' : ' || l_disb_num);

1083: lv_rec_status := 'N';
1084: log_start(l_loan_number, l_disb_num);
1085: -- Condition 0 : If there are any errors returned in the File, then Display and skip
1086: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1087: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','Start processing disb response rec 1 l_loan_number,l_disb_num ' || l_loan_number||' : ' || l_disb_num);
1088: END IF;
1089:
1090: IF cbth_rec.err_code1 IS NOT NULL
1091: OR cbth_rec.err_code2 IS NOT NULL

Line 1126: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','skip flag TRUE ');

1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: fnd_file.new_line(fnd_file.log,1);
1124: lv_rec_status := 'F';
1125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1126: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','skip flag TRUE ');
1127: END IF;
1128: lv_rec_status := 'F';
1129: RAISE SKIP_THIS_RECORD;
1130: END IF;

Line 1133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','loan disb found ');

1129: RAISE SKIP_THIS_RECORD;
1130: END IF;
1131: IF cur_awdisb%FOUND THEN
1132: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1133: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','loan disb found ');
1134: END IF;
1135: OPEN c_clset(disb_rec.award_id);
1136: FETCH c_clset INTO l_auto_late_ind;
1137: IF c_clset%NOTFOUND THEN

Line 1146: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','loan setup found, l_auto_late_ind ' || l_auto_late_ind);

1142: igs_ge_msg_stack.add;
1143: RAISE CLSETUP_NOT_FOUND;
1144: END IF;
1145: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1146: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug','loan setup found, l_auto_late_ind ' || l_auto_late_ind);
1147: END IF;
1148: CLOSE c_clset;
1149: END IF;
1150:

Line 1279: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug',

1275: fnd_file.new_line(fnd_file.log,1);
1276: END IF;
1277:
1278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1279: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_cl_roster.roster_ack.debug',
1280: 'Updating aw disb , award_id, disb_num, RESP_status ' || disb_rec.award_id || ' : ' || disb_rec.disb_num || ' : ' || lv_rec_status);
1281: END IF;
1282:
1283: igf_aw_awd_disb_pkg.update_row(

Line 1451: END igf_db_cl_roster;

1447: igs_ge_msg_stack.conc_exception_hndl;
1448:
1449: END roster_ack;
1450:
1451: END igf_db_cl_roster;