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_EXP_DUS_PKG dependencies on IGI_EXP_DUS_PKG

Line 1: PACKAGE BODY igi_exp_dus_pkg AS

1: PACKAGE BODY igi_exp_dus_pkg AS
2: /* $Header: igiexpwb.pls 120.4.12000000.1 2007/09/13 04:25:09 mbremkum ship $ */
3:
4: --following variables added for bug 3199481: fnd logging changes: sdixit
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 86: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.set_column_values',FALSE);

82: CLOSE cur_old_ref_values;
83: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
84: --bug 3199481 fnd logging changes: sdixit: start block
85: IF (l_error_level >= l_debug_level ) THEN
86: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.set_column_values',FALSE);
87: END IF;
88: --bug 3199481 fnd logging changes: sdixit: end block
89:
90: app_exception.raise_exception;

Line 166: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.check_parent_existance.msg1',FALSE);

162: ) THEN
163: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
164: --bug 3199481 fnd logging changes: sdixit: start block
165: IF (l_error_level >= l_debug_level ) THEN
166: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.check_parent_existance.msg1',FALSE);
167: END IF;
168: --bug 3199481 fnd logging changes: sdixit: end block
169:
170: app_exception.raise_exception;

Line 182: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.check_parent_existance.msg2',FALSE);

178: ) THEN
179: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
180: --bug 3199481 fnd logging changes: sdixit: start block
181: IF (l_error_level >= l_debug_level ) THEN
182: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.check_parent_existance.msg2',FALSE);
183: END IF;
184: --bug 3199481 fnd logging changes: sdixit: end block
185:
186: app_exception.raise_exception;

Line 289: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.get_fk_igi_exp_du_type_headers',FALSE);

285: CLOSE cur_rowid;
286: fnd_message.set_name('FND' ,'FND-CANNOT DELETE MASTER');
287: --bug 3199481 fnd logging changes: sdixit: start block
288: IF (l_error_level >= l_debug_level ) THEN
289: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
290: END IF;
291: --bug 3199481 fnd logging changes: sdixit: end block
292:
293: app_exception.raise_exception;

Line 329: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.get_fk_igi_exp_tus',FALSE);

325: CLOSE cur_rowid;
326: fnd_message.set_name('FND' ,'FND-CANNOT DELETE MASTER');
327: --bug 3199481 fnd logging changes: sdixit: start block
328: IF (l_error_level >= l_debug_level ) THEN
329: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.get_fk_igi_exp_tus',FALSE);
330: END IF;
331: --bug 3199481 fnd logging changes: sdixit: end block
332:
333: app_exception.raise_exception;

Line 369: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.get_fk_po_vendors',FALSE);

365: CLOSE cur_rowid;
366: fnd_message.set_name('FND' ,'FND-CANNOT DELETE MASTER');
367: --bug 3199481 fnd logging changes: sdixit: start block
368: IF (l_error_level >= l_debug_level ) THEN
369: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.get_fk_po_vendors',FALSE);
370: END IF;
371: --bug 3199481 fnd logging changes: sdixit: end block
372: app_exception.raise_exception;
373: RETURN;

Line 485: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.before_dml.msg1',FALSE);

481: ) THEN
482: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
483: --bug 3199481 fnd logging changes: sdixit: start block
484: IF (l_error_level >= l_debug_level ) THEN
485: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.before_dml.msg1',FALSE);
486: END IF;
487: --bug 3199481 fnd logging changes: sdixit: end block
488:
489: app_exception.raise_exception;

Line 507: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.before_dml.msg2',FALSE);

503: ) THEN
504: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
505: --bug 3199481 fnd logging changes: sdixit: start block
506: IF (l_error_level >= l_debug_level ) THEN
507: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.before_dml.msg2',FALSE);
508: END IF;
509: --bug 3199481 fnd logging changes: sdixit: end block
510:
511: app_exception.raise_exception;

Line 593: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.insert_row',FALSE);

589: ELSE
590: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
591: --bug 3199481 fnd logging changes: sdixit: start block
592: IF (l_error_level >= l_debug_level ) THEN
593: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.insert_row',FALSE);
594: END IF;
595: --bug 3199481 fnd logging changes: sdixit: end block
596:
597: app_exception.raise_exception;

Line 831: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.lock_row.msg1',FALSE);

827: IF (c1%notfound) THEN
828: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
829: --bug 3199481 fnd logging changes: sdixit: start block
830: IF (l_error_level >= l_debug_level ) THEN
831: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.lock_row.msg1',FALSE);
832: END IF;
833: --bug 3199481 fnd logging changes: sdixit: end block
834:
835: CLOSE c1;

Line 880: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.lock_row.msg2',FALSE);

876: ELSE
877: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
878: --bug 3199481 fnd logging changes: sdixit: start block
879: IF (l_error_level >= l_debug_level ) THEN
880: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.lock_row.msg2',FALSE);
881: END IF;
882: --bug 3199481 fnd logging changes: sdixit: end block
883:
884: app_exception.raise_exception;

Line 960: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.update_row',FALSE);

956: ELSE
957: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
958: --bug 3199481 fnd logging changes: sdixit: start block
959: IF (l_error_level >= l_debug_level ) THEN
960: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpwb.IGI_EXP_DUS_PKG.update_row',FALSE);
961: END IF;
962: --bug 3199481 fnd logging changes: sdixit: end block
963:
964: app_exception.raise_exception;

Line 1224: END igi_exp_dus_pkg;

1220:
1221: END delete_row;
1222:
1223:
1224: END igi_exp_dus_pkg;