DBA Data[Home] [Help]

APPS.IGI_DOS_DESTINATION_USAGES_PKG dependencies on FND_LOG

Line 4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

1: PACKAGE BODY igi_dos_destination_usages_pkg AS
2: /* $Header: igidosnb.pls 120.5.12000000.2 2007/06/14 04:34:16 pshivara 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 ;

Line 6: l_state_level number := FND_LOG.LEVEL_STATEMENT ;

2: /* $Header: igidosnb.pls 120.5.12000000.2 2007/06/14 04:34:16 pshivara 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 ;

Line 7: l_proc_level number := FND_LOG.LEVEL_PROCEDURE ;

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 ;

Line 8: l_event_level number := FND_LOG.LEVEL_EVENT ;

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:

Line 9: l_excep_level number := FND_LOG.LEVEL_EXCEPTION ;

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: 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_dos_destination_usages%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_dos_destination_usages%ROWTYPE;
15: new_references igi_dos_destination_usages%ROWTYPE;

Line 62: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.set_column_values.Msg1',FALSE);

58: CLOSE cur_old_ref_values;
59: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
60: -- bug 3199481, start block
61: IF (l_unexp_level >= l_debug_level) THEN
62: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.set_column_values.Msg1',FALSE);
63: END IF;
64: -- bug 3199481, end block
65: app_exception.raise_exception;
66: RETURN;

Line 117: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.check_parent_existance.Msg1',FALSE);

113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: -- bug 3199481, start block
116: IF (l_unexp_level >= l_debug_level) THEN
117: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.check_parent_existance.Msg1',FALSE);
118: END IF;
119: -- bug 3199481, end block
120: app_exception.raise_exception;
121: END IF;

Line 154: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.get_fk_igi_dos_destinations.Msg1',FALSE);

150: CLOSE cur_rowid;
151: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
152: -- bug 3199481, start block
153: IF (l_unexp_level >= l_debug_level) THEN
154: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.get_fk_igi_dos_destinations.Msg1',FALSE);
155: END IF;
156: -- bug 3199481, end block
157: app_exception.raise_exception;
158: RETURN;

Line 222: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.before_dml.Msg1',FALSE);

218: ) THEN
219: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
220: -- bug 3199481, start block
221: IF (l_unexp_level >= l_debug_level) THEN
222: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.before_dml.Msg1',FALSE);
223: END IF;
224: -- bug 3199481, end block
225: app_exception.raise_exception;
226: END IF; */

Line 240: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.before_dml.Msg2',FALSE);

236: ) THEN
237: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
238: -- bug 3199481, start block
239: IF (l_unexp_level >= l_debug_level) THEN
240: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.before_dml.Msg2',FALSE);
241: END IF;
242: -- bug 3199481, end block
243: app_exception.raise_exception;
244: END IF; */

Line 300: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.insert_row.Msg1',FALSE);

296: ELSE
297: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
298: -- bug 3199481, start block
299: IF (l_unexp_level >= l_debug_level) THEN
300: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.insert_row.Msg1',FALSE);
301: END IF;
302: -- bug 3199481, end block
303: app_exception.raise_exception;
304: END IF;

Line 414: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.lock_row.Msg1',FALSE);

410: IF (c1%notfound) THEN
411: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
412: -- bug 3199481, start block
413: IF (l_unexp_level >= l_debug_level) THEN
414: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.lock_row.Msg1',FALSE);
415: END IF;
416: -- bug 3199481, end block
417: CLOSE c1;
418: app_exception.raise_exception;

Line 439: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.lock_row.Msg2',FALSE);

435: ELSE
436: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
437: -- bug 3199481, start block
438: IF (l_unexp_level >= l_debug_level) THEN
439: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.lock_row.Msg2',FALSE);
440: END IF;
441: -- bug 3199481, end block
442: app_exception.raise_exception;
443: END IF;

Line 494: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.update_row.Msg1',FALSE);

490: ELSE
491: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
492: -- bug 3199481, start block
493: IF (l_unexp_level >= l_debug_level) THEN
494: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destination_usages_pkg.update_row.Msg1',FALSE);
495: END IF;
496: -- bug 3199481, end block
497: app_exception.raise_exception;
498: END IF;