APPS.IGF_AW_ROLLOVER dependencies on FND_LOG

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

150: END IF;
151: EXCEPTION
152: WHEN OTHERS THEN
153: CLOSE c_get_td_number;
154: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_fund_todo.exception','Error while creating To Do Items');
156: END IF;
157:
158: p_todo_item := l_todo_item;

Line 155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_fund_todo.exception','Error while creating To Do Items');

151: EXCEPTION
152: WHEN OTHERS THEN
153: CLOSE c_get_td_number;
154: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_fund_todo.exception','Error while creating To Do Items');
156: END IF;
157:
158: p_todo_item := l_todo_item;
159: RETURN FALSE;

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

197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: p_todo_item := l_todo_item;
201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_fund_todo.exception','Error while creating To Do Item mapping with fund');
203: END IF;
204: RETURN FALSE;
205:

Line 202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_fund_todo.exception','Error while creating To Do Item mapping with fund');

198: EXCEPTION
199: WHEN OTHERS THEN
200: p_todo_item := l_todo_item;
201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_fund_todo.exception','Error while creating To Do Item mapping with fund');
203: END IF;
204: RETURN FALSE;
205:
206: END create_fund_todo;

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

248: RETURN TRUE;
249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_feeclass.exception','Error while creating feeclass');
254: END IF;
255:
256: RETURN FALSE;

Line 253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_feeclass.exception','Error while creating feeclass');

249:
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
253: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_feeclass.exception','Error while creating feeclass');
254: END IF;
255:
256: RETURN FALSE;
257:

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

311: RETURN TRUE;
312:
313: EXCEPTION
314: WHEN OTHERS THEN
315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_unit.exception','Error while creating pay units');
317: END IF;
318:
319: RETURN FALSE;

Line 316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_unit.exception','Error while creating pay units');

312:
313: EXCEPTION
314: WHEN OTHERS THEN
315: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
316: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_unit.exception','Error while creating pay units');
317: END IF;
318:
319: RETURN FALSE;
320:

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

376: RETURN TRUE;
377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_program.exception','Error while creating pay programs');
382: END IF;
383: RETURN FALSE;
384:

Line 381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_program.exception','Error while creating pay programs');

377:
378: EXCEPTION
379: WHEN OTHERS THEN
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_pay_program.exception','Error while creating pay programs');
382: END IF;
383: RETURN FALSE;
384:
385: END create_pay_program;

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

448: RETURN TRUE;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
453: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_exclusive_fund.exception','Error while creating exclusive fund');
454: END IF;
455: RETURN FALSE;
456:

Line 453: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_exclusive_fund.exception','Error while creating exclusive fund');

449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
453: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_exclusive_fund.exception','Error while creating exclusive fund');
454: END IF;
455: RETURN FALSE;
456:
457: END create_exclusive_fund;

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

519: RETURN TRUE;
520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_inclusive_fund.exception','Error while creating inclusive fund');
525: END IF;
526: RETURN FALSE;
527:

Line 524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_inclusive_fund.exception','Error while creating inclusive fund');

520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
524: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_inclusive_fund.exception','Error while creating inclusive fund');
525: END IF;
526: RETURN FALSE;
527:
528: END create_inclusive_fund;

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

567: END IF;
568:
569: CLOSE c_fund_exists;
570:
571: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.fund_exists.debug','Fund already exists :'||p_fund_code);
573: END IF;
574:
575: RETURN TRUE;

Line 572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.fund_exists.debug','Fund already exists :'||p_fund_code);

568:
569: CLOSE c_fund_exists;
570:
571: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
572: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.fund_exists.debug','Fund already exists :'||p_fund_code);
573: END IF;
574:
575: RETURN TRUE;
576:

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

727: RETURN l_fund_id;
728:
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
732: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_fund.exception','Error while creating new fund :'||p_fund_rec.fund_code);
733: END IF;
734: RETURN NULL;
735:

Line 732: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_fund.exception','Error while creating new fund :'||p_fund_rec.fund_code);

728:
729: EXCEPTION
730: WHEN OTHERS THEN
731: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
732: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_fund.exception','Error while creating new fund :'||p_fund_rec.fund_code);
733: END IF;
734: RETURN NULL;
735:
736: END create_new_fund;

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

779:
780: fnd_file.new_line(fnd_file.log,1);
781: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE')||':' );
782:
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Processing Fund Attributes');
785: END IF;
786:
787: FOR l_fund IN c_fund(p_frm_cal_type, p_frm_sequence_number)

Line 784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Processing Fund Attributes');

780: fnd_file.new_line(fnd_file.log,1);
781: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_ATTRIBUTE')||':' );
782:
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
784: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Processing Fund Attributes');
785: END IF;
786:
787: FOR l_fund IN c_fund(p_frm_cal_type, p_frm_sequence_number)
788: LOOP

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

790: fnd_message.set_name('IGF','IGF_AW_PROC_FUND');
791: fnd_message.set_token('FUND',l_fund.fund_code);
792: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
793:
794: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
795: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Fund :'||l_fund.fund_code);
796: END IF;
797:
798: --Check whether the fund already got rolled over

Line 795: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Fund :'||l_fund.fund_code);

791: fnd_message.set_token('FUND',l_fund.fund_code);
792: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
793:
794: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
795: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Fund :'||l_fund.fund_code);
796: END IF;
797:
798: --Check whether the fund already got rolled over
799: IF fund_exists(l_fund.fund_code, p_to_cal_type, p_to_sequence_number) THEN

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

809: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_DISCONT');
810: fnd_message.set_token('FUND',l_fund.fund_code);
811: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
812:
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Discontinued Fund');
815: END IF;
816:
817: l_discontinued_flg := 'Y';

Line 814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Discontinued Fund');

810: fnd_message.set_token('FUND',l_fund.fund_code);
811: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
812:
813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
814: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Discontinued Fund');
815: END IF;
816:
817: l_discontinued_flg := 'Y';
818: RAISE E_SKIP_FUND;

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

907: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_FND_SUCCFL');
908: fnd_message.set_token('FUND',l_fund.fund_code);
909: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
910:
911: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
912: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Successfully rolled over fund :'||l_fund.fund_code);
913: END IF;
914: EXCEPTION
915: WHEN E_SKIP_FUND THEN

Line 912: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Successfully rolled over fund :'||l_fund.fund_code);

908: fnd_message.set_token('FUND',l_fund.fund_code);
909: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
910:
911: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
912: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.debug','Successfully rolled over fund :'||l_fund.fund_code);
913: END IF;
914: EXCEPTION
915: WHEN E_SKIP_FUND THEN
916: IF l_discontinued_flg = 'N' THEN

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

920: END IF;
921:
922: l_discontinued_flg := 'N';
923:
924: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
925: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.exception','Skipping the fund :'||l_fund.fund_code);
926: END IF;
927:
928: WHEN OTHERS THEN

Line 925: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.exception','Skipping the fund :'||l_fund.fund_code);

921:
922: l_discontinued_flg := 'N';
923:
924: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
925: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.exception','Skipping the fund :'||l_fund.fund_code);
926: END IF;
927:
928: WHEN OTHERS THEN
929: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

927:
928: WHEN OTHERS THEN
929: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
930: fnd_message.set_token('NAME','igf_aw_rollover.rollover_fund_attributes :' || SQLERRM);
931: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
932: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.exception','sql error:'||SQLERRM);
933: END IF;
934:
935: app_exception.raise_exception;

Line 932: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.exception','sql error:'||SQLERRM);

928: WHEN OTHERS THEN
929: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
930: fnd_message.set_token('NAME','igf_aw_rollover.rollover_fund_attributes :' || SQLERRM);
931: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
932: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_fund_attributes.exception','sql error:'||SQLERRM);
933: END IF;
934:
935: app_exception.raise_exception;
936: END;

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

962: BEGIN
963: OPEN c_map_details(p_frm_cal_type, p_frm_sequence_number);
964: FETCH c_map_details INTO p_to_cal_type, p_to_sequence_number;
965: IF c_map_details%NOTFOUND THEN
966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.chk_calendar_mapping.debug','Calendar Mapping does not exist');
968: END IF;
969:
970: CLOSE c_map_details;

Line 967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.chk_calendar_mapping.debug','Calendar Mapping does not exist');

963: OPEN c_map_details(p_frm_cal_type, p_frm_sequence_number);
964: FETCH c_map_details INTO p_to_cal_type, p_to_sequence_number;
965: IF c_map_details%NOTFOUND THEN
966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
967: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.chk_calendar_mapping.debug','Calendar Mapping does not exist');
968: END IF;
969:
970: CLOSE c_map_details;
971: RETURN FALSE;

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

972: END IF;
973:
974: CLOSE c_map_details;
975:
976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.chk_calendar_mapping.debug','Calendar Mapping exists');
978: END IF;
979:
980: RETURN TRUE;

Line 977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.chk_calendar_mapping.debug','Calendar Mapping exists');

973:
974: CLOSE c_map_details;
975:
976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
977: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.chk_calendar_mapping.debug','Calendar Mapping exists');
978: END IF;
979:
980: RETURN TRUE;
981:

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

1022: END IF;
1023:
1024: CLOSE c_item_exists;
1025:
1026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rate_setup_exists.debug','Item already exists :'||p_item_code);
1028: END IF;
1029:
1030: RETURN TRUE;

Line 1027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rate_setup_exists.debug','Item already exists :'||p_item_code);

1023:
1024: CLOSE c_item_exists;
1025:
1026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1027: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rate_setup_exists.debug','Item already exists :'||p_item_code);
1028: END IF;
1029:
1030: RETURN TRUE;
1031:

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

1081:
1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE')||':' );
1084:
1085: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Processing Rate Based Setups');
1087: END IF;
1088:
1089: FOR l_get_itm_code IN c_get_itm_code(p_frm_cal_type, p_frm_sequence_number)

Line 1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Processing Rate Based Setups');

1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_RATE_TABLE')||':' );
1084:
1085: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Processing Rate Based Setups');
1087: END IF;
1088:
1089: FOR l_get_itm_code IN c_get_itm_code(p_frm_cal_type, p_frm_sequence_number)
1090: LOOP

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

1094: fnd_message.set_name('IGF','IGF_AW_PROC_COA_ITEM');
1095: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1096: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item :'||l_get_itm_code.item_code);
1100: END IF;
1101:
1102: --Check whether the item already got rolled over

Line 1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item :'||l_get_itm_code.item_code);

1095: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1096: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1097:
1098: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1099: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item :'||l_get_itm_code.item_code);
1100: END IF;
1101:
1102: --Check whether the item already got rolled over
1103: IF rate_setup_exists(l_get_itm_code.item_code, p_to_cal_type, p_to_sequence_number) THEN

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

1104: fnd_message.set_name('IGF','IGF_AW_ITM_ALRDY_EXISTS');
1105: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1106: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1107:
1108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item already ecists :'||l_get_itm_code.item_code);
1110: END IF;
1111: RAISE E_SKIP_ITEM;
1112: END IF;

Line 1109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item already ecists :'||l_get_itm_code.item_code);

1105: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1106: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1107:
1108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','COA Item already ecists :'||l_get_itm_code.item_code);
1110: END IF;
1111: RAISE E_SKIP_ITEM;
1112: END IF;
1113:

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

1123: fnd_message.set_token('ITEM',l_rate_setup.item_code);
1124: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number));
1125:
1126: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1127: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Calendar Mapping does not exist');
1129: END IF;
1130:
1131: l_error_occurred := 'Y';

Line 1128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Calendar Mapping does not exist');

1124: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number));
1125:
1126: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1127: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Calendar Mapping does not exist');
1129: END IF;
1130:
1131: l_error_occurred := 'Y';
1132: END IF;

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

1166: fnd_message.set_name('IGF','IGF_AW_RT_RLOVR_SUCCFL');
1167: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1168: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1169:
1170: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Successfully rolled over coa item :'||l_get_itm_code.item_code);
1172: END IF;
1173: ELSE
1174: RAISE E_SKIP_ITEM;

Line 1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Successfully rolled over coa item :'||l_get_itm_code.item_code);

1167: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1168: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1169:
1170: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_rate_setups.debug','Successfully rolled over coa item :'||l_get_itm_code.item_code);
1172: END IF;
1173: ELSE
1174: RAISE E_SKIP_ITEM;
1175: END IF;

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

1180: fnd_message.set_name('IGF','IGF_AW_SKIPPING_ITEM');
1181: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1182: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1183:
1184: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1185: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','Skipping the item :'||l_get_itm_code.item_code);
1186: END IF;
1187:
1188: WHEN OTHERS THEN

Line 1185: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','Skipping the item :'||l_get_itm_code.item_code);

1181: fnd_message.set_token('ITEM',l_get_itm_code.item_code);
1182: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1183:
1184: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1185: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','Skipping the item :'||l_get_itm_code.item_code);
1186: END IF;
1187:
1188: WHEN OTHERS THEN
1189: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

1187:
1188: WHEN OTHERS THEN
1189: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1190: fnd_message.set_token('NAME','igf_aw_rollover.rollover_rate_setups :' || SQLERRM);
1191: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1192: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','sql error:'||SQLERRM);
1193: END IF;
1194:
1195: app_exception.raise_exception;

Line 1192: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','sql error:'||SQLERRM);

1188: WHEN OTHERS THEN
1189: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1190: fnd_message.set_token('NAME','igf_aw_rollover.rollover_rate_setups :' || SQLERRM);
1191: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1192: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_rate_setups.exception','sql error:'||SQLERRM);
1193: END IF;
1194:
1195: app_exception.raise_exception;
1196: END;

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

1265: BEGIN
1266: fnd_file.new_line(fnd_file.log,1);
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION')||':' );
1268:
1269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Processing Institutional Applications');
1271: END IF;
1272:
1273: FOR l_get_appln_code IN c_get_appln_code(p_frm_cal_type, p_frm_sequence_number)

Line 1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Processing Institutional Applications');

1266: fnd_file.new_line(fnd_file.log,1);
1267: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','INST_APPLICATION')||':' );
1268:
1269: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1270: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Processing Institutional Applications');
1271: END IF;
1272:
1273: FOR l_get_appln_code IN c_get_appln_code(p_frm_cal_type, p_frm_sequence_number)
1274: LOOP

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

1278: fnd_message.set_name('IGF','IGF_AP_PROC_INST_APLN');
1279: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1280: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1281:
1282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application :'||l_get_appln_code.application_code);
1284: END IF;
1285:
1286: --Check whether the application already got rolled over

Line 1283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application :'||l_get_appln_code.application_code);

1279: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1280: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1281:
1282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1283: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application :'||l_get_appln_code.application_code);
1284: END IF;
1285:
1286: --Check whether the application already got rolled over
1287: OPEN c_appln_exists(p_to_cal_type, p_to_sequence_number, l_get_appln_code.application_code);

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

1291: fnd_message.set_name('IGF','IGF_AP_INST_APLN_ALRDY_EXT');
1292: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1293: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1294:
1295: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application already exists');
1297: END IF;
1298: RAISE E_SKIP_APPLICATION;
1299: END IF;

Line 1296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application already exists');

1292: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1293: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1294:
1295: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1296: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Application already exists');
1297: END IF;
1298: RAISE E_SKIP_APPLICATION;
1299: END IF;
1300: CLOSE c_appln_exists;

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

1313: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);
1314: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_inst_appln_setup.ld_cal_type,l_inst_appln_setup.ld_sequence_number));
1315:
1316: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Calendar Mapping does not exist');
1319: END IF;
1320:
1321: l_error_occurred := 'Y';

Line 1318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Calendar Mapping does not exist');

1314: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_inst_appln_setup.ld_cal_type,l_inst_appln_setup.ld_sequence_number));
1315:
1316: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Calendar Mapping does not exist');
1319: END IF;
1320:
1321: l_error_occurred := 'Y';
1322: END IF;

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

1363: fnd_message.set_name('IGF','IGF_AP_APLN_QUES_ROLL');
1364: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);
1365: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1366:
1367: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);
1369: END IF;
1370: END;
1371: END LOOP;

Line 1368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);

1364: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);
1365: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1366:
1367: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1368: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);
1369: END IF;
1370: END;
1371: END LOOP;
1372:

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

1376: fnd_message.set_name('IGF','IGF_AP_APLN_RLOVR_SUCCFL');
1377: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1378: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1379:
1380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Successfully rolled over Application :'||l_get_appln_code.application_code);
1382: END IF;
1383: ELSE
1384: RAISE E_SKIP_APPLICATION;

Line 1381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Successfully rolled over Application :'||l_get_appln_code.application_code);

1377: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1378: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1379:
1380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1381: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_applications.debug','Successfully rolled over Application :'||l_get_appln_code.application_code);
1382: END IF;
1383: ELSE
1384: RAISE E_SKIP_APPLICATION;
1385: END IF;

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

1391: fnd_message.set_name('IGF','IGF_AP_SKIPPING_INST_APLN');
1392: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1393: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1394:
1395: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1396: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping the application :'||l_get_appln_code.application_code);
1397: END IF;
1398:
1399: WHEN OTHERS THEN

Line 1396: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping the application :'||l_get_appln_code.application_code);

1392: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);
1393: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1394:
1395: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1396: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','Skipping the application :'||l_get_appln_code.application_code);
1397: END IF;
1398:
1399: WHEN OTHERS THEN
1400: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

1398:
1399: WHEN OTHERS THEN
1400: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1401: fnd_message.set_token('NAME','igf_aw_rollover.rollover_inst_applications :' || SQLERRM);
1402: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1403: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','sql error:'||SQLERRM);
1404: END IF;
1405:
1406: app_exception.raise_exception;

Line 1403: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','sql error:'||SQLERRM);

1399: WHEN OTHERS THEN
1400: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1401: fnd_message.set_token('NAME','igf_aw_rollover.rollover_inst_applications :' || SQLERRM);
1402: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1403: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_applications.exception','sql error:'||SQLERRM);
1404: END IF;
1405:
1406: app_exception.raise_exception;
1407: END;

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

1429: l_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE := NULL;
1430:
1431: BEGIN
1432:
1433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan.debug','Insert an Award Distribution Plan');
1435: END IF;
1436:
1437: igf_aw_awd_dist_plans_pkg.insert_row (

Line 1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan.debug','Insert an Award Distribution Plan');

1430:
1431: BEGIN
1432:
1433: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan.debug','Insert an Award Distribution Plan');
1435: END IF;
1436:
1437: igf_aw_awd_dist_plans_pkg.insert_row (
1438: x_mode => 'R',

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

1471: l_adterms_id igf_aw_dp_terms.adterms_id%TYPE := NULL;
1472:
1473: BEGIN
1474:
1475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1476: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_term.debug','Insert term attached to the plan');
1477: END IF;
1478:
1479: igf_aw_dp_terms_pkg.insert_row (

Line 1476: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_term.debug','Insert term attached to the plan');

1472:
1473: BEGIN
1474:
1475: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1476: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_term.debug','Insert term attached to the plan');
1477: END IF;
1478:
1479: igf_aw_dp_terms_pkg.insert_row (
1480: x_mode => 'R',

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

1510: l_rowid VARCHAR2(25):= NULL;
1511: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;
1512:
1513: BEGIN
1514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_tp.debug','Insert teaching period attached to the term');
1516: END IF;
1517:
1518: igf_aw_dp_teach_prds_pkg.insert_row (

Line 1515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_tp.debug','Insert teaching period attached to the term');

1511: l_adteach_id igf_aw_dp_teach_prds.adteach_id%TYPE := NULL;
1512:
1513: BEGIN
1514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_tp.debug','Insert teaching period attached to the term');
1516: END IF;
1517:
1518: igf_aw_dp_teach_prds_pkg.insert_row (
1519: x_mode => 'R',

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

1605:
1606: fnd_file.new_line(fnd_file.log,1);
1607: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN')||':' );
1608:
1609: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1610: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Processing Award Distribution Plans');
1611: END IF;
1612:
1613:

Line 1610: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Processing Award Distribution Plans');

1606: fnd_file.new_line(fnd_file.log,1);
1607: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_DISTRIBUTION_PLAN')||':' );
1608:
1609: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1610: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Processing Award Distribution Plans');
1611: END IF;
1612:
1613:
1614: FOR l_distb_plan_setup IN c_distb_plan_setup(p_frm_cal_type, p_frm_sequence_number)

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

1619: fnd_message.set_name('IGF','IGF_AW_PROC_DIST_PLAN');
1620: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1621: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1622:
1623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1625: END IF;
1626:
1627: --Check whether the distribution plan already got rolled over or not

Line 1624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan :'||l_distb_plan_setup.awd_dist_plan_cd);

1620: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1621: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1622:
1623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1625: END IF;
1626:
1627: --Check whether the distribution plan already got rolled over or not
1628: OPEN c_plan_exists(p_to_cal_type, p_to_sequence_number, l_distb_plan_setup.awd_dist_plan_cd);

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

1632: fnd_message.set_name('IGF','IGF_AW_PLN_ALRDY_EXISTS');
1633: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1634: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1635:
1636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan already exists');
1638: END IF;
1639: RAISE E_SKIP_PLAN;
1640: END IF;

Line 1637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan already exists');

1633: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1634: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1635:
1636: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1637: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Distribution Plan already exists');
1638: END IF;
1639: RAISE E_SKIP_PLAN;
1640: END IF;
1641: CLOSE c_plan_exists;

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

1721: fnd_message.set_name('IGF','IGF_AW_PLN_RLOVR_SUCCFL');
1722: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1723: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1724:
1725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Successfully rolled over distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1727: END IF;
1728: ELSE
1729: RAISE E_SKIP_PLAN;

Line 1726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Successfully rolled over distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);

1722: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1723: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1724:
1725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.debug','Successfully rolled over distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1727: END IF;
1728: ELSE
1729: RAISE E_SKIP_PLAN;
1730: END IF;

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

1735: fnd_message.set_name('IGF','IGF_AW_SKIPPING_PLAN');
1736: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1737: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1738:
1739: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1740: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','Skipping the distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1741: END IF;
1742:
1743: WHEN OTHERS THEN

Line 1740: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','Skipping the distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);

1736: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);
1737: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1738:
1739: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1740: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','Skipping the distribution plan :'||l_distb_plan_setup.awd_dist_plan_cd);
1741: END IF;
1742:
1743: WHEN OTHERS THEN
1744: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

1742:
1743: WHEN OTHERS THEN
1744: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1745: fnd_message.set_token('NAME','igf_aw_rollover.rollover_distribution_plans :' || SQLERRM);
1746: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1747: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','sql error:'||SQLERRM);
1748: END IF;
1749:
1750: app_exception.raise_exception;

Line 1747: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','sql error:'||SQLERRM);

1743: WHEN OTHERS THEN
1744: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1745: fnd_message.set_token('NAME','igf_aw_rollover.rollover_distribution_plans :' || SQLERRM);
1746: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1747: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_distribution_plans.exception','sql error:'||SQLERRM);
1748: END IF;
1749:
1750: app_exception.raise_exception;
1751: END;

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

1860:
1861: fnd_file.new_line(fnd_file.log,1);
1862: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP')||':' );
1863:
1864: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1865: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Processing COA Groups');
1866: END IF;
1867:
1868:

Line 1865: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Processing COA Groups');

1861: fnd_file.new_line(fnd_file.log,1);
1862: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','COA_GROUP')||':' );
1863:
1864: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1865: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Processing COA Groups');
1866: END IF;
1867:
1868:
1869: FOR l_coa_grp_setup IN c_coa_grp_setup(p_frm_cal_type, p_frm_sequence_number)

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

1874: fnd_message.set_name('IGF','IGF_AW_PROC_COA_GROUP');
1875: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
1876: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1877:
1878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group :'||l_coa_grp_setup.coa_code);
1880: END IF;
1881:
1882:

Line 1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group :'||l_coa_grp_setup.coa_code);

1875: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
1876: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
1877:
1878: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1879: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group :'||l_coa_grp_setup.coa_code);
1880: END IF;
1881:
1882:
1883: --Check whether the COA Group already got rolled over or not

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

1888: fnd_message.set_name('IGF','IGF_AW_COA_GRP_ALRDY_EXISTS');
1889: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
1890: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1891:
1892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group already exists');
1894: END IF;
1895:
1896: RAISE E_SKIP_COA_GRP;

Line 1893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group already exists');

1889: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
1890: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1891:
1892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Group already exists');
1894: END IF;
1895:
1896: RAISE E_SKIP_COA_GRP;
1897: END IF;

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

1917:
1918: FOR l_coa_item IN c_coa_item(p_frm_cal_type, p_frm_sequence_number, l_coa_grp_setup.coa_code)
1919: LOOP
1920:
1921: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1922: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Item :'||l_coa_item.item_code);
1923: END IF;
1924:
1925: --check the COA Item in the rate table for the source award year

Line 1922: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Item :'||l_coa_item.item_code);

1918: FOR l_coa_item IN c_coa_item(p_frm_cal_type, p_frm_sequence_number, l_coa_grp_setup.coa_code)
1919: LOOP
1920:
1921: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1922: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','COA Item :'||l_coa_item.item_code);
1923: END IF;
1924:
1925: --check the COA Item in the rate table for the source award year
1926: --OPEN c_coa_itm_exists(p_frm_cal_type, p_frm_sequence_number, l_coa_item.item_code);

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

1937: fnd_message.set_token('ITEM',l_coa_item.item_code);
1938: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
1939: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1940:
1941: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1942: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Rate Setup does not exist in the target award year');
1943: END IF;
1944:
1945: --l_error_occurred := 'Y';

Line 1942: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Rate Setup does not exist in the target award year');

1938: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
1939: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1940:
1941: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1942: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Rate Setup does not exist in the target award year');
1943: END IF;
1944:
1945: --l_error_occurred := 'Y';
1946: END IF;

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

1974:
1975:
1976: FOR l_ld_coa IN c_ld_coa(p_frm_cal_type, p_frm_sequence_number, l_coa_grp_setup.coa_code)
1977: LOOP
1978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Term attached to the Item');
1980: END IF;
1981:
1982: l_to_ld_cal_type := NULL;

Line 1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Term attached to the Item');

1975:
1976: FOR l_ld_coa IN c_ld_coa(p_frm_cal_type, p_frm_sequence_number, l_coa_grp_setup.coa_code)
1977: LOOP
1978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Term attached to the Item');
1980: END IF;
1981:
1982: l_to_ld_cal_type := NULL;
1983: l_to_ld_sequence_number := NULL;

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

2008: END LOOP; -- end of FOR l_ld_coa IN c_ld_coa
2009:
2010: FOR l_overridden_item IN c_overridden_item(p_frm_cal_type, p_frm_sequence_number, l_coa_grp_setup.coa_code)
2011: LOOP
2012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Overridden COA Item :'||l_overridden_item.item_code);
2014: END IF;
2015:
2016: l_to_ld_cal_type := NULL;

Line 2013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Overridden COA Item :'||l_overridden_item.item_code);

2009:
2010: FOR l_overridden_item IN c_overridden_item(p_frm_cal_type, p_frm_sequence_number, l_coa_grp_setup.coa_code)
2011: LOOP
2012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Overridden COA Item :'||l_overridden_item.item_code);
2014: END IF;
2015:
2016: l_to_ld_cal_type := NULL;
2017: l_to_ld_sequence_number := NULL;

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

2050: fnd_message.set_name('IGF','IGF_AW_COA_GRP_RLOVR_SUCCFL');
2051: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
2052: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2053:
2054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Successfully rolled over coa group :'||l_coa_grp_setup.coa_code);
2056: END IF;
2057: ELSE
2058: RAISE E_SKIP_COA_GRP;

Line 2055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Successfully rolled over coa group :'||l_coa_grp_setup.coa_code);

2051: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
2052: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2053:
2054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2055: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_coa_groups.debug','Successfully rolled over coa group :'||l_coa_grp_setup.coa_code);
2056: END IF;
2057: ELSE
2058: RAISE E_SKIP_COA_GRP;
2059: END IF;

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

2064: fnd_message.set_name('IGF','IGF_AW_SKIPPING_COA_GRP');
2065: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
2066: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2067:
2068: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2069: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','Skipping the COA group :'||l_coa_grp_setup.coa_code);
2070: END IF;
2071:
2072: WHEN OTHERS THEN

Line 2069: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','Skipping the COA group :'||l_coa_grp_setup.coa_code);

2065: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);
2066: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2067:
2068: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2069: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','Skipping the COA group :'||l_coa_grp_setup.coa_code);
2070: END IF;
2071:
2072: WHEN OTHERS THEN
2073: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

2071:
2072: WHEN OTHERS THEN
2073: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2074: fnd_message.set_token('NAME','igf_aw_rollover.rollover_coa_groups :' || SQLERRM);
2075: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2076: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','sql error:'||SQLERRM);
2077: END IF;
2078:
2079: app_exception.raise_exception;

Line 2076: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','sql error:'||SQLERRM);

2072: WHEN OTHERS THEN
2073: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2074: fnd_message.set_token('NAME','igf_aw_rollover.rollover_coa_groups :' || SQLERRM);
2075: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2076: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_coa_groups.exception','sql error:'||SQLERRM);
2077: END IF;
2078:
2079: app_exception.raise_exception;
2080: END;

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

2132:
2133: fnd_file.new_line(fnd_file.log,1);
2134: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM')||':' );
2135:
2136: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2137: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Processing To Do Items');
2138: END IF;
2139:
2140:

Line 2137: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Processing To Do Items');

2133: fnd_file.new_line(fnd_file.log,1);
2134: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TODO_ITEM')||':' );
2135:
2136: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2137: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Processing To Do Items');
2138: END IF;
2139:
2140:
2141: FOR l_todo_item_setup IN c_todo_item_setup(p_frm_cal_type, p_frm_sequence_number)

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

2146: fnd_message.set_name('IGF','IGF_AP_PROC_TODO_ITEM');
2147: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2148: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
2149:
2150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item :'||l_todo_item_setup.item_code);
2152: END IF;
2153:
2154: --Check whether the todo item already got rolled over

Line 2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item :'||l_todo_item_setup.item_code);

2147: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2148: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
2149:
2150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item :'||l_todo_item_setup.item_code);
2152: END IF;
2153:
2154: --Check whether the todo item already got rolled over
2155: OPEN c_todo_exists(p_to_cal_type, p_to_sequence_number, l_todo_item_setup.item_code);

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

2159: fnd_message.set_name('IGF','IGF_AP_TODO_ALRDY_EXISTS');
2160: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2161: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2162:
2163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item already exists');
2165: END IF;
2166:
2167: RAISE E_SKIP_TODO;

Line 2164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item already exists');

2160: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2161: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2162:
2163: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2164: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','To Do Item already exists');
2165: END IF;
2166:
2167: RAISE E_SKIP_TODO;
2168: END IF;

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

2215: fnd_message.set_name('IGF','IGF_AP_TODO_RLOVR_SUCCFL');
2216: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2217: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2218:
2219: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Successfully rolled over To Do Item :'||l_todo_item_setup.item_code);
2221: END IF;
2222:
2223: EXCEPTION

Line 2220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Successfully rolled over To Do Item :'||l_todo_item_setup.item_code);

2216: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2217: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2218:
2219: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2220: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_todo_items.debug','Successfully rolled over To Do Item :'||l_todo_item_setup.item_code);
2221: END IF;
2222:
2223: EXCEPTION
2224: WHEN E_SKIP_TODO THEN

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

2225: fnd_message.set_name('IGF','IGF_AP_SKIPPING_TODO');
2226: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2227: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2228:
2229: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2230: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','Skipping the To Do Item :'||l_todo_item_setup.item_code);
2231: END IF;
2232:
2233: WHEN OTHERS THEN

Line 2230: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','Skipping the To Do Item :'||l_todo_item_setup.item_code);

2226: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2227: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2228:
2229: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2230: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','Skipping the To Do Item :'||l_todo_item_setup.item_code);
2231: END IF;
2232:
2233: WHEN OTHERS THEN
2234: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

2232:
2233: WHEN OTHERS THEN
2234: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2235: fnd_message.set_token('NAME','igf_aw_rollover.rollover_todo_items :' || SQLERRM);
2236: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2237: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','sql error:'||SQLERRM);
2238: END IF;
2239:
2240: app_exception.raise_exception;

Line 2237: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','sql error:'||SQLERRM);

2233: WHEN OTHERS THEN
2234: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2235: fnd_message.set_token('NAME','igf_aw_rollover.rollover_todo_items :' || SQLERRM);
2236: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2237: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_todo_items.exception','sql error:'||SQLERRM);
2238: END IF;
2239:
2240: app_exception.raise_exception;
2241: END;

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

2439:
2440: fnd_file.new_line(fnd_file.log,1);
2441: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP')||':' );
2442:
2443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Processing Award Groups');
2445: END IF;
2446:
2447: FOR l_award_grp_setup IN c_award_grp_setup(p_frm_cal_type, p_frm_sequence_number)

Line 2444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Processing Award Groups');

2440: fnd_file.new_line(fnd_file.log,1);
2441: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GROUP')||':' );
2442:
2443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Processing Award Groups');
2445: END IF;
2446:
2447: FOR l_award_grp_setup IN c_award_grp_setup(p_frm_cal_type, p_frm_sequence_number)
2448: LOOP

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

2453: fnd_message.set_name('IGF','IGF_AW_PROC_AWD_GROUP');
2454: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2455: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
2456:
2457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group :'||l_award_grp_setup.group_cd);
2459: END IF;
2460:
2461:

Line 2458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group :'||l_award_grp_setup.group_cd);

2454: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2455: fnd_file.put_line(fnd_file.log, RPAD(' ',5)|| fnd_message.get);
2456:
2457: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2458: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group :'||l_award_grp_setup.group_cd);
2459: END IF;
2460:
2461:
2462: --Check whether the award group already got rolled over

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

2467: fnd_message.set_name('IGF','IGF_AW_AWD_GRP_ALRDY_EXISTS');
2468: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2469: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2470:
2471: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2472: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group already exists');
2473: END IF;
2474:
2475: RAISE E_SKIP_AWARD_GRP;

Line 2472: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group already exists');

2468: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2469: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2470:
2471: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2472: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Group already exists');
2473: END IF;
2474:
2475: RAISE E_SKIP_AWARD_GRP;
2476: END IF;

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

2487: fnd_message.set_token('PLAN',get_plan_cd(l_award_grp_setup.adplans_id, p_frm_cal_type, p_frm_sequence_number));
2488: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2489: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2490:
2491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Distribution Plan does not exist');
2493: END IF;
2494:
2495: l_error_occurred := 'Y';

Line 2492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Distribution Plan does not exist');

2488: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2489: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2490:
2491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2492: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Distribution Plan does not exist');
2493: END IF;
2494:
2495: l_error_occurred := 'Y';
2496: END IF;

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

2545:
2546: -- Get the sequence of funds attached to the formula
2547: FOR l_formula_setup IN c_formula_setup(p_frm_cal_type, p_frm_sequence_number, l_award_grp_setup.group_cd)
2548: LOOP
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Formula Code :'||l_formula_setup.formula_code);
2551: END IF;
2552:
2553: --Check the existence of the FUND in the target award year

Line 2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Formula Code :'||l_formula_setup.formula_code);

2546: -- Get the sequence of funds attached to the formula
2547: FOR l_formula_setup IN c_formula_setup(p_frm_cal_type, p_frm_sequence_number, l_award_grp_setup.group_cd)
2548: LOOP
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Formula Code :'||l_formula_setup.formula_code);
2551: END IF;
2552:
2553: --Check the existence of the FUND in the target award year
2554: OPEN c_fund_exists(p_frm_cal_type, p_frm_sequence_number, p_to_cal_type, p_to_sequence_number, l_formula_setup.fund_id);

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

2558: fnd_message.set_token('FUND',get_fund_cd(l_formula_setup.fund_id, p_frm_cal_type, p_frm_sequence_number));
2559: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2560: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2561:
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Fund does not exist');
2564: END IF;
2565:
2566: l_error_occurred := 'Y';

Line 2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Fund does not exist');

2559: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2560: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2561:
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Fund does not exist');
2564: END IF;
2565:
2566: l_error_occurred := 'Y';
2567: END IF;

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

2578: fnd_message.set_token('PLAN',get_plan_cd(l_formula_setup.adplans_id, p_frm_cal_type, p_frm_sequence_number));
2579: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2580: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Distribution Plan does not exist');
2584: END IF;
2585:
2586: l_error_occurred := 'Y';

Line 2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Distribution Plan does not exist');

2579: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));
2580: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2581:
2582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Award Distribution Plan does not exist');
2584: END IF;
2585:
2586: l_error_occurred := 'Y';
2587: END IF;

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

2619: fnd_message.set_name('IGF','IGF_AW_AWD_GRP_RLOVR_SUCCFL');
2620: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2621: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2622:
2623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Successfully rolled over award group :'||l_award_grp_setup.group_cd);
2625: END IF;
2626: ELSE
2627: RAISE E_SKIP_AWARD_GRP;

Line 2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Successfully rolled over award group :'||l_award_grp_setup.group_cd);

2620: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2621: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2622:
2623: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_award_groups.debug','Successfully rolled over award group :'||l_award_grp_setup.group_cd);
2625: END IF;
2626: ELSE
2627: RAISE E_SKIP_AWARD_GRP;
2628: END IF;

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

2633: fnd_message.set_name('IGF','IGF_AW_SKIPPING_AWD_GRP');
2634: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2635: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2636:
2637: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2638: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','Skipping the Award Group :'||l_award_grp_setup.group_cd);
2639: END IF;
2640:
2641: WHEN OTHERS THEN

Line 2638: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','Skipping the Award Group :'||l_award_grp_setup.group_cd);

2634: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);
2635: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2636:
2637: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2638: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','Skipping the Award Group :'||l_award_grp_setup.group_cd);
2639: END IF;
2640:
2641: WHEN OTHERS THEN
2642: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

2640:
2641: WHEN OTHERS THEN
2642: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2643: fnd_message.set_token('NAME','igf_aw_rollover.rollover_award_groups :' || SQLERRM);
2644: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2645: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','sql error:'||SQLERRM);
2646: END IF;
2647:
2648: app_exception.raise_exception;

Line 2645: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','sql error:'||SQLERRM);

2641: WHEN OTHERS THEN
2642: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2643: fnd_message.set_token('NAME','igf_aw_rollover.rollover_award_groups :' || SQLERRM);
2644: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2645: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_award_groups.exception','sql error:'||SQLERRM);
2646: END IF;
2647:
2648: app_exception.raise_exception;
2649: END;

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

2703: l_to_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2704:
2705: BEGIN
2706:
2707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Processing Institutional Applications');
2709: END IF;
2710:
2711: SAVEPOINT rollover_inst_attch_todo;

Line 2708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Processing Institutional Applications');

2704:
2705: BEGIN
2706:
2707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Processing Institutional Applications');
2709: END IF;
2710:
2711: SAVEPOINT rollover_inst_attch_todo;
2712:

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

2709: END IF;
2710:
2711: SAVEPOINT rollover_inst_attch_todo;
2712:
2713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Application :'||p_application_code);
2715: END IF;
2716:
2717: --Check whether the application already got rolled over

Line 2714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Application :'||p_application_code);

2710:
2711: SAVEPOINT rollover_inst_attch_todo;
2712:
2713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Application :'||p_application_code);
2715: END IF;
2716:
2717: --Check whether the application already got rolled over
2718: OPEN c_appln_exists(p_to_cal_type, p_to_sequence_number, p_application_code);

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

2719: FETCH c_appln_exists INTO l_appln_exists;
2720: IF c_appln_exists%FOUND THEN
2721: CLOSE c_appln_exists;
2722:
2723: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2724: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Application already exists');
2725: END IF;
2726: RETURN 'N';
2727: END IF;

Line 2724: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Application already exists');

2720: IF c_appln_exists%FOUND THEN
2721: CLOSE c_appln_exists;
2722:
2723: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2724: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Application already exists');
2725: END IF;
2726: RETURN 'N';
2727: END IF;
2728: CLOSE c_appln_exists;

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

2736:
2737: IF l_inst_appln_setup.ld_cal_type IS NOT NULL AND l_inst_appln_setup.ld_sequence_number IS NOT NULL THEN
2738: IF NOT chk_calendar_mapping(l_inst_appln_setup.ld_cal_type,l_inst_appln_setup.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
2739:
2740: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2741: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Calendar Mapping does not exist');
2742: END IF;
2743:
2744: l_error_occurred := 'Y';

Line 2741: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Calendar Mapping does not exist');

2737: IF l_inst_appln_setup.ld_cal_type IS NOT NULL AND l_inst_appln_setup.ld_sequence_number IS NOT NULL THEN
2738: IF NOT chk_calendar_mapping(l_inst_appln_setup.ld_cal_type,l_inst_appln_setup.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
2739:
2740: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2741: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Calendar Mapping does not exist');
2742: END IF;
2743:
2744: l_error_occurred := 'Y';
2745: END IF;

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

2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: l_error_occurred := 'Y';
2785:
2786: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2787: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);
2788: END IF;
2789: END;
2790: END LOOP;

Line 2787: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);

2783: WHEN OTHERS THEN
2784: l_error_occurred := 'Y';
2785:
2786: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2787: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','Skipping Question ID :'||l_inst_appln_setup.question_id);
2788: END IF;
2789: END;
2790: END LOOP;
2791:

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

2789: END;
2790: END LOOP;
2791:
2792: IF l_error_occurred = 'N' THEN
2793: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Successfully rolled over Application :'||p_application_code);
2795: END IF;
2796:
2797: RETURN 'N';

Line 2794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Successfully rolled over Application :'||p_application_code);

2790: END LOOP;
2791:
2792: IF l_error_occurred = 'N' THEN
2793: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2794: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.debug','Successfully rolled over Application :'||p_application_code);
2795: END IF;
2796:
2797: RETURN 'N';
2798: ELSE

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

2802: EXCEPTION
2803: WHEN E_SKIP_APPLICATION THEN
2804: ROLLBACK TO rollover_inst_attch_todo;
2805:
2806: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2807: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','Skipping the application :'||p_application_code);
2808: END IF;
2809:
2810: RETURN 'Y';

Line 2807: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','Skipping the application :'||p_application_code);

2803: WHEN E_SKIP_APPLICATION THEN
2804: ROLLBACK TO rollover_inst_attch_todo;
2805:
2806: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2807: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','Skipping the application :'||p_application_code);
2808: END IF;
2809:
2810: RETURN 'Y';
2811:

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

2811:
2812: WHEN OTHERS THEN
2813: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2814: fnd_message.set_token('NAME','igf_aw_rollover.rollover_inst_attch_todo :' || SQLERRM);
2815: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2816: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','sql error:'||SQLERRM);
2817: END IF;
2818: app_exception.raise_exception;
2819:

Line 2816: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','sql error:'||SQLERRM);

2812: WHEN OTHERS THEN
2813: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2814: fnd_message.set_token('NAME','igf_aw_rollover.rollover_inst_attch_todo :' || SQLERRM);
2815: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2816: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rollover.rollover_inst_attch_todo.exception','sql error:'||SQLERRM);
2817: END IF;
2818: app_exception.raise_exception;
2819:
2820: END rollover_inst_attch_todo;

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

2888: END IF;
2889: CLOSE c_get_to_awdyr;
2890:
2891:
2892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);
2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);

Line 2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);

2889: CLOSE c_get_to_awdyr;
2890:
2891:
2892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);
2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);

Line 2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);

2890:
2891:
2892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);
2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);

Line 2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);

2891:
2892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);
2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);

Line 2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);

2892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);
2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);
2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);

Line 2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);

2893: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_frm_award_year:'||p_frm_award_year);
2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);
2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);
2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);

Line 2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);

2894: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_to_award_year:'||lv_to_award_year);
2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);
2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);
2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);
2902: END IF;

Line 2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);

2895: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_fund_attribute:'||p_fund_attribute);
2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);
2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);
2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);
2902: END IF;
2903:

Line 2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);

2896: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_rate_table:'||p_rate_table);
2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);
2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);
2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);
2902: END IF;
2903:
2904: fnd_file.new_line(fnd_file.log,1);

Line 2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);

2897: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_inst_application:'||p_inst_application);
2898: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_distribution_plan:'||p_distribution_plan);
2899: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_coa_group:'||p_coa_group);
2900: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_todo:'||p_todo);
2901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','p_award_grp:'||p_award_grp);
2902: END IF;
2903:
2904: fnd_file.new_line(fnd_file.log,1);
2905:

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

2921:
2922:
2923: -- Rollover Fund Attribute Setup
2924: IF NVL(p_fund_attribute,'N') = 'Y' THEN
2925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Fund rollover sub-process');
2927: END IF;
2928:
2929: rollover_fund_attributes( p_frm_cal_type => lv_frm_cal_type,

Line 2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Fund rollover sub-process');

2922:
2923: -- Rollover Fund Attribute Setup
2924: IF NVL(p_fund_attribute,'N') = 'Y' THEN
2925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2926: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Fund rollover sub-process');
2927: END IF;
2928:
2929: rollover_fund_attributes( p_frm_cal_type => lv_frm_cal_type,
2930: p_frm_sequence_number => ln_frm_sequence_number,

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

2934: END IF;
2935:
2936: -- Rollover Cost of Attendance Rate Table Setup
2937: IF NVL(p_rate_table,'N') = 'Y' THEN
2938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Cost of Attendance Rate Table rollover sub-process');
2940: END IF;
2941:
2942: rollover_rate_setups( p_frm_cal_type => lv_frm_cal_type,

Line 2939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Cost of Attendance Rate Table rollover sub-process');

2935:
2936: -- Rollover Cost of Attendance Rate Table Setup
2937: IF NVL(p_rate_table,'N') = 'Y' THEN
2938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Cost of Attendance Rate Table rollover sub-process');
2940: END IF;
2941:
2942: rollover_rate_setups( p_frm_cal_type => lv_frm_cal_type,
2943: p_frm_sequence_number => ln_frm_sequence_number,

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

2948:
2949:
2950: -- Rollover Institutional Application Setup
2951: IF NVL(p_inst_application,'N') = 'Y' THEN
2952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2953: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Institutional Application rollover sub-process');
2954: END IF;
2955:
2956:

Line 2953: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Institutional Application rollover sub-process');

2949:
2950: -- Rollover Institutional Application Setup
2951: IF NVL(p_inst_application,'N') = 'Y' THEN
2952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2953: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Institutional Application rollover sub-process');
2954: END IF;
2955:
2956:
2957: rollover_inst_applications( p_frm_cal_type => lv_frm_cal_type,

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

2963:
2964:
2965: -- Rollover Award Distribution Plan Setup
2966: IF NVL(p_distribution_plan,'N') = 'Y' THEN
2967: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Award Distribution Plan rollover sub-process');
2969: END IF;
2970:
2971: rollover_distribution_plans(p_frm_cal_type => lv_frm_cal_type,

Line 2968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Award Distribution Plan rollover sub-process');

2964:
2965: -- Rollover Award Distribution Plan Setup
2966: IF NVL(p_distribution_plan,'N') = 'Y' THEN
2967: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2968: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Award Distribution Plan rollover sub-process');
2969: END IF;
2970:
2971: rollover_distribution_plans(p_frm_cal_type => lv_frm_cal_type,
2972: p_frm_sequence_number => ln_frm_sequence_number,

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

2976: END IF;
2977:
2978: -- Rollover Cost of Attendance Group Setup
2979: IF NVL(p_coa_group,'N') = 'Y' THEN
2980: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2981: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Cost of Attendance Group rollover sub-process');
2982: END IF;
2983:
2984: rollover_coa_groups(p_frm_cal_type => lv_frm_cal_type,

Line 2981: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Cost of Attendance Group rollover sub-process');

2977:
2978: -- Rollover Cost of Attendance Group Setup
2979: IF NVL(p_coa_group,'N') = 'Y' THEN
2980: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2981: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Cost of Attendance Group rollover sub-process');
2982: END IF;
2983:
2984: rollover_coa_groups(p_frm_cal_type => lv_frm_cal_type,
2985: p_frm_sequence_number => ln_frm_sequence_number,

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

2989: END IF;
2990:
2991: -- Rollover To Do Item Setup
2992: IF NVL(p_todo,'N') = 'Y' THEN
2993: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2994: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling To Do Item rollover sub-process');
2995: END IF;
2996:
2997: rollover_todo_items(p_frm_cal_type => lv_frm_cal_type,

Line 2994: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling To Do Item rollover sub-process');

2990:
2991: -- Rollover To Do Item Setup
2992: IF NVL(p_todo,'N') = 'Y' THEN
2993: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2994: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling To Do Item rollover sub-process');
2995: END IF;
2996:
2997: rollover_todo_items(p_frm_cal_type => lv_frm_cal_type,
2998: p_frm_sequence_number => ln_frm_sequence_number,

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

3002: END IF;
3003:
3004: -- Rollover Award Group Setup
3005: IF NVL(p_award_grp,'N') = 'Y' THEN
3006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3007: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Award Group rollover sub-process');
3008: END IF;
3009:
3010: rollover_award_groups(p_frm_cal_type => lv_frm_cal_type,

Line 3007: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Award Group rollover sub-process');

3003:
3004: -- Rollover Award Group Setup
3005: IF NVL(p_award_grp,'N') = 'Y' THEN
3006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3007: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.main.debug','Calling Award Group rollover sub-process');
3008: END IF;
3009:
3010: rollover_award_groups(p_frm_cal_type => lv_frm_cal_type,
3011: p_frm_sequence_number => ln_frm_sequence_number,