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_SOURCES_PKG dependencies on IGI_DOS_SOURCES

Line 1: PACKAGE BODY igi_dos_sources_pkg AS

1: PACKAGE BODY igi_dos_sources_pkg AS
2: /* $Header: igidosqb.pls 120.5.12000000.2 2007/06/14 05:42:15 pshivara ship $ */
3:
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
5:

Line 14: old_references igi_dos_sources%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_sources%ROWTYPE;
15: new_references igi_dos_sources%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igi_dos_sources%ROWTYPE;

11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_dos_sources%ROWTYPE;
15: new_references igi_dos_sources%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2 ,

Line 112: FROM igi_dos_sources

108: */
109:
110: CURSOR cur_old_ref_values IS
111: SELECT *
112: FROM igi_dos_sources
113: WHERE rowid = x_rowid;
114:
115: BEGIN
116:

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

124: CLOSE cur_old_ref_values;
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: -- bug 3199481, start block
127: IF (l_unexp_level >= l_debug_level) THEN
128: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.set_column_values.Msg1',FALSE);
129: END IF;
130: -- bug 3199481, end block
131: app_exception.raise_exception;
132: RETURN;

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

244: ) THEN
245: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
246: -- bug 3199481, start block
247: IF (l_unexp_level >= l_debug_level) THEN
248: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.check_parent_existance.Msg1',FALSE);
249: END IF;
250: -- bug 3199481, end block
251: app_exception.raise_exception;
252: END IF;

Line 269: igi_dos_destinations_pkg.get_fk_igi_dos_sources (

265: || (reverse chronological order - newest change first)
266: */
267: BEGIN
268:
269: igi_dos_destinations_pkg.get_fk_igi_dos_sources (
270: old_references.source_id
271: );
272:
273:

Line 274: igi_dos_source_usages_pkg.get_fk_igi_dos_sources (

270: old_references.source_id
271: );
272:
273:
274: igi_dos_source_usages_pkg.get_fk_igi_dos_sources (
275: old_references.source_id
276: );
277:
278: END check_child_existance;

Line 295: FROM igi_dos_sources

291: || (reverse chronological order - newest change first)
292: */
293: CURSOR cur_rowid IS
294: SELECT rowid
295: FROM igi_dos_sources
296: WHERE source_id = x_source_id
297: FOR UPDATE NOWAIT;
298:
299: lv_rowid cur_rowid%RowType;

Line 330: FROM igi_dos_sources

326: || (reverse chronological order - newest change first)
327: */
328: CURSOR cur_rowid IS
329: SELECT rowid
330: FROM igi_dos_sources
331: WHERE ((dossier_id = x_dossier_id));
332:
333: lv_rowid cur_rowid%RowType;
334:

Line 344: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.get_fk_igi_dos_doc_types.Msg1',FALSE);

340: CLOSE cur_rowid;
341: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
342: -- bug 3199481, start block
343: IF (l_unexp_level >= l_debug_level) THEN
344: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.get_fk_igi_dos_doc_types.Msg1',FALSE);
345: END IF;
346: -- bug 3199481, end block
347: app_exception.raise_exception;
348: RETURN;

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

539: ) THEN
540: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
541: -- bug 3199481, start block
542: IF (l_unexp_level >= l_debug_level) THEN
543: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.before_dml.Msg1',FALSE);
544: END IF;
545: -- bug 3199481, end block
546: app_exception.raise_exception;
547: END IF;

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

560: ) THEN
561: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
562: -- bug 3199481, start block
563: IF (l_unexp_level >= l_debug_level) THEN
564: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.before_dml.Msg1',FALSE);
565: END IF;
566: -- bug 3199481, end block
567: app_exception.raise_exception;
568: END IF;

Line 664: FROM igi_dos_sources

660: || (reverse chronological order - newest change first)
661: */
662: CURSOR c IS
663: SELECT rowid
664: FROM igi_dos_sources
665: WHERE source_id = x_source_id;
666:
667: x_last_update_date DATE;
668: x_last_updated_by NUMBER;

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

686: ELSE
687: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
688: -- bug 3199481, start block
689: IF (l_unexp_level >= l_debug_level) THEN
690: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.insert_row.Msg1',FALSE);
691: END IF;
692: -- bug 3199481, end block
693: app_exception.raise_exception;
694: END IF;

Line 696: SELECT igi_dos_sources_s.NEXTVAL

692: -- bug 3199481, end block
693: app_exception.raise_exception;
694: END IF;
695:
696: SELECT igi_dos_sources_s.NEXTVAL
697: INTO x_source_id
698: FROM dual;
699:
700: before_dml(

Line 784: INSERT INTO igi_dos_sources (

780: x_last_updated_by => x_last_updated_by,
781: x_last_update_login => x_last_update_login
782: );
783:
784: INSERT INTO igi_dos_sources (
785: dossier_id,
786: source_id,
787: sob_id,
788: coa_id,

Line 1118: FROM igi_dos_sources

1114: segments_low_ccid_desc,
1115: segments_high_ccid_desc,
1116: budget_version_id,
1117: period_name
1118: FROM igi_dos_sources
1119: WHERE rowid = x_rowid
1120: FOR UPDATE NOWAIT;
1121:
1122: tlinfo c1%ROWTYPE;

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

1128: IF (c1%notfound) THEN
1129: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1130: -- bug 3199481, start block
1131: IF (l_unexp_level >= l_debug_level) THEN
1132: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.lock_row.Msg1',FALSE);
1133: END IF;
1134: -- bug 3199481, end block
1135: CLOSE c1;
1136: app_exception.raise_exception;

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

1217: ELSE
1218: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1219: -- bug 3199481, start block
1220: IF (l_unexp_level >= l_debug_level) THEN
1221: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.lock_row.Msg2',FALSE);
1222: END IF;
1223: -- bug 3199481, end block
1224: app_exception.raise_exception;
1225: END IF;

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

1337: ELSE
1338: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1339: -- bug 3199481, start block
1340: IF (l_unexp_level >= l_debug_level) THEN
1341: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_sources_pkg.update_row.Msg1',FALSE);
1342: END IF;
1343: -- bug 3199481, end block
1344: app_exception.raise_exception;
1345: END IF;

Line 1431: UPDATE igi_dos_sources

1427: x_last_updated_by => x_last_updated_by,
1428: x_last_update_login => x_last_update_login
1429: );
1430:
1431: UPDATE igi_dos_sources
1432: SET
1433: dossier_id = new_references.dossier_id,
1434: sob_id = new_references.sob_id,
1435: coa_id = new_references.coa_id,

Line 1606: FROM igi_dos_sources

1602: || (reverse chronological order - newest change first)
1603: */
1604: CURSOR c1 IS
1605: SELECT rowid
1606: FROM igi_dos_sources
1607: WHERE source_id = x_source_id;
1608:
1609: BEGIN
1610:

Line 1799: DELETE FROM igi_dos_sources

1795: p_action => 'DELETE',
1796: x_rowid => x_rowid
1797: );
1798:
1799: DELETE FROM igi_dos_sources
1800: WHERE rowid = x_rowid;
1801:
1802: IF (SQL%NOTFOUND) THEN
1803: RAISE NO_DATA_FOUND;

Line 1809: END igi_dos_sources_pkg;

1805:
1806: END delete_row;
1807:
1808:
1809: END igi_dos_sources_pkg;