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.BEN_PIL_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 = 'BEN_PER_IN_LER_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);

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

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PER_IN_LER_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else

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

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_PER_IN_LER_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

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

35: --
36: If (p_constraint_name = 'BEN_PER_IN_LER_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 40: hr_utility.raise_error;

36: If (p_constraint_name = 'BEN_PER_IN_LER_PK') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;

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

39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --

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

40: hr_utility.raise_error;
41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 45: hr_utility.raise_error;

41: Else
42: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: End constraint_error;

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

44: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
45: hr_utility.raise_error;
46: End If;
47: --
48: hr_utility.set_location(' Leaving:'||l_proc, 10);
49: End constraint_error;
50: --
51: -- ----------------------------------------------------------------------------
52: -- |-----------------------------< api_updating >-----------------------------|

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

125: l_proc varchar2(72) := g_package||'api_updating';
126: l_fct_ret boolean;
127: --
128: Begin
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: --
131: If (
132: p_per_in_ler_id is null and
133: p_object_version_number is null

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

141: If (
142: p_per_in_ler_id = g_old_rec.per_in_ler_id and
143: p_object_version_number = g_old_rec.object_version_number
144: ) Then
145: hr_utility.set_location(l_proc, 10);
146: --
147: -- The g_old_rec is current therefore we must
148: -- set the returning function to true
149: --

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

158: Close C_Sel1;
159: --
160: -- The primary key is invalid therefore we must error
161: --
162: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
163: hr_utility.raise_error;
164: End If;
165: Close C_Sel1;
166: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 163: hr_utility.raise_error;

159: --
160: -- The primary key is invalid therefore we must error
161: --
162: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
163: hr_utility.raise_error;
164: End If;
165: Close C_Sel1;
166: If (p_object_version_number <> g_old_rec.object_version_number) Then
167: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

163: hr_utility.raise_error;
164: End If;
165: Close C_Sel1;
166: If (p_object_version_number <> g_old_rec.object_version_number) Then
167: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
168: hr_utility.raise_error;
169: End If;
170: hr_utility.set_location(l_proc, 15);
171: l_fct_ret := true;

Line 168: hr_utility.raise_error;

164: End If;
165: Close C_Sel1;
166: If (p_object_version_number <> g_old_rec.object_version_number) Then
167: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
168: hr_utility.raise_error;
169: End If;
170: hr_utility.set_location(l_proc, 15);
171: l_fct_ret := true;
172: End If;

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

166: If (p_object_version_number <> g_old_rec.object_version_number) Then
167: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
168: hr_utility.raise_error;
169: End If;
170: hr_utility.set_location(l_proc, 15);
171: l_fct_ret := true;
172: End If;
173: End If;
174: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

170: hr_utility.set_location(l_proc, 15);
171: l_fct_ret := true;
172: End If;
173: End If;
174: hr_utility.set_location(' Leaving:'||l_proc, 20);
175: Return (l_fct_ret);
176: --
177: End api_updating;
178: --

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

251: --
252: l_proc varchar2(72) := g_package||'lck';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: -- Add any mandatory argument checking here:
258: -- Example:
259: -- hr_api.mandatory_arg_error

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

267: Close C_Sel1;
268: --
269: -- The primary key is invalid therefore we must error
270: --
271: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
272: hr_utility.raise_error;
273: End If;
274: Close C_Sel1;
275: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 272: hr_utility.raise_error;

268: --
269: -- The primary key is invalid therefore we must error
270: --
271: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
272: hr_utility.raise_error;
273: End If;
274: Close C_Sel1;
275: If (p_object_version_number <> g_old_rec.object_version_number) Then
276: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

272: hr_utility.raise_error;
273: End If;
274: Close C_Sel1;
275: If (p_object_version_number <> g_old_rec.object_version_number) Then
276: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
277: hr_utility.raise_error;
278: End If;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 277: hr_utility.raise_error;

273: End If;
274: Close C_Sel1;
275: If (p_object_version_number <> g_old_rec.object_version_number) Then
276: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
277: hr_utility.raise_error;
278: End If;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: --

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

276: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
277: hr_utility.raise_error;
278: End If;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: --
282: -- We need to trap the ORA LOCK exception
283: --
284: Exception

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

286: --
287: -- The object is locked therefore we need to supply a meaningful
288: -- error message.
289: --
290: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
291: hr_utility.set_message_token('TABLE_NAME', 'ben_per_in_ler');
292: hr_utility.raise_error;
293: End lck;
294: --

Line 291: hr_utility.set_message_token('TABLE_NAME', 'ben_per_in_ler');

287: -- The object is locked therefore we need to supply a meaningful
288: -- error message.
289: --
290: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
291: hr_utility.set_message_token('TABLE_NAME', 'ben_per_in_ler');
292: hr_utility.raise_error;
293: End lck;
294: --
295: -- ----------------------------------------------------------------------------

Line 292: hr_utility.raise_error;

288: -- error message.
289: --
290: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
291: hr_utility.set_message_token('TABLE_NAME', 'ben_per_in_ler');
292: hr_utility.raise_error;
293: End lck;
294: --
295: -- ----------------------------------------------------------------------------
296: -- |-----------------------------< convert_args >-----------------------------|

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

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

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

425: l_rec.object_version_number := p_object_version_number;
426: --
427: -- Return the plsql record structure.
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 10);
430: Return(l_rec);
431: --
432: End convert_args;
433: --