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

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

49:
50: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
51: IGS_GE_GEN_003.SET_ORG_ID;
52:
53: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);
55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);

Line 54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);

50: --anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
51: IGS_GE_GEN_003.SET_ORG_ID;
52:
53: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);
55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);

Line 55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);

51: IGS_GE_GEN_003.SET_ORG_ID;
52:
53: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);
55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);

Line 56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);

52:
53: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);
55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);

Line 57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);

53: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);
55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);

Line 58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);

54: fnd_file.put_line(fnd_file.log, 'P_ORG_UNIT_CODE = ' || p_org_unit_code);
55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);

Line 59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);

55: fnd_file.put_line(fnd_file.log, 'P_UCAS_SYSTEM_CODE = ' || p_ucas_system_code);
56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);

Line 60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);

56: fnd_file.put_line(fnd_file.log, 'P_UCAS_PROGRAM_CODE = ' || p_ucas_program_code);
57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);

Line 61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);

57: fnd_file.put_line(fnd_file.log, 'P_UCAS_CAMPUS = ' || p_ucas_campus);
58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);

Line 62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);

58: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_POINT = ' || p_ucas_entry_point);
59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);
66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);

Line 63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);

59: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_MONTH = ' || p_ucas_entry_month);
60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);
66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);
67: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');

Line 64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);

60: fnd_file.put_line(fnd_file.log, 'P_UCAS_ENTRY_YEAR = ' || p_ucas_entry_year);
61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);
66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);
67: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
68:

Line 65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);

61: fnd_file.put_line(fnd_file.log, 'P_UCAS_TRANS_TYPE = ' || p_ucas_trans_type);
62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);
66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);
67: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
68:
69:

Line 66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);

62: fnd_file.put_line(fnd_file.log, 'P_UCAS_DECISION_CODE = ' || p_ucas_decision_code);
63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);
66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);
67: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
68:
69:
70: /* Checking whether the UK profile is enabled */

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

63: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_FROM = ' || p_trans_creation_dt_from);
64: fnd_file.put_line(fnd_file.log, 'P_TRANS_CREATION_DT_TO = ' || p_trans_creation_dt_to);
65: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_FROM = ' || p_trans_transmit_dt_from);
66: fnd_file.put_line(fnd_file.log, 'P_TRANS_TRANSMIT_DT_TO = ' || p_trans_transmit_dt_to);
67: fnd_file.put_line(fnd_file.log, '-------------------------------------------------------');
68:
69:
70: /* Checking whether the UK profile is enabled */
71: IF NOT (igs_uc_utils.is_ucas_hesa_enabled) THEN

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

70: /* Checking whether the UK profile is enabled */
71: IF NOT (igs_uc_utils.is_ucas_hesa_enabled) THEN
72:
73: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
74: fnd_file.put_line(fnd_file.log, fnd_message.get()); -- display to user also
75: -- also log using the fnd logging framework
76: IF (fnd_log.level_statement >= l_debug_level ) THEN
77: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.validation', fnd_message.get());
78: END IF;

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

221: IF (l_updated_rows > 0) THEN
222: --show the number of records successfully processed
223: fnd_message.set_name('IGS','IGS_UC_REC_CNT_SUCCESS_PROC');
224: fnd_message.set_token('REC_CNT',l_updated_rows);
225: fnd_file.put_line(fnd_file.log, fnd_message.get());
226: ELSE
227: --report that there were no records processed
228: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC');
229: fnd_message.set_token('REC_CNT',l_updated_rows);

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

226: ELSE
227: --report that there were no records processed
228: fnd_message.set_name('IGS','IGS_UC_REC_CNT_PROC');
229: fnd_message.set_token('REC_CNT',l_updated_rows);
230: fnd_file.put_line(fnd_file.log, fnd_message.get());
231: END IF;
232:
233: EXCEPTION
234: WHEN OTHERS THEN

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

240: ROLLBACK;
241:
242: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
243: fnd_message.set_token('NAME','igs_uc_release_trans_on_hold_pkg.release_transactions - '||SQLERRM);
244: fnd_file.put_line(fnd_file.log,fnd_message.get);
245:
246: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN
247: fnd_log.message(fnd_log.level_unexpected, 'igs.plsql.ucas.release_transactions.exception', FALSE);
248: END IF;