1: PACKAGE BODY IGI_CIS2007_CERT_PKG AS
2: -- $Header: igipuprb.pls 120.0.12000000.1 2007/07/13 07:05:52 vensubra noship $
3:
4:
5: l_debug_level Number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level Number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
2: -- $Header: igipuprb.pls 120.0.12000000.1 2007/07/13 07:05:52 vensubra noship $
3:
4:
5: l_debug_level Number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level Number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level Number := FND_LOG.LEVEL_ERROR;
3:
4:
5: l_debug_level Number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level Number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level Number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level Number := FND_LOG.LEVEL_UNEXPECTED;
4:
5: l_debug_level Number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level Number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level Number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level Number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path Varchar2(50) := 'IGI.PLSQL.igipuprb.IGI_CIS2007_CERT_PKG.';
5: l_debug_level Number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: l_state_level Number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level Number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level Number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path Varchar2(50) := 'IGI.PLSQL.igipuprb.IGI_CIS2007_CERT_PKG.';
13:
6: l_state_level Number := FND_LOG.LEVEL_STATEMENT;
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level Number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level Number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path Varchar2(50) := 'IGI.PLSQL.igipuprb.IGI_CIS2007_CERT_PKG.';
13:
14:
7: l_proc_level Number := FND_LOG.LEVEL_PROCEDURE;
8: l_event_level Number := FND_LOG.LEVEL_EVENT;
9: l_excep_level Number := FND_LOG.LEVEL_EXCEPTION;
10: l_error_level Number := FND_LOG.LEVEL_ERROR;
11: l_unexp_level Number := FND_LOG.LEVEL_UNEXPECTED;
12: l_path Varchar2(50) := 'IGI.PLSQL.igipuprb.IGI_CIS2007_CERT_PKG.';
13:
14:
15: Procedure WriteLog ( pp_mesg in varchar2 ) Is
24:
25: Procedure Debug( p_level IN Number, p_path IN Varchar2, p_mesg IN Varchar2 ) Is
26: Begin
27: If (p_level >= l_debug_level ) THEN
28: FND_LOG.STRING (p_level , l_path || p_path , p_mesg );
29: End If;
30: End ;
31:
32: Procedure Update_Rates(