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_KR_PAYSLIP_ARCHIVE dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY pay_kr_payslip_archive AS
2: /* $Header: pykrparc.pkb 120.2 2006/12/08 05:05:03 pdesu noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: /********************************************************************************
7: -- This procedure returns a sql string to select a range
8: -- of assignments eligible for archival.

Line 24: hr_utility.trace(' Start of range_code');

20: IS
21: BEGIN
22:
23: IF g_debug then
24: hr_utility.trace(' Start of range_code');
25: END IF;
26:
27: -- call to APAC common archive procedure,which actually archives the EIT
28: -- balances and elements values and also the payroll action level data(like messages..etc.)

Line 36: hr_utility.trace('End of range_code');

32: pay_core_payslip_utils.range_cursor(p_payroll_action_id,
33: sqlstr);
34:
35: IF g_debug THEN
36: hr_utility.trace('End of range_code');
37: END IF;
38:
39: EXCEPTION
40: WHEN OTHERS THEN

Line 41: hr_utility.trace('Error occured in range code');

37: END IF;
38:
39: EXCEPTION
40: WHEN OTHERS THEN
41: hr_utility.trace('Error occured in range code');
42: RAISE;
43: END range_code;
44:
45: /********************************************************************************

Line 67: hr_utility.trace(' Start of Initialization Code');

63:
64: BEGIN
65:
66: if g_debug then
67: hr_utility.trace(' Start of Initialization Code');
68: end if;
69:
70: OPEN csr_archive_effective_date(p_payroll_action_id);
71: FETCH csr_archive_effective_date INTO g_archive_effective_date;

Line 77: hr_utility.trace(' g_archive_effective_date......:'||g_archive_effective_date);

73:
74: g_archive_payroll_action_id :=p_payroll_action_id;
75:
76: if g_debug then
77: hr_utility.trace(' g_archive_effective_date......:'||g_archive_effective_date);
78: hr_utility.trace(' g_archive_payroll_action_id...:'||g_archive_payroll_action_id);
79: end if;
80:
81: -- call to APAC common procedure "initilization_code" to populate the EIT's

Line 78: hr_utility.trace(' g_archive_payroll_action_id...:'||g_archive_payroll_action_id);

74: g_archive_payroll_action_id :=p_payroll_action_id;
75:
76: if g_debug then
77: hr_utility.trace(' g_archive_effective_date......:'||g_archive_effective_date);
78: hr_utility.trace(' g_archive_payroll_action_id...:'||g_archive_payroll_action_id);
79: end if;
80:
81: -- call to APAC common procedure "initilization_code" to populate the EIT's
82: -- balances and elements values into global tables

Line 88: hr_utility.trace('Exiting from initliazation Code');

84: pay_apac_payslip_archive.initialization_code(
85: p_payroll_action_id => p_payroll_action_id );
86:
87: if g_debug then
88: hr_utility.trace('Exiting from initliazation Code');
89: end if;
90:
91: EXCEPTION
92: WHEN OTHERS THEN

Line 93: hr_utility.trace('Error occured in initialization code');

89: end if;
90:
91: EXCEPTION
92: WHEN OTHERS THEN
93: hr_utility.trace('Error occured in initialization code');
94: RAISE;
95: END initialization_code;
96:
97:

Line 110: hr_utility.trace(' Start of assignment action code');

106: IS
107:
108: BEGIN
109: IF g_debug then
110: hr_utility.trace(' Start of assignment action code');
111: END IF;
112: -- Bug No: 3580598
113: pay_core_payslip_utils.action_creation (
114: p_payroll_action_id,

Line 121: hr_utility.trace('End of Assignment action code');

117: p_chunk,
118: 'KR_PAYSLIP_ARCHIVE',
119: 'KR');
120: IF g_debug then
121: hr_utility.trace('End of Assignment action code');
122: END IF;
123:
124: EXCEPTION
125: WHEN OTHERS THEN

Line 126: hr_utility.trace('Error occured in Assignment action code');

122: END IF;
123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: hr_utility.trace('Error occured in Assignment action code');
127: RAISE;
128: END assignment_action_code;
129:
130: /********************************************************************************

Line 160: hr_utility.trace('Entering the archive_kr_standard_elements procedure');

156:
157: BEGIN
158:
159: if g_debug then
160: hr_utility.trace('Entering the archive_kr_standard_elements procedure');
161: end if;
162:
163: FOR csr_record IN csr_std_elements(p_pre_assignment_action_id)
164: LOOP

Line 186: hr_utility.trace('Exiting the archive_kr_standard_elements procedure');

182:
183: END LOOP;
184:
185: if g_debug then
186: hr_utility.trace('Exiting the archive_kr_standard_elements procedure');
187: end if;
188:
189: EXCEPTION
190: WHEN OTHERS THEN

Line 191: hr_utility.trace('Error raised in Archiving KR Standard Elements');

187: end if;
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: hr_utility.trace('Error raised in Archiving KR Standard Elements');
192: RAISE;
193:
194: END archive_kr_standard_elements;
195:

Line 266: hr_utility.trace(' Start of Archive Leave Balances');

262:
263: BEGIN
264:
265: if g_debug then
266: hr_utility.trace(' Start of Archive Leave Balances');
267: end if;
268:
269: FOR leave_rec IN csr_leave_bal(p_run_assignment_action_id
270: ,p_assignment_id)

Line 273: hr_utility.trace('..l_taken_dimension..:'||leave_rec.leave_taken_dim);

269: FOR leave_rec IN csr_leave_bal(p_run_assignment_action_id
270: ,p_assignment_id)
271: LOOP
272: if g_debug then
273: hr_utility.trace('..l_taken_dimension..:'||leave_rec.leave_taken_dim);
274: end if;
275:
276: IF leave_rec.leave_taken_dim= 'KRCTD' THEN
277:

Line 287: hr_utility.trace('....l_from_date........:'||l_from_date);

283:
284: END IF;
285:
286: if g_debug then
287: hr_utility.trace('....l_from_date........:'||l_from_date);
288: end if;
289:
290: l_leave_taken:=per_accrual_calc_functions.get_absence(
291: p_assignment_id => p_assignment_id

Line 297: hr_utility.trace(' .......Leaves Taken...:'||l_leave_taken);

293: ,p_calculation_date => p_period_end_date
294: ,p_start_date => l_from_date );
295:
296: if g_debug then
297: hr_utility.trace(' .......Leaves Taken...:'||l_leave_taken);
298: end if;
299:
300: l_current_start_date:=fnd_date.date_to_canonical(l_from_date);
301: l_current_end_date :=fnd_date.date_to_canonical(p_period_end_date);

Line 304: hr_utility.trace('....l_current_start_date....:'|| l_current_start_date);

300: l_current_start_date:=fnd_date.date_to_canonical(l_from_date);
301: l_current_end_date :=fnd_date.date_to_canonical(p_period_end_date);
302:
303: if g_debug then
304: hr_utility.trace('....l_current_start_date....:'|| l_current_start_date);
305: hr_utility.trace('....l_current_end_date......:'|| l_current_end_date);
306: end if;
307:
308: per_accrual_calc_functions.get_net_accrual(

Line 305: hr_utility.trace('....l_current_end_date......:'|| l_current_end_date);

301: l_current_end_date :=fnd_date.date_to_canonical(p_period_end_date);
302:
303: if g_debug then
304: hr_utility.trace('....l_current_start_date....:'|| l_current_start_date);
305: hr_utility.trace('....l_current_end_date......:'|| l_current_end_date);
306: end if;
307:
308: per_accrual_calc_functions.get_net_accrual(
309: p_assignment_id => p_assignment_id

Line 326: hr_utility.trace('..Leave Balances...........:'|| l_leave_balance);

322:
323: l_leave_balance := l_accrual - l_leave_taken;
324:
325: if g_debug then
326: hr_utility.trace('..Leave Balances...........:'|| l_leave_balance);
327: hr_utility.trace('..archiving the ABSENCES Info');
328: end if;
329:
330: pay_action_information_api.create_action_information (

Line 327: hr_utility.trace('..archiving the ABSENCES Info');

323: l_leave_balance := l_accrual - l_leave_taken;
324:
325: if g_debug then
326: hr_utility.trace('..Leave Balances...........:'|| l_leave_balance);
327: hr_utility.trace('..archiving the ABSENCES Info');
328: end if;
329:
330: pay_action_information_api.create_action_information (
331: p_action_information_id => l_action_info_id

Line 352: hr_utility.trace('Error occured in archive_leave_balances');

348: END LOOP;
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: hr_utility.trace('Error occured in archive_leave_balances');
353: RAISE;
354: END archive_leave_balances;
355:
356: /********************************************************************************

Line 378: hr_utility.trace(' Start Of populate_multiple_runtypes_msg');

374:
375: BEGIN
376:
377: if g_debug then
378: hr_utility.trace(' Start Of populate_multiple_runtypes_msg');
379: end if;
380:
381: fnd_message.set_name('PAY','PAY_KR_RUN_TYPE_WARNING_MESG');
382:

Line 386: hr_utility.trace(' l_message_text..:'||l_message_text);

382:
383: l_message_text := fnd_message.get;
384:
385: if g_debug then
386: hr_utility.trace(' l_message_text..:'||l_message_text);
387: hr_utility.trace(' Inserting the multiple run types message into PAY_MESSAGE_LINES table');
388: end if;
389:
390: INSERT INTO pay_message_lines(line_sequence,

Line 387: hr_utility.trace(' Inserting the multiple run types message into PAY_MESSAGE_LINES table');

383: l_message_text := fnd_message.get;
384:
385: if g_debug then
386: hr_utility.trace(' l_message_text..:'||l_message_text);
387: hr_utility.trace(' Inserting the multiple run types message into PAY_MESSAGE_LINES table');
388: end if;
389:
390: INSERT INTO pay_message_lines(line_sequence,
391: payroll_id,

Line 407: hr_utility.trace(' End Of populate_multiple_runtypes_msg');

403: );
404:
405:
406: if g_debug then
407: hr_utility.trace(' End Of populate_multiple_runtypes_msg');
408: end if;
409:
410: EXCEPTION
411: WHEN OTHERS THEN

Line 412: hr_utility.trace('Error occured in archive_leave_balances');

408: end if;
409:
410: EXCEPTION
411: WHEN OTHERS THEN
412: hr_utility.trace('Error occured in archive_leave_balances');
413: RAISE;
414:
415: END populate_multiple_runtypes_msg;
416:

Line 473: hr_utility.trace(' Start Of archive_kr_employee_details');

469:
470: BEGIN
471:
472: if g_debug then
473: hr_utility.trace(' Start Of archive_kr_employee_details');
474: end if;
475:
476: FOR csr_record IN csr_additional_info(p_assignment_id,p_run_effective_date)
477: LOOP

Line 487: hr_utility.trace(' l_kr_job_title ...:'||l_kr_job_title);

483:
484: END LOOP;
485:
486: if g_debug then
487: hr_utility.trace(' l_kr_job_title ...:'||l_kr_job_title);
488: hr_utility.trace(' l_kr_seniority....:'||l_kr_seniority);
489: hr_utility.trace(' l_second_grade....:'||l_second_grade);
490: hr_utility.trace(' l_grade_point.....:'||l_grade_point);
491: end if;

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

484: END LOOP;
485:
486: if g_debug then
487: hr_utility.trace(' l_kr_job_title ...:'||l_kr_job_title);
488: hr_utility.trace(' l_kr_seniority....:'||l_kr_seniority);
489: hr_utility.trace(' l_second_grade....:'||l_second_grade);
490: hr_utility.trace(' l_grade_point.....:'||l_grade_point);
491: end if;
492:

Line 489: hr_utility.trace(' l_second_grade....:'||l_second_grade);

485:
486: if g_debug then
487: hr_utility.trace(' l_kr_job_title ...:'||l_kr_job_title);
488: hr_utility.trace(' l_kr_seniority....:'||l_kr_seniority);
489: hr_utility.trace(' l_second_grade....:'||l_second_grade);
490: hr_utility.trace(' l_grade_point.....:'||l_grade_point);
491: end if;
492:
493: OPEN csr_run_type_name(p_run_type_id);

Line 490: hr_utility.trace(' l_grade_point.....:'||l_grade_point);

486: if g_debug then
487: hr_utility.trace(' l_kr_job_title ...:'||l_kr_job_title);
488: hr_utility.trace(' l_kr_seniority....:'||l_kr_seniority);
489: hr_utility.trace(' l_second_grade....:'||l_second_grade);
490: hr_utility.trace(' l_grade_point.....:'||l_grade_point);
491: end if;
492:
493: OPEN csr_run_type_name(p_run_type_id);
494: FETCH csr_run_type_name INTO l_kr_run_type_name;

Line 498: hr_utility.trace('l_kr_run_type_name...:'|| l_kr_run_type_name);

494: FETCH csr_run_type_name INTO l_kr_run_type_name;
495: CLOSE csr_run_type_name;
496:
497: if g_debug then
498: hr_utility.trace('l_kr_run_type_name...:'|| l_kr_run_type_name);
499: end if;
500:
501: pay_action_information_api.create_action_information (
502: p_action_information_id => l_action_info_id

Line 518: hr_utility.trace(' End Of archive_kr_employee_details');

514: ,p_action_information25 => l_grade_point
515: );
516:
517: if g_debug then
518: hr_utility.trace(' End Of archive_kr_employee_details');
519: end if;
520:
521: EXCEPTION
522: WHEN OTHERS THEN

Line 523: hr_utility.trace('Error occured in archive_kr_employee_details');

519: end if;
520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: hr_utility.trace('Error occured in archive_kr_employee_details');
524: RAISE;
525: END archive_employee_other_info;
526:
527: /********************************************************************************

Line 596: hr_utility.trace(' Start Of archive_employee_details');

592:
593: BEGIN
594:
595: if g_debug then
596: hr_utility.trace(' Start Of archive_employee_details');
597: end if;
598:
599: pay_emp_action_arch.get_personal_information(
600: p_payroll_action_id => g_archive_payroll_action_id -- arch payroll action id

Line 614: hr_utility.trace(' Updating the Bank Details..');

610: ,p_run_action_id => p_run_action_id -- Latest run asst_act_id
611: );
612:
613: if g_debug then
614: hr_utility.trace(' Updating the Bank Details..');
615: end if;
616:
617: FOR net_pay_rec IN csr_net_pay(p_assignment_action_id)
618: LOOP

Line 622: hr_utility.trace(' Bank Name....:'||net_pay_rec.bank_name);

618: LOOP
619: l_ovn :=1;
620:
621: if g_debug then
622: hr_utility.trace(' Bank Name....:'||net_pay_rec.bank_name);
623: end if;
624:
625: pay_action_information_api.update_action_information (
626: p_action_information_id => net_pay_rec.action_information_id

Line 632: hr_utility.trace(' Updating the Employer Name with Business Place');

628: ,p_action_information9 => net_pay_rec.bank_name );
629: END LOOP;
630:
631: if g_debug then
632: hr_utility.trace(' Updating the Employer Name with Business Place');
633: end if;
634:
635: OPEN csr_business_place(p_tax_unit_id);
636: FETCH csr_business_place INTO l_kr_business_place;

Line 640: hr_utility.trace(' Business Place ..:'|| l_kr_business_place);

636: FETCH csr_business_place INTO l_kr_business_place;
637: CLOSE csr_business_place;
638:
639: if g_debug then
640: hr_utility.trace(' Business Place ..:'|| l_kr_business_place);
641: end if;
642:
643: FOR emp_rec IN csr_emp_details(p_assignment_action_id)
644: LOOP

Line 649: hr_utility.trace(' Updating the Employer Name..:'||emp_rec.action_information18);

645:
646: l_ovn :=1;
647:
648: if g_debug then
649: hr_utility.trace(' Updating the Employer Name..:'||emp_rec.action_information18);
650: hr_utility.trace(' with Business Place ..:'||l_kr_business_place);
651: end if;
652:
653: pay_action_information_api.update_action_information (

Line 650: hr_utility.trace(' with Business Place ..:'||l_kr_business_place);

646: l_ovn :=1;
647:
648: if g_debug then
649: hr_utility.trace(' Updating the Employer Name..:'||emp_rec.action_information18);
650: hr_utility.trace(' with Business Place ..:'||l_kr_business_place);
651: end if;
652:
653: pay_action_information_api.update_action_information (
654: p_action_information_id => emp_rec.action_information_id

Line 661: hr_utility.trace(' End Of archive_employee_details');

657:
658: END LOOP;
659:
660: if g_debug then
661: hr_utility.trace(' End Of archive_employee_details');
662: end if;
663:
664: EXCEPTION
665: WHEN OTHERS THEN

Line 666: hr_utility.trace('Error occured in archive_employee_details');

662: end if;
663:
664: EXCEPTION
665: WHEN OTHERS THEN
666: hr_utility.trace('Error occured in archive_employee_details');
667: RAISE;
668: END archive_employee_details;
669:
670: /********************************************************************************

Line 797: hr_utility.trace('Entering the archive_code');

793:
794: BEGIN
795:
796: if g_debug then
797: hr_utility.trace('Entering the archive_code');
798: end if;
799: -- Bug No: 3580598
800: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id,
801: p_effective_date);

Line 806: hr_utility.trace(' ..for master assignment action id..:'||csr_master_record.run_assignment_action_id);

802: l_pre_assignment_action_id:=0;
803:
804: FOR csr_master_record IN get_payslip_aa(p_assignment_action_id) LOOP
805: IF g_debug then
806: hr_utility.trace(' ..for master assignment action id..:'||csr_master_record.run_assignment_action_id);
807: hr_utility.trace(' ..for assignment_id..:'||csr_master_record.assignment_id);
808: END IF;
809:
810: -- This condition is for to archive the data once for each prepayment

Line 807: hr_utility.trace(' ..for assignment_id..:'||csr_master_record.assignment_id);

803:
804: FOR csr_master_record IN get_payslip_aa(p_assignment_action_id) LOOP
805: IF g_debug then
806: hr_utility.trace(' ..for master assignment action id..:'||csr_master_record.run_assignment_action_id);
807: hr_utility.trace(' ..for assignment_id..:'||csr_master_record.assignment_id);
808: END IF;
809:
810: -- This condition is for to archive the data once for each prepayment
811: -- So for the case of two payroll runs under the single prepayment we have to archive

Line 829: hr_utility.trace(' ..l_period_end_date...:'||l_period_end_date);

825: END IF;
826: CLOSE csr_get_termination_date;
827:
828: if g_debug then
829: hr_utility.trace(' ..l_period_end_date...:'||l_period_end_date);
830: hr_utility.trace(' ..l_payment_date ...:'||l_payment_date);
831: end if;
832:
833: archive_employee_details (

Line 830: hr_utility.trace(' ..l_payment_date ...:'||l_payment_date);

826: CLOSE csr_get_termination_date;
827:
828: if g_debug then
829: hr_utility.trace(' ..l_period_end_date...:'||l_period_end_date);
830: hr_utility.trace(' ..l_payment_date ...:'||l_payment_date);
831: end if;
832:
833: archive_employee_details (
834: -- 3580598

Line 900: hr_utility.trace(' l_run_type_count ....:'||l_run_type_count);

896: l_run_type_id :=csr_master_record.run_type_id;
897:
898: END LOOP; /* End of the csr_run_assignment_actions(p_assignment_action_id) Loop */
899: if g_debug then
900: hr_utility.trace(' l_run_type_count ....:'||l_run_type_count);
901: end if;
902: IF l_run_type_count > 1 THEN
903: OPEN csr_msg_sequence;
904: FETCH csr_msg_sequence INTO l_line_sequence;

Line 916: hr_utility.trace('Exiting from the archive_code');

912: ,p_source_type => 'A'
913: );
914: END IF;
915: if g_debug then
916: hr_utility.trace('Exiting from the archive_code');
917: end if;
918: EXCEPTION
919: WHEN OTHERS THEN
920: hr_utility.trace('Error raised in archive_code');

Line 920: hr_utility.trace('Error raised in archive_code');

916: hr_utility.trace('Exiting from the archive_code');
917: end if;
918: EXCEPTION
919: WHEN OTHERS THEN
920: hr_utility.trace('Error raised in archive_code');
921: RAISE;
922: END archive_code;
923: END pay_kr_payslip_archive; /* End Of the Package Body */