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

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

147: BEGIN
148: --
149: -- Load the boilerplate for totals and balances against their entities
150: --
151: hr_utility.set_location('Entering ' || l_proc,10);
152: --
153: -- Get the descriptive text for running subtotals and YTD balances
154: --
155: pay_fr_arc_pkg.load_payslip_text (

Line 158: hr_utility.set_location('Step ' || l_proc,20);

154: --
155: pay_fr_arc_pkg.load_payslip_text (
156: p_action_id => pactid);
157: --
158: hr_utility.set_location('Step ' || l_proc,20);
159: --
160: -- Return the select string
161: --
162: sqlstr := 'SELECT DISTINCT person_id

Line 169: hr_utility.set_location(' Leaving: '||l_proc,50);

165: WHERE ppa.payroll_action_id = :payroll_action_id
166: AND ppa.business_group_id = ppf.business_group_id
167: ORDER BY ppf.person_id';
168: --
169: hr_utility.set_location(' Leaving: '||l_proc,50);
170: EXCEPTION
171: WHEN OTHERS THEN
172: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);
173: -- Return cursor that selects no rows

Line 172: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);

168: --
169: hr_utility.set_location(' Leaving: '||l_proc,50);
170: EXCEPTION
171: WHEN OTHERS THEN
172: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);
173: -- Return cursor that selects no rows
174: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
175: END range_cursor;
176: ---------------------------------------------------------------------------------------------------

Line 220: hr_utility.set_location('Entering ' || l_proc,20);

216: rec_this csr_assignments%ROWTYPE;
217: l_counter number := 0;
218: --
219: BEGIN
220: hr_utility.set_location('Entering ' || l_proc,20);
221:
222: if g_payroll_action_id is null
223: or g_payroll_action_id <> pactid
224: then

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

251: ,rec_this.establishment_id);
252: -- lock this prepayment record with the newly created assignment action
253: hr_nonrun_asact.insint(l_actid, rec_this.assignment_action_id);
254: END LOOP;
255: hr_utility.set_location('Leaving ' || l_proc, 100);
256: EXCEPTION
257: WHEN OTHERS THEN
258: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);
259: END action_creation;

Line 258: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);

254: END LOOP;
255: hr_utility.set_location('Leaving ' || l_proc, 100);
256: EXCEPTION
257: WHEN OTHERS THEN
258: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,50);
259: END action_creation;
260: ---------------------------------------------------------------------------------------------------
261: -- ARCHINIT --
262: -- DESCRIPTION : populates defined balance ids for later use.

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

311: BEGIN
312: --
313: -- Load the defined balance ids, note balance 12 is a PTD
314: --
315: hr_utility.set_location('Entering ' || l_proc, 10);
316: hr_utility.set_location('Loading def balance ids ' || l_proc, 20);
317: g_1total_gross_pay_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_GROSS_PAY'
318: ,'Assignment Establishment Year To Date');
319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'

Line 316: hr_utility.set_location('Loading def balance ids ' || l_proc, 20);

312: --
313: -- Load the defined balance ids, note balance 12 is a PTD
314: --
315: hr_utility.set_location('Entering ' || l_proc, 10);
316: hr_utility.set_location('Loading def balance ids ' || l_proc, 20);
317: g_1total_gross_pay_db := pay_fr_arc_pkg.get_balance_id('FR_TOTAL_GROSS_PAY'
318: ,'Assignment Establishment Year To Date');
319: g_2ss_ceiling_db := pay_fr_arc_pkg.get_balance_id('FR_SS_CEILING'
320: ,'Assignment Establishment Year To Date');

Line 344: hr_utility.set_location('Loading translated names ' || l_proc, 50);

340: ,'Assignment Establishment Period To Date');
341: --
342: -- Get the translated names of input values from NAME Translations lookup
343: --
344: hr_utility.set_location('Loading translated names ' || l_proc, 50);
345: g_fr_name_pay_value := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','PAY VALUE'),1,30), g_us_name_pay_value);
346: g_retro_tl := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RETRO'),1,30), g_retro_tl);
347: g_fr_name_rate := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','RATE'),1,30), g_fr_name_rate);
348: g_fr_name_base := nvl(substr(hr_general.decode_lookup('NAME_TRANSLATIONS','BASE'),1,30), g_fr_name_base);

Line 372: hr_utility.set_location('Loading parameters ' || l_proc, 60);

368: --
369: if g_payroll_action_id is null
370: or g_payroll_action_id <> p_payroll_action_id
371: then
372: hr_utility.set_location('Loading parameters ' || l_proc, 60);
373: pay_fr_arc_pkg.get_all_parameters
374: (p_payroll_action_id => p_payroll_action_id
375: ,p_payroll_id => g_param_payroll_id
376: ,p_assignment_id => g_param_assignment_id

Line 384: hr_utility.set_location('Loading dimension ' || l_proc, 70);

380: ,p_effective_date => g_param_effective_date);
381: g_payroll_action_id := p_payroll_action_id;
382: end if;
383: --
384: hr_utility.set_location('Loading dimension ' || l_proc, 70);
385: open csr_get_dimension('Assignment Run To Date');
386: fetch csr_get_dimension into g_asg_run;
387: close csr_get_dimension;
388: --

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

494: fnd_global.lookup_security_group('FR_FIXED_TIME_UNITS',3);
495: g_sec_grp_id_fixed_time_freq :=
496: fnd_global.lookup_security_group('FR_FIXED_TIME_FREQUENCY',3);
497: --
498: hr_utility.set_location('Leaving ' || l_proc, 100);
499: --
500: END archinit;
501: ---------------------------------------------------------------------------------------------------
502: -- ARCHIVE CODE

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

526: --
527: l_child boolean;
528: --
529: BEGIN
530: hr_utility.set_location('Entering ' || l_proc,10);
531: --
532: -- Determine if need to create child actions and store in a loop, or
533: -- just archive the data under the action created in Action Creation
534: --

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

624: --
625: l_proc VARCHAR2(40):= g_package||' Archive code Sub';
626: --
627: BEGIN
628: hr_utility.set_location('Entering ' || l_proc,10);
629: --
630: -------------------------------------------------------------------
631: -- Get instance variables for this particular assignment action
632: -------------------------------------------------------------------

Line 643: hr_utility.set_location('Step ' || l_proc,20);

639: --
640: -------------------------------------------------------------------
641: -- Get latest date earned (no archiving) and process type
642: -------------------------------------------------------------------
643: hr_utility.set_location('Step ' || l_proc,20);
644: pay_fr_arc_pkg.get_latest_run_data (
645: p_archive_action_id => p_assactid
646: ,p_assignment_id => l_assignment_id
647: ,p_establishment_id => l_establishment_id

Line 660: hr_utility.set_location('Step ' || l_proc,30);

656: -------------------------------------------------------------------
657: -- Get the employee dates start / end estab, pay_period dates,
658: -- term date, sen date and archive
659: -------------------------------------------------------------------
660: hr_utility.set_location('Step ' || l_proc,30);
661: pay_fr_arc_pkg.load_employee_dates (
662: p_assignment_id => l_assignment_id
663: ,p_effective_date => g_param_effective_date
664: ,p_assignment_action_id => p_assactid

Line 674: hr_utility.trace('asg ' || to_char(l_assignment_id));

670: ,p_term_atd => l_term_atd
671: ,p_term_lwd => l_term_lwd
672: ,p_term_pay_schedule => l_term_pay_schedule);
673: --
674: hr_utility.trace('asg ' || to_char(l_assignment_id));
675: hr_utility.trace('est ' || to_char(l_establishment_id));
676: hr_utility.trace('asat ' || to_char(l_ee_asat_date));
677: -------------------------------------------------------------------
678: -- Get the employee data and archive AS AT p_asat date

Line 675: hr_utility.trace('est ' || to_char(l_establishment_id));

671: ,p_term_lwd => l_term_lwd
672: ,p_term_pay_schedule => l_term_pay_schedule);
673: --
674: hr_utility.trace('asg ' || to_char(l_assignment_id));
675: hr_utility.trace('est ' || to_char(l_establishment_id));
676: hr_utility.trace('asat ' || to_char(l_ee_asat_date));
677: -------------------------------------------------------------------
678: -- Get the employee data and archive AS AT p_asat date
679: -------------------------------------------------------------------

Line 676: hr_utility.trace('asat ' || to_char(l_ee_asat_date));

672: ,p_term_pay_schedule => l_term_pay_schedule);
673: --
674: hr_utility.trace('asg ' || to_char(l_assignment_id));
675: hr_utility.trace('est ' || to_char(l_establishment_id));
676: hr_utility.trace('asat ' || to_char(l_ee_asat_date));
677: -------------------------------------------------------------------
678: -- Get the employee data and archive AS AT p_asat date
679: -------------------------------------------------------------------
680: hr_utility.set_location('Step ' || l_proc,40);

Line 680: hr_utility.set_location('Step ' || l_proc,40);

676: hr_utility.trace('asat ' || to_char(l_ee_asat_date));
677: -------------------------------------------------------------------
678: -- Get the employee data and archive AS AT p_asat date
679: -------------------------------------------------------------------
680: hr_utility.set_location('Step ' || l_proc,40);
681: hr_utility.set_location('person_id is ' || to_char(l_person_id),12);
682: pay_fr_arc_pkg.load_employee (
683: p_assignment_id => l_assignment_id
684: ,p_person_id => l_person_id

Line 681: hr_utility.set_location('person_id is ' || to_char(l_person_id),12);

677: -------------------------------------------------------------------
678: -- Get the employee data and archive AS AT p_asat date
679: -------------------------------------------------------------------
680: hr_utility.set_location('Step ' || l_proc,40);
681: hr_utility.set_location('person_id is ' || to_char(l_person_id),12);
682: pay_fr_arc_pkg.load_employee (
683: p_assignment_id => l_assignment_id
684: ,p_person_id => l_person_id
685: ,p_asat_date => l_ee_asat_date

Line 694: hr_utility.set_location('Step ' || l_proc,50);

690: --
691: -------------------------------------------------------------------
692: -- Get the balance values and archive
693: -------------------------------------------------------------------
694: hr_utility.set_location('Step ' || l_proc,50);
695: pay_fr_arc_pkg.load_balances(
696: p_assignment_action_id => l_latest_assignment_action_id /* TO GET BALANCE VALUES */
697: ,p_archive_action_id => p_assactid
698: ,p_context_id => l_establishment_id

Line 704: hr_utility.set_location('Step ' || l_proc,60);

700: --
701: -------------------------------------------------------------------
702: -- Get the Holidays values and archive
703: -------------------------------------------------------------------
704: hr_utility.set_location('Step ' || l_proc,60);
705: pay_fr_arc_pkg.load_holidays (
706: p_assignment_id => l_assignment_id
707: ,p_person_id => l_person_id
708: ,p_effective_date => g_param_effective_date

Line 716: hr_utility.set_location('Step ' || l_proc,70);

712: --
713: -------------------------------------------------------------------
714: -- Get the BANK values and archive
715: -------------------------------------------------------------------
716: hr_utility.set_location('Step ' || l_proc,70);
717: pay_fr_arc_pkg.load_bank (
718: p_assignment_action_id => p_assactid
719: ,p_assignment_id => l_assignment_id
720: ,p_totals_previous_advice => l_totals_c8_previous_advice

Line 729: hr_utility.set_location('Step ' || l_proc,80);

725: --
726: -------------------------------------------------------------------
727: -- Get the MESSAGES values and archive
728: -------------------------------------------------------------------
729: hr_utility.set_location('Step ' || l_proc,80);
730: pay_fr_arc_pkg.load_messages (
731: p_archive_assignment_action_id => p_assactid
732: ,p_establishment_id => l_establishment_id
733: ,p_term_atd => l_term_atd

Line 740: hr_utility.set_location('Step ' || l_proc,90);

736: -------------------------------------------------------------------
737: -- Get the Rate GROUPED Earnings and Net payments run values and archive
738: -- pass back total gross pay, net pay and court orders
739: -------------------------------------------------------------------
740: hr_utility.set_location('Step ' || l_proc,90);
741: pay_fr_arc_pkg.load_ee_rate_grouped_runs(
742: p_archive_assignment_action_id => p_assactid
743: ,p_assignment_id => l_assignment_id
744: ,p_latest_process_type => l_latest_process_type

Line 760: hr_utility.set_location('Step ' || l_proc,100);

756: --
757: -------------------------------------------------------------------
758: -- Get the DEDUCTIONS values and archive
759: -------------------------------------------------------------------
760: hr_utility.set_location('Step ' || l_proc,100);
761: pay_fr_arc_pkg.load_deductions(
762: p_archive_assignment_action_id => p_assactid
763: ,p_assignment_id => l_assignment_id
764: ,p_latest_process_type => l_latest_process_type

Line 775: hr_utility.set_location('Step ' || l_proc,110);

771: --
772: -------------------------------------------------------------------
773: -- Get the RATE GROUPED run values and archive (net ee and ER LV)
774: -------------------------------------------------------------------
775: hr_utility.set_location('Step ' || l_proc,110);
776: pay_fr_arc_pkg.load_rate_grouped_runs(
777: p_archive_assignment_action_id => p_assactid
778: ,p_assignment_id => l_assignment_id
779: ,p_latest_process_type => l_latest_process_type

Line 820: hr_utility.trace(' l_totals_c7_total_pay ' || l_totals_c7_total_pay);

816: -- (ie notified by this payslip)
817: --
818: if greatest(to_number(nvl(l_totals_c7_total_pay,0)),0) <>
819: greatest(to_number(nvl(l_totals_c9_this_advice,0)),0) then
820: hr_utility.trace(' l_totals_c7_total_pay ' || l_totals_c7_total_pay);
821: hr_utility.trace(' l_totals_c9_this_advice ' || l_totals_c9_this_advice);
822: hr_utility.set_message(801, 'PAY_74982_INCONSISTENT_PAY');
823: -- hr_utility.raise_error;
824: end if;

Line 821: hr_utility.trace(' l_totals_c9_this_advice ' || l_totals_c9_this_advice);

817: --
818: if greatest(to_number(nvl(l_totals_c7_total_pay,0)),0) <>
819: greatest(to_number(nvl(l_totals_c9_this_advice,0)),0) then
820: hr_utility.trace(' l_totals_c7_total_pay ' || l_totals_c7_total_pay);
821: hr_utility.trace(' l_totals_c9_this_advice ' || l_totals_c9_this_advice);
822: hr_utility.set_message(801, 'PAY_74982_INCONSISTENT_PAY');
823: -- hr_utility.raise_error;
824: end if;
825: --

Line 822: hr_utility.set_message(801, 'PAY_74982_INCONSISTENT_PAY');

818: if greatest(to_number(nvl(l_totals_c7_total_pay,0)),0) <>
819: greatest(to_number(nvl(l_totals_c9_this_advice,0)),0) then
820: hr_utility.trace(' l_totals_c7_total_pay ' || l_totals_c7_total_pay);
821: hr_utility.trace(' l_totals_c9_this_advice ' || l_totals_c9_this_advice);
822: hr_utility.set_message(801, 'PAY_74982_INCONSISTENT_PAY');
823: -- hr_utility.raise_error;
824: end if;
825: --
826: -- test if this payslip should be suppressed

Line 823: -- hr_utility.raise_error;

819: greatest(to_number(nvl(l_totals_c9_this_advice,0)),0) then
820: hr_utility.trace(' l_totals_c7_total_pay ' || l_totals_c7_total_pay);
821: hr_utility.trace(' l_totals_c9_this_advice ' || l_totals_c9_this_advice);
822: hr_utility.set_message(801, 'PAY_74982_INCONSISTENT_PAY');
823: -- hr_utility.raise_error;
824: end if;
825: --
826: -- test if this payslip should be suppressed
827: --

Line 869: hr_utility.set_location('Entering ' || l_proc || 'loading totals names', 10);

865: BEGIN
866: --
867: -- Load the TOTALS bolierplate text
868: --
869: hr_utility.set_location('Entering ' || l_proc || 'loading totals names', 10);
870: --
871: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c1_total_gross);
872: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c2_total_subject);
873: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TEXT',g_totals_c3_total_deductions);

Line 905: hr_utility.set_location('Entering ' || l_proc || 'loading balance names', 20);

901: , p_action_information15 => l_text10);
902: --
903: -- Load balance names
904: --
905: hr_utility.set_location('Entering ' || l_proc || 'loading balance names', 20);
906: --
907: l_text1 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c1_total_gross);
908: l_text2 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c2_ss_ceiling);
909: l_text3 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c3_ee_total_conts);

Line 922: hr_utility.set_location('Entering ' || l_proc || 'archiving balance names', 30);

918: -- l_text12 := hr_general.decode_lookup('FR_PAYSLIP_TOTALS',g_balance_c12_taxable_income);
919: --
920: -- Archive the bolilerplate to the Balances
921: --
922: hr_utility.set_location('Entering ' || l_proc || 'archiving balance names', 30);
923: --
924: pay_action_information_api.create_action_information (
925: p_action_information_id => l_action_info_id
926: , p_action_context_id => p_action_id

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

1055: rec_urssaf csr_urssaf%ROWTYPE;
1056: l_proc VARCHAR2(60):= g_package||' Load_Organization_Details ';
1057: --
1058: BEGIN
1059: hr_utility.set_location('Entering ' || l_proc, 10);
1060: --
1061: BEGIN
1062: --
1063: -- delete any previous rows previously created - only relevent

Line 1090: hr_utility.set_location('Archiving Error ',30);

1086: -- check that the company has an address, and address line 1 is not null
1087: -- else raise an error
1088: --
1089: if rec_company.address_line_1 is null then
1090: hr_utility.set_location('Archiving Error ',30);
1091: l_error_flag := 'Y';
1092: else
1093: l_error_flag := 'N';
1094: end if;

Line 1107: hr_utility.trace('Fetched urssaf ' || rec_urssaf.urssaf_name);

1103: EXCEPTION
1104: when others then null;
1105: END;
1106: end if;
1107: hr_utility.trace('Fetched urssaf ' || rec_urssaf.urssaf_name);
1108: --
1109: -- Archive the Company details, using source_id to hold context of company id
1110: --
1111: pay_action_information_api.create_action_information (

Line 1136: hr_utility.set_location('Step ' || l_proc, 30);

1132: BEGIN
1133: --
1134: -- ESTABLISHMENT
1135: --
1136: hr_utility.set_location('Step ' || l_proc, 30);
1137: open csr_establishment(p_business_group_id, p_payroll_action_id);
1138: LOOP
1139: fetch csr_establishment INTO rec_establishment;
1140: hr_utility.set_location('Step ' || l_proc, 31);

Line 1140: hr_utility.set_location('Step ' || l_proc, 31);

1136: hr_utility.set_location('Step ' || l_proc, 30);
1137: open csr_establishment(p_business_group_id, p_payroll_action_id);
1138: LOOP
1139: fetch csr_establishment INTO rec_establishment;
1140: hr_utility.set_location('Step ' || l_proc, 31);
1141: EXIT WHEN csr_establishment%NOTFOUND;
1142: --
1143: if rec_establishment.location_id is null then
1144: hr_utility.set_location('Archiving Error ',35);

Line 1144: hr_utility.set_location('Archiving Error ',35);

1140: hr_utility.set_location('Step ' || l_proc, 31);
1141: EXIT WHEN csr_establishment%NOTFOUND;
1142: --
1143: if rec_establishment.location_id is null then
1144: hr_utility.set_location('Archiving Error ',35);
1145: l_error_flag := 'Y';
1146: else
1147: l_error_flag := 'N';
1148: end if;

Line 1173: hr_utility.set_location('Step ' || l_proc, 40);

1169: -- Repeat for all location_ids (addresses) used by either the est or coy
1170: --
1171: -- ADDRESS items
1172: BEGIN
1173: hr_utility.set_location('Step ' || l_proc, 40);
1174: open csr_addresses(p_payroll_action_id);
1175: LOOP
1176: fetch csr_addresses INTO rec_addresses;
1177: EXIT WHEN csr_addresses%NOTFOUND;

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

1194: , p_action_information10 => rec_addresses.postal_code);
1195: --
1196: END LOOP;
1197: close csr_addresses;
1198: hr_utility.set_location('Leaving ' || l_proc, 100);
1199: END;
1200: end load_organization_details;
1201: -------------------------------------------------------------------------------
1202: -- GET_INSTANCE_VARIABLES

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

1222: where paa.assignment_action_id = p_paa_id
1223: and paa.assignment_id = asg.assignment_id;
1224: BEGIN
1225: --
1226: hr_utility.set_location(' Entering ' || l_proc, 10);
1227: --
1228: open csr_establishment(p_assignment_action_id);
1229: fetch csr_establishment into l_tax_unit_id, l_assignment_id, l_person_id, l_payroll_id;
1230: if csr_establishment%NOTFOUND then

Line 1232: hr_utility.set_location('DEV ERROR : BAD assignment action : ' || to_char(p_assignment_action_id), 20);

1228: open csr_establishment(p_assignment_action_id);
1229: fetch csr_establishment into l_tax_unit_id, l_assignment_id, l_person_id, l_payroll_id;
1230: if csr_establishment%NOTFOUND then
1231: close csr_establishment;
1232: hr_utility.set_location('DEV ERROR : BAD assignment action : ' || to_char(p_assignment_action_id), 20);
1233: else
1234: close csr_establishment;
1235: p_person_id := l_person_id;
1236: p_establishment_id := l_tax_unit_id;

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

1236: p_establishment_id := l_tax_unit_id;
1237: p_assignment_id := l_assignment_id;
1238: p_payroll_id := l_payroll_id;
1239: end if;
1240: hr_utility.set_location(' Leaving ' || l_proc, 100);
1241: end get_instance_variables;
1242: -------------------------------------------------------------------------------
1243: -- GET_LATEST_RUN_DATA
1244: -- DESCRIPTION : gets the latest process type and date earned in set of

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

1294: AND rev_payact.action_status = 'C';
1295: --
1296: BEGIN
1297: --
1298: hr_utility.set_location('Entering ' || l_proc , 10);
1299: --
1300: open csr_date_earned(p_establishment_id, p_archive_action_id);
1301: loop
1302: fetch csr_date_earned into l_date_earned, l_latest_action_sequence,

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

1318: close csr_date_earned;
1319: p_date_earned := l_date_earned;
1320: p_latest_process_type := l_latest_process_type;
1321: p_latest_assignment_action_id := l_latest_asg_action_id;
1322: hr_utility.set_location(' Leaving ' || l_proc, 100);
1323: end get_latest_run_data;
1324: ------------------------------------------------------------------------------
1325: -- LOAD EMPLOYEE DATES
1326: -- DESCRIPTION : fetches and adjustes employee dates

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

1462: and asg.assignment_id = p_assignment_id;
1463: --
1464: BEGIN
1465:
1466: hr_utility.set_location('Entering ' || l_proc, 10);
1467: --
1468: -- Fetch the address data
1469: --
1470: open csr_ee_estab_start_date(p_assignment_id, p_latest_date_earned, p_establishment_id);

Line 1475: -- hr_utility.trace('p_assignment_id ' || to_char(p_assignment_id));

1471: fetch csr_ee_estab_start_date INTO l_ee_est_start_date;
1472: close csr_ee_estab_start_date;
1473: --
1474: --
1475: -- hr_utility.trace('p_assignment_id ' || to_char(p_assignment_id));
1476: -- hr_utility.trace('p_latest_date_earned ' || to_char(p_latest_date_earned));
1477: -- hr_utility.trace('p_establishment_id ' || to_char(p_establishment_id));
1478: --
1479: open csr_ee_estab_end_date(p_assignment_id, p_latest_date_earned, p_establishment_id);

Line 1476: -- hr_utility.trace('p_latest_date_earned ' || to_char(p_latest_date_earned));

1472: close csr_ee_estab_start_date;
1473: --
1474: --
1475: -- hr_utility.trace('p_assignment_id ' || to_char(p_assignment_id));
1476: -- hr_utility.trace('p_latest_date_earned ' || to_char(p_latest_date_earned));
1477: -- hr_utility.trace('p_establishment_id ' || to_char(p_establishment_id));
1478: --
1479: open csr_ee_estab_end_date(p_assignment_id, p_latest_date_earned, p_establishment_id);
1480: fetch csr_ee_estab_end_date INTO l_ee_est_end_date; /* may be eot */

Line 1477: -- hr_utility.trace('p_establishment_id ' || to_char(p_establishment_id));

1473: --
1474: --
1475: -- hr_utility.trace('p_assignment_id ' || to_char(p_assignment_id));
1476: -- hr_utility.trace('p_latest_date_earned ' || to_char(p_latest_date_earned));
1477: -- hr_utility.trace('p_establishment_id ' || to_char(p_establishment_id));
1478: --
1479: open csr_ee_estab_end_date(p_assignment_id, p_latest_date_earned, p_establishment_id);
1480: fetch csr_ee_estab_end_date INTO l_ee_est_end_date; /* may be eot */
1481: close csr_ee_estab_end_date;

Line 1485: hr_utility.trace('p_assignment_action_id ' || p_assignment_action_id);

1481: close csr_ee_estab_end_date;
1482: --
1483: -- Fetch the actual direct deposit dates
1484: --
1485: hr_utility.trace('p_assignment_action_id ' || p_assignment_action_id);
1486:
1487: open csr_actual_deposit_date(p_payroll_id, p_assignment_action_id, p_assignment_id);
1488: fetch csr_actual_deposit_date INTO l_direct_dd_date;
1489: close csr_actual_deposit_date;

Line 1501: hr_utility.set_location('Entering ' || l_proc, 22);

1497: end if;
1498: --
1499: -- Get the service history dates
1500: --
1501: hr_utility.set_location('Entering ' || l_proc, 22);
1502: open csr_get_service_dates(p_assignment_id, p_effective_date);
1503: hr_utility.set_location('Entering ' || l_proc, 23);
1504: fetch csr_get_service_dates INTO l_ee_termination_date
1505: ,l_ee_seniority_date

Line 1503: hr_utility.set_location('Entering ' || l_proc, 23);

1499: -- Get the service history dates
1500: --
1501: hr_utility.set_location('Entering ' || l_proc, 22);
1502: open csr_get_service_dates(p_assignment_id, p_effective_date);
1503: hr_utility.set_location('Entering ' || l_proc, 23);
1504: fetch csr_get_service_dates INTO l_ee_termination_date
1505: ,l_ee_seniority_date
1506: ,p_term_reason
1507: ,p_term_pay_schedule

Line 1509: hr_utility.set_location('Entering ' || l_proc, 24);

1505: ,l_ee_seniority_date
1506: ,p_term_reason
1507: ,p_term_pay_schedule
1508: ,p_term_lwd;
1509: hr_utility.set_location('Entering ' || l_proc, 24);
1510: /* pass actual termination date to out variable */
1511: p_term_atd := l_ee_termination_date;
1512: close csr_get_service_dates;
1513: --

Line 1516: hr_utility.set_location('Adjusting Dates ' || l_proc, 20);

1512: close csr_get_service_dates;
1513: --
1514: -- Store the dates
1515: --
1516: hr_utility.set_location('Adjusting Dates ' || l_proc, 20);
1517: --
1518: -- Adjust the employee dates
1519: --
1520: -- adjust termination date to be last day of period if null or outside period

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

1556: -- pass back the date as at to fetch the employee data
1557: --
1558: p_asat_date := l_ee_pay_period_end_date;
1559: --
1560: hr_utility.set_location('Leaving ' || l_proc, 100);
1561: end load_employee_dates;
1562: -------------------------------------------------------------------------------
1563: -- LOAD EMPLOYEE
1564: -- DESCRIPTION : Archives basic employee datails as at p_asat_date

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

1762:
1763: rec_ee_cagr_details csr_ee_cagr_details%ROWTYPE;
1764: --
1765: BEGIN
1766: hr_utility.set_location(' Entering ' || l_proc, 10);
1767: hr_utility.set_location(' as at date is ' || to_char(p_asat_date, 'yyyy-mm-dd'),20);
1768: --
1769: -- Fetch the address data
1770: --

Line 1767: hr_utility.set_location(' as at date is ' || to_char(p_asat_date, 'yyyy-mm-dd'),20);

1763: rec_ee_cagr_details csr_ee_cagr_details%ROWTYPE;
1764: --
1765: BEGIN
1766: hr_utility.set_location(' Entering ' || l_proc, 10);
1767: hr_utility.set_location(' as at date is ' || to_char(p_asat_date, 'yyyy-mm-dd'),20);
1768: --
1769: -- Fetch the address data
1770: --
1771: open csr_ee_address(p_person_id, p_asat_date);

Line 1776: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');

1772: fetch csr_ee_address INTO l_address_1, l_address_2, l_address_3
1773: ,l_address_insee_code, l_address_small_town, l_address_city
1774: ,l_address_post_code;
1775: if csr_ee_address%NOTFOUND then
1776: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');
1777: hr_utility.raise_error;
1778: close csr_ee_address;
1779: else
1780: close csr_ee_address;

Line 1777: hr_utility.raise_error;

1773: ,l_address_insee_code, l_address_small_town, l_address_city
1774: ,l_address_post_code;
1775: if csr_ee_address%NOTFOUND then
1776: hr_utility.set_message(800, 'PER_52990_ASG_PRADD_NE_PAY');
1777: hr_utility.raise_error;
1778: close csr_ee_address;
1779: else
1780: close csr_ee_address;
1781: --

Line 1802: hr_utility.set_location('Getting Basic Detail ' || l_proc, 30);

1798: end if;
1799: -------------------------------------------------------
1800: -- Get basic employee details
1801: -------------------------------------------------------
1802: hr_utility.set_location('Getting Basic Detail ' || l_proc, 30);
1803: open csr_ee_details(p_assignment_id, p_asat_date);
1804: fetch csr_ee_details INTO l_ee_soc_sec_number, l_ee_last_name, l_ee_first_name
1805: ,l_ee_full_name, l_ee_job_id, l_ee_job_definition_id, l_ee_position_name
1806: ,l_ee_coll_agree_name, l_ee_coy_id

Line 1829: hr_utility.set_location('Fetching CAGR details' || l_proc, 10);

1825: /* 3815632 appropriate job name is obtained using job_id and job_definition_id values */
1826: -----------------------------------------------------------------
1827: -- Get employees CAGR grade(s) and coefficient, if present
1828: -----------------------------------------------------------------
1829: hr_utility.set_location('Fetching CAGR details' || l_proc, 10);
1830: open csr_ee_cagr_details(p_assignment_id, p_asat_date, g_per_id);
1831: LOOP
1832: --@c:\local\fr\bal\pyfrarch.pkb;
1833: fetch csr_ee_cagr_details INTO rec_ee_cagr_details;

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

1889: -- pass out the action_information_id of the ee_details, as may need for update
1890: --
1891: p_ee_info_id := l_action_info_id;
1892: --
1893: hr_utility.set_location('Leaving ' || l_proc, 100);
1894: end load_employee;
1895: -------------------------------------------------------------------------------
1896: -- LOAD_BALANCES
1897: -- DESCRIPTION : Gets the balance values and archives for the given asg.

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

1920: l_ovn number (15);
1921: --
1922: l_proc VARCHAR2(40):= g_package||' load_balances ';
1923: BEGIN
1924: hr_utility.set_location(' Entering ' || l_proc, 10);
1925: --
1926: -- set the contexts
1927: --
1928: pay_balance_pkg.set_context ('ASSIGNMENT_ACTION_ID',to_char(p_assignment_action_id));

Line 1937: hr_utility.set_location('Balance 1 is ' || to_char(l_balance_value1), 15);

1933: -- BALANCE 1 total gross pay
1934: l_balance_value1 := pay_balance_pkg.get_value (
1935: p_defined_balance_id => g_1total_gross_pay_db,
1936: p_assignment_action_id => p_assignment_action_id);
1937: hr_utility.set_location('Balance 1 is ' || to_char(l_balance_value1), 15);
1938: -- BALANCE 2 ss ceiling
1939: l_balance_value2 := pay_balance_pkg.get_value (
1940: p_defined_balance_id => g_2ss_ceiling_db
1941: ,p_assignment_action_id => p_assignment_action_id);

Line 1942: hr_utility.set_location('Balance 2 is ' || to_char(l_balance_value2), 20);

1938: -- BALANCE 2 ss ceiling
1939: l_balance_value2 := pay_balance_pkg.get_value (
1940: p_defined_balance_id => g_2ss_ceiling_db
1941: ,p_assignment_action_id => p_assignment_action_id);
1942: hr_utility.set_location('Balance 2 is ' || to_char(l_balance_value2), 20);
1943: -- BALANCE 3 employees total contributions
1944: l_balance_value3 := pay_balance_pkg.get_value (
1945: p_defined_balance_id => g_3es_total_contributions_db
1946: ,p_assignment_action_id => p_assignment_action_id);

Line 1947: hr_utility.set_location('Balance 3 is ' || to_char(l_balance_value3), 30);

1943: -- BALANCE 3 employees total contributions
1944: l_balance_value3 := pay_balance_pkg.get_value (
1945: p_defined_balance_id => g_3es_total_contributions_db
1946: ,p_assignment_action_id => p_assignment_action_id);
1947: hr_utility.set_location('Balance 3 is ' || to_char(l_balance_value3), 30);
1948: -- BALANCE 4 statutory employer charges
1949: l_balance_value4 := pay_balance_pkg.get_value (
1950: p_defined_balance_id => g_4statutory_er_charges_db
1951: ,p_assignment_action_id => p_assignment_action_id);

Line 1952: hr_utility.set_location('Balance 4 is ' || to_char(l_balance_value4), 40);

1948: -- BALANCE 4 statutory employer charges
1949: l_balance_value4 := pay_balance_pkg.get_value (
1950: p_defined_balance_id => g_4statutory_er_charges_db
1951: ,p_assignment_action_id => p_assignment_action_id);
1952: hr_utility.set_location('Balance 4 is ' || to_char(l_balance_value4), 40);
1953: -- BALANCE 5 conventional employer charges
1954: l_balance_value5 := pay_balance_pkg.get_value (
1955: p_defined_balance_id => g_5conventional_er_charges_db
1956: ,p_assignment_action_id => p_assignment_action_id);

Line 1957: hr_utility.set_location('Balance 5 is ' || to_char(l_balance_value5), 50);

1953: -- BALANCE 5 conventional employer charges
1954: l_balance_value5 := pay_balance_pkg.get_value (
1955: p_defined_balance_id => g_5conventional_er_charges_db
1956: ,p_assignment_action_id => p_assignment_action_id);
1957: hr_utility.set_location('Balance 5 is ' || to_char(l_balance_value5), 50);
1958: -- BALANCE 6 t1 arrco band
1959: l_balance_value6 := pay_balance_pkg.get_value (
1960: p_defined_balance_id => g_6t1_arrco_band_db
1961: ,p_assignment_action_id => p_assignment_action_id);

Line 1962: hr_utility.set_location('Balance 6 is ' || to_char(l_balance_value6), 60);

1958: -- BALANCE 6 t1 arrco band
1959: l_balance_value6 := pay_balance_pkg.get_value (
1960: p_defined_balance_id => g_6t1_arrco_band_db
1961: ,p_assignment_action_id => p_assignment_action_id);
1962: hr_utility.set_location('Balance 6 is ' || to_char(l_balance_value6), 60);
1963: -- BALANCE 7 t2 arrco band
1964: l_balance_value7 := pay_balance_pkg.get_value (
1965: p_defined_balance_id => g_7t2_arrco_band_db
1966: ,p_assignment_action_id => p_assignment_action_id);

Line 1967: hr_utility.set_location('Balance 7 is ' || to_char(l_balance_value7), 70);

1963: -- BALANCE 7 t2 arrco band
1964: l_balance_value7 := pay_balance_pkg.get_value (
1965: p_defined_balance_id => g_7t2_arrco_band_db
1966: ,p_assignment_action_id => p_assignment_action_id);
1967: hr_utility.set_location('Balance 7 is ' || to_char(l_balance_value7), 70);
1968: -- BALANCE 8 tb arrco band
1969: l_balance_value8 := pay_balance_pkg.get_value (
1970: p_defined_balance_id => g_8tb_argic_band_db
1971: ,p_assignment_action_id => p_assignment_action_id);

Line 1972: hr_utility.set_location('Balance 8 is ' || to_char(l_balance_value8), 80);

1968: -- BALANCE 8 tb arrco band
1969: l_balance_value8 := pay_balance_pkg.get_value (
1970: p_defined_balance_id => g_8tb_argic_band_db
1971: ,p_assignment_action_id => p_assignment_action_id);
1972: hr_utility.set_location('Balance 8 is ' || to_char(l_balance_value8), 80);
1973: -- BALANCE 9 tc arrco band
1974: l_balance_value9 := pay_balance_pkg.get_value (
1975: p_defined_balance_id => g_9tc_agirc_band_db
1976: ,p_assignment_action_id => p_assignment_action_id);

Line 1977: hr_utility.set_location('Balance 9 is ' || to_char(l_balance_value9), 90);

1973: -- BALANCE 9 tc arrco band
1974: l_balance_value9 := pay_balance_pkg.get_value (
1975: p_defined_balance_id => g_9tc_agirc_band_db
1976: ,p_assignment_action_id => p_assignment_action_id);
1977: hr_utility.set_location('Balance 9 is ' || to_char(l_balance_value9), 90);
1978: -- BALANCE 10 gmp agirc band
1979: l_balance_value10 := pay_balance_pkg.get_value (
1980: p_defined_balance_id => g_10gmp_agirc_band_db
1981: ,p_assignment_action_id => p_assignment_action_id);

Line 1982: hr_utility.set_location('Balance 10 is ' || to_char(l_balance_value10), 100);

1978: -- BALANCE 10 gmp agirc band
1979: l_balance_value10 := pay_balance_pkg.get_value (
1980: p_defined_balance_id => g_10gmp_agirc_band_db
1981: ,p_assignment_action_id => p_assignment_action_id);
1982: hr_utility.set_location('Balance 10 is ' || to_char(l_balance_value10), 100);
1983: -- BALANCE 11 total cost to employer
1984: l_balance_value11 := pay_balance_pkg.get_value (
1985: p_defined_balance_id => g_11total_cost_to_employer_db
1986: ,p_assignment_action_id => p_assignment_action_id);

Line 1987: hr_utility.set_location('Balance 110 is ' || to_char(l_balance_value11), 110);

1983: -- BALANCE 11 total cost to employer
1984: l_balance_value11 := pay_balance_pkg.get_value (
1985: p_defined_balance_id => g_11total_cost_to_employer_db
1986: ,p_assignment_action_id => p_assignment_action_id);
1987: hr_utility.set_location('Balance 110 is ' || to_char(l_balance_value11), 110);
1988: --
1989: -- Archive the employee balances
1990: --
1991: pay_action_information_api.create_action_information (

Line 2017: hr_utility.set_location('Balance 12 is ' || to_char(l_balance_value12), 120);

2013: --
2014: l_balance_value12 := pay_balance_pkg.get_value (
2015: p_defined_balance_id => g_12taxable_income_db
2016: ,p_assignment_action_id => p_assignment_action_id);
2017: hr_utility.set_location('Balance 12 is ' || to_char(l_balance_value12), 120);
2018: hr_utility.set_location('Balance 12 db ' || to_char(g_12taxable_income_db), 121);
2019: --
2020: -- Set out variables
2021: --

Line 2018: hr_utility.set_location('Balance 12 db ' || to_char(g_12taxable_income_db), 121);

2014: l_balance_value12 := pay_balance_pkg.get_value (
2015: p_defined_balance_id => g_12taxable_income_db
2016: ,p_assignment_action_id => p_assignment_action_id);
2017: hr_utility.set_location('Balance 12 is ' || to_char(l_balance_value12), 120);
2018: hr_utility.set_location('Balance 12 db ' || to_char(g_12taxable_income_db), 121);
2019: --
2020: -- Set out variables
2021: --
2022: p_totals_taxable_income := l_balance_value12;

Line 2024: hr_utility.set_location(' Leaving ' || l_proc, 150);

2020: -- Set out variables
2021: --
2022: p_totals_taxable_income := l_balance_value12;
2023: --
2024: hr_utility.set_location(' Leaving ' || l_proc, 150);
2025: --
2026: end load_balances;
2027: -------------------------------------------------------------------------------
2028: -- LOAD_HOLIDAYS

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

2044: --
2045: l_proc VARCHAR2(40):= g_package||' Load Holidays ';
2046: --
2047: BEGIN
2048: hr_utility.set_location('Entering ' || l_proc, 10);
2049: --
2050: -- Get the holiday values
2051: --
2052: pay_fr_pto_pkg.load_fr_payslip_accrual_data

Line 2057: hr_utility.set_location('Step ' || l_proc, 20);

2053: (p_business_group_id => p_business_Group_id
2054: ,p_date_earned => p_effective_date
2055: ,p_assignment_id => p_assignment_id );
2056: --
2057: hr_utility.set_location('Step ' || l_proc, 20);
2058: --
2059: -- Loop through each record to fetch and archive
2060: --
2061: BEGIN

Line 2063: hr_utility.set_location('I loop is ' || l_proc, i);

2059: -- Loop through each record to fetch and archive
2060: --
2061: BEGIN
2062: FOR i in 1 .. pay_fr_pto_pkg.g_fr_payslip_info.LAST LOOP
2063: hr_utility.set_location('I loop is ' || l_proc, i);
2064: pay_action_information_api.create_action_information (
2065: p_action_information_id => l_action_info_id
2066: , p_action_context_id => p_assignment_action_id
2067: , p_action_context_type => l_archive_type

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

2078: EXCEPTION
2079: when others then null;
2080: END;
2081: --
2082: hr_utility.set_location('Leaving ' || l_proc, 100);
2083: end load_holidays;
2084: -------------------------------------------------------------------------------
2085: -- LOAD_BANK
2086: -- DESCRIPTION : fetches and archives all prepayments to be shown on payslip.

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

2153: l_ovn number (15);
2154: l_archive_type varchar2(3) := 'AAP';
2155: --
2156: BEGIN
2157: hr_utility.set_location('Entering ' || l_proc, 10);
2158: --
2159: open csr_bank_details(p_assignment_action_id);
2160: LOOP
2161: fetch csr_bank_details INTO rec_bank;

Line 2196: hr_utility.set_location('Step ' || l_proc, 50);

2192: end if;
2193: END LOOP;
2194: close csr_bank_details;
2195: l_net_deposit := l_running_total - l_already_notified;
2196: hr_utility.set_location('Step ' || l_proc, 50);
2197: --
2198: -- Set out variables
2199: --
2200: p_totals_previous_advice := l_already_notified;

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

2200: p_totals_previous_advice := l_already_notified;
2201: p_totals_this_advice := l_running_total;
2202: p_totals_net_advice := l_net_deposit;
2203: --
2204: hr_utility.set_location('Leaving ' || l_proc, 100);
2205: END load_bank;
2206: -------------------------------------------------------------------------------
2207: -- LOAD_MESSAGES
2208: -- DESCRIPTION : fetches and archives all the payroll action messages locked

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

2250: l_ovn number (15);
2251: l_archive_type varchar2(3) := 'AAP';
2252: --
2253: BEGIN
2254: hr_utility.set_location('Entering ' || l_proc, 10);
2255: open csr_message_details(p_archive_assignment_action_id);
2256: LOOP
2257: fetch csr_message_details INTO l_message;
2258: EXIT WHEN csr_message_details%NOTFOUND;

Line 2277: hr_utility.set_location('Step ' || l_proc, 50);

2273: END LOOP;
2274: --
2275: -- Construct the termination message
2276: --
2277: hr_utility.set_location('Step ' || l_proc, 50);
2278: if p_term_atd is not null then
2279: fnd_message.set_name('PAY', 'PAY_75057_SOE_TERM_DATA');
2280: fnd_message.set_token('TERM_DATE', fnd_date.date_to_displaydate(p_term_atd));
2281: fnd_message.set_token('TERM_REASON',p_term_reason);

Line 2282: l_message := hr_utility.get_message;

2278: if p_term_atd is not null then
2279: fnd_message.set_name('PAY', 'PAY_75057_SOE_TERM_DATA');
2280: fnd_message.set_token('TERM_DATE', fnd_date.date_to_displaydate(p_term_atd));
2281: fnd_message.set_token('TERM_REASON',p_term_reason);
2282: l_message := hr_utility.get_message;
2283: l_message := substrb(l_message, 1, 240);
2284: --
2285: -- archive the termination message
2286: --

Line 2287: hr_utility.set_location('Step ' || l_proc, 55);

2283: l_message := substrb(l_message, 1, 240);
2284: --
2285: -- archive the termination message
2286: --
2287: hr_utility.set_location('Step ' || l_proc, 55);
2288: pay_action_information_api.create_action_information (
2289: p_action_information_id => l_action_info_id
2290: ,p_action_context_id => p_archive_assignment_action_id
2291: ,p_action_context_type => l_archive_type

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

2295: ,p_action_information1 => to_char(l_loop_counter+1)
2296: ,p_action_information4 => substrb(l_message, 1, 150));
2297: end if;
2298: --
2299: hr_utility.set_location('Leaving ' || l_proc, 100);
2300: close csr_message_details;
2301: END load_messages;
2302: ---------------------------------------------------------------------------------------------------
2303: -- LOAD_EE_RATE_GROUPED_RUNS EARNINGS and NET PAYMENTS

Line 2579: hr_utility.set_location('Entering ' || l_proc, 5);

2575: -- BEGIN LOAD_EE_RATE_GROUPED_RUNS
2576: -----------------------------------------------------------------------------------------
2577: BEGIN
2578:
2579: hr_utility.set_location('Entering ' || l_proc, 5);
2580: for l_loop in 1..4 LOOP
2581: hr_utility.set_location('Major Loop ='||to_char(l_loop), 9);
2582: l_loop_counter := 0;
2583: l_ee_context_order := 0;

Line 2581: hr_utility.set_location('Major Loop ='||to_char(l_loop), 9);

2577: BEGIN
2578:
2579: hr_utility.set_location('Entering ' || l_proc, 5);
2580: for l_loop in 1..4 LOOP
2581: hr_utility.set_location('Major Loop ='||to_char(l_loop), 9);
2582: l_loop_counter := 0;
2583: l_ee_context_order := 0;
2584: l_previous_rubric := ' ';
2585: l_previous_process := ' ';

Line 2702: --hr_utility.trace('reason ' || p_termination_reason);

2698: ) THEN
2699: --
2700: -- Prefix the termination reason to the rubric
2701: --
2702: --hr_utility.trace('reason ' || p_termination_reason);
2703: --hr_utility.trace('descr ' || l_description);
2704: l_description := substrb(p_termination_reason || '-' || l_description, 1, 200);
2705: End If;
2706: --

Line 2703: --hr_utility.trace('descr ' || l_description);

2699: --
2700: -- Prefix the termination reason to the rubric
2701: --
2702: --hr_utility.trace('reason ' || p_termination_reason);
2703: --hr_utility.trace('descr ' || l_description);
2704: l_description := substrb(p_termination_reason || '-' || l_description, 1, 200);
2705: End If;
2706: --
2707: -- Only store the base units if the base is not null and not zero

Line 2747: hr_utility.set_location('context='||l_context_prefix, 30);

2743: -- Arcvive ee values
2744: -- only archive the pay_value and rubric and description for court orders
2745: -- and sum the pay_values until the end of fetch or a new rubric is fetched.
2746: --
2747: hr_utility.set_location('context='||l_context_prefix, 30);
2748: if l_loop <> 4 and rec_results.amount <> 0 then
2749: pay_action_information_api.create_action_information (
2750: p_action_information_id => l_action_info_id
2751: , p_action_context_id => p_archive_assignment_action_id

Line 2819: hr_utility.set_location('End of Prefix Loop ' || l_proc, 90);

2815: l_printed_end_date := null;
2816:
2817: --
2818: END LOOP; /* cursor loop */
2819: hr_utility.set_location('End of Prefix Loop ' || l_proc, 90);
2820: --
2821: -- Write any CO fetched on the very last fetch of loop = 4
2822: --
2823: if l_loop = 4 and l_total_loop_court_orders <> 0 then

Line 2841: hr_utility.set_location('End of Major Loop ' || l_proc, 100);

2837: --
2838: end if;
2839: close csr_get_ee_rate_grouped;
2840: END LOOP; /* loop of statutory deductions */
2841: hr_utility.set_location('End of Major Loop ' || l_proc, 100);
2842: --
2843: -- pass out the totals needed in future calculations of totals
2844: --
2845: p_total_gross_pay := nvl(l_total_gross_pay, 0);

Line 2850: hr_utility.set_location('Leaving ' || l_proc, 110);

2846: p_reductions := nvl(l_total_reductions, 0);
2847: p_net_payments := nvl(l_total_net_payments, 0);
2848: p_court_orders := nvl(l_total_court_orders, 0);
2849: --
2850: hr_utility.set_location('Leaving ' || l_proc, 110);
2851: END load_ee_rate_grouped_runs;
2852: -------------------------------------------------------------------------------
2853: -- LOAD_DEDUCTIONS1
2854: -- DESCRIPTION : OLD

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

2906: --
2907: l_proc VARCHAR2(60):= g_package||' Write Archive ';
2908: --
2909: BEGIN
2910: hr_utility.set_location('Entering ' || l_proc, 10);
2911: open csr_find_row;
2912: fetch csr_find_row into l_action_info_id, l_ovn;
2913: if csr_find_row%NOTFOUND THEN
2914: pay_action_information_api.create_action_information (

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

2953: , p_action_information12 => nvl(p_action_information12, hr_api.g_varchar2)
2954: , p_action_information13 => nvl(p_action_information13, hr_api.g_varchar2));
2955: end if;
2956: close csr_find_row;
2957: hr_utility.set_location('Leaving ' || l_proc, 100);
2958: EXCEPTION
2959: WHEN OTHERS then
2960: raise; /* error as no write to archive */
2961: END write_archive;

Line 3103: hr_utility.set_location('Entering ' || l_proc, 5);

3099: -----------------------------------------------------------------------------
3100: -- BEGIN LOAD_RATE_GROUPED_RUNS net payments, ER LV charges
3101: -----------------------------------------------------------------------------
3102: BEGIN
3103: hr_utility.set_location('Entering ' || l_proc, 5);
3104: -- Modified for bug 3683906, commented out under bug 4778143
3105: -- l_sec_grp_id_user_ele_grp := g_sec_grp_id_user_element_grp;
3106: -- l_sec_grp_id_base_unit := g_sec_grp_id_base_unit;
3107: --

Line 3181: hr_utility.set_location('End of Prefix Loop ' || l_proc, 90);

3177: end if;
3178: l_previous_rubric := nvl(rec_results.rubric, '.');
3179: l_previous_base := nvl(rec_results.base, 0);
3180: END LOOP; -- cursor loop
3181: hr_utility.set_location('End of Prefix Loop ' || l_proc, 90);
3182: close csr_get_results;
3183: --
3184: -- Pass back the return variable
3185: --

Line 3188: hr_utility.set_location('Leaving ' || l_proc, 110);

3184: -- Pass back the return variable
3185: --
3186: p_total_ee_net_deductions := l_total_ee_net_deductions;
3187: --
3188: hr_utility.set_location('Leaving ' || l_proc, 110);
3189: END load_rate_grouped_runs;
3190: -------------------------------------------------------------------------------
3191: -- SUPPORT CODE
3192: -------------------------------------------------------------------------------

Line 3206: hr_utility.set_location('Entering ' || l_proc, 20);

3202: l_start_pos NUMBER;
3203: l_delimiter varchar2(1):=' ';
3204: l_proc VARCHAR2(40):= g_package||' get parameter ';
3205: BEGIN
3206: hr_utility.set_location('Entering ' || l_proc, 20);
3207: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
3208: IF l_start_pos = 0 THEN
3209: l_delimiter := '|';
3210: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

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

3223: instr(l_parameter,':',1,p_segment_number+1) -1
3224: - instr(l_parameter,':',1,p_segment_number));
3225: END IF;
3226: END IF;
3227: hr_utility.set_location('Leaving ' || l_proc, 100);
3228: RETURN l_parameter;
3229: END get_parameter;
3230: -------------------------------------------------------------------------------
3231: -- GET_ALL_PARAMETERS gets all parameters for the payroll action

Line 3254: hr_utility.set_location('Entering ' || l_proc, 20);

3250: WHERE payroll_action_id = p_payroll_action_id;
3251: l_proc VARCHAR2(40):= g_package||' get_all_parameters ';
3252:
3253: BEGIN
3254: hr_utility.set_location('Entering ' || l_proc, 20);
3255: open csr_parameter_info (p_payroll_action_id);
3256: fetch csr_parameter_info into p_payroll_id, p_assignment_id, p_assignment_set_id
3257: ,p_business_group_id, p_start_date, p_effective_date;
3258: close csr_parameter_info;

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

3256: fetch csr_parameter_info into p_payroll_id, p_assignment_id, p_assignment_set_id
3257: ,p_business_group_id, p_start_date, p_effective_date;
3258: close csr_parameter_info;
3259:
3260: hr_utility.set_location('Leaving ' || l_proc, 100);
3261: END get_all_parameters;
3262: -------------------------------------------------------------------------------
3263: -- GET_BALANCE_ID
3264: -- DESCRIPTION : gets a defined balance id

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

3272: l_proc VARCHAR2(40):= g_package||' get_balance_id ';
3273: --
3274: BEGIN
3275: --
3276: hr_utility.set_location('Entering ' || l_proc, 10);
3277: SELECT defined_balance_id
3278: INTO l_defined_balance_id
3279: FROM pay_defined_balances db
3280: ,pay_balance_types b

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

3283: AND d.dimension_name = p_dimension
3284: AND db.balance_type_id = b.balance_type_id
3285: AND db.balance_dimension_id = d.balance_dimension_id
3286: AND d.legislation_code = 'FR';
3287: hr_utility.set_location(' Leaving ' || l_proc, 100);
3288: return l_defined_balance_id;
3289: EXCEPTION
3290: when NO_DATA_FOUND then
3291: hr_utility.set_location('DEV ERROR Balance Name not found ' || p_balance_name, 20);

Line 3291: hr_utility.set_location('DEV ERROR Balance Name not found ' || p_balance_name, 20);

3287: hr_utility.set_location(' Leaving ' || l_proc, 100);
3288: return l_defined_balance_id;
3289: EXCEPTION
3290: when NO_DATA_FOUND then
3291: hr_utility.set_location('DEV ERROR Balance Name not found ' || p_balance_name, 20);
3292: raise;
3293: when TOO_MANY_ROWS then
3294: hr_utility.set_location('DEV ERROR Balance Name ambiguous ' || p_balance_name, 20);
3295: raise;

Line 3294: hr_utility.set_location('DEV ERROR Balance Name ambiguous ' || p_balance_name, 20);

3290: when NO_DATA_FOUND then
3291: hr_utility.set_location('DEV ERROR Balance Name not found ' || p_balance_name, 20);
3292: raise;
3293: when TOO_MANY_ROWS then
3294: hr_utility.set_location('DEV ERROR Balance Name ambiguous ' || p_balance_name, 20);
3295: raise;
3296: end get_balance_id;
3297: -------------------------------------------------------------------------------
3298: -- DEINITIALIZE

Line 3339: hr_utility.set_location('Step ' || l_proc,30);

3335: --
3336: -- Get the company addresses and establishment addresses and
3337: -- company and establishment details
3338: --
3339: hr_utility.set_location('Step ' || l_proc,30);
3340: pay_fr_arc_pkg.load_organization_details(
3341: p_payroll_action_id => p_payroll_action_id
3342: ,p_business_Group_id => g_param_business_group_id
3343: ,p_payroll_id => g_param_payroll_id

Line 3352: hr_utility.set_location('Step ' || l_proc,30);

3348: --
3349: -- Error if any company or establishment
3350: -- addresses are missing.
3351: --
3352: hr_utility.set_location('Step ' || l_proc,30);
3353: FOR missing_address in csr_check_archive_org_address(p_payroll_action_id)
3354: LOOP
3355: hr_utility.set_message(801, 'PAY_74979_INCOMPLETE_ADDRESS');
3356: hr_utility.set_message_token(801,'ORGANIZATION',missing_address.name);

Line 3355: hr_utility.set_message(801, 'PAY_74979_INCOMPLETE_ADDRESS');

3351: --
3352: hr_utility.set_location('Step ' || l_proc,30);
3353: FOR missing_address in csr_check_archive_org_address(p_payroll_action_id)
3354: LOOP
3355: hr_utility.set_message(801, 'PAY_74979_INCOMPLETE_ADDRESS');
3356: hr_utility.set_message_token(801,'ORGANIZATION',missing_address.name);
3357: l_message := substr(hr_utility.get_message,1,240);
3358: l_error := TRUE;
3359: END LOOP;

Line 3356: hr_utility.set_message_token(801,'ORGANIZATION',missing_address.name);

3352: hr_utility.set_location('Step ' || l_proc,30);
3353: FOR missing_address in csr_check_archive_org_address(p_payroll_action_id)
3354: LOOP
3355: hr_utility.set_message(801, 'PAY_74979_INCOMPLETE_ADDRESS');
3356: hr_utility.set_message_token(801,'ORGANIZATION',missing_address.name);
3357: l_message := substr(hr_utility.get_message,1,240);
3358: l_error := TRUE;
3359: END LOOP;
3360: IF l_error = TRUE THEN

Line 3357: l_message := substr(hr_utility.get_message,1,240);

3353: FOR missing_address in csr_check_archive_org_address(p_payroll_action_id)
3354: LOOP
3355: hr_utility.set_message(801, 'PAY_74979_INCOMPLETE_ADDRESS');
3356: hr_utility.set_message_token(801,'ORGANIZATION',missing_address.name);
3357: l_message := substr(hr_utility.get_message,1,240);
3358: l_error := TRUE;
3359: END LOOP;
3360: IF l_error = TRUE THEN
3361: fnd_file.put_line (fnd_file.LOG, l_message);

Line 3362: hr_utility.raise_error;

3358: l_error := TRUE;
3359: END LOOP;
3360: IF l_error = TRUE THEN
3361: fnd_file.put_line (fnd_file.LOG, l_message);
3362: hr_utility.raise_error;
3363: END IF;
3364: hr_utility.set_location('Leaving ' || l_proc, 100);
3365: end deinitialize;
3366: -------------------------------------------------------------------------------

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

3360: IF l_error = TRUE THEN
3361: fnd_file.put_line (fnd_file.LOG, l_message);
3362: hr_utility.raise_error;
3363: END IF;
3364: hr_utility.set_location('Leaving ' || l_proc, 100);
3365: end deinitialize;
3366: -------------------------------------------------------------------------------
3367: -- LOAD_DEDUCTIONS
3368: -- DESCRIPTION : New

Line 3673: hr_utility.set_location('Entering ' || l_proc, 5);

3669: and VIEW_APPLICATION_ID = 3
3670: order by lookup_type desc;
3671: --
3672: BEGIN
3673: hr_utility.set_location('Entering ' || l_proc, 5);
3674: -- Modified for bug 3683906, commented out under bug 4778143
3675: -- l_sec_grp_id_user_ele_grp := g_sec_grp_id_user_element_grp;
3676: -- l_sec_grp_id_ele_grp := g_sec_grp_id_element_grp;
3677: --

Line 3678: hr_utility.trace('LOAD DEDUCTIONS 1');

3674: -- Modified for bug 3683906, commented out under bug 4778143
3675: -- l_sec_grp_id_user_ele_grp := g_sec_grp_id_user_element_grp;
3676: -- l_sec_grp_id_ele_grp := g_sec_grp_id_element_grp;
3677: --
3678: hr_utility.trace('LOAD DEDUCTIONS 1');
3679: l_pos_offset := 0;
3680: open csr_get_run_bals;
3681: fetch csr_get_run_bals bulk collect into
3682: tbl_tax_unit_id, tbl_process_type, tbl_ee_rate, tbl_cu_id, tbl_EE_ER,

Line 4011: hr_utility.trace('p_total_deduct_ee='|| p_total_deduct_ee);

4007: p_total_deduct_er := l_total_er_deductions;
4008: p_total_charge_ee := l_total_ee_deductions + l_total_ee_csg;
4009: p_total_charge_er := l_total_er_deductions;
4010: --
4011: hr_utility.trace('p_total_deduct_ee='|| p_total_deduct_ee);
4012: hr_utility.trace('p_total_deduct_er='|| p_total_deduct_er);
4013: hr_utility.trace('p_total_charge_ee='|| p_total_charge_ee);
4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);
4015: --

Line 4012: hr_utility.trace('p_total_deduct_er='|| p_total_deduct_er);

4008: p_total_charge_ee := l_total_ee_deductions + l_total_ee_csg;
4009: p_total_charge_er := l_total_er_deductions;
4010: --
4011: hr_utility.trace('p_total_deduct_ee='|| p_total_deduct_ee);
4012: hr_utility.trace('p_total_deduct_er='|| p_total_deduct_er);
4013: hr_utility.trace('p_total_charge_ee='|| p_total_charge_ee);
4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);
4015: --
4016: hr_utility.set_location('Leaving ' || l_proc, 210);

Line 4013: hr_utility.trace('p_total_charge_ee='|| p_total_charge_ee);

4009: p_total_charge_er := l_total_er_deductions;
4010: --
4011: hr_utility.trace('p_total_deduct_ee='|| p_total_deduct_ee);
4012: hr_utility.trace('p_total_deduct_er='|| p_total_deduct_er);
4013: hr_utility.trace('p_total_charge_ee='|| p_total_charge_ee);
4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);
4015: --
4016: hr_utility.set_location('Leaving ' || l_proc, 210);
4017: END load_deductions;

Line 4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);

4010: --
4011: hr_utility.trace('p_total_deduct_ee='|| p_total_deduct_ee);
4012: hr_utility.trace('p_total_deduct_er='|| p_total_deduct_er);
4013: hr_utility.trace('p_total_charge_ee='|| p_total_charge_ee);
4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);
4015: --
4016: hr_utility.set_location('Leaving ' || l_proc, 210);
4017: END load_deductions;
4018: END pay_fr_arc_pkg;

Line 4016: hr_utility.set_location('Leaving ' || l_proc, 210);

4012: hr_utility.trace('p_total_deduct_er='|| p_total_deduct_er);
4013: hr_utility.trace('p_total_charge_ee='|| p_total_charge_ee);
4014: hr_utility.trace('p_total_charge_er='|| p_total_charge_er);
4015: --
4016: hr_utility.set_location('Leaving ' || l_proc, 210);
4017: END load_deductions;
4018: END pay_fr_arc_pkg;