[Home] [Help]
213: g_precision NUMBER; -- For Bug 2916848 Ilo Mrc Ehnc.
214: g_ext_precision NUMBER; -- For Bug 2916848 Ilo Mrc Ehnc.
215:
216: -- Introduced the following for bug fix 3462452
217: --g_debug BOOLEAN DEFAULT hr_utility.debug_enabled;
218: g_package_name VARCHAR2(31) DEFAULT 'PSP_ENC_CREATE_LINES.';
219: -- End of bug fix 3462452
220:
221: g_dff_grouping_option CHAR(1); -- Introduced for bug fix 2908859
516:
517: IF l_asgn_end_date IS NULL AND l_assignment_id IS NULL THEN
518:
519: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd ::: If --- > assignment_id details is inserted in the table '||p_assignmnet_id);
520: -- hr_utility.trace(' hr:::If --- > assignment_id details is inserted in the table '||p_assignmnet_id);
521:
522:
523: IF p_payroll_mode = 'Y' OR p_payroll_mode IS NULL THEN
524:
538:
539: insert into psp_asg_end_dates (PAYROLL_ACTION_ID ,ASSIGNMENT_ID ,PAYROLL_ID ,BG_GRP_ID ,ASG_END_DATE ) --jnerella 26/07/2012
540: values(p_payroll_action_id,p_assignmnet_id,p_payroll_id,p_business_group_id,l_asgn_end_date);
541: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::If table --- > insert '||sql%rowcount);
542: -- hr_utility.trace(' hr:::If table --- > insert '||sql%rowcount);
543:
544: commit;
545:
546: return l_asgn_end_date;
547:
548: ELSE
549:
550: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::Else --> assignment_id already exists in the table'||p_assignmnet_id);
551: -- hr_utility.trace(' hr::Else --> assignment_id already exists in the table'||p_assignmnet_id);
552: return l_asgn_end_date;
553:
554: END IF;
555:
1071: ORDER BY start_date,end_date; -- Added for bug 12724506
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) ||
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) ||
1096: OPEN formula_date_cur;
1097: FETCH formula_date_cur BULK COLLECT INTO t_ff_start_date, t_ff_end_date;
1098: CLOSE formula_date_cur;
1099:
1100: hr_utility.trace('t_ff_start_date.COUNT: ' || t_ff_start_date.COUNT);
1101: END IF;
1102:
1103: OPEN get_no_per_fiscal_year_csr;
1104: FETCH get_no_per_fiscal_year_csr INTO 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:
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
1134: IF (r_enc_period.r_process_flag(I) <> 'I') THEN
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) ||
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
1177: FOR ff_recno IN 1..t_ff_start_date.COUNT
1178: LOOP
1179: l_asg_start_date := r_enc_period.r_asg_start_date(I);
1180: l_asg_end_date := r_enc_period.r_asg_end_date(I);
1181: hr_utility.trace('l_asg_start_date: ' || l_asg_start_date || ' l_asg_end_date: ' || l_asg_end_date || ' t_ff_start_date(ff_recno): ' || t_ff_start_date(ff_recno) || ' t_ff_end_date(ff_recno): ' || t_ff_end_date(ff_recno));
1182: IF l_asg_start_date <= t_ff_end_date(ff_recno) AND
1183: l_asg_end_date >= t_ff_start_date(ff_recno) THEN
1184: l_asg_start_date := GREATEST(l_asg_start_date, t_ff_start_date(ff_recno));
1185: l_asg_end_date := LEAST(l_asg_end_date, t_ff_end_date(ff_recno));
1186: l_inputs.DELETE;
1187: l_outputs.DELETE;
1188:
1189: ff_exec.init_formula(l_formula_id, l_asg_start_date, l_inputs,l_outputs);
1190: hr_utility.trace('Initiated Formula l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) || ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date));
1191:
1192: hr_utility.trace('l_inputs.COUNT: ' || l_inputs.COUNT);
1193: FOR recno IN 1..l_inputs.COUNT
1194: LOOP
1188:
1189: ff_exec.init_formula(l_formula_id, l_asg_start_date, l_inputs,l_outputs);
1190: hr_utility.trace('Initiated Formula l_asg_start_date: ' || fnd_date.date_to_canonical(l_asg_start_date) || ' l_asg_end_date: ' || fnd_date.date_to_canonical(l_asg_end_date));
1191:
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);
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');
1201: ELSIF l_inputs(recno).name='ELEMENT_TYPE_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');
1204: ELSIF l_inputs(recno).name='PAYROLL_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');
1207: ELSIF l_inputs(recno).name='TIME_PERIOD_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');
1210: ELSIF l_inputs(recno).name='ASG_START_DATE' 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');
1213: ELSIF l_inputs(recno).name='ASG_END_DATE' 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');
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
1211: l_inputs(recno).value := fnd_date.date_to_canonical(l_asg_start_date);
1212: hr_utility.trace('Assigned asg_start_date');
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
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');
1222: ELSIF l_inputs(recno).name='PERIOD_END_DATE' 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');
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
1220: l_inputs(recno).value := fnd_date.date_to_canonical(l_period_start_date);
1221: hr_utility.trace('Assigned period_start_date');
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
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');
1231:
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');
1231:
1232: END IF;
1233: END LOOP;
1234:
1231:
1232: END IF;
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;
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;
1242: l_calculate_period_amt := FALSE;
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);
1268: l_start_date := GREATEST(l_change_date, l_asg_start_date);
1269: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
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:
1297: l_bus_days_in_sched := NVL(PSP_GENERAL.BUSINESS_DAYS(l_start_date, l_end_date,p_assignment_id), 0);
1298: l_enc_amount := l_enc_amount + ROUND(((l_pay_amount * l_bus_days_in_sched)/( l_bus_working_days )),g_ext_precision);
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) ||
1326: END IF;
1327: END LOOP;
1328:
1329: l_proc_step:= 110;
1330: hr_utility.trace('Calculating Period Amounts...');
1331:
1332: IF (l_calculate_period_amt) THEN
1333: -- Modified period amount calculation for bug fix 3673723
1334: -- For element entry value based period amount calculation, changed to time period reference.
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:
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) ||
1416: END LOOP; -- Introduced for bug fix 3673723
1417:
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
1452: r_enc_period.r_period_amount(I) := r_enc_period.r_period_amount(I - 1);
1453: END IF;
1454: END LOOP;
1455: ELSE
1456: hr_utility.trace('Period amounts based on formula/user hook amounts');
1457: l_enc_amount := 0;
1458: l_period_counter := 1;
1459: l_tmp_counter := 1;
1460: LOOP
1458: l_period_counter := 1;
1459: l_tmp_counter := 1;
1460: LOOP
1461: EXIT WHEN l_tmp_counter > r_enc_period.r_time_period_id.COUNT;
1462: hr_utility.trace('l_tmp_counter: ' || l_tmp_counter || ' EM: ' || r_enc_period.r_encumbrance_amount(l_tmp_counter));
1463: IF (l_tmp_counter = 1) THEN
1464: l_time_period_id := r_enc_period.r_time_period_id(l_tmp_counter);
1465: END IF;
1466: IF (r_enc_period.r_time_period_id(l_tmp_counter) = l_time_period_id) THEN
1485: END LOOP;
1486: l_period_counter := 1;
1487: FOR J IN 1..r_enc_period.r_time_period_id.COUNT
1488: LOOP
1489: hr_utility.trace('l_period_counter: ' || l_period_counter);
1490: IF (r_enc_period.r_time_period_id(J) <> r_element_period_amount.r_time_period_id(l_period_counter)) THEN
1491: l_period_counter := l_period_counter + 1;
1492: END IF;
1493: r_enc_period.r_period_amount(J) := r_element_period_amount.r_period_amount(l_period_counter);
1495: END IF;
1496:
1497: l_proc_step:= 170;
1498:
1499: hr_utility.trace('Dumping Assignment Chunks after determining Assignment chunk and Period chunk amounts');
1500: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
1501: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
1502: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
1503: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
1496:
1497: l_proc_step:= 170;
1498:
1499: hr_utility.trace('Dumping Assignment Chunks after determining Assignment chunk and Period chunk amounts');
1500: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
1501: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
1502: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
1503: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
1504: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
1504: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
1505: LPAD('Encumbrance Amount', 18, ' ') || ' ' || LPAD('Period Amount', 18, ' ') || ' ' ||
1506: RPAD('Reason Code', 50, ' '));
1507:
1508: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
1509: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
1510: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
1511: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
1512: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
1514: RPAD('-', 50, '-'));
1515:
1516: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
1517: LOOP
1518: hr_utility.trace(LPAD(recno, 13, ' ') || ' ' ||
1519: LPAD(r_enc_period.r_time_period_id(recno), 14, ' ') || ' ' ||
1520: RPAD(TO_CHAR(r_enc_period.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
1521: RPAD(TO_CHAR(r_enc_period.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
1522: RPAD(TO_CHAR(r_enc_period.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
1527: LPAD(r_enc_period.r_encumbrance_amount(recno), 18, ' ') || ' ' ||
1528: LPAD(r_enc_period.r_period_amount(recno), 18, ' ') || ' ' ||
1529: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
1530: END LOOP;
1531: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1532:
1533: p_return_status := fnd_api.g_ret_sts_success;
1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1767: IF (p_process_flag = 'SA') THEN
1768: l_sa_reason_code := l_reason_code;
1769: END IF;
1770:
1771: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering process_all_hier');
1772: hr_utility.trace(' p_chunk_pointer: ' || p_chunk_pointer ||
1773: ' p_asg_start_date: ' || TO_CHAR(p_asg_start_date, 'DD-MON-RRRR') ||
1774: ' p_asg_end_date: ' || TO_CHAR(p_asg_end_date, 'DD-MON-RRRR') ||
1775: ' p_process_flag: ' || p_process_flag);
1768: l_sa_reason_code := l_reason_code;
1769: END IF;
1770:
1771: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering process_all_hier');
1772: hr_utility.trace(' p_chunk_pointer: ' || p_chunk_pointer ||
1773: ' p_asg_start_date: ' || TO_CHAR(p_asg_start_date, 'DD-MON-RRRR') ||
1774: ' p_asg_end_date: ' || TO_CHAR(p_asg_end_date, 'DD-MON-RRRR') ||
1775: ' p_process_flag: ' || p_process_flag);
1776:
1790: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1792: END IF;
1793: END IF;
1794: hr_utility.trace(' l_last_enc_date: ' || TO_CHAR(l_last_enc_date, 'DD-MON-RRRR'));
1795:
1796: IF (r_enc_period.r_asg_start_date(p_chunk_pointer) <= l_last_enc_date) THEN
1797: l_start_date_active := GREATEST(l_start_date_active, p_asg_start_date);
1798: l_end_date_active := LEAST(l_end_date_active, p_asg_end_date, l_last_enc_date);
1797: l_start_date_active := GREATEST(l_start_date_active, p_asg_start_date);
1798: l_end_date_active := LEAST(l_end_date_active, p_asg_end_date, l_last_enc_date);
1799: l_daily_rate := round((r_enc_period.r_encumbrance_amount(p_chunk_pointer) * l_schedule_percent/100),g_ext_precision);
1800: l_daily_rate := NVL(p_encumbrance_amount, l_daily_rate);
1801: hr_utility.trace(' l_start_date_active: ' || TO_CHAR(l_start_date_active, 'DD-MON-RRRR') ||
1802: ' l_end_date_active: ' || TO_CHAR(l_end_date_active, 'DD-MON-RRRR') ||
1803: ' l_poeta_start_date: ' || TO_CHAR(l_poeta_start_date, 'DD-MON-RRRR') ||
1804: ' l_poeta_end_date: ' || TO_CHAR(l_poeta_end_date, 'DD-MON-RRRR') ||
1805: ' l_daily_rate: ' || l_daily_rate);
1816: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1818: END IF;
1819:
1820: hr_utility.trace(' t_poeta_gl_hier_array.COUNT: ' || t_poeta_gl_hier_array.COUNT);
1821: FOR I IN 1..t_poeta_gl_hier_array.COUNT
1822: LOOP
1823: hr_utility.trace(' t_poeta_gl_hier_array(' || I || ').r_enc_start_date: ' || TO_CHAR(t_poeta_gl_hier_array(I).r_enc_start_date, 'DD-MON-RRRR') ||
1824: ' t_poeta_gl_hier_array(' || I || ').r_enc_end_date: ' || TO_CHAR(t_poeta_gl_hier_array(I).r_enc_end_date, 'DD-MON-RRRR') ||
1819:
1820: hr_utility.trace(' t_poeta_gl_hier_array.COUNT: ' || t_poeta_gl_hier_array.COUNT);
1821: FOR I IN 1..t_poeta_gl_hier_array.COUNT
1822: LOOP
1823: hr_utility.trace(' t_poeta_gl_hier_array(' || I || ').r_enc_start_date: ' || TO_CHAR(t_poeta_gl_hier_array(I).r_enc_start_date, 'DD-MON-RRRR') ||
1824: ' t_poeta_gl_hier_array(' || I || ').r_enc_end_date: ' || TO_CHAR(t_poeta_gl_hier_array(I).r_enc_end_date, 'DD-MON-RRRR') ||
1825: ' t_poeta_gl_hier_array(' || I || ').r_amount: ' || t_poeta_gl_hier_array(I).r_amount ||
1826: ' t_poeta_gl_hier_array(' || I || ').r_susp_flag: ' || t_poeta_gl_hier_array(I).r_susp_flag);
1827: IF t_poeta_gl_hier_array(I).r_susp_flag <> 'Y' THEN
2226: END IF;
2227: END LOOP;
2228: END IF;
2229: t_poeta_gl_hier_array.DELETE;
2230: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving process_all_hier');
2231: END process_all_hier;
2232:
2233: PROCEDURE log_gl_hours_message IS
2234: BEGIN
2242: BEGIN
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));
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:
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;
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);
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
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,
2347: r_enc_period.r_period_end_date(r_enc_period.r_asg_end_date.COUNT)) <>
2348: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN
2349: l_ignore_end := r_enc_period.r_time_period_id(r_enc_period.r_asg_end_date.COUNT);
2350: END IF;
2351: hr_utility.trace('l_ignore_start: ' || l_ignore_start);
2352: hr_utility.trace('l_ignore_end: ' || l_ignore_end);
2353: END IF;
2354:
2355: LOOP
2348: psp_general.business_days(r_enc_period.r_period_start_date(r_enc_period.r_asg_end_date.COUNT), l_max_end_date))) THEN
2349: l_ignore_end := r_enc_period.r_time_period_id(r_enc_period.r_asg_end_date.COUNT);
2350: END IF;
2351: hr_utility.trace('l_ignore_start: ' || l_ignore_start);
2352: hr_utility.trace('l_ignore_end: ' || l_ignore_end);
2353: END IF;
2354:
2355: LOOP
2356: EXIT WHEN (l_chunk_pointer > r_enc_period.r_time_period_id.COUNT);
2372: l_element_account_id := NULL;
2373: l_default_account_id := NULL;
2374: l_suspense_account_id := NULL;
2375:
2376: hr_utility.trace('Processing chunk: CP: ' || l_chunk_pointer || ' TP: ' || l_time_period_id ||
2377: ' PSD: ' || TO_CHAR(l_period_start_date, 'DD-MON-RRRR') || ' PED: ' || TO_CHAR(l_period_end_date, 'DD-MON-RRRR') ||
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);
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) ||
2490: p_exp_org_id => l_expenditure_org_id,
2491: p_exp_type => l_expenditure_type,
2492: p_effective_date => l_effective_date,
2493: p_error_status => l_autopop_error);
2494: hr_utility.trace('Posting to suspense account');
2495: ELSE
2496: IF (l_acct_type = 'E') THEN
2497: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,
2498: p_task_id => l_task_id,
2611: p_exp_org_id => l_expenditure_org_id,
2612: p_exp_type => l_expenditure_type,
2613: p_effective_date => l_effective_date,
2614: p_error_status => l_autopop_error);
2615: hr_utility.trace('Posting to suspense account');
2616: ELSE
2617: IF (l_acct_type = 'E') THEN
2618: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,
2619: p_task_id => l_task_id,
2732: p_exp_org_id => l_expenditure_org_id,
2733: p_exp_type => l_expenditure_type,
2734: p_effective_date => l_effective_date,
2735: p_error_status => l_autopop_error);
2736: hr_utility.trace('Posting to suspense account');
2737: ELSE
2738: IF (l_acct_type = 'E') THEN
2739: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,
2740: p_task_id => l_task_id,
2861: p_exp_org_id => l_expenditure_org_id,
2862: p_exp_type => l_expenditure_type,
2863: p_effective_date => l_effective_date,
2864: p_error_status => l_autopop_error);
2865: hr_utility.trace('Posting to suspense account');
2866: ELSE
2867: IF (l_acct_type = 'E') THEN
2868: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,
2869: p_task_id => l_task_id,
2988: p_exp_org_id => l_expenditure_org_id,
2989: p_exp_type => l_expenditure_type,
2990: p_effective_date => l_effective_date,
2991: p_error_status => l_autopop_error);
2992: hr_utility.trace('Posting to suspense account');
2993: ELSE
2994: IF (l_acct_type = 'E') THEN
2995: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,
2996: p_task_id => l_task_id,
3117: p_exp_org_id => l_expenditure_org_id,
3118: p_exp_type => l_expenditure_type,
3119: p_effective_date => l_effective_date,
3120: p_error_status => l_autopop_error);
3121: hr_utility.trace('Posting to suspense account');
3122: ELSE
3123: IF (l_acct_type = 'E') THEN
3124: psp_enc_pre_process.validate_poeta (p_project_id => l_project_id,
3125: p_task_id => l_task_id,
3295: END IF;
3296: END IF;
3297: END LOOP;
3298: ELSIF (l_process_flag = 'I') THEN
3299: hr_utility.trace('Ignoring chunk starting beyond org end date');
3300: END IF;
3301: END IF;
3302:
3303: l_chunk_pointer := l_chunk_pointer + 1;
3309: orig_ci.award_id.DELETE;
3310: orig_ci.expenditure_organization_id.DELETE;
3311: orig_ci.expenditure_type.DELETE;
3312:
3313: hr_utility.trace('Prev Enc Lines: ' || l_prev_enc_lines_counter);
3314: hr_utility.trace('G Enc Lines: ' || g_enc_lines_counter);
3315: hr_utility.trace('Enc Lines: ' || t_enc_lines_array.r_time_period_id.COUNT);
3316: l_time_period_id := -1;
3317: IF ((g_enc_lines_counter - l_prev_enc_lines_counter) > 0) THEN
3310: orig_ci.expenditure_organization_id.DELETE;
3311: orig_ci.expenditure_type.DELETE;
3312:
3313: hr_utility.trace('Prev Enc Lines: ' || l_prev_enc_lines_counter);
3314: hr_utility.trace('G Enc Lines: ' || g_enc_lines_counter);
3315: hr_utility.trace('Enc Lines: ' || t_enc_lines_array.r_time_period_id.COUNT);
3316: l_time_period_id := -1;
3317: IF ((g_enc_lines_counter - l_prev_enc_lines_counter) > 0) THEN
3318: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
3311: orig_ci.expenditure_type.DELETE;
3312:
3313: hr_utility.trace('Prev Enc Lines: ' || l_prev_enc_lines_counter);
3314: hr_utility.trace('G Enc Lines: ' || g_enc_lines_counter);
3315: hr_utility.trace('Enc Lines: ' || t_enc_lines_array.r_time_period_id.COUNT);
3316: l_time_period_id := -1;
3317: IF ((g_enc_lines_counter - l_prev_enc_lines_counter) > 0) THEN
3318: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
3319: LOOP
3329: l_proc_step := 100 + (recno2 / 100000);
3330: IF (t_enc_lines_array.r_time_period_id(recno2) = l_time_period_id) THEN
3331: l_running_total := l_running_total + t_enc_lines_array.r_encumbrance_amount(recno2);
3332: l_chunk_pointer := recno2;
3333: hr_utility.trace('Encumbrance Amount: ' || t_enc_lines_array.r_encumbrance_amount(recno2));
3334: END IF;
3335: END LOOP;
3336:
3337: IF (l_running_total > 0) AND (l_running_total <> r_enc_period.r_period_amount(recno)) THEN
3339: t_enc_lines_array.r_encumbrance_amount(l_chunk_pointer) +
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;
3360: r_enc_period.r_period_amount.DELETE;
3361: r_enc_period.r_reason_code.DELETE;
3362:
3363: l_proc_step := 210;
3364: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3365: EXCEPTION
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;
4284: BEGIN
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) ||
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));
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, ' ') || ' ' ||
4298: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
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, ' ') || ' ' ||
4298: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4299: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
4298: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4299: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
4300: RPAD('Reason Code', 50, ' '));
4301:
4302: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
4303: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
4304: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
4305: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
4306: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
4307: RPAD('-', 50, '-'));
4308:
4309: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
4310: LOOP
4311: hr_utility.trace(LPAD(recno, 13, ' ') || ' ' ||
4312: LPAD(r_enc_period.r_time_period_id(recno), 14, ' ') || ' ' ||
4313: RPAD(TO_CHAR(r_enc_period.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
4314: RPAD(TO_CHAR(r_enc_period.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4315: RPAD(TO_CHAR(r_enc_period.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
4318: RPAD(r_enc_period.r_process_flag(recno), 12, ' ') || ' ' ||
4319: LPAD(r_enc_period.r_schedule_percent(recno), 16, ' ') || ' ' ||
4320: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
4321: END LOOP;
4322: hr_utility.trace('Global Element Processing');
4323:
4324: l_proc_step := 10;
4325: l_sch_pointer := 1;
4326:
4327: OPEN global_element_cur;
4328: FETCH global_element_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
4329: CLOSE global_element_cur;
4330:
4331: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4332: hr_utility.trace('Schedule Chunk Details');
4333: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4334: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4335:
4328: FETCH global_element_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
4329: CLOSE global_element_cur;
4330:
4331: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4332: hr_utility.trace('Schedule Chunk Details');
4333: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4334: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4335:
4336: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4329: CLOSE global_element_cur;
4330:
4331: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4332: hr_utility.trace('Schedule Chunk Details');
4333: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4334: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4335:
4336: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4337: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4332: hr_utility.trace('Schedule Chunk Details');
4333: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4334: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4335:
4336: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4337: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4338:
4339: FOR recno IN 1..r_sch_rec.start_date.COUNT
4340: LOOP
4337: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4338:
4339: FOR recno IN 1..r_sch_rec.start_date.COUNT
4340: LOOP
4341: hr_utility.trace(RPAD(TO_CHAR(r_sch_rec.start_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4342: RPAD(TO_CHAR(r_sch_rec.end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4343: LPAD(r_sch_rec.schedule_percent(recno), 16, ' '));
4344: END LOOP;
4345:
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) ||
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));
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;
4563: r_enc_period.r_effective_date.DELETE;
4564: l_rec_no := 1;
4565: l_proc_step := 40;
4566:
4567: hr_utility.trace('Dumping Assignment Chunk After Global Element Processing ...');
4568: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4569: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
4570: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
4571: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4564: l_rec_no := 1;
4565: l_proc_step := 40;
4566:
4567: hr_utility.trace('Dumping Assignment Chunk After Global Element Processing ...');
4568: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4569: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
4570: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
4571: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4572: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
4571: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4572: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
4573: RPAD('Reason Code', 50, ' '));
4574:
4575: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
4576: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
4577: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
4578: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
4579: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
4580: RPAD('-', 50, '-'));
4581:
4582: FOR recno IN 1..r_enc_period_tmp1.r_time_period_id.COUNT
4583: LOOP
4584: hr_utility.trace(LPAD(recno, 13, ' ') || ' ' ||
4585: LPAD(r_enc_period_tmp1.r_time_period_id(recno), 14, ' ') || ' ' ||
4586: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
4587: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4588: RPAD(TO_CHAR(r_enc_period_tmp1.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
4591: RPAD(r_enc_period_tmp1.r_process_flag(recno), 12, ' ') || ' ' ||
4592: LPAD(r_enc_period_tmp1.r_schedule_percent(recno), 16, ' ') || ' ' ||
4593: RPAD(r_enc_period_tmp1.r_reason_code(recno), 50, ' '));
4594: END LOOP;
4595: hr_utility.trace('Element Type Processing ...');
4596:
4597: OPEN ls_hier_cur('ET');
4598: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
4599: CLOSE ls_hier_cur;
4726: OPEN ls_matrix_cur;
4727: FETCH ls_matrix_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
4728: CLOSE ls_matrix_cur;
4729:
4730: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4731: hr_utility.trace('Schedule Chunk Details');
4732: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4733: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4734: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4727: FETCH ls_matrix_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
4728: CLOSE ls_matrix_cur;
4729:
4730: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4731: hr_utility.trace('Schedule Chunk Details');
4732: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4733: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4734: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4735: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4728: CLOSE ls_matrix_cur;
4729:
4730: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4731: hr_utility.trace('Schedule Chunk Details');
4732: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4733: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4734: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4735: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4736:
4730: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
4731: hr_utility.trace('Schedule Chunk Details');
4732: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
4733: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
4734: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
4735: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4736:
4737: FOR recno IN 1..r_sch_rec.start_date.COUNT
4738: LOOP
4735: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
4736:
4737: FOR recno IN 1..r_sch_rec.start_date.COUNT
4738: LOOP
4739: hr_utility.trace(RPAD(TO_CHAR(r_sch_rec.start_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4740: RPAD(TO_CHAR(r_sch_rec.end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4741: LPAD(r_sch_rec.schedule_percent(recno), 16, ' '));
4742: END LOOP;
4743:
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) ||
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));
4961: r_enc_period_tmp1.r_effective_date.DELETE;
4962: l_rec_no := 1;
4963: l_proc_step := 70;
4964:
4965: hr_utility.trace('Dumping Assignment Chunk After Element Type Processing ...');
4966: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4967: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
4968: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
4969: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4962: l_rec_no := 1;
4963: l_proc_step := 70;
4964:
4965: hr_utility.trace('Dumping Assignment Chunk After Element Type Processing ...');
4966: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
4967: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
4968: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
4969: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4970: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
4968: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
4969: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
4970: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
4971: RPAD('Reason Code', 50, ' '));
4972: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
4973: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
4974: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
4975: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
4976: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
4977: RPAD('-', 50, '-'));
4978:
4979: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
4980: LOOP
4981: hr_utility.trace(LPAD(r_enc_period.r_period_ind(recno), 13, ' ') || ' ' ||
4982: LPAD(r_enc_period.r_time_period_id(recno), 14, ' ') || ' ' ||
4983: RPAD(TO_CHAR(r_enc_period.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
4984: RPAD(TO_CHAR(r_enc_period.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
4985: RPAD(TO_CHAR(r_enc_period.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
4988: RPAD(r_enc_period.r_process_flag(recno), 12, ' ') || ' ' ||
4989: LPAD(r_enc_period.r_schedule_percent(recno), 16, ' ') || ' ' ||
4990: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
4991: END LOOP;
4992: hr_utility.trace('Element Group Processing ...');
4993:
4994: psp_matrix_driver_pkg.clear_table('REFRESH');
4995: psp_matrix_driver_pkg.purge_table;
4996: l_period_count := r_enc_period.r_time_period_id.COUNT;
5127: OPEN eg_matrix_cur;
5128: FETCH eg_matrix_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5129: CLOSE eg_matrix_cur;
5130:
5131: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5132: hr_utility.trace('Schedule Chunk Details');
5133: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5134: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5135: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5128: FETCH eg_matrix_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5129: CLOSE eg_matrix_cur;
5130:
5131: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5132: hr_utility.trace('Schedule Chunk Details');
5133: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5134: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5135: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5136: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5129: CLOSE eg_matrix_cur;
5130:
5131: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5132: hr_utility.trace('Schedule Chunk Details');
5133: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5134: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5135: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5136: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5137:
5131: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5132: hr_utility.trace('Schedule Chunk Details');
5133: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5134: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5135: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5136: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5137:
5138: FOR recno IN 1..r_sch_rec.start_date.COUNT
5139: LOOP
5136: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5137:
5138: FOR recno IN 1..r_sch_rec.start_date.COUNT
5139: LOOP
5140: hr_utility.trace(RPAD(TO_CHAR(r_sch_rec.start_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5141: RPAD(TO_CHAR(r_sch_rec.end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5142: LPAD(r_sch_rec.schedule_percent(recno), 16, ' '));
5143: END LOOP;
5144:
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) ||
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));
5359: r_enc_period.r_effective_date.DELETE;
5360: l_rec_no := 1;
5361: l_proc_step := 100;
5362:
5363: hr_utility.trace('Dumping Assignment Chunk After Element Group Processing ...');
5364: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5365: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
5366: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
5367: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
5360: l_rec_no := 1;
5361: l_proc_step := 100;
5362:
5363: hr_utility.trace('Dumping Assignment Chunk After Element Group Processing ...');
5364: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5365: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
5366: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
5367: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
5368: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
5366: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
5367: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
5368: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
5369: RPAD('Reason Code', 50, ' '));
5370: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
5371: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
5372: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
5373: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
5374: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
5375: RPAD('-', 50, '-'));
5376:
5377: FOR recno IN 1..r_enc_period_tmp1.r_time_period_id.COUNT
5378: LOOP
5379: hr_utility.trace(LPAD(r_enc_period_tmp1.r_period_ind(recno), 13, ' ') || ' ' ||
5380: LPAD(r_enc_period_tmp1.r_time_period_id(recno), 14, ' ') || ' ' ||
5381: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
5382: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5383: RPAD(TO_CHAR(r_enc_period_tmp1.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
5386: RPAD(r_enc_period_tmp1.r_process_flag(recno), 12, ' ') || ' ' ||
5387: LPAD(r_enc_period_tmp1.r_schedule_percent(recno), 16, ' ') || ' ' ||
5388: RPAD(r_enc_period_tmp1.r_reason_code(recno), 50, ' '));
5389: END LOOP;
5390: hr_utility.trace('Assignment Processing ...');
5391:
5392: psp_matrix_driver_pkg.clear_table('REFRESH');
5393: psp_matrix_driver_pkg.purge_table;
5394: l_period_count := r_enc_period.r_time_period_id.COUNT;
5523: OPEN ls_matrix_cur;
5524: FETCH ls_matrix_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5525: CLOSE ls_matrix_cur;
5526:
5527: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5528: hr_utility.trace('Schedule Chunk Details');
5529: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5530: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5531:
5524: FETCH ls_matrix_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5525: CLOSE ls_matrix_cur;
5526:
5527: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5528: hr_utility.trace('Schedule Chunk Details');
5529: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5530: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5531:
5532: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5525: CLOSE ls_matrix_cur;
5526:
5527: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5528: hr_utility.trace('Schedule Chunk Details');
5529: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5530: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5531:
5532: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5533: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5528: hr_utility.trace('Schedule Chunk Details');
5529: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5530: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5531:
5532: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5533: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5534:
5535: FOR recno IN 1..r_sch_rec.start_date.COUNT
5536: LOOP
5533: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5534:
5535: FOR recno IN 1..r_sch_rec.start_date.COUNT
5536: LOOP
5537: hr_utility.trace(RPAD(TO_CHAR(r_sch_rec.start_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5538: RPAD(TO_CHAR(r_sch_rec.end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5539: LPAD(r_sch_rec.schedule_percent(recno), 16, ' '));
5540: END LOOP;
5541:
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) ||
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));
5761:
5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5764:
5765: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5766: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5767: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
5768: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
5769: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5764:
5765: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5766: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5767: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
5768: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
5769: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
5770: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
5768: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
5769: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
5770: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
5771: RPAD('Reason Code', 50, ' '));
5772: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
5773: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
5774: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
5775: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
5776: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
5777: RPAD('-', 50, '-'));
5778:
5779: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
5780: LOOP
5781: hr_utility.trace(LPAD(r_enc_period.r_period_ind(recno), 13, ' ') || ' ' ||
5782: LPAD(r_enc_period.r_time_period_id(recno), 14, ' ') || ' ' ||
5783: RPAD(TO_CHAR(r_enc_period.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
5784: RPAD(TO_CHAR(r_enc_period.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5785: RPAD(TO_CHAR(r_enc_period.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
5790: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
5791: END LOOP;
5792:
5793: IF (g_org_def_labor_schedule = 'Y') THEN
5794: hr_utility.trace('Organization Default LS Processing');
5795:
5796: l_sch_pointer := 1;
5797: OPEN odls_cur;
5798: FETCH odls_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5797: OPEN odls_cur;
5798: FETCH odls_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5799: CLOSE odls_cur;
5800:
5801: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5802: hr_utility.trace('Schedule Chunk Details');
5803: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5804: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5805: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5798: FETCH odls_cur BULK COLLECT INTO r_sch_rec.start_date, r_sch_rec.end_date, r_sch_rec.schedule_percent;
5799: CLOSE odls_cur;
5800:
5801: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5802: hr_utility.trace('Schedule Chunk Details');
5803: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5804: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5805: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5806: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5799: CLOSE odls_cur;
5800:
5801: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5802: hr_utility.trace('Schedule Chunk Details');
5803: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5804: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5805: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5806: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5807:
5801: hr_utility.trace('r_sch_rec.start_date.COUNT: ' || r_sch_rec.start_date.COUNT);
5802: hr_utility.trace('Schedule Chunk Details');
5803: hr_utility.trace(RPAD('Start Date', 15, ' ') || ' ' ||
5804: RPAD('End Date', 15, ' ') || ' ' || LPAD('Schedule Percent', 16, ' '));
5805: hr_utility.trace(RPAD('-', 15, '-') || ' ' ||
5806: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5807:
5808: FOR recno IN 1..r_sch_rec.start_date.COUNT
5809: LOOP
5806: RPAD('-', 15, '-') || ' ' || RPAD('-', 16, '-'));
5807:
5808: FOR recno IN 1..r_sch_rec.start_date.COUNT
5809: LOOP
5810: hr_utility.trace(RPAD(TO_CHAR(r_sch_rec.start_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5811: RPAD(TO_CHAR(r_sch_rec.end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
5812: LPAD(r_sch_rec.schedule_percent(recno), 16, ' '));
5813: END LOOP;
5814:
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) ||
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));
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);
6044: r_enc_period.r_effective_date.DELETE;
6045: l_rec_no := 1;
6046: l_proc_step := 170;
6047:
6048: hr_utility.trace('Dumping Assignment Chunk After Organization Default Schedules Processing ...');
6049: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
6050: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
6051: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6052: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6045: l_rec_no := 1;
6046: l_proc_step := 170;
6047:
6048: hr_utility.trace('Dumping Assignment Chunk After Organization Default Schedules Processing ...');
6049: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
6050: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
6051: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6052: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6053: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
6051: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6052: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6053: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
6054: RPAD('Reason Code', 50, ' '));
6055: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
6056: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
6057: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
6058: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
6059: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
6060: RPAD('-', 50, '-'));
6061:
6062: FOR recno IN 1..r_enc_period_tmp1.r_time_period_id.COUNT
6063: LOOP
6064: hr_utility.trace(LPAD(r_enc_period_tmp1.r_period_ind(recno), 13, ' ') || ' ' ||
6065: LPAD(r_enc_period_tmp1.r_time_period_id(recno), 14, ' ') || ' ' ||
6066: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
6067: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
6068: RPAD(TO_CHAR(r_enc_period_tmp1.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
6088: END LOOP;
6089: END IF;
6090:
6091: IF (g_org_def_account = 'Y') THEN
6092: hr_utility.trace('Organization Default Account Processing');
6093:
6094: l_sch_pointer := 1;
6095: FOR I IN 1..r_enc_period.r_time_period_id.COUNT
6096: LOOP
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) ||
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));
6274: r_enc_period_tmp1.r_reason_code(l_rec_no) := r_enc_period.r_reason_code(I);
6275: l_rec_no := l_rec_no + 1;
6276: END IF;
6277: END LOOP;
6278: hr_utility.trace('Dumping Assignment Chunk After Organization Default Account Processing ...');
6279: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
6280: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
6281: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6282: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6275: l_rec_no := l_rec_no + 1;
6276: END IF;
6277: END LOOP;
6278: hr_utility.trace('Dumping Assignment Chunk After Organization Default Account Processing ...');
6279: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
6280: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
6281: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6282: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6283: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
6281: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6282: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6283: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
6284: RPAD('Reason Code', 50, ' '));
6285: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
6286: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
6287: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
6288: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
6289: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
6290: RPAD('-', 50, '-'));
6291:
6292: FOR recno IN 1..r_enc_period_tmp1.r_time_period_id.COUNT
6293: LOOP
6294: hr_utility.trace(LPAD(r_enc_period_tmp1.r_period_ind(recno), 13, ' ') || ' ' ||
6295: LPAD(r_enc_period_tmp1.r_time_period_id(recno), 14, ' ') || ' ' ||
6296: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
6297: RPAD(TO_CHAR(r_enc_period_tmp1.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
6298: RPAD(TO_CHAR(r_enc_period_tmp1.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
6333:
6334: l_rec_no := 1;
6335: l_proc_step := 200;
6336:
6337: hr_utility.trace('Organization Suspense Account Processing');
6338:
6339: l_sch_pointer := 1;
6340: FOR I IN 1..r_enc_period_tmp1.r_time_period_id.COUNT
6341: LOOP
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) ||
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));
6537: r_enc_period_tmp1.r_reason_code.DELETE;
6538: r_enc_period_tmp1.r_effective_date.DELETE;
6539: l_proc_step := 230;
6540:
6541: hr_utility.trace('Dumping Assignment Chunk After Suspense Account Processing ...');
6542: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
6543: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
6544: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6545: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6538: r_enc_period_tmp1.r_effective_date.DELETE;
6539: l_proc_step := 230;
6540:
6541: hr_utility.trace('Dumping Assignment Chunk After Suspense Account Processing ...');
6542: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
6543: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||
6544: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6545: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6546: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
6544: RPAD('Period End Date', 15, ' ') || ' ' || RPAD('Asg Start Date', 14, ' ') || ' ' ||
6545: RPAD('Asg End Date', 12, ' ') || ' ' || RPAD('Effective Date', 14, ' ') || ' ' ||
6546: RPAD('Process Flag', 12, ' ') || ' ' || LPAD('Schedule Percent', 16, ' ') || ' ' ||
6547: RPAD('Reason Code', 50, ' '));
6548: hr_utility.trace(LPAD('-', 13, '-') || ' ' ||
6549: LPAD('-', 14, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
6550: RPAD('-', 15, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
6551: RPAD('-', 12, '-') || ' ' || RPAD('-', 14, '-') || ' ' ||
6552: RPAD('-', 12, '-') || ' ' || LPAD('-', 16, '-') || ' ' ||
6553: RPAD('-', 50, '-'));
6554:
6555: FOR recno IN 1..r_enc_period.r_time_period_id.COUNT
6556: LOOP
6557: hr_utility.trace(LPAD(r_enc_period.r_period_ind(recno), 13, ' ') || ' ' ||
6558: LPAD(r_enc_period.r_time_period_id(recno), 14, ' ') || ' ' ||
6559: RPAD(TO_CHAR(r_enc_period.r_period_start_date(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
6560: RPAD(TO_CHAR(r_enc_period.r_period_end_date(recno), 'DD-MON-RRRR'), 15, ' ') || ' ' ||
6561: RPAD(TO_CHAR(r_enc_period.r_asg_start_date(recno), 'DD-MON-RRRR'), 14, ' ') || ' ' ||
6565: LPAD(r_enc_period.r_schedule_percent(recno), 16, ' ') || ' ' ||
6566: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
6567: r_enc_period.r_encumbrance_amount(recno) := 0;
6568: END LOOP;
6569: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6570:
6571: p_return_status := fnd_api.g_ret_sts_success;
6572: EXCEPTION
6573: WHEN OTHERS THEN
6600:
6601: PROCEDURE cel_init(p_payroll_action_id IN NUMBER) IS
6602: BEGIN
6603: fnd_file.put_line(fnd_file.log,fnd_date.date_to_canonical(SYSDATE) || ' FND :: Initializing the profile option ');
6604: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' HR :: Initializing the profile option ');
6605: g_payroll_mode := NVL(FND_PROFILE.VALUE('PSP_USING_ORACLE_PAYROLL'),'Y'); -- 13566809
6606: -- spc_track_cel('Init', NULL, 'Start');
6607: NULL;
6608: -- spc_track_cel('Init', NULL, 'End');
6639: FROM psp_enc_payrolls pep
6640: WHERE pep.business_group_id = l_business_group_id
6641: AND pep.set_of_books_id = l_set_of_books_id;
6642: BEGIN
6643: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);
6644:
6645: l_last_update_date := SYSDATE;
6646: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
6647: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
6655:
6656: IF (l_payroll_id = -1) THEN
6657: l_payroll_id := NULL;
6658: END IF;
6659: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_payroll_id: ' || l_payroll_id || '
6660: process_mode: ' || l_process_mode);
6661:
6662: l_process_code := 'CEL';
6663: IF (l_process_mode = 'TERMINATE') THEN
6680:
6681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6683: END IF;
6684: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6685: ELSE
6686: OPEN enc_payrolls_cur;
6687: LOOP
6688: FETCH enc_payrolls_cur INTO l_payroll_id;
6691: enc_pre_process(pactid, l_payroll_id, l_process_mode, l_return_status);
6692: IF l_return_status <> fnd_api.g_ret_sts_success THEN
6693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6694: END IF;
6695: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed enc_pre_process for l_payroll_id: ' || l_payroll_id || ' process_mode: ' || l_process_mode);
6696: END LOOP;
6697: CLOSE enc_payrolls_cur;
6698: l_payroll_id := NULL;
6699: END IF;
6729: p_return_status => l_return_status);
6730: RAISE NO_UPDATE_REC_FOUND;
6731: END IF;
6732:
6733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' sqlstr: ' || sqlstr);
6734: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6735: EXCEPTION
6736: WHEN NO_UPDATE_REC_FOUND THEN
6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6730: RAISE NO_UPDATE_REC_FOUND;
6731: END IF;
6732:
6733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' sqlstr: ' || sqlstr);
6734: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6735: EXCEPTION
6736: WHEN NO_UPDATE_REC_FOUND THEN
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);
6757: TYPE t_number_15 IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
6758: t_asg_array t_number_15;
6759: l_asg_action_id NUMBER(15);
6760: BEGIN
6761: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_ASG_ACTION_CODE p_pactid: ' || p_pactid || '
6762: start_asg: ' || start_asg || '
6763: end_asg: ' || end_asg || '
6764: p_chunk_num: ' || p_chunk_num);
6765:
6766: OPEN get_assignments_cur;
6767: FETCH get_assignments_cur BULK COLLECT INTO t_asg_array;
6768: CLOSE get_assignments_cur;
6769:
6770: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_asg_array.COUNT: ' || t_asg_array.COUNT);
6771: FOR recno IN 1..t_asg_array.COUNT
6772: LOOP
6773: SELECT pay_assignment_actions_s.NEXTVAL INTO l_asg_action_id FROM DUAL;
6774: hr_nonrun_asact.insact(l_asg_action_id,
6777: object_id => t_asg_array(recno),
6778: object_type => 'ASG',
6779: p_transient_action => TRUE);
6780: END LOOP;
6781: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ASG_ACTION_CODE payroll_action_id: ' || p_pactid || '
6782: start_asg: ' || start_asg || '
6783: end_asg: ' || end_asg || '
6784: p_chunk_num: ' || p_chunk_num);
6785: END cel_asg_action_code;
7290: l_enc_create := 1;
7291: l_pre_process_mode:= 'R';
7292: g_currency_code := psp_general.get_currency_code(l_business_group_id);
7293: psp_general.get_currency_precision(g_currency_code,g_precision,g_ext_precision);
7294: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_line_type: U
7295: g_request_id: ' || g_request_id || '
7296: g_payroll_action_id: ' || g_payroll_action_id || '
7297: g_currency_code: ' || g_currency_code || '
7298: g_ge_autopop: ' || g_ge_autopop || ' g_et_autopop: ' || g_et_autopop ||
7303: OPEN c_obtain_eff_date_option;
7304: FETCH c_obtain_eff_date_option INTO g_eff_date_value;
7305: CLOSE c_obtain_eff_date_option;
7306:
7307: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_eff_date_value: ' || g_eff_date_value);
7308:
7309: obtain_enc_org_end_date(p_enc_org_end_date => l_enc_org_end_date,
7310: p_business_group_id => l_business_group_id,
7311: p_set_of_books_id => l_set_of_books_id,
7313: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7315: END IF;
7316: g_enc_org_end_date := l_enc_org_end_date ;
7317: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_enc_org_end_date: ' || fnd_date.date_to_canonical(g_enc_org_end_date));
7318:
7319: OPEN get_asg_id_cur;
7320: FETCH get_asg_id_cur INTO l_min_asg_id, l_max_asg_id;
7321: CLOSE get_asg_id_cur;
7318:
7319: OPEN get_asg_id_cur;
7320: FETCH get_asg_id_cur INTO l_min_asg_id, l_max_asg_id;
7321: CLOSE get_asg_id_cur;
7322: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_min_asg_id: ' || l_min_asg_id || ' l_max_asg_id: ' || l_max_asg_id);
7323:
7324: OPEN get_payroll_asg_cur;
7325: FETCH get_payroll_asg_cur BULK COLLECT INTO t_assignments.payroll_array, t_assignments.asg_array, t_assignments.term_date_array;
7326: CLOSE get_payroll_asg_cur;
7353: OPEN liq_only_asg_cur;
7354: FETCH liq_only_asg_cur INTO l_liq_only_count;
7355: CLOSE liq_only_asg_cur;
7356:
7357: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_liq_only_count: '||l_liq_only_count);
7358:
7359: OPEN liq_all_cur;
7360: FETCH liq_all_cur INTO l_liq_all_count;
7361: CLOSE liq_all_cur;
7359: OPEN liq_all_cur;
7360: FETCH liq_all_cur INTO l_liq_all_count;
7361: CLOSE liq_all_cur;
7362:
7363: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_liq_all_count: '||l_liq_all_count);
7364:
7365: IF ((l_liq_all_count =0) AND (l_liq_only_count > 0)) THEN
7366: delete_previous_error_log(p_assignment_id => l_assignment_id,
7367: p_payroll_id => l_payroll_id,
7376: IF g_payroll_mode = 'N' THEN
7377:
7378: -- 13566809 : For OTHER payroll we are using the same old cursor c_last_pay_run.
7379:
7380: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_payroll_mode : N ');
7381:
7382: OPEN c_last_pay_run(t_assignments.asg_array(recno));
7383: FETCH c_last_pay_run INTO l_enc_begin_date;
7384: CLOSE c_last_pay_run;
7390: So therefore in this process at this place earlier the query C_LAST_PAY_RUN cursor was used and this has outer join.
7391: But now when calling GET_ASG_PAY_END_DATE function, this uses cursor query ORACLE_PAYROLL_ASG_END_DATE which does not
7392: have outer join and this is a common query which is already used in CEL_RANGE_CODE */
7393:
7394: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_payroll_mode : Y ');
7395:
7396: l_enc_begin_date := get_asg_pay_end_date(NULL,p_payroll_action_id,l_assignment_id,l_business_group_id,l_payroll_id); --13566809
7397:
7398: END IF;
7396: l_enc_begin_date := get_asg_pay_end_date(NULL,p_payroll_action_id,l_assignment_id,l_business_group_id,l_payroll_id); --13566809
7397:
7398: END IF;
7399:
7400: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_enc_begin_date 1 '||l_enc_begin_date);
7401:
7402:
7403: IF l_enc_begin_date IS NULL THEN
7404: OPEN c_tp_start_date;
7406: CLOSE c_tp_start_date;
7407: END IF;
7408:
7409: -- END IF;
7410: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_enc_begin_date 2 '||l_enc_begin_date);
7411:
7412:
7413: OPEN earnings_element_cur(l_assignment_id);
7414: LOOP
7434:
7435: IF l_enc_create = 0 AND l_enc_create_lines = 0 THEN
7436: l_enc_create :=1;
7437: END IF;
7438: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_actual_term_date: ' || fnd_date.date_to_canonical(g_actual_term_date) || '
7439: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7440: l_enc_create: ' || l_enc_create);
7441:
7442: IF l_enc_create > 0 THEN
7439: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7440: l_enc_create: ' || l_enc_create);
7441:
7442: IF l_enc_create > 0 THEN
7443: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' p_chunk_number: ' || p_chunk_number || '
7444: p_assignment_id => ' || l_assignment_id || '
7445: p_payroll_id => ' || l_payroll_id || '
7446: p_element_type_id => ' || l_element_type_id || '
7447: p_business_group_id => ' || l_business_group_id || '
7483:
7484: IF l_enc_create = 0 AND l_enc_create_lines = 0 THEN
7485: l_enc_create :=1;
7486: END IF;
7487: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_actual_term_date: ' || fnd_date.date_to_canonical(g_actual_term_date) || '
7488: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7489: l_enc_create: ' || l_enc_create);
7490:
7491: IF l_enc_create > 0 THEN
7488: l_max_enc_date: ' || fnd_date.date_to_canonical(l_max_enc_date) || '
7489: l_enc_create: ' || l_enc_create);
7490:
7491: IF l_enc_create > 0 THEN
7492: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' p_chunk_number: ' || p_chunk_number || '
7493: p_assignment_id => ' || l_assignment_id || '
7494: p_payroll_id => ' || l_payroll_id || '
7495: p_element_type_id => ' || l_element_type_id || '
7496: p_business_group_id => ' || l_business_group_id || '
7520: fnd_file.put_line(fnd_file.log, 'No element found for encumbrance.');
7521: END IF;
7522: CLOSE earnings_element_cur;
7523:
7524: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_enc_lines_array.r_enc_element_type_id.COUNT: ' || t_enc_lines_array.r_enc_element_type_id.COUNT);
7525: verify_changes(p_payroll_id => l_payroll_id,
7526: p_assignment_id => l_assignment_id,
7527: p_business_group_id => l_business_group_id,
7528: p_set_of_books_id => l_set_of_books_id,
7531:
7532: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7533: RAISE fnd_api.g_exc_unexpected_error;
7534: END IF;
7535: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed verify_changes for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7536: ELSE
7537: IF (l_liq_all_count > 0) THEN
7538: UPDATE psp_enc_lines_history pelh
7539: SET change_flag = 'N'
7545: WHERE pesl.assignment_id = l_assignment_id
7546: AND pesl.payroll_id = l_payroll_id
7547: AND status_code = 'A'
7548: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id);
7549: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated');
7550: DELETE psp_enc_changed_assignments
7551: WHERE assignment_id = l_assignment_id
7552: AND payroll_id = l_payroll_id
7553: AND change_type = 'ZZ';
7566: AND pesl.effective_date <= (NVL((get_payroll_pay_end_date(l_payroll_id)
7567: -- and ptp.time_period_id = ppa.time_period_id -- Added for 11661463 -- Commented for the Bug 12647364
7568: ),l_enc_begin_date)) );
7569:
7570: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated by regular liquidation');
7571: UPDATE psp_enc_lines_history pelh
7572: SET change_flag = 'U'
7573: WHERE assignment_id = l_assignment_id
7574: AND payroll_id = l_payroll_id
7582: AND pesl.effective_date > (NVL((get_payroll_pay_end_date(l_payroll_id)
7583: -- and ptp.time_period_id = ppa.time_period_id -- Added for 11661463 -- Commented for the Bug 12647364
7584: ),l_enc_begin_date)) );
7585:
7586: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines not to be liquidated by regular liquidation');
7587: END IF;
7588: END IF;
7589:
7590: create_liq_lines (p_payroll_action_id => p_payroll_action_id,
7597:
7598: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7599: RAISE fnd_api.g_exc_unexpected_error;
7600: END IF;
7601: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_liq_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7602:
7603: create_sum_lines (p_payroll_action_id => p_payroll_action_id,
7604: p_payroll_id => l_payroll_id,
7605: p_assignment_id => l_assignment_id,
7609:
7610: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7611: RAISE fnd_api.g_exc_unexpected_error;
7612: END IF;
7613: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed create_sum_lines for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7614:
7615: update_hierarchy_dates (p_payroll_action_id => p_payroll_action_id,
7616: p_payroll_id => l_payroll_id,
7617: p_assignment_id => l_assignment_id,
7964: DELETE FROM psp_asg_end_dates
7965: WHERE payroll_action_id = p_payroll_action_id;
7966:
7967: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting data from the temporary dummy table'||sql%rowcount);
7968: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE)|| ' Deleting data from the temporary dummy table'||sql%rowcount);
7969: IF (l_process_mode = 'TERMINATE') THEN
7970: OPEN st_count_cur;
7971: FETCH st_count_cur INTO l_st_count;
7972: CLOSE st_count_cur;
8127: l_enc_lines_no NUMBER(15);
8128: l_delete_flag CHAR(1);
8129: l_return_status VARCHAR2(1);
8130: BEGIN
8131: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering verify_changes
8132: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
8133: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
8134: p_enc_line_type: ' || p_enc_line_type);
8135:
8200: OPEN modified_summary_lines_cur;
8201: FETCH modified_summary_lines_cur BULK COLLECT INTO l_enc_summary_line_id_tl;
8202: CLOSE modified_summary_lines_cur;
8203:
8204: hr_utility.trace('l_enc_summary_line_id_tl.COUNT: ' || l_enc_summary_line_id_tl.COUNT);
8205:
8206: FORALL recno IN 1..l_enc_summary_line_id_tl.COUNT
8207: UPDATE psp_enc_lines_history pelh
8208: SET change_flag='N'
8431: t_enc_lines_array.r_hierarchy_code.DELETE;
8432: t_enc_lines_array.r_hierarchy_start_date.DELETE;
8433: t_enc_lines_array.r_hierarchy_end_date.DELETE;
8434:
8435: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' t_enc_lines_array2.r_enc_element_type_id.COUNT: ' || t_enc_lines_array2.r_enc_element_type_id.COUNT);
8436:
8437: --IF (t_enc_lines_array2.r_enc_element_type_id.COUNT = 0) THEN
8438: --delete_previous_error_log(p_assignment_id => p_assignment_id,
8439: --p_payroll_id => p_payroll_id,
8449: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8450: RAISE fnd_api.g_exc_unexpected_error;
8451: END IF;
8452:
8453: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving verify_changes
8454: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
8455: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
8456: p_enc_line_type: ' || p_enc_line_type);
8457: l_retcode := FND_API.G_RET_STS_SUCCESS;
8548: FROM psp_enc_lines_history pelh
8549: WHERE pelh.change_flag = 'N'
8550: AND pelh.assignment_id = p_assignment_id
8551: AND pelh.payroll_id = p_payroll_id);
8552: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of liquidation lines created: ' || SQL%ROWCOUNT);
8553:
8554: p_return_status := fnd_api.g_ret_sts_success;
8555: EXCEPTION
8556: WHEN OTHERS THEN
8719: g_actual_term_date, SYSDATE,
8720: l_last_updated_by, l_last_update_login,
8721: l_last_updated_by, SYSDATE,
8722: t_sum_lines.org_id(recno));
8723: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of Summary lines created (t_sum_lines.enc_control_id.COUNT): ' || t_sum_lines.enc_control_id.COUNT);
8724:
8725: IF (g_dff_grouping_option = 'Y') THEN
8726: FORALL recno IN 1..t_sum_lines.enc_summary_line_id.COUNT
8727: UPDATE psp_enc_lines pel
8989:
8990: l_request_id := FND_GLOBAL. CONC_REQUEST_ID;
8991: l_set_of_books_id := FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
8992: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
8993: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_request_id: ' || l_request_id ||'
8994: l_set_of_books_id: ' || l_set_of_books_id || '
8995: l_business_group_id: ' || l_business_group_id);
8996:
8997: IF (p_process_mode = 'REGULAR') THEN
9007: OPEN c_tp_start_date;
9008: FETCH c_tp_start_date INTO l_enc_begin_date;
9009: CLOSE c_tp_start_date;
9010: END IF;
9011: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_enc_begin_date: ' || fnd_date.date_to_canonical(l_enc_begin_date));
9012:
9013: l_pre_process_mode := 'R';
9014: IF (l_new_cust = 0 AND psp_general.start_capturing_updates(l_business_group_id) = 'N') THEN
9015: l_pre_process_mode := 'F';
9023: p_return_status => l_return_status);
9024: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9026: END IF;
9027: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.poeta_pre_process');
9028:
9029: IF (l_pre_process_mode <>'F') THEN
9030: psp_enc_pre_process.labor_schedule_pre_process
9031: (p_enc_line_type => 'U',
9034:
9035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9037: END IF;
9038: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed psp_enc_pre_process.labor_schedule_pre_process');
9039: END IF;
9040:
9041: OPEN enc_payroll_cur;
9042: FETCH enc_payroll_cur INTO l_inc_exc_flag;
9040:
9041: OPEN enc_payroll_cur;
9042: FETCH enc_payroll_cur INTO l_inc_exc_flag;
9043: CLOSE enc_payroll_cur;
9044: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_inc_exc_flag: ' || l_inc_exc_flag);
9045:
9046: -- Bug 7188209
9047: -- Bug 10058104
9048: select prev_enc_end_date into l_prev_enc_end_date
9049: from PSP_ENC_END_DATES_V
9050: where business_group_id = l_business_group_id
9051: and set_of_books_id = l_set_of_books_id
9052: and default_org_flag='Y';
9053: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_prev_enc_end_date = ' || l_prev_enc_end_date);
9054:
9055: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Oracle Payroll Profile Value: '||FND_PROFILE.VALUE('PSP_USING_ORACLE_PAYROLL'));
9056:
9057: -- The following profile check is introduced and the insert statements are duplicated
9101: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9102: ),l_enc_begin_date))
9103: AND pesl.payroll_id = p_payroll_id);
9104:
9105: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9106:
9107:
9108: -- Added this INSERT for bug 7188209
9109:
9137: AND pesl.status_code IN ('A', 'N')
9138: AND pesl.effective_date > l_prev_enc_end_date
9139: AND pesl.payroll_id = p_payroll_id);
9140:
9141: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9142:
9143: INSERT INTO psp_enc_changed_assignments
9144: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9145: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9172: WHERE pesl.assignment_id = pa.assignment_id
9173: AND pesl.status_code = 'N'
9174: AND pesl.payroll_id = p_payroll_id);
9175:
9176: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9177:
9178: ELSE
9179: -- Modified the following statement for bug 9862281
9180: INSERT INTO psp_enc_changed_assignments
9212: ),l_enc_begin_date)) );
9213:
9214:
9215:
9216: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9217:
9218: -- Added for bug 7188209
9219: INSERT INTO psp_enc_changed_assignments
9220: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9240: WHERE pesl.assignment_id = pa.assignment_id
9241: AND pesl.status_code IN ('A', 'N')
9242: AND pesl.effective_date > l_prev_enc_end_date);
9243:
9244: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9245:
9246: INSERT INTO psp_enc_changed_assignments
9247: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9248: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9274: FROM psp_enc_summary_lines pesl
9275: WHERE pesl.assignment_id = pa.assignment_id
9276: AND pesl.status_code = 'N'
9277: AND pesl.payroll_id = p_payroll_id);
9278: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9279: END IF;
9280:
9281: INSERT INTO psp_enc_changed_assignments
9282: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9302: AND pesl2.effective_date <= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pesl2.assignment_id,pesl2.business_group_id,pesl2.payroll_id) --13566809
9303: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9304: ),l_enc_begin_date))
9305: AND pesl2.payroll_id = p_payroll_id);
9306: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9307:
9308: ELSE -- NOn-Oracle Payroll profile is set to YES (For Stanford type of customers)
9309: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Non-Oracle Payroll');
9310:
9347: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9348: ),l_enc_begin_date)) --13566809
9349: AND pesl.payroll_id = p_payroll_id);
9350:
9351: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9352:
9353: -- Added this INSERT for bug 7188209
9354:
9355: INSERT INTO psp_enc_changed_assignments
9382: AND pesl.status_code IN ('A', 'N')
9383: AND pesl.effective_date > l_prev_enc_end_date
9384: AND pesl.payroll_id = p_payroll_id);
9385:
9386: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9387:
9388: INSERT INTO psp_enc_changed_assignments
9389: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9390: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9417: WHERE pesl.assignment_id = pa.assignment_id
9418: AND pesl.status_code = 'N'
9419: AND pesl.payroll_id = p_payroll_id);
9420:
9421: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9422:
9423: ELSE
9424: -- Modified the following statement for bug 9862281
9425: INSERT INTO psp_enc_changed_assignments
9473: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date)) );
9474:
9475:
9476:
9477: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9478:
9479: -- Added for bug 7188209
9480: INSERT INTO psp_enc_changed_assignments
9481: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9501: WHERE pesl.assignment_id = pa.assignment_id
9502: AND pesl.status_code IN ('A', 'N')
9503: AND pesl.effective_date > l_prev_enc_end_date);
9504:
9505: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9506:
9507: INSERT INTO psp_enc_changed_assignments
9508: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9509: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9535: FROM psp_enc_summary_lines pesl
9536: WHERE pesl.assignment_id = pa.assignment_id
9537: AND pesl.status_code = 'N'
9538: AND pesl.payroll_id = p_payroll_id);
9539: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9540: END IF;
9541:
9542: INSERT INTO psp_enc_changed_assignments
9543: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9563: AND pesl2.effective_date <= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pesl2.assignment_id,pesl2.business_group_id,pesl2.payroll_id)--13566809
9564: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9565: ),l_enc_begin_date))
9566: AND pesl2.payroll_id = p_payroll_id);
9567: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9568:
9569: END IF; -- End of Oracle Payroll Profile
9570:
9571: UPDATE psp_enc_changed_assignments peca
9576: FROM psp_enc_process_assignments pepa
9577: WHERE pepa.assignment_id = peca.assignment_id
9578: AND pepa.assignment_status NOT IN ('B', 'P')
9579: AND pepa.payroll_id = peca.payroll_id);
9580: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Marked ' || SQL%ROWCOUNT || ' assignments in psp_enc_changed_assignments to be processed by this Create and Update process');
9581:
9582: /*
9583: DELETE FROM psp_enc_changed_assignments
9584: WHERE payroll_action_id = p_payroll_action_id
9624:
9625: CLOSE exc_asg_cur;
9626: END;
9627: -- Modified the delete statement for bug 9862281 end
9628: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted new excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');
9629:
9630: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' opening in_process_asg_cur fpr payroll_id: '||p_payroll_id);
9631:
9632:
9626: END;
9627: -- Modified the delete statement for bug 9862281 end
9628: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted new excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');
9629:
9630: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' opening in_process_asg_cur fpr payroll_id: '||p_payroll_id);
9631:
9632:
9633: OPEN in_process_asg_cur;
9634: LOOP
9634: LOOP
9635: FETCH in_process_asg_cur INTO l_assignment_id, l_payroll_action_id;
9636: EXIT WHEN in_process_asg_cur%NOTFOUND;
9637:
9638: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_assignment_id: '||l_assignment_id ||' l_payroll_action_id: '|| l_payroll_action_id);
9639:
9640: OPEN process_descr_cur;
9641: FETCH process_descr_cur INTO l_process_description;
9642: CLOSE process_descr_cur;
9640: OPEN process_descr_cur;
9641: FETCH process_descr_cur INTO l_process_description;
9642: CLOSE process_descr_cur;
9643:
9644: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_process_description: '||l_process_description);
9645:
9646: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9647: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9648: g_warning_message := fnd_message.get;
9646: fnd_message.set_name('PSP', 'PSP_ENC_ASG_IN_PROCESS');
9647: fnd_message.set_token('PROCESS_DESCRIPTION', l_process_description);
9648: g_warning_message := fnd_message.get;
9649:
9650: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_warning_message: '||g_warning_message);
9651:
9652: OPEN asg_number_cur (l_enc_begin_date);
9653: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9654: CLOSE asg_number_cur;
9652: OPEN asg_number_cur (l_enc_begin_date);
9653: FETCH asg_number_cur INTO l_assignment_number, l_person_id, l_organization_id;
9654: CLOSE asg_number_cur;
9655:
9656: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_assignment_number: '|| l_assignment_number|| ' l_person_id: '||l_person_id|| ' l_organization_id: '||l_organization_id);
9657:
9658: OPEN payroll_name_cur;
9659: FETCH payroll_name_cur INTO l_payroll_name;
9660: CLOSE payroll_name_cur;
9658: OPEN payroll_name_cur;
9659: FETCH payroll_name_cur INTO l_payroll_name;
9660: CLOSE payroll_name_cur;
9661:
9662: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_payroll_name: '||l_payroll_name);
9663:
9664: OPEN person_name_cur (l_enc_begin_date);
9665: FETCH person_name_cur INTO l_full_name;
9666: CLOSE person_name_cur;
9664: OPEN person_name_cur (l_enc_begin_date);
9665: FETCH person_name_cur INTO l_full_name;
9666: CLOSE person_name_cur;
9667:
9668: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_full_name: '||l_full_name);
9669:
9670: OPEN org_name_cur;
9671: FETCH org_name_cur INTO l_organization_name;
9672: CLOSE org_name_cur;
9669:
9670: OPEN org_name_cur;
9671: FETCH org_name_cur INTO l_organization_name;
9672: CLOSE org_name_cur;
9673: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_organization_name: '||l_organization_name);
9674:
9675:
9676: psp_general.add_report_error
9677: (p_request_id => l_request_id,
9686: p_information1 => l_payroll_name,
9687: p_value2 => l_organization_id,
9688: p_information2 => l_organization_name,
9689: p_return_status => l_return_status);
9690: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_return_status: '||l_return_status);
9691:
9692: END LOOP;
9693: CLOSE in_process_asg_cur;
9694: ELSE
9696: FETCH action_parameters_cur INTO l_person_id1, l_termination_date1,
9697: l_person_id2, l_termination_date2, l_person_id3, l_termination_date3,
9698: l_person_id4, l_termination_date4, l_person_id5, l_termination_date5;
9699: CLOSE action_parameters_cur;
9700: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' l_person_id1: ' || l_person_id1 || ' l_termination_date1: ' || fnd_date.date_to_canonical(l_termination_date1) || '
9701: l_person_id2: ' || l_person_id2 || ' l_termination_date2: ' || fnd_date.date_to_canonical(l_termination_date2) || '
9702: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9703: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9704: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9720: AND NOT EXISTS (SELECT 1
9721: FROM psp_enc_summary_lines pesl2
9722: WHERE pesl2.person_id = l_person_id1
9723: AND pesl2.status_code = 'N');
9724: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9725: IF (SQL%ROWCOUNT = 0) THEN
9726: OPEN in_process_term_cur(l_person_id1);
9727: LOOP
9728: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9788: AND NOT EXISTS (SELECT 1
9789: FROM psp_enc_summary_lines pesl2
9790: WHERE pesl2.person_id = l_person_id2
9791: AND pesl2.status_code = 'N');
9792: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9793: IF (SQL%ROWCOUNT = 0) THEN
9794: OPEN in_process_term_cur(l_person_id2);
9795: LOOP
9796: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9857: AND NOT EXISTS (SELECT 1
9858: FROM psp_enc_summary_lines pesl2
9859: WHERE pesl2.person_id = l_person_id3
9860: AND pesl2.status_code = 'N');
9861: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9862: IF (SQL%ROWCOUNT = 0) THEN
9863: OPEN in_process_term_cur(l_person_id3);
9864: LOOP
9865: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9926: AND NOT EXISTS (SELECT 1
9927: FROM psp_enc_summary_lines pesl2
9928: WHERE pesl2.person_id = l_person_id4
9929: AND pesl2.status_code = 'N');
9930: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9931: IF (SQL%ROWCOUNT = 0) THEN
9932: OPEN in_process_term_cur(l_person_id4);
9933: LOOP
9934: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
9995: AND NOT EXISTS (SELECT 1
9996: FROM psp_enc_summary_lines pesl2
9997: WHERE pesl2.person_id = l_person_id5
9998: AND pesl2.status_code = 'N');
9999: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
10000: IF (SQL%ROWCOUNT = 0) THEN
10001: OPEN in_process_term_cur(l_person_id5);
10002: LOOP
10003: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;
10047: END IF;
10048: END IF;
10049:
10050: COMMIT;
10051: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10052: p_payroll_action_id: ' || p_payroll_action_id || '
10053: p_payroll_id: ' || p_payroll_id || '
10054: p_process_mode: ' || p_process_mode);
10055: p_return_status := fnd_api.g_ret_sts_success;
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:
10689: r_gee.attribute5, r_gee.attribute6,
10690: r_gee.attribute7, r_gee.attribute8,
10691: r_gee.attribute9, r_gee.attribute10, r_gee.acct_type;
10692: CLOSE global_element_cur;
10693: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_gee.line_account_id.COUNT: ' || r_gee.line_account_id.COUNT);
10694:
10695: OPEN sch_lines_element_type_cur;
10696: FETCH sch_lines_element_type_cur BULK COLLECT INTO r_et.line_account_id,
10697: r_et.gl_code_combination_id, r_et.project_id,
10705: r_et.attribute5, r_et.attribute6,
10706: r_et.attribute7, r_et.attribute8,
10707: r_et.attribute9, r_et.attribute10, r_et.acct_type;
10708: CLOSE sch_lines_element_type_cur;
10709: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_et.line_account_id.COUNT: ' || r_et.line_account_id.COUNT);
10710:
10711: OPEN sch_lines_element_class_cur;
10712: FETCH sch_lines_element_class_cur BULK COLLECT INTO r_ec.line_account_id,
10713: r_ec.gl_code_combination_id, r_ec.project_id,
10721: r_ec.attribute5, r_ec.attribute6,
10722: r_ec.attribute7, r_ec.attribute8,
10723: r_ec.attribute9, r_ec.attribute10, r_ec.acct_type;
10724: CLOSE sch_lines_element_class_cur;
10725: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_ec.line_account_id.COUNT: ' || r_ec.line_account_id.COUNT);
10726:
10727: OPEN sch_lines_assignment_cur;
10728: FETCH sch_lines_assignment_cur BULK COLLECT INTO r_asg.line_account_id,
10729: r_asg.gl_code_combination_id, r_asg.project_id,
10737: r_asg.attribute5, r_asg.attribute6,
10738: r_asg.attribute7, r_asg.attribute8,
10739: r_asg.attribute9, r_asg.attribute10, r_asg.acct_type;
10740: CLOSE sch_lines_assignment_cur;
10741: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_asg.line_account_id.COUNT: ' || r_asg.line_account_id.COUNT);
10742:
10743: OPEN asg_org_cur;
10744: FETCH asg_org_cur BULK COLLECT INTO r_asg_org.organization_id, r_asg_org.start_date, r_asg_org.end_date;
10745: CLOSE asg_org_cur;
10959: r_gsa.attribute9.DELETE;
10960: r_gsa.attribute10.DELETE;
10961: r_gsa.acct_type.DELETE;
10962: END LOOP;
10963: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_odls.line_account_id.COUNT: ' || r_odls.line_account_id.COUNT);
10964: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_da.line_account_id.COUNT: ' || r_da.line_account_id.COUNT);
10965: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa_tmp.line_account_id.COUNT: ' || r_sa_tmp.line_account_id.COUNT);
10966:
10967: IF (r_sa_tmp.line_account_id.COUNT = 0) THEN
10960: r_gsa.attribute10.DELETE;
10961: r_gsa.acct_type.DELETE;
10962: END LOOP;
10963: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_odls.line_account_id.COUNT: ' || r_odls.line_account_id.COUNT);
10964: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_da.line_account_id.COUNT: ' || r_da.line_account_id.COUNT);
10965: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa_tmp.line_account_id.COUNT: ' || r_sa_tmp.line_account_id.COUNT);
10966:
10967: IF (r_sa_tmp.line_account_id.COUNT = 0) THEN
10968: OPEN generic_suspense_cur;
10961: r_gsa.acct_type.DELETE;
10962: END LOOP;
10963: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_odls.line_account_id.COUNT: ' || r_odls.line_account_id.COUNT);
10964: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_da.line_account_id.COUNT: ' || r_da.line_account_id.COUNT);
10965: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa_tmp.line_account_id.COUNT: ' || r_sa_tmp.line_account_id.COUNT);
10966:
10967: IF (r_sa_tmp.line_account_id.COUNT = 0) THEN
10968: OPEN generic_suspense_cur;
10969: FETCH generic_suspense_cur BULK COLLECT INTO r_sa.line_account_id,
10978: r_sa.attribute5, r_sa.attribute6,
10979: r_sa.attribute7, r_sa.attribute8,
10980: r_sa.attribute9, r_sa.attribute10, r_sa.acct_type;
10981: CLOSE generic_suspense_cur;
10982: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa.line_account_id.COUNT: ' || r_sa.line_account_id.COUNT);
10983: ELSE
10984: OPEN generic_suspense_cur;
10985: FETCH generic_suspense_cur BULK COLLECT INTO r_gsa.line_account_id,
10986: r_gsa.gl_code_combination_id, r_gsa.project_id,
10994: r_gsa.attribute5, r_gsa.attribute6,
10995: r_gsa.attribute7, r_gsa.attribute8,
10996: r_gsa.attribute9, r_gsa.attribute10, r_gsa.acct_type;
10997: CLOSE generic_suspense_cur;
10998: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_gsa.line_account_id.COUNT: ' || r_gsa.line_account_id.COUNT);
10999:
11000: g_sa_pointer := 0;
11001: IF (r_sa_tmp.start_date_active(1) >= r_enc_period.r_asg_start_date(1)) THEN
11002: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) ||
10998: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_gsa.line_account_id.COUNT: ' || r_gsa.line_account_id.COUNT);
10999:
11000: g_sa_pointer := 0;
11001: IF (r_sa_tmp.start_date_active(1) >= r_enc_period.r_asg_start_date(1)) THEN
11002: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) ||
11003: ' r_sa_tmp.start_date_active(1): ' || r_sa_tmp.start_date_active(1) ||
11004: ' r_enc_period.r_asg_start_date(1): ' || r_enc_period.r_asg_start_date(1));
11005: FOR gsa_rec_no IN 1..r_gsa.line_account_id.COUNT
11006: LOOP
11031: r_sa.attribute9(g_sa_pointer) := r_gsa.attribute9(gsa_rec_no);
11032: r_sa.attribute10(g_sa_pointer) := r_gsa.attribute10(gsa_rec_no);
11033: r_sa.acct_type(g_sa_pointer) := r_gsa.acct_type(gsa_rec_no);
11034: END LOOP;
11035: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Identified Generic Suspense Lines for suspense gap before the first suspense line');
11036: END IF;
11037: g_sa_pointer := g_sa_pointer + 1;
11038: r_sa.line_account_id(g_sa_pointer) := r_sa_tmp.line_account_id(1);
11039: r_sa.gl_code_combination_id(g_sa_pointer) := r_sa_tmp.gl_code_combination_id(1);
11058: r_sa.attribute8(g_sa_pointer) := r_sa_tmp.attribute8(1);
11059: r_sa.attribute9(g_sa_pointer) := r_sa_tmp.attribute9(1);
11060: r_sa.attribute10(g_sa_pointer) := r_sa_tmp.attribute10(1);
11061: r_sa.acct_type(g_sa_pointer) := r_sa_tmp.acct_type(1);
11062: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Stamped first suspense line');
11063:
11064: IF (r_sa_tmp.line_account_id.COUNT > 1) THEN
11065: FOR sa_recno IN 2..r_sa_tmp.line_account_id.COUNT
11066: LOOP
11093: r_sa.attribute8(g_sa_pointer) := r_gsa.attribute8(gsa_rec_no);
11094: r_sa.attribute9(g_sa_pointer) := r_gsa.attribute9(gsa_rec_no);
11095: r_sa.attribute10(g_sa_pointer) := r_gsa.attribute10(gsa_rec_no);
11096: r_sa.acct_type(g_sa_pointer) := r_gsa.acct_type(gsa_rec_no);
11097: hr_utility.trace(' Stamped generic suspense line between ' ||
11098: r_sa.start_date_active(g_sa_pointer) || ' AND ' ||
11099: r_sa.end_date_active(g_sa_pointer));
11100: END IF;
11101: END LOOP;
11099: r_sa.end_date_active(g_sa_pointer));
11100: END IF;
11101: END LOOP;
11102: END IF;
11103: hr_utility.trace(' Attempting to stamp org suspense');
11104: g_sa_pointer := g_sa_pointer + 1;
11105: r_sa.line_account_id(g_sa_pointer) := r_sa_tmp.line_account_id(sa_recno);
11106: r_sa.gl_code_combination_id(g_sa_pointer) := r_sa_tmp.gl_code_combination_id(sa_recno);
11107: r_sa.project_id(g_sa_pointer) := r_sa_tmp.project_id(sa_recno);
11125: r_sa.attribute8(g_sa_pointer) := r_sa_tmp.attribute8(sa_recno);
11126: r_sa.attribute9(g_sa_pointer) := r_sa_tmp.attribute9(sa_recno);
11127: r_sa.attribute10(g_sa_pointer) := r_sa_tmp.attribute10(sa_recno);
11128: r_sa.acct_type(g_sa_pointer) := r_sa_tmp.acct_type(sa_recno);
11129: hr_utility.trace(' Stamped org suspense line between ' ||
11130: r_sa.start_date_active(g_sa_pointer) || ' AND ' || r_sa.end_date_active(g_sa_pointer));
11131: END LOOP;
11132: END IF;
11133:
11186: r_sa_tmp.attribute9.DELETE;
11187: r_sa_tmp.attribute10.DELETE;
11188: r_sa_tmp.acct_type.DELETE;
11189: END IF;
11190: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' r_sa.line_account_id.COUNT: ' || r_sa.line_account_id.COUNT);
11191: END IF;
11192:
11193: r_gsa.line_account_id.DELETE;
11194: r_gsa.gl_code_combination_id.DELETE;
11216: r_gsa.acct_type.DELETE;
11217:
11218: g_pateo_end_date := fnd_date.canonical_to_date('1800/01/01 00:00:00');
11219:
11220: hr_utility.trace('
11221: Global Element Hierarchy');
11222: hr_utility.trace(LPAD('Element Account Id', 18, ' ') || ' ' ||
11223: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11224: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11218: g_pateo_end_date := fnd_date.canonical_to_date('1800/01/01 00:00:00');
11219:
11220: hr_utility.trace('
11221: Global Element Hierarchy');
11222: hr_utility.trace(LPAD('Element Account Id', 18, ' ') || ' ' ||
11223: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11224: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11225: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11226: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11226: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11227: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11228: LPAD('Percent', 10, ' '));
11229:
11230: hr_utility.trace(LPAD('-', 18, '-') || ' ' ||
11231: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11232: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11233: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11234: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11234: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11235:
11236: FOR recno IN 1..r_gee.line_account_id.COUNT
11237: LOOP
11238: hr_utility.trace(LPAD(r_gee.line_account_id(recno), 17, ' ') || ' ' ||
11239: RPAD(TO_CHAR(r_gee.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11240: RPAD(TO_CHAR(r_gee.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11241: RPAD(NVL(TO_CHAR(r_gee.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11242: RPAD(NVL(TO_CHAR(r_gee.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11265: END IF;
11266: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_gee.poeta_end_date(recno), g_pateo_end_date));
11267: END LOOP;
11268:
11269: hr_utility.trace('
11270: Element Type Hierarchy');
11271: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11272: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11273: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11267: END LOOP;
11268:
11269: hr_utility.trace('
11270: Element Type Hierarchy');
11271: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11272: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11273: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11274: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11275: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11275: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11276: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11277: LPAD('Percent', 10, ' '));
11278:
11279: hr_utility.trace(LPAD('-', 17, '-') || ' ' ||
11280: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11281: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11282: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11283: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11283: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11284:
11285: FOR recno IN 1..r_et.line_account_id.COUNT
11286: LOOP
11287: hr_utility.trace(LPAD(r_et.line_account_id(recno), 17, ' ') || ' ' ||
11288: RPAD(TO_CHAR(r_et.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11289: RPAD(TO_CHAR(r_et.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11290: RPAD(NVL(TO_CHAR(r_et.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11291: RPAD(NVL(TO_CHAR(r_et.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11313: END IF;
11314: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_et.poeta_end_date(recno), g_pateo_end_date));
11315: END LOOP;
11316:
11317: hr_utility.trace('
11318: Element Class Hierarchy');
11319: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11320: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11321: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11315: END LOOP;
11316:
11317: hr_utility.trace('
11318: Element Class Hierarchy');
11319: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11320: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11321: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11322: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11323: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11323: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11324: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11325: LPAD('Percent', 10, ' '));
11326:
11327: hr_utility.trace(LPAD('-', 17, '-') || ' ' ||
11328: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11329: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11330: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11331: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11331: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11332:
11333: FOR recno IN 1..r_ec.line_account_id.COUNT
11334: LOOP
11335: hr_utility.trace(LPAD(r_ec.line_account_id(recno), 17, ' ') || ' ' ||
11336: RPAD(TO_CHAR(r_ec.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11337: RPAD(TO_CHAR(r_ec.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11338: RPAD(NVL(TO_CHAR(r_ec.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11339: RPAD(NVL(TO_CHAR(r_ec.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11361: END IF;
11362: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_ec.poeta_end_date(recno), g_pateo_end_date));
11363: END LOOP;
11364:
11365: hr_utility.trace('
11366: Assignment Hierarchy');
11367: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11368: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11369: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11363: END LOOP;
11364:
11365: hr_utility.trace('
11366: Assignment Hierarchy');
11367: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11368: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11369: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11370: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11371: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11371: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11372: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11373: LPAD('Percent', 10, ' '));
11374:
11375: hr_utility.trace(LPAD('-', 17, '-') || ' ' ||
11376: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11377: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11378: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11379: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11379: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11380:
11381: FOR recno IN 1..r_asg.line_account_id.COUNT
11382: LOOP
11383: hr_utility.trace(LPAD(r_asg.line_account_id(recno), 17, ' ') || ' ' ||
11384: RPAD(TO_CHAR(r_asg.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11385: RPAD(TO_CHAR(r_asg.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11386: RPAD(NVL(TO_CHAR(r_asg.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11387: RPAD(NVL(TO_CHAR(r_asg.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11409: END IF;
11410: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_asg.poeta_end_date(recno), g_pateo_end_date));
11411: END LOOP;
11412:
11413: hr_utility.trace('
11414: Organization Default Schedules Hierarchy');
11415: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11416: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11417: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11411: END LOOP;
11412:
11413: hr_utility.trace('
11414: Organization Default Schedules Hierarchy');
11415: hr_utility.trace(LPAD('Schedule Line Id', 17, ' ') || ' ' ||
11416: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11417: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11418: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11419: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11419: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11420: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11421: LPAD('Percent', 10, ' '));
11422:
11423: hr_utility.trace(LPAD('-', 17, '-') || ' ' ||
11424: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11425: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11426: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11427: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11427: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11428:
11429: FOR recno IN 1..r_odls.line_account_id.COUNT
11430: LOOP
11431: hr_utility.trace(LPAD(r_odls.line_account_id(recno), 17, ' ') || ' ' ||
11432: RPAD(TO_CHAR(r_odls.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11433: RPAD(TO_CHAR(r_odls.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11434: RPAD(NVL(TO_CHAR(r_odls.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11435: RPAD(NVL(TO_CHAR(r_odls.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11457: END IF;
11458: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_odls.poeta_end_date(recno), g_pateo_end_date));
11459: END LOOP;
11460:
11461: hr_utility.trace('
11462: Organization Default Account Hierarchy');
11463: hr_utility.trace(LPAD('Line Account Id', 17, ' ') || ' ' ||
11464: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11465: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11459: END LOOP;
11460:
11461: hr_utility.trace('
11462: Organization Default Account Hierarchy');
11463: hr_utility.trace(LPAD('Line Account Id', 17, ' ') || ' ' ||
11464: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11465: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11466: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11467: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11467: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11468: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11469: LPAD('Percent', 10, ' '));
11470:
11471: hr_utility.trace(LPAD('-', 17, '-') || ' ' ||
11472: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11473: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11474: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11475: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11475: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11476:
11477: FOR recno IN 1..r_da.line_account_id.COUNT
11478: LOOP
11479: hr_utility.trace(LPAD(r_da.line_account_id(recno), 17, ' ') || ' ' ||
11480: RPAD(TO_CHAR(r_da.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11481: RPAD(TO_CHAR(r_da.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11482: RPAD(NVL(TO_CHAR(r_da.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11483: RPAD(NVL(TO_CHAR(r_da.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11505: END IF;
11506: g_pateo_end_date := GREATEST(g_pateo_end_date, NVL(r_da.poeta_end_date(recno), g_pateo_end_date));
11507: END LOOP;
11508:
11509: hr_utility.trace('
11510: Suspense Account Hierarchy');
11511: hr_utility.trace(LPAD('Line Account Id', 17, ' ') || ' ' ||
11512: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11513: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11507: END LOOP;
11508:
11509: hr_utility.trace('
11510: Suspense Account Hierarchy');
11511: hr_utility.trace(LPAD('Line Account Id', 17, ' ') || ' ' ||
11512: RPAD('Start Date Active', 17, ' ') || ' ' || RPAD('End Date Active', 17, ' ') || ' ' ||
11513: RPAD('PATEO Start Date', 17, ' ') || ' ' || RPAD('PATEO End Date', 17, ' ') || ' ' ||
11514: LPAD('GL CC Id', 15, ' ') || ' ' || LPAD('Project Id', 15, ' ') || ' ' ||
11515: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11515: LPAD('Task Id', 15, ' ') || ' ' || LPAD('Award Id', 15, ' ') || ' ' ||
11516: LPAD('Expenditure Org Id', 18, ' ') || ' ' || RPAD('Expenditure Type', 30, ' ') || ' ' ||
11517: LPAD('Percent', 10, ' '));
11518:
11519: hr_utility.trace(LPAD('-', 17, '-') || ' ' ||
11520: RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' || RPAD('-', 17, '-') || ' ' ||
11521: RPAD('-', 17, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' ||
11522: LPAD('-', 15, '-') || ' ' || LPAD('-', 15, '-') || ' ' || LPAD('-', 18, '-') || ' ' ||
11523: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11523: RPAD('-', 30, '-') || ' ' || LPAD('-', 10, '-'));
11524:
11525: FOR recno IN 1..r_sa.line_account_id.COUNT
11526: LOOP
11527: hr_utility.trace(LPAD(r_sa.line_account_id(recno), 17, ' ') || ' ' ||
11528: RPAD(TO_CHAR(r_sa.start_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11529: RPAD(TO_CHAR(r_sa.end_date_active(recno), 'DD-MON-RRRR'), 17, ' ') || ' ' ||
11530: RPAD(NVL(TO_CHAR(r_sa.poeta_start_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11531: RPAD(NVL(TO_CHAR(r_sa.poeta_end_date(recno), 'DD-MON-RRRR'), ' '), 17, ' ') || ' ' ||
11557: IF ((g_pateo_end_date = fnd_date.canonical_to_date('1800/01/01 00:00:00')) OR
11558: (g_pateo_end_date < g_enc_org_end_date)) THEN
11559: g_pateo_end_date := g_enc_org_end_date;
11560: END IF;
11561: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_pateo_end_date: ' || TO_CHAR(g_pateo_end_date, 'DD-MON-RRRR'));
11562:
11563: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11564: p_return_status := fnd_api.g_ret_sts_success;
11565: EXCEPTION
11559: g_pateo_end_date := g_enc_org_end_date;
11560: END IF;
11561: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' g_pateo_end_date: ' || TO_CHAR(g_pateo_end_date, 'DD-MON-RRRR'));
11562:
11563: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11564: p_return_status := fnd_api.g_ret_sts_success;
11565: EXCEPTION
11566: WHEN OTHERS THEN
11567: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
11590: p_percent IN NUMBER DEFAULT NULL) IS
11591: l_warning_ind NUMBER(15);
11592: l_duplicate_ind NUMBER(15);
11593: BEGIN
11594: hr_utility.trace('Entering add_cel_warnings');
11595: l_warning_ind := cel_warnings.start_date.COUNT;
11596: hr_utility.trace('p_start_date: ' || p_start_date || ' p_end_date: ' || p_end_date ||
11597: ' p_hierarchy_code: ' || p_hierarchy_code || ' p_warning_code: ' || p_warning_code ||
11598: ' p_gl_ccid: ' || p_gl_ccid || ' p_project_id: ' || p_project_id || ' p_task_id: ' || p_task_id ||
11592: l_duplicate_ind NUMBER(15);
11593: BEGIN
11594: hr_utility.trace('Entering add_cel_warnings');
11595: l_warning_ind := cel_warnings.start_date.COUNT;
11596: hr_utility.trace('p_start_date: ' || p_start_date || ' p_end_date: ' || p_end_date ||
11597: ' p_hierarchy_code: ' || p_hierarchy_code || ' p_warning_code: ' || p_warning_code ||
11598: ' p_gl_ccid: ' || p_gl_ccid || ' p_project_id: ' || p_project_id || ' p_task_id: ' || p_task_id ||
11599: ' p_award_id:' || p_award_id || ' p_exp_org_id: ' || p_exp_org_id ||
11600: ' p_exp_type: ' || p_exp_type || ' p_effective_date: ' || p_effective_date ||
11610: (cel_warnings.warning_code(l_warning_ind) = 'BAL') AND
11611: (cel_warnings.percent(l_warning_ind) = p_percent));
11612: l_warning_ind := l_warning_ind - 1;
11613: END LOOP;
11614: hr_utility.trace('processing bal l_warning_ind: ' || l_warning_ind);
11615:
11616: l_duplicate_ind := cel_warnings.start_date.COUNT;
11617: LOOP
11618: EXIT WHEN l_duplicate_ind = 0;
11623: (cel_warnings.warning_code(l_duplicate_ind) = 'BAL') AND
11624: (cel_warnings.percent(l_duplicate_ind) = p_percent));
11625: l_duplicate_ind := l_duplicate_ind - 1;
11626: END LOOP;
11627: hr_utility.trace('processing bal l_duplicate_ind: ' || l_duplicate_ind);
11628:
11629: IF (l_warning_ind = 0) THEN
11630: l_warning_ind := cel_warnings.start_date.COUNT + 1;
11631: cel_warnings.start_date(l_warning_ind) := p_start_date;
11658: (cel_warnings.hierarchy_code(l_warning_ind) = p_hierarchy_code) AND
11659: (cel_warnings.warning_code(l_warning_ind) = 'NO_CI'));
11660: l_warning_ind := l_warning_ind - 1;
11661: END LOOP;
11662: hr_utility.trace('processing no_ci l_warning_ind: ' || l_warning_ind);
11663:
11664: l_duplicate_ind := cel_warnings.start_date.COUNT;
11665: LOOP
11666: EXIT WHEN l_duplicate_ind = 0;
11670: (cel_warnings.hierarchy_code(l_duplicate_ind) <> p_hierarchy_code) AND
11671: (cel_warnings.warning_code(l_duplicate_ind) = 'NO_CI'));
11672: l_duplicate_ind := l_duplicate_ind - 1;
11673: END LOOP;
11674: hr_utility.trace('processing no_ci l_duplicate_ind: ' || l_duplicate_ind);
11675:
11676: IF (l_warning_ind = 0) THEN
11677: l_warning_ind := cel_warnings.start_date.COUNT + 1;
11678: cel_warnings.start_date(l_warning_ind) := p_start_date;
11711: (cel_warnings.exp_type(l_warning_ind) = p_exp_type) AND
11712: (NVL(cel_warnings.error_status(l_warning_ind), 'NULL') = NVL(p_error_status, 'NULL')));
11713: l_warning_ind := l_warning_ind - 1;
11714: END LOOP;
11715: hr_utility.trace('processing invalid_ci l_warning_ind: ' || l_warning_ind);
11716:
11717: IF (l_warning_ind = 0) THEN
11718: l_warning_ind := cel_warnings.start_date.COUNT + 1;
11719: cel_warnings.start_date(l_warning_ind) := p_start_date;
11743: (cel_warnings.gl_ccid(l_warning_ind) = p_gl_ccid) AND
11744: (NVL(cel_warnings.error_status(l_warning_ind), 'NULL') = NVL(p_error_status, 'NULL')));
11745: l_warning_ind := l_warning_ind - 1;
11746: END LOOP;
11747: hr_utility.trace('processing autopop l_warning_ind: ' || l_warning_ind);
11748:
11749: IF (l_warning_ind = 0) THEN
11750: l_warning_ind := cel_warnings.start_date.COUNT + 1;
11751: cel_warnings.start_date(l_warning_ind) := p_start_date;
11779: (cel_warnings.exp_type(l_warning_ind) = p_exp_type) AND
11780: (NVL(cel_warnings.error_status(l_warning_ind), 'NULL') = NVL(p_error_status, 'NULL')));
11781: l_warning_ind := l_warning_ind - 1;
11782: END LOOP;
11783: hr_utility.trace('processing autopop l_warning_ind: ' || l_warning_ind);
11784:
11785: IF (l_warning_ind = 0) THEN
11786: l_warning_ind := cel_warnings.start_date.COUNT + 1;
11787: cel_warnings.start_date(l_warning_ind) := p_start_date;
11809: (cel_warnings.hierarchy_code(l_warning_ind) = p_hierarchy_code) AND
11810: (cel_warnings.warning_code(l_warning_ind) = 'GL'));
11811: l_warning_ind := l_warning_ind - 1;
11812: END LOOP;
11813: hr_utility.trace('processing bal l_warning_ind: ' || l_warning_ind);
11814:
11815: l_duplicate_ind := cel_warnings.start_date.COUNT;
11816: LOOP
11817: EXIT WHEN l_duplicate_ind = 0;
11821: (cel_warnings.hierarchy_code(l_duplicate_ind) <> p_hierarchy_code) AND
11822: (cel_warnings.warning_code(l_duplicate_ind) = 'GL'));
11823: l_duplicate_ind := l_duplicate_ind - 1;
11824: END LOOP;
11825: hr_utility.trace('processing bal l_duplicate_ind: ' || l_duplicate_ind);
11826:
11827: IF (l_warning_ind = 0) THEN
11828: l_warning_ind := cel_warnings.start_date.COUNT + 1;
11829: cel_warnings.start_date(l_warning_ind) := p_start_date;
11849: cel_warnings.start_date(l_warning_ind) := cel_warnings.start_date(l_duplicate_ind);
11850: cel_warnings.percent(l_warning_ind) := cel_warnings.percent(l_duplicate_ind) + p_percent;
11851: END IF;
11852: END IF;
11853: hr_utility.trace('cel_warnings.start_date.COUNT: ' || cel_warnings.start_date.COUNT);
11854: hr_utility.trace('Leaving add_cel_warnings');
11855: END add_cel_warnings;
11856:
11857: PROCEDURE delete_previous_error_log(p_assignment_id IN NUMBER,
11850: cel_warnings.percent(l_warning_ind) := cel_warnings.percent(l_duplicate_ind) + p_percent;
11851: END IF;
11852: END IF;
11853: hr_utility.trace('cel_warnings.start_date.COUNT: ' || cel_warnings.start_date.COUNT);
11854: hr_utility.trace('Leaving add_cel_warnings');
11855: END add_cel_warnings;
11856:
11857: PROCEDURE delete_previous_error_log(p_assignment_id IN NUMBER,
11858: p_payroll_id IN NUMBER,
11920: t_enc_lines r_enc_rec;
11921: t_enc_nlines r_enc_rec;
11922: l_nlines_counter NUMBER(15);
11923: BEGIN
11924: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering UPDATE_HIERARCHY_DATES');
11925: OPEN hierarchy_dates_cur;
11926: FETCH hierarchy_dates_cur BULK COLLECT INTO t_enc_lines.element_type_id, t_enc_lines.hierarchy_code,
11927: t_enc_lines.gl_ccid, t_enc_lines.project_id, t_enc_lines.task_id,
11928: t_enc_lines.award_id, t_enc_lines.exp_org_id, t_enc_lines.exp_type,
12131: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
12132: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
12133: END IF;
12134: p_return_status := fnd_api.g_ret_sts_success;
12135: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12136: EXCEPTION
12137: WHEN OTHERS THEN
12138: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
12139: IF (g_error_message IS NULL) THEN