DBA Data[Home] [Help]

APPS.BEN_PLAN_TYPE_IN_PROGRAM_API dependencies on HR_UTILITY

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

160: l_otp_object_version_number ben_optip_f.object_version_number%type;
161:
162: begin
163: --
164: hr_utility.set_location('Entering:'|| l_proc, 10);
165: --
166: -- Issue a savepoint if operating in validation only mode
167: --
168: savepoint create_Plan_Type_In_Program;

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

166: -- Issue a savepoint if operating in validation only mode
167: --
168: savepoint create_Plan_Type_In_Program;
169: --
170: hr_utility.set_location(l_proc, 20);
171: --
172: -- Process Logic
173: --
174: begin

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

523: --
524: end;
525: --
526: -- bug 1285336
527: hr_utility.set_location(l_proc, 60);
528: --
529: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
530: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
531:

Line 529: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);

525: --
526: -- bug 1285336
527: hr_utility.set_location(l_proc, 60);
528: --
529: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
530: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
531:
532: FOR l_otp IN c_otp( l_ptip_id ) LOOP
533: --

Line 530: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);

526: -- bug 1285336
527: hr_utility.set_location(l_proc, 60);
528: --
529: hr_utility.set_location('p_pgm_id '||p_pgm_id , 65.1);
530: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
531:
532: FOR l_otp IN c_otp( l_ptip_id ) LOOP
533: --
534: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);

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

530: hr_utility.set_location('l_ptip_id'||l_ptip_id,65.2);
531:
532: FOR l_otp IN c_otp( l_ptip_id ) LOOP
533: --
534: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
535: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
536: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
537: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
538: --

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

531:
532: FOR l_otp IN c_otp( l_ptip_id ) LOOP
533: --
534: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
535: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
536: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
537: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
538: --
539: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm

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

532: FOR l_otp IN c_otp( l_ptip_id ) LOOP
533: --
534: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
535: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
536: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
537: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
538: --
539: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
540: (p_validate => false

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

533: --
534: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 65);
535: hr_utility.set_location('l_otp.pgm_id '||l_otp.pgm_id , 65.1);
536: hr_utility.set_location('l_otp.ptip_id'||l_otp.ptip_id,65.2);
537: hr_utility.set_location('l_otp.pl_typ_id'||l_otp.pl_typ_id,65.3);
538: --
539: ben_opt_pltyp_in_pgm_api.create_opt_pltyp_in_pgm
540: (p_validate => false
541: ,p_optip_id =>l_optip_id

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

549: -- ,p_cmbn_ptip_opt_id =>p_cmbn_ptip_opt_id
550: ,p_object_version_number =>l_otp_object_version_number
551: ,p_effective_date =>p_effective_date
552: );
553: hr_utility.set_location('Before entering into create_opt_pltyp_in_pgm ', 66);
554: END LOOP ;
555:
556:
557: -- When in validation only mode raise the Validate_Enabled exception

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

566: p_effective_start_date := l_effective_start_date;
567: p_effective_end_date := l_effective_end_date;
568: p_object_version_number := l_object_version_number;
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 70);
571: --
572: exception
573: --
574: when hr_api.validate_enabled then

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

585: p_ptip_id := null;
586: p_effective_start_date := null;
587: p_effective_end_date := null;
588: p_object_version_number := null;
589: hr_utility.set_location(' Leaving:'||l_proc, 80);
590: --
591: when others then
592: --
593: -- A validation or unexpected error has occured

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

722: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
723: --
724: begin
725: --
726: hr_utility.set_location('Entering:'|| l_proc, 10);
727: --
728: -- Issue a savepoint if operating in validation only mode
729: --
730: savepoint update_Plan_Type_In_Program;

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

728: -- Issue a savepoint if operating in validation only mode
729: --
730: savepoint update_Plan_Type_In_Program;
731: --
732: hr_utility.set_location(l_proc, 20);
733: --
734: -- Process Logic
735: --
736: l_object_version_number := p_object_version_number;

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

1090: -- End of API User Hook for the after hook of update_Plan_Type_In_Program
1091: --
1092: end;
1093: --
1094: hr_utility.set_location(l_proc, 60);
1095: --
1096: -- When in validation only mode raise the Validate_Enabled exception
1097: --
1098: if p_validate then

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

1104: p_object_version_number := l_object_version_number;
1105: p_effective_start_date := l_effective_start_date;
1106: p_effective_end_date := l_effective_end_date;
1107: --
1108: hr_utility.set_location(' Leaving:'||l_proc, 70);
1109: --
1110: exception
1111: --
1112: when hr_api.validate_enabled then

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

1121: -- when validation only mode is being used.)
1122: --
1123: p_effective_start_date := null;
1124: p_effective_end_date := null;
1125: hr_utility.set_location(' Leaving:'||l_proc, 80);
1126: --
1127: when others then
1128: --
1129: -- A validation or unexpected error has occured

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

1156: l_effective_end_date ben_ptip_f.effective_end_date%TYPE;
1157: --
1158: begin
1159: --
1160: hr_utility.set_location('Entering:'|| l_proc, 10);
1161: --
1162: -- Issue a savepoint if operating in validation only mode
1163: --
1164: savepoint delete_Plan_Type_In_Program;

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

1162: -- Issue a savepoint if operating in validation only mode
1163: --
1164: savepoint delete_Plan_Type_In_Program;
1165: --
1166: hr_utility.set_location(l_proc, 20);
1167: --
1168: -- Process Logic
1169: --
1170: l_object_version_number := p_object_version_number;

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

1225: -- End of API User Hook for the after hook of delete_Plan_Type_In_Program
1226: --
1227: end;
1228: --
1229: hr_utility.set_location(l_proc, 60);
1230: --
1231: -- When in validation only mode raise the Validate_Enabled exception
1232: --
1233: if p_validate then

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

1233: if p_validate then
1234: raise hr_api.validate_enabled;
1235: end if;
1236: --
1237: hr_utility.set_location(' Leaving:'||l_proc, 70);
1238: --
1239: exception
1240: --
1241: when hr_api.validate_enabled then

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

1285: l_validation_end_date date;
1286: --
1287: begin
1288: --
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: --
1291: ben_ctp_shd.lck
1292: (
1293: p_ptip_id => p_ptip_id

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

1297: ,p_effective_date => p_effective_date
1298: ,p_datetrack_mode => p_datetrack_mode
1299: );
1300: --
1301: hr_utility.set_location(' Leaving:'||l_proc, 70);
1302: --
1303: end lck;
1304: --
1305: end ben_Plan_Type_In_Program_api;