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

Line 49: hr_utility.set_location('Entering ' || l_procedure,10);

45: --
46: BEGIN
47: --
48: l_procedure := g_package || '.range_code';
49: hr_utility.set_location('Entering ' || l_procedure,10);
50:
51: --------------------------------------------------------------------------------+
52: -- Call to range_code from common apac package 'pay_apac_payslip_archive'
53: -- to archive the payroll action level data and EIT defintions.

Line 70: hr_utility.set_location('Leaving ' || l_procedure,20);

66: -- Call core package to return SQL statement
67: pay_core_payslip_utils.range_cursor(p_payroll_action_id
68: ,p_sql);
69:
70: hr_utility.set_location('Leaving ' || l_procedure,20);
71: --
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_location('Error in ' || l_procedure,30);

Line 74: hr_utility.set_location('Error in ' || l_procedure,30);

70: hr_utility.set_location('Leaving ' || l_procedure,20);
71: --
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_location('Error in ' || l_procedure,30);
75: RAISE;
76: --
77: END range_code;
78:

Line 171: hr_utility.set_location('Entering ' || l_procedure,10);

167: --
168: BEGIN
169: --
170: l_procedure := g_package || '.initialization_code';
171: hr_utility.set_location('Entering ' || l_procedure,10);
172:
173:
174: --------------------------------------------------------------------------
175: -- Code to update the payroll_id in the pay_payroll_actions tabel.

Line 208: hr_utility.set_location('Leaving ' || l_procedure,20);

204: pay_apac_payslip_archive.initialization_code(
205: p_payroll_action_id => p_payroll_action_id
206: );
207:
208: hr_utility.set_location('Leaving ' || l_procedure,20);
209: --
210: EXCEPTION
211: WHEN OTHERS THEN
212: hr_utility.set_location('Error in ' || l_procedure,10);

Line 212: hr_utility.set_location('Error in ' || l_procedure,10);

208: hr_utility.set_location('Leaving ' || l_procedure,20);
209: --
210: EXCEPTION
211: WHEN OTHERS THEN
212: hr_utility.set_location('Error in ' || l_procedure,10);
213: RAISE;
214: --
215: END initialization_code;
216:

Line 271: hr_utility.set_location('Entering ' || l_procedure,10);

267: --
268: BEGIN
269: --
270: l_procedure := g_package || '.assignment_action_code';
271: hr_utility.set_location('Entering ' || l_procedure,10);
272:
273: -- Bug 3580609
274: -- Call core package to create assignment actions
275: pay_core_payslip_utils.action_creation (

Line 287: hr_utility.set_location('Error in ' || l_procedure,10);

283: --
284: EXCEPTION
285: --
286: WHEN OTHERS THEN
287: hr_utility.set_location('Error in ' || l_procedure,10);
288: RAISE;
289: --
290: END assignment_action_code;
291:

Line 396: hr_utility.set_location('Entering ' || l_procedure,10);

392: --
393: BEGIN
394: --
395: l_procedure := g_package || '.archive_accrual_details';
396: hr_utility.set_location('Entering ' || l_procedure,10);
397:
398: hr_utility.set_location('Opening Cursor csr_leave_balance',20);
399:
400: OPEN csr_leave_balance;

Line 398: hr_utility.set_location('Opening Cursor csr_leave_balance',20);

394: --
395: l_procedure := g_package || '.archive_accrual_details';
396: hr_utility.set_location('Entering ' || l_procedure,10);
397:
398: hr_utility.set_location('Opening Cursor csr_leave_balance',20);
399:
400: OPEN csr_leave_balance;
401: FETCH csr_leave_balance INTO
402: l_accrual_plan_name

Line 427: hr_utility.set_location('Archiving Annual leave Balance information',30);

423: IF csr_leave_balance%FOUND THEN
424: --
425: -- Call to get annual leave balance
426:
427: hr_utility.set_location('Archiving Annual leave Balance information',30);
428:
429: per_accrual_calc_functions.get_net_accrual
430: (
431: p_assignment_id => p_assignment_id -- number in

Line 451: hr_utility.set_location('Archiving Leave Taken information',40);

447: --
448: END IF;
449:
450:
451: hr_utility.set_location('Archiving Leave Taken information',40);
452:
453: l_leave_taken := per_accrual_calc_functions.get_absence
454: (
455: p_assignment_id

Line 486: hr_utility.set_location('Closing Cursor csr_leave_balance',50);

482: --
483: END IF;
484: --
485: CLOSE csr_leave_balance;
486: hr_utility.set_location('Closing Cursor csr_leave_balance',50);
487:
488: hr_utility.set_location('Leaving ' || l_procedure,60);
489:
490: --

Line 488: hr_utility.set_location('Leaving ' || l_procedure,60);

484: --
485: CLOSE csr_leave_balance;
486: hr_utility.set_location('Closing Cursor csr_leave_balance',50);
487:
488: hr_utility.set_location('Leaving ' || l_procedure,60);
489:
490: --
491: EXCEPTION
492: WHEN OTHERS THEN

Line 499: hr_utility.set_location('Error in ' || l_procedure,70);

495: CLOSE csr_leave_balance;
496: --
497: END IF;
498: --
499: hr_utility.set_location('Error in ' || l_procedure,70);
500: RAISE;
501: --
502: END archive_accrual_details;
503:

Line 593: hr_utility.set_location('Entering Procedure ' || l_procedure,10);

589: --
590: BEGIN
591: --
592: l_procedure := g_package || '.archive_absences';
593: hr_utility.set_location('Entering Procedure ' || l_procedure,10);
594: --
595: FOR csr_rec in csr_asg_absences
596: LOOP
597: --

Line 598: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);

594: --
595: FOR csr_rec in csr_asg_absences
596: LOOP
597: --
598: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
599: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
600: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
601: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
602: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);

Line 599: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);

595: FOR csr_rec in csr_asg_absences
596: LOOP
597: --
598: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
599: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
600: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
601: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
602: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
603:

Line 600: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);

596: LOOP
597: --
598: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
599: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
600: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
601: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
602: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
603:
604: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);

Line 601: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);

597: --
598: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
599: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
600: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
601: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
602: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
603:
604: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
605: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

Line 602: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);

598: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
599: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
600: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
601: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
602: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
603:
604: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
605: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
606:

Line 630: hr_utility.set_location('Leaving Procedure ' || l_procedure,20);

626: );
627: --
628: END LOOP;
629: --
630: hr_utility.set_location('Leaving Procedure ' || l_procedure,20);
631: --
632: EXCEPTION
633: --
634: WHEN others THEN

Line 638: hr_utility.set_location('Error in ' || l_procedure,30);

634: WHEN others THEN
635: IF csr_asg_absences%ISOPEN THEN
636: close csr_asg_absences;
637: END IF;
638: hr_utility.set_location('Error in ' || l_procedure,30);
639: RAISE;
640: --
641: END archive_absences;
642: --

Line 803: hr_utility.set_location('Entering ' || l_procedure,10);

799: BEGIN
800: --
801:
802: l_procedure := g_package ||'.archive_stat_elements';
803: hr_utility.set_location('Entering ' || l_procedure,10);
804:
805: hr_utility.set_location('Opening Cursor csr_std_elements',20);
806:
807:

Line 805: hr_utility.set_location('Opening Cursor csr_std_elements',20);

801:
802: l_procedure := g_package ||'.archive_stat_elements';
803: hr_utility.set_location('Entering ' || l_procedure,10);
804:
805: hr_utility.set_location('Opening Cursor csr_std_elements',20);
806:
807:
808: FOR csr_rec IN csr_stat_elements
809: LOOP

Line 811: hr_utility.set_location('Archiving Details of Element ' ||csr_rec.element_reporting_name ,30);

807:
808: FOR csr_rec IN csr_stat_elements
809: LOOP
810: --
811: hr_utility.set_location('Archiving Details of Element ' ||csr_rec.element_reporting_name ,30);
812:
813: IF nvl(csr_rec.exchange_rate,0) <> 0 THEN
814: l_foreign_currency_amount := csr_rec.amount / csr_rec.exchange_rate;
815: ELSE

Line 848: hr_utility.set_location('Closing Cursor csr_std_elements',40);

844: END LOOP;
845: --
846:
847:
848: hr_utility.set_location('Closing Cursor csr_std_elements',40);
849: hr_utility.set_location('End of archive Standard Element',50);
850: hr_utility.set_location('Leaving ' || l_procedure,80);
851:
852: --

Line 849: hr_utility.set_location('End of archive Standard Element',50);

845: --
846:
847:
848: hr_utility.set_location('Closing Cursor csr_std_elements',40);
849: hr_utility.set_location('End of archive Standard Element',50);
850: hr_utility.set_location('Leaving ' || l_procedure,80);
851:
852: --
853: EXCEPTION

Line 850: hr_utility.set_location('Leaving ' || l_procedure,80);

846:
847:
848: hr_utility.set_location('Closing Cursor csr_std_elements',40);
849: hr_utility.set_location('End of archive Standard Element',50);
850: hr_utility.set_location('Leaving ' || l_procedure,80);
851:
852: --
853: EXCEPTION
854: --

Line 863: hr_utility.set_location('Error in ' || l_procedure,70);

859: CLOSE csr_stat_elements;
860: --
861: END IF;
862: --
863: hr_utility.set_location('Error in ' || l_procedure,70);
864: RAISE;
865: --
866: END archive_stat_elements;
867:

Line 923: hr_utility.set_location('Entering ' || l_procedure,10);

919:
920: BEGIN
921: --
922: l_procedure := g_package || '.archive_special_elements';
923: hr_utility.set_location('Entering ' || l_procedure,10);
924:
925: pay_cn_payslip.get_run_result_value (
926: p_assignment_action_id => p_assignment_action_id
927: ,p_element_name => p_element_name

Line 932: hr_utility.set_location('Archiving '|| p_element_name || p_input_value_name,20);

928: ,p_input_value_name => p_input_value_name
929: ,p_value => l_value
930: );
931:
932: hr_utility.set_location('Archiving '|| p_element_name || p_input_value_name,20);
933:
934: OPEN csr_elem_name;
935: FETCH csr_elem_name
936: INTO l_element_name;

Line 959: hr_utility.set_location('Leaving ' || l_procedure,30);

955: ,p_action_information10 => null
956: ,p_action_information11 => null
957: ,p_action_information12 => null
958: );
959: hr_utility.set_location('Leaving ' || l_procedure,30);
960: --
961: END archive_info_element;
962: --
963:

Line 1010: hr_utility.set_location('Entering ' || l_procedure,10);

1006: --
1007: BEGIN
1008: --
1009: l_procedure := g_package || '.archive_special_elements';
1010: hr_utility.set_location('Entering ' || l_procedure,10);
1011:
1012: archive_info_element (
1013: p_assignment_action_id => p_assignment_action_id
1014: ,p_assact_id => p_assact_id

Line 1146: hr_utility.set_location('Leaving ' || l_procedure,20);

1142: ,p_element_name => 'Special Payments Separate'
1143: ,p_input_value_name => 'Process Separate Amount'
1144: );
1145:
1146: hr_utility.set_location('Leaving ' || l_procedure,20);
1147:
1148: --
1149: END archive_special_elements;
1150: --

Line 1198: hr_utility.set_location('Entering ' || l_procedure,10);

1194: --
1195: BEGIN
1196: --
1197: l_procedure := g_package || '.archive_balances';
1198: hr_utility.set_location('Entering ' || l_procedure,10);
1199: hr_utility.set_location('Archiving balance : ' || p_narrative,20);
1200: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);
1201:
1202: -- Archive Statutory balances

Line 1199: hr_utility.set_location('Archiving balance : ' || p_narrative,20);

1195: BEGIN
1196: --
1197: l_procedure := g_package || '.archive_balances';
1198: hr_utility.set_location('Entering ' || l_procedure,10);
1199: hr_utility.set_location('Archiving balance : ' || p_narrative,20);
1200: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);
1201:
1202: -- Archive Statutory balances
1203:

Line 1200: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);

1196: --
1197: l_procedure := g_package || '.archive_balances';
1198: hr_utility.set_location('Entering ' || l_procedure,10);
1199: hr_utility.set_location('Archiving balance : ' || p_narrative,20);
1200: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);
1201:
1202: -- Archive Statutory balances
1203:
1204: pay_action_information_api.create_action_information

Line 1221: hr_utility.set_location('Leaving ' || l_procedure,30);

1217: ,p_action_information4 => fnd_number.number_to_canonical(p_value_ytd) -- Bug 3604206
1218: ,p_action_information5 => fnd_number.number_to_canonical(p_value_curr) -- Bug 3604206
1219: );
1220:
1221: hr_utility.set_location('Leaving ' || l_procedure,30);
1222: --
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: hr_utility.set_location('Error in ' || l_procedure,40);

Line 1225: hr_utility.set_location('Error in ' || l_procedure,40);

1221: hr_utility.set_location('Leaving ' || l_procedure,30);
1222: --
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: hr_utility.set_location('Error in ' || l_procedure,40);
1226: RAISE;
1227: --
1228: END archive_balances;
1229: --

Line 1325: hr_utility.set_location('Entering ' || l_procedure,10);

1321: --
1322: BEGIN
1323: --
1324: l_procedure := g_package || '.archive_stat_balances';
1325: hr_utility.set_location('Entering ' || l_procedure,10);
1326: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1327:
1328: -- Get the totals of all the balances
1329:

Line 1326: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);

1322: BEGIN
1323: --
1324: l_procedure := g_package || '.archive_stat_balances';
1325: hr_utility.set_location('Entering ' || l_procedure,10);
1326: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1327:
1328: -- Get the totals of all the balances
1329:
1330: pay_cn_payslip.balance_totals(

Line 1353: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);

1349: --
1350: OPEN csr_balance_rpt_name(l_narrative);
1351: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1352: CLOSE csr_balance_rpt_name;
1353: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1354:
1355: archive_balances(
1356: p_effective_date => p_effective_date
1357: ,p_assact_id => p_assact_id

Line 1375: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);

1371: --
1372: OPEN csr_balance_rpt_name(l_narrative);
1373: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1374: CLOSE csr_balance_rpt_name;
1375: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1376:
1377: archive_balances(
1378: p_effective_date => p_effective_date
1379: ,p_assact_id => p_assact_id

Line 1397: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);

1393: --
1394: OPEN csr_balance_rpt_name(l_narrative);
1395: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1396: CLOSE csr_balance_rpt_name;
1397: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1398:
1399: archive_balances(
1400: p_effective_date => p_effective_date
1401: ,p_assact_id => p_assact_id

Line 1420: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);

1416: OPEN csr_balance_rpt_name(l_narrative);
1417: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1418: CLOSE csr_balance_rpt_name;
1419:
1420: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1421:
1422: archive_balances(
1423: p_effective_date => p_effective_date
1424: ,p_assact_id => p_assact_id

Line 1442: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,35);

1438: --
1439: OPEN csr_balance_rpt_name(l_narrative);
1440: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1441: CLOSE csr_balance_rpt_name;
1442: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,35);
1443:
1444: archive_balances(
1445: p_effective_date => p_effective_date
1446: ,p_assact_id => p_assact_id

Line 1460: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,40);

1456: --
1457: OPEN csr_balance_rpt_name(l_narrative);
1458: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1459: CLOSE csr_balance_rpt_name;
1460: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,40);
1461:
1462: pay_cn_payslip.current_and_ytd_balances (
1463: p_prepaid_tag => 'Y'
1464: ,p_assignment_action_id => p_assact_id

Line 1486: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);

1482: --
1483: OPEN csr_balance_rpt_name(l_narrative);
1484: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1485: CLOSE csr_balance_rpt_name;
1486: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1487:
1488: pay_cn_payslip.current_and_ytd_balances (
1489: p_prepaid_tag => 'Y'
1490: ,p_assignment_action_id => p_assact_id

Line 1511: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);

1507: --
1508: OPEN csr_balance_rpt_name(l_narrative);
1509: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1510: CLOSE csr_balance_rpt_name;
1511: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1512:
1513: pay_cn_payslip.current_and_ytd_balances (
1514: p_prepaid_tag => 'Y'
1515: ,p_assignment_action_id => p_assact_id

Line 1530: hr_utility.set_location('End of Archiving Stat Balances ',100);

1526: ,p_value_ytd => l_tax_ann_bonus_ytd
1527: ,p_bal_rpt_name => l_balance_rpt_name
1528: );
1529:
1530: hr_utility.set_location('End of Archiving Stat Balances ',100);
1531:
1532: hr_utility.set_location('Leaving ' || l_procedure,110);
1533: --
1534: EXCEPTION

Line 1532: hr_utility.set_location('Leaving ' || l_procedure,110);

1528: );
1529:
1530: hr_utility.set_location('End of Archiving Stat Balances ',100);
1531:
1532: hr_utility.set_location('Leaving ' || l_procedure,110);
1533: --
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: hr_utility.set_location('Error in ' || l_procedure,120);

Line 1536: hr_utility.set_location('Error in ' || l_procedure,120);

1532: hr_utility.set_location('Leaving ' || l_procedure,110);
1533: --
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: hr_utility.set_location('Error in ' || l_procedure,120);
1537: RAISE;
1538: --
1539: END archive_stat_balances;
1540:

Line 1622: hr_utility.set_location('Entering ' || l_procedure,10);

1618: l_procedure := g_package || '.archive_employee_details';
1619: l_ovn := TO_NUMBER(NULL);
1620: l_action_info_id := TO_NUMBER(NULL);
1621:
1622: hr_utility.set_location('Entering ' || l_procedure,10);
1623:
1624: hr_utility.set_location('Opening cursor csr_arch_address',20);
1625: OPEN csr_arch_address;
1626: FETCH csr_arch_address

Line 1624: hr_utility.set_location('Opening cursor csr_arch_address',20);

1620: l_action_info_id := TO_NUMBER(NULL);
1621:
1622: hr_utility.set_location('Entering ' || l_procedure,10);
1623:
1624: hr_utility.set_location('Opening cursor csr_arch_address',20);
1625: OPEN csr_arch_address;
1626: FETCH csr_arch_address
1627: INTO l_dummy;
1628: IF csr_arch_address%NOTFOUND THEN

Line 1631: hr_utility.set_location('Opening cursor csr_le_address',30);

1627: INTO l_dummy;
1628: IF csr_arch_address%NOTFOUND THEN
1629: --
1630:
1631: hr_utility.set_location('Opening cursor csr_le_address',30);
1632:
1633: OPEN csr_le_address;
1634: FETCH csr_le_address
1635: INTO l_address_line_1, l_address_line_2, l_province, l_country, l_postal_code,l_telephone_no;

Line 1638: hr_utility.set_location('Closing cursor csr_le_address',40);

1634: FETCH csr_le_address
1635: INTO l_address_line_1, l_address_line_2, l_province, l_country, l_postal_code,l_telephone_no;
1636: CLOSE csr_le_address;
1637:
1638: hr_utility.set_location('Closing cursor csr_le_address',40);
1639:
1640: hr_utility.set_location('Opening cursor csr_file_number',50);
1641:
1642: OPEN csr_file_number;

Line 1640: hr_utility.set_location('Opening cursor csr_file_number',50);

1636: CLOSE csr_le_address;
1637:
1638: hr_utility.set_location('Closing cursor csr_le_address',40);
1639:
1640: hr_utility.set_location('Opening cursor csr_file_number',50);
1641:
1642: OPEN csr_file_number;
1643: FETCH csr_file_number
1644: INTO l_file_number;

Line 1647: hr_utility.set_location('Closing cursor csr_file_number',60);

1643: FETCH csr_file_number
1644: INTO l_file_number;
1645: CLOSE csr_file_number;
1646:
1647: hr_utility.set_location('Closing cursor csr_file_number',60);
1648: --
1649: -- Archiving the Employer Address only if it doesnot exists
1650: --
1651: hr_utility.set_location('Archiving Legal Employer Address',70);

Line 1651: hr_utility.set_location('Archiving Legal Employer Address',70);

1647: hr_utility.set_location('Closing cursor csr_file_number',60);
1648: --
1649: -- Archiving the Employer Address only if it doesnot exists
1650: --
1651: hr_utility.set_location('Archiving Legal Employer Address',70);
1652:
1653: pay_action_information_api.create_action_information
1654: (
1655: p_action_information_id => l_action_info_id,

Line 1672: hr_utility.set_location('After archival of Legal Employer Address',80);

1668: p_action_information14 => 'Legal Employer Address',
1669: p_action_information26 => l_file_number
1670: );
1671:
1672: hr_utility.set_location('After archival of Legal Employer Address',80);
1673: --
1674: END IF;
1675:
1676: CLOSE csr_arch_address;

Line 1678: hr_utility.set_location('Leaving ' || l_procedure,200);

1674: END IF;
1675:
1676: CLOSE csr_arch_address;
1677:
1678: hr_utility.set_location('Leaving ' || l_procedure,200);
1679: --
1680: EXCEPTION
1681: --
1682: WHEN OTHERS THEN

Line 1901: hr_utility.set_location('Entering ' || l_procedure,10);

1897: --
1898: BEGIN
1899: --
1900: l_procedure := g_package || '.archive_employee_details';
1901: hr_utility.set_location('Entering ' || l_procedure,10);
1902:
1903: -- call generic procedure to retrieve and archive all data for
1904: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1905:

Line 1906: hr_utility.set_location('Opening Cursor csr_tax_unit_id',20);

1902:
1903: -- call generic procedure to retrieve and archive all data for
1904: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1905:
1906: hr_utility.set_location('Opening Cursor csr_tax_unit_id',20);
1907:
1908: OPEN csr_tax_unit_id;
1909: FETCH csr_tax_unit_id INTO l_tax_unit_id;
1910: CLOSE csr_tax_unit_id;

Line 1912: hr_utility.set_location('Closing Cursor csr_tax_unit_id',30);

1908: OPEN csr_tax_unit_id;
1909: FETCH csr_tax_unit_id INTO l_tax_unit_id;
1910: CLOSE csr_tax_unit_id;
1911:
1912: hr_utility.set_location('Closing Cursor csr_tax_unit_id',30);
1913:
1914: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',40);
1915:
1916: pay_emp_action_arch.get_personal_information

Line 1914: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',40);

1910: CLOSE csr_tax_unit_id;
1911:
1912: hr_utility.set_location('Closing Cursor csr_tax_unit_id',30);
1913:
1914: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',40);
1915:
1916: pay_emp_action_arch.get_personal_information
1917: (
1918: p_payroll_action_id => p_payroll_action_id -- archive payroll_action_id

Line 1931: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);

1927: ,p_ppp_source_action_id => NULL
1928: ,p_run_action_id => p_pay_assignment_action_id
1929: );
1930:
1931: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);
1932:
1933: hr_utility.set_location('Calling update Net Pay Distribution',60);
1934:
1935: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);

Line 1933: hr_utility.set_location('Calling update Net Pay Distribution',60);

1929: );
1930:
1931: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);
1932:
1933: hr_utility.set_location('Calling update Net Pay Distribution',60);
1934:
1935: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);
1936:
1937: FOR net_pay_rec in csr_net_pay_action_info_id

Line 1935: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);

1931: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);
1932:
1933: hr_utility.set_location('Calling update Net Pay Distribution',60);
1934:
1935: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);
1936:
1937: FOR net_pay_rec in csr_net_pay_action_info_id
1938:
1939: LOOP

Line 1941: hr_utility.set_location('Opening Cursor csr_bank_details',80);

1937: FOR net_pay_rec in csr_net_pay_action_info_id
1938:
1939: LOOP
1940: --
1941: hr_utility.set_location('Opening Cursor csr_bank_details',80);
1942: OPEN csr_bank_details(
1943: net_pay_rec.action_information2
1944: ,net_pay_rec.action_information1
1945: );

Line 1953: hr_utility.set_location('Closing Cursor csr_bank_details',90);

1949: ,l_account_number
1950: ,l_percentage
1951: ,l_currency_code;
1952: CLOSE csr_bank_details;
1953: hr_utility.set_location('Closing Cursor csr_bank_details',90);
1954:
1955: l_ovn := 1;
1956:
1957: hr_utility.set_location('Archiving Bank Details',95);

Line 1957: hr_utility.set_location('Archiving Bank Details',95);

1953: hr_utility.set_location('Closing Cursor csr_bank_details',90);
1954:
1955: l_ovn := 1;
1956:
1957: hr_utility.set_location('Archiving Bank Details',95);
1958:
1959: pay_action_information_api.update_action_information
1960: (
1961: p_action_information_id => net_pay_rec.action_information_id

Line 1972: hr_utility.set_location('Closing Cursor csr_net_pay_action_info_id',100);

1968: );
1969: --
1970: END LOOP;
1971:
1972: hr_utility.set_location('Closing Cursor csr_net_pay_action_info_id',100);
1973:
1974: --
1975: -- Payroll Location available in soft coding key flexfield needs to be archived
1976: -- as this is not archived by the Core Package

Line 1983: hr_utility.set_location('Opening Cursor csr_emp_det_action_info_id',110);

1979: --
1980: -- Fetch the action_information_id of action information category EMPLOYEE DETAILS
1981: --
1982:
1983: hr_utility.set_location('Opening Cursor csr_emp_det_action_info_id',110);
1984:
1985:
1986: OPEN csr_emp_det_action_info_id;
1987: FETCH csr_emp_det_action_info_id INTO l_emp_det_act_info_id;

Line 1991: hr_utility.set_location('Closing Cursor csr_emp_det_action_info_id',120);

1987: FETCH csr_emp_det_action_info_id INTO l_emp_det_act_info_id;
1988: CLOSE csr_emp_det_action_info_id;
1989:
1990:
1991: hr_utility.set_location('Closing Cursor csr_emp_det_action_info_id',120);
1992:
1993: --
1994: -- Fetch Payroll Location
1995: --

Line 1997: hr_utility.set_location('Opening Cursor csr_soft_key',130);

1993: --
1994: -- Fetch Payroll Location
1995: --
1996:
1997: hr_utility.set_location('Opening Cursor csr_soft_key',130);
1998:
1999: -- Bug 3116630 starts
2000: -- Added code to archive Tax Area
2001: --

Line 2007: hr_utility.set_location('Closing Cursor csr_soft_key',140);

2003: FETCH csr_soft_key
2004: INTO l_tax_area,l_payroll_location;
2005: CLOSE csr_soft_key;
2006:
2007: hr_utility.set_location('Closing Cursor csr_soft_key',140);
2008: -- Bug 3139966 starts
2009: -- Added code to archive Expatriate Indicator, Passport
2010: OPEN csr_person_id;
2011: FETCH csr_person_id

Line 2015: hr_utility.set_location('Opening Cursor csr_expatriate', 150);

2011: FETCH csr_person_id
2012: INTO l_person_id;
2013: CLOSE csr_person_id;
2014:
2015: hr_utility.set_location('Opening Cursor csr_expatriate', 150);
2016:
2017: OPEN csr_expatriate (l_person_id);
2018: FETCH csr_expatriate
2019: INTO l_expatriate;

Line 2022: hr_utility.set_location('Closing Cursor csr_expatriate', 160);

2018: FETCH csr_expatriate
2019: INTO l_expatriate;
2020: CLOSE csr_expatriate;
2021:
2022: hr_utility.set_location('Closing Cursor csr_expatriate', 160);
2023:
2024: hr_utility.set_location('Opening Cursor csr_passport', 170);
2025:
2026: OPEN csr_passport (l_person_id);

Line 2024: hr_utility.set_location('Opening Cursor csr_passport', 170);

2020: CLOSE csr_expatriate;
2021:
2022: hr_utility.set_location('Closing Cursor csr_expatriate', 160);
2023:
2024: hr_utility.set_location('Opening Cursor csr_passport', 170);
2025:
2026: OPEN csr_passport (l_person_id);
2027: FETCH csr_passport
2028: INTO l_passport;

Line 2030: hr_utility.set_location('Closing Cursor csr_passport', 180);

2026: OPEN csr_passport (l_person_id);
2027: FETCH csr_passport
2028: INTO l_passport;
2029: CLOSE csr_passport;
2030: hr_utility.set_location('Closing Cursor csr_passport', 180);
2031:
2032: --
2033: -- Update Payroll Location,Tax Area, Passport and Expatriate Indicator
2034: --

Line 2036: hr_utility.set_location('Updating Tax area, Payroll location, Passport and Expat',190);

2032: --
2033: -- Update Payroll Location,Tax Area, Passport and Expatriate Indicator
2034: --
2035:
2036: hr_utility.set_location('Updating Tax area, Payroll location, Passport and Expat',190);
2037: l_ovn := 1;
2038: pay_action_information_api.update_action_information
2039: (
2040: p_action_information_id => l_emp_det_act_info_id

Line 2050: hr_utility.set_location('Archiving the Legal Employer Details',200);

2046: );
2047:
2048: -- Bug 3116630 ends
2049:
2050: hr_utility.set_location('Archiving the Legal Employer Details',200);
2051: archive_legal_employer_details
2052: (
2053: p_payroll_action_id => p_payroll_action_id
2054: ,p_employer_id => l_tax_unit_id

Line 2059: hr_utility.set_location('Leaving ' || l_procedure,200);

2055: ,p_effective_date => p_pre_effective_date
2056: );
2057:
2058: -- Bug 3139966 ends
2059: hr_utility.set_location('Leaving ' || l_procedure,200);
2060: --
2061: EXCEPTION
2062: --
2063: WHEN OTHERS THEN

Line 2089: hr_utility.set_location('Error in ' || l_procedure,10);

2085: IF csr_expatriate%ISOPEN THEN
2086: CLOSE csr_expatriate;
2087: END IF;
2088:
2089: hr_utility.set_location('Error in ' || l_procedure,10);
2090: RAISE;
2091: --
2092: END archive_employee_details;
2093:

Line 2226: hr_utility.set_location('Entering ' || l_procedure,10);

2222: --
2223: BEGIN
2224: --
2225: l_procedure := g_package || '.archive_code';
2226: hr_utility.set_location('Entering ' || l_procedure,10);
2227:
2228: -- Bug 3580609
2229: -- Create Child Assignment Actions
2230: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id

Line 2233: hr_utility.set_location('Opening Cursor get_payslip_aa',15);

2229: -- Create Child Assignment Actions
2230: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id
2231: ,p_effective_date);
2232:
2233: hr_utility.set_location('Opening Cursor get_payslip_aa',15);
2234:
2235: -- Bug 3580609
2236: -- use cursor suggested by core
2237: FOR csr_rec IN get_payslip_aa(p_assignment_action_id)

Line 2241: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);

2237: FOR csr_rec IN get_payslip_aa(p_assignment_action_id)
2238: LOOP
2239: --
2240:
2241: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
2242: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
2243:
2244: -- Added for bug 5634390
2245: open csr_payment_date(csr_rec.run_assignment_action_id);

Line 2242: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);

2238: LOOP
2239: --
2240:
2241: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
2242: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
2243:
2244: -- Added for bug 5634390
2245: open csr_payment_date(csr_rec.run_assignment_action_id);
2246: fetch csr_payment_date into l_payment_date;

Line 2368: hr_utility.set_location('Closing Cursor csr_assignment_actions',40);

2364:
2365: --
2366: END LOOP;
2367:
2368: hr_utility.set_location('Closing Cursor csr_assignment_actions',40);
2369: hr_utility.set_location('Leaving ' || l_procedure,50);
2370: --
2371: EXCEPTION
2372: WHEN OTHERS THEN

Line 2369: hr_utility.set_location('Leaving ' || l_procedure,50);

2365: --
2366: END LOOP;
2367:
2368: hr_utility.set_location('Closing Cursor csr_assignment_actions',40);
2369: hr_utility.set_location('Leaving ' || l_procedure,50);
2370: --
2371: EXCEPTION
2372: WHEN OTHERS THEN
2373: IF get_payslip_aa%ISOPEN THEN

Line 2376: hr_utility.set_location('Error in ' || l_procedure,50);

2372: WHEN OTHERS THEN
2373: IF get_payslip_aa%ISOPEN THEN
2374: close get_payslip_aa;
2375: END IF;
2376: hr_utility.set_location('Error in ' || l_procedure,50);
2377: RAISE;
2378: --
2379: END archive_code;
2380: --