DBA Data[Home] [Help]

APPS.BEN_CWB_PL_DSGN_API dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PL_DSGN_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: --
10: -- ----------------------------------------------------------------------------
11: -- |-------------------------< create_plan_or_option >------------------------|

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

108: --
109: l_proc varchar2(72) := g_package||'create_plan_or_option';
110: begin
111: if g_debug then
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: end if;
114: --
115: -- Issue a savepoint
116: --

Line 433: hr_utility.set_location(' Leaving:'||l_proc, 70);

429: --
430: p_object_version_number := l_object_version_number;
431: --
432: if g_debug then
433: hr_utility.set_location(' Leaving:'||l_proc, 70);
434: end if;
435: exception
436: when hr_api.validate_enabled then
437: --

Line 444: hr_utility.set_location(' Leaving:'||l_proc, 80);

440: --
441: rollback to create_plan_or_option;
442: --
443: if g_debug then
444: hr_utility.set_location(' Leaving:'||l_proc, 80);
445: end if;
446: when others then
447: --
448: -- A validation or unexpected error has occured

Line 453: hr_utility.set_location(' Leaving:'||l_proc, 90);

449: --
450: rollback to create_plan_or_option;
451: --
452: if g_debug then
453: hr_utility.set_location(' Leaving:'||l_proc, 90);
454: end if;
455: raise;
456: end create_plan_or_option;
457: --

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

547: --
548: begin
549: --
550: if g_debug then
551: hr_utility.set_location('Entering:'|| l_proc, 10);
552: end if;
553: --
554: if(p_pl_id = p_group_pl_id) then
555: -- Group Plan or Option

Line 572: hr_utility.set_location(l_proc, 20);

568: end if;
569: end if;
570: --
571: if g_debug then
572: hr_utility.set_location(l_proc, 20);
573: end if;
574: --
575: if (l_is_group_plan) then
576: --

Line 578: hr_utility.set_location(l_proc, 30);

574: --
575: if (l_is_group_plan) then
576: --
577: if g_debug then
578: hr_utility.set_location(l_proc, 30);
579: end if;
580: --
581: -- Pass the values of to local plan : group_pl_id, effective_date,
582: -- upd_start_dt, upd_end_dt, approval_mode, enrt_perd_start-dt,

Line 590: hr_utility.set_location(l_proc, 40);

586: for pl in csr_plans(p_pl_id, p_lf_evt_ocrd_dt)
587: loop
588: --
589: if g_debug then
590: hr_utility.set_location(l_proc, 40);
591: end if;
592: --
593: select object_version_number
594: into l_ovn

Line 625: hr_utility.set_location(l_proc, 50);

621: ,p_object_version_number => l_ovn);
622: end loop;
623: --
624: if g_debug then
625: hr_utility.set_location(l_proc, 50);
626: end if;
627: --
628: -- Pass the values to the Group Option : effective_date, group_pl_id,
629: -- pl_uom, pl_xchg_rate, business_group_id, actual_flag,

Line 636: hr_utility.set_location(l_proc, 60);

632: for oipl in csr_options(p_pl_id, p_lf_evt_ocrd_dt)
633: loop
634: --
635: if g_debug then
636: hr_utility.set_location(l_proc, 60);
637: end if;
638: --
639: select object_version_number
640: into l_ovn

Line 666: hr_utility.set_location(l_proc, 70);

662: ,p_object_version_number => l_ovn);
663: end loop;
664: --
665: if g_debug then
666: hr_utility.set_location(l_proc, 70);
667: end if;
668: --
669: -- Pass the following values to local options : effective_date,
670: -- group_pl_id

Line 691: hr_utility.set_location(l_proc, 80);

687: ,p_object_version_number => l_ovn);
688: end loop;
689: --
690: if g_debug then
691: hr_utility.set_location(l_proc, 80);
692: end if;
693: --
694: elsif (l_is_local_plan) then
695: --

Line 697: hr_utility.set_location(l_proc, 90);

693: --
694: elsif (l_is_local_plan) then
695: --
696: if g_debug then
697: hr_utility.set_location(l_proc, 90);
698: end if;
699: --
700: -- Pass the following values to local option : effective_date,
701: -- group_pl_id, pl_uom, pl_ordr_num, pl_xchg_rate, business_group_id,

Line 734: hr_utility.set_location(l_proc, 100);

730: ,p_object_version_number => l_ovn);
731: end loop;
732: --
733: if g_debug then
734: hr_utility.set_location(l_proc, 100);
735: end if;
736: --
737: elsif (l_is_group_option) then
738: --

Line 740: hr_utility.set_location(l_proc, 110);

736: --
737: elsif (l_is_group_option) then
738: --
739: if g_debug then
740: hr_utility.set_location(l_proc, 110);
741: end if;
742: --
743: -- Pass the following values to local option : effective_date,
744: -- group_pl_id, group_oipl_id, oipl_ordr_num

Line 769: hr_utility.set_location(l_proc, 120);

765: ,p_object_version_number => l_ovn);
766: end loop;
767: --
768: if g_debug then
769: hr_utility.set_location(l_proc, 120);
770: end if;
771: --
772: end if;
773: --

Line 775: hr_utility.set_location(' Leaving:'|| l_proc, 999);

771: --
772: end if;
773: --
774: if g_debug then
775: hr_utility.set_location(' Leaving:'|| l_proc, 999);
776: end if;
777: end;
778: --
779: -- ----------------------------------------------------------------------------

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

881: --
882: l_proc varchar2(72) := g_package||'update_plan_or_option';
883: begin
884: if g_debug then
885: hr_utility.set_location('Entering:'|| l_proc, 10);
886: end if;
887: --
888: -- Issue a savepoint
889: --

Line 1246: hr_utility.set_location(' Leaving:'||l_proc, 80);

1242: --
1243: p_object_version_number := l_object_version_number;
1244: --
1245: if g_debug then
1246: hr_utility.set_location(' Leaving:'||l_proc, 80);
1247: end if;
1248: exception
1249: when hr_api.validate_enabled then
1250: --

Line 1261: hr_utility.set_location(' Leaving:'||l_proc, 90);

1257: -- (Any key or derived arguments must be set to null
1258: -- when validation only mode is being used.)
1259: --
1260: if g_debug then
1261: hr_utility.set_location(' Leaving:'||l_proc, 90);
1262: end if;
1263: when others then
1264: --
1265: -- A validation or unexpected error has occured

Line 1273: hr_utility.set_location(' Leaving:'||l_proc, 99);

1269: -- Reset IN OUT parameters and set all
1270: -- OUT parameters, including warnings, to null
1271: --
1272: if g_debug then
1273: hr_utility.set_location(' Leaving:'||l_proc, 99);
1274: end if;
1275: raise;
1276: end update_plan_or_option;
1277: --

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

1293: l_object_version_number number;
1294: l_proc varchar2(72) := g_package||'delete_plan_or_option';
1295: begin
1296: if g_debug then
1297: hr_utility.set_location('Entering:'|| l_proc, 10);
1298: end if;
1299: --
1300: -- Issue a savepoint
1301: --

Line 1363: hr_utility.set_location(' Leaving:'||l_proc, 70);

1359: raise hr_api.validate_enabled;
1360: end if;
1361: --
1362: if g_debug then
1363: hr_utility.set_location(' Leaving:'||l_proc, 70);
1364: end if;
1365: exception
1366: when hr_api.validate_enabled then
1367: --

Line 1374: hr_utility.set_location(' Leaving:'||l_proc, 80);

1370: --
1371: rollback to delete_plan_or_option;
1372: --
1373: if g_debug then
1374: hr_utility.set_location(' Leaving:'||l_proc, 80);
1375: end if;
1376: when others then
1377: --
1378: -- A validation or unexpected error has occured

Line 1386: hr_utility.set_location(' Leaving:'||l_proc, 90);

1382: -- Reset IN OUT parameters and set all
1383: -- OUT parameters, including warnings, to null
1384: --
1385: if g_debug then
1386: hr_utility.set_location(' Leaving:'||l_proc, 90);
1387: end if;
1388: raise;
1389: end delete_plan_or_option;
1390: --