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_COP_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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_OIPL_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 152: hr_utility.set_location('Entering:'||l_proc, 5);

148: l_proc varchar2(72) := g_package||'api_updating';
149: l_fct_ret boolean;
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: If (p_effective_date is null or
155: p_oipl_id is null or
156: p_object_version_number is null) Then

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

161: l_fct_ret := false;
162: Else
163: If (p_oipl_id = g_old_rec.oipl_id and
164: p_object_version_number = g_old_rec.object_version_number) Then
165: hr_utility.set_location(l_proc, 10);
166: --
167: -- The g_old_rec is current therefore we must
168: -- set the returning function to true
169: --

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

178: Close C_Sel1;
179: --
180: -- The primary key is invalid therefore we must error
181: --
182: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
183: hr_utility.raise_error;
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 183: hr_utility.raise_error;

179: --
180: -- The primary key is invalid therefore we must error
181: --
182: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
183: hr_utility.raise_error;
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number <> g_old_rec.object_version_number) Then
187: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

183: hr_utility.raise_error;
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number <> g_old_rec.object_version_number) Then
187: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
188: hr_utility.raise_error;
189: End If;
190: hr_utility.set_location(l_proc, 15);
191: l_fct_ret := true;

Line 188: hr_utility.raise_error;

184: End If;
185: Close C_Sel1;
186: If (p_object_version_number <> g_old_rec.object_version_number) Then
187: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
188: hr_utility.raise_error;
189: End If;
190: hr_utility.set_location(l_proc, 15);
191: l_fct_ret := true;
192: End If;

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

186: If (p_object_version_number <> g_old_rec.object_version_number) Then
187: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
188: hr_utility.raise_error;
189: End If;
190: hr_utility.set_location(l_proc, 15);
191: l_fct_ret := true;
192: End If;
193: End If;
194: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

190: hr_utility.set_location(l_proc, 15);
191: l_fct_ret := true;
192: End If;
193: End If;
194: hr_utility.set_location(' Leaving:'||l_proc, 20);
195: Return (l_fct_ret);
196: --
197: End api_updating;
198: --

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

230: and p_effective_date
231: between t.effective_start_date and t.effective_end_date;
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: Open C_Sel1;
236: Fetch C_Sel1 Into l_parent_key_value1,
237: l_parent_key_value2,
238: l_parent_key_value3,

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

241: l_parent_key_value6,
242: l_parent_key_value7;
243: If C_Sel1%notfound then
244: Close C_Sel1;
245: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('PROCEDURE', l_proc);
247: hr_utility.set_message_token('STEP','10');
248: hr_utility.raise_error;
249: End If;

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

242: l_parent_key_value7;
243: If C_Sel1%notfound then
244: Close C_Sel1;
245: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('PROCEDURE', l_proc);
247: hr_utility.set_message_token('STEP','10');
248: hr_utility.raise_error;
249: End If;
250: Close C_Sel1;

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

243: If C_Sel1%notfound then
244: Close C_Sel1;
245: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('PROCEDURE', l_proc);
247: hr_utility.set_message_token('STEP','10');
248: hr_utility.raise_error;
249: End If;
250: Close C_Sel1;
251: --

Line 248: hr_utility.raise_error;

244: Close C_Sel1;
245: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
246: hr_utility.set_message_token('PROCEDURE', l_proc);
247: hr_utility.set_message_token('STEP','10');
248: hr_utility.raise_error;
249: End If;
250: Close C_Sel1;
251: --
252: -- Call the corresponding datetrack api

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

281: p_delete => p_delete,
282: p_future_change => p_future_change,
283: p_delete_next_change => p_delete_next_change);
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);
286: End find_dt_del_modes;
287: --
288: -- ----------------------------------------------------------------------------
289: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

298: --
299: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: -- Call the corresponding datetrack api
305: --
306: dt_api.find_dt_upd_modes

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

312: p_update => p_update,
313: p_update_override => p_update_override,
314: p_update_change_insert => p_update_change_insert);
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End find_dt_upd_modes;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |------------------------< upd_effective_end_date >------------------------|

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

330: l_proc varchar2(72) := g_package||'upd_effective_end_date';
331: l_object_version_number number;
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Because we are updating a row we must get the next object
337: -- version number.
338: --

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

341: (p_base_table_name => 'ben_oipl_f',
342: p_base_key_column => 'oipl_id',
343: p_base_key_value => p_base_key_value);
344: --
345: hr_utility.set_location(l_proc, 10);
346: g_api_dml := true; -- Set the api dml status
347: --
348: -- Update the specified datetrack row setting the effective
349: -- end date to the specified new effective end date.

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

356: between t.effective_start_date and t.effective_end_date;
357: --
358: g_api_dml := false; -- Unset the api dml status
359: p_object_version_number := l_object_version_number;
360: hr_utility.set_location(' Leaving:'||l_proc, 15);
361: --
362: Exception
363: When Others Then
364: g_api_dml := false; -- Unset the api dml status

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

468: --
469: --
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Ensure that all the mandatory arguments are not null
475: --
476: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

501: Close C_Sel1;
502: --
503: -- The primary key is invalid therefore we must error
504: --
505: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
506: hr_utility.raise_error;
507: End If;
508: Close C_Sel1;
509: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 506: hr_utility.raise_error;

502: --
503: -- The primary key is invalid therefore we must error
504: --
505: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
506: hr_utility.raise_error;
507: End If;
508: Close C_Sel1;
509: If (p_object_version_number <> g_old_rec.object_version_number) Then
510: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

506: hr_utility.raise_error;
507: End If;
508: Close C_Sel1;
509: If (p_object_version_number <> g_old_rec.object_version_number) Then
510: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
511: hr_utility.raise_error;
512: End If;
513: hr_utility.set_location(l_proc, 15);
514: --

Line 511: hr_utility.raise_error;

507: End If;
508: Close C_Sel1;
509: If (p_object_version_number <> g_old_rec.object_version_number) Then
510: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
511: hr_utility.raise_error;
512: End If;
513: hr_utility.set_location(l_proc, 15);
514: --
515: --

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

509: If (p_object_version_number <> g_old_rec.object_version_number) Then
510: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
511: hr_utility.raise_error;
512: End If;
513: hr_utility.set_location(l_proc, 15);
514: --
515: --
516: -- Validate the datetrack mode mode getting the validation start
517: -- and end dates for the specified datetrack operation.

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

561: -- We are doing a datetrack 'INSERT' which is illegal within this
562: -- procedure therefore we must error (note: to lck on insert the
563: -- private procedure ins_lck should be called).
564: --
565: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
566: hr_utility.set_message_token('PROCEDURE', l_proc);
567: hr_utility.set_message_token('STEP','20');
568: hr_utility.raise_error;
569: End If;

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

562: -- procedure therefore we must error (note: to lck on insert the
563: -- private procedure ins_lck should be called).
564: --
565: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
566: hr_utility.set_message_token('PROCEDURE', l_proc);
567: hr_utility.set_message_token('STEP','20');
568: hr_utility.raise_error;
569: End If;
570: --

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

563: -- private procedure ins_lck should be called).
564: --
565: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
566: hr_utility.set_message_token('PROCEDURE', l_proc);
567: hr_utility.set_message_token('STEP','20');
568: hr_utility.raise_error;
569: End If;
570: --
571: -- Set the validation start and end date OUT arguments

Line 568: hr_utility.raise_error;

564: --
565: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
566: hr_utility.set_message_token('PROCEDURE', l_proc);
567: hr_utility.set_message_token('STEP','20');
568: hr_utility.raise_error;
569: End If;
570: --
571: -- Set the validation start and end date OUT arguments
572: --

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

572: --
573: p_validation_start_date := l_validation_start_date;
574: p_validation_end_date := l_validation_end_date;
575: --
576: hr_utility.set_location(' Leaving:'||l_proc, 30);
577: --
578: -- We need to trap the ORA LOCK exception
579: --
580: Exception

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

582: --
583: -- The object is locked therefore we need to supply a meaningful
584: -- error message.
585: --
586: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
587: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
588: hr_utility.raise_error;
589: When l_object_invalid then
590: --

Line 587: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');

583: -- The object is locked therefore we need to supply a meaningful
584: -- error message.
585: --
586: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
587: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
588: hr_utility.raise_error;
589: When l_object_invalid then
590: --
591: -- The object doesn't exist or is invalid

Line 588: hr_utility.raise_error;

584: -- error message.
585: --
586: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
587: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
588: hr_utility.raise_error;
589: When l_object_invalid then
590: --
591: -- The object doesn't exist or is invalid
592: --

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

589: When l_object_invalid then
590: --
591: -- The object doesn't exist or is invalid
592: --
593: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
594: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
595: hr_utility.raise_error;
596: End lck;
597: --

Line 594: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');

590: --
591: -- The object doesn't exist or is invalid
592: --
593: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
594: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
595: hr_utility.raise_error;
596: End lck;
597: --
598: -- ----------------------------------------------------------------------------

Line 595: hr_utility.raise_error;

591: -- The object doesn't exist or is invalid
592: --
593: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
594: hr_utility.set_message_token('TABLE_NAME', 'ben_oipl_f');
595: hr_utility.raise_error;
596: End lck;
597: --
598: -- ----------------------------------------------------------------------------
599: -- |-----------------------------< convert_args >-----------------------------|

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

680: l_proc varchar2(72) := g_package||'convert_args';
681: --
682: Begin
683: --
684: hr_utility.set_location('Entering:'||l_proc, 5);
685: --
686: -- Convert arguments into local l_rec structure.
687: --
688: l_rec.oipl_id := p_oipl_id;

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

760: l_rec.object_version_number := p_object_version_number;
761: --
762: -- Return the plsql record structure.
763: --
764: hr_utility.set_location(' Leaving:'||l_proc, 10);
765: Return(l_rec);
766: --
767: End convert_args;
768: --