1: PACKAGE BODY igs_or_gen_012_pkg AS
2: /* $Header: IGSOR12B.pls 120.3 2006/02/06 23:40:08 pkpatel ship $ */
3:
4: PROCEDURE create_organization (
5: p_institution_cd IN VARCHAR2,
297: EXCEPTION
298: WHEN OTHERS THEN
299: p_where_clause := NULL;
300: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
301: FND_MESSAGE.SET_TOKEN('NAME','igs_or_gen_012_pkg.get_where_clause'||'-'||SQLERRM);
302: APP_EXCEPTION.RAISE_EXCEPTION;
303: END get_where_clause;
304:
305:
351: EXCEPTION
352: WHEN OTHERS THEN
353: p_where_clause := NULL;
354: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
355: FND_MESSAGE.SET_TOKEN('NAME','igs_or_gen_012_pkg.get_where_clause_form'||'-'||SQLERRM);
356: APP_EXCEPTION.RAISE_EXCEPTION;
357: END get_where_clause_form;
358:
359:
405: EXCEPTION
406: WHEN OTHERS THEN
407: p_where_clause := NULL;
408: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
409: FND_MESSAGE.SET_TOKEN('NAME','igs_or_gen_012_pkg.get_where_clause_api'||'-'||SQLERRM);
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END get_where_clause_api;
412:
413: PROCEDURE get_where_clause_form1(
462: EXCEPTION
463: WHEN OTHERS THEN
464: p_where_clause := NULL;
465: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
466: FND_MESSAGE.SET_TOKEN('NAME','igs_or_gen_012_pkg.get_where_clause_form1'||'-'||SQLERRM);
467: APP_EXCEPTION.RAISE_EXCEPTION;
468: END get_where_clause_form1;
469:
470:
520: EXCEPTION
521: WHEN OTHERS THEN
522: p_where_clause := NULL;
523: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
524: FND_MESSAGE.SET_TOKEN('NAME','igs_or_gen_012_pkg.get_where_clause_api1'||'-'||SQLERRM);
525: APP_EXCEPTION.RAISE_EXCEPTION;
526: END get_where_clause_api1;
527:
528: END igs_or_gen_012_pkg;
524: FND_MESSAGE.SET_TOKEN('NAME','igs_or_gen_012_pkg.get_where_clause_api1'||'-'||SQLERRM);
525: APP_EXCEPTION.RAISE_EXCEPTION;
526: END get_where_clause_api1;
527:
528: END igs_or_gen_012_pkg;