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 19: g_debug boolean := hr_utility.debug_enabled;

15: --
16: cursor csr_get_global_values(p_global_name IN varchar2) is
17: select global_value from ff_globals_f where global_name = p_global_name;
18: --
19: g_debug boolean := hr_utility.debug_enabled;
20: -----------------------------------------------------------------------------------------------
21: -- Function calc_wage_garnishment. Function with added parameter o_adjusted_amount.
22: -- This function calls another version with the parameter p_attachment_sequence_no
23: -----------------------------------------------------------------------------------------------

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

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

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

405: l_prev_payout_date := l_prev_payout_date_bal_adj;
406:
407: END IF;
408: if g_debug then
409: hr_utility.set_location('Previous Payout Date is : '||to_char(l_prev_payout_date), 1);
410: end if;
411:
412: RETURN l_prev_payout_date;
413:

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

413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: if g_debug then
417: hr_utility.set_location('Error in get_previous_payout_date. Message : '||substr(sqlerrm,1,200), -10);
418: end if;
419: RAISE;
420:
421: END get_previous_payout_date;

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

451:
452: -- Bug 3223825
453: IF g_wg_deduction_bal_id IS NULL THEN
454: IF g_debug THEN
455: hr_utility.trace('first attempt');
456: END IF;
457:
458: OPEN csr_defined_bal_id('WG Deductions', '_ASG_WG_ITD');
459: FETCH csr_defined_bal_id INTO l_defined_balance_id;

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

462: g_wg_deduction_bal_id:=l_defined_balance_id;
463: ELSE
464:
465: IF g_debug THEN
466: hr_utility.trace('sec attempt');
467: END IF;
468:
469: l_defined_balance_id := g_wg_deduction_bal_id;
470:

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

472: -- Bug 3435686
473: l_value:=pay_balance_pkg.get_value (l_defined_balance_id, p_assignment_action_id);
474:
475: if g_debug then
476: hr_utility.trace('l_value wg deduction ' || l_value) ;
477: end if;
478:
479: IF l_value > 0 THEN
480:

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

483: ELSE
484:
485: IF g_wg_interest_bal_id is NULL THEN
486: IF g_debug THEN
487: hr_utility.trace('first attempt');
488: END IF;
489:
490: OPEN csr_defined_bal_id('WG Paid Interest', '_ASG_WG_ITD');
491: FETCH csr_defined_bal_id INTO l_defined_balance_id;

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

494: g_wg_interest_bal_id := l_defined_balance_id;
495:
496: ELSE
497: IF g_debug THEN
498: hr_utility.trace('sec attempt');
499: end if;
500:
501: l_defined_balance_id:=g_wg_interest_bal_id;
502:

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

504: -- Bug 3435686
505: l_value:=pay_balance_pkg.get_value (l_defined_balance_id, p_assignment_action_id);
506:
507: IF g_debug THEN
508: hr_utility.trace('l_value wg paid interest ' || l_value);
509: END IF;
510:
511: IF l_value > 0 THEN
512: RETURN FALSE;

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

518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: if g_debug then
522: hr_utility.set_location('Error in Processing First Time. Message : '||substr(sqlerrm,1,200), -10);
523: end if;
524: RAISE;
525:
526: END processing_first_time;

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

718:
719: EXCEPTION
720: WHEN OTHERS THEN
721: if g_debug then
722: hr_utility.set_location('Error in Interest Validation. Message : '||substr(sqlerrm,1,200), -20);
723: end if;
724: RAISE;
725:
726: END validate_interest_bands;

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

776: ELSE
777: RETURN 'N';
778: END IF;
779: if g_debug then
780: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
781: hr_utility.trace('p_assignment_id '||p_assignment_id);
782: hr_utility.trace('l_provisional_date '||l_provisional_date);
783: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
784: end if;

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

777: RETURN 'N';
778: END IF;
779: if g_debug then
780: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
781: hr_utility.trace('p_assignment_id '||p_assignment_id);
782: hr_utility.trace('l_provisional_date '||l_provisional_date);
783: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
784: end if;
785: END check_exception_case;

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

778: END IF;
779: if g_debug then
780: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
781: hr_utility.trace('p_assignment_id '||p_assignment_id);
782: hr_utility.trace('l_provisional_date '||l_provisional_date);
783: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
784: end if;
785: END check_exception_case;
786:

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

779: if g_debug then
780: hr_utility.trace('l_count_court_orders '||l_count_court_orders);
781: hr_utility.trace('p_assignment_id '||p_assignment_id);
782: hr_utility.trace('l_provisional_date '||l_provisional_date);
783: hr_utility.trace('p_provisional_case_num '||p_prev_case_num);
784: end if;
785: END check_exception_case;
786:
787: --------------------------------------------------------------------------------------

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

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

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

900: -- to redistribute the Obligation Release amount only if at least one unprocessed
901: -- Obligation Released court order is found.
902: --
903: if g_debug then
904: hr_utility.trace('obligation_release_processed '||g_court_orders(l_court_order_no).obligation_release_processed);
905: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);
906: end if;
907: --
908: IF g_court_orders(l_court_order_no).obligation_release_processed = 'N' THEN

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

901: -- Obligation Released court order is found.
902: --
903: if g_debug then
904: hr_utility.trace('obligation_release_processed '||g_court_orders(l_court_order_no).obligation_release_processed);
905: hr_utility.trace('attachment_sequence_no'||g_court_orders(l_court_order_no).attachment_sequence_no);
906: end if;
907: --
908: IF g_court_orders(l_court_order_no).obligation_release_processed = 'N' THEN
909: c_redistribution_required := 'Y';

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

932: ELSE
933: l_count_oblig_rel_before := l_count_oblig_rel_before + 1;
934: END IF;
935: if g_debug then
936: hr_utility.set_location('num of court orders which received obligation_release'||l_count_oblig_rel_before,310);
937: end if;
938: END IF;
939: --
940: -- Changes for Bug 2708036

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

984: validate_interest_bands(l_court_order_no);
985:
986: l_interest_loaded := TRUE;
987: if g_debug then
988: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
989:
990: ' Band 1 : '||
991: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base1)||
992: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate1)||

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

993: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date1)||
994: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date1),11);
995:
996:
997: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
998:
999: ' Band 2 : '||
1000: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base2)||
1001: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate2)||

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

1001: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate2)||
1002: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date2)||
1003: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date2),21);
1004:
1005: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1006: ' Band 3 : '||
1007: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base3)||
1008: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate3)||
1009: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date3)||

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

1008: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate3)||
1009: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date3)||
1010: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date3),31);
1011:
1012: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1013: ' Band 4 : '||
1014: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base4)||
1015: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate4)||
1016: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date4)||

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

1015: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate4)||
1016: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date4)||
1017: ' '|| to_char(g_court_orders(l_court_order_no).interest_to_date4),41);
1018:
1019: hr_utility.set_location('Attachment Sequence Number : '||g_court_orders(l_court_order_no).attachment_sequence_no||
1020: ' Band 5 : '||
1021: ' '|| to_char(g_court_orders(l_court_order_no).interest_calculation_base5)||
1022: ' '|| to_char(g_court_orders(l_court_order_no).interest_rate5)||
1023: ' '|| to_char(g_court_orders(l_court_order_no).interest_from_date5)||

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

1043: g_excpn_court_order_flag :='Y';
1044: END IF;
1045: END IF;
1046: if g_debug then
1047: hr_utility.trace('l_count_oblig_rel_before '||l_count_oblig_rel_before);
1048: hr_utility.trace('l_count_oblig_rel_after '||l_count_oblig_rel_after);
1049: end if;
1050: --
1051: EXCEPTION

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

1044: END IF;
1045: END IF;
1046: if g_debug then
1047: hr_utility.trace('l_count_oblig_rel_before '||l_count_oblig_rel_before);
1048: hr_utility.trace('l_count_oblig_rel_after '||l_count_oblig_rel_after);
1049: end if;
1050: --
1051: EXCEPTION
1052: WHEN OTHERS THEN

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

1050: --
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: if g_debug then
1054: hr_utility.set_location('Error in loading court orders. Message : '||substr(sqlerrm,1,200), -30);
1055: end if;
1056: RAISE;
1057:
1058: END load_court_orders;

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

1072: l_old_rule_earnings NUMBER := 0;
1073: l_deductable_amount NUMBER := 0;
1074: BEGIN
1075: if g_debug then
1076: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1077: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1078: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1079: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1080: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );

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

1073: l_deductable_amount NUMBER := 0;
1074: BEGIN
1075: if g_debug then
1076: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1077: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1078: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1079: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1080: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1081: end if;

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

1074: BEGIN
1075: if g_debug then
1076: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1077: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1078: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1079: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1080: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1081: end if;
1082: l_old_rule_earnings := p_net_earnings * g_max_attachable_earnings;

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

1075: if g_debug then
1076: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1077: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1078: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1079: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1080: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1081: end if;
1082: l_old_rule_earnings := p_net_earnings * g_max_attachable_earnings;
1083: --

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

1076: hr_utility.trace('calc_net_earnings : p_net_earnings'||to_char(p_net_earnings) );
1077: hr_utility.trace('calc_net_earnings : p_date_paid'||to_char(p_date_paid) );
1078: hr_utility.trace('calc_net_earnings : l_count_court_orders'||to_char(l_count_court_orders) );
1079: hr_utility.trace('calc_net_earnings : p_wg_attach_earnings_mtd'||to_char(p_wg_attach_earnings_mtd) );
1080: hr_utility.trace('calc_net_earnings : p_wg_deductions_mtd'||to_char(p_wg_deductions_mtd) );
1081: end if;
1082: l_old_rule_earnings := p_net_earnings * g_max_attachable_earnings;
1083: --
1084: IF p_date_paid >= g_change_effective_date and l_count_court_orders > 0 then --After 28-JUL-2005

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

1104: l_deductable_amount := greatest(l_deductable_amount - p_wg_deductions_mtd, 0);
1105: END IF;
1106: --
1107: if g_debug then
1108: hr_utility.trace('calc_net_earnings : l_deductable_amount'||to_char(l_deductable_amount) );
1109: end if;
1110: return l_deductable_amount;
1111: ELSE --Before 28-JUL-2005
1112: if g_debug then

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

1109: end if;
1110: return l_deductable_amount;
1111: ELSE --Before 28-JUL-2005
1112: if g_debug then
1113: hr_utility.trace('calc_net_earnings : l_old_rule_earnings'||to_char(l_old_rule_earnings) );
1114: end if;
1115: return l_old_rule_earnings;
1116: END IF;
1117: END calc_net_earnings;

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

1142:
1143: FOR i in 1..g_court_orders.last
1144: LOOP
1145: if g_debug then
1146: hr_utility.set_location('Attachment Sequence : '||g_court_orders(i).attachment_sequence_no,12);
1147: end if;
1148: --
1149: IF nvl(g_court_orders(i).stop_flag, 'N') <> 'Y' THEN
1150:

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

1316: END IF; -- All Attachment
1317:
1318: END IF; -- Obligation Release
1319: if g_debug then
1320: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);
1321: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);
1322: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);
1323: end if;
1324: END IF; -- Stop Flag

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

1317:
1318: END IF; -- Obligation Release
1319: if g_debug then
1320: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);
1321: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);
1322: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);
1323: end if;
1324: END IF; -- Stop Flag
1325:

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

1318: END IF; -- Obligation Release
1319: if g_debug then
1320: hr_utility.set_location('Real Attachment Total By Creditor : '||to_CHAR(g_court_orders(i).real_attach_total_by_creditor),22);
1321: hr_utility.set_location('Interest Amount for this Creditor : '||to_CHAR(g_court_orders(i).interest_amount),32);
1322: hr_utility.set_location('Attachment Total Base : '||to_CHAR(g_court_orders(i).attachment_total_base),42);
1323: end if;
1324: END IF; -- Stop Flag
1325:
1326: END LOOP;

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

1329:
1330: EXCEPTION
1331: WHEN OTHERS THEN
1332: if g_debug then
1333: hr_utility.set_location('Error in calculating Real Attachment Total. '||substr(sqlerrm,1,200), -40);
1334: end if;
1335: RAISE;
1336:
1337: END calc_real_attachment_total;

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

1384:
1385: FOR i in 1..g_court_orders.last
1386: LOOP
1387: if g_debug then
1388: hr_utility.set_location('Attachment Sequence : '||g_court_orders(i).attachment_sequence_no,13);
1389: end if;
1390: --
1391: IF nvl(g_court_orders(i).stop_flag, 'N') <> 'Y' THEN
1392:

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

1511: g_emp_total.wg_adjustment := g_emp_total.wg_adjustment + g_court_orders(i).wg_adjustment_amount;
1512: END IF;
1513: --
1514: if g_debug then
1515: hr_utility.set_location('WG Adjustment amount ' || to_char(g_emp_total.wg_adjustment),23);
1516: end if;
1517:
1518: END IF;
1519:

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

1524: g_emp_total.distribution_base := g_emp_total.distribution_base + g_court_orders(i).distribution_base;
1525:
1526: END IF;
1527: if g_debug then
1528: hr_utility.set_location('Employee Attachment Total : '|| to_char(g_court_orders(i).emp_attach_total_by_creditor),33);
1529: end if;
1530: END LOOP;
1531: --
1532: if g_debug then

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

1529: end if;
1530: END LOOP;
1531: --
1532: if g_debug then
1533: hr_utility.set_location('Employee Attachment Total for all creditors: '|| to_char(g_emp_total.emp_attach_total),43);
1534: end if;
1535: END IF; -- g_court_orders.count > 0
1536:
1537: EXCEPTION

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

1536:
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: if g_debug then
1540: hr_utility.set_location('Error in calculating Employee Attachment Total. '||substr(sqlerrm,1,200), -50);
1541: end if;
1542: RAISE;
1543: END calc_emp_attachment_total;
1544:

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

1557: l_correction NUMBER := 0;
1558:
1559: BEGIN
1560: if g_debug then
1561: hr_utility.set_location('Inside distribute_paid_amt',14);
1562: end if;
1563: IF g_court_orders.count > 0 THEN
1564:
1565: FOR i in 1..g_court_orders.last

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

1564:
1565: FOR i in 1..g_court_orders.last
1566: LOOP
1567: if g_debug then
1568: hr_utility.set_location('Attachment Sequence '||g_court_orders(i).attachment_sequence_no,24);
1569: end if;
1570:
1571: IF nvl(g_court_orders(i).stop_flag, 'N') <> 'Y' THEN
1572:

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

1653: ELSE
1654: g_court_orders(i).distribution_rate := 0;
1655: END IF;
1656: if g_debug then
1657: hr_utility.set_location('Distribution Rate : ' || to_char(g_court_orders(i).distribution_rate),34);
1658: hr_utility.set_location('p_distribution_amount : '|| to_char(p_distribution_amount),44);
1659: end if;
1660: ELSE
1661: 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 1658: hr_utility.set_location('p_distribution_amount : '|| to_char(p_distribution_amount),44);

1654: g_court_orders(i).distribution_rate := 0;
1655: END IF;
1656: if g_debug then
1657: hr_utility.set_location('Distribution Rate : ' || to_char(g_court_orders(i).distribution_rate),34);
1658: hr_utility.set_location('p_distribution_amount : '|| to_char(p_distribution_amount),44);
1659: end if;
1660: ELSE
1661: 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;
1662:

Line 1671: 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);

1667: ----------------------
1668: -- End of Distribution
1669: ----------------------
1670: if g_debug then
1671: 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);
1672: 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);
1673: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);
1674: end if;
1675: ---------------------------------------------------------------

Line 1672: 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);

1668: -- End of Distribution
1669: ----------------------
1670: if g_debug then
1671: 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);
1672: 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);
1673: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);
1674: end if;
1675: ---------------------------------------------------------------
1676: -- Setting flags if full amount has been paid for a court order

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

1669: ----------------------
1670: if g_debug then
1671: 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);
1672: 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);
1673: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),74);
1674: end if;
1675: ---------------------------------------------------------------
1676: -- Setting flags if full amount has been paid for a court order
1677: ---------------------------------------------------------------

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

1684: --------------------------------------------------------------------------------------------
1685:
1686: IF g_court_orders(i).emp_attach_total_by_creditor > 0 THEN
1687: if g_debug then
1688: hr_utility.set_location('Setting stop flag...................',84);
1689: end if;
1690: g_court_orders(i).stop_flag := 'Y';
1691: END IF;
1692:

Line 1734: 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);

1730:
1731: END IF;
1732:
1733: if g_debug then
1734: 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);
1735: 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);
1736: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);
1737: end if;
1738: END IF; -- All Attachment

Line 1735: 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);

1731: END IF;
1732:
1733: if g_debug then
1734: 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);
1735: 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);
1736: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);
1737: end if;
1738: END IF; -- All Attachment
1739:

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

1732:
1733: if g_debug then
1734: 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);
1735: 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);
1736: hr_utility.set_location('g_court_orders(i).wg_adjusted_amount : '||to_char(g_court_orders(i).wg_adjusted_amount),114);
1737: end if;
1738: END IF; -- All Attachment
1739:
1740: ELSE -- Obligation Release

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

1769: -----------------------------------------------------------------------
1770:
1771: l_correction_amount := l_correction_amount + l_correction;
1772: if g_debug then
1773: hr_utility.trace('Going to call distribute_paid_amount recursively for the correction logic');
1774: end if;
1775: distribute_paid_amt(l_temp_total + l_leftover_amount, p_distribute_actual_flag, p_adj_pay_flag);
1776: l_leftover_amount := 0;
1777:

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

1783: -- Bug 2926020
1784: -- Left-over Amount Logic
1785: -------------------------
1786: if g_debug then
1787: hr_utility.trace('Going to adjust the leftover amount among outstanding court orders');
1788: end if;
1789: --
1790: IF p_distribute_actual_flag = 'D' and l_leftover_amount > 0 THEN
1791:

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

1859:
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: if g_debug then
1863: hr_utility.set_location('Error in Distributing Paid Amount. '||substr(sqlerrm,1,200), -60);
1864: end if;
1865: RAISE;
1866:
1867: END distribute_paid_amt;

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

1873: IS
1874:
1875: BEGIN
1876: if g_debug then
1877: hr_utility.set_location('Earnings for after_all_attachment : '||to_char(p_earnings),15);
1878: end if;
1879: g_emp_total.emp_attach_total := 0;
1880:
1881: -- Bug 2713144 Resetting Distribution Base

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

1881: -- Bug 2713144 Resetting Distribution Base
1882:
1883: g_emp_total.distribution_base := 0;
1884: if g_debug then
1885: hr_utility.set_location('Calculating Real Attachment Total for After All Attachment processing',25);
1886: end if;
1887:
1888: calc_real_attachment_total;
1889: if g_debug then

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

1886: end if;
1887:
1888: calc_real_attachment_total;
1889: if g_debug then
1890: hr_utility.set_location('Calculating employee attachment total for After All Attachment processing',35);
1891: end if;
1892: calc_emp_attachment_total;
1893:
1894: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, p_earnings);

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

1892: calc_emp_attachment_total;
1893:
1894: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, p_earnings);
1895: if g_debug then
1896: hr_utility.set_location('Distributing paid amount for After All Attachment processing ',45);
1897:
1898: end if;
1899: IF p_earnings >= g_emp_total.emp_attach_total THEN
1900: distribute_paid_amt(0, 'A', p_adj_pay);

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

1901: ELSE
1902: distribute_paid_amt(p_earnings, 'D', p_adj_pay);
1903: END IF;
1904: if g_debug then
1905: hr_utility.set_location('Employee Attachment total for After All Attachment processing : '||to_char(g_emp_total.emp_attach_total),55);
1906: end if;
1907: IF p_adj_pay = 'A' AND g_emp_total.emp_attach_total > p_earnings THEN
1908: if g_debug then
1909: hr_utility.set_location('p_net_earnings '||to_char(p_net_earnings),65);

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

1905: hr_utility.set_location('Employee Attachment total for After All Attachment processing : '||to_char(g_emp_total.emp_attach_total),55);
1906: end if;
1907: IF p_adj_pay = 'A' AND g_emp_total.emp_attach_total > p_earnings THEN
1908: if g_debug then
1909: hr_utility.set_location('p_net_earnings '||to_char(p_net_earnings),65);
1910: end if;
1911: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total - p_earnings, p_net_earnings);
1912:
1913: IF p_net_earnings >= g_emp_total.emp_attach_total - p_earnings THEN

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

1920:
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: if g_debug then
1924: hr_utility.set_location('Error in After All Attachment Processing. '||substr(sqlerrm,1,200), -70);
1925: end if;
1926: RAISE;
1927:
1928: END;

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

1931: -- Main proceudre body begins here
1932: ----------------------------------------
1933: BEGIN
1934: if g_debug then
1935: hr_utility.set_location('---------Entering pay_kr_wg_pkg.calc_wage_garnishment--------',10);
1936: end if;
1937: -- Bug 2715365 Fetch Payroll period start date and end date from per_time_periods table
1938:
1939: OPEN csr_pay_period(p_assignment_action_id);

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

1962: g_last_assignment_processed := p_assignment_id;
1963:
1964: -- Load all court orders for this assignment
1965: if g_debug then
1966: hr_utility.set_location('Loading court orders',30);
1967: end if;
1968: load_court_orders;
1969:
1970: -- Calculate attachment total base and real attachment total for each creditor

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

1968: load_court_orders;
1969:
1970: -- Calculate attachment total base and real attachment total for each creditor
1971: if g_debug then
1972: hr_utility.set_location('Calculating Real Attachment Total',40);
1973: end if;
1974: calc_real_attachment_total;
1975:
1976: -- calculate employee attachment total for each creditor and total of employee attahcment total

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

1974: calc_real_attachment_total;
1975:
1976: -- calculate employee attachment total for each creditor and total of employee attahcment total
1977: if g_debug then
1978: hr_utility.set_location('Calculating Employee Attachment Total',50);
1979: end if;
1980: calc_emp_attachment_total;
1981:
1982: ------------------------------------------------------------------------------------

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

1986: ------------------------------------------------------------------------------------
1987:
1988: l_emp_attach_total := g_emp_total.emp_attach_total;
1989: if g_debug then
1990: hr_utility.set_location('Adjusting WG Adjustment',60);
1991: end if;
1992: ------------------------------------------------------------------------------------
1993: -- Bug : 4498363
1994: -- Check for exception condition and distribution of earnings among court orders

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

2000: l_earnings := calc_net_earnings(p_net_earnings, p_wg_attach_earnings_mtd, p_wg_deductions_mtd, p_date_paid);
2001: end if;
2002: --
2003: if g_debug then
2004: hr_utility.set_location('Net earnings '||l_earnings,350);
2005: hr_utility.trace('c_redistribution_required '||c_redistribution_required);
2006: end if;
2007: --
2008: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417

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

2001: end if;
2002: --
2003: if g_debug then
2004: hr_utility.set_location('Net earnings '||l_earnings,350);
2005: hr_utility.trace('c_redistribution_required '||c_redistribution_required);
2006: end if;
2007: --
2008: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417
2009: if g_debug then

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

2006: end if;
2007: --
2008: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417
2009: if g_debug then
2010: hr_utility.set_location('g_emp_total.emp_attach_total : '||to_char(g_emp_total.emp_attach_total),70);
2011: hr_utility.set_location('g_emp_total.wg_adjustment : '|| to_char(g_emp_total.wg_adjustment),80);
2012: end if;
2013:
2014: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, g_emp_total.wg_adjustment);

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

2007: --
2008: IF c_obligation_release = 'Y' and c_redistribution_required = 'Y' THEN --4866417
2009: if g_debug then
2010: hr_utility.set_location('g_emp_total.emp_attach_total : '||to_char(g_emp_total.emp_attach_total),70);
2011: hr_utility.set_location('g_emp_total.wg_adjustment : '|| to_char(g_emp_total.wg_adjustment),80);
2012: end if;
2013:
2014: g_emp_total.curr_emp_paid_amt := least(g_emp_total.emp_attach_total, g_emp_total.wg_adjustment);
2015:

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

2043: -- WG_Adjustment is not sufficient to fully pay all court orders. Then net earnings will be used to pay the
2044: -- balance amount.
2045: -----------------------------------------------------------------------------------------------------------
2046: if g_debug then
2047: hr_utility.set_location('Distributing Amount',90);
2048: end if;
2049:
2050: IF l_emp_attach_total > g_emp_total.wg_adjustment THEN
2051: ---------------------------------------------------------------------------------------------

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

2063: -- If employee attachment total is less than attachable earnings then do not distribute the amount, pay actuals
2064: -- This is identfied with a flag distribute/actual, whose value will be 'D'-distribute and 'A'-actual
2065: ----------------------------------------------------------------------------------------------------------------
2066: if g_debug then
2067: hr_utility.set_location('Net Earnings : ' || to_char(l_earnings),100);
2068: end if;
2069: IF l_emp_attach_total - g_emp_total.wg_adjusted <= l_earnings THEN
2070:
2071: distribute_paid_amt(0, 'A', 'P');

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

2088:
2089: END IF;
2090: --
2091: if g_debug then
2092: hr_utility.set_location('p_adjustment_amount := '||to_char(g_emp_total.wg_adjustment),110);
2093: hr_utility.set_location('p_unadjusted_amount := '||to_char(g_emp_total.wg_adjustment - g_emp_total.wg_adjusted),120);
2094: end if;
2095: p_adjustment_amount := g_emp_total.wg_adjustment;
2096: p_unadjusted_amount := g_emp_total.wg_adjustment - g_emp_total.wg_adjusted;

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

2089: END IF;
2090: --
2091: if g_debug then
2092: hr_utility.set_location('p_adjustment_amount := '||to_char(g_emp_total.wg_adjustment),110);
2093: hr_utility.set_location('p_unadjusted_amount := '||to_char(g_emp_total.wg_adjustment - g_emp_total.wg_adjusted),120);
2094: end if;
2095: p_adjustment_amount := g_emp_total.wg_adjustment;
2096: p_unadjusted_amount := g_emp_total.wg_adjustment - g_emp_total.wg_adjusted;
2097:

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

2107: FOR i in 1..g_court_orders.last
2108: LOOP
2109: IF p_attachment_seq_no = g_court_orders(i).attachment_sequence_no THEN
2110: if g_debug then
2111: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2112: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);

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

2108: LOOP
2109: IF p_attachment_seq_no = g_court_orders(i).attachment_sequence_no THEN
2110: if g_debug then
2111: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2112: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);

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

2109: IF p_attachment_seq_no = g_court_orders(i).attachment_sequence_no THEN
2110: if g_debug then
2111: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2112: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);

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

2110: if g_debug then
2111: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2112: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);

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

2111: hr_utility.set_location('p_attachment_amount := '||to_char(g_court_orders(i).curr_emp_paid_amt_by_creditor),130);
2112: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2119: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);

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

2112: hr_utility.set_location('p_adjusted_amount := '||to_char(g_court_orders(i).wg_adjusted_amount),140);
2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2119: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2120: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);

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

2113: hr_utility.set_location('p_interest_amount := '||to_char(g_court_orders(i).interest_amount),150);
2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2119: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2120: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2121: end if;

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

2114: hr_utility.set_location('p_stop_flag := '||g_court_orders(i).stop_flag,160);
2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2119: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2120: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2121: end if;
2122: p_curr_attach_seq_no := g_court_orders(i).attachment_sequence_no;

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

2115: hr_utility.set_location('p_real_attach_total := '||to_char(g_court_orders(i).real_attach_total_by_creditor),170);
2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2119: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2120: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2121: end if;
2122: p_curr_attach_seq_no := g_court_orders(i).attachment_sequence_no;
2123: p_curr_case_number := g_court_orders(i).case_number;

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

2116: hr_utility.set_location('p_emp_attach_total := '||to_char(g_court_orders(i).emp_attach_total_by_creditor),180);
2117: hr_utility.set_location('p_attach_total_base := '||to_char(g_court_orders(i).attachment_total_base),190);
2118: hr_utility.set_location('p_message := '||g_court_orders(i).out_message,200);
2119: hr_utility.set_location('p_curr_attach_seq_no := '||g_court_orders(i).attachment_sequence_no,210);
2120: hr_utility.set_location('p_curr_case_number := '||g_court_orders(i).case_number,220);
2121: end if;
2122: p_curr_attach_seq_no := g_court_orders(i).attachment_sequence_no;
2123: p_curr_case_number := g_court_orders(i).case_number;
2124: p_attachment_amount := g_court_orders(i).curr_emp_paid_amt_by_creditor;

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

2146:
2147: END IF;
2148: --
2149: if g_debug then
2150: hr_utility.set_location('---------Leaving pay_kr_wg_pkg.calc_wage_garnishment--------',230);
2151: end if;
2152: RETURN 0;
2153:
2154: EXCEPTION

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

2163: RETURN 4;
2164:
2165: WHEN OTHERS THEN
2166: if g_debug then
2167: hr_utility.set_location(substr(sqlerrm,1,200),-80);
2168: end if;
2169: RAISE;
2170:
2171: END calc_wage_garnishment;