DBA Data[Home] [Help]

APPS.PAY_IE_PENSION_TEMPLATE dependencies on FND_MESSAGE

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

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:

Line 114: fnd_message.raise_error;

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: -- ---------------------------------------------------------------------

Line 259: fnd_message.raise_error;

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);

Line 268: fnd_message.raise_error;

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);

Line 277: fnd_message.raise_error;

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:

Line 288: fnd_message.raise_error;

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:

Line 297: fnd_message.raise_error;

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:

Line 329: fnd_message.raise_error;

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');

Line 337: fnd_message.raise_error;

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:

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

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: -- ---------------------------------------------------------------------

Line 697: fnd_message.raise_error;

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

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

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:

Line 718: fnd_message.raise_error;

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: -- ---------------------------------------------------------------------

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

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;

Line 1045: fnd_message.raise_error;

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

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

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;

Line 1054: fnd_message.raise_error;

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;