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

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

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

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

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

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

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

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

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

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

35: hr_utility.set_location('Entering:'||l_proc, 5);
36: --
37: If (p_constraint_name = 'BEN_dpnt_eligy_criteria_FK1') 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','5');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'BEN_dpnt_eligy_criteria_PK') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

Line 41: hr_utility.raise_error;

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

Line 43: 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 = 'BEN_dpnt_eligy_criteria_PK') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;
47:

Line 44: 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 = 'BEN_dpnt_eligy_criteria_PK') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;
47:
48: Else

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

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'BEN_dpnt_eligy_criteria_PK') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;
47:
48: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 46: hr_utility.raise_error;

42: ElsIf (p_constraint_name = 'BEN_dpnt_eligy_criteria_PK') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;
47:
48: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
50: hr_utility.set_message_token('PROCEDURE', l_proc);

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

45: hr_utility.set_message_token('STEP','10');
46: hr_utility.raise_error;
47:
48: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
50: hr_utility.set_message_token('PROCEDURE', l_proc);
51: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
52: hr_utility.raise_error;
53: End If;

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

46: hr_utility.raise_error;
47:
48: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
50: hr_utility.set_message_token('PROCEDURE', l_proc);
51: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
52: hr_utility.raise_error;
53: End If;
54: --

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

47:
48: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
50: hr_utility.set_message_token('PROCEDURE', l_proc);
51: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
52: hr_utility.raise_error;
53: End If;
54: --
55: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 52: hr_utility.raise_error;

48: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
50: hr_utility.set_message_token('PROCEDURE', l_proc);
51: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
52: hr_utility.raise_error;
53: End If;
54: --
55: hr_utility.set_location(' Leaving:'||l_proc, 10);
56: End constraint_error;

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

51: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
52: hr_utility.raise_error;
53: End If;
54: --
55: hr_utility.set_location(' Leaving:'||l_proc, 10);
56: End constraint_error;
57: --
58: -- ----------------------------------------------------------------------------
59: -- |-----------------------------< api_updating >-----------------------------|

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

134: l_proc varchar2(72) := g_package||'api_updating';
135: l_fct_ret boolean;
136: --
137: Begin
138: hr_utility.set_location('Entering:'||l_proc, 5);
139: --
140: If (
141: p_eligy_criteria_dpnt_id is null and
142: p_object_version_number is null

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

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

Line 172: hr_utility.raise_error;

168: --
169: -- The primary key is invalid therefore we must error
170: --
171: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
172: hr_utility.raise_error;
173: End If;
174: Close C_Sel1;
175: If (p_object_version_number <> g_old_rec.object_version_number) Then
176: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

172: hr_utility.raise_error;
173: End If;
174: Close C_Sel1;
175: If (p_object_version_number <> g_old_rec.object_version_number) Then
176: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
177: hr_utility.raise_error;
178: End If;
179:
180: l_fct_ret := true;

Line 177: hr_utility.raise_error;

173: End If;
174: Close C_Sel1;
175: If (p_object_version_number <> g_old_rec.object_version_number) Then
176: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
177: hr_utility.raise_error;
178: End If;
179:
180: l_fct_ret := true;
181: End If;

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

179:
180: l_fct_ret := true;
181: End If;
182: End If;
183: hr_utility.set_location(' Leaving:'||l_proc, 20);
184: Return (l_fct_ret);
185: --
186: End api_updating;
187: --

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

263: --
264: l_proc varchar2(72) := g_package||'lck';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269:
270: -- Add any mandatory argument checking here:
271: -- Example:

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

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

Line 287: hr_utility.raise_error;

283: -- The primary key is invalid therefore we must error
284: --
285:
286: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
287: hr_utility.raise_error;
288: End If;
289: Close C_Sel1;
290:
291: If (p_object_version_number <> g_old_rec.object_version_number) Then

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

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

Line 293: hr_utility.raise_error;

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

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

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

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

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

Line 307: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_criteria_dpnt');

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

Line 308: hr_utility.raise_error;

304: -- error message.
305: --
306: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
307: hr_utility.set_message_token('TABLE_NAME', 'ben_eligy_criteria_dpnt');
308: hr_utility.raise_error;
309: End lck;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |-----------------------------< convert_args >-----------------------------|

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

379: l_proc varchar2(72) := g_package||'convert_args';
380: --
381: Begin
382: --
383: hr_utility.set_location('Entering:'||l_proc, 5);
384: --
385: -- Convert arguments into local l_rec structure.
386: --
387: l_rec.eligy_criteria_dpnt_id := p_eligy_criteria_dpnt_id;

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

446:
447: --
448: -- Return the plsql record structure.
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: Return(l_rec);
452: --
453: End convert_args;
454: --