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_PEN_SHD dependencies on HR_UTILITY

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

12: -- ----------------------------------------------------------------------------
13: Function return_api_dml_status Return Boolean Is
14: l_proc varchar2(72) := g_package||'return_api_dml_status';
15: Begin
16: hr_utility.set_location('Entering:'||l_proc, 5);
17: Return (nvl(g_api_dml, false));
18: hr_utility.set_location(' Leaving:'||l_proc, 10);
19: End return_api_dml_status;
20: --

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

14: l_proc varchar2(72) := g_package||'return_api_dml_status';
15: Begin
16: hr_utility.set_location('Entering:'||l_proc, 5);
17: Return (nvl(g_api_dml, false));
18: hr_utility.set_location(' Leaving:'||l_proc, 10);
19: End return_api_dml_status;
20: --
21: -- ----------------------------------------------------------------------------
22: -- |---------------------------< constraint_error >---------------------------|

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

24: Procedure constraint_error
25: (p_constraint_name in all_constraints.constraint_name%TYPE) Is
26: l_proc varchar2(72) := g_package||'constraint_error';
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 5);
29: If (p_constraint_name = 'BEN_PRTT_ENRT_RSLT_PK') Then
30: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.set_token('PROCEDURE', l_proc);
32: fnd_message.set_token('STEP','5');

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

41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: hr_utility.set_location(' Leaving:'||l_proc, 10);
46: End constraint_error;
47: --
48: -- ----------------------------------------------------------------------------
49: -- |-----------------------------< api_updating >-----------------------------|

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

136: effective_start_date and effective_end_date;
137: l_proc varchar2(72) := g_package||'api_updating';
138: l_fct_ret boolean;
139: Begin
140: hr_utility.set_location('Entering:'||l_proc, 5);
141: If (p_effective_date is null or
142: p_prtt_enrt_rslt_id is null or
143: p_object_version_number is null) Then
144: --

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

148: l_fct_ret := false;
149: Else
150: If (p_prtt_enrt_rslt_id = g_old_rec.prtt_enrt_rslt_id
151: and p_object_version_number = g_old_rec.object_version_number) Then
152: hr_utility.set_location(l_proc, 10);
153: --
154: -- The g_old_rec is current therefore we must
155: -- set the returning function to true
156: --

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

173: If (p_object_version_number <> g_old_rec.object_version_number) Then
174: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
175: fnd_message.raise_error;
176: End If;
177: hr_utility.set_location(l_proc, 15);
178: l_fct_ret := true;
179: End If;
180: End If;
181: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

177: hr_utility.set_location(l_proc, 15);
178: l_fct_ret := true;
179: End If;
180: End If;
181: hr_utility.set_location(' Leaving:'||l_proc, 20);
182: Return (l_fct_ret);
183: End api_updating;
184: --
185: -- ----------------------------------------------------------------------------

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

214: and p_effective_date between
215: t.effective_start_date and t.effective_end_date;
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: Open C_Sel1;
220: Fetch C_Sel1 Into l_parent_key_value1
221: ,l_parent_key_value2
222: ,l_parent_key_value3

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

265: ,p_delete => p_delete
266: ,p_future_change => p_future_change
267: ,p_delete_next_change => p_delete_next_change
268: );
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: End find_dt_del_modes;
271: --
272: -- ----------------------------------------------------------------------------
273: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

282: ,p_update_change_insert out nocopy boolean
283: ) is
284: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: -- Call the corresponding datetrack api
289: --
290: dt_api.find_dt_upd_modes

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

296: ,p_update => p_update
297: ,p_update_override => p_update_override
298: ,p_update_change_insert => p_update_change_insert
299: );
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: End find_dt_upd_modes;
302: --
303: -- ----------------------------------------------------------------------------
304: -- |------------------------< upd_effective_end_date >------------------------|

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

313: ,p_object_version_number out nocopy number) is
314: l_proc varchar2(72) := g_package||'upd_effective_end_date';
315: l_object_version_number number;
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- Because we are updating a row we must get the next object
320: -- version number.
321: --

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

324: (p_base_table_name => 'ben_prtt_enrt_rslt_f'
325: ,p_base_key_column => 'prtt_enrt_rslt_id'
326: ,p_base_key_value => p_base_key_value
327: );
328: hr_utility.set_location(l_proc, 10);
329: g_api_dml := true; -- Set the api dml status
330: --
331: -- Update the specified datetrack row setting the effective
332: -- end date to the specified new effective end date.

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

338: and p_effective_date between
339: t.effective_start_date and t.effective_end_date;
340: g_api_dml := false; -- Unset the api dml status
341: p_object_version_number := l_object_version_number;
342: hr_utility.set_location(' Leaving:'||l_proc, 15);
343: Exception
344: When Others Then
345: g_api_dml := false; -- Unset the api dml status
346: Raise;

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

363: ,p_object_version_number out nocopy number) is
364: l_proc varchar2(72) := g_package||'upd_effective_end_date';
365: l_object_version_number number;
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- Because we are updating a row we must get the next object
370: -- version number.
371: --

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

374: (p_base_table_name => 'ben_prtt_enrt_rslt_f'
375: ,p_base_key_column => 'prtt_enrt_rslt_id'
376: ,p_base_key_value => p_base_key_value
377: );
378: hr_utility.set_location(l_proc, 10);
379: g_api_dml := true; -- Set the api dml status
380: --
381: -- Update the specified datetrack row setting the effective
382: -- end date to the specified new effective end date.

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

389: and p_effective_date between
390: t.effective_start_date and t.effective_end_date;
391: g_api_dml := false; -- Unset the api dml status
392: p_object_version_number := l_object_version_number;
393: hr_utility.set_location(' Leaving:'||l_proc, 15);
394: Exception
395: When Others Then
396: g_api_dml := false; -- Unset the api dml status
397: Raise;

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

498: and p_effective_date between
499: effective_start_date and effective_end_date
500: for update nowait;
501: Begin
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);
504: hr_utility.set_location('OVN:'||p_object_version_number, 5);
505: hr_utility.set_location('EFD:'||p_effective_date, 5);
506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);

Line 503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);

499: effective_start_date and effective_end_date
500: for update nowait;
501: Begin
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);
504: hr_utility.set_location('OVN:'||p_object_version_number, 5);
505: hr_utility.set_location('EFD:'||p_effective_date, 5);
506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);
507: hr_utility.set_location('Entering:'||l_proc, 5);

Line 504: hr_utility.set_location('OVN:'||p_object_version_number, 5);

500: for update nowait;
501: Begin
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);
504: hr_utility.set_location('OVN:'||p_object_version_number, 5);
505: hr_utility.set_location('EFD:'||p_effective_date, 5);
506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --

Line 505: hr_utility.set_location('EFD:'||p_effective_date, 5);

501: Begin
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);
504: hr_utility.set_location('OVN:'||p_object_version_number, 5);
505: hr_utility.set_location('EFD:'||p_effective_date, 5);
506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Ensure that all the mandatory arguments are not null

Line 506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);

502: hr_utility.set_location('Entering:'||l_proc, 5);
503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);
504: hr_utility.set_location('OVN:'||p_object_version_number, 5);
505: hr_utility.set_location('EFD:'||p_effective_date, 5);
506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Ensure that all the mandatory arguments are not null
510: --

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

503: hr_utility.set_location('Prtt enrt rslt id:'||p_prtt_enrt_rslt_id, 5);
504: hr_utility.set_location('OVN:'||p_object_version_number, 5);
505: hr_utility.set_location('EFD:'||p_effective_date, 5);
506: hr_utility.set_location('DM:'||p_datetrack_mode, 5);
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Ensure that all the mandatory arguments are not null
510: --
511: hr_api.mandatory_arg_error(p_api_name => l_proc

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

544: If (p_object_version_number <> g_old_rec.object_version_number) Then
545: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
546: fnd_message.raise_error;
547: End If;
548: hr_utility.set_location(l_proc, 15);
549: --
550: --
551: -- Validate the datetrack mode mode getting the validation start
552: -- and end dates for the specified datetrack operation.

Line 554: hr_utility.set_location('Here:',5);

550: --
551: -- Validate the datetrack mode mode getting the validation start
552: -- and end dates for the specified datetrack operation.
553: --
554: hr_utility.set_location('Here:',5);
555:
556: dt_api.validate_dt_mode
557: (p_effective_date => p_effective_date
558: ,p_datetrack_mode => p_datetrack_mode

Line 598: hr_utility.set_location('Now heer:',5);

594: ,p_enforce_foreign_locking => false
595: ,p_validation_start_date => l_validation_start_date
596: ,p_validation_end_date => l_validation_end_date
597: );
598: hr_utility.set_location('Now heer:',5);
599: Else
600: --
601: -- We are doing a datetrack 'INSERT' which is illegal within this
602: -- procedure therefore we must error (note: to lck on insert the

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

611: -- Set the validation start and end date OUT arguments
612: --
613: p_validation_start_date := l_validation_start_date;
614: p_validation_end_date := l_validation_end_date;
615: hr_utility.set_location(' Leaving:'||l_proc, 30);
616: --
617: -- We need to trap the ORA LOCK exception
618: --
619: Exception

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

719: l_proc varchar2(72) := g_package||'convert_args';
720: --
721: Begin
722: --
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: -- Convert arguments into local l_rec structure.
726: --
727: l_rec.prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;

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

799:
800: --
801: -- Return the plsql record structure.
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 10);
804: Return(l_rec);
805: --
806: End convert_args;
807: --