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.PSP_ENC_CREATE_LINES dependencies on PSP_GENERAL

Line 189: g_Org_def_labor_schedule VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');

185: PROCEDURE clear_sch_hierarchy;
186:
187: -- Define Global Variables
188: g_Eff_Date_Value NUMBER;
189: g_Org_def_labor_schedule VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
190: g_Org_def_account VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
191: g_dr_cr_flag VARCHAR2(1); /* DEFAULT 'D'; commented for 2530853 */
192: g_enc_line_type VARCHAR2(1);
193: g_business_group_id NUMBER;

Line 190: g_Org_def_account VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');

186:
187: -- Define Global Variables
188: g_Eff_Date_Value NUMBER;
189: g_Org_def_labor_schedule VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_SCHEDULE');
190: g_Org_def_account VARCHAR2(3) DEFAULT psp_general.get_specific_profile('PSP_DEFAULT_ACCOUNT');
191: g_dr_cr_flag VARCHAR2(1); /* DEFAULT 'D'; commented for 2530853 */
192: g_enc_line_type VARCHAR2(1);
193: g_business_group_id NUMBER;
194: g_set_of_books_id NUMBER;

Line 639: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),

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,
643: ptp.time_period_id

Line 641: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,

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,
643: ptp.time_period_id
644: FROM pay_element_entry_values_f peev,
645: pay_input_values_f piv,

Line 642: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) 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,
643: ptp.time_period_id
644: FROM pay_element_entry_values_f peev,
645: pay_input_values_f piv,
646: pay_element_entries_f pee,

Line 936: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id);

932: l_period_end_date := r_enc_period.r_period_end_date(I);
933: l_asg_start_date := r_enc_period.r_asg_start_date(I);
934: l_asg_end_date := r_enc_period.r_asg_end_date(I);
935: l_end_date := l_asg_end_date;
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) ||

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 1035: IF (psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id) > 0) THEN

1031: END IF;
1032: l_calculate_period_amt := FALSE;
1033: l_proc_step:= 90;
1034: ELSE
1035: IF (psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id) > 0) THEN
1036: FOR J IN 1..r_salary_proposal.r_change_date.COUNT
1037: LOOP
1038: IF (l_asg_start_date <= r_salary_proposal.r_effective_end_date(J) AND
1039: l_asg_end_date >= r_salary_proposal.r_effective_start_date(J)) THEN

Line 1059: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);

1055: l_temp_salary := round((l_temp_salary * l_annualization_factor / l_num_per_fiscal_year), g_ext_precision);
1056: END IF;
1057:
1058: l_start_date := GREATEST(l_change_date, l_asg_start_date);
1059: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
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) ||

Line 1087: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);

1083:
1084: IF (l_element_end_date >= l_asg_start_date) AND (l_element_start_date <= l_asg_end_date) THEN
1085: l_start_date := GREATEST(l_asg_start_date, l_element_start_date);
1086: l_end_date := LEAST(l_asg_end_date, l_element_end_date);
1087: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1088: l_enc_amount := l_enc_amount + ROUND(((l_pay_amount * l_bus_days_in_sched)/( l_bus_working_days )),g_ext_precision);
1089: END IF;
1090:
1091: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||

Line 1141: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id);

1137: l_period_start_date := r_enc_period.r_period_start_date(I);
1138: l_period_end_date := r_enc_period.r_period_end_date(I);
1139: l_change_end_date := l_period_end_date;
1140: l_enc_amount := 0;
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) ||

Line 1186: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date), 0);

1182: END IF;
1183:
1184: /***** Commented for bug fix 3551561
1185: l_start_date := GREATEST(l_change_date, r_salary_proposal.r_effective_start_date(J), l_period_start_date);
1186: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date), 0);
1187: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1188: End of comment for bug fix 3551561 *****/
1189: -- Introduced for bug fix 3551561
1190:

Line 1198: l_bus_days_in_sched := l_bus_days_in_sched + NVL(psp_general.business_days(l_start_date, l_end_date,p_assignment_id), 0);

1194: l_start_date := GREATEST(l_period_start_date,
1195: r_salary_proposal.r_effective_start_date(l_period_counter), l_change_date);
1196: l_end_date := LEAST(l_period_end_date,
1197: r_salary_proposal.r_effective_end_date(l_period_counter), l_change_end_date);
1198: l_bus_days_in_sched := l_bus_days_in_sched + NVL(psp_general.business_days(l_start_date, l_end_date,p_assignment_id), 0);
1199: EXIT WHEN l_period_counter = r_salary_proposal.r_change_date.COUNT;
1200: EXIT WHEN l_change_date <> r_salary_proposal.r_change_date(l_period_counter + 1);
1201: l_period_counter := l_period_counter + 1;
1202: END LOOP; -- Introduced for bug fix 3673723

Line 1670: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,

1666: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668: END IF;
1669: ELSE
1670: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,
1671: l_project_id,
1672: l_award_id,
1673: l_task_id,
1674: l_effective_date,

Line 1683: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);

1679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1680: END IF;
1681:
1682: -- R12 moac uptake. Set the MOAC Context to Single
1683: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);
1684: mo_global.set_policy_context('S', l_org_id);
1685:
1686: pa_transactions_pub.validate_transaction
1687: (x_project_id => l_project_id,

Line 1768: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,

1764: RAISE SUSPENSE_AC_INVALID;
1765: END IF;
1766:
1767: IF ((t_poeta_gl_hier_array(I).r_enc_start_date <= g_enc_org_end_date) AND
1768: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,
1769: t_poeta_gl_hier_array(I).r_enc_end_date) > 0)) THEN
1770: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;
1771: orig_ci.project_id(g_orig_pointer) := l_project_id;
1772: orig_ci.task_id(g_orig_pointer) := l_task_id;

Line 1788: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /

1784: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(p_chunk_pointer);
1785: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
1786: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
1787: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
1788: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
1789: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
1790: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
1791: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
1792: END IF;

Line 1789: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);

1785: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
1786: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
1787: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
1788: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
1789: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
1790: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
1791: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
1792: END IF;
1793: add_cel_warnings(p_start_date => t_poeta_gl_hier_array(I).r_enc_start_date,

Line 1862: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,

1858: END IF;
1859: ELSE
1860: l_dist_amount := t_poeta_gl_hier_array(i).r_amount;
1861:
1862: psp_general.poeta_effective_date (t_poeta_gl_hier_array(I).r_enc_end_date,
1863: l_project_id,
1864: l_award_id,
1865: l_task_id,
1866: l_effective_date,

Line 1875: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);

1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: END IF;
1873:
1874: -- R12 moac uptake. Set the MOAC Context to Single
1875: l_org_id := psp_general.get_transaction_org_id( l_project_id, l_expenditure_org_id);
1876: mo_global.set_policy_context('S', l_org_id);
1877:
1878: pa_transactions_pub.validate_transaction
1879: (x_project_id => l_project_id,

Line 1959: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,

1955: RAISE SUSPENSE_AC_INVALID;
1956: END IF;
1957:
1958: IF ((t_poeta_gl_hier_array(I).r_enc_start_date <= g_enc_org_end_date) AND
1959: (psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date,
1960: t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id) > 0)) THEN
1961: orig_ci.gl_code_combination_id(g_orig_pointer) := l_gl_code_combination_id;
1962: orig_ci.project_id(g_orig_pointer) := l_project_id;
1963: orig_ci.task_id(g_orig_pointer) := l_task_id;

Line 1979: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /

1975: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(p_chunk_pointer);
1976: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
1977: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
1978: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
1979: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
1980: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
1981: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
1982: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
1983: END IF;

Line 1980: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);

1976: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
1977: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
1978: r_enc_period.r_encumbrance_amount(l_enc_period_count) :=
1979: ROUND(((l_daily_rate * psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, LEAST(t_poeta_gl_hier_array(I).r_enc_end_date, g_enc_org_end_date),p_assignment_id)) /
1980: psp_general.business_days(t_poeta_gl_hier_array(I).r_enc_start_date, t_poeta_gl_hier_array(I).r_enc_end_date,p_assignment_id)),g_ext_precision);
1981: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(p_chunk_pointer);
1982: r_enc_period.r_reason_code(l_enc_period_count) := l_patc_status;
1983: END IF;
1984:

Line 2108: (psp_general.business_days(r_enc_period.r_period_start_date(1),

2104: l_max_end_date := LEAST(r_enc_period.r_asg_end_date(r_enc_period.r_asg_end_date.COUNT),
2105: l_max_end_date);
2106:
2107: IF ( (l_min_start_date > r_enc_period.r_period_start_date(1)) AND
2108: (psp_general.business_days(r_enc_period.r_period_start_date(1),
2109: r_enc_period.r_period_end_date(1),p_assignment_id) <>
2110: psp_general.business_days(l_min_start_date,
2111: r_enc_period.r_period_end_date(1),p_assignment_id))) THEN
2112: l_ignore_start := r_enc_period.r_time_period_id(1);

Line 2110: psp_general.business_days(l_min_start_date,

2106:
2107: IF ( (l_min_start_date > r_enc_period.r_period_start_date(1)) AND
2108: (psp_general.business_days(r_enc_period.r_period_start_date(1),
2109: r_enc_period.r_period_end_date(1),p_assignment_id) <>
2110: psp_general.business_days(l_min_start_date,
2111: r_enc_period.r_period_end_date(1),p_assignment_id))) THEN
2112: l_ignore_start := r_enc_period.r_time_period_id(1);
2113: END IF;
2114:

Line 2116: (psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT),

2112: l_ignore_start := r_enc_period.r_time_period_id(1);
2113: END IF;
2114:
2115: IF ( (l_max_end_date < r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) AND
2116: (psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT),
2117: r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) <>
2118: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN
2119: l_ignore_end := r_enc_period.r_time_period_id(r_enc_period.r_asg_end_date.COUNT);
2120: END IF;

Line 2118: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN

2114:
2115: IF ( (l_max_end_date < r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) AND
2116: (psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT),
2117: r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) <>
2118: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN
2119: l_ignore_end := r_enc_period.r_time_period_id(r_enc_period.r_asg_end_date.COUNT);
2120: END IF;
2121: hr_utility.trace('l_ignore_start: ' || l_ignore_start);
2122: hr_utility.trace('l_ignore_end: ' || l_ignore_end);

Line 2138: l_bus_days_in_chunk := psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id);

2134: l_period_ind := r_enc_period.r_period_ind(l_chunk_pointer);
2135: l_effective_date := r_enc_period.r_effective_date(l_chunk_pointer);
2136: l_reason_code := r_enc_period.r_reason_code(l_chunk_pointer);
2137:
2138: l_bus_days_in_chunk := psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id);
2139: l_dist_amount := 0;
2140: l_schedule_line_id := NULL;
2141: l_org_schedule_id := NULL;
2142: l_element_account_id := NULL;

Line 2247: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2243: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2244: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2245: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2246: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2247: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2248: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2249: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2250: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2251: END IF;

Line 2368: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2364: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2365: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2366: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2367: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2368: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2369: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2370: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2371: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2372: END IF;

Line 2489: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2485: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2486: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2487: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2488: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2489: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2490: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2491: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2492: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2493: END IF;

Line 2618: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2614: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2615: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2616: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2617: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2618: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2619: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2620: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2621: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2622: END IF;

Line 2745: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2741: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2742: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2743: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2744: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2745: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2746: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2747: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2748: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2749: END IF;

Line 2874: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));

2870: r_enc_period.r_time_period_id(l_enc_period_count) := r_enc_period.r_time_period_id(l_chunk_pointer);
2871: r_enc_period.r_process_flag(l_enc_period_count) := 'SA';
2872: r_enc_period.r_schedule_percent(l_enc_period_count) := 100;
2873: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND(r_enc_period.r_encumbrance_amount(l_chunk_pointer) *
2874: (psp_general.business_days(l_asg_start_date, r_enc_period.r_asg_end_date(l_enc_period_count)) / l_bus_days_in_chunk));
2875: r_enc_period.r_encumbrance_amount(l_enc_period_count) := ROUND((r_enc_period.r_encumbrance_amount(l_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
2876: r_enc_period.r_period_amount(l_enc_period_count) := r_enc_period.r_period_amount(l_chunk_pointer);
2877: r_enc_period.r_reason_code(l_enc_period_count) := l_autopop_error;
2878: END IF;

Line 3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);

3030: fnd_message.set_token('AW', l_award_number);
3031: fnd_message.set_token('EO', l_exp_org_name);
3032: fnd_message.set_token('ET', l_expenditure_type);
3033: ELSE
3034: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_gl_code_combination_id);
3035: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
3036: fnd_message.set_token('GL', l_gl_description);
3037: END IF;
3038: fnd_message.set_token('START_DATE', l_asg_start_date);

Line 3610: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);

3606: END IF;
3607: END IF;
3608: END IF; --Main IF :2317856
3609:
3610: l_bus_days_in_period := PSP_GENERAL.BUSINESS_DAYS(p_asg_start_date, p_asg_end_date,p_assignment_id);
3611: IF l_bus_days_in_period = 0 THEN
3612: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
3613: fnd_message.set_token('START_DATE', p_asg_start_date);
3614: fnd_message.set_token('END_DATE', p_asg_end_date);

Line 3621: l_bus_days_in_schedules := PSP_GENERAL.BUSINESS_DAYS(p_poeta_gl_hier_array(j).r_enc_start_date, p_poeta_gl_hier_array(j).r_enc_end_date,p_assignment_id);

3617: END IF;
3618:
3619: For j in 1 .. p_poeta_gl_hier_array.COUNT
3620: LOOP
3621: l_bus_days_in_schedules := PSP_GENERAL.BUSINESS_DAYS(p_poeta_gl_hier_array(j).r_enc_start_date, p_poeta_gl_hier_array(j).r_enc_end_date,p_assignment_id);
3622: p_poeta_gl_hier_array(j).r_amount :=
3623: round(((p_asg_amount * l_bus_days_in_schedules) / l_bus_days_in_period),g_ext_precision);
3624: -- Introduced rounding for Bug 2916848 Ilo Mrc Ehnc.
3625: END LOOP;

Line 6466: psp_general.add_report_error

6462: IF (SQL%ROWCOUNT = 0) THEN
6463: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');
6464: g_warning_message := fnd_message.get;
6465: fnd_file.put_line(fnd_file.log, g_warning_message);
6466: psp_general.add_report_error
6467: (p_request_id => l_request_id,
6468: p_message_level => 'N',
6469: p_source_id => NULL,
6470: p_source_name => NULL,

Line 6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));

6846: fnd_message.set_token('HOURS', cel_warnings.percent(recno));
6847: g_warning_message := fnd_message.get;
6848: ELSIF (cel_warnings.warning_code(recno) = 'AUTOPOP') AND
6849: (cel_warnings.gl_ccid(recno) IS NOT NULL) THEN
6850: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, cel_warnings.gl_ccid(recno));
6851: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6852: fnd_message.set_token('START_DATE', cel_warnings.start_date(recno));
6853: fnd_message.set_token('END_DATE', cel_warnings.end_date(recno));
6854: fnd_message.set_token('GL', l_gl_description);

Line 6930: psp_general.add_report_error

6926: END IF;
6927: g_warning_message := fnd_message.get;
6928: END IF;
6929:
6930: psp_general.add_report_error
6931: (p_request_id => g_request_id,
6932: p_message_level => 'W',
6933: p_source_id => l_assignment_id,
6934: p_source_name => l_assignment_number,

Line 6974: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(l_business_group_id);

6970: g_business_group_id := l_business_group_id;
6971: g_enc_line_type := 'U';
6972: g_package_name := 'PSP_ENC_CREATE_LINES.';
6973: g_payroll_action_id := p_payroll_action_id;
6974: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(l_business_group_id);
6975:
6976: OPEN cel_request_id_cur;
6977: FETCH cel_request_id_cur INTO g_request_id;
6978: CLOSE cel_request_id_cur;

Line 7015: g_currency_code := psp_general.get_currency_code(l_business_group_id);

7011: l_enc_create_lines := 1;
7012: l_enclines_index := 1;
7013: l_enc_create := 1;
7014: l_pre_process_mode:= 'R';
7015: g_currency_code := psp_general.get_currency_code(l_business_group_id);
7016: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);
7017: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_line_type: U
7018: g_request_id: ' || g_request_id || '
7019: g_payroll_action_id: ' || g_payroll_action_id || '

Line 7016: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);

7012: l_enclines_index := 1;
7013: l_enc_create := 1;
7014: l_pre_process_mode:= 'R';
7015: g_currency_code := psp_general.get_currency_code(l_business_group_id);
7016: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);
7017: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_line_type: U
7018: g_request_id: ' || g_request_id || '
7019: g_payroll_action_id: ' || g_payroll_action_id || '
7020: g_currency_code: ' || g_currency_code || '

Line 7148: psp_general.get_currency_precision('STAT',g_precision,g_ext_precision);

7144: CLOSE hours_value_cur;
7145:
7146: IF (l_hours_value > 0) THEN
7147: g_uom := 'H';
7148: psp_general.get_currency_precision('STAT',g_precision,g_ext_precision);
7149: OPEN c_max_enc_date(l_assignment_id, l_element_type_id, l_enc_begin_date);
7150: FETCH c_max_enc_date INTO l_enc_create, l_max_enc_hist_date;
7151: CLOSE c_max_enc_date;
7152:

Line 7380: psp_general.add_report_error

7376: OPEN element_name_cur;
7377: FETCH element_name_cur INTO l_element_name;
7378: CLOSE element_name_cur;
7379:
7380: psp_general.add_report_error
7381: (p_request_id => g_request_id,
7382: p_message_level => 'E',
7383: p_source_id => l_assignment_id,
7384: p_source_name => l_assignment_number,

Line 7397: psp_general.add_report_error

7393: p_value3 => l_element_type_id,
7394: p_information3 => l_element_name,
7395: p_return_status => l_return_status);
7396: ELSE
7397: psp_general.add_report_error
7398: (p_request_id => g_request_id,
7399: p_message_level => 'E',
7400: p_source_id => NULL,
7401: p_source_name => NULL,

Line 8637: IF (l_new_cust = 0 AND psp_general.start_capturing_updates(l_business_group_id) = 'N') THEN

8633: END IF;
8634: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_enc_begin_date: ' || fnd_date.date_to_canonical(l_enc_begin_date));
8635:
8636: l_pre_process_mode := 'R';
8637: IF (l_new_cust = 0 AND psp_general.start_capturing_updates(l_business_group_id) = 'N') THEN
8638: l_pre_process_mode := 'F';
8639: END IF;
8640:
8641: psp_enc_pre_process.poeta_pre_process

Line 9055: psp_general.add_report_error

9051: OPEN org_name_cur;
9052: FETCH org_name_cur INTO l_organization_name;
9053: CLOSE org_name_cur;
9054:
9055: psp_general.add_report_error
9056: (p_request_id => l_request_id,
9057: p_message_level => 'N',
9058: p_source_id => l_assignment_id,
9059: p_source_name => l_assignment_number,

Line 9131: psp_general.add_report_error

9127: OPEN org_name_cur;
9128: FETCH org_name_cur INTO l_organization_name;
9129: CLOSE org_name_cur;
9130:
9131: psp_general.add_report_error
9132: (p_request_id => l_request_id,
9133: p_message_level => 'N',
9134: p_source_id => l_assignment_id,
9135: p_source_name => l_assignment_number,

Line 9198: psp_general.add_report_error

9194: OPEN org_name_cur;
9195: FETCH org_name_cur INTO l_organization_name;
9196: CLOSE org_name_cur;
9197:
9198: psp_general.add_report_error
9199: (p_request_id => l_request_id,
9200: p_message_level => 'N',
9201: p_source_id => l_assignment_id,
9202: p_source_name => l_assignment_number,

Line 9266: psp_general.add_report_error

9262: OPEN org_name_cur;
9263: FETCH org_name_cur INTO l_organization_name;
9264: CLOSE org_name_cur;
9265:
9266: psp_general.add_report_error
9267: (p_request_id => l_request_id,
9268: p_message_level => 'N',
9269: p_source_id => l_assignment_id,
9270: p_source_name => l_assignment_number,

Line 9334: psp_general.add_report_error

9330: OPEN org_name_cur;
9331: FETCH org_name_cur INTO l_organization_name;
9332: CLOSE org_name_cur;
9333:
9334: psp_general.add_report_error
9335: (p_request_id => l_request_id,
9336: p_message_level => 'N',
9337: p_source_id => l_assignment_id,
9338: p_source_name => l_assignment_number,

Line 9402: psp_general.add_report_error

9398: OPEN org_name_cur;
9399: FETCH org_name_cur INTO l_organization_name;
9400: CLOSE org_name_cur;
9401:
9402: psp_general.add_report_error
9403: (p_request_id => l_request_id,
9404: p_message_level => 'N',
9405: p_source_id => l_assignment_id,
9406: p_source_name => l_assignment_number,