1: PACKAGE BODY IGIRRPI AS
2: -- $Header: igirrpib.pls 120.22.12020000.2 2012/08/27 13:58:34 sasukuma ship $
3:
4:
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
2: -- $Header: igirrpib.pls 120.22.12020000.2 2012/08/27 13:58:34 sasukuma ship $
3:
4:
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
3:
4:
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
4:
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: TYPE DATE_RANGE IS RECORD
5: l_state_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: TYPE DATE_RANGE IS RECORD
13: ( start_date DATE
6: l_proc_level CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: l_excep_level CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: l_unexp_level CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11:
12: TYPE DATE_RANGE IS RECORD
13: ( start_date DATE
14: , end_date DATE
268: -- -----------------------------------------------------------------------------
269:
270: PROCEDURE WriteToLogFile ( pp_msg_level in number,pp_path in varchar2, pp_mesg in varchar2 ) IS
271: BEGIN
272: IF pp_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: fnd_log.string(pp_msg_level, pp_path, pp_mesg );
274: END IF;
275: END;
276:
269:
270: PROCEDURE WriteToLogFile ( pp_msg_level in number,pp_path in varchar2, pp_mesg in varchar2 ) IS
271: BEGIN
272: IF pp_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
273: fnd_log.string(pp_msg_level, pp_path, pp_mesg );
274: END IF;
275: END;
276:
277: FUNCTION UseSalesCreditsAtSystem return BOOLEAN IS