1: PACKAGE BODY IGI_IGI_ITR_LINES_PKG as
2: -- $Header: igiitrbb.pls 120.5.12000000.1 2007/09/12 10:30:26 mbremkum ship $
3: --
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
1: PACKAGE BODY IGI_IGI_ITR_LINES_PKG as
2: -- $Header: igiitrbb.pls 120.5.12000000.1 2007/09/12 10:30:26 mbremkum ship $
3: --
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number := FND_LOG.LEVEL_ERROR;
2: -- $Header: igiitrbb.pls 120.5.12000000.1 2007/09/12 10:30:26 mbremkum ship $
3: --
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number := FND_LOG.LEVEL_ERROR;
10: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
3: --
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number := FND_LOG.LEVEL_ERROR;
10: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
11:
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number := FND_LOG.LEVEL_ERROR;
10: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
11:
12:
5: l_state_level number := FND_LOG.LEVEL_STATEMENT;
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number := FND_LOG.LEVEL_ERROR;
10: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
11:
12:
13: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;
7: l_event_level number := FND_LOG.LEVEL_EVENT;
8: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
9: l_error_level number := FND_LOG.LEVEL_ERROR;
10: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
11:
12:
13: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
14: X_It_Header_Id NUMBER,
122: CLOSE C;
123: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
124:
125: IF ( l_excep_level >= l_debug_level) THEN
126: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrbb.IGI_IGI_ITR_LINES_PKG.lock_row.msg1', FALSE);
127: END IF;
128:
129: APP_EXCEPTION.Raise_Exception;
130: end if;
166: else
167: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
168:
169: IF ( l_excep_level >= l_debug_level) THEN
170: FND_LOG.MESSAGE(l_excep_level,'igi.plsql.igiitrbb.IGI_IGI_ITR_LINES_PKG.lock_row.msg2', FALSE);
171: END IF;
172:
173: APP_EXCEPTION.Raise_Exception;
174: end if;