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_DOC_TYPES_PKG dependencies on IGI_DOS_DOC_TYPES

Line 1: PACKAGE BODY igi_dos_doc_types_pkg AS

1: PACKAGE BODY igi_dos_doc_types_pkg AS
2: /* $Header: igidosob.pls 120.6.12000000.2 2007/06/14 05:47:01 pshivara ship $ */
3:
4: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
5:

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

Line 15: new_references igi_dos_doc_types%ROWTYPE;

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

Line 71: FROM igi_dos_doc_types

67: */
68:
69: CURSOR cur_old_ref_values IS
70: SELECT *
71: FROM igi_dos_doc_types
72: WHERE rowid = x_rowid;
73:
74: BEGIN
75:

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

83: CLOSE cur_old_ref_values;
84: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
85: -- bug 3199481, start block
86: IF (l_unexp_level >= l_debug_level) THEN
87: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.set_column_values.Msg1',FALSE);
88: END IF;
89: -- bug 3199481, end block
90: app_exception.raise_exception;
91: RETURN;

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

164: ) THEN
165: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
166: -- bug 3199481, start block
167: IF (l_unexp_level >= l_debug_level) THEN
168: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.check_parent_existance.Msg1',FALSE);
169: END IF;
170: -- bug 3199481, end block
171: app_exception.raise_exception; */
172: END IF;

Line 190: igi_dos_doc_types

186: */
187:
188: cursor cur_rel_dos is
189: select count(*) from
190: igi_dos_doc_types
191: where related_dossier_id = old_references.dossier_id ;
192:
193: cur_row_cnt number;
194:

Line 204: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.check_child_existance.Msg1',FALSE);

200: if cur_row_cnt > 0 then
201: fnd_message.set_name('IGI', 'IGI_DOS_NO_DELETE_TYPE');
202: -- bug 3199481, start block
203: IF (l_unexp_level >= l_debug_level) THEN
204: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.check_child_existance.Msg1',FALSE);
205: END IF;
206: -- bug 3199481, end block
207: app_exception.raise_exception;
208: end if;

Line 210: igi_dos_sources_pkg.get_fk_igi_dos_doc_types (

206: -- bug 3199481, end block
207: app_exception.raise_exception;
208: end if;
209:
210: igi_dos_sources_pkg.get_fk_igi_dos_doc_types (
211: old_references.dossier_id
212: );
213: igi_dos_destinations_pkg.get_fk_igi_dos_doc_types (
214: old_references.dossier_id

Line 213: igi_dos_destinations_pkg.get_fk_igi_dos_doc_types (

209:
210: igi_dos_sources_pkg.get_fk_igi_dos_doc_types (
211: old_references.dossier_id
212: );
213: igi_dos_destinations_pkg.get_fk_igi_dos_doc_types (
214: old_references.dossier_id
215: );
216:
217: END check_child_existance;

Line 234: FROM igi_dos_doc_types

230: || (reverse chronological order - newest change first)
231: */
232: CURSOR cur_rowid IS
233: SELECT rowid
234: FROM igi_dos_doc_types
235: WHERE dossier_id = x_dossier_id
236: FOR UPDATE NOWAIT;
237:
238: lv_rowid cur_rowid%RowType;

Line 269: FROM igi_dos_doc_types

265: || (reverse chronological order - newest change first)
266: */
267: CURSOR cur_rowid IS
268: SELECT rowid
269: FROM igi_dos_doc_types
270: WHERE ((dossier_numbering = x_numbering_scheme));
271:
272: lv_rowid cur_rowid%RowType;
273:

Line 283: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.get_fk_igi_dossier_numbering.Msg1',FALSE);

279: CLOSE cur_rowid;
280: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
281: -- bug 3199481, start block
282: IF (l_unexp_level >= l_debug_level) THEN
283: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.get_fk_igi_dossier_numbering.Msg1',FALSE);
284: END IF;
285: -- bug 3199481, end block
286: app_exception.raise_exception;
287: RETURN;

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

398: ) THEN
399: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
400: -- bug 3199481, start block
401: IF (l_unexp_level >= l_debug_level) THEN
402: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.before_dml.Msg1',FALSE);
403: END IF;
404: -- bug 3199481, end block
405: app_exception.raise_exception;
406: END IF;

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

419: ) THEN
420: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
421: -- bug 3199481, start block
422: IF (l_unexp_level >= l_debug_level) THEN
423: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.before_dml.Msg2',FALSE);
424: END IF;
425: -- bug 3199481, end block
426: app_exception.raise_exception;
427: END IF;

Line 483: FROM igi_dos_doc_types

479: || (reverse chronological order - newest change first)
480: */
481: CURSOR c IS
482: SELECT rowid
483: FROM igi_dos_doc_types
484: WHERE dossier_id = x_dossier_id;
485:
486: x_last_update_date DATE;
487: x_last_updated_by NUMBER;

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

505: ELSE
506: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
507: -- bug 3199481, start block
508: IF (l_unexp_level >= l_debug_level) THEN
509: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.insert_row.Msg1',FALSE);
510: END IF;
511: -- bug 3199481, end block
512: app_exception.raise_exception;
513: END IF;

Line 515: SELECT igi_dos_doc_types_s.NEXTVAL

511: -- bug 3199481, end block
512: app_exception.raise_exception;
513: END IF;
514:
515: SELECT igi_dos_doc_types_s.NEXTVAL
516: INTO x_dossier_id
517: FROM dual;
518:
519: before_dml(

Line 563: INSERT INTO igi_dos_doc_types (

559: x_last_updated_by => x_last_updated_by,
560: x_last_update_login => x_last_update_login
561: );
562:
563: INSERT INTO igi_dos_doc_types (
564: amount_type,
565: dossier_id,
566: dossier_name,
567: dossier_numbering,

Line 737: FROM igi_dos_doc_types

733: attribute13,
734: attribute14,
735: attribute15,
736: related_dossier_id
737: FROM igi_dos_doc_types
738: WHERE rowid = x_rowid
739: FOR UPDATE NOWAIT;
740:
741: tlinfo c1%ROWTYPE;

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

747: IF (c1%notfound) THEN
748: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
749: -- bug 3199481, start block
750: IF (l_unexp_level >= l_debug_level) THEN
751: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.lock_row.Msg1',FALSE);
752: END IF;
753: -- bug 3199481, end block
754: CLOSE c1;
755: app_exception.raise_exception;

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

796: ELSE
797: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
798: -- bug 3199481, start block
799: IF (l_unexp_level >= l_debug_level) THEN
800: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.lock_row.Msg2',FALSE);
801: END IF;
802: -- bug 3199481, end block
803: app_exception.raise_exception;
804: END IF;

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

876: ELSE
877: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
878: -- bug 3199481, start block
879: IF (l_unexp_level >= l_debug_level) THEN
880: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_dos_doc_types_pkg.update_row.Msg1',FALSE);
881: END IF;
882: -- bug 3199481, end block
883: app_exception.raise_exception;
884: END IF;

Line 930: UPDATE igi_dos_doc_types

926: x_last_updated_by => x_last_updated_by,
927: x_last_update_login => x_last_update_login
928: );
929:
930: UPDATE igi_dos_doc_types
931: SET
932: amount_type = new_references.amount_type,
933: dossier_name = new_references.dossier_name,
934: dossier_numbering = new_references.dossier_numbering,

Line 1025: FROM igi_dos_doc_types

1021: || (reverse chronological order - newest change first)
1022: */
1023: CURSOR c1 IS
1024: SELECT rowid
1025: FROM igi_dos_doc_types
1026: WHERE dossier_id = x_dossier_id;
1027:
1028: BEGIN
1029:

Line 1139: DELETE FROM igi_dos_doc_types

1135: x_rowid => x_rowid
1136: );
1137:
1138:
1139: DELETE FROM igi_dos_doc_types
1140: WHERE rowid = x_rowid;
1141:
1142: IF (SQL%NOTFOUND) THEN
1143: RAISE NO_DATA_FOUND;

Line 1149: END igi_dos_doc_types_pkg;

1145:
1146: END delete_row;
1147:
1148:
1149: END igi_dos_doc_types_pkg;