APPS.IGS_FI_ANC_RATES_PKG dependencies on IGS_FI_IMP_CHGS

Line 153: ( SELECT 'x' from igs_fi_imp_chgs c

149: (ancillary_attribute15 = cp_anc_att15 OR ( ancillary_attribute15 IS NULL AND cp_anc_att15 IS NULL)) AND
150: (transaction_amount = cp_anc_chg_rate)
151: AND
152: EXISTS
153: ( SELECT 'x' from igs_fi_imp_chgs c
154: WHERE fee_type = cp_fee_type AND
155: fee_ci_sequence_number = cp_sequence_number AND
156: fee_cal_type = cp_fee_cal_type AND
157: transaction_type = 'ANCILLARY' AND

Line 257: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMP_CHGS_EXISTS');

253: );
254: FETCH cur_impchgs_lines INTO l_var;
255: IF cur_impchgs_lines%FOUND THEN
256: CLOSE cur_impchgs_lines;
257: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMP_CHGS_EXISTS');
258: --'Deletion of this record is not allowed since Ancillary Charges exist for these attributes'
259: IGS_GE_MSG_STACK.ADD;
260: APP_EXCEPTION.RAISE_EXCEPTION;
261: END IF;