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_FILE

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1698: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));

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

Line 1699: fnd_file.new_line(fnd_file.output,1);

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;
1702:
1703: fnd_file.new_line(fnd_file.output,1);

Line 1703: fnd_file.new_line(fnd_file.output,1);

1699: fnd_file.new_line(fnd_file.output,1);
1700: g_b_header := FALSE;
1701: END IF;
1702:
1703: fnd_file.new_line(fnd_file.output,1);
1704: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER'),15)
1705: ||LPAD(igf_gr_gen.get_per_num(p_base_id),15));
1706: fnd_file.new_line(fnd_file.output,1);
1707:

Line 1704: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER'),15)

1700: g_b_header := FALSE;
1701: END IF;
1702:
1703: fnd_file.new_line(fnd_file.output,1);
1704: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER'),15)
1705: ||LPAD(igf_gr_gen.get_per_num(p_base_id),15));
1706: fnd_file.new_line(fnd_file.output,1);
1707:
1708:

Line 1706: fnd_file.new_line(fnd_file.output,1);

1702:
1703: fnd_file.new_line(fnd_file.output,1);
1704: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER'),15)
1705: ||LPAD(igf_gr_gen.get_per_num(p_base_id),15));
1706: fnd_file.new_line(fnd_file.output,1);
1707:
1708:
1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)
1710: || LPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TP_TOT'),30));

Line 1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)

1705: ||LPAD(igf_gr_gen.get_per_num(p_base_id),15));
1706: fnd_file.new_line(fnd_file.output,1);
1707:
1708:
1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)
1710: || LPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TP_TOT'),30));
1711: FOR c_out_file_rec IN c_out_file(p_base_id) LOOP
1712: fnd_file.put_line(fnd_file.output,RPAD(c_out_file_rec.term,30)
1713: ||LPAD(TO_CHAR(c_out_file_rec.amount,'FM9999999990D90'),30));

Line 1712: fnd_file.put_line(fnd_file.output,RPAD(c_out_file_rec.term,30)

1708:
1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)
1710: || LPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TP_TOT'),30));
1711: FOR c_out_file_rec IN c_out_file(p_base_id) LOOP
1712: fnd_file.put_line(fnd_file.output,RPAD(c_out_file_rec.term,30)
1713: ||LPAD(TO_CHAR(c_out_file_rec.amount,'FM9999999990D90'),30));
1714: END LOOP;
1715:
1716: OPEN c_total_coa(p_base_id);

Line 1718: fnd_file.new_line(fnd_file.output,1);

1714: END LOOP;
1715:
1716: OPEN c_total_coa(p_base_id);
1717: FETCH c_total_coa INTO c_total_coa_rec;
1718: fnd_file.new_line(fnd_file.output,1);
1719: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)
1721: ||LPAD(TO_CHAR(c_total_coa_rec.total,'FM9999999990D90'),30));
1722: CLOSE c_total_coa;

Line 1719: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));

1715:
1716: OPEN c_total_coa(p_base_id);
1717: FETCH c_total_coa INTO c_total_coa_rec;
1718: fnd_file.new_line(fnd_file.output,1);
1719: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)
1721: ||LPAD(TO_CHAR(c_total_coa_rec.total,'FM9999999990D90'),30));
1722: CLOSE c_total_coa;
1723:

Line 1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)

1716: OPEN c_total_coa(p_base_id);
1717: FETCH c_total_coa INTO c_total_coa_rec;
1718: fnd_file.new_line(fnd_file.output,1);
1719: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)
1721: ||LPAD(TO_CHAR(c_total_coa_rec.total,'FM9999999990D90'),30));
1722: CLOSE c_total_coa;
1723:
1724: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));

Line 1724: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));

1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)
1721: ||LPAD(TO_CHAR(c_total_coa_rec.total,'FM9999999990D90'),30));
1722: CLOSE c_total_coa;
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);

Line 1828: fnd_file.put_line(fnd_file.log,' --------------------------------------------------------');

1824: p_base_id || ' / ' ||
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:

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 1831: fnd_file.new_line(fnd_file.log,1);

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;
1835: CLOSE c_base_rec;

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 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 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 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 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 1921: fnd_file.new_line(fnd_file.log,1);

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

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 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 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 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 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 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 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 2090: fnd_file.new_line(fnd_file.log,1);

2086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.run.debug','l_ci_cal_type:'||l_ci_cal_type);
2087: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.run.debug','l_ci_sequence_number:'||l_ci_sequence_number);
2088: END IF;
2089:
2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);

Line 2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

2088: END IF;
2089:
2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;

Line 2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));

2089:
2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;

Line 2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);

2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);

Line 2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);

2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
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:

Line 2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));

2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
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);

Line 2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);

2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
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');

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

2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
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));

Line 2103: fnd_file.new_line(fnd_file.log,2);

2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
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);

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 2107: fnd_file.new_line(fnd_file.log,1);

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
2110: RAISE param_exception;
2111:

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 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 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 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 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 2167: fnd_file.new_line(fnd_file.log,1);

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:
2171: LOOP

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 2197: fnd_file.new_line(fnd_file.log,1);

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;
2201: EXIT WHEN cur_per_grp%NOTFOUND;

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 2230: fnd_file.new_line(fnd_file.log,1);

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(
2234: p_grp_code,

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 2243: fnd_file.new_line(fnd_file.log,1);

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
2247: process_student(