eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_EYU dependencies on HR_UTILITY

Line 204: hr_utility.set_location('Entering : '||l_proc,1);

200:
201: l_addr_rec csr_address%rowtype;
202:
203: BEGIN
204: hr_utility.set_location('Entering : '||l_proc,1);
205: l_arch := true;
206:
207: OPEN csr_address;
208: FETCH csr_address INTO l_addr_rec;

Line 259: hr_utility.trace('line 1'||l_address_line1);

255: ELSE
256: l_addr_rec.post_code:= ' ';
257: END IF;
258:
259: hr_utility.trace('line 1'||l_address_line1);
260: hr_utility.trace('line 2'||l_address_line2);
261: hr_utility.trace('line 3'||l_address_line3);
262: hr_utility.trace('line 4'||l_address_line4);
263:

Line 260: hr_utility.trace('line 2'||l_address_line2);

256: l_addr_rec.post_code:= ' ';
257: END IF;
258:
259: hr_utility.trace('line 1'||l_address_line1);
260: hr_utility.trace('line 2'||l_address_line2);
261: hr_utility.trace('line 3'||l_address_line3);
262: hr_utility.trace('line 4'||l_address_line4);
263:
264: p_addr_rec.assignment_id := p_assignment_id;

Line 261: hr_utility.trace('line 3'||l_address_line3);

257: END IF;
258:
259: hr_utility.trace('line 1'||l_address_line1);
260: hr_utility.trace('line 2'||l_address_line2);
261: hr_utility.trace('line 3'||l_address_line3);
262: hr_utility.trace('line 4'||l_address_line4);
263:
264: p_addr_rec.assignment_id := p_assignment_id;
265: p_addr_rec.action_info_category := 'ADDRESS DETAILS';

Line 262: hr_utility.trace('line 4'||l_address_line4);

258:
259: hr_utility.trace('line 1'||l_address_line1);
260: hr_utility.trace('line 2'||l_address_line2);
261: hr_utility.trace('line 3'||l_address_line3);
262: hr_utility.trace('line 4'||l_address_line4);
263:
264: p_addr_rec.assignment_id := p_assignment_id;
265: p_addr_rec.action_info_category := 'ADDRESS DETAILS';
266: p_addr_rec.act_info5 := l_address_line1;

Line 272: hr_utility.set_location('Leaving: '||l_proc,999);

268: p_addr_rec.act_info7 := l_address_line3;
269: p_addr_rec.act_info8 := l_address_line4;
270: p_addr_rec.act_info12 := l_addr_rec.post_code;
271: p_addr_rec.act_info13 := l_addr_rec.country;
272: hr_utility.set_location('Leaving: '||l_proc,999);
273: RETURN l_arch;
274: END fetch_address_rec;
275:
276: /*

Line 323: hr_utility.set_location('Entering: '||l_proc,1);

319: where person_id = p_person_id
320: and effective_start_date <= p_effective_date;
321:
322: BEGIN
323: hr_utility.set_location('Entering: '||l_proc,1);
324: hr_utility.trace('p_effective_date in get_passport_number : ' || p_effective_date);
325:
326: open csr_per_start_date;
327: fetch csr_per_start_date into l_effective_date;

Line 324: hr_utility.trace('p_effective_date in get_passport_number : ' || p_effective_date);

320: and effective_start_date <= p_effective_date;
321:
322: BEGIN
323: hr_utility.set_location('Entering: '||l_proc,1);
324: hr_utility.trace('p_effective_date in get_passport_number : ' || p_effective_date);
325:
326: open csr_per_start_date;
327: fetch csr_per_start_date into l_effective_date;
328: close csr_per_start_date;

Line 330: hr_utility.trace('l_effective_date in get_oneoff_payment : ' || l_effective_date);

326: open csr_per_start_date;
327: fetch csr_per_start_date into l_effective_date;
328: close csr_per_start_date;
329:
330: hr_utility.trace('l_effective_date in get_oneoff_payment : ' || l_effective_date);
331: -- Use below API to get the config values for the given context in the business group
332: PQP_UTILITIES.get_config_type_values( p_configuration_type => 'PAY_GB_FPS_PASSPORT_NO' ,
333: p_business_group_id => p_bg_id ,
334: p_legislation_code => g_legislation_code ,

Line 342: hr_utility.set_location('l_source_name' || l_source_name,1);

338: l_source_name := l_config_values(l_config_values.FIRST).pcv_information1;
339: l_context_name := l_config_values(l_config_values.FIRST).pcv_information4;
340: l_column_name := l_config_values(l_config_values.FIRST).pcv_information5;
341: l_function_name := l_config_values(l_config_values.FIRST).pcv_information6;
342: hr_utility.set_location('l_source_name' || l_source_name,1);
343: hr_utility.set_location('l_context_name' || l_context_name,1);
344: hr_utility.set_location('l_column_name' || l_column_name,1);
345: hr_utility.set_location('l_function_name' || l_function_name,1);
346:

Line 343: hr_utility.set_location('l_context_name' || l_context_name,1);

339: l_context_name := l_config_values(l_config_values.FIRST).pcv_information4;
340: l_column_name := l_config_values(l_config_values.FIRST).pcv_information5;
341: l_function_name := l_config_values(l_config_values.FIRST).pcv_information6;
342: hr_utility.set_location('l_source_name' || l_source_name,1);
343: hr_utility.set_location('l_context_name' || l_context_name,1);
344: hr_utility.set_location('l_column_name' || l_column_name,1);
345: hr_utility.set_location('l_function_name' || l_function_name,1);
346:
347: /** The source can be either from Others--> Extra information of the person

Line 344: hr_utility.set_location('l_column_name' || l_column_name,1);

340: l_column_name := l_config_values(l_config_values.FIRST).pcv_information5;
341: l_function_name := l_config_values(l_config_values.FIRST).pcv_information6;
342: hr_utility.set_location('l_source_name' || l_source_name,1);
343: hr_utility.set_location('l_context_name' || l_context_name,1);
344: hr_utility.set_location('l_column_name' || l_column_name,1);
345: hr_utility.set_location('l_function_name' || l_function_name,1);
346:
347: /** The source can be either from Others--> Extra information of the person
348: or from the descriptive flex field on the person form.

Line 345: hr_utility.set_location('l_function_name' || l_function_name,1);

341: l_function_name := l_config_values(l_config_values.FIRST).pcv_information6;
342: hr_utility.set_location('l_source_name' || l_source_name,1);
343: hr_utility.set_location('l_context_name' || l_context_name,1);
344: hr_utility.set_location('l_column_name' || l_column_name,1);
345: hr_utility.set_location('l_function_name' || l_function_name,1);
346:
347: /** The source can be either from Others--> Extra information of the person
348: or from the descriptive flex field on the person form.
349: **/

Line 351: hr_utility.set_location('into Extra Person Info DDF',1);

347: /** The source can be either from Others--> Extra information of the person
348: or from the descriptive flex field on the person form.
349: **/
350: IF l_source_name = 'Extra Person Info DDF' THEN
351: hr_utility.set_location('into Extra Person Info DDF',1);
352: sqlstr := 'select ' || l_column_name ||
353: ' from per_people_extra_info where person_id = :p_person_id and PEI_INFORMATION_CATEGORY = :l_context_name';
354: hr_utility.set_location(sqlstr,1);
355: begin

Line 354: hr_utility.set_location(sqlstr,1);

350: IF l_source_name = 'Extra Person Info DDF' THEN
351: hr_utility.set_location('into Extra Person Info DDF',1);
352: sqlstr := 'select ' || l_column_name ||
353: ' from per_people_extra_info where person_id = :p_person_id and PEI_INFORMATION_CATEGORY = :l_context_name';
354: hr_utility.set_location(sqlstr,1);
355: begin
356: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name;
357: Exception
358: when others then

Line 359: hr_utility.set_location('Exception in extra info : ' || sqlerrm,1);

355: begin
356: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name;
357: Exception
358: when others then
359: hr_utility.set_location('Exception in extra info : ' || sqlerrm,1);
360: end;
361:
362: elsif l_source_name = 'PER_PEOPLE' THEN
363: hr_utility.set_location('into PER_PEOPLE',1);

Line 363: hr_utility.set_location('into PER_PEOPLE',1);

359: hr_utility.set_location('Exception in extra info : ' || sqlerrm,1);
360: end;
361:
362: elsif l_source_name = 'PER_PEOPLE' THEN
363: hr_utility.set_location('into PER_PEOPLE',1);
364: sqlstr := 'select ' || l_column_name ||
365: ' from per_all_people_f where person_id = :p_person_id and ATTRIBUTE_CATEGORY = :l_context_name' ||
366: ' and :l_effective_date between effective_start_date and effective_end_date' ;
367: hr_utility.trace(sqlstr);

Line 367: hr_utility.trace(sqlstr);

363: hr_utility.set_location('into PER_PEOPLE',1);
364: sqlstr := 'select ' || l_column_name ||
365: ' from per_all_people_f where person_id = :p_person_id and ATTRIBUTE_CATEGORY = :l_context_name' ||
366: ' and :l_effective_date between effective_start_date and effective_end_date' ;
367: hr_utility.trace(sqlstr);
368: begin
369: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name,l_effective_date;
370: exception
371: when others then

Line 372: hr_utility.trace('Exception in per_people: ' || sqlerrm);

368: begin
369: EXECUTE immediate sqlstr INTO l_passport_number USING p_person_id,l_context_name,l_effective_date;
370: exception
371: when others then
372: hr_utility.trace('Exception in per_people: ' || sqlerrm);
373: end;
374:
375: elsif l_source_name = 'Function' THEN
376:

Line 384: hr_utility.trace('l_package'||l_package);

380: FROM ff_functions
381: WHERE name = l_function_name
382: and business_group_id = p_bg_id;
383:
384: hr_utility.trace('l_package'||l_package);
385:
386: sqlstr :=
387: 'SELECT '
388: || l_package

Line 391: hr_utility.set_location(sqlstr,1);

387: 'SELECT '
388: || l_package
389: || ' (:p_person_id,:p_eff_date) '
390: || 'FROM DUAL';
391: hr_utility.set_location(sqlstr,1);
392: EXECUTE IMMEDIATE sqlstr into l_passport_number USING p_person_id,l_effective_date;
393: hr_utility.trace('Function value l_passport_number '||l_passport_number);
394: exception
395: WHEN OTHERS THEN

Line 393: hr_utility.trace('Function value l_passport_number '||l_passport_number);

389: || ' (:p_person_id,:p_eff_date) '
390: || 'FROM DUAL';
391: hr_utility.set_location(sqlstr,1);
392: EXECUTE IMMEDIATE sqlstr into l_passport_number USING p_person_id,l_effective_date;
393: hr_utility.trace('Function value l_passport_number '||l_passport_number);
394: exception
395: WHEN OTHERS THEN
396: hr_utility.trace('Exception in get_passport_number.Function.');
397: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );

Line 396: hr_utility.trace('Exception in get_passport_number.Function.');

392: EXECUTE IMMEDIATE sqlstr into l_passport_number USING p_person_id,l_effective_date;
393: hr_utility.trace('Function value l_passport_number '||l_passport_number);
394: exception
395: WHEN OTHERS THEN
396: hr_utility.trace('Exception in get_passport_number.Function.');
397: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
398: return null;
399: end;
400:

Line 397: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );

393: hr_utility.trace('Function value l_passport_number '||l_passport_number);
394: exception
395: WHEN OTHERS THEN
396: hr_utility.trace('Exception in get_passport_number.Function.');
397: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
398: return null;
399: end;
400:
401: END IF;

Line 409: hr_utility.set_location('l_passport_number: '||l_passport_number,1);

405: fetch csr_doc_of_rec into l_passport_number;
406: close csr_doc_of_rec;
407:
408: END IF;
409: hr_utility.set_location('l_passport_number: '||l_passport_number,1);
410: hr_utility.set_location('Leaving: '||l_proc,1);
411:
412: RETURN l_passport_number;
413:

Line 410: hr_utility.set_location('Leaving: '||l_proc,1);

406: close csr_doc_of_rec;
407:
408: END IF;
409: hr_utility.set_location('l_passport_number: '||l_passport_number,1);
410: hr_utility.set_location('Leaving: '||l_proc,1);
411:
412: RETURN l_passport_number;
413:
414: EXCEPTION

Line 486: hr_utility.set_location('Entering: '||l_proc,1);

482: AND EVIDENCE_STATUS = 'CURRENT';
483: l_person_rec csr_person_details%rowtype;
484:
485: BEGIN
486: hr_utility.set_location('Entering: '||l_proc,1);
487: l_arch := true;
488: hr_utility.trace('p_assactid : '||p_assactid);
489: hr_utility.trace('p_effective_date : '||TO_CHAR(p_effective_date));
490:

Line 488: hr_utility.trace('p_assactid : '||p_assactid);

484:
485: BEGIN
486: hr_utility.set_location('Entering: '||l_proc,1);
487: l_arch := true;
488: hr_utility.trace('p_assactid : '||p_assactid);
489: hr_utility.trace('p_effective_date : '||TO_CHAR(p_effective_date));
490:
491: OPEN csr_person_details;
492: FETCH csr_person_details INTO l_person_rec;

Line 489: hr_utility.trace('p_effective_date : '||TO_CHAR(p_effective_date));

485: BEGIN
486: hr_utility.set_location('Entering: '||l_proc,1);
487: l_arch := true;
488: hr_utility.trace('p_assactid : '||p_assactid);
489: hr_utility.trace('p_effective_date : '||TO_CHAR(p_effective_date));
490:
491: OPEN csr_person_details;
492: FETCH csr_person_details INTO l_person_rec;
493: CLOSE csr_person_details;

Line 521: hr_utility.set_location('Leaving: '||l_proc,999);

517: p_person_rec.act_info12 := l_partner_surname;
518: p_person_rec.act_info13 := l_partner_first_name;
519: p_person_rec.act_info14 := l_partner_second_name;
520: p_person_rec.act_info15 := l_partner_ni;
521: hr_utility.set_location('Leaving: '||l_proc,999);
522: RETURN l_arch;
523: END fetch_person_rec;
524: --
525:

Line 687: hr_utility.set_location('Entering: '||l_proc,1);

683: l_paye_rr_id number;
684: l_paye_details_rr_id number;
685:
686: BEGIN
687: hr_utility.set_location('Entering: '||l_proc,1);
688: l_arch := true;
689:
690:
691: hr_utility.trace('Start Year: '||TO_CHAR(g_start_year));

Line 691: hr_utility.trace('Start Year: '||TO_CHAR(g_start_year));

687: hr_utility.set_location('Entering: '||l_proc,1);
688: l_arch := true;
689:
690:
691: hr_utility.trace('Start Year: '||TO_CHAR(g_start_year));
692: hr_utility.trace('End Year: '||TO_CHAR(g_end_year));
693: hr_utility.trace('Calling csr_get_starter_details');
694: hr_utility.trace('p_person_rec.assignment_id: '||p_person_rec.assignment_id);
695:

Line 692: hr_utility.trace('End Year: '||TO_CHAR(g_end_year));

688: l_arch := true;
689:
690:
691: hr_utility.trace('Start Year: '||TO_CHAR(g_start_year));
692: hr_utility.trace('End Year: '||TO_CHAR(g_end_year));
693: hr_utility.trace('Calling csr_get_starter_details');
694: hr_utility.trace('p_person_rec.assignment_id: '||p_person_rec.assignment_id);
695:
696: OPEN csr_get_starter_details(p_person_rec.assignment_id);

Line 693: hr_utility.trace('Calling csr_get_starter_details');

689:
690:
691: hr_utility.trace('Start Year: '||TO_CHAR(g_start_year));
692: hr_utility.trace('End Year: '||TO_CHAR(g_end_year));
693: hr_utility.trace('Calling csr_get_starter_details');
694: hr_utility.trace('p_person_rec.assignment_id: '||p_person_rec.assignment_id);
695:
696: OPEN csr_get_starter_details(p_person_rec.assignment_id);
697: FETCH csr_get_starter_details INTO l_starter_rec;

Line 694: hr_utility.trace('p_person_rec.assignment_id: '||p_person_rec.assignment_id);

690:
691: hr_utility.trace('Start Year: '||TO_CHAR(g_start_year));
692: hr_utility.trace('End Year: '||TO_CHAR(g_end_year));
693: hr_utility.trace('Calling csr_get_starter_details');
694: hr_utility.trace('p_person_rec.assignment_id: '||p_person_rec.assignment_id);
695:
696: OPEN csr_get_starter_details(p_person_rec.assignment_id);
697: FETCH csr_get_starter_details INTO l_starter_rec;
698: CLOSE csr_get_starter_details;

Line 704: hr_utility.trace('Calling csr_get_starter_details1');

700: l_starter_decl := NULL;
701: l_continue_with_student_loan := NULL;
702: l_starter_flag := l_starter_rec.starter_flag;
703: g_reset_flag_type := NULL;
704: hr_utility.trace('Calling csr_get_starter_details1');
705: hr_utility.trace('l_starter_flag: '||l_starter_flag);
706: hr_utility.trace('l_starter_rec.starter_decl: '||l_starter_rec.starter_decl);
707: hr_utility.trace(' l_starter_rec.continue_with_student_loan: '|| l_starter_rec.continue_with_student_loan);
708:

Line 705: hr_utility.trace('l_starter_flag: '||l_starter_flag);

701: l_continue_with_student_loan := NULL;
702: l_starter_flag := l_starter_rec.starter_flag;
703: g_reset_flag_type := NULL;
704: hr_utility.trace('Calling csr_get_starter_details1');
705: hr_utility.trace('l_starter_flag: '||l_starter_flag);
706: hr_utility.trace('l_starter_rec.starter_decl: '||l_starter_rec.starter_decl);
707: hr_utility.trace(' l_starter_rec.continue_with_student_loan: '|| l_starter_rec.continue_with_student_loan);
708:
709: IF (l_starter_flag = 'N'

Line 706: hr_utility.trace('l_starter_rec.starter_decl: '||l_starter_rec.starter_decl);

702: l_starter_flag := l_starter_rec.starter_flag;
703: g_reset_flag_type := NULL;
704: hr_utility.trace('Calling csr_get_starter_details1');
705: hr_utility.trace('l_starter_flag: '||l_starter_flag);
706: hr_utility.trace('l_starter_rec.starter_decl: '||l_starter_rec.starter_decl);
707: hr_utility.trace(' l_starter_rec.continue_with_student_loan: '|| l_starter_rec.continue_with_student_loan);
708:
709: IF (l_starter_flag = 'N'
710: AND (l_starter_rec.starter_decl IS NOT NULL

Line 707: hr_utility.trace(' l_starter_rec.continue_with_student_loan: '|| l_starter_rec.continue_with_student_loan);

703: g_reset_flag_type := NULL;
704: hr_utility.trace('Calling csr_get_starter_details1');
705: hr_utility.trace('l_starter_flag: '||l_starter_flag);
706: hr_utility.trace('l_starter_rec.starter_decl: '||l_starter_rec.starter_decl);
707: hr_utility.trace(' l_starter_rec.continue_with_student_loan: '|| l_starter_rec.continue_with_student_loan);
708:
709: IF (l_starter_flag = 'N'
710: AND (l_starter_rec.starter_decl IS NOT NULL
711: OR NVL(l_starter_rec.continue_with_student_loan,'N') = 'Y' )) THEN

Line 712: hr_utility.trace('Calling csr_get_starter_details2');

708:
709: IF (l_starter_flag = 'N'
710: AND (l_starter_rec.starter_decl IS NOT NULL
711: OR NVL(l_starter_rec.continue_with_student_loan,'N') = 'Y' )) THEN
712: hr_utility.trace('Calling csr_get_starter_details2');
713: l_starter_decl := l_starter_rec.starter_decl;
714: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
715: l_ovn := l_starter_rec.object_version_number;
716: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

Line 723: hr_utility.trace('Calling csr_get_starter_details3');

719: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
720: p_aei_information8 => 'Y');
721: g_reset_flag_type := 'STARTER';
722: l_rti_sent_flag := 'STARTER';
723: hr_utility.trace('Calling csr_get_starter_details3');
724: END IF;
725: ---
726: hr_utility.trace('Calling csr_get_pensioner_details');
727:

Line 726: hr_utility.trace('Calling csr_get_pensioner_details');

722: l_rti_sent_flag := 'STARTER';
723: hr_utility.trace('Calling csr_get_starter_details3');
724: END IF;
725: ---
726: hr_utility.trace('Calling csr_get_pensioner_details');
727:
728: OPEN csr_get_pensioner_details(p_person_rec.assignment_id);
729: FETCH csr_get_pensioner_details INTO l_pensioner_rec;
730: CLOSE csr_get_pensioner_details;

Line 737: hr_utility.trace('l_pensioner_flag: '||l_pensioner_flag);

733: l_pensioner_flag := l_pensioner_rec.pensioner_flag;
734: l_annual_pension := NULL;
735: g_reset_flag_type := NULL;
736:
737: hr_utility.trace('l_pensioner_flag: '||l_pensioner_flag);
738: hr_utility.trace('l_pensioner_rec.pensioner_flag: '||l_pensioner_rec.pensioner_flag);
739: hr_utility.trace('l_pensioner_rec.recently_bereaved: '||l_pensioner_rec.recently_bereaved);
740: hr_utility.trace('l_pensioner_rec.annual_pension: '||l_pensioner_rec.annual_pension);
741:

Line 738: hr_utility.trace('l_pensioner_rec.pensioner_flag: '||l_pensioner_rec.pensioner_flag);

734: l_annual_pension := NULL;
735: g_reset_flag_type := NULL;
736:
737: hr_utility.trace('l_pensioner_flag: '||l_pensioner_flag);
738: hr_utility.trace('l_pensioner_rec.pensioner_flag: '||l_pensioner_rec.pensioner_flag);
739: hr_utility.trace('l_pensioner_rec.recently_bereaved: '||l_pensioner_rec.recently_bereaved);
740: hr_utility.trace('l_pensioner_rec.annual_pension: '||l_pensioner_rec.annual_pension);
741:
742: IF (l_pensioner_flag = 'N'

Line 739: hr_utility.trace('l_pensioner_rec.recently_bereaved: '||l_pensioner_rec.recently_bereaved);

735: g_reset_flag_type := NULL;
736:
737: hr_utility.trace('l_pensioner_flag: '||l_pensioner_flag);
738: hr_utility.trace('l_pensioner_rec.pensioner_flag: '||l_pensioner_rec.pensioner_flag);
739: hr_utility.trace('l_pensioner_rec.recently_bereaved: '||l_pensioner_rec.recently_bereaved);
740: hr_utility.trace('l_pensioner_rec.annual_pension: '||l_pensioner_rec.annual_pension);
741:
742: IF (l_pensioner_flag = 'N'
743: AND ( NVL(l_pensioner_rec.recently_bereaved,'N') = 'Y'

Line 740: hr_utility.trace('l_pensioner_rec.annual_pension: '||l_pensioner_rec.annual_pension);

736:
737: hr_utility.trace('l_pensioner_flag: '||l_pensioner_flag);
738: hr_utility.trace('l_pensioner_rec.pensioner_flag: '||l_pensioner_rec.pensioner_flag);
739: hr_utility.trace('l_pensioner_rec.recently_bereaved: '||l_pensioner_rec.recently_bereaved);
740: hr_utility.trace('l_pensioner_rec.annual_pension: '||l_pensioner_rec.annual_pension);
741:
742: IF (l_pensioner_flag = 'N'
743: AND ( NVL(l_pensioner_rec.recently_bereaved,'N') = 'Y'
744: OR l_pensioner_rec.annual_pension IS NOT NULL)) THEN

Line 759: hr_utility.trace('Calling csr_get_expat_details');

755: l_rti_sent_flag := 'PENSIONER';
756: g_reset_flag_type := 'PENSIONER';
757: END IF;
758: ---
759: hr_utility.trace('Calling csr_get_expat_details');
760:
761: OPEN csr_get_expat_details(p_person_rec.assignment_id);
762: FETCH csr_get_expat_details INTO l_expat_rec;
763: CLOSE csr_get_expat_details;

Line 772: hr_utility.trace('Calling csr_get_expat_details1');

768: l_stay_less_6_months := NULL;
769: l_working_in_out_UK := NULL;
770: l_expat_flag := l_expat_rec.expat_flag;
771:
772: hr_utility.trace('Calling csr_get_expat_details1');
773: hr_utility.trace('l_expat_flag: '||l_expat_flag);
774: hr_utility.trace('l_expat_rec.eea_cw_citizen: '||l_expat_rec.eea_cw_citizen);
775: hr_utility.trace(' l_expat_rec.epm6_scheme: '|| l_expat_rec.epm6_scheme);
776: hr_utility.trace(' l_expat_rec.expat_statement: '|| l_expat_rec.expat_statement);

Line 773: hr_utility.trace('l_expat_flag: '||l_expat_flag);

769: l_working_in_out_UK := NULL;
770: l_expat_flag := l_expat_rec.expat_flag;
771:
772: hr_utility.trace('Calling csr_get_expat_details1');
773: hr_utility.trace('l_expat_flag: '||l_expat_flag);
774: hr_utility.trace('l_expat_rec.eea_cw_citizen: '||l_expat_rec.eea_cw_citizen);
775: hr_utility.trace(' l_expat_rec.epm6_scheme: '|| l_expat_rec.epm6_scheme);
776: hr_utility.trace(' l_expat_rec.expat_statement: '|| l_expat_rec.expat_statement);
777:

Line 774: hr_utility.trace('l_expat_rec.eea_cw_citizen: '||l_expat_rec.eea_cw_citizen);

770: l_expat_flag := l_expat_rec.expat_flag;
771:
772: hr_utility.trace('Calling csr_get_expat_details1');
773: hr_utility.trace('l_expat_flag: '||l_expat_flag);
774: hr_utility.trace('l_expat_rec.eea_cw_citizen: '||l_expat_rec.eea_cw_citizen);
775: hr_utility.trace(' l_expat_rec.epm6_scheme: '|| l_expat_rec.epm6_scheme);
776: hr_utility.trace(' l_expat_rec.expat_statement: '|| l_expat_rec.expat_statement);
777:
778: g_reset_flag_type := NULL;

Line 775: hr_utility.trace(' l_expat_rec.epm6_scheme: '|| l_expat_rec.epm6_scheme);

771:
772: hr_utility.trace('Calling csr_get_expat_details1');
773: hr_utility.trace('l_expat_flag: '||l_expat_flag);
774: hr_utility.trace('l_expat_rec.eea_cw_citizen: '||l_expat_rec.eea_cw_citizen);
775: hr_utility.trace(' l_expat_rec.epm6_scheme: '|| l_expat_rec.epm6_scheme);
776: hr_utility.trace(' l_expat_rec.expat_statement: '|| l_expat_rec.expat_statement);
777:
778: g_reset_flag_type := NULL;
779:

Line 776: hr_utility.trace(' l_expat_rec.expat_statement: '|| l_expat_rec.expat_statement);

772: hr_utility.trace('Calling csr_get_expat_details1');
773: hr_utility.trace('l_expat_flag: '||l_expat_flag);
774: hr_utility.trace('l_expat_rec.eea_cw_citizen: '||l_expat_rec.eea_cw_citizen);
775: hr_utility.trace(' l_expat_rec.epm6_scheme: '|| l_expat_rec.epm6_scheme);
776: hr_utility.trace(' l_expat_rec.expat_statement: '|| l_expat_rec.expat_statement);
777:
778: g_reset_flag_type := NULL;
779:
780: IF (l_expat_flag = 'N'

Line 784: hr_utility.trace('Calling csr_get_expat_details2');

780: IF (l_expat_flag = 'N'
781: AND ( NVL(l_expat_rec.eea_cw_citizen,'N') = 'Y'
782: OR NVL(l_expat_rec.epm6_scheme,'N') = 'Y'
783: OR l_expat_rec.expat_statement IS NOT NULL)) THEN
784: hr_utility.trace('Calling csr_get_expat_details2');
785: IF l_expat_rec.expat_statement = 'A' THEN
786: l_stay_over_6_months := 'Y';
787: elsif l_expat_rec.expat_statement = 'B' THEN
788: l_stay_less_6_months := 'Y';

Line 793: hr_utility.trace('Calling csr_get_expat_details3');

789: elsif l_expat_rec.expat_statement = 'C' THEN
790: l_working_in_out_UK := 'Y';
791: END IF;
792:
793: hr_utility.trace('Calling csr_get_expat_details3');
794: --l_starter_decl := l_expat_rec.expat_statement;
795: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
796: l_epm6_scheme := l_expat_rec.epm6_scheme;
797: l_ovn := l_expat_rec.object_version_number;

Line 828: hr_utility.trace('l_asg_eff_start_date : '||l_asg_eff_start_date);

824: OR NVL(l_expat_rec.eea_cw_citizen,'N') = 'Y'
825: OR NVL(l_expat_rec.epm6_scheme,'N') = 'Y')
826: AND l_expat_rec.expat_flag = 'N') THEN
827:
828: hr_utility.trace('l_asg_eff_start_date : '||l_asg_eff_start_date);
829:
830: if(l_min_active_start_date >= g_start_year) then
831: l_asg_eff_start_date := l_min_active_start_date;
832: hr_utility.trace('l_asg_eff_start_date assigned: '||l_asg_eff_start_date);

Line 832: hr_utility.trace('l_asg_eff_start_date assigned: '||l_asg_eff_start_date);

828: hr_utility.trace('l_asg_eff_start_date : '||l_asg_eff_start_date);
829:
830: if(l_min_active_start_date >= g_start_year) then
831: l_asg_eff_start_date := l_min_active_start_date;
832: hr_utility.trace('l_asg_eff_start_date assigned: '||l_asg_eff_start_date);
833: end if;
834:
835: ELSE
836: l_asg_eff_start_date := NULL;

Line 837: hr_utility.trace('l_asg_eff_start_date'||l_asg_eff_start_date);

833: end if;
834:
835: ELSE
836: l_asg_eff_start_date := NULL;
837: hr_utility.trace('l_asg_eff_start_date'||l_asg_eff_start_date);
838: END IF;
839: END IF;
840:
841: --Fetch RTI Payroll id .

Line 846: hr_utility.trace('l_asg_number : '|| l_asg_number);

842: open csr_fetch_asg_num;
843: fetch csr_fetch_asg_num into l_asg_number;
844: close csr_fetch_asg_num;
845:
846: hr_utility.trace('l_asg_number : '|| l_asg_number);
847:
848: open csr_terminated_date;
849: fetch csr_terminated_date into l_person_actual_term_date;
850: close csr_terminated_date;

Line 852: hr_utility.trace('l_person_actual_term_date : '|| l_person_actual_term_date);

848: open csr_terminated_date;
849: fetch csr_terminated_date into l_person_actual_term_date;
850: close csr_terminated_date;
851:
852: hr_utility.trace('l_person_actual_term_date : '|| l_person_actual_term_date);
853:
854: l_date_of_leaving := l_person_actual_term_date;
855:
856: hr_utility.trace('l_date_of_leaving : '|| l_date_of_leaving);

Line 856: hr_utility.trace('l_date_of_leaving : '|| l_date_of_leaving);

852: hr_utility.trace('l_person_actual_term_date : '|| l_person_actual_term_date);
853:
854: l_date_of_leaving := l_person_actual_term_date;
855:
856: hr_utility.trace('l_date_of_leaving : '|| l_date_of_leaving);
857: hr_utility.trace('l_starter_decl : '|| l_starter_decl);
858: hr_utility.trace('l_asg_eff_start_date : '|| l_asg_eff_start_date);
859: ---
860:

Line 857: hr_utility.trace('l_starter_decl : '|| l_starter_decl);

853:
854: l_date_of_leaving := l_person_actual_term_date;
855:
856: hr_utility.trace('l_date_of_leaving : '|| l_date_of_leaving);
857: hr_utility.trace('l_starter_decl : '|| l_starter_decl);
858: hr_utility.trace('l_asg_eff_start_date : '|| l_asg_eff_start_date);
859: ---
860:
861: hr_utility.trace('g_paye_details_id : '|| g_paye_details_id);

Line 858: hr_utility.trace('l_asg_eff_start_date : '|| l_asg_eff_start_date);

854: l_date_of_leaving := l_person_actual_term_date;
855:
856: hr_utility.trace('l_date_of_leaving : '|| l_date_of_leaving);
857: hr_utility.trace('l_starter_decl : '|| l_starter_decl);
858: hr_utility.trace('l_asg_eff_start_date : '|| l_asg_eff_start_date);
859: ---
860:
861: hr_utility.trace('g_paye_details_id : '|| g_paye_details_id);
862: hr_utility.trace('g_paye_element_id : '|| g_paye_element_id);

Line 861: hr_utility.trace('g_paye_details_id : '|| g_paye_details_id);

857: hr_utility.trace('l_starter_decl : '|| l_starter_decl);
858: hr_utility.trace('l_asg_eff_start_date : '|| l_asg_eff_start_date);
859: ---
860:
861: hr_utility.trace('g_paye_details_id : '|| g_paye_details_id);
862: hr_utility.trace('g_paye_element_id : '|| g_paye_element_id);
863:
864:
865: open csr_max_run_result(p_last_asg_action_id,g_paye_element_id);

Line 862: hr_utility.trace('g_paye_element_id : '|| g_paye_element_id);

858: hr_utility.trace('l_asg_eff_start_date : '|| l_asg_eff_start_date);
859: ---
860:
861: hr_utility.trace('g_paye_details_id : '|| g_paye_details_id);
862: hr_utility.trace('g_paye_element_id : '|| g_paye_element_id);
863:
864:
865: open csr_max_run_result(p_last_asg_action_id,g_paye_element_id);
866: fetch csr_max_run_result into l_paye_rr_id;

Line 869: hr_utility.trace('Fetching run result : '||l_paye_rr_id);

865: open csr_max_run_result(p_last_asg_action_id,g_paye_element_id);
866: fetch csr_max_run_result into l_paye_rr_id;
867: close csr_max_run_result;
868:
869: hr_utility.trace('Fetching run result : '||l_paye_rr_id);
870: -- First we try to fetch it from the latest PAYE run results
871: open csr_run_result(l_paye_rr_id, g_paye_element_id);
872: fetch csr_run_result into l_tax_code,l_tax_basis;
873: close csr_run_result;

Line 882: hr_utility.trace('l_tax_code : '|| l_tax_code);

878: INTO l_tax_code,
879: l_tax_basis;
880: close csr_paye_details;
881: end if;
882: hr_utility.trace('l_tax_code : '|| l_tax_code);
883: hr_utility.trace('l_tax_basis : '|| l_tax_basis);
884: hr_utility.trace('l_rti_sent_flag : '|| l_rti_sent_flag);
885:
886: hr_utility.trace('Assigning values');

Line 883: hr_utility.trace('l_tax_basis : '|| l_tax_basis);

879: l_tax_basis;
880: close csr_paye_details;
881: end if;
882: hr_utility.trace('l_tax_code : '|| l_tax_code);
883: hr_utility.trace('l_tax_basis : '|| l_tax_basis);
884: hr_utility.trace('l_rti_sent_flag : '|| l_rti_sent_flag);
885:
886: hr_utility.trace('Assigning values');
887:

Line 884: hr_utility.trace('l_rti_sent_flag : '|| l_rti_sent_flag);

880: close csr_paye_details;
881: end if;
882: hr_utility.trace('l_tax_code : '|| l_tax_code);
883: hr_utility.trace('l_tax_basis : '|| l_tax_basis);
884: hr_utility.trace('l_rti_sent_flag : '|| l_rti_sent_flag);
885:
886: hr_utility.trace('Assigning values');
887:
888: p_fps_rec1.assignment_id := p_person_rec.assignment_id;

Line 886: hr_utility.trace('Assigning values');

882: hr_utility.trace('l_tax_code : '|| l_tax_code);
883: hr_utility.trace('l_tax_basis : '|| l_tax_basis);
884: hr_utility.trace('l_rti_sent_flag : '|| l_rti_sent_flag);
885:
886: hr_utility.trace('Assigning values');
887:
888: p_fps_rec1.assignment_id := p_person_rec.assignment_id;
889: p_fps_rec1.action_info_category := 'GB_RTI_EYU_ASG_DET';
890: p_fps_rec1.act_info1 := to_char(l_asg_eff_start_date,'YYYY-MM-DD');

Line 906: hr_utility.set_location('Leaving: '||l_proc,999);

902: p_fps_rec1.act_info13 := l_tax_code;
903: p_fps_rec1.act_info14 := l_tax_basis;
904:
905:
906: hr_utility.set_location('Leaving: '||l_proc,999);
907: RETURN l_arch;
908:
909: EXCEPTION
910: WHEN OTHERS THEN

Line 911: hr_utility.set_location('Error in function fetch_fps_asg_det1 ', 15);

907: RETURN l_arch;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: hr_utility.set_location('Error in function fetch_fps_asg_det1 ', 15);
912: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
913: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
914: RAISE;
915: END fetch_asg_det1;

Line 912: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );

908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: hr_utility.set_location('Error in function fetch_fps_asg_det1 ', 15);
912: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
913: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
914: RAISE;
915: END fetch_asg_det1;
916: --

Line 973: hr_utility.set_location('Entering: '||l_proc,1);

969: is
970: select hr_dirbal.get_balance(p_last_asg_action_id,l_tax_pay_def_bal_id) from dual;
971:
972: BEGIN
973: hr_utility.set_location('Entering: '||l_proc,1);
974: l_context_lst(1).tax_unit_id :=NULL;
975: l_context_lst(1).jurisdiction_code :=NULL;
976: l_context_lst(1).source_id :=NULL;
977: l_context_lst(1).source_text :=NULL;

Line 985: hr_utility.set_location('assignment_id :' || p_asg_id,15);

981: l_context_lst(1).balance_date :=NULL;
982: l_context_lst(1).local_unit_id :=NULL;
983: l_context_lst(1).source_number2 :=NULL;
984: l_context_lst(1).organization_id :=NULL;
985: hr_utility.set_location('assignment_id :' || p_asg_id,15);
986: l_asg_primary_flag := 'N';
987: l_per_agg_flag := 'N';
988: l_aggr_archive_flag := 'N';
989:

Line 995: hr_utility.set_location('p_last_asg_action_id :' || p_last_asg_action_id,15);

991: FETCH csr_asg INTO l_asg_primary_flag, l_per_agg_flag;
992: CLOSE csr_asg;
993:
994:
995: hr_utility.set_location('p_last_asg_action_id :' || p_last_asg_action_id,15);
996: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
997: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
998:
999: IF NVL(l_per_agg_flag,'N') = 'Y' THEN

Line 996: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);

992: CLOSE csr_asg;
993:
994:
995: hr_utility.set_location('p_last_asg_action_id :' || p_last_asg_action_id,15);
996: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
997: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
998:
999: IF NVL(l_per_agg_flag,'N') = 'Y' THEN
1000: hr_utility.trace('Aggregation Found.');

Line 997: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);

993:
994:
995: hr_utility.set_location('p_last_asg_action_id :' || p_last_asg_action_id,15);
996: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
997: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
998:
999: IF NVL(l_per_agg_flag,'N') = 'Y' THEN
1000: hr_utility.trace('Aggregation Found.');
1001: l_aggr_archive_flag := 'Y';

Line 1000: hr_utility.trace('Aggregation Found.');

996: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
997: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
998:
999: IF NVL(l_per_agg_flag,'N') = 'Y' THEN
1000: hr_utility.trace('Aggregation Found.');
1001: l_aggr_archive_flag := 'Y';
1002: l_ytd_dim := '_PER_TD_YTD';
1003: END IF;
1004: hr_utility.set_location('l_aggr_archive_flag :' || l_aggr_archive_flag,15);

Line 1004: hr_utility.set_location('l_aggr_archive_flag :' || l_aggr_archive_flag,15);

1000: hr_utility.trace('Aggregation Found.');
1001: l_aggr_archive_flag := 'Y';
1002: l_ytd_dim := '_PER_TD_YTD';
1003: END IF;
1004: hr_utility.set_location('l_aggr_archive_flag :' || l_aggr_archive_flag,15);
1005: ---
1006:
1007: -- Get the child assignment action id to Archive Tax code and Tax basis.
1008: -- As the run results are generated with child assignment action id.

Line 1018: hr_utility.trace('l_last_chld_act_id : '||l_last_chld_act_id);

1014: IF l_last_chld_act_id is NULL THEN
1015: l_last_chld_act_id := p_last_asg_action_id;
1016: END IF;
1017:
1018: hr_utility.trace('l_last_chld_act_id : '||l_last_chld_act_id);
1019:
1020: open csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
1021: fetch csr_get_taxable_pay into l_tax_pay_def_bal_id;
1022: close csr_get_taxable_pay;

Line 1032: hr_utility.trace('l_aggr_archive_flag '||l_aggr_archive_flag);

1028: -- If not pass the child assignment action id.
1029:
1030: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1031:
1032: hr_utility.trace('l_aggr_archive_flag '||l_aggr_archive_flag);
1033:
1034: if l_tax_pay_val = 0 then
1035: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
1036: p_defined_balance_lst => g_aggr_defined_balance_lst ,

Line 1047: hr_utility.trace('l_aggr_archive_flag '||l_aggr_archive_flag);

1043: p_output_table => l_output_table );
1044: end if;
1045: else
1046:
1047: hr_utility.trace('l_aggr_archive_flag '||l_aggr_archive_flag);
1048:
1049: if l_tax_pay_val = 0 then
1050: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
1051: p_defined_balance_lst => g_defined_balance_lst ,

Line 1064: hr_utility.trace('After invoking get_value');

1060:
1061: end if;
1062:
1063:
1064: hr_utility.trace('After invoking get_value');
1065: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1066: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1067:
1068: if NVL(l_aggr_archive_flag,'N') = 'Y' then

Line 1065: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');

1061: end if;
1062:
1063:
1064: hr_utility.trace('After invoking get_value');
1065: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1066: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1067:
1068: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1069:

Line 1066: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);

1062:
1063:
1064: hr_utility.trace('After invoking get_value');
1065: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1066: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1067:
1068: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1069:
1070: hr_utility.trace('After l_aggr_archive_flag'||l_aggr_archive_flag);

Line 1070: hr_utility.trace('After l_aggr_archive_flag'||l_aggr_archive_flag);

1066: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1067:
1068: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1069:
1070: hr_utility.trace('After l_aggr_archive_flag'||l_aggr_archive_flag);
1071:
1072: FOR outer_rec IN 1..l_output_table.count
1073: LOOP
1074:

Line 1133: hr_utility.trace('After for i in 1..g_fps_aggr_bal_det_tab.last loop');

1129: END IF;
1130: END IF;
1131: END IF;
1132: END LOOP;
1133: hr_utility.trace('After for i in 1..g_fps_aggr_bal_det_tab.last loop');
1134: END IF; --Not null check ends
1135: END LOOP;
1136: else
1137:

Line 1138: hr_utility.trace('After l_aggr_archive_flag'||l_aggr_archive_flag);

1134: END IF; --Not null check ends
1135: END LOOP;
1136: else
1137:
1138: hr_utility.trace('After l_aggr_archive_flag'||l_aggr_archive_flag);
1139:
1140: FOR outer_rec IN 1..l_output_table.count
1141: LOOP
1142:

Line 1152: hr_utility.trace('Taxable pay '||p_fps_bal_context_2.act_info15);

1148: IF g_fps_bal_det_tab(inner_rec).balance_name = 'Taxable Pay' THEN
1149: IF (g_fps_bal_det_tab(inner_rec).database_item_suffix = l_ytd_dim ) THEN
1150: g_fps_bal_det_tab(inner_rec).balance_value := 100 * l_output_table(outer_rec).balance_value;
1151: p_fps_bal_context_2.act_info15 := 100 * l_output_table(outer_rec).balance_value;
1152: hr_utility.trace('Taxable pay '||p_fps_bal_context_2.act_info15);
1153: END IF;
1154: elsif g_fps_bal_det_tab(inner_rec).balance_name = 'PAYE' THEN
1155: IF (g_fps_bal_det_tab(inner_rec).database_item_suffix = l_ytd_dim) THEN
1156: g_fps_bal_det_tab(inner_rec).balance_value := 100 * l_output_table(outer_rec).balance_value;

Line 1202: hr_utility.trace('After for i in 1..g_fps_bal_det_tab.last loop');

1198: END IF;
1199: END IF;
1200: END IF;
1201: END LOOP;
1202: hr_utility.trace('After for i in 1..g_fps_bal_det_tab.last loop');
1203: END IF; --Not null check ends
1204: END LOOP;
1205:
1206: end if;

Line 1212: hr_utility.set_location('Error in function fetch_asg_det2 ', 15);

1208: RETURN true;
1209:
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: hr_utility.set_location('Error in function fetch_asg_det2 ', 15);
1213: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1214: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1215: RAISE;
1216: END fetch_asg_det2;

Line 1213: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );

1209:
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: hr_utility.set_location('Error in function fetch_asg_det2 ', 15);
1213: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1214: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1215: RAISE;
1216: END fetch_asg_det2;
1217: --

Line 1359: hr_utility.set_location('Entering: '||l_proc,1);

1355: and paa.payroll_action_id = ppa.payroll_action_id
1356: and ACTION_TYPE in ('V');
1357:
1358: BEGIN
1359: hr_utility.set_location('Entering: '||l_proc,1);
1360: l_context_lst(1).tax_unit_id :=NULL;
1361: l_context_lst(1).jurisdiction_code :=NULL;
1362: l_context_lst(1).source_id :=NULL;
1363: l_context_lst(1).source_text :=NULL;

Line 1376: hr_utility.set_location('assignment_id :' || p_asg_id,15);

1372: l_asg_primary_flag := 'N';
1373: l_per_agg_flag := 'N';
1374: l_aggr_archive_flag := 'N';
1375:
1376: hr_utility.set_location('assignment_id :' || p_asg_id,15);
1377:
1378: IF l_archive_tab_ni_det.count > 0 THEN
1379: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
1380: LOOP

Line 1381: hr_utility.set_location('i : ' || i ,999);

1377:
1378: IF l_archive_tab_ni_det.count > 0 THEN
1379: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
1380: LOOP
1381: hr_utility.set_location('i : ' || i ,999);
1382: if l_archive_tab_ni_det(i).act_info1 = 'A' then
1383: already_a := i;
1384: elsif l_archive_tab_ni_det(i).act_info1 = 'B' then
1385: already_b := i;

Line 1405: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);

1401: OPEN csr_asg(p_asg_id, p_effective_date);
1402: FETCH csr_asg INTO l_asg_primary_flag, l_per_agg_flag,l_per_ni_flag;
1403: CLOSE csr_asg;
1404:
1405: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
1406: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
1407: hr_utility.set_location('l_per_ni_flag :' || l_per_ni_flag,15);
1408:
1409: IF NVL(l_per_agg_flag,'N') = 'Y' THEN

Line 1406: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);

1402: FETCH csr_asg INTO l_asg_primary_flag, l_per_agg_flag,l_per_ni_flag;
1403: CLOSE csr_asg;
1404:
1405: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
1406: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
1407: hr_utility.set_location('l_per_ni_flag :' || l_per_ni_flag,15);
1408:
1409: IF NVL(l_per_agg_flag,'N') = 'Y' THEN
1410: hr_utility.trace('Aggregation Found.');

Line 1407: hr_utility.set_location('l_per_ni_flag :' || l_per_ni_flag,15);

1403: CLOSE csr_asg;
1404:
1405: hr_utility.set_location('l_asg_primary_flag :' || l_asg_primary_flag,15);
1406: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
1407: hr_utility.set_location('l_per_ni_flag :' || l_per_ni_flag,15);
1408:
1409: IF NVL(l_per_agg_flag,'N') = 'Y' THEN
1410: hr_utility.trace('Aggregation Found.');
1411: l_aggr_archive_flag := 'Y';

Line 1410: hr_utility.trace('Aggregation Found.');

1406: hr_utility.set_location('l_per_agg_flag :' || l_per_agg_flag,15);
1407: hr_utility.set_location('l_per_ni_flag :' || l_per_ni_flag,15);
1408:
1409: IF NVL(l_per_agg_flag,'N') = 'Y' THEN
1410: hr_utility.trace('Aggregation Found.');
1411: l_aggr_archive_flag := 'Y';
1412: l_ytd_dim := '_PER_TD_YTD';
1413: END IF;
1414: hr_utility.set_location('l_aggr_archive_flag :' || l_aggr_archive_flag,15);

Line 1414: hr_utility.set_location('l_aggr_archive_flag :' || l_aggr_archive_flag,15);

1410: hr_utility.trace('Aggregation Found.');
1411: l_aggr_archive_flag := 'Y';
1412: l_ytd_dim := '_PER_TD_YTD';
1413: END IF;
1414: hr_utility.set_location('l_aggr_archive_flag :' || l_aggr_archive_flag,15);
1415: ---
1416:
1417: open csr_reversal;
1418: fetch csr_reversal into l_reversal;

Line 1432: hr_utility.trace('l_last_chld_act_id : '||l_last_chld_act_id);

1428: IF l_last_chld_act_id is NULL THEN
1429: l_last_chld_act_id := p_last_asg_action_id;
1430: END IF;
1431:
1432: hr_utility.trace('l_last_chld_act_id : '||l_last_chld_act_id);
1433:
1434: open csr_get_taxable_pay('Taxable Pay', '_ASG_RUN');
1435: fetch csr_get_taxable_pay into l_tax_pay_def_bal_id;
1436: close csr_get_taxable_pay;

Line 1454: hr_utility.trace('RTI Reporting Assignment.');

1450: if NVL(l_per_ni_flag,'N') = 'Y' and NVL(l_per_agg_flag,'N') = 'N' then
1451: if l_ni_rpt_asg_id = p_asg_id then
1452: l_aggr_archive_flag := 'Y';
1453: l_ytd_dim := '_PER_TD_YTD';
1454: hr_utility.trace('RTI Reporting Assignment.');
1455: hr_utility.trace('l_aggr_archive_flag : '||l_aggr_archive_flag);
1456: else
1457: l_ni_non_rti := 'Y';
1458: hr_utility.trace('Non RTI Reporting Assignment.');

Line 1455: hr_utility.trace('l_aggr_archive_flag : '||l_aggr_archive_flag);

1451: if l_ni_rpt_asg_id = p_asg_id then
1452: l_aggr_archive_flag := 'Y';
1453: l_ytd_dim := '_PER_TD_YTD';
1454: hr_utility.trace('RTI Reporting Assignment.');
1455: hr_utility.trace('l_aggr_archive_flag : '||l_aggr_archive_flag);
1456: else
1457: l_ni_non_rti := 'Y';
1458: hr_utility.trace('Non RTI Reporting Assignment.');
1459: hr_utility.trace('l_ni_non_rti : '||l_ni_non_rti);

Line 1458: hr_utility.trace('Non RTI Reporting Assignment.');

1454: hr_utility.trace('RTI Reporting Assignment.');
1455: hr_utility.trace('l_aggr_archive_flag : '||l_aggr_archive_flag);
1456: else
1457: l_ni_non_rti := 'Y';
1458: hr_utility.trace('Non RTI Reporting Assignment.');
1459: hr_utility.trace('l_ni_non_rti : '||l_ni_non_rti);
1460: end if;
1461: end if;
1462:

Line 1459: hr_utility.trace('l_ni_non_rti : '||l_ni_non_rti);

1455: hr_utility.trace('l_aggr_archive_flag : '||l_aggr_archive_flag);
1456: else
1457: l_ni_non_rti := 'Y';
1458: hr_utility.trace('Non RTI Reporting Assignment.');
1459: hr_utility.trace('l_ni_non_rti : '||l_ni_non_rti);
1460: end if;
1461: end if;
1462:
1463: if NVL(l_aggr_archive_flag,'N') = 'Y' then

Line 1490: hr_utility.trace('After invoking get_value');

1486: p_output_table => l_output_table );
1487: end if;
1488: end if;
1489:
1490: hr_utility.trace('After invoking get_value');
1491: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1492: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1493:
1494: if NVL(l_aggr_archive_flag,'N') = 'Y' then

Line 1491: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');

1487: end if;
1488: end if;
1489:
1490: hr_utility.trace('After invoking get_value');
1491: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1492: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1493:
1494: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1495:

Line 1492: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);

1488: end if;
1489:
1490: hr_utility.trace('After invoking get_value');
1491: hr_utility.trace('Before entering for i in 1..g_fps_bal_det_tab.last loop');
1492: hr_utility.set_location('l_ytd_dim :' || l_ytd_dim,15);
1493:
1494: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1495:
1496: FOR outer_rec IN 1..l_output_table.count

Line 1507: hr_utility.trace('After invoking ni D'||l_output_table(outer_rec).balance_value);

1503: IF (g_fps_ni_aggr_bal_det_tab(inner_rec).defined_balance_id = l_output_table(outer_rec).defined_balance_id and l_output_table(outer_rec).balance_value is not null) THEN
1504: IF g_fps_ni_aggr_bal_det_tab(inner_rec).balance_name = 'NI A Total' THEN
1505: IF (g_fps_ni_aggr_bal_det_tab(inner_rec).database_item_suffix = l_ytd_dim) THEN
1506: l_nia_total := 100 * NVL(l_output_table(outer_rec).balance_value,0);
1507: hr_utility.trace('After invoking ni D'||l_output_table(outer_rec).balance_value);
1508: END IF;
1509: elsif g_fps_ni_aggr_bal_det_tab(inner_rec).balance_name = 'NI A Able' THEN
1510: IF (g_fps_ni_aggr_bal_det_tab(inner_rec).database_item_suffix = l_ytd_dim) THEN
1511: g_fps_ni_aggr_bal_det_tab(inner_rec).balance_value := 100 * l_output_table(outer_rec).balance_value;

Line 1577: hr_utility.trace('After for i in 1..g_fps_ni_aggr_bal_det_tab.last loop');

1573: END IF;
1574: END IF;
1575: END IF;
1576: END LOOP;
1577: hr_utility.trace('After for i in 1..g_fps_ni_aggr_bal_det_tab.last loop');
1578: END IF; --Not null check ends
1579: END LOOP;
1580:
1581: else

Line 1663: hr_utility.trace('After for i in 1..g_fps_ni_bal_det_tab.last loop');

1659: END IF;
1660: END IF;
1661: END IF;
1662: END LOOP;
1663: hr_utility.trace('After for i in 1..g_fps_ni_bal_det_tab.last loop');
1664: END IF; --Not null check ends
1665: END LOOP;
1666:
1667: end if;

Line 1669: hr_utility.trace('After invoking l_nia_total '||l_nia_total);

1665: END LOOP;
1666:
1667: end if;
1668:
1669: hr_utility.trace('After invoking l_nia_total '||l_nia_total);
1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);
1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);

Line 1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);

1666:
1667: end if;
1668:
1669: hr_utility.trace('After invoking l_nia_total '||l_nia_total);
1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);
1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);

Line 1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);

1667: end if;
1668:
1669: hr_utility.trace('After invoking l_nia_total '||l_nia_total);
1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);
1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);

Line 1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);

1668:
1669: hr_utility.trace('After invoking l_nia_total '||l_nia_total);
1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);
1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);

Line 1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);

1669: hr_utility.trace('After invoking l_nia_total '||l_nia_total);
1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);
1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);

Line 1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);

1670: hr_utility.trace('After invoking l_nia_able '||l_nia_able);
1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);

Line 1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);

1671: hr_utility.trace('After invoking l_nib_total '||l_nib_total);
1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);

Line 1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);

1672: hr_utility.trace('After invoking l_nib_able '||l_nib_able);
1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);

Line 1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);

1673: hr_utility.trace('After invoking l_nic_total '||l_nic_total);
1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);
1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);

Line 1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);

1674: hr_utility.trace('After invoking l_nic_able '||l_nic_able);
1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);
1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);
1682: hr_utility.trace('After invoking l_nil_able '||l_nil_able);

Line 1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);

1675: hr_utility.trace('After invoking l_nid_total '||l_nid_total);
1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);
1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);
1682: hr_utility.trace('After invoking l_nil_able '||l_nil_able);
1683:

Line 1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);

1676: hr_utility.trace('After invoking l_nid_able '||l_nid_able);
1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);
1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);
1682: hr_utility.trace('After invoking l_nil_able '||l_nil_able);
1683:
1684: if l_reversal is not null then

Line 1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);

1677: hr_utility.trace('After invoking l_nie_total '||l_nie_total);
1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);
1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);
1682: hr_utility.trace('After invoking l_nil_able '||l_nil_able);
1683:
1684: if l_reversal is not null then
1685:

Line 1682: hr_utility.trace('After invoking l_nil_able '||l_nil_able);

1678: hr_utility.trace('After invoking l_nie_able '||l_nie_able);
1679: hr_utility.trace('After invoking l_nij_total '||l_nij_total);
1680: hr_utility.trace('After invoking l_nij_able '||l_nij_able);
1681: hr_utility.trace('After invoking l_nil_total '||l_nil_total);
1682: hr_utility.trace('After invoking l_nil_able '||l_nil_able);
1683:
1684: if l_reversal is not null then
1685:
1686:

Line 1712: hr_utility.trace('fetching NI Aggr balances');

1708: end if;
1709:
1710: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1711:
1712: hr_utility.trace('fetching NI Aggr balances');
1713:
1714: hr_utility.trace('fetching l_nid_total'||l_nid_total);
1715: hr_utility.trace('fetching l_nid_able'||l_nid_able);
1716:

Line 1714: hr_utility.trace('fetching l_nid_total'||l_nid_total);

1710: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1711:
1712: hr_utility.trace('fetching NI Aggr balances');
1713:
1714: hr_utility.trace('fetching l_nid_total'||l_nid_total);
1715: hr_utility.trace('fetching l_nid_able'||l_nid_able);
1716:
1717: -- Fetch 6 NI balances based on the Total and Able
1718: IF (NVL(l_nia_total,0) <> 0 OR NVL(l_nia_able,0) <> 0 ) OR

Line 1715: hr_utility.trace('fetching l_nid_able'||l_nid_able);

1711:
1712: hr_utility.trace('fetching NI Aggr balances');
1713:
1714: hr_utility.trace('fetching l_nid_total'||l_nid_total);
1715: hr_utility.trace('fetching l_nid_able'||l_nid_able);
1716:
1717: -- Fetch 6 NI balances based on the Total and Able
1718: IF (NVL(l_nia_total,0) <> 0 OR NVL(l_nia_able,0) <> 0 ) OR
1719: ( l_reversal is not null and NVL(l_nia_able_run,0) <> 0 OR NVL(l_nia_e_run,0) <> 0) THEN

Line 1726: hr_utility.trace('fetching NI A Total/Able balances');

1722: i := i+1;
1723: already_a := i;
1724: END IF;
1725:
1726: hr_utility.trace('fetching NI A Total/Able balances');
1727: l_archive_tab_ni_det(already_a).assignment_id := p_asg_id;
1728: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1729: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1730: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nia_lel_id);

Line 1744: hr_utility.trace('fetching NI B Total/Able balances');

1740: IF already_b = -1 THEN
1741: i := i+1;
1742: already_b := i;
1743: END IF;
1744: hr_utility.trace('fetching NI B Total/Able balances');
1745: l_archive_tab_ni_det(already_b).assignment_id := p_asg_id;
1746: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1747: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1748: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nib_lel_id);

Line 1761: hr_utility.trace('fetching NI C Total/Able balances');

1757: IF already_c = -1 THEN
1758: i := i+1;
1759: already_c := i;
1760: END IF;
1761: hr_utility.trace('fetching NI C Total/Able balances');
1762: l_archive_tab_ni_det(already_c).assignment_id := p_asg_id;
1763: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1764: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1765: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nic_lel_id);

Line 1778: hr_utility.trace('fetching NI D Total/Able balances');

1774: IF already_d = -1 THEN
1775: i := i+1;
1776: already_d := i;
1777: END IF;
1778: hr_utility.trace('fetching NI D Total/Able balances');
1779: l_archive_tab_ni_det(already_d).assignment_id := p_asg_id;
1780: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1781: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1782: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nid_lel_id);

Line 1795: hr_utility.trace('fetching NI E Total/Able balances');

1791: IF already_e = -1 THEN
1792: i := i+1;
1793: already_e := i;
1794: END IF;
1795: hr_utility.trace('fetching NI E Total/Able balances');
1796: l_archive_tab_ni_det(already_e).assignment_id := p_asg_id;
1797: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1798: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1799: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nie_lel_id);

Line 1812: hr_utility.trace('fetching NI J Total/Able balances');

1808: IF already_j = -1 THEN
1809: i := i+1;
1810: already_j := i;
1811: END IF;
1812: hr_utility.trace('fetching NI J Total/Able balances');
1813: l_archive_tab_ni_det(already_j).assignment_id := p_asg_id;
1814: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1815: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1816: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nij_lel_id);

Line 1829: hr_utility.trace('fetching NI L Total/Able balances');

1825: IF already_l = -1 THEN
1826: i := i+1;
1827: already_l := i;
1828: END IF;
1829: hr_utility.trace('fetching NI L Total/Able balances');
1830: l_archive_tab_ni_det(already_l).assignment_id := p_asg_id;
1831: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1832: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1833: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_lel_id);

Line 1842: hr_utility.trace('fetching NI balances');

1838: l_archive_tab_ni_det(already_l).act_info8 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_per_nil_e_ytd_id);
1839: END IF;
1840:
1841: else --Aggregation else
1842: hr_utility.trace('fetching NI balances');
1843: -- Fetch 6 NI balances based on the Total and Able
1844: IF (NVL(l_nia_total,0) <> 0 OR NVL(l_nia_able,0) <> 0 ) OR
1845: ( l_reversal is not null and NVL(l_nia_able_run,0) <> 0 OR NVL(l_nia_e_run,0) <> 0) THEN
1846: IF already_a = -1 THEN

Line 1850: hr_utility.trace('fetching NI A Total/Able balances');

1846: IF already_a = -1 THEN
1847: i := i+1;
1848: already_a := i;
1849: END IF;
1850: hr_utility.trace('fetching NI A Total/Able balances');
1851: l_archive_tab_ni_det(already_a).assignment_id := p_asg_id;
1852: l_archive_tab_ni_det(already_a).action_info_category := 'GB_RTI_FPS_NI_DET';
1853: l_archive_tab_ni_det(already_a).act_info1 := 'A';
1854: l_archive_tab_ni_det(already_a).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nia_lel_id);

Line 1867: hr_utility.trace('fetching NI B Total/Able balances');

1863: IF already_b = -1 THEN
1864: i := i+1;
1865: already_b := i;
1866: END IF;
1867: hr_utility.trace('fetching NI B Total/Able balances');
1868: l_archive_tab_ni_det(already_b).assignment_id := p_asg_id;
1869: l_archive_tab_ni_det(already_b).action_info_category := 'GB_RTI_FPS_NI_DET';
1870: l_archive_tab_ni_det(already_b).act_info1 := 'B';
1871: l_archive_tab_ni_det(already_b).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nib_lel_id);

Line 1884: hr_utility.trace('fetching NI C Total/Able balances');

1880: IF already_c = -1 THEN
1881: i := i+1;
1882: already_c := i;
1883: END IF;
1884: hr_utility.trace('fetching NI C Total/Able balances');
1885: l_archive_tab_ni_det(already_c).assignment_id := p_asg_id;
1886: l_archive_tab_ni_det(already_c).action_info_category := 'GB_RTI_FPS_NI_DET';
1887: l_archive_tab_ni_det(already_c).act_info1 := 'C';
1888: l_archive_tab_ni_det(already_c).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nic_lel_id);

Line 1901: hr_utility.trace('fetching NI D Total/Able balances');

1897: IF already_d = -1 THEN
1898: i := i+1;
1899: already_d := i;
1900: END IF;
1901: hr_utility.trace('fetching NI D Total/Able balances');
1902: l_archive_tab_ni_det(already_d).assignment_id := p_asg_id;
1903: l_archive_tab_ni_det(already_d).action_info_category := 'GB_RTI_FPS_NI_DET';
1904: l_archive_tab_ni_det(already_d).act_info1 := 'D';
1905: l_archive_tab_ni_det(already_d).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nid_lel_id);

Line 1918: hr_utility.trace('fetching NI E Total/Able balances');

1914: IF already_e = -1 THEN
1915: i := i+1;
1916: already_e := i;
1917: END IF;
1918: hr_utility.trace('fetching NI E Total/Able balances');
1919: l_archive_tab_ni_det(already_e).assignment_id := p_asg_id;
1920: l_archive_tab_ni_det(already_e).action_info_category := 'GB_RTI_FPS_NI_DET';
1921: l_archive_tab_ni_det(already_e).act_info1 := 'E';
1922: l_archive_tab_ni_det(already_e).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nie_lel_id);

Line 1935: hr_utility.trace('fetching NI J Total/Able balances');

1931: IF already_j = -1 THEN
1932: i := i+1;
1933: already_j := i;
1934: END IF;
1935: hr_utility.trace('fetching NI J Total/Able balances');
1936: l_archive_tab_ni_det(already_j).assignment_id := p_asg_id;
1937: l_archive_tab_ni_det(already_j).action_info_category := 'GB_RTI_FPS_NI_DET';
1938: l_archive_tab_ni_det(already_j).act_info1 := 'J';
1939: l_archive_tab_ni_det(already_j).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nij_lel_id);

Line 1952: hr_utility.trace('fetching NI L Total/Able balances');

1948: IF already_l = -1 THEN
1949: i := i+1;
1950: already_l := i;
1951: END IF;
1952: hr_utility.trace('fetching NI L Total/Able balances');
1953: l_archive_tab_ni_det(already_l).assignment_id := p_asg_id;
1954: l_archive_tab_ni_det(already_l).action_info_category := 'GB_RTI_FPS_NI_DET';
1955: l_archive_tab_ni_det(already_l).act_info1 := 'L';
1956: l_archive_tab_ni_det(already_l).act_info3 := 100 * hr_dirbal.get_balance(p_last_asg_action_id, g_nil_lel_id);

Line 1968: hr_utility.trace('Assigning zeroes Non RTI Reporting Assignment.');

1964: END IF; --Aggregation End
1965:
1966: --Non RTI Reporting asg . make values to zero
1967: IF l_ni_non_rti = 'Y' then
1968: hr_utility.trace('Assigning zeroes Non RTI Reporting Assignment.');
1969:
1970: IF l_archive_tab_ni_det.count > 0 THEN
1971: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
1972: LOOP

Line 1973: hr_utility.set_location('i : ' || i ,999);

1969:
1970: IF l_archive_tab_ni_det.count > 0 THEN
1971: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
1972: LOOP
1973: hr_utility.set_location('i : ' || i ,999);
1974: l_archive_tab_ni_det(i).act_info3 := 0;
1975: l_archive_tab_ni_det(i).act_info4 := 0;
1976: l_archive_tab_ni_det(i).act_info5 := 0;
1977: l_archive_tab_ni_det(i).act_info6 := 0;

Line 1990: hr_utility.set_location('Error in function fetch_ni_det ', 15);

1986: RETURN true;
1987:
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: hr_utility.set_location('Error in function fetch_ni_det ', 15);
1991: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1992: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1993: RAISE;
1994: END fetch_ni_det;

Line 1991: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );

1987:
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: hr_utility.set_location('Error in function fetch_ni_det ', 15);
1991: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1992: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1993: RAISE;
1994: END fetch_ni_det;
1995:

Line 2015: hr_utility.trace('Inside fetch_nic_refund');

2011:
2012: l_nic_refund PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION10%type;
2013:
2014: begin
2015: hr_utility.trace('Inside fetch_nic_refund');
2016:
2017: open csr_fetch_nic_refund;
2018: fetch csr_fetch_nic_refund into l_nic_refund;
2019: close csr_fetch_nic_refund;

Line 2021: hr_utility.trace('EYU NIC Refunded from EIT'||l_nic_refund);

2017: open csr_fetch_nic_refund;
2018: fetch csr_fetch_nic_refund into l_nic_refund;
2019: close csr_fetch_nic_refund;
2020:
2021: hr_utility.trace('EYU NIC Refunded from EIT'||l_nic_refund);
2022:
2023: if l_nic_refund is NULL then
2024: l_nic_refund := 'Y' ;
2025: end if;

Line 2027: hr_utility.trace('EYU NIC Refunded after default'||l_nic_refund);

2023: if l_nic_refund is NULL then
2024: l_nic_refund := 'Y' ;
2025: end if;
2026:
2027: hr_utility.trace('EYU NIC Refunded after default'||l_nic_refund);
2028:
2029: IF l_archive_tab_ni_det.count > 0 THEN
2030: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
2031: LOOP

Line 2032: hr_utility.set_location('i : ' || i ,999);

2028:
2029: IF l_archive_tab_ni_det.count > 0 THEN
2030: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
2031: LOOP
2032: hr_utility.set_location('i : ' || i ,999);
2033: if l_archive_tab_ni_det(i).act_info8 < 0 then
2034: l_archive_tab_ni_det(i).act_info11 := l_nic_refund;
2035: end if;
2036: END LOOP;

Line 2038: hr_utility.trace('Leaving fetch_nic_refund');

2034: l_archive_tab_ni_det(i).act_info11 := l_nic_refund;
2035: end if;
2036: END LOOP;
2037: END IF;
2038: hr_utility.trace('Leaving fetch_nic_refund');
2039: EXCEPTION
2040: WHEN OTHERS THEN
2041: hr_utility.trace('Fetch nic refund failed:'||SQLERRM);
2042: END;

Line 2041: hr_utility.trace('Fetch nic refund failed:'||SQLERRM);

2037: END IF;
2038: hr_utility.trace('Leaving fetch_nic_refund');
2039: EXCEPTION
2040: WHEN OTHERS THEN
2041: hr_utility.trace('Fetch nic refund failed:'||SQLERRM);
2042: END;
2043: ---
2044:
2045: procedure calculate_diff (pactid number , p_report_type varchar2,p_asg_id number,p_archive_tab IN OUT NOCOPY action_info_table,p_flag IN OUT NOCOPY varchar2 )

Line 2114: hr_utility.trace('Entering calculate_diff '||p_asg_id);

2110: l_aspp NUMBER;
2111: l_flag VARCHAR2(1) := 'N';
2112:
2113: begin
2114: hr_utility.trace('Entering calculate_diff '||p_asg_id);
2115:
2116: hr_utility.trace('Entering pactid '||pactid);
2117: hr_utility.trace('Entering p_report_type '||p_report_type);
2118:

Line 2116: hr_utility.trace('Entering pactid '||pactid);

2112:
2113: begin
2114: hr_utility.trace('Entering calculate_diff '||p_asg_id);
2115:
2116: hr_utility.trace('Entering pactid '||pactid);
2117: hr_utility.trace('Entering p_report_type '||p_report_type);
2118:
2119: if p_report_type = 'RTI_FPS_REP' then
2120:

Line 2117: hr_utility.trace('Entering p_report_type '||p_report_type);

2113: begin
2114: hr_utility.trace('Entering calculate_diff '||p_asg_id);
2115:
2116: hr_utility.trace('Entering pactid '||pactid);
2117: hr_utility.trace('Entering p_report_type '||p_report_type);
2118:
2119: if p_report_type = 'RTI_FPS_REP' then
2120:
2121: --Paye Aggregation

Line 2123: hr_utility.trace('Entering Aggregation '||p_report_type);

2119: if p_report_type = 'RTI_FPS_REP' then
2120:
2121: --Paye Aggregation
2122: if NVL(p_archive_tab(0).act_info10,'N') = 'Y' then
2123: hr_utility.trace('Entering Aggregation '||p_report_type);
2124: open csr_fps_details_payeagg;
2125: fetch csr_fps_details_payeagg into l_taxable_pay,l_paye,l_stud_loan,l_ssp,l_smp,l_ospp,l_sap,l_aspp;
2126: close csr_fps_details_payeagg;
2127: else

Line 2128: hr_utility.trace('Entering Others '||p_report_type);

2124: open csr_fps_details_payeagg;
2125: fetch csr_fps_details_payeagg into l_taxable_pay,l_paye,l_stud_loan,l_ssp,l_smp,l_ospp,l_sap,l_aspp;
2126: close csr_fps_details_payeagg;
2127: else
2128: hr_utility.trace('Entering Others '||p_report_type);
2129: open csr_fps_details;
2130: fetch csr_fps_details into l_taxable_pay,l_paye,l_stud_loan,l_ssp,l_smp,l_ospp,l_sap,l_aspp;
2131: close csr_fps_details;
2132: end if;

Line 2141: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);

2137: close csr_eyu_details;
2138: end if;
2139:
2140:
2141: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);

Line 2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);

2138: end if;
2139:
2140:
2141: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);

Line 2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);

2139:
2140:
2141: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);

Line 2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);

2140:
2141: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);

Line 2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);

2141: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:

Line 2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);

2142: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);

Line 2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);

2143: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);

Line 2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);

2144: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2145: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);

Line 2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);

2146: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);

Line 2151: hr_utility.trace('l_paye :'||l_paye);

2147: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);

Line 2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);

2148: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);
2156: hr_utility.trace('l_sap :'||l_sap);

Line 2153: hr_utility.trace('l_ssp :'||l_ssp);

2149:
2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);
2156: hr_utility.trace('l_sap :'||l_sap);
2157: hr_utility.trace('l_aspp :'||l_aspp);

Line 2154: hr_utility.trace('l_smp :'||l_smp);

2150: hr_utility.trace('l_taxable_pay : '||l_taxable_pay);
2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);
2156: hr_utility.trace('l_sap :'||l_sap);
2157: hr_utility.trace('l_aspp :'||l_aspp);
2158:

Line 2155: hr_utility.trace('l_ospp :'||l_ospp);

2151: hr_utility.trace('l_paye :'||l_paye);
2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);
2156: hr_utility.trace('l_sap :'||l_sap);
2157: hr_utility.trace('l_aspp :'||l_aspp);
2158:
2159: --Suppressing zeroes

Line 2156: hr_utility.trace('l_sap :'||l_sap);

2152: hr_utility.trace('l_stud_loan :'||l_stud_loan);
2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);
2156: hr_utility.trace('l_sap :'||l_sap);
2157: hr_utility.trace('l_aspp :'||l_aspp);
2158:
2159: --Suppressing zeroes
2160: if p_archive_tab(2).act_info15 = 0 and l_taxable_pay = 0 then

Line 2157: hr_utility.trace('l_aspp :'||l_aspp);

2153: hr_utility.trace('l_ssp :'||l_ssp);
2154: hr_utility.trace('l_smp :'||l_smp);
2155: hr_utility.trace('l_ospp :'||l_ospp);
2156: hr_utility.trace('l_sap :'||l_sap);
2157: hr_utility.trace('l_aspp :'||l_aspp);
2158:
2159: --Suppressing zeroes
2160: if p_archive_tab(2).act_info15 = 0 and l_taxable_pay = 0 then
2161: p_archive_tab(2).act_info15 := NULL;

Line 2203: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);

2199: p_archive_tab(2).act_info20 := p_archive_tab(2).act_info20 - l_ospp ;
2200: p_archive_tab(2).act_info21 := p_archive_tab(2).act_info21 - l_sap ;
2201: p_archive_tab(2).act_info22 := p_archive_tab(2).act_info22 - l_aspp ;
2202:
2203: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);

Line 2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);

2200: p_archive_tab(2).act_info21 := p_archive_tab(2).act_info21 - l_sap ;
2201: p_archive_tab(2).act_info22 := p_archive_tab(2).act_info22 - l_aspp ;
2202:
2203: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);

Line 2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);

2201: p_archive_tab(2).act_info22 := p_archive_tab(2).act_info22 - l_aspp ;
2202:
2203: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);

Line 2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);

2202:
2203: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2210: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);

Line 2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);

2203: hr_utility.trace('p_archive_tab(2).act_info15 '||p_archive_tab(2).act_info15);
2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2210: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2211:

Line 2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);

2204: hr_utility.trace('p_archive_tab(2).act_info16 '||p_archive_tab(2).act_info16);
2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2210: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2211:
2212:

Line 2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);

2205: hr_utility.trace('p_archive_tab(2).act_info17 '||p_archive_tab(2).act_info17);
2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2210: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2211:
2212:
2213: if p_archive_tab(2).act_info15 <> 0 or p_archive_tab(2).act_info16 <> 0 or p_archive_tab(2).act_info17 <> 0

Line 2210: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);

2206: hr_utility.trace('p_archive_tab(2).act_info18 '||p_archive_tab(2).act_info18);
2207: hr_utility.trace('p_archive_tab(2).act_info19 '||p_archive_tab(2).act_info19);
2208: hr_utility.trace('p_archive_tab(2).act_info20 '||p_archive_tab(2).act_info20);
2209: hr_utility.trace('p_archive_tab(2).act_info21 '||p_archive_tab(2).act_info21);
2210: hr_utility.trace('p_archive_tab(2).act_info22 '||p_archive_tab(2).act_info22);
2211:
2212:
2213: if p_archive_tab(2).act_info15 <> 0 or p_archive_tab(2).act_info16 <> 0 or p_archive_tab(2).act_info17 <> 0
2214: or p_archive_tab(2).act_info18 <> 0 or p_archive_tab(2).act_info19 <> 0 or p_archive_tab(2).act_info20 <> 0

Line 2217: hr_utility.trace('Differences are found. Archive the data.');

2213: if p_archive_tab(2).act_info15 <> 0 or p_archive_tab(2).act_info16 <> 0 or p_archive_tab(2).act_info17 <> 0
2214: or p_archive_tab(2).act_info18 <> 0 or p_archive_tab(2).act_info19 <> 0 or p_archive_tab(2).act_info20 <> 0
2215: or p_archive_tab(2).act_info21 <> 0 or p_archive_tab(2).act_info22 <> 0 then
2216: l_flag := 'Y';
2217: hr_utility.trace('Differences are found. Archive the data.');
2218: end if;
2219: p_flag := l_flag;
2220: hr_utility.trace('Leaving calculate_diff');
2221: end calculate_diff;

Line 2220: hr_utility.trace('Leaving calculate_diff');

2216: l_flag := 'Y';
2217: hr_utility.trace('Differences are found. Archive the data.');
2218: end if;
2219: p_flag := l_flag;
2220: hr_utility.trace('Leaving calculate_diff');
2221: end calculate_diff;
2222:
2223: --
2224: procedure calculate_diff_ni (pactid number , p_report_type varchar2 , p_asg_id number, p_archive_tab IN OUT NOCOPY action_info_table,p_flag IN OUT NOCOPY varchar2)

Line 2252: hr_utility.trace('Entering calculate_diff_ni');

2248: l_emp NUMBER;
2249: l_flag VARCHAR2(1) := 'N';
2250:
2251: begin
2252: hr_utility.trace('Entering calculate_diff_ni');
2253:
2254: IF p_archive_tab.count > 0 THEN
2255:
2256: hr_utility.trace('Entering if');

Line 2256: hr_utility.trace('Entering if');

2252: hr_utility.trace('Entering calculate_diff_ni');
2253:
2254: IF p_archive_tab.count > 0 THEN
2255:
2256: hr_utility.trace('Entering if');
2257:
2258: FOR i IN p_archive_tab.first .. p_archive_tab.last
2259: LOOP
2260:

Line 2261: hr_utility.trace('Entering for loop1');

2257:
2258: FOR i IN p_archive_tab.first .. p_archive_tab.last
2259: LOOP
2260:
2261: hr_utility.trace('Entering for loop1');
2262:
2263: for ni_fps_rec in csr_fps_details
2264: loop
2265: hr_utility.trace('Entering for loop2');

Line 2265: hr_utility.trace('Entering for loop2');

2261: hr_utility.trace('Entering for loop1');
2262:
2263: for ni_fps_rec in csr_fps_details
2264: loop
2265: hr_utility.trace('Entering for loop2');
2266:
2267: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2268: hr_utility.trace('Entering if');
2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);

Line 2268: hr_utility.trace('Entering if');

2264: loop
2265: hr_utility.trace('Entering for loop2');
2266:
2267: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2268: hr_utility.trace('Entering if');
2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2271:
2272: hr_utility.trace('Entering i '||i);

Line 2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);

2265: hr_utility.trace('Entering for loop2');
2266:
2267: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2268: hr_utility.trace('Entering if');
2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2271:
2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);

Line 2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);

2266:
2267: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2268: hr_utility.trace('Entering if');
2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2271:
2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);

Line 2272: hr_utility.trace('Entering i '||i);

2268: hr_utility.trace('Entering if');
2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2271:
2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);

Line 2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);

2269: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2271:
2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

Line 2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);

2270: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2271:
2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

Line 2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);

2271:
2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2279:

Line 2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);

2272: hr_utility.trace('Entering i '||i);
2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2279:
2280: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);

Line 2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

2273: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2279:
2280: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2281: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);

Line 2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

2274: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2275: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2279:
2280: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2281: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);
2282:

Line 2280: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);

2276: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2279:
2280: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2281: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);
2282:
2283: -- New YTD - Old YTD
2284: p_archive_tab(i).act_info3 := p_archive_tab(i).act_info3 - ni_fps_rec.l_lel ;

Line 2281: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);

2277: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2278: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2279:
2280: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2281: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);
2282:
2283: -- New YTD - Old YTD
2284: p_archive_tab(i).act_info3 := p_archive_tab(i).act_info3 - ni_fps_rec.l_lel ;
2285: p_archive_tab(i).act_info4 := p_archive_tab(i).act_info4 - ni_fps_rec.l_et ;

Line 2291: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);

2287: p_archive_tab(i).act_info6 := p_archive_tab(i).act_info6 - ni_fps_rec.l_uel ;
2288: p_archive_tab(i).act_info7 := p_archive_tab(i).act_info7 - ni_fps_rec.l_emr ;
2289: p_archive_tab(i).act_info8 := p_archive_tab(i).act_info8 - ni_fps_rec.l_emp ;
2290:
2291: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

Line 2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);

2288: p_archive_tab(i).act_info7 := p_archive_tab(i).act_info7 - ni_fps_rec.l_emr ;
2289: p_archive_tab(i).act_info8 := p_archive_tab(i).act_info8 - ni_fps_rec.l_emp ;
2290:
2291: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2296: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

Line 2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);

2289: p_archive_tab(i).act_info8 := p_archive_tab(i).act_info8 - ni_fps_rec.l_emp ;
2290:
2291: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2296: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2297:

Line 2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);

2290:
2291: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2296: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2297:
2298: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0

Line 2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

2291: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2296: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2297:
2298: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0
2299: or p_archive_tab(i).act_info6 <> 0 or p_archive_tab(i).act_info7 <> 0 or p_archive_tab(i).act_info8 <> 0

Line 2296: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

2292: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2293: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2294: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2295: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2296: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2297:
2298: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0
2299: or p_archive_tab(i).act_info6 <> 0 or p_archive_tab(i).act_info7 <> 0 or p_archive_tab(i).act_info8 <> 0
2300: then

Line 2302: hr_utility.trace('Differences are found.Archive the data.');

2298: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0
2299: or p_archive_tab(i).act_info6 <> 0 or p_archive_tab(i).act_info7 <> 0 or p_archive_tab(i).act_info8 <> 0
2300: then
2301: l_flag := 'Y';
2302: hr_utility.trace('Differences are found.Archive the data.');
2303: end if;
2304: end if;
2305: end loop;
2306:

Line 2310: hr_utility.trace('Leaving calculate_diff_ni');

2306:
2307: end loop;
2308: END IF;
2309: p_flag := l_flag;
2310: hr_utility.trace('Leaving calculate_diff_ni');
2311: end calculate_diff_ni;
2312:
2313: procedure calculate_diff_ni_payeagg (pactid number , p_report_type varchar2 , p_asg_id number, p_person_id number,p_archive_tab IN OUT NOCOPY action_info_table,p_flag IN OUT NOCOPY varchar2)
2314: is

Line 2354: hr_utility.trace('Entering calculate_diff_ni_payeagg');

2350: l_flag VARCHAR2(1) := 'N';
2351: l_latest_fps_asg number;
2352:
2353: begin
2354: hr_utility.trace('Entering calculate_diff_ni_payeagg');
2355:
2356: open csr_get_latest_fps_asg;
2357: fetch csr_get_latest_fps_asg into l_latest_fps_asg;
2358: close csr_get_latest_fps_asg;

Line 2362: hr_utility.trace('Entering if');

2358: close csr_get_latest_fps_asg;
2359:
2360: IF p_archive_tab.count > 0 THEN
2361:
2362: hr_utility.trace('Entering if');
2363:
2364: FOR i IN p_archive_tab.first .. p_archive_tab.last
2365: LOOP
2366:

Line 2367: hr_utility.trace('Entering for loop1');

2363:
2364: FOR i IN p_archive_tab.first .. p_archive_tab.last
2365: LOOP
2366:
2367: hr_utility.trace('Entering for loop1');
2368:
2369: for ni_fps_rec in csr_fps_details(l_latest_fps_asg)
2370: loop
2371: hr_utility.trace('Entering for loop2');

Line 2371: hr_utility.trace('Entering for loop2');

2367: hr_utility.trace('Entering for loop1');
2368:
2369: for ni_fps_rec in csr_fps_details(l_latest_fps_asg)
2370: loop
2371: hr_utility.trace('Entering for loop2');
2372:
2373: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2374: hr_utility.trace('Entering if');
2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);

Line 2374: hr_utility.trace('Entering if');

2370: loop
2371: hr_utility.trace('Entering for loop2');
2372:
2373: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2374: hr_utility.trace('Entering if');
2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2377:
2378: hr_utility.trace('Entering i '||i);

Line 2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);

2371: hr_utility.trace('Entering for loop2');
2372:
2373: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2374: hr_utility.trace('Entering if');
2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2377:
2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);

Line 2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);

2372:
2373: if p_archive_tab(i).act_info1 = ni_fps_rec.l_ni_cat then
2374: hr_utility.trace('Entering if');
2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2377:
2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);

Line 2378: hr_utility.trace('Entering i '||i);

2374: hr_utility.trace('Entering if');
2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2377:
2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);

Line 2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);

2375: hr_utility.trace('Entering ni_fps_rec.l_ni_cat '||ni_fps_rec.l_ni_cat);
2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2377:
2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

Line 2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);

2376: hr_utility.trace('Entering ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2377:
2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

Line 2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);

2377:
2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2385:

Line 2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);

2378: hr_utility.trace('Entering i '||i);
2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2385:
2386: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);

Line 2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

2379: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2385:
2386: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2387: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);

Line 2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

2380: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2381: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2385:
2386: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2387: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);
2388:

Line 2386: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);

2382: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2385:
2386: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2387: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);
2388:
2389: -- New YTD - Old YTD
2390: p_archive_tab(i).act_info3 := p_archive_tab(i).act_info3 - ni_fps_rec.l_lel ;

Line 2387: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);

2383: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2384: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2385:
2386: hr_utility.trace('ni_fps_rec.l_lel '||ni_fps_rec.l_lel);
2387: hr_utility.trace('ni_fps_rec.l_et '||ni_fps_rec.l_et);
2388:
2389: -- New YTD - Old YTD
2390: p_archive_tab(i).act_info3 := p_archive_tab(i).act_info3 - ni_fps_rec.l_lel ;
2391: p_archive_tab(i).act_info4 := p_archive_tab(i).act_info4 - ni_fps_rec.l_et ;

Line 2397: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);

2393: p_archive_tab(i).act_info6 := p_archive_tab(i).act_info6 - ni_fps_rec.l_uel ;
2394: p_archive_tab(i).act_info7 := p_archive_tab(i).act_info7 - ni_fps_rec.l_emr ;
2395: p_archive_tab(i).act_info8 := p_archive_tab(i).act_info8 - ni_fps_rec.l_emp ;
2396:
2397: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

Line 2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);

2394: p_archive_tab(i).act_info7 := p_archive_tab(i).act_info7 - ni_fps_rec.l_emr ;
2395: p_archive_tab(i).act_info8 := p_archive_tab(i).act_info8 - ni_fps_rec.l_emp ;
2396:
2397: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2402: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

Line 2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);

2395: p_archive_tab(i).act_info8 := p_archive_tab(i).act_info8 - ni_fps_rec.l_emp ;
2396:
2397: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2402: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2403:

Line 2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);

2396:
2397: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2402: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2403:
2404: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0

Line 2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);

2397: hr_utility.trace('p_archive_tab(i).act_info3 '||p_archive_tab(i).act_info3);
2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2402: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2403:
2404: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0
2405: or p_archive_tab(i).act_info6 <> 0 or p_archive_tab(i).act_info7 <> 0 or p_archive_tab(i).act_info8 <> 0

Line 2402: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);

2398: hr_utility.trace('p_archive_tab(i).act_info4 '||p_archive_tab(i).act_info4);
2399: hr_utility.trace('p_archive_tab(i).act_info5 '||p_archive_tab(i).act_info5);
2400: hr_utility.trace('p_archive_tab(i).act_info6 '||p_archive_tab(i).act_info6);
2401: hr_utility.trace('p_archive_tab(i).act_info7 '||p_archive_tab(i).act_info7);
2402: hr_utility.trace('p_archive_tab(i).act_info8 '||p_archive_tab(i).act_info8);
2403:
2404: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0
2405: or p_archive_tab(i).act_info6 <> 0 or p_archive_tab(i).act_info7 <> 0 or p_archive_tab(i).act_info8 <> 0
2406: then

Line 2408: hr_utility.trace('Differences are found.Archive the data.');

2404: if p_archive_tab(i).act_info3 <> 0 or p_archive_tab(i).act_info4 <> 0 or p_archive_tab(i).act_info5 <> 0
2405: or p_archive_tab(i).act_info6 <> 0 or p_archive_tab(i).act_info7 <> 0 or p_archive_tab(i).act_info8 <> 0
2406: then
2407: l_flag := 'Y';
2408: hr_utility.trace('Differences are found.Archive the data.');
2409: end if;
2410: end if;
2411: end loop;
2412:

Line 2416: hr_utility.trace('Leaving calculate_diff_ni_payeagg');

2412:
2413: end loop;
2414: END IF;
2415: p_flag := l_flag;
2416: hr_utility.trace('Leaving calculate_diff_ni_payeagg');
2417: end calculate_diff_ni_payeagg;
2418:
2419:
2420: procedure supressing_zeros_new_starter(p_archive_tab IN OUT nocopy action_info_table,p_flag IN OUT NOCOPY varchar2)

Line 2463: hr_utility.trace('Values are found. Archive the data.');

2459: if NVL(p_archive_tab(2).act_info15,0) <> 0 or NVL(p_archive_tab(2).act_info16,0) <> 0 or NVL(p_archive_tab(2).act_info17,0) <> 0
2460: or NVL(p_archive_tab(2).act_info18,0) <> 0 or NVL(p_archive_tab(2).act_info19,0) <> 0 or NVL(p_archive_tab(2).act_info20,0) <> 0
2461: or NVL(p_archive_tab(2).act_info21,0) <> 0 or NVL(p_archive_tab(2).act_info22,0) <> 0 then
2462: p_flag := 'Y';
2463: hr_utility.trace('Values are found. Archive the data.');
2464: end if;
2465:
2466: end supressing_zeros_new_starter;
2467:

Line 2475: hr_utility.set_location(' Entering: populate_run_msg',111);

2471: p_message_level IN VARCHAR2 DEFAULT 'F')
2472: IS
2473: PRAGMA AUTONOMOUS_TRANSACTION;
2474: BEGIN
2475: hr_utility.set_location(' Entering: populate_run_msg',111);
2476:
2477: INSERT
2478: INTO pay_message_lines
2479: (

Line 2496: hr_utility.set_location(' Leaving: populate_run_msg',999);

2492: p_assignment_action_id ,
2493: 'A' ,
2494: SUBSTR(p_message_text,1,240)
2495: );
2496: hr_utility.set_location(' Leaving: populate_run_msg',999);
2497: COMMIT;
2498:
2499: EXCEPTION
2500: WHEN OTHERS THEN

Line 2501: hr_utility.trace('Error occured in populate_run_msg');

2497: COMMIT;
2498:
2499: EXCEPTION
2500: WHEN OTHERS THEN
2501: hr_utility.trace('Error occured in populate_run_msg');
2502: RAISE;
2503: END populate_run_msg;
2504:
2505: procedure set_address_fields (p_addr_rec IN OUT nocopy act_info_rec,p_person_rec IN act_info_rec, p_asg_det IN act_info_rec )

Line 2508: hr_utility.trace('Entering set_address_fields');

2504:
2505: procedure set_address_fields (p_addr_rec IN OUT nocopy act_info_rec,p_person_rec IN act_info_rec, p_asg_det IN act_info_rec )
2506: is
2507: begin
2508: hr_utility.trace('Entering set_address_fields');
2509:
2510: --Address Fields are mandatory when nino is not known or on starter
2511: if p_asg_det.act_info1 is null then
2512: if p_person_rec.act_info7 is not null then

Line 2519: hr_utility.trace('Address details will not be reported.');

2515: p_addr_rec.act_info7 := NULL;
2516: p_addr_rec.act_info8 := NULL;
2517: p_addr_rec.act_info12 := NULL;
2518: p_addr_rec.act_info13 := NULL;
2519: hr_utility.trace('Address details will not be reported.');
2520: end if;
2521: end if;
2522:
2523: hr_utility.trace('Leaving set_address_fields');

Line 2523: hr_utility.trace('Leaving set_address_fields');

2519: hr_utility.trace('Address details will not be reported.');
2520: end if;
2521: end if;
2522:
2523: hr_utility.trace('Leaving set_address_fields');
2524: end set_address_fields;
2525:
2526: PROCEDURE header_validations(p_payroll_action_id IN NUMBER)
2527: IS

Line 2556: hr_utility.set_location('Entering '|| l_proc, 10);

2552: l_payroll_rec csr_payroll_details%rowtype;
2553:
2554: BEGIN
2555:
2556: hr_utility.set_location('Entering '|| l_proc, 10);
2557: l_err := FALSE;
2558:
2559: open csr_payroll_details(p_payroll_action_id);
2560: fetch csr_payroll_details into l_payroll_rec;

Line 2565: hr_utility.set_location('The Sender ID is missing.',10);

2561: close csr_payroll_details;
2562:
2563: -- Sender Id
2564: if l_payroll_rec.sender_id = ' ' or l_payroll_rec.sender_id is null then
2565: hr_utility.set_location('The Sender ID is missing.',10);
2566: fnd_file.put_line(fnd_file.output,'The Sender ID is missing.');
2567: l_err := true;
2568: end if;
2569:

Line 2572: hr_utility.set_location('The HMRC Office number is missing.',10);

2568: end if;
2569:
2570: -- HMRC Office Number
2571: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
2572: hr_utility.set_location('The HMRC Office number is missing.',10);
2573: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
2574: l_err := true;
2575: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2576: then

Line 2577: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);

2573: fnd_file.put_line(fnd_file.output,'The HMRC Office number is missing.');
2574: l_err := true;
2575: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2576: then
2577: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
2578: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
2579: l_err := true;
2580: end if;
2581:

Line 2584: hr_utility.set_location('The Employer PAYE Reference is missing.',10);

2580: end if;
2581:
2582: -- Employer PAYE Ref
2583: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then
2584: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
2585: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2586: l_err := true;
2587: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2588: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);

Line 2588: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);

2584: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
2585: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2586: l_err := true;
2587: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2588: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
2589: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');
2590: l_err := true;
2591: end if;
2592:

Line 2595: hr_utility.set_location('The Employer Name is missing.',10);

2591: end if;
2592:
2593: -- Employer Name
2594: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then
2595: hr_utility.set_location('The Employer Name is missing.',10);
2596: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2597: l_err := true;
2598: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2599: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);

Line 2599: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);

2595: hr_utility.set_location('The Employer Name is missing.',10);
2596: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2597: l_err := true;
2598: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2599: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.',10);
2600: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name ||' has invalid characters.');
2601: l_err := true;
2602: end if;
2603:

Line 2606: hr_utility.set_location('The Employer Accounts Office Ref Number is missing.',10);

2602: end if;
2603:
2604: -- Accounts Office Number
2605: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then
2606: hr_utility.set_location('The Employer Accounts Office Ref Number is missing.',10);
2607: fnd_file.put_line(fnd_file.output,'The Employer Accounts Office Ref Number is missing.');
2608: l_err := true;
2609: elsif (length(l_payroll_rec.acc_ref_no) > 13
2610: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN

Line 2612: hr_utility.set_location ('Incorrect format entered for Employer Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);

2608: l_err := true;
2609: elsif (length(l_payroll_rec.acc_ref_no) > 13
2610: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
2611:
2612: hr_utility.set_location ('Incorrect format entered for Employer Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);
2613: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Employer Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
2614: l_err := true;
2615: END IF;
2616:

Line 2620: hr_utility.set_location('ECON Number '||l_payroll_rec.econ ||' is invalid',10);

2616:
2617: -- Econ
2618: if l_payroll_rec.econ is not null then
2619: IF econ_validate(l_payroll_rec.econ) = 0 THEN
2620: hr_utility.set_location('ECON Number '||l_payroll_rec.econ ||' is invalid',10);
2621: fnd_file.put_line(fnd_file.output,'ECON Number '||l_payroll_rec.econ ||' is invalid.');
2622: l_err := true;
2623: END IF;
2624: END IF;

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

2626: if (l_err) then
2627: raise l_exp; -- Raising Exception when error is found
2628: end if;
2629:
2630: hr_utility.set_location('Leaving '|| l_proc, 10);
2631: EXCEPTION
2632: when l_exp then
2633: raise_application_error(-20001,'Errors found while archiving data.');
2634:

Line 2684: hr_utility.set_location('Entering '||l_proc,10);

2680: l_year1 NUMBER;
2681: l_year2 NUMBER;
2682:
2683: BEGIN
2684: hr_utility.set_location('Entering '||l_proc,10);
2685: edi_validation_fail := 'N'; -- Initialized validation fail to N
2686:
2687: -- Assignment Number
2688: l_assignment_number := p_asg_no;

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

2900: edi_validation_fail := 'Y';
2901: END IF;
2902:
2903:
2904: hr_utility.set_location('Leaving'||l_proc,10);
2905: END person_address_validations;
2906:
2907: PROCEDURE assignment_validations(p_assactid IN NUMBER,
2908: p_effective_date IN DATE,

Line 2957: hr_utility.set_location('Entering: '||l_proc,1);

2953: l_eff_date date;
2954:
2955:
2956: BEGIN
2957: hr_utility.set_location('Entering: '||l_proc,1);
2958: --
2959: edi_validation_fail := 'N'; -- Initialized validation fail to N
2960:
2961: -- Assigning values to the local variables

Line 3166: hr_utility.set_location('Leaving '||l_proc,1);

3162: edi_validation_fail := 'Y';
3163: END IF;
3164:
3165:
3166: hr_utility.set_location('Leaving '||l_proc,1);
3167:
3168: END assignment_validations;
3169:
3170: PROCEDURE ni_validations( p_assactid IN NUMBER,

Line 3197: hr_utility.set_location('Entering: '||l_proc,1);

3193: l_gender varchar2(1);
3194:
3195:
3196: BEGIN
3197: hr_utility.set_location('Entering: '||l_proc,1);
3198:
3199: edi_validation_fail := 'N'; -- Initialized validation fail to N
3200:
3201:

Line 3321: hr_utility.set_location('Entering: '||l_proc,1);

3317: l_proc CONSTANT VARCHAR2(70):= g_package||'footer_validations';
3318: l_err BOOLEAN := FALSE;
3319:
3320: BEGIN
3321: hr_utility.set_location('Entering: '||l_proc,1);
3322:
3323: -- ECON Validations
3324: IF g_econ_ni_check = 'Y' THEN
3325: IF econ IS NULL THEN

Line 3326: hr_utility.set_location('ECON is missing.',10);

3322:
3323: -- ECON Validations
3324: IF g_econ_ni_check = 'Y' THEN
3325: IF econ IS NULL THEN
3326: hr_utility.set_location('ECON is missing.',10);
3327: fnd_file.put_line(fnd_file.output,'ECON is missing. Provide the ECON , rollback and rerun the process.');
3328: l_err := true;
3329: END IF;
3330: END IF;

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

3333: flag := 'Y';
3334: else flag := 'N';
3335: end if;
3336:
3337: hr_utility.set_location('Leaving '|| l_proc, 10);
3338: END footer_validations;
3339:
3340:
3341: -- Function to validate the format of the fields

Line 3363: hr_utility.trace('Entering validate_input');

3359: l_translated_value varchar2(200); -- Required to output failing char.
3360: --
3361: BEGIN
3362: --
3363: hr_utility.trace('Entering validate_input');
3364: hr_utility.trace('p_validate_mode='||p_validate_mode);
3365: hr_utility.trace('p_input_value='||p_input_value);
3366: --
3367:

Line 3364: hr_utility.trace('p_validate_mode='||p_validate_mode);

3360: --
3361: BEGIN
3362: --
3363: hr_utility.trace('Entering validate_input');
3364: hr_utility.trace('p_validate_mode='||p_validate_mode);
3365: hr_utility.trace('p_input_value='||p_input_value);
3366: --
3367:
3368: if p_validate_mode = 'EMP_NAME' then

Line 3365: hr_utility.trace('p_input_value='||p_input_value);

3361: BEGIN
3362: --
3363: hr_utility.trace('Entering validate_input');
3364: hr_utility.trace('p_validate_mode='||p_validate_mode);
3365: hr_utility.trace('p_input_value='||p_input_value);
3366: --
3367:
3368: if p_validate_mode = 'EMP_NAME' then
3369: if ( substr(p_input_value,1,1) =' ') then

Line 3370: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3366: --
3367:
3368: if p_validate_mode = 'EMP_NAME' then
3369: if ( substr(p_input_value,1,1) =' ') then
3370: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3371: l_valid := 2;
3372: else
3373: l_translated_value :=
3374: translate(p_input_value,

Line 3378: hr_utility.trace('Invalid chars found: '||l_translated_value);

3374: translate(p_input_value,
3375: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_A||l_space,l_invalid_char);
3376:
3377: if l_translated_value is not null then
3378: hr_utility.trace('Invalid chars found: '||l_translated_value);
3379: l_valid := 1; -- Not valid
3380: else
3381: l_valid := 0; -- Valid
3382: end if;

Line 3394: hr_utility.trace('Invalid chars found: '||l_translated_value);

3390: translate(p_input_value,
3391: l_invalid_char||l_number_chk,l_invalid_char);
3392:
3393: if l_translated_value is not null then
3394: hr_utility.trace('Invalid chars found: '||l_translated_value);
3395: l_valid := 1; -- Not valid
3396: else
3397: l_valid := 0; -- Valid
3398: end if;

Line 3405: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3401: --
3402: -- Check for Valid First Char
3403: --
3404: if ( substr(p_input_value,1,1) =' ') then
3405: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3406: l_valid := 2;
3407: else
3408: l_translated_value :=
3409: translate(p_input_value,

Line 3413: hr_utility.trace('Invalid chars found: '||l_translated_value);

3409: translate(p_input_value,
3410: l_invalid_char||l_char_chk||l_number_chk||l_char_set_B||l_space,l_invalid_char);
3411:
3412: if l_translated_value is not null then
3413: hr_utility.trace('Invalid chars found: '||l_translated_value);
3414: l_valid := 1; -- Not valid
3415: else
3416: l_valid := 0; -- Valid
3417: end if;

Line 3426: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3422: -- Check for Valid First Char
3423: --
3424: if not (substr(p_input_value,1,1) between 'A' and 'Z'
3425: or substr(p_input_value,1,1) between 'a' and 'z') then
3426: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3427: l_valid := 2;
3428: else
3429: l_translated_value :=
3430: translate(p_input_value,

Line 3434: hr_utility.trace('Invalid chars found: '||l_translated_value);

3430: translate(p_input_value,
3431: l_invalid_char||l_mix_chars||l_char_set_D||l_space,l_invalid_char);
3432:
3433: if l_translated_value is not null then
3434: hr_utility.trace('Invalid chars found: '||l_translated_value);
3435: l_valid := 1; -- Not valid
3436: else
3437: l_valid := 0; -- Valid
3438: end if;

Line 3447: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3443: -- Check for Valid First Char
3444: --
3445: if not (substr(p_input_value,1,1) between 'A' and 'Z'
3446: or substr(p_input_value,1,1) between 'a' and 'z') then
3447: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3448: l_valid := 2;
3449: else
3450: l_translated_value :=
3451: translate(p_input_value,

Line 3455: hr_utility.trace('Invalid chars found: '||l_translated_value);

3451: translate(p_input_value,
3452: l_invalid_char||l_mix_chars||l_char_set_C||l_space,l_invalid_char);
3453:
3454: if l_translated_value is not null then
3455: hr_utility.trace('Invalid chars found: '||l_translated_value);
3456: l_valid := 1; -- Not valid
3457: else
3458: l_valid := 0; -- Valid
3459: end if;

Line 3469: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3465: --
3466: if not (substr(p_input_value,1,1) between 'A' and 'Z'
3467: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
3468: -- First char invalid
3469: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3470: l_valid := 2;
3471: else
3472: l_translated_value :=
3473: translate(p_input_value,

Line 3477: hr_utility.trace('Invalid chars found: '||l_translated_value);

3473: translate(p_input_value,
3474: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
3475:
3476: if l_translated_value is not null then
3477: hr_utility.trace('Invalid chars found: '||l_translated_value);
3478: l_valid := 1; --Invalid
3479: else
3480: l_valid := 0; -- Valid
3481: end if;

Line 3487: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3483:
3484: elsif p_validate_mode = 'COUNTRY' then
3485: if not (substr(p_input_value,1,1) between 'A' and 'Z' or
3486: substr(p_input_value,1,1) between 'a' and 'z' ) then
3487: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3488: l_valid := 2;
3489: else
3490: l_translated_value :=
3491: translate(p_input_value,

Line 3495: hr_utility.trace('Invalid chars found: '||l_translated_value);

3491: translate(p_input_value,
3492: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
3493:
3494: if l_translated_value is not null then
3495: hr_utility.trace('Invalid chars found: '||l_translated_value);
3496: l_valid := 1; -- Not valid
3497: else
3498: l_valid := 0; -- Valid
3499: end if;

Line 3508: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3504:
3505: if not (substr(p_input_value,1,1) between 'A' and 'Z'
3506: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
3507: -- First char invalid
3508: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3509: l_valid := 2;
3510: else
3511: l_translated_value := translate(p_input_value,
3512: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);

Line 3515: hr_utility.trace('Invalid chars found: '||l_translated_value);

3511: l_translated_value := translate(p_input_value,
3512: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);
3513: --
3514: if l_translated_value is not null then
3515: hr_utility.trace('Invalid chars found: '||l_translated_value);
3516: l_valid := 1; -- Not valid
3517: else
3518: l_valid := 0; -- Valid
3519: end if;

Line 3529: hr_utility.trace('Invalid chars found: '||l_translated_value);

3525: l_translated_value := translate(p_input_value,
3526: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
3527: --
3528: if l_translated_value is not null then
3529: hr_utility.trace('Invalid chars found: '||l_translated_value);
3530: l_valid := 1; -- Not valid
3531: else
3532: l_valid := 0; -- Valid
3533: end if;

Line 3538: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

3534:
3535:
3536: elsif p_validate_mode = 'PAYROLLID' then
3537: if ( substr(p_input_value,1,1) =' ') then
3538: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
3539: l_valid := 2;
3540: else
3541: l_translated_value :=
3542: translate(p_input_value,

Line 3546: hr_utility.trace('Invalid chars found: '||l_translated_value);

3542: translate(p_input_value,
3543: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_B||l_space,l_invalid_char);
3544:
3545: if l_translated_value is not null then
3546: hr_utility.trace('Invalid chars found: '||l_translated_value);
3547: l_valid := 1; -- Not valid
3548: else
3549: l_valid := 0; -- Valid
3550: end if;

Line 3555: hr_utility.trace('Leaving validate_input');

3551: end if ;
3552:
3553: END IF;
3554: --
3555: hr_utility.trace('Leaving validate_input');
3556: return l_valid;
3557: end validate_input;
3558:
3559: -- Function for validating Date fields

Line 3588: hr_utility.trace('date as parameter : '||p_validate_date);

3584: open csr_parameter_info;
3585: fetch csr_parameter_info into l_test_submission,l_tax_date;
3586: close csr_parameter_info;
3587:
3588: hr_utility.trace('date as parameter : '||p_validate_date);
3589:
3590: l_tax_year := to_char(l_tax_date,'RRRR');
3591: if (l_tax_date > to_date(l_tax_year||'0405','RRRRMMDD')) THEN
3592: l_tax_date := ADD_MONTHS(to_date(l_tax_year||'0405','RRRRMMDD'),12) ; /*tax year end date*/

Line 3644: hr_utility.trace('Entering ECON Validate');

3640: l_reminder number;
3641: l_check_letters varchar2(19) := 'ABCDEFHJKLMNPQRTWXY';
3642:
3643: begin
3644: hr_utility.trace('Entering ECON Validate');
3645:
3646: -- Format Check ENNNNNNNA
3647: IF regexp_instr(econ,'^E[[:digit:]]{7}[[:alpha:]]$') = 0 THEN
3648: hr_utility.set_location('ECON Validation Fails',10);

Line 3648: hr_utility.set_location('ECON Validation Fails',10);

3644: hr_utility.trace('Entering ECON Validate');
3645:
3646: -- Format Check ENNNNNNNA
3647: IF regexp_instr(econ,'^E[[:digit:]]{7}[[:alpha:]]$') = 0 THEN
3648: hr_utility.set_location('ECON Validation Fails',10);
3649: return 0;-- Validation fails
3650: END IF;
3651:
3652: -- First Char must be E

Line 3654: hr_utility.set_location('ECON Validation Fails',10);

3650: END IF;
3651:
3652: -- First Char must be E
3653: IF substr(econ,1,1) <> 'E' THEN
3654: hr_utility.set_location('ECON Validation Fails',10);
3655: return 0;-- Validation fails
3656:
3657: -- Next 7 should be numeric ranging 3000000 up to 3999999
3658: ELSIF substr(econ,2,7) < 3000000 OR substr(econ,2,7) > 3999999 THEN

Line 3659: hr_utility.set_location('ECON Validation Fails',20);

3655: return 0;-- Validation fails
3656:
3657: -- Next 7 should be numeric ranging 3000000 up to 3999999
3658: ELSIF substr(econ,2,7) < 3000000 OR substr(econ,2,7) > 3999999 THEN
3659: hr_utility.set_location('ECON Validation Fails',20);
3660: return 0;-- Validation fails
3661: END IF;
3662:
3663: -- Last char must be alpha satifying modulas 19 rule

Line 3673: hr_utility.set_location('ECON Validation Fails',30);

3669: l_sum := l_sum + l_fixed_value;
3670: l_reminder := mod(l_sum,19);
3671:
3672: IF substr(l_check_letters,l_reminder+1,1) <> substr(econ,9,1) THEN
3673: hr_utility.set_location('ECON Validation Fails',30);
3674: return 0; -- Validation Fails
3675: END IF;
3676:
3677: return 1; -- Validation passes

Line 3678: hr_utility.trace('Leaving ECON Validate');

3674: return 0; -- Validation Fails
3675: END IF;
3676:
3677: return 1; -- Validation passes
3678: hr_utility.trace('Leaving ECON Validate');
3679: END econ_validate;
3680:
3681: FUNCTION get_version(
3682: p_assig_id IN NUMBER,

Line 3697: hr_utility.set_location('Entering: '||l_proc,1);

3693: FROM per_assignment_extra_info
3694: WHERE assignment_id = p_assig_id
3695: AND information_type = p_type;
3696: BEGIN
3697: hr_utility.set_location('Entering: '||l_proc,1);
3698: OPEN csr_ovn;
3699: FETCH csr_ovn INTO l_ovn, p_aei_id;
3700: CLOSE csr_ovn;
3701: RETURN l_ovn;

Line 3702: hr_utility.set_location('Leaving: '||l_proc,999);

3698: OPEN csr_ovn;
3699: FETCH csr_ovn INTO l_ovn, p_aei_id;
3700: CLOSE csr_ovn;
3701: RETURN l_ovn;
3702: hr_utility.set_location('Leaving: '||l_proc,999);
3703: END;
3704:
3705: -- Procedure to insert data to the archive table pay_action_information
3706: PROCEDURE insert_archive_row

Line 3717: hr_utility.set_location('Entering: '||l_proc,1);

3713: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';
3714: l_ovn NUMBER;
3715: l_action_id NUMBER;
3716: BEGIN
3717: hr_utility.set_location('Entering: '||l_proc,1);
3718:
3719: IF p_tab_rec_data.count > 0 THEN
3720: FOR i IN p_tab_rec_data.first .. p_tab_rec_data.last
3721: LOOP

Line 3722: hr_utility.trace

3718:
3719: IF p_tab_rec_data.count > 0 THEN
3720: FOR i IN p_tab_rec_data.first .. p_tab_rec_data.last
3721: LOOP
3722: hr_utility.trace
3723: (
3724: 'Defining category '|| p_tab_rec_data(i).action_info_category
3725: )
3726: ;

Line 3727: hr_utility.trace('action_context_id = '|| p_assactid);

3723: (
3724: 'Defining category '|| p_tab_rec_data(i).action_info_category
3725: )
3726: ;
3727: hr_utility.trace('action_context_id = '|| p_assactid);
3728: IF p_tab_rec_data(i).action_info_category IS NOT NULL THEN
3729: pay_action_information_api.create_action_information( p_action_information_id => l_action_id,
3730: p_object_version_number => l_ovn,
3731: p_action_information_category => p_tab_rec_data(i).action_info_category,

Line 3769: hr_utility.set_location('Leaving: '||l_proc,999);

3765: p_action_information30 => p_tab_rec_data(i).act_info30 );
3766: END IF;
3767: END LOOP;
3768: END IF;
3769: hr_utility.set_location('Leaving: '||l_proc,999);
3770: END insert_archive_row;
3771:
3772:
3773: --

Line 3795: hr_utility.set_location('Entering: '||l_proc,1);

3791:
3792: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
3793:
3794: BEGIN
3795: hr_utility.set_location('Entering: '||l_proc,1);
3796:
3797: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_people_f ppf, '
3798: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '
3799: || 'and ppa.business_group_id = ppf.business_group_id '

Line 3802: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

3798: || 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '
3799: || 'and ppa.business_group_id = ppf.business_group_id '
3800: || ' order by person_id';
3801:
3802: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
3803: -- Header validations
3804: header_validations(pactid);
3805:
3806: hr_utility.set_location(' Leaving: '||l_proc,100);

Line 3806: hr_utility.set_location(' Leaving: '||l_proc,100);

3802: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
3803: -- Header validations
3804: header_validations(pactid);
3805:
3806: hr_utility.set_location(' Leaving: '||l_proc,100);
3807:
3808: EXCEPTION
3809: WHEN OTHERS THEN
3810: hr_utility.raise_error;

Line 3810: hr_utility.raise_error;

3806: hr_utility.set_location(' Leaving: '||l_proc,100);
3807:
3808: EXCEPTION
3809: WHEN OTHERS THEN
3810: hr_utility.raise_error;
3811: END range_cursor;
3812: --
3813: --
3814: PROCEDURE internal_action_creation_eyu(

Line 4168: hr_utility.set_location('Entering: '||l_proc,1);

4164: l_latest_action_type VARCHAR2(5);
4165: l_tax_year varchar2(4) := '2013';
4166:
4167: BEGIN
4168: hr_utility.set_location('Entering: '||l_proc,1);
4169:
4170: --Fetching Request Details
4171: OPEN csr_parameter_info;
4172: FETCH csr_parameter_info

Line 4190: hr_utility.set_location('pactid : '||pactid,20);

4186: g_start_year := to_date('06-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4))-1 ),'DD-MM-YYYY') ;
4187: g_end_year := to_date('05-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
4188: END IF;
4189:
4190: hr_utility.set_location('pactid : '||pactid,20);
4191: hr_utility.set_location('stperson : '||stperson,20);
4192: hr_utility.set_location('endperson : '||endperson,20);
4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);
4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);

Line 4191: hr_utility.set_location('stperson : '||stperson,20);

4187: g_end_year := to_date('05-04-'||SUBSTR(TO_CHAR(l_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY') ;
4188: END IF;
4189:
4190: hr_utility.set_location('pactid : '||pactid,20);
4191: hr_utility.set_location('stperson : '||stperson,20);
4192: hr_utility.set_location('endperson : '||endperson,20);
4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);
4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);
4195: hr_utility.set_location('l_bg_id : '||l_business_group_id,20);

Line 4192: hr_utility.set_location('endperson : '||endperson,20);

4188: END IF;
4189:
4190: hr_utility.set_location('pactid : '||pactid,20);
4191: hr_utility.set_location('stperson : '||stperson,20);
4192: hr_utility.set_location('endperson : '||endperson,20);
4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);
4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);
4195: hr_utility.set_location('l_bg_id : '||l_business_group_id,20);
4196:

Line 4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);

4189:
4190: hr_utility.set_location('pactid : '||pactid,20);
4191: hr_utility.set_location('stperson : '||stperson,20);
4192: hr_utility.set_location('endperson : '||endperson,20);
4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);
4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);
4195: hr_utility.set_location('l_bg_id : '||l_business_group_id,20);
4196:
4197: for asg_rec in csr_asg

Line 4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);

4190: hr_utility.set_location('pactid : '||pactid,20);
4191: hr_utility.set_location('stperson : '||stperson,20);
4192: hr_utility.set_location('endperson : '||endperson,20);
4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);
4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);
4195: hr_utility.set_location('l_bg_id : '||l_business_group_id,20);
4196:
4197: for asg_rec in csr_asg
4198: loop

Line 4195: hr_utility.set_location('l_bg_id : '||l_business_group_id,20);

4191: hr_utility.set_location('stperson : '||stperson,20);
4192: hr_utility.set_location('endperson : '||endperson,20);
4193: hr_utility.set_location('l_tax_ref : '||l_tax_ref,20);
4194: hr_utility.set_location('l_effective_date : '||l_effective_date,20);
4195: hr_utility.set_location('l_bg_id : '||l_business_group_id,20);
4196:
4197: for asg_rec in csr_asg
4198: loop
4199: l_flag := 'Y';

Line 4202: hr_utility.set_location('Assignment ID : '||asg_rec.assignment_id,20);

4198: loop
4199: l_flag := 'Y';
4200: l_action_created := 'N';
4201:
4202: hr_utility.set_location('Assignment ID : '||asg_rec.assignment_id,20);
4203: hr_utility.set_location('Person ID : '||asg_rec.person_id,20);
4204: hr_utility.set_location('PAYE Aggregation : '||asg_rec.per_agg_flag,20);
4205: hr_utility.set_location('NI Aggregation : '||asg_rec.per_ni_flag,20);
4206:

Line 4203: hr_utility.set_location('Person ID : '||asg_rec.person_id,20);

4199: l_flag := 'Y';
4200: l_action_created := 'N';
4201:
4202: hr_utility.set_location('Assignment ID : '||asg_rec.assignment_id,20);
4203: hr_utility.set_location('Person ID : '||asg_rec.person_id,20);
4204: hr_utility.set_location('PAYE Aggregation : '||asg_rec.per_agg_flag,20);
4205: hr_utility.set_location('NI Aggregation : '||asg_rec.per_ni_flag,20);
4206:
4207: -- PAYE Aggregation

Line 4204: hr_utility.set_location('PAYE Aggregation : '||asg_rec.per_agg_flag,20);

4200: l_action_created := 'N';
4201:
4202: hr_utility.set_location('Assignment ID : '||asg_rec.assignment_id,20);
4203: hr_utility.set_location('Person ID : '||asg_rec.person_id,20);
4204: hr_utility.set_location('PAYE Aggregation : '||asg_rec.per_agg_flag,20);
4205: hr_utility.set_location('NI Aggregation : '||asg_rec.per_ni_flag,20);
4206:
4207: -- PAYE Aggregation
4208: if NVL(asg_rec.per_agg_flag,'N') = 'Y' then

Line 4205: hr_utility.set_location('NI Aggregation : '||asg_rec.per_ni_flag,20);

4201:
4202: hr_utility.set_location('Assignment ID : '||asg_rec.assignment_id,20);
4203: hr_utility.set_location('Person ID : '||asg_rec.person_id,20);
4204: hr_utility.set_location('PAYE Aggregation : '||asg_rec.per_agg_flag,20);
4205: hr_utility.set_location('NI Aggregation : '||asg_rec.per_ni_flag,20);
4206:
4207: -- PAYE Aggregation
4208: if NVL(asg_rec.per_agg_flag,'N') = 'Y' then
4209: open csr_rti_payroll_id(asg_rec.assignment_id);

Line 4213: hr_utility.set_location('l_rti_payroll_id : '||l_rti_payroll_id,20);

4209: open csr_rti_payroll_id(asg_rec.assignment_id);
4210: fetch csr_rti_payroll_id into l_rti_payroll_id;
4211: close csr_rti_payroll_id;
4212:
4213: hr_utility.set_location('l_rti_payroll_id : '||l_rti_payroll_id,20);
4214:
4215: -- Fetch latest asg action id , asg id for the person
4216: open csr_get_max_asg_actid_person(asg_rec.person_id);
4217: fetch csr_get_max_asg_actid_person INTO l_last_asg_action_id1,l_last_effective_date1;

Line 4220: hr_utility.set_location('l_last_asg_action_id1 : '||l_last_asg_action_id1,20);

4216: open csr_get_max_asg_actid_person(asg_rec.person_id);
4217: fetch csr_get_max_asg_actid_person INTO l_last_asg_action_id1,l_last_effective_date1;
4218: close csr_get_max_asg_actid_person;
4219:
4220: hr_utility.set_location('l_last_asg_action_id1 : '||l_last_asg_action_id1,20);
4221: hr_utility.set_location('l_last_effective_date1 : '||l_last_effective_date1,20);
4222:
4223: open csr_latest_asg(l_last_asg_action_id1);
4224: fetch csr_latest_asg INTO l_latest_asg;

Line 4221: hr_utility.set_location('l_last_effective_date1 : '||l_last_effective_date1,20);

4217: fetch csr_get_max_asg_actid_person INTO l_last_asg_action_id1,l_last_effective_date1;
4218: close csr_get_max_asg_actid_person;
4219:
4220: hr_utility.set_location('l_last_asg_action_id1 : '||l_last_asg_action_id1,20);
4221: hr_utility.set_location('l_last_effective_date1 : '||l_last_effective_date1,20);
4222:
4223: open csr_latest_asg(l_last_asg_action_id1);
4224: fetch csr_latest_asg INTO l_latest_asg;
4225: close csr_latest_asg;

Line 4227: hr_utility.set_location('l_latest_asg : '||l_latest_asg,20);

4223: open csr_latest_asg(l_last_asg_action_id1);
4224: fetch csr_latest_asg INTO l_latest_asg;
4225: close csr_latest_asg;
4226:
4227: hr_utility.set_location('l_latest_asg : '||l_latest_asg,20);
4228:
4229: if asg_rec.assignment_id <> l_latest_asg then
4230:
4231: hr_utility.set_location('Not archiving as this is not the latest assignment.',20);

Line 4231: hr_utility.set_location('Not archiving as this is not the latest assignment.',20);

4227: hr_utility.set_location('l_latest_asg : '||l_latest_asg,20);
4228:
4229: if asg_rec.assignment_id <> l_latest_asg then
4230:
4231: hr_utility.set_location('Not archiving as this is not the latest assignment.',20);
4232: l_flag := 'N';
4233: end if;
4234:
4235: end if;

Line 4240: hr_utility.set_location('asg_rec.assignment_id : '||asg_rec.assignment_id,20);

4236: --PAYE Aggregation ends
4237:
4238: if l_flag = 'Y' then
4239:
4240: hr_utility.set_location('asg_rec.assignment_id : '||asg_rec.assignment_id,20);
4241: l_fps_run_date := NULL;
4242: l_pact_id := NULL;
4243: -- Get the Last FPS run date
4244: -- check any payroll actions after that date till 5-apr-13

Line 4250: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);

4246: open csr_latest_fps_date(asg_rec.assignment_id);
4247: fetch csr_latest_fps_date into l_fps_run_date,l_pact_id;
4248: close csr_latest_fps_date;
4249:
4250: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);
4251: hr_utility.set_location('l_pact_id : '||l_pact_id,20);
4252:
4253: if l_fps_run_date is not null then
4254: open csr_latest_asg_action1(asg_rec.assignment_id,l_pact_id);

Line 4251: hr_utility.set_location('l_pact_id : '||l_pact_id,20);

4247: fetch csr_latest_fps_date into l_fps_run_date,l_pact_id;
4248: close csr_latest_fps_date;
4249:
4250: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);
4251: hr_utility.set_location('l_pact_id : '||l_pact_id,20);
4252:
4253: if l_fps_run_date is not null then
4254: open csr_latest_asg_action1(asg_rec.assignment_id,l_pact_id);
4255: fetch csr_latest_asg_action1 into l_last_asg_action_id, l_last_effective_date;

Line 4266: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);

4262: fetch csr_latest_asg_action into l_last_asg_action_id, l_last_effective_date;
4263: close csr_latest_asg_action;
4264: end if;
4265:
4266: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);
4267: hr_utility.set_location('l_last_asg_action_id : '||l_last_asg_action_id,20);
4268: hr_utility.set_location('l_last_effective_date : '||l_last_effective_date,20);
4269:
4270: if l_last_asg_action_id is not null then

Line 4267: hr_utility.set_location('l_last_asg_action_id : '||l_last_asg_action_id,20);

4263: close csr_latest_asg_action;
4264: end if;
4265:
4266: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);
4267: hr_utility.set_location('l_last_asg_action_id : '||l_last_asg_action_id,20);
4268: hr_utility.set_location('l_last_effective_date : '||l_last_effective_date,20);
4269:
4270: if l_last_asg_action_id is not null then
4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);

Line 4268: hr_utility.set_location('l_last_effective_date : '||l_last_effective_date,20);

4264: end if;
4265:
4266: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);
4267: hr_utility.set_location('l_last_asg_action_id : '||l_last_asg_action_id,20);
4268: hr_utility.set_location('l_last_effective_date : '||l_last_effective_date,20);
4269:
4270: if l_last_asg_action_id is not null then
4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);
4272:

Line 4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);

4267: hr_utility.set_location('l_last_asg_action_id : '||l_last_asg_action_id,20);
4268: hr_utility.set_location('l_last_effective_date : '||l_last_effective_date,20);
4269:
4270: if l_last_asg_action_id is not null then
4271: hr_utility.set_location('Creating assignment action for the assignment ID : '||asg_rec.assignment_id,20);
4272:
4273: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4274: -- Insert assignment into pay_assignment_actions
4275: hr_nonrun_asact.insact ( lockingactid, asg_rec.assignment_id, pactid, chunk, NULL );

Line 4285: hr_utility.set_location('lockingactid '||lockingactid, 50);

4281: fetch csr_action_type INTO l_latest_action_type;
4282: close csr_action_type;
4283:
4284: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4285: hr_utility.set_location('lockingactid '||lockingactid, 50);
4286: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4287: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4288: else
4289: if l_fps_run_date is not null then

Line 4286: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);

4282: close csr_action_type;
4283:
4284: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4285: hr_utility.set_location('lockingactid '||lockingactid, 50);
4286: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4287: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4288: else
4289: if l_fps_run_date is not null then
4290:

Line 4293: hr_utility.set_location('lockingactid '||lockingactid, 50);

4289: if l_fps_run_date is not null then
4290:
4291: for asg_actions in csr_all_actions_after_fps(asg_rec.assignment_id,l_pact_id)
4292: loop
4293: hr_utility.set_location('lockingactid '||lockingactid, 50);
4294: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4295: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4296: end loop;
4297: else

Line 4294: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);

4290:
4291: for asg_actions in csr_all_actions_after_fps(asg_rec.assignment_id,l_pact_id)
4292: loop
4293: hr_utility.set_location('lockingactid '||lockingactid, 50);
4294: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4295: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4296: end loop;
4297: else
4298: for asg_actions in csr_all_actions_tax_year(asg_rec.assignment_id)

Line 4300: hr_utility.set_location('New Starter ', 50);

4296: end loop;
4297: else
4298: for asg_actions in csr_all_actions_tax_year(asg_rec.assignment_id)
4299: loop
4300: hr_utility.set_location('New Starter ', 50);
4301: hr_utility.set_location('lockingactid '||lockingactid, 50);
4302: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4303: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4304: end loop;

Line 4301: hr_utility.set_location('lockingactid '||lockingactid, 50);

4297: else
4298: for asg_actions in csr_all_actions_tax_year(asg_rec.assignment_id)
4299: loop
4300: hr_utility.set_location('New Starter ', 50);
4301: hr_utility.set_location('lockingactid '||lockingactid, 50);
4302: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4303: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4304: end loop;
4305: end if;

Line 4302: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);

4298: for asg_actions in csr_all_actions_tax_year(asg_rec.assignment_id)
4299: loop
4300: hr_utility.set_location('New Starter ', 50);
4301: hr_utility.set_location('lockingactid '||lockingactid, 50);
4302: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4303: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4304: end loop;
4305: end if;
4306: end if;

Line 4315: hr_utility.set_location('lockingactid '||lockingactid, 50);

4311: fetch csr_action_type INTO l_latest_action_type;
4312: close csr_action_type;
4313:
4314: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4315: hr_utility.set_location('lockingactid '||lockingactid, 50);
4316: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4317: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4318: else
4319: if l_fps_run_date is not null then

Line 4316: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);

4312: close csr_action_type;
4313:
4314: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4315: hr_utility.set_location('lockingactid '||lockingactid, 50);
4316: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4317: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4318: else
4319: if l_fps_run_date is not null then
4320:

Line 4323: hr_utility.set_location('lockingactid '||lockingactid, 50);

4319: if l_fps_run_date is not null then
4320:
4321: for asg_actions in csr_all_actions_after_fps_agg(asg_rec.person_id,l_pact_id)
4322: loop
4323: hr_utility.set_location('lockingactid '||lockingactid, 50);
4324: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4325: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4326: end loop;
4327: else

Line 4324: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);

4320:
4321: for asg_actions in csr_all_actions_after_fps_agg(asg_rec.person_id,l_pact_id)
4322: loop
4323: hr_utility.set_location('lockingactid '||lockingactid, 50);
4324: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4325: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4326: end loop;
4327: else
4328: for asg_actions in csr_all_actions_tax_year_agg(asg_rec.person_id)

Line 4330: hr_utility.set_location('New Starter ', 50);

4326: end loop;
4327: else
4328: for asg_actions in csr_all_actions_tax_year_agg(asg_rec.person_id)
4329: loop
4330: hr_utility.set_location('New Starter ', 50);
4331: hr_utility.set_location('lockingactid '||lockingactid, 50);
4332: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4333: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4334: end loop;

Line 4331: hr_utility.set_location('lockingactid '||lockingactid, 50);

4327: else
4328: for asg_actions in csr_all_actions_tax_year_agg(asg_rec.person_id)
4329: loop
4330: hr_utility.set_location('New Starter ', 50);
4331: hr_utility.set_location('lockingactid '||lockingactid, 50);
4332: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4333: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4334: end loop;
4335: end if;

Line 4332: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);

4328: for asg_actions in csr_all_actions_tax_year_agg(asg_rec.person_id)
4329: loop
4330: hr_utility.set_location('New Starter ', 50);
4331: hr_utility.set_location('lockingactid '||lockingactid, 50);
4332: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4333: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4334: end loop;
4335: end if;
4336: end if;

Line 4348: hr_utility.set_location('Created assignment action for the NI Aggr assignment ID : '||asg_rec.assignment_id,20);

4344: end if; -- if l_flag = 'Y' then
4345:
4346: --Ni Aggr
4347: if l_action_created = 'Y' then
4348: hr_utility.set_location('Created assignment action for the NI Aggr assignment ID : '||asg_rec.assignment_id,20);
4349:
4350: --Get NI RTI reporting assignment
4351: open csr_get_ni_rpt_asg(asg_rec.assignment_id);
4352: fetch csr_get_ni_rpt_asg into l_ni_rpt_asg_id,l_ni_rpt_date;

Line 4355: hr_utility.set_location('l_ni_rpt_asg_id: ' || l_ni_rpt_asg_id, 50);

4351: open csr_get_ni_rpt_asg(asg_rec.assignment_id);
4352: fetch csr_get_ni_rpt_asg into l_ni_rpt_asg_id,l_ni_rpt_date;
4353: close csr_get_ni_rpt_asg;
4354:
4355: hr_utility.set_location('l_ni_rpt_asg_id: ' || l_ni_rpt_asg_id, 50);
4356:
4357: if asg_rec.assignment_id <> l_ni_rpt_asg_id then
4358:
4359: -- fetch latest asg action id , asg id for the person , if both r same create actions

Line 4364: hr_utility.set_location('l_last_asg_action_id1 : '||l_last_asg_action_id1,20);

4360: open csr_get_max_asg_actid_person_n(asg_rec.person_id,l_ni_rpt_asg_id);
4361: fetch csr_get_max_asg_actid_person_n INTO l_last_asg_action_id1,l_last_effective_date1;
4362: close csr_get_max_asg_actid_person_n;
4363:
4364: hr_utility.set_location('l_last_asg_action_id1 : '||l_last_asg_action_id1,20);
4365: hr_utility.set_location('l_last_effective_date1 : '||l_last_effective_date1,20);
4366:
4367: open csr_latest_asg(l_last_asg_action_id1);
4368: fetch csr_latest_asg INTO l_latest_asg;

Line 4365: hr_utility.set_location('l_last_effective_date1 : '||l_last_effective_date1,20);

4361: fetch csr_get_max_asg_actid_person_n INTO l_last_asg_action_id1,l_last_effective_date1;
4362: close csr_get_max_asg_actid_person_n;
4363:
4364: hr_utility.set_location('l_last_asg_action_id1 : '||l_last_asg_action_id1,20);
4365: hr_utility.set_location('l_last_effective_date1 : '||l_last_effective_date1,20);
4366:
4367: open csr_latest_asg(l_last_asg_action_id1);
4368: fetch csr_latest_asg INTO l_latest_asg;
4369: close csr_latest_asg;

Line 4371: hr_utility.set_location('l_latest_asg : ' || l_latest_asg, 50);

4367: open csr_latest_asg(l_last_asg_action_id1);
4368: fetch csr_latest_asg INTO l_latest_asg;
4369: close csr_latest_asg;
4370:
4371: hr_utility.set_location('l_latest_asg : ' || l_latest_asg, 50);
4372:
4373: if l_latest_asg = asg_rec.assignment_id then
4374: -- If RTI Reporting asg is not processed then create action for it
4375:

Line 4380: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);

4376: ----------------------------------------------------------------------------------------
4377: l_fps_run_date := NULL;
4378: -- Get the Last FPS run date
4379: -- check any payroll actions after that date till 5-apr-13
4380: hr_utility.set_location('l_fps_run_date : '||l_fps_run_date,20);
4381:
4382: open csr_latest_fps_date(l_ni_rpt_asg_id);
4383: fetch csr_latest_fps_date into l_fps_run_date,l_pact_id;
4384: if csr_latest_fps_date%found then

Line 4385: hr_utility.set_location('Cursor Found. l_fps_run_date : '||l_fps_run_date,20);

4381:
4382: open csr_latest_fps_date(l_ni_rpt_asg_id);
4383: fetch csr_latest_fps_date into l_fps_run_date,l_pact_id;
4384: if csr_latest_fps_date%found then
4385: hr_utility.set_location('Cursor Found. l_fps_run_date : '||l_fps_run_date,20);
4386: hr_utility.set_location('Cursor Found. l_pact_id : '||l_pact_id,20);
4387: end if;
4388: close csr_latest_fps_date;
4389:

Line 4386: hr_utility.set_location('Cursor Found. l_pact_id : '||l_pact_id,20);

4382: open csr_latest_fps_date(l_ni_rpt_asg_id);
4383: fetch csr_latest_fps_date into l_fps_run_date,l_pact_id;
4384: if csr_latest_fps_date%found then
4385: hr_utility.set_location('Cursor Found. l_fps_run_date : '||l_fps_run_date,20);
4386: hr_utility.set_location('Cursor Found. l_pact_id : '||l_pact_id,20);
4387: end if;
4388: close csr_latest_fps_date;
4389:
4390: if l_fps_run_date is not null then

Line 4404: hr_utility.set_location('l_last_asg_action_id: '||l_last_asg_action_id,20);

4400: fetch csr_latest_asg_action into l_last_asg_action_id, l_last_effective_date;
4401: close csr_latest_asg_action;
4402: end if;
4403:
4404: hr_utility.set_location('l_last_asg_action_id: '||l_last_asg_action_id,20);
4405: hr_utility.set_location('l_last_effective_date: '||l_last_effective_date,20);
4406:
4407: if l_last_asg_action_id is null then
4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);

Line 4405: hr_utility.set_location('l_last_effective_date: '||l_last_effective_date,20);

4401: close csr_latest_asg_action;
4402: end if;
4403:
4404: hr_utility.set_location('l_last_asg_action_id: '||l_last_asg_action_id,20);
4405: hr_utility.set_location('l_last_effective_date: '||l_last_effective_date,20);
4406:
4407: if l_last_asg_action_id is null then
4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);
4409:

Line 4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);

4404: hr_utility.set_location('l_last_asg_action_id: '||l_last_asg_action_id,20);
4405: hr_utility.set_location('l_last_effective_date: '||l_last_effective_date,20);
4406:
4407: if l_last_asg_action_id is null then
4408: hr_utility.set_location('Creating assignment action for the assignment ID : '||l_ni_rpt_asg_id,20);
4409:
4410: SELECT pay_assignment_actions_s.nextval INTO lockingactid FROM dual;
4411: -- Insert assignment into pay_assignment_actions
4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );

Line 4415: hr_utility.set_location('Action Created for RTI Reporting Ni Aggr asg : '||l_ni_rpt_asg_id,20);

4411: -- Insert assignment into pay_assignment_actions
4412: hr_nonrun_asact.insact ( lockingactid, l_ni_rpt_asg_id, pactid, chunk, NULL );
4413:
4414: --NI Aggr
4415: hr_utility.set_location('Action Created for RTI Reporting Ni Aggr asg : '||l_ni_rpt_asg_id,20);
4416:
4417: --Locking mechanism
4418: -- If NI Aggr
4419:

Line 4425: hr_utility.set_location('lockingactid '||lockingactid, 50);

4421: fetch csr_action_type INTO l_latest_action_type;
4422: close csr_action_type;
4423:
4424: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4425: hr_utility.set_location('lockingactid '||lockingactid, 50);
4426: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4427: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4428: else
4429: if l_fps_run_date is not null then

Line 4426: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);

4422: close csr_action_type;
4423:
4424: if l_latest_action_type = 'P' or l_latest_action_type = 'U' then
4425: hr_utility.set_location('lockingactid '||lockingactid, 50);
4426: hr_utility.set_location('Prepayment l_last_asg_action_id '||l_last_asg_action_id, 50);
4427: hr_nonrun_asact.insint(lockingactid, l_last_asg_action_id);
4428: else
4429: if l_fps_run_date is not null then
4430:

Line 4433: hr_utility.set_location('lockingactid '||lockingactid, 50);

4429: if l_fps_run_date is not null then
4430:
4431: for asg_actions in csr_all_actions_after_fps(l_ni_rpt_asg_id,l_pact_id)
4432: loop
4433: hr_utility.set_location('lockingactid '||lockingactid, 50);
4434: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4435: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4436: end loop;
4437: else

Line 4434: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);

4430:
4431: for asg_actions in csr_all_actions_after_fps(l_ni_rpt_asg_id,l_pact_id)
4432: loop
4433: hr_utility.set_location('lockingactid '||lockingactid, 50);
4434: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4435: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4436: end loop;
4437: else
4438: for asg_actions in csr_all_actions_tax_year(l_ni_rpt_asg_id)

Line 4440: hr_utility.set_location('New Starter ', 50);

4436: end loop;
4437: else
4438: for asg_actions in csr_all_actions_tax_year(l_ni_rpt_asg_id)
4439: loop
4440: hr_utility.set_location('New Starter ', 50);
4441: hr_utility.set_location('lockingactid '||lockingactid, 50);
4442: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4443: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4444: end loop;

Line 4441: hr_utility.set_location('lockingactid '||lockingactid, 50);

4437: else
4438: for asg_actions in csr_all_actions_tax_year(l_ni_rpt_asg_id)
4439: loop
4440: hr_utility.set_location('New Starter ', 50);
4441: hr_utility.set_location('lockingactid '||lockingactid, 50);
4442: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4443: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4444: end loop;
4445: end if;

Line 4442: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);

4438: for asg_actions in csr_all_actions_tax_year(l_ni_rpt_asg_id)
4439: loop
4440: hr_utility.set_location('New Starter ', 50);
4441: hr_utility.set_location('lockingactid '||lockingactid, 50);
4442: hr_utility.set_location('asg_actions.asg_act_id '||asg_actions.asg_act_id, 50);
4443: hr_nonrun_asact.insint(lockingactid, asg_actions.asg_act_id);
4444: end loop;
4445: end if;
4446: end if;

Line 4461: hr_utility.set_location('Leaving: '||l_proc,999);

4457: --NI Aggr
4458:
4459: end loop;
4460:
4461: hr_utility.set_location('Leaving: '||l_proc,999);
4462: END internal_action_creation_eyu;
4463: --
4464: --
4465: --

Line 4761: hr_utility.set_location('Entering '|| l_proc, 10);

4757: l_pre_pact_effective_date DATE;
4758: l_first_fps_run_date date;
4759: l_tax_year varchar2(4) := '2013';
4760: BEGIN
4761: hr_utility.set_location('Entering '|| l_proc, 10);
4762: l_err := FALSE;
4763:
4764: OPEN csr_parameter_info(p_payroll_action_id);
4765: FETCH csr_parameter_info

Line 4792: hr_utility.trace('g_paye_element_id: '||TO_CHAR(g_paye_element_id));

4788: FROM pay_element_types_f
4789: WHERE element_name = 'PAYE Details'
4790: AND legislation_code = 'GB';
4791:
4792: hr_utility.trace('g_paye_element_id: '||TO_CHAR(g_paye_element_id));
4793:
4794: --******************************
4795: l_balance_counter := 1;
4796: FOR rec IN get_defined_balance_id1

Line 4799: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);

4795: l_balance_counter := 1;
4796: FOR rec IN get_defined_balance_id1
4797: LOOP
4798: g_fps_bal_det_tab(l_balance_counter).balance_name := rec.balance_name;
4799: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);
4800: g_fps_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
4801: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
4802: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4803: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);

Line 4801: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);

4797: LOOP
4798: g_fps_bal_det_tab(l_balance_counter).balance_name := rec.balance_name;
4799: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);
4800: g_fps_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
4801: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
4802: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4803: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
4804: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4805: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);

Line 4803: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);

4799: hr_utility.trace('balance_name: '||g_fps_bal_det_tab(l_balance_counter).balance_name);
4800: g_fps_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
4801: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
4802: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4803: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
4804: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4805: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
4806: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4807: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);

Line 4805: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);

4801: hr_utility.trace('balance_type_id: '||g_fps_bal_det_tab(l_balance_counter).balance_type_id);
4802: g_fps_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4803: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
4804: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4805: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
4806: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4807: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
4808: l_balance_counter := l_balance_counter + 1;
4809: hr_utility.trace('Balance Counter: '||l_balance_counter);

Line 4807: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);

4803: hr_utility.trace('database_item_suffix: '||g_fps_bal_det_tab(l_balance_counter).database_item_suffix);
4804: g_fps_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4805: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
4806: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4807: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
4808: l_balance_counter := l_balance_counter + 1;
4809: hr_utility.trace('Balance Counter: '||l_balance_counter);
4810: END LOOP;
4811:

Line 4809: hr_utility.trace('Balance Counter: '||l_balance_counter);

4805: hr_utility.trace('balance_dimension_id: '||g_fps_bal_det_tab(l_balance_counter).balance_dimension_id);
4806: g_fps_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4807: hr_utility.trace('defined_balance_id: '||g_fps_bal_det_tab(l_balance_counter).defined_balance_id);
4808: l_balance_counter := l_balance_counter + 1;
4809: hr_utility.trace('Balance Counter: '||l_balance_counter);
4810: END LOOP;
4811:
4812: FOR i IN 1..g_fps_bal_det_tab.last
4813: LOOP

Line 4840: hr_utility.trace('balance name: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_name);

4836: l_balance_counter := 1;
4837: FOR rec IN get_aggr_defined_balance_id
4838: LOOP
4839: g_fps_aggr_bal_det_tab(l_balance_counter).balance_name := rec.balance_name;
4840: hr_utility.trace('balance name: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_name);
4841: g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
4842: hr_utility.trace('balance_type_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id);
4843: g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4844: hr_utility.trace('database_item_suffix: '||g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix);

Line 4842: hr_utility.trace('balance_type_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id);

4838: LOOP
4839: g_fps_aggr_bal_det_tab(l_balance_counter).balance_name := rec.balance_name;
4840: hr_utility.trace('balance name: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_name);
4841: g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
4842: hr_utility.trace('balance_type_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id);
4843: g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4844: hr_utility.trace('database_item_suffix: '||g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix);
4845: g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4846: hr_utility.trace('balance_dimension_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id);

Line 4844: hr_utility.trace('database_item_suffix: '||g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix);

4840: hr_utility.trace('balance name: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_name);
4841: g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id := rec.balance_type_id;
4842: hr_utility.trace('balance_type_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id);
4843: g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4844: hr_utility.trace('database_item_suffix: '||g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix);
4845: g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4846: hr_utility.trace('balance_dimension_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id);
4847: g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4848: hr_utility.trace('defined_balance_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id);

Line 4846: hr_utility.trace('balance_dimension_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id);

4842: hr_utility.trace('balance_type_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_type_id);
4843: g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix := rec.database_item_suffix;
4844: hr_utility.trace('database_item_suffix: '||g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix);
4845: g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4846: hr_utility.trace('balance_dimension_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id);
4847: g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4848: hr_utility.trace('defined_balance_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id);
4849: l_balance_counter := l_balance_counter + 1;
4850: hr_utility.trace('Balance Counter: '||l_balance_counter);

Line 4848: hr_utility.trace('defined_balance_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id);

4844: hr_utility.trace('database_item_suffix: '||g_fps_aggr_bal_det_tab(l_balance_counter).database_item_suffix);
4845: g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id := rec.balance_dimension_id;
4846: hr_utility.trace('balance_dimension_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id);
4847: g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4848: hr_utility.trace('defined_balance_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id);
4849: l_balance_counter := l_balance_counter + 1;
4850: hr_utility.trace('Balance Counter: '||l_balance_counter);
4851: END LOOP;
4852:

Line 4850: hr_utility.trace('Balance Counter: '||l_balance_counter);

4846: hr_utility.trace('balance_dimension_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).balance_dimension_id);
4847: g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id := rec.defined_balance_id;
4848: hr_utility.trace('defined_balance_id: '||g_fps_aggr_bal_det_tab(l_balance_counter).defined_balance_id);
4849: l_balance_counter := l_balance_counter + 1;
4850: hr_utility.trace('Balance Counter: '||l_balance_counter);
4851: END LOOP;
4852:
4853: FOR i IN 1..g_fps_aggr_bal_det_tab.last
4854: LOOP

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

5276: OPEN get_defined_balance_id('NI L Employee','_ASG_RUN');
5277: FETCH get_defined_balance_id INTO g_nil_e_id_run;
5278: CLOSE get_defined_balance_id;
5279:
5280: hr_utility.set_location('Leaving '|| l_proc, 10);
5281:
5282: EXCEPTION
5283: WHEN OTHERS THEN
5284: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

Line 5285: hr_utility.raise_error;

5281:
5282: EXCEPTION
5283: WHEN OTHERS THEN
5284: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
5285: hr_utility.raise_error;
5286: END archinit;
5287: --
5288: --
5289: /*--------------------------------------------------------------------------

Line 5497: hr_utility.set_location('Entering the debug: '||l_proc,1);

5493: l_fps_check NUMBER;
5494:
5495: BEGIN
5496: --archive_code begins here
5497: hr_utility.set_location('Entering the debug: '||l_proc,1);
5498: hr_utility.trace('p_assactid: '||p_assactid);
5499: hr_utility.trace('p_effective_date: '||p_effective_date);
5500:
5501: open fetch_asg_details;

Line 5498: hr_utility.trace('p_assactid: '||p_assactid);

5494:
5495: BEGIN
5496: --archive_code begins here
5497: hr_utility.set_location('Entering the debug: '||l_proc,1);
5498: hr_utility.trace('p_assactid: '||p_assactid);
5499: hr_utility.trace('p_effective_date: '||p_effective_date);
5500:
5501: open fetch_asg_details;
5502: fetch fetch_asg_details into l_asg_id,l_person_id,l_ni_flag,l_paye_flag,l_asg_no;

Line 5499: hr_utility.trace('p_effective_date: '||p_effective_date);

5495: BEGIN
5496: --archive_code begins here
5497: hr_utility.set_location('Entering the debug: '||l_proc,1);
5498: hr_utility.trace('p_assactid: '||p_assactid);
5499: hr_utility.trace('p_effective_date: '||p_effective_date);
5500:
5501: open fetch_asg_details;
5502: fetch fetch_asg_details into l_asg_id,l_person_id,l_ni_flag,l_paye_flag,l_asg_no;
5503: close fetch_asg_details;

Line 5505: hr_utility.trace('l_asg_id : '||l_asg_id);

5501: open fetch_asg_details;
5502: fetch fetch_asg_details into l_asg_id,l_person_id,l_ni_flag,l_paye_flag,l_asg_no;
5503: close fetch_asg_details;
5504:
5505: hr_utility.trace('l_asg_id : '||l_asg_id);
5506: hr_utility.trace('l_person_id : '||l_person_id);
5507: hr_utility.trace('l_ni_flag : '||l_ni_flag);
5508: hr_utility.trace('l_paye_flag : '||l_paye_flag);
5509: hr_utility.trace('l_asg_no : '||l_asg_no);

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

5502: fetch fetch_asg_details into l_asg_id,l_person_id,l_ni_flag,l_paye_flag,l_asg_no;
5503: close fetch_asg_details;
5504:
5505: hr_utility.trace('l_asg_id : '||l_asg_id);
5506: hr_utility.trace('l_person_id : '||l_person_id);
5507: hr_utility.trace('l_ni_flag : '||l_ni_flag);
5508: hr_utility.trace('l_paye_flag : '||l_paye_flag);
5509: hr_utility.trace('l_asg_no : '||l_asg_no);
5510:

Line 5507: hr_utility.trace('l_ni_flag : '||l_ni_flag);

5503: close fetch_asg_details;
5504:
5505: hr_utility.trace('l_asg_id : '||l_asg_id);
5506: hr_utility.trace('l_person_id : '||l_person_id);
5507: hr_utility.trace('l_ni_flag : '||l_ni_flag);
5508: hr_utility.trace('l_paye_flag : '||l_paye_flag);
5509: hr_utility.trace('l_asg_no : '||l_asg_no);
5510:
5511: --RETRY LOGIC

Line 5508: hr_utility.trace('l_paye_flag : '||l_paye_flag);

5504:
5505: hr_utility.trace('l_asg_id : '||l_asg_id);
5506: hr_utility.trace('l_person_id : '||l_person_id);
5507: hr_utility.trace('l_ni_flag : '||l_ni_flag);
5508: hr_utility.trace('l_paye_flag : '||l_paye_flag);
5509: hr_utility.trace('l_asg_no : '||l_asg_no);
5510:
5511: --RETRY LOGIC
5512: l_retry_req_flag := NULL;

Line 5509: hr_utility.trace('l_asg_no : '||l_asg_no);

5505: hr_utility.trace('l_asg_id : '||l_asg_id);
5506: hr_utility.trace('l_person_id : '||l_person_id);
5507: hr_utility.trace('l_ni_flag : '||l_ni_flag);
5508: hr_utility.trace('l_paye_flag : '||l_paye_flag);
5509: hr_utility.trace('l_asg_no : '||l_asg_no);
5510:
5511: --RETRY LOGIC
5512: l_retry_req_flag := NULL;
5513: open csr_is_retry_request;

Line 5519: hr_utility.trace('RETRY : l_retry_req_flag: '|| l_retry_req_flag);

5515: close csr_is_retry_request;
5516:
5517: if l_retry_req_flag = 'Y' then
5518:
5519: hr_utility.trace('RETRY : l_retry_req_flag: '|| l_retry_req_flag);
5520: open csr_get_starter_details(l_asg_id);
5521: fetch csr_get_starter_details into l_new_starter;
5522: close csr_get_starter_details;
5523:

Line 5524: hr_utility.trace('RETRY : l_new_starter.l_aei_id : '|| l_new_starter.l_aei_id);

5520: open csr_get_starter_details(l_asg_id);
5521: fetch csr_get_starter_details into l_new_starter;
5522: close csr_get_starter_details;
5523:
5524: hr_utility.trace('RETRY : l_new_starter.l_aei_id : '|| l_new_starter.l_aei_id);
5525: hr_utility.trace('RETRY : l_new_starter.l_ovn : '|| l_new_starter.l_ovn);
5526: hr_utility.trace('RETRY : l_new_starter.starter_flag : '|| l_new_starter.starter_flag);
5527: hr_utility.trace('RETRY : l_new_starter.pensioner_flag : '|| l_new_starter.pensioner_flag);
5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);

Line 5525: hr_utility.trace('RETRY : l_new_starter.l_ovn : '|| l_new_starter.l_ovn);

5521: fetch csr_get_starter_details into l_new_starter;
5522: close csr_get_starter_details;
5523:
5524: hr_utility.trace('RETRY : l_new_starter.l_aei_id : '|| l_new_starter.l_aei_id);
5525: hr_utility.trace('RETRY : l_new_starter.l_ovn : '|| l_new_starter.l_ovn);
5526: hr_utility.trace('RETRY : l_new_starter.starter_flag : '|| l_new_starter.starter_flag);
5527: hr_utility.trace('RETRY : l_new_starter.pensioner_flag : '|| l_new_starter.pensioner_flag);
5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);
5529:

Line 5526: hr_utility.trace('RETRY : l_new_starter.starter_flag : '|| l_new_starter.starter_flag);

5522: close csr_get_starter_details;
5523:
5524: hr_utility.trace('RETRY : l_new_starter.l_aei_id : '|| l_new_starter.l_aei_id);
5525: hr_utility.trace('RETRY : l_new_starter.l_ovn : '|| l_new_starter.l_ovn);
5526: hr_utility.trace('RETRY : l_new_starter.starter_flag : '|| l_new_starter.starter_flag);
5527: hr_utility.trace('RETRY : l_new_starter.pensioner_flag : '|| l_new_starter.pensioner_flag);
5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);
5529:
5530: if l_new_starter.starter_flag = 'Y' OR l_new_starter.pensioner_flag = 'Y' OR l_new_starter.expat_flag = 'Y' THEN

Line 5527: hr_utility.trace('RETRY : l_new_starter.pensioner_flag : '|| l_new_starter.pensioner_flag);

5523:
5524: hr_utility.trace('RETRY : l_new_starter.l_aei_id : '|| l_new_starter.l_aei_id);
5525: hr_utility.trace('RETRY : l_new_starter.l_ovn : '|| l_new_starter.l_ovn);
5526: hr_utility.trace('RETRY : l_new_starter.starter_flag : '|| l_new_starter.starter_flag);
5527: hr_utility.trace('RETRY : l_new_starter.pensioner_flag : '|| l_new_starter.pensioner_flag);
5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);
5529:
5530: if l_new_starter.starter_flag = 'Y' OR l_new_starter.pensioner_flag = 'Y' OR l_new_starter.expat_flag = 'Y' THEN
5531:

Line 5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);

5524: hr_utility.trace('RETRY : l_new_starter.l_aei_id : '|| l_new_starter.l_aei_id);
5525: hr_utility.trace('RETRY : l_new_starter.l_ovn : '|| l_new_starter.l_ovn);
5526: hr_utility.trace('RETRY : l_new_starter.starter_flag : '|| l_new_starter.starter_flag);
5527: hr_utility.trace('RETRY : l_new_starter.pensioner_flag : '|| l_new_starter.pensioner_flag);
5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);
5529:
5530: if l_new_starter.starter_flag = 'Y' OR l_new_starter.pensioner_flag = 'Y' OR l_new_starter.expat_flag = 'Y' THEN
5531:
5532: hr_utility.trace('RTI Sent checked.');

Line 5532: hr_utility.trace('RTI Sent checked.');

5528: hr_utility.trace('RETRY : l_new_starter.expat_flag : '|| l_new_starter.expat_flag);
5529:
5530: if l_new_starter.starter_flag = 'Y' OR l_new_starter.pensioner_flag = 'Y' OR l_new_starter.expat_flag = 'Y' THEN
5531:
5532: hr_utility.trace('RTI Sent checked.');
5533:
5534: open csr_fps_check(l_asg_id);
5535: fetch csr_fps_check into l_fps_check;
5536: close csr_fps_check;

Line 5540: hr_utility.trace('RETRY : Reset is required.');

5536: close csr_fps_check;
5537:
5538: if l_fps_check = 0 then
5539:
5540: hr_utility.trace('RETRY : Reset is required.');
5541:
5542: --EXPAT Flag
5543: IF l_new_starter.starter_flag = 'Y' THEN
5544: l_ovn := get_version(l_asg_id,'GB_RTI_ASG_DETAILS',l_new_starter.l_aei_id);

Line 5585: hr_utility.set_location('l_last_fps_pactid ' || l_last_fps_pactid ,999);

5581: fetch csr_latest_fps into l_last_fps_effdate,l_last_fps_pactid,l_report_type;
5582: close csr_latest_fps;
5583: end if;
5584:
5585: hr_utility.set_location('l_last_fps_pactid ' || l_last_fps_pactid ,999);
5586: hr_utility.set_location('l_last_fps_effdate ' || l_last_fps_effdate ,999);
5587: hr_utility.set_location('l_report_type ' || l_report_type ,999);
5588:
5589: if l_last_fps_effdate is null then

Line 5586: hr_utility.set_location('l_last_fps_effdate ' || l_last_fps_effdate ,999);

5582: close csr_latest_fps;
5583: end if;
5584:
5585: hr_utility.set_location('l_last_fps_pactid ' || l_last_fps_pactid ,999);
5586: hr_utility.set_location('l_last_fps_effdate ' || l_last_fps_effdate ,999);
5587: hr_utility.set_location('l_report_type ' || l_report_type ,999);
5588:
5589: if l_last_fps_effdate is null then
5590: l_last_fps_effdate := g_start_year;

Line 5587: hr_utility.set_location('l_report_type ' || l_report_type ,999);

5583: end if;
5584:
5585: hr_utility.set_location('l_last_fps_pactid ' || l_last_fps_pactid ,999);
5586: hr_utility.set_location('l_last_fps_effdate ' || l_last_fps_effdate ,999);
5587: hr_utility.set_location('l_report_type ' || l_report_type ,999);
5588:
5589: if l_last_fps_effdate is null then
5590: l_last_fps_effdate := g_start_year;
5591: end if;

Line 5593: hr_utility.set_location('l_last_fps_effdate : ' || l_last_fps_effdate ,999);

5589: if l_last_fps_effdate is null then
5590: l_last_fps_effdate := g_start_year;
5591: end if;
5592:
5593: hr_utility.set_location('l_last_fps_effdate : ' || l_last_fps_effdate ,999);
5594:
5595: OPEN csr_latest_asg_action(l_asg_id);
5596: FETCH csr_latest_asg_action
5597: INTO l_last_asg_action_id,

Line 5601: hr_utility.trace('l_asg_id : '||l_asg_id);

5597: INTO l_last_asg_action_id,
5598: l_last_effective_date;
5599: close csr_latest_asg_action;
5600:
5601: hr_utility.trace('l_asg_id : '||l_asg_id);
5602: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5603: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5604:
5605: hr_utility.set_location('Fetching person details ',10);

Line 5602: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);

5598: l_last_effective_date;
5599: close csr_latest_asg_action;
5600:
5601: hr_utility.trace('l_asg_id : '||l_asg_id);
5602: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5603: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5604:
5605: hr_utility.set_location('Fetching person details ',10);
5606: l_archive_person := fetch_person_rec(p_assactid, l_last_effective_date,l_archive_tab(0));

Line 5603: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);

5599: close csr_latest_asg_action;
5600:
5601: hr_utility.trace('l_asg_id : '||l_asg_id);
5602: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5603: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5604:
5605: hr_utility.set_location('Fetching person details ',10);
5606: l_archive_person := fetch_person_rec(p_assactid, l_last_effective_date,l_archive_tab(0));
5607:

Line 5605: hr_utility.set_location('Fetching person details ',10);

5601: hr_utility.trace('l_asg_id : '||l_asg_id);
5602: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5603: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5604:
5605: hr_utility.set_location('Fetching person details ',10);
5606: l_archive_person := fetch_person_rec(p_assactid, l_last_effective_date,l_archive_tab(0));
5607:
5608: hr_utility.set_location('Fetching address details ',20);
5609: l_archive_addr := fetch_address_rec(l_archive_tab(0).person_id,

Line 5608: hr_utility.set_location('Fetching address details ',20);

5604:
5605: hr_utility.set_location('Fetching person details ',10);
5606: l_archive_person := fetch_person_rec(p_assactid, l_last_effective_date,l_archive_tab(0));
5607:
5608: hr_utility.set_location('Fetching address details ',20);
5609: l_archive_addr := fetch_address_rec(l_archive_tab(0).person_id,
5610: l_archive_tab(0).assignment_id,
5611: l_last_effective_date,
5612: l_archive_tab(1));

Line 5614: hr_utility.set_location('Fetching Assignment details ',30);

5610: l_archive_tab(0).assignment_id,
5611: l_last_effective_date,
5612: l_archive_tab(1));
5613:
5614: hr_utility.set_location('Fetching Assignment details ',30);
5615: l_archive_asg_det1 := fetch_asg_det1(
5616: l_last_effective_date,
5617: l_last_asg_action_id,
5618: p_effective_date,

Line 5632: hr_utility.trace('l_asg_id : '||l_asg_id);

5628: close csr_get_max_asg_actid_person;
5629:
5630: end if;
5631:
5632: hr_utility.trace('l_asg_id : '||l_asg_id);
5633: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5634: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5635:
5636: hr_utility.set_location('Fetching Assignment details 2',30);

Line 5633: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);

5629:
5630: end if;
5631:
5632: hr_utility.trace('l_asg_id : '||l_asg_id);
5633: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5634: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5635:
5636: hr_utility.set_location('Fetching Assignment details 2',30);
5637: l_archive_asg_det2 := fetch_asg_det2(l_last_asg_action_id,l_asg_id,l_last_effective_date,l_archive_tab(2));

Line 5634: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);

5630: end if;
5631:
5632: hr_utility.trace('l_asg_id : '||l_asg_id);
5633: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5634: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5635:
5636: hr_utility.set_location('Fetching Assignment details 2',30);
5637: l_archive_asg_det2 := fetch_asg_det2(l_last_asg_action_id,l_asg_id,l_last_effective_date,l_archive_tab(2));
5638:

Line 5636: hr_utility.set_location('Fetching Assignment details 2',30);

5632: hr_utility.trace('l_asg_id : '||l_asg_id);
5633: hr_utility.set_location('l_last_asg_action_id '||l_last_asg_action_id,10);
5634: hr_utility.set_location('l_last_effective_date '||l_last_effective_date,10);
5635:
5636: hr_utility.set_location('Fetching Assignment details 2',30);
5637: l_archive_asg_det2 := fetch_asg_det2(l_last_asg_action_id,l_asg_id,l_last_effective_date,l_archive_tab(2));
5638:
5639: hr_utility.set_location('Fetching Ni details 2',30);
5640: l_archive_asg_det2 := fetch_ni_det(l_last_asg_action_id,l_asg_id,l_last_effective_date,l_archive_tab_ni_det);

Line 5639: hr_utility.set_location('Fetching Ni details 2',30);

5635:
5636: hr_utility.set_location('Fetching Assignment details 2',30);
5637: l_archive_asg_det2 := fetch_asg_det2(l_last_asg_action_id,l_asg_id,l_last_effective_date,l_archive_tab(2));
5638:
5639: hr_utility.set_location('Fetching Ni details 2',30);
5640: l_archive_asg_det2 := fetch_ni_det(l_last_asg_action_id,l_asg_id,l_last_effective_date,l_archive_tab_ni_det);
5641:
5642:
5643:

Line 5646: hr_utility.set_location('FPS/EYU Run Exist.',999);

5642:
5643:
5644: if l_last_fps_pactid is not null then
5645:
5646: hr_utility.set_location('FPS/EYU Run Exist.',999);
5647:
5648: calculate_diff (l_last_fps_pactid , l_report_type,l_asg_id, l_archive_tab ,l_flag);
5649:
5650: if l_report_type = 'RTI_FPS_REP' and NVL(l_archive_tab(0).act_info10,'N') = 'Y' then

Line 5662: hr_utility.set_location('l_flag ' || l_flag ,999);

5658: end if;
5659:
5660: fetch_nic_refund(l_asg_id,l_archive_tab_ni_det);
5661:
5662: hr_utility.set_location('l_flag ' || l_flag ,999);
5663: hr_utility.set_location('l_flag_ni ' || l_flag_ni ,999);
5664:
5665: -- no payment for the assignment exist
5666: if l_last_fps_pactid is null and l_flag_strt = 'N' then

Line 5663: hr_utility.set_location('l_flag_ni ' || l_flag_ni ,999);

5659:
5660: fetch_nic_refund(l_asg_id,l_archive_tab_ni_det);
5661:
5662: hr_utility.set_location('l_flag ' || l_flag ,999);
5663: hr_utility.set_location('l_flag_ni ' || l_flag_ni ,999);
5664:
5665: -- no payment for the assignment exist
5666: if l_last_fps_pactid is null and l_flag_strt = 'N' then
5667: populate_run_msg(p_assactid, 'No payment has been made for assignment ' || l_asg_no || '.');

Line 5678: hr_utility.set_location('Calling validations ',999);

5674: end if;
5675:
5676: if l_last_fps_pactid is null or (l_flag = 'Y' or l_flag_ni = 'Y') then
5677:
5678: hr_utility.set_location('Calling validations ',999);
5679: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
5680:
5681: person_address_validations(p_assactid, l_last_effective_date, l_archive_tab,l_asg_no,l_per_addr_val_flag);
5682: hr_utility.set_location('l_per_addr_val_flag : ' || l_per_addr_val_flag ,999);

Line 5682: hr_utility.set_location('l_per_addr_val_flag : ' || l_per_addr_val_flag ,999);

5678: hr_utility.set_location('Calling validations ',999);
5679: set_address_fields(l_archive_tab(1),l_archive_tab(0),l_archive_tab(2));
5680:
5681: person_address_validations(p_assactid, l_last_effective_date, l_archive_tab,l_asg_no,l_per_addr_val_flag);
5682: hr_utility.set_location('l_per_addr_val_flag : ' || l_per_addr_val_flag ,999);
5683: assignment_validations(p_assactid, l_last_effective_date, l_archive_tab,l_asg_no,l_asg_val_flag);
5684: hr_utility.set_location('l_asg_val_flag : ' || l_asg_val_flag ,999);
5685:
5686: IF l_archive_tab_ni_det.count > 0 THEN

Line 5684: hr_utility.set_location('l_asg_val_flag : ' || l_asg_val_flag ,999);

5680:
5681: person_address_validations(p_assactid, l_last_effective_date, l_archive_tab,l_asg_no,l_per_addr_val_flag);
5682: hr_utility.set_location('l_per_addr_val_flag : ' || l_per_addr_val_flag ,999);
5683: assignment_validations(p_assactid, l_last_effective_date, l_archive_tab,l_asg_no,l_asg_val_flag);
5684: hr_utility.set_location('l_asg_val_flag : ' || l_asg_val_flag ,999);
5685:
5686: IF l_archive_tab_ni_det.count > 0 THEN
5687: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
5688: LOOP

Line 5689: hr_utility.set_location('i : ' || i ,999);

5685:
5686: IF l_archive_tab_ni_det.count > 0 THEN
5687: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
5688: LOOP
5689: hr_utility.set_location('i : ' || i ,999);
5690: ni_validations(p_assactid, l_last_effective_date, l_archive_tab_ni_det,i,l_asg_no,l_ni_val_flag);
5691: hr_utility.set_location('l_ni_val_flag : ' || l_ni_val_flag ,999);
5692: if l_ni_val_flag = 'Y' then
5693: l_ni_val_flag1 := 'Y';

Line 5691: hr_utility.set_location('l_ni_val_flag : ' || l_ni_val_flag ,999);

5687: FOR i IN l_archive_tab_ni_det.first .. l_archive_tab_ni_det.last
5688: LOOP
5689: hr_utility.set_location('i : ' || i ,999);
5690: ni_validations(p_assactid, l_last_effective_date, l_archive_tab_ni_det,i,l_asg_no,l_ni_val_flag);
5691: hr_utility.set_location('l_ni_val_flag : ' || l_ni_val_flag ,999);
5692: if l_ni_val_flag = 'Y' then
5693: l_ni_val_flag1 := 'Y';
5694: end if;
5695: END LOOP;

Line 5699: hr_utility.set_location('Archiving - assignment action id ' || p_assactid ,999);

5695: END LOOP;
5696: END IF;
5697:
5698: if l_per_addr_val_flag = 'N' and l_asg_val_flag ='N' and l_ni_val_flag1 = 'N' then
5699: hr_utility.set_location('Archiving - assignment action id ' || p_assactid ,999);
5700: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
5701: insert_archive_row(p_assactid, p_effective_date,l_archive_tab_ni_det);
5702: else
5703: hr_utility.set_location('Validation failed - assignment action id ' || p_assactid ,999);

Line 5703: hr_utility.set_location('Validation failed - assignment action id ' || p_assactid ,999);

5699: hr_utility.set_location('Archiving - assignment action id ' || p_assactid ,999);
5700: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
5701: insert_archive_row(p_assactid, p_effective_date,l_archive_tab_ni_det);
5702: else
5703: hr_utility.set_location('Validation failed - assignment action id ' || p_assactid ,999);
5704: raise error_found;
5705: end if;
5706:
5707: end if;

Line 6141: hr_utility.trace('Entering deinit: '||l_proc);

6137: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
6138: END write_footer;
6139: ---------------------
6140: BEGIN
6141: hr_utility.trace('Entering deinit: '||l_proc);
6142:
6143: -- To avoid re-archiving while Retry
6144: delete from pay_action_information pai
6145: where pai.action_context_id = pactid

Line 6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);

6160: --Footer Validations
6161: footer_validations(l_payroll_rec.econ_number,l_flag);
6162:
6163: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);

Line 6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);

6161: footer_validations(l_payroll_rec.econ_number,l_flag);
6162:
6163: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
6169: hr_utility.set_location('g_start_year = '||g_start_year,60);

Line 6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);

6162:
6163: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
6169: hr_utility.set_location('g_start_year = '||g_start_year,60);
6170:

Line 6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);

6163: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
6169: hr_utility.set_location('g_start_year = '||g_start_year,60);
6170:
6171: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);

Line 6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);

6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
6169: hr_utility.set_location('g_start_year = '||g_start_year,60);
6170:
6171: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
6172:

Line 6169: hr_utility.set_location('g_start_year = '||g_start_year,60);

6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
6169: hr_utility.set_location('g_start_year = '||g_start_year,60);
6170:
6171: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
6172:
6173: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,

Line 6171: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);

6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
6168: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
6169: hr_utility.set_location('g_start_year = '||g_start_year,60);
6170:
6171: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
6172:
6173: pay_action_information_api.create_action_information ( p_action_information_id => l_action_info_id ,
6174: p_action_context_id => pactid ,
6175: p_action_context_type => 'PA' ,

Line 6220: hr_utility.set_location('Spawning RTI EYU output process',1);

6216: raise l_exp;
6217: end if;
6218:
6219: -- For Spawning the output Concurrent Program
6220: hr_utility.set_location('Spawning RTI EYU output process',1);
6221: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PYGBRTIEYUOP13','en','US', 'ETEXT');
6222:
6223:
6224: IF xml_layout = true and g_validation_check = 'Y' and l_person_count <> 0 THEN

Line 6232: hr_utility.set_location('Error spawning output process',1);

6228: );
6229: COMMIT;
6230: --check for process submit error
6231: IF l_request_id = 0 THEN
6232: hr_utility.set_location('Error spawning output process',1);
6233: END IF;
6234:
6235: END IF;
6236: hr_utility.set_location('Leaving: '||l_proc,999);

Line 6236: hr_utility.set_location('Leaving: '||l_proc,999);

6232: hr_utility.set_location('Error spawning output process',1);
6233: END IF;
6234:
6235: END IF;
6236: hr_utility.set_location('Leaving: '||l_proc,999);
6237:
6238: EXCEPTION
6239: When l_exp then
6240: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');