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

Line 402: fnd_file.put_line(fnd_file.log, errbuf); -- as this info is also important to end user.

398: IF l_prs_grp_status <> 'S' THEN
399: fnd_message.set_name('IGS','IGS_HE_UT_PRSN_ID_GRP_ERR');
400: fnd_message.set_token('PRSNIDGRP',p_person_id_grp);
401: errbuf := fnd_message.get();
402: fnd_file.put_line(fnd_file.log, errbuf); -- as this info is also important to end user.
403: retcode := '2';
404: RETURN;
405: END IF;
406:

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

488:
489: fnd_message.set_name('IGS','IGS_HE_UT_EXT_NOT_RECALC');
490: fnd_message.set_token('PERSON', l_person_number);
491: fnd_message.set_token('PROGRAM', c_st_spa.course_cd);
492: fnd_file.put_line(fnd_file.log, fnd_message.get());
493:
494: END IF;
495:
496: -- Further processing is done only if the flag is set to Y

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

606: Fnd_Message.Set_Token('COURSE_CODE',c_st_spa.course_cd);
607: Fnd_Message.Set_Token('EXAM_LEVEL',c_exam_level.Exam_level);
608: Fnd_Message.Set_Token('SUBJECT_COUNT',l_qual_count);
609: Fnd_Message.Set_Token('TARIFF_SCORE',l_tariff_score);
610: fnd_file.put_line(fnd_file.log, fnd_message.get());
611:
612: END IF;
613:
614: END LOOP; --end for Cur_exam_level

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

699: ELSE
700: fnd_message.set_token('HIGH_QUAL', l_grade.full_grade_name);
701: END IF;
702: fnd_message.set_token('TOTAL_TARIFF',l_total_tariff_score);
703: fnd_file.put_line(fnd_file.log, fnd_message.get());
704:
705: l_record_updated := l_record_updated + 1 ;
706:
707: COMMIT;

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

713: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
714:
715: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
716: fnd_message.set_token('REC_CNT',l_record_updated);
717: fnd_file.put_line(fnd_file.log, fnd_message.get());
718:
719: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
720: fnd_message.set_token('REC_CNT',l_record_inserted);
721: fnd_file.put_line(fnd_file.log, fnd_message.get());

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

717: fnd_file.put_line(fnd_file.log, fnd_message.get());
718:
719: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
720: fnd_message.set_token('REC_CNT',l_record_inserted);
721: fnd_file.put_line(fnd_file.log, fnd_message.get());
722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF l_cursor_id IS NOT NULL THEN

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

730: IF SQLCODE=-1436 THEN
731: fnd_message.set_name('IGS','IGS_HE_UT_AWD_CYCLIC_REL');
732: fnd_message.set_token('AWARD',NULL);
733: -- anwest Bug# 4035243 Peer review noted no actual logging
734: fnd_file.put_line(fnd_file.log, fnd_message.get());
735: ELSE
736: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
737: fnd_message.set_token('NAME','IGS_HE_UCAS_TARIFF_PKG.External_tariff_calc - '||SQLERRM);
738: -- anwest Bug# 4035243 Peer review noted no actual logging

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

735: ELSE
736: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
737: fnd_message.set_token('NAME','IGS_HE_UCAS_TARIFF_PKG.External_tariff_calc - '||SQLERRM);
738: -- anwest Bug# 4035243 Peer review noted no actual logging
739: fnd_file.put_line(fnd_file.log, fnd_message.get());
740: END IF;
741:
742: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN
743: fnd_log.message(fnd_log.level_unexpected, 'igs.plsql.hesa.ucas_tariff_calc.exception', FALSE);

Line 949: fnd_file.put_line(fnd_file.log, errbuf); -- this message need to be displayed to user.

945: IF l_prs_grp_status <> 'S' THEN
946: fnd_message.set_name('IGS','IGS_HE_UT_PRSN_ID_GRP_ERR');
947: fnd_message.set_token('PRSNIDGRP',p_person_id_grp);
948: errbuf := fnd_message.get();
949: fnd_file.put_line(fnd_file.log, errbuf); -- this message need to be displayed to user.
950: retcode := '2';
951: RETURN;
952: END IF;
953:

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

1045:
1046: fnd_message.set_name('IGS','IGS_HE_UT_NOT_RECALC');
1047: fnd_message.set_token('PERSON', l_person_number);
1048: fnd_message.set_token('CALCTYPE', p_tariff_calc_type);
1049: fnd_file.put_line(fnd_file.log, fnd_message.get());
1050:
1051: END IF;
1052:
1053: END IF; -- check for existence of parent record

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

1135: Fnd_Message.Set_Token('COURSE_CODE', '---');
1136: Fnd_Message.Set_Token('EXAM_LEVEL',prsn_exam_level_rec.Exam_level);
1137: Fnd_Message.Set_Token('SUBJECT_COUNT',l_qual_count);
1138: Fnd_Message.Set_Token('TARIFF_SCORE',l_tariff_score);
1139: fnd_file.put_line(fnd_file.log, fnd_message.get());
1140:
1141: END LOOP; -- for distinct exam levels for a person
1142:
1143: -- jchin bug 3678414 - display total tariff score

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

1145: Fnd_Message.Set_Token('PERSON_NUMBER',l_person_number);
1146: Fnd_Message.Set_Token('COURSE_CODE', '---');
1147: Fnd_Message.Set_Token('HIGH_QUAL', '---');
1148: Fnd_Message.Set_Token('TOTAL_TARIFF',l_total_tariff_score);
1149: fnd_file.put_line(fnd_file.log, fnd_message.get());
1150:
1151: END IF; -- l_calc_prsn_tariff = Y check. If no then bypass the above processing
1152:
1153: COMMIT;

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

1157: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
1158:
1159: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
1160: fnd_message.set_token('REC_CNT',l_record_inserted);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get());
1162:
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: IF l_cursor_id IS NOT NULL THEN

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

1369:
1370: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
1371: IGS_GE_GEN_003.SET_ORG_ID;
1372:
1373: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);
1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));

Line 1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);

1370: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
1371: IGS_GE_GEN_003.SET_ORG_ID;
1372:
1373: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);
1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);

Line 1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);

1371: IGS_GE_GEN_003.SET_ORG_ID;
1372:
1373: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);
1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);

Line 1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);

1372:
1373: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);
1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);

Line 1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));

1373: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);
1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);

Line 1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);

1374: fnd_file.put_line(fnd_file.log, 'P_TARIFF_CALC_TYPE = ' || p_tariff_calc_type);
1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);

Line 1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);

1375: fnd_file.put_line(fnd_file.log, 'P_CALCULATE_TARIFF = ' || p_calculate_tariff);
1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);
1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);

Line 1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);

1376: fnd_file.put_line(fnd_file.log, 'P_PERSON_ID_GRP = ' || p_person_id_grp);
1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);
1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);
1384: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');

Line 1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);

1377: fnd_file.put_line(fnd_file.log, 'P_PERSON_IDENTIFIER = ' || TO_CHAR(p_person_identifier));
1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);
1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);
1384: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1385:

Line 1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);

1378: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_GROUP = ' || p_program_group);
1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);
1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);
1384: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1385:
1386:

Line 1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);

1379: fnd_file.put_line(fnd_file.log, 'P_PROGRAM_TYPE = ' || p_program_type);
1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);
1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);
1384: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1385:
1386:
1387: /* Checking whether the UK profile is enabled */

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

1380: fnd_file.put_line(fnd_file.log, 'P_COURSE_CODE = ' || p_course_code);
1381: fnd_file.put_line(fnd_file.log, 'P_START_DATE = ' || p_start_date);
1382: fnd_file.put_line(fnd_file.log, 'P_END_DATE = ' || p_end_date);
1383: fnd_file.put_line(fnd_file.log, 'P_RECALCULATE = ' || p_recalculate);
1384: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
1385:
1386:
1387: /* Checking whether the UK profile is enabled */
1388: IF NOT (igs_uc_utils.is_ucas_hesa_enabled) THEN

Line 1391: fnd_file.put_line(fnd_file.log, fnd_message.get()); -- display to user also

1387: /* Checking whether the UK profile is enabled */
1388: IF NOT (igs_uc_utils.is_ucas_hesa_enabled) THEN
1389:
1390: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
1391: fnd_file.put_line(fnd_file.log, fnd_message.get()); -- display to user also
1392: -- also log using the new logging framework
1393: IF (fnd_log.level_statement >= l_debug_level ) THEN
1394: fnd_log.string( fnd_log.level_statement, 'igs.plsql.hesa.ucas_tariff_calc.validation', fnd_message.get());
1395: END IF;

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

1408:
1409: IF get_calc_type_rec.external_calc_ind <> 'Y' THEN
1410: --Display log message that HESA Tariff calculation can only be done for External Flagged Calculation type.
1411: fnd_message.set_name('IGS','IGS_HE_UT_CALC_NOT_EXTERNAL');
1412: fnd_file.put_line(fnd_file.log, fnd_message.get());
1413: retcode := 3;
1414: RETURN;
1415: END IF;
1416:

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

1418:
1419: -- If internal tariff calculation and start or end dates are not null then log an appropriate message and continue
1420: IF p_calculate_tariff = 'N' AND (p_start_date IS NOT NULL OR p_end_date IS NOT NULL) THEN
1421: fnd_message.set_name('IGS','IGS_HE_UT_DATE_NOT_RELEVANT');
1422: fnd_file.put_line(fnd_file.log, fnd_message.get());
1423: END IF;
1424:
1425: -- for Internal tariff calculation, parameters
1426: -- p_course_cd, p_start_date, p_end_date, p_program_group and p_program_type