DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on FND_LOG

Line 214: FND_LOG_REPOSITORY.init(null,null);

210: G_PKG_NAME)
211: THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214: FND_LOG_REPOSITORY.init(null,null);
215: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
216: g_statement_log:=true;
217: end if;
218: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 215: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

211: THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214: FND_LOG_REPOSITORY.init(null,null);
215: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
216: g_statement_log:=true;
217: end if;
218: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
219: g_exception_log:=true;

Line 218: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

214: FND_LOG_REPOSITORY.init(null,null);
215: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
216: g_statement_log:=true;
217: end if;
218: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
219: g_exception_log:=true;
220: end if;
221: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
222: g_error_log:=true;

Line 221: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

217: end if;
218: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
219: g_exception_log:=true;
220: end if;
221: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
222: g_error_log:=true;
223: end if;
224: LOOP
225: SAVEPOINT process_emails_pvt;

Line 3535: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3531:
3532: PROCEDURE iem_logger(l_logmessage in varchar2) IS
3533: begin
3534: if g_statement_log THEN
3535: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3537: end if;
3538: end if;
3539: if g_exception_log then

Line 3536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);

3532: PROCEDURE iem_logger(l_logmessage in varchar2) IS
3533: begin
3534: if g_statement_log THEN
3535: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3537: end if;
3538: end if;
3539: if g_exception_log then
3540: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3540: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3537: end if;
3538: end if;
3539: if g_exception_log then
3540: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3541: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3542: end if;
3543: end if;
3544: if g_error_log then

Line 3541: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);

3537: end if;
3538: end if;
3539: if g_exception_log then
3540: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3541: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3542: end if;
3543: end if;
3544: if g_error_log then
3545: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3545: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3541: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3542: end if;
3543: end if;
3544: if g_error_log then
3545: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3546: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3547: end if;
3548: end if;
3549: end iem_logger;

Line 3546: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);

3542: end if;
3543: end if;
3544: if g_error_log then
3545: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3546: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3547: end if;
3548: end if;
3549: end iem_logger;
3550:

Line 4969: FND_LOG_REPOSITORY.init(null,null);

4965: THEN
4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END IF;
4968: l_level:='STATEMENT';
4969: FND_LOG_REPOSITORY.init(null,null);
4970: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
4971: SAVEPOINT processautoreply;
4972: -- Find the record from iem_rt_proc_emails based on media id
4973: BEGIN

Line 4970: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');

4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END IF;
4968: l_level:='STATEMENT';
4969: FND_LOG_REPOSITORY.init(null,null);
4970: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
4971: SAVEPOINT processautoreply;
4972: -- Find the record from iem_rt_proc_emails based on media id
4973: BEGIN
4974: select * into l_mail_rec from iem_rt_proc_emails