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 115: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

441: --
442: p_object_version_number := l_object_version_number;
443: --
444: if g_debug then
445: hr_utility.set_location(' Leaving:'||l_proc, 70);
446: end if;
447: exception
448: when hr_api.validate_enabled then
449: --

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

452: --
453: rollback to create_plan_or_option;
454: --
455: if g_debug then
456: hr_utility.set_location(' Leaving:'||l_proc, 80);
457: end if;
458: when others then
459: --
460: -- A validation or unexpected error has occured

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

461: --
462: rollback to create_plan_or_option;
463: --
464: if g_debug then
465: hr_utility.set_location(' Leaving:'||l_proc, 90);
466: end if;
467: raise;
468: end create_plan_or_option;
469: --

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

559: --
560: begin
561: --
562: if g_debug then
563: hr_utility.set_location('Entering:'|| l_proc, 10);
564: end if;
565: --
566: if(p_pl_id = p_group_pl_id) then
567: -- Group Plan or Option

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

580: end if;
581: end if;
582: --
583: if g_debug then
584: hr_utility.set_location(l_proc, 20);
585: end if;
586: --
587: if (l_is_group_plan) then
588: --

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

586: --
587: if (l_is_group_plan) then
588: --
589: if g_debug then
590: hr_utility.set_location(l_proc, 30);
591: end if;
592: --
593: -- Pass the values of to local plan : group_pl_id, effective_date,
594: -- upd_start_dt, upd_end_dt, approval_mode, enrt_perd_start-dt,

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

598: for pl in csr_plans(p_pl_id, p_lf_evt_ocrd_dt)
599: loop
600: --
601: if g_debug then
602: hr_utility.set_location(l_proc, 40);
603: end if;
604: --
605: select object_version_number
606: into l_ovn

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

633: ,p_object_version_number => l_ovn);
634: end loop;
635: --
636: if g_debug then
637: hr_utility.set_location(l_proc, 50);
638: end if;
639: --
640: -- Pass the values to the Group Option : effective_date, group_pl_id,
641: -- pl_uom, pl_xchg_rate, business_group_id, actual_flag,

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

644: for oipl in csr_options(p_pl_id, p_lf_evt_ocrd_dt)
645: loop
646: --
647: if g_debug then
648: hr_utility.set_location(l_proc, 60);
649: end if;
650: --
651: select object_version_number
652: into l_ovn

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

674: ,p_object_version_number => l_ovn);
675: end loop;
676: --
677: if g_debug then
678: hr_utility.set_location(l_proc, 70);
679: end if;
680: --
681: -- Pass the following values to local options : effective_date,
682: -- group_pl_id

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

699: ,p_object_version_number => l_ovn);
700: end loop;
701: --
702: if g_debug then
703: hr_utility.set_location(l_proc, 80);
704: end if;
705: --
706: elsif (l_is_local_plan) then
707: --

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

705: --
706: elsif (l_is_local_plan) then
707: --
708: if g_debug then
709: hr_utility.set_location(l_proc, 90);
710: end if;
711: --
712: -- Pass the following values to local option : effective_date,
713: -- group_pl_id, pl_uom, pl_ordr_num, pl_xchg_rate, business_group_id,

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

742: ,p_object_version_number => l_ovn);
743: end loop;
744: --
745: if g_debug then
746: hr_utility.set_location(l_proc, 100);
747: end if;
748: --
749: elsif (l_is_group_option) then
750: --

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

748: --
749: elsif (l_is_group_option) then
750: --
751: if g_debug then
752: hr_utility.set_location(l_proc, 110);
753: end if;
754: --
755: -- Pass the following values to local option : effective_date,
756: -- group_pl_id, group_oipl_id, oipl_ordr_num

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

777: ,p_object_version_number => l_ovn);
778: end loop;
779: --
780: if g_debug then
781: hr_utility.set_location(l_proc, 120);
782: end if;
783: --
784: end if;
785: --

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

783: --
784: end if;
785: --
786: if g_debug then
787: hr_utility.set_location(' Leaving:'|| l_proc, 999);
788: end if;
789: end;
790: --
791: -- ----------------------------------------------------------------------------

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

901: --
902: l_proc varchar2(72) := g_package||'update_plan_or_option';
903: begin
904: if g_debug then
905: hr_utility.set_location('Entering:'|| l_proc, 10);
906: end if;
907: --
908: -- Issue a savepoint
909: --

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

1284: --
1285: p_object_version_number := l_object_version_number;
1286: --
1287: if g_debug then
1288: hr_utility.set_location(' Leaving:'||l_proc, 80);
1289: end if;
1290: exception
1291: when hr_api.validate_enabled then
1292: --

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

1299: -- (Any key or derived arguments must be set to null
1300: -- when validation only mode is being used.)
1301: --
1302: if g_debug then
1303: hr_utility.set_location(' Leaving:'||l_proc, 90);
1304: end if;
1305: when others then
1306: --
1307: -- A validation or unexpected error has occured

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

1311: -- Reset IN OUT parameters and set all
1312: -- OUT parameters, including warnings, to null
1313: --
1314: if g_debug then
1315: hr_utility.set_location(' Leaving:'||l_proc, 99);
1316: end if;
1317: raise;
1318: end update_plan_or_option;
1319: --

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

1335: l_object_version_number number;
1336: l_proc varchar2(72) := g_package||'delete_plan_or_option';
1337: begin
1338: if g_debug then
1339: hr_utility.set_location('Entering:'|| l_proc, 10);
1340: end if;
1341: --
1342: -- Issue a savepoint
1343: --

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

1401: raise hr_api.validate_enabled;
1402: end if;
1403: --
1404: if g_debug then
1405: hr_utility.set_location(' Leaving:'||l_proc, 70);
1406: end if;
1407: exception
1408: when hr_api.validate_enabled then
1409: --

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

1412: --
1413: rollback to delete_plan_or_option;
1414: --
1415: if g_debug then
1416: hr_utility.set_location(' Leaving:'||l_proc, 80);
1417: end if;
1418: when others then
1419: --
1420: -- A validation or unexpected error has occured

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

1424: -- Reset IN OUT parameters and set all
1425: -- OUT parameters, including warnings, to null
1426: --
1427: if g_debug then
1428: hr_utility.set_location(' Leaving:'||l_proc, 90);
1429: end if;
1430: raise;
1431: end delete_plan_or_option;
1432: --