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

Line 52: hr_utility.set_location('Entering:'|| l_proc, 10);

48: l_legislation_code varchar2(150);
49: --
50: begin
51: --
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Ensure that all the mandatory parameter are not null
55: --
56: hr_api.mandatory_arg_error

Line 92: hr_utility.set_location(' Leaving:'|| l_proc, 20);

88: --
89: hr_api.set_legislation_context(l_legislation_code);
90: end if;
91: --
92: hr_utility.set_location(' Leaving:'|| l_proc, 20);
93: --
94: end set_security_group_id;
95: */
96:

Line 127: hr_utility.set_location('Entering:'|| l_proc, 10);

123: l_proc varchar2(72) := g_package||'return_legislation_code';
124: --
125: Begin
126: --
127: hr_utility.set_location('Entering:'|| l_proc, 10);
128: --
129: -- Ensure that all the mandatory parameter are not null
130: --
131: hr_api.mandatory_arg_error

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

141: -- call to this function. Just return the value in the global
142: -- variable.
143: --
144: l_legislation_code := pqp_gda_bus.g_legislation_code;
145: hr_utility.set_location(l_proc, 20);
146: else
147: --
148: -- The ID is different to the last call to this function
149: -- or this is the first call to this function.

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

158: close csr_leg_code;
159: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
160: fnd_message.raise_error;
161: end if;
162: hr_utility.set_location(l_proc,30);
163: --
164: -- Set the global variables so the values are
165: -- available for the next call to this function.
166: --

Line 171: hr_utility.set_location(' Leaving:'|| l_proc, 40);

167: close csr_leg_code;
168: pqp_gda_bus.g_gap_daily_absence_id := p_gap_daily_absence_id;
169: pqp_gda_bus.g_legislation_code := l_legislation_code;
170: end if;
171: hr_utility.set_location(' Leaving:'|| l_proc, 40);
172: return l_legislation_code;
173: end return_legislation_code;
174: --
175: -- ----------------------------------------------------------------------------

Line 288: hr_utility.set_location(' Entering: '|| l_proc, 10);

284: l_GAPValid char(1) := 'N';
285: --
286: Begin
287: --
288: hr_utility.set_location(' Entering: '|| l_proc, 10);
289: --
290: hr_api.mandatory_arg_error
291: (p_api_name => l_proc
292: ,p_argument => 'gap_absence_plan_id'

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

292: ,p_argument => 'gap_absence_plan_id'
293: ,p_argument_value => p_gap_absence_plan_id
294: );
295: --
296: hr_utility.set_location(l_proc, 20);
297: --
298: open ChkGAPId;
299: fetch ChkGAPId into l_GAPValid;
300: close ChkGAPId;

Line 310: hr_utility.set_location(' Leaving: '|| l_proc, 30);

306: fnd_message.raise_error;
307:
308: end if; -- l_GAPValid = 'N'
309: --
310: hr_utility.set_location(' Leaving: '|| l_proc, 30);
311: --
312: end chk_gap_absence_plan_id;
313: --
314: -- ---------------------------------------------------------------------------+

Line 344: hr_utility.set_location(' Entering: '|| l_proc, 10);

340: l_proc varchar2(72) := g_package || 'chk_absence_date';
341: --
342: Begin
343: --
344: hr_utility.set_location(' Entering: '|| l_proc, 10);
345: --
346: hr_api.mandatory_arg_error
347: (p_api_name => l_proc
348: ,p_argument => 'absence_date'

Line 352: hr_utility.set_location(' Leaving: '|| l_proc, 20);

348: ,p_argument => 'absence_date'
349: ,p_argument_value => p_absence_date
350: );
351: --
352: hr_utility.set_location(' Leaving: '|| l_proc, 20);
353: --
354: end chk_absence_date;
355: --
356: -- ---------------------------------------------------------------------------+

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

387: l_proc varchar2(72) := g_package || 'chk_work_pattern_day_type';
388: --
389: Begin
390: --
391: hr_utility.set_location(' Entering: '|| l_proc, 10);
392: --
393: hr_api.mandatory_arg_error
394: (p_api_name => l_proc
395: ,p_argument => 'effective_date'

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

401: ,p_argument => 'work_pattern_day_type'
402: ,p_argument_value => p_work_pattern_day_type
403: );
404: --
405: hr_utility.set_location(l_proc, 20);
406: --
407: if (((p_gap_daily_absence_id is not null) and
408: nvl(pqp_gda_shd.g_old_rec.work_pattern_day_type,
409: hr_api.g_varchar2) <> nvl(p_work_pattern_day_type,

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

410: hr_api.g_varchar2))
411: or
412: (p_gap_daily_absence_id is null)) then
413:
414: hr_utility.set_location(l_proc, 30);
415: --
416: if hr_api.not_exists_in_hr_lookups
417: (p_effective_date => p_effective_date
418: ,p_lookup_type => 'PQP_GAP_WORK_PATTERN_DAY_TYPE'

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

425: fnd_message.raise_error;
426:
427: end if; -- hr_api.not_exists_in_hr_lookups
428: --
429: hr_utility.set_location(l_proc, 40);
430: --
431: end if; -- (((p_gap_daily_absence_id is not null) and...
432: --
433: hr_utility.set_location(' Leaving: '|| l_proc, 50);

Line 433: hr_utility.set_location(' Leaving: '|| l_proc, 50);

429: hr_utility.set_location(l_proc, 40);
430: --
431: end if; -- (((p_gap_daily_absence_id is not null) and...
432: --
433: hr_utility.set_location(' Leaving: '|| l_proc, 50);
434: --
435: end chk_work_pattern_day_type;
436: --
437: -- ---------------------------------------------------------------------------+

Line 472: hr_utility.set_location(' Entering: '|| l_proc, 10);

468: l_proc varchar2(72) := g_package || 'chk_level_of_entitlement';
469: --
470: Begin
471: --
472: hr_utility.set_location(' Entering: '|| l_proc, 10);
473: --
474: hr_api.mandatory_arg_error
475: (p_api_name => l_proc
476: ,p_argument => 'effective_date'

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

482: ,p_argument => 'level_of_entitlement'
483: ,p_argument_value => p_level_of_entitlement
484: );
485: --
486: hr_utility.set_location(l_proc, 20);
487: --
488: if (((p_gap_daily_absence_id is not null) and
489: nvl(pqp_gda_shd.g_old_rec.level_of_entitlement,
490: hr_api.g_varchar2) <> nvl(p_level_of_entitlement,

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

491: hr_api.g_varchar2))
492: or
493: (p_gap_daily_absence_id is null)) then
494:
495: hr_utility.set_location(l_proc, 30);
496: --
497: if hr_api.not_exists_in_hr_lookups
498: (p_effective_date => p_effective_date
499: ,p_lookup_type => 'PQP_GAP_ENTITLEMENT_BANDS'

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

506: fnd_message.raise_error;
507:
508: end if; -- hr_api.not_exists_in_hr_lookups
509: --
510: hr_utility.set_location(l_proc, 40);
511: --
512: end if; -- (((p_gap_daily_absence_id is not null) and...
513: --
514: hr_utility.set_location(' Leaving: '|| l_proc, 50);

Line 514: hr_utility.set_location(' Leaving: '|| l_proc, 50);

510: hr_utility.set_location(l_proc, 40);
511: --
512: end if; -- (((p_gap_daily_absence_id is not null) and...
513: --
514: hr_utility.set_location(' Leaving: '|| l_proc, 50);
515: --
516: end chk_level_of_entitlement;
517: --
518: -- ---------------------------------------------------------------------------+

Line 555: hr_utility.set_location(' Entering: '|| l_proc, 10);

551: l_proc varchar2(72) := g_package || 'chk_level_of_pay';
552: --
553: Begin
554: --
555: hr_utility.set_location(' Entering: '|| l_proc, 10);
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc
559: ,p_argument => 'effective_date'

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

565: ,p_argument => 'level_of_pay'
566: ,p_argument_value => p_level_of_pay
567: );
568: --
569: hr_utility.set_location(l_proc, 20);
570: --
571: if (((p_gap_daily_absence_id is not null) and
572: nvl(pqp_gda_shd.g_old_rec.level_of_pay,
573: hr_api.g_varchar2) <> nvl(p_level_of_pay,

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

574: hr_api.g_varchar2))
575: or
576: (p_gap_daily_absence_id is null)) then
577:
578: hr_utility.set_location(l_proc, 30);
579: --
580: if hr_api.not_exists_in_hr_lookups
581: (p_effective_date => p_effective_date
582: ,p_lookup_type => 'PQP_GB_OSP_CALENDAR_RULES'

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

582: ,p_lookup_type => 'PQP_GB_OSP_CALENDAR_RULES'
583: ,p_lookup_code => p_level_of_pay
584: ) then
585:
586: hr_utility.set_location(l_proc, 40);
587: --
588: if hr_api.not_exists_in_hr_lookups
589: (p_effective_date => p_effective_date
590: ,p_lookup_type => 'PQP_GB_OMP_CALENDAR_RULES'

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

590: ,p_lookup_type => 'PQP_GB_OMP_CALENDAR_RULES'
591: ,p_lookup_code => p_level_of_pay
592: ) then
593:
594: hr_utility.set_location(l_proc, 50);
595: --
596: if hr_api.not_exists_in_hr_lookups
597: (p_effective_date => p_effective_date
598: ,p_lookup_type => 'PQP_GAP_ENTITLEMENT_BANDS'

Line 613: hr_utility.set_location(l_proc, 60);

609: end if; -- PQP_GB_OMP_CALENDAR_RULES
610: --
611: end if; -- PQP_GB_OSP_CALENDAR_RULES
612: --
613: hr_utility.set_location(l_proc, 60);
614: --
615: end if; -- (((p_gap_daily_absence_id is not null) and...
616: --
617: hr_utility.set_location(' Leaving: '|| l_proc, 70);

Line 617: hr_utility.set_location(' Leaving: '|| l_proc, 70);

613: hr_utility.set_location(l_proc, 60);
614: --
615: end if; -- (((p_gap_daily_absence_id is not null) and...
616: --
617: hr_utility.set_location(' Leaving: '|| l_proc, 70);
618: --
619: end chk_level_of_pay;
620: --
621: -- ---------------------------------------------------------------------------+

Line 653: hr_utility.set_location(' Entering: '|| l_proc, 10);

649: l_proc varchar2(72) := g_package || 'chk_duration';
650: --
651: Begin
652: --
653: hr_utility.set_location(' Entering: '|| l_proc, 10);
654: --
655: hr_api.mandatory_arg_error
656: (p_api_name => l_proc
657: ,p_argument => 'duration'

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

657: ,p_argument => 'duration'
658: ,p_argument_value => p_duration
659: );
660: --
661: hr_utility.set_location(l_proc, 20);
662: --
663: if (((p_gap_daily_absence_id is not null) and
664: nvl(pqp_gda_shd.g_old_rec.duration,
665: hr_api.g_number) <> nvl(p_duration,

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

666: hr_api.g_number))
667: or
668: (p_gap_daily_absence_id is null)) then
669:
670: hr_utility.set_location(l_proc, 30);
671: --
672: if NOT (p_duration between 0 and 1) then
673:
674: -- invalid duration

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

676: fnd_message.raise_error;
677:
678: end if; -- NOT (p_duration between 0 and 1)
679: --
680: hr_utility.set_location(l_proc, 40);
681: --
682: end if; -- (((p_gap_daily_absence_id is not null) and...
683: --
684: hr_utility.set_location(' Leaving: '|| l_proc, 50);

Line 684: hr_utility.set_location(' Leaving: '|| l_proc, 50);

680: hr_utility.set_location(l_proc, 40);
681: --
682: end if; -- (((p_gap_daily_absence_id is not null) and...
683: --
684: hr_utility.set_location(' Leaving: '|| l_proc, 50);
685: --
686: end chk_duration;
687: --
688: -- ---------------------------------------------------------------------------+

Line 720: hr_utility.set_location(' Entering: '|| l_proc, 10);

716: l_proc varchar2(72) := g_package || 'chk_duration_in_hours';
717: --
718: Begin
719: --
720: hr_utility.set_location(' Entering: '|| l_proc, 10);
721: --
722: -- Duration_in_hours is mandatory only while inserting
723: -- because this is a new column and existing customers
724: -- will not have data in this column hence we cannot

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

730: ,p_argument_value => p_duration_in_hours
731: );
732: end if;
733: --
734: hr_utility.set_location(l_proc, 20);
735: --
736: if (((p_gap_daily_absence_id is not null) and
737: nvl(pqp_gda_shd.g_old_rec.duration_in_hours,
738: hr_api.g_number) <> nvl(p_duration_in_hours,

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

739: hr_api.g_number))
740: or
741: (p_gap_daily_absence_id is null)) then
742:
743: hr_utility.set_location(l_proc, 30);
744: --
745: if NOT (p_duration_in_hours between 0 and 24) then
746:
747: -- invalid duration_in_hours

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

749: fnd_message.raise_error;
750:
751: end if; -- NOT (p_duration_in_hours between 0 and 24)
752: --
753: hr_utility.set_location(l_proc, 40);
754: --
755: end if; -- (((p_gap_daily_absence_id is not null) and...
756: --
757: hr_utility.set_location(' Leaving: '|| l_proc, 50);

Line 757: hr_utility.set_location(' Leaving: '|| l_proc, 50);

753: hr_utility.set_location(l_proc, 40);
754: --
755: end if; -- (((p_gap_daily_absence_id is not null) and...
756: --
757: hr_utility.set_location(' Leaving: '|| l_proc, 50);
758: --
759: end chk_duration_in_hours;
760: -- ---------------------------------------------------------------------------+
761: -- |-----------------------< chk_working_days_per_week >----------------------|

Line 792: hr_utility.set_location(' Entering: '|| l_proc, 10);

788: l_proc varchar2(72) := g_package || 'chk_working_days_per_week';
789: --
790: Begin
791: --
792: hr_utility.set_location(' Entering: '|| l_proc, 10);
793: --
794: -- Working_Days_Per_Week is mandatory only while inserting
795: -- because this is a new column and existing customers
796: -- will not have data in this column hence we cannot

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

802: ,p_argument_value => p_working_days_per_week
803: );
804: end if;
805: --
806: hr_utility.set_location(l_proc, 20);
807: --
808: if (((p_gap_daily_absence_id is not null) and
809: nvl(pqp_gda_shd.g_old_rec.working_days_per_week,
810: hr_api.g_number) <> nvl(p_working_days_per_week,

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

811: hr_api.g_number))
812: or
813: (p_gap_daily_absence_id is null)) then
814:
815: hr_utility.set_location(l_proc, 30);
816: --
817: if (p_working_days_per_week <= 0 -- Must be greater than 0
818: or
819: p_working_days_per_week > 7 -- Must be 7 or less

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

824: fnd_message.raise_error;
825:
826: end if; -- (p_working_days_per_week <= 0..
827: --
828: hr_utility.set_location(l_proc, 40);
829: --
830: end if; -- (((p_gap_daily_absence_id is not null) and...
831: --
832: hr_utility.set_location(' Leaving: '|| l_proc, 50);

Line 832: hr_utility.set_location(' Leaving: '|| l_proc, 50);

828: hr_utility.set_location(l_proc, 40);
829: --
830: end if; -- (((p_gap_daily_absence_id is not null) and...
831: --
832: hr_utility.set_location(' Leaving: '|| l_proc, 50);
833: --
834: end chk_working_days_per_week;
835: --
836: -- LG below Procedure added

Line 869: hr_utility.set_location(' Entering: '|| l_proc, 10);

865: l_proc varchar2(72) := g_package || 'chk_fte';
866: --
867: Begin
868: --
869: hr_utility.set_location(' Entering: '|| l_proc, 10);
870: --
871: -- fte is mandatory only while inserting
872: -- because this is a new column and existing customers
873: -- will not have data in this column hence we cannot

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

879: ,p_argument_value => p_fte
880: );
881: end if;
882: --
883: hr_utility.set_location(l_proc, 20);
884: --
885: if (((p_gap_daily_absence_id is not null) and
886: nvl(pqp_gda_shd.g_old_rec.fte,hr_api.g_number)
887: <> nvl(p_fte, hr_api.g_number))

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

887: <> nvl(p_fte, hr_api.g_number))
888: or
889: (p_gap_daily_absence_id is null)) then
890:
891: hr_utility.set_location(l_proc, 30);
892: --
893: if (p_fte <= 0 -- Must be greater than 0
894: or
895: p_fte > 7 -- Must be 7 or less

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

900: fnd_message.raise_error;
901:
902: end if; -- (p_working_days_per_week <= 0..
903: --
904: hr_utility.set_location(l_proc, 40);
905: --
906: end if; -- (((p_gap_daily_absence_id is not null) and...
907: --
908: hr_utility.set_location(' Leaving: '|| l_proc, 50);

Line 908: hr_utility.set_location(' Leaving: '|| l_proc, 50);

904: hr_utility.set_location(l_proc, 40);
905: --
906: end if; -- (((p_gap_daily_absence_id is not null) and...
907: --
908: hr_utility.set_location(' Leaving: '|| l_proc, 50);
909: --
910: end chk_fte;
911: --
912: -- ----------------------------------------------------------------------------

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

919: --
920: l_proc varchar2(72) := g_package||'insert_validate';
921: --
922: Begin
923: hr_utility.set_location('Entering:'||l_proc, 5);
924: --
925: -- Call all supporting business operations
926: --
927:

Line 982: hr_utility.set_location(' Leaving:'||l_proc, 10);

978: (p_gap_daily_absence_id => p_rec.gap_absence_plan_id
979: ,p_fte => p_rec.fte
980: );
981: --
982: hr_utility.set_location(' Leaving:'||l_proc, 10);
983: End insert_validate;
984: --
985: -- ----------------------------------------------------------------------------
986: -- |---------------------------< update_validate >----------------------------|

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

992: --
993: l_proc varchar2(72) := g_package||'update_validate';
994: --
995: Begin
996: hr_utility.set_location('Entering:'||l_proc, 5);
997: --
998: -- Call all supporting business operations
999: --
1000:

Line 1060: hr_utility.set_location(' Leaving:'||l_proc, 10);

1056: (p_gap_daily_absence_id => p_rec.gap_absence_plan_id
1057: ,p_fte => p_rec.fte
1058: );
1059: --
1060: hr_utility.set_location(' Leaving:'||l_proc, 10);
1061: End update_validate;
1062: --
1063: -- ----------------------------------------------------------------------------
1064: -- |---------------------------< delete_validate >----------------------------|

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

1069: --
1070: l_proc varchar2(72) := g_package||'delete_validate';
1071: --
1072: Begin
1073: hr_utility.set_location('Entering:'||l_proc, 5);
1074: --
1075: -- Call all supporting business operations
1076: --
1077: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1077: hr_utility.set_location(' Leaving:'||l_proc, 10);

1073: hr_utility.set_location('Entering:'||l_proc, 5);
1074: --
1075: -- Call all supporting business operations
1076: --
1077: hr_utility.set_location(' Leaving:'||l_proc, 10);
1078: End delete_validate;
1079: --
1080: end pqp_gda_bus;