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 119: hr_utility.set_location('Entering ' || l_procedure,10);

115: --
116: BEGIN
117: --
118: l_procedure := g_package || '.initialization_code';
119: hr_utility.set_location('Entering ' || l_procedure,10);
120:
121: g_archive_pact := p_payroll_action_id;
122:
123: ------------------------------------------------------------------+

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

129: pay_apac_payslip_archive.initialization_code(
130: p_payroll_action_id => p_payroll_action_id
131: );
132:
133: hr_utility.set_location('Leaving ' || l_procedure,20);
134: --
135: EXCEPTION
136: WHEN OTHERS THEN
137: hr_utility.set_location('Error in ' || l_procedure,10);

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

133: hr_utility.set_location('Leaving ' || l_procedure,20);
134: --
135: EXCEPTION
136: WHEN OTHERS THEN
137: hr_utility.set_location('Error in ' || l_procedure,10);
138: RAISE;
139: --
140: END initialization_code;
141:

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

192: --
193: BEGIN
194: --
195: l_procedure := g_package || '.assignment_action_code';
196: hr_utility.set_location('Entering ' || l_procedure,10);
197:
198: -- Bug 3580609
199: -- Call core package to create assignment actions
200: pay_core_payslip_utils.action_creation (

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

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

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

316: --
317: BEGIN
318: --
319: l_procedure := g_package || '.archive_accrual_details';
320: hr_utility.set_location('Entering ' || l_procedure,10);
321:
322: hr_utility.set_location('Opening Cursor csr_leave_balance',20);
323:
324: OPEN csr_leave_balance;

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

318: --
319: l_procedure := g_package || '.archive_accrual_details';
320: hr_utility.set_location('Entering ' || l_procedure,10);
321:
322: hr_utility.set_location('Opening Cursor csr_leave_balance',20);
323:
324: OPEN csr_leave_balance;
325: FETCH csr_leave_balance INTO
326: l_accrual_plan_name

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

333: IF csr_leave_balance%FOUND THEN
334: --
335: -- Call to get annual leave balance
336:
337: hr_utility.set_location('Archiving Annual leave Balance information',30);
338:
339: per_accrual_calc_functions.get_net_accrual
340: (
341: p_assignment_id => p_assignment_id -- number in

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

357: --
358: END IF;
359:
360:
361: hr_utility.set_location('Archiving Leave Taken information',40);
362:
363: l_leave_taken := per_accrual_calc_functions.get_absence
364: (
365: p_assignment_id

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

392: --
393: END IF;
394: --
395: CLOSE csr_leave_balance;
396: hr_utility.set_location('Closing Cursor csr_leave_balance',50);
397:
398: hr_utility.set_location('Leaving ' || l_procedure,60);
399:
400: --

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

394: --
395: CLOSE csr_leave_balance;
396: hr_utility.set_location('Closing Cursor csr_leave_balance',50);
397:
398: hr_utility.set_location('Leaving ' || l_procedure,60);
399:
400: --
401: EXCEPTION
402: WHEN OTHERS THEN

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

405: CLOSE csr_leave_balance;
406: --
407: END IF;
408: --
409: hr_utility.set_location('Error in ' || l_procedure,70);
410: RAISE;
411: --
412: END archive_accrual_details;
413:

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

496: --
497: BEGIN
498: --
499: l_procedure := g_package || '.archive_absences';
500: hr_utility.set_location('Entering Procedure ' || l_procedure,10);
501: --
502: FOR csr_rec in csr_asg_absences
503: LOOP
504: --

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

501: --
502: FOR csr_rec in csr_asg_absences
503: LOOP
504: --
505: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
506: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
507: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
508: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
509: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);

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

502: FOR csr_rec in csr_asg_absences
503: LOOP
504: --
505: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
506: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
507: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
508: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
509: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
510:

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

503: LOOP
504: --
505: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
506: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
507: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
508: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
509: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
510:
511: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);

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

504: --
505: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
506: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
507: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
508: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
509: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
510:
511: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
512: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);

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

505: hr_utility.set_location('csr_rec.name..................= ' ||csr_rec.absence_type,50);
506: hr_utility.set_location('csr_rec.element_reporting_name.= '||csr_rec.reporting_name,50);
507: hr_utility.set_location('csr_rec.start_date.............= '||to_char(csr_rec.start_date,'DD-MON-YYYY'),50);
508: hr_utility.set_location('csr_rec.end_date...............= '||to_char(csr_rec.end_date,'DD-MON-YYYY'),50);
509: hr_utility.set_location('csr_rec.absence_days.......... = '||csr_rec.absence_days,50);
510:
511: l_start_date := fnd_date.date_to_canonical(csr_rec.start_date);
512: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
513:

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

533: );
534: --
535: END LOOP;
536: --
537: hr_utility.set_location('Leaving Procedure ' || l_procedure,20);
538: --
539: EXCEPTION
540: --
541: WHEN others THEN

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

541: WHEN others THEN
542: IF csr_asg_absences%ISOPEN THEN
543: close csr_asg_absences;
544: END IF;
545: hr_utility.set_location('Error in ' || l_procedure,30);
546: RAISE;
547: --
548: END archive_absences;
549: --

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

697: BEGIN
698: --
699:
700: l_procedure := g_package ||'.archive_stat_elements';
701: hr_utility.set_location('Entering ' || l_procedure,10);
702:
703: hr_utility.set_location('Opening Cursor csr_std_elements',20);
704:
705:

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

699:
700: l_procedure := g_package ||'.archive_stat_elements';
701: hr_utility.set_location('Entering ' || l_procedure,10);
702:
703: hr_utility.set_location('Opening Cursor csr_std_elements',20);
704:
705:
706: FOR csr_rec IN csr_stat_elements
707: LOOP

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

705:
706: FOR csr_rec IN csr_stat_elements
707: LOOP
708: --
709: hr_utility.set_location('Archiving Details of Element ' ||csr_rec.element_reporting_name ,30);
710:
711: IF nvl(csr_rec.exchange_rate,0) <> 0 THEN
712: l_foreign_currency_amount := csr_rec.amount / csr_rec.exchange_rate;
713: ELSE

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

742: END LOOP;
743: --
744:
745:
746: hr_utility.set_location('Closing Cursor csr_std_elements',40);
747: hr_utility.set_location('End of archive Standard Element',50);
748: hr_utility.set_location('Leaving ' || l_procedure,80);
749:
750: --

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

743: --
744:
745:
746: hr_utility.set_location('Closing Cursor csr_std_elements',40);
747: hr_utility.set_location('End of archive Standard Element',50);
748: hr_utility.set_location('Leaving ' || l_procedure,80);
749:
750: --
751: EXCEPTION

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

744:
745:
746: hr_utility.set_location('Closing Cursor csr_std_elements',40);
747: hr_utility.set_location('End of archive Standard Element',50);
748: hr_utility.set_location('Leaving ' || l_procedure,80);
749:
750: --
751: EXCEPTION
752: --

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

757: CLOSE csr_stat_elements;
758: --
759: END IF;
760: --
761: hr_utility.set_location('Error in ' || l_procedure,70);
762: RAISE;
763: --
764: END archive_stat_elements;
765:

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

817:
818: BEGIN
819: --
820: l_procedure := g_package || '.archive_special_elements';
821: hr_utility.set_location('Entering ' || l_procedure,10);
822:
823: pay_cn_payslip.get_run_result_value (
824: p_assignment_action_id => p_assignment_action_id
825: ,p_element_name => p_element_name

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

826: ,p_input_value_name => p_input_value_name
827: ,p_value => l_value
828: );
829:
830: hr_utility.set_location('Archiving '|| p_element_name || p_input_value_name,20);
831:
832: OPEN csr_elem_name;
833: FETCH csr_elem_name
834: INTO l_element_name;

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

853: ,p_action_information10 => null
854: ,p_action_information11 => null
855: ,p_action_information12 => null
856: );
857: hr_utility.set_location('Leaving ' || l_procedure,30);
858: --
859: END archive_info_element;
860: --
861:

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

904: --
905: BEGIN
906: --
907: l_procedure := g_package || '.archive_special_elements';
908: hr_utility.set_location('Entering ' || l_procedure,10);
909:
910: archive_info_element (
911: p_assignment_action_id => p_assignment_action_id
912: ,p_assact_id => p_assact_id

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

1040: ,p_element_name => 'Special Payments Separate'
1041: ,p_input_value_name => 'Process Separate Amount'
1042: );
1043:
1044: hr_utility.set_location('Leaving ' || l_procedure,20);
1045:
1046: --
1047: END archive_special_elements;
1048: --

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

1092: --
1093: BEGIN
1094: --
1095: l_procedure := g_package || '.archive_balances';
1096: hr_utility.set_location('Entering ' || l_procedure,10);
1097: hr_utility.set_location('Archiving balance : ' || p_narrative,20);
1098: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);
1099:
1100: -- Archive Statutory balances

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

1093: BEGIN
1094: --
1095: l_procedure := g_package || '.archive_balances';
1096: hr_utility.set_location('Entering ' || l_procedure,10);
1097: hr_utility.set_location('Archiving balance : ' || p_narrative,20);
1098: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);
1099:
1100: -- Archive Statutory balances
1101:

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

1094: --
1095: l_procedure := g_package || '.archive_balances';
1096: hr_utility.set_location('Entering ' || l_procedure,10);
1097: hr_utility.set_location('Archiving balance : ' || p_narrative,20);
1098: hr_utility.set_location('Balance reporting name : ' || p_bal_rpt_name,25);
1099:
1100: -- Archive Statutory balances
1101:
1102: pay_action_information_api.create_action_information

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

1115: ,p_action_information4 => fnd_number.number_to_canonical(p_value_ytd) -- Bug 3604206
1116: ,p_action_information5 => fnd_number.number_to_canonical(p_value_curr) -- Bug 3604206
1117: );
1118:
1119: hr_utility.set_location('Leaving ' || l_procedure,30);
1120: --
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: hr_utility.set_location('Error in ' || l_procedure,40);

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

1119: hr_utility.set_location('Leaving ' || l_procedure,30);
1120: --
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: hr_utility.set_location('Error in ' || l_procedure,40);
1124: RAISE;
1125: --
1126: END archive_balances;
1127: --

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

1215: --
1216: BEGIN
1217: --
1218: l_procedure := g_package || '.archive_stat_balances';
1219: hr_utility.set_location('Entering ' || l_procedure,10);
1220: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1221:
1222: -- Get the totals of all the balances
1223:

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

1216: BEGIN
1217: --
1218: l_procedure := g_package || '.archive_stat_balances';
1219: hr_utility.set_location('Entering ' || l_procedure,10);
1220: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1221:
1222: -- Get the totals of all the balances
1223:
1224: pay_cn_payslip.balance_totals(

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

1241: --
1242: OPEN csr_balance_rpt_name(l_narrative);
1243: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1244: CLOSE csr_balance_rpt_name;
1245: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1246:
1247: archive_balances(
1248: p_effective_date => p_effective_date
1249: ,p_assact_id => p_assact_id

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

1263: --
1264: OPEN csr_balance_rpt_name(l_narrative);
1265: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1266: CLOSE csr_balance_rpt_name;
1267: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1268:
1269: archive_balances(
1270: p_effective_date => p_effective_date
1271: ,p_assact_id => p_assact_id

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

1285: --
1286: OPEN csr_balance_rpt_name(l_narrative);
1287: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1288: CLOSE csr_balance_rpt_name;
1289: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1290:
1291: archive_balances(
1292: p_effective_date => p_effective_date
1293: ,p_assact_id => p_assact_id

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

1308: OPEN csr_balance_rpt_name(l_narrative);
1309: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1310: CLOSE csr_balance_rpt_name;
1311:
1312: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,30);
1313:
1314: archive_balances(
1315: p_effective_date => p_effective_date
1316: ,p_assact_id => p_assact_id

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

1328: --
1329: OPEN csr_balance_rpt_name(l_narrative);
1330: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1331: CLOSE csr_balance_rpt_name;
1332: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,40);
1333:
1334: pay_cn_payslip.current_and_ytd_balances (
1335: p_prepaid_tag => 'Y'
1336: ,p_assignment_action_id => p_assact_id

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

1354: --
1355: OPEN csr_balance_rpt_name(l_narrative);
1356: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1357: CLOSE csr_balance_rpt_name;
1358: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1359:
1360: pay_cn_payslip.current_and_ytd_balances (
1361: p_prepaid_tag => 'Y'
1362: ,p_assignment_action_id => p_assact_id

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

1379: --
1380: OPEN csr_balance_rpt_name(l_narrative);
1381: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1382: CLOSE csr_balance_rpt_name;
1383: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1384:
1385: pay_cn_payslip.current_and_ytd_balances (
1386: p_prepaid_tag => 'Y'
1387: ,p_assignment_action_id => p_assact_id

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

1398: ,p_value_ytd => l_tax_ann_bonus_ytd
1399: ,p_bal_rpt_name => l_balance_rpt_name
1400: );
1401:
1402: hr_utility.set_location('End of Archiving Stat Balances ',100);
1403:
1404: hr_utility.set_location('Leaving ' || l_procedure,110);
1405: --
1406: EXCEPTION

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

1400: );
1401:
1402: hr_utility.set_location('End of Archiving Stat Balances ',100);
1403:
1404: hr_utility.set_location('Leaving ' || l_procedure,110);
1405: --
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: hr_utility.set_location('Error in ' || l_procedure,120);

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

1404: hr_utility.set_location('Leaving ' || l_procedure,110);
1405: --
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: hr_utility.set_location('Error in ' || l_procedure,120);
1409: RAISE;
1410: --
1411: END archive_stat_balances;
1412:

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

1490: l_procedure := g_package || '.archive_employee_details';
1491: l_ovn := TO_NUMBER(NULL);
1492: l_action_info_id := TO_NUMBER(NULL);
1493:
1494: hr_utility.set_location('Entering ' || l_procedure,10);
1495:
1496: hr_utility.set_location('Opening cursor csr_arch_address',20);
1497: OPEN csr_arch_address;
1498: FETCH csr_arch_address

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

1492: l_action_info_id := TO_NUMBER(NULL);
1493:
1494: hr_utility.set_location('Entering ' || l_procedure,10);
1495:
1496: hr_utility.set_location('Opening cursor csr_arch_address',20);
1497: OPEN csr_arch_address;
1498: FETCH csr_arch_address
1499: INTO l_dummy;
1500: IF csr_arch_address%NOTFOUND THEN

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

1499: INTO l_dummy;
1500: IF csr_arch_address%NOTFOUND THEN
1501: --
1502:
1503: hr_utility.set_location('Opening cursor csr_le_address',30);
1504:
1505: OPEN csr_le_address;
1506: FETCH csr_le_address
1507: INTO l_address_line_1, l_address_line_2, l_province, l_country, l_postal_code,l_telephone_no;

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

1506: FETCH csr_le_address
1507: INTO l_address_line_1, l_address_line_2, l_province, l_country, l_postal_code,l_telephone_no;
1508: CLOSE csr_le_address;
1509:
1510: hr_utility.set_location('Closing cursor csr_le_address',40);
1511:
1512: hr_utility.set_location('Opening cursor csr_file_number',50);
1513:
1514: OPEN csr_file_number;

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

1508: CLOSE csr_le_address;
1509:
1510: hr_utility.set_location('Closing cursor csr_le_address',40);
1511:
1512: hr_utility.set_location('Opening cursor csr_file_number',50);
1513:
1514: OPEN csr_file_number;
1515: FETCH csr_file_number
1516: INTO l_file_number;

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

1515: FETCH csr_file_number
1516: INTO l_file_number;
1517: CLOSE csr_file_number;
1518:
1519: hr_utility.set_location('Closing cursor csr_file_number',60);
1520: --
1521: -- Archiving the Employer Address only if it doesnot exists
1522: --
1523: hr_utility.set_location('Archiving Legal Employer Address',70);

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

1519: hr_utility.set_location('Closing cursor csr_file_number',60);
1520: --
1521: -- Archiving the Employer Address only if it doesnot exists
1522: --
1523: hr_utility.set_location('Archiving Legal Employer Address',70);
1524:
1525: pay_action_information_api.create_action_information
1526: (
1527: p_action_information_id => l_action_info_id,

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

1540: p_action_information14 => 'Legal Employer Address',
1541: p_action_information26 => l_file_number
1542: );
1543:
1544: hr_utility.set_location('After archival of Legal Employer Address',80);
1545: --
1546: END IF;
1547:
1548: CLOSE csr_arch_address;

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

1546: END IF;
1547:
1548: CLOSE csr_arch_address;
1549:
1550: hr_utility.set_location('Leaving ' || l_procedure,200);
1551: --
1552: EXCEPTION
1553: --
1554: WHEN OTHERS THEN

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

1769: --
1770: BEGIN
1771: --
1772: l_procedure := g_package || '.archive_employee_details';
1773: hr_utility.set_location('Entering ' || l_procedure,10);
1774:
1775: -- call generic procedure to retrieve and archive all data for
1776: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1777:

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

1774:
1775: -- call generic procedure to retrieve and archive all data for
1776: -- EMPLOYEE DETAILS, ADDRESS DETAILS and EMPLOYEE NET PAY DISTRIBUTION
1777:
1778: hr_utility.set_location('Opening Cursor csr_tax_unit_id',20);
1779:
1780: OPEN csr_tax_unit_id;
1781: FETCH csr_tax_unit_id INTO l_tax_unit_id;
1782: CLOSE csr_tax_unit_id;

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

1780: OPEN csr_tax_unit_id;
1781: FETCH csr_tax_unit_id INTO l_tax_unit_id;
1782: CLOSE csr_tax_unit_id;
1783:
1784: hr_utility.set_location('Closing Cursor csr_tax_unit_id',30);
1785:
1786: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',40);
1787:
1788: pay_emp_action_arch.get_personal_information

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

1782: CLOSE csr_tax_unit_id;
1783:
1784: hr_utility.set_location('Closing Cursor csr_tax_unit_id',30);
1785:
1786: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information ',40);
1787:
1788: pay_emp_action_arch.get_personal_information
1789: (
1790: p_payroll_action_id => p_payroll_action_id -- archive payroll_action_id

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

1799: ,p_ppp_source_action_id => NULL
1800: ,p_run_action_id => p_pay_assignment_action_id
1801: );
1802:
1803: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);
1804:
1805: hr_utility.set_location('Calling update Net Pay Distribution',60);
1806:
1807: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);

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

1801: );
1802:
1803: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);
1804:
1805: hr_utility.set_location('Calling update Net Pay Distribution',60);
1806:
1807: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);
1808:
1809: FOR net_pay_rec in csr_net_pay_action_info_id

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

1803: hr_utility.set_location('Returned from pay_emp_action_arch.csr_personal_information ',50);
1804:
1805: hr_utility.set_location('Calling update Net Pay Distribution',60);
1806:
1807: hr_utility.set_location('Opening Cursor csr_net_pay_action_info_id',70);
1808:
1809: FOR net_pay_rec in csr_net_pay_action_info_id
1810:
1811: LOOP

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

1809: FOR net_pay_rec in csr_net_pay_action_info_id
1810:
1811: LOOP
1812: --
1813: hr_utility.set_location('Opening Cursor csr_bank_details',80);
1814: OPEN csr_bank_details(
1815: net_pay_rec.action_information2
1816: ,net_pay_rec.action_information1
1817: );

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

1821: ,l_account_number
1822: ,l_percentage
1823: ,l_currency_code;
1824: CLOSE csr_bank_details;
1825: hr_utility.set_location('Closing Cursor csr_bank_details',90);
1826:
1827: l_ovn := 1;
1828:
1829: hr_utility.set_location('Archiving Bank Details',95);

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

1825: hr_utility.set_location('Closing Cursor csr_bank_details',90);
1826:
1827: l_ovn := 1;
1828:
1829: hr_utility.set_location('Archiving Bank Details',95);
1830:
1831: pay_action_information_api.update_action_information
1832: (
1833: p_action_information_id => net_pay_rec.action_information_id

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

1840: );
1841: --
1842: END LOOP;
1843:
1844: hr_utility.set_location('Closing Cursor csr_net_pay_action_info_id',100);
1845:
1846: --
1847: -- Payroll Location available in soft coding key flexfield needs to be archived
1848: -- as this is not archived by the Core Package

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

1851: --
1852: -- Fetch the action_information_id of action information category EMPLOYEE DETAILS
1853: --
1854:
1855: hr_utility.set_location('Opening Cursor csr_emp_det_action_info_id',110);
1856:
1857:
1858: OPEN csr_emp_det_action_info_id;
1859: FETCH csr_emp_det_action_info_id INTO l_emp_det_act_info_id;

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

1859: FETCH csr_emp_det_action_info_id INTO l_emp_det_act_info_id;
1860: CLOSE csr_emp_det_action_info_id;
1861:
1862:
1863: hr_utility.set_location('Closing Cursor csr_emp_det_action_info_id',120);
1864:
1865: --
1866: -- Fetch Payroll Location
1867: --

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

1865: --
1866: -- Fetch Payroll Location
1867: --
1868:
1869: hr_utility.set_location('Opening Cursor csr_soft_key',130);
1870:
1871: -- Bug 3116630 starts
1872: -- Added code to archive Tax Area
1873: --

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

1875: FETCH csr_soft_key
1876: INTO l_tax_area,l_payroll_location;
1877: CLOSE csr_soft_key;
1878:
1879: hr_utility.set_location('Closing Cursor csr_soft_key',140);
1880: -- Bug 3139966 starts
1881: -- Added code to archive Expatriate Indicator, Passport
1882: OPEN csr_person_id;
1883: FETCH csr_person_id

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

1883: FETCH csr_person_id
1884: INTO l_person_id;
1885: CLOSE csr_person_id;
1886:
1887: hr_utility.set_location('Opening Cursor csr_expatriate', 150);
1888:
1889: OPEN csr_expatriate (l_person_id);
1890: FETCH csr_expatriate
1891: INTO l_expatriate;

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

1890: FETCH csr_expatriate
1891: INTO l_expatriate;
1892: CLOSE csr_expatriate;
1893:
1894: hr_utility.set_location('Closing Cursor csr_expatriate', 160);
1895:
1896: hr_utility.set_location('Opening Cursor csr_passport', 170);
1897:
1898: OPEN csr_passport (l_person_id);

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

1892: CLOSE csr_expatriate;
1893:
1894: hr_utility.set_location('Closing Cursor csr_expatriate', 160);
1895:
1896: hr_utility.set_location('Opening Cursor csr_passport', 170);
1897:
1898: OPEN csr_passport (l_person_id);
1899: FETCH csr_passport
1900: INTO l_passport;

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

1898: OPEN csr_passport (l_person_id);
1899: FETCH csr_passport
1900: INTO l_passport;
1901: CLOSE csr_passport;
1902: hr_utility.set_location('Closing Cursor csr_passport', 180);
1903:
1904: --
1905: -- Update Payroll Location,Tax Area, Passport and Expatriate Indicator
1906: --

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

1904: --
1905: -- Update Payroll Location,Tax Area, Passport and Expatriate Indicator
1906: --
1907:
1908: hr_utility.set_location('Updating Tax area, Payroll location, Passport and Expat',190);
1909: l_ovn := 1;
1910: pay_action_information_api.update_action_information
1911: (
1912: p_action_information_id => l_emp_det_act_info_id

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

1918: );
1919:
1920: -- Bug 3116630 ends
1921:
1922: hr_utility.set_location('Archiving the Legal Employer Details',200);
1923: archive_legal_employer_details
1924: (
1925: p_payroll_action_id => p_payroll_action_id
1926: ,p_employer_id => l_tax_unit_id

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

1927: ,p_effective_date => p_pre_effective_date
1928: );
1929:
1930: -- Bug 3139966 ends
1931: hr_utility.set_location('Leaving ' || l_procedure,200);
1932: --
1933: EXCEPTION
1934: --
1935: WHEN OTHERS THEN

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

1957: IF csr_expatriate%ISOPEN THEN
1958: CLOSE csr_expatriate;
1959: END IF;
1960:
1961: hr_utility.set_location('Error in ' || l_procedure,10);
1962: RAISE;
1963: --
1964: END archive_employee_details;
1965:

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

2094: --
2095: BEGIN
2096: --
2097: l_procedure := g_package || '.archive_code';
2098: hr_utility.set_location('Entering ' || l_procedure,10);
2099:
2100: -- Bug 3580609
2101: -- Create Child Assignment Actions
2102: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id

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

2101: -- Create Child Assignment Actions
2102: pay_core_payslip_utils.generate_child_actions(p_assignment_action_id
2103: ,p_effective_date);
2104:
2105: hr_utility.set_location('Opening Cursor get_payslip_aa',15);
2106:
2107: -- Bug 3580609
2108: -- use cursor suggested by core
2109: FOR csr_rec IN get_payslip_aa(p_assignment_action_id)

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

2109: FOR csr_rec IN get_payslip_aa(p_assignment_action_id)
2110: LOOP
2111: --
2112:
2113: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
2114: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
2115:
2116: -- Added for bug 5634390
2117: open csr_payment_date(csr_rec.run_assignment_action_id);

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

2110: LOOP
2111: --
2112:
2113: hr_utility.set_location('csr_rec.master_assignment_action_id = ' || csr_rec.run_assignment_action_id,20);
2114: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' || csr_rec.pre_assignment_action_id,30);
2115:
2116: -- Added for bug 5634390
2117: open csr_payment_date(csr_rec.run_assignment_action_id);
2118: fetch csr_payment_date into l_payment_date;

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

2236:
2237: --
2238: END LOOP;
2239:
2240: hr_utility.set_location('Closing Cursor csr_assignment_actions',40);
2241: hr_utility.set_location('Leaving ' || l_procedure,50);
2242: --
2243: EXCEPTION
2244: WHEN OTHERS THEN

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

2237: --
2238: END LOOP;
2239:
2240: hr_utility.set_location('Closing Cursor csr_assignment_actions',40);
2241: hr_utility.set_location('Leaving ' || l_procedure,50);
2242: --
2243: EXCEPTION
2244: WHEN OTHERS THEN
2245: IF get_payslip_aa%ISOPEN THEN

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

2244: WHEN OTHERS THEN
2245: IF get_payslip_aa%ISOPEN THEN
2246: close get_payslip_aa;
2247: END IF;
2248: hr_utility.set_location('Error in ' || l_procedure,50);
2249: RAISE;
2250: --
2251: END archive_code;
2252: --