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_LOG

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

68: p_cal_sequence => p_ci_seq_num
69: ), SYSDATE + 1);
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;

Line 73: fnd_log.string(fnd_log.level_statement,

69: ), SYSDATE + 1);
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:

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

79: -- There is some more time for the award to Expire. Do not cancel the award
80: l_result := FALSE;
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;

Line 84: fnd_log.string(fnd_log.level_statement,

80: l_result := FALSE;
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

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

89: -- Award has expired. Cancel award.
90: l_result := TRUE;
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;

Line 94: fnd_log.string(fnd_log.level_statement,

90: l_result := TRUE;
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;

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

100: -- Award expiration date is not defined. Do not cancel the award.
101: l_result := FALSE;
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;

Line 105: fnd_log.string(fnd_log.level_statement,

101: l_result := FALSE;
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;

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

237:
238: BEGIN
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;

Line 242: fnd_log.string(fnd_log.level_statement,

238: BEGIN
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:

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

289: ) THEN
290: -- AWARD ELIGIBLE FOR CANCELLATION
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;

Line 294: fnd_log.string(fnd_log.level_statement,

290: -- AWARD ELIGIBLE FOR CANCELLATION
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:

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

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,
382: 'igf.plsql.igf_aw_cancel_awd.cancel_award_fabase.debug',
383: 'Award id :' ||lc_awd.AWARD_ID|| ' cancelled successfully');
384: END IF;

Line 381: fnd_log.string(fnd_log.level_statement,

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,
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

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

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,
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;

Line 394: fnd_log.string(fnd_log.level_statement,

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,
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

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

397: END IF;
398: ELSE
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;

Line 402: fnd_log.string(fnd_log.level_statement,

398: ELSE
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

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

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 ####');
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, ''));

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

604:
605: IF (p_base_id IS NULL) AND (p_pig IS NULL) THEN
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;

Line 609: fnd_log.string(fnd_log.level_statement,

605: IF (p_base_id IS NULL) AND (p_pig IS NULL) THEN
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:

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

622:
623: IF p_base_id IS NOT NULL THEN
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;

Line 627: fnd_log.string(fnd_log.level_statement,

623: IF p_base_id IS NOT NULL THEN
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:

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

645:
646: IF p_pig IS NOT NULL THEN
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;

Line 650: fnd_log.string(fnd_log.level_statement,

646: IF p_pig IS NOT NULL THEN
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:

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

686: -- Check if Person number and base_id are valid
687: IF (l_person_no IS NOT NULL) AND (l_base_id IS NOT NULL) THEN
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;

Line 691: fnd_log.string(fnd_log.level_statement,

687: IF (l_person_no IS NOT NULL) AND (l_base_id IS NOT NULL) THEN
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: