DBA Data[Home] [Help]

APPS.BEN_VPF_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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_VRBL_RT_PRFL_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 210: hr_utility.set_location('Entering:'||l_proc, 5);

206: l_proc varchar2(72) := g_package||'api_updating';
207: l_fct_ret boolean;
208: --
209: Begin
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: If (p_effective_date is null or
213: p_vrbl_rt_prfl_id is null or
214: p_object_version_number is null) Then

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

219: l_fct_ret := false;
220: Else
221: If (p_vrbl_rt_prfl_id = g_old_rec.vrbl_rt_prfl_id and
222: p_object_version_number = g_old_rec.object_version_number) Then
223: hr_utility.set_location(l_proc, 10);
224: --
225: -- The g_old_rec is current therefore we must
226: -- set the returning function to true
227: --

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

236: Close C_Sel1;
237: --
238: -- The primary key is invalid therefore we must error
239: --
240: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
241: hr_utility.raise_error;
242: End If;
243: Close C_Sel1;
244: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 241: hr_utility.raise_error;

237: --
238: -- The primary key is invalid therefore we must error
239: --
240: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
241: hr_utility.raise_error;
242: End If;
243: Close C_Sel1;
244: If (p_object_version_number <> g_old_rec.object_version_number) Then
245: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

241: hr_utility.raise_error;
242: End If;
243: Close C_Sel1;
244: If (p_object_version_number <> g_old_rec.object_version_number) Then
245: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
246: hr_utility.raise_error;
247: End If;
248: hr_utility.set_location(l_proc, 15);
249: l_fct_ret := true;

Line 246: hr_utility.raise_error;

242: End If;
243: Close C_Sel1;
244: If (p_object_version_number <> g_old_rec.object_version_number) Then
245: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
246: hr_utility.raise_error;
247: End If;
248: hr_utility.set_location(l_proc, 15);
249: l_fct_ret := true;
250: End If;

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

244: If (p_object_version_number <> g_old_rec.object_version_number) Then
245: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
246: hr_utility.raise_error;
247: End If;
248: hr_utility.set_location(l_proc, 15);
249: l_fct_ret := true;
250: End If;
251: End If;
252: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

248: hr_utility.set_location(l_proc, 15);
249: l_fct_ret := true;
250: End If;
251: End If;
252: hr_utility.set_location(' Leaving:'||l_proc, 20);
253: Return (l_fct_ret);
254: --
255: End api_updating;
256: --

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

280: and p_effective_date
281: between t.effective_start_date and t.effective_end_date;
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: Open C_Sel1;
286: Fetch C_Sel1 Into l_parent_key_value1,
287: l_parent_key_value3,
288: l_parent_key_value2;

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

287: l_parent_key_value3,
288: l_parent_key_value2;
289: If C_Sel1%notfound then
290: Close C_Sel1;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE', l_proc);
293: hr_utility.set_message_token('STEP','10');
294: hr_utility.raise_error;
295: End If;

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

288: l_parent_key_value2;
289: If C_Sel1%notfound then
290: Close C_Sel1;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE', l_proc);
293: hr_utility.set_message_token('STEP','10');
294: hr_utility.raise_error;
295: End If;
296: Close C_Sel1;

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

289: If C_Sel1%notfound then
290: Close C_Sel1;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE', l_proc);
293: hr_utility.set_message_token('STEP','10');
294: hr_utility.raise_error;
295: End If;
296: Close C_Sel1;
297: --

Line 294: hr_utility.raise_error;

290: Close C_Sel1;
291: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
292: hr_utility.set_message_token('PROCEDURE', l_proc);
293: hr_utility.set_message_token('STEP','10');
294: hr_utility.raise_error;
295: End If;
296: Close C_Sel1;
297: --
298: -- Call the corresponding datetrack api

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_vrbl_rt_prfl_f',
373: p_base_key_column => 'vrbl_rt_prfl_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 565: hr_utility.set_location('Entering:'||l_proc, 5);

561: --
562: --
563: --
564: Begin
565: hr_utility.set_location('Entering:'||l_proc, 5);
566: --
567: -- Ensure that all the mandatory arguments are not null
568: --
569: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

594: Close C_Sel1;
595: --
596: -- The primary key is invalid therefore we must error
597: --
598: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
599: hr_utility.raise_error;
600: End If;
601: Close C_Sel1;
602: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 599: hr_utility.raise_error;

595: --
596: -- The primary key is invalid therefore we must error
597: --
598: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
599: hr_utility.raise_error;
600: End If;
601: Close C_Sel1;
602: If (p_object_version_number <> g_old_rec.object_version_number) Then
603: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

599: hr_utility.raise_error;
600: End If;
601: Close C_Sel1;
602: If (p_object_version_number <> g_old_rec.object_version_number) Then
603: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
604: hr_utility.raise_error;
605: End If;
606: hr_utility.set_location(l_proc, 15);
607: --

Line 604: hr_utility.raise_error;

600: End If;
601: Close C_Sel1;
602: If (p_object_version_number <> g_old_rec.object_version_number) Then
603: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
604: hr_utility.raise_error;
605: End If;
606: hr_utility.set_location(l_proc, 15);
607: --
608: -- Validate the datetrack mode mode getting the validation start

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

602: If (p_object_version_number <> g_old_rec.object_version_number) Then
603: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
604: hr_utility.raise_error;
605: End If;
606: hr_utility.set_location(l_proc, 15);
607: --
608: -- Validate the datetrack mode mode getting the validation start
609: -- and end dates for the specified datetrack operation.
610: --

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

823: -- We are doing a datetrack 'INSERT' which is illegal within this
824: -- procedure therefore we must error (note: to lck on insert the
825: -- private procedure ins_lck should be called).
826: --
827: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE', l_proc);
829: hr_utility.set_message_token('STEP','20');
830: hr_utility.raise_error;
831: End If;

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

824: -- procedure therefore we must error (note: to lck on insert the
825: -- private procedure ins_lck should be called).
826: --
827: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE', l_proc);
829: hr_utility.set_message_token('STEP','20');
830: hr_utility.raise_error;
831: End If;
832: --

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

825: -- private procedure ins_lck should be called).
826: --
827: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE', l_proc);
829: hr_utility.set_message_token('STEP','20');
830: hr_utility.raise_error;
831: End If;
832: --
833: -- Set the validation start and end date OUT arguments

Line 830: hr_utility.raise_error;

826: --
827: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
828: hr_utility.set_message_token('PROCEDURE', l_proc);
829: hr_utility.set_message_token('STEP','20');
830: hr_utility.raise_error;
831: End If;
832: --
833: -- Set the validation start and end date OUT arguments
834: --

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

883: end if;
884: --
885: end if;
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 30);
888: --
889: -- We need to trap the ORA LOCK exception
890: --
891: Exception

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

893: --
894: -- The object is locked therefore we need to supply a meaningful
895: -- error message.
896: --
897: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
898: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
899: hr_utility.raise_error;
900: When l_object_invalid then
901: --

Line 898: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');

894: -- The object is locked therefore we need to supply a meaningful
895: -- error message.
896: --
897: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
898: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
899: hr_utility.raise_error;
900: When l_object_invalid then
901: --
902: -- The object doesn't exist or is invalid

Line 899: hr_utility.raise_error;

895: -- error message.
896: --
897: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
898: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
899: hr_utility.raise_error;
900: When l_object_invalid then
901: --
902: -- The object doesn't exist or is invalid
903: --

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

900: When l_object_invalid then
901: --
902: -- The object doesn't exist or is invalid
903: --
904: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
905: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
906: hr_utility.raise_error;
907: End lck;
908: --

Line 905: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');

901: --
902: -- The object doesn't exist or is invalid
903: --
904: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
905: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
906: hr_utility.raise_error;
907: End lck;
908: --
909: -- ----------------------------------------------------------------------------

Line 906: hr_utility.raise_error;

902: -- The object doesn't exist or is invalid
903: --
904: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
905: hr_utility.set_message_token('TABLE_NAME', 'ben_vrbl_rt_prfl_f');
906: hr_utility.raise_error;
907: End lck;
908: --
909: -- ----------------------------------------------------------------------------
910: -- |-----------------------------< convert_args >-----------------------------|

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

1048: l_proc varchar2(72) := g_package||'convert_args';
1049: --
1050: Begin
1051: --
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: -- Convert arguments into local l_rec structure.
1055: --
1056: l_rec.vrbl_rt_prfl_id := p_vrbl_rt_prfl_id;

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

1187:
1188: --
1189: -- Return the plsql record structure.
1190: --
1191: hr_utility.set_location(' Leaving:'||l_proc, 10);
1192: Return(l_rec);
1193: --
1194: End convert_args;
1195: --