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_GR_REPACKAGE dependencies on FND_LOG

Line 143: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

139: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
140: fnd_message.set_token('NAME','IGF_GE_REPACKAGE.LOG_PARAMETERS '||SQLERRM);
141: igs_ge_msg_stack.add;
142:
143: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
144: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.log_parameters.exception','sql error message:'||SQLERRM);
145: END IF;
146:
147: app_exception.raise_exception;

Line 144: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.log_parameters.exception','sql error message:'||SQLERRM);

140: fnd_message.set_token('NAME','IGF_GE_REPACKAGE.LOG_PARAMETERS '||SQLERRM);
141: igs_ge_msg_stack.add;
142:
143: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
144: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.log_parameters.exception','sql error message:'||SQLERRM);
145: END IF;
146:
147: app_exception.raise_exception;
148: END log_parameters;

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

184:
185:
186: BEGIN
187:
188: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
189: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','starting cancel_invalid_award with award_id:'||p_award_id);
190: END IF;
191:
192: FOR awd_rec IN c_award(p_award_id) LOOP

Line 189: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','starting cancel_invalid_award with award_id:'||p_award_id);

185:
186: BEGIN
187:
188: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
189: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','starting cancel_invalid_award with award_id:'||p_award_id);
190: END IF;
191:
192: FOR awd_rec IN c_award(p_award_id) LOOP
193:

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

241: x_fund_return_mthd_code => disb_rec.fund_return_mthd_code,
242: x_direct_to_borr_flag => disb_rec.direct_to_borr_flag
243: );
244:
245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','updated disbursement number '||disb_rec.disb_num);
247: END IF;
248:
249: END LOOP;

Line 246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','updated disbursement number '||disb_rec.disb_num);

242: x_direct_to_borr_flag => disb_rec.direct_to_borr_flag
243: );
244:
245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','updated disbursement number '||disb_rec.disb_num);
247: END IF;
248:
249: END LOOP;
250:

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

297: x_publish_in_ss_flag => awd_rec.publish_in_ss_flag
298: );
299: END LOOP;
300:
301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
302: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','finsihed cancel_invalid_award for award_id:'||p_award_id);
303: END IF;
304:
305: EXCEPTION

Line 302: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','finsihed cancel_invalid_award for award_id:'||p_award_id);

298: );
299: END LOOP;
300:
301: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
302: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','finsihed cancel_invalid_award for award_id:'||p_award_id);
303: END IF;
304:
305: EXCEPTION
306: WHEN OTHERS THEN

Line 311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

307: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
308: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.CANCEL_INVALID_AWARD ' || SQLERRM);
309: igs_ge_msg_stack.add;
310:
311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
312: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.cancel_invalid_award.exception','sql error message:'||SQLERRM);
313: END IF;
314:
315: app_exception.raise_exception;

Line 312: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.cancel_invalid_award.exception','sql error message:'||SQLERRM);

308: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.CANCEL_INVALID_AWARD ' || SQLERRM);
309: igs_ge_msg_stack.add;
310:
311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
312: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.cancel_invalid_award.exception','sql error message:'||SQLERRM);
313: END IF;
314:
315: app_exception.raise_exception;
316:

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

552: -- RFMS AND RFMS Disbursement tables then delete from it.
553: --
554:
555:
556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','***********person_number:'||l_person_number||'********');
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_id:'||lc_stud_det.award_id);
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','fund_id:'||lc_stud_det.fund_id);
560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_status:'||lc_stud_det.award_status);

Line 557: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','***person_number:'||l_person_number||'');

553: --
554:
555:
556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','***********person_number:'||l_person_number||'********');
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_id:'||lc_stud_det.award_id);
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','fund_id:'||lc_stud_det.fund_id);
560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_status:'||lc_stud_det.award_status);
561: END IF;

Line 558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_id:'||lc_stud_det.award_id);

554:
555:
556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','***********person_number:'||l_person_number||'********');
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_id:'||lc_stud_det.award_id);
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','fund_id:'||lc_stud_det.fund_id);
560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_status:'||lc_stud_det.award_status);
561: END IF;
562:

Line 559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','fund_id:'||lc_stud_det.fund_id);

555:
556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','***********person_number:'||l_person_number||'********');
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_id:'||lc_stud_det.award_id);
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','fund_id:'||lc_stud_det.fund_id);
560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_status:'||lc_stud_det.award_status);
561: END IF;
562:
563: SAVEPOINT sv_student;

Line 560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_status:'||lc_stud_det.award_status);

556: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','***********person_number:'||l_person_number||'********');
558: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_id:'||lc_stud_det.award_id);
559: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','fund_id:'||lc_stud_det.fund_id);
560: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','award_status:'||lc_stud_det.award_status);
561: END IF;
562:
563: SAVEPOINT sv_student;
564: FOR lc_rfms IN c_rfms(lc_stud_det.award_id) LOOP

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

562:
563: SAVEPOINT sv_student;
564: FOR lc_rfms IN c_rfms(lc_stud_det.award_id) LOOP
565:
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms.orig_action_code:'||lc_rfms.orig_action_code);
568: END IF;
569:
570:

Line 567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms.orig_action_code:'||lc_rfms.orig_action_code);

563: SAVEPOINT sv_student;
564: FOR lc_rfms IN c_rfms(lc_stud_det.award_id) LOOP
565:
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms.orig_action_code:'||lc_rfms.orig_action_code);
568: END IF;
569:
570:
571: FOR lc_rfms_disb IN c_rfms_disb(lc_rfms.origination_id) LOOP

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

570:
571: FOR lc_rfms_disb IN c_rfms_disb(lc_rfms.origination_id) LOOP
572:
573:
574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms_disb.disb_ack_act_status:'||lc_rfms_disb.disb_ack_act_status);
576: END IF;
577:
578: IF lc_rfms_disb.disb_ack_act_status NOT IN ('R','N') THEN

Line 575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms_disb.disb_ack_act_status:'||lc_rfms_disb.disb_ack_act_status);

571: FOR lc_rfms_disb IN c_rfms_disb(lc_rfms.origination_id) LOOP
572:
573:
574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms_disb.disb_ack_act_status:'||lc_rfms_disb.disb_ack_act_status);
576: END IF;
577:
578: IF lc_rfms_disb.disb_ack_act_status NOT IN ('R','N') THEN
579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');

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

578: IF lc_rfms_disb.disb_ack_act_status NOT IN ('R','N') THEN
579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');
580: fnd_file.put_line( fnd_file.log, fnd_message.get);
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell orig sent...erroring out');
584: END IF;
585:
586: RAISE e_next_record;

Line 583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell orig sent...erroring out');

579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');
580: fnd_file.put_line( fnd_file.log, fnd_message.get);
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell orig sent...erroring out');
584: END IF;
585:
586: RAISE e_next_record;
587:

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

604: fnd_message.set_name('IGF', 'IGF_AW_NO_AWARD_REC');
605: fnd_file.put_line( fnd_file.log, fnd_message.get);
606: CLOSE c_award;
607:
608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','no PELL award for student');
610: END IF;
611:
612: RAISE e_next_record;

Line 609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','no PELL award for student');

605: fnd_file.put_line( fnd_file.log, fnd_message.get);
606: CLOSE c_award;
607:
608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','no PELL award for student');
610: END IF;
611:
612: RAISE e_next_record;
613: END IF;

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

627:
628: IF NOT lb_valid_pell THEN
629:
630: --log messages
631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell elig failed for :'||l_person_number);
633: END IF;
634:
635: IF igs_ge_msg_stack.count_msg > 0 THEN

Line 632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell elig failed for :'||l_person_number);

628: IF NOT lb_valid_pell THEN
629:
630: --log messages
631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
632: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell elig failed for :'||l_person_number);
633: END IF;
634:
635: IF igs_ge_msg_stack.count_msg > 0 THEN
636: lv_message := NULL;

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

674: fnd_file.put_line(fnd_file.log,fnd_message.get);
675:
676: cancel_invalid_award(lc_stud_det.award_id);
677: COMMIT;
678: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
679: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);
680: END IF;
681:
682: ELSE -- Actual Mode but Cancel Awards not set to Yes

Line 679: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);

675:
676: cancel_invalid_award(lc_stud_det.award_id);
677: COMMIT;
678: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
679: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);
680: END IF;
681:
682: ELSE -- Actual Mode but Cancel Awards not set to Yes
683:

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

705:
706: --log messages
707: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
710: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','payment isir is not active isir..error');
711: END IF;
712:
713: IF g_test_run <> 'Y' AND g_cancel_invalid_awds = 'Y' THEN

Line 710: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','payment isir is not active isir..error');

706: --log messages
707: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
710: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','payment isir is not active isir..error');
711: END IF;
712:
713: IF g_test_run <> 'Y' AND g_cancel_invalid_awds = 'Y' THEN
714: --cancel award and disbursements

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

721: fnd_file.put_line(fnd_file.log,fnd_message.get);
722:
723: cancel_invalid_award(lc_stud_det.award_id);
724: COMMIT;
725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);
727: END IF;
728:
729: ELSE

Line 726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);

722:
723: cancel_invalid_award(lc_stud_det.award_id);
724: COMMIT;
725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);
727: END IF;
728:
729: ELSE
730: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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

737: END IF; -- Payment ISIR not equal to Active ISIR
738:
739: l_offered_amt := NULL;
740: -- Call the procedure to get the offered amount
741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.fund_id:'||lc_stud_det.fund_id);
743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_award.adplans_id:'||lc_award.adplans_id);
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.base_id:'||lc_stud_det.base_id);
745: END IF;

Line 742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.fund_id:'||lc_stud_det.fund_id);

738:
739: l_offered_amt := NULL;
740: -- Call the procedure to get the offered amount
741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.fund_id:'||lc_stud_det.fund_id);
743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_award.adplans_id:'||lc_award.adplans_id);
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.base_id:'||lc_stud_det.base_id);
745: END IF;
746:

Line 743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_award.adplans_id:'||lc_award.adplans_id);

739: l_offered_amt := NULL;
740: -- Call the procedure to get the offered amount
741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.fund_id:'||lc_stud_det.fund_id);
743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_award.adplans_id:'||lc_award.adplans_id);
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.base_id:'||lc_stud_det.base_id);
745: END IF;
746:
747: lv_message := NULL;

Line 744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.base_id:'||lc_stud_det.base_id);

740: -- Call the procedure to get the offered amount
741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.fund_id:'||lc_stud_det.fund_id);
743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_award.adplans_id:'||lc_award.adplans_id);
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_stud_det.base_id:'||lc_stud_det.base_id);
745: END IF;
746:
747: lv_message := NULL;
748: l_pell_seq_id := NULL;

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

760: cp_pell_seq_id => l_pell_seq_id,
761: cp_pell_schedule_code => l_pell_schedule_code
762: );
763:
764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);
767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);
768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);

Line 765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);

761: cp_pell_schedule_code => l_pell_schedule_code
762: );
763:
764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);
767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);
768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);
769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_schedule_code:'||l_pell_schedule_code);

Line 766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);

762: );
763:
764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);
767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);
768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);
769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_schedule_code:'||l_pell_schedule_code);
770: END IF;

Line 767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);

763:
764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);
767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);
768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);
769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_schedule_code:'||l_pell_schedule_code);
770: END IF;
771:

Line 768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);

764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);
767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);
768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);
769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_schedule_code:'||l_pell_schedule_code);
770: END IF;
771:
772: -- ========== Calculation Complete at this Point of Time ===========---

Line 769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_schedule_code:'||l_pell_schedule_code);

765: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_return_status:'||lv_return_status);
766: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_message:'||lv_message);
767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_seq_id:'||l_pell_seq_id);
768: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_offered_amt returned by the wrapper:'||l_offered_amt);
769: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_pell_schedule_code:'||l_pell_schedule_code);
770: END IF;
771:
772: -- ========== Calculation Complete at this Point of Time ===========---
773: -- ========== Now do Table Insert ===========---

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

789: OPEN c_rfms(lc_stud_det.award_id);
790: FETCH c_rfms INTO lc_rfms;
791: IF c_rfms%FOUND THEN
792:
793: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Found Pell Origination.Finding FT_PELL_AMT');
795: END IF;
796:
797: igf_gr_pell_calc.calc_ft_max_pell(

Line 794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Found Pell Origination.Finding FT_PELL_AMT');

790: FETCH c_rfms INTO lc_rfms;
791: IF c_rfms%FOUND THEN
792:
793: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Found Pell Origination.Finding FT_PELL_AMT');
795: END IF;
796:
797: igf_gr_pell_calc.calc_ft_max_pell(
798: cp_base_id => lc_stud_det.base_id,

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

810: fnd_file.put_line(fnd_file.log,lv_message_ft);
811: RAISE e_next_record;
812: END IF;
813:
814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Full time PELL Amount:'||l_pell_ft_aid);
816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);
817: END IF;
818:

Line 815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Full time PELL Amount:'||l_pell_ft_aid);

811: RAISE e_next_record;
812: END IF;
813:
814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Full time PELL Amount:'||l_pell_ft_aid);
816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);
817: END IF;
818:
819: -- Update the Origination Record

Line 816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);

812: END IF;
813:
814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Full time PELL Amount:'||l_pell_ft_aid);
816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);
817: END IF;
818:
819: -- Update the Origination Record
820: igf_gr_rfms_pkg.update_row(

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

1076: l_rfmb_disb_rec.edit_code := NULL ;
1077: l_rfmb_disb_rec.rfmb_id := NULL ;
1078:
1079:
1080: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);
1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);

Line 1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);

1077: l_rfmb_disb_rec.rfmb_id := NULL ;
1078:
1079:
1080: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);
1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);
1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);

Line 1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);

1078:
1079:
1080: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);
1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);
1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);

Line 1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);

1079:
1080: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);
1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);
1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);
1087: END IF;

Line 1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);

1080: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);
1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);
1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);
1087: END IF;
1088:

Line 1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);

1081: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ref_num:'||l_rfmb_disb_rec.disb_ref_num);
1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);
1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);
1087: END IF;
1088:
1089:

Line 1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);

1082: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_dt:'||l_rfmb_disb_rec.disb_dt);
1083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_amt:'||l_rfmb_disb_rec.disb_amt);
1084: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.db_cr_flag:'||l_rfmb_disb_rec.db_cr_flag);
1085: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_ack_act_status:'||l_rfmb_disb_rec.disb_ack_act_status);
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);
1087: END IF;
1088:
1089:
1090: igf_gr_rfms_disb_pkg.update_row(

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

1107: x_edit_code => l_rfmb_disb_rec.edit_code ,
1108: x_rfmb_id => l_rfmb_disb_rec.rfmb_id,
1109: x_ed_use_flags => l_rfmb_disb_rec.ed_use_flags
1110: );
1111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_rfmd_id:'||lv_rfmd_id);
1113: END IF;
1114:
1115: ELSE -- RFMS Disbursement does not exist so add

Line 1112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_rfmd_id:'||lv_rfmd_id);

1108: x_rfmb_id => l_rfmb_disb_rec.rfmb_id,
1109: x_ed_use_flags => l_rfmb_disb_rec.ed_use_flags
1110: );
1111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lv_rfmd_id:'||lv_rfmd_id);
1113: END IF;
1114:
1115: ELSE -- RFMS Disbursement does not exist so add
1116:

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

1160: -- Delete Additional Disbursement records
1161:
1162: FOR disb_cancel_rec IN c_disb_cancel(lc_stud_det.award_id,l_last_disb_num) LOOP
1163:
1164: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1165: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelling awd_disb for award_id:'||disb_cancel_rec.award_id||' disb_cancel_rec.disb_num:'||disb_cancel_rec.disb_num);
1166: END IF;
1167:
1168: -- cancel the disbursement

Line 1165: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelling awd_disb for award_id:'||disb_cancel_rec.award_id||' disb_cancel_rec.disb_num:'||disb_cancel_rec.disb_num);

1161:
1162: FOR disb_cancel_rec IN c_disb_cancel(lc_stud_det.award_id,l_last_disb_num) LOOP
1163:
1164: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1165: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelling awd_disb for award_id:'||disb_cancel_rec.award_id||' disb_cancel_rec.disb_num:'||disb_cancel_rec.disb_num);
1166: END IF;
1167:
1168: -- cancel the disbursement
1169: igf_aw_awd_disb_pkg.update_row(

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

1392:
1393: g_test_run := p_test_run;
1394: g_cancel_invalid_awds := p_cancel_invalid_awds;
1395:
1396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);
1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);
1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);
1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);

Line 1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);

1393: g_test_run := p_test_run;
1394: g_cancel_invalid_awds := p_cancel_invalid_awds;
1395:
1396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);
1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);
1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);
1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);
1401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_cancel_invalid_awds:'||g_cancel_invalid_awds);

Line 1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);

1394: g_cancel_invalid_awds := p_cancel_invalid_awds;
1395:
1396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);
1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);
1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);
1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);
1401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_cancel_invalid_awds:'||g_cancel_invalid_awds);
1402: END IF;

Line 1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);

1395:
1396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);
1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);
1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);
1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);
1401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_cancel_invalid_awds:'||g_cancel_invalid_awds);
1402: END IF;
1403:

Line 1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);

1396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);
1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);
1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);
1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);
1401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_cancel_invalid_awds:'||g_cancel_invalid_awds);
1402: END IF;
1403:
1404: log_parameters(l_ci_cal_type,l_ci_sequence_number,l_base_id,p_persid_grp,p_test_run,p_cancel_invalid_awds);

Line 1401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_cancel_invalid_awds:'||g_cancel_invalid_awds);

1397: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_cal_type:'||l_ci_cal_type);
1398: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_ci_sequence_number:'||l_ci_sequence_number);
1399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','l_base_id:'||l_base_id);
1400: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_test_run:'||g_test_run);
1401: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','g_cancel_invalid_awds:'||g_cancel_invalid_awds);
1402: END IF;
1403:
1404: log_parameters(l_ci_cal_type,l_ci_sequence_number,l_base_id,p_persid_grp,p_test_run,p_cancel_invalid_awds);
1405:

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

1446: END IF;
1447:
1448: ELSIF p_base_id IS NOT NULL THEN
1449: --call the routine for the single base_id
1450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','calling repackage with base_id:'||p_base_id);
1452: END IF;
1453: repackage(p_base_id);
1454:

Line 1451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','calling repackage with base_id:'||p_base_id);

1447:
1448: ELSIF p_base_id IS NOT NULL THEN
1449: --call the routine for the single base_id
1450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage_pell.debug','calling repackage with base_id:'||p_base_id);
1452: END IF;
1453: repackage(p_base_id);
1454:
1455: ELSIF p_base_id IS NULL THEN