DBA Data[Home] [Help]

APPS.BEN_PLAN_TYPE_OPTION_TYPE_API dependencies on HR_UTILITY

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

88: l_eff_end_dt date ;
89:
90: begin
91: --
92: hr_utility.set_location('Entering:'|| l_proc, 10);
93: --
94: -- Issue a savepoint if operating in validation only mode
95: --
96: savepoint create_plan_type_option_type;

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

94: -- Issue a savepoint if operating in validation only mode
95: --
96: savepoint create_plan_type_option_type;
97: --
98: hr_utility.set_location(l_proc, 20);
99: --
100: -- Process Logic
101: --
102: begin

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

261: -- End of API User Hook for the after hook of create_plan_type_option_type
262: --
263: end;
264: --
265: hr_utility.set_location(l_proc, 60);
266: --
267:
268: hr_utility.set_location(l_proc, 60);
269: -- when the plan type is CWB and the group_id is null then

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

264: --
265: hr_utility.set_location(l_proc, 60);
266: --
267:
268: hr_utility.set_location(l_proc, 60);
269: -- when the plan type is CWB and the group_id is null then
270: -- update the group id
271: open c_ptp ;
272: fetch c_ptp into l_opt_typ_cd ;

Line 274: hr_utility.set_location('OPT TYP CD '|| l_opt_typ_cd , 60);

270: -- update the group id
271: open c_ptp ;
272: fetch c_ptp into l_opt_typ_cd ;
273: close c_ptp ;
274: hr_utility.set_location('OPT TYP CD '|| l_opt_typ_cd , 60);
275: if l_opt_typ_cd = 'CWB' then
276: open c_opt ;
277: fetch c_opt
278: into l_group_opt_id ,

Line 281: hr_utility.set_location(' l_group_opt_id '|| l_group_opt_id , 60);

277: fetch c_opt
278: into l_group_opt_id ,
279: l_opt_ovn ;
280: close c_opt ;
281: hr_utility.set_location(' l_group_opt_id '|| l_group_opt_id , 60);
282: if l_group_opt_id is null then
283: BEN_option_definition_API.update_option_definition
284: (p_validate => FALSE
285: ,p_OPT_ID => p_opt_id

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

305: p_effective_start_date := l_effective_start_date;
306: p_effective_end_date := l_effective_end_date;
307: p_object_version_number := l_object_version_number;
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 70);
310: --
311: exception
312: --
313: when hr_api.validate_enabled then

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

324: p_pl_typ_opt_typ_id := null;
325: p_effective_start_date := null;
326: p_effective_end_date := null;
327: p_object_version_number := null;
328: hr_utility.set_location(' Leaving:'||l_proc, 80);
329: --
330: when others then
331: --
332: -- A validation or unexpected error has occured

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

421: l_eff_end_dt date ;
422:
423: begin
424: --
425: hr_utility.set_location('Entering:'|| l_proc, 10);
426: --
427: -- Issue a savepoint if operating in validation only mode
428: --
429: savepoint update_plan_type_option_type;

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

427: -- Issue a savepoint if operating in validation only mode
428: --
429: savepoint update_plan_type_option_type;
430: --
431: hr_utility.set_location(l_proc, 20);
432: --
433: -- Process Logic
434: --
435: l_object_version_number := p_object_version_number;

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

600: -- End of API User Hook for the after hook of update_plan_type_option_type
601: --
602: end;
603: --
604: hr_utility.set_location(l_proc, 60);
605: -- when the plan type is CWB and the group_id is null then
606: -- update the group id
607: open c_ptp ;
608: fetch c_ptp into l_opt_typ_cd ;

Line 610: hr_utility.set_location('OPT TYP CD '|| l_opt_typ_cd , 60);

606: -- update the group id
607: open c_ptp ;
608: fetch c_ptp into l_opt_typ_cd ;
609: close c_ptp ;
610: hr_utility.set_location('OPT TYP CD '|| l_opt_typ_cd , 60);
611: if l_opt_typ_cd = 'CWB' then
612: open c_opt ;
613: fetch c_opt
614: into l_group_opt_id ,

Line 617: hr_utility.set_location(' l_group_opt_id '|| l_group_opt_id , 60);

613: fetch c_opt
614: into l_group_opt_id ,
615: l_opt_ovn ;
616: close c_opt ;
617: hr_utility.set_location(' l_group_opt_id '|| l_group_opt_id , 60);
618: if l_group_opt_id is null then
619: BEN_option_definition_API.update_option_definition
620: (p_validate => FALSE
621: ,p_OPT_ID => p_opt_id

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

644: p_object_version_number := l_object_version_number;
645: p_effective_start_date := l_effective_start_date;
646: p_effective_end_date := l_effective_end_date;
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 70);
649: --
650: exception
651: --
652: when hr_api.validate_enabled then

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

659: -- Only set output warning arguments
660: -- (Any key or derived arguments must be set to null
661: -- when validation only mode is being used.)
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 80);
664: --
665: when others then
666: --
667: -- A validation or unexpected error has occured

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

715: l_effective_end_date ben_pl_typ_opt_typ_f.effective_end_date%TYPE;
716: --
717: begin
718: --
719: hr_utility.set_location('Entering:'|| l_proc, 10);
720: --
721: -- Issue a savepoint if operating in validation only mode
722: --
723: savepoint delete_plan_type_option_type;

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

721: -- Issue a savepoint if operating in validation only mode
722: --
723: savepoint delete_plan_type_option_type;
724: --
725: hr_utility.set_location(l_proc, 20);
726: --
727: -- Process Logic
728: --
729: l_object_version_number := p_object_version_number;

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

789: -- End of API User Hook for the after hook of delete_plan_type_option_type
790: --
791: end;
792: --
793: hr_utility.set_location(l_proc, 60);
794: --
795: -- When in validation only mode raise the Validate_Enabled exception
796: --
797: if p_validate then

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

816: end if;
817: --
818: --Bug : 3453791
819: --
820: hr_utility.set_location(' Leaving:'||l_proc, 70);
821: --
822: exception
823: --
824: when hr_api.validate_enabled then

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

870: l_validation_end_date date;
871: --
872: begin
873: --
874: hr_utility.set_location('Entering:'|| l_proc, 10);
875: --
876: ben_pon_shd.lck
877: (
878: p_pl_typ_opt_typ_id => p_pl_typ_opt_typ_id

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

882: ,p_effective_date => p_effective_date
883: ,p_datetrack_mode => p_datetrack_mode
884: );
885: --
886: hr_utility.set_location(' Leaving:'||l_proc, 70);
887: --
888: end lck;
889: --
890: end ben_plan_type_option_type_api;