1: PACKAGE BODY IGI_IGI_EER_SETUP_PKG as
2: -- $Header: igihglab.pls 120.4.12000000.1 2007/09/12 10:11:39 mbremkum ship $
3: --following variables added for bug 3199481: fnd logging changes: sdixit
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;
1: PACKAGE BODY IGI_IGI_EER_SETUP_PKG as
2: -- $Header: igihglab.pls 120.4.12000000.1 2007/09/12 10:11:39 mbremkum ship $
3: --following variables added for bug 3199481: fnd logging changes: sdixit
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_EER_SETUP_PKG as
2: -- $Header: igihglab.pls 120.4.12000000.1 2007/09/12 10:11:39 mbremkum ship $
3: --following variables added for bug 3199481: fnd logging changes: sdixit
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: igihglab.pls 120.4.12000000.1 2007/09/12 10:11:39 mbremkum ship $
3: --following variables added for bug 3199481: fnd logging changes: sdixit
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: --following variables added for bug 3199481: fnd logging changes: sdixit
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_Gl_Set_Of_Books_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_Gl_Set_Of_Books_Id NUMBER,
14: X_Level_1 NUMBER,
84: FETCH C INTO Recinfo;
85: if (C%NOTFOUND) then
86: CLOSE C;
87: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
88: --bug 3199481 fnd logging changes: sdixit: start block
89: IF (l_excep_level >= l_debug_level ) THEN
90: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igihglab.IGI_IGI_ERR_SETUP_PKG.Lock_Row',FALSE);
91: END IF;
92: --bug 3199481 fnd logging changes: sdixit: end block
86: CLOSE C;
87: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
88: --bug 3199481 fnd logging changes: sdixit: start block
89: IF (l_excep_level >= l_debug_level ) THEN
90: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igihglab.IGI_IGI_ERR_SETUP_PKG.Lock_Row',FALSE);
91: END IF;
92: --bug 3199481 fnd logging changes: sdixit: end block
93: APP_EXCEPTION.Raise_Exception;
94: end if;
88: --bug 3199481 fnd logging changes: sdixit: start block
89: IF (l_excep_level >= l_debug_level ) THEN
90: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igihglab.IGI_IGI_ERR_SETUP_PKG.Lock_Row',FALSE);
91: END IF;
92: --bug 3199481 fnd logging changes: sdixit: end block
93: APP_EXCEPTION.Raise_Exception;
94: end if;
95: CLOSE C;
96: if (
108: ) then
109: return;
110: else
111: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
112: --bug 3199481 fnd logging changes: sdixit: start block
113: IF (l_excep_level >= l_debug_level ) THEN
114: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igihglab.IGI_IGI_ERR_SETUP_PKG.Lock_Row',FALSE);
115: END IF;
116: --bug 3199481 fnd logging changes: sdixit: end block
110: else
111: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
112: --bug 3199481 fnd logging changes: sdixit: start block
113: IF (l_excep_level >= l_debug_level ) THEN
114: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igihglab.IGI_IGI_ERR_SETUP_PKG.Lock_Row',FALSE);
115: END IF;
116: --bug 3199481 fnd logging changes: sdixit: end block
117: APP_EXCEPTION.Raise_Exception;
118: end if;
112: --bug 3199481 fnd logging changes: sdixit: start block
113: IF (l_excep_level >= l_debug_level ) THEN
114: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igihglab.IGI_IGI_ERR_SETUP_PKG.Lock_Row',FALSE);
115: END IF;
116: --bug 3199481 fnd logging changes: sdixit: end block
117: APP_EXCEPTION.Raise_Exception;
118: end if;
119: END Lock_Row;
120: