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_TRX_DEST_PKG dependencies on IGI_DOS_TRX_DEST

Line 1: PACKAGE BODY igi_dos_trx_dest_pkg AS

1: PACKAGE BODY igi_dos_trx_dest_pkg AS
2: /* $Header: igidosrb.pls 120.8.12000000.2 2007/06/14 05:57:08 pshivara ship $ */
3:
4: l_debug_level number;
5:

Line 14: old_references igi_dos_trx_dest%ROWTYPE;

10: l_error_level number;
11: l_unexp_level number;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_dos_trx_dest%ROWTYPE;
15: new_references igi_dos_trx_dest%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igi_dos_trx_dest%ROWTYPE;

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

Line 109: FROM igi_dos_trx_dest

105: */
106:
107: CURSOR cur_old_ref_values IS
108: SELECT *
109: FROM igi_dos_trx_dest
110: WHERE rowid = x_rowid;
111:
112: BEGIN
113:

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

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

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

238: ) THEN
239: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
240: -- bug 3199481, start block
241: IF (l_unexp_level >= l_debug_level) THEN
242: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg1',FALSE);
243: END IF;
244: -- bug 3199481, end block
245: app_exception.raise_exception;
246: END IF;

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

253: ) THEN
254: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
255: -- bug 3199481, start block
256: IF (l_unexp_level >= l_debug_level) THEN
257: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg2',FALSE);
258: END IF;
259: -- bug 3199481, end block
260: app_exception.raise_exception;
261: END IF;

Line 272: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg3',FALSE);

268: ) THEN
269: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
270: -- bug 3199481, start block
271: IF (l_unexp_level >= l_debug_level) THEN
272: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.check_parent_existance.Msg3',FALSE);
273: END IF;
274: -- bug 3199481, end block
275: app_exception.raise_exception;
276: END IF;

Line 294: /* Commented the following code as this igi_dos_trx_dest_hist_pkg

290: */
291: BEGIN
292:
293: /* sowsubra 06-JUN-2002 start */
294: /* Commented the following code as this igi_dos_trx_dest_hist_pkg
295: is currently not present */
296:
297: null;
298: /*igi_dos_trx_dest_hist_pkg.get_fk_igi_dos_trx_dest (

Line 298: /*igi_dos_trx_dest_hist_pkg.get_fk_igi_dos_trx_dest (

294: /* Commented the following code as this igi_dos_trx_dest_hist_pkg
295: is currently not present */
296:
297: null;
298: /*igi_dos_trx_dest_hist_pkg.get_fk_igi_dos_trx_dest (
299: old_references.dest_trx_id );
300: /* sowsubra 06-JUN-2002 end */
301:
302: END check_child_existance;

Line 319: FROM igi_dos_trx_dest

315: || (reverse chronological order - newest change first)
316: */
317: CURSOR cur_rowid IS
318: SELECT rowid
319: FROM igi_dos_trx_dest
320: WHERE dest_trx_id = x_dest_trx_id
321: FOR UPDATE NOWAIT;
322:
323: lv_rowid cur_rowid%RowType;

Line 354: FROM igi_dos_trx_dest

350: || (reverse chronological order - newest change first)
351: */
352: CURSOR cur_rowid IS
353: SELECT rowid
354: FROM igi_dos_trx_dest
355: WHERE ((source_trx_id = x_source_trx_id));
356:
357: lv_rowid cur_rowid%RowType;
358:

Line 368: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_sources.Msg1',FALSE);

364: CLOSE cur_rowid;
365: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
366: -- bug 3199481, start block
367: IF (l_unexp_level >= l_debug_level) THEN
368: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_sources.Msg1',FALSE);
369: END IF;
370: -- bug 3199481, end block
371: app_exception.raise_exception;
372: RETURN;

Line 393: FROM igi_dos_trx_dest

389: || (reverse chronological order - newest change first)
390: */
391: CURSOR cur_rowid IS
392: SELECT rowid
393: FROM igi_dos_trx_dest
394: WHERE ((trx_id = x_trx_id));
395:
396: lv_rowid cur_rowid%RowType;
397:

Line 407: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_headers.Msg1',FALSE);

403: CLOSE cur_rowid;
404: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
405: -- bug 3199481, start block
406: IF (l_unexp_level >= l_debug_level) THEN
407: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_headers.Msg1',FALSE);
408: END IF;
409: -- bug 3199481, end block
410: app_exception.raise_exception;
411: RETURN;

Line 432: FROM igi_dos_trx_dest

428: || (reverse chronological order - newest change first)
429: */
430: CURSOR cur_rowid IS
431: SELECT rowid
432: FROM igi_dos_trx_dest
433: WHERE ((dossier_id = x_dossier_id));
434:
435: lv_rowid cur_rowid%RowType;
436:

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

442: CLOSE cur_rowid;
443: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
444: -- bug 3199481, start block
445: IF (l_unexp_level >= l_debug_level) THEN
446: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.get_fk_igi_dos_doc_types.Msg1',FALSE);
447: END IF;
448: -- bug 3199481, end block
449: app_exception.raise_exception;
450: RETURN;

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

635: ) THEN
636: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
637: -- bug 3199481, start block
638: IF (l_unexp_level >= l_debug_level) THEN
639: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.before_dml.Msg1',FALSE);
640: END IF;
641: -- bug 3199481, end block
642: app_exception.raise_exception;
643: END IF;

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

657: ) THEN
658: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
659: -- bug 3199481, start block
660: IF (l_unexp_level >= l_debug_level) THEN
661: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.before_dml.Msg2',FALSE);
662: END IF;
663: -- bug 3199481, end block
664: app_exception.raise_exception;
665: END IF;

Line 758: FROM igi_dos_trx_dest

754: || (reverse chronological order - newest change first)
755: */
756: CURSOR c IS
757: SELECT rowid
758: FROM igi_dos_trx_dest
759: WHERE dest_trx_id = x_dest_trx_id;
760:
761: x_last_update_date DATE;
762: x_last_updated_by NUMBER;

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

787: ELSE
788: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
789: -- bug 3199481, start block
790: IF (l_unexp_level >= l_debug_level) THEN
791: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.insert_row.Msg1',FALSE);
792: END IF;
793: -- bug 3199481, end block
794: app_exception.raise_exception;
795: END IF;

Line 797: SELECT igi_dos_trx_dest_s.NEXTVAL

793: -- bug 3199481, end block
794: app_exception.raise_exception;
795: END IF;
796:
797: SELECT igi_dos_trx_dest_s.NEXTVAL
798: INTO x_dest_trx_id
799: FROM dual;
800:
801: before_dml(

Line 882: INSERT INTO igi_dos_trx_dest (

878: x_last_updated_by => x_last_updated_by,
879: x_last_update_login => x_last_update_login
880: );
881:
882: INSERT INTO igi_dos_trx_dest (
883: sob_id,
884: trx_id,
885: dest_trx_id,
886: source_trx_id,

Line 1204: FROM igi_dos_trx_dest

1200: segment27,
1201: segment28,
1202: segment29,
1203: segment30
1204: FROM igi_dos_trx_dest
1205: WHERE rowid = x_rowid
1206: FOR UPDATE NOWAIT;
1207:
1208: tlinfo c1%ROWTYPE;

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

1214: IF (c1%notfound) THEN
1215: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1216: -- bug 3199481, start block
1217: IF (l_unexp_level >= l_debug_level) THEN
1218: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.lock_row.Msg1',FALSE);
1219: END IF;
1220: -- bug 3199481, end block
1221: CLOSE c1;
1222: app_exception.raise_exception;

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

1300: ELSE
1301: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1302: -- bug 3199481, start block
1303: IF (l_unexp_level >= l_debug_level) THEN
1304: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.lock_row.Msg2',FALSE);
1305: END IF;
1306: -- bug 3199481, end block
1307: app_exception.raise_exception;
1308: END IF;

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

1424: ELSE
1425: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1426: -- bug 3199481, start block
1427: IF (l_unexp_level >= l_debug_level) THEN
1428: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_dest_pkg.update_row.Msg1',FALSE);
1429: END IF;
1430: -- bug 3199481, end block
1431: app_exception.raise_exception;
1432: END IF;

Line 1515: UPDATE igi_dos_trx_dest

1511: x_last_updated_by => x_last_updated_by,
1512: x_last_update_login => x_last_update_login
1513: );
1514:
1515: UPDATE igi_dos_trx_dest
1516: SET
1517: sob_id = new_references.sob_id,
1518: trx_id = new_references.trx_id,
1519: source_trx_id = new_references.source_trx_id,

Line 1684: FROM igi_dos_trx_dest

1680: || (reverse chronological order - newest change first)
1681: */
1682: CURSOR c1 IS
1683: SELECT rowid
1684: FROM igi_dos_trx_dest
1685: WHERE dest_trx_id = x_dest_trx_id;
1686:
1687: l_mode VARCHAR2(1);
1688: BEGIN

Line 1954: DELETE FROM igi_dos_trx_dest

1950: x_last_update_login => NULL
1951: );
1952:
1953:
1954: DELETE FROM igi_dos_trx_dest
1955: WHERE rowid = x_rowid;
1956:
1957: --IF (SQL%NOTFOUND) THEN
1958: -- RAISE NO_DATA_FOUND;

Line 1974: END igi_dos_trx_dest_pkg;

1970: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED ;
1971:
1972:
1973:
1974: END igi_dos_trx_dest_pkg;