DBA Data[Home] [Help]

APPS.BEN_OPTION_IN_PLAN_API dependencies on HR_UTILITY

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

134: l_otp_object_version_number ben_optip_f.object_version_number%type;
135: --
136: begin
137: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Issue a savepoint if operating in validation only mode
141: --
142: savepoint create_Option_in_Plan;

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

140: -- Issue a savepoint if operating in validation only mode
141: --
142: savepoint create_Option_in_Plan;
143: --
144: hr_utility.set_location(l_proc, 20);
145: --
146: -- Process Logic
147: --
148: begin

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

415: p_effective_date => p_effective_date);
416: --
417: end loop;
418: --
419: hr_utility.set_location(l_proc, 60);
420: -- bug 1285336
421: FOR l_otp IN c_otp LOOP
422: --
423: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);

Line 423: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);

419: hr_utility.set_location(l_proc, 60);
420: -- bug 1285336
421: FOR l_otp IN c_otp LOOP
422: --
423: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
424: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
425: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
426: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
427: --

Line 424: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);

420: -- bug 1285336
421: FOR l_otp IN c_otp LOOP
422: --
423: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
424: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
425: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
426: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
427: --
428: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm

Line 425: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);

421: FOR l_otp IN c_otp LOOP
422: --
423: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
424: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
425: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
426: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
427: --
428: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
429: (p_validate => false

Line 426: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);

422: --
423: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
424: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
425: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
426: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
427: --
428: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
429: (p_validate => false
430: ,p_optip_id =>l_optip_id

Line 442: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 66);

438: -- ,p_cmbn_ptip_opt_id =>p_cmbn_ptip_opt_id
439: ,p_object_version_number =>l_otp_object_version_number
440: ,p_effective_date =>p_effective_date
441: );
442: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 66);
443: END LOOP ;
444:
445: -- When in validation only mode raise the Validate_Enabled exception
446: --

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

454: p_effective_start_date := l_effective_start_date;
455: p_effective_end_date := l_effective_end_date;
456: p_object_version_number := l_object_version_number;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 70);
459: --
460: exception
461: --
462: when hr_api.validate_enabled then

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

473: p_oipl_id := null;
474: p_effective_start_date := null;
475: p_effective_end_date := null;
476: p_object_version_number := null;
477: hr_utility.set_location(' Leaving:'||l_proc, 80);
478: --
479: when others then
480: --
481: -- A validation or unexpected error has occured

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

579: l_effective_end_date ben_oipl_f.effective_end_date%TYPE;
580: --
581: begin
582: --
583: hr_utility.set_location('Entering:'|| l_proc, 10);
584: --
585: -- Issue a savepoint if operating in validation only mode
586: --
587: savepoint update_Option_in_Plan;

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

585: -- Issue a savepoint if operating in validation only mode
586: --
587: savepoint update_Option_in_Plan;
588: --
589: hr_utility.set_location(l_proc, 20);
590: --
591: -- Process Logic
592: --
593: l_object_version_number := p_object_version_number;

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

852: -- End of API User Hook for the after hook of update_Option_in_Plan
853: --
854: end;
855: --
856: hr_utility.set_location(l_proc, 60);
857: --
858: -- When in validation only mode raise the Validate_Enabled exception
859: --
860: if p_validate then

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

866: p_object_version_number := l_object_version_number;
867: p_effective_start_date := l_effective_start_date;
868: p_effective_end_date := l_effective_end_date;
869: --
870: hr_utility.set_location(' Leaving:'||l_proc, 70);
871: --
872: exception
873: --
874: when hr_api.validate_enabled then

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

881: -- Only set output warning arguments
882: -- (Any key or derived arguments must be set to null
883: -- when validation only mode is being used.)
884: --
885: hr_utility.set_location(' Leaving:'||l_proc, 80);
886: --
887: when others then
888: --
889: -- A validation or unexpected error has occured

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

990: --
991:
992: begin
993: --
994: hr_utility.set_location('Entering:'|| l_proc, 10);
995: --
996: -- Issue a savepoint if operating in validation only mode
997: --
998: savepoint delete_Option_in_Plan;

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

996: -- Issue a savepoint if operating in validation only mode
997: --
998: savepoint delete_Option_in_Plan;
999: --
1000: hr_utility.set_location(l_proc, 20);
1001: --
1002: -- Process Logic
1003: --
1004: l_object_version_number := p_object_version_number;

Line 1048: hr_utility.set_location('Before entering into Optip delete api ',24);

1044: );
1045: --
1046: end loop;
1047: --
1048: hr_utility.set_location('Before entering into Optip delete api ',24);
1049: for l_exist_otp in c_exist_otp loop
1050: --
1051: hr_utility.set_location('Entering:'||l_proc||'in l_exist_otp ',25);
1052: for l_delete_otp in c_delete_otp(l_exist_otp.opt_id,

Line 1051: hr_utility.set_location('Entering:'||l_proc||'in l_exist_otp ',25);

1047: --
1048: hr_utility.set_location('Before entering into Optip delete api ',24);
1049: for l_exist_otp in c_exist_otp loop
1050: --
1051: hr_utility.set_location('Entering:'||l_proc||'in l_exist_otp ',25);
1052: for l_delete_otp in c_delete_otp(l_exist_otp.opt_id,
1053: l_exist_otp.pgm_id,
1054: l_exist_otp.pl_id,
1055: l_exist_otp.pl_typ_id ) loop

Line 1059: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);

1055: l_exist_otp.pl_typ_id ) loop
1056: --
1057: l_otp_object_version_number := l_delete_otp.object_version_number;
1058: --
1059: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1060: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1061: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1062: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1063: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);

Line 1060: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);

1056: --
1057: l_otp_object_version_number := l_delete_otp.object_version_number;
1058: --
1059: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1060: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1061: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1062: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1063: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1064: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(

Line 1061: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);

1057: l_otp_object_version_number := l_delete_otp.object_version_number;
1058: --
1059: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1060: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1061: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1062: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1063: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1064: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(
1065: p_validate => false,

Line 1062: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);

1058: --
1059: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1060: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1061: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1062: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1063: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1064: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(
1065: p_validate => false,
1066: p_optip_id => l_delete_otp.optip_id,

Line 1063: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);

1059: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1060: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1061: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1062: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1063: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1064: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(
1065: p_validate => false,
1066: p_optip_id => l_delete_otp.optip_id,
1067: p_effective_start_date => l_otp_effective_start_date,

Line 1078: hr_utility.set_location('After leaving Optip delete api ',27);

1074: end loop;
1075: --
1076: end loop ;
1077: End if;
1078: hr_utility.set_location('After leaving Optip delete api ',27);
1079: --
1080: ben_cop_del.del
1081: (p_oipl_id => p_oipl_id
1082: ,p_effective_start_date => l_effective_start_date

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

1108: -- End of API User Hook for the after hook of delete_Option_in_Plan
1109: --
1110: end;
1111: --
1112: hr_utility.set_location(l_proc, 60);
1113: --
1114: -- When in validation only mode raise the Validate_Enabled exception
1115: --
1116: if p_validate then

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

1116: if p_validate then
1117: raise hr_api.validate_enabled;
1118: end if;
1119: --
1120: hr_utility.set_location(' Leaving:'||l_proc, 70);
1121: --
1122: exception
1123: --
1124: when hr_api.validate_enabled then

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

1168: l_validation_end_date date;
1169: --
1170: begin
1171: --
1172: hr_utility.set_location('Entering:'|| l_proc, 10);
1173: --
1174: ben_cop_shd.lck
1175: (p_oipl_id => p_oipl_id
1176: ,p_validation_start_date => l_validation_start_date

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

1178: ,p_object_version_number => p_object_version_number
1179: ,p_effective_date => p_effective_date
1180: ,p_datetrack_mode => p_datetrack_mode);
1181: --
1182: hr_utility.set_location(' Leaving:'||l_proc, 70);
1183: --
1184: end lck;
1185: --
1186: end ben_Option_in_Plan_api;