DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on FND_MESSAGE

Line 104: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');

100:
101: EXCEPTION
102:
103: WHEN OTHERS THEN
104: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
105: fnd_message.raise_error;
106:
107: END chk_scheme_prefix;
108:

Line 105: fnd_message.raise_error;

101: EXCEPTION
102:
103: WHEN OTHERS THEN
104: fnd_message.set_name('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
105: fnd_message.raise_error;
106:
107: END chk_scheme_prefix;
108:
109: -- ---------------------------------------------------------------------

Line 250: fnd_message.raise_error;

246: OPEN c_formula_id (replace(p_scheme_prefix,' ','_')||'_ER_CONTRIBUTION');
247: FETCH c_formula_id INTO l_er_formula_id;
248: IF c_formula_id%NOTFOUND THEN
249: CLOSE c_formula_id;
250: fnd_message.raise_error;
251: ELSE
252: CLOSE c_formula_id;
253: END IF;
254: hr_utility.set_location('..Fetched Formula ID', 51);

Line 259: fnd_message.raise_error;

255: OPEN c_ele_id (p_scheme_prefix||' ER Contribution');
256: FETCH c_ele_id INTO l_er_ele_id;
257: IF c_ele_id%NOTFOUND THEN
258: CLOSE c_ele_id;
259: fnd_message.raise_error;
260: ELSE
261: CLOSE c_ele_id;
262: END IF;
263: hr_utility.set_location('..Fetched Element ID', 51);

Line 268: fnd_message.raise_error;

264: OPEN c_status_proc_id (l_er_ele_id, l_er_formula_id);
265: FETCH c_status_proc_id INTO l_er_status_proc_rule_id;
266: IF c_status_proc_id%NOTFOUND THEN
267: CLOSE c_status_proc_id;
268: fnd_message.raise_error;
269: ELSE
270: CLOSE c_status_proc_id;
271: END IF;
272:

Line 279: fnd_message.raise_error;

275: OPEN c_ele_id ('IE BIK PRSA ER Contribution');
276: FETCH c_ele_id INTO l_bik_er_ele_id;
277: IF c_ele_id%NOTFOUND THEN
278: CLOSE c_ele_id;
279: fnd_message.raise_error;
280: ELSE
281: CLOSE c_ele_id;
282: END IF;
283:

Line 288: fnd_message.raise_error;

284: OPEN c_ip_val (l_bik_er_ele_id, 'Contribution Amount');
285: FETCH c_ip_val INTO l_bik_er_iv;
286: IF c_ip_val%NOTFOUND THEN
287: CLOSE c_ip_val;
288: fnd_message.raise_error;
289: ELSE
290: CLOSE c_ip_val;
291: END IF;
292:

Line 320: fnd_message.raise_error;

316: OPEN c_ele_id ('IE BIK RAC ER Contribution');
317: FETCH c_ele_id INTO l_bik_er_ele_id;
318: IF c_ele_id%NOTFOUND THEN
319: CLOSE c_ele_id;
320: fnd_message.raise_error;
321: ELSE
322: CLOSE c_ele_id;
323: END IF;
324: OPEN c_ip_val (l_bik_er_ele_id, 'Contribution Amount');

Line 328: fnd_message.raise_error;

324: OPEN c_ip_val (l_bik_er_ele_id, 'Contribution Amount');
325: FETCH c_ip_val INTO l_bik_er_iv;
326: IF c_ip_val%NOTFOUND THEN
327: CLOSE c_ip_val;
328: fnd_message.raise_error;
329: ELSE
330: CLOSE c_ip_val;
331: END IF;
332:

Line 687: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

683: (p_legislation_code => g_template_leg_code);
684: OPEN csr_get_category (p_pension_type_id, p_effective_start_date);
685: FETCH csr_get_category INTO l_pension_category;
686: IF csr_get_category%NOTFOUND THEN
687: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
688: fnd_message.raise_error;
689: END IF;
690: CLOSE csr_get_category;
691: -- ---------------------------------------------------------------------

Line 688: fnd_message.raise_error;

684: OPEN csr_get_category (p_pension_type_id, p_effective_start_date);
685: FETCH csr_get_category INTO l_pension_category;
686: IF csr_get_category%NOTFOUND THEN
687: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
688: fnd_message.raise_error;
689: END IF;
690: CLOSE csr_get_category;
691: -- ---------------------------------------------------------------------
692: -- Exclusion rules

Line 708: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');

704: ,c_effective_date => p_effective_start_date);
705: FETCH csr_pty1 INTO r_pty_rec;
706:
707: IF csr_pty1%notfound THEN
708: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
709: fnd_message.raise_error;
710: CLOSE csr_pty1;
711: ELSE
712:

Line 709: fnd_message.raise_error;

705: FETCH csr_pty1 INTO r_pty_rec;
706:
707: IF csr_pty1%notfound THEN
708: fnd_message.set_name('PQP', 'PQP_230805_INV_PENSIONID');
709: fnd_message.raise_error;
710: CLOSE csr_pty1;
711: ELSE
712:
713: -- ---------------------------------------------------------------------

Line 1035: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

1031:
1032: OPEN csr_get_ee_bal_info (l_bal_name1);
1033: FETCH csr_get_ee_bal_info INTO l_seed_ee_bal_type_id;
1034: IF csr_get_ee_bal_info%NOTFOUND THEN
1035: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1036: fnd_message.raise_error;
1037: CLOSE csr_get_ee_bal_info;
1038: END IF;
1039: CLOSE csr_get_ee_bal_info;

Line 1036: fnd_message.raise_error;

1032: OPEN csr_get_ee_bal_info (l_bal_name1);
1033: FETCH csr_get_ee_bal_info INTO l_seed_ee_bal_type_id;
1034: IF csr_get_ee_bal_info%NOTFOUND THEN
1035: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');
1036: fnd_message.raise_error;
1037: CLOSE csr_get_ee_bal_info;
1038: END IF;
1039: CLOSE csr_get_ee_bal_info;
1040: IF l_pension_category <> 'RBSAVC' AND l_pension_category <> 'PRSAAVC' THEN

Line 1044: fnd_message.set_name('PQP', 'PQP_230805_BAL_NOTFOUND');

1040: IF l_pension_category <> 'RBSAVC' AND l_pension_category <> 'PRSAAVC' THEN
1041: OPEN csr_get_ee_bal_info (l_bal_name2);
1042: FETCH csr_get_ee_bal_info INTO l_seed_er_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;

Line 1045: fnd_message.raise_error;

1041: OPEN csr_get_ee_bal_info (l_bal_name2);
1042: FETCH csr_get_ee_bal_info INTO l_seed_er_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: END IF;