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_PEA_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_PRTT_ENRT_ACTN_FK1') 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_PRTT_ENRT_ACTN_FK1') 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: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK2') Then

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_PRTT_ENRT_ACTN_FK1') 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: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK2') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

35: --
36: If (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK1') 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: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK2') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 40: hr_utility.raise_error;

36: If (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK1') 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: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK2') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');

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

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

39: hr_utility.set_message_token('STEP','5');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_FK2') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_PK') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

Line 45: hr_utility.raise_error;

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

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

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

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

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

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

45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_PK') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: Else
52: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
53: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 50: hr_utility.raise_error;

46: ElsIf (p_constraint_name = 'BEN_PRTT_ENRT_ACTN_PK') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: Else
52: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

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

48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: Else
52: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
55: hr_utility.raise_error;
56: End If;

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

49: hr_utility.set_message_token('STEP','15');
50: hr_utility.raise_error;
51: Else
52: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
55: hr_utility.raise_error;
56: End If;
57: --

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

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

Line 55: hr_utility.raise_error;

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

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

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

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

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

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

137: l_fct_ret := false;
138: Else
139: If (p_prtt_enrt_actn_id = g_old_rec.prtt_enrt_actn_id and
140: p_object_version_number = g_old_rec.object_version_number) Then
141: hr_utility.set_location(l_proc, 10);
142: --
143: -- The g_old_rec is current therefore we must
144: -- set the returning function to true
145: --

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

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

Line 159: hr_utility.raise_error;

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

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

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

Line 164: hr_utility.raise_error;

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

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

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

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

166: hr_utility.set_location(l_proc, 15);
167: l_fct_ret := true;
168: End If;
169: End If;
170: hr_utility.set_location(' Leaving:'||l_proc, 20);
171: Return (l_fct_ret);
172: --
173: End api_updating;
174: --

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

194: and p_effective_date
195: between t.effective_start_date and t.effective_end_date;
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: Open C_Sel1;
200: Fetch C_Sel1 Into l_parent_key_value1;
201: If C_Sel1%notfound then
202: Close C_Sel1;

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

199: Open C_Sel1;
200: Fetch C_Sel1 Into l_parent_key_value1;
201: If C_Sel1%notfound then
202: Close C_Sel1;
203: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('PROCEDURE', l_proc);
205: hr_utility.set_message_token('STEP','10');
206: hr_utility.raise_error;
207: End If;

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

200: Fetch C_Sel1 Into l_parent_key_value1;
201: If C_Sel1%notfound then
202: Close C_Sel1;
203: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('PROCEDURE', l_proc);
205: hr_utility.set_message_token('STEP','10');
206: hr_utility.raise_error;
207: End If;
208: Close C_Sel1;

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

201: If C_Sel1%notfound then
202: Close C_Sel1;
203: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('PROCEDURE', l_proc);
205: hr_utility.set_message_token('STEP','10');
206: hr_utility.raise_error;
207: End If;
208: Close C_Sel1;
209: --

Line 206: hr_utility.raise_error;

202: Close C_Sel1;
203: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
204: hr_utility.set_message_token('PROCEDURE', l_proc);
205: hr_utility.set_message_token('STEP','10');
206: hr_utility.raise_error;
207: End If;
208: Close C_Sel1;
209: --
210: -- Call the corresponding datetrack api

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

221: p_delete => p_delete,
222: p_future_change => p_future_change,
223: p_delete_next_change => p_delete_next_change);
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End find_dt_del_modes;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

238: --
239: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: -- Call the corresponding datetrack api
245: --
246: dt_api.find_dt_upd_modes

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

252: p_update => p_update,
253: p_update_override => p_update_override,
254: p_update_change_insert => p_update_change_insert);
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 10);
257: End find_dt_upd_modes;
258: --
259: -- ----------------------------------------------------------------------------
260: -- |------------------------< upd_effective_end_date >------------------------|

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

270: l_proc varchar2(72) := g_package||'upd_effective_end_date';
271: l_object_version_number number;
272: --
273: Begin
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Because we are updating a row we must get the next object
277: -- version number.
278: --

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

281: (p_base_table_name => 'ben_prtt_enrt_actn_f',
282: p_base_key_column => 'prtt_enrt_actn_id',
283: p_base_key_value => p_base_key_value);
284: --
285: hr_utility.set_location(l_proc, 10);
286: g_api_dml := true; -- Set the api dml status
287: --
288: -- Update the specified datetrack row setting the effective
289: -- end date to the specified new effective end date.

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

296: between t.effective_start_date and t.effective_end_date;
297: --
298: g_api_dml := false; -- Unset the api dml status
299: p_object_version_number := l_object_version_number;
300: hr_utility.set_location(' Leaving:'||l_proc, 15);
301: --
302: Exception
303: When Others Then
304: g_api_dml := false; -- Unset the api dml status

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

379: --
380: --
381: --
382: Begin
383: hr_utility.set_location('Entering:'||l_proc, 5);
384: --
385: -- Ensure that all the mandatory arguments are not null
386: --
387: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

412: Close C_Sel1;
413: --
414: -- The primary key is invalid therefore we must error
415: --
416: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
417: hr_utility.raise_error;
418: End If;
419: Close C_Sel1;
420: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 417: hr_utility.raise_error;

413: --
414: -- The primary key is invalid therefore we must error
415: --
416: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
417: hr_utility.raise_error;
418: End If;
419: Close C_Sel1;
420: If (p_object_version_number <> g_old_rec.object_version_number) Then
421: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

417: hr_utility.raise_error;
418: End If;
419: Close C_Sel1;
420: If (p_object_version_number <> g_old_rec.object_version_number) Then
421: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
422: hr_utility.raise_error;
423: End If;
424: hr_utility.set_location(l_proc, 15);
425: --

Line 422: hr_utility.raise_error;

418: End If;
419: Close C_Sel1;
420: If (p_object_version_number <> g_old_rec.object_version_number) Then
421: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
422: hr_utility.raise_error;
423: End If;
424: hr_utility.set_location(l_proc, 15);
425: --
426: --

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

420: If (p_object_version_number <> g_old_rec.object_version_number) Then
421: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
422: hr_utility.raise_error;
423: End If;
424: hr_utility.set_location(l_proc, 15);
425: --
426: --
427: -- Validate the datetrack mode mode getting the validation start
428: -- and end dates for the specified datetrack operation.

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

450: -- We are doing a datetrack 'INSERT' which is illegal within this
451: -- procedure therefore we must error (note: to lck on insert the
452: -- private procedure ins_lck should be called).
453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','20');
457: hr_utility.raise_error;
458: End If;

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

451: -- procedure therefore we must error (note: to lck on insert the
452: -- private procedure ins_lck should be called).
453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','20');
457: hr_utility.raise_error;
458: End If;
459: --

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

452: -- private procedure ins_lck should be called).
453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','20');
457: hr_utility.raise_error;
458: End If;
459: --
460: -- Set the validation start and end date OUT arguments

Line 457: hr_utility.raise_error;

453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','20');
457: hr_utility.raise_error;
458: End If;
459: --
460: -- Set the validation start and end date OUT arguments
461: --

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

461: --
462: p_validation_start_date := l_validation_start_date;
463: p_validation_end_date := l_validation_end_date;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 30);
466: --
467: -- We need to trap the ORA LOCK exception
468: --
469: Exception

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

471: --
472: -- The object is locked therefore we need to supply a meaningful
473: -- error message.
474: --
475: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
476: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');
477: hr_utility.raise_error;
478: When l_object_invalid then
479: --

Line 476: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');

472: -- The object is locked therefore we need to supply a meaningful
473: -- error message.
474: --
475: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
476: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');
477: hr_utility.raise_error;
478: When l_object_invalid then
479: --
480: -- The object doesn't exist or is invalid

Line 477: hr_utility.raise_error;

473: -- error message.
474: --
475: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
476: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');
477: hr_utility.raise_error;
478: When l_object_invalid then
479: --
480: -- The object doesn't exist or is invalid
481: --

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

478: When l_object_invalid then
479: --
480: -- The object doesn't exist or is invalid
481: --
482: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
483: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');
484: hr_utility.raise_error;
485: End lck;
486: --

Line 483: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');

479: --
480: -- The object doesn't exist or is invalid
481: --
482: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
483: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');
484: hr_utility.raise_error;
485: End lck;
486: --
487: -- ----------------------------------------------------------------------------

Line 484: hr_utility.raise_error;

480: -- The object doesn't exist or is invalid
481: --
482: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
483: hr_utility.set_message_token('TABLE_NAME', 'ben_prtt_enrt_actn_f');
484: hr_utility.raise_error;
485: End lck;
486: --
487: -- ----------------------------------------------------------------------------
488: -- |-----------------------------< convert_args >-----------------------------|

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

540: l_proc varchar2(72) := g_package||'convert_args';
541: --
542: Begin
543: --
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Convert arguments into local l_rec structure.
547: --
548: l_rec.prtt_enrt_actn_id := p_prtt_enrt_actn_id;

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

593: l_rec.object_version_number := p_object_version_number;
594: --
595: -- Return the plsql record structure.
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598: Return(l_rec);
599: --
600: End convert_args;
601: --