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

Line 121: hr_utility.set_location('pay_advance_pay_pkg.get_balance', 5);

117: and fue.business_group_id = asg.business_group_id)));
118: --
119: begin
120: --
121: hr_utility.set_location('pay_advance_pay_pkg.get_balance', 5);
122:
123: open creator_id;
124: fetch creator_id into l_creator_id;
125: --

Line 137: hr_utility.set_location('pay_advance_pay_pkg.get_balance', 80);

133: close creator_id;
134:
135: return l_balance_value;
136:
137: hr_utility.set_location('pay_advance_pay_pkg.get_balance', 80);
138:
139: end get_balance;
140: -------------------------------------------------------------------------------
141: function get_processed_flag

Line 246: hr_utility.set_location('pay_advance_pay_pkg.get_period_end_date' , 5);

242: ptp.end_date >= p_session_date;
243: --
244: begin
245: --
246: hr_utility.set_location('pay_advance_pay_pkg.get_period_end_date' , 5);
247:
248: open period_end_date;
249: fetch period_end_date into l_period_end_date;
250:

Line 252: hr_utility.trace('session_date'|| fnd_date.date_to_canonical(p_session_date));

248: open period_end_date;
249: fetch period_end_date into l_period_end_date;
250:
251: if period_end_date%notfound then
252: hr_utility.trace('session_date'|| fnd_date.date_to_canonical(p_session_date));
253: hr_utility.set_message (801,'PAY_52103_PERIOD_NOT_EXIST');
254: hr_utility.raise_error;
255: end if;
256: --

Line 253: hr_utility.set_message (801,'PAY_52103_PERIOD_NOT_EXIST');

249: fetch period_end_date into l_period_end_date;
250:
251: if period_end_date%notfound then
252: hr_utility.trace('session_date'|| fnd_date.date_to_canonical(p_session_date));
253: hr_utility.set_message (801,'PAY_52103_PERIOD_NOT_EXIST');
254: hr_utility.raise_error;
255: end if;
256: --
257: close period_end_date;

Line 254: hr_utility.raise_error;

250:
251: if period_end_date%notfound then
252: hr_utility.trace('session_date'|| fnd_date.date_to_canonical(p_session_date));
253: hr_utility.set_message (801,'PAY_52103_PERIOD_NOT_EXIST');
254: hr_utility.raise_error;
255: end if;
256: --
257: close period_end_date;
258: --

Line 261: hr_utility.set_location('pay_advance_pay_pkg.get_period_end_date' , 80);

257: close period_end_date;
258: --
259: return l_period_end_date;
260: --
261: hr_utility.set_location('pay_advance_pay_pkg.get_period_end_date' , 80);
262: --
263: end get_period_end_date;
264: ------------------------------------------------------------------------
265: function get_period_start_date

Line 296: hr_utility.set_location('pay_advance_pay_pkg.get_period_start_date' , 5);

292: ptp.end_date >= p_session_date;
293:
294: begin
295:
296: hr_utility.set_location('pay_advance_pay_pkg.get_period_start_date' , 5);
297:
298: open period_start_date;
299: fetch period_start_date into l_period_start_date;
300:

Line 302: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');

298: open period_start_date;
299: fetch period_start_date into l_period_start_date;
300:
301: if period_start_date%notfound then
302: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
303: hr_utility.raise_error;
304: end if;
305: --
306: close period_start_date;

Line 303: hr_utility.raise_error;

299: fetch period_start_date into l_period_start_date;
300:
301: if period_start_date%notfound then
302: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
303: hr_utility.raise_error;
304: end if;
305: --
306: close period_start_date;
307: --

Line 310: hr_utility.set_location('pay_advance_pay_pkg.get_period_start_date' , 80);

306: close period_start_date;
307: --
308: return l_period_start_date;
309: --
310: hr_utility.set_location('pay_advance_pay_pkg.get_period_start_date' , 80);
311: --
312: end get_period_start_date;
313: ------------------------------------------------------------------------
314: function get_advance_period_start_date

Line 371: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_start_date' , 5);

367: aptp.end_date >= ptp.regular_payment_date;
368:
369: begin
370:
371: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_start_date' , 5);
372: if p_flag = 'N' then
373: open period_start_date;
374: fetch period_start_date into l_period_start_date;
375:

Line 377: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');

373: open period_start_date;
374: fetch period_start_date into l_period_start_date;
375:
376: if period_start_date%notfound then
377: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
378: hr_utility.raise_error;
379: end if;
380: --
381: close period_start_date;

Line 378: hr_utility.raise_error;

374: fetch period_start_date into l_period_start_date;
375:
376: if period_start_date%notfound then
377: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
378: hr_utility.raise_error;
379: end if;
380: --
381: close period_start_date;
382: --

Line 388: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');

384: open r_period_start_date;
385: fetch r_period_start_date into l_period_start_date;
386:
387: if r_period_start_date%notfound then
388: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
389: hr_utility.raise_error;
390: end if;
391: --
392: close r_period_start_date;

Line 389: hr_utility.raise_error;

385: fetch r_period_start_date into l_period_start_date;
386:
387: if r_period_start_date%notfound then
388: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
389: hr_utility.raise_error;
390: end if;
391: --
392: close r_period_start_date;
393: --

Line 398: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_start_date' , 80);

394: end if;
395: --
396: return l_period_start_date;
397: --
398: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_start_date' , 80);
399: --
400: end get_advance_period_start_date;
401: ------------------------------------------------------------------------
402: function get_advance_period_end_date

Line 459: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_end_date' , 5);

455: aptp.end_date >= ptp.regular_payment_date;
456:
457: begin
458:
459: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_end_date' , 5);
460:
461: if p_flag = 'N' then
462: --
463: open period_start_date;

Line 467: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');

463: open period_start_date;
464: fetch period_start_date into l_period_start_date;
465:
466: if period_start_date%notfound then
467: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
468: hr_utility.raise_error;
469: end if;
470: --
471: close period_start_date;

Line 468: hr_utility.raise_error;

464: fetch period_start_date into l_period_start_date;
465:
466: if period_start_date%notfound then
467: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
468: hr_utility.raise_error;
469: end if;
470: --
471: close period_start_date;
472: --

Line 479: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');

475: open r_period_start_date;
476: fetch r_period_start_date into l_period_start_date;
477:
478: if r_period_start_date%notfound then
479: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
480: hr_utility.raise_error;
481: end if;
482: --
483: close r_period_start_date;

Line 480: hr_utility.raise_error;

476: fetch r_period_start_date into l_period_start_date;
477:
478: if r_period_start_date%notfound then
479: hr_utility.set_message (801, 'PAY_52103_PERIOD_NOT_EXIST');
480: hr_utility.raise_error;
481: end if;
482: --
483: close r_period_start_date;
484: --

Line 489: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_end_date' , 80);

485: end if;
486: --
487: return l_period_start_date;
488: --
489: hr_utility.set_location('pay_advance_pay_pkg.get_advance_period_end_date' , 80);
490: --
491: end get_advance_period_end_date;
492: ------------------------------------------------------------------------
493: procedure insert_indicator_entries

Line 530: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 5);

526: l_pai_element_entry_id number;
527: --
528: begin
529: --
530: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 5);
531: --
532: l_arrears_offset := 0;
533: l_advance_pay := 'Y';
534: l_defer_pay := p_defer_flag;

Line 551: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 60);

547: );
548: --
549: l_element_entry_end_date := l_element_entry_start_date;
550:
551: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 60);
552: --
553: hr_entry_api.insert_element_entry
554: (
555: p_effective_start_date => l_element_entry_start_date,

Line 590: hr_utility.trace('l_element_entry_start_date (1): ' ||

586: -- dates changed in the loop to fall within each pay period
587:
588: l_element_entry_start_date := p_advance_pay_start_date;
589:
590: hr_utility.trace('l_element_entry_start_date (1): ' ||
591: fnd_date.date_to_canonical(l_element_entry_start_date));
592:
593: l_element_entry_end_date := pay_advance_pay_pkg.get_period_end_date
594: (

Line 615: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 70);

611: l_pay_periods = (p_periods_advanced + l_arrears_offset) then
612: l_defer_pay := 'N';
613: end if;
614: --
615: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 70);
616: --
617: hr_entry_api.insert_element_entry
618: (
619: p_effective_start_date => l_element_entry_start_date,

Line 641: hr_utility.trace('l_element_entry_start_date (2): ' ||

637: );
638: --
639: -- move to the next pay period
640: --
641: hr_utility.trace('l_element_entry_start_date (2): ' ||
642: fnd_date.date_to_canonical(l_element_entry_start_date));
643: l_element_entry_start_date := pay_advance_pay_pkg.get_period_end_date
644: (
645: p_assignment_id,

Line 649: hr_utility.trace('l_element_entry_start_date (3): ' ||

645: p_assignment_id,
646: l_element_entry_start_date
647: ) + 1;
648: --
649: hr_utility.trace('l_element_entry_start_date (3): ' ||
650: fnd_date.date_to_canonical(l_element_entry_start_date));
651: --
652: l_element_entry_end_date := pay_advance_pay_pkg.get_period_end_date
653: (

Line 663: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 80);

659: --
660: p_session_date := l_session_date;
661: p_pai_element_entry_id := l_pai_element_entry_id;
662: --
663: hr_utility.set_location('pay_advance_pay_pkg.insert_indicator_entries', 80);
664: --
665: end insert_indicator_entries;
666: ------------------------------------------------------------------------
667: procedure delete_indicator_entries

Line 719: hr_utility.set_location('pay_advance_pay_pkg.delete_indicator_entries' , 5);

715: and l_indicators_end_date;
716:
717: begin
718: --
719: hr_utility.set_location('pay_advance_pay_pkg.delete_indicator_entries' , 5);
720: --
721: -- fetch advance dates
722: open advance_dates;
723: fetch advance_dates into l_indicators_start_date,

Line 746: hr_utility.trace('p_pai_element_entry_id: ' || to_char(p_pai_element_entry_id));

742: );
743: end if;
744:
745: -- trace dates used to remove Advance Indicators
746: hr_utility.trace('p_pai_element_entry_id: ' || to_char(p_pai_element_entry_id));
747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));
748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));
749:
750: -- Advance Indicator(s)

Line 747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));

743: end if;
744:
745: -- trace dates used to remove Advance Indicators
746: hr_utility.trace('p_pai_element_entry_id: ' || to_char(p_pai_element_entry_id));
747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));
748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));
749:
750: -- Advance Indicator(s)
751:

Line 748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));

744:
745: -- trace dates used to remove Advance Indicators
746: hr_utility.trace('p_pai_element_entry_id: ' || to_char(p_pai_element_entry_id));
747: hr_utility.trace('l_indicators_start_date: ' || fnd_date.date_to_canonical(l_indicators_start_date));
748: hr_utility.trace('l_indicators_end_date: ' || fnd_date.date_to_canonical(l_indicators_end_date));
749:
750: -- Advance Indicator(s)
751:
752: -- first Advance Indicator element_entry_id

Line 760: hr_utility.set_location('pay_advance_pay_pkg.delete_indicator_entries' , 10);

756: l_effective_start_date;
757:
758: while corresponding_ai_entries%found loop
759:
760: hr_utility.set_location('pay_advance_pay_pkg.delete_indicator_entries' , 10);
761:
762: hr_entry_api.delete_element_entry
763: (
764: p_dt_delete_mode =>'ZAP',

Line 777: hr_utility.set_location('pay_advance_pay_pkg.delete_indicator_entries' , 80);

773: end loop;
774:
775: close corresponding_ai_entries;
776:
777: hr_utility.set_location('pay_advance_pay_pkg.delete_indicator_entries' , 80);
778:
779: end delete_indicator_entries;
780: ------------------------------------------------------------------------
781: end pay_advance_pay_pkg;