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

Line 340: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');

336: p_expiry_information := 0;
337: RETURN;
338:
339: ELSE
340: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');
341: hr_utility.raise_error;
342:
343: END IF;
344:

Line 341: hr_utility.raise_error;

337: RETURN;
338:
339: ELSE
340: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');
341: hr_utility.raise_error;
342:
343: END IF;
344:
345: IF p_user_effective_date >= l_expiry_date THEN

Line 471: hr_utility.set_message(801, 'NO_EXPIRY_DATE_FOR_DIMENSION');

467: ELSIF l_dimension_name like '%LTD' THEN
468: RETURN l_end_of_time;
469:
470: ELSE
471: hr_utility.set_message(801, 'NO_EXPIRY_DATE_FOR_DIMENSION');
472: hr_utility.raise_error;
473:
474: END IF;
475:

Line 472: hr_utility.raise_error;

468: RETURN l_end_of_time;
469:
470: ELSE
471: hr_utility.set_message(801, 'NO_EXPIRY_DATE_FOR_DIMENSION');
472: hr_utility.raise_error;
473:
474: END IF;
475:
476: END get_expiry_date;

Line 534: hr_utility.trace('Entered the procedure date_ec');

530: l_end_of_time CONSTANT DATE := to_date('31/12/4712','DD/MM/YYYY');
531:
532: BEGIN
533:
534: hr_utility.trace('Entered the procedure date_ec');
535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);
536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);

Line 535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);

531:
532: BEGIN
533:
534: hr_utility.trace('Entered the procedure date_ec');
535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);
536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);

Line 536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);

532: BEGIN
533:
534: hr_utility.trace('Entered the procedure date_ec');
535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);
536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);
540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);

Line 537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);

533:
534: hr_utility.trace('Entered the procedure date_ec');
535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);
536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);
540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);
541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);

Line 538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);

534: hr_utility.trace('Entered the procedure date_ec');
535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);
536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);
540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);
541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);
542:

Line 539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);

535: hr_utility.trace('p_owner_payroll_action_id ===>' || p_owner_payroll_action_id);
536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);
540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);
541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);
542:
543: IF p_dimension_name like '%MPF_PTD' THEN

Line 540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);

536: hr_utility.trace('p_user_payroll_action_id ===>' || p_user_payroll_action_id);
537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);
540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);
541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);
542:
543: IF p_dimension_name like '%MPF_PTD' THEN
544: p_expiry_date := next_ri_period(p_owner_payroll_action_id) - 1;

Line 541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);

537: hr_utility.trace('p_owner_assignment_action_id ===>' || p_owner_assignment_action_id);
538: hr_utility.trace('p_user_assignment_action_id ===>' || p_user_assignment_action_id);
539: hr_utility.trace('p_owner_effective_date ===>' || p_owner_effective_date);
540: hr_utility.trace('p_user_effective_date ===>' || p_user_effective_date);
541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);
542:
543: IF p_dimension_name like '%MPF_PTD' THEN
544: p_expiry_date := next_ri_period(p_owner_payroll_action_id) - 1;
545: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 545: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

541: hr_utility.trace('p_dimension_name ===>' || p_dimension_name);
542:
543: IF p_dimension_name like '%MPF_PTD' THEN
544: p_expiry_date := next_ri_period(p_owner_payroll_action_id) - 1;
545: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
546:
547: ELSIF p_dimension_name like '%MPF_MONTH' THEN
548: p_expiry_date := next_ri_month(p_owner_payroll_action_id) - 1;
549: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 549: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

545: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
546:
547: ELSIF p_dimension_name like '%MPF_MONTH' THEN
548: p_expiry_date := next_ri_month(p_owner_payroll_action_id) - 1;
549: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
550:
551: ELSIF p_dimension_name like '%MPF_QTD' THEN
552: p_expiry_date := next_ri_quarter(p_owner_payroll_action_id) - 1;
553: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 553: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

549: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
550:
551: ELSIF p_dimension_name like '%MPF_QTD' THEN
552: p_expiry_date := next_ri_quarter(p_owner_payroll_action_id) - 1;
553: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
554:
555: ELSIF p_dimension_name like '%MPF_YTD' THEN
556: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
557: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned

Line 563: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

559: ,-1,0,1)),'DD-MM-YYYY') - 1
560: INTO p_expiry_date
561: FROM pay_payroll_actions PACT
562: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
563: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
564:
565: ELSIF p_dimension_name like '%PTD' THEN
566: p_expiry_date := next_period(p_owner_payroll_action_id,p_owner_effective_date) - 1;
567: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 567: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

563: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
564:
565: ELSIF p_dimension_name like '%PTD' THEN
566: p_expiry_date := next_period(p_owner_payroll_action_id,p_owner_effective_date) - 1;
567: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
568:
569: ELSIF p_dimension_name like '%MONTH' THEN
570: p_expiry_date := next_month(p_owner_effective_date) - 1;
571: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 571: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

567: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
568:
569: ELSIF p_dimension_name like '%MONTH' THEN
570: p_expiry_date := next_month(p_owner_effective_date) - 1;
571: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
572:
573: ELSIF p_dimension_name like '%FQTD' THEN
574: SELECT fnd_date.canonical_to_date(org_information11)
575: INTO l_beg_of_fiscal_year

Line 582: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

578: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
579: AND HOI.organization_id = PACT.business_group_id
580: AND PACT.payroll_action_id = p_owner_payroll_action_id;
581: p_expiry_date := next_fiscal_quarter(l_beg_of_fiscal_year,p_owner_effective_date) - 1;
582: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
583:
584: ELSIF p_dimension_name like '%FYTD' THEN
585: SELECT fnd_date.canonical_to_date(org_information11)
586: INTO l_beg_of_fiscal_year

Line 594: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

590: AND HOI.organization_id = PACT.business_group_id
591: AND PACT.payroll_action_id = p_owner_payroll_action_id;
592:
593: p_expiry_date := next_fiscal_year(l_beg_of_fiscal_year,p_owner_effective_date) - 1;
594: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
595:
596: ELSIF p_dimension_name like '%_CAL_YTD' THEN
597: p_expiry_date := next_calendar_year(p_owner_effective_date) - 1;
598: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 598: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

594: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
595:
596: ELSIF p_dimension_name like '%_CAL_YTD' THEN
597: p_expiry_date := next_calendar_year(p_owner_effective_date) - 1;
598: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
599:
600: ELSIF p_dimension_name like '%QTD' THEN
601: p_expiry_date := next_quarter(p_owner_effective_date) - 1;
602: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

Line 602: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

598: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
599:
600: ELSIF p_dimension_name like '%QTD' THEN
601: p_expiry_date := next_quarter(p_owner_effective_date) - 1;
602: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
603:
604: ELSIF p_dimension_name like '%YTD' THEN
605: SELECT to_date('01-04-'||to_char(fnd_number.canonical_to_number(
606: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date

Line 615: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);

611: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
612:
613: ELSIF p_dimension_name like '%LTD' THEN
614: p_expiry_date := fnd_date.canonical_to_date('4712/12/31');
615: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
616:
617: ELSE
618: hr_utility.trace('Entered Exception section');
619: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');

Line 618: hr_utility.trace('Entered Exception section');

614: p_expiry_date := fnd_date.canonical_to_date('4712/12/31');
615: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
616:
617: ELSE
618: hr_utility.trace('Entered Exception section');
619: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');
620: hr_utility.raise_error;
621:
622: END IF;

Line 619: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');

615: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
616:
617: ELSE
618: hr_utility.trace('Entered Exception section');
619: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');
620: hr_utility.raise_error;
621:
622: END IF;
623:

Line 620: hr_utility.raise_error;

616:
617: ELSE
618: hr_utility.trace('Entered Exception section');
619: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_DIMENSION');
620: hr_utility.raise_error;
621:
622: END IF;
623:
624: END date_ec;