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_SAR_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_SVC_AREA_RT_PK') 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_SVC_AREA_RT_PK') 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 = 'EXCLD_FLAG_FLGD') 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_SVC_AREA_RT_PK') 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 = 'EXCLD_FLAG_FLGD') 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_SVC_AREA_RT_PK') 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 = 'EXCLD_FLAG_FLGD') 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_SVC_AREA_RT_PK') 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 = 'EXCLD_FLAG_FLGD') 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 = 'EXCLD_FLAG_FLGD') 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 = 'EXCLD_FLAG_FLGD') 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 = 'EXCLD_FLAG_FLGD') 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 = 'EXCLD_FLAG_FLGD') 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 119: hr_utility.set_location('Entering:'||l_proc, 5);

115: l_proc varchar2(72) := g_package||'api_updating';
116: l_fct_ret boolean;
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: If (p_effective_date is null or
122: p_svc_area_rt_id is null or
123: p_object_version_number is null) Then

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

128: l_fct_ret := false;
129: Else
130: If (p_svc_area_rt_id = g_old_rec.svc_area_rt_id and
131: p_object_version_number = g_old_rec.object_version_number) Then
132: hr_utility.set_location(l_proc, 10);
133: --
134: -- The g_old_rec is current therefore we must
135: -- set the returning function to true
136: --

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

145: Close C_Sel1;
146: --
147: -- The primary key is invalid therefore we must error
148: --
149: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
150: hr_utility.raise_error;
151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 150: hr_utility.raise_error;

146: --
147: -- The primary key is invalid therefore we must error
148: --
149: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
150: hr_utility.raise_error;
151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

150: hr_utility.raise_error;
151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
155: hr_utility.raise_error;
156: End If;
157: hr_utility.set_location(l_proc, 15);
158: l_fct_ret := true;

Line 155: hr_utility.raise_error;

151: End If;
152: Close C_Sel1;
153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
155: hr_utility.raise_error;
156: End If;
157: hr_utility.set_location(l_proc, 15);
158: l_fct_ret := true;
159: End If;

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

153: If (p_object_version_number <> g_old_rec.object_version_number) Then
154: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
155: hr_utility.raise_error;
156: End If;
157: hr_utility.set_location(l_proc, 15);
158: l_fct_ret := true;
159: End If;
160: End If;
161: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

157: hr_utility.set_location(l_proc, 15);
158: l_fct_ret := true;
159: End If;
160: End If;
161: hr_utility.set_location(' Leaving:'||l_proc, 20);
162: Return (l_fct_ret);
163: --
164: End api_updating;
165: --

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

187: and p_effective_date
188: between t.effective_start_date and t.effective_end_date;
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: Open C_Sel1;
193: Fetch C_Sel1 Into l_parent_key_value1,
194: l_parent_key_value2;
195: If C_Sel1%notfound then

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

193: Fetch C_Sel1 Into l_parent_key_value1,
194: l_parent_key_value2;
195: If C_Sel1%notfound then
196: Close C_Sel1;
197: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PROCEDURE', l_proc);
199: hr_utility.set_message_token('STEP','10');
200: hr_utility.raise_error;
201: End If;

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

194: l_parent_key_value2;
195: If C_Sel1%notfound then
196: Close C_Sel1;
197: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PROCEDURE', l_proc);
199: hr_utility.set_message_token('STEP','10');
200: hr_utility.raise_error;
201: End If;
202: Close C_Sel1;

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

195: If C_Sel1%notfound then
196: Close C_Sel1;
197: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PROCEDURE', l_proc);
199: hr_utility.set_message_token('STEP','10');
200: hr_utility.raise_error;
201: End If;
202: Close C_Sel1;
203: --

Line 200: hr_utility.raise_error;

196: Close C_Sel1;
197: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
198: hr_utility.set_message_token('PROCEDURE', l_proc);
199: hr_utility.set_message_token('STEP','10');
200: hr_utility.raise_error;
201: End If;
202: Close C_Sel1;
203: --
204: -- Call the corresponding datetrack api

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

218: p_delete => p_delete,
219: p_future_change => p_future_change,
220: p_delete_next_change => p_delete_next_change);
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: End find_dt_del_modes;
224: --
225: -- ----------------------------------------------------------------------------
226: -- |--------------------------< find_dt_upd_modes >---------------------------|

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

235: --
236: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: -- Call the corresponding datetrack api
242: --
243: dt_api.find_dt_upd_modes

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

249: p_update => p_update,
250: p_update_override => p_update_override,
251: p_update_change_insert => p_update_change_insert);
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: End find_dt_upd_modes;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |------------------------< upd_effective_end_date >------------------------|

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

267: l_proc varchar2(72) := g_package||'upd_effective_end_date';
268: l_object_version_number number;
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: -- Because we are updating a row we must get the next object
274: -- version number.
275: --

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

278: (p_base_table_name => 'ben_svc_area_rt_f',
279: p_base_key_column => 'svc_area_rt_id',
280: p_base_key_value => p_base_key_value);
281: --
282: hr_utility.set_location(l_proc, 10);
283: g_api_dml := true; -- Set the api dml status
284: --
285: -- Update the specified datetrack row setting the effective
286: -- end date to the specified new effective end date.

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

293: between t.effective_start_date and t.effective_end_date;
294: --
295: g_api_dml := false; -- Unset the api dml status
296: p_object_version_number := l_object_version_number;
297: hr_utility.set_location(' Leaving:'||l_proc, 15);
298: --
299: Exception
300: When Others Then
301: g_api_dml := false; -- Unset the api dml status

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

372: --
373: --
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: -- Ensure that all the mandatory arguments are not null
379: --
380: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

405: Close C_Sel1;
406: --
407: -- The primary key is invalid therefore we must error
408: --
409: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
410: hr_utility.raise_error;
411: End If;
412: Close C_Sel1;
413: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 410: hr_utility.raise_error;

406: --
407: -- The primary key is invalid therefore we must error
408: --
409: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
410: hr_utility.raise_error;
411: End If;
412: Close C_Sel1;
413: If (p_object_version_number <> g_old_rec.object_version_number) Then
414: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

410: hr_utility.raise_error;
411: End If;
412: Close C_Sel1;
413: If (p_object_version_number <> g_old_rec.object_version_number) Then
414: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
415: hr_utility.raise_error;
416: End If;
417: hr_utility.set_location(l_proc, 15);
418: --

Line 415: hr_utility.raise_error;

411: End If;
412: Close C_Sel1;
413: If (p_object_version_number <> g_old_rec.object_version_number) Then
414: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
415: hr_utility.raise_error;
416: End If;
417: hr_utility.set_location(l_proc, 15);
418: --
419: --

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

413: If (p_object_version_number <> g_old_rec.object_version_number) Then
414: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
415: hr_utility.raise_error;
416: End If;
417: hr_utility.set_location(l_proc, 15);
418: --
419: --
420: -- Validate the datetrack mode mode getting the validation start
421: -- and end dates for the specified datetrack operation.

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

440: -- We are doing a datetrack 'INSERT' which is illegal within this
441: -- procedure therefore we must error (note: to lck on insert the
442: -- private procedure ins_lck should be called).
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','20');
447: hr_utility.raise_error;
448: End If;

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

441: -- procedure therefore we must error (note: to lck on insert the
442: -- private procedure ins_lck should be called).
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','20');
447: hr_utility.raise_error;
448: End If;
449: --

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

442: -- private procedure ins_lck should be called).
443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','20');
447: hr_utility.raise_error;
448: End If;
449: --
450: -- Set the validation start and end date OUT arguments

Line 447: hr_utility.raise_error;

443: --
444: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
445: hr_utility.set_message_token('PROCEDURE', l_proc);
446: hr_utility.set_message_token('STEP','20');
447: hr_utility.raise_error;
448: End If;
449: --
450: -- Set the validation start and end date OUT arguments
451: --

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

451: --
452: p_validation_start_date := l_validation_start_date;
453: p_validation_end_date := l_validation_end_date;
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 30);
456: --
457: -- We need to trap the ORA LOCK exception
458: --
459: Exception

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

461: --
462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');
467: hr_utility.raise_error;
468: When l_object_invalid then
469: --

Line 466: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');

462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');
467: hr_utility.raise_error;
468: When l_object_invalid then
469: --
470: -- The object doesn't exist or is invalid

Line 467: hr_utility.raise_error;

463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');
467: hr_utility.raise_error;
468: When l_object_invalid then
469: --
470: -- The object doesn't exist or is invalid
471: --

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

468: When l_object_invalid then
469: --
470: -- The object doesn't exist or is invalid
471: --
472: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
473: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');
474: hr_utility.raise_error;
475: End lck;
476: --

Line 473: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');

469: --
470: -- The object doesn't exist or is invalid
471: --
472: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
473: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');
474: hr_utility.raise_error;
475: End lck;
476: --
477: -- ----------------------------------------------------------------------------

Line 474: hr_utility.raise_error;

470: -- The object doesn't exist or is invalid
471: --
472: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
473: hr_utility.set_message_token('TABLE_NAME', 'ben_svc_area_rt_f');
474: hr_utility.raise_error;
475: End lck;
476: --
477: -- ----------------------------------------------------------------------------
478: -- |-----------------------------< convert_args >-----------------------------|

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

526: l_proc varchar2(72) := g_package||'convert_args';
527: --
528: Begin
529: --
530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Convert arguments into local l_rec structure.
533: --
534: l_rec.svc_area_rt_id := p_svc_area_rt_id;

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

573: l_rec.object_version_number := p_object_version_number;
574: --
575: -- Return the plsql record structure.
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 10);
578: Return(l_rec);
579: --
580: End convert_args;
581: --