DBA Data[Home] [Help]

APPS.BEN_ETP_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_etp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_TTL_PRTT_PRTE_id => p_ELIG_TTL_PRTT_PRTE_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_ELIG_TTL_PRTT_PRTE_id;
78: --
79: -- ---------------------------------------------------------------------------

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

119: and ordr_num = p_ordr_num
120: and business_group_id = p_business_group_id;
121: --
122: Begin
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then

Line 134: hr_utility.set_location('Leaving:'||l_proc, 15);

130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136:
137: --
138: -- ----------------------------------------------------------------------------

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

179: and ff.effective_end_date;
180: --
181: Begin
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := ben_etp_shd.api_updating
186: (p_ELIG_TTL_PRTT_PRTE_id => p_ELIG_TTL_PRTT_PRTE_id,
187: p_effective_date => p_effective_date,

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

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

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

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

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

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

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_etp_shd.api_updating
333: (p_ELIG_TTL_PRTT_PRTE_id => p_ELIG_TTL_PRTT_PRTE_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_no_mx_prtt_num_apls_flag;
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_etp_shd.api_updating
404: (p_ELIG_TTL_PRTT_PRTE_id => p_ELIG_TTL_PRTT_PRTE_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_no_mn_prtt_num_apls_flag;
435: --
436: -- ----------------------------------------------------------------------------

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

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

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

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

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

535: l_proc varchar2(72) := g_package||'chk_flag_and_val';
536: --
537: Begin
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: if p_flag = 'Y' and p_val is not null then
542: fnd_message.set_name('BEN', p_msg);
543: fnd_message.raise_error;

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

542: fnd_message.set_name('BEN', p_msg);
543: fnd_message.raise_error;
544: end if;
545: --
546: hr_utility.set_location('Leaving:'||l_proc,10);
547: --
548: end chk_flag_and_val;
549: --
550: ----------------------------------------------------------------------------

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

589: l_dummy varchar2(1);
590: --
591: Begin
592: --
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: --
595: -- Minimum prtt Number must be < Maximum prtt Number,
596: -- if both are used.
597: --

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

641: fnd_message.raise_error;
642: --
643: end if;
644: --
645: hr_utility.set_location('Leaving:'||l_proc,10);
646: --
647: end chk_mn_mx_prtt_num;
648: -- ----------------------------------------------------------------------------
649: -- |--------------------------< dt_update_validate >--------------------------|

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

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

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

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

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

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

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

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

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

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

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

924: p_eligy_prfl_id => p_rec.eligy_prfl_id,
925: p_ordr_num => p_rec.ordr_num,
926: p_business_group_id => p_rec.business_group_id);
927: --
928: hr_utility.set_location(' Leaving:'||l_proc, 10);
929: End insert_validate;
930: --
931: -- ----------------------------------------------------------------------------
932: -- |---------------------------< update_validate >----------------------------|

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

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

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

1014: p_datetrack_mode => p_datetrack_mode,
1015: p_validation_start_date => p_validation_start_date,
1016: p_validation_end_date => p_validation_end_date);
1017: --
1018: hr_utility.set_location(' Leaving:'||l_proc, 10);
1019: End update_validate;
1020: --
1021: -- ----------------------------------------------------------------------------
1022: -- |---------------------------< delete_validate >----------------------------|

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

1030: --
1031: l_proc varchar2(72) := g_package||'delete_validate';
1032: --
1033: Begin
1034: hr_utility.set_location('Entering:'||l_proc, 5);
1035: --
1036: -- Call all supporting business operations
1037: --
1038: dt_delete_validate

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

1040: p_validation_start_date => p_validation_start_date,
1041: p_validation_end_date => p_validation_end_date,
1042: p_ELIG_TTL_PRTT_PRTE_id => p_rec.ELIG_TTL_PRTT_PRTE_id);
1043: --
1044: hr_utility.set_location(' Leaving:'||l_proc, 10);
1045: End delete_validate;
1046: --
1047: --
1048: -- ---------------------------------------------------------------------------

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

1067: l_proc varchar2(72) := g_package||'return_legislation_code';
1068: --
1069: begin
1070: --
1071: hr_utility.set_location('Entering:'|| l_proc, 10);
1072: --
1073: -- Ensure that all the mandatory parameter are not null
1074: --
1075: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1092: end if;
1093: --
1094: close csr_leg_code;
1095: --
1096: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1097: --
1098: return l_legislation_code;
1099: --
1100: end return_legislation_code;