DBA Data[Home] [Help]

APPS.IGS_UC_UPD_PENDING_TRANS_PKG dependencies on FND_MESSAGE

Line 134: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');

130:
131: /* Checking whether the UK profile is enabled */
132: IF NOT (igs_uc_utils.is_ucas_hesa_enabled) THEN
133:
134: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
135: fnd_file.put_line(fnd_file.log, fnd_message.get()); -- display to user also
136: -- also log using the fnd logging framework
137: IF (fnd_log.level_statement >= l_debug_level ) THEN
138: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.upd_pending_transactions.validation', fnd_message.get());

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

131: /* Checking whether the UK profile is enabled */
132: IF NOT (igs_uc_utils.is_ucas_hesa_enabled) THEN
133:
134: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
135: fnd_file.put_line(fnd_file.log, fnd_message.get()); -- display to user also
136: -- also log using the fnd logging framework
137: IF (fnd_log.level_statement >= l_debug_level ) THEN
138: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.upd_pending_transactions.validation', fnd_message.get());
139: END IF;

Line 138: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.upd_pending_transactions.validation', fnd_message.get());

134: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
135: fnd_file.put_line(fnd_file.log, fnd_message.get()); -- display to user also
136: -- also log using the fnd logging framework
137: IF (fnd_log.level_statement >= l_debug_level ) THEN
138: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.upd_pending_transactions.validation', fnd_message.get());
139: END IF;
140: errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');
141: retcode := 3 ;
142: RETURN ;

Line 140: errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');

136: -- also log using the fnd logging framework
137: IF (fnd_log.level_statement >= l_debug_level ) THEN
138: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.upd_pending_transactions.validation', fnd_message.get());
139: END IF;
140: errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');
141: retcode := 3 ;
142: RETURN ;
143:
144: END IF;

Line 159: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');

155: CLOSE c_control;
156:
157: -- Check whether configured cycle is same as entry year
158: IF l_entry_year <> c_cycle_rec.configured_cycle THEN
159: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
160: fnd_message.set_token('UCAS_CYCLE',c_cycle_rec.configured_cycle);
161: fnd_message.set_token('HERC_CYCLE',l_entry_year);
162: fnd_file.put_line(fnd_file.log, fnd_message.get());
163: errbuf := fnd_message.get;

Line 160: fnd_message.set_token('UCAS_CYCLE',c_cycle_rec.configured_cycle);

156:
157: -- Check whether configured cycle is same as entry year
158: IF l_entry_year <> c_cycle_rec.configured_cycle THEN
159: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
160: fnd_message.set_token('UCAS_CYCLE',c_cycle_rec.configured_cycle);
161: fnd_message.set_token('HERC_CYCLE',l_entry_year);
162: fnd_file.put_line(fnd_file.log, fnd_message.get());
163: errbuf := fnd_message.get;
164: retcode := 2;

Line 161: fnd_message.set_token('HERC_CYCLE',l_entry_year);

157: -- Check whether configured cycle is same as entry year
158: IF l_entry_year <> c_cycle_rec.configured_cycle THEN
159: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
160: fnd_message.set_token('UCAS_CYCLE',c_cycle_rec.configured_cycle);
161: fnd_message.set_token('HERC_CYCLE',l_entry_year);
162: fnd_file.put_line(fnd_file.log, fnd_message.get());
163: errbuf := fnd_message.get;
164: retcode := 2;
165: RETURN;

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

158: IF l_entry_year <> c_cycle_rec.configured_cycle THEN
159: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
160: fnd_message.set_token('UCAS_CYCLE',c_cycle_rec.configured_cycle);
161: fnd_message.set_token('HERC_CYCLE',l_entry_year);
162: fnd_file.put_line(fnd_file.log, fnd_message.get());
163: errbuf := fnd_message.get;
164: retcode := 2;
165: RETURN;
166: END IF;

Line 163: errbuf := fnd_message.get;

159: fnd_message.set_name('IGS','IGS_UC_CYCLES_NOT_SYNC');
160: fnd_message.set_token('UCAS_CYCLE',c_cycle_rec.configured_cycle);
161: fnd_message.set_token('HERC_CYCLE',l_entry_year);
162: fnd_file.put_line(fnd_file.log, fnd_message.get());
163: errbuf := fnd_message.get;
164: retcode := 2;
165: RETURN;
166: END IF;
167:

Line 177: fnd_message.set_name('IGS','IGS_UC_INIT_TRAN_PENDING_CNT');

173: OPEN c_pending_trans_count(c_cycle_rec.configured_cycle);
174: FETCH c_pending_trans_count INTO l_pending_cnt;
175: CLOSE c_pending_trans_count;
176:
177: fnd_message.set_name('IGS','IGS_UC_INIT_TRAN_PENDING_CNT');
178: fnd_message.set_token('REC_CNT',l_pending_cnt);
179: fnd_file.put_line(fnd_file.log, fnd_message.get());
180:
181: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .

Line 178: fnd_message.set_token('REC_CNT',l_pending_cnt);

174: FETCH c_pending_trans_count INTO l_pending_cnt;
175: CLOSE c_pending_trans_count;
176:
177: fnd_message.set_name('IGS','IGS_UC_INIT_TRAN_PENDING_CNT');
178: fnd_message.set_token('REC_CNT',l_pending_cnt);
179: fnd_file.put_line(fnd_file.log, fnd_message.get());
180:
181: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .
182: FOR c_pending_trans_rec IN c_pending_trans(c_cycle_rec.configured_cycle)

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

175: CLOSE c_pending_trans_count;
176:
177: fnd_message.set_name('IGS','IGS_UC_INIT_TRAN_PENDING_CNT');
178: fnd_message.set_token('REC_CNT',l_pending_cnt);
179: fnd_file.put_line(fnd_file.log, fnd_message.get());
180:
181: --When the Interface is Hercules then get the Transaction records from IGS_UC_TRANSACTIONS table and insert into Hercules igs_uc_u_tranin_2004 .
182: FOR c_pending_trans_rec IN c_pending_trans(c_cycle_rec.configured_cycle)
183: LOOP

Line 255: fnd_message.set_name('IGS','IGS_UC_TRAN_VALID_CNT');

251:
252: COMMIT;
253:
254: --print statistics
255: fnd_message.set_name('IGS','IGS_UC_TRAN_VALID_CNT');
256: fnd_message.set_token('REC_CNT',l_valid_cnt);
257: fnd_file.put_line(fnd_file.log, fnd_message.get());
258:
259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');

Line 256: fnd_message.set_token('REC_CNT',l_valid_cnt);

252: COMMIT;
253:
254: --print statistics
255: fnd_message.set_name('IGS','IGS_UC_TRAN_VALID_CNT');
256: fnd_message.set_token('REC_CNT',l_valid_cnt);
257: fnd_file.put_line(fnd_file.log, fnd_message.get());
258:
259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');
260: fnd_message.set_token('REC_CNT',l_invalid_cnt);

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

253:
254: --print statistics
255: fnd_message.set_name('IGS','IGS_UC_TRAN_VALID_CNT');
256: fnd_message.set_token('REC_CNT',l_valid_cnt);
257: fnd_file.put_line(fnd_file.log, fnd_message.get());
258:
259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');
260: fnd_message.set_token('REC_CNT',l_invalid_cnt);
261: fnd_file.put_line(fnd_file.log, fnd_message.get());

Line 259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');

255: fnd_message.set_name('IGS','IGS_UC_TRAN_VALID_CNT');
256: fnd_message.set_token('REC_CNT',l_valid_cnt);
257: fnd_file.put_line(fnd_file.log, fnd_message.get());
258:
259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');
260: fnd_message.set_token('REC_CNT',l_invalid_cnt);
261: fnd_file.put_line(fnd_file.log, fnd_message.get());
262:
263: -- get the final count of pending transactions

Line 260: fnd_message.set_token('REC_CNT',l_invalid_cnt);

256: fnd_message.set_token('REC_CNT',l_valid_cnt);
257: fnd_file.put_line(fnd_file.log, fnd_message.get());
258:
259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');
260: fnd_message.set_token('REC_CNT',l_invalid_cnt);
261: fnd_file.put_line(fnd_file.log, fnd_message.get());
262:
263: -- get the final count of pending transactions
264: OPEN c_pending_trans_count(c_cycle_rec.configured_cycle);

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

257: fnd_file.put_line(fnd_file.log, fnd_message.get());
258:
259: fnd_message.set_name('IGS','IGS_UC_TRAN_INVALID_CNT');
260: fnd_message.set_token('REC_CNT',l_invalid_cnt);
261: fnd_file.put_line(fnd_file.log, fnd_message.get());
262:
263: -- get the final count of pending transactions
264: OPEN c_pending_trans_count(c_cycle_rec.configured_cycle);
265: FETCH c_pending_trans_count INTO l_pending_cnt;

Line 268: fnd_message.set_name('IGS','IGS_UC_TRAN_PENDING_CNT');

264: OPEN c_pending_trans_count(c_cycle_rec.configured_cycle);
265: FETCH c_pending_trans_count INTO l_pending_cnt;
266: CLOSE c_pending_trans_count;
267:
268: fnd_message.set_name('IGS','IGS_UC_TRAN_PENDING_CNT');
269: fnd_message.set_token('REC_CNT',l_pending_cnt);
270: fnd_file.put_line(fnd_file.log, fnd_message.get());
271:
272:

Line 269: fnd_message.set_token('REC_CNT',l_pending_cnt);

265: FETCH c_pending_trans_count INTO l_pending_cnt;
266: CLOSE c_pending_trans_count;
267:
268: fnd_message.set_name('IGS','IGS_UC_TRAN_PENDING_CNT');
269: fnd_message.set_token('REC_CNT',l_pending_cnt);
270: fnd_file.put_line(fnd_file.log, fnd_message.get());
271:
272:
273: EXCEPTION

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

266: CLOSE c_pending_trans_count;
267:
268: fnd_message.set_name('IGS','IGS_UC_TRAN_PENDING_CNT');
269: fnd_message.set_token('REC_CNT',l_pending_cnt);
270: fnd_file.put_line(fnd_file.log, fnd_message.get());
271:
272:
273: EXCEPTION
274: WHEN OTHERS THEN

Line 277: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

273: EXCEPTION
274: WHEN OTHERS THEN
275: ROLLBACK;
276:
277: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
278: fnd_message.set_token('NAME','igs_uc_upd_pending_trans_pkg.upd_pending_transactions - '||SQLERRM);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280:
281: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN

Line 278: fnd_message.set_token('NAME','igs_uc_upd_pending_trans_pkg.upd_pending_transactions - '||SQLERRM);

274: WHEN OTHERS THEN
275: ROLLBACK;
276:
277: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
278: fnd_message.set_token('NAME','igs_uc_upd_pending_trans_pkg.upd_pending_transactions - '||SQLERRM);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280:
281: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN
282: fnd_log.message(fnd_log.level_unexpected, 'igs.plsql.ucas.upd_pending_transactions.exception', FALSE);

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

275: ROLLBACK;
276:
277: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
278: fnd_message.set_token('NAME','igs_uc_upd_pending_trans_pkg.upd_pending_transactions - '||SQLERRM);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280:
281: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN
282: fnd_log.message(fnd_log.level_unexpected, 'igs.plsql.ucas.upd_pending_transactions.exception', FALSE);
283: END IF;

Line 285: fnd_message.retrieve (errbuf);

281: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN
282: fnd_log.message(fnd_log.level_unexpected, 'igs.plsql.ucas.upd_pending_transactions.exception', FALSE);
283: END IF;
284:
285: fnd_message.retrieve (errbuf);
286: retcode := 2 ;
287: igs_ge_msg_stack.conc_exception_hndl;
288:
289: END upd_pending_transactions;