1: PACKAGE BODY IGI_SAP_INVOICE_CLERK_PKG as
2: -- $Header: igisiadb.pls 120.4.12000000.1 2007/09/12 11:47:32 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
2: -- $Header: igisiadb.pls 120.4.12000000.1 2007/09/12 11:47:32 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
5:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13:
6: l_state_level number:=FND_LOG.LEVEL_STATEMENT;
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13:
14: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
7: l_proc_level number:=FND_LOG.LEVEL_PROCEDURE;
8: l_event_level number:=FND_LOG.LEVEL_EVENT;
9: l_excep_level number:=FND_LOG.LEVEL_EXCEPTION;
10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13:
14: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
15: X_Group_Id NUMBER,
73: CLOSE C;
74: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
75: --Bug 3199481 (start)
76: If (l_unexp_level >= l_debug_level) then
77: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_sap_invoice_clerk_pkg.lock_row.Msg1',FALSE);
78: End if;
79: --Bug 3199481 (end)
80: APP_EXCEPTION.Raise_Exception;
81: end if;
92: else
93: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
94: --Bug 3199481 (start)
95: If (l_unexp_level >= l_debug_level) then
96: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_sap_invoice_clerk_pkg.lock_row.Msg2',FALSE);
97: End if;
98: --Bug 3199481 (end)
99: APP_EXCEPTION.Raise_Exception;
100: end if;