DBA Data[Home] [Help]

APPS.IGF_DB_CL_ROSTER dependencies on FND_LOG

Line 276: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

272: BEGIN
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;

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 295: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

291: l_recipient_name,
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;

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 314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

310: LTRIM(RTRIM(l_file_ident_code)), -- 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:

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 348: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

344: RAISE FILE_NOT_LOADED;
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:

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 353: 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
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;

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 360: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

356:
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(

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 387: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

383: x_total_deficit_amt => l_tot_deficit_amt ,
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:

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 393: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

389: END IF;
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(

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 421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

417: x_total_net_cancel_amt => l_tot_net_cancel_amt ,
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;

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 460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

456: fnd_file.put_line(fnd_file.output, RPAD(lv_file_creation_date,30) || ' : '|| RPAD(l_file_creation_dt,40) || RPAD(lv_file_creation_time,30) || ' : '|| l_file_creation_time);
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;

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 511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

507: fnd_file.new_line(fnd_file.output,1);
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;

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 584: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

580: END IF;
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);

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 735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

731: x_direct_to_borr_flag => l_direct_to_borr_ind);
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

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 746: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

742: IF cur_lor_data%NOTFOUND THEN
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 (

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 1002: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

998: igf_aw_gen.set_org_id(NULL);
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);

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 1008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1004: END IF;
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

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 1086: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1082:
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

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 1125: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1121: fnd_file.new_line(fnd_file.log,1);
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;

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 1132: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1128: lv_rec_status := 'F';
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;

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 1145: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1141: -- No Records in CommonLine Setup Table.
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;

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 1278: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1274: fnd_file.put_line(fnd_file.log,fnd_message.get);
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:

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(