DBA Data[Home] [Help]

APPS.IGI_DUN_CUST_LET_SET_CUR_PKG dependencies on FND_LOG

Line 4: --following variables added for bug 3199481: fnd logging changes: sdixit

1: PACKAGE BODY IGI_DUN_CUST_LET_SET_CUR_PKG as
2: /* $Header: igidunkb.pls 115.6 2003/11/27 13:09:43 sdixit ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY IGI_DUN_CUST_LET_SET_CUR_PKG as
2: /* $Header: igidunkb.pls 115.6 2003/11/27 13:09:43 sdixit ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 6: l_state_level number := FND_LOG.LEVEL_STATEMENT;

2: /* $Header: igidunkb.pls 115.6 2003/11/27 13:09:43 sdixit ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE;

3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 8: l_event_level number := FND_LOG.LEVEL_EVENT;

4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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:

Line 9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;

5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 10: l_error_level number := FND_LOG.LEVEL_ERROR;

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: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
14: X_Customer_Profile_Id NUMBER,

Line 11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;

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: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
14: X_Customer_Profile_Id NUMBER,
15: X_Currency_Code VARCHAR2,

Line 73: --bug 3199481 fnd logging changes: sdixit: start block

69: FETCH C INTO Recinfo;
70: if (C%NOTFOUND) then
71: CLOSE C;
72: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
73: --bug 3199481 fnd logging changes: sdixit: start block
74: IF (l_excep_level >= l_debug_level ) THEN
75: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);
76: END IF;
77: --bug 3199481 fnd logging changes: sdixit: end block

Line 75: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);

71: CLOSE C;
72: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
73: --bug 3199481 fnd logging changes: sdixit: start block
74: IF (l_excep_level >= l_debug_level ) THEN
75: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);
76: END IF;
77: --bug 3199481 fnd logging changes: sdixit: end block
78: APP_EXCEPTION.Raise_Exception;
79: end if;

Line 77: --bug 3199481 fnd logging changes: sdixit: end block

73: --bug 3199481 fnd logging changes: sdixit: start block
74: IF (l_excep_level >= l_debug_level ) THEN
75: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);
76: END IF;
77: --bug 3199481 fnd logging changes: sdixit: end block
78: APP_EXCEPTION.Raise_Exception;
79: end if;
80: CLOSE C;
81: if (

Line 89: --bug 3199481 fnd logging changes: sdixit: start block

85: ) then
86: return;
87: else
88: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
89: --bug 3199481 fnd logging changes: sdixit: start block
90: IF (l_excep_level >= l_debug_level ) THEN
91: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);
92: END IF;
93: --bug 3199481 fnd logging changes: sdixit: end block

Line 91: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);

87: else
88: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
89: --bug 3199481 fnd logging changes: sdixit: start block
90: IF (l_excep_level >= l_debug_level ) THEN
91: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);
92: END IF;
93: --bug 3199481 fnd logging changes: sdixit: end block
94: APP_EXCEPTION.Raise_Exception;
95: end if;

Line 93: --bug 3199481 fnd logging changes: sdixit: end block

89: --bug 3199481 fnd logging changes: sdixit: start block
90: IF (l_excep_level >= l_debug_level ) THEN
91: FND_LOG.MESSAGE (l_excep_level , 'igi.plsql.igidunkb.IGI_DUN_CUST_LET_SET_CUR_PKG.Lock_Row',FALSE);
92: END IF;
93: --bug 3199481 fnd logging changes: sdixit: end block
94: APP_EXCEPTION.Raise_Exception;
95: end if;
96: END Lock_Row;
97: