DBA Data[Home] [Help]

APPS.BEN_SVA_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_sva_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_svc_area_id => p_svc_area_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_svc_area_id;
78: --
79: -- ---------------------------------------------------------------------------

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

115: and name = p_name
116: and business_group_id = p_business_group_id;
117: --
118: Begin
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: open c1;
122: fetch c1 into l_dummy;
123: if c1%found then

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

125: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
126: fnd_message.raise_error;
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 15);
130: End chk_name_unique;
131: --
132: -- ----------------------------------------------------------------------------
133: -- |------< chk_org_unit_prdct >------|

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

164: l_api_updating boolean;
165: --
166: Begin
167: --
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: l_api_updating := ben_sva_shd.api_updating
171: (p_svc_area_id => p_svc_area_id,
172: p_effective_date => p_effective_date,

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

196: end if;
197: --
198: end if;
199: --
200: hr_utility.set_location('Leaving:'||l_proc,10);
201: --
202: end chk_org_unit_prdct;
203: --
204: -- ----------------------------------------------------------------------------

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

240: l_integrity_error Exception;
241: l_table_name all_tables.table_name%TYPE;
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- Ensure that the p_datetrack_mode argument is not null
247: --
248: hr_api.mandatory_arg_error

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

268: p_argument_value => p_validation_end_date);
269: --
270: End If;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: Exception
274: When l_integrity_error Then
275: --
276: -- A referential integrity check was violated therefore

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

335: l_rows_exist Exception;
336: l_table_name all_tables.table_name%TYPE;
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Ensure that the p_datetrack_mode argument is not null
342: --
343: hr_api.mandatory_arg_error

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

398: End If;
399: --
400: End If;
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: Exception
404: When l_rows_exist Then
405: --
406: -- A referential integrity check was violated therefore

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

431: --
432: l_proc varchar2(72) := g_package||'insert_validate';
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- Call all supporting business operations
438: --
439: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

453: p_org_unit_prdct => p_rec.org_unit_prdct,
454: p_effective_date => p_effective_date,
455: p_object_version_number => p_rec.object_version_number);
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: End insert_validate;
459: --
460: -- ----------------------------------------------------------------------------
461: -- |---------------------------< update_validate >----------------------------|

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

469: --
470: l_proc varchar2(72) := g_package||'update_validate';
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Call all supporting business operations
476: --
477: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

499: p_datetrack_mode => p_datetrack_mode,
500: p_validation_start_date => p_validation_start_date,
501: p_validation_end_date => p_validation_end_date);
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: End update_validate;
505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< delete_validate >----------------------------|

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

515: --
516: l_proc varchar2(72) := g_package||'delete_validate';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call all supporting business operations
522: --
523: dt_delete_validate

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

525: p_validation_start_date => p_validation_start_date,
526: p_validation_end_date => p_validation_end_date,
527: p_svc_area_id => p_rec.svc_area_id);
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
530: End delete_validate;
531: --
532: --
533: -- ---------------------------------------------------------------------------

Line 556: hr_utility.set_location('Entering:'|| l_proc, 10);

552: l_proc varchar2(72) := g_package||'return_legislation_code';
553: --
554: begin
555: --
556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: --
558: -- Ensure that all the mandatory parameter are not null
559: --
560: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

577: end if;
578: --
579: close csr_leg_code;
580: --
581: hr_utility.set_location(' Leaving:'|| l_proc, 20);
582: --
583: return l_legislation_code;
584: --
585: end return_legislation_code;