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

Line 216: hr_utility.set_location('HR_PRE_PAY.INS_COIN_EL',2);

212: if (cash_detail.val_mode = 'TRANSFER') then
213: --
214: -- Now make the payment
215: --
216: hr_utility.set_location('HR_PRE_PAY.INS_COIN_EL',2);
217: --
218: insert into pay_coin_anal_elements(
219: coin_anal_element_id,
220: pre_payment_id,

Line 250: hr_utility.set_location('HR_PRE_PAY.PAY_COIN',1);

246: begin
247: --
248: -- Firstly get the monetary unit of the payment.
249: --
250: hr_utility.set_location('HR_PRE_PAY.PAY_COIN',1);
251: --
252: select pmu.monetary_unit_id
253: into monetary_unit
254: from pay_monetary_units pmu,

Line 318: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',1);

314: cash_detail.a_action_id := action_id;
315: --
316: -- Get the number of decimal places used by the currency
317: --
318: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',1);
319: --
320: select cur.precision
321: into cash_detail.precision
322: from fnd_currencies cur

Line 338: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',2);

334: -- represeneted in pay_coin_anal_elements already. Cash_left will
335: -- represent what hasn't been assigned a monetary unit.
336: -- Now pay this remainder by default.
337: --
338: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',2);
339: --
340: open coin_cursor(pay_currency, action_id);
341: --
342: -- Cursor orders by value (hi-lo). While there is cash left pay it.

Line 346: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',3);

342: -- Cursor orders by value (hi-lo). While there is cash left pay it.
343: --
344: while cash_detail.cash_left > 0 loop
345: --
346: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',3);
347: --
348: fetch coin_cursor into monetary_unit, factor;
349: --
350: if coin_cursor%notfound then

Line 354: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

350: if coin_cursor%notfound then
351: --
352: if (cash_detail.val_mode = 'TRANSFER') then
353: close coin_cursor;
354: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
355: hr_utility.raise_error;
356: else
357: close coin_cursor;
358: --

Line 355: hr_utility.raise_error;

351: --
352: if (cash_detail.val_mode = 'TRANSFER') then
353: close coin_cursor;
354: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
355: hr_utility.raise_error;
356: else
357: close coin_cursor;
358: --
359: declare

Line 373: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

369: --
370: -- Since the payment currency is not the same as base
371: -- error out. Lets not get into exchange rate conversions.
372: --
373: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
374: hr_utility.raise_error;
375: --
376: end if;
377: --

Line 374: hr_utility.raise_error;

370: -- Since the payment currency is not the same as base
371: -- error out. Lets not get into exchange rate conversions.
372: --
373: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
374: hr_utility.raise_error;
375: --
376: end if;
377: --
378: -- Lets take money off the payment amount and put it back

Line 404: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',4);

400: end if;
401: --
402: end loop;
403: --
404: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',4);
405: --
406: if (coin_cursor%ISOPEN) then
407: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',5);
408: close coin_cursor;

Line 407: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',5);

403: --
404: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',4);
405: --
406: if (coin_cursor%ISOPEN) then
407: hr_utility.set_location('HR_PRE_PAY.DO_CASH_ANALYSIS',5);
408: close coin_cursor;
409: end if;
410: --
411: end do_cash_analysis;

Line 578: hr_utility.trace('Enter create_payment');

574: l_org_method_id number(16);
575: --
576: begin
577: --
578: hr_utility.trace('Enter create_payment');
579: if base_currency <> pay_currency then
580: --
581: begin
582: if (pay_currency_type is NULL)

Line 584: hr_utility.set_message(801,'HR_52349_NO_RATE_TYPE');

580: --
581: begin
582: if (pay_currency_type is NULL)
583: then
584: hr_utility.set_message(801,'HR_52349_NO_RATE_TYPE');
585: hr_utility.raise_error;
586: end if;
587: payment:=hr_currency_pkg.convert_amount(base_currency,
588: pay_currency,

Line 585: hr_utility.raise_error;

581: begin
582: if (pay_currency_type is NULL)
583: then
584: hr_utility.set_message(801,'HR_52349_NO_RATE_TYPE');
585: hr_utility.raise_error;
586: end if;
587: payment:=hr_currency_pkg.convert_amount(base_currency,
588: pay_currency,
589: pre_payment_date,

Line 596: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');

592:
593: exception
594: --
595: when no_data_found then
596: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
597: hr_utility.set_message_token('RATE1', base_currency);
598: hr_utility.set_message_token('RATE2', pay_currency);
599: hr_utility.raise_error;
600:

Line 597: hr_utility.set_message_token('RATE1', base_currency);

593: exception
594: --
595: when no_data_found then
596: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
597: hr_utility.set_message_token('RATE1', base_currency);
598: hr_utility.set_message_token('RATE2', pay_currency);
599: hr_utility.raise_error;
600:
601: when gl_currency_api.NO_RATE then

Line 598: hr_utility.set_message_token('RATE2', pay_currency);

594: --
595: when no_data_found then
596: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
597: hr_utility.set_message_token('RATE1', base_currency);
598: hr_utility.set_message_token('RATE2', pay_currency);
599: hr_utility.raise_error;
600:
601: when gl_currency_api.NO_RATE then
602: --

Line 599: hr_utility.raise_error;

595: when no_data_found then
596: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
597: hr_utility.set_message_token('RATE1', base_currency);
598: hr_utility.set_message_token('RATE2', pay_currency);
599: hr_utility.raise_error;
600:
601: when gl_currency_api.NO_RATE then
602: --
603: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');

Line 603: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');

599: hr_utility.raise_error;
600:
601: when gl_currency_api.NO_RATE then
602: --
603: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
604: hr_utility.set_message_token('RATE1', base_currency);
605: hr_utility.set_message_token('RATE2', pay_currency);
606: hr_utility.raise_error;
607:

Line 604: hr_utility.set_message_token('RATE1', base_currency);

600:
601: when gl_currency_api.NO_RATE then
602: --
603: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
604: hr_utility.set_message_token('RATE1', base_currency);
605: hr_utility.set_message_token('RATE2', pay_currency);
606: hr_utility.raise_error;
607:
608: when gl_currency_api.INVALID_CURRENCY then

Line 605: hr_utility.set_message_token('RATE2', pay_currency);

601: when gl_currency_api.NO_RATE then
602: --
603: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
604: hr_utility.set_message_token('RATE1', base_currency);
605: hr_utility.set_message_token('RATE2', pay_currency);
606: hr_utility.raise_error;
607:
608: when gl_currency_api.INVALID_CURRENCY then
609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');

Line 606: hr_utility.raise_error;

602: --
603: hr_utility.set_message(801,'HR_6405_PAYM_NO_EXCHANGE_RATE');
604: hr_utility.set_message_token('RATE1', base_currency);
605: hr_utility.set_message_token('RATE2', pay_currency);
606: hr_utility.raise_error;
607:
608: when gl_currency_api.INVALID_CURRENCY then
609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');
610: hr_utility.set_message_token('RATE1', base_currency);

Line 609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');

605: hr_utility.set_message_token('RATE2', pay_currency);
606: hr_utility.raise_error;
607:
608: when gl_currency_api.INVALID_CURRENCY then
609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');
610: hr_utility.set_message_token('RATE1', base_currency);
611: hr_utility.set_message_token('RATE2', pay_currency);
612: hr_utility.raise_error;
613:

Line 610: hr_utility.set_message_token('RATE1', base_currency);

606: hr_utility.raise_error;
607:
608: when gl_currency_api.INVALID_CURRENCY then
609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');
610: hr_utility.set_message_token('RATE1', base_currency);
611: hr_utility.set_message_token('RATE2', pay_currency);
612: hr_utility.raise_error;
613:
614: --

Line 611: hr_utility.set_message_token('RATE2', pay_currency);

607:
608: when gl_currency_api.INVALID_CURRENCY then
609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');
610: hr_utility.set_message_token('RATE1', base_currency);
611: hr_utility.set_message_token('RATE2', pay_currency);
612: hr_utility.raise_error;
613:
614: --
615: end;

Line 612: hr_utility.raise_error;

608: when gl_currency_api.INVALID_CURRENCY then
609: hr_utility.set_message(801,'HR_52350_INVALID_CURRENCY');
610: hr_utility.set_message_token('RATE1', base_currency);
611: hr_utility.set_message_token('RATE2', pay_currency);
612: hr_utility.raise_error;
613:
614: --
615: end;
616: --

Line 662: hr_utility.set_location('HR_PRE_PAY.CREATE_PAYMENT',1);

658: if payment <> 0 then
659: --
660: -- Save the ID for cash analysis
661: --
662: hr_utility.set_location('HR_PRE_PAY.CREATE_PAYMENT',1);
663: --
664: payment_id := null;
665: declare
666: ins_cnt number;

Line 696: hr_utility.trace('pay_left = '||pay_left);

692: --
693: do_cash_analysis(payment, cash_rule, payment_id,
694: pay_currency,
695: action_id, 'VALIDATE', pay_left);
696: hr_utility.trace('pay_left = '||pay_left);
697: --
698: end if;
699: end if;
700: --

Line 701: hr_utility.trace('Exit create_payment');

697: --
698: end if;
699: end if;
700: --
701: hr_utility.trace('Exit create_payment');
702: end create_payment;
703: --
704: -------------------------- pay_method ------------------------------
705: /*

Line 728: hr_utility.set_location('HR_PRE_PAY.PAY_METHOD',1);

724: begin
725: --
726: -- Get the percentage or amount to be paid
727: --
728: hr_utility.set_location('HR_PRE_PAY.PAY_METHOD',1);
729: --
730: select cur.precision
731: into cash_detail.precision
732: from fnd_currencies cur

Line 802: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',1);

798: p_effdate in date default null) return boolean is
799: --
800: begin
801: --
802: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',1);
803: --
804: if prenote_date is null then
805: --
806: -- insert a prenote entry.

Line 808: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',2);

804: if prenote_date is null then
805: --
806: -- insert a prenote entry.
807: --
808: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',2);
809: insert into pay_pre_payments
810: (pre_payment_id,
811: personal_payment_method_id,
812: org_payment_method_id,

Line 834: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',3);

830: --
831: return false;
832: --
833: end if;
834: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',3);
835: if valid_date >= prenote_date then
836: --
837: return true;
838: --

Line 867: hr_utility.set_location('HR_PRE_PAY.Initialise',1);

863: pay_bg_id number(16);
864: --
865: begin
866: --
867: hr_utility.set_location('HR_PRE_PAY.Initialise',1);
868: --
869: payroll_action := to_number(action_id);
870: --
871: begin

Line 924: hr_utility.set_message(801,'HR_6238_PAYM_NO_DEFAULT');

920: exception
921: --
922: when others then
923: --
924: hr_utility.set_message(801,'HR_6238_PAYM_NO_DEFAULT');
925: hr_utility.raise_error;
926: --
927: end;
928: --

Line 925: hr_utility.raise_error;

921: --
922: when others then
923: --
924: hr_utility.set_message(801,'HR_6238_PAYM_NO_DEFAULT');
925: hr_utility.raise_error;
926: --
927: end;
928: --
929: --

Line 930: hr_utility.set_location('HR_PRE_PAY.Initialise',2);

926: --
927: end;
928: --
929: --
930: hr_utility.set_location('HR_PRE_PAY.Initialise',2);
931: --
932: begin
933: select plr.rule_mode
934: into g_adjust_ee_source

Line 953: hr_utility.set_location('HR_PRE_PAY.Initialise',3);

949: g_adjust_ee_source := 'A';
950: end if;
951: end;
952: --
953: hr_utility.set_location('HR_PRE_PAY.Initialise',3);
954: --
955: end initialise;
956: --
957: --

Line 979: hr_utility.set_location('HR_PRE_PAY.INIT_OVERRIDE',1);

975: --
976: pay_bg_id number(16);
977: begin
978: --
979: hr_utility.set_location('HR_PRE_PAY.INIT_OVERRIDE',1);
980: --
981: payroll_action := to_number(action_id);
982: override.payment_method_id := to_number(override_method);
983: --

Line 1041: hr_utility.set_message(801,'HR_6239_PAYM_INVALID_OVERRIDE');

1037: exception
1038: --
1039: when others then
1040: --
1041: hr_utility.set_message(801,'HR_6239_PAYM_INVALID_OVERRIDE');
1042: hr_utility.raise_error;
1043: --
1044: end;
1045: --

Line 1042: hr_utility.raise_error;

1038: --
1039: when others then
1040: --
1041: hr_utility.set_message(801,'HR_6239_PAYM_INVALID_OVERRIDE');
1042: hr_utility.raise_error;
1043: --
1044: end;
1045: --
1046: begin

Line 1126: hr_utility.set_message(801,'HR_XXXX_PAYM_NO_RENUMERATION');

1122: p_def_bal_id := def_bal;
1123: --
1124: exception
1125: when NO_DATA_FOUND then
1126: hr_utility.set_message(801,'HR_XXXX_PAYM_NO_RENUMERATION');
1127: hr_utility.raise_error;
1128: end get_ren_balance;
1129: -------------------------- get_third_party_details --------------------------
1130: /*

Line 1127: hr_utility.raise_error;

1123: --
1124: exception
1125: when NO_DATA_FOUND then
1126: hr_utility.set_message(801,'HR_XXXX_PAYM_NO_RENUMERATION');
1127: hr_utility.raise_error;
1128: end get_ren_balance;
1129: -------------------------- get_third_party_details --------------------------
1130: /*
1131: NAME

Line 1227: hr_utility.trace('Enter adjust_payments');

1223: pp_ptr number;
1224: --
1225: begin
1226: --
1227: hr_utility.trace('Enter adjust_payments');
1228: pp_ptr := g_pre_payments.count;
1229: while (pp_ptr > 0) loop
1230: --
1231: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);

Line 1231: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);

1227: hr_utility.trace('Enter adjust_payments');
1228: pp_ptr := g_pre_payments.count;
1229: while (pp_ptr > 0) loop
1230: --
1231: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);
1232: hr_utility.trace('Compare '||
1233: nvl(g_pre_payments(pp_ptr).payment_currency, 'NULL')||
1234: ' with '||
1235: nvl(g_pre_payments(pp_ptr).base_currency, 'NULL'));

Line 1232: hr_utility.trace('Compare '||

1228: pp_ptr := g_pre_payments.count;
1229: while (pp_ptr > 0) loop
1230: --
1231: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);
1232: hr_utility.trace('Compare '||
1233: nvl(g_pre_payments(pp_ptr).payment_currency, 'NULL')||
1234: ' with '||
1235: nvl(g_pre_payments(pp_ptr).base_currency, 'NULL'));
1236: hr_utility.trace('Compare '||

Line 1236: hr_utility.trace('Compare '||

1232: hr_utility.trace('Compare '||
1233: nvl(g_pre_payments(pp_ptr).payment_currency, 'NULL')||
1234: ' with '||
1235: nvl(g_pre_payments(pp_ptr).base_currency, 'NULL'));
1236: hr_utility.trace('Compare '||
1237: nvl(g_pre_payments(pp_ptr).source_action_id, -999)||
1238: ' with '||
1239: nvl(p_src_action_id, -999));
1240: --

Line 1258: hr_utility.trace('Exit adjust_payments');

1254: end if;
1255: --
1256: pp_ptr := pp_ptr - 1;
1257: end loop;
1258: hr_utility.trace('Exit adjust_payments');
1259: --
1260: end adjust_payments;
1261: --
1262: -------------------------- pay_per_payment_methods ------------------------------

Line 1295: hr_utility.trace('Enter pay_per_payment_methods');

1291: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;
1292: --
1293: begin
1294: --
1295: hr_utility.trace('Enter pay_per_payment_methods');
1296: payment := FALSE;
1297:
1298: -- check for legilsation rule
1299: select org.legislation_code

Line 1458: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

1454: if (p_pay_left > 0) then
1455: adjust_payments(p_pay_left, p_src_act_id);
1456: --
1457: if p_pay_left > 0 then
1458: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1459: hr_utility.raise_error;
1460: end if;
1461: end if;
1462: --

Line 1459: hr_utility.raise_error;

1455: adjust_payments(p_pay_left, p_src_act_id);
1456: --
1457: if p_pay_left > 0 then
1458: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1459: hr_utility.raise_error;
1460: end if;
1461: end if;
1462: --
1463: end if ;

Line 1465: hr_utility.trace('Exit pay_per_payment_methods');

1461: end if;
1462: --
1463: end if ;
1464: --
1465: hr_utility.trace('Exit pay_per_payment_methods');
1466: --
1467: end pay_per_payment_methods;
1468: --
1469: -------------------------- pay_run_type_methods ----------------------------- -

Line 1605: hr_utility.trace('Enter pay_run_type_methods');

1601: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;
1602: got_payment_amount boolean;
1603: begin
1604: --
1605: hr_utility.trace('Enter pay_run_type_methods');
1606: -- check for legilsation rule
1607: select org.legislation_code
1608: into leg_code
1609: from pay_assignment_Actions act,

Line 1924: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

1920: master_action_id,
1921: pay_left);
1922: --
1923: if pay_left > 0 then
1924: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1925: hr_utility.raise_error;
1926: end if;
1927: --
1928: p_pay_left := p_pay_left - base_payment;

Line 1925: hr_utility.raise_error;

1921: pay_left);
1922: --
1923: if pay_left > 0 then
1924: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1925: hr_utility.raise_error;
1926: end if;
1927: --
1928: p_pay_left := p_pay_left - base_payment;
1929: end if;

Line 1935: hr_utility.trace('Exit pay_run_type_methods');

1931: end if;
1932: end if;
1933: --
1934: end loop;
1935: hr_utility.trace('Exit pay_run_type_methods');
1936: end pay_run_type_methods;
1937: --
1938: procedure process_per_payment(p_assignment_action in number,
1939: p_assignment in number,

Line 1976: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

1972: null,
1973: p_pay_left);
1974: --
1975: if p_pay_left > 0 then
1976: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1977: hr_utility.raise_error;
1978: end if;
1979: --
1980: end if;

Line 1977: hr_utility.raise_error;

1973: p_pay_left);
1974: --
1975: if p_pay_left > 0 then
1976: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1977: hr_utility.raise_error;
1978: end if;
1979: --
1980: end if;
1981: --

Line 2007: hr_utility.trace('Enter pay_personal_methods');

2003: total_pay number;
2004: pay_left number;
2005: begin
2006: --
2007: hr_utility.trace('Enter pay_personal_methods');
2008: g_pre_payments.delete;
2009: total_pay := fnd_number.canonical_to_number(p_balance_value);
2010: pay_left := total_pay;
2011: --

Line 2028: hr_utility.trace('Exit pay_personal_methods');

2024: pay_left);
2025: --
2026: flush_payments;
2027: --
2028: hr_utility.trace('Exit pay_personal_methods');
2029: end pay_personal_methods;
2030: --
2031: -------------------------- pay_run_type_override ----------------------------- -
2032: /*

Line 2069: hr_utility.trace('Enter pay_run_type_override');

2065: assign_id number;
2066: --
2067: begin
2068: --
2069: hr_utility.trace('Enter pay_run_type_override');
2070: --
2071: for chdrec in chdact loop
2072: --
2073: if chdrec.run_method = 'S' then

Line 2080: hr_utility.trace('Found Child Type '||chdrec.run_method);

2076: chdrec.assignment_action_id,
2077: total_pay);
2078: pay_left := 0;
2079: --
2080: hr_utility.trace('Found Child Type '||chdrec.run_method);
2081: --
2082: -- OK, we've checked the run type payment methods now
2083: -- if this is a separate payment run, and if there is
2084: -- money left to be paid then use either the personal

Line 2092: hr_utility.trace('Paying Run Override of '||total_pay);

2088: (total_pay > 0
2089: or (negative_pay = 'Y' and total_pay <> 0 and
2090: override.category = 'CA')) then
2091: --
2092: hr_utility.trace('Paying Run Override of '||total_pay);
2093: --
2094: child_action_id := p_assignment_action;
2095: master_action_id := p_master_aa_id;
2096: --

Line 2111: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

2107: master_action_id,
2108: pay_left);
2109: --
2110: if pay_left > 0 then
2111: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2112: hr_utility.raise_error;
2113: end if;
2114: --
2115: p_pay_left := p_pay_left - total_pay;

Line 2112: hr_utility.raise_error;

2108: pay_left);
2109: --
2110: if pay_left > 0 then
2111: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2112: hr_utility.raise_error;
2113: end if;
2114: --
2115: p_pay_left := p_pay_left - total_pay;
2116: --

Line 2121: hr_utility.trace('Exit pay_run_type_override');

2117: end if;
2118: end if;
2119: --
2120: end loop;
2121: hr_utility.trace('Exit pay_run_type_override');
2122: --
2123: end pay_run_type_override;
2124: --
2125: procedure process_run_types(p_override_method in number,

Line 2182: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

2178: null,
2179: p_pay_left);
2180: --
2181: if p_pay_left > 0 then
2182: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2183: hr_utility.raise_error;
2184: end if;
2185: end if;
2186: end process_ovr_payment;

Line 2183: hr_utility.raise_error;

2179: p_pay_left);
2180: --
2181: if p_pay_left > 0 then
2182: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2183: hr_utility.raise_error;
2184: end if;
2185: end if;
2186: end process_ovr_payment;
2187: --

Line 2197: hr_utility.trace('Enter process_normal_payments');

2193: p_pay_left in out nocopy number)
2194: is
2195: begin
2196: --
2197: hr_utility.trace('Enter process_normal_payments');
2198: --
2199: g_pre_payments.delete;
2200: if (p_override_method is not null) then
2201: process_ovr_payment(p_assignment_action,

Line 2213: hr_utility.trace('Exit process_normal_payments');

2209: end if;
2210: --
2211: flush_payments;
2212: --
2213: hr_utility.trace('Exit process_normal_payments');
2214: end process_normal_payments;
2215: --
2216: -------------------------- pay_override_method -------------------------------
2217: /*

Line 2435: hr_utility.trace('Entered pay third party');

2431: child_action_id number;
2432: master_action_id number;
2433: l_max_eff_end_date date;
2434: begin
2435: hr_utility.trace('Entered pay third party');
2436: --
2437: g_pre_payments.delete;
2438: pay_left := 0;
2439: --

Line 2505: hr_utility.trace('Entered pay third party location 1 ');

2501: )
2502: )
2503: order by ppm.priority;
2504: --
2505: hr_utility.trace('Entered pay third party location 1 ');
2506: if fnd_number.canonical_to_number(p_bal_value) <> 0 then
2507: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
2508: payment_details.valid_days);
2509: --

Line 2576: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

2572: master_action_id,
2573: pay_left);
2574: --
2575: if pay_left > 0 then
2576: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2577: hr_utility.raise_error;
2578: end if;
2579: --
2580: end;

Line 2577: hr_utility.raise_error;

2573: pay_left);
2574: --
2575: if pay_left > 0 then
2576: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2577: hr_utility.raise_error;
2578: end if;
2579: --
2580: end;
2581: end if;

Line 2584: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');

2580: end;
2581: end if;
2582: else
2583: -- invalid pay method.
2584: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2585: hr_utility.raise_error;
2586: --
2587: end if;
2588: --

Line 2585: hr_utility.raise_error;

2581: end if;
2582: else
2583: -- invalid pay method.
2584: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2585: hr_utility.raise_error;
2586: --
2587: end if;
2588: --
2589: end if;

Line 2595: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');

2591: flush_payments;
2592: --
2593: exception
2594: when NO_DATA_FOUND then
2595: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2596: hr_utility.raise_error;
2597: end pay_third_party;
2598: --
2599: ------------------- get_dynamic_org_method -------------------

Line 2596: hr_utility.raise_error;

2592: --
2593: exception
2594: when NO_DATA_FOUND then
2595: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2596: hr_utility.raise_error;
2597: end pay_third_party;
2598: --
2599: ------------------- get_dynamic_org_method -------------------
2600: /*

Line 2675: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');

2671: and p_effective_date between opm.effective_start_date
2672: and opm.effective_end_date;
2673:
2674: if ((l_paytype = 0) or (l_ext_acc = 0)) then
2675: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2676: hr_utility.raise_error;
2677: end if;
2678: --
2679: else

Line 2676: hr_utility.raise_error;

2672: and opm.effective_end_date;
2673:
2674: if ((l_paytype = 0) or (l_ext_acc = 0)) then
2675: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2676: hr_utility.raise_error;
2677: end if;
2678: --
2679: else
2680: dbms_sql.close_cursor(sql_cursor);

Line 2681: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');

2677: end if;
2678: --
2679: else
2680: dbms_sql.close_cursor(sql_cursor);
2681: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2682: hr_utility.raise_error;
2683: end if;
2684: --
2685: p_org_method_id := l_org_method_id;

Line 2682: hr_utility.raise_error;

2678: --
2679: else
2680: dbms_sql.close_cursor(sql_cursor);
2681: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2682: hr_utility.raise_error;
2683: end if;
2684: --
2685: p_org_method_id := l_org_method_id;
2686: --

Line 2790: hr_utility.trace('Enter process_org_third_party');

2786: l_org_context_name pay_legislation_contexts.input_value_name%type;
2787: --
2788: begin
2789: --
2790: hr_utility.trace('Enter process_org_third_party');
2791: --
2792: g_pre_payments.delete;
2793: pay_left := 0;
2794: --

Line 2800: hr_utility.trace('Process Org '||orgrec.organization_id);

2796: 'ORGANIZATION_ID');
2797: --
2798: for orgrec in get_orgs (p_asg_act, l_org_context_name) loop
2799: --
2800: hr_utility.trace('Process Org '||orgrec.organization_id);
2801: --
2802: for payments in get_opms(p_asg_act, orgrec.organization_id) loop
2803: --
2804: get_balance_value(p_def_balance => payments.defined_balance_id,

Line 2809: hr_utility.trace('Amount to Pay '||l_bal_value);

2805: p_assignment_actions => p_asg_act,
2806: p_balance_value => l_bal_value,
2807: p_org_id => orgrec.organization_id);
2808: --
2809: hr_utility.trace('Amount to Pay '||l_bal_value);
2810: hr_utility.trace('Time Def '||payments.time_def_id);
2811: hr_utility.trace('Payment Date '||payments.payment_date);
2812: --
2813: if fnd_number.canonical_to_number(l_bal_value) <> 0 then

Line 2810: hr_utility.trace('Time Def '||payments.time_def_id);

2806: p_balance_value => l_bal_value,
2807: p_org_id => orgrec.organization_id);
2808: --
2809: hr_utility.trace('Amount to Pay '||l_bal_value);
2810: hr_utility.trace('Time Def '||payments.time_def_id);
2811: hr_utility.trace('Payment Date '||payments.payment_date);
2812: --
2813: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2814: valid_date := (fnd_date.canonical_to_date(p_eff_date) -

Line 2811: hr_utility.trace('Payment Date '||payments.payment_date);

2807: p_org_id => orgrec.organization_id);
2808: --
2809: hr_utility.trace('Amount to Pay '||l_bal_value);
2810: hr_utility.trace('Time Def '||payments.time_def_id);
2811: hr_utility.trace('Payment Date '||payments.payment_date);
2812: --
2813: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2814: valid_date := (fnd_date.canonical_to_date(p_eff_date) -
2815: payments.valid_days);

Line 2864: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');

2860: payments.payee_org_method,
2861: payments.payment_date);
2862: --
2863: if pay_left > 0 then
2864: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2865: hr_utility.raise_error;
2866: end if;
2867: --
2868: end if;

Line 2865: hr_utility.raise_error;

2861: payments.payment_date);
2862: --
2863: if pay_left > 0 then
2864: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2865: hr_utility.raise_error;
2866: end if;
2867: --
2868: end if;
2869: else

Line 2871: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');

2867: --
2868: end if;
2869: else
2870: -- invalid pay method.
2871: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2872: hr_utility.raise_error;
2873: --
2874: end if;
2875: --

Line 2872: hr_utility.raise_error;

2868: end if;
2869: else
2870: -- invalid pay method.
2871: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2872: hr_utility.raise_error;
2873: --
2874: end if;
2875: --
2876: end if;

Line 2885: hr_utility.trace('Exit process_org_third_party');

2881: end loop;
2882: --
2883: end loop;
2884: --
2885: hr_utility.trace('Exit process_org_third_party');
2886: --
2887: end process_org_third_party;
2888: --
2889: procedure process_third_party(p_asg_act in number,

Line 2901: hr_utility.trace('Enter process_third_party');

2897: l_entry number;
2898: l_assignment_id number;
2899: begin
2900: --
2901: hr_utility.trace('Enter process_third_party');
2902: --
2903: do_process := TRUE;
2904: while (do_process = TRUE) loop
2905: begin

Line 2937: hr_utility.trace('Exit process_third_party');

2933: p_eff_date => p_eff_date,
2934: p_master_aa_id => p_master_aa_id
2935: );
2936: --
2937: hr_utility.trace('Exit process_third_party');
2938: --
2939: end process_third_party;
2940: --
2941: procedure process_action(p_asg_act in number,

Line 3063: hr_utility.trace('Enter create_child_actions');

3059: pre_asg_actid number;
3060: --
3061: begin
3062: --
3063: hr_utility.trace('Enter create_child_actions');
3064: --
3065: prev_tu := -1;
3066: --
3067: found_tu := FALSE;

Line 3075: hr_utility.trace('Found Pro Asg '||turec.assignment_id||' '||

3071: --
3072: if (p_multi_gre_payment = 'N') then
3073: for turec in get_tu_child(p_asg_act) loop
3074: --
3075: hr_utility.trace('Found Pro Asg '||turec.assignment_id||' '||
3076: 'TU ='||turec.run_tax_unit_id);
3077: --
3078: found_tu := TRUE;
3079: --

Line 3123: hr_utility.trace('Found Non Pro Asg '||asgrec.assignment_id);

3119: prev_asg_id := -1;
3120: --
3121: for asgrec in get_mlt_asg(p_asg_act) loop
3122: --
3123: hr_utility.trace('Found Non Pro Asg '||asgrec.assignment_id);
3124: --
3125: if (prev_asg_id <> asgrec.assignment_id) then
3126: select pay_assignment_actions_s.nextval
3127: into pre_asg_actid

Line 3155: hr_utility.trace('Exit create_child_actions');

3151: end if;
3152: --
3153: p_multi_gre := found_tu;
3154: --
3155: hr_utility.trace('Exit create_child_actions');
3156: --
3157: end create_child_actions;
3158: --
3159: procedure do_prepayment(p_asg_act in number,

Line 3198: hr_utility.trace('Enter do_prepayment');

3194: l_multi_gre boolean;
3195: --
3196: begin
3197: --
3198: hr_utility.trace('Enter do_prepayment');
3199: l_eff_date := fnd_date.canonical_to_date(p_effective_date);
3200: child_processed := FALSE;
3201: --
3202: create_child_actions(p_asg_act,

Line 3265: hr_utility.trace('Exit do_prepayment');

3261: p_def_bal_id,
3262: p_effective_date,
3263: l_pay_left);
3264:
3265: hr_utility.trace('Exit do_prepayment');
3266: --
3267: end do_prepayment;
3268: --
3269: --------------------------------- get_trx_date ------------------------------