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:
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
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:
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:
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:
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.
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;
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
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:
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:
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',