DBA Data[Home] [Help]

APPS.GHR_REI_BUS dependencies on HR_API

Line 56: hr_api.mandatory_arg_error

52: hr_utility.set_location('Entering:'||l_proc, 1);
53: --
54: -- Check mandatory parameters have been set
55: --
56: hr_api.mandatory_arg_error
57: (
58: p_api_name => l_proc,
59: p_argument => 'pa_request_id',
60: p_argument_value => p_pa_request_id

Line 134: if nvl(p_rec.pa_request_id,hr_api.g_number)

130: end if;
131: --
132: hr_utility.set_location (l_proc, 30);
133: --
134: if nvl(p_rec.pa_request_id,hr_api.g_number)
135: <> nvl(ghr_rei_shd.g_old_rec.pa_request_id,hr_api.g_number) then
136: l_argument := 'pa_request_id';
137: raise l_error;
138: end if;

Line 135: <> nvl(ghr_rei_shd.g_old_rec.pa_request_id,hr_api.g_number) then

131: --
132: hr_utility.set_location (l_proc, 30);
133: --
134: if nvl(p_rec.pa_request_id,hr_api.g_number)
135: <> nvl(ghr_rei_shd.g_old_rec.pa_request_id,hr_api.g_number) then
136: l_argument := 'pa_request_id';
137: raise l_error;
138: end if;
139: --

Line 140: if nvl(p_rec.information_type,hr_api.g_varchar2)

136: l_argument := 'pa_request_id';
137: raise l_error;
138: end if;
139: --
140: if nvl(p_rec.information_type,hr_api.g_varchar2)
141: <> nvl(ghr_rei_shd.g_old_rec.information_type,hr_api.g_varchar2) then
142: l_argument := 'information_type';
143: raise l_error;
144: end if;

Line 141: <> nvl(ghr_rei_shd.g_old_rec.information_type,hr_api.g_varchar2) then

137: raise l_error;
138: end if;
139: --
140: if nvl(p_rec.information_type,hr_api.g_varchar2)
141: <> nvl(ghr_rei_shd.g_old_rec.information_type,hr_api.g_varchar2) then
142: l_argument := 'information_type';
143: raise l_error;
144: end if;
145: --

Line 150: hr_api.argument_changed_error

146: hr_utility.set_location(' Leaving : '|| l_proc, 40);
147: --
148: exception
149: when l_error then
150: hr_api.argument_changed_error
151: (p_api_name => l_proc
152: ,p_argument => l_argument);
153: when others then
154: raise;

Line 213: hr_api.mandatory_arg_error

209: --
210: --
211: -- Check mandatory parameters have been set
212: --
213: hr_api.mandatory_arg_error
214: (
215: p_api_name => l_proc,
216: p_argument => 'information_type',
217: p_argument_value => p_information_type

Line 312: hr_api.mandatory_arg_error

308: if p_multiple_occurrences_flag = 'N' then
309: --
310: -- Check mandatory parameters have been set
311: --
312: hr_api.mandatory_arg_error
313: (
314: p_api_name => l_proc,
315: p_argument => 'information_type',
316: p_argument_value => p_information_type

Line 320: hr_api.mandatory_arg_error

316: p_argument_value => p_information_type
317: );
318: --
319: --
320: hr_api.mandatory_arg_error
321: (
322: p_api_name => l_proc,
323: p_argument => 'pa_request_id',
324: p_argument_value => p_pa_request_id

Line 365: hr_api.mandatory_arg_error

361: hr_utility.set_location('Entering: '|| l_proc, 10);
362: --
363: -- Check mandatory parameters have been set
364: --
365: hr_api.mandatory_arg_error
366: (p_api_name => l_proc
367: ,p_argument => 'effective date'
368: ,p_argument_value => p_effective_date
369: );

Line 381: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)

377: (p_pa_request_extra_info_id => p_pa_request_extra_info_id
378: ,p_object_version_number => p_object_version_number
379: );
380: if ((l_api_updating and
381: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
382: <> nvl(p_reason_for_submission, hr_api.g_varchar2)) or
383: (not l_api_updating))
384: then
385: hr_utility.set_location(l_proc, 20);

Line 382: <> nvl(p_reason_for_submission, hr_api.g_varchar2)) or

378: ,p_object_version_number => p_object_version_number
379: );
380: if ((l_api_updating and
381: nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
382: <> nvl(p_reason_for_submission, hr_api.g_varchar2)) or
383: (not l_api_updating))
384: then
385: hr_utility.set_location(l_proc, 20);
386: --

Line 393: if hr_api.not_exists_in_hr_lookups

389: -- where the lookup_type is 'GHR_US_SUBMISSION_REASON'
390: --
391: if p_reason_for_submission is not null
392: then
393: if hr_api.not_exists_in_hr_lookups
394: (p_effective_date => p_effective_date
395: ,p_lookup_type => 'GHR_US_SUBMISSION_REASON'
396: ,p_lookup_code => p_reason_for_submission
397: )

Line 434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)

430: ,p_object_version_number => p_object_version_number
431: );
432: IF (l_api_updating
433: AND
434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))
436: OR
437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
438: <> nvl(p_explanation,hr_api.g_varchar2)))

Line 435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))

431: );
432: IF (l_api_updating
433: AND
434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))
436: OR
437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
438: <> nvl(p_explanation,hr_api.g_varchar2)))
439: )

Line 437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)

433: AND
434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))
436: OR
437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
438: <> nvl(p_explanation,hr_api.g_varchar2)))
439: )
440: OR
441: NOT l_api_updating THEN

Line 438: <> nvl(p_explanation,hr_api.g_varchar2)))

434: ((nvl(ghr_rei_shd.g_old_rec.rei_information3,hr_api.g_varchar2)
435: <> nvl(p_reason_for_submission,hr_api.g_varchar2)))
436: OR
437: ((nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
438: <> nvl(p_explanation,hr_api.g_varchar2)))
439: )
440: OR
441: NOT l_api_updating THEN
442: /*

Line 444: nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)

440: OR
441: NOT l_api_updating THEN
442: /*
443: if ((l_api_updating and
444: nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
445: <> nvl(p_explanation, hr_api.g_varchar2)) or
446: (not l_api_updating))
447: then
448: */

Line 445: <> nvl(p_explanation, hr_api.g_varchar2)) or

441: NOT l_api_updating THEN
442: /*
443: if ((l_api_updating and
444: nvl(ghr_rei_shd.g_old_rec.rei_information4,hr_api.g_varchar2)
445: <> nvl(p_explanation, hr_api.g_varchar2)) or
446: (not l_api_updating))
447: then
448: */
449: if (p_reason_for_submission = '4' and (p_explanation is null))

Line 477: hr_api.mandatory_arg_error

473: hr_utility.set_location('Entering: '|| l_proc, 10);
474: --
475: -- Check mandatory parameters have been set
476: --
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc
479: ,p_argument => 'service'
480: ,p_argument_value => p_service
481: );

Line 494: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)

490: ,p_object_version_number => p_object_version_number
491: );
492: --
493: if ((l_api_updating and
494: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)
495: <> nvl(p_service, hr_api.g_varchar2)) or
496: (not l_api_updating))
497: then
498: hr_utility.set_location(l_proc, 20);

Line 495: <> nvl(p_service, hr_api.g_varchar2)) or

491: );
492: --
493: if ((l_api_updating and
494: nvl(ghr_rei_shd.g_old_rec.rei_information5,hr_api.g_varchar2)
495: <> nvl(p_service, hr_api.g_varchar2)) or
496: (not l_api_updating))
497: then
498: hr_utility.set_location(l_proc, 20);
499: --

Line 506: if hr_api.not_exists_in_hr_lookups

502: -- where the lookup type is 'GHR_US_SERVICE'
503: --
504: if p_service is not null
505: then
506: if hr_api.not_exists_in_hr_lookups
507: (p_effective_date => p_effective_date
508: ,P_lookup_type => 'GHR_US_SERVICE'
509: ,p_lookup_code => p_service
510: )