7: g_debug_flag VARCHAR2(1) := 'N' ;
8:
9: -- Variables for ATG Central Logging
10:
11: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: l_state_level number := FND_LOG.LEVEL_STATEMENT;
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
8:
9: -- Variables for ATG Central Logging
10:
11: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: l_state_level number := FND_LOG.LEVEL_STATEMENT;
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: l_error_level number := FND_LOG.LEVEL_ERROR;
9: -- Variables for ATG Central Logging
10:
11: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: l_state_level number := FND_LOG.LEVEL_STATEMENT;
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: l_error_level number := FND_LOG.LEVEL_ERROR;
17: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
10:
11: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: l_state_level number := FND_LOG.LEVEL_STATEMENT;
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: l_error_level number := FND_LOG.LEVEL_ERROR;
17: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: l_path VARCHAR2(255) := 'IGC.PLSQL.IGCSYSPB.IGC_CC_SYSTEM_OPTIONS_PKG';
11: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
12: l_state_level number := FND_LOG.LEVEL_STATEMENT;
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: l_error_level number := FND_LOG.LEVEL_ERROR;
17: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: l_path VARCHAR2(255) := 'IGC.PLSQL.IGCSYSPB.IGC_CC_SYSTEM_OPTIONS_PKG';
19:
12: l_state_level number := FND_LOG.LEVEL_STATEMENT;
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: l_error_level number := FND_LOG.LEVEL_ERROR;
17: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: l_path VARCHAR2(255) := 'IGC.PLSQL.IGCSYSPB.IGC_CC_SYSTEM_OPTIONS_PKG';
19:
20: /*=======================================================================+
13: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
14: l_event_level number := FND_LOG.LEVEL_EVENT;
15: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
16: l_error_level number := FND_LOG.LEVEL_ERROR;
17: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
18: l_path VARCHAR2(255) := 'IGC.PLSQL.IGCSYSPB.IGC_CC_SYSTEM_OPTIONS_PKG';
19:
20: /*=======================================================================+
21: | PROCEDURE Insert_Row |
685: WHEN e_row_locked
686: THEN
687: fnd_message.set_name('IGC','IGC_CC_NUM_LOCK');
688: fnd_msg_pub.add;
689: IF( FND_LOG.TEST(FND_LOG.LEVEL_ERROR,
690: 'IGC.PLSQL.Igc_Cc_Numbers_Pkg.Create_Auto_CC_Num.Lock1'))
691: THEN
692: if (l_error_level >= l_debug_level) then
693: FND_LOG.MESSAGE(l_error_level,
689: IF( FND_LOG.TEST(FND_LOG.LEVEL_ERROR,
690: 'IGC.PLSQL.Igc_Cc_Numbers_Pkg.Create_Auto_CC_Num.Lock1'))
691: THEN
692: if (l_error_level >= l_debug_level) then
693: FND_LOG.MESSAGE(l_error_level,
694: 'IGC.PLSQL.Igc_Cc_Numbers_Pkg.Create_Auto_CC_Num.Lock1'
695: , FALSE);
696: end if;
697: END IF;