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

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

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

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

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

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

32: --
33: l_proc varchar2(72) := g_package||'constraint_error';
34: --
35: Begin
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: --
38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then
39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;

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

35: Begin
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: --
38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then
39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;

Line 40: hr_utility.raise_error;

36: hr_utility.set_location('Entering:'||l_proc, 5);
37: --
38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then
39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then

Line 42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');

38: If (p_constraint_name = 'PER_POSITIONS_FK1') Then
39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');
46: hr_utility.raise_error;

Line 43: hr_utility.raise_error;

39: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then

Line 45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');

41: ElsIf (p_constraint_name = 'PER_POSITIONS_FK2') Then
42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then
48: fnd_message.set_name('PER','PER_52979_POS_SUCC_NOT_EXIST');
49: fnd_message.raise_error;

Line 46: hr_utility.raise_error;

42: hr_utility.set_message(801, 'HR_51090_JOB_NOT_EXIST');
43: hr_utility.raise_error;
44: ElsIf (p_constraint_name = 'PER_POSITIONS_FK3') Then
45: hr_utility.set_message(801, 'HR_51371_POS_ORG_NOT_EXIST');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PER_POSITIONS_FK4') Then
48: fnd_message.set_name('PER','PER_52979_POS_SUCC_NOT_EXIST');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'PER_POSITIONS_FK5') Then

Line 54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');

50: ElsIf (p_constraint_name = 'PER_POSITIONS_FK5') Then
51: fnd_message.set_name('PER','PER_52980_POS_RELF_NOT_EXIST');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then
54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;

Line 55: hr_utility.raise_error;

51: fnd_message.set_name('PER','PER_52980_POS_RELF_NOT_EXIST');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then
54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then

Line 57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');

53: ElsIf (p_constraint_name = 'PER_POSITIONS_FK6') Then
54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;

Line 58: hr_utility.raise_error;

54: hr_utility.set_message(801, 'HR_51357_POS_LOC_NOT_EXIST');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then

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

56: ElsIf (p_constraint_name = 'PER_POSITIONS_FK7') Then
57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;

Line 61: hr_utility.raise_error;

57: hr_utility.set_message(801, 'HR_51369_POS_DEF_NOT_EXIST');
58: hr_utility.raise_error;
59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then

Line 63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');

59: ElsIf (p_constraint_name = 'PER_POSITIONS_PK') Then
60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then
66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');
67: hr_utility.raise_error;

Line 64: hr_utility.raise_error;

60: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
61: hr_utility.raise_error;
62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then
66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');
67: hr_utility.raise_error;
68: Else

Line 66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');

62: ElsIf (p_constraint_name = 'PER_POSITIONS_UK2') Then
63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then
66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');
67: hr_utility.raise_error;
68: Else
69: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
70: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 67: hr_utility.raise_error;

63: hr_utility.set_message(801, 'PER_7415_POS_EXISTS');
64: hr_utility.raise_error;
65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then
66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');
67: hr_utility.raise_error;
68: Else
69: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

65: ElsIf (p_constraint_name = 'PER_POST_REPLACEMENT_REQUI_CHK') Then
66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');
67: hr_utility.raise_error;
68: Else
69: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
72: hr_utility.raise_error;
73: End If;

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

66: hr_utility.set_message(801, 'HR_51370_POS_REPL_REQ_FLAG');
67: hr_utility.raise_error;
68: Else
69: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
72: hr_utility.raise_error;
73: End If;
74: --

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

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

Line 72: hr_utility.raise_error;

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

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

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

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

141: l_proc varchar2(72) := g_package||'api_updating';
142: l_fct_ret boolean;
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: If (
148: p_position_id is null and
149: p_object_version_number is null

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

157: If (
158: p_position_id = g_old_rec.position_id and
159: p_object_version_number = g_old_rec.object_version_number
160: ) Then
161: hr_utility.set_location(l_proc, 10);
162: --
163: -- The g_old_rec is current therefore we must
164: -- set the returning function to true
165: --

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

174: Close C_Sel1;
175: --
176: -- The primary key is invalid therefore we must error
177: --
178: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
179: hr_utility.raise_error;
180: End If;
181: Close C_Sel1;
182: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 179: hr_utility.raise_error;

175: --
176: -- The primary key is invalid therefore we must error
177: --
178: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
179: hr_utility.raise_error;
180: End If;
181: Close C_Sel1;
182: If (p_object_version_number <> g_old_rec.object_version_number) Then
183: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

179: hr_utility.raise_error;
180: End If;
181: Close C_Sel1;
182: If (p_object_version_number <> g_old_rec.object_version_number) Then
183: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
184: hr_utility.raise_error;
185: End If;
186: hr_utility.set_location(l_proc, 15);
187: l_fct_ret := true;

Line 184: hr_utility.raise_error;

180: End If;
181: Close C_Sel1;
182: If (p_object_version_number <> g_old_rec.object_version_number) Then
183: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
184: hr_utility.raise_error;
185: End If;
186: hr_utility.set_location(l_proc, 15);
187: l_fct_ret := true;
188: End If;

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

182: If (p_object_version_number <> g_old_rec.object_version_number) Then
183: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
184: hr_utility.raise_error;
185: End If;
186: hr_utility.set_location(l_proc, 15);
187: l_fct_ret := true;
188: End If;
189: End If;
190: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

186: hr_utility.set_location(l_proc, 15);
187: l_fct_ret := true;
188: End If;
189: End If;
190: hr_utility.set_location(' Leaving:'||l_proc, 20);
191: Return (l_fct_ret);
192: --
193: End api_updating;
194: --

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

256: --
257: l_proc varchar2(72) := g_package||'lck';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- Add any mandatory argument checking here:
263: --
264: hr_api.mandatory_arg_error

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

277: Close C_Sel1;
278: --
279: -- The primary key is invalid therefore we must error
280: --
281: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
282: hr_utility.raise_error;
283: End If;
284: Close C_Sel1;
285: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 282: hr_utility.raise_error;

278: --
279: -- The primary key is invalid therefore we must error
280: --
281: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
282: hr_utility.raise_error;
283: End If;
284: Close C_Sel1;
285: If (p_object_version_number <> g_old_rec.object_version_number) Then
286: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

282: hr_utility.raise_error;
283: End If;
284: Close C_Sel1;
285: If (p_object_version_number <> g_old_rec.object_version_number) Then
286: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
287: hr_utility.raise_error;
288: End If;
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 287: hr_utility.raise_error;

283: End If;
284: Close C_Sel1;
285: If (p_object_version_number <> g_old_rec.object_version_number) Then
286: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
287: hr_utility.raise_error;
288: End If;
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: --

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

286: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
287: hr_utility.raise_error;
288: End If;
289: --
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: --
292: -- We need to trap the ORA LOCK exception
293: --
294: Exception

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

296: --
297: -- The object is locked therefore we need to supply a meaningful
298: -- error message.
299: --
300: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
301: hr_utility.set_message_token('TABLE_NAME', 'per_all_positions');
302: hr_utility.raise_error;
303: End lck;
304: --

Line 301: hr_utility.set_message_token('TABLE_NAME', 'per_all_positions');

297: -- The object is locked therefore we need to supply a meaningful
298: -- error message.
299: --
300: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
301: hr_utility.set_message_token('TABLE_NAME', 'per_all_positions');
302: hr_utility.raise_error;
303: End lck;
304: --
305: -- ----------------------------------------------------------------------------

Line 302: hr_utility.raise_error;

298: -- error message.
299: --
300: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
301: hr_utility.set_message_token('TABLE_NAME', 'per_all_positions');
302: hr_utility.raise_error;
303: End lck;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |-----------------------------< convert_args >-----------------------------|

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

360: l_proc varchar2(72) := g_package||'convert_args';
361: --
362: Begin
363: --
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: -- Convert arguments into local l_rec structure.
367: --
368: l_rec.position_id := p_position_id;

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

413: l_rec.object_version_number := p_object_version_number;
414: --
415: -- Return the plsql record structure.
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 10);
418: Return(l_rec);
419: --
420: End convert_args;
421: --