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.PERWSEPY_PKG dependencies on HR_UTILITY

Line 21: hr_utility.set_location('Entering:'||l_proc, 5);

17: L_MIN_ACCT_UNIT NUMBER;
18:
19: l_proc VARCHAR2(100):='PERWSEPY.PKG.CHECK_FORMAT';
20: BEGIN
21: hr_utility.set_location('Entering:'||l_proc, 5);
22: if(p_uom='M') then
23: hr_utility.set_location(l_proc, 10);
24: fnd_currency.get_info(currency_code => p_currcode
25: ,precision => L_PRECISION

Line 23: hr_utility.set_location(l_proc, 10);

19: l_proc VARCHAR2(100):='PERWSEPY.PKG.CHECK_FORMAT';
20: BEGIN
21: hr_utility.set_location('Entering:'||l_proc, 5);
22: if(p_uom='M') then
23: hr_utility.set_location(l_proc, 10);
24: fnd_currency.get_info(currency_code => p_currcode
25: ,precision => L_PRECISION
26: ,EXT_PRECISION => L_EXT_PRECISION
27: ,MIN_ACCT_UNIT => L_MIN_ACCT_UNIT);

Line 28: hr_utility.set_location(l_proc, 20);

24: fnd_currency.get_info(currency_code => p_currcode
25: ,precision => L_PRECISION
26: ,EXT_PRECISION => L_EXT_PRECISION
27: ,MIN_ACCT_UNIT => L_MIN_ACCT_UNIT);
28: hr_utility.set_location(l_proc, 20);
29: p_amount:=round(p_amount,l_precision);
30: else
31: hr_utility.set_location(l_proc, 30);
32: p_amount:=round(p_amount,5);

Line 31: hr_utility.set_location(l_proc, 30);

27: ,MIN_ACCT_UNIT => L_MIN_ACCT_UNIT);
28: hr_utility.set_location(l_proc, 20);
29: p_amount:=round(p_amount,l_precision);
30: else
31: hr_utility.set_location(l_proc, 30);
32: p_amount:=round(p_amount,5);
33: end if;
34: END CHECK_LENGTH;
35: --------------------------------------------------------------------------

Line 391: hr_utility.set_location('Entering:'|| l_proc, 1);

387: and approved = 'N'
388: and pay_proposal_id<>nvl(p_pay_proposal_id,-1);
389: --
390: begin
391: hr_utility.set_location('Entering:'|| l_proc, 1);
392:
393: -- The following is commented out in PER_PPC_BUS api as enhancement in FPKRUP.
394: -- New Salary proposals can be added even if future proposals exist.
395: -- This need to be restriced for the old Salary Form.

Line 401: hr_utility.set_location(l_proc, 35);

397:
398: open csr_last_change_date;
399: fetch csr_last_change_date into l_change_date;
400: if csr_last_change_date%notfound then
401: hr_utility.set_location(l_proc, 35);
402: --
403: elsif
404: l_change_date > p_change_date then
405: hr_utility.set_location(l_proc, 40);

Line 405: hr_utility.set_location(l_proc, 40);

401: hr_utility.set_location(l_proc, 35);
402: --
403: elsif
404: l_change_date > p_change_date then
405: hr_utility.set_location(l_proc, 40);
406: close csr_last_change_date;
407: hr_utility.set_message(801,'HR_7293_SAL_FUTURE_APPS_EXIST');
408: hr_utility.raise_error;
409: --

Line 407: hr_utility.set_message(801,'HR_7293_SAL_FUTURE_APPS_EXIST');

403: elsif
404: l_change_date > p_change_date then
405: hr_utility.set_location(l_proc, 40);
406: close csr_last_change_date;
407: hr_utility.set_message(801,'HR_7293_SAL_FUTURE_APPS_EXIST');
408: hr_utility.raise_error;
409: --
410: end if;
411: close csr_last_change_date;

Line 408: hr_utility.raise_error;

404: l_change_date > p_change_date then
405: hr_utility.set_location(l_proc, 40);
406: close csr_last_change_date;
407: hr_utility.set_message(801,'HR_7293_SAL_FUTURE_APPS_EXIST');
408: hr_utility.raise_error;
409: --
410: end if;
411: close csr_last_change_date;
412:

Line 421: hr_utility.set_location(l_proc, 45);

417:
418: open csr_other_proposals_exist;
419: fetch csr_other_proposals_exist into l_exists;
420: if csr_other_proposals_exist%notfound then
421: hr_utility.set_location(l_proc, 45);
422: close csr_other_proposals_exist;
423: --
424: else
425: close csr_other_proposals_exist;

Line 426: hr_utility.set_location(l_proc, 50);

422: close csr_other_proposals_exist;
423: --
424: else
425: close csr_other_proposals_exist;
426: hr_utility.set_location(l_proc, 50);
427: hr_utility.set_message(801, 'HR_7294_SAL_ONLY_ONE_PROPOSAL');
428: hr_utility.raise_error;
429: end if;
430:

Line 427: hr_utility.set_message(801, 'HR_7294_SAL_ONLY_ONE_PROPOSAL');

423: --
424: else
425: close csr_other_proposals_exist;
426: hr_utility.set_location(l_proc, 50);
427: hr_utility.set_message(801, 'HR_7294_SAL_ONLY_ONE_PROPOSAL');
428: hr_utility.raise_error;
429: end if;
430:
431: -- The following is commented out in PER_PPC_BUS api as relaxation in FPKRUP.

Line 428: hr_utility.raise_error;

424: else
425: close csr_other_proposals_exist;
426: hr_utility.set_location(l_proc, 50);
427: hr_utility.set_message(801, 'HR_7294_SAL_ONLY_ONE_PROPOSAL');
428: hr_utility.raise_error;
429: end if;
430:
431: -- The following is commented out in PER_PPC_BUS api as relaxation in FPKRUP.
432: -- The new salary proposal need not have the change_date equals to the

Line 438: hr_utility.set_location(l_proc, 61);

434: -- This need to be restriced for the old Salary Form.
435: -- Change made by abhshriv.
436:
437: chk_pay_basis_change_date (p_assignment_id,p_change_date);
438: hr_utility.set_location(l_proc, 61);
439:
440: hr_utility.set_location('Leaving: ' || l_proc, 65);
441: end chk_assignment_id_change_date;
442: -------------------------------------------------------------------------------

Line 440: hr_utility.set_location('Leaving: ' || l_proc, 65);

436:
437: chk_pay_basis_change_date (p_assignment_id,p_change_date);
438: hr_utility.set_location(l_proc, 61);
439:
440: hr_utility.set_location('Leaving: ' || l_proc, 65);
441: end chk_assignment_id_change_date;
442: -------------------------------------------------------------------------------
443: -------------------------------------------------------------------------------
444: /* Following procedure has been copied from per_pyp_bus.

Line 475: hr_utility.set_location('Entering: ' || l_proc,1);

471: l_proc varchar2(72) := g_package||'chk_pay_basis_change_date';
472: --
473: begin
474: --
475: hr_utility.set_location('Entering: ' || l_proc,1);
476: --
477: --
478:
479: -- The validation for future pay basis changes has been commented in

Line 494: hr_utility.set_location(l_proc,30);

490: --
491: -- raise an error if there future pay_basis change in the assignment.
492: --
493: close csr_asg_pay_bases;
494: hr_utility.set_location(l_proc,30);
495: hr_utility.set_message(801,'HR_51718_PYP_FUTU_PAY_BAS_CHG');
496: hr_utility.raise_error;
497: else
498: close csr_asg_pay_bases;

Line 495: hr_utility.set_message(801,'HR_51718_PYP_FUTU_PAY_BAS_CHG');

491: -- raise an error if there future pay_basis change in the assignment.
492: --
493: close csr_asg_pay_bases;
494: hr_utility.set_location(l_proc,30);
495: hr_utility.set_message(801,'HR_51718_PYP_FUTU_PAY_BAS_CHG');
496: hr_utility.raise_error;
497: else
498: close csr_asg_pay_bases;
499: hr_utility.set_location(l_proc,31);

Line 496: hr_utility.raise_error;

492: --
493: close csr_asg_pay_bases;
494: hr_utility.set_location(l_proc,30);
495: hr_utility.set_message(801,'HR_51718_PYP_FUTU_PAY_BAS_CHG');
496: hr_utility.raise_error;
497: else
498: close csr_asg_pay_bases;
499: hr_utility.set_location(l_proc,31);
500: end if;

Line 499: hr_utility.set_location(l_proc,31);

495: hr_utility.set_message(801,'HR_51718_PYP_FUTU_PAY_BAS_CHG');
496: hr_utility.raise_error;
497: else
498: close csr_asg_pay_bases;
499: hr_utility.set_location(l_proc,31);
500: end if;
501:
502:
503: hr_utility.set_location('Leaving: ' ||l_proc,35);

Line 503: hr_utility.set_location('Leaving: ' ||l_proc,35);

499: hr_utility.set_location(l_proc,31);
500: end if;
501:
502:
503: hr_utility.set_location('Leaving: ' ||l_proc,35);
504: --
505: end chk_pay_basis_change_date;
506: --------------------------------------------------------------------------------------
507: -------------------------------------------------------------------------------

Line 547: hr_utility.set_location('Entering:'|| l_proc, 1);

543: from per_pay_proposals
544: where assignment_id = l_assignment_id;
545: --
546: begin
547: hr_utility.set_location('Entering:'|| l_proc, 1);
548: --
549: -- get the proposal details first.
550: --
551: open csr_get_pro_detail;

Line 556: hr_utility.set_location(l_proc, 2);

552: fetch csr_get_pro_detail into l_assignment_id,l_business_group_id,
553: l_change_date,l_multiple_components, l_approved;
554: if csr_get_pro_detail%notfound then
555: close csr_get_pro_detail;
556: hr_utility.set_location(l_proc, 2);
557: per_pyp_shd.constraint_error('PER_PAY_PROPOSALS_PK');
558: end if;
559: close csr_get_pro_detail;
560:

Line 567: hr_utility.set_location(l_proc,5);

563: --
564: open csr_is_latest_proposal;
565: fetch csr_is_latest_proposal into l_last_change_date;
566: if csr_is_latest_proposal%notfound then
567: hr_utility.set_location(l_proc,5);
568: close csr_is_latest_proposal;
569: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
570: hr_utility.raise_error;
571: elsif (l_change_date < l_last_change_date) then

Line 569: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

565: fetch csr_is_latest_proposal into l_last_change_date;
566: if csr_is_latest_proposal%notfound then
567: hr_utility.set_location(l_proc,5);
568: close csr_is_latest_proposal;
569: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
570: hr_utility.raise_error;
571: elsif (l_change_date < l_last_change_date) then
572: --
573: -- raise an error. You can only delete the latest proposal

Line 570: hr_utility.raise_error;

566: if csr_is_latest_proposal%notfound then
567: hr_utility.set_location(l_proc,5);
568: close csr_is_latest_proposal;
569: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
570: hr_utility.raise_error;
571: elsif (l_change_date < l_last_change_date) then
572: --
573: -- raise an error. You can only delete the latest proposal
574: --

Line 575: hr_utility.set_location(l_proc,10);

571: elsif (l_change_date < l_last_change_date) then
572: --
573: -- raise an error. You can only delete the latest proposal
574: --
575: hr_utility.set_location(l_proc,10);
576: close csr_is_latest_proposal;
577: hr_utility.set_message(801, 'HR_7292_SAL_NOT_LATEST_SAL_REC');
578: hr_utility.raise_error;
579: end if;

Line 577: hr_utility.set_message(801, 'HR_7292_SAL_NOT_LATEST_SAL_REC');

573: -- raise an error. You can only delete the latest proposal
574: --
575: hr_utility.set_location(l_proc,10);
576: close csr_is_latest_proposal;
577: hr_utility.set_message(801, 'HR_7292_SAL_NOT_LATEST_SAL_REC');
578: hr_utility.raise_error;
579: end if;
580: close csr_is_latest_proposal;
581:

Line 578: hr_utility.raise_error;

574: --
575: hr_utility.set_location(l_proc,10);
576: close csr_is_latest_proposal;
577: hr_utility.set_message(801, 'HR_7292_SAL_NOT_LATEST_SAL_REC');
578: hr_utility.raise_error;
579: end if;
580: close csr_is_latest_proposal;
581:
582: hr_utility.set_location('Leaving: ' ||l_proc, 55);

Line 582: hr_utility.set_location('Leaving: ' ||l_proc, 55);

578: hr_utility.raise_error;
579: end if;
580: close csr_is_latest_proposal;
581:
582: hr_utility.set_location('Leaving: ' ||l_proc, 55);
583:
584: end chk_del_pay_proposal;
585: -------------------------------------------------------------------------------
586: /* Following procedure has been copied from per_ppc_bus.

Line 618: hr_utility.set_location('Entering:'|| l_proc, 1);

614: where comp.component_id = p_component_id;
615: --
616: --
617: begin
618: hr_utility.set_location('Entering:'|| l_proc, 1);
619: --
620: -- Check that the component exists and get the proposal
621: --
622: open csr_comp_exists;

Line 626: hr_utility.set_location(l_proc, 2);

622: open csr_comp_exists;
623: fetch csr_comp_exists into l_pay_proposal_id;
624: if csr_comp_exists%notfound then
625: close csr_comp_exists;
626: hr_utility.set_location(l_proc, 2);
627: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
628: hr_utility.raise_error;
629: end if;
630: close csr_comp_exists;

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

623: fetch csr_comp_exists into l_pay_proposal_id;
624: if csr_comp_exists%notfound then
625: close csr_comp_exists;
626: hr_utility.set_location(l_proc, 2);
627: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
628: hr_utility.raise_error;
629: end if;
630: close csr_comp_exists;
631: --

Line 628: hr_utility.raise_error;

624: if csr_comp_exists%notfound then
625: close csr_comp_exists;
626: hr_utility.set_location(l_proc, 2);
627: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
628: hr_utility.raise_error;
629: end if;
630: close csr_comp_exists;
631: --
632: -- Check that the proposal is not already approved.

Line 637: hr_utility.set_location(l_proc, 2);

633: --
634: open csr_proposal_status;
635: fetch csr_proposal_status into l_exists;
636: if csr_proposal_status%notfound then
637: hr_utility.set_location(l_proc, 2);
638: close csr_proposal_status;
639: else
640: hr_utility.set_location(l_proc, 3);
641: close csr_proposal_status;

Line 640: hr_utility.set_location(l_proc, 3);

636: if csr_proposal_status%notfound then
637: hr_utility.set_location(l_proc, 2);
638: close csr_proposal_status;
639: else
640: hr_utility.set_location(l_proc, 3);
641: close csr_proposal_status;
642: hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
643: hr_utility.raise_error;
644: end if;

Line 642: hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');

638: close csr_proposal_status;
639: else
640: hr_utility.set_location(l_proc, 3);
641: close csr_proposal_status;
642: hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
643: hr_utility.raise_error;
644: end if;
645: --
646: hr_utility.set_location ('Leaving: ' || l_proc, 4);

Line 643: hr_utility.raise_error;

639: else
640: hr_utility.set_location(l_proc, 3);
641: close csr_proposal_status;
642: hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
643: hr_utility.raise_error;
644: end if;
645: --
646: hr_utility.set_location ('Leaving: ' || l_proc, 4);
647: --

Line 646: hr_utility.set_location ('Leaving: ' || l_proc, 4);

642: hr_utility.set_message(801,'HR_51315_PPC_CANT_DEL_RECORD');
643: hr_utility.raise_error;
644: end if;
645: --
646: hr_utility.set_location ('Leaving: ' || l_proc, 4);
647: --
648: end chk_delete_component;
649:
650: -------------------------------------------------------------------------------