109:
110: EXCEPTION
111:
112: WHEN OTHERS THEN
113: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
114: fnd_message.raise_error;
115:
116: END chk_scheme_prefix;
117:
110: EXCEPTION
111:
112: WHEN OTHERS THEN
113: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
114: fnd_message.raise_error;
115:
116: END chk_scheme_prefix;
117:
118: -- ---------------------------------------------------------------------
255: OPEN c_formula_id (replace(p_scheme_prefix,' ','_')||'_ER_CONTRIBUTION');
256: FETCH c_formula_id INTO l_er_formula_id;
257: IF c_formula_id%NOTFOUND THEN
258: CLOSE c_formula_id;
259: fnd_message.raise_error;
260: ELSE
261: CLOSE c_formula_id;
262: END IF;
263: hr_utility.set_location('..Fetched Formula ID', 51);
264: OPEN c_ele_id (p_scheme_prefix||' ER Contribution');
265: FETCH c_ele_id INTO l_er_ele_id;
266: IF c_ele_id%NOTFOUND THEN
267: CLOSE c_ele_id;
268: fnd_message.raise_error;
269: ELSE
270: CLOSE c_ele_id;
271: END IF;
272: hr_utility.set_location('..Fetched Element ID', 51);
273: OPEN c_status_proc_id (l_er_ele_id, l_er_formula_id);
274: FETCH c_status_proc_id INTO l_er_status_proc_rule_id;
275: IF c_status_proc_id%NOTFOUND THEN
276: CLOSE c_status_proc_id;
277: fnd_message.raise_error;
278: ELSE
279: CLOSE c_status_proc_id;
280: END IF;
281:
284: OPEN c_ele_id ('IE BIK PRSA ER Contribution');
285: FETCH c_ele_id INTO l_bik_er_ele_id;
286: IF c_ele_id%NOTFOUND THEN
287: CLOSE c_ele_id;
288: fnd_message.raise_error;
289: ELSE
290: CLOSE c_ele_id;
291: END IF;
292:
293: OPEN c_ip_val (l_bik_er_ele_id, 'Contribution Amount');
294: FETCH c_ip_val INTO l_bik_er_iv;
295: IF c_ip_val%NOTFOUND THEN
296: CLOSE c_ip_val;
297: fnd_message.raise_error;
298: ELSE
299: CLOSE c_ip_val;
300: END IF;
301:
325: OPEN c_ele_id ('IE BIK RAC ER Contribution');
326: FETCH c_ele_id INTO l_bik_er_ele_id;
327: IF c_ele_id%NOTFOUND THEN
328: CLOSE c_ele_id;
329: fnd_message.raise_error;
330: ELSE
331: CLOSE c_ele_id;
332: END IF;
333: OPEN c_ip_val (l_bik_er_ele_id, 'Contribution Amount');
333: OPEN c_ip_val (l_bik_er_ele_id, 'Contribution Amount');
334: FETCH c_ip_val INTO l_bik_er_iv;
335: IF c_ip_val%NOTFOUND THEN
336: CLOSE c_ip_val;
337: fnd_message.raise_error;
338: ELSE
339: CLOSE c_ip_val;
340: END IF;
341:
692: (p_legislation_code => g_template_leg_code);
693: OPEN csr_get_category (p_pension_type_id, p_effective_start_date);
694: FETCH csr_get_category INTO l_pension_category;
695: IF csr_get_category%NOTFOUND THEN
696: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
697: fnd_message.raise_error;
698: END IF;
699: CLOSE csr_get_category;
700: -- ---------------------------------------------------------------------
693: OPEN csr_get_category (p_pension_type_id, p_effective_start_date);
694: FETCH csr_get_category INTO l_pension_category;
695: IF csr_get_category%NOTFOUND THEN
696: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
697: fnd_message.raise_error;
698: END IF;
699: CLOSE csr_get_category;
700: -- ---------------------------------------------------------------------
701: -- Exclusion rules
713: ,c_effective_date => p_effective_start_date);
714: FETCH csr_pty1 INTO r_pty_rec;
715:
716: IF csr_pty1%notfound THEN
717: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
718: fnd_message.raise_error;
719: CLOSE csr_pty1;
720: ELSE
721:
714: FETCH csr_pty1 INTO r_pty_rec;
715:
716: IF csr_pty1%notfound THEN
717: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
718: fnd_message.raise_error;
719: CLOSE csr_pty1;
720: ELSE
721:
722: -- ---------------------------------------------------------------------
1040:
1041: OPEN csr_get_ee_bal_info (l_bal_name1);
1042: FETCH csr_get_ee_bal_info INTO l_seed_ee_bal_type_id;
1043: IF csr_get_ee_bal_info%NOTFOUND THEN
1044: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1045: fnd_message.raise_error;
1046: CLOSE csr_get_ee_bal_info;
1047: END IF;
1048: CLOSE csr_get_ee_bal_info;
1041: OPEN csr_get_ee_bal_info (l_bal_name1);
1042: FETCH csr_get_ee_bal_info INTO l_seed_ee_bal_type_id;
1043: IF csr_get_ee_bal_info%NOTFOUND THEN
1044: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1045: fnd_message.raise_error;
1046: CLOSE csr_get_ee_bal_info;
1047: END IF;
1048: CLOSE csr_get_ee_bal_info;
1049: IF l_pension_category <> 'RBSAVC' AND l_pension_category <> 'PRSAAVC' THEN
1049: IF l_pension_category <> 'RBSAVC' AND l_pension_category <> 'PRSAAVC' THEN
1050: OPEN csr_get_ee_bal_info (l_bal_name2);
1051: FETCH csr_get_ee_bal_info INTO l_seed_er_bal_type_id;
1052: IF csr_get_ee_bal_info%NOTFOUND THEN
1053: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1054: fnd_message.raise_error;
1055: CLOSE csr_get_ee_bal_info;
1056: END IF;
1057: CLOSE csr_get_ee_bal_info;
1050: OPEN csr_get_ee_bal_info (l_bal_name2);
1051: FETCH csr_get_ee_bal_info INTO l_seed_er_bal_type_id;
1052: IF csr_get_ee_bal_info%NOTFOUND THEN
1053: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1054: fnd_message.raise_error;
1055: CLOSE csr_get_ee_bal_info;
1056: END IF;
1057: CLOSE csr_get_ee_bal_info;
1058: END IF;