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.PER_RTX_SHD dependencies on HR_UTILITY

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

16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');

19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then

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

20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 25: hr_utility.set_message_token('STEP','5');

21: --
22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 26: hr_utility.raise_error;

22: If (p_constraint_name = 'PER_RATING_LEVELS_FK1') Then
23: hr_utility.set_message(801, 'HR_51471_RTL_RSC_NOT_EXIST');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');

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

24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then

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

25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');

Line 30: hr_utility.set_message_token('STEP','10');

26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 31: hr_utility.raise_error;

27: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK2') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');

Line 33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');

29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then

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

30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 35: hr_utility.set_message_token('STEP','15');

31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 36: hr_utility.raise_error;

32: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_FK3') Then
33: hr_utility.set_message(801, 'HR_51472_RTL_CPN_NOT_EXIST');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');

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

34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then

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

35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');

Line 40: hr_utility.set_message_token('STEP','20');

36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 41: hr_utility.raise_error;

37: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_PK') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');

Line 43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');

39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then

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

40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');

Line 45: hr_utility.set_message_token('STEP','25');

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 46: hr_utility.raise_error;

42: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK2') Then
43: hr_utility.set_message(801, 'HR_51477_RTL_STEP_NOT_UNIQUE');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');

Line 48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');

44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then

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

45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');

Line 50: hr_utility.set_message_token('STEP','30');

46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
54: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 51: hr_utility.raise_error;

47: ElsIf (p_constraint_name = 'PER_RATING_LEVELS_UK3') Then
48: hr_utility.set_message(801, 'HR_51474_RTL_NOT_UNIQUE');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');

Line 53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');

49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else

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

50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 55: hr_utility.set_message_token('STEP','35');

51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 56: hr_utility.raise_error;

52: ElsIf (p_constraint_name = 'PER_RTL_CPN_OR_RSC_CHK') Then
53: hr_utility.set_message(801, 'HR_51482_RTL_RSC_OR_CPN');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;

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

55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --

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

56: hr_utility.raise_error;
57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
64: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 61: hr_utility.raise_error;

57: Else
58: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
64: hr_utility.set_location(' Leaving:'||l_proc, 10);
65: End constraint_error;

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

60: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
61: hr_utility.raise_error;
62: End If;
63: --
64: hr_utility.set_location(' Leaving:'||l_proc, 10);
65: End constraint_error;
66: --
67: -- ----------------------------------------------------------------------------
68: -- |-----------------------------< api_updating >-----------------------------|

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

156: --
157: l_proc varchar2(72) := g_package||'lck';
158: --
159: Begin
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: hr_api.mandatory_arg_error
163: (p_api_name => l_proc
164: ,p_argument => 'RATING_LEVEL_ID'

Line 167: hr_utility.set_location(l_proc,6);

163: (p_api_name => l_proc
164: ,p_argument => 'RATING_LEVEL_ID'
165: ,p_argument_value => p_rating_level_id
166: );
167: hr_utility.set_location(l_proc,6);
168: hr_api.mandatory_arg_error
169: (p_api_name => l_proc
170: ,p_argument => 'LANGUAGE'
171: ,p_argument_value => p_language

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

183: End If;
184: Close C_Sel1;
185: --
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: --
189: -- We need to trap the ORA LOCK exception
190: --
191: Exception