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.

[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on HR_UTILITY

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

3083: r_net_zero_diff net_batch_sum_cur%rowtype;
3084:
3085: begin
3086:
3087: hr_utility.trace('**************************************************');
3088: hr_utility.trace('LD Debugging Starts');
3089: hr_utility.trace('Entering GENERATE_LINES procedure');
3090:
3091: hr_utility.trace('Procedure IN Parameters Starts ');

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

3084:
3085: begin
3086:
3087: hr_utility.trace('**************************************************');
3088: hr_utility.trace('LD Debugging Starts');
3089: hr_utility.trace('Entering GENERATE_LINES procedure');
3090:
3091: hr_utility.trace('Procedure IN Parameters Starts ');
3092:

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

3085: begin
3086:
3087: hr_utility.trace('**************************************************');
3088: hr_utility.trace('LD Debugging Starts');
3089: hr_utility.trace('Entering GENERATE_LINES procedure');
3090:
3091: hr_utility.trace('Procedure IN Parameters Starts ');
3092:
3093: hr_utility.trace('p_person_id = '||p_person_id);

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

3087: hr_utility.trace('**************************************************');
3088: hr_utility.trace('LD Debugging Starts');
3089: hr_utility.trace('Entering GENERATE_LINES procedure');
3090:
3091: hr_utility.trace('Procedure IN Parameters Starts ');
3092:
3093: hr_utility.trace('p_person_id = '||p_person_id);
3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);

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

3089: hr_utility.trace('Entering GENERATE_LINES procedure');
3090:
3091: hr_utility.trace('Procedure IN Parameters Starts ');
3092:
3093: hr_utility.trace('p_person_id = '||p_person_id);
3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);

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

3090:
3091: hr_utility.trace('Procedure IN Parameters Starts ');
3092:
3093: hr_utility.trace('p_person_id = '||p_person_id);
3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);

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

3091: hr_utility.trace('Procedure IN Parameters Starts ');
3092:
3093: hr_utility.trace('p_person_id = '||p_person_id);
3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);

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

3092:
3093: hr_utility.trace('p_person_id = '||p_person_id);
3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);

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

3093: hr_utility.trace('p_person_id = '||p_person_id);
3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);

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

3094: hr_utility.trace('p_assignment_id = '||p_assignment_id);
3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);

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

3095: hr_utility.trace('p_batch_name = '||p_batch_name);
3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);

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

3096: hr_utility.trace('p_batch_comments = '||p_batch_comments);
3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);

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

3097: hr_utility.trace('p_run_id = '||p_run_id);
3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);

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

3098: hr_utility.trace('p_gl_posting_override_date = '||p_gl_posting_override_date);
3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);

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

3099: hr_utility.trace('p_distribution_start_date = '||p_distribution_start_date);
3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);

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

3100: hr_utility.trace('p_distribution_end_date = '||p_distribution_end_date);
3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);

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

3101: hr_utility.trace('p_business_group_id = '||p_business_group_id);
3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3109: hr_utility.trace('p_begin_date = '||p_begin_date);

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

3102: hr_utility.trace('p_set_of_books_id = '||p_set_of_books_id);
3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3109: hr_utility.trace('p_begin_date = '||p_begin_date);
3110:

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

3103: hr_utility.trace('p_employee_full_name = '||p_employee_full_name);
3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3109: hr_utility.trace('p_begin_date = '||p_begin_date);
3110:
3111: hr_utility.trace('Procedure IN Parameters Ends ');

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

3104: hr_utility.trace('p_assignment_number = '||p_assignment_number);
3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3109: hr_utility.trace('p_begin_date = '||p_begin_date);
3110:
3111: hr_utility.trace('Procedure IN Parameters Ends ');
3112:

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

3105: hr_utility.trace('p_time_out = '||p_time_out);
3106: hr_utility.trace('p_adjust_by = '||p_adjust_by);
3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3109: hr_utility.trace('p_begin_date = '||p_begin_date);
3110:
3111: hr_utility.trace('Procedure IN Parameters Ends ');
3112:
3113: g_error_api_path := '';

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

3107: hr_utility.trace('p_currency_code = '||p_currency_code);
3108: hr_utility.trace('p_defer_autopop_param = '||p_defer_autopop_param);
3109: hr_utility.trace('p_begin_date = '||p_begin_date);
3110:
3111: hr_utility.trace('Procedure IN Parameters Ends ');
3112:
3113: g_error_api_path := '';
3114: fnd_msg_pub.initialize;
3115: errbuf := '';

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

3119: l_struc_num := psp_general.find_chart_of_accts(p_set_of_books_id,l_chart_of_accts);
3120:
3121: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3122:
3123: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3124: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3125:
3126: insert_adjustment_control(p_batch_name,
3127: p_batch_comments,

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

3120:
3121: select psp_payroll_controls_s.nextval into l_payroll_control_id from dual;
3122:
3123: hr_utility.trace('l_payroll_control_id = '||l_payroll_control_id);
3124: hr_utility.trace('Inserting into PSP_ADJUSTMENT_CONTROL_TABLE : batch = '||p_batch_name);
3125:
3126: insert_adjustment_control(p_batch_name,
3127: p_batch_comments,
3128: l_return_status,

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

3144: END IF;
3145:
3146: --Reversal Lines Generation
3147:
3148: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 10');
3149:
3150: insert into psp_adjustment_lines(adjustment_line_id,
3151: person_id,
3152: assignment_id,

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

3252: g_error_api_path := 'No records found in reversal lines:'||g_error_api_path;
3253: raise NO_RECORDS_FOUND;
3254: end if;
3255:
3256: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 10');
3257:
3258: /***** Converted the following update statements into BULK update for R12 performance fixes (bug 4507892)
3259: UPDATE psp_distribution_lines_history
3260: SET adjustment_batch_name = p_batch_name

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

3281: End of comment for bug fix 4507892 *****/
3282:
3283: -- Introduced the following for bug fix 4507892
3284:
3285: hr_utility.trace('Calling ORIG_LINE_ID_CUR cursor');
3286: OPEN orig_line_id_cur;
3287: FETCH orig_line_id_cur BULK COLLECT INTO r_orig_lines.orig_line_id, r_orig_lines.orig_source_type;
3288: CLOSE orig_line_id_cur;
3289:

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

3286: OPEN orig_line_id_cur;
3287: FETCH orig_line_id_cur BULK COLLECT INTO r_orig_lines.orig_line_id, r_orig_lines.orig_source_type;
3288: CLOSE orig_line_id_cur;
3289:
3290: hr_utility.trace('r_orig_lines.orig_line_id.COUNT = '||r_orig_lines.orig_line_id.COUNT);
3291:
3292: FORALL I IN 1..r_orig_lines.orig_line_id.COUNT
3293: UPDATE psp_distribution_lines_history
3294: SET adjustment_batch_name = p_batch_name

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

3310: r_orig_lines.orig_line_id.DELETE;
3311: r_orig_lines.orig_source_type.DELETE;
3312: -- End of changes for bug fix 4507892
3313:
3314: hr_utility.trace('Completed BULK updates');
3315:
3316: ----- Insert statement to generate new adj lines.
3317: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 20');
3318:

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

3313:
3314: hr_utility.trace('Completed BULK updates');
3315:
3316: ----- Insert statement to generate new adj lines.
3317: hr_utility.trace('Inserting into PSP_ADJUSTMENT_LINES - 20');
3318:
3319: insert into psp_adjustment_lines
3320: (adjustment_line_id,
3321: person_id,

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

3440: DEST.original_line_flag = 'N';
3441: /* ORDER BY DEST.adj_set_number, DEST.line_number, LINES.time_period_id;
3442: --- order by ensures the delta amount will be posted to line of last time periods.
3443: */
3444: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');
3445:
3446: hr_utility.trace('g_precision = '||g_precision);
3447: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');
3448:

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

3442: --- order by ensures the delta amount will be posted to line of last time periods.
3443: */
3444: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');
3445:
3446: hr_utility.trace('g_precision = '||g_precision);
3447: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');
3448:
3449: open sline_ideal_amnt_matrix;
3450: fetch sline_ideal_amnt_matrix bulk collect into

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

3443: */
3444: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 20');
3445:
3446: hr_utility.trace('g_precision = '||g_precision);
3447: hr_utility.trace('Bulk Fetch SLINE_IDEAL_AMNT_MATRIX values');
3448:
3449: open sline_ideal_amnt_matrix;
3450: fetch sline_ideal_amnt_matrix bulk collect into
3451: r_sline_ideal_amnt_matrix.adj_set_number,

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

3456: r_sline_ideal_amnt_matrix.delta_sum,
3457: r_sline_ideal_amnt_matrix.adjustment_sline_id;
3458: close sline_ideal_amnt_matrix;
3459:
3460: hr_utility.trace('Updating the DISTRIBUTION_AMOUNT based on g_precision');
3461:
3462: update psp_adjustment_lines
3463: set distribution_amount = round(distribution_amount, g_precision)
3464: where original_line_flag = 'N'and

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

3477: r_sline_ideal_amnt_matrix.distribution_sum.delete;
3478: r_sline_ideal_amnt_matrix.delta_sum.delete;
3479: r_sline_ideal_amnt_matrix.adjustment_sline_id.delete;
3480:
3481: hr_utility.trace('Bulk Fetch ADJ_MATRIX values');
3482:
3483: open adj_matrix;
3484: fetch adj_matrix bulk collect into r_adj_matrix.adj_set_number,
3485: r_adj_matrix.time_period_id,

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

3486: r_adj_matrix.element_type_id,
3487: r_adj_matrix.distribution_sum;
3488: close adj_matrix;
3489:
3490: hr_utility.trace('Bulk Fetch SLINE_ACTUAL_AMNT_MATRIX values');
3491:
3492: open sline_actual_amnt_matrix;
3493: fetch sline_actual_amnt_matrix bulk collect into
3494: r_sline_actual_amnt_matrix.adj_set_number,

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

3514: then
3515: r_sline_actual_amnt_matrix.delta_sum(i) :=
3516: r_adj_matrix.distribution_sum(i) - r_sline_actual_amnt_matrix.distribution_sum(j);
3517:
3518: hr_utility.trace('Inside Loop1');
3519: hr_utility.trace('r_sline_actual_amnt_matrix.delta_sum(i) = '||r_sline_actual_amnt_matrix.delta_sum(i));
3520:
3521: end if;
3522: end loop;

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

3515: r_sline_actual_amnt_matrix.delta_sum(i) :=
3516: r_adj_matrix.distribution_sum(i) - r_sline_actual_amnt_matrix.distribution_sum(j);
3517:
3518: hr_utility.trace('Inside Loop1');
3519: hr_utility.trace('r_sline_actual_amnt_matrix.delta_sum(i) = '||r_sline_actual_amnt_matrix.delta_sum(i));
3520:
3521: end if;
3522: end loop;
3523: end loop;

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

3546: -- to the last line in last time period of the element with max element_type_id
3547: --- there is no reason for this criteria in particular, but there should
3548: -- some convention to adjust.
3549:
3550: hr_utility.trace('Opening GET_DEST_DIFF cursor');
3551: open get_dest_diff;
3552: loop
3553: hr_utility.trace('LOOP2');
3554: fetch get_dest_diff into r_dest_diff;

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

3549:
3550: hr_utility.trace('Opening GET_DEST_DIFF cursor');
3551: open get_dest_diff;
3552: loop
3553: hr_utility.trace('LOOP2');
3554: fetch get_dest_diff into r_dest_diff;
3555: if get_dest_diff%notfound then
3556: close get_dest_diff;
3557: exit;

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

3556: close get_dest_diff;
3557: exit;
3558: end if;
3559:
3560: hr_utility.trace('r_dest_diff.amount = '||r_dest_diff.amount);
3561: hr_utility.trace('r_dest_diff.distribution_sum = '||r_dest_diff.distribution_sum);
3562:
3563: if r_dest_diff.amount <> r_dest_diff.distribution_sum then
3564: if (nvl(l_prev_adj_set,0) = 0 or l_prev_adj_set <> r_dest_diff.adj_set_number) then

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

3557: exit;
3558: end if;
3559:
3560: hr_utility.trace('r_dest_diff.amount = '||r_dest_diff.amount);
3561: hr_utility.trace('r_dest_diff.distribution_sum = '||r_dest_diff.distribution_sum);
3562:
3563: if r_dest_diff.amount <> r_dest_diff.distribution_sum then
3564: if (nvl(l_prev_adj_set,0) = 0 or l_prev_adj_set <> r_dest_diff.adj_set_number) then
3565: open get_max_element(r_dest_diff.adj_set_number, r_dest_diff.line_number);

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

3600: CLOSE net_batch_sum_cur;
3601:
3602: IF (r_net_zero_diff.amount <> 0) THEN
3603:
3604: hr_utility.trace('Opening CHECK_BATCH_INTEGRITY cursor for batch_name = '||p_batch_name);
3605:
3606: open check_batch_integrity(p_batch_name);
3607: fetch check_batch_integrity into l_integrity_count, l_element_type_id;
3608: close check_batch_integrity;

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

3606: open check_batch_integrity(p_batch_name);
3607: fetch check_batch_integrity into l_integrity_count, l_element_type_id;
3608: close check_batch_integrity;
3609:
3610: hr_utility.trace('l_integrity_count = '||l_integrity_count);
3611: hr_utility.trace('l_element_type_id = '||l_element_type_id);
3612:
3613: if l_integrity_count > 0 then
3614: --- shows only the first offending element i.e net amount not zero.

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

3607: fetch check_batch_integrity into l_integrity_count, l_element_type_id;
3608: close check_batch_integrity;
3609:
3610: hr_utility.trace('l_integrity_count = '||l_integrity_count);
3611: hr_utility.trace('l_element_type_id = '||l_element_type_id);
3612:
3613: if l_integrity_count > 0 then
3614: --- shows only the first offending element i.e net amount not zero.
3615: open get_element_name;

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

3615: open get_element_name;
3616: fetch get_element_name into l_element_name;
3617: close get_element_name;
3618:
3619: hr_utility.trace('l_element_name = '||l_element_name);
3620: hr_utility.trace('Before Raise error');
3621:
3622: raise batch_net_not_zero;
3623:

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

3616: fetch get_element_name into l_element_name;
3617: close get_element_name;
3618:
3619: hr_utility.trace('l_element_name = '||l_element_name);
3620: hr_utility.trace('Before Raise error');
3621:
3622: raise batch_net_not_zero;
3623:
3624: hr_utility.trace('After Raise error');

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

3620: hr_utility.trace('Before Raise error');
3621:
3622: raise batch_net_not_zero;
3623:
3624: hr_utility.trace('After Raise error');
3625: end if;
3626:
3627: END IF; -- Added If - End If for bug 6634876
3628:

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

3965: else
3966: raise workflow_failed;
3967: end if;
3968:
3969: hr_utility.trace('Procedure OUT parameters :-') ;
3970:
3971: hr_utility.trace('OUT errbuf = '||errbuf) ;
3972: hr_utility.trace('OUT retcode = '||retcode) ;
3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;

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

3967: end if;
3968:
3969: hr_utility.trace('Procedure OUT parameters :-') ;
3970:
3971: hr_utility.trace('OUT errbuf = '||errbuf) ;
3972: hr_utility.trace('OUT retcode = '||retcode) ;
3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3974: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3975:

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

3968:
3969: hr_utility.trace('Procedure OUT parameters :-') ;
3970:
3971: hr_utility.trace('OUT errbuf = '||errbuf) ;
3972: hr_utility.trace('OUT retcode = '||retcode) ;
3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3974: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3975:
3976: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;

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

3969: hr_utility.trace('Procedure OUT parameters :-') ;
3970:
3971: hr_utility.trace('OUT errbuf = '||errbuf) ;
3972: hr_utility.trace('OUT retcode = '||retcode) ;
3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3974: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3975:
3976: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3977: hr_utility.trace('**************************************************');

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

3970:
3971: hr_utility.trace('OUT errbuf = '||errbuf) ;
3972: hr_utility.trace('OUT retcode = '||retcode) ;
3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3974: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3975:
3976: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3977: hr_utility.trace('**************************************************');
3978:

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

3972: hr_utility.trace('OUT retcode = '||retcode) ;
3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3974: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3975:
3976: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3977: hr_utility.trace('**************************************************');
3978:
3979: EXCEPTION
3980:

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

3973: hr_utility.trace('OUT p_adjustment_line_id = '||p_adjustment_line_id) ;
3974: hr_utility.trace('OUT p_element_status = '||p_element_status) ;
3975:
3976: hr_utility.trace('EXIT Leaving GENERATE_LINES procedure') ;
3977: hr_utility.trace('**************************************************');
3978:
3979: EXCEPTION
3980:
3981: WHEN Inv_autopop_element THEN

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

4011: rollback;
4012: errbuf := l_element_name;
4013: retcode := 1;
4014:
4015: hr_utility.trace('EXCEPTION');
4016: hr_utility.trace('EXC errbuf = '||errbuf) ;
4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;

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

4012: errbuf := l_element_name;
4013: retcode := 1;
4014:
4015: hr_utility.trace('EXCEPTION');
4016: hr_utility.trace('EXC errbuf = '||errbuf) ;
4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;

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

4013: retcode := 1;
4014:
4015: hr_utility.trace('EXCEPTION');
4016: hr_utility.trace('EXC errbuf = '||errbuf) ;
4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4021: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;

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

4014:
4015: hr_utility.trace('EXCEPTION');
4016: hr_utility.trace('EXC errbuf = '||errbuf) ;
4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4021: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4022: hr_utility.trace('**************************************************');

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

4015: hr_utility.trace('EXCEPTION');
4016: hr_utility.trace('EXC errbuf = '||errbuf) ;
4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4021: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4022: hr_utility.trace('**************************************************');
4023:

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

4016: hr_utility.trace('EXC errbuf = '||errbuf) ;
4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4021: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4022: hr_utility.trace('**************************************************');
4023:
4024: WHEN OTHERS THEN

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

4017: hr_utility.trace('EXC retcode = '||retcode) ;
4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4021: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4022: hr_utility.trace('**************************************************');
4023:
4024: WHEN OTHERS THEN
4025: rollback;

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

4018: hr_utility.trace('EXC p_adjustment_line_id = '||p_adjustment_line_id) ;
4019: hr_utility.trace('EXC p_element_status = '||p_element_status) ;
4020: hr_utility.trace('EXC l_element_name = '||l_element_name) ;
4021: hr_utility.trace('EXCEPTION Leaving GENERATE_LINES procedure') ;
4022: hr_utility.trace('**************************************************');
4023:
4024: WHEN OTHERS THEN
4025: rollback;
4026: /***** Commented the following DELETE statements for the following reasons as part of R12 performance fixes (bug 4507892)