DBA Data[Home] [Help]

APPS.IGI_EXP_TU_TYPE_DETAILS_PKG dependencies on IGI_EXP_TU_TYPE_DETAILS_PKG

Line 1: PACKAGE BODY igi_exp_tu_type_details_pkg AS

1: PACKAGE BODY igi_exp_tu_type_details_pkg AS
2: /* $Header: igiexpvb.pls 120.5.12000000.1 2007/09/13 04:24:59 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 57: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.set_column_values',FALSE);

53: CLOSE cur_old_ref_values;
54: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
55: --bug 3199481 fnd logging changes: sdixit: start block
56: IF (l_error_level >= l_debug_level ) THEN
57: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.set_column_values',FALSE);
58: END IF;
59: --bug 3199481 fnd logging changes: sdixit: end block
60:
61: app_exception.raise_exception;

Line 108: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.check_parent_existance.msg1',FALSE);

104: ) THEN
105: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
106: --bug 3199481 fnd logging changes: sdixit: start block
107: IF (l_error_level >= l_debug_level ) THEN
108: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.check_parent_existance.msg1',FALSE);
109: END IF;
110: --bug 3199481 fnd logging changes: sdixit: end block
111:
112: app_exception.raise_exception;

Line 124: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.check_parent_existance.msg2',FALSE);

120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: --bug 3199481 fnd logging changes: sdixit: start block
123: IF (l_error_level >= l_debug_level ) THEN
124: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.check_parent_existance.msg2',FALSE);
125: END IF;
126: --bug 3199481 fnd logging changes: sdixit: end block
127:
128: app_exception.raise_exception;

Line 197: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);

193: CLOSE cur_rowid;
194: fnd_message.set_name ('FND','FND-CANNOT DELETE MASTER');
195: --bug 3199481 fnd logging changes: sdixit: start block
196: IF (l_error_level >= l_debug_level ) THEN
197: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
198: END IF;
199: --bug 3199481 fnd logging changes: sdixit: end block
200:
201: app_exception.raise_exception;

Line 237: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);

233: CLOSE cur_rowid;
234: fnd_message.set_name ('FND','FND-CANNOT DELETE MASTER');
235: --bug 3199481 fnd logging changes: sdixit: start block
236: IF (l_error_level >= l_debug_level ) THEN
237: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
238: END IF;
239: --bug 3199481 fnd logging changes: sdixit: end block
240:
241: app_exception.raise_exception;

Line 296: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.before_dml',FALSE);

292: ) THEN
293: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
294: --bug 3199481 fnd logging changes: sdixit: start block
295: IF (l_error_level >= l_debug_level ) THEN
296: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.before_dml',FALSE);
297: END IF;
298: --bug 3199481 fnd logging changes: sdixit: end block
299:
300: app_exception.raise_exception;

Line 315: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.before_dml',FALSE);

311: ) THEN
312: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
313: --bug 3199481 fnd logging changes: sdixit: start block
314: IF (l_error_level >= l_debug_level ) THEN
315: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.before_dml',FALSE);
316: END IF;
317: --bug 3199481 fnd logging changes: sdixit: end block
318:
319: app_exception.raise_exception;

Line 370: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.insert_row',FALSE);

366: ELSE
367: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
368: --bug 3199481 fnd logging changes: sdixit: start block
369: IF (l_error_level >= l_debug_level ) THEN
370: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.insert_row',FALSE);
371: END IF;
372: --bug 3199481 fnd logging changes: sdixit: end block
373:
374: app_exception.raise_exception;

Line 463: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.lock_row.msg1',FALSE);

459: IF (c1%notfound) THEN
460: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
461: --bug 3199481 fnd logging changes: sdixit: start block
462: IF (l_error_level >= l_debug_level ) THEN
463: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.lock_row.msg1',FALSE);
464: END IF;
465: --bug 3199481 fnd logging changes: sdixit: end block
466:
467: CLOSE c1;

Line 483: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.lock_row.msg2',FALSE);

479: ELSE
480: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
481: --bug 3199481 fnd logging changes: sdixit: start block
482: IF (l_error_level >= l_debug_level ) THEN
483: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.lock_row.msg2',FALSE);
484: END IF;
485: --bug 3199481 fnd logging changes: sdixit: end block
486:
487: app_exception.raise_exception;

Line 534: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.update_row',FALSE);

530: ELSE
531: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
532: --bug 3199481 fnd logging changes: sdixit: start block
533: IF (l_error_level >= l_debug_level ) THEN
534: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpvb.IGI_EXP_TU_TYPE_DETAILS_PKG.update_row',FALSE);
535: END IF;
536: --bug 3199481 fnd logging changes: sdixit: end block
537:
538: app_exception.raise_exception;

Line 653: END igi_exp_tu_type_details_pkg;

649:
650: END delete_row;
651:
652:
653: END igi_exp_tu_type_details_pkg;