DBA Data[Home] [Help]

APPS.PAY_US_EXTRA_PER_INFO_LEG_HOOK dependencies on HR_UTILITY

Line 88: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');

84: and fetr.effective_start_date <=(select sysdate from dual)
85: and fetr.effective_end_date >=(select sysdate from dual);
86:
87: begin
88: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');
89:
90: l_person_id := P_PERSON_ID;
91: l_information_type := P_INFORMATION_TYPE;
92: l_pei_information_category := P_PEI_INFORMATION_CATEGORY;

Line 144: hr_utility.trace('Leaving PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');

140: fnd_message.raise_error;
141: end if; */
142: end if;
143:
144: hr_utility.trace('Leaving PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_create');
145:
146: end person_check_nra_status_create;
147:
148:

Line 235: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_update');

231:
232:
233:
234: begin
235: hr_utility.trace('Entering PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_update');
236:
237: l_person_extra_info_id := P_PERSON_EXTRA_INFO_ID;
238: l_pei_information_category := P_PEI_INFORMATION_CATEGORY;
239: l_pei_information1 := P_PEI_INFORMATION1; /*student status*/

Line 271: hr_utility.trace('l_person_id '||l_person_id);

267: fetch get_fitexempt_fed into l_fit_exempt;
268: close get_fitexempt_fed;
269:
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);

Line 272: hr_utility.trace('l_information_type '||l_information_type);

268: close get_fitexempt_fed;
269:
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);

Line 273: hr_utility.trace('l_assignment_id '||l_assignment_id);

269:
270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */

Line 274: hr_utility.trace('l_wa_fed '||l_wa_fed);

270: /*
271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
278:

Line 275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);

271: hr_utility.trace('l_person_id '||l_person_id);
272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
278:
279: /* if person is a student or a business appprentice his records are selected */

Line 276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);

272: hr_utility.trace('l_information_type '||l_information_type);
273: hr_utility.trace('l_assignment_id '||l_assignment_id);
274: hr_utility.trace('l_wa_fed '||l_wa_fed);
275: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
276: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
277: */
278:
279: /* if person is a student or a business appprentice his records are selected */
280: open csr_chk_student_status;

Line 313: hr_utility.trace('l_student_flag '||l_student_flag);

309: end if;
310: end if;
311:
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);

Line 314: hr_utility.trace('l_information_type '||l_information_type);

310: end if;
311:
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);

Line 315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);

311:
312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);

Line 316: hr_utility.trace('l_pei_information5 '||l_pei_information5);

312: /*
313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */

Line 317: hr_utility.trace('l_pei_information9 '||l_pei_information9);

313: hr_utility.trace('l_student_flag '||l_student_flag);
314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
321:

Line 318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);

314: hr_utility.trace('l_information_type '||l_information_type);
315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
321:
322: if l_information_type like 'PER_US_ADDITIONAL_DETAILS'

Line 319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);

315: hr_utility.trace('l_pei_information_category '||l_pei_information_category);
316: hr_utility.trace('l_pei_information5 '||l_pei_information5);
317: hr_utility.trace('l_pei_information9 '||l_pei_information9);
318: hr_utility.trace('l_filing_status_code '||l_filing_status_code);
319: hr_utility.trace('l_fit_exempt '||l_fit_exempt);
320: */
321:
322: if l_information_type like 'PER_US_ADDITIONAL_DETAILS'
323: and l_pei_information_category like 'PER_US_ADDITIONAL_DETAILS'

Line 345: hr_utility.trace('Leaving PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_update');

341: fnd_message.raise_error;
342: end if; */
343: end if;
344:
345: hr_utility.trace('Leaving PAY_US_EXTRA_PER_INFO_LEG_HOOK.person_check_nra_status_update');
346:
347: end person_check_nra_status_update;
348:
349: end PAY_US_EXTRA_PER_INFO_LEG_HOOK ;