eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_ROLLOVER dependencies on FND_MESSAGE

Line 143: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');

139:
140: IF lv_return_flg = 'Y' THEN
141: p_todo_item := l_todo_item;
142:
143: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
144: fnd_message.set_token('APPLICATION',l_get_fund_todo.application_code);
145: fnd_message.set_token('ITEM',l_todo_item);
146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
147:

Line 144: fnd_message.set_token('APPLICATION',l_get_fund_todo.application_code);

140: IF lv_return_flg = 'Y' THEN
141: p_todo_item := l_todo_item;
142:
143: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
144: fnd_message.set_token('APPLICATION',l_get_fund_todo.application_code);
145: fnd_message.set_token('ITEM',l_todo_item);
146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
147:
148: RETURN FALSE;

Line 145: fnd_message.set_token('ITEM',l_todo_item);

141: p_todo_item := l_todo_item;
142:
143: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
144: fnd_message.set_token('APPLICATION',l_get_fund_todo.application_code);
145: fnd_message.set_token('ITEM',l_todo_item);
146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
147:
148: RETURN FALSE;
149: END IF;

Line 146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

142:
143: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
144: fnd_message.set_token('APPLICATION',l_get_fund_todo.application_code);
145: fnd_message.set_token('ITEM',l_todo_item);
146: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
147:
148: RETURN FALSE;
149: END IF;
150: END IF;

Line 790: fnd_message.set_name('IGF','IGF_AW_PROC_FUND');

786:
787: FOR l_fund IN c_fund(p_frm_cal_type, p_frm_sequence_number)
788: LOOP
789: BEGIN
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

Line 791: fnd_message.set_token('FUND',l_fund.fund_code);

787: FOR l_fund IN c_fund(p_frm_cal_type, p_frm_sequence_number)
788: LOOP
789: BEGIN
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);

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

788: LOOP
789: BEGIN
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;

Line 800: fnd_message.set_name('IGF','IGF_AW_FND_ALRDY_PRSNT');

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
800: fnd_message.set_name('IGF','IGF_AW_FND_ALRDY_PRSNT');
801: fnd_message.set_token('FUND',l_fund.fund_code);
802: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
803:
804: RAISE E_SKIP_FUND;

Line 801: fnd_message.set_token('FUND',l_fund.fund_code);

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
800: fnd_message.set_name('IGF','IGF_AW_FND_ALRDY_PRSNT');
801: fnd_message.set_token('FUND',l_fund.fund_code);
802: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
803:
804: RAISE E_SKIP_FUND;
805: END IF;

Line 802: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

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
800: fnd_message.set_name('IGF','IGF_AW_FND_ALRDY_PRSNT');
801: fnd_message.set_token('FUND',l_fund.fund_code);
802: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
803:
804: RAISE E_SKIP_FUND;
805: END IF;
806:

Line 809: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_DISCONT');

805: END IF;
806:
807: --Check for discontinued fund
808: IF l_fund.discontinue_fund = 'Y' 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

Line 810: fnd_message.set_token('FUND',l_fund.fund_code);

806:
807: --Check for discontinued fund
808: IF l_fund.discontinue_fund = 'Y' 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');

Line 811: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

807: --Check for discontinued fund
808: IF l_fund.discontinue_fund = 'Y' 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;

Line 830: fnd_message.set_name('IGF','IGF_AW_INSERT_FUND_ERR');

826: p_to_sequence_number => p_to_sequence_number
827: );
828:
829: IF l_new_fund_id IS NULL THEN
830: fnd_message.set_name('IGF','IGF_AW_INSERT_FUND_ERR');
831: fnd_message.set_token('FUND',l_fund.fund_code);
832: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
833:
834: ROLLBACK TO rollover_fund_attributes;

Line 831: fnd_message.set_token('FUND',l_fund.fund_code);

827: );
828:
829: IF l_new_fund_id IS NULL THEN
830: fnd_message.set_name('IGF','IGF_AW_INSERT_FUND_ERR');
831: fnd_message.set_token('FUND',l_fund.fund_code);
832: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
833:
834: ROLLBACK TO rollover_fund_attributes;
835: RAISE E_SKIP_FUND;

Line 832: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

828:
829: IF l_new_fund_id IS NULL THEN
830: fnd_message.set_name('IGF','IGF_AW_INSERT_FUND_ERR');
831: fnd_message.set_token('FUND',l_fund.fund_code);
832: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
833:
834: ROLLBACK TO rollover_fund_attributes;
835: RAISE E_SKIP_FUND;
836:

Line 841: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_INCL_FLD');

837: ELSE
838: l_inclusive_fund := NULL;
839: --Skip the fund if creation of inclusive fund is not successful
840: IF NOT create_inclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_inclusive_fund) THEN
841: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_INCL_FLD');
842: fnd_message.set_token('FUND',l_inclusive_fund);
843: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
844:
845: ROLLBACK TO rollover_fund_attributes;

Line 842: fnd_message.set_token('FUND',l_inclusive_fund);

838: l_inclusive_fund := NULL;
839: --Skip the fund if creation of inclusive fund is not successful
840: IF NOT create_inclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_inclusive_fund) THEN
841: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_INCL_FLD');
842: fnd_message.set_token('FUND',l_inclusive_fund);
843: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
844:
845: ROLLBACK TO rollover_fund_attributes;
846: RAISE E_SKIP_FUND;

Line 843: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

839: --Skip the fund if creation of inclusive fund is not successful
840: IF NOT create_inclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_inclusive_fund) THEN
841: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_INCL_FLD');
842: fnd_message.set_token('FUND',l_inclusive_fund);
843: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
844:
845: ROLLBACK TO rollover_fund_attributes;
846: RAISE E_SKIP_FUND;
847: END IF;

Line 852: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_EXCL_FLD');

848:
849: l_exclusive_fund := NULL;
850: --Skip the fund if creation of exclusive fund is not successful
851: IF NOT create_exclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_exclusive_fund) THEN
852: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_EXCL_FLD');
853: fnd_message.set_token('FUND',l_exclusive_fund);
854: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
855:
856: ROLLBACK TO rollover_fund_attributes;

Line 853: fnd_message.set_token('FUND',l_exclusive_fund);

849: l_exclusive_fund := NULL;
850: --Skip the fund if creation of exclusive fund is not successful
851: IF NOT create_exclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_exclusive_fund) THEN
852: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_EXCL_FLD');
853: fnd_message.set_token('FUND',l_exclusive_fund);
854: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
855:
856: ROLLBACK TO rollover_fund_attributes;
857: RAISE E_SKIP_FUND;

Line 854: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

850: --Skip the fund if creation of exclusive fund is not successful
851: IF NOT create_exclusive_fund(l_fund.fund_id, l_new_fund_id, p_frm_cal_type, p_frm_sequence_number, l_exclusive_fund) THEN
852: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_EXCL_FLD');
853: fnd_message.set_token('FUND',l_exclusive_fund);
854: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
855:
856: ROLLBACK TO rollover_fund_attributes;
857: RAISE E_SKIP_FUND;
858: END IF;

Line 863: fnd_message.set_name('IGF','IGF_AW_FND_PRG_ROLL');

859:
860: l_pay_program := NULL;
861: --Skip the fund if creation of pay program is not successful
862: IF NOT create_pay_program(l_fund.fund_id, l_new_fund_id, l_pay_program) THEN
863: fnd_message.set_name('IGF','IGF_AW_FND_PRG_ROLL');
864: fnd_message.set_token('PROGRAM',l_pay_program);
865: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
866:
867: ROLLBACK TO rollover_fund_attributes;

Line 864: fnd_message.set_token('PROGRAM',l_pay_program);

860: l_pay_program := NULL;
861: --Skip the fund if creation of pay program is not successful
862: IF NOT create_pay_program(l_fund.fund_id, l_new_fund_id, l_pay_program) THEN
863: fnd_message.set_name('IGF','IGF_AW_FND_PRG_ROLL');
864: fnd_message.set_token('PROGRAM',l_pay_program);
865: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
866:
867: ROLLBACK TO rollover_fund_attributes;
868: RAISE E_SKIP_FUND;

Line 865: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

861: --Skip the fund if creation of pay program is not successful
862: IF NOT create_pay_program(l_fund.fund_id, l_new_fund_id, l_pay_program) THEN
863: fnd_message.set_name('IGF','IGF_AW_FND_PRG_ROLL');
864: fnd_message.set_token('PROGRAM',l_pay_program);
865: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
866:
867: ROLLBACK TO rollover_fund_attributes;
868: RAISE E_SKIP_FUND;
869: END IF;

Line 874: fnd_message.set_name('IGF','IGF_AW_FND_UNIT_ROLL');

870:
871: l_pay_unit := NULL;
872: --Skip the fund if creation of pay unit is not successful
873: IF NOT create_pay_unit(l_fund.fund_id, l_new_fund_id, l_pay_unit) THEN
874: fnd_message.set_name('IGF','IGF_AW_FND_UNIT_ROLL');
875: fnd_message.set_token('UNIT',l_pay_unit);
876: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
877:
878: ROLLBACK TO rollover_fund_attributes;

Line 875: fnd_message.set_token('UNIT',l_pay_unit);

871: l_pay_unit := NULL;
872: --Skip the fund if creation of pay unit is not successful
873: IF NOT create_pay_unit(l_fund.fund_id, l_new_fund_id, l_pay_unit) THEN
874: fnd_message.set_name('IGF','IGF_AW_FND_UNIT_ROLL');
875: fnd_message.set_token('UNIT',l_pay_unit);
876: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
877:
878: ROLLBACK TO rollover_fund_attributes;
879: RAISE E_SKIP_FUND;

Line 876: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

872: --Skip the fund if creation of pay unit is not successful
873: IF NOT create_pay_unit(l_fund.fund_id, l_new_fund_id, l_pay_unit) THEN
874: fnd_message.set_name('IGF','IGF_AW_FND_UNIT_ROLL');
875: fnd_message.set_token('UNIT',l_pay_unit);
876: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
877:
878: ROLLBACK TO rollover_fund_attributes;
879: RAISE E_SKIP_FUND;
880: END IF;

Line 885: fnd_message.set_name('IGF','IGF_AW_FND_FEECLS_ROLL');

881:
882: l_fee_class := NULL;
883: --Skip the fund if creation of pay feeclass is not successful
884: IF NOT create_pay_feeclass(l_fund.fund_id, l_new_fund_id, l_fee_class) THEN
885: fnd_message.set_name('IGF','IGF_AW_FND_FEECLS_ROLL');
886: fnd_message.set_token('FEE_CLASS',l_fee_class);
887: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
888:
889: ROLLBACK TO rollover_fund_attributes;

Line 886: fnd_message.set_token('FEE_CLASS',l_fee_class);

882: l_fee_class := NULL;
883: --Skip the fund if creation of pay feeclass is not successful
884: IF NOT create_pay_feeclass(l_fund.fund_id, l_new_fund_id, l_fee_class) THEN
885: fnd_message.set_name('IGF','IGF_AW_FND_FEECLS_ROLL');
886: fnd_message.set_token('FEE_CLASS',l_fee_class);
887: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
888:
889: ROLLBACK TO rollover_fund_attributes;
890: RAISE E_SKIP_FUND;

Line 887: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

883: --Skip the fund if creation of pay feeclass is not successful
884: IF NOT create_pay_feeclass(l_fund.fund_id, l_new_fund_id, l_fee_class) THEN
885: fnd_message.set_name('IGF','IGF_AW_FND_FEECLS_ROLL');
886: fnd_message.set_token('FEE_CLASS',l_fee_class);
887: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
888:
889: ROLLBACK TO rollover_fund_attributes;
890: RAISE E_SKIP_FUND;
891: END IF;

Line 896: fnd_message.set_name('IGF','IGF_AW_FND_TODO_ROLL');

892:
893: l_todo_item := NULL;
894: --Skip the fund if creation of fund todo is not successful
895: IF NOT create_fund_todo(l_fund.fund_id,l_new_fund_id,p_frm_cal_type,p_frm_sequence_number,p_to_cal_type,p_to_sequence_number,l_todo_item) THEN
896: fnd_message.set_name('IGF','IGF_AW_FND_TODO_ROLL');
897: fnd_message.set_token('TODO_ITEM',l_todo_item);
898: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
899:
900: ROLLBACK TO rollover_fund_attributes;

Line 897: fnd_message.set_token('TODO_ITEM',l_todo_item);

893: l_todo_item := NULL;
894: --Skip the fund if creation of fund todo is not successful
895: IF NOT create_fund_todo(l_fund.fund_id,l_new_fund_id,p_frm_cal_type,p_frm_sequence_number,p_to_cal_type,p_to_sequence_number,l_todo_item) THEN
896: fnd_message.set_name('IGF','IGF_AW_FND_TODO_ROLL');
897: fnd_message.set_token('TODO_ITEM',l_todo_item);
898: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
899:
900: ROLLBACK TO rollover_fund_attributes;
901: RAISE E_SKIP_FUND;

Line 898: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

894: --Skip the fund if creation of fund todo is not successful
895: IF NOT create_fund_todo(l_fund.fund_id,l_new_fund_id,p_frm_cal_type,p_frm_sequence_number,p_to_cal_type,p_to_sequence_number,l_todo_item) THEN
896: fnd_message.set_name('IGF','IGF_AW_FND_TODO_ROLL');
897: fnd_message.set_token('TODO_ITEM',l_todo_item);
898: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
899:
900: ROLLBACK TO rollover_fund_attributes;
901: RAISE E_SKIP_FUND;
902: END IF;

Line 907: fnd_message.set_name('IGF','IGF_AW_FND_RLOVR_FND_SUCCFL');

903:
904: END IF;
905:
906: COMMIT;
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

Line 908: fnd_message.set_token('FUND',l_fund.fund_code);

904: END IF;
905:
906: COMMIT;
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);

Line 909: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

905:
906: COMMIT;
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;

Line 917: fnd_message.set_name('IGF','IGF_AW_SKIPPING_FUND');

913: END IF;
914: EXCEPTION
915: WHEN E_SKIP_FUND THEN
916: IF l_discontinued_flg = 'N' THEN
917: fnd_message.set_name('IGF','IGF_AW_SKIPPING_FUND');
918: fnd_message.set_token('FUND_CODE',l_fund.fund_code);
919: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
920: END IF;
921:

Line 918: fnd_message.set_token('FUND_CODE',l_fund.fund_code);

914: EXCEPTION
915: WHEN E_SKIP_FUND THEN
916: IF l_discontinued_flg = 'N' THEN
917: fnd_message.set_name('IGF','IGF_AW_SKIPPING_FUND');
918: fnd_message.set_token('FUND_CODE',l_fund.fund_code);
919: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
920: END IF;
921:
922: l_discontinued_flg := 'N';

Line 919: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

915: WHEN E_SKIP_FUND THEN
916: IF l_discontinued_flg = 'N' THEN
917: fnd_message.set_name('IGF','IGF_AW_SKIPPING_FUND');
918: fnd_message.set_token('FUND_CODE',l_fund.fund_code);
919: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
920: END IF;
921:
922: l_discontinued_flg := 'N';
923:

Line 929: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 930: fnd_message.set_token('NAME','igf_aw_rollover.rollover_fund_attributes :' || SQLERRM);

926: END IF;
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:

Line 1094: fnd_message.set_name('IGF','IGF_AW_PROC_COA_ITEM');

1090: LOOP
1091: BEGIN
1092: SAVEPOINT rollover_rate_setups;
1093:
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

Line 1095: fnd_message.set_token('ITEM',l_get_itm_code.item_code);

1091: BEGIN
1092: SAVEPOINT rollover_rate_setups;
1093:
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);

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

1092: SAVEPOINT rollover_rate_setups;
1093:
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;

Line 1104: fnd_message.set_name('IGF','IGF_AW_ITM_ALRDY_EXISTS');

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

Line 1105: fnd_message.set_token('ITEM',l_get_itm_code.item_code);

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

Line 1106: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

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

Line 1122: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');

1118: l_to_ld_sequence_number := NULL;
1119:
1120: IF l_rate_setup.ld_cal_type IS NOT NULL AND l_rate_setup.ld_sequence_number IS NOT NULL THEN
1121: IF NOT chk_calendar_mapping(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1122: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
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);

Line 1123: fnd_message.set_token('ITEM',l_rate_setup.item_code);

1119:
1120: IF l_rate_setup.ld_cal_type IS NOT NULL AND l_rate_setup.ld_sequence_number IS NOT NULL THEN
1121: IF NOT chk_calendar_mapping(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1122: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
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

Line 1124: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number));

1120: IF l_rate_setup.ld_cal_type IS NOT NULL AND l_rate_setup.ld_sequence_number IS NOT NULL THEN
1121: IF NOT chk_calendar_mapping(l_rate_setup.ld_cal_type,l_rate_setup.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1122: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
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');

Line 1126: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1122: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
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:

Line 1166: fnd_message.set_name('IGF','IGF_AW_RT_RLOVR_SUCCFL');

1162:
1163: IF l_error_occurred = 'N' THEN
1164: COMMIT;
1165:
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

Line 1167: fnd_message.set_token('ITEM',l_get_itm_code.item_code);

1163: IF l_error_occurred = 'N' THEN
1164: COMMIT;
1165:
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);

Line 1168: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1164: COMMIT;
1165:
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;

Line 1180: fnd_message.set_name('IGF','IGF_AW_SKIPPING_ITEM');

1176:
1177: EXCEPTION
1178: WHEN E_SKIP_ITEM THEN
1179: ROLLBACK TO rollover_rate_setups;
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

Line 1181: fnd_message.set_token('ITEM',l_get_itm_code.item_code);

1177: EXCEPTION
1178: WHEN E_SKIP_ITEM THEN
1179: ROLLBACK TO rollover_rate_setups;
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);

Line 1182: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1178: WHEN E_SKIP_ITEM THEN
1179: ROLLBACK TO rollover_rate_setups;
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;

Line 1189: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 1190: fnd_message.set_token('NAME','igf_aw_rollover.rollover_rate_setups :' || SQLERRM);

1186: END IF;
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:

Line 1278: fnd_message.set_name('IGF','IGF_AP_PROC_INST_APLN');

1274: LOOP
1275: BEGIN
1276: SAVEPOINT rollover_inst_applications;
1277:
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

Line 1279: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);

1275: BEGIN
1276: SAVEPOINT rollover_inst_applications;
1277:
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);

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

1276: SAVEPOINT rollover_inst_applications;
1277:
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;

Line 1291: fnd_message.set_name('IGF','IGF_AP_INST_APLN_ALRDY_EXT');

1287: OPEN c_appln_exists(p_to_cal_type, p_to_sequence_number, l_get_appln_code.application_code);
1288: FETCH c_appln_exists INTO l_appln_exists;
1289: IF c_appln_exists%FOUND THEN
1290: CLOSE c_appln_exists;
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

Line 1292: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);

1288: FETCH c_appln_exists INTO l_appln_exists;
1289: IF c_appln_exists%FOUND THEN
1290: CLOSE c_appln_exists;
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');

Line 1293: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1289: IF c_appln_exists%FOUND THEN
1290: CLOSE c_appln_exists;
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;

Line 1312: fnd_message.set_name('IGF','IGF_AP_QUES_TRM_NT_EXISTS');

1308: l_to_ld_sequence_number := NULL;
1309:
1310: IF l_inst_appln_setup.ld_cal_type IS NOT NULL AND l_inst_appln_setup.ld_sequence_number IS NOT NULL THEN
1311: 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
1312: fnd_message.set_name('IGF','IGF_AP_QUES_TRM_NT_EXISTS');
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);

Line 1313: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);

1309:
1310: IF l_inst_appln_setup.ld_cal_type IS NOT NULL AND l_inst_appln_setup.ld_sequence_number IS NOT NULL THEN
1311: 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
1312: fnd_message.set_name('IGF','IGF_AP_QUES_TRM_NT_EXISTS');
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

Line 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));

1310: IF l_inst_appln_setup.ld_cal_type IS NOT NULL AND l_inst_appln_setup.ld_sequence_number IS NOT NULL THEN
1311: 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
1312: fnd_message.set_name('IGF','IGF_AP_QUES_TRM_NT_EXISTS');
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');

Line 1316: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1312: fnd_message.set_name('IGF','IGF_AP_QUES_TRM_NT_EXISTS');
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:

Line 1363: fnd_message.set_name('IGF','IGF_AP_APLN_QUES_ROLL');

1359: EXCEPTION
1360: WHEN OTHERS THEN
1361: l_error_occurred := 'Y';
1362:
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

Line 1364: fnd_message.set_token('QUESTION',l_inst_appln_setup.question);

1360: WHEN OTHERS THEN
1361: l_error_occurred := 'Y';
1362:
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);

Line 1365: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1361: l_error_occurred := 'Y';
1362:
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;

Line 1376: fnd_message.set_name('IGF','IGF_AP_APLN_RLOVR_SUCCFL');

1372:
1373: IF l_error_occurred = 'N' THEN
1374: COMMIT;
1375:
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

Line 1377: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);

1373: IF l_error_occurred = 'N' THEN
1374: COMMIT;
1375:
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);

Line 1378: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1374: COMMIT;
1375:
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;

Line 1391: fnd_message.set_name('IGF','IGF_AP_SKIPPING_INST_APLN');

1387: EXCEPTION
1388: WHEN E_SKIP_APPLICATION THEN
1389: ROLLBACK TO rollover_inst_applications;
1390:
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

Line 1392: fnd_message.set_token('APPLICATION',l_get_appln_code.application_code);

1388: WHEN E_SKIP_APPLICATION THEN
1389: ROLLBACK TO rollover_inst_applications;
1390:
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);

Line 1393: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1389: ROLLBACK TO rollover_inst_applications;
1390:
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;

Line 1400: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 1401: fnd_message.set_token('NAME','igf_aw_rollover.rollover_inst_applications :' || SQLERRM);

1397: END IF;
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:

Line 1619: fnd_message.set_name('IGF','IGF_AW_PROC_DIST_PLAN');

1615: LOOP
1616: BEGIN
1617: SAVEPOINT rollover_distribution_plans;
1618:
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

Line 1620: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);

1616: BEGIN
1617: SAVEPOINT rollover_distribution_plans;
1618:
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);

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

1617: SAVEPOINT rollover_distribution_plans;
1618:
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;

Line 1632: fnd_message.set_name('IGF','IGF_AW_PLN_ALRDY_EXISTS');

1628: OPEN c_plan_exists(p_to_cal_type, p_to_sequence_number, l_distb_plan_setup.awd_dist_plan_cd);
1629: FETCH c_plan_exists INTO l_plan_exists;
1630: IF c_plan_exists%FOUND THEN
1631: CLOSE c_plan_exists;
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

Line 1633: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);

1629: FETCH c_plan_exists INTO l_plan_exists;
1630: IF c_plan_exists%FOUND THEN
1631: CLOSE c_plan_exists;
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');

Line 1634: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1630: IF c_plan_exists%FOUND THEN
1631: CLOSE c_plan_exists;
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;

Line 1662: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');

1658: l_to_ld_sequence_number := NULL;
1659:
1660: --chech whether term mapping exists or not
1661: IF NOT chk_calendar_mapping(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1662: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1663: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number));
1664: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1665:
1666: l_error_occurred := 'Y';

Line 1663: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number));

1659:
1660: --chech whether term mapping exists or not
1661: IF NOT chk_calendar_mapping(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1662: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1663: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number));
1664: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1665:
1666: l_error_occurred := 'Y';
1667: END IF;

Line 1664: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1660: --chech whether term mapping exists or not
1661: IF NOT chk_calendar_mapping(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1662: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1663: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_distb_plan_term.ld_cal_type,l_distb_plan_term.ld_sequence_number));
1664: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1665:
1666: l_error_occurred := 'Y';
1667: END IF;
1668:

Line 1691: fnd_message.set_name('IGF','IGF_AW_TP_MAP_NT_FND');

1687: l_to_tp_sequence_number := NULL;
1688:
1689: --chech whether teaching period mapping exists or not
1690: IF NOT chk_calendar_mapping(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number,l_to_tp_cal_type,l_to_tp_sequence_number) THEN
1691: fnd_message.set_name('IGF','IGF_AW_TP_MAP_NT_FND');
1692: fnd_message.set_token('PERIOD',igf_gr_gen.get_alt_code(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number));
1693: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1694:
1695: l_error_occurred := 'Y';

Line 1692: fnd_message.set_token('PERIOD',igf_gr_gen.get_alt_code(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number));

1688:
1689: --chech whether teaching period mapping exists or not
1690: IF NOT chk_calendar_mapping(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number,l_to_tp_cal_type,l_to_tp_sequence_number) THEN
1691: fnd_message.set_name('IGF','IGF_AW_TP_MAP_NT_FND');
1692: fnd_message.set_token('PERIOD',igf_gr_gen.get_alt_code(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number));
1693: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1694:
1695: l_error_occurred := 'Y';
1696: END IF;

Line 1693: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1689: --chech whether teaching period mapping exists or not
1690: IF NOT chk_calendar_mapping(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number,l_to_tp_cal_type,l_to_tp_sequence_number) THEN
1691: fnd_message.set_name('IGF','IGF_AW_TP_MAP_NT_FND');
1692: fnd_message.set_token('PERIOD',igf_gr_gen.get_alt_code(l_distb_plan_tp.tp_cal_type,l_distb_plan_tp.tp_sequence_number));
1693: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1694:
1695: l_error_occurred := 'Y';
1696: END IF;
1697:

Line 1721: fnd_message.set_name('IGF','IGF_AW_PLN_RLOVR_SUCCFL');

1717:
1718: IF l_error_occurred = 'N' THEN
1719: COMMIT;
1720:
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

Line 1722: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);

1718: IF l_error_occurred = 'N' THEN
1719: COMMIT;
1720:
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);

Line 1723: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1719: COMMIT;
1720:
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;

Line 1735: fnd_message.set_name('IGF','IGF_AW_SKIPPING_PLAN');

1731:
1732: EXCEPTION
1733: WHEN E_SKIP_PLAN THEN
1734: ROLLBACK TO rollover_distribution_plans;
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

Line 1736: fnd_message.set_token('PLAN',l_distb_plan_setup.awd_dist_plan_cd);

1732: EXCEPTION
1733: WHEN E_SKIP_PLAN THEN
1734: ROLLBACK TO rollover_distribution_plans;
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);

Line 1737: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1733: WHEN E_SKIP_PLAN THEN
1734: ROLLBACK TO rollover_distribution_plans;
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;

Line 1744: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 1745: fnd_message.set_token('NAME','igf_aw_rollover.rollover_distribution_plans :' || SQLERRM);

1741: END IF;
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:

Line 1874: fnd_message.set_name('IGF','IGF_AW_PROC_COA_GROUP');

1870: LOOP
1871: BEGIN
1872: SAVEPOINT rollover_coa_groups;
1873:
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

Line 1875: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);

1871: BEGIN
1872: SAVEPOINT rollover_coa_groups;
1873:
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);

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

1872: SAVEPOINT rollover_coa_groups;
1873:
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;

Line 1888: fnd_message.set_name('IGF','IGF_AW_COA_GRP_ALRDY_EXISTS');

1884: OPEN c_coa_grp_exists(p_to_cal_type, p_to_sequence_number, l_coa_grp_setup.coa_code);
1885: FETCH c_coa_grp_exists INTO l_coa_grp_exists;
1886: IF c_coa_grp_exists%FOUND THEN
1887: CLOSE c_coa_grp_exists;
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

Line 1889: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);

1885: FETCH c_coa_grp_exists INTO l_coa_grp_exists;
1886: IF c_coa_grp_exists%FOUND THEN
1887: CLOSE c_coa_grp_exists;
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');

Line 1890: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1886: IF c_coa_grp_exists%FOUND THEN
1887: CLOSE c_coa_grp_exists;
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;

Line 1936: fnd_message.set_name('IGF','IGF_AW_RT_SETUP_NT_EXISTS');

1932: OPEN c_coa_itm_exists(p_to_cal_type, p_to_sequence_number, l_coa_item.item_code);
1933: FETCH c_coa_itm_exists INTO l_to_coa_itm_exists;
1934:
1935: IF c_coa_itm_exists%NOTFOUND THEN
1936: fnd_message.set_name('IGF','IGF_AW_RT_SETUP_NT_EXISTS');
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:

Line 1937: fnd_message.set_token('ITEM',l_coa_item.item_code);

1933: FETCH c_coa_itm_exists INTO l_to_coa_itm_exists;
1934:
1935: IF c_coa_itm_exists%NOTFOUND THEN
1936: fnd_message.set_name('IGF','IGF_AW_RT_SETUP_NT_EXISTS');
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

Line 1938: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));

1934:
1935: IF c_coa_itm_exists%NOTFOUND THEN
1936: fnd_message.set_name('IGF','IGF_AW_RT_SETUP_NT_EXISTS');
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');

Line 1939: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1935: IF c_coa_itm_exists%NOTFOUND THEN
1936: fnd_message.set_name('IGF','IGF_AW_RT_SETUP_NT_EXISTS');
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;

Line 1987: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');

1983: l_to_ld_sequence_number := NULL;
1984:
1985: --chech whether term mapping exists or not
1986: IF NOT chk_calendar_mapping(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1987: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1988: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number));
1989: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1990:
1991: l_error_occurred := 'Y';

Line 1988: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number));

1984:
1985: --chech whether term mapping exists or not
1986: IF NOT chk_calendar_mapping(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1987: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1988: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number));
1989: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1990:
1991: l_error_occurred := 'Y';
1992: END IF;

Line 1989: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

1985: --chech whether term mapping exists or not
1986: IF NOT chk_calendar_mapping(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
1987: fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
1988: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_ld_coa.ld_cal_type,l_ld_coa.ld_sequence_number));
1989: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
1990:
1991: l_error_occurred := 'Y';
1992: END IF;
1993:

Line 2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');

2017: l_to_ld_sequence_number := NULL;
2018:
2019: --check whether term mapping exists or not
2020: IF NOT chk_calendar_mapping(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);
2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));
2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

Line 2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');

2018:
2019: --check whether term mapping exists or not
2020: IF NOT chk_calendar_mapping(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);
2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));
2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2026:

Line 2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);

2019: --check whether term mapping exists or not
2020: IF NOT chk_calendar_mapping(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);
2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));
2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2026:
2027: l_error_occurred := 'Y';

Line 2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));

2020: IF NOT chk_calendar_mapping(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number,l_to_ld_cal_type,l_to_ld_sequence_number) THEN
2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);
2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));
2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2026:
2027: l_error_occurred := 'Y';
2028: END IF;

Line 2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2021: --fnd_message.set_name('IGF','IGF_AW_TRM_MAP_NT_FND');
2022: fnd_message.set_name('IGF','IGF_AW_TRM_NT_EXISTS');
2023: fnd_message.set_token('ITEM',l_overridden_item.item_code);
2024: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(l_overridden_item.ld_cal_type,l_overridden_item.ld_sequence_number));
2025: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2026:
2027: l_error_occurred := 'Y';
2028: END IF;
2029:

Line 2050: fnd_message.set_name('IGF','IGF_AW_COA_GRP_RLOVR_SUCCFL');

2046: END LOOP; -- end of FOR l_overridden_item IN c_overridden_item
2047:
2048: IF l_error_occurred = 'N' THEN
2049: COMMIT;
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

Line 2051: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);

2047:
2048: IF l_error_occurred = 'N' THEN
2049: COMMIT;
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);

Line 2052: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2048: IF l_error_occurred = 'N' THEN
2049: COMMIT;
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;

Line 2064: fnd_message.set_name('IGF','IGF_AW_SKIPPING_COA_GRP');

2060:
2061: EXCEPTION
2062: WHEN E_SKIP_COA_GRP THEN
2063: ROLLBACK TO rollover_coa_groups;
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

Line 2065: fnd_message.set_token('COA_GROUP',l_coa_grp_setup.coa_code);

2061: EXCEPTION
2062: WHEN E_SKIP_COA_GRP THEN
2063: ROLLBACK TO rollover_coa_groups;
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);

Line 2066: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2062: WHEN E_SKIP_COA_GRP THEN
2063: ROLLBACK TO rollover_coa_groups;
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;

Line 2073: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 2074: fnd_message.set_token('NAME','igf_aw_rollover.rollover_coa_groups :' || SQLERRM);

2070: END IF;
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:

Line 2146: fnd_message.set_name('IGF','IGF_AP_PROC_TODO_ITEM');

2142: LOOP
2143: BEGIN
2144: SAVEPOINT rollover_todo_items;
2145:
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

Line 2147: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);

2143: BEGIN
2144: SAVEPOINT rollover_todo_items;
2145:
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);

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

2144: SAVEPOINT rollover_todo_items;
2145:
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;

Line 2159: fnd_message.set_name('IGF','IGF_AP_TODO_ALRDY_EXISTS');

2155: OPEN c_todo_exists(p_to_cal_type, p_to_sequence_number, l_todo_item_setup.item_code);
2156: FETCH c_todo_exists INTO l_todo_exists;
2157: IF c_todo_exists%FOUND THEN
2158: CLOSE c_todo_exists;
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

Line 2160: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);

2156: FETCH c_todo_exists INTO l_todo_exists;
2157: IF c_todo_exists%FOUND THEN
2158: CLOSE c_todo_exists;
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');

Line 2161: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2157: IF c_todo_exists%FOUND THEN
2158: CLOSE c_todo_exists;
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;

Line 2204: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');

2200: p_application_code => l_todo_item_setup.application_code
2201: );
2202:
2203: IF lv_return_flg = 'Y' THEN
2204: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
2205: fnd_message.set_token('APPLICATION',l_todo_item_setup.application_code);
2206: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2208:

Line 2205: fnd_message.set_token('APPLICATION',l_todo_item_setup.application_code);

2201: );
2202:
2203: IF lv_return_flg = 'Y' THEN
2204: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
2205: fnd_message.set_token('APPLICATION',l_todo_item_setup.application_code);
2206: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2208:
2209: RAISE E_SKIP_TODO;

Line 2206: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);

2202:
2203: IF lv_return_flg = 'Y' THEN
2204: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
2205: fnd_message.set_token('APPLICATION',l_todo_item_setup.application_code);
2206: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2208:
2209: RAISE E_SKIP_TODO;
2210: END IF;

Line 2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2203: IF lv_return_flg = 'Y' THEN
2204: fnd_message.set_name('IGF','IGF_AP_INST_ATTCH_TODO_ERR');
2205: fnd_message.set_token('APPLICATION',l_todo_item_setup.application_code);
2206: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);
2207: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);
2208:
2209: RAISE E_SKIP_TODO;
2210: END IF;
2211: END IF;

Line 2215: fnd_message.set_name('IGF','IGF_AP_TODO_RLOVR_SUCCFL');

2211: END IF;
2212:
2213: COMMIT;
2214:
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

Line 2216: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);

2212:
2213: COMMIT;
2214:
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);

Line 2217: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2213: COMMIT;
2214:
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;

Line 2225: fnd_message.set_name('IGF','IGF_AP_SKIPPING_TODO');

2221: END IF;
2222:
2223: EXCEPTION
2224: WHEN E_SKIP_TODO 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

Line 2226: fnd_message.set_token('ITEM',l_todo_item_setup.item_code);

2222:
2223: EXCEPTION
2224: WHEN E_SKIP_TODO 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);

Line 2227: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2223: EXCEPTION
2224: WHEN E_SKIP_TODO 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;

Line 2234: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 2235: fnd_message.set_token('NAME','igf_aw_rollover.rollover_todo_items :' || SQLERRM);

2231: END IF;
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:

Line 2453: fnd_message.set_name('IGF','IGF_AW_PROC_AWD_GROUP');

2449: BEGIN
2450: SAVEPOINT rollover_award_groups;
2451: l_error_occurred := 'N';
2452:
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

Line 2454: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);

2450: SAVEPOINT rollover_award_groups;
2451: l_error_occurred := 'N';
2452:
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);

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

2451: l_error_occurred := 'N';
2452:
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;

Line 2467: fnd_message.set_name('IGF','IGF_AW_AWD_GRP_ALRDY_EXISTS');

2463: OPEN c_grp_exists(p_to_cal_type, p_to_sequence_number, l_award_grp_setup.group_cd);
2464: FETCH c_grp_exists INTO l_grp_exists;
2465: IF c_grp_exists%FOUND THEN
2466: CLOSE c_grp_exists;
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

Line 2468: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);

2464: FETCH c_grp_exists INTO l_grp_exists;
2465: IF c_grp_exists%FOUND THEN
2466: CLOSE c_grp_exists;
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');

Line 2469: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2465: IF c_grp_exists%FOUND THEN
2466: CLOSE c_grp_exists;
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;

Line 2486: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_NT_EXISTS');

2482: --Check the existence of the distribution plan in the target award year
2483: OPEN c_plan_exists(p_frm_cal_type, p_frm_sequence_number, p_to_cal_type, p_to_sequence_number, l_award_grp_setup.adplans_id);
2484: FETCH c_plan_exists INTO l_plan_exists;
2485: IF c_plan_exists%NOTFOUND THEN
2486: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_NT_EXISTS');
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:

Line 2487: fnd_message.set_token('PLAN',get_plan_cd(l_award_grp_setup.adplans_id, p_frm_cal_type, p_frm_sequence_number));

2483: OPEN c_plan_exists(p_frm_cal_type, p_frm_sequence_number, p_to_cal_type, p_to_sequence_number, l_award_grp_setup.adplans_id);
2484: FETCH c_plan_exists INTO l_plan_exists;
2485: IF c_plan_exists%NOTFOUND THEN
2486: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_NT_EXISTS');
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

Line 2488: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));

2484: FETCH c_plan_exists INTO l_plan_exists;
2485: IF c_plan_exists%NOTFOUND THEN
2486: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_NT_EXISTS');
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');

Line 2489: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2485: IF c_plan_exists%NOTFOUND THEN
2486: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_NT_EXISTS');
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;

Line 2557: fnd_message.set_name('IGF','IGF_AW_FUND_NT_EXISTS');

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);
2555: FETCH c_fund_exists INTO l_fund_exists;
2556: IF c_fund_exists%NOTFOUND THEN
2557: fnd_message.set_name('IGF','IGF_AW_FUND_NT_EXISTS');
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:

Line 2558: fnd_message.set_token('FUND',get_fund_cd(l_formula_setup.fund_id, p_frm_cal_type, p_frm_sequence_number));

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);
2555: FETCH c_fund_exists INTO l_fund_exists;
2556: IF c_fund_exists%NOTFOUND THEN
2557: fnd_message.set_name('IGF','IGF_AW_FUND_NT_EXISTS');
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

Line 2559: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));

2555: FETCH c_fund_exists INTO l_fund_exists;
2556: IF c_fund_exists%NOTFOUND THEN
2557: fnd_message.set_name('IGF','IGF_AW_FUND_NT_EXISTS');
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');

Line 2560: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2556: IF c_fund_exists%NOTFOUND THEN
2557: fnd_message.set_name('IGF','IGF_AW_FUND_NT_EXISTS');
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;

Line 2577: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_OVR_NT_EXISTS');

2573: --Check the existence of the distribution plan in the target award year
2574: OPEN c_plan_exists(p_frm_cal_type, p_frm_sequence_number, p_to_cal_type, p_to_sequence_number, l_formula_setup.adplans_id);
2575: FETCH c_plan_exists INTO l_plan_exists;
2576: IF c_plan_exists%NOTFOUND THEN
2577: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_OVR_NT_EXISTS');
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:

Line 2578: fnd_message.set_token('PLAN',get_plan_cd(l_formula_setup.adplans_id, p_frm_cal_type, p_frm_sequence_number));

2574: OPEN c_plan_exists(p_frm_cal_type, p_frm_sequence_number, p_to_cal_type, p_to_sequence_number, l_formula_setup.adplans_id);
2575: FETCH c_plan_exists INTO l_plan_exists;
2576: IF c_plan_exists%NOTFOUND THEN
2577: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_OVR_NT_EXISTS');
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

Line 2579: fnd_message.set_token('AWARD_YEAR',igf_gr_gen.get_alt_code(p_to_cal_type,p_to_sequence_number));

2575: FETCH c_plan_exists INTO l_plan_exists;
2576: IF c_plan_exists%NOTFOUND THEN
2577: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_OVR_NT_EXISTS');
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');

Line 2580: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2576: IF c_plan_exists%NOTFOUND THEN
2577: fnd_message.set_name('IGF','IGF_AW_DIST_PLN_OVR_NT_EXISTS');
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;

Line 2619: fnd_message.set_name('IGF','IGF_AW_AWD_GRP_RLOVR_SUCCFL');

2615:
2616: IF l_error_occurred = 'N' THEN
2617: COMMIT;
2618:
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

Line 2620: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);

2616: IF l_error_occurred = 'N' THEN
2617: COMMIT;
2618:
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);

Line 2621: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2617: COMMIT;
2618:
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;

Line 2633: fnd_message.set_name('IGF','IGF_AW_SKIPPING_AWD_GRP');

2629:
2630: EXCEPTION
2631: WHEN E_SKIP_AWARD_GRP THEN
2632: ROLLBACK TO rollover_award_groups;
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

Line 2634: fnd_message.set_token('AWD_GROUP',l_award_grp_setup.group_cd);

2630: EXCEPTION
2631: WHEN E_SKIP_AWARD_GRP THEN
2632: ROLLBACK TO rollover_award_groups;
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);

Line 2635: fnd_file.put_line(fnd_file.log, RPAD(' ',10)|| fnd_message.get);

2631: WHEN E_SKIP_AWARD_GRP THEN
2632: ROLLBACK TO rollover_award_groups;
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;

Line 2642: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

Line 2643: fnd_message.set_token('NAME','igf_aw_rollover.rollover_award_groups :' || SQLERRM);

2639: END IF;
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:

Line 2813: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2809:
2810: RETURN 'Y';
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;

Line 2814: fnd_message.set_token('NAME','igf_aw_rollover.rollover_inst_attch_todo :' || SQLERRM);

2810: RETURN 'Y';
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;

Line 3026: fnd_message.set_name('IGF','IGF_AW_AWD_NT_EXISTS');

3022:
3023: EXCEPTION
3024: WHEN to_awdyr_exception THEN
3025: retcode:=2;
3026: fnd_message.set_name('IGF','IGF_AW_AWD_NT_EXISTS');
3027: igs_ge_msg_stack.add;
3028: errbuf := fnd_message.get;
3029:
3030: WHEN app_exception.record_lock_exception THEN

Line 3028: errbuf := fnd_message.get;

3024: WHEN to_awdyr_exception THEN
3025: retcode:=2;
3026: fnd_message.set_name('IGF','IGF_AW_AWD_NT_EXISTS');
3027: igs_ge_msg_stack.add;
3028: errbuf := fnd_message.get;
3029:
3030: WHEN app_exception.record_lock_exception THEN
3031: ROLLBACK;
3032: retcode:=2;

Line 3033: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

3029:
3030: WHEN app_exception.record_lock_exception THEN
3031: ROLLBACK;
3032: retcode:=2;
3033: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
3034: igs_ge_msg_stack.add;
3035: errbuf := fnd_message.get;
3036:
3037: WHEN OTHERS THEN

Line 3035: errbuf := fnd_message.get;

3031: ROLLBACK;
3032: retcode:=2;
3033: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
3034: igs_ge_msg_stack.add;
3035: errbuf := fnd_message.get;
3036:
3037: WHEN OTHERS THEN
3038: ROLLBACK;
3039: retcode:=2;

Line 3040: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

3036:
3037: WHEN OTHERS THEN
3038: ROLLBACK;
3039: retcode:=2;
3040: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
3041: igs_ge_msg_stack.add;
3042: errbuf := fnd_message.get || SQLERRM;
3043:
3044: END main;

Line 3042: errbuf := fnd_message.get || SQLERRM;

3038: ROLLBACK;
3039: retcode:=2;
3040: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
3041: igs_ge_msg_stack.add;
3042: errbuf := fnd_message.get || SQLERRM;
3043:
3044: END main;
3045:
3046: END igf_aw_rollover;