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.

[Home] [Help]

APPS.BEN_PGM_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_PGM_FK1') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);

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

49: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50: fnd_message.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 189: hr_utility.set_location('Entering:'||l_proc, 5);

185: l_proc varchar2(72) := g_package||'api_updating';
186: l_fct_ret boolean;
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: If (p_effective_date is null or
192: p_pgm_id is null or
193: p_object_version_number is null) Then

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

198: l_fct_ret := false;
199: Else
200: If (p_pgm_id = g_old_rec.pgm_id and
201: p_object_version_number = g_old_rec.object_version_number) Then
202: hr_utility.set_location(l_proc, 10);
203: --
204: -- The g_old_rec is current therefore we must
205: -- set the returning function to true
206: --

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

223: If (p_object_version_number <> g_old_rec.object_version_number) Then
224: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
225: fnd_message.raise_error;
226: End If;
227: hr_utility.set_location(l_proc, 15);
228: l_fct_ret := true;
229: End If;
230: End If;
231: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

227: hr_utility.set_location(l_proc, 15);
228: l_fct_ret := true;
229: End If;
230: End If;
231: hr_utility.set_location(' Leaving:'||l_proc, 20);
232: Return (l_fct_ret);
233: --
234: End api_updating;
235: --

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

265: and p_effective_date
266: between t.effective_start_date and t.effective_end_date;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: Open C_Sel1;
271: Fetch C_Sel1 Into l_parent_key_value1,
272: l_parent_key_value2,
273: l_parent_key_value3,

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

312: p_delete => p_delete,
313: p_future_change => p_future_change,
314: p_delete_next_change => p_delete_next_change);
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End find_dt_del_modes;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

329: --
330: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call the corresponding datetrack api
336: --
337: dt_api.find_dt_upd_modes

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

343: p_update => p_update,
344: p_update_override => p_update_override,
345: p_update_change_insert => p_update_change_insert);
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 10);
348: End find_dt_upd_modes;
349: --
350: -- ----------------------------------------------------------------------------
351: -- |------------------------< upd_effective_end_date >------------------------|

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

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

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

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

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

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

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

536: --
537: --
538: --
539: Begin
540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- Ensure that all the mandatory arguments are not null
543: --
544: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

577: If (p_object_version_number <> g_old_rec.object_version_number) Then
578: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
579: fnd_message.raise_error;
580: End If;
581: hr_utility.set_location(l_proc, 15);
582: --
583: --
584: -- Validate the datetrack mode mode getting the validation start
585: -- and end dates for the specified datetrack operation.

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

680: --
681: p_validation_start_date := l_validation_start_date;
682: p_validation_end_date := l_validation_end_date;
683: --
684: hr_utility.set_location(' Leaving:'||l_proc, 30);
685: --
686: -- We need to trap the ORA LOCK exception
687: --
688: Exception

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

825: l_proc varchar2(72) := g_package||'convert_args';
826: --
827: Begin
828: --
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: -- Convert arguments into local l_rec structure.
832: --
833: l_rec.pgm_id := p_pgm_id;

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

942: l_rec.object_version_number := p_object_version_number;
943: --
944: -- Return the plsql record structure.
945: --
946: hr_utility.set_location(' Leaving:'||l_proc, 10);
947: Return(l_rec);
948: --
949: End convert_args;
950: --