DBA Data[Home] [Help]

APPS.BEN_CLF_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_clf_shd.api_updating
47: (p_comp_lvl_fctr_id => p_comp_lvl_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_comp_lvl_fctr_id;
75: --
76: -- ----------------------------------------------------------------------------

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

115: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id;
116: --
117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: l_api_updating := ben_clf_shd.api_updating
122: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
123: 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_defined_balance_id;
151: -- ----------------------------------------------------------------------------
152: -- |------< chk_rndg_rl >------|

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

201: and ff.effective_end_date;
202: --
203: Begin
204: --
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: l_api_updating := ben_clf_shd.api_updating
208: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
209: p_object_version_number => p_object_version_number);

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

250: --
251: end if;
252: --
253: --
254: hr_utility.set_location('Leaving:'||l_proc,10);
255: --
256: end chk_rndg_rl;
257: --
258: -- ----------------------------------------------------------------------------

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

290: l_api_updating boolean;
291: --
292: Begin
293: --
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: l_api_updating := ben_clf_shd.api_updating
297: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
298: p_object_version_number => p_object_version_number);

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

318: end if;
319: --
320: end if;
321: --
322: hr_utility.set_location('Leaving:'||l_proc,10);
323: --
324: end chk_rndg_cd;
325: --
326: -- ----------------------------------------------------------------------------

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

376: and ff.effective_end_date;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := ben_clf_shd.api_updating
383: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
384: p_object_version_number => p_object_version_number);

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

427: fnd_message.raise_error;
428: --
429: end if;
430: --
431: hr_utility.set_location('Leaving:'||l_proc,10);
432: --
433: end chk_comp_lvl_det_rl;
434: --
435: -- ----------------------------------------------------------------------------

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

467: l_api_updating boolean;
468: --
469: Begin
470: --
471: hr_utility.set_location('Entering:'||l_proc, 5);
472: --
473: l_api_updating := ben_clf_shd.api_updating
474: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
475: p_object_version_number => p_object_version_number);

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

495: end if;
496: --
497: end if;
498: --
499: hr_utility.set_location('Leaving:'||l_proc,10);
500: --
501: end chk_no_mx_comp_flag;
502: --
503: -- ----------------------------------------------------------------------------

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

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

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

563: end if;
564: --
565: end if;
566: --
567: hr_utility.set_location('Leaving:'||l_proc,10);
568: --
569: end chk_no_mn_comp_flag;
570: --
571: -- ----------------------------------------------------------------------------

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

603: l_api_updating boolean;
604: --
605: Begin
606: --
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: l_api_updating := ben_clf_shd.api_updating
610: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
611: p_object_version_number => p_object_version_number);

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

631: end if;
632: --
633: end if;
634: --
635: hr_utility.set_location('Leaving:'||l_proc,10);
636: --
637: end chk_comp_src_cd;
638: --
639: -- ----------------------------------------------------------------------------

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

679: l_dummy varchar2(30);
680: --
681: Begin
682: --
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: --
685: l_api_updating := ben_clf_shd.api_updating
686: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
687: p_object_version_number => p_object_version_number);

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

718: close c1;
719: --
720: end if;
721: --
722: hr_utility.set_location('Leaving:'||l_proc,10);
723: --
724: end chk_comp_lvl_uom;
725: --
726: --

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

759: l_api_updating boolean;
760: --
761: Begin
762: --
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: l_api_updating := ben_clf_shd.api_updating
766: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
767: p_object_version_number => p_object_version_number);

Line 784: -- Bug 4129562 : Replaced hr_utility calls by fnd_message

780: p_effective_date => p_effective_date) then
781: --
782: -- raise error as does not exist as lookup
783: --
784: -- Bug 4129562 : Replaced hr_utility calls by fnd_message
785: --
786: -- hr_utility.set_message('BEN','BEN_91268_INV_COMP_LVL_DET_CD');
787: -- hr_utility.raise_error;
788: fnd_message.set_name('BEN','BEN_91268_INV_COMP_LVL_DET_CD');

Line 786: -- hr_utility.set_message('BEN','BEN_91268_INV_COMP_LVL_DET_CD');

782: -- raise error as does not exist as lookup
783: --
784: -- Bug 4129562 : Replaced hr_utility calls by fnd_message
785: --
786: -- hr_utility.set_message('BEN','BEN_91268_INV_COMP_LVL_DET_CD');
787: -- hr_utility.raise_error;
788: fnd_message.set_name('BEN','BEN_91268_INV_COMP_LVL_DET_CD');
789: fnd_message.raise_error;
790: --

Line 787: -- hr_utility.raise_error;

783: --
784: -- Bug 4129562 : Replaced hr_utility calls by fnd_message
785: --
786: -- hr_utility.set_message('BEN','BEN_91268_INV_COMP_LVL_DET_CD');
787: -- hr_utility.raise_error;
788: fnd_message.set_name('BEN','BEN_91268_INV_COMP_LVL_DET_CD');
789: fnd_message.raise_error;
790: --
791: end if;

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: end chk_comp_lvl_det_cd;
797: --
798: -- ----------------------------------------------------------------------------
799: -- |------< chk_sttd_sal_prdcty_cd >------|

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

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

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

860: end if;
861: --
862: end if;
863: --
864: hr_utility.set_location('Leaving:'||l_proc,10); --
865: end chk_sttd_sal_prdcty_cd;
866: --
867: -- ----------------------------------------------------------------------------
868: -- |-----------------< chk_comp_alt_val_to_use_cd >--------------------------|

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

899: l_api_updating boolean;
900: --
901: Begin
902: --
903: hr_utility.set_location('Entering:'||l_proc, 5);
904: --
905: l_api_updating := ben_clf_shd.api_updating
906: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
907: p_object_version_number => p_object_version_number);

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

929: end if;
930: --
931: end if;
932: --
933: hr_utility.set_location('Leaving:'||l_proc,10); --
934: end chk_comp_alt_val_to_use_cd;
935: --
936: -- ----------------------------------------------------------------------------
937: -- |---------------------< chk_comp_calc_rl >------------------------------|

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

985: and ff.effective_end_date;
986: --
987: Begin
988: --
989: hr_utility.set_location('Entering:'||l_proc, 5);
990: --
991: l_api_updating := ben_clf_shd.api_updating
992: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
993: p_object_version_number => p_object_version_number);

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

1022: close c1;
1023: --
1024: end if;
1025: --
1026: hr_utility.set_location('Leaving:'||l_proc,10);
1027: --
1028: end chk_comp_calc_rl;
1029: --
1030: ------------------------------------------------------------------------

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

1072: where clf.business_group_id = p_business_group_id and
1073: clf.name = p_name;
1074: Begin
1075: --
1076: hr_utility.set_location('Entering:'||l_proc, 5);
1077: --
1078: l_api_updating := ben_clf_shd.api_updating
1079: (p_comp_lvl_fctr_id => p_comp_lvl_fctr_id,
1080: -- p_effective_date => p_effective_date,

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

1108: --
1109: close c1;
1110: end if;
1111: --
1112: hr_utility.set_location('Leaving:'||l_proc,10);
1113: --
1114: end chk_name;
1115: --
1116: -----------------------------------------------------------------------------

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

1145: l_date date;
1146: --
1147: Begin
1148: --
1149: hr_utility.set_location('Entering:'||l_proc, 5);
1150: hr_utility.set_location('p_day_mo '||p_day_mo, 5);
1151: hr_utility.set_location('p_year '||p_year, 5);
1152: --
1153: if p_day_mo is null then

Line 1150: hr_utility.set_location('p_day_mo '||p_day_mo, 5);

1146: --
1147: Begin
1148: --
1149: hr_utility.set_location('Entering:'||l_proc, 5);
1150: hr_utility.set_location('p_day_mo '||p_day_mo, 5);
1151: hr_utility.set_location('p_year '||p_year, 5);
1152: --
1153: if p_day_mo is null then
1154: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1151: hr_utility.set_location('p_year '||p_year, 5);

1147: Begin
1148: --
1149: hr_utility.set_location('Entering:'||l_proc, 5);
1150: hr_utility.set_location('p_day_mo '||p_day_mo, 5);
1151: hr_utility.set_location('p_year '||p_year, 5);
1152: --
1153: if p_day_mo is null then
1154: hr_api.mandatory_arg_error(p_api_name => l_proc,
1155: p_argument => p_label,

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

1156: p_argument_value => '');
1157: end if;
1158: l_date := to_date(substr('0'||p_day_mo,-4)||l_year,'ddmmyyyy');
1159: --
1160: hr_utility.set_location('Leaving:'||l_proc,10);
1161: Exception
1162: when others then
1163: fnd_message.set_name('BEN','BEN_92603_INVALID_DATE');
1164: fnd_message.raise_error;

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

1196: l_date2 date;
1197: --
1198: Begin
1199: --
1200: hr_utility.set_location('Entering:'||l_proc, 5);
1201: --
1202: if p_clf_rec.start_year is not null and
1203: p_clf_rec.end_year is not null then
1204: l_date1 := to_date(substr('0'||p_clf_rec.start_day_mo,-4)||l_start_year,'ddmmyyyy');

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

1211: fnd_message.raise_error;
1212: end if;
1213: end if;
1214: --
1215: hr_utility.set_location('Leaving:'||l_proc,10);
1216:
1217: End chk_date_range;
1218: --
1219: -----------------------------------------------------------------------------

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

1256: l_dummy varchar2(1);
1257: --
1258: Begin
1259: --
1260: hr_utility.set_location('Entering:'||l_proc, 5);
1261: --
1262: -- Minimum compensation value must be < Maximum compensation value ,
1263: -- if both are used.
1264: --

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

1312: fnd_message.raise_error;
1313: --
1314: end if;
1315: --
1316: hr_utility.set_location('Leaving:'||l_proc,10);
1317: --
1318: end chk_mn_mx_comp_val;
1319: --
1320: -------------------------------------------------------------------------------

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

1352: l_proc varchar2(72) := g_package || 'chk_source';
1353: --
1354: Begin
1355: --
1356: hr_utility.set_location('Entering:'||l_proc, 5);
1357: --
1358: -- Defined Balance must be entered if "Balance Type" is selected for
1359: -- Source.
1360: --

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

1369: fnd_message.raise_error;
1370: --
1371: end if;
1372: --
1373: hr_utility.set_location('Leaving:'||l_proc,10);
1374: --
1375: end chk_source;
1376: --
1377: -- Bug 2978945 begin

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

1407:
1408:
1409: begin
1410: --
1411: hr_utility.set_location('Entering:'||l_proc, 5);
1412:
1413: --Used in Standard Rates
1414: If (ben_batch_utils.rows_exist
1415: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',

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

1474: )) Then
1475: ben_utility.child_exists_error('BEN_BNFT_PRVDR_POOL_F');
1476: End If;
1477:
1478: hr_utility.set_location('Leaving:'||l_proc,10);
1479: --
1480: end chk_child_records;
1481:
1482: -- Bug 2978945 end

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

1489: --
1490: l_proc varchar2(72) := g_package||'insert_validate';
1491: --
1492: Begin
1493: hr_utility.set_location('Entering:'||l_proc, 5);
1494: --
1495: -- Call all supporting business operations
1496: --
1497: --

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

1612: chk_date_range
1613: (p_clf_rec => p_rec);
1614: end if;
1615: --
1616: hr_utility.set_location(' Leaving:'||l_proc, 10);
1617: End insert_validate;
1618: --
1619: -- ----------------------------------------------------------------------------
1620: -- |---------------------------< update_validate >----------------------------|

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

1624: --
1625: l_proc varchar2(72) := g_package||'update_validate';
1626: --
1627: Begin
1628: hr_utility.set_location('Entering:'||l_proc, 5);
1629: --
1630: -- Call all supporting business operations
1631: --
1632: --

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

1749: chk_date_range
1750: (p_clf_rec => p_rec);
1751: end if;
1752: --
1753: hr_utility.set_location(' Leaving:'||l_proc, 10);
1754: End update_validate;
1755: --
1756: -- ----------------------------------------------------------------------------
1757: -- |---------------------------< delete_validate >----------------------------|

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

1761: --
1762: l_proc varchar2(72) := g_package||'delete_validate';
1763: --
1764: Begin
1765: hr_utility.set_location('Entering:'||l_proc, 5);
1766: --
1767: -- Call all supporting business operations
1768: --
1769:

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

1768: --
1769:
1770: chk_child_records(p_comp_lvl_fctr_id => p_rec.comp_lvl_fctr_id); -- Bug 2978945
1771:
1772: hr_utility.set_location(' Leaving:'||l_proc, 10);
1773: End delete_validate;
1774: --
1775: --
1776: -- ---------------------------------------------------------------------------

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

1795: l_proc varchar2(72) := g_package||'return_legislation_code';
1796: --
1797: begin
1798: --
1799: hr_utility.set_location('Entering:'|| l_proc, 10);
1800: --
1801: -- Ensure that all the mandatory parameter are not null
1802: --
1803: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1820: end if;
1821: --
1822: close csr_leg_code;
1823: --
1824: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1825: --
1826: return l_legislation_code;
1827: --
1828: end return_legislation_code;