DBA Data[Home] [Help]

APPS.BEN_XCV_BUS dependencies on HR_UTILITY

Line 50: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

46: -- If the value is not known then go onto check against the
47: -- hr_lookups view. Just in case there has been a change to
48: -- the system defined lookup.
49: end if;
50: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
51: --
52: open csr_hr_look;
53: fetch csr_hr_look into l_exists;
54: if csr_hr_look%notfound then

Line 103: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);

99: -- If the value is not known then go onto check against the
100: -- hr_lookups view. Just in case there has been a change to
101: -- the system defined lookup.
102: end if;
103: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
104: --
105: open csr_hr_look;
106: fetch csr_hr_look into l_exists;
107: if csr_hr_look%notfound then

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

185: l_proc varchar2(72) := g_package||'set_security_group_id';
186: --
187: begin
188: --
189: hr_utility.set_location('Entering:'|| l_proc, 10);
190: --
191: -- Ensure that all the mandatory parameter are not null
192: --
193: hr_api.mandatory_arg_error

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

216: hr_api.set_security_group_id
217: (p_security_group_id => l_security_group_id
218: );
219: --
220: hr_utility.set_location(' Leaving:'|| l_proc, 20);
221: --
222: end set_security_group_id;
223:
224: --

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

255: l_api_updating boolean;
256: --
257: Begin
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: l_api_updating := ben_xcv_shd.api_updating
262: (p_ext_crit_val_id => p_ext_crit_val_id,
263: p_object_version_number => p_object_version_number);

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

283: end if;
284: --
285: end if;
286: --
287: hr_utility.set_location('Leaving:'||l_proc, 10);
288: --
289: End chk_ext_crit_val_id;
290: --
291: -- ----------------------------------------------------------------------------

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

327: where a.ext_crit_typ_id = p_ext_crit_typ_id;
328: --
329: Begin
330: --
331: hr_utility.set_location('Entering:'||l_proc,5);
332: --
333: l_api_updating := ben_xcv_shd.api_updating
334: (p_ext_crit_val_id => p_ext_crit_val_id,
335: p_object_version_number => p_object_version_number);

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

358: close c1;
359: --
360: end if;
361: --
362: hr_utility.set_location('Leaving:'||l_proc,10);
363: --
364: End chk_ext_crit_typ_id;
365:
366:

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

389: ;
390: --
391: Begin
392: --
393: hr_utility.set_location('Entering:'||l_proc,5);
394: --
395: l_api_updating := ben_xcv_shd.api_updating
396: (p_ext_crit_val_id => p_ext_crit_val_id,
397: p_object_version_number => p_object_version_number);

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

430: end if ;
431: end if;
432: end if ;
433: --
434: hr_utility.set_location('Leaving:'||l_proc,10);
435: --
436: End chk_ext_crit_bg_id;
437:
438:

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

567: ;
568: --
569: Begin
570: --
571: hr_utility.set_location('Entering:'||l_proc,5);
572: --
573: l_api_updating := ben_xcv_shd.api_updating
574: (p_ext_crit_val_id => p_ext_crit_val_id,
575: p_object_version_number => p_object_version_number);

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

856:
857: --
858: end if;
859: --
860: hr_utility.set_location('Leaving:'||l_proc,10);
861: --
862: End chk_val_1;
863: -- ----------------------------------------------------------------------------
864: -- |------< chk_val_2 >------|

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

922: and b.val_1 = p_val_1
923: and b.val_2 = p_val_2;
924: Begin
925: --
926: hr_utility.set_location('Entering:'||l_proc,5);
927: --
928: l_api_updating := ben_xcv_shd.api_updating
929: (p_ext_crit_val_id => p_ext_crit_val_id,
930: p_object_version_number => p_object_version_number);

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

972: --
973: end if;
974: end if;
975: --
976: hr_utility.set_location('Leaving:'||l_proc,10);
977: --
978: End chk_val_2;
979: -- ----------------------------------------------------------------------------
980: -- |------< chk_val_dpndcy >------|

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

1019: where a.ext_crit_typ_id = p_ext_crit_typ_id;
1020: --
1021: Begin
1022: --
1023: hr_utility.set_location('Entering:'||l_proc,5);
1024: --
1025: l_api_updating := ben_xcv_shd.api_updating
1026: (p_ext_crit_val_id => p_ext_crit_val_id,
1027: p_object_version_number => p_object_version_number);

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

1054: end if;
1055: --
1056: end if;
1057: --
1058: hr_utility.set_location('Leaving:'||l_proc,10);
1059: --
1060: End chk_val_dpndcy;
1061: -- ----------------------------------------------------------------------------
1062: -- |---------------------------< insert_validate >----------------------------|

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

1066: --
1067: l_proc varchar2(72) := g_package||'insert_validate';
1068: --
1069: Begin
1070: hr_utility.set_location('Entering:'||l_proc, 5);
1071: --
1072: -- Call all supporting business operations
1073: --
1074: --

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

1123: p_business_group_id => p_rec.business_group_id,
1124: p_object_version_number => p_rec.object_version_number)
1125: ;
1126:
1127: hr_utility.set_location(' Leaving:'||l_proc, 10);
1128: End insert_validate;
1129: --
1130: -- ----------------------------------------------------------------------------
1131: -- |---------------------------< update_validate >----------------------------|

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

1135: --
1136: l_proc varchar2(72) := g_package||'update_validate';
1137: --
1138: Begin
1139: hr_utility.set_location('Entering:'||l_proc, 5);
1140: --
1141: -- Call all supporting business operations
1142: --
1143: --

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

1192: p_ext_crit_typ_id => p_rec.ext_crit_typ_id,
1193: p_business_group_id => p_rec.business_group_id,
1194: p_object_version_number => p_rec.object_version_number)
1195: ;
1196: hr_utility.set_location(' Leaving:'||l_proc, 10);
1197: End update_validate;
1198: --
1199: -- ----------------------------------------------------------------------------
1200: -- |---------------------------< delete_validate >----------------------------|

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

1203: --
1204: l_proc varchar2(72) := g_package||'delete_validate';
1205: --
1206: Begin
1207: hr_utility.set_location('Entering:'||l_proc, 5);
1208: --
1209: -- Call all supporting business operations
1210: --
1211: chk_startup_action(False

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

1211: chk_startup_action(False
1212: ,ben_xcv_shd.g_old_rec.business_group_id
1213: ,ben_xcv_shd.g_old_rec.legislation_code);
1214: --
1215: hr_utility.set_location(' Leaving:'||l_proc, 10);
1216: End delete_validate;
1217: --
1218: --
1219: -- ---------------------------------------------------------------------------

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

1238: l_proc varchar2(72) := g_package||'return_legislation_code';
1239: --
1240: begin
1241: --
1242: hr_utility.set_location('Entering:'|| l_proc, 10);
1243: --
1244: -- Ensure that all the mandatory parameter are not null
1245: --
1246: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1263: end if;
1264: --
1265: close csr_leg_code;
1266: --
1267: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1268: --
1269: return l_legislation_code;
1270: --
1271: end return_legislation_code;