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

Line 248: fnd_file.put_line(fnd_file.log,' ');

244: '*** Starting to cancel award for base_id: ' ||p_base_id|| ', fund_id: ' ||p_fund_id|| ',cal_type: ' ||p_ci_cal_type|| ', seq_num: ' ||p_ci_seq_num|| ' ***');
245: END IF;
246:
247: OPEN c_award(p_ci_cal_type, p_ci_seq_num, p_fund_id, p_base_id);
248: fnd_file.put_line(fnd_file.log,' ');
249: FETCH c_award INTO lc_award;
250:
251: IF c_award%NOTFOUND THEN
252: -- No awards found satisfying the criteria

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

250:
251: IF c_award%NOTFOUND THEN
252: -- No awards found satisfying the criteria
253: fnd_message.set_name('IGF','IGF_AW_CANCEL_NOT_FOUND');
254: fnd_file.put_line( fnd_file.log, fnd_message.get);
255: CLOSE c_award;
256: RETURN;
257: END IF;
258:

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

267:
268: IF c_awd%NOTFOUND THEN
269: -- This award does not seem to exist ???
270: fnd_message.set_name('IGF','IGF_AW_AWARD_NOT_FOUND');
271: fnd_file.put_line( fnd_file.log, fnd_message.get);
272: CLOSE c_awd;
273: RAISE e_next_record;
274: END IF;
275:

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

276: l_retval := chk_awd_cancel(lc_awd.award_id,lc_awd.base_id,lc_awd.fund_id,l_msgname);
277:
278: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_AWD');
279: fnd_message.set_token('AWD_ID', lc_award.award_id);
280: fnd_file.put_line( fnd_file.log, fnd_message.get);
281:
282: -- Check if award can be cancelled
283: IF l_retval AND chk_awd_exp_date(
284: p_base_id => lc_awd.base_id,

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

372:
373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);
376: fnd_file.put_line( fnd_file.log, fnd_message.get);
377: fnd_file.new_line(fnd_file.log,1);
378:
379: -- Log
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);
376: fnd_file.put_line( fnd_file.log, fnd_message.get);
377: fnd_file.new_line(fnd_file.log,1);
378:
379: -- Log
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_statement,

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

386: -- AWARD INELIGIBLE FOR CANCELLATION
387: IF l_msgname IS NOT NULL THEN
388: -- chk_awd_cancel() failed
389: fnd_message.set_name('IGF', l_msgname);
390: fnd_file.put_line( fnd_file.log, fnd_message.get);
391:
392: -- Log
393: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
394: fnd_log.string(fnd_log.level_statement,

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

523: IF cur_alt_code%NOTFOUND THEN
524: CLOSE cur_alt_code;
525: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
526: igs_ge_msg_stack.add;
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: RAISE NO_DATA_FOUND;
529: END IF;
530: CLOSE cur_alt_code;
531:

Line 560: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),80,' '));

556: END LOOP;
557: CLOSE cur_get_parameters;
558:
559: --Show the parameters passed
560: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),80,' '));
561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));

Line 561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);

557: CLOSE cur_get_parameters;
558:
559: --Show the parameters passed
560: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),80,' '));
561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));
565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));

Line 562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));

558:
559: --Show the parameters passed
560: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),80,' '));
561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));
565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));
566:

Line 563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));

559: --Show the parameters passed
560: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),80,' '));
561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));
565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));
566:
567: -- Log paramaters

Line 564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));

560: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),80,' '));
561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));
565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));
566:
567: -- Log paramaters
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));

561: fnd_file.put_line(fnd_file.log,RPAD(l_year,80,' ')||':'||RPAD(' ',4,' ')||l_alt_code);
562: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_fund_code, ''));
563: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(4),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_pig_desc, ''));
564: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),80,' ')||':'||RPAD(' ',4,' ') ||NVL(l_person_no, ''));
565: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),80,' ')||':'||RPAD(' ',4,' ') ||igf_aw_gen.lookup_desc('IGF_AW_CNC_RUN_MODE', p_run_mode));
566:
567: -- Log paramaters
568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', '#### Awards - Cancel Offered Awards process - STARTS ####');

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

582: -- Award Year
583: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN
584: -- Err
585: fnd_message.set_name('IGS','IGS_AD_SYSCAL_CONFIG_NOT_DTMN');
586: fnd_file.put_line(fnd_file.log, fnd_message.get);
587: RAISE PARAM_ERR;
588: END IF;
589:
590: -- Base Id and PIG

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

592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;
599: END IF;
600:

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

593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;
599: END IF;
600:
601: --------------------------------------------------------------------------------------------------------------

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

628: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',
629: 'Parameters base_id is available and pig is NULL. Calling cancel_award_fabase');
630: END IF;
631:
632: fnd_file.new_line(fnd_file.log,1);
633: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
634: fnd_message.set_token('STUD', l_person_no);
635: fnd_file.put_line( fnd_file.log, fnd_message.get);
636:

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

631:
632: fnd_file.new_line(fnd_file.log,1);
633: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
634: fnd_message.set_token('STUD', l_person_no);
635: fnd_file.put_line( fnd_file.log, fnd_message.get);
636:
637: cancel_award_fabase (
638: p_ci_cal_type => l_ci_cal_type,
639: p_ci_seq_num => l_ci_sequence_number,

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

692: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',
693: 'Calling cancel_award_fabase for base_id: ' ||l_base_id);
694: END IF;
695:
696: fnd_file.new_line(fnd_file.log,1);
697: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
698: fnd_message.set_token('STUD', l_person_no);
699: fnd_file.put_line( fnd_file.log, fnd_message.get);
700:

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

695:
696: fnd_file.new_line(fnd_file.log,1);
697: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
698: fnd_message.set_token('STUD', l_person_no);
699: fnd_file.put_line( fnd_file.log, fnd_message.get);
700:
701: cancel_award_fabase (
702: p_ci_cal_type => l_ci_cal_type,
703: p_ci_seq_num => l_ci_sequence_number,

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

707: );
708: ELSE
709: IF l_person_no IS NULL THEN
710: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
711: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
712: END IF;
713:
714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');

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

714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
716: fnd_message.set_token('PERSON_NUMBER', l_person_no);
717: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type, l_ci_sequence_number));
718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: END IF;
720:
721: END IF;
722: END IF; -- l_party_id IS NOT NULL

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

724:
725: IF NOT l_per_exists THEN
726: -- No records found in PIG
727: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
728: fnd_file.put_line(fnd_file.log,fnd_message.get);
729: END IF;
730:
731: END IF;
732: