DBA Data[Home] [Help]

APPS.BEN_PCD_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_pcd_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_cm_prvdd_id => p_per_cm_prvdd_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_per_cm_prvdd_id;
78: --
79: -- ----------------------------------------------------------------------------

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

117: where a.address_id = p_address_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_pcd_shd.api_updating
124: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
125: p_effective_date => p_effective_date,

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

150: close c1;
151: --
152: end if;
153: --
154: hr_utility.set_location('Leaving:'||l_proc,10);
155: --
156: End chk_address_id;
157: --
158: -- ----------------------------------------------------------------------------

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

192: l_api_updating boolean;
193: --
194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: l_api_updating := ben_pcd_shd.api_updating
199: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
200: p_effective_date => p_effective_date,

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

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

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

254: l_api_updating boolean;
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_pcd_shd.api_updating
261: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
262: p_effective_date => p_effective_date,

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

285: end if;
286: --
287: end if;
288: --
289: hr_utility.set_location('Leaving:'||l_proc,10);
290: --
291: end chk_cm_dlvry_mthd_cd;
292: --
293:

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

326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ben_pcd_shd.api_updating
333: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
334: p_effective_date => p_effective_date,

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

357: end if;
358: --
359: end if;
360: --
361: hr_utility.set_location('Leaving:'||l_proc,10);
362: --
363: end chk_cm_dlvry_med_cd;
364: --
365: -- ----------------------------------------------------------------------------

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

397: l_api_updating boolean;
398: --
399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ben_pcd_shd.api_updating
404: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
405: p_effective_date => p_effective_date,

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

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

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

469: l_api_updating boolean;
470: --
471: Begin
472: --
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: l_api_updating := ben_pcd_shd.api_updating
476: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
477: p_effective_date => p_effective_date,

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

500: end if;
501: --
502: end if;
503: --
504: hr_utility.set_location('Leaving:'||l_proc,10);
505: --
506: end chk_resnd_rsn_cd;
507: -- ----------------------------------------------------------------------------
508: -- |------< chk_inspn_rqd_flag >------|

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

539: l_api_updating boolean;
540: --
541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_pcd_shd.api_updating
546: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
547: p_effective_date => p_effective_date,

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

570: end if;
571: --
572: end if;
573: --
574: hr_utility.set_location('Leaving:'||l_proc,10);
575: --
576: end chk_inspn_rqd_flag;
577: --
578: -- ----------------------------------------------------------------------------

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

610: l_api_updating boolean;
611: --
612: Begin
613: --
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: l_api_updating := ben_pcd_shd.api_updating
617: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
618: p_effective_date => p_effective_date,

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

641: end if;
642: --
643: end if;
644: --
645: hr_utility.set_location('Leaving:'||l_proc,10);
646: --
647: end chk_rqstd_flag;
648: --
649: -- ----------------------------------------------------------------------------

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

685: l_integrity_error Exception;
686: l_table_name all_tables.table_name%TYPE;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Ensure that the p_datetrack_mode argument is not null
692: --
693: hr_api.mandatory_arg_error

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

724: End If;
725: --
726: End If;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: Exception
730: When l_integrity_error Then
731: --
732: -- A referential integrity check was violated therefore

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

790: l_rows_exist Exception;
791: l_table_name all_tables.table_name%TYPE;
792: --
793: Begin
794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: -- Ensure that the p_datetrack_mode argument is not null
797: --
798: hr_api.mandatory_arg_error

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

827: --
828: --
829: End If;
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: Exception
833: When l_rows_exist Then
834: --
835: -- A referential integrity check was violated therefore

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

859: --
860: l_proc varchar2(72) := g_package||'insert_validate';
861: --
862: Begin
863: hr_utility.set_location('Entering:'||l_proc, 5);
864: --
865: -- Call all supporting business operations
866: --
867: --

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

925: p_rqstd_flag => p_rec.rqstd_flag,
926: p_effective_date => p_effective_date,
927: p_object_version_number => p_rec.object_version_number);
928: --
929: hr_utility.set_location(' Leaving:'||l_proc, 10);
930: End insert_validate;
931: --
932: -- ----------------------------------------------------------------------------
933: -- |---------------------------< update_validate >----------------------------|

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

941: --
942: l_proc varchar2(72) := g_package||'update_validate';
943: --
944: Begin
945: hr_utility.set_location('Entering:'||l_proc, 5);
946: --
947: -- Call all supporting business operations
948: --
949: --

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

1004: p_datetrack_mode => p_datetrack_mode,
1005: p_validation_start_date => p_validation_start_date,
1006: p_validation_end_date => p_validation_end_date);
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: End update_validate;
1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< delete_validate >----------------------------|

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

1020: --
1021: l_proc varchar2(72) := g_package||'delete_validate';
1022: --
1023: Begin
1024: hr_utility.set_location('Entering:'||l_proc, 5);
1025: --
1026: -- Call all supporting business operations
1027: --
1028: dt_delete_validate

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

1030: p_validation_start_date => p_validation_start_date,
1031: p_validation_end_date => p_validation_end_date,
1032: p_per_cm_prvdd_id => p_rec.per_cm_prvdd_id);
1033: --
1034: hr_utility.set_location(' Leaving:'||l_proc, 10);
1035: End delete_validate;
1036: --
1037: --
1038: -- ---------------------------------------------------------------------------

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

1057: l_proc varchar2(72) := g_package||'return_legislation_code';
1058: --
1059: begin
1060: --
1061: hr_utility.set_location('Entering:'|| l_proc, 10);
1062: --
1063: -- Ensure that all the mandatory parameter are not null
1064: --
1065: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1082: end if;
1083: --
1084: close csr_leg_code;
1085: --
1086: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1087: --
1088: return l_legislation_code;
1089: --
1090: end return_legislation_code;