APPS.IGS_UC_RELEASE_TRANS_PKG dependencies on FND_LOG

Line 4: l_debug_level NUMBER:= fnd_log.g_current_runtime_level;

1: PACKAGE BODY igs_uc_release_trans_pkg AS
2: /* $Header: IGSUC69B.pls 120.2 2006/05/04 20:59:02 jchakrab noship $*/
3:
4: l_debug_level NUMBER:= fnd_log.g_current_runtime_level;
5:
6: PROCEDURE release_transactions (
7: errbuf OUT NOCOPY VARCHAR2,
8: retcode OUT NOCOPY NUMBER,

Line 75: -- also log using the fnd logging framework

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;
79: errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');

Line 76: IF (fnd_log.level_statement >= l_debug_level ) 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;
79: errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');
80: retcode := 3 ;

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

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;
79: errbuf := fnd_message.get_string ('IGS', 'IGS_UC_HE_NOT_ENABLED');
80: retcode := 3 ;
81: RETURN ;

Line 204: -- log the UPDATE DML statement using the fnd logging framework

200:
201:
202: l_update_stmt := fnd_dsql.get_text(FALSE);
203:
204: -- log the UPDATE DML statement using the fnd logging framework
205: IF (fnd_log.level_statement >= l_debug_level ) THEN
206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);
207: END IF;
208:

Line 205: IF (fnd_log.level_statement >= l_debug_level ) THEN

201:
202: l_update_stmt := fnd_dsql.get_text(FALSE);
203:
204: -- log the UPDATE DML statement using the fnd logging framework
205: IF (fnd_log.level_statement >= l_debug_level ) THEN
206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);
207: END IF;
208:
209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);

202: l_update_stmt := fnd_dsql.get_text(FALSE);
203:
204: -- log the UPDATE DML statement using the fnd logging framework
205: IF (fnd_log.level_statement >= l_debug_level ) THEN
206: fnd_log.string( fnd_log.level_statement, 'igs.plsql.ucas.release_transactions.update_dml', l_update_stmt);
207: END IF;
208:
209: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
210: fnd_dsql.set_cursor(l_cursor_id);

Line 246: IF ( fnd_log.level_unexpected >= l_debug_level ) THEN

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;
249:
250: fnd_message.retrieve (errbuf);

Line 247: fnd_log.message(fnd_log.level_unexpected, 'igs.plsql.ucas.release_transactions.exception', FALSE);

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;
249:
250: fnd_message.retrieve (errbuf);
251: retcode := 2 ;