DBA Data[Home] [Help]

APPS.IGI_EXP_TUS_PKG dependencies on IGI_EXP_TUS_PKG

Line 1: PACKAGE BODY igi_exp_tus_pkg AS

1: PACKAGE BODY igi_exp_tus_pkg AS
2: /* $Header: igiexpzb.pls 120.5.12000000.1 2007/09/13 04:25:30 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 82: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.set_column_values',FALSE);

78: CLOSE cur_old_ref_values;
79: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
80: --bug 3199481 fnd logging changes: sdixit: start block
81: IF (l_error_level >= l_debug_level ) THEN
82: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.set_column_values',FALSE);
83: END IF;
84: --bug 3199481 fnd logging changes: sdixit: end block
85: app_exception.raise_exception;
86: RETURN;

Line 157: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.check_parent_existance.msg1',FALSE);

153: ) THEN
154: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
155: --bug 3199481 fnd logging changes: sdixit: start block
156: IF (l_error_level >= l_debug_level ) THEN
157: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.check_parent_existance.msg1',FALSE);
158: END IF;
159: --bug 3199481 fnd logging changes: sdixit: end block
160: app_exception.raise_exception;
161: END IF;

Line 172: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.check_parent_existance.msg2',FALSE);

168: ) THEN
169: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
170: --bug 3199481 fnd logging changes: sdixit: start block
171: IF (l_error_level >= l_debug_level ) THEN
172: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.check_parent_existance.msg2',FALSE);
173: END IF;
174: --bug 3199481 fnd logging changes: sdixit: end block
175: app_exception.raise_exception;
176: END IF;

Line 262: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.get_fk_igi_exp_apprv_profiles',FALSE);

258: CLOSE cur_rowid;
259: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
260: --bug 3199481 fnd logging changes: sdixit: start block
261: IF (l_error_level >= l_debug_level ) THEN
262: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.get_fk_igi_exp_apprv_profiles',FALSE);
263: END IF;
264: --bug 3199481 fnd logging changes: sdixit: end block
265: app_exception.raise_exception;
266: RETURN;

Line 301: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.get_fk_igi_exp_tu_type_headers ',FALSE);

297: CLOSE cur_rowid;
298: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
299: --bug 3199481 fnd logging changes: sdixit: start block
300: IF (l_error_level >= l_debug_level ) THEN
301: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.get_fk_igi_exp_tu_type_headers ',FALSE);
302: END IF;
303: --bug 3199481 fnd logging changes: sdixit: end block
304: app_exception.raise_exception;
305: RETURN;

Line 409: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.before_dml.msg1',FALSE);

405: ) THEN
406: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
407: --bug 3199481 fnd logging changes: sdixit: start block
408: IF (l_error_level >= l_debug_level ) THEN
409: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.before_dml.msg1',FALSE);
410: END IF;
411: --bug 3199481 fnd logging changes: sdixit: end block
412: app_exception.raise_exception;
413: END IF;

Line 427: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.before_dml.msg2',FALSE);

423: ) THEN
424: fnd_message.set_name('IGI','IGI_EXP_DUP_ROW');
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.igiexpzb.IGI_EXP_TUS_PKG.before_dml.msg2',FALSE);
428: END IF;
429: --bug 3199481 fnd logging changes: sdixit: end block
430: app_exception.raise_exception;
431: END IF;

Line 507: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.insert_row',FALSE);

503: ELSE
504: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
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.igiexpzb.IGI_EXP_TUS_PKG.insert_row',FALSE);
508: END IF;
509: --bug 3199481 fnd logging changes: sdixit: end block
510: app_exception.raise_exception;
511: END IF;

Line 728: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.lock_row',FALSE);

724: IF (c1%notfound) THEN
725: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
726: --bug 3199481 fnd logging changes: sdixit: start block
727: IF (l_error_level >= l_debug_level ) THEN
728: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.lock_row',FALSE);
729: END IF;
730: --bug 3199481 fnd logging changes: sdixit: end block
731: CLOSE c1;
732: app_exception.raise_exception;

Line 772: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.lock_row',FALSE);

768: ELSE
769: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
770: --bug 3199481 fnd logging changes: sdixit: start block
771: IF (l_error_level >= l_debug_level ) THEN
772: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.lock_row',FALSE);
773: END IF;
774: --bug 3199481 fnd logging changes: sdixit: end block
775: app_exception.raise_exception;
776: END IF;

Line 847: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.update_row',FALSE);

843: ELSE
844: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
845: --bug 3199481 fnd logging changes: sdixit: start block
846: IF (l_error_level >= l_debug_level ) THEN
847: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpzb.IGI_EXP_TUS_PKG.update_row',FALSE);
848: END IF;
849: --bug 3199481 fnd logging changes: sdixit: end block
850: app_exception.raise_exception;
851: END IF;

Line 1112: END igi_exp_tus_pkg;

1108:
1109: END get_org_id ;
1110: */
1111:
1112: END igi_exp_tus_pkg;