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_AP_BATCH_VER_PRC_PKG dependencies on FND_FILE

Line 779: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

775: EXCEPTION
776: WHEN others THEN
777: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
778: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.CREATE_CORRECTION_ISIR '||SQLERRM);
779: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
780: IGS_GE_MSG_STACK.ADD;
781: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
782: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.create_correction_isir.debug',SQLERRM);
783: END IF;

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

821: );
822:
823: IF l_message = 'IGF_GR_UPDT_SSN_FAIL' THEN
824: fnd_message.set_name('IGF','IGF_GR_UPDT_SSN_FAIL');
825: fnd_file.put_line(fnd_file.log,fnd_message.get);
826: END IF;
827:
828: END IF;
829:

Line 1183: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);

1179: CLOSE cur_get_ver_data;
1180:
1181: IF lv_flag > 0 THEN
1182: FND_MESSAGE.SET_NAME('IGF','IGF_AP_INCOMPLETE_DOC_VAL');
1183: FND_FILE.PUT_LINE(FND_FILE.LOG,fnd_message.get);
1184: lb_return_status := TRUE;
1185: ELSE
1186: lb_return_status := FALSE;
1187: END IF;

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

1334:
1335: -- Get the isir_id of the latest ISIR for the student
1336: IF pv_isir_id IS NULL THEN
1337: fnd_message.set_name('IGF','IGF_AP_NO_ISIR_RECS_EXIST');
1338: fnd_file.put_line(fnd_file.log,fnd_message.get);
1339: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1340: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.l_create_corr_record.debug','No ISIR record exists');
1341: END IF;
1342: ELSE

Line 1366: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);

1362: CLOSE cur_get_sar_field_desc ;
1363:
1364: fnd_message.set_name('IGF','IGF_AP_CORR_REC_CREATED');
1365: fnd_message.set_token ('ITEM',l_sar_col_desc );
1366: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
1367: l_create_corr_record ( pn_base_id,ln_isir_id,pv_isir_map_column,lv_cal_type, ln_sequence_number, lv_retval,lv_item_value,l_mode);
1368:
1369: -- Update the Correction ISIR with the correction Value
1370: EXECUTE IMMEDIATE 'BEGIN igf_ap_batch_ver_prc_pkg.lp_isir_rec.'

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

1539:
1540: fnd_message.set_name('IGF','IGF_AP_PROCESSING_STUDENT');
1541: fnd_message.set_token ('PERSON_NAME',rec_selected.given_names ||' '||rec_selected.surname);
1542: fnd_message.set_token ('PERSON_NUMBER',rec_selected.person_number);
1543: fnd_file.put_line(fnd_file.log,fnd_message.get);
1544: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1545: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Procssing student '||rec_selected.given_names ||' '||rec_selected.surname );
1546: END IF;
1547: ln_tot_count := ln_tot_count + 1;

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

1569: FETCH cur_get_ver_item_count INTO lc_get_ver_item_count;
1570: IF cur_get_ver_item_count%NOTFOUND THEN
1571: CLOSE cur_get_ver_item_count;
1572: fnd_message.set_name('IGF','IGF_AP_STDNT_SKIP_NO_VERIF');
1573: fnd_file.put_line(fnd_file.log,fnd_message.get);
1574: fnd_file.new_line(fnd_file.log,2);
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','No verification items present , Therefore skipping the student');
1577: END IF;

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

1570: IF cur_get_ver_item_count%NOTFOUND THEN
1571: CLOSE cur_get_ver_item_count;
1572: fnd_message.set_name('IGF','IGF_AP_STDNT_SKIP_NO_VERIF');
1573: fnd_file.put_line(fnd_file.log,fnd_message.get);
1574: fnd_file.new_line(fnd_file.log,2);
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','No verification items present , Therefore skipping the student');
1577: END IF;
1578: RAISE SKIP_STUDENT;

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

1676: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Updated FA Process Status in FA Base Record');
1677: END IF;
1678: ln_tot_no_corr_count := ln_tot_no_corr_count+1;
1679: fnd_message.set_name ('IGF','IGF_AP_VER_STAT_ACCURATE');
1680: fnd_file.put_line(fnd_file.log,fnd_message.get);
1681:
1682: ELSIF ln_corr_count <> 0 THEN
1683:
1684: -- Update the Correction ISIR with Correction Items Values in Federal Verification Worksheet.

Line 1706: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1703: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','EFC computation for the context student has failed.');
1704: END IF;
1705: FND_MESSAGE.SET_NAME('IGF','IGF_AP_EFC_FAIL');
1706: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1707:
1708: FOR i in 1..p_msg_count LOOP
1709: p_msg_text := fnd_msg_pub.get(i,'F');
1710: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || TO_CHAR(i) || '.' || p_msg_text);

Line 1710: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || TO_CHAR(i) || '.' || p_msg_text);

1706: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1707:
1708: FOR i in 1..p_msg_count LOOP
1709: p_msg_text := fnd_msg_pub.get(i,'F');
1710: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ' || TO_CHAR(i) || '.' || p_msg_text);
1711: END LOOP;
1712: END IF;
1713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Since EFC could not be computed with given correction items, No correction item has been created for this Student.');

Line 1717: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1714: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug','Since EFC could not be computed with given correction items, No correction item has been created for this Student.');
1715: END IF;
1716: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1718: ROLLBACK TO IGFAP08B_SP;
1719:
1720: END IF;
1721:

Line 1722: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));

1718: ROLLBACK TO IGFAP08B_SP;
1719:
1720: END IF;
1721:
1722: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
1723:
1724: EXCEPTION
1725: WHEN SKIP_STUDENT THEN
1726: NULL;

Line 1731: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1727:
1728: WHEN OTHERS THEN
1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1730: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.MAIN-INNER '||SQLERRM);
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1732: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1734: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main-inner.debug',SQLERRM);

Line 1733: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1730: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.MAIN-INNER '||SQLERRM);
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1732: FND_MESSAGE.SET_NAME('IGF','IGF_AP_CORR_SKIP');
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1734: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1735: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main-inner.debug',SQLERRM);
1736: END IF;
1737: ROLLBACK TO IGFAP08B_SP;

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

1738: END;
1739: ELSE
1740: IF l_cur_chk_batched.base_id IS NOT NULL THEN
1741: fnd_message.set_name('IGF','IGF_AP_COR_BATCH_EXIST');
1742: fnd_file.put_line(fnd_file.log,fnd_message.get);
1743: END IF;
1744: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
1745:
1746: END IF;

Line 1744: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));

1740: IF l_cur_chk_batched.base_id IS NOT NULL THEN
1741: fnd_message.set_name('IGF','IGF_AP_COR_BATCH_EXIST');
1742: fnd_file.put_line(fnd_file.log,fnd_message.get);
1743: END IF;
1744: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
1745:
1746: END IF;
1747:
1748: END LOOP;

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

1748: END LOOP;
1749:
1750: IF ln_tot_count = 0 THEN
1751: fnd_message.set_name('IGF','IGF_AP_MATCHING_REC_NT_FND');
1752: fnd_file.put_line(fnd_file.log,fnd_message.get);
1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));

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

1753: END IF;
1754:
1755: fnd_message.set_name('IGF','IGF_AP_TOTAL_RECS');
1756: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count));
1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);

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

1757: fnd_file.put_line(fnd_file.output,fnd_message.get);
1758:
1759: fnd_message.set_name('IGF','IGF_AP_COMPLETED_RECS');
1760: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_count-ln_tot_corr_count));
1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));
1765: fnd_file.put_line(fnd_file.output,fnd_message.get);

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

1761: fnd_file.put_line(fnd_file.output,fnd_message.get);
1762:
1763: fnd_message.set_name('IGF','IGF_AP_CORR_RECS');
1764: fnd_message.set_token('COUNT',TO_CHAR(ln_tot_corr_count));
1765: fnd_file.put_line(fnd_file.output,fnd_message.get);
1766:
1767: retcode := 0;
1768: EXCEPTION
1769: WHEN others THEN

Line 1774: fnd_file.put_line(fnd_file.log,'ERROR: '||SQLERRM);

1770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1771: fnd_message.set_token('NAME','IGF_AP_BATCH_VER_PRC.main');
1772: igs_ge_msg_stack.add;
1773: igs_ge_msg_stack.conc_exception_hndl;
1774: fnd_file.put_line(fnd_file.log,'ERROR: '||SQLERRM);
1775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1776: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_batch_ver_prc_pkg.main.debug',SQLERRM);
1777: END IF;
1778: app_exception.raise_exception;

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

1848: IF cur_ver_status%NOTFOUND THEN
1849: CLOSE cur_ver_status;
1850: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1851: FND_MESSAGE.SET_TOKEN('NAME','FA BASE DOES NOT EXIST');
1852: fnd_file.put_line(fnd_file.log,fnd_message.get);
1853: APP_EXCEPTION.RAISE_EXCEPTION;
1854: END IF;
1855: CLOSE cur_ver_status;
1856:

Line 1886: fnd_file.put_line(fnd_file.log,SQLERRM);

1882: l_update_base_rec (p_base_id,p_fed_verif_status,NULL,lv_fa_process_status);
1883:
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: fnd_file.put_line(fnd_file.log,SQLERRM);
1887: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1888: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_PROCESS_STATUS');
1889: IGS_GE_MSG_STACK.ADD;
1890: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1936: fnd_file.put_line(fnd_file.log,SQLERRM);

1932: END IF;
1933:
1934: EXCEPTION
1935: WHEN OTHERS THEN
1936: fnd_file.put_line(fnd_file.log,SQLERRM);
1937: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1938: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_BATCH_VER_PRC.UPDATE_FED_VERIF_STATUS');
1939: IGS_GE_MSG_STACK.ADD;
1940: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN