DBA Data[Home] [Help]

APPS.BEN_PTP_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ptp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_typ_id => p_pl_typ_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pl_typ_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_ptp_shd.api_updating
118: (p_pl_typ_id => p_pl_typ_id,
119: p_effective_date => p_effective_date,

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_no_mn_enrl_num_dfnd_flag;
147: --
148: -- ----------------------------------------------------------------------------

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

180: l_api_updating boolean;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_ptp_shd.api_updating
187: (p_pl_typ_id => p_pl_typ_id,
188: p_effective_date => p_effective_date,

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

209: end if;
210: --
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: end chk_no_mx_enrl_num_dfnd_flag;
216: --
217: -- ----------------------------------------------------------------------------

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

249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_ptp_shd.api_updating
256: (p_pl_typ_id => p_pl_typ_id,
257: p_effective_date => p_effective_date,

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

278: end if;
279: --
280: end if;
281: --
282: hr_utility.set_location('Leaving:'||l_proc,10);
283: --
284: end chk_opt_typ_cd;
285: --
286: -- ----------------------------------------------------------------------------

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

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

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

376: --
377: --
378: end if;
379: --
380: hr_utility.set_location('Leaving:'||l_proc,10);
381: --
382: end chk_irec_pln_in_rptg_grp;
383: --
384: -- ----------------------------------------------------------------------------

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

417: l_api_updating boolean;
418: --
419: Begin
420: --
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: l_api_updating := ben_ptp_shd.api_updating
424: (p_pl_typ_id => p_pl_typ_id,
425: p_effective_date => p_effective_date,

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

470: --iRec
471: --
472: end if;
473: --
474: hr_utility.set_location('Leaving:'||l_proc,10);
475: --
476: end chk_opt_dsply_fmt_cd;
477: --
478: -- ----------------------------------------------------------------------------

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

510: l_api_updating boolean;
511: --
512: Begin
513: --
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: l_api_updating := ben_ptp_shd.api_updating
517: (p_pl_typ_id => p_pl_typ_id,
518: p_effective_date => p_effective_date,

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

540: end if;
541: --
542: end if;
543: --
544: hr_utility.set_location('Leaving:'||l_proc,10);
545: --
546: end chk_comp_typ_cd;
547: --
548: -- ----------------------------------------------------------------------------

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

580: l_api_updating boolean;
581: --
582: Begin
583: --
584: hr_utility.set_location('Entering:'||l_proc, 5);
585: --
586: l_api_updating := ben_ptp_shd.api_updating
587: (p_pl_typ_id => p_pl_typ_id,
588: p_effective_date => p_effective_date,

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

609: end if;
610: --
611: end if;
612: --
613: hr_utility.set_location('Leaving:'||l_proc,10);
614: --
615: end chk_pl_typ_stat_cd;
616:
617:

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

671: and p_validation_end_date >= effective_start_date;
672: --
673: Begin
674: --
675: hr_utility.set_location('Entering:'||l_proc, 5);
676: --
677: l_api_updating := ben_ptp_shd.api_updating
678: (p_effective_date => p_effective_date,
679: p_pl_typ_id => p_pl_typ_id,

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

682: if (l_api_updating
683: and p_name <> ben_ptp_shd.g_old_rec.name) or
684: not l_api_updating then
685: --
686: hr_utility.set_location('Entering:'||l_proc, 10);
687: --
688: -- check if this name already exist
689: --
690: open csr_name;

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

703: close csr_name;
704: --
705: end if;
706: --
707: hr_utility.set_location('Leaving:'||l_proc, 20);
708: --
709: End chk_name;
710: --
711:

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

754: l_dummy varchar2(1);
755: --
756: Begin
757: --
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Maximum enrollments allowed nuumber
761: -- >= Minimum enrollments allowed number.
762: -- if both are used.

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

788: fnd_message.raise_error;
789: end if;
790: --
791: --
792: hr_utility.set_location('Leaving:'||l_proc,10);
793: --
794: end chk_mn_mx_num;
795:
796:

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

852:
853: --
854: Begin
855: --
856: hr_utility.set_location('Entering:'||l_proc, 5);
857: --
858: --
859: l_api_updating := ben_ptp_shd.api_updating
860: (p_effective_date => p_effective_date,

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

883: --
884: end if;
885: --
886:
887: hr_utility.set_location('Leaving:'||l_proc,10);
888: --
889: end chk_gsp_opt_typ_cd;
890:
891: --

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

928: l_integrity_error Exception;
929: l_table_name all_tables.table_name%TYPE;
930: --
931: Begin
932: hr_utility.set_location('Entering:'||l_proc, 5);
933: --
934: -- Ensure that the p_datetrack_mode argument is not null
935: --
936: hr_api.mandatory_arg_error

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

958: --
959: --
960: End If;
961: --
962: hr_utility.set_location(' Leaving:'||l_proc, 10);
963: Exception
964: When l_integrity_error Then
965: --
966: -- A referential integrity check was violated therefore

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

1025: l_rows_exist Exception;
1026: l_table_name all_tables.table_name%TYPE;
1027: --
1028: Begin
1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: -- Ensure that the p_datetrack_mode argument is not null
1032: --
1033: hr_api.mandatory_arg_error

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

1089: End If;
1090: --
1091: End If;
1092: --
1093: hr_utility.set_location(' Leaving:'||l_proc, 10);
1094: Exception
1095: When l_rows_exist Then
1096: --
1097: -- A referential integrity check was violated therefore

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

1123: --
1124: l_proc varchar2(72) := g_package||'insert_validate';
1125: --
1126: Begin
1127: hr_utility.set_location('Entering:'||l_proc, 5);
1128: --
1129: -- Call all supporting business operations
1130: --
1131: --

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

1199: --p_validation_end_date
1200: p_business_group_id => p_rec.business_group_id,
1201: p_object_version_number => p_rec.object_version_number ) ;
1202: --
1203: hr_utility.set_location(' Leaving:'||l_proc, 10);
1204: End insert_validate;
1205: --
1206: -- ----------------------------------------------------------------------------
1207: -- |---------------------------< update_validate >----------------------------|

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

1215: --
1216: l_proc varchar2(72) := g_package||'update_validate';
1217: --
1218: Begin
1219: hr_utility.set_location('Entering:'||l_proc, 5);
1220: --
1221: -- Call all supporting business operations
1222: --
1223: --

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

1309: p_datetrack_mode => p_datetrack_mode,
1310: p_validation_start_date => p_validation_start_date,
1311: p_validation_end_date => p_validation_end_date);
1312: --
1313: hr_utility.set_location(' Leaving:'||l_proc, 10);
1314: End update_validate;
1315: --
1316: -- ----------------------------------------------------------------------------
1317: -- |---------------------------< delete_validate >----------------------------|

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

1325: --
1326: l_proc varchar2(72) := g_package||'delete_validate';
1327: --
1328: Begin
1329: hr_utility.set_location('Entering:'||l_proc, 5);
1330: --
1331: -- Call all supporting business operations
1332: --
1333: dt_delete_validate

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

1335: p_validation_start_date => p_validation_start_date,
1336: p_validation_end_date => p_validation_end_date,
1337: p_pl_typ_id => p_rec.pl_typ_id);
1338: --
1339: hr_utility.set_location(' Leaving:'||l_proc, 10);
1340: End delete_validate;
1341: --
1342: --
1343: -- ---------------------------------------------------------------------------

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

1364:
1365: --
1366: begin
1367: --
1368: hr_utility.set_location('Entering:'|| l_proc, 10);
1369: --
1370: -- Ensure that all the mandatory parameter are not null
1371: --
1372: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1389: end if;
1390: --
1391: close csr_leg_code;
1392: --
1393: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1394: --
1395: return l_legislation_code;
1396:
1397: --