DBA Data[Home] [Help]

APPS.IEM_TAG_RUN_PROC_PVT dependencies on FND_LOG

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

338: EXCEPTION
339: WHEN l_IEM_INVALID_PROCEDURE THEN
340: ROLLBACK TO run_Procedure_PVT;
341:
342: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
343: logMessage := '[Invalid procedure: ' || l_proc_name|| ']';
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
345: end if;
346: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);

340: ROLLBACK TO run_Procedure_PVT;
341:
342: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
343: logMessage := '[Invalid procedure: ' || l_proc_name|| ']';
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
345: end if;
346: x_return_status := FND_API.G_RET_STS_ERROR ;
347:
348: WHEN FND_API.G_EXC_ERROR THEN

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

351: FND_MSG_PUB.Count_And_Get
352: ( p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
356: logMessage := '[FND_API.G_EXC_ERROR happened in RUN_PROCEDURE - ' || l_proc_name|| ' error:'||sqlerrm||']';
357: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
358: end if;
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 357: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);

353: p_data => x_msg_data
354: );
355: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
356: logMessage := '[FND_API.G_EXC_ERROR happened in RUN_PROCEDURE - ' || l_proc_name|| ' error:'||sqlerrm||']';
357: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
358: end if;
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360: ROLLBACK TO run_Procedure_PVT;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
367: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR happened in RUN_PROCEDURE - ' || l_proc_name|| ' error:'||sqlerrm||']';
368: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
369: end if;
370: WHEN OTHERS THEN

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);

364: p_data => x_msg_data
365: );
366: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
367: logMessage := '[FND_API.G_EXC_UNEXPECTED_ERROR happened in RUN_PROCEDURE - ' || l_proc_name|| ' error:'||sqlerrm||']';
368: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
369: end if;
370: WHEN OTHERS THEN
371: ROLLBACK TO run_Procedure_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR;

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

385: p_data => x_msg_data
386: );
387:
388:
389: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
390: logMessage := '[OTHER exception happened in RUN_PROCEDURE - ' || l_proc_name|| ' error:'||sqlerrm||']';
391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
392: end if;
393: -- dbms_output.put_line('Exception in Run Procedure happened ' || SUBSTR (SQLERRM , 1 , 100));

Line 391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);

387:
388:
389: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
390: logMessage := '[OTHER exception happened in RUN_PROCEDURE - ' || l_proc_name|| ' error:'||sqlerrm||']';
391: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_TAG_RUNPROC_PVT.RUN_PROCEDURE', logMessage);
392: end if;
393: -- dbms_output.put_line('Exception in Run Procedure happened ' || SUBSTR (SQLERRM , 1 , 100));
394: END run_Procedure;
395: