DBA Data[Home] [Help]

APPS.IGI_DOS_SOURCE_USAGES_PKG dependencies on FND_LOG

Line 4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

1: PACKAGE BODY igi_dos_source_usages_pkg AS
2: /* $Header: igidospb.pls 120.5.12000000.2 2007/06/14 05:01:41 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: igidospb.pls 120.5.12000000.2 2007/06/14 05:01:41 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_source_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_source_usages%ROWTYPE;
15: new_references igi_dos_source_usages%ROWTYPE;

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

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

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

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

Line 157: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.get_fk_igi_dos_sources.Msg1',FALSE);

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

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

225: ) THEN
226: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
227: -- bug 3199481, start block
228: IF (l_unexp_level >= l_debug_level) THEN
229: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.before_dml.Msg1',FALSE);
230: END IF;
231: -- bug 3199481, end block
232: app_exception.raise_exception;
233: END IF; */

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

245: ) THEN
246: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
247: -- bug 3199481, start block
248: IF (l_unexp_level >= l_debug_level) THEN
249: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.before_dml.Msg2',FALSE);
250: END IF;
251: -- bug 3199481, end block
252: app_exception.raise_exception;
253: END IF; */

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

307: ELSE
308: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
309: -- bug 3199481, start block
310: IF (l_unexp_level >= l_debug_level) THEN
311: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.insert_row.Msg1',FALSE);
312: END IF;
313: -- bug 3199481, end block
314: app_exception.raise_exception;
315: END IF;

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

426: IF (c1%notfound) THEN
427: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
428: -- bug 3199481, start block
429: IF (l_unexp_level >= l_debug_level) THEN
430: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.lock_row.Msg1',FALSE);
431: END IF;
432: -- bug 3199481, end block
433: CLOSE c1;
434: app_exception.raise_exception;

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

452: ELSE
453: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
454: -- bug 3199481, start block
455: IF (l_unexp_level >= l_debug_level) THEN
456: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.lock_row.Msg2',FALSE);
457: END IF;
458: -- bug 3199481, end block
459: app_exception.raise_exception;
460: END IF;

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

508: ELSE
509: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
510: -- bug 3199481, start block
511: IF (l_unexp_level >= l_debug_level) THEN
512: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_source_usages_pkg.update_row.Msg1',FALSE);
513: END IF;
514: -- bug 3199481, end block
515: app_exception.raise_exception;
516: END IF;