DBA Data[Home] [Help]

APPS.PAY_PL_PAYE_API dependencies on HR_UTILITY

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

77: l_effective_end_date date;
78:
79:
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 10);
82: --
83: -- Issue a savepoint
84: --
85: savepoint create_pl_paye_details;

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

198: p_object_version_number := l_object_version_number;
199: p_effective_start_date := l_effective_start_date;
200: p_effective_end_date := l_effective_end_date;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised

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

215: p_paye_details_id := NULL;
216: p_object_version_number := NULL;
217: p_effective_start_date := NULL;
218: p_effective_end_date := NULL;
219: hr_utility.set_location(' Leaving:'||l_proc, 80);
220: when others then
221: --
222: -- A validation or unexpected error has occured
223: --

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

229: p_paye_details_id := NULL;
230: p_object_version_number := NULL;
231: p_effective_start_date := NULL;
232: p_effective_end_date := NULL;
233: hr_utility.set_location(' Leaving:'||l_proc, 90);
234: raise;
235: end CREATE_PL_PAYE_DETAILS;
236: --
237: -- ----------------------------------------------------------------------------

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

267: l_in_out_parameter1 number;
268:
269: begin
270:
271: hr_utility.set_location('Entering:'|| l_proc, 10);
272: --
273: -- Issue a savepoint
274: --
275: savepoint update_pl_paye_details;

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

368: p_effective_start_date := l_effective_start_date;
369: p_effective_end_date := l_effective_end_date;
370:
371: --
372: hr_utility.set_location(' Leaving:'||l_proc, 70);
373: exception
374: when hr_api.validate_enabled then
375: --
376: -- As the Validate_Enabled exception has been raised

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

385: p_object_version_number := l_in_out_parameter1;
386: p_effective_start_date := NULL;
387: p_effective_end_date := NULL;
388:
389: hr_utility.set_location(' Leaving:'||l_proc, 80);
390: when others then
391: --
392: -- A validation or unexpected error has occured
393: --

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

398: --
399: p_object_version_number := l_in_out_parameter1;
400: p_effective_start_date := NULL;
401: p_effective_end_date := NULL;
402: hr_utility.set_location(' Leaving:'||l_proc, 90);
403: raise;
404: end update_pl_paye_details;
405: --
406: -- ----------------------------------------------------------------------------

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

433: l_in_out_parameter1 number;
434:
435: begin
436:
437: hr_utility.set_location('Entering:'|| l_proc, 10);
438: --
439: -- Issue a savepoint
440: --
441: savepoint delete_pl_paye_details;

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

520: p_effective_end_date := l_effective_end_date;
521:
522:
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 70);
525: exception
526: when hr_api.validate_enabled then
527: --
528: -- As the Validate_Enabled exception has been raised

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

537: p_object_version_number := l_in_out_parameter1;
538: p_effective_start_date := NULL;
539: p_effective_end_date := NULL;
540:
541: hr_utility.set_location(' Leaving:'||l_proc, 80);
542: when others then
543: --
544: -- A validation or unexpected error has occured
545: --

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

550: --
551: p_object_version_number := l_in_out_parameter1;
552: p_effective_start_date := NULL;
553: p_effective_end_date := NULL;
554: hr_utility.set_location(' Leaving:'||l_proc, 90);
555: raise;
556: end delete_pl_paye_details;
557: --
558: -- ----------------------------------------------------------------------------

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

596: and paf.effective_end_date
597: and bus.business_group_id = paf.business_group_id;
598:
599: begin
600: hr_utility.set_location('Entering:'|| l_proc, 10);
601:
602: l_leg_code := 'PL';
603:
604: l_effective_date := trunc(p_effective_date);

Line 613: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');

609: if csr_get_derived_details%NOTFOUND then
610: --
611: close csr_get_derived_details;
612: --
613: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
614: hr_utility.raise_error;
615: end if;
616: --
617: close csr_get_derived_details;

Line 614: hr_utility.raise_error;

610: --
611: close csr_get_derived_details;
612: --
613: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
614: hr_utility.raise_error;
615: end if;
616: --
617: close csr_get_derived_details;
618:

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

700: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;
701: l_rate_of_tax pay_pl_paye_details_f.rate_of_tax%TYPE;
702:
703: begin
704: hr_utility.set_location('Entering:'|| l_proc, 10);
705:
706: l_leg_code := 'PL';
707:
708: l_effective_date := trunc(p_effective_date);

Line 717: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');

713: if csr_get_derived_details%NOTFOUND then
714: --
715: close csr_get_derived_details;
716: --
717: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
718: hr_utility.raise_error;
719: end if;
720: --
721: close csr_get_derived_details;

Line 718: hr_utility.raise_error;

714: --
715: close csr_get_derived_details;
716: --
717: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
718: hr_utility.raise_error;
719: end if;
720: --
721: close csr_get_derived_details;
722:

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

805: and paf.effective_end_date
806: and bus.business_group_id = paf.business_group_id;
807:
808: begin
809: hr_utility.set_location('Entering:'|| l_proc, 10);
810:
811: l_leg_code := 'PL';
812:
813: l_effective_date := trunc(p_effective_date);

Line 822: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');

818: if csr_get_derived_details%NOTFOUND then
819: --
820: close csr_get_derived_details;
821: --
822: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
823: hr_utility.raise_error;
824: end if;
825: --
826: close csr_get_derived_details;

Line 823: hr_utility.raise_error;

819: --
820: close csr_get_derived_details;
821: --
822: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
823: hr_utility.raise_error;
824: end if;
825: --
826: close csr_get_derived_details;
827:

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

904: and bus.business_group_id = papf.business_group_id;
905:
906:
907: begin
908: hr_utility.set_location('Entering:'|| l_proc, 10);
909:
910: l_leg_code := 'PL';
911: l_effective_date := trunc(p_effective_date);
912:

Line 920: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');

916: if csr_get_derived_details%NOTFOUND then
917: --
918: close csr_get_derived_details;
919: --
920: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
921: hr_utility.raise_error;
922: end if;
923: --
924: close csr_get_derived_details;

Line 921: hr_utility.raise_error;

917: --
918: close csr_get_derived_details;
919: --
920: hr_utility.set_message(801,'PAY_375848_PL_INVALID_ASG');
921: hr_utility.raise_error;
922: end if;
923: --
924: close csr_get_derived_details;
925: -- Since we will be re-setting the effective_start_date to the Person's start date,