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_EDC_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_DPNT_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK3') Then

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

35: --
36: If (p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK3') Then
39: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','5');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then

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

36: If (p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK1'
37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK3') Then
39: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','5');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

37: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK2'
38: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK3') Then
39: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','5');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
44: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 42: hr_utility.raise_error;

38: OR p_constraint_name = 'BEN_DPNT_ELIGY_CRIT_VALUES_F_FK3') Then
39: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','5');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
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');

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

40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP','5');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
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: Else

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

41: hr_utility.set_message_token('STEP','5');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
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: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

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

42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
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: Else
49: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
50: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 47: hr_utility.raise_error;

43: ElsIf (p_constraint_name = 'ben_dpnt_eligy_crit_values_f_PK') Then
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: 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);

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

45: hr_utility.set_message_token('PROCEDURE', l_proc);
46: hr_utility.set_message_token('STEP','10');
47: 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;

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

46: hr_utility.set_message_token('STEP','10');
47: 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: --

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

47: 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);

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 134: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

143: l_fct_ret := false;
144: Else
145: If (p_dpnt_eligy_crit_values_id = g_old_rec.dpnt_eligy_crit_values_id and
146: p_object_version_number = g_old_rec.object_version_number) Then
147: hr_utility.set_location(l_proc, 10);
148: --
149: -- The g_old_rec is current therefore we must
150: -- set the returning function to true
151: --

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

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

Line 165: hr_utility.raise_error;

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

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

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

Line 170: hr_utility.raise_error;

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

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

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

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

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

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

201: and p_effective_date
202: between t.effective_start_date and t.effective_end_date;
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: Open C_Sel1;
207: Fetch C_Sel1 Into l_parent_key_value1,l_parent_key_value2;
208: If C_Sel1%notfound then
209: Close C_Sel1;

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

206: Open C_Sel1;
207: Fetch C_Sel1 Into l_parent_key_value1,l_parent_key_value2;
208: If C_Sel1%notfound then
209: Close C_Sel1;
210: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
211: hr_utility.set_message_token('PROCEDURE', l_proc);
212: hr_utility.set_message_token('STEP','10');
213: hr_utility.raise_error;
214: End If;

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

207: Fetch C_Sel1 Into l_parent_key_value1,l_parent_key_value2;
208: If C_Sel1%notfound then
209: Close C_Sel1;
210: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
211: hr_utility.set_message_token('PROCEDURE', l_proc);
212: hr_utility.set_message_token('STEP','10');
213: hr_utility.raise_error;
214: End If;
215: Close C_Sel1;

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

208: If C_Sel1%notfound then
209: Close C_Sel1;
210: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
211: hr_utility.set_message_token('PROCEDURE', l_proc);
212: hr_utility.set_message_token('STEP','10');
213: hr_utility.raise_error;
214: End If;
215: Close C_Sel1;
216: --

Line 213: hr_utility.raise_error;

209: Close C_Sel1;
210: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
211: hr_utility.set_message_token('PROCEDURE', l_proc);
212: hr_utility.set_message_token('STEP','10');
213: hr_utility.raise_error;
214: End If;
215: Close C_Sel1;
216: --
217: -- Call the corresponding datetrack api

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

231: p_delete => p_delete,
232: p_future_change => p_future_change,
233: p_delete_next_change => p_delete_next_change);
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End find_dt_del_modes;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

248: --
249: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call the corresponding datetrack api
255: --
256: dt_api.find_dt_upd_modes

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

262: p_update => p_update,
263: p_update_override => p_update_override,
264: p_update_change_insert => p_update_change_insert);
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End find_dt_upd_modes;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |------------------------< upd_effective_end_date >------------------------|

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

280: l_proc varchar2(72) := g_package||'upd_effective_end_date';
281: l_object_version_number number;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- Because we are updating a row we must get the next object
287: -- version number.
288: --

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

291: (p_base_table_name => 'ben_dpnt_eligy_crit_values_f',
292: p_base_key_column => 'dpnt_eligy_crit_values_id',
293: p_base_key_value => p_base_key_value);
294: --
295: hr_utility.set_location(l_proc, 10);
296: g_api_dml := true; -- Set the api dml status
297: --
298: -- Update the specified datetrack row setting the effective
299: -- end date to the specified new effective end date.

Line 310: hr_utility.set_location(' Leaving:'||l_proc, 15);

306: between t.effective_start_date and t.effective_end_date;
307: --
308: g_api_dml := false; -- Unset the api dml status
309: p_object_version_number := l_object_version_number;
310: hr_utility.set_location(' Leaving:'||l_proc, 15);
311: --
312: Exception
313: When Others Then
314: g_api_dml := false; -- Unset the api dml status

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

398: --
399: --
400: --
401: Begin
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Ensure that all the mandatory arguments are not null
405: --
406: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

431: Close C_Sel1;
432: --
433: -- The primary key is invalid therefore we must error
434: --
435: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
436: hr_utility.raise_error;
437: End If;
438: Close C_Sel1;
439: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 436: hr_utility.raise_error;

432: --
433: -- The primary key is invalid therefore we must error
434: --
435: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
436: hr_utility.raise_error;
437: End If;
438: Close C_Sel1;
439: If (p_object_version_number <> g_old_rec.object_version_number) Then
440: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

436: hr_utility.raise_error;
437: End If;
438: Close C_Sel1;
439: If (p_object_version_number <> g_old_rec.object_version_number) Then
440: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
441: hr_utility.raise_error;
442: End If;
443: hr_utility.set_location(l_proc, 15);
444: --

Line 441: hr_utility.raise_error;

437: End If;
438: Close C_Sel1;
439: If (p_object_version_number <> g_old_rec.object_version_number) Then
440: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
441: hr_utility.raise_error;
442: End If;
443: hr_utility.set_location(l_proc, 15);
444: --
445: --

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

439: If (p_object_version_number <> g_old_rec.object_version_number) Then
440: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
441: hr_utility.raise_error;
442: End If;
443: hr_utility.set_location(l_proc, 15);
444: --
445: --
446: -- Validate the datetrack mode mode getting the validation start
447: -- and end dates for the specified datetrack operation.

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

466: -- We are doing a datetrack 'INSERT' which is illegal within this
467: -- procedure therefore we must error (note: to lck on insert the
468: -- private procedure ins_lck should be called).
469: --
470: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
471: hr_utility.set_message_token('PROCEDURE', l_proc);
472: hr_utility.set_message_token('STEP','20');
473: hr_utility.raise_error;
474: End If;

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

467: -- procedure therefore we must error (note: to lck on insert the
468: -- private procedure ins_lck should be called).
469: --
470: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
471: hr_utility.set_message_token('PROCEDURE', l_proc);
472: hr_utility.set_message_token('STEP','20');
473: hr_utility.raise_error;
474: End If;
475: --

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

468: -- private procedure ins_lck should be called).
469: --
470: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
471: hr_utility.set_message_token('PROCEDURE', l_proc);
472: hr_utility.set_message_token('STEP','20');
473: hr_utility.raise_error;
474: End If;
475: --
476: -- Set the validation start and end date OUT arguments

Line 473: hr_utility.raise_error;

469: --
470: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
471: hr_utility.set_message_token('PROCEDURE', l_proc);
472: hr_utility.set_message_token('STEP','20');
473: hr_utility.raise_error;
474: End If;
475: --
476: -- Set the validation start and end date OUT arguments
477: --

Line 481: hr_utility.set_location(' Leaving:'||l_proc, 30);

477: --
478: p_validation_start_date := l_validation_start_date;
479: p_validation_end_date := l_validation_end_date;
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 30);
482: --
483: -- We need to trap the ORA LOCK exception
484: --
485: Exception

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

487: --
488: -- The object is locked therefore we need to supply a meaningful
489: -- error message.
490: --
491: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
492: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
493: hr_utility.raise_error;
494: When l_object_invalid then
495: --

Line 492: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');

488: -- The object is locked therefore we need to supply a meaningful
489: -- error message.
490: --
491: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
492: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
493: hr_utility.raise_error;
494: When l_object_invalid then
495: --
496: -- The object doesn't exist or is invalid

Line 493: hr_utility.raise_error;

489: -- error message.
490: --
491: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
492: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
493: hr_utility.raise_error;
494: When l_object_invalid then
495: --
496: -- The object doesn't exist or is invalid
497: --

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

494: When l_object_invalid then
495: --
496: -- The object doesn't exist or is invalid
497: --
498: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
499: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
500: hr_utility.raise_error;
501: End lck;
502: --

Line 499: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');

495: --
496: -- The object doesn't exist or is invalid
497: --
498: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
499: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
500: hr_utility.raise_error;
501: End lck;
502: --
503: -- ----------------------------------------------------------------------------

Line 500: hr_utility.raise_error;

496: -- The object doesn't exist or is invalid
497: --
498: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
499: hr_utility.set_message_token('TABLE_NAME', 'ben_dpnt_eligy_crit_values_f');
500: hr_utility.raise_error;
501: End lck;
502: --
503: -- ----------------------------------------------------------------------------
504: -- |-----------------------------< convert_args >-----------------------------|

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

564: l_proc varchar2(72) := g_package||'convert_args';
565: --
566: Begin
567: --
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Convert arguments into local l_rec structure.
571: --
572: l_rec.dpnt_eligy_crit_values_id := p_dpnt_eligy_crit_values_id;

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

623: l_rec.date_value4 := p_date_value4;
624: --
625: -- Return the plsql record structure.
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 10);
628: Return(l_rec);
629: --
630: End convert_args;
631: --