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_PPV_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 = 'PRTL_MO_RT_PRTN_VAL_F_PK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);

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

45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
49: hr_utility.set_location(' Leaving:'||l_proc, 10);
50: End constraint_error;
51: --
52: -- ----------------------------------------------------------------------------
53: -- |-----------------------------< api_updating >-----------------------------|

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

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

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

132: l_fct_ret := false;
133: Else
134: If (p_prtl_mo_rt_prtn_val_id = g_old_rec.prtl_mo_rt_prtn_val_id and
135: p_object_version_number = g_old_rec.object_version_number) Then
136: hr_utility.set_location(l_proc, 10);
137: --
138: -- The g_old_rec is current therefore we must
139: -- set the returning function to true
140: --

Line 153: hr_utility.set_message('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 154: hr_utility.raise_error;

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

Line 158: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');

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

Line 159: hr_utility.raise_error;

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

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

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

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

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

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

193: and p_effective_date
194: between t.effective_start_date and t.effective_end_date;
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: Open C_Sel1;
199: Fetch C_Sel1 Into l_parent_key_value1,
200: l_parent_key_value2,
201: l_parent_key_value3;

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

200: l_parent_key_value2,
201: l_parent_key_value3;
202: If C_Sel1%notfound then
203: Close C_Sel1;
204: hr_utility.set_message('PAY', '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_value3;
202: If C_Sel1%notfound then
203: Close C_Sel1;
204: hr_utility.set_message('PAY', '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('PAY', '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('PAY', '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 232: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 427: hr_utility.set_message('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

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

Line 428: hr_utility.raise_error;

424: --
425: -- The primary key is invalid therefore we must error
426: --
427: hr_utility.set_message('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
428: hr_utility.raise_error;
429: End If;
430: Close C_Sel1;
431: If (p_object_version_number <> g_old_rec.object_version_number) Then
432: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');

Line 432: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');

428: hr_utility.raise_error;
429: End If;
430: Close C_Sel1;
431: If (p_object_version_number <> g_old_rec.object_version_number) Then
432: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');
433: hr_utility.raise_error;
434: End If;
435: hr_utility.set_location(l_proc, 15);
436: --

Line 433: hr_utility.raise_error;

429: End If;
430: Close C_Sel1;
431: If (p_object_version_number <> g_old_rec.object_version_number) Then
432: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');
433: hr_utility.raise_error;
434: End If;
435: hr_utility.set_location(l_proc, 15);
436: --
437: --

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

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

Line 465: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

462: -- procedure therefore we must error (note: to lck on insert the
463: -- private procedure ins_lck should be called).
464: --
465: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
466: hr_utility.set_message_token('PROCEDURE', l_proc);
467: hr_utility.set_message_token('STEP','20');
468: hr_utility.raise_error;
469: End If;
470: --

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

463: -- private procedure ins_lck should be called).
464: --
465: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
466: hr_utility.set_message_token('PROCEDURE', l_proc);
467: hr_utility.set_message_token('STEP','20');
468: hr_utility.raise_error;
469: End If;
470: --
471: -- Set the validation start and end date OUT arguments

Line 468: hr_utility.raise_error;

464: --
465: hr_utility.set_message('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
466: hr_utility.set_message_token('PROCEDURE', l_proc);
467: hr_utility.set_message_token('STEP','20');
468: hr_utility.raise_error;
469: End If;
470: --
471: -- Set the validation start and end date OUT arguments
472: --

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

472: --
473: p_validation_start_date := l_validation_start_date;
474: p_validation_end_date := l_validation_end_date;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 30);
477: --
478: -- We need to trap the ORA LOCK exception
479: --
480: Exception

Line 486: hr_utility.set_message('PAY', 'HR_7165_OBJECT_LOCKED');

482: --
483: -- The object is locked therefore we need to supply a meaningful
484: -- error message.
485: --
486: hr_utility.set_message('PAY', 'HR_7165_OBJECT_LOCKED');
487: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
488: hr_utility.raise_error;
489: When l_object_invalid then
490: --

Line 487: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');

483: -- The object is locked therefore we need to supply a meaningful
484: -- error message.
485: --
486: hr_utility.set_message('PAY', 'HR_7165_OBJECT_LOCKED');
487: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
488: hr_utility.raise_error;
489: When l_object_invalid then
490: --
491: -- The object doesn't exist or is invalid

Line 488: hr_utility.raise_error;

484: -- error message.
485: --
486: hr_utility.set_message('PAY', 'HR_7165_OBJECT_LOCKED');
487: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
488: hr_utility.raise_error;
489: When l_object_invalid then
490: --
491: -- The object doesn't exist or is invalid
492: --

Line 493: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');

489: When l_object_invalid then
490: --
491: -- The object doesn't exist or is invalid
492: --
493: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');
494: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
495: hr_utility.raise_error;
496: End lck;
497: --

Line 494: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');

490: --
491: -- The object doesn't exist or is invalid
492: --
493: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');
494: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
495: hr_utility.raise_error;
496: End lck;
497: --
498: -- ----------------------------------------------------------------------------

Line 495: hr_utility.raise_error;

491: -- The object doesn't exist or is invalid
492: --
493: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');
494: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
495: hr_utility.raise_error;
496: End lck;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |-----------------------------< convert_args >-----------------------------|

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

555: l_proc varchar2(72) := g_package||'convert_args';
556: --
557: Begin
558: --
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Convert arguments into local l_rec structure.
562: --
563: l_rec.prtl_mo_rt_prtn_val_id := p_prtl_mo_rt_prtn_val_id;

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

610: l_rec.object_version_number := p_object_version_number;
611: --
612: -- Return the plsql record structure.
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: Return(l_rec);
616: --
617: End convert_args;
618: --