APPS.IGS_FI_ANC_RATES_PKG dependencies on IGS_FI_IMPCHGS_LINES

Line 134: SELECT 'x' FROM igs_fi_impchgs_lines i

130: cp_sequence_number IGS_FI_F_TYP_CA_INST_LKP_V.fee_ci_sequence_number%TYPE,
131: cp_fee_cal_type IGS_FI_F_TYP_CA_INST_LKP_V.fee_cal_type%TYPE,
132: cp_anc_chg_rate IGS_FI_ANC_RATES.ancillary_chg_rate%TYPE) IS
133:
134: SELECT 'x' FROM igs_fi_impchgs_lines i
135: WHERE (ancillary_attribute1 = cp_anc_att1 OR ( ancillary_attribute1 IS NULL AND cp_anc_att1 IS NULL)) AND
136: (ancillary_attribute2 = cp_anc_att2 OR ( ancillary_attribute2 IS NULL AND cp_anc_att2 IS NULL)) AND
137: (ancillary_attribute3 = cp_anc_att3 OR ( ancillary_attribute3 IS NULL AND cp_anc_att3 IS NULL)) AND
138: (ancillary_attribute4 = cp_anc_att4 OR ( ancillary_attribute4 IS NULL AND cp_anc_att4 IS NULL)) AND

Line 224: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMPCHGS_LINES_EXISTS');

220: FETCH cur_impchgs_lines INTO l_var;
221: IF cur_impchgs_lines%FOUND THEN
222: IF NOT l_bool THEN
223: CLOSE cur_impchgs_lines;
224: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMPCHGS_LINES_EXISTS');
225: --'Update of this record is not allowed since Ancillary Charges exist for these attributes and rate'
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;