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 HR_UTILITY

Line 19: hr_utility.set_location('Entering:'||l_proc, 5);

15: --
16: l_proc varchar2(72) := g_package||'constraint_error';
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;

Line 22: hr_utility.set_message(8301, 'GHR_38058_INV_FIRST_NOA');

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');
26: hr_utility.raise_error;

Line 23: hr_utility.raise_error;

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');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK11') Then -- First_noa_pa_request_id

Line 25: hr_utility.set_message(8301, 'GHR_38050_INV_ROUTING_GROUP');

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');
29: hr_utility.raise_error;

Line 26: hr_utility.raise_error;

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');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK12') Then -- Second Noa_pa_request_id

Line 28: hr_utility.set_message(8301, 'GHR_38199_INV_F_PA_REQ');

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');
32: hr_utility.raise_error;

Line 29: hr_utility.raise_error;

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');
32: hr_utility.raise_error;
33: hr_utility.raise_error;

Line 31: hr_utility.set_message(8301, 'GHR_38125_INV_S_PA_REQ');

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
35: hr_utility.set_message(8301, 'GHR_38126_INV_A_PA_REQ');

Line 32: hr_utility.raise_error;

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
35: hr_utility.set_message(8301, 'GHR_38126_INV_A_PA_REQ');
36: hr_utility.raise_error;

Line 33: hr_utility.raise_error;

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
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

Line 35: hr_utility.set_message(8301, 'GHR_38126_INV_A_PA_REQ');

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');
39: hr_utility.raise_error;

Line 36: hr_utility.raise_error;

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');
39: hr_utility.raise_error;
40: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK1') Then

Line 38: hr_utility.set_message(8301, 'GHR_38166_INV_SECOND_NOA');

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');
42: hr_utility.raise_error;

Line 39: hr_utility.raise_error;

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');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK4') Then

Line 41: hr_utility.set_message(8301, 'GHR_38049_INV_NOA_FAMILY');

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');
45: hr_utility.raise_error;

Line 42: hr_utility.raise_error;

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');
45: hr_utility.raise_error;
46: -- ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK5') Then

Line 44: hr_utility.set_message(8301, 'GHR_38266_INV_TO_PAY_PLAN');

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');
48: -- hr_utility.raise_error;

Line 45: hr_utility.raise_error;

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');
48: -- hr_utility.raise_error;
49: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK6') Then

Line 47: -- hr_utility.set_message(8301, 'GHR_38057_INV_TO_POSITION');

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');
51: hr_utility.raise_error;

Line 48: -- hr_utility.raise_error;

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');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK7') Then

Line 50: hr_utility.set_message(8301, 'GHR_38052_INV_JOB');

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');
54: hr_utility.raise_error;

Line 51: hr_utility.raise_error;

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');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK8') Then

Line 53: hr_utility.set_message(8301, 'GHR_38053_INV_GRADE');

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');
57: hr_utility.raise_error;

Line 54: hr_utility.raise_error;

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');
57: hr_utility.raise_error;
58: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_FK14') Then

Line 56: hr_utility.set_message(8301, 'GHR_38054_INV_ORGANIZATION');

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');
60: hr_utility.raise_error;

Line 57: hr_utility.raise_error;

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');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_PK') Then

Line 59: hr_utility.set_message(8301, 'GHR_38265_INV_FROM_PAY_PLAN');

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');
63: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 60: hr_utility.raise_error;

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');
63: hr_utility.set_message_token('PROCEDURE', l_proc);
64: hr_utility.set_message_token('STEP','70');

Line 62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;
66: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_UK1') Then

Line 63: hr_utility.set_message_token('PROCEDURE', l_proc);

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;
66: ElsIf (p_constraint_name = 'GHR_PA_REQUESTS_UK1') Then
67: -- hr_utility.set_message(8301, 'GHR_38127_NOTIF_MUST_BE_UNIQ');

Line 64: hr_utility.set_message_token('STEP','70');

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

Line 65: 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;
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

Line 67: -- hr_utility.set_message(8301, 'GHR_38127_NOTIF_MUST_BE_UNIQ');

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');
71: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 68: hr_utility.raise_error;

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');
71: hr_utility.set_message_token('PROCEDURE', l_proc);
72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 70: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

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');
71: hr_utility.set_message_token('PROCEDURE', l_proc);
72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
73: hr_utility.raise_error;
74: End If;

Line 71: hr_utility.set_message_token('PROCEDURE', l_proc);

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');
71: hr_utility.set_message_token('PROCEDURE', l_proc);
72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
73: hr_utility.raise_error;
74: End If;
75: --

Line 72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

68: hr_utility.raise_error;
69: Else
70: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
71: hr_utility.set_message_token('PROCEDURE', l_proc);
72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
73: hr_utility.raise_error;
74: End If;
75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 73: hr_utility.raise_error;

69: Else
70: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
71: hr_utility.set_message_token('PROCEDURE', l_proc);
72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
73: hr_utility.raise_error;
74: End If;
75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: End constraint_error;

Line 76: hr_utility.set_location(' Leaving:'||l_proc, 10);

72: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
73: hr_utility.raise_error;
74: End If;
75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: End constraint_error;
78: --
79: -- ----------------------------------------------------------------------------
80: -- |-----------------------------< api_updating >-----------------------------|

Line 325: hr_utility.set_location('Entering:'||l_proc, 5);

321: l_proc varchar2(72) := g_package||'api_updating';
322: l_fct_ret boolean;
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: If (
328: -- p_pa_request_id is null and
329: p_object_version_number is null

Line 341: hr_utility.set_location(l_proc, 10);

337: If (
338: p_pa_request_id = g_old_rec.pa_request_id and
339: p_object_version_number = g_old_rec.object_version_number
340: ) Then
341: hr_utility.set_location(l_proc, 10);
342: --
343: -- The g_old_rec is current therefore we must
344: -- set the returning function to true
345: --

Line 358: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

354: Close C_Sel1;
355: --
356: -- The primary key is invalid therefore we must error
357: --
358: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
359: hr_utility.raise_error;
360: End If;
361: Close C_Sel1;
362: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 359: hr_utility.raise_error;

355: --
356: -- The primary key is invalid therefore we must error
357: --
358: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
359: hr_utility.raise_error;
360: End If;
361: Close C_Sel1;
362: If (p_object_version_number <> g_old_rec.object_version_number) Then
363: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 363: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

359: hr_utility.raise_error;
360: End If;
361: Close C_Sel1;
362: If (p_object_version_number <> g_old_rec.object_version_number) Then
363: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
364: hr_utility.raise_error;
365: End If;
366: hr_utility.set_location(l_proc, 15);
367: l_fct_ret := true;

Line 364: hr_utility.raise_error;

360: End If;
361: Close C_Sel1;
362: If (p_object_version_number <> g_old_rec.object_version_number) Then
363: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
364: hr_utility.raise_error;
365: End If;
366: hr_utility.set_location(l_proc, 15);
367: l_fct_ret := true;
368: End If;

Line 366: hr_utility.set_location(l_proc, 15);

362: If (p_object_version_number <> g_old_rec.object_version_number) Then
363: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
364: hr_utility.raise_error;
365: End If;
366: hr_utility.set_location(l_proc, 15);
367: l_fct_ret := true;
368: End If;
369: End If;
370: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 370: hr_utility.set_location(' Leaving:'||l_proc, 20);

366: hr_utility.set_location(l_proc, 15);
367: l_fct_ret := true;
368: End If;
369: End If;
370: hr_utility.set_location(' Leaving:'||l_proc, 20);
371: Return (l_fct_ret);
372: --
373: End api_updating;
374: --

Line 621: hr_utility.set_location('Entering:'||l_proc, 5);

617: --
618: l_proc varchar2(72) := g_package||'lck';
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Add any mandatory argument checking here:
624: -- Example:
625: -- hr_api.mandatory_arg_error

Line 644: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

640: Close C_Sel1;
641: --
642: -- The primary key is invalid therefore we must error
643: --
644: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
645: hr_utility.raise_error;
646: End If;
647: Close C_Sel1;
648: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 645: hr_utility.raise_error;

641: --
642: -- The primary key is invalid therefore we must error
643: --
644: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
645: hr_utility.raise_error;
646: End If;
647: Close C_Sel1;
648: If (p_object_version_number <> g_old_rec.object_version_number) Then
649: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 649: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

645: hr_utility.raise_error;
646: End If;
647: Close C_Sel1;
648: If (p_object_version_number <> g_old_rec.object_version_number) Then
649: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
650: hr_utility.raise_error;
651: End If;
652: --
653: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 650: hr_utility.raise_error;

646: End If;
647: Close C_Sel1;
648: If (p_object_version_number <> g_old_rec.object_version_number) Then
649: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
650: hr_utility.raise_error;
651: End If;
652: --
653: hr_utility.set_location(' Leaving:'||l_proc, 10);
654: --

Line 653: hr_utility.set_location(' Leaving:'||l_proc, 10);

649: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
650: hr_utility.raise_error;
651: End If;
652: --
653: hr_utility.set_location(' Leaving:'||l_proc, 10);
654: --
655: -- We need to trap the ORA LOCK exception
656: --
657: Exception

Line 663: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

659: --
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: --

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: -- ----------------------------------------------------------------------------

Line 665: hr_utility.raise_error;

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: -- ----------------------------------------------------------------------------
669: -- |-----------------------------< convert_args >-----------------------------|

Line 906: hr_utility.set_location('Entering:'||l_proc, 5);

902: l_proc varchar2(72) := g_package||'convert_args';
903: --
904: Begin
905: --
906: hr_utility.set_location('Entering:'||l_proc, 5);
907: --
908: -- Convert arguments into local l_rec structure.
909: --
910: l_rec.pa_request_id := p_pa_request_id;

Line 933: hr_utility.set_location('Before awarduom', 1);

929: l_rec.sf50_approving_ofcl_work_title := p_sf50_approving_ofcl_work_tit;
930: l_rec.authorized_by_person_id := p_authorized_by_person_id;
931: l_rec.authorized_by_title := p_authorized_by_title;
932: l_rec.award_amount := p_award_amount;
933: hr_utility.set_location('Before awarduom', 1);
934: hr_utility.set_location('Award UOM' || p_award_uom,1);
935: l_rec.award_uom := p_award_uom;
936: hr_utility.set_location('L Award UOM' || l_rec.award_uom,1);
937: l_rec.bargaining_unit_status := p_bargaining_unit_status;

Line 934: hr_utility.set_location('Award UOM' || p_award_uom,1);

930: l_rec.authorized_by_person_id := p_authorized_by_person_id;
931: l_rec.authorized_by_title := p_authorized_by_title;
932: l_rec.award_amount := p_award_amount;
933: hr_utility.set_location('Before awarduom', 1);
934: hr_utility.set_location('Award UOM' || p_award_uom,1);
935: l_rec.award_uom := p_award_uom;
936: hr_utility.set_location('L Award UOM' || l_rec.award_uom,1);
937: l_rec.bargaining_unit_status := p_bargaining_unit_status;
938: l_rec.citizenship := p_citizenship;

Line 936: hr_utility.set_location('L Award UOM' || l_rec.award_uom,1);

932: l_rec.award_amount := p_award_amount;
933: hr_utility.set_location('Before awarduom', 1);
934: hr_utility.set_location('Award UOM' || p_award_uom,1);
935: l_rec.award_uom := p_award_uom;
936: hr_utility.set_location('L Award UOM' || l_rec.award_uom,1);
937: l_rec.bargaining_unit_status := p_bargaining_unit_status;
938: l_rec.citizenship := p_citizenship;
939: l_rec.concurrence_date := p_concurrence_date;
940: l_rec.custom_pay_calc_flag := p_custom_pay_calc_flag;

Line 1125: hr_utility.set_location('Before all per', 1);

1121: l_rec.attribute20 := p_attribute20;
1122: l_rec.object_version_number := p_object_version_number;
1123: l_rec.first_noa_canc_pa_request_id := p_first_noa_canc_pa_request_id;
1124: l_rec.second_noa_canc_pa_request_id := p_second_noa_canc_pa_request_i;
1125: hr_utility.set_location('Before all per', 1);
1126: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
1127: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
1128: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
1129: hr_utility.set_location('Before awardper', 1);

Line 1129: hr_utility.set_location('Before awardper', 1);

1125: hr_utility.set_location('Before all per', 1);
1126: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
1127: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
1128: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
1129: hr_utility.set_location('Before awardper', 1);
1130: l_rec.award_percentage := p_award_percentage;
1131: hr_utility.set_location('Before RPA Type', 1);
1132: hr_utility.set_location('RPA Type ' || p_rpa_type,1);
1133: l_rec.rpa_type := p_rpa_type;

Line 1131: hr_utility.set_location('Before RPA Type', 1);

1127: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
1128: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
1129: hr_utility.set_location('Before awardper', 1);
1130: l_rec.award_percentage := p_award_percentage;
1131: hr_utility.set_location('Before RPA Type', 1);
1132: hr_utility.set_location('RPA Type ' || p_rpa_type,1);
1133: l_rec.rpa_type := p_rpa_type;
1134: hr_utility.set_location('after RPA Type', 1);
1135: l_rec.mass_action_id := p_mass_action_id;

Line 1132: hr_utility.set_location('RPA Type ' || p_rpa_type,1);

1128: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
1129: hr_utility.set_location('Before awardper', 1);
1130: l_rec.award_percentage := p_award_percentage;
1131: hr_utility.set_location('Before RPA Type', 1);
1132: hr_utility.set_location('RPA Type ' || p_rpa_type,1);
1133: l_rec.rpa_type := p_rpa_type;
1134: hr_utility.set_location('after RPA Type', 1);
1135: l_rec.mass_action_id := p_mass_action_id;
1136: hr_utility.set_location('after massactg', 1);

Line 1134: hr_utility.set_location('after RPA Type', 1);

1130: l_rec.award_percentage := p_award_percentage;
1131: hr_utility.set_location('Before RPA Type', 1);
1132: hr_utility.set_location('RPA Type ' || p_rpa_type,1);
1133: l_rec.rpa_type := p_rpa_type;
1134: hr_utility.set_location('after RPA Type', 1);
1135: l_rec.mass_action_id := p_mass_action_id;
1136: hr_utility.set_location('after massactg', 1);
1137: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
1138: hr_utility.set_location('elig flag value is ' || l_rec.mass_action_eligible_flag , 1);

Line 1136: hr_utility.set_location('after massactg', 1);

1132: hr_utility.set_location('RPA Type ' || p_rpa_type,1);
1133: l_rec.rpa_type := p_rpa_type;
1134: hr_utility.set_location('after RPA Type', 1);
1135: l_rec.mass_action_id := p_mass_action_id;
1136: hr_utility.set_location('after massactg', 1);
1137: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
1138: hr_utility.set_location('elig flag value is ' || l_rec.mass_action_eligible_flag , 1);
1139: l_rec.mass_action_select_flag := p_mass_action_select_flag;
1140: hr_utility.set_location('after seleflag', 1);

Line 1138: hr_utility.set_location('elig flag value is ' || l_rec.mass_action_eligible_flag , 1);

1134: hr_utility.set_location('after RPA Type', 1);
1135: l_rec.mass_action_id := p_mass_action_id;
1136: hr_utility.set_location('after massactg', 1);
1137: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
1138: hr_utility.set_location('elig flag value is ' || l_rec.mass_action_eligible_flag , 1);
1139: l_rec.mass_action_select_flag := p_mass_action_select_flag;
1140: hr_utility.set_location('after seleflag', 1);
1141: l_rec.mass_action_comments := p_mass_action_comments;
1142: -- Bug#4486823 RRR Changes

Line 1140: hr_utility.set_location('after seleflag', 1);

1136: hr_utility.set_location('after massactg', 1);
1137: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
1138: hr_utility.set_location('elig flag value is ' || l_rec.mass_action_eligible_flag , 1);
1139: l_rec.mass_action_select_flag := p_mass_action_select_flag;
1140: hr_utility.set_location('after seleflag', 1);
1141: l_rec.mass_action_comments := p_mass_action_comments;
1142: -- Bug#4486823 RRR Changes
1143: l_rec.payment_option := p_payment_option;
1144: l_rec.award_salary := p_award_salary ;

Line 1146: hr_utility.set_location('after comments', 1);

1142: -- Bug#4486823 RRR Changes
1143: l_rec.payment_option := p_payment_option;
1144: l_rec.award_salary := p_award_salary ;
1145: -- Bug#4486823 RRR Changes
1146: hr_utility.set_location('after comments', 1);
1147: --
1148: -- Return the plsql record structure.
1149: --
1150: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1150: hr_utility.set_location(' Leaving:'||l_proc, 10);

1146: hr_utility.set_location('after comments', 1);
1147: --
1148: -- Return the plsql record structure.
1149: --
1150: hr_utility.set_location(' Leaving:'||l_proc, 10);
1151: Return(l_rec);
1152: --
1153: End convert_args;
1154: --