DBA Data[Home] [Help]

APPS.BEN_AGF_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_agf_shd.api_updating
47: (p_age_fctr_id => p_age_fctr_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_age_fctr_id;
75: --
76: /*

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

113: where a.organization_id = p_organization_id;
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc,5);
118: --
119: l_api_updating := ben_agf_shd.api_updating
120: (p_age_fctr_id => p_age_fctr_id,
121: p_object_version_number => p_object_version_number);

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

144: close c1;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: End chk_organization_id;
151: */
152: --

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

185: l_api_updating boolean;
186: --
187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_agf_shd.api_updating
192: (p_age_fctr_id => p_age_fctr_id,
193: p_object_version_number => p_object_version_number);

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

215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_age_to_use_cd;
222: --
223: -- ----------------------------------------------------------------------------

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

257: l_api_updating boolean;
258: --
259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_agf_shd.api_updating
264: (p_age_fctr_id => p_age_fctr_id,
265: p_object_version_number => p_object_version_number);

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

302: fnd_message.raise_error;
303: --
304: end if;
305: --
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: end chk_rndg_rl;
309: --
310: -- ----------------------------------------------------------------------------

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

343: l_api_updating boolean;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: l_api_updating := ben_agf_shd.api_updating
350: (p_age_fctr_id => p_age_fctr_id,
351: p_object_version_number => p_object_version_number);

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

374: end if;
375: --
376: end if;
377: --
378: hr_utility.set_location('Leaving:'||l_proc,10);
379: --
380: end chk_age_calc_rl;
381: -- ----------------------------------------------------------------------------
382: -- |-----------------------------< chk_age_code_rule >------------------------|

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

408: l_proc varchar2(72) := g_package||'chk_age_code_rule';
409: --
410: Begin
411: --
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: --
414: if p_age_to_use_cd is null and
415: p_age_calc_rl is null or
416: p_age_to_use_cd is not null and

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

422: fnd_message.raise_error;
423: --
424: end if;
425: --
426: hr_utility.set_location('Leaving:'||l_proc,10);
427: --
428: end chk_age_code_rule;
429: -- ----------------------------------------------------------------------------
430: -- |------< chk_rndg_cd >------|

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

461: l_api_updating boolean;
462: --
463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_agf_shd.api_updating
468: (p_age_fctr_id => p_age_fctr_id,
469: p_object_version_number => p_object_version_number);

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

491: end if;
492: --
493: end if;
494: --
495: hr_utility.set_location('Leaving:'||l_proc,10);
496: --
497: end chk_rndg_cd;
498: --
499: -- ----------------------------------------------------------------------------

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

534: l_api_updating boolean;
535: --
536: Begin
537: --
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: l_api_updating := ben_agf_shd.api_updating
541: (p_age_fctr_id => p_age_fctr_id,
542: p_object_version_number => p_object_version_number);

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

581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: hr_utility.set_location('Leaving:'||l_proc,10);
586: --
587: end chk_age_det_rl;
588: --
589: -- ----------------------------------------------------------------------------

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

621: l_api_updating boolean;
622: --
623: Begin
624: --
625: hr_utility.set_location('Entering:'||l_proc, 5);
626: --
627: l_api_updating := ben_agf_shd.api_updating
628: (p_age_fctr_id => p_age_fctr_id,
629: p_object_version_number => p_object_version_number);

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

651: end if;
652: --
653: end if;
654: --
655: hr_utility.set_location('Leaving:'||l_proc,10);
656: --
657: end chk_age_det_cd;
658: --
659: -- ----------------------------------------------------------------------------

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

691: l_api_updating boolean;
692: --
693: Begin
694: --
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: l_api_updating := ben_agf_shd.api_updating
698: (p_age_fctr_id => p_age_fctr_id,
699: p_object_version_number => p_object_version_number);

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

721: end if;
722: --
723: end if;
724: --
725: hr_utility.set_location('Leaving:'||l_proc,10);
726: --
727: end chk_no_mx_age_flag;
728: --
729: -- ----------------------------------------------------------------------------

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

761: l_api_updating boolean;
762: --
763: Begin
764: --
765: hr_utility.set_location('Entering:'||l_proc, 5);
766: --
767: l_api_updating := ben_agf_shd.api_updating
768: (p_age_fctr_id => p_age_fctr_id,
769: p_object_version_number => p_object_version_number);

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

791: end if;
792: --
793: end if;
794: --
795: hr_utility.set_location('Leaving:'||l_proc,10);
796: --
797: end chk_no_mn_age_flag;
798: --
799: -- ----------------------------------------------------------------------------

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

831: l_api_updating boolean;
832: --
833: Begin
834: --
835: hr_utility.set_location('Entering:'||l_proc, 5);
836: --
837: l_api_updating := ben_agf_shd.api_updating
838: (p_age_fctr_id => p_age_fctr_id,
839: p_object_version_number => p_object_version_number);

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

861: end if;
862: --
863: end if;
864: --
865: hr_utility.set_location('Leaving:'||l_proc,10);
866: --
867: end chk_age_uom;
868: --
869: ------------------------------------------------------------------------

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

909: l_dummy varchar2(1);
910: --
911: Begin
912: --
913: hr_utility.set_location('Entering:'||l_proc, 5);
914: --
915: -- Minimum Age Number must be < Maximum Age Number,
916: -- if both are used.
917: --

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

960: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
961: fnd_message.raise_error;
962: end if;
963: --
964: hr_utility.set_location('Leaving:'||l_proc,10);
965: --
966: end chk_mn_mx_age_num;
967: ------------------------------------------------------------------------
968: ----

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

1009: where agf.business_group_id = p_business_group_id and
1010: agf.name = p_name;
1011: Begin
1012: --
1013: hr_utility.set_location('Entering:'||l_proc, 5);
1014: --
1015: l_api_updating := ben_agf_shd.api_updating
1016: (p_age_fctr_id => p_age_fctr_id,
1017: -- p_effective_date => p_effective_date,

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

1044: --
1045: close c1;
1046: end if;
1047: --
1048: hr_utility.set_location('Leaving:'||l_proc,10);
1049: --
1050: end chk_name;
1051: --
1052:

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

1084: where cla.age_fctr_id = p_age_fctr_id;
1085:
1086: begin
1087: --
1088: hr_utility.set_location('Entering:'||l_proc, 5);
1089: --
1090: -- check if age factor record exists in the ben_cmbn_age_los_fctr table
1091: --
1092: /* open chk_cmbn_age_los_fctr;

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

1150:
1151:
1152: --Bug 2978945
1153:
1154: hr_utility.set_location('Leaving:'||l_proc,10);
1155: --
1156:
1157: end chk_child_records;
1158:

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

1167: --
1168: l_proc varchar2(72) := g_package||'insert_validate';
1169: --
1170: Begin
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: --
1173: -- Call all supporting business operations
1174: --
1175: --

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

1263: chk_age_code_rule
1264: (p_age_to_use_cd => p_rec.age_to_use_cd,
1265: p_age_calc_rl => p_rec.age_calc_rl);
1266: --
1267: hr_utility.set_location(' Leaving:'||l_proc, 10);
1268: End insert_validate;
1269: --
1270: -- ----------------------------------------------------------------------------
1271: -- |---------------------------< update_validate >----------------------------|

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

1275: --
1276: l_proc varchar2(72) := g_package||'update_validate';
1277: --
1278: Begin
1279: hr_utility.set_location('Entering:'||l_proc, 5);
1280: --
1281: -- Call all supporting business operations
1282: --
1283: --

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

1371: chk_age_code_rule
1372: (p_age_to_use_cd => p_rec.age_to_use_cd,
1373: p_age_calc_rl => p_rec.age_calc_rl);
1374: --
1375: hr_utility.set_location(' Leaving:'||l_proc, 10);
1376: End update_validate;
1377: --
1378: -- ----------------------------------------------------------------------------
1379: -- |---------------------------< delete_validate >----------------------------|

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

1383: --
1384: l_proc varchar2(72) := g_package||'delete_validate';
1385: --
1386: Begin
1387: hr_utility.set_location('Entering:'||l_proc, 5);
1388: --
1389: -- Call all supporting business operations
1390: chk_child_records(p_age_fctr_id => p_rec.age_fctr_id);
1391: --

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

1388: --
1389: -- Call all supporting business operations
1390: chk_child_records(p_age_fctr_id => p_rec.age_fctr_id);
1391: --
1392: hr_utility.set_location(' Leaving:'||l_proc, 10);
1393: End delete_validate;
1394: --
1395: --
1396: -- ---------------------------------------------------------------------------

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

1415: l_proc varchar2(72) := g_package||'return_legislation_code';
1416: --
1417: begin
1418: --
1419: hr_utility.set_location('Entering:'|| l_proc, 10);
1420: --
1421: -- Ensure that all the mandatory parameter are not null
1422: --
1423: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1433: close csr_leg_code;
1434: --
1435: -- The primary key is invalid therefore we must error
1436: --
1437: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1438: hr_utility.raise_error;
1439: --
1440: end if;
1441: --

Line 1438: hr_utility.raise_error;

1434: --
1435: -- The primary key is invalid therefore we must error
1436: --
1437: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1438: hr_utility.raise_error;
1439: --
1440: end if;
1441: --
1442: close csr_leg_code;

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

1440: end if;
1441: --
1442: close csr_leg_code;
1443: --
1444: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1445: --
1446: return l_legislation_code;
1447: --
1448: end return_legislation_code;