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_OPT_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_OPT_F_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_OPT_F_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_OPT_F_PK') 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_OPT_F_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_OPT_F_PK') 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_OPT_F_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_OPT_F_PK') 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_OPT_F_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_OPT_F_PK') 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_OPT_F_PK') 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: Else

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_OPT_F_PK') 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: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

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

40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'BEN_OPT_F_PK') 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: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 45: hr_utility.raise_error;

41: ElsIf (p_constraint_name = 'BEN_OPT_F_PK') 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: Else
47: 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('CONSTRAINT_NAME', p_constraint_name);

Line 47: 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('STEP','10');
45: hr_utility.raise_error;
46: Else
47: 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('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;

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

44: hr_utility.set_message_token('STEP','10');
45: hr_utility.raise_error;
46: Else
47: 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('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --

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

45: hr_utility.raise_error;
46: Else
47: 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('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 50: hr_utility.raise_error;

46: Else
47: 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('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);
54: End constraint_error;

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

49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --
53: hr_utility.set_location(' Leaving:'||l_proc, 10);
54: End constraint_error;
55: --
56: -- ----------------------------------------------------------------------------
57: -- |-----------------------------< 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 (p_effective_date is null or
132: p_opt_id is null or
133: p_object_version_number is null) Then

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

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

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

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

Line 160: hr_utility.raise_error;

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

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

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

Line 165: hr_utility.raise_error;

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

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

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

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

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

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

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

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

200: Open C_Sel1;
201: Fetch C_Sel1 Into l_parent_key_value1;
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: Fetch C_Sel1 Into l_parent_key_value1;
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 226: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

386: --
387: --
388: --
389: Begin
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: -- Ensure that all the mandatory arguments are not null
393: --
394: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

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

Line 424: hr_utility.raise_error;

420: --
421: -- The primary key is invalid therefore we must error
422: --
423: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
424: hr_utility.raise_error;
425: End If;
426: Close C_Sel1;
427: If (p_object_version_number <> g_old_rec.object_version_number) Then
428: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

424: hr_utility.raise_error;
425: End If;
426: Close C_Sel1;
427: If (p_object_version_number <> g_old_rec.object_version_number) Then
428: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
429: hr_utility.raise_error;
430: End If;
431: hr_utility.set_location(l_proc, 15);
432: --

Line 429: hr_utility.raise_error;

425: End If;
426: Close C_Sel1;
427: If (p_object_version_number <> g_old_rec.object_version_number) Then
428: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
429: hr_utility.raise_error;
430: End If;
431: hr_utility.set_location(l_proc, 15);
432: --
433: --

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

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

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

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

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

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

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

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

Line 458: hr_utility.raise_error;

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

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

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

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

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

Line 477: hr_utility.set_message_token('TABLE_NAME', 'ben_opt_f');

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

Line 478: hr_utility.raise_error;

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

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

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

Line 484: hr_utility.set_message_token('TABLE_NAME', 'ben_opt_f');

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

Line 485: hr_utility.raise_error;

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

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

547: l_proc varchar2(72) := g_package||'convert_args';
548: --
549: Begin
550: --
551: hr_utility.set_location('Entering:'||l_proc, 5);
552: --
553: -- Convert arguments into local l_rec structure.
554: --
555: l_rec.opt_id := p_opt_id;

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

604: l_rec.mapping_table_pk_id := p_mapping_table_pk_id;
605: --
606: -- Return the plsql record structure.
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 10);
609: Return(l_rec);
610: --
611: End convert_args;
612: --