DBA Data[Home] [Help]

APPS.IGI_EXP_DU_TYPE_DETAILS_PKG dependencies on IGI_EXP_DU_TYPE_DETAILS_PKG

Line 1: PACKAGE BODY igi_exp_du_type_details_pkg AS

1: PACKAGE BODY igi_exp_du_type_details_pkg AS
2: /* $Header: igiexptb.pls 120.5.12000000.1 2007/09/13 04:24:40 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.igiexptb.IGI_EXP_DU_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.igiexptb.IGI_EXP_DU_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.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.check_parent_existance',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.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.check_parent_existance',FALSE);
109: END IF;
110: --bug 3199481 fnd logging changes: sdixit: end block
111:
112: app_exception.raise_exception;

Line 181: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);

177: CLOSE cur_rowid;
178: fnd_message.set_name ('FND','FND-CANNOT DELETE MASTER');
179: --bug 3199481 fnd logging changes: sdixit: start block
180: IF (l_error_level >= l_debug_level ) THEN
181: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.get_fk_igi_exp_du_type_headers',FALSE);
182: END IF;
183: --bug 3199481 fnd logging changes: sdixit: end block
184:
185: app_exception.raise_exception;

Line 240: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg1',FALSE);

236: ) THEN
237: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
238: --bug 3199481 fnd logging changes: sdixit: start block
239: IF (l_error_level >= l_debug_level ) THEN
240: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg1',FALSE);
241: END IF;
242: --bug 3199481 fnd logging changes: sdixit: end block
243:
244: app_exception.raise_exception;

Line 259: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg2',FALSE);

255: ) THEN
256: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
257: --bug 3199481 fnd logging changes: sdixit: start block
258: IF (l_error_level >= l_debug_level ) THEN
259: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.before_dml.msg2',FALSE);
260: END IF;
261: --bug 3199481 fnd logging changes: sdixit: end block
262:
263: app_exception.raise_exception;

Line 314: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.insert_row',FALSE);

310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: --bug 3199481 fnd logging changes: sdixit: start block
313: IF (l_error_level >= l_debug_level ) THEN
314: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.insert_row',FALSE);
315: END IF;
316: --bug 3199481 fnd logging changes: sdixit: end block
317:
318: app_exception.raise_exception;

Line 407: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);

403: IF (c1%notfound) THEN
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: --bug 3199481 fnd logging changes: sdixit: start block
406: IF (l_error_level >= l_debug_level ) THEN
407: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
408: END IF;
409: --bug 3199481 fnd logging changes: sdixit: end block
410:
411: CLOSE c1;

Line 427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);

423: ELSE
424: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
425: --bug 3199481 fnd logging changes: sdixit: start block
426: IF (l_error_level >= l_debug_level ) THEN
427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.lock_row',FALSE);
428: END IF;
429: --bug 3199481 fnd logging changes: sdixit: end block
430:
431: app_exception.raise_exception;

Line 478: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.update_row',FALSE);

474: ELSE
475: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
476: --bug 3199481 fnd logging changes: sdixit: start block
477: IF (l_error_level >= l_debug_level ) THEN
478: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexptb.IGI_EXP_DU_TYPE_DETAILS_PKG.update_row',FALSE);
479: END IF;
480: --bug 3199481 fnd logging changes: sdixit: end block
481:
482: app_exception.raise_exception;

Line 597: END igi_exp_du_type_details_pkg;

593:
594: END delete_row;
595:
596:
597: END igi_exp_du_type_details_pkg;