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_DESTINATIONS_PKG dependencies on IGI_DOS_DESTINATIONS

Line 1: PACKAGE BODY igi_dos_destinations_pkg AS

1: PACKAGE BODY igi_dos_destinations_pkg AS
2: /* $Header: igidosmb.pls 120.5.12000000.2 2007/06/14 05:52:49 pshivara ship $ */
3:
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
5:

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

Line 15: new_references igi_dos_destinations%ROWTYPE;

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

Line 111: FROM igi_dos_destinations

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

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

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

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

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

Line 262: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.check_parent_existance.Msg2',FALSE);

258: ) THEN
259: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
260: -- bug 3199481, start block
261: IF (l_unexp_level >= l_debug_level) THEN
262: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.check_parent_existance.Msg2',FALSE);
263: END IF;
264: -- bug 3199481, end block
265: app_exception.raise_exception;
266: END IF;

Line 284: igi_dos_destination_usages_pkg.get_fk_igi_dos_destinations (

280: */
281: BEGIN
282:
283:
284: igi_dos_destination_usages_pkg.get_fk_igi_dos_destinations (
285: old_references.destination_id
286: );
287:
288:

Line 306: FROM igi_dos_destinations

302: || (reverse chronological order - newest change first)
303: */
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igi_dos_destinations
307: WHERE destination_id = x_destination_id
308: FOR UPDATE NOWAIT;
309:
310: lv_rowid cur_rowid%RowType;

Line 341: FROM igi_dos_destinations

337: || (reverse chronological order - newest change first)
338: */
339: CURSOR cur_rowid IS
340: SELECT rowid
341: FROM igi_dos_destinations
342: WHERE ((dossier_id = x_dossier_id));
343:
344: lv_rowid cur_rowid%RowType;
345:

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

351: CLOSE cur_rowid;
352: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
353: -- bug 3199481, start block
354: IF (l_unexp_level >= l_debug_level) THEN
355: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.get_fk_igi_dos_doc_types.Msg1',FALSE);
356: END IF;
357: -- bug 3199481, end block
358: app_exception.raise_exception;
359: RETURN;

Line 380: FROM igi_dos_destinations

376: || (reverse chronological order - newest change first)
377: */
378: CURSOR cur_rowid IS
379: SELECT rowid
380: FROM igi_dos_destinations
381: WHERE ((source_id = x_source_id));
382:
383: lv_rowid cur_rowid%RowType;
384:

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

390: CLOSE cur_rowid;
391: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
392: -- bug 3199481, start block
393: IF (l_unexp_level >= l_debug_level) THEN
394: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.get_fk_igi_dos_sources.Msg1',FALSE);
395: END IF;
396: -- bug 3199481, end block
397: app_exception.raise_exception;
398: RETURN;

Line 592: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.beforedml.Msg1',FALSE);

588: ) THEN
589: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
590: -- bug 3199481, start block
591: IF (l_unexp_level >= l_debug_level) THEN
592: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.beforedml.Msg1',FALSE);
593: END IF;
594: -- bug 3199481, end block
595: app_exception.raise_exception;
596: END IF;

Line 613: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.beforedml.Msg2',FALSE);

609: ) THEN
610: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
611: -- bug 3199481, start block
612: IF (l_unexp_level >= l_debug_level) THEN
613: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.beforedml.Msg2',FALSE);
614: END IF;
615: -- bug 3199481, end block
616: app_exception.raise_exception;
617: END IF;

Line 713: FROM igi_dos_destinations

709: || (reverse chronological order - newest change first)
710: */
711: CURSOR c IS
712: SELECT rowid
713: FROM igi_dos_destinations
714: WHERE destination_id = x_destination_id;
715:
716: x_last_update_date DATE;
717: x_last_updated_by NUMBER;

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

735: ELSE
736: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
737: -- bug 3199481, start block
738: IF (l_unexp_level >= l_debug_level) THEN
739: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.insert_row.Msg1',FALSE);
740: END IF;
741: -- bug 3199481, end block
742: app_exception.raise_exception;
743: END IF;

Line 745: SELECT igi_dos_destinations_s.NEXTVAL

741: -- bug 3199481, end block
742: app_exception.raise_exception;
743: END IF;
744:
745: SELECT igi_dos_destinations_s.NEXTVAL
746: INTO x_destination_id
747: FROM dual;
748:
749: before_dml(

Line 833: INSERT INTO igi_dos_destinations (

829: x_last_updated_by => x_last_updated_by,
830: x_last_update_login => x_last_update_login
831: );
832:
833: INSERT INTO igi_dos_destinations (
834: line_num,
835: dossier_id,
836: source_id,
837: destination_id,

Line 1167: FROM igi_dos_destinations

1163: segments_high_ccid,
1164: segments_low_ccid_desc,
1165: segments_high_ccid_desc,
1166: budget_version_id
1167: FROM igi_dos_destinations
1168: WHERE rowid = x_rowid
1169: FOR UPDATE NOWAIT;
1170:
1171: tlinfo c1%ROWTYPE;

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

1177: IF (c1%notfound) THEN
1178: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1179: -- bug 3199481, start block
1180: IF (l_unexp_level >= l_debug_level) THEN
1181: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.lock_row.Msg1',FALSE);
1182: END IF;
1183: -- bug 3199481, end block
1184: CLOSE c1;
1185: app_exception.raise_exception;

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

1266: ELSE
1267: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1268: -- bug 3199481, start block
1269: IF (l_unexp_level >= l_debug_level) THEN
1270: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.lock_row.Msg2',FALSE);
1271: END IF;
1272: -- bug 3199481, end block
1273: app_exception.raise_exception;
1274: END IF;

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

1386: ELSE
1387: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1388: -- bug 3199481, start block
1389: IF (l_unexp_level >= l_debug_level) THEN
1390: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_destinations_pkg.update_row.Msg1',FALSE);
1391: END IF;
1392: -- bug 3199481, end block
1393: app_exception.raise_exception;
1394: END IF;

Line 1480: UPDATE igi_dos_destinations

1476: x_last_updated_by => x_last_updated_by,
1477: x_last_update_login => x_last_update_login
1478: );
1479:
1480: UPDATE igi_dos_destinations
1481: SET
1482: line_num = new_references.line_num,
1483: dossier_id = new_references.dossier_id,
1484: source_id = new_references.source_id,

Line 1655: FROM igi_dos_destinations

1651: || (reverse chronological order - newest change first)
1652: */
1653: CURSOR c1 IS
1654: SELECT rowid
1655: FROM igi_dos_destinations
1656: WHERE destination_id = x_destination_id;
1657:
1658: BEGIN
1659:

Line 1848: DELETE FROM igi_dos_destinations

1844: p_action => 'DELETE',
1845: x_rowid => x_rowid
1846: );
1847:
1848: DELETE FROM igi_dos_destinations
1849: WHERE rowid = x_rowid;
1850:
1851: IF (SQL%NOTFOUND) THEN
1852: RAISE NO_DATA_FOUND;

Line 1858: END igi_dos_destinations_pkg;

1854:
1855: END delete_row;
1856:
1857:
1858: END igi_dos_destinations_pkg;