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

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

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

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

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

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

Line 157: hr_utility.raise_error;

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

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

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

Line 162: hr_utility.raise_error;

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

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

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

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

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

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: l_parent_key_value2;
202: If C_Sel1%notfound then

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

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

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

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

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

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

Line 207: hr_utility.raise_error;

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

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

225: p_delete => p_delete,
226: p_future_change => p_future_change,
227: p_delete_next_change => p_delete_next_change);
228: --
229: hr_utility.set_location(' Leaving:'||l_proc, 10);
230: End find_dt_del_modes;
231: --
232: -- ----------------------------------------------------------------------------
233: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

242: --
243: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: -- Call the corresponding datetrack api
249: --
250: dt_api.find_dt_upd_modes

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

256: p_update => p_update,
257: p_update_override => p_update_override,
258: p_update_change_insert => p_update_change_insert);
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End find_dt_upd_modes;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |------------------------< upd_effective_end_date >------------------------|

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

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

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

285: (p_base_table_name => 'ben_popl_org_f',
286: p_base_key_column => 'popl_org_id',
287: p_base_key_value => p_base_key_value);
288: --
289: hr_utility.set_location(l_proc, 10);
290: g_api_dml := true; -- Set the api dml status
291: --
292: -- Update the specified datetrack row setting the effective
293: -- end date to the specified new effective end date.

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

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

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

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

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

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

Line 419: hr_utility.raise_error;

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

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

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

Line 424: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 456: hr_utility.raise_error;

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

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

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

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

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

Line 475: hr_utility.set_message_token('TABLE_NAME', 'ben_popl_org_f');

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

Line 476: hr_utility.raise_error;

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

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

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

Line 482: hr_utility.set_message_token('TABLE_NAME', 'ben_popl_org_f');

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

Line 483: hr_utility.raise_error;

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

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

537: l_proc varchar2(72) := g_package||'convert_args';
538: --
539: Begin
540: --
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: -- Convert arguments into local l_rec structure.
544: --
545: l_rec.popl_org_id := p_popl_org_id;

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

586: l_rec.object_version_number := p_object_version_number;
587: --
588: -- Return the plsql record structure.
589: --
590: hr_utility.set_location(' Leaving:'||l_proc, 10);
591: Return(l_rec);
592: --
593: End convert_args;
594: --