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_OBJ_SHD dependencies on HR_UTILITY

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

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

Line 21: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: If (p_constraint_name = 'PER_OBJECTIVES_FK1') Then
21: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PER_OBJECTIVES_FK2') Then

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

18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: If (p_constraint_name = 'PER_OBJECTIVES_FK1') Then
21: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PER_OBJECTIVES_FK2') Then
26: hr_utility.set_message(801,'HR_52054_OBJ_APR_NOT_EXIST');

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

19: --
20: If (p_constraint_name = 'PER_OBJECTIVES_FK1') Then
21: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PER_OBJECTIVES_FK2') Then
26: hr_utility.set_message(801,'HR_52054_OBJ_APR_NOT_EXIST');
27: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 24: hr_utility.raise_error;

20: If (p_constraint_name = 'PER_OBJECTIVES_FK1') Then
21: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PER_OBJECTIVES_FK2') Then
26: hr_utility.set_message(801,'HR_52054_OBJ_APR_NOT_EXIST');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');

Line 26: hr_utility.set_message(801,'HR_52054_OBJ_APR_NOT_EXIST');

22: hr_utility.set_message_token('PROCEDURE', l_proc);
23: hr_utility.set_message_token('STEP','5');
24: hr_utility.raise_error;
25: ElsIf (p_constraint_name = 'PER_OBJECTIVES_FK2') Then
26: hr_utility.set_message(801,'HR_52054_OBJ_APR_NOT_EXIST');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_OBJECTIVES_PK') Then

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

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

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

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

Line 29: hr_utility.raise_error;

25: ElsIf (p_constraint_name = 'PER_OBJECTIVES_FK2') Then
26: hr_utility.set_message(801,'HR_52054_OBJ_APR_NOT_EXIST');
27: hr_utility.set_message_token('PROCEDURE', l_proc);
28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_OBJECTIVES_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');

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

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

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

28: hr_utility.set_message_token('STEP','10');
29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_OBJECTIVES_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

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

29: hr_utility.raise_error;
30: ElsIf (p_constraint_name = 'PER_OBJECTIVES_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
37: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 34: hr_utility.raise_error;

30: ElsIf (p_constraint_name = 'PER_OBJECTIVES_PK') Then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
39: hr_utility.raise_error;
40: End If;

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

33: hr_utility.set_message_token('STEP','15');
34: hr_utility.raise_error;
35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
39: hr_utility.raise_error;
40: End If;
41: --

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

34: hr_utility.raise_error;
35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
39: hr_utility.raise_error;
40: End If;
41: --
42: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 39: hr_utility.raise_error;

35: Else
36: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
37: hr_utility.set_message_token('PROCEDURE', l_proc);
38: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
39: hr_utility.raise_error;
40: End If;
41: --
42: hr_utility.set_location(' Leaving:'||l_proc, 10);
43: End constraint_error;

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

38: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
39: hr_utility.raise_error;
40: End If;
41: --
42: hr_utility.set_location(' Leaving:'||l_proc, 10);
43: End constraint_error;
44: --
45: -- ----------------------------------------------------------------------------
46: -- |-----------------------------< api_updating >-----------------------------|

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

129: l_proc varchar2(72) := g_package||'api_updating';
130: l_fct_ret boolean;
131: --
132: Begin
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: If (
136: p_objective_id is null and
137: p_object_version_number is null

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

145: If (
146: p_objective_id = g_old_rec.objective_id and
147: p_object_version_number = g_old_rec.object_version_number
148: ) Then
149: hr_utility.set_location(l_proc, 10);
150: --
151: -- The g_old_rec is current therefore we must
152: -- set the returning function to true
153: --

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

162: Close C_Sel1;
163: --
164: -- The primary key is invalid therefore we must error
165: --
166: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
167: hr_utility.raise_error;
168: else
169: Close C_Sel1;
170: End If;

Line 167: hr_utility.raise_error;

163: --
164: -- The primary key is invalid therefore we must error
165: --
166: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
167: hr_utility.raise_error;
168: else
169: Close C_Sel1;
170: End If;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then

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

168: else
169: Close C_Sel1;
170: End If;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then
172: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
173: hr_utility.raise_error;
174: End If;
175: hr_utility.set_location(l_proc, 15);
176: l_fct_ret := true;

Line 173: hr_utility.raise_error;

169: Close C_Sel1;
170: End If;
171: If (p_object_version_number <> g_old_rec.object_version_number) Then
172: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
173: hr_utility.raise_error;
174: End If;
175: hr_utility.set_location(l_proc, 15);
176: l_fct_ret := true;
177: End If;

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

171: If (p_object_version_number <> g_old_rec.object_version_number) Then
172: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
173: hr_utility.raise_error;
174: End If;
175: hr_utility.set_location(l_proc, 15);
176: l_fct_ret := true;
177: End If;
178: End If;
179: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

175: hr_utility.set_location(l_proc, 15);
176: l_fct_ret := true;
177: End If;
178: End If;
179: hr_utility.set_location(' Leaving:'||l_proc, 20);
180: Return (l_fct_ret);
181: --
182: End api_updating;
183: --

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

268: --
269: l_proc varchar2(72) := g_package||'lck';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Add any mandatory argument checking here:
275: -- Example:
276: -- hr_api.mandatory_arg_error

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

284: Close C_Sel1;
285: --
286: -- The primary key is invalid therefore we must error
287: --
288: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
289: hr_utility.raise_error;
290: else
291: Close C_Sel1;
292: End If;

Line 289: hr_utility.raise_error;

285: --
286: -- The primary key is invalid therefore we must error
287: --
288: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
289: hr_utility.raise_error;
290: else
291: Close C_Sel1;
292: End If;
293:

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

291: Close C_Sel1;
292: End If;
293:
294: If (p_object_version_number <> g_old_rec.object_version_number) Then
295: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
296: hr_utility.raise_error;
297: End If;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 296: hr_utility.raise_error;

292: End If;
293:
294: If (p_object_version_number <> g_old_rec.object_version_number) Then
295: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
296: hr_utility.raise_error;
297: End If;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: --

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

295: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
296: hr_utility.raise_error;
297: End If;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 10);
300: --
301: -- We need to trap the ORA LOCK exception
302: --
303: Exception

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

305: --
306: -- The object is locked therefore we need to supply a meaningful
307: -- error message.
308: --
309: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
310: hr_utility.set_message_token('TABLE_NAME', 'per_objectives');
311: hr_utility.raise_error;
312: End lck;
313: --

Line 310: hr_utility.set_message_token('TABLE_NAME', 'per_objectives');

306: -- The object is locked therefore we need to supply a meaningful
307: -- error message.
308: --
309: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
310: hr_utility.set_message_token('TABLE_NAME', 'per_objectives');
311: hr_utility.raise_error;
312: End lck;
313: --
314: -- ----------------------------------------------------------------------------

Line 311: hr_utility.raise_error;

307: -- error message.
308: --
309: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
310: hr_utility.set_message_token('TABLE_NAME', 'per_objectives');
311: hr_utility.raise_error;
312: End lck;
313: --
314: -- ----------------------------------------------------------------------------
315: -- |-----------------------------< convert_args >-----------------------------|

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

391: l_proc varchar2(72) := g_package||'convert_args';
392: --
393: Begin
394: --
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: --
397: -- Convert arguments into local l_rec structure.
398: --
399: l_rec.objective_id := p_objective_id;

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

466:
467: --
468: -- Return the plsql record structure.
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: Return(l_rec);
472: --
473: End convert_args;
474: --