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_ADJ_DRIVER dependencies on HR_UTILITY

Line 3096: hr_utility.trace('**************************************************');

3092: r_net_zero_diff net_batch_sum_cur%rowtype;
3093:
3094: begin
3095:
3096: hr_utility.trace('**************************************************');
3097: hr_utility.trace('LD Debugging Starts');
3098: hr_utility.trace('Entering GENERATE_LINES procedure');
3099:
3100: hr_utility.trace('Procedure IN Parameters Starts ');

Line 3097: hr_utility.trace('LD Debugging Starts');

3093:
3094: begin
3095:
3096: hr_utility.trace('**************************************************');
3097: hr_utility.trace('LD Debugging Starts');
3098: hr_utility.trace('Entering GENERATE_LINES procedure');
3099:
3100: hr_utility.trace('Procedure IN Parameters Starts ');
3101:

Line 3098: hr_utility.trace('Entering GENERATE_LINES procedure');

3094: begin
3095:
3096: hr_utility.trace('**************************************************');
3097: hr_utility.trace('LD Debugging Starts');
3098: hr_utility.trace('Entering GENERATE_LINES procedure');
3099:
3100: hr_utility.trace('Procedure IN Parameters Starts ');
3101:
3102: hr_utility.trace('p_person_id = '||p_person_id);

Line 3100: hr_utility.trace('Procedure IN Parameters Starts ');

3096: hr_utility.trace('**************************************************');
3097: hr_utility.trace('LD Debugging Starts');
3098: hr_utility.trace('Entering GENERATE_LINES procedure');
3099:
3100: hr_utility.trace('Procedure IN Parameters Starts ');
3101:
3102: hr_utility.trace('p_person_id = '||p_person_id);
3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);

Line 3102: hr_utility.trace('p_person_id = '||p_person_id);

3098: hr_utility.trace('Entering GENERATE_LINES procedure');
3099:
3100: hr_utility.trace('Procedure IN Parameters Starts ');
3101:
3102: hr_utility.trace('p_person_id = '||p_person_id);
3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);

Line 3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);

3099:
3100: hr_utility.trace('Procedure IN Parameters Starts ');
3101:
3102: hr_utility.trace('p_person_id = '||p_person_id);
3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);

Line 3104: hr_utility.trace('p_batch_name = '||p_batch_name);

3100: hr_utility.trace('Procedure IN Parameters Starts ');
3101:
3102: hr_utility.trace('p_person_id = '||p_person_id);
3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);

Line 3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);

3101:
3102: hr_utility.trace('p_person_id = '||p_person_id);
3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);

Line 3106: hr_utility.trace('p_run_id = '||p_run_id);

3102: hr_utility.trace('p_person_id = '||p_person_id);
3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);

Line 3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);

3103: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);

Line 3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);

3104: hr_utility.trace('p_batch_name = '||p_batch_name);
3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);

Line 3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);

3105: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);

Line 3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);

3106: hr_utility.trace('p_run_id = '||p_run_id);
3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);

Line 3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);

3107: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);

Line 3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);

3108: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);

Line 3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);

3109: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);

Line 3114: hr_utility.trace('p_time_out = '||p_time_out);

3110: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3118: hr_utility.trace('p_begin_date = '||p_begin_date);

Line 3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);

3111: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3118: hr_utility.trace('p_begin_date = '||p_begin_date);
3119:

Line 3116: hr_utility.trace('p_currency_code = '||p_currency_code);

3112: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3118: hr_utility.trace('p_begin_date = '||p_begin_date);
3119:
3120: hr_utility.trace('Procedure IN Parameters Ends ');

Line 3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);

3113: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3118: hr_utility.trace('p_begin_date = '||p_begin_date);
3119:
3120: hr_utility.trace('Procedure IN Parameters Ends ');
3121:

Line 3118: hr_utility.trace('p_begin_date = '||p_begin_date);

3114: hr_utility.trace('p_time_out = '||p_time_out);
3115: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3118: hr_utility.trace('p_begin_date = '||p_begin_date);
3119:
3120: hr_utility.trace('Procedure IN Parameters Ends ');
3121:
3122: g_error_api_path := '';

Line 3120: hr_utility.trace('Procedure IN Parameters Ends ');

3116: hr_utility.trace('p_currency_code = '||p_currency_code);
3117: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3118: hr_utility.trace('p_begin_date = '||p_begin_date);
3119:
3120: hr_utility.trace('Procedure IN Parameters Ends ');
3121:
3122: g_error_api_path := '';
3123: fnd_msg_pub.initialize;
3124: errbuf := '';

Line 3132: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);

3128: l_struc_num := psp_general.find_chart_of_accts(p_set_of_books_id,l_chart_of_accts);
3129:
3130: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3131:
3132: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3133: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3134:
3135: insert_adjustment_control(p_batch_name,
3136: p_batch_comments,

Line 3133: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);

3129:
3130: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3131:
3132: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3133: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3134:
3135: insert_adjustment_control(p_batch_name,
3136: p_batch_comments,
3137: l_return_status,

Line 3157: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 10');

3153: END IF;
3154:
3155: --Reversal Lines Generation
3156:
3157: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 10');
3158:
3159: insert into psp_adjustment_lines(adjustment_line_id,
3160: person_id,
3161: assignment_id,

Line 3265: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 10');

3261: g_error_api_path := 'No records found in reversal lines:'||g_error_api_path;
3262: raise NO_RECORDS_FOUND;
3263: end if;
3264:
3265: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 10');
3266:
3267: /***** Converted the following update statements into BULK update for R12 performance fixes (bug 4507892)
3268: UPDATE psp_distribution_lines_history
3269: SET adjustment_batch_name = p_batch_name

Line 3294: hr_utility.trace('Calling ORIG_LINE_ID_CUR cursor');

3290: End of comment for bug fix 4507892 *****/
3291:
3292: -- Introduced the following for bug fix 4507892
3293:
3294: hr_utility.trace('Calling ORIG_LINE_ID_CUR cursor');
3295: OPEN orig_line_id_cur;
3296: FETCH orig_line_id_cur BULK COLLECT INTO r_orig_lines.orig_line_id, r_orig_lines.orig_source_type;
3297: CLOSE orig_line_id_cur;
3298:

Line 3299: hr_utility.trace('r_orig_lines.orig_line_id.COUNT = '||r_orig_lines.orig_line_id.COUNT);

3295: OPEN orig_line_id_cur;
3296: FETCH orig_line_id_cur BULK COLLECT INTO r_orig_lines.orig_line_id, r_orig_lines.orig_source_type;
3297: CLOSE orig_line_id_cur;
3298:
3299: hr_utility.trace('r_orig_lines.orig_line_id.COUNT = '||r_orig_lines.orig_line_id.COUNT);
3300:
3301: FORALL I IN 1..r_orig_lines.orig_line_id.COUNT
3302: UPDATE psp_distribution_lines_history
3303: SET adjustment_batch_name = p_batch_name

Line 3323: hr_utility.trace('Completed BULK updates');

3319: r_orig_lines.orig_line_id.DELETE;
3320: r_orig_lines.orig_source_type.DELETE;
3321: -- End of changes for bug fix 4507892
3322:
3323: hr_utility.trace('Completed BULK updates');
3324:
3325: ----- Insert statement to generate new adj lines.
3326: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 20');
3327:

Line 3326: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 20');

3322:
3323: hr_utility.trace('Completed BULK updates');
3324:
3325: ----- Insert statement to generate new adj lines.
3326: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 20');
3327:
3328: insert into psp_adjustment_lines
3329: (adjustment_line_id,
3330: person_id,

Line 3453: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');

3449: DEST.original_line_flag = 'N';
3450: /* ORDER BY DEST.adj_set_number, DEST.line_number, LINES.time_period_id;
3451: --- order by ensures the delta amount will be posted to line of last time periods.
3452: */
3453: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');
3454:
3455: hr_utility.trace('g_precision = '||g_precision);
3456: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');
3457:

Line 3455: hr_utility.trace('g_precision = '||g_precision);

3451: --- order by ensures the delta amount will be posted to line of last time periods.
3452: */
3453: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');
3454:
3455: hr_utility.trace('g_precision = '||g_precision);
3456: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');
3457:
3458: open sline_ideal_amnt_matrix;
3459: fetch sline_ideal_amnt_matrix bulk collect into

Line 3456: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');

3452: */
3453: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');
3454:
3455: hr_utility.trace('g_precision = '||g_precision);
3456: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');
3457:
3458: open sline_ideal_amnt_matrix;
3459: fetch sline_ideal_amnt_matrix bulk collect into
3460: r_sline_ideal_amnt_matrix.adj_set_number,

Line 3469: hr_utility.trace('Updating the DISTRIBUTION_AMOUNT based on g_precision');

3465: r_sline_ideal_amnt_matrix.delta_sum,
3466: r_sline_ideal_amnt_matrix.adjustment_sline_id;
3467: close sline_ideal_amnt_matrix;
3468:
3469: hr_utility.trace('Updating the DISTRIBUTION_AMOUNT based on g_precision');
3470:
3471: update psp_adjustment_lines
3472: set distribution_amount = round(distribution_amount, g_precision)
3473: where original_line_flag = 'N'and

Line 3490: hr_utility.trace('Bulk Fetch ADJ_MATRIX values');

3486: r_sline_ideal_amnt_matrix.distribution_sum.delete;
3487: r_sline_ideal_amnt_matrix.delta_sum.delete;
3488: r_sline_ideal_amnt_matrix.adjustment_sline_id.delete;
3489:
3490: hr_utility.trace('Bulk Fetch ADJ_MATRIX values');
3491:
3492: open adj_matrix;
3493: fetch adj_matrix bulk collect into r_adj_matrix.adj_set_number,
3494: r_adj_matrix.time_period_id,

Line 3499: hr_utility.trace('Bulk Fetch SLINE_ACTUAL_AMNT_MATRIX values');

3495: r_adj_matrix.element_type_id,
3496: r_adj_matrix.distribution_sum;
3497: close adj_matrix;
3498:
3499: hr_utility.trace('Bulk Fetch SLINE_ACTUAL_AMNT_MATRIX values');
3500:
3501: open sline_actual_amnt_matrix;
3502: fetch sline_actual_amnt_matrix bulk collect into
3503: r_sline_actual_amnt_matrix.adj_set_number,

Line 3527: hr_utility.trace('Inside Loop1');

3523: then
3524: r_sline_actual_amnt_matrix.delta_sum(i) :=
3525: r_adj_matrix.distribution_sum(i) - r_sline_actual_amnt_matrix.distribution_sum(j);
3526:
3527: hr_utility.trace('Inside Loop1');
3528: hr_utility.trace('r_sline_actual_amnt_matrix.delta_sum(i) = '||r_sline_actual_amnt_matrix.delta_sum(i));
3529:
3530: end if;
3531: end loop;

Line 3528: hr_utility.trace('r_sline_actual_amnt_matrix.delta_sum(i) = '||r_sline_actual_amnt_matrix.delta_sum(i));

3524: r_sline_actual_amnt_matrix.delta_sum(i) :=
3525: r_adj_matrix.distribution_sum(i) - r_sline_actual_amnt_matrix.distribution_sum(j);
3526:
3527: hr_utility.trace('Inside Loop1');
3528: hr_utility.trace('r_sline_actual_amnt_matrix.delta_sum(i) = '||r_sline_actual_amnt_matrix.delta_sum(i));
3529:
3530: end if;
3531: end loop;
3532: end loop;

Line 3559: hr_utility.trace('Opening GET_DEST_DIFF cursor');

3555: -- to the last line in last time period of the element with max element_type_id
3556: --- there is no reason for this criteria in particular, but there should
3557: -- some convention to adjust.
3558:
3559: hr_utility.trace('Opening GET_DEST_DIFF cursor');
3560: open get_dest_diff;
3561: loop
3562: hr_utility.trace('LOOP2');
3563: fetch get_dest_diff into r_dest_diff;

Line 3562: hr_utility.trace('LOOP2');

3558:
3559: hr_utility.trace('Opening GET_DEST_DIFF cursor');
3560: open get_dest_diff;
3561: loop
3562: hr_utility.trace('LOOP2');
3563: fetch get_dest_diff into r_dest_diff;
3564: if get_dest_diff%notfound then
3565: close get_dest_diff;
3566: exit;

Line 3569: hr_utility.trace('r_dest_diff.amount = '||r_dest_diff.amount);

3565: close get_dest_diff;
3566: exit;
3567: end if;
3568:
3569: hr_utility.trace('r_dest_diff.amount = '||r_dest_diff.amount);
3570: hr_utility.trace('r_dest_diff.distribution_sum = '||r_dest_diff.distribution_sum);
3571:
3572: if r_dest_diff.amount <> r_dest_diff.distribution_sum then
3573: if (nvl(l_prev_adj_set,0) = 0 or l_prev_adj_set <> r_dest_diff.adj_set_number) then

Line 3570: hr_utility.trace('r_dest_diff.distribution_sum = '||r_dest_diff.distribution_sum);

3566: exit;
3567: end if;
3568:
3569: hr_utility.trace('r_dest_diff.amount = '||r_dest_diff.amount);
3570: hr_utility.trace('r_dest_diff.distribution_sum = '||r_dest_diff.distribution_sum);
3571:
3572: if r_dest_diff.amount <> r_dest_diff.distribution_sum then
3573: if (nvl(l_prev_adj_set,0) = 0 or l_prev_adj_set <> r_dest_diff.adj_set_number) then
3574: open get_max_element(r_dest_diff.adj_set_number, r_dest_diff.line_number);

Line 3613: hr_utility.trace('Opening CHECK_BATCH_INTEGRITY cursor for batch_name = '||p_batch_name);

3609: CLOSE net_batch_sum_cur;
3610:
3611: IF (r_net_zero_diff.amount <> 0) THEN
3612:
3613: hr_utility.trace('Opening CHECK_BATCH_INTEGRITY cursor for batch_name = '||p_batch_name);
3614:
3615: open check_batch_integrity(p_batch_name);
3616: fetch check_batch_integrity into l_integrity_count, l_element_type_id;
3617: close check_batch_integrity;

Line 3619: hr_utility.trace('l_integrity_count = '||l_integrity_count);

3615: open check_batch_integrity(p_batch_name);
3616: fetch check_batch_integrity into l_integrity_count, l_element_type_id;
3617: close check_batch_integrity;
3618:
3619: hr_utility.trace('l_integrity_count = '||l_integrity_count);
3620: hr_utility.trace('l_element_type_id = '||l_element_type_id);
3621:
3622: if l_integrity_count > 0 then
3623: --- shows only the first offending element i.e net amount not zero.

Line 3620: hr_utility.trace('l_element_type_id = '||l_element_type_id);

3616: fetch check_batch_integrity into l_integrity_count, l_element_type_id;
3617: close check_batch_integrity;
3618:
3619: hr_utility.trace('l_integrity_count = '||l_integrity_count);
3620: hr_utility.trace('l_element_type_id = '||l_element_type_id);
3621:
3622: if l_integrity_count > 0 then
3623: --- shows only the first offending element i.e net amount not zero.
3624: open get_element_name;

Line 3628: hr_utility.trace('l_element_name = '||l_element_name);

3624: open get_element_name;
3625: fetch get_element_name into l_element_name;
3626: close get_element_name;
3627:
3628: hr_utility.trace('l_element_name = '||l_element_name);
3629: hr_utility.trace('Before Raise error');
3630:
3631: raise batch_net_not_zero;
3632:

Line 3629: hr_utility.trace('Before Raise error');

3625: fetch get_element_name into l_element_name;
3626: close get_element_name;
3627:
3628: hr_utility.trace('l_element_name = '||l_element_name);
3629: hr_utility.trace('Before Raise error');
3630:
3631: raise batch_net_not_zero;
3632:
3633: hr_utility.trace('After Raise error');

Line 3633: hr_utility.trace('After Raise error');

3629: hr_utility.trace('Before Raise error');
3630:
3631: raise batch_net_not_zero;
3632:
3633: hr_utility.trace('After Raise error');
3634: end if;
3635:
3636: END IF; -- Added If - End If for bug 6634876
3637:

Line 3978: hr_utility.trace('Procedure OUT parameters :-') ;

3974: else
3975: raise workflow_failed;
3976: end if;
3977:
3978: hr_utility.trace('Procedure OUT parameters :-') ;
3979:
3980: hr_utility.trace('OUT errbuf = '||errbuf) ;
3981: hr_utility.trace('OUT retcode = '||retcode) ;
3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;

Line 3980: hr_utility.trace('OUT errbuf = '||errbuf) ;

3976: end if;
3977:
3978: hr_utility.trace('Procedure OUT parameters :-') ;
3979:
3980: hr_utility.trace('OUT errbuf = '||errbuf) ;
3981: hr_utility.trace('OUT retcode = '||retcode) ;
3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3984:

Line 3981: hr_utility.trace('OUT retcode = '||retcode) ;

3977:
3978: hr_utility.trace('Procedure OUT parameters :-') ;
3979:
3980: hr_utility.trace('OUT errbuf = '||errbuf) ;
3981: hr_utility.trace('OUT retcode = '||retcode) ;
3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3984:
3985: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;

Line 3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;

3978: hr_utility.trace('Procedure OUT parameters :-') ;
3979:
3980: hr_utility.trace('OUT errbuf = '||errbuf) ;
3981: hr_utility.trace('OUT retcode = '||retcode) ;
3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3984:
3985: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3986: hr_utility.trace('**************************************************');

Line 3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;

3979:
3980: hr_utility.trace('OUT errbuf = '||errbuf) ;
3981: hr_utility.trace('OUT retcode = '||retcode) ;
3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3984:
3985: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3986: hr_utility.trace('**************************************************');
3987:

Line 3985: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;

3981: hr_utility.trace('OUT retcode = '||retcode) ;
3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3984:
3985: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3986: hr_utility.trace('**************************************************');
3987:
3988: EXCEPTION
3989:

Line 3986: hr_utility.trace('**************************************************');

3982: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3983: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3984:
3985: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3986: hr_utility.trace('**************************************************');
3987:
3988: EXCEPTION
3989:
3990: WHEN Inv_autopop_element THEN

Line 4024: hr_utility.trace('EXCEPTION');

4020: rollback;
4021: errbuf := l_element_name;
4022: retcode := 1;
4023:
4024: hr_utility.trace('EXCEPTION');
4025: hr_utility.trace('EXC errbuf = '||errbuf) ;
4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;

Line 4025: hr_utility.trace('EXC errbuf = '||errbuf) ;

4021: errbuf := l_element_name;
4022: retcode := 1;
4023:
4024: hr_utility.trace('EXCEPTION');
4025: hr_utility.trace('EXC errbuf = '||errbuf) ;
4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;

Line 4026: hr_utility.trace('EXC retcode = '||retcode) ;

4022: retcode := 1;
4023:
4024: hr_utility.trace('EXCEPTION');
4025: hr_utility.trace('EXC errbuf = '||errbuf) ;
4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;

Line 4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;

4023:
4024: hr_utility.trace('EXCEPTION');
4025: hr_utility.trace('EXC errbuf = '||errbuf) ;
4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4031: hr_utility.trace('**************************************************');

Line 4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;

4024: hr_utility.trace('EXCEPTION');
4025: hr_utility.trace('EXC errbuf = '||errbuf) ;
4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4031: hr_utility.trace('**************************************************');
4032:

Line 4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;

4025: hr_utility.trace('EXC errbuf = '||errbuf) ;
4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4031: hr_utility.trace('**************************************************');
4032:
4033: WHEN OTHERS THEN

Line 4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;

4026: hr_utility.trace('EXC retcode = '||retcode) ;
4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4031: hr_utility.trace('**************************************************');
4032:
4033: WHEN OTHERS THEN
4034: rollback;

Line 4031: hr_utility.trace('**************************************************');

4027: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4028: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4029: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4030: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4031: hr_utility.trace('**************************************************');
4032:
4033: WHEN OTHERS THEN
4034: rollback;
4035: /***** Commented the following DELETE statements for the following reasons as part of R12 performance fixes (bug 4507892)