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.PAY_KR_WG_PKG dependencies on HR_UTILITY

Line 15: g_debug boolean := hr_utility.debug_enabled;

11: g_change_eff_date_NTLA DATE := to_date('2006/04/28', 'YYYY/MM/DD');
12: g_excpn_court_order_flag VARCHAR2(1) := 'N';
13: --
14:
15: g_debug boolean := hr_utility.debug_enabled;
16: -----------------------------------------------------------------------------------------------
17: -- Function calc_wage_garnishment. Function with added parameter o_adjusted_amount.
18: -- This function calls another version with the parameter p_attachment_sequence_no
19: -----------------------------------------------------------------------------------------------

Line 55: hr_utility.set_location('Got the attachment seq no : '||l_attachment_seq_no, 10);

51: l_attachment_seq_no := pay_kr_wg_report_pkg.get_attach_seq_no(p_element_entry_id);
52:
53:
54: if g_debug then
55: hr_utility.set_location('Got the attachment seq no : '||l_attachment_seq_no, 10);
56: end if;
57:
58: l_return := calc_wage_garnishment( p_assignment_id => p_assignment_id ,
59: p_assignment_action_id => p_assignment_action_id ,

Line 415: hr_utility.set_location('Previous Payout Date is : '||to_char(l_prev_payout_date), 1);

411: l_prev_payout_date := l_prev_payout_date_bal_adj;
412:
413: END IF;
414: if g_debug then
415: hr_utility.set_location('Previous Payout Date is : '||to_char(l_prev_payout_date), 1);
416: end if;
417:
418: RETURN l_prev_payout_date;
419:

Line 423: hr_utility.set_location('Error in get_previous_payout_date. Message : '||substr(sqlerrm,1,200), -10);

419:
420: EXCEPTION
421: WHEN OTHERS THEN
422: if g_debug then
423: hr_utility.set_location('Error in get_previous_payout_date. Message : '||substr(sqlerrm,1,200), -10);
424: end if;
425: RAISE;
426:
427: END get_previous_payout_date;

Line 461: hr_utility.trace('first attempt');

457:
458: -- Bug 3223825
459: IF g_wg_deduction_bal_id IS NULL THEN
460: IF g_debug THEN
461: hr_utility.trace('first attempt');
462: END IF;
463:
464: OPEN csr_defined_bal_id('WG Deductions', '_ASG_WG_ITD');
465: FETCH csr_defined_bal_id INTO l_defined_balance_id;

Line 472: hr_utility.trace('sec attempt');

468: g_wg_deduction_bal_id:=l_defined_balance_id;
469: ELSE
470:
471: IF g_debug THEN
472: hr_utility.trace('sec attempt');
473: END IF;
474:
475: l_defined_balance_id := g_wg_deduction_bal_id;
476:

Line 482: hr_utility.trace('l_value wg deduction ' || l_value) ;

478: -- Bug 3435686
479: l_value:=pay_balance_pkg.get_value (l_defined_balance_id, p_assignment_action_id);
480:
481: if g_debug then
482: hr_utility.trace('l_value wg deduction ' || l_value) ;
483: end if;
484:
485: IF l_value > 0 THEN
486:

Line 493: hr_utility.trace('first attempt');

489: ELSE
490:
491: IF g_wg_interest_bal_id is NULL THEN
492: IF g_debug THEN
493: hr_utility.trace('first attempt');
494: END IF;
495:
496: OPEN csr_defined_bal_id('WG Paid Interest', '_ASG_WG_ITD');
497: FETCH csr_defined_bal_id INTO l_defined_balance_id;

Line 504: hr_utility.trace('sec attempt');

500: g_wg_interest_bal_id := l_defined_balance_id;
501:
502: ELSE
503: IF g_debug THEN
504: hr_utility.trace('sec attempt');
505: end if;
506:
507: l_defined_balance_id:=g_wg_interest_bal_id;
508:

Line 514: hr_utility.trace('l_value wg paid interest ' || l_value);

510: -- Bug 3435686
511: l_value:=pay_balance_pkg.get_value (l_defined_balance_id, p_assignment_action_id);
512:
513: IF g_debug THEN
514: hr_utility.trace('l_value wg paid interest ' || l_value);
515: END IF;
516:
517: IF l_value > 0 THEN
518: RETURN FALSE;

Line 528: hr_utility.set_location('Error in Processing First Time. Message : '||substr(sqlerrm,1,200), -10);

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: if g_debug then
528: hr_utility.set_location('Error in Processing First Time. Message : '||substr(sqlerrm,1,200), -10);
529: end if;
530: RAISE;
531:
532: END processing_first_time;

Line 728: hr_utility.set_location('Error in Interest Validation. Message : '||substr(sqlerrm,1,200), -20);

724:
725: EXCEPTION
726: WHEN OTHERS THEN
727: if g_debug then
728: hr_utility.set_location('Error in Interest Validation. Message : '||substr(sqlerrm,1,200), -20);
729: end if;
730: RAISE;
731:
732: END validate_interest_bands;

Line 786: hr_utility.trace('l_count_court_orders '||l_count_court_orders);

782: ELSE
783: RETURN 'N';
784: END IF;
785: if g_debug then
786: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
787: hr_utility.trace('p_assignment_id '||p_assignment_id);
788: hr_utility.trace('l_provisional_date '||l_provisional_date);
789: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
790: end if;

Line 787: hr_utility.trace('p_assignment_id '||p_assignment_id);

783: RETURN 'N';
784: END IF;
785: if g_debug then
786: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
787: hr_utility.trace('p_assignment_id '||p_assignment_id);
788: hr_utility.trace('l_provisional_date '||l_provisional_date);
789: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
790: end if;
791: END check_exception_case;

Line 788: hr_utility.trace('l_provisional_date '||l_provisional_date);

784: END IF;
785: if g_debug then
786: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
787: hr_utility.trace('p_assignment_id '||p_assignment_id);
788: hr_utility.trace('l_provisional_date '||l_provisional_date);
789: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
790: end if;
791: END check_exception_case;
792:

Line 789: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);

785: if g_debug then
786: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
787: hr_utility.trace('p_assignment_id '||p_assignment_id);
788: hr_utility.trace('l_provisional_date '||l_provisional_date);
789: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
790: end if;
791: END check_exception_case;
792:
793: --------------------------------------------------------------------------------------

Line 838: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);

834:
835: IF upper(i.name) = 'ATTACHMENT SEQ NO' THEN
836: g_court_orders(l_court_order_no).attachment_sequence_no := i.screen_entry_value;
837: if g_debug then
838: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);
839: end if;
840: -------------------------------------------------------------------
841: -- RAISE error in attachment sequence number has already been used.
842: -- This check will be run only once for a court order.

Line 910: hr_utility.trace('obligation_release_processed '||g_court_orders(l_court_order_no).obligation_release_processed);

906: -- to redistribute the Obligation Release amount only if at least one unprocessed
907: -- Obligation Released court order is found.
908: --
909: if g_debug then
910: hr_utility.trace('obligation_release_processed '||g_court_orders(l_court_order_no).obligation_release_processed);
911: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);
912: end if;
913: --
914: IF g_court_orders(l_court_order_no).obligation_release_processed = 'N' THEN

Line 911: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);

907: -- Obligation Released court order is found.
908: --
909: if g_debug then
910: hr_utility.trace('obligation_release_processed '||g_court_orders(l_court_order_no).obligation_release_processed);
911: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);
912: end if;
913: --
914: IF g_court_orders(l_court_order_no).obligation_release_processed = 'N' THEN
915: c_redistribution_required := 'Y';

Line 942: hr_utility.set_location('num of court orders which received obligation_release'||l_count_oblig_rel_before,310);

938: ELSE
939: l_count_oblig_rel_before := l_count_oblig_rel_before + 1;
940: END IF;
941: if g_debug then
942: hr_utility.set_location('num of court orders which received obligation_release'||l_count_oblig_rel_before,310);
943: end if;
944: END IF;
945: --
946: -- Changes for Bug 2708036

Line 994: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||

990: validate_interest_bands(l_court_order_no);
991:
992: l_interest_loaded := TRUE;
993: if g_debug then
994: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
995:
996: ' Band 1 : '||
997: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base1)||
998: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate1)||

Line 1003: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||

999: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date1)||
1000: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date1),11);
1001:
1002:
1003: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1004:
1005: ' Band 2 : '||
1006: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base2)||
1007: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate2)||

Line 1011: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||

1007: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate2)||
1008: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date2)||
1009: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date2),21);
1010:
1011: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1012: ' Band 3 : '||
1013: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base3)||
1014: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate3)||
1015: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date3)||

Line 1018: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||

1014: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate3)||
1015: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date3)||
1016: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date3),31);
1017:
1018: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1019: ' Band 4 : '||
1020: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base4)||
1021: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate4)||
1022: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date4)||

Line 1025: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||

1021: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate4)||
1022: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date4)||
1023: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date4),41);
1024:
1025: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1026: ' Band 5 : '||
1027: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base5)||
1028: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate5)||
1029: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date5)||

Line 1053: hr_utility.trace('l_count_oblig_rel_before '||l_count_oblig_rel_before);

1049: g_excpn_court_order_flag :='Y';
1050: END IF;
1051: END IF;
1052: if g_debug then
1053: hr_utility.trace('l_count_oblig_rel_before '||l_count_oblig_rel_before);
1054: hr_utility.trace('l_count_oblig_rel_after '||l_count_oblig_rel_after);
1055: end if;
1056: --
1057: EXCEPTION

Line 1054: hr_utility.trace('l_count_oblig_rel_after '||l_count_oblig_rel_after);

1050: END IF;
1051: END IF;
1052: if g_debug then
1053: hr_utility.trace('l_count_oblig_rel_before '||l_count_oblig_rel_before);
1054: hr_utility.trace('l_count_oblig_rel_after '||l_count_oblig_rel_after);
1055: end if;
1056: --
1057: EXCEPTION
1058: WHEN OTHERS THEN

Line 1060: hr_utility.set_location('Error in loading court orders. Message : '||substr(sqlerrm,1,200), -30);

1056: --
1057: EXCEPTION
1058: WHEN OTHERS THEN
1059: if g_debug then
1060: hr_utility.set_location('Error in loading court orders. Message : '||substr(sqlerrm,1,200), -30);
1061: end if;
1062: RAISE;
1063:
1064: END load_court_orders;

Line 1085: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );

1081: l_deductable_amount NUMBER := 0;
1082:
1083: BEGIN
1084: if g_debug then
1085: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1086: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1087: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1088: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1089: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );

Line 1086: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );

1082:
1083: BEGIN
1084: if g_debug then
1085: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1086: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1087: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1088: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1089: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1090: end if;

Line 1087: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );

1083: BEGIN
1084: if g_debug then
1085: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1086: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1087: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1088: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1089: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1090: end if;
1091:

Line 1088: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );

1084: if g_debug then
1085: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1086: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1087: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1088: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1089: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1090: end if;
1091:
1092: l_old_rule_earnings := p_net_earnings * g_max_attachable_earnings;

Line 1089: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );

1085: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1086: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1087: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1088: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1089: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1090: end if;
1091:
1092: l_old_rule_earnings := p_net_earnings * g_max_attachable_earnings;
1093: --

Line 1118: hr_utility.trace('calc_net_earnings : l_deductable_amount'||to_char(l_deductable_amount) );

1114: l_deductable_amount := greatest(l_deductable_amount - p_wg_deductions_mtd, 0);
1115: END IF;
1116: --
1117: if g_debug then
1118: hr_utility.trace('calc_net_earnings : l_deductable_amount'||to_char(l_deductable_amount) );
1119: end if;
1120: return l_deductable_amount;
1121: ELSE --Before 28-JUL-2005
1122: if g_debug then

Line 1123: hr_utility.trace('calc_net_earnings : l_old_rule_earnings'||to_char(l_old_rule_earnings) );

1119: end if;
1120: return l_deductable_amount;
1121: ELSE --Before 28-JUL-2005
1122: if g_debug then
1123: hr_utility.trace('calc_net_earnings : l_old_rule_earnings'||to_char(l_old_rule_earnings) );
1124: end if;
1125: return l_old_rule_earnings;
1126: END IF;
1127: END calc_net_earnings;

Line 1156: hr_utility.set_location('Attachment Sequence : '||g_court_orders(i).attachment_sequence_no,12);

1152:
1153: FOR i in 1..g_court_orders.last
1154: LOOP
1155: if g_debug then
1156: hr_utility.set_location('Attachment Sequence : '||g_court_orders(i).attachment_sequence_no,12);
1157: end if;
1158: --
1159: IF nvl(g_court_orders(i).stop_flag, 'N') <> 'Y' THEN
1160:

Line 1330: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);

1326: END IF; -- All Attachment
1327:
1328: END IF; -- Obligation Release
1329: if g_debug then
1330: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);
1331: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);
1332: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);
1333: end if;
1334: END IF; -- Stop Flag

Line 1331: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);

1327:
1328: END IF; -- Obligation Release
1329: if g_debug then
1330: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);
1331: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);
1332: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);
1333: end if;
1334: END IF; -- Stop Flag
1335:

Line 1332: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);

1328: END IF; -- Obligation Release
1329: if g_debug then
1330: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);
1331: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);
1332: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);
1333: end if;
1334: END IF; -- Stop Flag
1335:
1336: END LOOP;

Line 1343: hr_utility.set_location('Error in calculating Real Attachment Total. '||substr(sqlerrm,1,200), -40);

1339:
1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: if g_debug then
1343: hr_utility.set_location('Error in calculating Real Attachment Total. '||substr(sqlerrm,1,200), -40);
1344: end if;
1345: RAISE;
1346:
1347: END calc_real_attachment_total;

Line 1398: hr_utility.set_location('Attachment Sequence : '||g_court_orders(i).attachment_sequence_no,13);

1394:
1395: FOR i in 1..g_court_orders.last
1396: LOOP
1397: if g_debug then
1398: hr_utility.set_location('Attachment Sequence : '||g_court_orders(i).attachment_sequence_no,13);
1399: end if;
1400: --
1401: IF nvl(g_court_orders(i).stop_flag, 'N') <> 'Y' THEN
1402:

Line 1525: hr_utility.set_location('WG Adjustment amount ' || to_char(g_emp_total.wg_adjustment),23);

1521: g_emp_total.wg_adjustment := g_emp_total.wg_adjustment + g_court_orders(i).wg_adjustment_amount;
1522: END IF;
1523: --
1524: if g_debug then
1525: hr_utility.set_location('WG Adjustment amount ' || to_char(g_emp_total.wg_adjustment),23);
1526: end if;
1527:
1528: END IF;
1529:

Line 1538: hr_utility.set_location('Employee Attachment Total : '|| to_char(g_court_orders(i).emp_attach_total_by_creditor),33);

1534: g_emp_total.distribution_base := g_emp_total.distribution_base + g_court_orders(i).distribution_base;
1535:
1536: END IF;
1537: if g_debug then
1538: hr_utility.set_location('Employee Attachment Total : '|| to_char(g_court_orders(i).emp_attach_total_by_creditor),33);
1539: end if;
1540: END LOOP;
1541: --
1542: if g_debug then

Line 1543: hr_utility.set_location('Employee Attachment Total for all creditors: '|| to_char(g_emp_total.emp_attach_total),43);

1539: end if;
1540: END LOOP;
1541: --
1542: if g_debug then
1543: hr_utility.set_location('Employee Attachment Total for all creditors: '|| to_char(g_emp_total.emp_attach_total),43);
1544: end if;
1545: END IF; -- g_court_orders.count > 0
1546:
1547: EXCEPTION

Line 1550: hr_utility.set_location('Error in calculating Employee Attachment Total. '||substr(sqlerrm,1,200), -50);

1546:
1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: if g_debug then
1550: hr_utility.set_location('Error in calculating Employee Attachment Total. '||substr(sqlerrm,1,200), -50);
1551: end if;
1552: RAISE;
1553: END calc_emp_attachment_total;
1554:

Line 1571: hr_utility.set_location('Inside distribute_paid_amt',14);

1567: l_correction NUMBER := 0;
1568:
1569: BEGIN
1570: if g_debug then
1571: hr_utility.set_location('Inside distribute_paid_amt',14);
1572: end if;
1573: IF g_court_orders.count > 0 THEN
1574:
1575: FOR i in 1..g_court_orders.last

Line 1578: hr_utility.set_location('Attachment Sequence '||g_court_orders(i).attachment_sequence_no,24);

1574:
1575: FOR i in 1..g_court_orders.last
1576: LOOP
1577: if g_debug then
1578: hr_utility.set_location('Attachment Sequence '||g_court_orders(i).attachment_sequence_no,24);
1579: end if;
1580:
1581: IF nvl(g_court_orders(i).stop_flag, 'N') <> 'Y' THEN
1582:

Line 1667: hr_utility.set_location('Distribution Rate : ' || to_char(g_court_orders(i).distribution_rate),34);

1663: ELSE
1664: g_court_orders(i).distribution_rate := 0;
1665: END IF;
1666: if g_debug then
1667: hr_utility.set_location('Distribution Rate : ' || to_char(g_court_orders(i).distribution_rate),34);
1668: hr_utility.set_location('p_distribution_amount : '|| to_char(p_distribution_amount),44);
1669: end if;
1670: ELSE
1671: g_court_orders(i).curr_emp_paid_amt_by_creditor := g_court_orders(i).emp_attach_total_by_creditor - g_court_orders(i).wg_adjusted_amount;

Line 1668: hr_utility.set_location('p_distribution_amount : '|| to_char(p_distribution_amount),44);

1664: g_court_orders(i).distribution_rate := 0;
1665: END IF;
1666: if g_debug then
1667: hr_utility.set_location('Distribution Rate : ' || to_char(g_court_orders(i).distribution_rate),34);
1668: hr_utility.set_location('p_distribution_amount : '|| to_char(p_distribution_amount),44);
1669: end if;
1670: ELSE
1671: g_court_orders(i).curr_emp_paid_amt_by_creditor := g_court_orders(i).emp_attach_total_by_creditor - g_court_orders(i).wg_adjusted_amount;
1672:

Line 1681: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),54);

1677: ----------------------
1678: -- End of Distribution
1679: ----------------------
1680: if g_debug then
1681: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),54);
1682: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),64);
1683: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);
1684: end if;
1685: ---------------------------------------------------------------

Line 1682: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),64);

1678: -- End of Distribution
1679: ----------------------
1680: if g_debug then
1681: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),54);
1682: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),64);
1683: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);
1684: end if;
1685: ---------------------------------------------------------------
1686: -- Setting flags if full amount has been paid for a court order

Line 1683: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);

1679: ----------------------
1680: if g_debug then
1681: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),54);
1682: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),64);
1683: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);
1684: end if;
1685: ---------------------------------------------------------------
1686: -- Setting flags if full amount has been paid for a court order
1687: ---------------------------------------------------------------

Line 1698: hr_utility.set_location('Setting stop flag...................',84);

1694: --------------------------------------------------------------------------------------------
1695:
1696: IF g_court_orders(i).emp_attach_total_by_creditor > 0 THEN
1697: if g_debug then
1698: hr_utility.set_location('Setting stop flag...................',84);
1699: end if;
1700: g_court_orders(i).stop_flag := 'Y';
1701: END IF;
1702:

Line 1744: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),94);

1740:
1741: END IF;
1742:
1743: if g_debug then
1744: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),94);
1745: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),104);
1746: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);
1747: end if;
1748: END IF; -- All Attachment

Line 1745: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),104);

1741: END IF;
1742:
1743: if g_debug then
1744: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),94);
1745: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),104);
1746: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);
1747: end if;
1748: END IF; -- All Attachment
1749:

Line 1746: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);

1742:
1743: if g_debug then
1744: hr_utility.set_location('g_court_orders(i).curr_emp_paid_amt_by_creditor : '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),94);
1745: hr_utility.set_location('g_court_orders(i).emp_attach_total_by_creditor : '||to_char(g_court_orders(i).emp_attach_total_by_creditor),104);
1746: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);
1747: end if;
1748: END IF; -- All Attachment
1749:
1750: ELSE -- Obligation Release

Line 1783: hr_utility.trace('Going to call distribute_paid_amount recursively for the correction logic');

1779: -----------------------------------------------------------------------
1780:
1781: l_correction_amount := l_correction_amount + l_correction;
1782: if g_debug then
1783: hr_utility.trace('Going to call distribute_paid_amount recursively for the correction logic');
1784: end if;
1785: distribute_paid_amt(l_temp_total + l_leftover_amount, p_distribute_actual_flag, p_adj_pay_flag);
1786: l_leftover_amount := 0;
1787:

Line 1797: hr_utility.trace('Going to adjust the leftover amount among outstanding court orders');

1793: -- Bug 2926020
1794: -- Left-over Amount Logic
1795: -------------------------
1796: if g_debug then
1797: hr_utility.trace('Going to adjust the leftover amount among outstanding court orders');
1798: end if;
1799: --
1800: IF p_distribute_actual_flag = 'D' and l_leftover_amount > 0 THEN
1801:

Line 1873: hr_utility.set_location('Error in Distributing Paid Amount. '||substr(sqlerrm,1,200), -60);

1869:
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: if g_debug then
1873: hr_utility.set_location('Error in Distributing Paid Amount. '||substr(sqlerrm,1,200), -60);
1874: end if;
1875: RAISE;
1876:
1877: END distribute_paid_amt;

Line 1887: hr_utility.set_location('Earnings for after_all_attachment : '||to_char(p_earnings),15);

1883: IS
1884:
1885: BEGIN
1886: if g_debug then
1887: hr_utility.set_location('Earnings for after_all_attachment : '||to_char(p_earnings),15);
1888: end if;
1889: g_emp_total.emp_attach_total := 0;
1890:
1891: -- Bug 2713144 Resetting Distribution Base

Line 1895: hr_utility.set_location('Calculating Real Attachment Total for After All Attachment processing',25);

1891: -- Bug 2713144 Resetting Distribution Base
1892:
1893: g_emp_total.distribution_base := 0;
1894: if g_debug then
1895: hr_utility.set_location('Calculating Real Attachment Total for After All Attachment processing',25);
1896: end if;
1897:
1898: calc_real_attachment_total;
1899: if g_debug then

Line 1900: hr_utility.set_location('Calculating employee attachment total for After All Attachment processing',35);

1896: end if;
1897:
1898: calc_real_attachment_total;
1899: if g_debug then
1900: hr_utility.set_location('Calculating employee attachment total for After All Attachment processing',35);
1901: end if;
1902: calc_emp_attachment_total;
1903:
1904: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, p_earnings);

Line 1906: hr_utility.set_location('Distributing paid amount for After All Attachment processing ',45);

1902: calc_emp_attachment_total;
1903:
1904: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, p_earnings);
1905: if g_debug then
1906: hr_utility.set_location('Distributing paid amount for After All Attachment processing ',45);
1907:
1908: end if;
1909: IF p_earnings >= g_emp_total.emp_attach_total THEN
1910: distribute_paid_amt(0, 'A', p_adj_pay);

Line 1915: hr_utility.set_location('Employee Attachment total for After All Attachment processing : '||to_char(g_emp_total.emp_attach_total),55);

1911: ELSE
1912: distribute_paid_amt(p_earnings, 'D', p_adj_pay);
1913: END IF;
1914: if g_debug then
1915: hr_utility.set_location('Employee Attachment total for After All Attachment processing : '||to_char(g_emp_total.emp_attach_total),55);
1916: end if;
1917: IF p_adj_pay = 'A' AND g_emp_total.emp_attach_total > p_earnings THEN
1918: if g_debug then
1919: hr_utility.set_location('p_net_earnings '||to_char(p_net_earnings),65);

Line 1919: hr_utility.set_location('p_net_earnings '||to_char(p_net_earnings),65);

1915: hr_utility.set_location('Employee Attachment total for After All Attachment processing : '||to_char(g_emp_total.emp_attach_total),55);
1916: end if;
1917: IF p_adj_pay = 'A' AND g_emp_total.emp_attach_total > p_earnings THEN
1918: if g_debug then
1919: hr_utility.set_location('p_net_earnings '||to_char(p_net_earnings),65);
1920: end if;
1921: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total - p_earnings, p_net_earnings);
1922:
1923: IF p_net_earnings >= g_emp_total.emp_attach_total - p_earnings THEN

Line 1934: hr_utility.set_location('Error in After All Attachment Processing. '||substr(sqlerrm,1,200), -70);

1930:
1931: EXCEPTION
1932: WHEN OTHERS THEN
1933: if g_debug then
1934: hr_utility.set_location('Error in After All Attachment Processing. '||substr(sqlerrm,1,200), -70);
1935: end if;
1936: RAISE;
1937:
1938: END;

Line 1945: hr_utility.set_location('---------Entering pay_kr_wg_pkg.calc_wage_garnishment--------',10);

1941: -- Main proceudre body begins here
1942: ----------------------------------------
1943: BEGIN
1944: if g_debug then
1945: hr_utility.set_location('---------Entering pay_kr_wg_pkg.calc_wage_garnishment--------',10);
1946: end if;
1947: -- Bug 2715365 Fetch Payroll period start date and end date from per_time_periods table
1948:
1949: -- Bug : 4498363

Line 1989: hr_utility.set_location('Loading court orders',30);

1985: g_last_assignment_processed := p_assignment_id;
1986:
1987: -- Load all court orders for this assignment
1988: if g_debug then
1989: hr_utility.set_location('Loading court orders',30);
1990: end if;
1991: load_court_orders;
1992:
1993: -- Calculate attachment total base and real attachment total for each creditor

Line 1995: hr_utility.set_location('Calculating Real Attachment Total',40);

1991: load_court_orders;
1992:
1993: -- Calculate attachment total base and real attachment total for each creditor
1994: if g_debug then
1995: hr_utility.set_location('Calculating Real Attachment Total',40);
1996: end if;
1997: calc_real_attachment_total;
1998:
1999: -- calculate employee attachment total for each creditor and total of employee attahcment total

Line 2001: hr_utility.set_location('Calculating Employee Attachment Total',50);

1997: calc_real_attachment_total;
1998:
1999: -- calculate employee attachment total for each creditor and total of employee attahcment total
2000: if g_debug then
2001: hr_utility.set_location('Calculating Employee Attachment Total',50);
2002: end if;
2003: calc_emp_attachment_total;
2004:
2005: ------------------------------------------------------------------------------------

Line 2013: hr_utility.set_location('Adjusting WG Adjustment',60);

2009: ------------------------------------------------------------------------------------
2010:
2011: l_emp_attach_total := g_emp_total.emp_attach_total;
2012: if g_debug then
2013: hr_utility.set_location('Adjusting WG Adjustment',60);
2014: end if;
2015: ------------------------------------------------------------------------------------
2016: -- Bug : 4498363
2017: -- Check for exception condition and distribution of earnings among court orders

Line 2027: hr_utility.set_location('Net earnings '||l_earnings,350);

2023: l_earnings := calc_net_earnings(p_net_earnings, p_wg_attach_earnings_mtd, p_wg_deductions_mtd, p_date_paid);
2024: end if;
2025: --
2026: if g_debug then
2027: hr_utility.set_location('Net earnings '||l_earnings,350);
2028: hr_utility.trace('c_redistribution_required '||c_redistribution_required);
2029: end if;
2030: --
2031: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417

Line 2028: hr_utility.trace('c_redistribution_required '||c_redistribution_required);

2024: end if;
2025: --
2026: if g_debug then
2027: hr_utility.set_location('Net earnings '||l_earnings,350);
2028: hr_utility.trace('c_redistribution_required '||c_redistribution_required);
2029: end if;
2030: --
2031: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417
2032: if g_debug then

Line 2033: hr_utility.set_location('g_emp_total.emp_attach_total : '||to_char(g_emp_total.emp_attach_total),70);

2029: end if;
2030: --
2031: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417
2032: if g_debug then
2033: hr_utility.set_location('g_emp_total.emp_attach_total : '||to_char(g_emp_total.emp_attach_total),70);
2034: hr_utility.set_location('g_emp_total.wg_adjustment : '|| to_char(g_emp_total.wg_adjustment),80);
2035: end if;
2036:
2037: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, g_emp_total.wg_adjustment);

Line 2034: hr_utility.set_location('g_emp_total.wg_adjustment : '|| to_char(g_emp_total.wg_adjustment),80);

2030: --
2031: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417
2032: if g_debug then
2033: hr_utility.set_location('g_emp_total.emp_attach_total : '||to_char(g_emp_total.emp_attach_total),70);
2034: hr_utility.set_location('g_emp_total.wg_adjustment : '|| to_char(g_emp_total.wg_adjustment),80);
2035: end if;
2036:
2037: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, g_emp_total.wg_adjustment);
2038:

Line 2070: hr_utility.set_location('Distributing Amount',90);

2066: -- WG_Adjustment is not sufficient to fully pay all court orders. Then net earnings will be used to pay the
2067: -- balance amount.
2068: -----------------------------------------------------------------------------------------------------------
2069: if g_debug then
2070: hr_utility.set_location('Distributing Amount',90);
2071: end if;
2072:
2073: IF l_emp_attach_total > g_emp_total.wg_adjustment THEN
2074: ---------------------------------------------------------------------------------------------

Line 2090: hr_utility.set_location('Net Earnings : ' || to_char(l_earnings),100);

2086: -- If employee attachment total is less than attachable earnings then do not distribute the amount, pay actuals
2087: -- This is identfied with a flag distribute/actual, whose value will be 'D'-distribute and 'A'-actual
2088: ----------------------------------------------------------------------------------------------------------------
2089: if g_debug then
2090: hr_utility.set_location('Net Earnings : ' || to_char(l_earnings),100);
2091: end if;
2092: IF l_emp_attach_total - g_emp_total.wg_adjusted <= l_earnings THEN
2093:
2094: distribute_paid_amt(0, 'A', 'P');

Line 2115: hr_utility.set_location('p_adjustment_amount := '||to_char(g_emp_total.wg_adjustment),110);

2111:
2112: END IF;
2113: --
2114: if g_debug then
2115: hr_utility.set_location('p_adjustment_amount := '||to_char(g_emp_total.wg_adjustment),110);
2116: hr_utility.set_location('p_unadjusted_amount := '||to_char(g_emp_total.wg_adjustment - g_emp_total.wg_adjusted),120);
2117: end if;
2118: p_adjustment_amount := g_emp_total.wg_adjustment;
2119: p_unadjusted_amount := g_emp_total.wg_adjustment - g_emp_total.wg_adjusted;

Line 2116: hr_utility.set_location('p_unadjusted_amount := '||to_char(g_emp_total.wg_adjustment - g_emp_total.wg_adjusted),120);

2112: END IF;
2113: --
2114: if g_debug then
2115: hr_utility.set_location('p_adjustment_amount := '||to_char(g_emp_total.wg_adjustment),110);
2116: hr_utility.set_location('p_unadjusted_amount := '||to_char(g_emp_total.wg_adjustment - g_emp_total.wg_adjusted),120);
2117: end if;
2118: p_adjustment_amount := g_emp_total.wg_adjustment;
2119: p_unadjusted_amount := g_emp_total.wg_adjustment - g_emp_total.wg_adjusted;
2120:

Line 2134: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);

2130: FOR i in 1..g_court_orders.last
2131: LOOP
2132: IF p_attachment_seq_no = g_court_orders(i).attachment_sequence_no THEN
2133: if g_debug then
2134: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);

Line 2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);

2131: LOOP
2132: IF p_attachment_seq_no = g_court_orders(i).attachment_sequence_no THEN
2133: if g_debug then
2134: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);

Line 2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);

2132: IF p_attachment_seq_no = g_court_orders(i).attachment_sequence_no THEN
2133: if g_debug then
2134: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);

Line 2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);

2133: if g_debug then
2134: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);

Line 2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);

2134: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);

Line 2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);

2135: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2143: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);

Line 2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);

2136: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2143: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2144: end if;

Line 2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);

2137: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2143: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2144: end if;
2145: p_curr_attach_seq_no := g_court_orders(i).attachment_sequence_no;

Line 2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);

2138: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2143: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2144: end if;
2145: p_curr_attach_seq_no := g_court_orders(i).attachment_sequence_no;
2146: p_curr_case_number := g_court_orders(i).case_number;

Line 2143: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);

2139: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2140: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2141: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2142: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2143: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2144: end if;
2145: p_curr_attach_seq_no := g_court_orders(i).attachment_sequence_no;
2146: p_curr_case_number := g_court_orders(i).case_number;
2147: p_attachment_amount := g_court_orders(i).curr_emp_paid_amt_by_creditor;

Line 2173: hr_utility.set_location('---------Leaving pay_kr_wg_pkg.calc_wage_garnishment--------',230);

2169:
2170: END IF;
2171: --
2172: if g_debug then
2173: hr_utility.set_location('---------Leaving pay_kr_wg_pkg.calc_wage_garnishment--------',230);
2174: end if;
2175: RETURN 0;
2176:
2177: EXCEPTION

Line 2190: hr_utility.set_location(substr(sqlerrm,1,200),-80);

2186: RETURN 4;
2187:
2188: WHEN OTHERS THEN
2189: if g_debug then
2190: hr_utility.set_location(substr(sqlerrm,1,200),-80);
2191: end if;
2192: RAISE;
2193:
2194: END calc_wage_garnishment;