1: PACKAGE BODY IGI_RPI_LINE_DETAILS_PKG as
2: --- $Header: igirldeb.pls 120.5.12000000.1 2007/08/31 05:52:59 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_RPI_LINE_DETAILS_PKG as
2: --- $Header: igirldeb.pls 120.5.12000000.1 2007/08/31 05:52:59 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: igirldeb.pls 120.5.12000000.1 2007/08/31 05:52:59 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: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
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: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
13: X_Standing_Charge_Id NUMBER,
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: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
13: X_Standing_Charge_Id NUMBER,
14: X_Line_Item_Id IN OUT NOCOPY NUMBER,
157: CLOSE C;
158: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
159: --Bug 3199481 (start)
160: If (l_unexp_level >= l_debug_level) then
161: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_line_details_pkg.lock_row.Msg1',FALSE);
162: End if;
163: --Bug 3199481 (end)
164: APP_EXCEPTION.Raise_Exception;
165: end if;
216: else
217: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
218: --Bug 3199481 (start)
219: If (l_unexp_level >= l_debug_level) then
220: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_line_details_pkg.lock_row.Msg2',FALSE);
221: End if;
222: --Bug 3199481 (end)
223: APP_EXCEPTION.Raise_Exception;
224: end if;