DBA Data[Home] [Help]

APPS.BEN_OPTION_IN_PLAN_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

458: p_effective_start_date := l_effective_start_date;
459: p_effective_end_date := l_effective_end_date;
460: p_object_version_number := l_object_version_number;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 70);
463: --
464: exception
465: --
466: when hr_api.validate_enabled then

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

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

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

584: l_effective_end_date ben_oipl_f.effective_end_date%TYPE;
585: --
586: begin
587: --
588: hr_utility.set_location('Entering:'|| l_proc, 10);
589: --
590: -- Issue a savepoint if operating in validation only mode
591: --
592: savepoint update_Option_in_Plan;

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

590: -- Issue a savepoint if operating in validation only mode
591: --
592: savepoint update_Option_in_Plan;
593: --
594: hr_utility.set_location(l_proc, 20);
595: --
596: -- Process Logic
597: --
598: l_object_version_number := p_object_version_number;

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

860: -- End of API User Hook for the after hook of update_Option_in_Plan
861: --
862: end;
863: --
864: hr_utility.set_location(l_proc, 60);
865: --
866: -- When in validation only mode raise the Validate_Enabled exception
867: --
868: if p_validate then

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

874: p_object_version_number := l_object_version_number;
875: p_effective_start_date := l_effective_start_date;
876: p_effective_end_date := l_effective_end_date;
877: --
878: hr_utility.set_location(' Leaving:'||l_proc, 70);
879: --
880: exception
881: --
882: when hr_api.validate_enabled then

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

889: -- Only set output warning arguments
890: -- (Any key or derived arguments must be set to null
891: -- when validation only mode is being used.)
892: --
893: hr_utility.set_location(' Leaving:'||l_proc, 80);
894: --
895: when others then
896: --
897: -- A validation or unexpected error has occured

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

998: --
999:
1000: begin
1001: --
1002: hr_utility.set_location('Entering:'|| l_proc, 10);
1003: --
1004: -- Issue a savepoint if operating in validation only mode
1005: --
1006: savepoint delete_Option_in_Plan;

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

1004: -- Issue a savepoint if operating in validation only mode
1005: --
1006: savepoint delete_Option_in_Plan;
1007: --
1008: hr_utility.set_location(l_proc, 20);
1009: --
1010: -- Process Logic
1011: --
1012: l_object_version_number := p_object_version_number;

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

1052: );
1053: --
1054: end loop;
1055: --
1056: hr_utility.set_location('Before entering into Optip delete api ',24);
1057: for l_exist_otp in c_exist_otp loop
1058: --
1059: hr_utility.set_location('Entering:'||l_proc||'in l_exist_otp ',25);
1060: for l_delete_otp in c_delete_otp(l_exist_otp.opt_id,

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

1055: --
1056: hr_utility.set_location('Before entering into Optip delete api ',24);
1057: for l_exist_otp in c_exist_otp loop
1058: --
1059: hr_utility.set_location('Entering:'||l_proc||'in l_exist_otp ',25);
1060: for l_delete_otp in c_delete_otp(l_exist_otp.opt_id,
1061: l_exist_otp.pgm_id,
1062: l_exist_otp.pl_id,
1063: l_exist_otp.pl_typ_id ) loop

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

1063: l_exist_otp.pl_typ_id ) loop
1064: --
1065: l_otp_object_version_number := l_delete_otp.object_version_number;
1066: --
1067: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1068: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1069: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1070: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1071: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);

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

1064: --
1065: l_otp_object_version_number := l_delete_otp.object_version_number;
1066: --
1067: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1068: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1069: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1070: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1071: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1072: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(

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

1065: l_otp_object_version_number := l_delete_otp.object_version_number;
1066: --
1067: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1068: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1069: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1070: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1071: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1072: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(
1073: p_validate => false,

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

1066: --
1067: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1068: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1069: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1070: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1071: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1072: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(
1073: p_validate => false,
1074: p_optip_id => l_delete_otp.optip_id,

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

1067: hr_utility.set_location('Entering:'||l_proc||'in l_delete_otp' ,26);
1068: hr_utility.set_location(' Opt_id '||l_exist_otp.opt_id , 26);
1069: hr_utility.set_location(' pgm_id '||l_exist_otp.pgm_id , 26);
1070: hr_utility.set_location(' pl_id '||l_exist_otp.pl_id , 26);
1071: hr_utility.set_location(' pl_typ_id '||l_exist_otp.pl_typ_id , 26);
1072: ben_opt_pltyp_in_pgm_api.delete_opt_pltyp_in_pgm(
1073: p_validate => false,
1074: p_optip_id => l_delete_otp.optip_id,
1075: p_effective_start_date => l_otp_effective_start_date,

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

1082: end loop;
1083: --
1084: end loop ;
1085: End if;
1086: hr_utility.set_location('After leaving Optip delete api ',27);
1087: --
1088: ben_cop_del.del
1089: (p_oipl_id => p_oipl_id
1090: ,p_effective_start_date => l_effective_start_date

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

1116: -- End of API User Hook for the after hook of delete_Option_in_Plan
1117: --
1118: end;
1119: --
1120: hr_utility.set_location(l_proc, 60);
1121: --
1122: -- When in validation only mode raise the Validate_Enabled exception
1123: --
1124: if p_validate then

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

1124: if p_validate then
1125: raise hr_api.validate_enabled;
1126: end if;
1127: --
1128: hr_utility.set_location(' Leaving:'||l_proc, 70);
1129: --
1130: exception
1131: --
1132: when hr_api.validate_enabled then

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

1176: l_validation_end_date date;
1177: --
1178: begin
1179: --
1180: hr_utility.set_location('Entering:'|| l_proc, 10);
1181: --
1182: ben_cop_shd.lck
1183: (p_oipl_id => p_oipl_id
1184: ,p_validation_start_date => l_validation_start_date

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

1186: ,p_object_version_number => p_object_version_number
1187: ,p_effective_date => p_effective_date
1188: ,p_datetrack_mode => p_datetrack_mode);
1189: --
1190: hr_utility.set_location(' Leaving:'||l_proc, 70);
1191: --
1192: end lck;
1193: --
1194: end ben_Option_in_Plan_api;