DBA Data[Home] [Help]

APPS.IGI_EXP_TUS_PKG dependencies on APP_EXCEPTION

Line 85: app_exception.raise_exception;

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;
87: END IF;
88: CLOSE cur_old_ref_values;
89:

Line 160: app_exception.raise_exception;

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;
162:
163: IF (((old_references.tu_type_header_id = new_references.tu_type_header_id)) OR
164: ((new_references.tu_type_header_id IS NULL))) THEN

Line 175: app_exception.raise_exception;

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;
177:
178: END check_parent_existance;
179:

Line 265: app_exception.raise_exception;

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;
267: END IF;
268: CLOSE cur_rowid;
269:

Line 304: app_exception.raise_exception;

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;
306: END IF;
307: CLOSE cur_rowid;
308:

Line 412: app_exception.raise_exception;

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;
414: check_parent_existance;
415: ELSIF (p_action = 'UPDATE') THEN
416: -- Call all the procedures related to Before Update.

Line 430: app_exception.raise_exception;

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;
432: END IF;
433:
434: END before_dml;

Line 510: app_exception.raise_exception;

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;
512:
513: SELECT igi_exp_tus_s1.NEXTVAL
514: INTO x_tu_id

Line 732: app_exception.raise_exception;

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;
733: RETURN;
734: END IF;
735: CLOSE c1;
736:

Line 775: app_exception.raise_exception;

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;
777:
778: RETURN;
779:

Line 850: app_exception.raise_exception;

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;
852:
853: before_dml(
854: p_action => 'UPDATE',