DBA Data[Home] [Help]

APPS.BEN_CTY_BUS dependencies on HR_UTILITY

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

48: l_api_updating boolean;
49: --
50: Begin
51: --
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: --
54: l_api_updating := ben_cty_shd.api_updating
55: (p_effective_date => p_effective_date,
56: p_comptncy_rt_id => p_comptncy_rt_id,

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

77: end if;
78: --
79: end if;
80: --
81: hr_utility.set_location('Leaving:'||l_proc, 10);
82: --
83: End chk_comptncy_rt_id;
84: --
85: -- ----------------------------------------------------------------------------

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

147: --
148: --
149: Begin
150: --
151: hr_utility.set_location('Entering:'||l_proc,5);
152: --
153: l_api_updating := ben_cty_shd.api_updating
154: (p_comptncy_rt_id => p_comptncy_rt_id,
155: p_effective_date => p_effective_date,

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

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

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

273: --
274: --
275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc,5);
278: --
279: l_api_updating := ben_cty_shd.api_updating
280: (p_comptncy_rt_id => p_comptncy_rt_id,
281: p_effective_date => p_effective_date,

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

321: --
322: --
323: end if;
324: --
325: hr_utility.set_location('Leaving:'||l_proc,10);
326: --
327: End chk_rating_level_id;
328:
329:

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

363: l_api_updating boolean;
364: --
365: Begin
366: --
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: l_api_updating := ben_cty_shd.api_updating
370: (p_comptncy_rt_id => p_comptncy_rt_id,
371: p_effective_date => p_effective_date,

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

392: end if;
393: --
394: end if;
395: --
396: hr_utility.set_location('Leaving:'||l_proc,10);
397: --
398: end chk_excld_flag;
399: --
400: -- added for Bug 5078478 .. add this procedure to check the duplicate seq no

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

448: and business_group_id + 0 = p_business_group_id
449: and ordr_num = p_ordr_num;
450: --
451: Begin
452: hr_utility.set_location('Entering:'||l_proc, 5);
453:
454: --
455: open c1;
456: fetch c1 into l_dummy;

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

460: fnd_message.raise_error;
461: end if;
462: close c1;
463: --
464: hr_utility.set_location('Leaving:'||l_proc, 15);
465: End chk_duplicate_ordr_num;
466:
467: --
468: -- ---------------------------------------------------------------------------

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

489: l_proc varchar2(72) := g_package||'set_security_group_id';
490: --
491: begin
492: --
493: hr_utility.set_location('Entering:'|| l_proc, 10);
494: --
495: -- Ensure that all the mandatory parameter are not null
496: --
497: hr_api.mandatory_arg_error

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

524: (p_security_group_id => l_security_group_id
525: );
526: end if;
527: --
528: hr_utility.set_location(' Leaving:'|| l_proc, 20);
529: --
530: end set_security_group_id;
531: --
532: -- ---------------------------------------------------------------------------

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

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

Line 575: hr_utility.set_location(l_proc, 20);

571: -- call to this function. Just return the value in the global
572: -- variable.
573: --
574: l_legislation_code := ben_cty_bus.g_legislation_code;
575: hr_utility.set_location(l_proc, 20);
576: else
577: --
578: -- The ID is different to the last call to this function
579: -- or this is the first call to this function.

Line 592: hr_utility.set_location(l_proc,30);

588: close csr_leg_code;
589: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
590: fnd_message.raise_error;
591: end if;
592: hr_utility.set_location(l_proc,30);
593: --
594: -- Set the global variables so the values are
595: -- available for the next call to this function.
596: --

Line 601: hr_utility.set_location(' Leaving:'|| l_proc, 40);

597: close csr_leg_code;
598: ben_cty_bus.g_comptncy_rt_id := p_comptncy_rt_id;
599: ben_cty_bus.g_legislation_code := l_legislation_code;
600: end if;
601: hr_utility.set_location(' Leaving:'|| l_proc, 40);
602: return l_legislation_code;
603: end return_legislation_code;
604: --
605: -- ----------------------------------------------------------------------------

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

636: --
637: l_proc varchar2(72) := g_package || 'chk_df';
638: --
639: begin
640: hr_utility.set_location('Entering:'||l_proc,10);
641: --
642: if ((p_rec.comptncy_rt_id is not null) and (
643: nvl(ben_cty_shd.g_old_rec.cty_attribute_category, hr_api.g_varchar2) <>
644: nvl(p_rec.cty_attribute_category, hr_api.g_varchar2) or

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

775: ,p_attribute30_value => p_rec.cty_attribute30
776: );
777: end if;
778: --
779: hr_utility.set_location(' Leaving:'||l_proc,20);
780: end chk_df;
781: --
782: -- ----------------------------------------------------------------------------
783: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1034: --
1035: l_proc varchar2(72) := g_package||'insert_validate';
1036: --
1037: Begin
1038: hr_utility.set_location('Entering:'||l_proc, 5);
1039: --
1040: -- Call all supporting business operations
1041: --
1042: hr_api.validate_bus_grp_id

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

1097: --
1098: --
1099: -- ben_cty_bus.chk_df(p_rec);
1100: --
1101: hr_utility.set_location(' Leaving:'||l_proc, 10);
1102: End insert_validate;
1103: --
1104: -- ----------------------------------------------------------------------------
1105: -- |---------------------------< update_validate >----------------------------|

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

1114: --
1115: l_proc varchar2(72) := g_package||'update_validate';
1116: --
1117: Begin
1118: hr_utility.set_location('Entering:'||l_proc, 5);
1119: --
1120: -- Call all supporting business operations
1121: --
1122: hr_api.validate_bus_grp_id

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

1189: --
1190: --
1191: -- ben_cty_bus.chk_df(p_rec);
1192: --
1193: hr_utility.set_location(' Leaving:'||l_proc, 10);
1194: End update_validate;
1195: --
1196: -- ----------------------------------------------------------------------------
1197: -- |---------------------------< delete_validate >----------------------------|

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

1206: --
1207: l_proc varchar2(72) := g_package||'delete_validate';
1208: --
1209: Begin
1210: hr_utility.set_location('Entering:'||l_proc, 5);
1211: --
1212: -- Call all supporting business operations
1213: --
1214: dt_delete_validate

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

1217: ,p_validation_end_date => p_validation_end_date
1218: ,p_comptncy_rt_id => p_rec.comptncy_rt_id
1219: );
1220: --
1221: hr_utility.set_location(' Leaving:'||l_proc, 10);
1222: End delete_validate;
1223: --
1224: end ben_cty_bus;