eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_PRE_PROCESS dependencies on HR_UTILITY

Line 120: hr_utility.trace('Entering ' || l_proc_name);

116: WHERE payroll_id = p_payroll_id;
117:
118: BEGIN
119: -- Introduced the following for bug fix 3434626
120: hr_utility.trace('Entering ' || l_proc_name);
121: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
122: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
123: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
124: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));

Line 121: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||

117:
118: BEGIN
119: -- Introduced the following for bug fix 3434626
120: hr_utility.trace('Entering ' || l_proc_name);
121: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
122: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
123: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
124: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id));
125:

Line 140: hr_utility.trace('l_business_group_id: ' || fnd_number.number_to_canonical(l_business_group_id) ||

136: RETURN;
137: END IF;
138:
139: -- Introduced the following for bug fix 3434626
140: hr_utility.trace('l_business_group_id: ' || fnd_number.number_to_canonical(l_business_group_id) ||
141: ' l_set_of_books_id: ' || fnd_number.number_to_canonical(l_set_of_books_id) ||
142: ' l_operating_unit: ' || fnd_number.number_to_canonical(l_operating_unit) ||
143: ' l_pa_gms_install_option: ' || l_pa_gms_install_option);
144:

Line 170: hr_utility.trace('l_max_pay_date: ' || fnd_date.date_to_canonical(l_max_pay_date));

166:
167:
168:
169: -- Introduced the following for bug fix 3434626
170: hr_utility.trace('l_max_pay_date: ' || fnd_date.date_to_canonical(l_max_pay_date));
171:
172: l_proc_step := 30;
173: -- End of bug fix 3434626
174:

Line 232: hr_utility.trace('Leaving ' || l_proc_name);

228: p_return_status := fnd_api.g_ret_sts_success;
229:
230:
231: -- Introduced the following for bug fix 3434626
232: hr_utility.trace('Leaving ' || l_proc_name);
233: -- End of bug fix 3434626
234: EXCEPTION
235: WHEN OTHERS THEN
236: g_error_api_path := SUBSTR(g_error_api_path,1,30);

Line 243: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

239: p_print_header=>FND_API.G_TRUE);
240: -- bug fix 2597666
241: p_return_status := fnd_api.g_ret_sts_unexp_error;
242: -- Introduced the following for bug fix 3434626
243: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
244: hr_utility.trace('Leaving ' || l_proc_name);
245: -- End of changed for bug fix 3434626
246: END poeta_pre_process;
247:

Line 244: hr_utility.trace('Leaving ' || l_proc_name);

240: -- bug fix 2597666
241: p_return_status := fnd_api.g_ret_sts_unexp_error;
242: -- Introduced the following for bug fix 3434626
243: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
244: hr_utility.trace('Leaving ' || l_proc_name);
245: -- End of changed for bug fix 3434626
246: END poeta_pre_process;
247:
248: /****************************************************************************************************

Line 318: hr_utility.trace('Entering ' || l_proc_name);

314: AND pelh.change_flag = 'N';
315:
316: BEGIN
317: -- Introduced the following for bug fix 3434626
318: hr_utility.trace('Entering ' || l_proc_name);
319: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
320: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
321: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
322: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

Line 319: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||

315:
316: BEGIN
317: -- Introduced the following for bug fix 3434626
318: hr_utility.trace('Entering ' || l_proc_name);
319: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
320: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
321: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
322: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
323: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

Line 348: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||

344:
345: FOR i IN 1.. g_total_num_rec
346: LOOP
347: -- Introduced the following for bug fix 3434626
348: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||
349: ' r_global_control_rec.r_global_line_id: ' || fnd_number.number_to_canonical(r_global_control_rec.r_global_line_id(i)) ||
350: ' r_global_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_project_id(i)) ||
351: ' r_global_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_award_id(i)) ||
352: ' r_global_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_task_id(i)) ||

Line 386: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Introduced for bug fix 3434626
386: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
387: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
388: l_proc_step := 30;
389: -- End of bug fix 3434626
390:

Line 413: hr_utility.trace('r_asg_id_array.r_asg_id.count: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.count));

409: r_asg_id_array.r_asg_id, r_asg_id_array.r_payroll_id;
410: CLOSE assignment_payroll_cur;
411:
412: -- Introduced for bug fix 3434626
413: hr_utility.trace('r_asg_id_array.r_asg_id.count: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.count));
414: l_proc_step := 40;
415: -- End of bug fix 3434626
416:
417: /* Insert assignments (exists in psp_enc_lines_history and poeta dates

Line 457: hr_utility.trace('Leaving ' || l_proc_name);

453:
454: p_return_status := fnd_api.g_ret_sts_success;
455:
456: -- Introduced for bug fix 3434626
457: hr_utility.trace('Leaving ' || l_proc_name);
458: -- End of bug fix 3434626
459: EXCEPTION
460: WHEN OTHERS THEN
461: g_error_api_path := SUBSTR('UPDT_GLBL:'||g_error_api_path,1,30);

Line 465: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

461: g_error_api_path := SUBSTR('UPDT_GLBL:'||g_error_api_path,1,30);
462: -- bug fix 2597666
463: p_return_status := fnd_api.g_ret_sts_unexp_error;
464: -- Introduced for bug fix 3434626
465: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
466: hr_utility.trace('Leaving ' || l_proc_name);
467: -- End of bug fix 3434626
468: END update_global_earning_elements;
469:

Line 466: hr_utility.trace('Leaving ' || l_proc_name);

462: -- bug fix 2597666
463: p_return_status := fnd_api.g_ret_sts_unexp_error;
464: -- Introduced for bug fix 3434626
465: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
466: hr_utility.trace('Leaving ' || l_proc_name);
467: -- End of bug fix 3434626
468: END update_global_earning_elements;
469:
470: /****************************************************************************************************

Line 548: hr_utility.trace('Entering ' || l_proc_name);

544: ORDER BY 4,5,6,7,8;
545:
546: BEGIN
547: -- Introduced the following for bug fix 3434626
548: hr_utility.trace('Entering ' || l_proc_name);
549: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
550: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
551: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
552: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

Line 549: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||

545:
546: BEGIN
547: -- Introduced the following for bug fix 3434626
548: hr_utility.trace('Entering ' || l_proc_name);
549: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
550: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
551: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
552: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
553: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

Line 580: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||

576:
577: FOR i IN 1..g_total_num_rec
578: LOOP
579: -- Introduced the following for bug fix 3434626
580: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||
581: ' r_schedule_control_rec.r_schedule_line_id: ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_schedule_line_id(i)) ||
582: ' r_schedule_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_project_id(i)) ||
583: ' r_schedule_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_award_id(i)) ||
584: ' r_schedule_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_task_id(i)) ||

Line 621: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: -- Introduced for bug fix 3434626
621: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
622: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
623: l_proc_step := 30;
624: -- End of bug fix 3434626
625:

Line 645: hr_utility.trace('j: ' || fnd_number.number_to_canonical(j));

641: r_asg_id_array.r_payroll_id(j) := r_schedule_control_rec.r_payroll_id(i);
642: j := j+1;
643: END IF;
644: -- Introduced for bug fix 3434626
645: hr_utility.trace('j: ' || fnd_number.number_to_canonical(j));
646: l_proc_step := 40;
647: -- End of bug fix 3434626
648:
649: ELSE

Line 713: hr_utility.trace('Leaving ' || l_proc_name);

709: p_return_status := fnd_api.g_ret_sts_success;
710:
711: -- Introduced for bug fix 3434626
712: l_proc_step := 80;
713: hr_utility.trace('Leaving ' || l_proc_name);
714: -- End of bug fix 3434626
715: EXCEPTION
716: WHEN OTHERS THEN
717: g_error_api_path := SUBSTR('UPDT_SCHDLS:'||g_error_api_path,1,30);

Line 721: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

717: g_error_api_path := SUBSTR('UPDT_SCHDLS:'||g_error_api_path,1,30);
718: -- bug fix 2597666
719: p_return_status := fnd_api.g_ret_sts_unexp_error;
720: -- Introduced for bug fix 3434626
721: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
722: hr_utility.trace('Leaving ' || l_proc_name);
723: -- End of bug fix 3434626
724: END update_schedules;
725:

Line 722: hr_utility.trace('Leaving ' || l_proc_name);

718: -- bug fix 2597666
719: p_return_status := fnd_api.g_ret_sts_unexp_error;
720: -- Introduced for bug fix 3434626
721: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
722: hr_utility.trace('Leaving ' || l_proc_name);
723: -- End of bug fix 3434626
724: END update_schedules;
725:
726: /****************************************************************************************************

Line 797: hr_utility.trace('Entering ' || l_proc_name);

793: -- End of changes for bug fix 3434626
794:
795: BEGIN
796: -- Introduced the following for bug fix 3434626
797: hr_utility.trace('Entering ' || l_proc_name);
798: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
799: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
800: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
801: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

Line 798: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||

794:
795: BEGIN
796: -- Introduced the following for bug fix 3434626
797: hr_utility.trace('Entering ' || l_proc_name);
798: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
799: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
800: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
801: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
802: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

Line 826: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||

822:
823: FOR i IN 1..g_total_num_rec
824: LOOP
825: -- Introduced the following for bug fix 3434626
826: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||
827: ' r_ls_control_rec.r_schedule_line_id: ' || fnd_number.number_to_canonical(r_ls_control_rec.r_org_schedule_id(i)) ||
828: ' r_ls_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_project_id(i)) ||
829: ' r_ls_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_award_id(i)) ||
830: ' r_ls_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_task_id(i)) ||

Line 866: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864:
865: -- Introduced for bug fix 3434626
866: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
867: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
868: l_proc_step := 30;
869: -- End of bug fix 3434626
870:

Line 893: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

889: r_asg_id_array.r_payroll_id;
890: CLOSE assignment_payroll_cur;
891:
892: -- Introduced for bug fix 3434626
893: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
894: l_proc_step := 40;
895: -- End of bug fix 3434626
896: /* Insert assignments (exists in psp_enc_lines_history and poeta dates are
897: changed) into psp_enc_changed_assignments table*/

Line 940: hr_utility.trace('Leaving ' || l_proc_name);

936: p_return_status := fnd_api.g_ret_sts_success;
937:
938: -- Introduced for bug fix 3434626
939: l_proc_step := 70;
940: hr_utility.trace('Leaving ' || l_proc_name);
941: -- End of bug fix 3434626
942: EXCEPTION
943: WHEN OTHERS THEN
944: g_error_api_path := SUBSTR('UPDT_DFLT_LBR_SCHD:'||g_error_api_path,1,30);

Line 948: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

944: g_error_api_path := SUBSTR('UPDT_DFLT_LBR_SCHD:'||g_error_api_path,1,30);
945: -- bug fix 2597666
946: p_return_status := fnd_api.g_ret_sts_unexp_error;
947: -- Introduced for bug fix 3434626
948: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
949: hr_utility.trace('Leaving ' || l_proc_name);
950: -- End of bug fix 3434626
951: END update_default_labor_schedules;
952:

Line 949: hr_utility.trace('Leaving ' || l_proc_name);

945: -- bug fix 2597666
946: p_return_status := fnd_api.g_ret_sts_unexp_error;
947: -- Introduced for bug fix 3434626
948: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
949: hr_utility.trace('Leaving ' || l_proc_name);
950: -- End of bug fix 3434626
951: END update_default_labor_schedules;
952:
953: /****************************************************************************************************

Line 1022: hr_utility.trace('Entering ' || l_proc_name);

1018: l_proc_step NUMBER(20, 10) DEFAULT 0;
1019: -- End of changes for bug fix 3434626
1020: BEGIN
1021: -- Introduced the following for bug fix 3434626
1022: hr_utility.trace('Entering ' || l_proc_name);
1023: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
1024: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1025: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1026: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||

Line 1023: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||

1019: -- End of changes for bug fix 3434626
1020: BEGIN
1021: -- Introduced the following for bug fix 3434626
1022: hr_utility.trace('Entering ' || l_proc_name);
1023: hr_utility.trace('p_pre_process_mode: ' || p_pre_process_mode ||
1024: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1025: ' p_business_group_id: ' || fnd_number.number_to_canonical(p_business_group_id) ||
1026: ' p_set_of_books_id: ' || fnd_number.number_to_canonical(p_set_of_books_id) ||
1027: ' p_max_pay_date: ' || fnd_date.date_to_canonical(p_max_pay_date));

Line 1051: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||

1047:
1048: FOR i IN 1..g_total_num_rec
1049: LOOP
1050: -- Introduced the following for bug fix 3434626
1051: hr_utility.trace('i: ' || fnd_number.number_to_canonical(i) ||
1052: ' r_susp_control_rec.r_schedule_line_id: ' || fnd_number.number_to_canonical(r_susp_control_rec.r_organization_account_id(i)) ||
1053: ' r_susp_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_project_id(i)) ||
1054: ' r_susp_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_award_id(i)) ||
1055: ' r_susp_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_task_id(i)) ||

Line 1091: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- Introduced for bug fix 3434626
1091: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||
1092: ' l_poeta_end_date: ' || fnd_date.date_to_canonical(g_final_end_date));
1093: l_proc_step := 30;
1094: -- End of bug fix 3434626
1095:

Line 1119: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1115: r_asg_id_array.r_payroll_id;
1116: CLOSE assignment_payroll_cur;
1117:
1118: -- Introduced for bug fix 3434626
1119: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1120: l_proc_step := 40;
1121: -- End of bug fix 3434626
1122:
1123: /* Insert assignments (exists in psp_enc_lines_history and poeta dates are

Line 1168: hr_utility.trace('Leaving ' || l_proc_name);

1164: p_return_status := fnd_api.g_ret_sts_success;
1165:
1166: -- Introduced for bug fix 3434626
1167: l_proc_step := 70;
1168: hr_utility.trace('Leaving ' || l_proc_name);
1169: -- End of bug fix 3434626
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: g_error_api_path := SUBSTR('UPDT_DFLT_SSP_ACCNT:'||g_error_api_path,1,30);

Line 1176: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1172: g_error_api_path := SUBSTR('UPDT_DFLT_SSP_ACCNT:'||g_error_api_path,1,30);
1173: -- bug fix 2597666
1174: p_return_status := fnd_api.g_ret_sts_unexp_error;
1175: -- Introduced for bug fix 3434626
1176: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1177: hr_utility.trace('Leaving ' || l_proc_name);
1178: -- End of bug fix 3434626
1179: END update_default_susp_accounts;
1180:

Line 1177: hr_utility.trace('Leaving ' || l_proc_name);

1173: -- bug fix 2597666
1174: p_return_status := fnd_api.g_ret_sts_unexp_error;
1175: -- Introduced for bug fix 3434626
1176: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1177: hr_utility.trace('Leaving ' || l_proc_name);
1178: -- End of bug fix 3434626
1179: END update_default_susp_accounts;
1180:
1181: /****************************************************************************************************

Line 1291: hr_utility.trace('Entering ' || l_proc_name);

1287: l_proc_step NUMBER(20, 10) DEFAULT 0;
1288: -- End of changes for bug fix 3434626
1289: BEGIN
1290: -- Introduced the following for bug fix 3434626
1291: hr_utility.trace('Entering ' || l_proc_name);
1292: hr_utility.trace('p_project_id: ' || fnd_number.number_to_canonical(p_project_id) ||
1293: ' p_award_id: ' || fnd_number.number_to_canonical(p_award_id) ||
1294: ' p_task_id: ' || fnd_number.number_to_canonical(p_task_id) ||
1295: ' p_expenditure_organization_id: ' || fnd_number.number_to_canonical(p_expenditure_organization_id) ||

Line 1292: hr_utility.trace('p_project_id: ' || fnd_number.number_to_canonical(p_project_id) ||

1288: -- End of changes for bug fix 3434626
1289: BEGIN
1290: -- Introduced the following for bug fix 3434626
1291: hr_utility.trace('Entering ' || l_proc_name);
1292: hr_utility.trace('p_project_id: ' || fnd_number.number_to_canonical(p_project_id) ||
1293: ' p_award_id: ' || fnd_number.number_to_canonical(p_award_id) ||
1294: ' p_task_id: ' || fnd_number.number_to_canonical(p_task_id) ||
1295: ' p_expenditure_organization_id: ' || fnd_number.number_to_canonical(p_expenditure_organization_id) ||
1296: ' p_expenditure_type: ' || p_expenditure_type ||

Line 1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1309: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1310: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1311: CLOSE project_info_cur;
1312: -- Introduced the following for bug fix 3434626
1313: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1314: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1315:
1316: l_proc_step := 20;
1317: -- End of bug fix 3434626

Line 1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1331: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1332: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1333: CLOSE project_status_csr;
1334: -- Introduced the following for bug fix 3434626
1335: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1336: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1337:
1338: l_proc_step := 40;
1339: -- End of bug fix 3434626

Line 1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1352: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1353: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1354: CLOSE award_info_cur;
1355: -- Introduced the following for bug fix 3434626
1356: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1357: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1358:
1359: l_proc_step := 60;
1360: -- End of bug fix 3434626

Line 1378: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1374: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1375: CLOSE expenditure_type_info_cur;
1376: RETURN;
1377: -- Introduced the following for bug fix 3434626
1378: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1379: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1380:
1381: l_proc_step := 80;
1382: -- End of bug fix 3434626

Line 1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1394: p_start_date := fnd_date.canonical_to_date('1800/01/01');
1395: p_end_date := fnd_date.canonical_to_date('1800/01/31');
1396: CLOSE exp_org_cur;
1397: -- Introduced the following for bug fix 3434626
1398: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1399: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1400:
1401: l_proc_step := 100;
1402: -- End of bug fix 3434626

Line 1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||

1418: l_labor_enc_start_date,
1419: l_labor_enc_end_date);
1420: l_labor_enc_start_date := NVL(l_labor_enc_start_date, fnd_date.canonical_to_date('1800/01/01'));
1421: l_labor_enc_end_date := NVL(l_labor_enc_end_date, fnd_date.canonical_to_date('4712/12/31'));
1422: hr_utility.trace('l_labor_enc_start_date: ' || fnd_date.date_to_canonical(l_labor_enc_start_date) ||
1423: ' l_labor_enc_end_date: ' || fnd_date.date_to_canonical(l_labor_enc_end_date));
1424:
1425: p_end_date := LEAST (l_proj_end_date,
1426: l_task_end_date,

Line 1439: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

1435: l_exp_org_start_date,
1436: l_labor_enc_start_date);
1437:
1438: -- Introduced the following for bug fix 3434626
1439: hr_utility.trace('p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1440: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1441:
1442: l_proc_step := 120;
1443: -- End of bug fix 3434626

Line 1448: hr_utility.trace('Leaving ' || l_proc_name);

1444:
1445: p_return_status := fnd_api.g_ret_sts_success;
1446:
1447: -- Introduced for bug fix 3434626
1448: hr_utility.trace('Leaving ' || l_proc_name);
1449: -- End of bug fix 3434626
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: g_error_api_path := SUBSTR('VALIDATE_POETA:'||g_error_api_path,1,30);

Line 1456: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1452: g_error_api_path := SUBSTR('VALIDATE_POETA:'||g_error_api_path,1,30);
1453: -- bug fix 2597666
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: -- Introduced for bug fix 3434626
1456: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1457: hr_utility.trace('Leaving ' || l_proc_name);
1458: -- End of bug fix 3434626
1459: END validate_poeta;
1460:

Line 1457: hr_utility.trace('Leaving ' || l_proc_name);

1453: -- bug fix 2597666
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: -- Introduced for bug fix 3434626
1456: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1457: hr_utility.trace('Leaving ' || l_proc_name);
1458: -- End of bug fix 3434626
1459: END validate_poeta;
1460:
1461: /****************************************************************************************************

Line 1509: hr_utility.trace('Entering ' || l_proc_name);

1505: -- End of changes for bug fix 3434626
1506:
1507: BEGIN
1508: -- Introduced the following for bug fix 3434626
1509: hr_utility.trace('Entering ' || l_proc_name);
1510: hr_utility.trace('p_project_id: ' || fnd_number.number_to_canonical(p_project_id) ||
1511: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id));
1512:
1513: l_proc_step := 10;

Line 1510: hr_utility.trace('p_project_id: ' || fnd_number.number_to_canonical(p_project_id) ||

1506:
1507: BEGIN
1508: -- Introduced the following for bug fix 3434626
1509: hr_utility.trace('Entering ' || l_proc_name);
1510: hr_utility.trace('p_project_id: ' || fnd_number.number_to_canonical(p_project_id) ||
1511: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id));
1512:
1513: l_proc_step := 10;
1514: -- End of bug fix 3434626

Line 1523: hr_utility.trace('l_enc_cr_date: ' || fnd_date.date_to_canonical(l_enc_cr_date));

1519: FETCH max_create_dt_cur INTO l_enc_cr_date;
1520: CLOSE max_create_dt_cur;
1521:
1522: -- Introduced the following for bug fix 3434626
1523: hr_utility.trace('l_enc_cr_date: ' || fnd_date.date_to_canonical(l_enc_cr_date));
1524:
1525: l_proc_step := 20;
1526: -- End of bug fix 3434626
1527:

Line 1537: hr_utility.trace('l_project_id: ' || fnd_number.number_to_canonical(l_project_id));

1533: FETCH patc_change_cur INTO l_project_id;
1534: CLOSE patc_change_cur;
1535:
1536: -- Introduced the following for bug fix 3434626
1537: hr_utility.trace('l_project_id: ' || fnd_number.number_to_canonical(l_project_id));
1538:
1539: l_proc_step := 30;
1540: -- End of bug fix 3434626
1541:

Line 1549: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1545: r_asg_id_array.r_payroll_id;
1546: CLOSE tx_control_asg_cur;
1547:
1548: -- Introduced the following for bug fix 3434626
1549: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1550:
1551: l_proc_step := 40;
1552: -- End of bug fix 3434626
1553:

Line 1571: hr_utility.trace('Leaving ' || l_proc_name);

1567:
1568: p_return_status := fnd_api.g_ret_sts_success;
1569:
1570: -- Introduced the following for bug fix 3434626
1571: hr_utility.trace('Leaving ' || l_proc_name);
1572: -- End of bug fix 3434626
1573:
1574: EXCEPTION
1575: WHEN OTHERS THEN

Line 1580: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1576: g_error_api_path := SUBSTR('VLDT_TRNSCTN_CNTRLS:'||g_error_api_path,1,30);
1577: -- bug fix 2597666
1578: p_return_status := fnd_api.g_ret_sts_unexp_error;
1579: -- Introduced the following for bug fix 3434626
1580: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1581: hr_utility.trace('Leaving ' || l_proc_name);
1582: -- End of changed for bug fix 3434626
1583: END validate_transaction_controls;
1584:

Line 1581: hr_utility.trace('Leaving ' || l_proc_name);

1577: -- bug fix 2597666
1578: p_return_status := fnd_api.g_ret_sts_unexp_error;
1579: -- Introduced the following for bug fix 3434626
1580: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1581: hr_utility.trace('Leaving ' || l_proc_name);
1582: -- End of changed for bug fix 3434626
1583: END validate_transaction_controls;
1584:
1585: /****************************************************************************************************

Line 1602: hr_utility.trace('Entering ' || l_proc_name);

1598: l_proc_step NUMBER(20, 10) DEFAULT 10;
1599: -- End of changes for bug fix 3434626
1600: BEGIN
1601: -- Introduced the following for bug fix 3434626
1602: hr_utility.trace('Entering ' || l_proc_name);
1603: hr_utility.trace('p_change_type ' || p_change_type || ' p_action_type ' || p_action_type ||
1604: ' p_reference_id: ' || fnd_number.number_to_canonical(p_reference_id) ||
1605: ' r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1606: -- End of bug fix 3434626

Line 1603: hr_utility.trace('p_change_type ' || p_change_type || ' p_action_type ' || p_action_type ||

1599: -- End of changes for bug fix 3434626
1600: BEGIN
1601: -- Introduced the following for bug fix 3434626
1602: hr_utility.trace('Entering ' || l_proc_name);
1603: hr_utility.trace('p_change_type ' || p_change_type || ' p_action_type ' || p_action_type ||
1604: ' p_reference_id: ' || fnd_number.number_to_canonical(p_reference_id) ||
1605: ' r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1606: -- End of bug fix 3434626
1607:

Line 1620: hr_utility.trace('Leaving ' || l_proc_name);

1616: r_asg_id_array.r_payroll_id.delete;
1617:
1618: p_return_status := fnd_api.g_ret_sts_success;
1619: -- Introduced the following for bug fix 3434626
1620: hr_utility.trace('Leaving ' || l_proc_name);
1621: -- End of changed for bug fix 3434626
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: g_error_api_path := SUBSTR('INSERT_CHANGED_ASSIGNMENTS:'||g_error_api_path,1,30);

Line 1628: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

1624: g_error_api_path := SUBSTR('INSERT_CHANGED_ASSIGNMENTS:'||g_error_api_path,1,30);
1625: -- bug fix 2597666
1626: p_return_status := fnd_api.g_ret_sts_unexp_error;
1627: -- Introduced the following for bug fix 3434626
1628: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1629: hr_utility.trace('Leaving ' || l_proc_name);
1630: -- End of changed for bug fix 3434626
1631: END insert_changed_assignments;
1632:

Line 1629: hr_utility.trace('Leaving ' || l_proc_name);

1625: -- bug fix 2597666
1626: p_return_status := fnd_api.g_ret_sts_unexp_error;
1627: -- Introduced the following for bug fix 3434626
1628: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1629: hr_utility.trace('Leaving ' || l_proc_name);
1630: -- End of changed for bug fix 3434626
1631: END insert_changed_assignments;
1632:
1633: /****************************************************************************************************

Line 1825: hr_utility.trace('Entering ' || l_proc_name);

1821: l_proc_step NUMBER(20, 10) DEFAULT 0;
1822: -- End of changes for bug fix 3434626
1823: BEGIN
1824: -- Introduced the following for bug fix 3434626
1825: hr_utility.trace('Entering ' || l_proc_name);
1826: hr_utility.trace('p_enc_line_type: ' || p_enc_line_type || ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id));
1827:
1828: l_proc_step := 10;
1829: -- End of bug fix 3434626

Line 1826: hr_utility.trace('p_enc_line_type: ' || p_enc_line_type || ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id));

1822: -- End of changes for bug fix 3434626
1823: BEGIN
1824: -- Introduced the following for bug fix 3434626
1825: hr_utility.trace('Entering ' || l_proc_name);
1826: hr_utility.trace('p_enc_line_type: ' || p_enc_line_type || ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id));
1827:
1828: l_proc_step := 10;
1829: -- End of bug fix 3434626
1830:

Line 1839: hr_utility.trace('Leaving: ' || l_proc_name);

1835: AND change_type IN ('AS', 'ET', 'LS', 'QU');
1836:
1837: p_return_status := fnd_api.g_ret_sts_success;
1838: -- Introduced the following for bug fix 3434626
1839: hr_utility.trace('Leaving: ' || l_proc_name);
1840: -- End of changed for bug fix 3434626
1841:
1842: RETURN;
1843: ELSE

Line 1865: hr_utility.trace('r_reference_id_array.r_reference_id.COUNT: ' || fnd_number.number_to_canonical(r_reference_id_array.r_reference_id.COUNT));

1861: r_reference_id_array.r_action_type;
1862: CLOSE enc_changed_schedule_cur;
1863:
1864: -- Introduced the following for bug fix 3434626
1865: hr_utility.trace('r_reference_id_array.r_reference_id.COUNT: ' || fnd_number.number_to_canonical(r_reference_id_array.r_reference_id.COUNT));
1866:
1867: l_proc_step := 40;
1868: -- End of bug fix 3434626
1869:

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

1869:
1870: FOR I in 1 .. r_reference_id_array.r_reference_id.COUNT
1871: LOOP
1872: -- Introduced the following for bug fix 3434626
1873: hr_utility.trace('I: ' || fnd_number.number_to_canonical(I) ||
1874: ' r_reference_id_array.r_reference_id(I): ' || fnd_number.number_to_canonical(r_reference_id_array.r_reference_id(I)) ||
1875: ' r_reference_id_array.r_reference_field(I): ' || r_reference_id_array.r_reference_field(I) ||
1876: ' r_reference_id_array.r_change_type(I): ' || r_reference_id_array.r_change_type(I) ||
1877: ' r_reference_id_array.r_action_type(I): ' || r_reference_id_array.r_action_type(I));

Line 1894: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1890: BULK COLLECT INTO r_asg_id_array.r_asg_id, r_asg_id_array.r_payroll_id;
1891: CLOSE assignment_payroll_da_upd_cur;
1892:
1893: -- Introduced the following for bug fix 3434626
1894: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1895: -- End of bug fix 3434626
1896:
1897: insert_changed_assignments(p_change_type => 'DA',
1898: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 1918: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1914: r_asg_id_array.r_payroll_id;
1915: CLOSE org_da_insert_cur;
1916:
1917: -- Introduced the following for bug fix 3434626
1918: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1919: -- End of bug fix 3434626
1920:
1921: insert_changed_assignments(p_change_type => 'DA',
1922: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 1942: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1938: r_asg_id_array.r_payroll_id;
1939: CLOSE assignment_payroll_sa_upd_cur;
1940:
1941: -- Introduced the following for bug fix 3434626
1942: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1943: -- End of bug fix 3434626
1944:
1945: insert_changed_assignments(p_change_type => r_reference_id_array.r_change_type(i),
1946: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 1964: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1960: r_asg_id_array.r_payroll_id;
1961: CLOSE org_sa_insert_cur;
1962:
1963: -- Introduced the following for bug fix 3434626
1964: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1965: -- End of bug fix 3434626
1966:
1967: insert_changed_assignments(p_change_type => 'SA',
1968: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 1986: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

1982: BULK COLLECT INTO r_asg_id_array.r_asg_id,
1983: r_asg_id_array.r_payroll_id;
1984: CLOSE assignment_payroll_ds_upd_cur;
1985: -- Introduced the following for bug fix 3434626
1986: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1987: -- End of bug fix 3434626
1988:
1989: insert_changed_assignments(p_change_type => 'DS',
1990: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2010: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

2006: r_asg_id_array.r_payroll_id;
2007: CLOSE org_ds_insert_cur;
2008:
2009: -- Introduced the following for bug fix 3434626
2010: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
2011: -- End of bug fix 3434626
2012:
2013: insert_changed_assignments(p_change_type => 'DS',
2014: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2032: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

2028: BULK COLLECT INTO r_asg_id_array.r_asg_id,
2029: r_asg_id_array.r_payroll_id;
2030: CLOSE assignment_payroll_ge_upd_cur;
2031: -- Introduced the following for bug fix 3434626
2032: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
2033: -- End of bug fix 3434626
2034:
2035: insert_changed_assignments(p_change_type => 'GE',
2036: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2053: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

2049: BULK COLLECT INTO r_asg_id_array.r_asg_id,
2050: r_asg_id_array.r_payroll_id;
2051: CLOSE global_element_insert_cur;
2052: -- Introduced the following for bug fix 3434626
2053: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
2054: -- End of bug fix 3434626
2055:
2056: insert_changed_assignments(p_change_type => 'GE',
2057: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2073: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

2069: BULK COLLECT INTO r_asg_id_array.r_asg_id,
2070: r_asg_id_array.r_payroll_id;
2071: CLOSE assignment_payroll_ex_upd_cur;
2072: -- Introduced the following for bug fix 3434626
2073: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
2074: -- End of bug fix 3434626
2075:
2076: insert_changed_assignments(p_change_type => 'EX',
2077: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2109: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

2105: CLOSE default_org_end_date_asg_cur;
2106: END IF; -- Introduced for bug fix 3426871
2107:
2108: -- Introduced the following for bug fix 3434626
2109: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
2110: -- End of bug fix 3434626
2111:
2112: insert_changed_assignments(p_change_type => 'OE',
2113: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2130: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

2126: r_asg_id_array.r_payroll_id;
2127: CLOSE element_ed_ins_upd_cur;
2128:
2129: -- Introduced the following for bug fix 3434626
2130: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
2131: -- End of bug fix 3434626
2132:
2133: insert_changed_assignments(p_change_type => 'ED',
2134: p_reference_id => r_reference_id_array.r_reference_id(i),

Line 2172: hr_utility.trace('Leaving: ' || l_proc_name);

2168: l_proc_step := 200; -- Introduced for bug fix 3434626
2169:
2170: p_return_status := fnd_api.g_ret_sts_success;
2171: -- Introduced the following for bug fix 3434626
2172: hr_utility.trace('Leaving: ' || l_proc_name);
2173: -- End of changed for bug fix 3434626
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: g_error_api_path := 'PSP_ENC_PRE_PROCESS : LABOR_SCHEDULE_PRE_PROCESS';

Line 2181: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

2177: fnd_msg_pub.add_exc_msg('PSP_ENC_PRE_PROCESS', 'LABOR_SCHEDULE_PRE_PROCESS');
2178: ROLLBACK;
2179: p_return_status := fnd_api.g_ret_sts_unexp_error;
2180: -- Introduced the following for bug fix 3434626
2181: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
2182: hr_utility.trace('Leaving: ' || l_proc_name);
2183: -- End of changed for bug fix 3434626
2184: END labor_schedule_pre_process;
2185:

Line 2182: hr_utility.trace('Leaving: ' || l_proc_name);

2178: ROLLBACK;
2179: p_return_status := fnd_api.g_ret_sts_unexp_error;
2180: -- Introduced the following for bug fix 3434626
2181: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
2182: hr_utility.trace('Leaving: ' || l_proc_name);
2183: -- End of changed for bug fix 3434626
2184: END labor_schedule_pre_process;
2185:
2186: END psp_enc_pre_process;