1: PACKAGE BODY IGI_IMP_IAC_EXCEP_INER_PKG AS
2: -- $Header: igiiaerb.pls 120.13.12000000.1 2007/08/01 16:15:16 npandya noship $
3:
4: --===========================FND_LOG.START=====================================
5:
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
2: -- $Header: igiiaerb.pls 120.13.12000000.1 2007/08/01 16:15:16 npandya noship $
3:
4: --===========================FND_LOG.START=====================================
5:
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
3:
4: --===========================FND_LOG.START=====================================
5:
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
4: --===========================FND_LOG.START=====================================
5:
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaerb.IGI_IMP_IAC_EXCEP_INER_PKG.';
5:
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaerb.IGI_IMP_IAC_EXCEP_INER_PKG.';
13:
6: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaerb.IGI_IMP_IAC_EXCEP_INER_PKG.';
13:
14: --===========================FND_LOG.END=====================================
7: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaerb.IGI_IMP_IAC_EXCEP_INER_PKG.';
13:
14: --===========================FND_LOG.END=====================================
15:
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaerb.IGI_IMP_IAC_EXCEP_INER_PKG.';
13:
14: --===========================FND_LOG.END=====================================
15:
16: l_message varchar2(1000);
17: l_concat_asset_key VARCHAR2(200);
18: l_period_name VARCHAR2(15);