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

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

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

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

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

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

Line 184: hr_utility.raise_error;

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

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

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

Line 189: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 249: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 508: hr_utility.raise_error;

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

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

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

Line 513: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 570: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 590: hr_utility.raise_error;

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

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

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

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

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

Line 597: hr_utility.raise_error;

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

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

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

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

764: l_rec.all_inelig := p_all_inelig;
765: --
766: -- Return the plsql record structure.
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 10);
769: Return(l_rec);
770: --
771: End convert_args;
772: --