eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_EXP_DU_TYPE_DETAILS_PKG dependencies on FND_LOG

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

1: PACKAGE BODY igi_exp_du_type_details_pkg AS
2: /* $Header: igiexptb.pls 120.5.12000000.1 2007/09/13 04:24:40 mbremkum 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_exp_du_type_details_pkg AS
2: /* $Header: igiexptb.pls 120.5.12000000.1 2007/09/13 04:24:40 mbremkum 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: igiexptb.pls 120.5.12000000.1 2007/09/13 04:24:40 mbremkum 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: l_rowid VARCHAR2(25);

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: l_rowid VARCHAR2(25);
14: old_references igi_exp_du_type_details_all%ROWTYPE;

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: l_rowid VARCHAR2(25);
14: old_references igi_exp_du_type_details_all%ROWTYPE;
15: new_references igi_exp_du_type_details_all%ROWTYPE;

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

51: FETCH cur_old_ref_values INTO old_references;
52: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: --bug 3199481 fnd logging changes: sdixit: start block
56: IF (l_error_level >= l_debug_level ) THEN
57: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.set_column_values',FALSE);
58: END IF;
59: --bug 3199481 fnd logging changes: sdixit: end block

Line 57: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.set_column_values',FALSE);

53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: --bug 3199481 fnd logging changes: sdixit: start block
56: IF (l_error_level >= l_debug_level ) THEN
57: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.set_column_values',FALSE);
58: END IF;
59: --bug 3199481 fnd logging changes: sdixit: end block
60:
61: app_exception.raise_exception;

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

55: --bug 3199481 fnd logging changes: sdixit: start block
56: IF (l_error_level >= l_debug_level ) THEN
57: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.set_column_values',FALSE);
58: END IF;
59: --bug 3199481 fnd logging changes: sdixit: end block
60:
61: app_exception.raise_exception;
62: RETURN;
63: END IF;

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

102: ELSIF NOT igi_exp_du_type_headers_pkg.get_pk_for_validation (
103: new_references.du_type_header_id
104: ) THEN
105: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
106: --bug 3199481 fnd logging changes: sdixit: start block
107: IF (l_error_level >= l_debug_level ) THEN
108: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.check_parent_existance',FALSE);
109: END IF;
110: --bug 3199481 fnd logging changes: sdixit: end block

Line 108: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.check_parent_existance',FALSE);

104: ) THEN
105: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
106: --bug 3199481 fnd logging changes: sdixit: start block
107: IF (l_error_level >= l_debug_level ) THEN
108: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.check_parent_existance',FALSE);
109: END IF;
110: --bug 3199481 fnd logging changes: sdixit: end block
111:
112: app_exception.raise_exception;

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

106: --bug 3199481 fnd logging changes: sdixit: start block
107: IF (l_error_level >= l_debug_level ) THEN
108: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.check_parent_existance',FALSE);
109: END IF;
110: --bug 3199481 fnd logging changes: sdixit: end block
111:
112: app_exception.raise_exception;
113: END IF;
114:

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

175: FETCH cur_rowid INTO lv_rowid;
176: IF (cur_rowid%FOUND) THEN
177: CLOSE cur_rowid;
178: fnd_message.set_name ('FND','FND-CANNOT DELETE MASTER');
179: --bug 3199481 fnd logging changes: sdixit: start block
180: IF (l_error_level >= l_debug_level ) THEN
181: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
182: END IF;
183: --bug 3199481 fnd logging changes: sdixit: end block

Line 181: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);

177: CLOSE cur_rowid;
178: fnd_message.set_name ('FND','FND-CANNOT DELETE MASTER');
179: --bug 3199481 fnd logging changes: sdixit: start block
180: IF (l_error_level >= l_debug_level ) THEN
181: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
182: END IF;
183: --bug 3199481 fnd logging changes: sdixit: end block
184:
185: app_exception.raise_exception;

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

179: --bug 3199481 fnd logging changes: sdixit: start block
180: IF (l_error_level >= l_debug_level ) THEN
181: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
182: END IF;
183: --bug 3199481 fnd logging changes: sdixit: end block
184:
185: app_exception.raise_exception;
186: RETURN;
187: END IF;

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

234: new_references.du_type_detail_id
235: )
236: ) THEN
237: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
238: --bug 3199481 fnd logging changes: sdixit: start block
239: IF (l_error_level >= l_debug_level ) THEN
240: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg1',FALSE);
241: END IF;
242: --bug 3199481 fnd logging changes: sdixit: end block

Line 240: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg1',FALSE);

236: ) THEN
237: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
238: --bug 3199481 fnd logging changes: sdixit: start block
239: IF (l_error_level >= l_debug_level ) THEN
240: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg1',FALSE);
241: END IF;
242: --bug 3199481 fnd logging changes: sdixit: end block
243:
244: app_exception.raise_exception;

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

238: --bug 3199481 fnd logging changes: sdixit: start block
239: IF (l_error_level >= l_debug_level ) THEN
240: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg1',FALSE);
241: END IF;
242: --bug 3199481 fnd logging changes: sdixit: end block
243:
244: app_exception.raise_exception;
245: END IF;
246: check_parent_existance;

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

253: new_references.du_type_detail_id
254: )
255: ) THEN
256: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
257: --bug 3199481 fnd logging changes: sdixit: start block
258: IF (l_error_level >= l_debug_level ) THEN
259: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg2',FALSE);
260: END IF;
261: --bug 3199481 fnd logging changes: sdixit: end block

Line 259: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg2',FALSE);

255: ) THEN
256: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
257: --bug 3199481 fnd logging changes: sdixit: start block
258: IF (l_error_level >= l_debug_level ) THEN
259: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg2',FALSE);
260: END IF;
261: --bug 3199481 fnd logging changes: sdixit: end block
262:
263: app_exception.raise_exception;

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

257: --bug 3199481 fnd logging changes: sdixit: start block
258: IF (l_error_level >= l_debug_level ) THEN
259: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg2',FALSE);
260: END IF;
261: --bug 3199481 fnd logging changes: sdixit: end block
262:
263: app_exception.raise_exception;
264: END IF;
265: END IF;

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

308: x_last_update_login := -1;
309: END IF;
310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: --bug 3199481 fnd logging changes: sdixit: start block
313: IF (l_error_level >= l_debug_level ) THEN
314: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.insert_row',FALSE);
315: END IF;
316: --bug 3199481 fnd logging changes: sdixit: end block

Line 314: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.insert_row',FALSE);

310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: --bug 3199481 fnd logging changes: sdixit: start block
313: IF (l_error_level >= l_debug_level ) THEN
314: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.insert_row',FALSE);
315: END IF;
316: --bug 3199481 fnd logging changes: sdixit: end block
317:
318: app_exception.raise_exception;

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

312: --bug 3199481 fnd logging changes: sdixit: start block
313: IF (l_error_level >= l_debug_level ) THEN
314: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.insert_row',FALSE);
315: END IF;
316: --bug 3199481 fnd logging changes: sdixit: end block
317:
318: app_exception.raise_exception;
319: END IF;
320:

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

401: OPEN c1;
402: FETCH c1 INTO tlinfo;
403: IF (c1%notfound) THEN
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: --bug 3199481 fnd logging changes: sdixit: start block
406: IF (l_error_level >= l_debug_level ) THEN
407: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
408: END IF;
409: --bug 3199481 fnd logging changes: sdixit: end block

Line 407: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);

403: IF (c1%notfound) THEN
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: --bug 3199481 fnd logging changes: sdixit: start block
406: IF (l_error_level >= l_debug_level ) THEN
407: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
408: END IF;
409: --bug 3199481 fnd logging changes: sdixit: end block
410:
411: CLOSE c1;

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

405: --bug 3199481 fnd logging changes: sdixit: start block
406: IF (l_error_level >= l_debug_level ) THEN
407: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
408: END IF;
409: --bug 3199481 fnd logging changes: sdixit: end block
410:
411: CLOSE c1;
412: app_exception.raise_exception;
413: RETURN;

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

421: ) THEN
422: NULL;
423: ELSE
424: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
425: --bug 3199481 fnd logging changes: sdixit: start block
426: IF (l_error_level >= l_debug_level ) THEN
427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
428: END IF;
429: --bug 3199481 fnd logging changes: sdixit: end block

Line 427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);

423: ELSE
424: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
425: --bug 3199481 fnd logging changes: sdixit: start block
426: IF (l_error_level >= l_debug_level ) THEN
427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
428: END IF;
429: --bug 3199481 fnd logging changes: sdixit: end block
430:
431: app_exception.raise_exception;

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

425: --bug 3199481 fnd logging changes: sdixit: start block
426: IF (l_error_level >= l_debug_level ) THEN
427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
428: END IF;
429: --bug 3199481 fnd logging changes: sdixit: end block
430:
431: app_exception.raise_exception;
432: END IF;
433:

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

472: x_last_update_login := -1;
473: END IF;
474: ELSE
475: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
476: --bug 3199481 fnd logging changes: sdixit: start block
477: IF (l_error_level >= l_debug_level ) THEN
478: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.update_row',FALSE);
479: END IF;
480: --bug 3199481 fnd logging changes: sdixit: end block

Line 478: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.update_row',FALSE);

474: ELSE
475: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
476: --bug 3199481 fnd logging changes: sdixit: start block
477: IF (l_error_level >= l_debug_level ) THEN
478: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.update_row',FALSE);
479: END IF;
480: --bug 3199481 fnd logging changes: sdixit: end block
481:
482: app_exception.raise_exception;

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

476: --bug 3199481 fnd logging changes: sdixit: start block
477: IF (l_error_level >= l_debug_level ) THEN
478: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.update_row',FALSE);
479: END IF;
480: --bug 3199481 fnd logging changes: sdixit: end block
481:
482: app_exception.raise_exception;
483: END IF;
484: