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 FND_NUMBER

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

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:
126: l_proc_step := 10;

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

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:
126: l_proc_step := 10;
127: -- End of Changes for bug fix 3434626

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

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:
126: l_proc_step := 10;
127: -- End of Changes for bug fix 3434626
128: /* Validation for GMS install option */

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 141: ' l_set_of_books_id: ' || fnd_number.number_to_canonical(l_set_of_books_id) ||

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:
145: l_proc_step := 20;

Line 142: ' l_operating_unit: ' || fnd_number.number_to_canonical(l_operating_unit) ||

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:
145: l_proc_step := 20;
146: -- End of changes for bug fix 3434626

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 320: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

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));
324:

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

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));
324:
325: l_proc_step := 10; -- Introduced for bug fix 3434626

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

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));
324:
325: l_proc_step := 10; -- Introduced for bug fix 3434626
326: -- End of bug fix 3434626

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 349: ' r_global_control_rec.r_global_line_id: ' || fnd_number.number_to_canonical(r_global_control_rec.r_global_line_id(i)) ||

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)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||

Line 350: ' r_global_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_project_id(i)) ||

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)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||

Line 351: ' r_global_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_award_id(i)) ||

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)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||

Line 352: ' r_global_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_task_id(i)) ||

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)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||

Line 353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(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)) ||
353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

Line 357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

353: ' r_global_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_global_control_rec.r_expenditure_organization_id(i)) ||
354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
359: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
360: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
361: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);

Line 358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

354: ' r_global_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_start_date(i)) ||
355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
359: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
360: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
361: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
362:

Line 359: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

355: ' r_global_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_global_control_rec.r_poeta_end_date(i)) ||
356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
359: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
360: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
361: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
362:
363: l_proc_step := 20;

Line 360: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||

356: ' r_global_control_rec.r_expenditure_type(i): ' || r_global_control_rec.r_expenditure_type(i) ||
357: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
358: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
359: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
360: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
361: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
362:
363: l_proc_step := 20;
364: -- End of bug fix 3434626

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 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 550: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

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));
554:

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

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));
554:
555: l_proc_step := 10; -- Introduced for bug fix 3434626

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

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));
554:
555: l_proc_step := 10; -- Introduced for bug fix 3434626
556: -- End of bug fix 3434626

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 581: ' r_schedule_control_rec.r_schedule_line_id: ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_schedule_line_id(i)) ||

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)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||

Line 582: ' r_schedule_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_project_id(i)) ||

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)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||

Line 583: ' r_schedule_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_award_id(i)) ||

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)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||

Line 584: ' r_schedule_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_task_id(i)) ||

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)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||

Line 585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(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)) ||
585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

Line 589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

585: ' r_schedule_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_schedule_control_rec.r_expenditure_organization_id(i)) ||
586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
591: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
592: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
593: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);

Line 590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

586: ' r_schedule_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_start_date(i)) ||
587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
591: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
592: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
593: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
594:

Line 591: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

587: ' r_schedule_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_schedule_control_rec.r_poeta_end_date(i)) ||
588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
591: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
592: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
593: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
594:
595: l_proc_step := 20;

Line 592: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||

588: ' r_schedule_control_rec.r_expenditure_type(i): ' || r_schedule_control_rec.r_expenditure_type(i) ||
589: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
590: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
591: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
592: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
593: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
594:
595: l_proc_step := 20;
596: -- End of bug fix 3434626

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 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 799: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

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));
803:

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

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));
803:
804: l_proc_step := 10; -- Introduced for bug fix 3434626

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

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));
803:
804: l_proc_step := 10; -- Introduced for bug fix 3434626
805: -- End of bug fix 3434626

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 827: ' r_ls_control_rec.r_schedule_line_id: ' || fnd_number.number_to_canonical(r_ls_control_rec.r_org_schedule_id(i)) ||

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)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||

Line 828: ' r_ls_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_project_id(i)) ||

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)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||

Line 829: ' r_ls_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_award_id(i)) ||

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)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||

Line 830: ' r_ls_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_task_id(i)) ||

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)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||

Line 831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(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)) ||
831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

Line 835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

831: ' r_ls_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_ls_control_rec.r_expenditure_organization_id(i)) ||
832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
837: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
838: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
839: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);

Line 836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

832: ' r_ls_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_start_date(i)) ||
833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
837: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
838: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
839: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
840:

Line 837: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

833: ' r_ls_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_ls_control_rec.r_poeta_end_date(i)) ||
834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
837: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
838: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
839: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
840:
841: l_proc_step := 20;

Line 838: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||

834: ' r_ls_control_rec.r_expenditure_type(i): ' || r_ls_control_rec.r_expenditure_type(i) ||
835: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
836: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
837: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
838: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
839: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
840:
841: l_proc_step := 20;
842: -- End of bug fix 3434626

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 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 1024: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

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));
1028:

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

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));
1028:
1029: l_proc_step := 10; -- Introduced for bug fix 3434626

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

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));
1028:
1029: l_proc_step := 10; -- Introduced for bug fix 3434626
1030: -- End of bug fix 3434626

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 1052: ' r_susp_control_rec.r_schedule_line_id: ' || fnd_number.number_to_canonical(r_susp_control_rec.r_organization_account_id(i)) ||

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)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||

Line 1053: ' r_susp_control_rec.r_project_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_project_id(i)) ||

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)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||

Line 1054: ' r_susp_control_rec.r_award_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_award_id(i)) ||

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)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||

Line 1055: ' r_susp_control_rec.r_task_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_task_id(i)) ||

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)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||

Line 1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(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)) ||
1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

Line 1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||

1056: ' r_susp_control_rec.r_expenditure_organization_id(i): ' || fnd_number.number_to_canonical(r_susp_control_rec.r_expenditure_organization_id(i)) ||
1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
1062: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
1063: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
1064: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);

Line 1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||

1057: ' r_susp_control_rec.r_poeta_start_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_start_date(i)) ||
1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
1062: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
1063: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
1064: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
1065:

Line 1062: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||

1058: ' r_susp_control_rec.r_poeta_end_date(i): ' || fnd_date.date_to_canonical(r_susp_control_rec.r_poeta_end_date(i)) ||
1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
1062: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
1063: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
1064: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
1065:
1066: l_proc_step := 20;

Line 1063: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||

1059: ' r_susp_control_rec.r_expenditure_type(i): ' || r_susp_control_rec.r_expenditure_type(i) ||
1060: ' l_prev_project_id: ' || fnd_number.number_to_canonical(l_prev_project_id) ||
1061: ' l_prev_award_id: ' || fnd_number.number_to_canonical(l_prev_award_id) ||
1062: ' l_prev_task_id: ' || fnd_number.number_to_canonical(l_prev_task_id) ||
1063: ' l_prev_exp_organization_id: ' || fnd_number.number_to_canonical(l_prev_exp_organization_id) ||
1064: ' l_prev_expenditure_type: ' || l_prev_expenditure_type);
1065:
1066: l_proc_step := 20;
1067: -- End of bug fix 3434626

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 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 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 1293: ' p_award_id: ' || fnd_number.number_to_canonical(p_award_id) ||

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 ||
1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||

Line 1294: ' p_task_id: ' || fnd_number.number_to_canonical(p_task_id) ||

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 ||
1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1298: ' p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||

Line 1295: ' p_expenditure_organization_id: ' || fnd_number.number_to_canonical(p_expenditure_organization_id) ||

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 ||
1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1298: ' p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1299: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));

Line 1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_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 ||
1297: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id) ||
1298: ' p_start_date: ' || fnd_date.date_to_canonical(p_start_date) ||
1299: ' p_end_date: ' || fnd_date.date_to_canonical(p_end_date));
1300:
1301: l_proc_step := 10;

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 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 1511: ' p_payroll_id: ' || fnd_number.number_to_canonical(p_payroll_id));

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
1515:

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 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 1604: ' p_reference_id: ' || fnd_number.number_to_canonical(p_reference_id) ||

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:
1608: FORALL k in 1 .. r_asg_id_array.r_asg_id.count

Line 1605: ' r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));

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:
1608: FORALL k in 1 .. r_asg_id_array.r_asg_id.count
1609: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

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 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 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 1874: ' r_reference_id_array.r_reference_id(I): ' || fnd_number.number_to_canonical(r_reference_id_array.r_reference_id(I)) ||

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));
1878:

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 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: