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 948: hr_utility.set_location('HR_PRE_PAY.Initialise',3);

944: when no_data_found then
945: g_adjust_ee_source := 'A';
946: end;
947: --
948: hr_utility.set_location('HR_PRE_PAY.Initialise',3);
949: --
950: end initialise;
951: --
952: --

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

970: --
971: pay_bg_id number(16);
972: begin
973: --
974: hr_utility.set_location('HR_PRE_PAY.INIT_OVERRIDE',1);
975: --
976: payroll_action := to_number(action_id);
977: override.payment_method_id := to_number(override_method);
978: --

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

1032: exception
1033: --
1034: when others then
1035: --
1036: hr_utility.set_message(801,'HR_6239_PAYM_INVALID_OVERRIDE');
1037: hr_utility.raise_error;
1038: --
1039: end;
1040: --

Line 1037: hr_utility.raise_error;

1033: --
1034: when others then
1035: --
1036: hr_utility.set_message(801,'HR_6239_PAYM_INVALID_OVERRIDE');
1037: hr_utility.raise_error;
1038: --
1039: end;
1040: --
1041: begin

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

1117: p_def_bal_id := def_bal;
1118: --
1119: exception
1120: when NO_DATA_FOUND then
1121: hr_utility.set_message(801,'HR_XXXX_PAYM_NO_RENUMERATION');
1122: hr_utility.raise_error;
1123: end get_ren_balance;
1124: -------------------------- get_third_party_details --------------------------
1125: /*

Line 1122: hr_utility.raise_error;

1118: --
1119: exception
1120: when NO_DATA_FOUND then
1121: hr_utility.set_message(801,'HR_XXXX_PAYM_NO_RENUMERATION');
1122: hr_utility.raise_error;
1123: end get_ren_balance;
1124: -------------------------- get_third_party_details --------------------------
1125: /*
1126: NAME

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

1218: pp_ptr number;
1219: --
1220: begin
1221: --
1222: hr_utility.trace('Enter adjust_payments');
1223: pp_ptr := g_pre_payments.count;
1224: while (pp_ptr > 0) loop
1225: --
1226: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);

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

1222: hr_utility.trace('Enter adjust_payments');
1223: pp_ptr := g_pre_payments.count;
1224: while (pp_ptr > 0) loop
1225: --
1226: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);
1227: hr_utility.trace('Compare '||
1228: nvl(g_pre_payments(pp_ptr).payment_currency, 'NULL')||
1229: ' with '||
1230: nvl(g_pre_payments(pp_ptr).base_currency, 'NULL'));

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

1223: pp_ptr := g_pre_payments.count;
1224: while (pp_ptr > 0) loop
1225: --
1226: hr_utility.trace('Compare '||g_pre_payments(pp_ptr).category);
1227: hr_utility.trace('Compare '||
1228: nvl(g_pre_payments(pp_ptr).payment_currency, 'NULL')||
1229: ' with '||
1230: nvl(g_pre_payments(pp_ptr).base_currency, 'NULL'));
1231: hr_utility.trace('Compare '||

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

1227: hr_utility.trace('Compare '||
1228: nvl(g_pre_payments(pp_ptr).payment_currency, 'NULL')||
1229: ' with '||
1230: nvl(g_pre_payments(pp_ptr).base_currency, 'NULL'));
1231: hr_utility.trace('Compare '||
1232: nvl(g_pre_payments(pp_ptr).source_action_id, -999)||
1233: ' with '||
1234: nvl(p_src_action_id, -999));
1235: --

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

1249: end if;
1250: --
1251: pp_ptr := pp_ptr - 1;
1252: end loop;
1253: hr_utility.trace('Exit adjust_payments');
1254: --
1255: end adjust_payments;
1256: --
1257: -------------------------- pay_per_payment_methods ------------------------------

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

1286: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;
1287: --
1288: begin
1289: --
1290: hr_utility.trace('Enter pay_per_payment_methods');
1291: payment := FALSE;
1292:
1293: -- check for legilsation rule
1294: select org.legislation_code

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

1449: if (p_pay_left > 0) then
1450: adjust_payments(p_pay_left, p_src_act_id);
1451: --
1452: if p_pay_left > 0 then
1453: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1454: hr_utility.raise_error;
1455: end if;
1456: end if;
1457: --

Line 1454: hr_utility.raise_error;

1450: adjust_payments(p_pay_left, p_src_act_id);
1451: --
1452: if p_pay_left > 0 then
1453: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1454: hr_utility.raise_error;
1455: end if;
1456: end if;
1457: --
1458: end if ;

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

1456: end if;
1457: --
1458: end if ;
1459: --
1460: hr_utility.trace('Exit pay_per_payment_methods');
1461: --
1462: end pay_per_payment_methods;
1463: --
1464: -------------------------- pay_run_type_methods ----------------------------- -

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

1596: l_org_method_id pay_org_payment_methods.org_payment_method_id%TYPE;
1597: got_payment_amount boolean;
1598: begin
1599: --
1600: hr_utility.trace('Enter pay_run_type_methods');
1601: -- check for legilsation rule
1602: select org.legislation_code
1603: into leg_code
1604: from pay_assignment_Actions act,

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

1915: master_action_id,
1916: pay_left);
1917: --
1918: if pay_left > 0 then
1919: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1920: hr_utility.raise_error;
1921: end if;
1922: --
1923: p_pay_left := p_pay_left - base_payment;

Line 1920: hr_utility.raise_error;

1916: pay_left);
1917: --
1918: if pay_left > 0 then
1919: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1920: hr_utility.raise_error;
1921: end if;
1922: --
1923: p_pay_left := p_pay_left - base_payment;
1924: end if;

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

1926: end if;
1927: end if;
1928: --
1929: end loop;
1930: hr_utility.trace('Exit pay_run_type_methods');
1931: end pay_run_type_methods;
1932: --
1933: procedure process_per_payment(p_assignment_action in number,
1934: p_assignment in number,

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

1967: null,
1968: p_pay_left);
1969: --
1970: if p_pay_left > 0 then
1971: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1972: hr_utility.raise_error;
1973: end if;
1974: --
1975: end if;

Line 1972: hr_utility.raise_error;

1968: p_pay_left);
1969: --
1970: if p_pay_left > 0 then
1971: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
1972: hr_utility.raise_error;
1973: end if;
1974: --
1975: end if;
1976: --

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

1998: total_pay number;
1999: pay_left number;
2000: begin
2001: --
2002: hr_utility.trace('Enter pay_personal_methods');
2003: g_pre_payments.delete;
2004: total_pay := fnd_number.canonical_to_number(p_balance_value);
2005: pay_left := total_pay;
2006: --

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

2019: pay_left);
2020: --
2021: flush_payments;
2022: --
2023: hr_utility.trace('Exit pay_personal_methods');
2024: end pay_personal_methods;
2025: --
2026: -------------------------- pay_run_type_override ----------------------------- -
2027: /*

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

2060: assign_id number;
2061: --
2062: begin
2063: --
2064: hr_utility.trace('Enter pay_run_type_override');
2065: --
2066: for chdrec in chdact loop
2067: --
2068: if chdrec.run_method = 'S' then

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

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

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

2083: (total_pay > 0
2084: or (negative_pay = 'Y' and total_pay <> 0 and
2085: override.category = 'CA')) then
2086: --
2087: hr_utility.trace('Paying Run Override of '||total_pay);
2088: --
2089: child_action_id := p_assignment_action;
2090: master_action_id := p_master_aa_id;
2091: --

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

2102: master_action_id,
2103: pay_left);
2104: --
2105: if pay_left > 0 then
2106: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2107: hr_utility.raise_error;
2108: end if;
2109: --
2110: p_pay_left := p_pay_left - total_pay;

Line 2107: hr_utility.raise_error;

2103: pay_left);
2104: --
2105: if pay_left > 0 then
2106: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2107: hr_utility.raise_error;
2108: end if;
2109: --
2110: p_pay_left := p_pay_left - total_pay;
2111: --

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

2112: end if;
2113: end if;
2114: --
2115: end loop;
2116: hr_utility.trace('Exit pay_run_type_override');
2117: --
2118: end pay_run_type_override;
2119: --
2120: procedure process_run_types(p_override_method in number,

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

2173: null,
2174: p_pay_left);
2175: --
2176: if p_pay_left > 0 then
2177: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2178: hr_utility.raise_error;
2179: end if;
2180: end if;
2181: end process_ovr_payment;

Line 2178: hr_utility.raise_error;

2174: p_pay_left);
2175: --
2176: if p_pay_left > 0 then
2177: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2178: hr_utility.raise_error;
2179: end if;
2180: end if;
2181: end process_ovr_payment;
2182: --

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

2188: p_pay_left in out nocopy number)
2189: is
2190: begin
2191: --
2192: hr_utility.trace('Enter process_normal_payments');
2193: --
2194: g_pre_payments.delete;
2195: if (p_override_method is not null) then
2196: process_ovr_payment(p_assignment_action,

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

2204: end if;
2205: --
2206: flush_payments;
2207: --
2208: hr_utility.trace('Exit process_normal_payments');
2209: end process_normal_payments;
2210: --
2211: -------------------------- pay_override_method -------------------------------
2212: /*

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

2536: master_action_id,
2537: pay_left);
2538: --
2539: if pay_left > 0 then
2540: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2541: hr_utility.raise_error;
2542: end if;
2543: --
2544: end;

Line 2541: hr_utility.raise_error;

2537: pay_left);
2538: --
2539: if pay_left > 0 then
2540: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2541: hr_utility.raise_error;
2542: end if;
2543: --
2544: end;
2545: end if;

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

2544: end;
2545: end if;
2546: else
2547: -- invalid pay method.
2548: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2549: hr_utility.raise_error;
2550: --
2551: end if;
2552: --

Line 2549: hr_utility.raise_error;

2545: end if;
2546: else
2547: -- invalid pay method.
2548: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2549: hr_utility.raise_error;
2550: --
2551: end if;
2552: --
2553: end if;

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

2555: flush_payments;
2556: --
2557: exception
2558: when NO_DATA_FOUND then
2559: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2560: hr_utility.raise_error;
2561: end pay_third_party;
2562: --
2563: ------------------- get_dynamic_org_method -------------------

Line 2560: hr_utility.raise_error;

2556: --
2557: exception
2558: when NO_DATA_FOUND then
2559: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2560: hr_utility.raise_error;
2561: end pay_third_party;
2562: --
2563: ------------------- get_dynamic_org_method -------------------
2564: /*

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

2635: and p_effective_date between opm.effective_start_date
2636: and opm.effective_end_date;
2637:
2638: if ((l_paytype = 0) or (l_ext_acc = 0)) then
2639: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2640: hr_utility.raise_error;
2641: end if;
2642: --
2643: else

Line 2640: hr_utility.raise_error;

2636: and opm.effective_end_date;
2637:
2638: if ((l_paytype = 0) or (l_ext_acc = 0)) then
2639: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2640: hr_utility.raise_error;
2641: end if;
2642: --
2643: else
2644: dbms_sql.close_cursor(sql_cursor);

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

2641: end if;
2642: --
2643: else
2644: dbms_sql.close_cursor(sql_cursor);
2645: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2646: hr_utility.raise_error;
2647: end if;
2648: --
2649: p_org_method_id := l_org_method_id;

Line 2646: hr_utility.raise_error;

2642: --
2643: else
2644: dbms_sql.close_cursor(sql_cursor);
2645: hr_utility.set_message(801,'HR_50412_INVALID_ORG_PAYMETH');
2646: hr_utility.raise_error;
2647: end if;
2648: --
2649: p_org_method_id := l_org_method_id;
2650: --

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

2748: l_org_context_name pay_legislation_contexts.input_value_name%type;
2749: --
2750: begin
2751: --
2752: hr_utility.trace('Enter process_org_third_party');
2753: --
2754: g_pre_payments.delete;
2755: pay_left := 0;
2756: --

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

2758: 'ORGANIZATION_ID');
2759: --
2760: for orgrec in get_orgs (p_asg_act, l_org_context_name) loop
2761: --
2762: hr_utility.trace('Process Org '||orgrec.organization_id);
2763: --
2764: for payments in get_opms(p_asg_act, orgrec.organization_id) loop
2765: --
2766: get_balance_value(p_def_balance => payments.defined_balance_id,

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

2767: p_assignment_actions => p_asg_act,
2768: p_balance_value => l_bal_value,
2769: p_org_id => orgrec.organization_id);
2770: --
2771: hr_utility.trace('Amount to Pay '||l_bal_value);
2772: hr_utility.trace('Time Def '||payments.time_def_id);
2773: hr_utility.trace('Payment Date '||payments.payment_date);
2774: --
2775: if fnd_number.canonical_to_number(l_bal_value) <> 0 then

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

2768: p_balance_value => l_bal_value,
2769: p_org_id => orgrec.organization_id);
2770: --
2771: hr_utility.trace('Amount to Pay '||l_bal_value);
2772: hr_utility.trace('Time Def '||payments.time_def_id);
2773: hr_utility.trace('Payment Date '||payments.payment_date);
2774: --
2775: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2776: valid_date := (fnd_date.canonical_to_date(p_eff_date) -

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

2769: p_org_id => orgrec.organization_id);
2770: --
2771: hr_utility.trace('Amount to Pay '||l_bal_value);
2772: hr_utility.trace('Time Def '||payments.time_def_id);
2773: hr_utility.trace('Payment Date '||payments.payment_date);
2774: --
2775: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2776: valid_date := (fnd_date.canonical_to_date(p_eff_date) -
2777: payments.valid_days);

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

2822: payments.payee_org_method,
2823: payments.payment_date);
2824: --
2825: if pay_left > 0 then
2826: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2827: hr_utility.raise_error;
2828: end if;
2829: --
2830: end if;

Line 2827: hr_utility.raise_error;

2823: payments.payment_date);
2824: --
2825: if pay_left > 0 then
2826: hr_utility.set_message(801,'HR_6442_PAYM_MISSING_UNITS');
2827: hr_utility.raise_error;
2828: end if;
2829: --
2830: end if;
2831: else

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

2829: --
2830: end if;
2831: else
2832: -- invalid pay method.
2833: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2834: hr_utility.raise_error;
2835: --
2836: end if;
2837: --

Line 2834: hr_utility.raise_error;

2830: end if;
2831: else
2832: -- invalid pay method.
2833: hr_utility.set_message(801,'HR_7723_PAYM_NO_PAY_METHOD');
2834: hr_utility.raise_error;
2835: --
2836: end if;
2837: --
2838: end if;

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

2843: end loop;
2844: --
2845: end loop;
2846: --
2847: hr_utility.trace('Exit process_org_third_party');
2848: --
2849: end process_org_third_party;
2850: --
2851: procedure process_third_party(p_asg_act in number,

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

2859: l_entry number;
2860: l_assignment_id number;
2861: begin
2862: --
2863: hr_utility.trace('Enter process_third_party');
2864: --
2865: do_process := TRUE;
2866: while (do_process = TRUE) loop
2867: begin

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

2895: p_eff_date => p_eff_date,
2896: p_master_aa_id => p_master_aa_id
2897: );
2898: --
2899: hr_utility.trace('Exit process_third_party');
2900: --
2901: end process_third_party;
2902: --
2903: procedure process_action(p_asg_act in number,

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

3021: pre_asg_actid number;
3022: --
3023: begin
3024: --
3025: hr_utility.trace('Enter create_child_actions');
3026: --
3027: prev_tu := -1;
3028: --
3029: found_tu := FALSE;

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

3033: --
3034: if (p_multi_gre_payment = 'N') then
3035: for turec in get_tu_child(p_asg_act) loop
3036: --
3037: hr_utility.trace('Found Pro Asg '||turec.assignment_id||' '||
3038: 'TU ='||turec.run_tax_unit_id);
3039: --
3040: found_tu := TRUE;
3041: --

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

3081: prev_asg_id := -1;
3082: --
3083: for asgrec in get_mlt_asg(p_asg_act) loop
3084: --
3085: hr_utility.trace('Found Non Pro Asg '||asgrec.assignment_id);
3086: --
3087: if (prev_asg_id <> asgrec.assignment_id) then
3088: select pay_assignment_actions_s.nextval
3089: into pre_asg_actid

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

3113: end if;
3114: --
3115: p_multi_gre := found_tu;
3116: --
3117: hr_utility.trace('Exit create_child_actions');
3118: --
3119: end create_child_actions;
3120: --
3121: procedure do_prepayment(p_asg_act in number,

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

3156: l_multi_gre boolean;
3157: --
3158: begin
3159: --
3160: hr_utility.trace('Enter do_prepayment');
3161: l_eff_date := fnd_date.canonical_to_date(p_effective_date);
3162: child_processed := FALSE;
3163: --
3164: create_child_actions(p_asg_act,

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

3223: p_def_bal_id,
3224: p_effective_date,
3225: l_pay_left);
3226:
3227: hr_utility.trace('Exit do_prepayment');
3228: --
3229: end do_prepayment;
3230: --
3231: --------------------------------- get_trx_date ------------------------------