DBA Data[Home] [Help]

APPS.BEN_HWF_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_hwf_shd.api_updating
47: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_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_hrs_wkd_in_perd_fctr_id;
75: --
76: -- ----------------------------------------------------------------------------

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

108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_hwf_shd.api_updating
115: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
116: p_object_version_number => p_object_version_number);

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

136: end if;
137: --
138: end if;
139: --
140: hr_utility.set_location('Leaving:'||l_proc,10);
141: --
142: end chk_once_r_cntug_cd;
143: --
144: --

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

177: l_api_updating boolean;
178: --
179: Begin
180: --
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: l_api_updating := ben_hwf_shd.api_updating
184: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
185: p_object_version_number => p_object_version_number);

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

205: end if;
206: --
207: end if;
208: --
209: hr_utility.set_location('Leaving:'||l_proc,10);
210: --
211: end chk_no_mx_hrs_wkd_flag;
212: -- ----------------------------------------------------------------------------
213: -- |------< chk_no_mn_hrs_wkd_flag >------|

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

244: l_api_updating boolean;
245: --
246: Begin
247: --
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: l_api_updating := ben_hwf_shd.api_updating
251: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
252: p_object_version_number => p_object_version_number);

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

272: end if;
273: --
274: end if;
275: --
276: hr_utility.set_location('Leaving:'||l_proc,10);
277: --
278: end chk_no_mn_hrs_wkd_flag;
279: --
280: -- ----------------------------------------------------------------------------

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

330: and ff.effective_end_date;
331: --
332: Begin
333: --
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: l_api_updating := ben_hwf_shd.api_updating
337: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
338: p_object_version_number => p_object_version_number);

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

378: fnd_message.raise_error;
379: --
380: end if;
381: --
382: hr_utility.set_location('Leaving:'||l_proc,10);
383: --
384: end chk_hrs_wkd_det_rl;
385: --
386: -- ----------------------------------------------------------------------------

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

418: l_api_updating boolean;
419: --
420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_hwf_shd.api_updating
425: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
426: p_object_version_number => p_object_version_number);

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

446: end if;
447: --
448: end if;
449: --
450: hr_utility.set_location('Leaving:'||l_proc,10);
451: --
452: end chk_hrs_wkd_det_cd;
453: --
454: -- ----------------------------------------------------------------------------

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

504: and ff.effective_end_date;
505: --
506: Begin
507: --
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: l_api_updating := ben_hwf_shd.api_updating
511: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
512: p_object_version_number => p_object_version_number);

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

553: --
554: end if;
555: --
556: --
557: hr_utility.set_location('Leaving:'||l_proc,10);
558: --
559: end chk_rndg_rl;
560: --
561: -- ----------------------------------------------------------------------------

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

593: l_api_updating boolean;
594: --
595: Begin
596: --
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: l_api_updating := ben_hwf_shd.api_updating
600: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
601: p_object_version_number => p_object_version_number);

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

621: end if;
622: --
623: end if;
624: --
625: hr_utility.set_location('Leaving:'||l_proc,10);
626: --
627: end chk_rndg_cd;
628: --
629: -- ----------------------------------------------------------------------------

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

661: l_api_updating boolean;
662: --
663: Begin
664: --
665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: l_api_updating := ben_hwf_shd.api_updating
668: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
669: p_object_version_number => p_object_version_number);

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

689: end if;
690: --
691: end if;
692: --
693: hr_utility.set_location('Leaving:'||l_proc,10);
694: --
695: end chk_hrs_src_cd;
696: --
697: -- ----------------------------------------------------------------------------

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

729: l_api_updating boolean;
730: --
731: Begin
732: --
733: hr_utility.set_location('Entering:'||l_proc, 5);
734: --
735: l_api_updating := ben_hwf_shd.api_updating
736: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
737: p_object_version_number => p_object_version_number);

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

759: end if;
760: --
761: end if;
762: --
763: hr_utility.set_location('Leaving:'||l_proc,10); --
764: end chk_hrs_alt_val_to_use_cd;
765: --
766: -- ----------------------------------------------------------------------------
767: -- |-----------------< chk_pyrl_freq_cd >--------------------------|

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

798: l_api_updating boolean;
799: --
800: Begin
801: --
802: hr_utility.set_location('Entering:'||l_proc, 5);
803: --
804: l_api_updating := ben_hwf_shd.api_updating
805: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
806: p_object_version_number => p_object_version_number);

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

828: end if;
829: --
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10); --
833: end chk_pyrl_freq_cd;
834: --
835: -- ----------------------------------------------------------------------------
836: -- |---------------------< chk_hrs_wkd_calc_rl >------------------------------|

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

884: and ff.effective_end_date;
885: --
886: Begin
887: --
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: --
890: l_api_updating := ben_hwf_shd.api_updating
891: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
892: p_object_version_number => p_object_version_number);

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

921: close c1;
922: --
923: end if;
924: --
925: hr_utility.set_location('Leaving:'||l_proc,10);
926: --
927: end chk_hrs_wkd_calc_rl;
928: --
929: ------------------------------------------------------------------------

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

971: where hwf.business_group_id = p_business_group_id and
972: hwf.name = p_name;
973: Begin
974: --
975: hr_utility.set_location('Entering:'||l_proc, 5);
976: --
977: l_api_updating := ben_hwf_shd.api_updating
978: (p_hrs_wkd_in_perd_fctr_id => p_hrs_wkd_in_perd_fctr_id,
979: -- p_effective_date => p_effective_date,

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

1007: --
1008: close c1;
1009: end if;
1010: --
1011: hr_utility.set_location('Leaving:'||l_proc,10);
1012: --
1013: end chk_name;
1014: --
1015: ------------------------------------------------------------------------

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

1056: l_dummy varchar2(1);
1057: --
1058: Begin
1059: --
1060: hr_utility.set_location('Entering:'||l_proc, 5);
1061: --
1062: -- Minimum hours Number must be < Maximum hours Number,
1063: -- if both are used.
1064: --

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

1111: --
1112: end if;
1113:
1114: --
1115: hr_utility.set_location('Leaving:'||l_proc,10);
1116: --
1117: end chk_mn_mx_hrs_num;
1118: --
1119: -------------------------------------------------------------------------------

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

1150: l_proc varchar2(72) := g_package || 'chk_source';
1151: --
1152: Begin
1153: --
1154: hr_utility.set_location('Entering:'||l_proc, 5);
1155: --
1156: -- Defined Balance must be entered if "Balance Type" is selected for
1157: -- Source.
1158: --

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

1167: fnd_message.raise_error;
1168: --
1169: end if;
1170: --
1171: hr_utility.set_location('Leaving:'||l_proc,10);
1172: --
1173: end chk_source;
1174: --
1175: --Bug 2978945 begin

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

1202: l_proc varchar2(72):= g_package||'chk_child_records';
1203:
1204: begin
1205: --
1206: hr_utility.set_location('Entering:'||l_proc, 5);
1207:
1208: --Used in eligibility profiles
1209: If (ben_batch_utils.rows_exist
1210: (p_base_table_name => 'BEN_ELIG_HRS_WKD_PRTE_F',

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

1222: )) Then
1223: ben_utility.child_exists_error('BEN_HRS_WKD_IN_PERD_RT_F');
1224: End If;
1225:
1226: hr_utility.set_location('Leaving:'||l_proc,10);
1227: --
1228: end chk_child_records;
1229:
1230: --Bug 2978945

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

1237: --
1238: l_proc varchar2(72) := g_package||'insert_validate';
1239: --
1240: Begin
1241: hr_utility.set_location('Entering:'||l_proc, 5);
1242: --
1243: -- Call all supporting business operations
1244: --
1245: --

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

1340: (p_hrs_src_cd => p_rec.hrs_src_cd,
1341: p_defined_balance_id => p_rec.defined_balance_id,
1342: p_bnfts_bal_id => p_rec.bnfts_bal_id);
1343: --
1344: hr_utility.set_location(' Leaving:'||l_proc, 10);
1345: End insert_validate;
1346: --
1347: -- ----------------------------------------------------------------------------
1348: -- |---------------------------< update_validate >----------------------------|

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

1352: --
1353: l_proc varchar2(72) := g_package||'update_validate';
1354: --
1355: Begin
1356: hr_utility.set_location('Entering:'||l_proc, 5);
1357: --
1358: -- Call all supporting business operations
1359: --
1360: --

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

1455: (p_hrs_src_cd => p_rec.hrs_src_cd,
1456: p_defined_balance_id => p_rec.defined_balance_id,
1457: p_bnfts_bal_id => p_rec.bnfts_bal_id);
1458: --
1459: hr_utility.set_location(' Leaving:'||l_proc, 10);
1460: End update_validate;
1461: --
1462: -- ----------------------------------------------------------------------------
1463: -- |---------------------------< delete_validate >----------------------------|

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

1467: --
1468: l_proc varchar2(72) := g_package||'delete_validate';
1469: --
1470: Begin
1471: hr_utility.set_location('Entering:'||l_proc, 5);
1472: --
1473: -- Call all supporting business operations
1474: --
1475: chk_child_records(p_hrs_wkd_in_perd_fctr_id => p_rec.hrs_wkd_in_perd_fctr_id); --Bug 2978945

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

1472: --
1473: -- Call all supporting business operations
1474: --
1475: chk_child_records(p_hrs_wkd_in_perd_fctr_id => p_rec.hrs_wkd_in_perd_fctr_id); --Bug 2978945
1476: hr_utility.set_location(' Leaving:'||l_proc, 10);
1477: End delete_validate;
1478: --
1479: --
1480: -- ---------------------------------------------------------------------------

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

1499: l_proc varchar2(72) := g_package||'return_legislation_code';
1500: --
1501: begin
1502: --
1503: hr_utility.set_location('Entering:'|| l_proc, 10);
1504: --
1505: -- Ensure that all the mandatory parameter are not null
1506: --
1507: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1524: end if;
1525: --
1526: close csr_leg_code;
1527: --
1528: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1529: --
1530: return l_legislation_code;
1531: --
1532: end return_legislation_code;