DBA Data[Home] [Help]

APPS.GHR_CAA_BUS dependencies on HR_API

Line 50: hr_api.mandatory_arg_error

46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error
51: (p_api_name => l_proc
52: ,p_argument => 'compl_agency_appeal_id'
53: ,p_argument_value => p_compl_agency_appeal_id
54: );

Line 73: hr_api.set_security_group_id

69: close csr_sec_grp;
70: --
71: -- Set the security_group_id in CLIENT_INFO
72: --
73: hr_api.set_security_group_id
74: (p_security_group_id => l_security_group_id
75: );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'compl_agency_appeal_id'
119: ,p_argument_value => p_compl_agency_appeal_id
120: );

Line 122: if ( nvl(ghr_caa_bus.g_compl_agency_appeal_id, hr_api.g_number)

118: ,p_argument => 'compl_agency_appeal_id'
119: ,p_argument_value => p_compl_agency_appeal_id
120: );
121: --
122: if ( nvl(ghr_caa_bus.g_compl_agency_appeal_id, hr_api.g_number)
123: = p_compl_agency_appeal_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 216: hr_api.argument_changed_error

212: -- not been updated.
213: --
214: EXCEPTION
215: WHEN l_error THEN
216: hr_api.argument_changed_error
217: (p_api_name => l_proc
218: ,p_argument => l_argument);
219: WHEN OTHERS THEN
220: RAISE;

Line 246: hr_api.mandatory_arg_error

242: hr_utility.set_location('Entering: '|| l_proc, 10);
243:
244: -- Check Mandatory Parameters are set
245:
246: hr_api.mandatory_arg_error
247: (p_api_name => l_proc,
248: p_argument => 'effective date',
249: p_argument_value => p_effective_date
250: );

Line 266: ((nvl(ghr_caa_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263:
264: IF (l_api_updating
265: AND
266: ((nvl(ghr_caa_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
267: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
268: OR
269: NOT l_api_updating THEN
270:

Line 267: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))

263:
264: IF (l_api_updating
265: AND
266: ((nvl(ghr_caa_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
267: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
268: OR
269: NOT l_api_updating THEN
270:
271: --

Line 281: IF hr_api.not_exists_in_hr_lookups

277: --
278:
279: IF p_reason_for_appeal is NOT NULL THEN
280:
281: IF hr_api.not_exists_in_hr_lookups
282: (p_effective_date => p_effective_date,
283: p_lookup_type => 'GHR_US_APPEAL_REASON',
284: p_lookup_code => p_reason_for_appeal
285: ) THEN

Line 326: hr_api.mandatory_arg_error

322: hr_utility.set_location('Entering: '|| l_proc, 10);
323:
324: -- Check Mandatory Parameters are set
325:
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc,
328: p_argument => 'effective date',
329: p_argument_value => p_effective_date
330: );

Line 346: ((nvl(ghr_caa_shd.g_old_rec.decision,hr_api.g_varchar2)

342: p_object_version_number => p_object_version_number);
343:
344: IF (l_api_updating
345: AND
346: ((nvl(ghr_caa_shd.g_old_rec.decision,hr_api.g_varchar2)
347: <> nvl(p_decision,hr_api.g_varchar2))))
348: OR
349: NOT l_api_updating THEN
350:

Line 347: <> nvl(p_decision,hr_api.g_varchar2))))

343:
344: IF (l_api_updating
345: AND
346: ((nvl(ghr_caa_shd.g_old_rec.decision,hr_api.g_varchar2)
347: <> nvl(p_decision,hr_api.g_varchar2))))
348: OR
349: NOT l_api_updating THEN
350:
351: --

Line 362: IF hr_api.not_exists_in_hr_lookups

358:
359: --
360: IF p_decision is NOT NULL THEN
361:
362: IF hr_api.not_exists_in_hr_lookups
363: (p_effective_date => p_effective_date,
364: p_lookup_type => 'GHR_US_APPEAL_DECISION',
365: p_lookup_code => p_decision
366: ) THEN

Line 407: hr_api.mandatory_arg_error

403: hr_utility.set_location('Entering: '|| l_proc, 10);
404:
405: -- Check Mandatory Parameters are set
406:
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc,
409: p_argument => 'effective date',
410: p_argument_value => p_effective_date
411: );

Line 427: ((nvl(ghr_caa_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)

423: p_object_version_number => p_object_version_number);
424:
425: IF (l_api_updating
426: AND
427: ((nvl(ghr_caa_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
428: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
429: OR
430: NOT l_api_updating THEN
431:

Line 428: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))

424:
425: IF (l_api_updating
426: AND
427: ((nvl(ghr_caa_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
428: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
429: OR
430: NOT l_api_updating THEN
431:
432: --

Line 442: IF hr_api.not_exists_in_hr_lookups

438: --
439:
440: IF p_rfr_requested_by is NOT NULL THEN
441:
442: IF hr_api.not_exists_in_hr_lookups
443: (p_effective_date => p_effective_date,
444: p_lookup_type => 'GHR_US_REQUESTOR',
445: p_lookup_code => p_rfr_requested_by
446: ) THEN

Line 487: hr_api.mandatory_arg_error

483: hr_utility.set_location('Entering: '|| l_proc, 10);
484:
485: -- Check Mandatory Parameters are set
486:
487: hr_api.mandatory_arg_error
488: (p_api_name => l_proc,
489: p_argument => 'effective date',
490: p_argument_value => p_effective_date
491: );

Line 507: ((nvl(ghr_caa_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)

503: p_object_version_number => p_object_version_number);
504:
505: IF (l_api_updating
506: AND
507: ((nvl(ghr_caa_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
508: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
509: OR
510: NOT l_api_updating THEN
511:

Line 508: <> nvl(p_rfr_decision,hr_api.g_varchar2))))

504:
505: IF (l_api_updating
506: AND
507: ((nvl(ghr_caa_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
508: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
509: OR
510: NOT l_api_updating THEN
511:
512: --

Line 522: IF hr_api.not_exists_in_hr_lookups

518: --
519:
520: IF p_rfr_decision is NOT NULL THEN
521:
522: IF hr_api.not_exists_in_hr_lookups
523: (p_effective_date => p_effective_date,
524: p_lookup_type => 'GHR_US_OFO_RFR_DECISION',
525: p_lookup_code => p_rfr_decision
526: ) THEN