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

Line 33: fnd_file.put_line ( fnd_file.LOG, ' ' );

29: BEGIN
30: -- Create a Savepoint for Rollback
31: SAVEPOINT igs_ps_ofr_opt_all ;
32:
33: fnd_file.put_line ( fnd_file.LOG, ' ' );
34: fnd_message.set_name ( 'IGS', 'IGS_PS_OFR_OPT_PURGE' );
35: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
36:
37: l_n_rec_count := 0;

Line 35: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

31: SAVEPOINT igs_ps_ofr_opt_all ;
32:
33: fnd_file.put_line ( fnd_file.LOG, ' ' );
34: fnd_message.set_name ( 'IGS', 'IGS_PS_OFR_OPT_PURGE' );
35: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
36:
37: l_n_rec_count := 0;
38: FOR rec_del_recs IN c_del_recs LOOP
39: l_b_purged := TRUE;

Line 146: fnd_file.put_line ( fnd_file.LOG, ' ');

142: igs_ps_ofr_opt_pkg.delete_row ( x_rowid => rec_del_recs.rowid );
143: END IF;
144:
145: -- Log the details of record and status of purging.
146: fnd_file.put_line ( fnd_file.LOG, ' ');
147: fnd_file.put_line ( fnd_file.LOG, ' ');
148: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
149: || ' : ' || rec_del_recs.course_cd );
150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )

Line 147: fnd_file.put_line ( fnd_file.LOG, ' ');

143: END IF;
144:
145: -- Log the details of record and status of purging.
146: fnd_file.put_line ( fnd_file.LOG, ' ');
147: fnd_file.put_line ( fnd_file.LOG, ' ');
148: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
149: || ' : ' || rec_del_recs.course_cd );
150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
151: || ' : ' || rec_del_recs.version_number );

Line 148: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )

144:
145: -- Log the details of record and status of purging.
146: fnd_file.put_line ( fnd_file.LOG, ' ');
147: fnd_file.put_line ( fnd_file.LOG, ' ');
148: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
149: || ' : ' || rec_del_recs.course_cd );
150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
151: || ' : ' || rec_del_recs.version_number );
152: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

Line 150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )

146: fnd_file.put_line ( fnd_file.LOG, ' ');
147: fnd_file.put_line ( fnd_file.LOG, ' ');
148: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
149: || ' : ' || rec_del_recs.course_cd );
150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
151: || ' : ' || rec_del_recs.version_number );
152: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
153: || ' : ' || rec_del_recs.cal_type );
154: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

Line 152: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

148: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PROGRAM_CD' )
149: || ' : ' || rec_del_recs.course_cd );
150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
151: || ' : ' || rec_del_recs.version_number );
152: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
153: || ' : ' || rec_del_recs.cal_type );
154: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
155: || ' : ' || rec_del_recs.location_cd );
156: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_MODE' )

Line 154: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )

150: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
151: || ' : ' || rec_del_recs.version_number );
152: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
153: || ' : ' || rec_del_recs.cal_type );
154: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
155: || ' : ' || rec_del_recs.location_cd );
156: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_MODE' )
157: || ' : ' || rec_del_recs.attendance_mode );
158: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_TYPE' )

Line 156: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_MODE' )

152: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
153: || ' : ' || rec_del_recs.cal_type );
154: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
155: || ' : ' || rec_del_recs.location_cd );
156: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_MODE' )
157: || ' : ' || rec_del_recs.attendance_mode );
158: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_TYPE' )
159: || ' : ' || rec_del_recs.attendance_type );
160: IF l_b_purged THEN

Line 158: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_TYPE' )

154: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'LOCATION_CD' )
155: || ' : ' || rec_del_recs.location_cd );
156: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_MODE' )
157: || ' : ' || rec_del_recs.attendance_mode );
158: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_TYPE' )
159: || ' : ' || rec_del_recs.attendance_type );
160: IF l_b_purged THEN
161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
162: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );

Line 161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )

157: || ' : ' || rec_del_recs.attendance_mode );
158: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'ATTENDANCE_TYPE' )
159: || ' : ' || rec_del_recs.attendance_type );
160: IF l_b_purged THEN
161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
162: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );
163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
164: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
165: ELSE

Line 163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )

159: || ' : ' || rec_del_recs.attendance_type );
160: IF l_b_purged THEN
161: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
162: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );
163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
164: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
165: ELSE
166: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
167: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'N' ) );

Line 166: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )

162: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );
163: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
164: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
165: ELSE
166: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
167: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'N' ) );
168: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
169: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'UPDATED' ) );
170: END IF;

Line 168: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )

164: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
165: ELSE
166: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
167: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'N' ) );
168: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
169: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'UPDATED' ) );
170: END IF;
171:
172: END LOOP;

Line 177: fnd_file.put_line ( fnd_file.LOG, ' ' );

173:
174: -- Log the number of records processed.
175: fnd_message.set_name ( 'IGS', 'IGS_AD_TOT_REC_PRC' );
176: fnd_message.set_token ( 'RCOUNT', l_n_rec_count );
177: fnd_file.put_line ( fnd_file.LOG, ' ' );
178: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
179:
180: EXCEPTION /* This exception handling is at table level */
181: WHEN OTHERS THEN

Line 178: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

174: -- Log the number of records processed.
175: fnd_message.set_name ( 'IGS', 'IGS_AD_TOT_REC_PRC' );
176: fnd_message.set_token ( 'RCOUNT', l_n_rec_count );
177: fnd_file.put_line ( fnd_file.LOG, ' ' );
178: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
179:
180: EXCEPTION /* This exception handling is at table level */
181: WHEN OTHERS THEN
182: -- If any exception occurs, whole transaction should be rolled off.

Line 188: fnd_file.put_line ( fnd_file.LOG, l_c_message );

184:
185: -- We have to log message stacked by TBH, if any. Otherwise, we will log the generic unhandled exception.
186: l_c_message := fnd_message.get ;
187: IF ( l_c_message IS NOT NULL ) THEN
188: fnd_file.put_line ( fnd_file.LOG, l_c_message );
189: ELSE
190: fnd_message.set_name ( 'IGS', 'IGS_GE_UNHANDLED_EXP' );
191: fnd_message.set_token ( 'NAME', 'purge_igs_ps_ofr_opt_all' );
192: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );

Line 192: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );

188: fnd_file.put_line ( fnd_file.LOG, l_c_message );
189: ELSE
190: fnd_message.set_name ( 'IGS', 'IGS_GE_UNHANDLED_EXP' );
191: fnd_message.set_token ( 'NAME', 'purge_igs_ps_ofr_opt_all' );
192: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );
193: END IF;
194:
195: END purge_igs_ps_ofr_opt_all; /* End Of Processing IGS_PS_OFR_OPT_ALL records */
196:

Line 235: fnd_file.put_line ( fnd_file.LOG, ' ' );

231: BEGIN
232: -- Create a Savepoint for Rollback
233: SAVEPOINT igs_ps_unit_ofr_pat_all ;
234:
235: fnd_file.put_line ( fnd_file.LOG, ' ' );
236: fnd_message.set_name ( 'IGS', 'IGS_PS_UOP_PURGE' );
237: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
238:
239: l_n_rec_count := 0;

Line 237: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

233: SAVEPOINT igs_ps_unit_ofr_pat_all ;
234:
235: fnd_file.put_line ( fnd_file.LOG, ' ' );
236: fnd_message.set_name ( 'IGS', 'IGS_PS_UOP_PURGE' );
237: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
238:
239: l_n_rec_count := 0;
240: FOR rec_del_recs IN c_del_recs LOOP
241: l_b_purged := TRUE;

Line 297: fnd_file.put_line ( fnd_file.LOG, ' ');

293: igs_ps_unit_ofr_pat_pkg.delete_row ( x_rowid => rec_del_recs.rowid );
294: END IF;
295:
296: -- Log the details of record and status of purging.
297: fnd_file.put_line ( fnd_file.LOG, ' ');
298: fnd_file.put_line ( fnd_file.LOG, ' ');
299: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
300: || ' : ' || rec_del_recs.unit_cd );
301: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )

Line 298: fnd_file.put_line ( fnd_file.LOG, ' ');

294: END IF;
295:
296: -- Log the details of record and status of purging.
297: fnd_file.put_line ( fnd_file.LOG, ' ');
298: fnd_file.put_line ( fnd_file.LOG, ' ');
299: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
300: || ' : ' || rec_del_recs.unit_cd );
301: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
302: || ' : ' || rec_del_recs.version_number );

Line 299: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

295:
296: -- Log the details of record and status of purging.
297: fnd_file.put_line ( fnd_file.LOG, ' ');
298: fnd_file.put_line ( fnd_file.LOG, ' ');
299: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
300: || ' : ' || rec_del_recs.unit_cd );
301: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
302: || ' : ' || rec_del_recs.version_number );
303: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

Line 301: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )

297: fnd_file.put_line ( fnd_file.LOG, ' ');
298: fnd_file.put_line ( fnd_file.LOG, ' ');
299: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
300: || ' : ' || rec_del_recs.unit_cd );
301: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
302: || ' : ' || rec_del_recs.version_number );
303: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
304: || ' : ' || rec_del_recs.cal_type );
305: OPEN c_alt_code(rec_del_recs.cal_type,rec_del_recs.ci_sequence_number);

Line 303: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

299: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
300: || ' : ' || rec_del_recs.unit_cd );
301: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'VERSION_NUMBER' )
302: || ' : ' || rec_del_recs.version_number );
303: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
304: || ' : ' || rec_del_recs.cal_type );
305: OPEN c_alt_code(rec_del_recs.cal_type,rec_del_recs.ci_sequence_number);
306: FETCH c_alt_code INTO l_c_alt_code;
307: CLOSE c_alt_code;

Line 308: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'ALT_CODE' )

304: || ' : ' || rec_del_recs.cal_type );
305: OPEN c_alt_code(rec_del_recs.cal_type,rec_del_recs.ci_sequence_number);
306: FETCH c_alt_code INTO l_c_alt_code;
307: CLOSE c_alt_code;
308: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'ALT_CODE' )
309: || ' : ' || l_c_alt_code );
310: IF l_b_purged THEN
311: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
312: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );

Line 311: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )

307: CLOSE c_alt_code;
308: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'ALT_CODE' )
309: || ' : ' || l_c_alt_code );
310: IF l_b_purged THEN
311: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
312: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );
313: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
314: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
315: ELSE

Line 313: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )

309: || ' : ' || l_c_alt_code );
310: IF l_b_purged THEN
311: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
312: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );
313: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
314: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
315: ELSE
316: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
317: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'N' ) );

Line 316: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )

312: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'Y' ) );
313: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
314: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
315: ELSE
316: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
317: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'N' ) );
318: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
319: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'UPDATED' ) );
320: END IF;

Line 318: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )

314: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'PURGED' ) );
315: ELSE
316: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'DELETE_FLAG' )
317: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'TIMESLOT_ALPHABET', 'N' ) );
318: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'STATUS' )
319: || ' : ' || igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'UPDATED' ) );
320: END IF;
321:
322: END LOOP;

Line 327: fnd_file.put_line ( fnd_file.LOG, ' ' );

323:
324: -- Log the number of records processed.
325: fnd_message.set_name ( 'IGS', 'IGS_AD_TOT_REC_PRC' );
326: fnd_message.set_token ( 'RCOUNT', l_n_rec_count );
327: fnd_file.put_line ( fnd_file.LOG, ' ' );
328: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
329:
330: EXCEPTION /* This exception handling is at table level */
331: WHEN OTHERS THEN

Line 328: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

324: -- Log the number of records processed.
325: fnd_message.set_name ( 'IGS', 'IGS_AD_TOT_REC_PRC' );
326: fnd_message.set_token ( 'RCOUNT', l_n_rec_count );
327: fnd_file.put_line ( fnd_file.LOG, ' ' );
328: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
329:
330: EXCEPTION /* This exception handling is at table level */
331: WHEN OTHERS THEN
332: -- If any exception occurs, whole transaction should be rolled off.

Line 338: fnd_file.put_line ( fnd_file.LOG, l_c_message );

334:
335: -- We have to log message stacked by TBH, if any. Otherwise, we will log the generic unhandled exception.
336: l_c_message := fnd_message.get ;
337: IF ( l_c_message IS NOT NULL ) THEN
338: fnd_file.put_line ( fnd_file.LOG, l_c_message );
339: ELSE
340: fnd_message.set_name ( 'IGS', 'IGS_GE_UNHANDLED_EXP' );
341: fnd_message.set_token ( 'NAME', 'purge_igs_ps_unit_ofr_pat_all' );
342: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );

Line 342: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );

338: fnd_file.put_line ( fnd_file.LOG, l_c_message );
339: ELSE
340: fnd_message.set_name ( 'IGS', 'IGS_GE_UNHANDLED_EXP' );
341: fnd_message.set_token ( 'NAME', 'purge_igs_ps_unit_ofr_pat_all' );
342: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );
343: END IF;
344:
345: END purge_igs_ps_unit_ofr_pat_all; /* End Of Processing IGS_PS_UNIT_OFR_PAT_ALL records */
346:

Line 386: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );

382: EXCEPTION /* This exception handling is at Module Level */
383: WHEN OTHERS THEN
384: fnd_message.set_name ( 'IGS', 'IGS_GE_UNHANDLED_EXP' );
385: fnd_message.set_token ( 'NAME', 'purge_ps_records' );
386: fnd_file.put_line ( fnd_file.LOG, fnd_message.get || ' : ' || SQLERRM );
387:
388: END purge_ps_records;
389:
390: END igs_ps_purge_del_record;