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.GHR_CCA_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_appeal_id'
53: ,p_argument_value => p_compl_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_appeal_id'
119: ,p_argument_value => p_compl_appeal_id
120: );

Line 122: if ( nvl(ghr_cca_bus.g_compl_appeal_id, hr_api.g_number)

118: ,p_argument => 'compl_appeal_id'
119: ,p_argument_value => p_compl_appeal_id
120: );
121: --
122: if ( nvl(ghr_cca_bus.g_compl_appeal_id, hr_api.g_number)
123: = p_compl_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 245: hr_api.mandatory_arg_error

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

Line 265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)

261: p_object_version_number => p_object_version_number);
262:
263: IF (l_api_updating
264: AND
265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)
266: <> nvl(p_appealed_to,hr_api.g_varchar2))))
267: OR
268: NOT l_api_updating THEN
269:

Line 266: <> nvl(p_appealed_to,hr_api.g_varchar2))))

262:
263: IF (l_api_updating
264: AND
265: ((nvl(ghr_cca_shd.g_old_rec.appealed_to,hr_api.g_varchar2)
266: <> nvl(p_appealed_to,hr_api.g_varchar2))))
267: OR
268: NOT l_api_updating THEN
269:
270: --

Line 280: IF hr_api.not_exists_in_hr_lookups

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

Line 325: hr_api.mandatory_arg_error

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

Line 345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)

341: p_object_version_number => p_object_version_number);
342:
343: IF (l_api_updating
344: AND
345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
346: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
347: OR
348: NOT l_api_updating THEN
349:

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

342:
343: IF (l_api_updating
344: AND
345: ((nvl(ghr_cca_shd.g_old_rec.reason_for_appeal,hr_api.g_varchar2)
346: <> nvl(p_reason_for_appeal,hr_api.g_varchar2))))
347: OR
348: NOT l_api_updating THEN
349:
350: --

Line 360: IF hr_api.not_exists_in_hr_lookups

356: --
357:
358: IF p_reason_for_appeal is NOT NULL THEN
359:
360: IF hr_api.not_exists_in_hr_lookups
361: (p_effective_date => p_effective_date,
362: p_lookup_type => 'GHR_US_APPEAL_REASON',
363: p_lookup_code => p_reason_for_appeal
364: ) THEN

Line 410: hr_api.mandatory_arg_error

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

Line 430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)

426: p_object_version_number => p_object_version_number);
427:
428: IF (l_api_updating
429: AND
430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)
431: <> nvl(p_decision,hr_api.g_varchar2))))
432: OR
433: NOT l_api_updating THEN
434:

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

427:
428: IF (l_api_updating
429: AND
430: ((nvl(ghr_cca_shd.g_old_rec.decision,hr_api.g_varchar2)
431: <> nvl(p_decision,hr_api.g_varchar2))))
432: OR
433: NOT l_api_updating THEN
434:
435: --

Line 455: IF hr_api.not_exists_in_hr_lookups

451: ELSIF p_appealed_to = l_mspb then
452: l_lookup_type := 'GHR_US_MSPB_DECISION';
453: END IF;
454:
455: IF hr_api.not_exists_in_hr_lookups
456: (p_effective_date => p_effective_date,
457: p_lookup_type => l_lookup_type,
458: p_lookup_code => p_decision
459: ) THEN

Line 500: hr_api.mandatory_arg_error

496: hr_utility.set_location('Entering: '|| l_proc, 10);
497:
498: -- Check Mandatory Parameters are set
499:
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'effective date',
503: p_argument_value => p_effective_date
504: );

Line 520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)

516: p_object_version_number => p_object_version_number);
517:
518: IF (l_api_updating
519: AND
520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
521: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
522: OR
523: NOT l_api_updating THEN
524:

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

517:
518: IF (l_api_updating
519: AND
520: ((nvl(ghr_cca_shd.g_old_rec.rfr_requested_by,hr_api.g_varchar2)
521: <> nvl(p_rfr_requested_by,hr_api.g_varchar2))))
522: OR
523: NOT l_api_updating THEN
524:
525: --

Line 535: IF hr_api.not_exists_in_hr_lookups

531: --
532:
533: IF p_rfr_requested_by is NOT NULL THEN
534:
535: IF hr_api.not_exists_in_hr_lookups
536: (p_effective_date => p_effective_date,
537: p_lookup_type => 'GHR_US_REQUESTOR',
538: p_lookup_code => p_rfr_requested_by
539: ) THEN

Line 580: hr_api.mandatory_arg_error

576: hr_utility.set_location('Entering: '|| l_proc, 10);
577:
578: -- Check Mandatory Parameters are set
579:
580: hr_api.mandatory_arg_error
581: (p_api_name => l_proc,
582: p_argument => 'effective date',
583: p_argument_value => p_effective_date
584: );

Line 600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)

596: p_object_version_number => p_object_version_number);
597:
598: IF (l_api_updating
599: AND
600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
601: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
602: OR
603: NOT l_api_updating THEN
604:

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

597:
598: IF (l_api_updating
599: AND
600: ((nvl(ghr_cca_shd.g_old_rec.rfr_decision,hr_api.g_varchar2)
601: <> nvl(p_rfr_decision,hr_api.g_varchar2))))
602: OR
603: NOT l_api_updating THEN
604:
605: --

Line 615: IF hr_api.not_exists_in_hr_lookups

611: --
612:
613: IF p_rfr_decision is NOT NULL THEN
614:
615: IF hr_api.not_exists_in_hr_lookups
616: (p_effective_date => p_effective_date,
617: p_lookup_type => 'GHR_US_OFO_RFR_DECISION',
618: p_lookup_code => p_rfr_decision
619: ) THEN