DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on FND_LOG

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

175: G_PKG_NAME)
176: THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179: FND_LOG_REPOSITORY.init(null,null);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: g_statement_log:=true;
182: end if;
183: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

176: THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179: FND_LOG_REPOSITORY.init(null,null);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: g_statement_log:=true;
182: end if;
183: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
184: g_exception_log:=true;

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

179: FND_LOG_REPOSITORY.init(null,null);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: g_statement_log:=true;
182: end if;
183: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
184: g_exception_log:=true;
185: end if;
186: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
187: g_error_log:=true;

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

182: end if;
183: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
184: g_exception_log:=true;
185: end if;
186: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
187: g_error_log:=true;
188: end if;
189: LOOP
190: SAVEPOINT process_emails_pvt;

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

2436:
2437: PROCEDURE iem_logger(l_logmessage in varchar2) IS
2438: begin
2439: if g_statement_log THEN
2440: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2442: end if;
2443: end if;
2444: if g_exception_log then

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

2437: PROCEDURE iem_logger(l_logmessage in varchar2) IS
2438: begin
2439: if g_statement_log THEN
2440: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2442: end if;
2443: end if;
2444: if g_exception_log then
2445: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

2441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2442: end if;
2443: end if;
2444: if g_exception_log then
2445: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2447: end if;
2448: end if;
2449: if g_error_log then

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

2442: end if;
2443: end if;
2444: if g_exception_log then
2445: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2447: end if;
2448: end if;
2449: if g_error_log then
2450: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

2446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2447: end if;
2448: end if;
2449: if g_error_log then
2450: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2451: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2452: end if;
2453: end if;
2454: end iem_logger;

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

2447: end if;
2448: end if;
2449: if g_error_log then
2450: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2451: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2452: end if;
2453: end if;
2454: end iem_logger;
2455:

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

3870: THEN
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873: l_level:='STATEMENT';
3874: FND_LOG_REPOSITORY.init(null,null);
3875: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
3876: SAVEPOINT processautoreply;
3877: -- Find the record from iem_rt_proc_emails based on media id
3878: BEGIN

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

3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873: l_level:='STATEMENT';
3874: FND_LOG_REPOSITORY.init(null,null);
3875: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
3876: SAVEPOINT processautoreply;
3877: -- Find the record from iem_rt_proc_emails based on media id
3878: BEGIN
3879: select * into l_mail_rec from iem_rt_proc_emails