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_API

Line 56: hr_api.mandatory_arg_error

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
57: (p_api_name => l_proc
58: ,p_argument => 'gap_daily_absence_id'
59: ,p_argument_value => p_gap_daily_absence_id
60: );

Line 83: hr_api.set_security_group_id

79: close csr_sec_grp;
80: --
81: -- Set the security_group_id in CLIENT_INFO
82: --
83: hr_api.set_security_group_id
84: (p_security_group_id => l_security_group_id
85: );
86: --
87: -- Set the sessions legislation context in HR_SESSION_DATA

Line 89: hr_api.set_legislation_context(l_legislation_code);

85: );
86: --
87: -- Set the sessions legislation context in HR_SESSION_DATA
88: --
89: hr_api.set_legislation_context(l_legislation_code);
90: end if;
91: --
92: hr_utility.set_location(' Leaving:'|| l_proc, 20);
93: --

Line 131: hr_api.mandatory_arg_error

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
132: (p_api_name => l_proc
133: ,p_argument => 'gap_daily_absence_id'
134: ,p_argument_value => p_gap_daily_absence_id
135: );

Line 137: if ( nvl(pqp_gda_bus.g_gap_daily_absence_id, hr_api.g_number)

133: ,p_argument => 'gap_daily_absence_id'
134: ,p_argument_value => p_gap_daily_absence_id
135: );
136: --
137: if ( nvl(pqp_gda_bus.g_gap_daily_absence_id, hr_api.g_number)
138: = p_gap_daily_absence_id) then
139: --
140: -- The legislation code has already been found with a previous
141: -- call to this function. Just return the value in the global

Line 224: IF nvl(p_rec.gap_absence_plan_id, hr_api.g_number) <>

220: fnd_message.set_token('STEP ', '5');
221: fnd_message.raise_error;
222: END IF;
223: --
224: IF nvl(p_rec.gap_absence_plan_id, hr_api.g_number) <>
225: nvl(pqp_gda_shd.g_old_rec.gap_absence_plan_id
226: ,hr_api.g_number
227: ) THEN
228:

Line 226: ,hr_api.g_number

222: END IF;
223: --
224: IF nvl(p_rec.gap_absence_plan_id, hr_api.g_number) <>
225: nvl(pqp_gda_shd.g_old_rec.gap_absence_plan_id
226: ,hr_api.g_number
227: ) THEN
228:
229: hr_api.argument_changed_error
230: (p_api_name => l_proc

Line 229: hr_api.argument_changed_error

225: nvl(pqp_gda_shd.g_old_rec.gap_absence_plan_id
226: ,hr_api.g_number
227: ) THEN
228:
229: hr_api.argument_changed_error
230: (p_api_name => l_proc
231: ,p_argument => 'GAP_ABSENCE_PLAN_ID'
232: ,p_base_table => pqp_gda_shd.g_tab_nam
233: );

Line 237: IF nvl(p_rec.absence_date, hr_api.g_date) <>

233: );
234:
235: END IF;
236: --
237: IF nvl(p_rec.absence_date, hr_api.g_date) <>
238: nvl(pqp_gda_shd.g_old_rec.absence_date
239: ,hr_api.g_date
240: ) THEN
241:

Line 239: ,hr_api.g_date

235: END IF;
236: --
237: IF nvl(p_rec.absence_date, hr_api.g_date) <>
238: nvl(pqp_gda_shd.g_old_rec.absence_date
239: ,hr_api.g_date
240: ) THEN
241:
242: hr_api.argument_changed_error
243: (p_api_name => l_proc

Line 242: hr_api.argument_changed_error

238: nvl(pqp_gda_shd.g_old_rec.absence_date
239: ,hr_api.g_date
240: ) THEN
241:
242: hr_api.argument_changed_error
243: (p_api_name => l_proc
244: ,p_argument => 'ABSENCE_DATE'
245: ,p_base_table => pqp_gda_shd.g_tab_nam
246: );

Line 290: hr_api.mandatory_arg_error

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'
293: ,p_argument_value => p_gap_absence_plan_id
294: );

Line 346: hr_api.mandatory_arg_error

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'
349: ,p_argument_value => p_absence_date
350: );

Line 393: hr_api.mandatory_arg_error

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'
396: ,p_argument_value => p_effective_date
397: );

Line 399: hr_api.mandatory_arg_error

395: ,p_argument => 'effective_date'
396: ,p_argument_value => p_effective_date
397: );
398: --
399: hr_api.mandatory_arg_error
400: (p_api_name => l_proc
401: ,p_argument => 'work_pattern_day_type'
402: ,p_argument_value => p_work_pattern_day_type
403: );

Line 409: hr_api.g_varchar2) <> nvl(p_work_pattern_day_type,

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,
410: hr_api.g_varchar2))
411: or
412: (p_gap_daily_absence_id is null)) then
413:

Line 410: hr_api.g_varchar2))

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,
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);

Line 416: if hr_api.not_exists_in_hr_lookups

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'
419: ,p_lookup_code => p_work_pattern_day_type
420: ) then

Line 427: end if; -- hr_api.not_exists_in_hr_lookups

423: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
424: fnd_message.set_token('COLUMN_NAME', 'WORK_PATTERN_DAY_TYPE');
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...

Line 474: hr_api.mandatory_arg_error

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'
477: ,p_argument_value => p_effective_date
478: );

Line 480: hr_api.mandatory_arg_error

476: ,p_argument => 'effective_date'
477: ,p_argument_value => p_effective_date
478: );
479: --
480: hr_api.mandatory_arg_error
481: (p_api_name => l_proc
482: ,p_argument => 'level_of_entitlement'
483: ,p_argument_value => p_level_of_entitlement
484: );

Line 490: hr_api.g_varchar2) <> nvl(p_level_of_entitlement,

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,
491: hr_api.g_varchar2))
492: or
493: (p_gap_daily_absence_id is null)) then
494:

Line 491: hr_api.g_varchar2))

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,
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);

Line 497: if hr_api.not_exists_in_hr_lookups

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'
500: ,p_lookup_code => p_level_of_entitlement
501: ) then

Line 508: end if; -- hr_api.not_exists_in_hr_lookups

504: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
505: fnd_message.set_token('COLUMN_NAME', 'LEVEL_OF_ENTITLEMENT');
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...

Line 557: hr_api.mandatory_arg_error

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'
560: ,p_argument_value => p_effective_date
561: );

Line 563: hr_api.mandatory_arg_error

559: ,p_argument => 'effective_date'
560: ,p_argument_value => p_effective_date
561: );
562: --
563: hr_api.mandatory_arg_error
564: (p_api_name => l_proc
565: ,p_argument => 'level_of_pay'
566: ,p_argument_value => p_level_of_pay
567: );

Line 573: hr_api.g_varchar2) <> nvl(p_level_of_pay,

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,
574: hr_api.g_varchar2))
575: or
576: (p_gap_daily_absence_id is null)) then
577:

Line 574: hr_api.g_varchar2))

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,
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);

Line 580: if hr_api.not_exists_in_hr_lookups

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'
583: ,p_lookup_code => p_level_of_pay
584: ) then

Line 588: if hr_api.not_exists_in_hr_lookups

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'
591: ,p_lookup_code => p_level_of_pay
592: ) then

Line 596: if hr_api.not_exists_in_hr_lookups

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'
599: ,p_lookup_code => p_level_of_pay
600: ) then

Line 655: hr_api.mandatory_arg_error

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'
658: ,p_argument_value => p_duration
659: );

Line 665: hr_api.g_number) <> nvl(p_duration,

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,
666: hr_api.g_number))
667: or
668: (p_gap_daily_absence_id is null)) then
669:

Line 666: hr_api.g_number))

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,
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);

Line 727: hr_api.mandatory_arg_error

723: -- because this is a new column and existing customers
724: -- will not have data in this column hence we cannot
725: -- enforce this while updating
726: if p_gap_daily_absence_id is null then
727: hr_api.mandatory_arg_error
728: (p_api_name => l_proc
729: ,p_argument => 'duration_in_hours'
730: ,p_argument_value => p_duration_in_hours
731: );

Line 738: hr_api.g_number) <> nvl(p_duration_in_hours,

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,
739: hr_api.g_number))
740: or
741: (p_gap_daily_absence_id is null)) then
742:

Line 739: hr_api.g_number))

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,
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);

Line 799: hr_api.mandatory_arg_error

795: -- because this is a new column and existing customers
796: -- will not have data in this column hence we cannot
797: -- enforce this while updating
798: if p_gap_daily_absence_id is null then
799: hr_api.mandatory_arg_error
800: (p_api_name => l_proc
801: ,p_argument => 'working_days_per_week'
802: ,p_argument_value => p_working_days_per_week
803: );

Line 810: hr_api.g_number) <> nvl(p_working_days_per_week,

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,
811: hr_api.g_number))
812: or
813: (p_gap_daily_absence_id is null)) then
814:

Line 811: hr_api.g_number))

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,
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);

Line 876: hr_api.mandatory_arg_error

872: -- because this is a new column and existing customers
873: -- will not have data in this column hence we cannot
874: -- enforce this while updating
875: if p_gap_daily_absence_id is null then
876: hr_api.mandatory_arg_error
877: (p_api_name => l_proc
878: ,p_argument => 'fte'
879: ,p_argument_value => p_fte
880: );

Line 886: nvl(pqp_gda_shd.g_old_rec.fte,hr_api.g_number)

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))
888: or
889: (p_gap_daily_absence_id is null)) then
890:

Line 887: <> nvl(p_fte, hr_api.g_number))

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))
888: or
889: (p_gap_daily_absence_id is null)) then
890:
891: hr_utility.set_location(l_proc, 30);