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.IGS_AS_CALC_AWARD_MARK dependencies on FND_FILE

Line 1695: fnd_file.put_line (fnd_file.LOG, ' Failed to Update ' || spaa_rec.person_id || ' - ' || spaa_rec.course_cd || ' - ' || P_AWARD_CD );

1691: l_mesg_text := l_mesg_text || lmsgdata || ';' ;
1692: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1693: END LOOP;
1694:
1695: fnd_file.put_line (fnd_file.LOG, ' Failed to Update ' || spaa_rec.person_id || ' - ' || spaa_rec.course_cd || ' - ' || P_AWARD_CD );
1696: fnd_file.put_line (fnd_file.LOG, l_mesg_text);
1697:
1698: ELSE -- The mark and honors level were calculated successfully. Now update the SPAA record.
1699: fnd_file.put_line (fnd_file.LOG,'-------------------------***----------------------');

Line 1696: fnd_file.put_line (fnd_file.LOG, l_mesg_text);

1692: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1693: END LOOP;
1694:
1695: fnd_file.put_line (fnd_file.LOG, ' Failed to Update ' || spaa_rec.person_id || ' - ' || spaa_rec.course_cd || ' - ' || P_AWARD_CD );
1696: fnd_file.put_line (fnd_file.LOG, l_mesg_text);
1697:
1698: ELSE -- The mark and honors level were calculated successfully. Now update the SPAA record.
1699: fnd_file.put_line (fnd_file.LOG,'-------------------------***----------------------');
1700: BEGIN

Line 1699: fnd_file.put_line (fnd_file.LOG,'-------------------------***----------------------');

1695: fnd_file.put_line (fnd_file.LOG, ' Failed to Update ' || spaa_rec.person_id || ' - ' || spaa_rec.course_cd || ' - ' || P_AWARD_CD );
1696: fnd_file.put_line (fnd_file.LOG, l_mesg_text);
1697:
1698: ELSE -- The mark and honors level were calculated successfully. Now update the SPAA record.
1699: fnd_file.put_line (fnd_file.LOG,'-------------------------***----------------------');
1700: BEGIN
1701: igs_en_spa_awd_aim_pkg.update_row(
1702: x_rowid => spaa_rec.row_id,
1703: x_person_id => spaa_rec.person_id,

Line 1718: fnd_file.put_line (fnd_file.LOG,'Updated ' ||spaa_rec.person_id || ': ' || spaa_rec.course_cd || ': ' || spaa_rec.award_cd || ': With award grade :' || NVL(lrowawd_grd.grade, lawadrdgrade) );

1714: x_gs_version_number => NVL(lrowawd_grd.version_number, l_gs_version_number));
1715:
1716: IF NVL(lrowawd_grd.grade, lawadrdgrade) IS NOT NULL THEN
1717: --Print the success in log...
1718: fnd_file.put_line (fnd_file.LOG,'Updated ' ||spaa_rec.person_id || ': ' || spaa_rec.course_cd || ': ' || spaa_rec.award_cd || ': With award grade :' || NVL(lrowawd_grd.grade, lawadrdgrade) );
1719: -- Increment the total updated records by 1
1720: l_total_spa_updated_rec := l_total_spa_updated_rec + 1;
1721: END IF;
1722:

Line 1726: fnd_file.put_line (fnd_file.LOG, 'Error Occured For '|| spaa_rec.PERSON_ID || ' - ' || spaa_rec.COURSE_CD || ' - ' || P_AWARD_CD || SQLERRM );

1722:
1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: fnd_file.put_line (fnd_file.LOG, 'Error Occured For '|| spaa_rec.PERSON_ID || ' - ' || spaa_rec.COURSE_CD || ' - ' || P_AWARD_CD || SQLERRM );
1727: END;
1728: END IF;
1729: END LOOP;
1730:

Line 1732: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records selected : ' || l_total_spa_rec);

1728: END IF;
1729: END LOOP;
1730:
1731: --Print the total statistics in log.
1732: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records selected : ' || l_total_spa_rec);
1733: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records updated successfully : ' || l_total_spa_updated_rec);
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN

Line 1733: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records updated successfully : ' || l_total_spa_updated_rec);

1729: END LOOP;
1730:
1731: --Print the total statistics in log.
1732: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records selected : ' || l_total_spa_rec);
1733: fnd_file.put_line (fnd_file.LOG, 'Total program attempt award records updated successfully : ' || l_total_spa_updated_rec);
1734:
1735: EXCEPTION
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP

Line 1749: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );

1745: lmsgdata := FND_MESSAGE.GET;
1746: l_mesg_text := l_mesg_text || lmsgdata || ';' ;
1747: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1748: END LOOP;
1749: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );
1750:
1751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1752: FOR l_index IN 1..NVL(l_msg_count, 0) LOOP
1753:

Line 1765: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );

1761: lmsgdata := FND_MESSAGE.GET;
1762: l_mesg_text := l_mesg_text || lmsgdata || ';' ;
1763: FND_MSG_PUB.DELETE_MSG(l_msg_index);
1764: END LOOP;
1765: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );
1766:
1767: WHEN OTHERS THEN
1768: retcode:=2;
1769: fnd_file.put_line (fnd_file.LOG, 'Error encountered : ' || SQLERRM);

Line 1769: fnd_file.put_line (fnd_file.LOG, 'Error encountered : ' || SQLERRM);

1765: fnd_file.put_line (fnd_file.LOG, 'Error Ocuured : ' ||l_mesg_text );
1766:
1767: WHEN OTHERS THEN
1768: retcode:=2;
1769: fnd_file.put_line (fnd_file.LOG, 'Error encountered : ' || SQLERRM);
1770: END upgrade_awards;
1771:
1772:
1773:

Line 1797: fnd_file.put_line (fnd_file.LOG, 'Error encountered : ' || SQLERRM);

1793:
1794: return l_unit_level_mark;
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: fnd_file.put_line (fnd_file.LOG, 'Error encountered : ' || SQLERRM);
1798: End fn_ret_unit_lvl_mark;
1799:
1800: END igs_as_calc_award_mark;