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_HEADERS_PKG dependencies on IGI_DOS_TRX_HEADERS

Line 1: PACKAGE BODY igi_dos_trx_headers_pkg AS

1: PACKAGE BODY igi_dos_trx_headers_pkg AS
2: /* $Header: igidossb.pls 120.13 2010/07/19 09:59:37 dramired ship $ */
3:
4: l_debug_level number;
5:

Line 14: old_references igi_dos_trx_headers%ROWTYPE;

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

Line 15: new_references igi_dos_trx_headers%ROWTYPE;

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

Line 81: FROM igi_dos_trx_headers

77: */
78:
79: CURSOR cur_old_ref_values IS
80: SELECT *
81: FROM igi_dos_trx_headers
82: WHERE rowid = x_rowid;
83:
84: BEGIN
85:

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

93: CLOSE cur_old_ref_values;
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: -- bug 3199481, start block
96: IF (l_unexp_level >= l_debug_level) THEN
97: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.set_column_values.Msg1',FALSE);
98: END IF;
99: -- bug 3199481, end block
100: app_exception.raise_exception;
101: RETURN;

Line 166: -- IGI_DOS_TRX_HEADERS_T1

162: END set_column_values;
163:
164:
165: -- Trigger description :-
166: -- IGI_DOS_TRX_HEADERS_T1
167: -- BEFORE UPDATE OF TRX_STATUS
168: -- ON IGI_DOS_TRX_HEADERS
169: -- REFERENCING OLD AS OLD NEW AS NEW
170: -- FOR EACH ROW

Line 168: -- ON IGI_DOS_TRX_HEADERS

164:
165: -- Trigger description :-
166: -- IGI_DOS_TRX_HEADERS_T1
167: -- BEFORE UPDATE OF TRX_STATUS
168: -- ON IGI_DOS_TRX_HEADERS
169: -- REFERENCING OLD AS OLD NEW AS NEW
170: -- FOR EACH ROW
171: -- -- PL/SQL Block
172:

Line 184: SELECT igi_dos_trx_headers_hist_s.NEXTVAL

180: --
181: -- Bug 2897525 Start(1)
182: --
183: -- select igi_dos_trx_history_s.nextval
184: SELECT igi_dos_trx_headers_hist_s.NEXTVAL
185: --
186: -- Bug 2897525 End(1)
187: --
188: into x_history_trx_id

Line 191: insert into igi_dos_trx_headers_hist

187: --
188: into x_history_trx_id
189: from dual;
190:
191: insert into igi_dos_trx_headers_hist
192: (
193: trx_id ,
194: dossier_name ,
195: trx_number ,

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

425: ) THEN
426: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
427: -- bug 3199481, start block
428: IF (l_unexp_level >= l_debug_level) THEN
429: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.check_parent_existance.Msg1',FALSE);
430: END IF;
431: -- bug 3199481, end block
432: app_exception.raise_exception;
433: END IF;

Line 450: igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_headers (

446: || (reverse chronological order - newest change first)
447: */
448: BEGIN
449:
450: igi_dos_trx_dest_pkg.get_fk_igi_dos_trx_headers (
451: old_references.trx_id
452: );
453: /* sowsubra 06-JUN-2002 start */
454: /* Commented the following code as this igi_dos_headers_dest_hist_pkg

Line 457: /*igi_dos_trx_headers_hist_pkg.get_fk_igi_dos_trx_headers (

453: /* sowsubra 06-JUN-2002 start */
454: /* Commented the following code as this igi_dos_headers_dest_hist_pkg
455: is currently not present */
456:
457: /*igi_dos_trx_headers_hist_pkg.get_fk_igi_dos_trx_headers (
458: old_references.trx_id
459: );*/
460: /* sowsubra 06-JUN-2002 end */
461:

Line 463: igi_dos_trx_sources_pkg.get_fk_igi_dos_trx_headers (

459: );*/
460: /* sowsubra 06-JUN-2002 end */
461:
462:
463: igi_dos_trx_sources_pkg.get_fk_igi_dos_trx_headers (
464: old_references.trx_id
465: );
466:
467: END check_child_existance;

Line 484: FROM igi_dos_trx_headers

480: || (reverse chronological order - newest change first)
481: */
482: CURSOR cur_rowid IS
483: SELECT rowid
484: FROM igi_dos_trx_headers
485: WHERE trx_id = x_trx_id
486: FOR UPDATE NOWAIT;
487:
488: lv_rowid cur_rowid%RowType;

Line 519: FROM igi_dos_trx_headers

515: || (reverse chronological order - newest change first)
516: */
517: CURSOR cur_rowid IS
518: SELECT rowid
519: FROM igi_dos_trx_headers
520: WHERE ((dossier_id = x_dossier_id));
521:
522: lv_rowid cur_rowid%RowType;
523:

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

529: CLOSE cur_rowid;
530: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
531: -- bug 3199481, start block
532: IF (l_unexp_level >= l_debug_level) THEN
533: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.get_fk_igi_dos_doc_types.Msg1',FALSE);
534: END IF;
535: -- bug 3199481, end block
536: app_exception.raise_exception;
537: RETURN;

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

666: ) THEN
667: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
668: -- bug 3199481, start block
669: IF (l_unexp_level >= l_debug_level) THEN
670: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.before_dml.Msg1',FALSE);
671: END IF;
672: -- bug 3199481, end block
673: app_exception.raise_exception;
674: END IF;

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

688: ) THEN
689: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
690: -- bug 3199481, start block
691: IF (l_unexp_level >= l_debug_level) THEN
692: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.before_dml.Msg2',FALSE);
693: END IF;
694: -- bug 3199481, end block
695: app_exception.raise_exception;
696: END IF;

Line 761: FROM igi_dos_trx_headers

757: || (reverse chronological order - newest change first)
758: */
759: CURSOR c IS
760: SELECT rowid
761: FROM igi_dos_trx_headers
762: WHERE trx_id = x_trx_id;
763:
764: x_last_update_date DATE;
765: x_last_updated_by NUMBER;

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

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

Line 800: SELECT igi_dos_trx_headers_s.NEXTVAL

796: -- bug 3199481, end block
797: app_exception.raise_exception;
798: END IF;
799:
800: SELECT igi_dos_trx_headers_s.NEXTVAL
801: INTO x_trx_id
802: FROM dual;
803:
804: before_dml(

Line 857: INSERT INTO igi_dos_trx_headers (

853: x_last_updated_by => x_last_updated_by,
854: x_last_update_login => x_last_update_login
855: );
856:
857: INSERT INTO igi_dos_trx_headers (
858: sob_id,
859: trx_id,
860: dossier_name,
861: trx_number,

Line 1067: FROM igi_dos_trx_headers

1063: attribute29,
1064: attribute30,
1065: parent_trx_id,
1066: parent_trx_number
1067: FROM igi_dos_trx_headers
1068: WHERE rowid = x_rowid
1069: FOR UPDATE NOWAIT;
1070:
1071: tlinfo c1%ROWTYPE;

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

1077: IF (c1%notfound) THEN
1078: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1079: -- bug 3199481, start block
1080: IF (l_unexp_level >= l_debug_level) THEN
1081: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.lock_row.Msg1',FALSE);
1082: END IF;
1083: -- bug 3199481, end block
1084: CLOSE c1;
1085: app_exception.raise_exception;

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

1135: ELSE
1136: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1137: -- bug 3199481, start block
1138: IF (l_unexp_level >= l_debug_level) THEN
1139: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.lock_row.Msg1',FALSE);
1140: END IF;
1141: -- bug 3199481, end block
1142: app_exception.raise_exception;
1143: END IF;

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

1232: ELSE
1233: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1234: -- bug 3199481, start block
1235: IF (l_unexp_level >= l_debug_level) THEN
1236: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_trx_headers_pkg.update_row.Msg1',FALSE);
1237: END IF;
1238: -- bug 3199481, end block
1239: app_exception.raise_exception;
1240: END IF;

Line 1295: UPDATE igi_dos_trx_headers

1291: x_last_updated_by => x_last_updated_by,
1292: x_last_update_login => x_last_update_login
1293: );
1294:
1295: UPDATE igi_dos_trx_headers
1296: SET
1297: sob_id = new_references.sob_id,
1298: dossier_name = new_references.dossier_name,
1299: trx_number = new_references.trx_number,

Line 1408: FROM igi_dos_trx_headers

1404: || (reverse chronological order - newest change first)
1405: */
1406: CURSOR c1 IS
1407: SELECT rowid
1408: FROM igi_dos_trx_headers
1409: WHERE trx_id = x_trx_id;
1410:
1411: l_mode VARCHAR2(1);
1412:

Line 1595: DELETE FROM igi_dos_trx_headers

1591: x_last_update_login=>NULL
1592:
1593: );
1594:
1595: DELETE FROM igi_dos_trx_headers
1596: WHERE rowid = x_rowid;
1597:
1598: IF (SQL%NOTFOUND) THEN
1599: RAISE NO_DATA_FOUND;

Line 1613: END igi_dos_trx_headers_pkg;

1609: l_excep_level := FND_LOG.LEVEL_EXCEPTION ;
1610: l_error_level := FND_LOG.LEVEL_ERROR ;
1611: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED ;
1612:
1613: END igi_dos_trx_headers_pkg;