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

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

14: --
15: l_proc varchar2(72) := g_package||'return_api_dml_status';
16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
23: End return_api_dml_status;
24: --
25: -- ----------------------------------------------------------------------------
26: -- |---------------------------< constraint_error >---------------------------|

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

30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'HR_EXU_CAL_CAU_ARC') Then
37: -- *** NEW_MESSAGE_REQUIRED ***
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'HR_EXU_CAL_CAU_ARC') Then
37: -- *** NEW_MESSAGE_REQUIRED ***
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','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then

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

35: --
36: If (p_constraint_name = 'HR_EXU_CAL_CAU_ARC') Then
37: -- *** NEW_MESSAGE_REQUIRED ***
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','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then
43: -- *** NEW_MESSAGE_REQUIRED ***

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

36: If (p_constraint_name = 'HR_EXU_CAL_CAU_ARC') Then
37: -- *** NEW_MESSAGE_REQUIRED ***
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','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then
43: -- *** NEW_MESSAGE_REQUIRED ***
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 41: hr_utility.raise_error;

37: -- *** NEW_MESSAGE_REQUIRED ***
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','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then
43: -- *** NEW_MESSAGE_REQUIRED ***
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);

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

40: hr_utility.set_message_token('STEP','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then
43: -- *** NEW_MESSAGE_REQUIRED ***
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP','10');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then

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

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then
43: -- *** NEW_MESSAGE_REQUIRED ***
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP','10');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then
49: -- *** NEW_MESSAGE_REQUIRED ***

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

42: ElsIf (p_constraint_name = 'HR_EXU_CAL_FK') Then
43: -- *** NEW_MESSAGE_REQUIRED ***
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP','10');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then
49: -- *** NEW_MESSAGE_REQUIRED ***
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 47: hr_utility.raise_error;

43: -- *** NEW_MESSAGE_REQUIRED ***
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP','10');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then
49: -- *** NEW_MESSAGE_REQUIRED ***
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);

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

46: hr_utility.set_message_token('STEP','10');
47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then
49: -- *** NEW_MESSAGE_REQUIRED ***
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);
52: hr_utility.set_message_token('STEP','15');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then

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

47: hr_utility.raise_error;
48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then
49: -- *** NEW_MESSAGE_REQUIRED ***
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);
52: hr_utility.set_message_token('STEP','15');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then
55: -- *** NEW_MESSAGE_REQUIRED ***

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

48: ElsIf (p_constraint_name = 'HR_EXU_CAU_FK') Then
49: -- *** NEW_MESSAGE_REQUIRED ***
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);
52: hr_utility.set_message_token('STEP','15');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then
55: -- *** NEW_MESSAGE_REQUIRED ***
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 53: hr_utility.raise_error;

49: -- *** NEW_MESSAGE_REQUIRED ***
50: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.set_message_token('PROCEDURE', l_proc);
52: hr_utility.set_message_token('STEP','15');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then
55: -- *** NEW_MESSAGE_REQUIRED ***
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);

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

52: hr_utility.set_message_token('STEP','15');
53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then
55: -- *** NEW_MESSAGE_REQUIRED ***
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','20');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then

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

53: hr_utility.raise_error;
54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then
55: -- *** NEW_MESSAGE_REQUIRED ***
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','20');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then
61: -- *** NEW_MESSAGE_REQUIRED ***

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

54: ElsIf (p_constraint_name = 'HR_EXU_PAE_FK') Then
55: -- *** NEW_MESSAGE_REQUIRED ***
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','20');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then
61: -- *** NEW_MESSAGE_REQUIRED ***
62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 59: hr_utility.raise_error;

55: -- *** NEW_MESSAGE_REQUIRED ***
56: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
57: hr_utility.set_message_token('PROCEDURE', l_proc);
58: hr_utility.set_message_token('STEP','20');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then
61: -- *** NEW_MESSAGE_REQUIRED ***
62: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
63: hr_utility.set_message_token('PROCEDURE', l_proc);

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

58: hr_utility.set_message_token('STEP','20');
59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then
61: -- *** NEW_MESSAGE_REQUIRED ***
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','25');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then

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

59: hr_utility.raise_error;
60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then
61: -- *** NEW_MESSAGE_REQUIRED ***
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','25');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then
67: -- *** NEW_MESSAGE_REQUIRED ***

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

60: ElsIf (p_constraint_name = 'HR_EXU_PK') Then
61: -- *** NEW_MESSAGE_REQUIRED ***
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','25');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then
67: -- *** NEW_MESSAGE_REQUIRED ***
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 65: hr_utility.raise_error;

61: -- *** NEW_MESSAGE_REQUIRED ***
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','25');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then
67: -- *** NEW_MESSAGE_REQUIRED ***
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', l_proc);

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

64: hr_utility.set_message_token('STEP','25');
65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then
67: -- *** NEW_MESSAGE_REQUIRED ***
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', l_proc);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then

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

65: hr_utility.raise_error;
66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then
67: -- *** NEW_MESSAGE_REQUIRED ***
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', l_proc);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then
73: -- *** NEW_MESSAGE_REQUIRED ***

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

66: ElsIf (p_constraint_name = 'HR_EXU_UK01') Then
67: -- *** NEW_MESSAGE_REQUIRED ***
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', l_proc);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then
73: -- *** NEW_MESSAGE_REQUIRED ***
74: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 71: hr_utility.raise_error;

67: -- *** NEW_MESSAGE_REQUIRED ***
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', l_proc);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then
73: -- *** NEW_MESSAGE_REQUIRED ***
74: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE', l_proc);

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

70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then
73: -- *** NEW_MESSAGE_REQUIRED ***
74: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE', l_proc);
76: hr_utility.set_message_token('STEP','35');
77: hr_utility.raise_error;
78: Else

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

71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then
73: -- *** NEW_MESSAGE_REQUIRED ***
74: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE', l_proc);
76: hr_utility.set_message_token('STEP','35');
77: hr_utility.raise_error;
78: Else
79: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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

72: ElsIf (p_constraint_name = 'HR_EXU_UK02') Then
73: -- *** NEW_MESSAGE_REQUIRED ***
74: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE', l_proc);
76: hr_utility.set_message_token('STEP','35');
77: hr_utility.raise_error;
78: Else
79: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
80: fnd_message.set_token('PROCEDURE',l_proc);

Line 77: hr_utility.raise_error;

73: -- *** NEW_MESSAGE_REQUIRED ***
74: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
75: hr_utility.set_message_token('PROCEDURE', l_proc);
76: hr_utility.set_message_token('STEP','35');
77: hr_utility.raise_error;
78: Else
79: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
80: fnd_message.set_token('PROCEDURE',l_proc);
81: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);

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

81: fnd_message.set_token('CONSTRAINT_NAME',p_constraint_name);
82: fnd_message.raise_error;
83: End If;
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: End constraint_error;
87: --
88: -- ----------------------------------------------------------------------------
89: -- |-----------------------------< api_updating >-----------------------------|

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

111: l_proc varchar2(72) := g_package||'api_updating';
112: l_fct_ret boolean;
113: --
114: Begin
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: If (
118: p_exception_usage_id is null and
119: p_object_version_number is null

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

127: If (
128: p_exception_usage_id = g_old_rec.exception_usage_id and
129: p_object_version_number = g_old_rec.object_version_number
130: ) Then
131: hr_utility.set_location(l_proc, 10);
132: --
133: -- The g_old_rec is current therefore we must
134: -- set the returning function to true
135: --

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

145: --
146: -- The primary key is invalid therefore we must error
147: --
148: -- *** NEW_MESSAGE_REQUIRED ***
149: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
150: hr_utility.raise_error;
151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 150: hr_utility.raise_error;

146: -- The primary key is invalid therefore we must error
147: --
148: -- *** NEW_MESSAGE_REQUIRED ***
149: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
150: hr_utility.raise_error;
151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: -- *** NEW_MESSAGE_REQUIRED ***

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

151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: -- *** NEW_MESSAGE_REQUIRED ***
155: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
156: hr_utility.raise_error;
157: End If;
158: hr_utility.set_location(l_proc, 15);
159: l_fct_ret := true;

Line 156: hr_utility.raise_error;

152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: -- *** NEW_MESSAGE_REQUIRED ***
155: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
156: hr_utility.raise_error;
157: End If;
158: hr_utility.set_location(l_proc, 15);
159: l_fct_ret := true;
160: End If;

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

154: -- *** NEW_MESSAGE_REQUIRED ***
155: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
156: hr_utility.raise_error;
157: End If;
158: hr_utility.set_location(l_proc, 15);
159: l_fct_ret := true;
160: End If;
161: End If;
162: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

158: hr_utility.set_location(l_proc, 15);
159: l_fct_ret := true;
160: End If;
161: End If;
162: hr_utility.set_location(' Leaving:'||l_proc, 20);
163: Return (l_fct_ret);
164: --
165: End api_updating;
166: --

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

188: --
189: l_proc varchar2(72) := g_package||'lck';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: -- Add any mandatory argument checking here:
195: -- Example:
196: -- hr_api.mandatory_arg_error

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

205: --
206: -- The primary key is invalid therefore we must error
207: --
208: -- *** NEW_MESSAGE_REQUIRED ***
209: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
210: hr_utility.raise_error;
211: End If;
212: Close C_Sel1;
213: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 210: hr_utility.raise_error;

206: -- The primary key is invalid therefore we must error
207: --
208: -- *** NEW_MESSAGE_REQUIRED ***
209: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
210: hr_utility.raise_error;
211: End If;
212: Close C_Sel1;
213: If (p_object_version_number <> g_old_rec.object_version_number) Then
214: -- *** NEW_MESSAGE_REQUIRED ***

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

211: End If;
212: Close C_Sel1;
213: If (p_object_version_number <> g_old_rec.object_version_number) Then
214: -- *** NEW_MESSAGE_REQUIRED ***
215: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
216: hr_utility.raise_error;
217: End If;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 216: hr_utility.raise_error;

212: Close C_Sel1;
213: If (p_object_version_number <> g_old_rec.object_version_number) Then
214: -- *** NEW_MESSAGE_REQUIRED ***
215: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
216: hr_utility.raise_error;
217: End If;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: --

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

215: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
216: hr_utility.raise_error;
217: End If;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: --
221: -- We need to trap the ORA LOCK exception
222: --
223: Exception

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

226: -- The object is locked therefore we need to supply a meaningful
227: -- error message.
228: --
229: -- *** NEW_MESSAGE_REQUIRED ***
230: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
231: hr_utility.set_message_token('TABLE_NAME', 'hr_exception_usages');
232: hr_utility.raise_error;
233: End lck;
234: --

Line 231: hr_utility.set_message_token('TABLE_NAME', 'hr_exception_usages');

227: -- error message.
228: --
229: -- *** NEW_MESSAGE_REQUIRED ***
230: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
231: hr_utility.set_message_token('TABLE_NAME', 'hr_exception_usages');
232: hr_utility.raise_error;
233: End lck;
234: --
235: -- ----------------------------------------------------------------------------

Line 232: hr_utility.raise_error;

228: --
229: -- *** NEW_MESSAGE_REQUIRED ***
230: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
231: hr_utility.set_message_token('TABLE_NAME', 'hr_exception_usages');
232: hr_utility.raise_error;
233: End lck;
234: --
235: -- ----------------------------------------------------------------------------
236: -- |-----------------------------< convert_args >-----------------------------|

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

250: l_proc varchar2(72) := g_package||'convert_args';
251: --
252: Begin
253: --
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: -- Convert arguments into local l_rec structure.
257: --
258: l_rec.exception_usage_id := p_exception_usage_id;

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

263: l_rec.exception_id := p_exception_id;
264: --
265: -- Return the plsql record structure.
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: Return(l_rec);
269: --
270: End convert_args;
271: --