APPS.PSP_ENC_CREATE_LINES dependencies on FND_NUMBER

Line 638: FROM (SELECT ((MAX(fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0))) *

634:
635: CURSOR element_period_amount_cur IS
636: SELECT time_period_id,
637: SUM(period_amount)
638: FROM (SELECT ((MAX(fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0))) *
639: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),
640: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
641: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
642: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,

Line 748: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount

744:
745: CURSOR get_element_entry IS
746: SELECT DISTINCT GREATEST(paf.effective_start_date, peev.effective_start_date) element_start_date,
747: LEAST(paf.effective_end_date, peev.effective_end_date) element_end_date,
748: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
749: FROM pay_element_entry_values_f peev,
750: pay_input_values_f piv,
751: pay_element_entries_f pee,
752: pay_element_links_f pel,

Line 872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

868:
869: BEGIN
870: l_proc_step:= 10;
871: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

Line 873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

869: BEGIN
870: l_proc_step:= 10;
871: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||

Line 874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

870: l_proc_step:= 10;
871: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
878: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

Line 875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||

871: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
878: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
879:

Line 876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

872: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
878: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
879:
880: IF (r_enc_period.r_time_period_id.COUNT = 0) THEN

Line 877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||

873: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
878: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
879:
880: IF (r_enc_period.r_time_period_id.COUNT = 0) THEN
881: RETURN;

Line 878: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

874: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
875: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
876: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
877: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
878: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
879:
880: IF (r_enc_period.r_time_period_id.COUNT = 0) THEN
881: RETURN;
882: END IF;

Line 923: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||

919: CLOSE get_element_entry;
920:
921: l_proc_step:= 50;
922:
923: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||
924: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||
925: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));
926: hr_utility.trace('Calculating Assignment Chunk Amounts...');
927:

Line 924: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||

920:
921: l_proc_step:= 50;
922:
923: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||
924: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||
925: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));
926: hr_utility.trace('Calculating Assignment Chunk Amounts...');
927:
928: FOR I IN 1..r_enc_period.r_time_period_id.COUNT

Line 925: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));

921: l_proc_step:= 50;
922:
923: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||
924: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||
925: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));
926: hr_utility.trace('Calculating Assignment Chunk Amounts...');
927:
928: FOR I IN 1..r_enc_period.r_time_period_id.COUNT
929: LOOP

Line 940: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

936: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id);
937: l_enc_amount := 0;
938: l_proc_step:= 60 + (I / 100000);
939:
940: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
941: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
942: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
943: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));

941: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
942: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
943: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
944: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
945: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
946:
947: IF (l_bus_working_days = 0) THEN
948: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
949: fnd_message.set_token('START_DATE', l_period_start_date);

Line 960: hr_utility.trace('l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));

956: p_element_type_id => p_element_type_id,
957: p_time_period_id => r_enc_period.r_time_period_id(I),
958: p_asg_start_date => l_asg_start_date,
959: p_asg_end_date => l_asg_end_date);
960: hr_utility.trace('l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
961:
962: IF (l_enc_amount = 0) THEN
963: IF (l_formula_id IS NOT NULL) THEN
964: IF ( (t_ff_start_date.COUNT > 0) AND

Line 986: l_inputs(recno).value := fnd_number.number_to_canonical(p_person_id);

982: hr_utility.trace('l_inputs.COUNT: ' || l_inputs.COUNT);
983: FOR recno IN 1..l_inputs.COUNT
984: LOOP
985: IF (l_inputs(recno).name ='PERSON_ID') THEN
986: l_inputs(recno).value := fnd_number.number_to_canonical(p_person_id);
987: hr_utility.trace('Assigned person_id');
988: ELSIF (l_inputs(recno).name ='ASSIGNMENT_ID') THEN
989: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);
990: hr_utility.trace('Assigned assignment_id');

Line 989: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);

985: IF (l_inputs(recno).name ='PERSON_ID') THEN
986: l_inputs(recno).value := fnd_number.number_to_canonical(p_person_id);
987: hr_utility.trace('Assigned person_id');
988: ELSIF (l_inputs(recno).name ='ASSIGNMENT_ID') THEN
989: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);
990: hr_utility.trace('Assigned assignment_id');
991: ELSIF l_inputs(recno).name='ELEMENT_TYPE_ID' THEN
992: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);
993: hr_utility.trace('Assigned element_type_id');

Line 992: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);

988: ELSIF (l_inputs(recno).name ='ASSIGNMENT_ID') THEN
989: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);
990: hr_utility.trace('Assigned assignment_id');
991: ELSIF l_inputs(recno).name='ELEMENT_TYPE_ID' THEN
992: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);
993: hr_utility.trace('Assigned element_type_id');
994: ELSIF l_inputs(recno).name='PAYROLL_ID' THEN
995: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);
996: hr_utility.trace('Assigned payroll_id');

Line 995: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);

991: ELSIF l_inputs(recno).name='ELEMENT_TYPE_ID' THEN
992: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);
993: hr_utility.trace('Assigned element_type_id');
994: ELSIF l_inputs(recno).name='PAYROLL_ID' THEN
995: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);
996: hr_utility.trace('Assigned payroll_id');
997: ELSIF l_inputs(recno).name='TIME_PERIOD_ID' THEN
998: l_inputs(recno).value := fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I));
999: hr_utility.trace('Assigned time_period_id');

Line 998: l_inputs(recno).value := fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I));

994: ELSIF l_inputs(recno).name='PAYROLL_ID' THEN
995: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);
996: hr_utility.trace('Assigned payroll_id');
997: ELSIF l_inputs(recno).name='TIME_PERIOD_ID' THEN
998: l_inputs(recno).value := fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I));
999: hr_utility.trace('Assigned time_period_id');
1000: ELSIF l_inputs(recno).name='ASG_START_DATE' THEN
1001: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_start_date);
1002: hr_utility.trace('Assigned asg_start_date');

Line 1007: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));

1003: ELSIF l_inputs(recno).name='ASG_END_DATE' THEN
1004: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_end_date);
1005: hr_utility.trace('Assigned asg_end_date');
1006: ELSIF l_inputs(recno).name='BUS_DAYS_IN_CHUNK' THEN
1007: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));
1008: hr_utility.trace('Assigned business days in chunk');
1009: ELSIF l_inputs(recno).name='PERIOD_START_DATE' THEN
1010: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_start_date);
1011: hr_utility.trace('Assigned period_start_date');

Line 1016: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id));

1012: ELSIF l_inputs(recno).name='PERIOD_END_DATE' THEN
1013: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_end_date);
1014: hr_utility.trace('Assigned period_end_date');
1015: ELSIF l_inputs(recno).name='BUS_DAYS_IN_PERIOD' THEN
1016: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id));
1017: hr_utility.trace('Assigned business days in period');
1018: ELSIF l_inputs(recno).name='UOM' THEN
1019: l_inputs(recno).value := g_uom;
1020: hr_utility.trace('Assigned UOM');

Line 1027: l_enc_amount := l_enc_amount + fnd_number.canonical_to_number(l_outputs(1).value); -- Bug 7536024

1023: END LOOP;
1024:
1025: hr_utility.trace('Before executing fast formula');
1026: ff_exec.run_formula(l_inputs, l_outputs);
1027: l_enc_amount := l_enc_amount + fnd_number.canonical_to_number(l_outputs(1).value); -- Bug 7536024
1028: hr_utility.trace('After executing fast formula; l_enc_amount: ' || l_enc_amount);
1029: END IF;
1030: END LOOP;
1031: END IF;

Line 1047: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||

1043: l_annualization_factor := r_salary_proposal.r_pay_annualization_factor(J);
1044: l_pay_basis := r_salary_proposal.r_pay_basis(J);
1045: l_proc_step:= 70 + (J / 100000);
1046:
1047: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1048: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1049: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1050: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1051: ' l_pay_basis: ' || l_pay_basis);

Line 1049: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||

1045: l_proc_step:= 70 + (J / 100000);
1046:
1047: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1048: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1049: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1050: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1051: ' l_pay_basis: ' || l_pay_basis);
1052:
1053: IF (l_change_date <= l_end_date) THEN

Line 1050: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||

1046:
1047: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1048: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1049: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1050: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1051: ' l_pay_basis: ' || l_pay_basis);
1052:
1053: IF (l_change_date <= l_end_date) THEN
1054: IF (l_num_per_fiscal_year <> 0 AND (l_pay_basis IN ('ANNUAL','MONTHLY','HOURLY'))) THEN

Line 1064: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||

1060: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1061:
1062: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1063: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1064: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1065: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1066:
1067: l_end_date := GREATEST(l_start_date, l_change_date) - 1;
1068:

Line 1065: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));

1061:
1062: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1063: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1064: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1065: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1066:
1067: l_end_date := GREATEST(l_start_date, l_change_date) - 1;
1068:
1069: EXIT WHEN l_change_date < l_asg_start_date;

Line 1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||

1089: END IF;
1090:
1091: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||
1092: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1097: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));

Line 1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||

1092: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1097: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1098:
1099: EXIT WHEN l_element_start_date > l_asg_end_date;
1100: END LOOP;

Line 1097: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));

1093: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1094: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1095: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1096: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1097: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1098:
1099: EXIT WHEN l_element_start_date > l_asg_end_date;
1100: END LOOP;
1101: END IF;

Line 1145: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

1141: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id);
1142: l_end_date := l_period_end_date;
1143: l_period_counter := 0;
1144:
1145: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1146: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1147: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1148: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1149:

Line 1148: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));

1144:
1145: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1146: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1147: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1148: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1149:
1150: IF (l_bus_working_days > 0) THEN
1151: FOR J IN 1..r_salary_proposal.r_change_date.COUNT
1152: LOOP

Line 1171: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||

1167: l_annualization_factor := r_salary_proposal.r_pay_annualization_factor(J);
1168: l_pay_basis := r_salary_proposal.r_pay_basis(J);
1169: l_proc_step:= 130 + (J / 100000);
1170:
1171: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1172: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1173: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1174: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1175: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||

Line 1174: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||

1170:
1171: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1172: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1173: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1174: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1175: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1176: ' l_pay_basis: ' || l_pay_basis);
1177:
1178: -- IF (l_change_date <= l_end_date) THEN Commented for bug fix 3551561

Line 1175: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||

1171: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1172: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1173: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1174: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1175: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1176: ' l_pay_basis: ' || l_pay_basis);
1177:
1178: -- IF (l_change_date <= l_end_date) THEN Commented for bug fix 3551561
1179: IF (l_change_end_date >= l_period_start_date) AND (l_change_date <= l_period_end_date) THEN

Line 1208: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||

1204: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched)/( l_bus_working_days )), g_ext_precision);
1205: -- End of changes for bug fix 3551561
1206: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1207: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1208: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1209: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1210: -- l_end_date := GREATEST(l_start_date, l_change_date) - 1; Commented for bug fix 3551561
1211: l_prev_change_end_date := l_change_end_date;
1212: END IF;

Line 1209: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));

1205: -- End of changes for bug fix 3551561
1206: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1207: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1208: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1209: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1210: -- l_end_date := GREATEST(l_start_date, l_change_date) - 1; Commented for bug fix 3551561
1211: l_prev_change_end_date := l_change_end_date;
1212: END IF;
1213: l_prev_change_date := l_change_date;

Line 1323: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1319: p_return_status := fnd_api.g_ret_sts_success;
1320: EXCEPTION
1321: WHEN DIVIDE_BY_ZERO THEN
1322: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1323: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1324: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1325: p_return_status := fnd_api.g_ret_sts_unexp_error;
1326: WHEN OTHERS THEN
1327: IF (g_error_message IS NULL) THEN

Line 1331: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1327: IF (g_error_message IS NULL) THEN
1328: g_error_message := l_proc_name || ': ' || SQLERRM;
1329: END IF;
1330: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1331: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1333: p_return_status := fnd_api.g_ret_sts_unexp_error;
1334: END determine_enc_amount;
1335: -- End of changes for bug fix 3488734

Line 2017: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

2013: l_proc_step := 10;
2014: l_proc_name := 'CREATE_LINES';
2015:
2016: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2017: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2018: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2019: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2020: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2021:

Line 2018: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

2014: l_proc_name := 'CREATE_LINES';
2015:
2016: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2017: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2018: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2019: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2020: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2021:
2022: p_return_status := fnd_api.g_ret_sts_success;

Line 2019: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

2015:
2016: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2017: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2018: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2019: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2020: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2021:
2022: p_return_status := fnd_api.g_ret_sts_success;
2023:

Line 2028: hr_utility.trace('l_person_id: ' || fnd_number.number_to_canonical(l_person_id));

2024: OPEN c_person_id;
2025: FETCH c_person_id INTO l_person_id;
2026: CLOSE c_person_id;
2027:
2028: hr_utility.trace('l_person_id: ' || fnd_number.number_to_canonical(l_person_id));
2029: l_proc_step := 20;
2030: g_pateo_end_date := NULL;
2031:
2032: OPEN enc_period_cur;

Line 2040: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

2036: r_enc_period.r_effective_date, r_enc_period.r_process_flag,
2037: r_enc_period.r_schedule_percent, r_enc_period.r_reason_code;
2038: CLOSE enc_period_cur;
2039:
2040: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
2041: l_proc_step := 30;
2042:
2043: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2044: load_sch_hierarchy(p_assignment_id, p_payroll_id, p_element_type_id, g_business_group_id, g_set_of_books_id, p_return_status);

Line 2058: hr_utility.trace('Cutting down periods beyond MAX(poeta_end_date); r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

2054: r_enc_period.r_effective_date, r_enc_period.r_process_flag,
2055: r_enc_period.r_schedule_percent, r_enc_period.r_reason_code;
2056: CLOSE enc_period_cur;
2057:
2058: hr_utility.trace('Cutting down periods beyond MAX(poeta_end_date); r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
2059:
2060: l_proc_step := 40;
2061:
2062: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN

Line 2069: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

2065: RAISE fnd_api.g_exc_unexpected_error;
2066: END IF;
2067: END IF;
2068:
2069: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
2070: l_proc_step := 50;
2071:
2072: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2073: determine_enc_amount(p_person_id => l_person_id,

Line 2152: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||

2148: ' ASD: ' || TO_CHAR(l_asg_start_date, 'DD-MON-RRRR') || ' AED: ' || TO_CHAR(l_asg_end_date, 'DD-MON-RRRR') ||
2149: ' PF: ' || l_process_flag || ' EA: ' || l_earnings_amount || ' ED: ' || TO_CHAR(l_effective_date, 'DD-MON-RRRR') ||
2150: ' BD: ' || l_bus_days_in_chunk);
2151:
2152: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||
2153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||

Line 2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||

2154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||

Line 2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||

2155: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2156: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2163: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||

Line 2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||

2157: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2163: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2164: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2165:

Line 2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||

2158: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2163: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2164: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2165:
2166: l_proc_step := 70 + (l_chunk_pointer / 100000);

Line 2163: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||

2159: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2163: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2164: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2165:
2166: l_proc_step := 70 + (l_chunk_pointer / 100000);
2167:

Line 2164: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));

2160: ' l_process_flag: ' || l_process_flag ||
2161: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2162: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2163: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2164: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2165:
2166: l_proc_step := 70 + (l_chunk_pointer / 100000);
2167:
2168: IF (l_earnings_amount <> 0) AND (l_bus_days_in_chunk > 0) THEN

Line 3114: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||

3110: (r_enc_period.r_period_amount(recno) - l_running_total);
3111: END IF;
3112:
3113: hr_utility.trace('l_time_period_id: ' || l_time_period_id ||
3114: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||
3115: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||
3116: ' t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer)));
3117: END IF;
3118: END LOOP;

Line 3115: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||

3111: END IF;
3112:
3113: hr_utility.trace('l_time_period_id: ' || l_time_period_id ||
3114: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||
3115: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||
3116: ' t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer)));
3117: END IF;
3118: END LOOP;
3119: END IF;

Line 3116: ' t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer)));

3112:
3113: hr_utility.trace('l_time_period_id: ' || l_time_period_id ||
3114: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||
3115: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||
3116: ' t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer)));
3117: END IF;
3118: END LOOP;
3119: END IF;
3120:

Line 3140: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

3136: WHEN suspense_autopop_failed THEN
3137: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3138: p_return_status := fnd_api.g_ret_sts_unexp_error;
3139: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3140: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3141: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3142: WHEN OTHERS THEN
3143: IF (g_error_message IS NULL) THEN
3144: g_error_message := l_proc_name || ': ' || SQLERRM;

Line 3148: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

3144: g_error_message := l_proc_name || ': ' || SQLERRM;
3145: END IF;
3146: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3147: p_return_status := fnd_api.g_ret_sts_unexp_error;
3148: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3149: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3150: END create_lines;
3151:
3152: ---------------------- I N S E R T S T A T E M E N T ------------------------------------

Line 4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

4049: psp_matrix_driver_pkg.set_runid;
4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4057: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

Line 4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4057: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4058: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');

Line 4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||

4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4057: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4058: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');
4059: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||

Line 4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4057: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4058: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');
4059: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4060: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||

Line 4057: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4055: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4056: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4057: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4058: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');
4059: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4060: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
4061: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||

Line 4119: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

4115: l_asg_end_date := r_enc_period.r_asg_end_date(I);
4116: l_sub_slice_counter := 1;
4117: l_proc_step := 20 + (I / 100000);
4118:
4119: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4120: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||

4120: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4125: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4126:
4127: IF (r_sch_rec.end_date.COUNT > 0) THEN
4128: FOR ge_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

Line 4125: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

4121: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4122: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4123: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4124: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4125: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4126:
4127: IF (r_sch_rec.end_date.COUNT > 0) THEN
4128: FOR ge_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
4129: LOOP

Line 4137: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

4133: l_proc_step := 30 + (ge_recno / 100000);
4134: -- OPEN global_element_cur(l_period_start_date, l_period_end_date, l_asg_start_date, l_asg_end_date);
4135: -- FETCH global_element_cur INTO l_start_date, l_end_date, l_schedule_percent;
4136:
4137: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4139: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4140: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

4134: -- OPEN global_element_cur(l_period_start_date, l_period_end_date, l_asg_start_date, l_asg_end_date);
4135: -- FETCH global_element_cur INTO l_start_date, l_end_date, l_schedule_percent;
4136:
4137: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4139: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4140: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4142: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));

Line 4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

4137: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4139: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4140: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4142: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));
4143:
4144: -- IF (global_element_cur%NOTFOUND) THEN
4145: IF (l_start_date > l_asg_end_date) THEN

Line 4142: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));

4138: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4139: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4140: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4141: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4142: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));
4143:
4144: -- IF (global_element_cur%NOTFOUND) THEN
4145: IF (l_start_date > l_asg_end_date) THEN
4146: r_enc_period_tmp1.r_period_ind(l_rec_no) := I;

Line 4518: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

4514: l_process_flag := r_enc_period_tmp1.r_process_flag(I);
4515: l_sub_slice_counter := 1;
4516: l_proc_step := 50 + (I / 100000);
4517:
4518: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4519: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||

4519: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4524: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4525:
4526: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4527: FOR et_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

Line 4524: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

4520: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4521: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4522: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4523: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4524: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4525:
4526: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4527: FOR et_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
4528: LOOP

Line 4534: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

4530: l_end_date:= r_sch_rec.end_date(et_recno);
4531: l_schedule_percent:= r_sch_rec.schedule_percent(et_recno);
4532: l_proc_step := 60 + (et_recno / 100000);
4533:
4534: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4535: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4536: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4537: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4538: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 4535: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

4531: l_schedule_percent:= r_sch_rec.schedule_percent(et_recno);
4532: l_proc_step := 60 + (et_recno / 100000);
4533:
4534: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4535: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4536: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4537: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4538: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4539:

Line 4538: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

4534: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4535: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4536: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4537: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4538: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4539:
4540: -- OPEN ls_matrix_cur;
4541: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
4542: -- IF (ls_matrix_cur%NOTFOUND) THEN

Line 4919: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

4915: l_process_flag := r_enc_period.r_process_flag(I);
4916: l_sub_slice_counter := 1;
4917: l_proc_step := 80 + (I / 100000);
4918:
4919: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4920: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||

4920: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4925: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4926:
4927: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4928: FOR eg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

Line 4925: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

4921: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4922: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4923: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4924: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4925: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4926:
4927: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4928: FOR eg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
4929: LOOP

Line 4935: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

4931: l_end_date:= r_sch_rec.end_date(eg_recno);
4932: l_schedule_percent:= r_sch_rec.schedule_percent(eg_recno);
4933: l_proc_step := 90 + (eg_recno / 100000);
4934:
4935: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4936: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4937: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4938: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4939: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 4936: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

4932: l_schedule_percent:= r_sch_rec.schedule_percent(eg_recno);
4933: l_proc_step := 90 + (eg_recno / 100000);
4934:
4935: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4936: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4937: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4938: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4939: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4940:

Line 4939: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

4935: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4936: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4937: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4938: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4939: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4940:
4941: -- OPEN eg_matrix_cur;
4942: -- FETCH eg_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
4943: -- IF (eg_matrix_cur%NOTFOUND) THEN

Line 5316: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

5312: l_process_flag := r_enc_period_tmp1.r_process_flag(I);
5313: l_sub_slice_counter := 1;
5314: l_proc_step := 110 + (I / 100000);
5315:
5316: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5317: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||

5317: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5322: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5323:
5324: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5325: FOR asg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

Line 5322: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

5318: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5319: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5320: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5321: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5322: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5323:
5324: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5325: FOR asg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
5326: LOOP

Line 5332: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

5328: l_end_date:= r_sch_rec.end_date(asg_recno);
5329: l_schedule_percent:= r_sch_rec.schedule_percent(asg_recno);
5330: l_proc_step := 120 + (l_rec_no / 100000);
5331:
5332: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5333: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5334: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5335: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5336: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 5333: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

5329: l_schedule_percent:= r_sch_rec.schedule_percent(asg_recno);
5330: l_proc_step := 120 + (l_rec_no / 100000);
5331:
5332: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5333: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5334: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5335: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5336: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5337: -- OPEN ls_matrix_cur;

Line 5336: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

5332: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5333: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5334: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5335: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5336: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5337: -- OPEN ls_matrix_cur;
5338: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
5339: -- IF (ls_matrix_cur%NOTFOUND) THEN
5340: IF (l_start_date > l_asg_end_date) THEN

Line 5589: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

5585: l_process_flag := r_enc_period.r_process_flag(I);
5586: l_sub_slice_counter := 1;
5587: l_proc_step := 150 + (I / 100000);
5588:
5589: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5590: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||

5590: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5595: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5596:
5597: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5598: FOR odls_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

Line 5595: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

5591: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5592: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5593: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5594: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5595: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5596:
5597: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5598: FOR odls_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
5599: LOOP

Line 5607: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

5603: l_proc_step := 160 + (l_rec_no / 100000);
5604: -- OPEN odls_cur(l_asg_start_date, l_asg_end_date);
5605: -- FETCH odls_cur INTO l_start_date, l_end_date, l_schedule_percent;
5606:
5607: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5609: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5610: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

5604: -- OPEN odls_cur(l_asg_start_date, l_asg_end_date);
5605: -- FETCH odls_cur INTO l_start_date, l_end_date, l_schedule_percent;
5606:
5607: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5609: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5610: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5612: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));

Line 5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

5607: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5609: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5610: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5612: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));
5613:
5614: -- IF (odls_cur%NOTFOUND) THEN
5615: IF (l_start_date > l_asg_end_date) THEN

Line 5612: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));

5608: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5609: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5610: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5611: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5612: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));
5613:
5614: -- IF (odls_cur%NOTFOUND) THEN
5615: IF (l_start_date > l_asg_end_date) THEN
5616: r_enc_period_tmp1.r_period_ind(l_rec_no) := r_enc_period.r_period_ind(I);

Line 5869: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

5865: l_process_flag := r_enc_period.r_process_flag(I);
5866: l_sub_slice_counter := 1;
5867: l_proc_step := 180 + (I / 100000);
5868:
5869: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5870: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||

5870: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5875: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5876:
5877: IF (l_process_flag IN ('BAL', 'Y')) AND (r_da.end_date_active.COUNT > 0) THEN
5878: FOR da_recno IN l_sch_pointer..r_da.start_date_active.COUNT

Line 5875: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

5871: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5872: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5873: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5874: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5875: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5876:
5877: IF (l_process_flag IN ('BAL', 'Y')) AND (r_da.end_date_active.COUNT > 0) THEN
5878: FOR da_recno IN l_sch_pointer..r_da.start_date_active.COUNT
5879: LOOP

Line 5889: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

5885: l_schedule_percent:= r_da.percent(da_recno);
5886: END IF;
5887: l_proc_step := 190 + (l_rec_no / 100000);
5888:
5889: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5890: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5891: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5892: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5893: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 5890: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

5886: END IF;
5887: l_proc_step := 190 + (l_rec_no / 100000);
5888:
5889: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5890: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5891: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5892: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5893: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5894:

Line 5893: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

5889: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5890: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5891: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5892: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5893: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5894:
5895: IF (l_start_date > l_asg_end_date) THEN
5896: r_enc_period_tmp1.r_period_ind(l_rec_no) := r_enc_period.r_period_ind(I);
5897: r_enc_period_tmp1.r_period_start_date(l_rec_no) := l_period_start_date;

Line 6114: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||

6110: l_process_flag := r_enc_period_tmp1.r_process_flag(I);
6111: l_sub_slice_counter := 1;
6112: l_proc_step := 210 + (I / 100000);
6113:
6114: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6115: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

Line 6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||

6115: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6120: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6121:
6122: IF (l_process_flag IN ('BAL', 'Y')) AND (l_sch_pointer <= r_sa.end_date_active.COUNT) THEN
6123: IF (l_asg_start_date <= g_enc_org_end_date) THEN

Line 6120: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));

6116: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6117: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6118: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6119: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6120: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6121:
6122: IF (l_process_flag IN ('BAL', 'Y')) AND (l_sch_pointer <= r_sa.end_date_active.COUNT) THEN
6123: IF (l_asg_start_date <= g_enc_org_end_date) THEN
6124: FOR sa_recno IN l_sch_pointer..r_sa.start_date_active.COUNT

Line 6135: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||

6131: l_schedule_percent:= r_sa.percent(sa_recno);
6132: END IF;
6133: l_proc_step := 220 + (l_rec_no / 100000);
6134:
6135: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6136: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6137: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6138: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6139: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

Line 6136: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||

6132: END IF;
6133: l_proc_step := 220 + (l_rec_no / 100000);
6134:
6135: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6136: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6137: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6138: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6139: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6140:

Line 6139: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

6135: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6136: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6137: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6138: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6139: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6140:
6141: IF (r_sa.start_date_active(sa_recno) > l_asg_end_date) THEN
6142: r_enc_period.r_period_ind(l_rec_no) := r_enc_period_tmp1.r_period_ind(I);
6143: r_enc_period.r_period_start_date(l_rec_no) := l_period_start_date;

Line 6344: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

6340: END IF;
6341: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6342: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6343: p_return_status := fnd_api.g_ret_sts_unexp_error;
6344: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6345: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6346: END sub_slice_asg_chunk;
6347: -- End of bug fix 3462452
6348:

Line 6356: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

6352: NULL;
6353: -- spc_track_cel('Init', NULL, 'End');
6354: EXCEPTION
6355: WHEN OTHERS THEN
6356: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6357: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6358: p_print_header => FND_API.G_TRUE);
6359: END cel_init;
6360:

Line 6376: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),

6372: l_set_of_books_id NUMBER(15);
6373: NO_UPDATE_REC_FOUND EXCEPTION;
6374:
6375: CURSOR action_parameters_cur IS
6376: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6377: argument12
6378: FROM fnd_concurrent_requests
6379: WHERE request_id = l_request_id;
6380:

Line 6447: sqlstr := sqlstr || 'payroll_id = ' || fnd_number.number_to_canonical(l_payroll_id) || ' AND ';

6443: END IF;
6444:
6445: sqlstr := 'SELECT DISTINCT assignment_id FROM psp_enc_changed_assignments WHERE ';
6446: IF (l_payroll_id IS NOT NULL) THEN
6447: sqlstr := sqlstr || 'payroll_id = ' || fnd_number.number_to_canonical(l_payroll_id) || ' AND ';
6448: END IF;
6449:
6450: sqlstr := sqlstr || 'payroll_action_id = :payroll_action_id ORDER BY assignment_id';
6451:

Line 6484: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

6480: WHEN NO_UPDATE_REC_FOUND THEN
6481: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6482: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6483: WHEN OTHERS THEN
6484: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6485: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6486: p_print_header => FND_API.G_TRUE);
6487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6488: END cel_range_code;

Line 6568: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),

6564: l_money_value NUMBER(15);
6565: l_hours_value NUMBER(15);
6566:
6567: CURSOR payroll_id_cur IS
6568: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6569: argument12
6570: FROM fnd_concurrent_requests fcr,
6571: psp_enc_processes pep
6572: WHERE pep.payroll_action_id = p_payroll_action_id

Line 7411: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

7407: p_information1 => NULL,
7408: p_return_status => l_return_status);
7409: END IF;
7410: END IF;
7411: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7412: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7413: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7414: ROLLBACK TO CEL_ARCHIVE;
7415: RAISE;

Line 7559: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', 1, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', 1, 0))),

7555: total_dr_amount, total_cr_amount,
7556: gl_dr_amount, gl_cr_amount,
7557: ogm_dr_amount, ogm_cr_amount) =
7558: (SELECT 'N',
7559: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', 1, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', 1, 0))),
7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),
7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),

Line 7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),

7556: gl_dr_amount, gl_cr_amount,
7557: ogm_dr_amount, ogm_cr_amount) =
7558: (SELECT 'N',
7559: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', 1, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', 1, 0))),
7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),
7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))

Line 7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),

7557: ogm_dr_amount, ogm_cr_amount) =
7558: (SELECT 'N',
7559: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', 1, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', 1, 0))),
7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),
7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7565: FROM psp_enc_lines pel

Line 7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),

7558: (SELECT 'N',
7559: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', 1, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', 1, 0))),
7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),
7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7565: FROM psp_enc_lines pel
7566: WHERE pel.enc_control_id = pec.enc_control_id)

Line 7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),

7559: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', 1, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', 1, 0))),
7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),
7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7565: FROM psp_enc_lines pel
7566: WHERE pel.enc_control_id = pec.enc_control_id)
7567: WHERE payroll_action_id = p_payroll_action_id;

Line 7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))

7560: SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0))), SUM(fnd_number.canonical_to_number(DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0))),
7561: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7562: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7563: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7565: FROM psp_enc_lines pel
7566: WHERE pel.enc_control_id = pec.enc_control_id)
7567: WHERE payroll_action_id = p_payroll_action_id;
7568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');

Line 8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),

8501: FROM psp_enc_controls
8502: WHERE ROWNUM = 1;
8503:
8504: CURSOR action_parameters_cur IS
8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8506: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),

Line 8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),

8503:
8504: CURSOR action_parameters_cur IS
8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8506: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),

Line 8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),

8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8506: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),

Line 8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),

8507: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8508: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,

Line 8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),

8509: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8510: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,
8516: fnd_concurrent_requests fcr
8517: WHERE pep.payroll_action_id = p_payroll_action_id

Line 9433: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

9429: WHEN OTHERS THEN
9430: IF (g_error_message IS NULL) THEN
9431: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
9432: END IF;
9433: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9434: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
9435: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
9436: p_payroll_action_id: ' || p_payroll_action_id || '
9437: p_payroll_id: ' || p_payroll_id || '

Line 9686: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

9682: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9683: retcode := fnd_api.g_ret_sts_success;
9684: EXCEPTION
9685: WHEN OTHERS THEN
9686: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
9687: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
9688: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
9689: retcode := fnd_api.g_ret_sts_unexp_error;
9690: END rollback_cel;

Line 10039: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '

10035: AND ( poa.gl_code_combination_id IS NOT NULL
10036: OR poa.award_id IS NOT NULL)
10037: ORDER BY poa.start_date_active, poa.end_date_active;
10038: BEGIN
10039: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10040: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10041: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10042: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10043:

Line 10040: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '

10036: OR poa.award_id IS NOT NULL)
10037: ORDER BY poa.start_date_active, poa.end_date_active;
10038: BEGIN
10039: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10040: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10041: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10042: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10043:
10044: clear_sch_hierarchy;

Line 10041: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '

10037: ORDER BY poa.start_date_active, poa.end_date_active;
10038: BEGIN
10039: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10040: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10041: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10042: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10043:
10044: clear_sch_hierarchy;
10045:

Line 10042: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));

10038: BEGIN
10039: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10040: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10041: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10042: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10043:
10044: clear_sch_hierarchy;
10045:
10046: l_min_start_date := r_enc_period.r_asg_start_date(1);

Line 10943: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');

10939: END IF;
10940: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
10941: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
10942: p_return_status := fnd_api.g_ret_sts_unexp_error;
10943: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
10944: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
10945: END load_sch_hierarchy;
10946:
10947: PROCEDURE add_cel_warnings(p_start_date IN DATE DEFAULT NULL,