DBA Data[Home] [Help]

APPS.IGC_CC_APPROVAL_PROCESS dependencies on FND_LOG

Line 11: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

7: --l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
8: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9:
10: --Variables for ATG Central logging
11: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

8: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9:
10: --Variables for ATG Central logging
11: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

Line 13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

9:
10: --Variables for ATG Central logging
11: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
17: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;

10: --Variables for ATG Central logging
11: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
17: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
18: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPPB.IGC_CC_APPROVAL_PROCESS.';

Line 15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

11: g_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
17: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
18: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPPB.IGC_CC_APPROVAL_PROCESS.';
19:

Line 16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;

12: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
17: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
18: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPPB.IGC_CC_APPROVAL_PROCESS.';
19:
20:

Line 17: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;

13: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
15: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
16: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
17: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
18: g_path VARCHAR2(255) := 'IGC.PLSQL.IGCCAPPB.IGC_CC_APPROVAL_PROCESS.';
19:
20:
21: PROCEDURE Put_Debug_Msg (

Line 114: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);

110: FOR l_cur IN 1..l_msg_count LOOP
111: -- l_msg_data :=l_msg_data||' Mes No'||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
112: l_msg_data :=l_msg_data||' '||l_cur||' '||FND_MSG_PUB.GET(l_cur,FND_API.G_FALSE);
113: IF(g_error_level >= g_debug_level) THEN
114: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);
115: END IF;
116: END LOOP;
117: ELSE
118: IF(g_error_level >= g_debug_level) THEN

Line 119: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);

115: END IF;
116: END LOOP;
117: ELSE
118: IF(g_error_level >= g_debug_level) THEN
119: FND_LOG.STRING(g_error_level, l_full_path, l_msg_data);
120: END IF;
121: l_msg_data :='Error stack has no data';
122: END IF;
123:

Line 257: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

253:
254: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
255: p_data => x_msg_data);
256: IF (g_excep_level >= g_debug_level ) THEN
257: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
258: END IF;
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK to Preparer_Can_Approve;
261:

Line 267: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

263:
264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
265: p_data => x_msg_data);
266: IF (g_excep_level >= g_debug_level ) THEN
267: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
268: END IF;
269: WHEN OTHERS THEN
270: ROLLBACK to Preparer_Can_Approve;
271:

Line 284: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

280: IF ( g_unexp_level >= g_debug_level ) THEN
281: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
282: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
283: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
284: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
285: END IF;
286:
287: END Preparer_Can_Approve;
288:

Line 558: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');

554:
555: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
556: p_data => p_msg_data );
557: IF (g_excep_level >= g_debug_level ) THEN
558: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_ERROR Exception Raised');
559: END IF;
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK to Approved_By_Preparer;
562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 569: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');

565:
566: FND_MSG_PUB.Count_And_Get(p_count => p_msg_count ,
567: p_data => p_msg_data );
568: IF (g_excep_level >= g_debug_level ) THEN
569: FND_LOG.STRING (g_excep_level,l_full_path,'FND_API.G_EXC_UNEXPECTED_ERROR Exception Raised');
570: END IF;
571: WHEN OTHERS THEN
572: ROLLBACK to Approved_By_Preparer;
573: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 587: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);

583: IF ( g_unexp_level >= g_debug_level ) THEN
584: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
585: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
586: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
587: FND_LOG.MESSAGE ( g_unexp_level,l_full_path, TRUE);
588: END IF;
589:
590:
591: END Approved_By_Preparer;

Line 757: FND_LOG.STRING(g_state_level, p_path, p_debug_msg);

753: END IF;*/
754: -- END IF;
755:
756: IF(g_state_level >= g_debug_level) THEN
757: FND_LOG.STRING(g_state_level, p_path, p_debug_msg);
758: END IF;
759: -- --------------------------------------------------------------------
760: -- Exception handler section for the Put_Debug_Msg procedure.
761: -- --------------------------------------------------------------------