61: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.set_column_values',FALSE);
62: END IF;
63: --bug 3199481 fnd logging changes: sdixit: end block
64:
65: app_exception.raise_exception;
66: RETURN;
67: END IF;
68: CLOSE cur_old_ref_values;
69:
116: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.check_parent_existance',FALSE);
117: END IF;
118: --bug 3199481 fnd logging changes: sdixit: end block
119:
120: app_exception.raise_exception;
121: END IF;
122:
123: END check_parent_existance;
124:
208: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.get_fk_igi_exp_apprv_profiles',FALSE);
209: END IF;
210: --bug 3199481 fnd logging changes: sdixit: end block
211:
212: app_exception.raise_exception;
213: RETURN;
214: END IF;
215: CLOSE cur_rowid;
216:
275: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.before_dml.msg1',FALSE);
276: END IF;
277: --bug 3199481 fnd logging changes: sdixit: end block
278:
279: app_exception.raise_exception;
280: END IF;
281: check_parent_existance;
282: ELSIF (p_action = 'UPDATE') THEN
283: -- Call all the procedures related to Before Update.
297: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.before_dml.msg1',FALSE);
298: END IF;
299: --bug 3199481 fnd logging changes: sdixit: end block
300:
301: app_exception.raise_exception;
302: END IF;
303: ELSIF (p_action = 'VALIDATE_DELETE') THEN
304: check_child_existance;
305: END IF;
358: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.insert_row',FALSE);
359: END IF;
360: --bug 3199481 fnd logging changes: sdixit: end block
361:
362: app_exception.raise_exception;
363: END IF;
364:
365: SELECT igi_exp_tu_type_headers_s1.NEXTVAL
366: INTO x_tu_type_header_id
472: END IF;
473: --bug 3199481 fnd logging changes: sdixit: end block
474:
475: CLOSE c1;
476: app_exception.raise_exception;
477: RETURN;
478: END IF;
479: CLOSE c1;
480:
495: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.lock_row',FALSE);
496: END IF;
497: --bug 3199481 fnd logging changes: sdixit: end block
498:
499: app_exception.raise_exception;
500: END IF;
501:
502: RETURN;
503:
550: FND_LOG.MESSAGE (l_error_level , 'igi.plsql.igiexpub.IGI_EXP_TU_TYPE_HEADERS_PKG.update_row',FALSE);
551: END IF;
552: --bug 3199481 fnd logging changes: sdixit: end block
553:
554: app_exception.raise_exception;
555: END IF;
556:
557: before_dml(
558: p_action => 'UPDATE',