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_PAR_SHD dependencies on GHR_PA_REQUESTS

Line 21: If (p_constraint_name = 'GHR_PA_REQUESTS_FK2') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'GHR_PA_REQUESTS_FK2') Then
22: hr_utility.set_message(8301, 'GHR_38058_INV_FIRST_NOA');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK10') Then
25: hr_utility.set_message(8301, 'GHR_38050_INV_ROUTING_GROUP');

Line 24: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK10') Then

20: --
21: If (p_constraint_name = 'GHR_PA_REQUESTS_FK2') Then
22: hr_utility.set_message(8301, 'GHR_38058_INV_FIRST_NOA');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK10') Then
25: hr_utility.set_message(8301, 'GHR_38050_INV_ROUTING_GROUP');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK11') Then -- First_noa_pa_request_id
28: hr_utility.set_message(8301, 'GHR_38199_INV_F_PA_REQ');

Line 27: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK11') Then -- First_noa_pa_request_id

23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK10') Then
25: hr_utility.set_message(8301, 'GHR_38050_INV_ROUTING_GROUP');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK11') Then -- First_noa_pa_request_id
28: hr_utility.set_message(8301, 'GHR_38199_INV_F_PA_REQ');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK12') Then -- Second Noa_pa_request_id
31: hr_utility.set_message(8301, 'GHR_38125_INV_S_PA_REQ');

Line 30: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK12') Then -- Second Noa_pa_request_id

26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK11') Then -- First_noa_pa_request_id
28: hr_utility.set_message(8301, 'GHR_38199_INV_F_PA_REQ');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK12') Then -- Second Noa_pa_request_id
31: hr_utility.set_message(8301, 'GHR_38125_INV_S_PA_REQ');
32: hr_utility.raise_error;
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK13') Then -- Altered Pa_request_id

Line 34: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK13') Then -- Altered Pa_request_id

30: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK12') Then -- Second Noa_pa_request_id
31: hr_utility.set_message(8301, 'GHR_38125_INV_S_PA_REQ');
32: hr_utility.raise_error;
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK13') Then -- Altered Pa_request_id
35: hr_utility.set_message(8301, 'GHR_38126_INV_A_PA_REQ');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK3') Then
38: hr_utility.set_message(8301, 'GHR_38166_INV_SECOND_NOA');

Line 37: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK3') Then

33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK13') Then -- Altered Pa_request_id
35: hr_utility.set_message(8301, 'GHR_38126_INV_A_PA_REQ');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK3') Then
38: hr_utility.set_message(8301, 'GHR_38166_INV_SECOND_NOA');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK1') Then
41: hr_utility.set_message(8301, 'GHR_38049_INV_NOA_FAMILY');

Line 40: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK1') Then

36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK3') Then
38: hr_utility.set_message(8301, 'GHR_38166_INV_SECOND_NOA');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK1') Then
41: hr_utility.set_message(8301, 'GHR_38049_INV_NOA_FAMILY');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK4') Then
44: hr_utility.set_message(8301, 'GHR_38266_INV_TO_PAY_PLAN');

Line 43: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK4') Then

39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK1') Then
41: hr_utility.set_message(8301, 'GHR_38049_INV_NOA_FAMILY');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK4') Then
44: hr_utility.set_message(8301, 'GHR_38266_INV_TO_PAY_PLAN');
45: hr_utility.raise_error;
46: -- ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK5') Then
47: -- hr_utility.set_message(8301, 'GHR_38057_INV_TO_POSITION');

Line 46: -- ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK5') Then

42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK4') Then
44: hr_utility.set_message(8301, 'GHR_38266_INV_TO_PAY_PLAN');
45: hr_utility.raise_error;
46: -- ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK5') Then
47: -- hr_utility.set_message(8301, 'GHR_38057_INV_TO_POSITION');
48: -- hr_utility.raise_error;
49: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK6') Then
50: hr_utility.set_message(8301, 'GHR_38052_INV_JOB');

Line 49: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK6') Then

45: hr_utility.raise_error;
46: -- ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK5') Then
47: -- hr_utility.set_message(8301, 'GHR_38057_INV_TO_POSITION');
48: -- hr_utility.raise_error;
49: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK6') Then
50: hr_utility.set_message(8301, 'GHR_38052_INV_JOB');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK7') Then
53: hr_utility.set_message(8301, 'GHR_38053_INV_GRADE');

Line 52: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK7') Then

48: -- hr_utility.raise_error;
49: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK6') Then
50: hr_utility.set_message(8301, 'GHR_38052_INV_JOB');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK7') Then
53: hr_utility.set_message(8301, 'GHR_38053_INV_GRADE');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK8') Then
56: hr_utility.set_message(8301, 'GHR_38054_INV_ORGANIZATION');

Line 55: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK8') Then

51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK7') Then
53: hr_utility.set_message(8301, 'GHR_38053_INV_GRADE');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK8') Then
56: hr_utility.set_message(8301, 'GHR_38054_INV_ORGANIZATION');
57: hr_utility.raise_error;
58: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK14') Then
59: hr_utility.set_message(8301, 'GHR_38265_INV_FROM_PAY_PLAN');

Line 58: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK14') Then

54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK8') Then
56: hr_utility.set_message(8301, 'GHR_38054_INV_ORGANIZATION');
57: hr_utility.raise_error;
58: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK14') Then
59: hr_utility.set_message(8301, 'GHR_38265_INV_FROM_PAY_PLAN');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_PK') Then
62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 61: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_PK') Then

57: hr_utility.raise_error;
58: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK14') Then
59: hr_utility.set_message(8301, 'GHR_38265_INV_FROM_PAY_PLAN');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_PK') Then
62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
63: hr_utility.set_message_token('PROCEDURE', l_proc);
64: hr_utility.set_message_token('STEP','70');
65: hr_utility.raise_error;

Line 66: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_UK1') Then

62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
63: hr_utility.set_message_token('PROCEDURE', l_proc);
64: hr_utility.set_message_token('STEP','70');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_UK1') Then
67: -- hr_utility.set_message(8301, 'GHR_38127_NOTIF_MUST_BE_UNIQ');
68: hr_utility.raise_error;
69: Else
70: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 318: from ghr_pa_requests

314: pa_incentive_payment_option,
315: award_salary,
316: -- Bug# RRR Changes
317: object_version_number
318: from ghr_pa_requests
319: where pa_request_id = p_pa_request_id;
320: --
321: l_proc varchar2(72) := g_package||'api_updating';
322: l_fct_ret boolean;

Line 614: from ghr_pa_requests

610: pa_incentive_payment_option,
611: award_salary,
612: -- Bug# RRR Changes
613: object_version_number
614: from ghr_pa_requests
615: where pa_request_id = p_pa_request_id
616: for update nowait;
617: --
618: l_proc varchar2(72) := g_package||'lck';

Line 664: hr_utility.set_message_token('TABLE_NAME', 'ghr_pa_requests');

660: -- The object is locked therefore we need to supply a meaningful
661: -- error message.
662: --
663: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
664: hr_utility.set_message_token('TABLE_NAME', 'ghr_pa_requests');
665: hr_utility.raise_error;
666: End lck;
667: --
668: -- ----------------------------------------------------------------------------