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_DOS_SOURCE_USAGES_PKG dependencies on IGI_DOS_SOURCE_USAGES

Line 1: PACKAGE BODY igi_dos_source_usages_pkg AS

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:

Line 14: old_references igi_dos_source_usages%ROWTYPE;

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;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igi_dos_source_usages%ROWTYPE;

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;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 ,

Line 48: FROM igi_dos_source_usages

44: */
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM igi_dos_source_usages
49: WHERE rowid = x_rowid;
50:
51: BEGIN
52:

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 143: FROM igi_dos_source_usages

139: || (reverse chronological order - newest change first)
140: */
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM igi_dos_source_usages
144: WHERE ((source_id = x_source_id));
145:
146: lv_rowid cur_rowid%RowType;
147:

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 285: FROM igi_dos_source_usages

281: || (reverse chronological order - newest change first)
282: */
283: CURSOR c IS
284: SELECT rowid
285: FROM igi_dos_source_usages
286: WHERE 1=1 ;
287:
288: x_last_update_date DATE;
289: x_last_updated_by NUMBER;

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 337: INSERT INTO igi_dos_source_usages (

333: x_last_updated_by => x_last_updated_by,
334: x_last_update_login => x_last_update_login
335: );
336:
337: INSERT INTO igi_dos_source_usages (
338: source_id,
339: segment_name,
340: segment_name_dsp,
341: sob_id,

Line 416: FROM igi_dos_source_usages

412: default_type,
413: default_value,
414: updatable,
415: stored_name
416: FROM igi_dos_source_usages
417: WHERE rowid = x_rowid
418: FOR UPDATE NOWAIT;
419:
420: tlinfo c1%ROWTYPE;

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;

Line 538: UPDATE igi_dos_source_usages

534: x_last_updated_by => x_last_updated_by,
535: x_last_update_login => x_last_update_login
536: );
537:
538: UPDATE igi_dos_source_usages
539: SET
540: source_id = new_references.source_id,
541: segment_name = new_references.segment_name,
542: segment_name_dsp = new_references.segment_name_dsp,

Line 586: FROM igi_dos_source_usages

582: || (reverse chronological order - newest change first)
583: */
584: CURSOR c1 IS
585: SELECT rowid
586: FROM igi_dos_source_usages
587: WHERE 1=1 ;
588:
589: BEGIN
590:

Line 651: DELETE FROM igi_dos_source_usages

647: p_action => 'DELETE',
648: x_rowid => x_rowid
649: );
650:
651: DELETE FROM igi_dos_source_usages
652: WHERE rowid = x_rowid;
653:
654: IF (SQL%NOTFOUND) THEN
655: RAISE NO_DATA_FOUND;

Line 661: END igi_dos_source_usages_pkg;

657:
658: END delete_row;
659:
660:
661: END igi_dos_source_usages_pkg;