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_HEADERS_PKG dependencies on FND_LOG

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

1: PACKAGE BODY igi_exp_du_type_headers_pkg AS
2: /* $Header: igiexpsb.pls 120.5.12000000.1 2007/09/13 04:24:33 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_headers_pkg AS
2: /* $Header: igiexpsb.pls 120.5.12000000.1 2007/09/13 04:24:33 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: igiexpsb.pls 120.5.12000000.1 2007/09/13 04:24:33 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_headers_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_headers_all%ROWTYPE;
15: new_references igi_exp_du_type_headers_all%ROWTYPE;

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

56: FETCH cur_old_ref_values INTO old_references;
57: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
58: CLOSE cur_old_ref_values;
59: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
60: --bug 3199481 fnd logging changes: sdixit: start block
61: IF (l_error_level >= l_debug_level ) THEN
62: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.set_column_values',FALSE);
63: END IF;
64: --bug 3199481 fnd logging changes: sdixit: end block

Line 62: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.set_column_values',FALSE);

58: CLOSE cur_old_ref_values;
59: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
60: --bug 3199481 fnd logging changes: sdixit: start block
61: IF (l_error_level >= l_debug_level ) THEN
62: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.set_column_values',FALSE);
63: END IF;
64: --bug 3199481 fnd logging changes: sdixit: end block
65:
66: app_exception.raise_exception;

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

60: --bug 3199481 fnd logging changes: sdixit: start block
61: IF (l_error_level >= l_debug_level ) THEN
62: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.set_column_values',FALSE);
63: END IF;
64: --bug 3199481 fnd logging changes: sdixit: end block
65:
66: app_exception.raise_exception;
67: RETURN;
68: END IF;

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

207: new_references.du_type_header_id
208: )
209: ) THEN
210: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
211: --bug 3199481 fnd logging changes: sdixit: start block
212: IF (l_error_level >= l_debug_level ) THEN
213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg1',FALSE);
214: END IF;
215: --bug 3199481 fnd logging changes: sdixit: end block

Line 213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg1',FALSE);

209: ) THEN
210: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
211: --bug 3199481 fnd logging changes: sdixit: start block
212: IF (l_error_level >= l_debug_level ) THEN
213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg1',FALSE);
214: END IF;
215: --bug 3199481 fnd logging changes: sdixit: end block
216:
217: app_exception.raise_exception;

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

211: --bug 3199481 fnd logging changes: sdixit: start block
212: IF (l_error_level >= l_debug_level ) THEN
213: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg1',FALSE);
214: END IF;
215: --bug 3199481 fnd logging changes: sdixit: end block
216:
217: app_exception.raise_exception;
218: END IF;
219: ELSIF (p_action = 'DELETE') THEN

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

225: new_references.du_type_header_id
226: )
227: ) THEN
228: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
229: --bug 3199481 fnd logging changes: sdixit: start block
230: IF (l_error_level >= l_debug_level ) THEN
231: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg2',FALSE);
232: END IF;
233: --bug 3199481 fnd logging changes: sdixit: end block

Line 231: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg2',FALSE);

227: ) THEN
228: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
229: --bug 3199481 fnd logging changes: sdixit: start block
230: IF (l_error_level >= l_debug_level ) THEN
231: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg2',FALSE);
232: END IF;
233: --bug 3199481 fnd logging changes: sdixit: end block
234:
235: app_exception.raise_exception;

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

229: --bug 3199481 fnd logging changes: sdixit: start block
230: IF (l_error_level >= l_debug_level ) THEN
231: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.before_dml.msg2',FALSE);
232: END IF;
233: --bug 3199481 fnd logging changes: sdixit: end block
234:
235: app_exception.raise_exception;
236: END IF;
237: ELSIF (p_action = 'VALIDATE_DELETE') THEN

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

287: x_last_update_login := -1;
288: END IF;
289: ELSE
290: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
291: --bug 3199481 fnd logging changes: sdixit: start block
292: IF (l_error_level >= l_debug_level ) THEN
293: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.insert_row',FALSE);
294: END IF;
295: --bug 3199481 fnd logging changes: sdixit: end block

Line 293: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.insert_row',FALSE);

289: ELSE
290: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
291: --bug 3199481 fnd logging changes: sdixit: start block
292: IF (l_error_level >= l_debug_level ) THEN
293: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.insert_row',FALSE);
294: END IF;
295: --bug 3199481 fnd logging changes: sdixit: end block
296:
297: app_exception.raise_exception;

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

291: --bug 3199481 fnd logging changes: sdixit: start block
292: IF (l_error_level >= l_debug_level ) THEN
293: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.insert_row',FALSE);
294: END IF;
295: --bug 3199481 fnd logging changes: sdixit: end block
296:
297: app_exception.raise_exception;
298: END IF;
299:

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

405: OPEN c1;
406: FETCH c1 INTO tlinfo;
407: IF (c1%notfound) THEN
408: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
409: --bug 3199481 fnd logging changes: sdixit: start block
410: IF (l_error_level >= l_debug_level ) THEN
411: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);
412: END IF;
413: --bug 3199481 fnd logging changes: sdixit: end block

Line 411: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);

407: IF (c1%notfound) THEN
408: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
409: --bug 3199481 fnd logging changes: sdixit: start block
410: IF (l_error_level >= l_debug_level ) THEN
411: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);
412: END IF;
413: --bug 3199481 fnd logging changes: sdixit: end block
414:
415: CLOSE c1;

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

409: --bug 3199481 fnd logging changes: sdixit: start block
410: IF (l_error_level >= l_debug_level ) THEN
411: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);
412: END IF;
413: --bug 3199481 fnd logging changes: sdixit: end block
414:
415: CLOSE c1;
416: app_exception.raise_exception;
417: RETURN;

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

430: ) THEN
431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: --bug 3199481 fnd logging changes: sdixit: start block
435: IF (l_error_level >= l_debug_level ) THEN
436: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);
437: END IF;
438: --bug 3199481 fnd logging changes: sdixit: end block

Line 436: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);

432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: --bug 3199481 fnd logging changes: sdixit: start block
435: IF (l_error_level >= l_debug_level ) THEN
436: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);
437: END IF;
438: --bug 3199481 fnd logging changes: sdixit: end block
439:
440: app_exception.raise_exception;

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

434: --bug 3199481 fnd logging changes: sdixit: start block
435: IF (l_error_level >= l_debug_level ) THEN
436: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.lock_row',FALSE);
437: END IF;
438: --bug 3199481 fnd logging changes: sdixit: end block
439:
440: app_exception.raise_exception;
441: END IF;
442:

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

486: x_last_update_login := -1;
487: END IF;
488: ELSE
489: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
490: --bug 3199481 fnd logging changes: sdixit: start block
491: IF (l_error_level >= l_debug_level ) THEN
492: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.update_row',FALSE);
493: END IF;
494: --bug 3199481 fnd logging changes: sdixit: end block

Line 492: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.update_row',FALSE);

488: ELSE
489: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
490: --bug 3199481 fnd logging changes: sdixit: start block
491: IF (l_error_level >= l_debug_level ) THEN
492: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.update_row',FALSE);
493: END IF;
494: --bug 3199481 fnd logging changes: sdixit: end block
495:
496: app_exception.raise_exception;

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

490: --bug 3199481 fnd logging changes: sdixit: start block
491: IF (l_error_level >= l_debug_level ) THEN
492: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpsb.IGI_EXP_DU_TYPE_HEADERS_PKG.update_row',FALSE);
493: END IF;
494: --bug 3199481 fnd logging changes: sdixit: end block
495:
496: app_exception.raise_exception;
497: END IF;
498: