602:
603: END Check_Constraints;
604:
605: PROCEDURE Check_Parent_Existance IS
606: CURSOR c_gl_code_combinations_pk IS
607: SELECT 'X'
608: FROM GL_CODE_COMBINATIONS
609: WHERE code_combination_id = new_references.rec_gl_ccid;
610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;
604:
605: PROCEDURE Check_Parent_Existance IS
606: CURSOR c_gl_code_combinations_pk IS
607: SELECT 'X'
608: FROM GL_CODE_COMBINATIONS
609: WHERE code_combination_id = new_references.rec_gl_ccid;
610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;
611:
612: BEGIN
606: CURSOR c_gl_code_combinations_pk IS
607: SELECT 'X'
608: FROM GL_CODE_COMBINATIONS
609: WHERE code_combination_id = new_references.rec_gl_ccid;
610: l_ccid_temp c_gl_code_combinations_pk%ROWTYPE;
611:
612: BEGIN
613: IF (((old_references.fee_cal_type = new_references.fee_cal_type) AND
614: (old_references.fee_ci_sequence_number = new_references.fee_ci_sequence_number)) OR
772: (new_references.rec_gl_ccid IS NULL))
773: THEN
774: NULL;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
773: THEN
774: NULL;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
774: NULL;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
775: ELSE
776: OPEN c_gl_code_combinations_pk;
777: FETCH c_gl_code_combinations_pk INTO l_ccid_temp;
778: IF c_gl_code_combinations_pk%NOTFOUND THEN
779: CLOSE c_gl_code_combinations_pk;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF;
780: FND_MESSAGE.set_name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF;
784: IF c_gl_code_combinations_pk%ISOPEN THEN
785: CLOSE c_gl_code_combinations_pk;
786: END IF;
787: END IF;
788:
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF;
784: IF c_gl_code_combinations_pk%ISOPEN THEN
785: CLOSE c_gl_code_combinations_pk;
786: END IF;
787: END IF;
788:
789: -- Added by jbegum for bug #2113459