2: -- $Header: igibuddb.pls 120.4 2005/10/30 05:51:39 appldev 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,
110: CLOSE C;
111: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
112: --Bug 3199481 (start)
113: If (l_unexp_level >= l_debug_level) then
114: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journals_periods_pkg.lock_row.Msg1',FALSE);
115: End if;
116: --Bug 3199481 (End)
117: APP_EXCEPTION.Raise_Exception;
118: end if;
141: else
142: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
143: --Bug 3199481 (start)
144: If (l_unexp_level >= l_debug_level) then
145: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_bud_journals_periods_pkg.lock_row.Msg2',FALSE);
146: End if;
147: --Bug 3199481 (End)
148: APP_EXCEPTION.Raise_Exception;
149: end if;