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 IGF_AW_CANCEL_AWD

Line 1: PACKAGE BODY igf_aw_cancel_awd AS

1: PACKAGE BODY igf_aw_cancel_awd AS
2: /* $Header: IGFAW06B.pls 120.8 2006/02/08 23:39:51 ridas ship $ */
3:
4: /*
5: || Created On : 12-Jun-2001

Line 74: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',

70:
71: -- Log
72: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
73: fnd_log.string(fnd_log.level_statement,
74: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',
75: 'Award expiration date(l_awd_exp_date): ' ||l_awd_exp_date);
76: END IF;
77:
78: IF l_awd_exp_date >= SYSDATE THEN

Line 85: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',

81:
82: -- Log
83: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
84: fnd_log.string(fnd_log.level_statement,
85: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',
86: 'Award expiration date > SYSDATE. Award NOT expired.');
87: END IF;
88: ELSE
89: -- Award has expired. Cancel award.

Line 95: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',

91:
92: -- Log
93: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
94: fnd_log.string(fnd_log.level_statement,
95: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',
96: 'Award expiration date < SYSDATE. Award expired.');
97: END IF;
98: END IF;
99: ELSE

Line 106: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',

102:
103: -- Log
104: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
105: fnd_log.string(fnd_log.level_statement,
106: 'igf.plsql.igf_aw_cancel_awd.chk_awd_exp_date.debug',
107: 'Award expiration offset not setup in Fund Manager for fund_id: ' ||p_fund_id);
108: END IF;
109: END IF;
110: END IF;

Line 243: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',

239:
240: -- Log
241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_statement,
243: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',
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);

Line 295: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',

291:
292: -- Log
293: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
294: fnd_log.string(fnd_log.level_statement,
295: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',
296: 'Award id :' ||lc_awd.AWARD_ID|| ' passed validation checks and is eligible for cancellation');
297: END IF;
298:
299: --Create a SavePoint here so that whenever any of the Award/Disb/Loan is Locked then

Line 382: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',

378:
379: -- Log
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_statement,
382: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',
383: 'Award id :' ||lc_awd.AWARD_ID|| ' cancelled successfully');
384: END IF;
385: ELSE
386: -- AWARD INELIGIBLE FOR CANCELLATION

Line 395: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',

391:
392: -- Log
393: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
394: fnd_log.string(fnd_log.level_statement,
395: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',
396: 'Award id :' ||lc_awd.AWARD_ID|| ' CANNOT be cancelled bcoz of the message ' ||l_msgname);
397: END IF;
398: ELSE
399: -- chk_awd_exp_date() failed

Line 403: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',

399: -- chk_awd_exp_date() failed
400: -- Log
401: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
402: fnd_log.string(fnd_log.level_statement,
403: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',
404: 'Award id :' ||lc_awd.AWARD_ID|| ' CANNOT be cancelled bcoz - the award is not expired (or) award expiration offset is not setup');
405: END IF;
406: END IF; -- l_msgname IS NOT NULL
407: END IF; -- l_retval AND chk_awd_exp_date

Line 569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', '#### Awards - Cancel Offered Awards process - STARTS ####');

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 ####');
570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');
571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);

Line 570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');

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 ####');
570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');
571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);
574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));

Line 571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);

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 ####');
570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');
571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);
574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));
575: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person Id Grp: ' ||NVL(p_pig, ''));

Line 572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));

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 ####');
570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');
571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);
574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));
575: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person Id Grp: ' ||NVL(p_pig, ''));
576: END IF;

Line 573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);

569: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', '#### Awards - Cancel Offered Awards process - STARTS ####');
570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');
571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);
574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));
575: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person Id Grp: ' ||NVL(p_pig, ''));
576: END IF;
577:

Line 574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));

570: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'Concurrent Process Req Id: ' ||fnd_global.conc_request_id ||' ####');
571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);
574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));
575: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person Id Grp: ' ||NVL(p_pig, ''));
576: END IF;
577:
578: --------------------------------------------------------------------------------------------------------------

Line 575: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person Id Grp: ' ||NVL(p_pig, ''));

571: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Award yr: ' ||p_award_year);
572: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Fund code: ' ||NVL(l_fund_code, ''));
573: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Run mode: ' ||p_run_mode);
574: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person num: ' ||NVL(l_person_no, ''));
575: fnd_log.string(fnd_log.level_statement, 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug', 'PARAMETER Person Id Grp: ' ||NVL(p_pig, ''));
576: END IF;
577:
578: --------------------------------------------------------------------------------------------------------------
579: -- Parameter Validation --

Line 610: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',

606:
607: -- Log
608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
609: fnd_log.string(fnd_log.level_statement,
610: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',
611: 'Parameters base_id and pig are NULL. Calling cancel_award_fabase');
612: END IF;
613:
614: cancel_award_fabase (

Line 628: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',

624:
625: -- Log
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
627: fnd_log.string(fnd_log.level_statement,
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);

Line 651: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',

647:
648: -- Log
649: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
650: fnd_log.string(fnd_log.level_statement,
651: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',
652: 'Parameters pig is available and base_id is NULL. Processing pig');
653: END IF;
654:
655: --Bug #5021084

Line 692: 'igf.plsql.igf_aw_cancel_awd.cancel_award.debug',

688:
689: -- Log
690: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
691: fnd_log.string(fnd_log.level_statement,
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);

Line 749: fnd_message.set_token('NAME','igf_aw_cancel_awd.cancel_award');

745: WHEN OTHERS THEN
746: ROLLBACK ;
747: RETCODE := 2;
748: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
749: fnd_message.set_token('NAME','igf_aw_cancel_awd.cancel_award');
750: ERRBUF := fnd_message.get;
751: igs_ge_msg_stack.conc_exception_hndl;
752:
753: END cancel_award;

Line 954: fnd_message.set_token('NAME','igf_aw_cancel_awd.chk_awd_cancel');

950: CLOSE cur_dl_disb;
951: END IF;
952:
953: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
954: fnd_message.set_token('NAME','igf_aw_cancel_awd.chk_awd_cancel');
955: igs_ge_msg_stack.conc_exception_hndl;
956: RETURN FALSE;
957:
958: END chk_awd_cancel;

Line 960: END igf_aw_cancel_awd;

956: RETURN FALSE;
957:
958: END chk_awd_cancel;
959:
960: END igf_aw_cancel_awd;