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

Line 114: hr_utility.set_location('pay_sla_pkg.trans_asg_costs',10);

110: l_event_source_info xla_events_pub_pkg.t_event_source_info;
111: l_security_context xla_events_pub_pkg.t_security;
112: BEGIN
113: --
114: hr_utility.set_location('pay_sla_pkg.trans_asg_costs',10);
115: --
116: SELECT pa.payroll_action_id,
117: pa1.assignment_id,
118: pa1.assignment_action_id,

Line 153: hr_utility.set_location('pytrgl.trans_ass_costs',20);

149: if (c_action_type IN ('C', 'S')) then
150: --
151: -- Costing or Retrocosting : event class COSTS
152: --
153: hr_utility.set_location('pytrgl.trans_ass_costs',20);
154: --
155: SELECT pa2.assignment_action_id,
156: ppa2.payroll_action_id,
157: ppa2.action_type,

Line 243: hr_utility.set_location('pytrgl.trans_ass_costs',30);

239: elsif (c_action_type = 'EC') then
240: --
241: -- Estimate Costing : event class ESTIMATE_COSTS
242: --
243: hr_utility.set_location('pytrgl.trans_ass_costs',30);
244: --
245: SELECT pay_sla_pkg.get_ecost_accounting_date
246: (pera.payroll_id, c_effective_date),
247: pap.gl_set_of_books_id

Line 385: hr_utility.set_location('pay_sla_pkg.post_process_event',10);

381: AND PAYE.event_status <> 'C';
382:
383: BEGIN
384: --
385: hr_utility.set_location('pay_sla_pkg.post_process_event',10);
386: --
387: IF (p_application_id <> 801) THEN
388: RETURN;
389: END IF;

Line 400: hr_utility.set_location('pay_sla_pkg.post_process_event',10);

396: END IF;
397: --
398: for xlarec in xla_events_cur loop
399: --
400: hr_utility.set_location('pay_sla_pkg.post_process_event',10);
401: --
402: --
403: -- Mark the Events as complete
404: --

Line 427: hr_utility.set_location('Entering pay_sla_pkg.get_conversion_type',10);

423: l_user_currency_type VARCHAR2(30);
424: l_currency_type VARCHAR2(30);
425: BEGIN
426: --
427: hr_utility.set_location('Entering pay_sla_pkg.get_conversion_type',10);
428: --
429: if (g_business_group_id is not null) and
430: (i_business_group_id = g_business_group_id) and
431: (i_conversion_date = g_conversion_date) then

Line 441: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_user_currency_type '||l_user_currency_type,15);

437: l_user_currency_type := hruserdt.get_table_value(i_business_group_id,
438: 'EXCHANGE_RATE_TYPES', 'Conversion Rate Type',
439: 'PAY',i_conversion_date);
440:
441: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_user_currency_type '||l_user_currency_type,15);
442: /*Begin Bug 7283055 USER_CONVERSION_TYPE was getting returned need to return Conversion Type */
443: open get_conv_type(l_user_currency_type);
444: fetch get_conv_type into l_currency_type;
445: close get_conv_type;

Line 452: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);

448: g_business_group_id := i_business_group_id;
449: g_conversion_date := i_conversion_date;
450: --
451: end if;
452: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);
453: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);
454: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);
455: --
456: return(l_currency_type);

Line 453: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);

449: g_conversion_date := i_conversion_date;
450: --
451: end if;
452: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);
453: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);
454: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);
455: --
456: return(l_currency_type);
457: --

Line 454: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);

450: --
451: end if;
452: hr_utility.set_location('In pay_sla_pkg.get_conversion_type l_currency_type '||l_currency_type,20);
453: hr_utility.set_location('In pay_sla_pkg.get_conversion_type g_currency_type '||g_currency_type,30);
454: hr_utility.set_location('Leaving pay_sla_pkg.get_conversion_type',40);
455: --
456: return(l_currency_type);
457: --
458: END get_conversion_type;

Line 469: hr_utility.set_location('pay_sla_pkg.get_accounting_date',10);

465: RETURN DATE IS
466: l_accounting_date DATE;
467: BEGIN
468: --
469: hr_utility.set_location('pay_sla_pkg.get_accounting_date',10);
470: --
471: if (run_action_type in ('B', 'V')) then
472: --
473: -- For Reversals and Balance Adjustments

Line 530: hr_utility.set_location('pay_sla_pkg.get_ecost_accounting_date',10);

526: RETURN DATE IS
527: l_accounting_date DATE;
528: BEGIN
529: --
530: hr_utility.set_location('pay_sla_pkg.get_ecost_accounting_date',10);
531: --
532: --
533: -- For Estimate Costs
534: -- negation deltas at end of payroll period only

Line 599: hr_utility.set_location('pay_sla_pkg.preaccounting',10);

595: p_report_request_id NUMBER)
596: IS
597: BEGIN
598: --
599: hr_utility.set_location('pay_sla_pkg.preaccounting',10);
600: --
601: END preaccounting;
602: --
603: -- Stub for XLA postaccounting hook

Line 622: hr_utility.set_location('pay_sla_pkg.postaccounting',10);

618: p_report_request_id NUMBER)
619: IS
620: BEGIN
621: --
622: hr_utility.set_location('pay_sla_pkg.postaccounting',10);
623: --
624: END postaccounting;
625: --
626: --

Line 635: hr_utility.set_location('pay_sla_pkg.extract',10);

631: p_accounting_mode VARCHAR2)
632: IS
633: BEGIN
634: --
635: hr_utility.set_location('pay_sla_pkg.extract',10);
636: --
637: END extract;
638: --
639: -- Delet_event : called form rollback code

Line 657: hr_utility.set_location('pay_sla_pkg.delete_event',10);

653: l_security_context xla_events_pub_pkg.t_security;
654:
655: BEGIN
656: --
657: hr_utility.set_location('pay_sla_pkg.delete_event',10);
658: --
659: -- Confirm no Completed events for this action
660: --
661: SELECT count(*)

Line 672: hr_utility.trace('delete_event failed more than 1 C event');

668:
669: --
670: -- SLA has processed the event and passed to GL
671: --
672: hr_utility.trace('delete_event failed more than 1 C event');
673: hr_utility.set_message (801, 'HR_7507_ACTION_UNDO_INTLOCK');
674: hr_utility.raise_error;
675:
676: ELSE

Line 673: hr_utility.set_message (801, 'HR_7507_ACTION_UNDO_INTLOCK');

669: --
670: -- SLA has processed the event and passed to GL
671: --
672: hr_utility.trace('delete_event failed more than 1 C event');
673: hr_utility.set_message (801, 'HR_7507_ACTION_UNDO_INTLOCK');
674: hr_utility.raise_error;
675:
676: ELSE
677:

Line 674: hr_utility.raise_error;

670: -- SLA has processed the event and passed to GL
671: --
672: hr_utility.trace('delete_event failed more than 1 C event');
673: hr_utility.set_message (801, 'HR_7507_ACTION_UNDO_INTLOCK');
674: hr_utility.raise_error;
675:
676: ELSE
677:
678: SELECT pap.gl_set_of_books_id

Line 694: hr_utility.trace('Set of books id is'||l_ledger_id);

690: AND ppa1.payroll_id = pap.payroll_id (+)
691: AND ppa1.effective_date BETWEEN pap.effective_start_date (+)
692: AND pap.effective_end_date (+);
693:
694: hr_utility.trace('Set of books id is'||l_ledger_id);
695:
696: IF l_ledger_id is null then
697:
698: SELECT pap.gl_set_of_books_id

Line 734: hr_utility.trace('Before XLA_EVENTS_PUB_PKG.delete_event');

730:
731: l_event_source_info.source_id_char_1 := to_char(xlarec.accounting_date,
732: 'YYYY/MM/DD');
733:
734: hr_utility.trace('Before XLA_EVENTS_PUB_PKG.delete_event');
735: -- delete the event in SLA
736: XLA_EVENTS_PUB_PKG.delete_event (
737: p_event_source_info => l_event_source_info,
738: p_event_id => xlarec.event_id,

Line 742: hr_utility.trace('After XLA_EVENTS_PUB_PKG.delete_event');

738: p_event_id => xlarec.event_id,
739: p_valuation_method => null,
740: p_security_context => l_security_context
741: );
742: hr_utility.trace('After XLA_EVENTS_PUB_PKG.delete_event');
743: end loop;
744:
745: -- delete the event from pay_xla_events
746: DELETE from pay_xla_events

Line 794: hr_utility.set_location('pay_sla_pkg.create_custom_adrs',10);

790: l_rule_det_seq xla_rule_details_t.user_sequence%type;
791: --
792: BEGIN
793: --
794: hr_utility.set_location('pay_sla_pkg.create_custom_adrs',10);
795: --
796: for segmap in segmaps loop
797:
798: l_acc_segment := segmap.gl_account_segment;