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_COA_CALC dependencies on FND_MESSAGE

Line 318: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');

314:
315: BEGIN
316: FOR coa_rec IN c_coa(p_base_id) LOOP
317: IF coa_rec.lock_flag = 'Y' THEN
318: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');
319: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
320: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
321:
322:

Line 319: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);

315: BEGIN
316: FOR coa_rec IN c_coa(p_base_id) LOOP
317: IF coa_rec.lock_flag = 'Y' THEN
318: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');
319: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
320: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
321:
322:
323: RETURN FALSE;

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

316: FOR coa_rec IN c_coa(p_base_id) LOOP
317: IF coa_rec.lock_flag = 'Y' THEN
318: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');
319: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
320: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
321:
322:
323: RETURN FALSE;
324: END IF;

Line 328: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');

324: END IF;
325:
326: FOR coa_terms_rec IN c_coa_terms(p_base_id,coa_rec.item_code) LOOP
327: IF coa_terms_rec.lock_flag = 'Y' THEN
328: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');
329: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
330: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
331:
332: RETURN FALSE;

Line 329: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);

325:
326: FOR coa_terms_rec IN c_coa_terms(p_base_id,coa_rec.item_code) LOOP
327: IF coa_terms_rec.lock_flag = 'Y' THEN
328: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');
329: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
330: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
331:
332: RETURN FALSE;
333: END IF;

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

326: FOR coa_terms_rec IN c_coa_terms(p_base_id,coa_rec.item_code) LOOP
327: IF coa_terms_rec.lock_flag = 'Y' THEN
328: fnd_message.set_name('IGF','IGF_AW_COA_ITM_NOT_DEL');
329: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
330: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
331:
332: RETURN FALSE;
333: END IF;
334: END LOOP;

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

336:
337: RETURN TRUE;
338: EXCEPTION
339: WHEN OTHERS THEN
340: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
341: fnd_message.set_token('NAME','IGF_AW_COA_CALC.ISCOALOCKED' || ' '|| SQLERRM);
342: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
343: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.iscoalocked.exception','sql error: '||SQLERRM);
344: END IF;

Line 341: fnd_message.set_token('NAME','IGF_AW_COA_CALC.ISCOALOCKED' || ' '|| SQLERRM);

337: RETURN TRUE;
338: EXCEPTION
339: WHEN OTHERS THEN
340: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
341: fnd_message.set_token('NAME','IGF_AW_COA_CALC.ISCOALOCKED' || ' '|| SQLERRM);
342: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
343: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.iscoalocked.exception','sql error: '||SQLERRM);
344: END IF;
345: igs_ge_msg_stack.conc_exception_hndl;

Line 405: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_DEL');

401:
402: igf_aw_coa_items_pkg.delete_row(
403: x_rowid => coa_rec.row_id
404: );
405: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_DEL');
406: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
407: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
408:
409: END LOOP;

Line 406: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);

402: igf_aw_coa_items_pkg.delete_row(
403: x_rowid => coa_rec.row_id
404: );
405: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_DEL');
406: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
407: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
408:
409: END LOOP;
410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

403: x_rowid => coa_rec.row_id
404: );
405: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_DEL');
406: fnd_message.set_token('ITEM_CODE',coa_rec.item_code);
407: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
408:
409: END LOOP;
410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
411: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.delete_coa.debug','delete_coa done');

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

412: END IF;
413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
417: fnd_message.set_token('NAME','IGF_AW_COA_CALC.DELETE_COA' || ' '|| SQLERRM);
418: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
419: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.delete_coa.exception','sql error: '||SQLERRM);
420: END IF;

Line 417: fnd_message.set_token('NAME','IGF_AW_COA_CALC.DELETE_COA' || ' '|| SQLERRM);

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
417: fnd_message.set_token('NAME','IGF_AW_COA_CALC.DELETE_COA' || ' '|| SQLERRM);
418: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
419: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.delete_coa.exception','sql error: '||SQLERRM);
420: END IF;
421: igs_ge_msg_stack.conc_exception_hndl;

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

555: COMMIT;
556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
560: fnd_message.set_token('NAME','IGF_AW_COA_CALC.POPULATE_SETUP_TABLE' || ' '|| SQLERRM);
561: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
562: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.populate_setup_table.exception','sql error message: '||SQLERRM);
563: END IF;

Line 560: fnd_message.set_token('NAME','IGF_AW_COA_CALC.POPULATE_SETUP_TABLE' || ' '|| SQLERRM);

556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
560: fnd_message.set_token('NAME','IGF_AW_COA_CALC.POPULATE_SETUP_TABLE' || ' '|| SQLERRM);
561: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
562: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.populate_setup_table.exception','sql error message: '||SQLERRM);
563: END IF;
564: igs_ge_msg_stack.conc_exception_hndl;

Line 844: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

840: ELSE
841: lv_term_not_asgn := 'N';
842:
843: IF NVL(ln_rate_order,0) <> -1 THEN
844: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
845: fnd_message.set_token('ITEM_CODE',first_itm_term_rec.item_code);
846: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(first_itm_term_rec.ld_cal_type,first_itm_term_rec.ld_sequence_number));
847: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
848: END IF;

Line 845: fnd_message.set_token('ITEM_CODE',first_itm_term_rec.item_code);

841: lv_term_not_asgn := 'N';
842:
843: IF NVL(ln_rate_order,0) <> -1 THEN
844: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
845: fnd_message.set_token('ITEM_CODE',first_itm_term_rec.item_code);
846: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(first_itm_term_rec.ld_cal_type,first_itm_term_rec.ld_sequence_number));
847: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
848: END IF;
849: END IF;

Line 846: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(first_itm_term_rec.ld_cal_type,first_itm_term_rec.ld_sequence_number));

842:
843: IF NVL(ln_rate_order,0) <> -1 THEN
844: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
845: fnd_message.set_token('ITEM_CODE',first_itm_term_rec.item_code);
846: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(first_itm_term_rec.ld_cal_type,first_itm_term_rec.ld_sequence_number));
847: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
848: END IF;
849: END IF;
850:

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

843: IF NVL(ln_rate_order,0) <> -1 THEN
844: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
845: fnd_message.set_token('ITEM_CODE',first_itm_term_rec.item_code);
846: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(first_itm_term_rec.ld_cal_type,first_itm_term_rec.ld_sequence_number));
847: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
848: END IF;
849: END IF;
850:
851: --if the amount is NOT NULL COA Group Setup is used

Line 875: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');

871: END IF;
872: END LOOP;
873:
874: IF lv_item_assigned = 'Y' THEN
875: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
876: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
877: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
878: ELSE
879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

Line 876: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);

872: END LOOP;
873:
874: IF lv_item_assigned = 'Y' THEN
875: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
876: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
877: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
878: ELSE
879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
880: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);

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

873:
874: IF lv_item_assigned = 'Y' THEN
875: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
876: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
877: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
878: ELSE
879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
880: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
881: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);

Line 879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

875: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
876: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
877: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
878: ELSE
879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
880: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
881: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
882: END IF;
883:

Line 880: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);

876: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
877: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
878: ELSE
879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
880: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
881: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
882: END IF;
883:
884: IF lv_term_not_asgn = 'N' THEN

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

877: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
878: ELSE
879: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
880: fnd_message.set_token('ITEM_CODE',first_coa_rec.item_code);
881: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
882: END IF;
883:
884: IF lv_term_not_asgn = 'N' THEN
885: RAISE E_SKIP_STD_NO_TERMS;

Line 901: fnd_message.set_name('IGF','IGF_AW_COA_INCONSTENT_TERMS');

897: result := 'N';
898:
899: IF g_update_coa = 'N' THEN
900: IF does_term_mismatch(p_base_id,l_process_id) THEN
901: fnd_message.set_name('IGF','IGF_AW_COA_INCONSTENT_TERMS');
902: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
903:
904: ELSE
905: result := 'N';

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

898:
899: IF g_update_coa = 'N' THEN
900: IF does_term_mismatch(p_base_id,l_process_id) THEN
901: fnd_message.set_name('IGF','IGF_AW_COA_INCONSTENT_TERMS');
902: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
903:
904: ELSE
905: result := 'N';
906: FOR chk_item_match_rec IN c_check_item_match(p_base_id,l_process_id) LOOP

Line 978: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

974: ELSE
975: lv_term_not_asgn := 'N';
976:
977: IF NVL(ln_rate_order,0) <> -1 THEN
978: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
979: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
980: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
981: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
982: END IF;

Line 979: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);

975: lv_term_not_asgn := 'N';
976:
977: IF NVL(ln_rate_order,0) <> -1 THEN
978: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
979: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
980: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
981: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
982: END IF;
983: END IF;

Line 980: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));

976:
977: IF NVL(ln_rate_order,0) <> -1 THEN
978: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
979: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
980: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
981: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
982: END IF;
983: END IF;
984:

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

977: IF NVL(ln_rate_order,0) <> -1 THEN
978: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
979: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
980: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
981: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
982: END IF;
983: END IF;
984:
985: --if the amount is NOT NULL COA Group Setup is used

Line 1017: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');

1013: END LOOP;
1014: END IF;
1015:
1016: IF lv_item_assigned = 'Y' THEN
1017: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1018: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1019: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1020: ELSE
1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

Line 1018: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1014: END IF;
1015:
1016: IF lv_item_assigned = 'Y' THEN
1017: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1018: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1019: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1020: ELSE
1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1022: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

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

1015:
1016: IF lv_item_assigned = 'Y' THEN
1017: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1018: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1019: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1020: ELSE
1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1022: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1023: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);

Line 1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

1017: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1018: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1019: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1020: ELSE
1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1022: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1023: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1024: END IF;
1025:

Line 1022: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1018: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1019: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1020: ELSE
1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1022: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1023: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1024: END IF;
1025:
1026: IF lv_term_not_asgn = 'N' THEN

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

1019: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1020: ELSE
1021: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1022: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1023: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1024: END IF;
1025:
1026: IF lv_term_not_asgn = 'N' THEN
1027: RAISE E_SKIP_STD_NO_TERMS;

Line 1043: fnd_message.set_name('IGF','IGF_AW_COA_INCONSTENT_TERMS');

1039: --log an error message
1040: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1041: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.add_coa_items.debug','g_override_inconsistent_terms = N!so erroring out');
1042: END IF;
1043: fnd_message.set_name('IGF','IGF_AW_COA_INCONSTENT_TERMS');
1044: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1045: result := 'N';
1046: ELSE
1047: FOR chk_item_match_rec IN c_check_item_match(p_base_id,l_process_id) LOOP

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

1040: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1041: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.add_coa_items.debug','g_override_inconsistent_terms = N!so erroring out');
1042: END IF;
1043: fnd_message.set_name('IGF','IGF_AW_COA_INCONSTENT_TERMS');
1044: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1045: result := 'N';
1046: ELSE
1047: FOR chk_item_match_rec IN c_check_item_match(p_base_id,l_process_id) LOOP
1048: l_rowid := NULL;

Line 1121: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

1117: ELSE
1118: lv_term_not_asgn := 'N';
1119:
1120: IF NVL(ln_rate_order,0) <> -1 THEN
1121: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1122: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1123: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1124: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1125: END IF;

Line 1122: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);

1118: lv_term_not_asgn := 'N';
1119:
1120: IF NVL(ln_rate_order,0) <> -1 THEN
1121: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1122: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1123: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1124: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1125: END IF;
1126: END IF;

Line 1123: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));

1119:
1120: IF NVL(ln_rate_order,0) <> -1 THEN
1121: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1122: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1123: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1124: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1125: END IF;
1126: END IF;
1127:

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

1120: IF NVL(ln_rate_order,0) <> -1 THEN
1121: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1122: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1123: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1124: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1125: END IF;
1126: END IF;
1127:
1128: --if the amount is NOT NULL COA Group Setup is used

Line 1157: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');

1153:
1154: END LOOP;
1155:
1156: IF lv_item_assigned = 'Y' THEN
1157: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1158: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1159: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1160: ELSE
1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

Line 1158: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1154: END LOOP;
1155:
1156: IF lv_item_assigned = 'Y' THEN
1157: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1158: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1159: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1160: ELSE
1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1162: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

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

1155:
1156: IF lv_item_assigned = 'Y' THEN
1157: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1158: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1159: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1160: ELSE
1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1162: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1163: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);

Line 1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

1157: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1158: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1159: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1160: ELSE
1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1162: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1163: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1164: END IF;
1165:

Line 1162: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1158: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1159: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1160: ELSE
1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1162: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1163: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1164: END IF;
1165:
1166: IF lv_term_not_asgn = 'N' THEN

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

1159: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1160: ELSE
1161: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1162: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1163: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1164: END IF;
1165:
1166: IF lv_term_not_asgn = 'N' THEN
1167: RAISE E_SKIP_STD_NO_TERMS;

Line 1204: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');

1200: END IF;
1201:
1202: --skip the item if it is locked
1203: IF l_item_term.lock_flag = 'Y' THEN
1204: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
1205: fnd_message.set_token('ITEM_CODE',l_items.item_code);
1206: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1207: ELSE
1208: --if the amount is NULL Rate Order Setup is used

Line 1205: fnd_message.set_token('ITEM_CODE',l_items.item_code);

1201:
1202: --skip the item if it is locked
1203: IF l_item_term.lock_flag = 'Y' THEN
1204: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
1205: fnd_message.set_token('ITEM_CODE',l_items.item_code);
1206: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1207: ELSE
1208: --if the amount is NULL Rate Order Setup is used
1209: IF sec_itm_term_rec.item_term_amount IS NULL THEN

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

1202: --skip the item if it is locked
1203: IF l_item_term.lock_flag = 'Y' THEN
1204: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
1205: fnd_message.set_token('ITEM_CODE',l_items.item_code);
1206: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1207: ELSE
1208: --if the amount is NULL Rate Order Setup is used
1209: IF sec_itm_term_rec.item_term_amount IS NULL THEN
1210: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1254: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

1250: ELSE
1251: lv_term_not_asgn := 'N';
1252:
1253: IF NVL(ln_rate_order,0) <> -1 THEN
1254: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1255: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1256: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1257: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1258: END IF;

Line 1255: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);

1251: lv_term_not_asgn := 'N';
1252:
1253: IF NVL(ln_rate_order,0) <> -1 THEN
1254: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1255: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1256: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1257: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1258: END IF;
1259: END IF;

Line 1256: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));

1252:
1253: IF NVL(ln_rate_order,0) <> -1 THEN
1254: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1255: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1256: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1257: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1258: END IF;
1259: END IF;
1260:

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

1253: IF NVL(ln_rate_order,0) <> -1 THEN
1254: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1255: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1256: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1257: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1258: END IF;
1259: END IF;
1260:
1261: --if the amount is NOT NULL COA Group Setup is used

Line 1294: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');

1290: END IF;
1291: END LOOP;
1292:
1293: IF lv_item_assigned = 'Y' THEN
1294: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1295: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1296: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1297: ELSE
1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');

Line 1295: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1291: END LOOP;
1292:
1293: IF lv_item_assigned = 'Y' THEN
1294: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1295: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1296: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1297: ELSE
1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1299: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

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

1292:
1293: IF lv_item_assigned = 'Y' THEN
1294: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1295: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1296: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1297: ELSE
1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1299: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1300: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);

Line 1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');

1294: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1295: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1296: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1297: ELSE
1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1299: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1300: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1301: END IF;
1302:

Line 1299: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1295: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1296: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1297: ELSE
1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1299: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1300: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1301: END IF;
1302:
1303: IF lv_term_not_asgn = 'N' THEN

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

1296: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1297: ELSE
1298: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1299: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1300: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1301: END IF;
1302:
1303: IF lv_term_not_asgn = 'N' THEN
1304: RAISE E_SKIP_STD_NO_TERMS;

Line 1418: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

1414: ELSE
1415: lv_term_not_asgn := 'N';
1416:
1417: IF NVL(ln_rate_order,0) <> -1 THEN
1418: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1419: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1420: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1421: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1422: END IF;

Line 1419: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);

1415: lv_term_not_asgn := 'N';
1416:
1417: IF NVL(ln_rate_order,0) <> -1 THEN
1418: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1419: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1420: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1421: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1422: END IF;
1423: END IF;

Line 1420: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));

1416:
1417: IF NVL(ln_rate_order,0) <> -1 THEN
1418: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1419: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1420: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1421: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1422: END IF;
1423: END IF;
1424:

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

1417: IF NVL(ln_rate_order,0) <> -1 THEN
1418: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1419: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1420: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1421: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1422: END IF;
1423: END IF;
1424:
1425: --if the amount is NOT NULL COA Group Setup is used

Line 1452: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');

1448: END IF;
1449: END LOOP;
1450:
1451: IF lv_item_assigned = 'Y' THEN
1452: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1453: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1454: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1455: ELSE
1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

Line 1453: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1449: END LOOP;
1450:
1451: IF lv_item_assigned = 'Y' THEN
1452: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1453: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1454: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1455: ELSE
1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1457: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

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

1450:
1451: IF lv_item_assigned = 'Y' THEN
1452: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1453: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1454: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1455: ELSE
1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1457: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1458: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);

Line 1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');

1452: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_ADD');
1453: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1454: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1455: ELSE
1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1457: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1458: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1459: END IF;
1460:

Line 1457: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1453: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1454: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1455: ELSE
1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1457: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1458: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1459: END IF;
1460:
1461: IF lv_term_not_asgn = 'N' THEN

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

1454: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1455: ELSE
1456: fnd_message.set_name('IGF','IGF_AW_COA_ITEM_NTADD');
1457: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1458: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1459: END IF;
1460:
1461: IF lv_term_not_asgn = 'N' THEN
1462: RAISE E_SKIP_STD_NO_TERMS;

Line 1500: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');

1496: END IF;
1497:
1498: --skip the item if it is locked
1499: IF l_item_term.lock_flag = 'Y' THEN
1500: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
1501: fnd_message.set_token('ITEM_CODE',l_items.item_code);
1502: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1503: ELSE
1504:

Line 1501: fnd_message.set_token('ITEM_CODE',l_items.item_code);

1497:
1498: --skip the item if it is locked
1499: IF l_item_term.lock_flag = 'Y' THEN
1500: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
1501: fnd_message.set_token('ITEM_CODE',l_items.item_code);
1502: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1503: ELSE
1504:
1505: --if the amount is NULL Rate Order Setup is used

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

1498: --skip the item if it is locked
1499: IF l_item_term.lock_flag = 'Y' THEN
1500: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
1501: fnd_message.set_token('ITEM_CODE',l_items.item_code);
1502: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1503: ELSE
1504:
1505: --if the amount is NULL Rate Order Setup is used
1506: IF sec_itm_term_rec.item_term_amount IS NULL THEN

Line 1551: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

1547: ELSE
1548: lv_term_not_asgn := 'N';
1549:
1550: IF NVL(ln_rate_order,0) <> -1 THEN
1551: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1552: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1553: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1554: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1555: END IF;

Line 1552: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);

1548: lv_term_not_asgn := 'N';
1549:
1550: IF NVL(ln_rate_order,0) <> -1 THEN
1551: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1552: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1553: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1554: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1555: END IF;
1556: END IF;

Line 1553: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));

1549:
1550: IF NVL(ln_rate_order,0) <> -1 THEN
1551: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1552: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1553: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1554: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1555: END IF;
1556: END IF;
1557:

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

1550: IF NVL(ln_rate_order,0) <> -1 THEN
1551: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
1552: fnd_message.set_token('ITEM_CODE',sec_itm_term_rec.item_code);
1553: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(sec_itm_term_rec.ld_cal_type,sec_itm_term_rec.ld_sequence_number));
1554: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1555: END IF;
1556: END IF;
1557:
1558: --if the amount is NOT NULL COA Group Setup is used

Line 1589: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');

1585: END IF;
1586: END LOOP;
1587:
1588: IF lv_item_assigned = 'Y' THEN
1589: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1590: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1591: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1592: ELSE
1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');

Line 1590: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1586: END LOOP;
1587:
1588: IF lv_item_assigned = 'Y' THEN
1589: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1590: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1591: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1592: ELSE
1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1594: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

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

1587:
1588: IF lv_item_assigned = 'Y' THEN
1589: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1590: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1591: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1592: ELSE
1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1594: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1595: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);

Line 1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');

1589: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_CHNG');
1590: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1591: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1592: ELSE
1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1594: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1595: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1596: END IF;
1597:

Line 1594: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);

1590: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1591: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1592: ELSE
1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1594: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1595: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1596: END IF;
1597:
1598: IF lv_term_not_asgn = 'N' THEN

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

1591: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1592: ELSE
1593: fnd_message.set_name('IGF','IGF_AW_COA_ITM_ATTR_NTCHNG');
1594: fnd_message.set_token('ITEM_CODE',chk_item_match_rec.new_item);
1595: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1596: END IF;
1597:
1598: IF lv_term_not_asgn = 'N' THEN
1599: RAISE E_SKIP_STD_NO_TERMS;

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

1645: RAISE E_SKIP_STD_NO_ITEMS;
1646: WHEN E_SKIP_STD_NO_TERMS THEN
1647: RAISE E_SKIP_STD_NO_TERMS;
1648: WHEN OTHERS THEN
1649: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1650: fnd_message.set_token('NAME','IGF_AW_COA_CALC.ADD_COA_ITEMS' || ' '|| SQLERRM);
1651: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1652: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.add_coa_items.exception','sql error message: '||SQLERRM);
1653: END IF;

Line 1650: fnd_message.set_token('NAME','IGF_AW_COA_CALC.ADD_COA_ITEMS' || ' '|| SQLERRM);

1646: WHEN E_SKIP_STD_NO_TERMS THEN
1647: RAISE E_SKIP_STD_NO_TERMS;
1648: WHEN OTHERS THEN
1649: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1650: fnd_message.set_token('NAME','IGF_AW_COA_CALC.ADD_COA_ITEMS' || ' '|| SQLERRM);
1651: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1652: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.add_coa_items.exception','sql error message: '||SQLERRM);
1653: END IF;
1654:

Line 1696: fnd_message.set_name('IGF','IGF_AW_COA_PRINT_DTLS');

1692:
1693: BEGIN
1694:
1695: IF g_b_header THEN
1696: fnd_message.set_name('IGF','IGF_AW_COA_PRINT_DTLS');
1697: fnd_file.put_line(fnd_file.output,fnd_message.get);
1698: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1699: fnd_file.new_line(fnd_file.output,1);
1700: g_b_header := FALSE;

Line 1697: fnd_file.put_line(fnd_file.output,fnd_message.get);

1693: BEGIN
1694:
1695: IF g_b_header THEN
1696: fnd_message.set_name('IGF','IGF_AW_COA_PRINT_DTLS');
1697: fnd_file.put_line(fnd_file.output,fnd_message.get);
1698: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1699: fnd_file.new_line(fnd_file.output,1);
1700: g_b_header := FALSE;
1701: END IF;

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

1723:
1724: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1728: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PRINT_OUTPUT_FILE' || ' '|| SQLERRM);
1729: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1730: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.print_output_file.exception','sql error message: '||SQLERRM);
1731: END IF;

Line 1728: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PRINT_OUTPUT_FILE' || ' '|| SQLERRM);

1724: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1725: EXCEPTION
1726: WHEN OTHERS THEN
1727: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1728: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PRINT_OUTPUT_FILE' || ' '|| SQLERRM);
1729: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1730: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.print_output_file.exception','sql error message: '||SQLERRM);
1731: END IF;
1732: igs_ge_msg_stack.conc_exception_hndl;

Line 1829: fnd_message.set_name('IGF','IGF_AW_COA_PROCESS_STD');

1825: p_grp_code);
1826: END IF;
1827:
1828: fnd_file.put_line(fnd_file.log,' --------------------------------------------------------');
1829: fnd_message.set_name('IGF','IGF_AW_COA_PROCESS_STD');
1830: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || RPAD(fnd_message.get,55) || igf_gr_gen.get_per_num(p_base_id));
1831: fnd_file.new_line(fnd_file.log,1);
1832:
1833: OPEN c_base_rec(p_base_id);

Line 1830: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || RPAD(fnd_message.get,55) || igf_gr_gen.get_per_num(p_base_id));

1826: END IF;
1827:
1828: fnd_file.put_line(fnd_file.log,' --------------------------------------------------------');
1829: fnd_message.set_name('IGF','IGF_AW_COA_PROCESS_STD');
1830: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || RPAD(fnd_message.get,55) || igf_gr_gen.get_per_num(p_base_id));
1831: fnd_file.new_line(fnd_file.log,1);
1832:
1833: OPEN c_base_rec(p_base_id);
1834: FETCH c_base_rec INTO l_base_rec;

Line 1838: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');

1834: FETCH c_base_rec INTO l_base_rec;
1835: CLOSE c_base_rec;
1836:
1837: IF l_base_rec.lock_coa_flag = 'Y' THEN
1838: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');
1839: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1840: ELSE
1841: OPEN cur_per_coa(p_base_id);
1842: FETCH cur_per_coa INTO l_cur_per_coa ;

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

1835: CLOSE c_base_rec;
1836:
1837: IF l_base_rec.lock_coa_flag = 'Y' THEN
1838: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');
1839: fnd_file.put_line(fnd_file.log,RPAD(' ',10)||fnd_message.get);
1840: ELSE
1841: OPEN cur_per_coa(p_base_id);
1842: FETCH cur_per_coa INTO l_cur_per_coa ;
1843:

Line 1883: fnd_message.set_name('IGF','IGF_AW_COA_RSLT_OVERAWD');

1879:
1880: print_output_file(p_base_id);
1881:
1882: IF igf_aw_packng_subfns.is_over_award_occured(p_base_id) THEN
1883: fnd_message.set_name('IGF','IGF_AW_COA_RSLT_OVERAWD');
1884: fnd_message.set_token('OVER_AWD_AMT',overaward_amount(p_base_id));
1885: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1886: END IF;
1887:

Line 1884: fnd_message.set_token('OVER_AWD_AMT',overaward_amount(p_base_id));

1880: print_output_file(p_base_id);
1881:
1882: IF igf_aw_packng_subfns.is_over_award_occured(p_base_id) THEN
1883: fnd_message.set_name('IGF','IGF_AW_COA_RSLT_OVERAWD');
1884: fnd_message.set_token('OVER_AWD_AMT',overaward_amount(p_base_id));
1885: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1886: END IF;
1887:
1888: OPEN c_pell_award(p_base_id);

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

1881:
1882: IF igf_aw_packng_subfns.is_over_award_occured(p_base_id) THEN
1883: fnd_message.set_name('IGF','IGF_AW_COA_RSLT_OVERAWD');
1884: fnd_message.set_token('OVER_AWD_AMT',overaward_amount(p_base_id));
1885: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1886: END IF;
1887:
1888: OPEN c_pell_award(p_base_id);
1889: FETCH c_pell_award INTO l_pell_award;

Line 1905: fnd_message.set_name('IGF','IGF_AW_PELL_COA_CHNG');

1901: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','l_new_coa.alt_pell_coa:'||l_new_coa.alt_pell_coa);
1902: END IF;
1903:
1904: IF l_old_coa.pell_coa <> l_new_coa.pell_coa OR l_old_coa.alt_pell_coa <> l_new_coa.alt_pell_coa THEN
1905: fnd_message.set_name('IGF','IGF_AW_PELL_COA_CHNG');
1906: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1907: END IF;
1908:
1909: END IF;

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

1902: END IF;
1903:
1904: IF l_old_coa.pell_coa <> l_new_coa.pell_coa OR l_old_coa.alt_pell_coa <> l_new_coa.alt_pell_coa THEN
1905: fnd_message.set_name('IGF','IGF_AW_PELL_COA_CHNG');
1906: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1907: END IF;
1908:
1909: END IF;
1910:

Line 1914: fnd_message.set_name('IGF','IGF_AW_NO_CHNG');

1910:
1911: END IF;
1912:
1913: IF g_coa_updated = 'N' THEN
1914: fnd_message.set_name('IGF','IGF_AW_NO_CHNG');
1915: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get);
1916: END IF;
1917:
1918: fnd_message.set_name('IGF','IGF_AW_COA_ASSIGN_COMP');

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

1911: END IF;
1912:
1913: IF g_coa_updated = 'N' THEN
1914: fnd_message.set_name('IGF','IGF_AW_NO_CHNG');
1915: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get);
1916: END IF;
1917:
1918: fnd_message.set_name('IGF','IGF_AW_COA_ASSIGN_COMP');
1919: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(p_base_id));

Line 1918: fnd_message.set_name('IGF','IGF_AW_COA_ASSIGN_COMP');

1914: fnd_message.set_name('IGF','IGF_AW_NO_CHNG');
1915: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get);
1916: END IF;
1917:
1918: fnd_message.set_name('IGF','IGF_AW_COA_ASSIGN_COMP');
1919: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(p_base_id));
1920: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1921: fnd_file.new_line(fnd_file.log,1);
1922:

Line 1919: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(p_base_id));

1915: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get);
1916: END IF;
1917:
1918: fnd_message.set_name('IGF','IGF_AW_COA_ASSIGN_COMP');
1919: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(p_base_id));
1920: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1921: fnd_file.new_line(fnd_file.log,1);
1922:
1923: COMMIT;

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

1916: END IF;
1917:
1918: fnd_message.set_name('IGF','IGF_AW_COA_ASSIGN_COMP');
1919: fnd_message.set_token('PERSON_NUMBER',igf_gr_gen.get_per_num(p_base_id));
1920: fnd_file.put_line(fnd_file.log,RPAD(' ',10) || fnd_message.get);
1921: fnd_file.new_line(fnd_file.log,1);
1922:
1923: COMMIT;
1924:

Line 1931: fnd_message.set_name('IGF','IGF_AW_INCON_ITM_TERMS');

1927:
1928: EXCEPTION
1929: WHEN E_SKIP_STUDENT THEN
1930: ROLLBACK TO start_coa_calc;
1931: fnd_message.set_name('IGF','IGF_AW_INCON_ITM_TERMS');
1932: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1933:
1934: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1935: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());

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

1928: EXCEPTION
1929: WHEN E_SKIP_STUDENT THEN
1930: ROLLBACK TO start_coa_calc;
1931: fnd_message.set_name('IGF','IGF_AW_INCON_ITM_TERMS');
1932: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1933:
1934: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1935: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1936:

Line 1934: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

1930: ROLLBACK TO start_coa_calc;
1931: fnd_message.set_name('IGF','IGF_AW_INCON_ITM_TERMS');
1932: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1933:
1934: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1935: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1936:
1937: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1938: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);

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

1931: fnd_message.set_name('IGF','IGF_AW_INCON_ITM_TERMS');
1932: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1933:
1934: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1935: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1936:
1937: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1938: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);
1939: END IF;

Line 1943: fnd_message.set_name('IGF','IGF_AW_STD_SKIP_ASSGN');

1939: END IF;
1940:
1941: WHEN E_SKIP_STD_NO_ITEMS THEN
1942: ROLLBACK TO start_coa_calc;
1943: fnd_message.set_name('IGF','IGF_AW_STD_SKIP_ASSGN');
1944: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1945:
1946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1947: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);

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

1940:
1941: WHEN E_SKIP_STD_NO_ITEMS THEN
1942: ROLLBACK TO start_coa_calc;
1943: fnd_message.set_name('IGF','IGF_AW_STD_SKIP_ASSGN');
1944: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1945:
1946: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1947: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);
1948: END IF;

Line 1952: fnd_message.set_name('IGF','IGF_AW_COA_SKIP_STD');

1948: END IF;
1949:
1950: WHEN E_SKIP_STD_NO_TERMS THEN
1951: ROLLBACK TO start_coa_calc;
1952: fnd_message.set_name('IGF','IGF_AW_COA_SKIP_STD');
1953: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1954:
1955: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1956: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());

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

1949:
1950: WHEN E_SKIP_STD_NO_TERMS THEN
1951: ROLLBACK TO start_coa_calc;
1952: fnd_message.set_name('IGF','IGF_AW_COA_SKIP_STD');
1953: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1954:
1955: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1956: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1957:

Line 1955: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');

1951: ROLLBACK TO start_coa_calc;
1952: fnd_message.set_name('IGF','IGF_AW_COA_SKIP_STD');
1953: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1954:
1955: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1956: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1957:
1958: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1959: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);

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

1952: fnd_message.set_name('IGF','IGF_AW_COA_SKIP_STD');
1953: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1954:
1955: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1956: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1957:
1958: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1959: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);
1960: END IF;

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

1965: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1966: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);
1967: END IF;
1968:
1969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1970: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PROCESS_STUDENT' || ' '||SQLERRM);
1971: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1972:
1973: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');

Line 1970: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PROCESS_STUDENT' || ' '||SQLERRM);

1966: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_calc.process_student.exception','sql error message: '||SQLERRM);
1967: END IF;
1968:
1969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1970: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PROCESS_STUDENT' || ' '||SQLERRM);
1971: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1972:
1973: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1974: fnd_file.put_line(fnd_file.log,RPAD(' ',10)|| fnd_message.get());

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

1967: END IF;
1968:
1969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1970: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PROCESS_STUDENT' || ' '||SQLERRM);
1971: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1972:
1973: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1974: fnd_file.put_line(fnd_file.log,RPAD(' ',10)|| fnd_message.get());
1975:

Line 1973: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');

1969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1970: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PROCESS_STUDENT' || ' '||SQLERRM);
1971: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1972:
1973: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1974: fnd_file.put_line(fnd_file.log,RPAD(' ',10)|| fnd_message.get());
1975:
1976: END process_student;
1977:

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

1970: fnd_message.set_token('NAME','IGF_AW_COA_CALC.PROCESS_STUDENT' || ' '||SQLERRM);
1971: fnd_file.put_line(fnd_file.log,RPAD(' ',10,' ') || fnd_message.get());
1972:
1973: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
1974: fnd_file.put_line(fnd_file.log,RPAD(' ',10)|| fnd_message.get());
1975:
1976: END process_student;
1977:
1978:

Line 2104: fnd_message.set_name('IGF','IGF_AW_PROCESS_COA_CAL');

2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);
2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));
2102:
2103: fnd_file.new_line(fnd_file.log,2);
2104: fnd_message.set_name('IGF','IGF_AW_PROCESS_COA_CAL');
2105: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2106:
2107: fnd_file.new_line(fnd_file.log,1);
2108:

Line 2105: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));

2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));
2102:
2103: fnd_file.new_line(fnd_file.log,2);
2104: fnd_message.set_name('IGF','IGF_AW_PROCESS_COA_CAL');
2105: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2106:
2107: fnd_file.new_line(fnd_file.log,1);
2108:
2109: IF p_award_year IS NULL OR p_grp_code IS NULL THEN

Line 2119: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');

2115: ELSIF (p_pergrp_id IS NOT NULL) AND (p_base_id IS NOT NULL) THEN
2116: RAISE param_exception;
2117:
2118: ELSIF l_run_type = 'P' AND p_pergrp_id IS NULL THEN
2119: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
2120: fnd_file.put_line(fnd_file.log,fnd_message.get);
2121: RAISE param_exception;
2122:
2123: ELSIF l_run_type = 'S' AND p_base_id IS NULL THEN

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

2116: RAISE param_exception;
2117:
2118: ELSIF l_run_type = 'P' AND p_pergrp_id IS NULL THEN
2119: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
2120: fnd_file.put_line(fnd_file.log,fnd_message.get);
2121: RAISE param_exception;
2122:
2123: ELSIF l_run_type = 'S' AND p_base_id IS NULL THEN
2124: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');

Line 2124: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');

2120: fnd_file.put_line(fnd_file.log,fnd_message.get);
2121: RAISE param_exception;
2122:
2123: ELSIF l_run_type = 'S' AND p_base_id IS NULL THEN
2124: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
2125: fnd_file.put_line(fnd_file.log,fnd_message.get);
2126: RAISE param_exception;
2127:
2128: ELSIF p_update_coa = 'Y' AND p_update_method IS NULL THEN

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

2121: RAISE param_exception;
2122:
2123: ELSIF l_run_type = 'S' AND p_base_id IS NULL THEN
2124: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
2125: fnd_file.put_line(fnd_file.log,fnd_message.get);
2126: RAISE param_exception;
2127:
2128: ELSIF p_update_coa = 'Y' AND p_update_method IS NULL THEN
2129: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_UPD');

Line 2129: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_UPD');

2125: fnd_file.put_line(fnd_file.log,fnd_message.get);
2126: RAISE param_exception;
2127:
2128: ELSIF p_update_coa = 'Y' AND p_update_method IS NULL THEN
2129: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_UPD');
2130: fnd_file.put_line(fnd_file.log,fnd_message.get);
2131: RAISE param_exception;
2132:
2133: ELSIF l_run_type = 'P' AND (p_pergrp_id IS NOT NULL) THEN

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

2126: RAISE param_exception;
2127:
2128: ELSIF p_update_coa = 'Y' AND p_update_method IS NULL THEN
2129: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_UPD');
2130: fnd_file.put_line(fnd_file.log,fnd_message.get);
2131: RAISE param_exception;
2132:
2133: ELSIF l_run_type = 'P' AND (p_pergrp_id IS NOT NULL) THEN
2134: --Bug #5021084

Line 2155: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

2151:
2152: FETCH cur_per_grp INTO per_grp_rec;
2153:
2154: IF (cur_per_grp%NOTFOUND) THEN
2155: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
2156: fnd_file.put_line(fnd_file.log,fnd_message.get);
2157: ELSE
2158: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;
2159: populate_setup_table(p_grp_code,l_ci_cal_type,l_ci_sequence_number,l_process_id);

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

2152: FETCH cur_per_grp INTO per_grp_rec;
2153:
2154: IF (cur_per_grp%NOTFOUND) THEN
2155: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
2156: fnd_file.put_line(fnd_file.log,fnd_message.get);
2157: ELSE
2158: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;
2159: populate_setup_table(p_grp_code,l_ci_cal_type,l_ci_sequence_number,l_process_id);
2160:

Line 2164: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');

2160:
2161: OPEN c_group_code(p_pergrp_id);
2162: FETCH c_group_code INTO c_grp_cd;
2163:
2164: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
2165: fnd_message.set_token('P_PER_GRP',c_grp_cd.group_cd);
2166: fnd_file.put_line(fnd_file.log,fnd_message.get );
2167: fnd_file.new_line(fnd_file.log,1);
2168:

Line 2165: fnd_message.set_token('P_PER_GRP',c_grp_cd.group_cd);

2161: OPEN c_group_code(p_pergrp_id);
2162: FETCH c_group_code INTO c_grp_cd;
2163:
2164: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
2165: fnd_message.set_token('P_PER_GRP',c_grp_cd.group_cd);
2166: fnd_file.put_line(fnd_file.log,fnd_message.get );
2167: fnd_file.new_line(fnd_file.log,1);
2168:
2169: CLOSE c_group_code;

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

2162: FETCH c_group_code INTO c_grp_cd;
2163:
2164: fnd_message.set_name('IGF','IGF_AW_PERSON_ID_GROUP');
2165: fnd_message.set_token('P_PER_GRP',c_grp_cd.group_cd);
2166: fnd_file.put_line(fnd_file.log,fnd_message.get );
2167: fnd_file.new_line(fnd_file.log,1);
2168:
2169: CLOSE c_group_code;
2170:

Line 2193: fnd_message.set_name('IGF','IGF_AW_NO_FA_BASE_EXISTS');

2189: p_grp_code,
2190: l_process_id
2191: );
2192: ELSE
2193: fnd_message.set_name('IGF','IGF_AW_NO_FA_BASE_EXISTS');
2194: fnd_message.set_token('PERS_NUM',per_grp_rec.person_number);
2195: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2196: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || fnd_message.get);
2197: fnd_file.new_line(fnd_file.log,1);

Line 2194: fnd_message.set_token('PERS_NUM',per_grp_rec.person_number);

2190: l_process_id
2191: );
2192: ELSE
2193: fnd_message.set_name('IGF','IGF_AW_NO_FA_BASE_EXISTS');
2194: fnd_message.set_token('PERS_NUM',per_grp_rec.person_number);
2195: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2196: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || fnd_message.get);
2197: fnd_file.new_line(fnd_file.log,1);
2198: END IF;

Line 2195: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));

2191: );
2192: ELSE
2193: fnd_message.set_name('IGF','IGF_AW_NO_FA_BASE_EXISTS');
2194: fnd_message.set_token('PERS_NUM',per_grp_rec.person_number);
2195: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2196: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || fnd_message.get);
2197: fnd_file.new_line(fnd_file.log,1);
2198: END IF;
2199:

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

2192: ELSE
2193: fnd_message.set_name('IGF','IGF_AW_NO_FA_BASE_EXISTS');
2194: fnd_message.set_token('PERS_NUM',per_grp_rec.person_number);
2195: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2196: fnd_file.put_line(fnd_file.log,RPAD(' ',5) || fnd_message.get);
2197: fnd_file.new_line(fnd_file.log,1);
2198: END IF;
2199:
2200: FETCH cur_per_grp INTO per_grp_rec;

Line 2228: fnd_message.set_name('IGF','IGF_AW_COA_NO_STDS');

2224: OPEN c_per_awd_yr(l_ci_cal_type,l_ci_sequence_number);
2225: FETCH c_per_awd_yr INTO per_awd_rec;
2226:
2227: IF (c_per_awd_yr%NOTFOUND) THEN
2228: fnd_message.set_name('IGF','IGF_AW_COA_NO_STDS');
2229: fnd_file.put_line(fnd_file.log,fnd_message.get);
2230: fnd_file.new_line(fnd_file.log,1);
2231: ELSE
2232: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;

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

2225: FETCH c_per_awd_yr INTO per_awd_rec;
2226:
2227: IF (c_per_awd_yr%NOTFOUND) THEN
2228: fnd_message.set_name('IGF','IGF_AW_COA_NO_STDS');
2229: fnd_file.put_line(fnd_file.log,fnd_message.get);
2230: fnd_file.new_line(fnd_file.log,1);
2231: ELSE
2232: SELECT igf_aw_process_s.nextval INTO l_process_id FROM dual ;
2233: populate_setup_table(

Line 2240: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');

2236: l_ci_sequence_number,
2237: l_process_id
2238: );
2239:
2240: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');
2241: fnd_message.set_token('AWD_YR',p_award_year);
2242: fnd_file.put_line(fnd_file.log,fnd_message.get );
2243: fnd_file.new_line(fnd_file.log,1);
2244:

Line 2241: fnd_message.set_token('AWD_YR',p_award_year);

2237: l_process_id
2238: );
2239:
2240: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');
2241: fnd_message.set_token('AWD_YR',p_award_year);
2242: fnd_file.put_line(fnd_file.log,fnd_message.get );
2243: fnd_file.new_line(fnd_file.log,1);
2244:
2245: LOOP

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

2238: );
2239:
2240: fnd_message.set_name('IGF','IGF_AW_PROC_AWD');
2241: fnd_message.set_token('AWD_YR',p_award_year);
2242: fnd_file.put_line(fnd_file.log,fnd_message.get );
2243: fnd_file.new_line(fnd_file.log,1);
2244:
2245: LOOP
2246: IF per_awd_rec.base_id IS NOT NULL THEN

Line 2270: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');

2266:
2267: EXCEPTION
2268: WHEN param_exception THEN
2269: retcode:=2;
2270: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
2271: igs_ge_msg_stack.add;
2272: errbuf := fnd_message.get;
2273:
2274: WHEN app_exception.record_lock_exception THEN

Line 2272: errbuf := fnd_message.get;

2268: WHEN param_exception THEN
2269: retcode:=2;
2270: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
2271: igs_ge_msg_stack.add;
2272: errbuf := fnd_message.get;
2273:
2274: WHEN app_exception.record_lock_exception THEN
2275: ROLLBACK;
2276: retcode:=2;

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

2273:
2274: WHEN app_exception.record_lock_exception THEN
2275: ROLLBACK;
2276: retcode:=2;
2277: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
2278: igs_ge_msg_stack.add;
2279: errbuf := fnd_message.get;
2280:
2281: WHEN OTHERS THEN

Line 2279: errbuf := fnd_message.get;

2275: ROLLBACK;
2276: retcode:=2;
2277: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
2278: igs_ge_msg_stack.add;
2279: errbuf := fnd_message.get;
2280:
2281: WHEN OTHERS THEN
2282: ROLLBACK;
2283: retcode:=2;

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

2280:
2281: WHEN OTHERS THEN
2282: ROLLBACK;
2283: retcode:=2;
2284: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2285: igs_ge_msg_stack.add;
2286: errbuf := fnd_message.get || ' '|| SQLERRM;
2287: END run;
2288:

Line 2286: errbuf := fnd_message.get || ' '|| SQLERRM;

2282: ROLLBACK;
2283: retcode:=2;
2284: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2285: igs_ge_msg_stack.add;
2286: errbuf := fnd_message.get || ' '|| SQLERRM;
2287: END run;
2288:
2289: END igf_aw_coa_calc;