4:
5: p_effective_date DATE;
6:
7:
8: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
5: p_effective_date DATE;
6:
7:
8: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
6:
7:
8: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7:
8: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: l_path VARCHAR2(50) := 'IGI.PLSQL.igicisdb.IGI_CIS_UPDC.';
8: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: l_path VARCHAR2(50) := 'IGI.PLSQL.igicisdb.IGI_CIS_UPDC.';
16:
9: l_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: l_path VARCHAR2(50) := 'IGI.PLSQL.igicisdb.IGI_CIS_UPDC.';
16:
17:
10: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: l_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: l_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: l_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: l_path VARCHAR2(50) := 'IGI.PLSQL.igicisdb.IGI_CIS_UPDC.';
16:
17:
18: /*PROCEDURE WriteLog ( pp_mesg in varchar2 , pp_debug_mode in boolean := FALSE ) IS
28:
29: PROCEDURE Debug ( p_level IN NUMBER, p_path IN VARCHAR2, p_mesg IN VARCHAR2 ) is
30: BEGIN
31: IF (p_level >= l_debug_level ) THEN
32: FND_LOG.STRING (p_level , l_path || p_path , p_mesg );
33: END IF;
34: END ;
35:
36: