DBA Data[Home] [Help]

APPS.BEN_ESH_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_esh_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_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_schedd_hrs_prte_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_esh_shd.api_updating
118: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_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_excld_flag;
147:
148: -- ---------------------------------------------------------------------------

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

188: and ordr_num = p_ordr_num
189: and business_group_id = p_business_group_id;
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: open c1;
195: fetch c1 into l_dummy;
196: if c1%found then

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

199: fnd_message.raise_error;
200: end if;
201: close c1;
202: --
203: hr_utility.set_location('Leaving:'||l_proc, 15);
204: End chk_duplicate_ordr_num;
205: --
206:
207: -- ----------------------------------------------------------------------------

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

262: --
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: l_api_updating := ben_esh_shd.api_updating
269: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
270: p_effective_date => p_effective_date,

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

292: close c3;
293: --
294: -- end if;
295: --
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: --
298: end chk_dup_criteria;
299: --
300:

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

340: --
341:
342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: l_api_updating := ben_esh_shd.api_updating
347: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
348: p_effective_date => p_effective_date,

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

374: end if;
375: --
376: end if;
377: --
378: hr_utility.set_location('Leaving:'||l_proc,10);
379: --
380: end chk_freq_cd;
381: --
382:

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

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

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

463: end if;
464: --
465: end if;
466: --
467: hr_utility.set_location('Leaving:'||l_proc,10);
468: --
469: end check_determination_cd;
470: --
471:

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

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

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

556: end if;
557: --
558: end if;
559: --
560: hr_utility.set_location('Leaving:'||l_proc,10);
561: --
562: end check_rounding_cd;
563: --
564: -- ----------------------------------------------------------------------------

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

611: open c_rule;
612: fetch c_rule into l_exists;
613: if c_rule%notfound then
614: close c_rule;
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: return false;
617: end if;
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: close c_rule;

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

614: close c_rule;
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: return false;
617: end if;
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: close c_rule;
620: return true;
621: --
622:

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

665: --
666: --
667: Begin
668: --
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: l_api_updating := ben_esh_shd.api_updating
672: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
673: p_effective_date => p_effective_date,

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

711: end if;
712: --
713: end if;
714: --
715: hr_utility.set_location('Leaving:'||l_proc,10);
716: --
717: end check_determination_rl;
718: --
719:

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

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

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

803: end if;
804: --
805: end if;
806: --
807: hr_utility.set_location('Leaving:'||l_proc,10);
808: --
809: end check_rounding_rl;
810: --
811:

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

847: --
848: --
849: Begin
850: --
851: hr_utility.set_location('Entering:'||l_proc, 5);
852: --
853: l_api_updating := ben_esh_shd.api_updating
854: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
855: p_effective_date => p_effective_date,

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

875: --
876: --
877: end if;
878: --
879: hr_utility.set_location('Leaving:'||l_proc,10);
880: --
881: end check_schedd_hrs_rl;
882: --
883:

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

920: --
921: --
922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := ben_esh_shd.api_updating
927: (p_elig_schedd_hrs_prte_id => p_elig_schedd_hrs_prte_id,
928: p_effective_date => p_effective_date,

Line 937: hr_utility.set_location('Inside:'||l_proc,8);

933: or (l_api_updating and p_freq_cd <> nvl(ben_esh_shd.g_old_rec.freq_cd,hr_api.g_varchar2))
934: or not l_api_updating
935: or (nvl(p_hrs_num,hr_api.g_number) is not null and nvl(p_max_hrs_num,hr_api.g_number) is not null) then
936: --
937: hr_utility.set_location('Inside:'||l_proc,8);
938:
939: -- check if min or max is null, if freq_cd is specified
940: -- note that this check is also there in the chk_freq_cd procedure.
941: if (p_hrs_num is null and p_max_hrs_num is null) then

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

965: end if;
966: --
967: end if;
968: --
969: hr_utility.set_location('Leaving:'||l_proc,10);
970: --
971: end check_min_or_max;
972: --
973:

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

1012: l_integrity_error Exception;
1013: l_table_name all_tables.table_name%TYPE;
1014: --
1015: Begin
1016: hr_utility.set_location('Entering:'||l_proc, 5);
1017: --
1018: -- Ensure that the p_datetrack_mode argument is not null
1019: --
1020: hr_api.mandatory_arg_error

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

1051: End If;
1052: --
1053: End If;
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056: Exception
1057: When l_integrity_error Then
1058: --
1059: -- A referential integrity check was violated therefore

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

1118: l_rows_exist Exception;
1119: l_table_name all_tables.table_name%TYPE;
1120: --
1121: Begin
1122: hr_utility.set_location('Entering:'||l_proc, 5);
1123: --
1124: -- Ensure that the p_datetrack_mode argument is not null
1125: --
1126: hr_api.mandatory_arg_error

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

1155: --
1156: --
1157: End If;
1158: --
1159: hr_utility.set_location(' Leaving:'||l_proc, 10);
1160: Exception
1161: When l_rows_exist Then
1162: --
1163: -- A referential integrity check was violated therefore

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

1189: --
1190: l_proc varchar2(72) := g_package||'insert_validate';
1191: --
1192: Begin
1193: hr_utility.set_location('Entering:'||l_proc, 5);
1194: --
1195: -- Call all supporting business operations
1196: --
1197: --

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

1278: p_freq_cd => p_rec.freq_cd,
1279: p_effective_date => p_effective_date,
1280: p_object_version_number => p_rec.object_version_number);
1281: --
1282: hr_utility.set_location(' Leaving:'||l_proc, 10);
1283: End insert_validate;
1284: --
1285: -- ----------------------------------------------------------------------------
1286: -- |---------------------------< update_validate >----------------------------|

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

1294: --
1295: l_proc varchar2(72) := g_package||'update_validate';
1296: --
1297: Begin
1298: hr_utility.set_location('Entering:'||l_proc, 5);
1299: --
1300: -- Call all supporting business operations
1301: --
1302: --

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

1391: p_datetrack_mode => p_datetrack_mode,
1392: p_validation_start_date => p_validation_start_date,
1393: p_validation_end_date => p_validation_end_date);
1394: --
1395: hr_utility.set_location(' Leaving:'||l_proc, 10);
1396: End update_validate;
1397: --
1398: -- ----------------------------------------------------------------------------
1399: -- |---------------------------< delete_validate >----------------------------|

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

1407: --
1408: l_proc varchar2(72) := g_package||'delete_validate';
1409: --
1410: Begin
1411: hr_utility.set_location('Entering:'||l_proc, 5);
1412: --
1413: -- Call all supporting business operations
1414: --
1415: dt_delete_validate

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

1417: p_validation_start_date => p_validation_start_date,
1418: p_validation_end_date => p_validation_end_date,
1419: p_elig_schedd_hrs_prte_id => p_rec.elig_schedd_hrs_prte_id);
1420: --
1421: hr_utility.set_location(' Leaving:'||l_proc, 10);
1422: End delete_validate;
1423: --
1424: --
1425: -- ---------------------------------------------------------------------------

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

1444: l_proc varchar2(72) := g_package||'return_legislation_code';
1445: --
1446: begin
1447: --
1448: hr_utility.set_location('Entering:'|| l_proc, 10);
1449: --
1450: -- Ensure that all the mandatory parameter are not null
1451: --
1452: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1469: end if;
1470: --
1471: close csr_leg_code;
1472: --
1473: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1474: --
1475: return l_legislation_code;
1476: --
1477: end return_legislation_code;