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

Line 1: PACKAGE BODY igi_dos_trx_sources_pkg AS

1: PACKAGE BODY igi_dos_trx_sources_pkg AS
2: /* $Header: igidostb.pls 120.7.12000000.2 2007/06/14 05:55:29 pshivara ship $ */
3:
4: l_debug_level number;
5:

Line 14: old_references igi_dos_trx_sources%ROWTYPE;

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

Line 15: new_references igi_dos_trx_sources%ROWTYPE;

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

Line 107: FROM igi_dos_trx_sources

103: */
104:
105: CURSOR cur_old_ref_values IS
106: SELECT *
107: FROM igi_dos_trx_sources
108: WHERE rowid = x_rowid;
109:
110: BEGIN
111:

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

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

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

234: ) THEN
235: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
236: -- bug 3199481, start block
237: IF (l_unexp_level >= l_debug_level) THEN
238: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.check_parent_existance.Msg1',FALSE);
239: END IF;
240: -- bug 3199481, end block
241: app_exception.raise_exception;
242: END IF;

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

249: ) THEN
250: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
251: -- bug 3199481, start block
252: IF (l_unexp_level >= l_debug_level) THEN
253: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.check_parent_existance.Msg2',FALSE);
254: END IF;
255: -- bug 3199481, end block
256: app_exception.raise_exception;
257: END IF;

Line 274: igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_sources (

270: || (reverse chronological order - newest change first)
271: */
272: BEGIN
273:
274: igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_sources (
275: old_references.source_trx_id
276: );
277:
278: /* sowsubra 06-JUN-2002 start */

Line 279: /* Commented the following code as this igi_dos_trx_sources_hist_pkg

275: old_references.source_trx_id
276: );
277:
278: /* sowsubra 06-JUN-2002 start */
279: /* Commented the following code as this igi_dos_trx_sources_hist_pkg
280: is currently not present */
281:
282: /*igi_dos_trx_sources_hist_pkg.get_fk_igi_dos_trx_sources (
283: old_references.source_trx_id );

Line 282: /*igi_dos_trx_sources_hist_pkg.get_fk_igi_dos_trx_sources (

278: /* sowsubra 06-JUN-2002 start */
279: /* Commented the following code as this igi_dos_trx_sources_hist_pkg
280: is currently not present */
281:
282: /*igi_dos_trx_sources_hist_pkg.get_fk_igi_dos_trx_sources (
283: old_references.source_trx_id );
284: */
285: /* sowsubra 06-JUN-2002 end */
286:

Line 305: FROM igi_dos_trx_sources

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

Line 340: FROM igi_dos_trx_sources

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

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

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

Line 379: FROM igi_dos_trx_sources

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

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

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

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

578: ) THEN
579: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
580: -- bug 3199481, start block
581: IF (l_unexp_level >= l_debug_level) THEN
582: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.before_dml.Msg1',FALSE);
583: END IF;
584: -- bug 3199481, end block
585: app_exception.raise_exception;
586: END IF;

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

599: ) THEN
600: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
601: -- bug 3199481, start block
602: IF (l_unexp_level >= l_debug_level) THEN
603: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.before_dml.Msg2',FALSE);
604: END IF;
605: -- bug 3199481, end block
606: app_exception.raise_exception;
607: END IF;

Line 698: FROM igi_dos_trx_sources

694: || (reverse chronological order - newest change first)
695: */
696: CURSOR c IS
697: SELECT rowid
698: FROM igi_dos_trx_sources
699: WHERE source_trx_id = x_source_trx_id;
700:
701: x_last_update_date DATE;
702: x_last_updated_by NUMBER;

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

727: ELSE
728: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
729: -- bug 3199481, start block
730: IF (l_unexp_level >= l_debug_level) THEN
731: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.insert_row.Msg1',FALSE);
732: END IF;
733: -- bug 3199481, end block
734: app_exception.raise_exception;
735: END IF;

Line 737: SELECT igi_dos_trx_sources_s.NEXTVAL

733: -- bug 3199481, end block
734: app_exception.raise_exception;
735: END IF;
736:
737: SELECT igi_dos_trx_sources_s.NEXTVAL
738: INTO x_source_trx_id
739: FROM dual;
740:
741: before_dml(

Line 820: INSERT INTO igi_dos_trx_sources (

816: x_last_updated_by => x_last_updated_by,
817: x_last_update_login => x_last_update_login
818: );
819:
820: INSERT INTO igi_dos_trx_sources (
821: sob_id,
822: trx_id,
823: source_trx_id,
824: source_id,

Line 1134: FROM igi_dos_trx_sources

1130: segment27,
1131: segment28,
1132: segment29,
1133: segment30
1134: FROM igi_dos_trx_sources
1135: WHERE rowid = x_rowid
1136: FOR UPDATE NOWAIT;
1137:
1138: tlinfo c1%ROWTYPE;

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

1144: IF (c1%notfound) THEN
1145: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1146: -- bug 3199481, start block
1147: IF (l_unexp_level >= l_debug_level) THEN
1148: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.lock_row.Msg1',FALSE);
1149: END IF;
1150: -- bug 3199481, end block
1151: CLOSE c1;
1152: app_exception.raise_exception;

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

1228: ELSE
1229: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1230: -- bug 3199481, start block
1231: IF (l_unexp_level >= l_debug_level) THEN
1232: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.lock_row.Msg2',FALSE);
1233: END IF;
1234: -- bug 3199481, end block
1235: app_exception.raise_exception;
1236: END IF;

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

1351: ELSE
1352: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1353: -- bug 3199481, start block
1354: IF (l_unexp_level >= l_debug_level) THEN
1355: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_sources_pkg.update_row.Msg1',FALSE);
1356: END IF;
1357: -- bug 3199481, end block
1358: app_exception.raise_exception;
1359: END IF;

Line 1440: UPDATE igi_dos_trx_sources

1436: x_last_updated_by => x_last_updated_by,
1437: x_last_update_login => x_last_update_login
1438: );
1439:
1440: UPDATE igi_dos_trx_sources
1441: SET
1442: sob_id = new_references.sob_id,
1443: trx_id = new_references.trx_id,
1444: source_id = new_references.source_id,

Line 1605: FROM igi_dos_trx_sources

1601: || (reverse chronological order - newest change first)
1602: */
1603: CURSOR c1 IS
1604: SELECT rowid
1605: FROM igi_dos_trx_sources
1606: WHERE source_trx_id = x_source_trx_id;
1607:
1608: l_mode VARCHAR2(1);
1609: BEGIN

Line 1796: DELETE FROM igi_dos_trx_sources

1792: -- p_action => 'DELETE',
1793: -- x_rowid => x_rowid
1794: --);
1795:
1796: DELETE FROM igi_dos_trx_sources
1797: WHERE rowid = x_rowid;
1798:
1799: ----IF (SQL%NOTFOUND) THEN
1800: --RAISE NO_DATA_FOUND;

Line 1814: END igi_dos_trx_sources_pkg;

1810: l_excep_level := FND_LOG.LEVEL_EXCEPTION ;
1811: l_error_level := FND_LOG.LEVEL_ERROR ;
1812: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED ;
1813:
1814: END igi_dos_trx_sources_pkg;