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_PAYMENTS dependencies on HR_UTILITY

Line 63: hr_utility.set_location('HR_PAYMENTS.VALIDATE_MAGNETIC',1);

59: validation_value in varchar2) return boolean is
60: --
61: begin
62: --
63: hr_utility.set_location('HR_PAYMENTS.VALIDATE_MAGNETIC',1);
64: --
65: -- Check mand values for mag method are there.
66: --
67: if validate is null then

Line 69: hr_utility.set_message(801,'HR_6227_PAYM_MAND_MAG_DETAILS');

65: -- Check mand values for mag method are there.
66: --
67: if validate is null then
68: --
69: hr_utility.set_message(801,'HR_6227_PAYM_MAND_MAG_DETAILS');
70: hr_utility.raise_error;
71: return(false);
72: --
73: end if;

Line 70: hr_utility.raise_error;

66: --
67: if validate is null then
68: --
69: hr_utility.set_message(801,'HR_6227_PAYM_MAND_MAG_DETAILS');
70: hr_utility.raise_error;
71: return(false);
72: --
73: end if;
74: --

Line 83: hr_utility.set_message(801,'HR_6228_PAYM_NO_VALIDATION');

79: -- Magnetic validation required. Days and values must be set
80: --
81: if validation_days is null or validation_value is null then
82: --
83: hr_utility.set_message(801,'HR_6228_PAYM_NO_VALIDATION');
84: hr_utility.raise_error;
85: return(false);
86: --
87: end if;

Line 84: hr_utility.raise_error;

80: --
81: if validation_days is null or validation_value is null then
82: --
83: hr_utility.set_message(801,'HR_6228_PAYM_NO_VALIDATION');
84: hr_utility.raise_error;
85: return(false);
86: --
87: end if;
88: --

Line 107: hr_utility.set_location('HR_PAYMENTS.CHECK_DEFAULT',1);

103: */
104: function check_ok_default(category in varchar2) return boolean is
105: begin
106: --
107: hr_utility.set_location('HR_PAYMENTS.CHECK_DEFAULT',1);
108: --
109: if category = 'CA' or category = 'CH' then
110: --
111: return(true);

Line 115: hr_utility.set_message(801,'HR_6229_PAYM_BAD_DEFAULT_TYPE');

111: return(true);
112: --
113: else
114: --
115: hr_utility.set_message(801,'HR_6229_PAYM_BAD_DEFAULT_TYPE');
116: hr_utility.raise_error;
117: return(false);
118: --
119: end if;

Line 116: hr_utility.raise_error;

112: --
113: else
114: --
115: hr_utility.set_message(801,'HR_6229_PAYM_BAD_DEFAULT_TYPE');
116: hr_utility.raise_error;
117: return(false);
118: --
119: end if;
120: --

Line 175: hr_utility.set_location('HR_PAYMENTS.CHECK_ACCOUNT',1);

171: begin
172: --
173: -- One row each from EXA and PPT.
174: --
175: hr_utility.set_location('HR_PAYMENTS.CHECK_ACCOUNT',1);
176: --
177: select ppt.territory_code,
178: exa.territory_code
179: into required_territory,

Line 188: hr_utility.set_location('HR_PAYMENTS.CHECK_ACCOUNT',2);

184: and ppt.payment_type_id = type;
185: --
186: -- Check that they are the same and generate an error if not
187: --
188: hr_utility.set_location('HR_PAYMENTS.CHECK_ACCOUNT',2);
189: --
190: if required_territory <> actual_territory then
191: --
192: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');

Line 192: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');

188: hr_utility.set_location('HR_PAYMENTS.CHECK_ACCOUNT',2);
189: --
190: if required_territory <> actual_territory then
191: --
192: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');
193: hr_utility.set_message_token('TERITORY',required_territory);
194: hr_utility.raise_error;
195: return(false);
196: --

Line 193: hr_utility.set_message_token('TERITORY',required_territory);

189: --
190: if required_territory <> actual_territory then
191: --
192: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');
193: hr_utility.set_message_token('TERITORY',required_territory);
194: hr_utility.raise_error;
195: return(false);
196: --
197: else

Line 194: hr_utility.raise_error;

190: if required_territory <> actual_territory then
191: --
192: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');
193: hr_utility.set_message_token('TERITORY',required_territory);
194: hr_utility.raise_error;
195: return(false);
196: --
197: else
198: --

Line 207: hr_utility.set_message(801,'HR_6230_PAYM_NO_ACCT_TYPE');

203: exception
204: --
205: when no_data_found then
206: --
207: hr_utility.set_message(801,'HR_6230_PAYM_NO_ACCT_TYPE');
208: hr_utility.raise_error;
209: return(false);
210: --
211: --

Line 208: hr_utility.raise_error;

204: --
205: when no_data_found then
206: --
207: hr_utility.set_message(801,'HR_6230_PAYM_NO_ACCT_TYPE');
208: hr_utility.raise_error;
209: return(false);
210: --
211: --
212: end check_account;

Line 230: hr_utility.set_location('HR_PAYMENTS.CHECK_CURRENCY',1);

226: opm_currency in varchar2) return boolean is
227: required_currency varchar2(16);
228: begin
229: --
230: hr_utility.set_location('HR_PAYMENTS.CHECK_CURRENCY',1);
231: --
232: select ppt.currency_code
233: into required_currency
234: from pay_payment_types ppt

Line 241: hr_utility.set_message(801,'HR_6231_PAYM_INVALID_CURRENCY');

237: -- Check that they are the same. If not report the error
238: --
239: if nvl(required_currency,opm_currency) <> opm_currency then
240: --
241: hr_utility.set_message(801,'HR_6231_PAYM_INVALID_CURRENCY');
242: hr_utility.set_message_token('CURRENCY',required_currency);
243: hr_utility.raise_error;
244: return(false);
245: --

Line 242: hr_utility.set_message_token('CURRENCY',required_currency);

238: --
239: if nvl(required_currency,opm_currency) <> opm_currency then
240: --
241: hr_utility.set_message(801,'HR_6231_PAYM_INVALID_CURRENCY');
242: hr_utility.set_message_token('CURRENCY',required_currency);
243: hr_utility.raise_error;
244: return(false);
245: --
246: else

Line 243: hr_utility.raise_error;

239: if nvl(required_currency,opm_currency) <> opm_currency then
240: --
241: hr_utility.set_message(801,'HR_6231_PAYM_INVALID_CURRENCY');
242: hr_utility.set_message_token('CURRENCY',required_currency);
243: hr_utility.raise_error;
244: return(false);
245: --
246: else
247: --

Line 256: hr_utility.set_message(801,'HR_6232_PAYM_NO_TYPE');

252: exception
253: --
254: when no_data_found then
255: --
256: hr_utility.set_message(801,'HR_6232_PAYM_NO_TYPE');
257: hr_utility.raise_error;
258: return(false);
259: --
260: --

Line 257: hr_utility.raise_error;

253: --
254: when no_data_found then
255: --
256: hr_utility.set_message(801,'HR_6232_PAYM_NO_TYPE');
257: hr_utility.raise_error;
258: return(false);
259: --
260: --
261: end check_currency;

Line 282: hr_utility.set_location('HR_PAYMENTS.MATCH_CURRENCY',1);

278: bal_type varchar2(9);
279: bal_currency varchar2(16);
280: begin
281: --
282: hr_utility.set_location('HR_PAYMENTS.MATCH_CURRENCY',1);
283: --
284: if check_currency(type,opm_currency) then
285: --
286: select pdb.balance_type_id

Line 332: hr_utility.set_location('HR_PAYMENTS.GEN_BALANCE',1);

328: begin
329: --
330: -- Get it then (if its there)
331: --
332: hr_utility.set_location('HR_PAYMENTS.GEN_BALANCE',1);
333: --
334: select pdb.defined_balance_id
335: into defined_balance
336: from pay_balance_types pbt,

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

350: exception
351: --
352: when no_data_found then
353: --
354: hr_utility.set_message(801,'HR_6233_PAYM_NO_PAY_BALANCE');
355: hr_utility.raise_error;
356: return(0);
357: --
358: end gen_balance;

Line 355: hr_utility.raise_error;

351: --
352: when no_data_found then
353: --
354: hr_utility.set_message(801,'HR_6233_PAYM_NO_PAY_BALANCE');
355: hr_utility.raise_error;
356: return(0);
357: --
358: end gen_balance;
359: --

Line 375: hr_utility.set_location('HR_PAYMENTS.CHECK_PREPAY',1);

371: val_start_date in varchar2) return boolean is
372: dummy varchar2(2);
373: begin
374: --
375: hr_utility.set_location('HR_PAYMENTS.CHECK_PREPAY',1);
376: --
377: select 1
378: into dummy
379: from dual

Line 401: hr_utility.set_message(801,'HR_6234_PAYM_ENTRIES_EXIST');

397: exception
398: --
399: when no_data_found then
400: --
401: hr_utility.set_message(801,'HR_6234_PAYM_ENTRIES_EXIST');
402: hr_utility.raise_error;
403: return(false);
404: --
405: end check_prepay;

Line 402: hr_utility.raise_error;

398: --
399: when no_data_found then
400: --
401: hr_utility.set_message(801,'HR_6234_PAYM_ENTRIES_EXIST');
402: hr_utility.raise_error;
403: return(false);
404: --
405: end check_prepay;
406: --

Line 432: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);

428: -- If there is a ppm which finishes after the validation start date, then
429: -- the (DE) delete is invalid. This case is given if no rows are returned
430: -- and is picked up in the error handler.
431: --
432: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);
433: --
434: select 1
435: into dummy
436: from dual

Line 455: hr_utility.set_message(801,'HR_6235_PAYM_EXISTING_PPMS');

451: exception
452: --
453: when no_data_found then
454: --
455: hr_utility.set_message(801,'HR_6235_PAYM_EXISTING_PPMS');
456: hr_utility.raise_error;
457: return(false);
458: --
459: end check_ppm;

Line 456: hr_utility.raise_error;

452: --
453: when no_data_found then
454: --
455: hr_utility.set_message(801,'HR_6235_PAYM_EXISTING_PPMS');
456: hr_utility.raise_error;
457: return(false);
458: --
459: end check_ppm;
460: --

Line 478: hr_utility.set_location('HR_PAYMENTS.CHECK_DEFAULT',1);

474: begin
475: --
476: -- Check if any payrolls use this OPM whichare valid after the delete date.
477: --
478: hr_utility.set_location('HR_PAYMENTS.CHECK_DEFAULT',1);
479: --
480: select 'Y'
481: into valid_del
482: from dual

Line 501: hr_utility.set_message(801,'HR_6236_PAYM_USED_AS_DEFAULT');

497: exception
498: --
499: when no_data_found then
500: --
501: hr_utility.set_message(801,'HR_6236_PAYM_USED_AS_DEFAULT');
502: hr_utility.raise_error;
503: return(false);
504: --
505: end check_default;

Line 502: hr_utility.raise_error;

498: --
499: when no_data_found then
500: --
501: hr_utility.set_message(801,'HR_6236_PAYM_USED_AS_DEFAULT');
502: hr_utility.raise_error;
503: return(false);
504: --
505: end check_default;
506: --

Line 531: hr_utility.set_message(801,'HR_6221_PAYM_INVALID_PPM');

527: return(true);
528: --
529: else
530: --
531: hr_utility.set_message(801,'HR_6221_PAYM_INVALID_PPM');
532: hr_utility.raise_error;
533: return(false);
534: --
535: end if;

Line 532: hr_utility.raise_error;

528: --
529: else
530: --
531: hr_utility.set_message(801,'HR_6221_PAYM_INVALID_PPM');
532: hr_utility.raise_error;
533: return(false);
534: --
535: end if;
536: --

Line 558: hr_utility.set_location('HR_PAYMENTS.MT_CHECKS',1);

554: begin
555: --
556: -- Check if an account is specified and if so get the territory
557: --
558: hr_utility.set_location('HR_PAYMENTS.MT_CHECKS',1);
559: --
560: if account_id is null then
561: --
562: actual_territory := 'NONE';

Line 579: hr_utility.set_message(801,'HR_6223_PAYM_BAD_ACCT');

575: exception
576: --
577: when no_data_found then
578: --
579: hr_utility.set_message(801,'HR_6223_PAYM_BAD_ACCT');
580: hr_utility.raise_error;
581: --
582: end;
583: --

Line 580: hr_utility.raise_error;

576: --
577: when no_data_found then
578: --
579: hr_utility.set_message(801,'HR_6223_PAYM_BAD_ACCT');
580: hr_utility.raise_error;
581: --
582: end;
583: --
584: end if;

Line 588: hr_utility.set_location('HR_PAYMENTS.MT_CHECKS',2);

584: end if;
585: --
586: -- Now make sure its in the right territory (if required)
587: --
588: hr_utility.set_location('HR_PAYMENTS.MT_CHECKS',2);
589: --
590: select nvl(ppt.territory_code, 'NONE'),
591: ppt.category
592: into required_territory,

Line 603: hr_utility.set_location('HR_PAYMENTS.MT_CHECKS',3);

599: opm.effective_start_date and opm.effective_end_date;
600: --
601: -- Check the category. If it is 'MT' do the checks...
602: --
603: hr_utility.set_location('HR_PAYMENTS.MT_CHECKS',3);
604: --
605: if category = 'MT' then
606: --
607: if actual_territory <> required_territory then

Line 611: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');

607: if actual_territory <> required_territory then
608: --
609: if required_territory <> 'NONE' then
610: --
611: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');
612: hr_utility.set_message_token('TERITORY',required_territory);
613: hr_utility.raise_error;
614: return(false);
615: --

Line 612: hr_utility.set_message_token('TERITORY',required_territory);

608: --
609: if required_territory <> 'NONE' then
610: --
611: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');
612: hr_utility.set_message_token('TERITORY',required_territory);
613: hr_utility.raise_error;
614: return(false);
615: --
616: end if;

Line 613: hr_utility.raise_error;

609: if required_territory <> 'NONE' then
610: --
611: hr_utility.set_message(801,'HR_6220_PAYM_INVALID_ACT');
612: hr_utility.set_message_token('TERITORY',required_territory);
613: hr_utility.raise_error;
614: return(false);
615: --
616: end if;
617: end if;

Line 627: hr_utility.set_message(801,'HR_6224_PAYM_NO_OPM');

623: exception
624: --
625: when no_data_found then
626: --
627: hr_utility.set_message(801,'HR_6224_PAYM_NO_OPM');
628: hr_utility.raise_error;
629: return(false);
630: --
631: end mt_checks;

Line 628: hr_utility.raise_error;

624: --
625: when no_data_found then
626: --
627: hr_utility.set_message(801,'HR_6224_PAYM_NO_OPM');
628: hr_utility.raise_error;
629: return(false);
630: --
631: end mt_checks;
632: --

Line 651: hr_utility.set_location('HR_PAYMENTS.UNIQUE_PRIORITY',1);

647: assignment in varchar2) return boolean is
648: duplicate varchar2(2);
649: begin
650: --
651: hr_utility.set_location('HR_PAYMENTS.UNIQUE_PRIORITY',1);
652: --
653: select 'N'
654: into duplicate
655: from sys.dual

Line 676: hr_utility.set_message(801,'HR_6225_PAYM_DUP_PRIORITY');

672: exception
673: --
674: when no_data_found then
675: --
676: hr_utility.set_message(801,'HR_6225_PAYM_DUP_PRIORITY');
677: hr_utility.raise_error;
678: return false;
679: --
680: end unique_priority;

Line 677: hr_utility.raise_error;

673: --
674: when no_data_found then
675: --
676: hr_utility.set_message(801,'HR_6225_PAYM_DUP_PRIORITY');
677: hr_utility.raise_error;
678: return false;
679: --
680: end unique_priority;
681: --

Line 697: hr_utility.set_location('HR_PAYMENTS.CHECK_PP',1);

693: val_start_date in varchar2) return boolean is
694: status varchar2(2);
695: begin
696: --
697: hr_utility.set_location('HR_PAYMENTS.CHECK_PP',1);
698: --
699: -- WWbug 264094. Changed below from effective_date >= val_start_date to
700: -- effective_date > val_start_date. This has the effect of allowing the
701: -- delete if there are pre-payments on the deleteion date, providing there

Line 719: hr_utility.set_location('HR_PAYMENTS.CHECK_PP',2);

715: and pa.effective_date > fnd_date.canonical_to_date(val_start_date));
716: --
717: -- If there is a row, then all is cool, but check anyhow to be defensive.
718: --
719: hr_utility.set_location('HR_PAYMENTS.CHECK_PP',2);
720: --
721: if status = 'Y' then
722: --
723: return true;

Line 733: hr_utility.set_message(801,'HR_6226_PAYM_PPS_EXIST');

729: when no_data_found then
730: --
731: -- This means future PPs exist so flag it.
732: --
733: hr_utility.set_message(801,'HR_6226_PAYM_PPS_EXIST');
734: hr_utility.raise_error;
735: return false;
736: --
737: end check_pp;

Line 734: hr_utility.raise_error;

730: --
731: -- This means future PPs exist so flag it.
732: --
733: hr_utility.set_message(801,'HR_6226_PAYM_PPS_EXIST');
734: hr_utility.raise_error;
735: return false;
736: --
737: end check_pp;
738: --

Line 759: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);

755: eff_date date;
756: begin
757: --
758: status := 'Y';
759: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);
760: hr_utility.trace('trans_step_id is '||trans_step_id);
761:
762: /*Handled the No Data Found for the bug 13010568 */
763:

Line 760: hr_utility.trace('trans_step_id is '||trans_step_id);

756: begin
757: --
758: status := 'Y';
759: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);
760: hr_utility.trace('trans_step_id is '||trans_step_id);
761:
762: /*Handled the No Data Found for the bug 13010568 */
763:
764: begin

Line 773: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',11);

769: WHERE transaction_step_id = trans_step_id;
770: exception
771: --
772: when no_data_found then
773: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',11);
774: status := 'Y';
775: return;
776: end;
777:

Line 778: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',2);

774: status := 'Y';
775: return;
776: end;
777:
778: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',2);
779:
780: select 'Y'
781: into status
782: from sys.dual

Line 793: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',4);

789: and pp.assignment_action_id = aa.assignment_action_id
790: and aa.payroll_action_id = pa.payroll_action_id
791: and pa.effective_date > eff_date);
792:
793: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',4);
794: --
795: if status = 'Y' then
796: status := 'Y';
797: --

Line 803: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',5);

799: --
800: exception
801: --
802: when no_data_found then
803: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',5);
804: status := 'N';
805: --
806: end check_ppm;
807: --