DBA Data[Home] [Help]

APPS.PER_PL_UPDATE_PERSON dependencies on HR_UTILITY

Line 69: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

65: l_cwk := NULL;
66: per_business_group_id := NULL;
67: l_proc := 'PER_PL_UPDATE_PERSON.UPDATE_PL_PERSON';
68: /* Added for GSI Bug 5472781 */
69: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
70: hr_utility.set_location('Leaving : '||l_proc,10);
71: return;
72: END IF;
73:

Line 70: hr_utility.set_location('Leaving : '||l_proc,10);

66: per_business_group_id := NULL;
67: l_proc := 'PER_PL_UPDATE_PERSON.UPDATE_PL_PERSON';
68: /* Added for GSI Bug 5472781 */
69: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
70: hr_utility.set_location('Leaving : '||l_proc,10);
71: return;
72: END IF;
73:
74: identifier_chk := NULL;

Line 185: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');

181: fetch csr_payroll_id into assg_payroll_id;
182: close csr_payroll_id;
183:
184: /* if assg_payroll_id is not NULL and p_per_information1 is NULL then
185: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
186: hr_utility.raise_error;
187: end if;
188: Removing this check because according to latest requirement,
189: NIP is needed for an Payroll only if nationality and citizenship are both Polish.

Line 186: hr_utility.raise_error;

182: close csr_payroll_id;
183:
184: /* if assg_payroll_id is not NULL and p_per_information1 is NULL then
185: hr_utility.set_message(800,'HR_NIP_REQUIRED_PL');
186: hr_utility.raise_error;
187: end if;
188: Removing this check because according to latest requirement,
189: NIP is needed for an Payroll only if nationality and citizenship are both Polish.
190: If nationality and citizenship are Polish,we need to enter NIP by default.Hence no need for

Line 197: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');

193: */
194:
195: /*Phase2 4340576 Oldage pension rights is required to attach payroll to any assignment */
196: if assg_payroll_id is not NULL and p_per_information4 is null then
197: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
198: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
199: hr_utility.raise_error;
200: end if;
201: /* Tax office is required to attach payroll to any assignment*/

Line 198: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false

194:
195: /*Phase2 4340576 Oldage pension rights is required to attach payroll to any assignment */
196: if assg_payroll_id is not NULL and p_per_information4 is null then
197: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
198: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
199: hr_utility.raise_error;
200: end if;
201: /* Tax office is required to attach payroll to any assignment*/
202: if assg_payroll_id is not NULL and p_per_information6 is null then

Line 199: hr_utility.raise_error;

195: /*Phase2 4340576 Oldage pension rights is required to attach payroll to any assignment */
196: if assg_payroll_id is not NULL and p_per_information4 is null then
197: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
198: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','OLDAGE_PENSION_RIGHTS')); --default translate false
199: hr_utility.raise_error;
200: end if;
201: /* Tax office is required to attach payroll to any assignment*/
202: if assg_payroll_id is not NULL and p_per_information6 is null then
203: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');

Line 203: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');

199: hr_utility.raise_error;
200: end if;
201: /* Tax office is required to attach payroll to any assignment*/
202: if assg_payroll_id is not NULL and p_per_information6 is null then
203: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
204: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
205: hr_utility.raise_error;
206: end if;
207:

Line 204: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false

200: end if;
201: /* Tax office is required to attach payroll to any assignment*/
202: if assg_payroll_id is not NULL and p_per_information6 is null then
203: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
204: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
205: hr_utility.raise_error;
206: end if;
207:
208: elsif l_con = 'Y' then -- Person Type is Contact

Line 205: hr_utility.raise_error;

201: /* Tax office is required to attach payroll to any assignment*/
202: if assg_payroll_id is not NULL and p_per_information6 is null then
203: hr_utility.set_message(800,'HR_375855_DONOT_ATTACH_PAYROLL');
204: hr_utility.set_message_token ('TOKEN',hr_general.decode_lookup('PL_FORM_LABELS','TAX_OFFICE')); --default translate false
205: hr_utility.raise_error;
206: end if;
207:
208: elsif l_con = 'Y' then -- Person Type is Contact
209:

Line 217: hr_utility.set_message(800,'HR_375873_FIRST_NAME_REQD');

213: ) then
214:
215: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
216: if p_first_name is null then
217: hr_utility.set_message(800,'HR_375873_FIRST_NAME_REQD');
218: hr_utility.raise_error;
219: end if;
220:
221: --Citizenship Mandatory for contact if either insured by or inheritor is yes.

Line 218: hr_utility.raise_error;

214:
215: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
216: if p_first_name is null then
217: hr_utility.set_message(800,'HR_375873_FIRST_NAME_REQD');
218: hr_utility.raise_error;
219: end if;
220:
221: --Citizenship Mandatory for contact if either insured by or inheritor is yes.
222: hr_api.mandatory_arg_error

Line 237: hr_utility.set_message(800,'HR_375874_NIP_REQD');

233: ) then
234:
235: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
236: if p_per_information1 is null then
237: hr_utility.set_message(800,'HR_375874_NIP_REQD');
238: hr_utility.raise_error;
239: end if;
240:
241: end if; */

Line 238: hr_utility.raise_error;

234:
235: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
236: if p_per_information1 is null then
237: hr_utility.set_message(800,'HR_375874_NIP_REQD');
238: hr_utility.raise_error;
239: end if;
240:
241: end if; */
242:

Line 264: hr_utility.set_message(800,'HR_375878_NIP_OR_PESEL');

260: or ((p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) --NIP is null
261: and (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) --PESEL is null
262: )
263: )then
264: hr_utility.set_message(800,'HR_375878_NIP_OR_PESEL');
265: hr_utility.raise_error;
266:
267: end if; -- End if of Nationality and Citizenship is Polish
268: end if;--p_per_information8='PL' or p_nationality='PQH_PL'

Line 265: hr_utility.raise_error;

261: and (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) --PESEL is null
262: )
263: )then
264: hr_utility.set_message(800,'HR_375878_NIP_OR_PESEL');
265: hr_utility.raise_error;
266:
267: end if; -- End if of Nationality and Citizenship is Polish
268: end if;--p_per_information8='PL' or p_nationality='PQH_PL'
269: end if;--Insured by Employee is yes