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 FND_NUMBER

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

836:
837: CURSOR element_period_amount_cur IS
838: SELECT time_period_id,
839: SUM(period_amount)
840: FROM (SELECT ((MAX(fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0))) *
841: SUM(psp_general.business_days( GREATEST(ptp.start_date, paf.effective_start_date, peev.effective_start_date),
842: LEAST(ptp.end_date, paf.effective_end_date, peev.effective_end_date),p_assignment_id)) ) /
843: DECODE(psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id), 0, 1,
844: psp_general.business_days(MAX(ptp.start_date), MAX(ptp.end_date),p_assignment_id)) ) period_amount,

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

946:
947: CURSOR get_element_entry IS
948: SELECT DISTINCT GREATEST(paf.effective_start_date, peev.effective_start_date) element_start_date,
949: LEAST(paf.effective_end_date, peev.effective_end_date) element_end_date,
950: fnd_number.canonical_to_number(NVL(peev.screen_entry_value, 0)) pay_amount
951: FROM pay_element_entry_values_f peev,
952: pay_input_values_f piv,
953: pay_element_entries_f pee,
954: pay_element_links_f pel,

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

1072:
1073: BEGIN
1074: l_proc_step:= 10;
1075: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
1076: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
1077: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

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

1073: BEGIN
1074: l_proc_step:= 10;
1075: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
1076: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
1077: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1081: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||

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

1074: l_proc_step:= 10;
1075: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
1076: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
1077: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1081: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
1082: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

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

1075: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
1076: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
1077: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1081: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
1082: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
1083:

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

1076: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
1077: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1081: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
1082: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
1083:
1084: IF (r_enc_period.r_time_period_id.COUNT = 0) THEN

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

1077: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1081: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
1082: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
1083:
1084: IF (r_enc_period.r_time_period_id.COUNT = 0) THEN
1085: RETURN;

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

1078: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1079: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1080: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1081: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days) ||
1082: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
1083:
1084: IF (r_enc_period.r_time_period_id.COUNT = 0) THEN
1085: RETURN;
1086: END IF;

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

1123: CLOSE get_element_entry;
1124:
1125: l_proc_step:= 50;
1126:
1127: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||
1128: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||
1129: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));
1130: hr_utility.trace('Calculating Assignment Chunk Amounts...');
1131:

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

1124:
1125: l_proc_step:= 50;
1126:
1127: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||
1128: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||
1129: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));
1130: hr_utility.trace('Calculating Assignment Chunk Amounts...');
1131:
1132: FOR I IN 1..r_enc_period.r_time_period_id.COUNT

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

1125: l_proc_step:= 50;
1126:
1127: hr_utility.trace('l_num_per_fiscal_year: ' || fnd_number.number_to_canonical(l_num_per_fiscal_year) ||
1128: ' r_salary_proposal.r_change_date.COUNT: ' || fnd_number.number_to_canonical(r_salary_proposal.r_change_date.COUNT) ||
1129: ' r_element_entry.r_element_start_date.COUNT: ' || fnd_number.number_to_canonical(r_element_entry.r_element_start_date.COUNT));
1130: hr_utility.trace('Calculating Assignment Chunk Amounts...');
1131:
1132: FOR I IN 1..r_enc_period.r_time_period_id.COUNT
1133: LOOP

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

1146: l_bus_working_days := psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id); -- Reverting the change done by 9683158 for the Bug 12647364
1147: l_enc_amount := 0;
1148: l_proc_step:= 60 + (I / 100000);
1149:
1150: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1151: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1152: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
1154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

1151: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1152: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1153: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
1154: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
1155: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1156:
1157: IF (l_bus_working_days = 0) THEN
1158: fnd_message.set_name('PSP', 'PSP_ENC_ZERO_WORK_DAYS_PERIOD');
1159: fnd_message.set_token('START_DATE', l_period_start_date);

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

1166: p_element_type_id => p_element_type_id,
1167: p_time_period_id => r_enc_period.r_time_period_id(I),
1168: p_asg_start_date => l_asg_start_date,
1169: p_asg_end_date => l_asg_end_date);
1170: hr_utility.trace('l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1171:
1172: IF (l_enc_amount = 0) THEN
1173: IF (l_formula_id IS NOT NULL) THEN
1174: IF ( (t_ff_start_date.COUNT > 0) AND

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

1192: hr_utility.trace('l_inputs.COUNT: ' || l_inputs.COUNT);
1193: FOR recno IN 1..l_inputs.COUNT
1194: LOOP
1195: IF (l_inputs(recno).name ='PERSON_ID') THEN
1196: l_inputs(recno).value := fnd_number.number_to_canonical(p_person_id);
1197: hr_utility.trace('Assigned person_id');
1198: ELSIF (l_inputs(recno).name ='ASSIGNMENT_ID') THEN
1199: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);
1200: hr_utility.trace('Assigned assignment_id');

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

1195: IF (l_inputs(recno).name ='PERSON_ID') THEN
1196: l_inputs(recno).value := fnd_number.number_to_canonical(p_person_id);
1197: hr_utility.trace('Assigned person_id');
1198: ELSIF (l_inputs(recno).name ='ASSIGNMENT_ID') THEN
1199: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);
1200: hr_utility.trace('Assigned assignment_id');
1201: ELSIF l_inputs(recno).name='ELEMENT_TYPE_ID' THEN
1202: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);
1203: hr_utility.trace('Assigned element_type_id');

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

1198: ELSIF (l_inputs(recno).name ='ASSIGNMENT_ID') THEN
1199: l_inputs(recno).value := fnd_number.number_to_canonical(p_assignment_id);
1200: hr_utility.trace('Assigned assignment_id');
1201: ELSIF l_inputs(recno).name='ELEMENT_TYPE_ID' THEN
1202: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);
1203: hr_utility.trace('Assigned element_type_id');
1204: ELSIF l_inputs(recno).name='PAYROLL_ID' THEN
1205: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);
1206: hr_utility.trace('Assigned payroll_id');

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

1201: ELSIF l_inputs(recno).name='ELEMENT_TYPE_ID' THEN
1202: l_inputs(recno).value := fnd_number.number_to_canonical(p_element_type_id);
1203: hr_utility.trace('Assigned element_type_id');
1204: ELSIF l_inputs(recno).name='PAYROLL_ID' THEN
1205: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);
1206: hr_utility.trace('Assigned payroll_id');
1207: ELSIF l_inputs(recno).name='TIME_PERIOD_ID' THEN
1208: l_inputs(recno).value := fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I));
1209: hr_utility.trace('Assigned time_period_id');

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

1204: ELSIF l_inputs(recno).name='PAYROLL_ID' THEN
1205: l_inputs(recno).value := fnd_number.number_to_canonical(p_payroll_id);
1206: hr_utility.trace('Assigned payroll_id');
1207: ELSIF l_inputs(recno).name='TIME_PERIOD_ID' THEN
1208: l_inputs(recno).value := fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I));
1209: hr_utility.trace('Assigned time_period_id');
1210: ELSIF l_inputs(recno).name='ASG_START_DATE' THEN
1211: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_start_date);
1212: hr_utility.trace('Assigned asg_start_date');

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

1213: ELSIF l_inputs(recno).name='ASG_END_DATE' THEN
1214: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_end_date);
1215: hr_utility.trace('Assigned asg_end_date');
1216: ELSIF l_inputs(recno).name='BUS_DAYS_IN_CHUNK' THEN
1217: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_asg_start_date, l_asg_end_date,p_assignment_id));
1218: hr_utility.trace('Assigned business days in chunk');
1219: ELSIF l_inputs(recno).name='PERIOD_START_DATE' THEN
1220: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_start_date);
1221: hr_utility.trace('Assigned period_start_date');

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

1222: ELSIF l_inputs(recno).name='PERIOD_END_DATE' THEN
1223: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_end_date);
1224: hr_utility.trace('Assigned period_end_date');
1225: ELSIF l_inputs(recno).name='BUS_DAYS_IN_PERIOD' THEN
1226: l_inputs(recno).value := fnd_number.number_to_canonical(psp_general.business_days(l_period_start_date, l_period_end_date,p_assignment_id));
1227: hr_utility.trace('Assigned business days in period');
1228: ELSIF l_inputs(recno).name='UOM' THEN
1229: l_inputs(recno).value := g_uom;
1230: hr_utility.trace('Assigned UOM');

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

1233: END LOOP;
1234:
1235: hr_utility.trace('Before executing fast formula');
1236: ff_exec.run_formula(l_inputs, l_outputs);
1237: l_enc_amount := l_enc_amount + fnd_number.canonical_to_number(l_outputs(1).value); -- Bug 7536024
1238: hr_utility.trace('After executing fast formula; l_enc_amount: ' || l_enc_amount);
1239: END IF;
1240: END LOOP;
1241: END IF;

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

1253: l_annualization_factor := r_salary_proposal.r_pay_annualization_factor(J);
1254: l_pay_basis := r_salary_proposal.r_pay_basis(J);
1255: l_proc_step:= 70 + (J / 100000);
1256:
1257: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1258: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1259: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1260: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1261: ' l_pay_basis: ' || l_pay_basis);

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

1255: l_proc_step:= 70 + (J / 100000);
1256:
1257: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1258: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1259: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1260: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1261: ' l_pay_basis: ' || l_pay_basis);
1262:
1263: IF (l_change_date <= l_end_date) THEN

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

1256:
1257: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1258: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1259: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1260: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1261: ' l_pay_basis: ' || l_pay_basis);
1262:
1263: IF (l_change_date <= l_end_date) THEN
1264: IF (l_num_per_fiscal_year <> 0 AND (l_pay_basis IN ('ANNUAL','MONTHLY','HOURLY'))) THEN

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

1270: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched) / ( l_bus_working_days )), g_ext_precision);
1271:
1272: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1273: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1274: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1275: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1276:
1277: l_end_date := GREATEST(l_start_date, l_change_date) - 1;
1278:

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

1271:
1272: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1273: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1274: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1275: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1276:
1277: l_end_date := GREATEST(l_start_date, l_change_date) - 1;
1278:
1279: EXIT WHEN l_change_date < l_asg_start_date;

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

1299: END IF;
1300:
1301: hr_utility.trace('l_element_start_date: ' || fnd_date.date_to_canonical(l_element_start_date) ||
1302: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1303: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1304: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1305: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1306: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1307: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));

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

1302: ' l_element_end_date: ' || fnd_date.date_to_canonical(l_element_end_date) ||
1303: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1304: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1305: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1306: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1307: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1308:
1309: EXIT WHEN l_element_start_date > l_asg_end_date;
1310: END LOOP;

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

1303: ' l_pay_amount: ' || fnd_number.number_to_canonical(l_pay_amount) ||
1304: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1305: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1306: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1307: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1308:
1309: EXIT WHEN l_element_start_date > l_asg_end_date;
1310: END LOOP;
1311: END IF;

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

1355: l_bus_working_days := psp_general.business_days(greatest(l_period_start_date,l_asg_start_date), LEAST(l_period_end_date,l_asg_end_date), p_assignment_id); -- Bug 11930831
1356: l_end_date := l_period_end_date;
1357: l_period_counter := 0;
1358:
1359: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1360: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1361: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1362: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1363:

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

1358:
1359: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1360: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
1361: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
1362: ' l_bus_working_days: ' || fnd_number.number_to_canonical(l_bus_working_days));
1363:
1364: IF (l_bus_working_days > 0) THEN
1365: FOR J IN 1..r_salary_proposal.r_change_date.COUNT
1366: LOOP

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

1381: l_annualization_factor := r_salary_proposal.r_pay_annualization_factor(J);
1382: l_pay_basis := r_salary_proposal.r_pay_basis(J);
1383: l_proc_step:= 130 + (J / 100000);
1384:
1385: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1386: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1387: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1388: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1389: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||

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

1384:
1385: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1386: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1387: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1388: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1389: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1390: ' l_pay_basis: ' || l_pay_basis);
1391:
1392: -- IF (l_change_date <= l_end_date) THEN Commented for bug fix 3551561

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

1385: hr_utility.trace('J: ' || fnd_number.number_to_canonical(J) ||
1386: ' l_change_date: ' || fnd_date.date_to_canonical(l_change_date) ||
1387: ' l_change_end_date: ' || fnd_date.date_to_canonical(l_change_end_date) ||
1388: ' l_temp_salary: ' || fnd_number.number_to_canonical(l_temp_salary) ||
1389: ' l_annualization_factor: ' || fnd_number.number_to_canonical(l_annualization_factor) ||
1390: ' l_pay_basis: ' || l_pay_basis);
1391:
1392: -- IF (l_change_date <= l_end_date) THEN Commented for bug fix 3551561
1393: IF (l_change_end_date >= l_period_start_date) AND (l_change_date <= l_period_end_date) THEN

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

1418: l_enc_amount := l_enc_amount + ROUND(((l_temp_salary * l_bus_days_in_sched)/( l_bus_working_days )), g_ext_precision);
1419: -- End of changes for bug fix 3551561
1420: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1421: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1422: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1423: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1424: -- l_end_date := GREATEST(l_start_date, l_change_date) - 1; Commented for bug fix 3551561
1425: l_prev_change_end_date := l_change_end_date;
1426: END IF;

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

1419: -- End of changes for bug fix 3551561
1420: hr_utility.trace('l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
1421: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
1422: ' l_bus_days_in_sched: ' || fnd_number.number_to_canonical(l_bus_days_in_sched) ||
1423: ' l_enc_amount: ' || fnd_number.number_to_canonical(l_enc_amount));
1424: -- l_end_date := GREATEST(l_start_date, l_change_date) - 1; Commented for bug fix 3551561
1425: l_prev_change_end_date := l_change_end_date;
1426: END IF;
1427: l_prev_change_date := l_change_date;

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

1533: p_return_status := fnd_api.g_ret_sts_success;
1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN
1541: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

1542: IF (g_error_message IS NULL) THEN
1543: g_error_message := l_proc_name || ': ' || SQLERRM;
1544: END IF;
1545: fnd_msg_pub.add_exc_msg('PSP', 'DETERMINE_ENC_AMOUNT');
1546: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1547: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1548: p_return_status := fnd_api.g_ret_sts_unexp_error;
1549: END determine_enc_amount;
1550: -- End of changes for bug fix 3488734

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

2243: l_proc_step := 10;
2244: l_proc_name := 'CREATE_LINES';
2245:
2246: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2247: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2248: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2249: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2250: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2251:

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

2244: l_proc_name := 'CREATE_LINES';
2245:
2246: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2247: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2248: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2249: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2250: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2251:
2252: p_return_status := fnd_api.g_ret_sts_success;

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

2245:
2246: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
2247: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
2248: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
2249: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
2250: ' p_last_paid_date: ' || fnd_date.date_to_canonical(p_last_paid_date));
2251:
2252: p_return_status := fnd_api.g_ret_sts_success;
2253:

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

2254: OPEN c_person_id;
2255: FETCH c_person_id INTO l_person_id;
2256: CLOSE c_person_id;
2257:
2258: hr_utility.trace('l_person_id: ' || fnd_number.number_to_canonical(l_person_id));
2259: l_proc_step := 20;
2260: g_pateo_end_date := NULL;
2261:
2262: OPEN enc_period_cur;

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

2266: r_enc_period.r_effective_date, r_enc_period.r_process_flag,
2267: r_enc_period.r_schedule_percent, r_enc_period.r_reason_code;
2268: CLOSE enc_period_cur;
2269:
2270: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
2271: l_proc_step := 30;
2272:
2273: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2274: 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 2288: 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));

2284: r_enc_period.r_effective_date, r_enc_period.r_process_flag,
2285: r_enc_period.r_schedule_percent, r_enc_period.r_reason_code;
2286: CLOSE enc_period_cur;
2287:
2288: 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));
2289:
2290: l_proc_step := 40;
2291:
2292: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN

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

2295: RAISE fnd_api.g_exc_unexpected_error;
2296: END IF;
2297: END IF;
2298:
2299: hr_utility.trace('r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
2300: l_proc_step := 50;
2301:
2302: IF (r_enc_period.r_time_period_id.COUNT > 0) THEN
2303: determine_enc_amount(p_person_id => l_person_id,

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

2378: ' ASD: ' || TO_CHAR(l_asg_start_date, 'DD-MON-RRRR') || ' AED: ' || TO_CHAR(l_asg_end_date, 'DD-MON-RRRR') ||
2379: ' PF: ' || l_process_flag || ' EA: ' || l_earnings_amount || ' ED: ' || TO_CHAR(l_effective_date, 'DD-MON-RRRR') ||
2380: ' BD: ' || l_bus_days_in_chunk);
2381:
2382: hr_utility.trace('l_chunk_pointer: ' || fnd_number.number_to_canonical(l_chunk_pointer) ||
2383: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
2384: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2385: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2386: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||

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

2384: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
2385: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2386: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2387: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2388: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2389: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2390: ' l_process_flag: ' || l_process_flag ||
2391: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2392: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||

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

2385: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
2386: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
2387: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2388: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2389: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2390: ' l_process_flag: ' || l_process_flag ||
2391: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2392: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2393: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||

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

2387: ' l_effective_date: ' || fnd_date.date_to_canonical(l_effective_date) ||
2388: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2389: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2390: ' l_process_flag: ' || l_process_flag ||
2391: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2392: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2393: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2394: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2395:

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

2388: ' l_time_period_id: ' || fnd_number.number_to_canonical(l_time_period_id) ||
2389: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2390: ' l_process_flag: ' || l_process_flag ||
2391: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2392: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2393: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2394: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2395:
2396: l_proc_step := 70 + (l_chunk_pointer / 100000);

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

2389: ' l_prev_time_period_id: ' || fnd_number.number_to_canonical(l_prev_time_period_id) ||
2390: ' l_process_flag: ' || l_process_flag ||
2391: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2392: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2393: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2394: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2395:
2396: l_proc_step := 70 + (l_chunk_pointer / 100000);
2397:

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

2390: ' l_process_flag: ' || l_process_flag ||
2391: ' l_earnings_amount: ' || fnd_number.number_to_canonical(l_earnings_amount) ||
2392: ' r_enc_period.r_period_amount(l_chunk_pointer): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(l_chunk_pointer)) ||
2393: ' l_period_ind: ' || fnd_number.number_to_canonical(l_period_ind) ||
2394: ' g_enc_lines_counter: ' || fnd_number.number_to_canonical(g_enc_lines_counter));
2395:
2396: l_proc_step := 70 + (l_chunk_pointer / 100000);
2397:
2398: IF (l_earnings_amount <> 0) AND (l_bus_days_in_chunk > 0) THEN

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

3340: (r_enc_period.r_period_amount(recno) - l_running_total);
3341: END IF;
3342:
3343: hr_utility.trace('l_time_period_id: ' || l_time_period_id ||
3344: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||
3345: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||
3346: ' 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)));
3347: END IF;
3348: END LOOP;

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

3341: END IF;
3342:
3343: hr_utility.trace('l_time_period_id: ' || l_time_period_id ||
3344: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||
3345: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||
3346: ' 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)));
3347: END IF;
3348: END LOOP;
3349: END IF;

Line 3346: ' 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)));

3342:
3343: hr_utility.trace('l_time_period_id: ' || l_time_period_id ||
3344: ' l_running_total: ' || fnd_number.number_to_canonical(l_running_total) ||
3345: ' r_enc_period.r_period_amount(recno): ' || fnd_number.number_to_canonical(r_enc_period.r_period_amount(recno)) ||
3346: ' 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)));
3347: END IF;
3348: END LOOP;
3349: END IF;
3350:

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

3366: WHEN suspense_autopop_failed THEN
3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3372: WHEN OTHERS THEN
3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3374: IF (g_error_message IS NULL) THEN

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

3375: g_error_message := l_proc_name || ': ' || SQLERRM;
3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3378: p_return_status := fnd_api.g_ret_sts_unexp_error;
3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3381: END create_lines;
3382:
3383: ---------------------- I N S E R T S T A T E M E N T ------------------------------------

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

4285: psp_matrix_driver_pkg.set_runid;
4286: l_run_id := psp_matrix_driver_pkg.get_run_id;
4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4291: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4292: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4293: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));

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

4286: l_run_id := psp_matrix_driver_pkg.get_run_id;
4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4291: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4292: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4293: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4294: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');

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

4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4291: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4292: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4293: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4294: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');
4295: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||

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

4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4291: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4292: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4293: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4294: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');
4295: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4296: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||

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

4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||
4291: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
4292: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
4293: ' r_enc_period.r_time_period_id.COUNT: ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id.COUNT));
4294: hr_utility.trace('Dumping Assignment Chunk Before Global Element Processing ...');
4295: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4296: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
4297: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||

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

4351: l_asg_end_date := r_enc_period.r_asg_end_date(I);
4352: l_sub_slice_counter := 1;
4353: l_proc_step := 20 + (I / 100000);
4354:
4355: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4356: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4357: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4358: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4359: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

4356: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4357: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4358: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4359: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4360: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4361: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4362:
4363: IF (r_sch_rec.end_date.COUNT > 0) THEN
4364: FOR ge_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

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

4357: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4358: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4359: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4360: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
4361: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4362:
4363: IF (r_sch_rec.end_date.COUNT > 0) THEN
4364: FOR ge_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
4365: LOOP

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

4369: l_proc_step := 30 + (ge_recno / 100000);
4370: -- OPEN global_element_cur(l_period_start_date, l_period_end_date, l_asg_start_date, l_asg_end_date);
4371: -- FETCH global_element_cur INTO l_start_date, l_end_date, l_schedule_percent;
4372:
4373: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4374: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4375: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4376: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4377: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

4370: -- OPEN global_element_cur(l_period_start_date, l_period_end_date, l_asg_start_date, l_asg_end_date);
4371: -- FETCH global_element_cur INTO l_start_date, l_end_date, l_schedule_percent;
4372:
4373: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4374: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4375: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4376: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4377: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4378: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));

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

4373: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4374: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4375: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4376: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4377: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4378: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));
4379:
4380: -- IF (global_element_cur%NOTFOUND) THEN
4381: IF (l_start_date > l_asg_end_date) THEN

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

4374: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4375: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4376: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4377: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4378: -- hr_utility.trace('global_element_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(global_element_cur%ROWCOUNT));
4379:
4380: -- IF (global_element_cur%NOTFOUND) THEN
4381: IF (l_start_date > l_asg_end_date) THEN
4382: r_enc_period_tmp1.r_period_ind(l_rec_no) := I;

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

4750: l_process_flag := r_enc_period_tmp1.r_process_flag(I);
4751: l_sub_slice_counter := 1;
4752: l_proc_step := 50 + (I / 100000);
4753:
4754: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
4755: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4756: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4757: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4758: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

4755: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
4756: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4757: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4758: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4759: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4760: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4761:
4762: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4763: FOR et_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

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

4756: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
4757: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
4758: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
4759: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
4760: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
4761:
4762: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
4763: FOR et_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
4764: LOOP

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

4766: l_end_date:= r_sch_rec.end_date(et_recno);
4767: l_schedule_percent:= r_sch_rec.schedule_percent(et_recno);
4768: l_proc_step := 60 + (et_recno / 100000);
4769:
4770: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4771: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4772: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4773: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4774: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

4767: l_schedule_percent:= r_sch_rec.schedule_percent(et_recno);
4768: l_proc_step := 60 + (et_recno / 100000);
4769:
4770: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4771: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4772: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4773: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4774: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4775:

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

4770: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
4771: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
4772: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
4773: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
4774: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
4775:
4776: -- OPEN ls_matrix_cur;
4777: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
4778: -- IF (ls_matrix_cur%NOTFOUND) THEN

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

5151: l_process_flag := r_enc_period.r_process_flag(I);
5152: l_sub_slice_counter := 1;
5153: l_proc_step := 80 + (I / 100000);
5154:
5155: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5156: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5157: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5158: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5159: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

5156: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5157: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5158: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5159: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5160: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5161: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5162:
5163: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5164: FOR eg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

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

5157: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5158: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5159: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5160: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5161: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5162:
5163: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5164: FOR eg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
5165: LOOP

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

5167: l_end_date:= r_sch_rec.end_date(eg_recno);
5168: l_schedule_percent:= r_sch_rec.schedule_percent(eg_recno);
5169: l_proc_step := 90 + (eg_recno / 100000);
5170:
5171: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5172: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5173: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5174: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5175: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

5168: l_schedule_percent:= r_sch_rec.schedule_percent(eg_recno);
5169: l_proc_step := 90 + (eg_recno / 100000);
5170:
5171: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5172: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5173: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5174: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5175: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5176:

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

5171: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5172: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5173: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5174: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5175: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5176:
5177: -- OPEN eg_matrix_cur;
5178: -- FETCH eg_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
5179: -- IF (eg_matrix_cur%NOTFOUND) THEN

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

5548: l_process_flag := r_enc_period_tmp1.r_process_flag(I);
5549: l_sub_slice_counter := 1;
5550: l_proc_step := 110 + (I / 100000);
5551:
5552: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5553: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5554: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5555: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5556: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

5553: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5554: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5555: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5556: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5557: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5558: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5559:
5560: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5561: FOR asg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

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

5554: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5555: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5556: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5557: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
5558: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5559:
5560: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5561: FOR asg_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
5562: LOOP

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

5564: l_end_date:= r_sch_rec.end_date(asg_recno);
5565: l_schedule_percent:= r_sch_rec.schedule_percent(asg_recno);
5566: l_proc_step := 120 + (l_rec_no / 100000);
5567:
5568: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5569: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5570: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5571: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5572: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

5565: l_schedule_percent:= r_sch_rec.schedule_percent(asg_recno);
5566: l_proc_step := 120 + (l_rec_no / 100000);
5567:
5568: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5569: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5570: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5571: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5572: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5573: -- OPEN ls_matrix_cur;

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

5568: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5569: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5570: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5571: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5572: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5573: -- OPEN ls_matrix_cur;
5574: -- FETCH ls_matrix_cur INTO l_start_date, l_end_date, l_schedule_percent;
5575: -- IF (ls_matrix_cur%NOTFOUND) THEN
5576: IF (l_start_date > l_asg_end_date) THEN

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

5821: l_process_flag := r_enc_period.r_process_flag(I);
5822: l_sub_slice_counter := 1;
5823: l_proc_step := 150 + (I / 100000);
5824:
5825: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
5826: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5827: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5828: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5829: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

5826: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
5827: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5828: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5829: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5830: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5831: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5832:
5833: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5834: FOR odls_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT

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

5827: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
5828: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
5829: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
5830: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
5831: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
5832:
5833: IF (l_process_flag = 'Y') AND (r_sch_rec.end_date.COUNT > 0) THEN
5834: FOR odls_recno IN l_sch_pointer..r_sch_rec.start_date.COUNT
5835: LOOP

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

5839: l_proc_step := 160 + (l_rec_no / 100000);
5840: -- OPEN odls_cur(l_asg_start_date, l_asg_end_date);
5841: -- FETCH odls_cur INTO l_start_date, l_end_date, l_schedule_percent;
5842:
5843: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5844: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5845: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5846: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5847: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

5840: -- OPEN odls_cur(l_asg_start_date, l_asg_end_date);
5841: -- FETCH odls_cur INTO l_start_date, l_end_date, l_schedule_percent;
5842:
5843: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5844: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5845: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5846: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5847: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5848: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));

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

5843: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
5844: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5845: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5846: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5847: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5848: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));
5849:
5850: -- IF (odls_cur%NOTFOUND) THEN
5851: IF (l_start_date > l_asg_end_date) THEN

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

5844: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
5845: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
5846: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
5847: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
5848: -- hr_utility.trace('odls_cur%ROWCOUNT: ' || fnd_number.number_to_canonical(odls_cur%ROWCOUNT));
5849:
5850: -- IF (odls_cur%NOTFOUND) THEN
5851: IF (l_start_date > l_asg_end_date) THEN
5852: r_enc_period_tmp1.r_period_ind(l_rec_no) := r_enc_period.r_period_ind(I);

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

6101: l_process_flag := r_enc_period.r_process_flag(I);
6102: l_sub_slice_counter := 1;
6103: l_proc_step := 180 + (I / 100000);
6104:
6105: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6106: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6107: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6108: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6109: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

6106: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6107: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6108: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6109: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6110: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
6111: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6112:
6113: IF (l_process_flag IN ('BAL', 'Y')) AND (r_da.end_date_active.COUNT > 0) THEN
6114: FOR da_recno IN l_sch_pointer..r_da.start_date_active.COUNT

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

6107: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6108: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6109: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6110: ' r_enc_period.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period.r_time_period_id(I)) ||
6111: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6112:
6113: IF (l_process_flag IN ('BAL', 'Y')) AND (r_da.end_date_active.COUNT > 0) THEN
6114: FOR da_recno IN l_sch_pointer..r_da.start_date_active.COUNT
6115: LOOP

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

6121: l_schedule_percent:= r_da.percent(da_recno);
6122: END IF;
6123: l_proc_step := 190 + (l_rec_no / 100000);
6124:
6125: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6126: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6127: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6128: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6129: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

6122: END IF;
6123: l_proc_step := 190 + (l_rec_no / 100000);
6124:
6125: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6126: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6127: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6128: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6129: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6130:

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

6125: hr_utility.trace(' l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6126: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6127: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6128: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6129: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6130:
6131: IF (l_start_date > l_asg_end_date) THEN
6132: r_enc_period_tmp1.r_period_ind(l_rec_no) := r_enc_period.r_period_ind(I);
6133: r_enc_period_tmp1.r_period_start_date(l_rec_no) := l_period_start_date;

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

6346: l_process_flag := r_enc_period_tmp1.r_process_flag(I);
6347: l_sub_slice_counter := 1;
6348: l_proc_step := 210 + (I / 100000);
6349:
6350: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
6351: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6352: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6353: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6354: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||

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

6351: ' l_period_start_date: ' || fnd_date.date_to_canonical(l_period_start_date) ||
6352: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6353: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6354: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6355: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6356: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6357:
6358: IF (l_process_flag IN ('BAL', 'Y')) AND (l_sch_pointer <= r_sa.end_date_active.COUNT) THEN
6359: IF (l_asg_start_date <= g_enc_org_end_date) THEN

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

6352: ' l_period_end_date: ' || fnd_date.date_to_canonical(l_period_end_date) ||
6353: ' l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) ||
6354: ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date) ||
6355: ' r_enc_period_tmp1.r_time_period_id(I): ' || fnd_number.number_to_canonical(r_enc_period_tmp1.r_time_period_id(I)) ||
6356: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no));
6357:
6358: IF (l_process_flag IN ('BAL', 'Y')) AND (l_sch_pointer <= r_sa.end_date_active.COUNT) THEN
6359: IF (l_asg_start_date <= g_enc_org_end_date) THEN
6360: FOR sa_recno IN l_sch_pointer..r_sa.start_date_active.COUNT

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

6367: l_schedule_percent:= r_sa.percent(sa_recno);
6368: END IF;
6369: l_proc_step := 220 + (l_rec_no / 100000);
6370:
6371: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6372: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6373: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6374: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6375: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));

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

6368: END IF;
6369: l_proc_step := 220 + (l_rec_no / 100000);
6370:
6371: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6372: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6373: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6374: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6375: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6376:

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

6371: hr_utility.trace('l_sub_slice_counter: ' || fnd_number.number_to_canonical(l_sub_slice_counter) ||
6372: ' l_rec_no: ' || fnd_number.number_to_canonical(l_rec_no) ||
6373: ' l_start_date: ' || fnd_date.date_to_canonical(l_start_date) ||
6374: ' l_end_date: ' || fnd_date.date_to_canonical(l_end_date) ||
6375: ' l_schedule_percent: ' || fnd_number.number_to_canonical(l_schedule_percent));
6376:
6377: IF (r_sa.start_date_active(sa_recno) > l_asg_end_date) THEN
6378: r_enc_period.r_period_ind(l_rec_no) := r_enc_period_tmp1.r_period_ind(I);
6379: r_enc_period.r_period_start_date(l_rec_no) := l_period_start_date;

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

6577: END IF;
6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6580: p_return_status := fnd_api.g_ret_sts_unexp_error;
6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6583: END sub_slice_asg_chunk;
6584: -- End of bug fix 3462452
6585:

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

6608: -- spc_track_cel('Init', NULL, 'End');
6609: EXCEPTION
6610: WHEN OTHERS THEN
6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6614: p_print_header => FND_API.G_TRUE);
6615: END cel_init;
6616:

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

6628: l_set_of_books_id NUMBER(15);
6629: NO_UPDATE_REC_FOUND EXCEPTION;
6630:
6631: CURSOR action_parameters_cur IS
6632: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6633: argument12
6634: FROM fnd_concurrent_requests
6635: WHERE request_id = l_request_id;
6636:

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

6699: END IF;
6700:
6701: sqlstr := 'SELECT DISTINCT assignment_id FROM psp_enc_changed_assignments WHERE ';
6702: IF (l_payroll_id IS NOT NULL) THEN
6703: sqlstr := sqlstr || 'payroll_id = ' || fnd_number.number_to_canonical(l_payroll_id) || ' AND ';
6704: END IF;
6705:
6706: sqlstr := sqlstr || 'payroll_action_id = :payroll_action_id ORDER BY assignment_id';
6707:

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

6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6745: END cel_range_code;

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

6821: l_money_value NUMBER(15);
6822: l_hours_value NUMBER(15);
6823:
6824: CURSOR payroll_id_cur IS
6825: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6826: argument12
6827: FROM fnd_concurrent_requests fcr,
6828: psp_enc_processes pep
6829: WHERE pep.payroll_action_id = p_payroll_action_id

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

7719: p_information1 => NULL,
7720: p_return_status => l_return_status);
7721: END IF;
7722: END IF;
7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7725: 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 ||')');
7726: ROLLBACK TO CEL_ARCHIVE;
7727: RAISE;

Line 7871: 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))),

7867: total_dr_amount, total_cr_amount,
7868: gl_dr_amount, gl_cr_amount,
7869: ogm_dr_amount, ogm_cr_amount) =
7870: (SELECT 'N',
7871: 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))),
7872: 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))),
7873: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7874: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7875: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),

Line 7872: 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))),

7868: gl_dr_amount, gl_cr_amount,
7869: ogm_dr_amount, ogm_cr_amount) =
7870: (SELECT 'N',
7871: 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))),
7872: 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))),
7873: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7874: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7875: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))

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

7869: ogm_dr_amount, ogm_cr_amount) =
7870: (SELECT 'N',
7871: 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))),
7872: 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))),
7873: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7874: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7875: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7877: FROM psp_enc_lines pel

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

7870: (SELECT 'N',
7871: 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))),
7872: 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))),
7873: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7874: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7875: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7877: FROM psp_enc_lines pel
7878: WHERE pel.enc_control_id = pec.enc_control_id)

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

7871: 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))),
7872: 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))),
7873: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7874: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7875: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7877: FROM psp_enc_lines pel
7878: WHERE pel.enc_control_id = pec.enc_control_id)
7879: WHERE payroll_action_id = p_payroll_action_id;

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

7872: 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))),
7873: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7874: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'G', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0))),
7875: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'D', pel.encumbrance_amount, 0), 0))),
7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7877: FROM psp_enc_lines pel
7878: WHERE pel.enc_control_id = pec.enc_control_id)
7879: WHERE payroll_action_id = p_payroll_action_id;
7880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');

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

8825: FROM psp_enc_controls
8826: WHERE ROWNUM = 1;
8827:
8828: CURSOR action_parameters_cur IS
8829: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8830: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8831: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8832: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8833: fnd_number.canonical_to_number(NVL(argument17, '-1')),

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

8827:
8828: CURSOR action_parameters_cur IS
8829: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8830: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8831: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8832: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8833: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8834: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8835: fnd_number.canonical_to_number(NVL(argument19, '-1')),

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

8829: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),
8830: fnd_date.canonical_to_date(NVL(argument14, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8831: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8832: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8833: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8834: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8835: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8836: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8837: fnd_number.canonical_to_number(NVL(argument21, '-1')),

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

8831: fnd_number.canonical_to_number(NVL(argument15, '-1')),
8832: fnd_date.canonical_to_date(NVL(argument16, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8833: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8834: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8835: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8836: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8837: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8838: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8839: FROM psp_enc_processes pep,

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

8833: fnd_number.canonical_to_number(NVL(argument17, '-1')),
8834: fnd_date.canonical_to_date(NVL(argument18, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8835: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8836: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8837: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8838: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8839: FROM psp_enc_processes pep,
8840: fnd_concurrent_requests fcr
8841: WHERE pep.payroll_action_id = p_payroll_action_id

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

10058: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10059: IF (g_error_message IS NULL) THEN
10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '

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

10312: retcode := fnd_api.g_ret_sts_success;
10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;

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

10665: AND ( poa.gl_code_combination_id IS NOT NULL
10666: OR poa.award_id IS NOT NULL)
10667: ORDER BY poa.start_date_active, poa.end_date_active;
10668: BEGIN
10669: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10670: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10671: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10672: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10673:

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

10666: OR poa.award_id IS NOT NULL)
10667: ORDER BY poa.start_date_active, poa.end_date_active;
10668: BEGIN
10669: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10670: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10671: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10672: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10673:
10674: clear_sch_hierarchy;

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

10667: ORDER BY poa.start_date_active, poa.end_date_active;
10668: BEGIN
10669: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10670: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10671: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10672: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10673:
10674: clear_sch_hierarchy;
10675:

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

10668: BEGIN
10669: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering LOAD_SCH_HIERARCHY p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) || '
10670: p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) || '
10671: p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) || '
10672: p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
10673:
10674: clear_sch_hierarchy;
10675:
10676: l_min_start_date := r_enc_period.r_asg_start_date(1);

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

11570: END IF;
11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
11573: p_return_status := fnd_api.g_ret_sts_unexp_error;
11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11576: END load_sch_hierarchy;
11577:
11578: PROCEDURE add_cel_warnings(p_start_date IN DATE DEFAULT NULL,