2: -- $Header: igibudgb.pls 120.5 2007/09/12 10:34:12 pshivara ship $
3:
4: --Bug 3199481
5:
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7:
8: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
4: --Bug 3199481
5:
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7:
8: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
12: l_error_level number := FND_LOG.LEVEL_ERROR ;
5:
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7:
8: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
12: l_error_level number := FND_LOG.LEVEL_ERROR ;
13: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
6: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
7:
8: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
12: l_error_level number := FND_LOG.LEVEL_ERROR ;
13: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
14:
7:
8: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
12: l_error_level number := FND_LOG.LEVEL_ERROR ;
13: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
14:
15: --Bug 3199481
8: l_state_level number := FND_LOG.LEVEL_STATEMENT ;
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
12: l_error_level number := FND_LOG.LEVEL_ERROR ;
13: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
14:
15: --Bug 3199481
16:
9: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;
10: l_event_level number := FND_LOG.LEVEL_EVENT ;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;
12: l_error_level number := FND_LOG.LEVEL_ERROR ;
13: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
14:
15: --Bug 3199481
16:
17: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
115: CLOSE C;
116: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
117: --Bug 3199481 (start)
118: If (l_unexp_level >= l_debug_level) then
119: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journal_headers_pkg.lock_row.Msg1',FALSE);
120: End if;
121: --Bug 3199481 (End)
122: APP_EXCEPTION.Raise_Exception;
123: end if;
147: else
148: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
149: --Bug 3199481 (start)
150: If (l_unexp_level >= l_debug_level) then
151: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journal_headers_pkg.lock_row.Msg2',FALSE);
152: End if;
153: --Bug 3199481 (End)
154: APP_EXCEPTION.Raise_Exception;
155: end if;