DBA Data[Home] [Help]

APPS.PER_BF_PAYMENT_DETAILS_API dependencies on HR_UTILITY

Line 58: hr_utility.set_message(800,'HR_50403_NEED_PD_CURR');

54: CLOSE csr_get_org_currency;
55: --
56: IF p_currency_code IS NULL THEN
57: -- Raise an error as a currency code is required
58: hr_utility.set_message(800,'HR_50403_NEED_PD_CURR');
59: hr_utility.raise_error;
60: END IF;
61: IF p_currency_code <> l_currency_code THEN
62: -- Wrong currency has been passed.

Line 59: hr_utility.raise_error;

55: --
56: IF p_currency_code IS NULL THEN
57: -- Raise an error as a currency code is required
58: hr_utility.set_message(800,'HR_50403_NEED_PD_CURR');
59: hr_utility.raise_error;
60: END IF;
61: IF p_currency_code <> l_currency_code THEN
62: -- Wrong currency has been passed.
63: hr_utility.set_message(800,'HR_50404_PD_WRONG_CURR');

Line 63: hr_utility.set_message(800,'HR_50404_PD_WRONG_CURR');

59: hr_utility.raise_error;
60: END IF;
61: IF p_currency_code <> l_currency_code THEN
62: -- Wrong currency has been passed.
63: hr_utility.set_message(800,'HR_50404_PD_WRONG_CURR');
64: hr_utility.raise_error;
65: END IF;
66: END IF;
67: END chk_currency_code;

Line 64: hr_utility.raise_error;

60: END IF;
61: IF p_currency_code <> l_currency_code THEN
62: -- Wrong currency has been passed.
63: hr_utility.set_message(800,'HR_50404_PD_WRONG_CURR');
64: hr_utility.raise_error;
65: END IF;
66: END IF;
67: END chk_currency_code;
68: --

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

143: --
144: --
145: l_proc varchar2(72) := g_package||'create_payment_detail';
146: begin
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: --
149: -- Issue a savepoint
150: --
151: savepoint create_payment_detail;

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

148: --
149: -- Issue a savepoint
150: --
151: savepoint create_payment_detail;
152: hr_utility.set_location(l_proc, 20);
153: --
154: -- Truncate the time portion from all IN date parameters
155: --
156:

Line 208: hr_utility.set_location(l_proc, 30);

204: (p_module_name => 'CREATE_PAYMENT_DETAIL'
205: ,p_hook_type => 'BP'
206: );
207: end;
208: hr_utility.set_location(l_proc, 30);
209: --
210: -- Validation in addition to Row Handlers
211: --
212: -- Validation to ensure that the currency is the same for the org payment

Line 227: hr_utility.set_location(l_proc, 35);

223: , l_processed_assignment_ovn;
224: --
225: IF csr_get_pa_id_ovn%NOTFOUND THEN
226: --
227: hr_utility.set_location(l_proc, 35);
228: --
229: -- This is the first balance to be associated with this assignment and
230: -- payroll run, so a new row needs to be created in the table
231: -- PER_BF_PROCESSED_ASSIGNMENTS.

Line 245: hr_utility.set_location(l_proc, 36);

241: );
242: --
243: ELSE
244: --
245: hr_utility.set_location(l_proc, 36);
246: --
247: -- A row exists in PER_BF_PROCESSED_ASSIGNMENTS for this payroll run and
248: -- assignment combination, so no need to do anything as the values
249: -- for the processed_assignment_id and object_version number are

Line 257: hr_utility.set_location(l_proc, 40);

253: --
254: END IF;
255: --
256: --
257: hr_utility.set_location(l_proc, 40);
258: --
259: -- Process Logic
260: --
261: per_bpd_ins.ins

Line 305: hr_utility.set_location(l_proc, 50);

301: ,p_payment_detail_id => l_payment_detail_id
302: ,p_object_version_number => l_payment_detail_ovn
303: );
304: --
305: hr_utility.set_location(l_proc, 50);
306: --
307: -- Call After Process User Hook
308: --
309: begin

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

357: (p_module_name => 'CREATE_PAYMENT_DETAIL'
358: ,p_hook_type => 'AP'
359: );
360: end;
361: hr_utility.set_location(l_proc, 60);
362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then

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

372: p_payment_detail_ovn := l_payment_detail_ovn;
373: p_processed_assignment_id := l_processed_assignment_id;
374: p_processed_assignment_ovn := l_processed_assignment_ovn;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 70);
377: exception
378: when hr_api.validate_enabled then
379: --
380: -- As the Validate_Enabled exception has been raised

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

389: p_payment_detail_id := null;
390: p_payment_detail_ovn := null;
391: p_processed_assignment_id := null;
392: p_processed_assignment_ovn := null;
393: hr_utility.set_location(' Leaving:'||l_proc, 80);
394: when others then
395: --
396: -- A validation or unexpected error has occured
397: --

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

400: p_payment_detail_id := null;
401: p_payment_detail_ovn := null;
402: p_processed_assignment_id := null;
403: p_processed_assignment_ovn := null;
404: hr_utility.set_location(' Leaving:'||l_proc, 90);
405: raise;
406: end CREATE_PAYMENT_DETAIL;
407: --
408: -- ----------------------------------------------------------------------------

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

455: l_payment_detail_ovn PER_BF_PAYMENT_DETAILS.OBJECT_VERSION_NUMBER%TYPE;
456: --
457: l_proc varchar2(72) := g_package||'update_payment_detail';
458: begin
459: hr_utility.set_location('Entering:'|| l_proc, 10);
460: --
461: -- Issue a savepoint
462: --
463: savepoint update_payment_detail;

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

460: --
461: -- Issue a savepoint
462: --
463: savepoint update_payment_detail;
464: hr_utility.set_location(l_proc, 20);
465: --
466: -- Truncate the time portion from all IN date parameters
467: --
468:

Line 520: hr_utility.set_location(l_proc, 30);

516: (p_module_name => 'UPDATE_PAYMENT_DETAIL'
517: ,p_hook_type => 'BP'
518: );
519: end;
520: hr_utility.set_location(l_proc, 30);
521: --
522: -- Validation in addition to Row Handlers
523: --
524: hr_utility.set_location(l_proc, 40);

Line 524: hr_utility.set_location(l_proc, 40);

520: hr_utility.set_location(l_proc, 30);
521: --
522: -- Validation in addition to Row Handlers
523: --
524: hr_utility.set_location(l_proc, 40);
525: --
526: chk_currency_code
527: (p_currency_code => p_currency_code
528: ,p_payment_detail_id => p_payment_detail_id

Line 577: hr_utility.set_location(l_proc, 50);

573: ,p_payment_detail_id => p_payment_detail_id
574: ,p_object_version_number => l_payment_detail_ovn
575: );
576: --
577: hr_utility.set_location(l_proc, 50);
578: --
579: -- Call After Process User Hook
580: --
581: begin

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

625: (p_module_name => 'UPDATE_PAYMENT_DETAIL'
626: ,p_hook_type => 'AP'
627: );
628: end;
629: hr_utility.set_location(l_proc, 60);
630: --
631: -- When in validation only mode raise the Validate_Enabled exception
632: --
633: if p_validate then

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

637: -- Set all output arguments
638: --
639: p_payment_detail_ovn := l_payment_detail_ovn;
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 70);
642: exception
643: when hr_api.validate_enabled then
644: --
645: -- As the Validate_Enabled exception has been raised

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

652: -- when validation only mode is being used.)
653: --
654: p_payment_detail_ovn := null;
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 80);
657: when others then
658: --
659: -- A validation or unexpected error has occured
660: --

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

660: --
661: rollback to UPDATE_PAYMENT_DETAIL;
662: --set out NOCOPY variables
663: p_payment_detail_ovn := null;
664: hr_utility.set_location(' Leaving:'||l_proc, 90);
665: raise;
666: end UPDATE_PAYMENT_DETAIL;
667: -- ----------------------------------------------------------------------------
668: -- |-----------------------< >------------------------|

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

700: --
701: l_proc varchar2(72) := g_package||'delete_payment_detail';
702: --
703: begin
704: hr_utility.set_location('Entering:'|| l_proc, 10);
705: --
706: -- Issue a savepoint
707: --
708: savepoint delete_payment_detail;

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

705: --
706: -- Issue a savepoint
707: --
708: savepoint delete_payment_detail;
709: hr_utility.set_location(l_proc, 20);
710: --
711: -- Truncate the time portion from all IN date parameters
712: --
713:

Line 729: hr_utility.set_location(l_proc, 30);

725: (p_module_name => 'DELETE_PAYMENT_DETAIL'
726: ,p_hook_type => 'BP'
727: );
728: end;
729: hr_utility.set_location(l_proc, 30);
730: --
731: -- Validation in addition to Row Handlers
732: --
733: hr_utility.set_location(l_proc, 40);

Line 733: hr_utility.set_location(l_proc, 40);

729: hr_utility.set_location(l_proc, 30);
730: --
731: -- Validation in addition to Row Handlers
732: --
733: hr_utility.set_location(l_proc, 40);
734: --
735: -- Process Logic
736: --
737: -- If no other entity uses the processed_assignment row that the FK

Line 788: hr_utility.set_location(l_proc, 50);

784: );
785: --
786: END IF;
787:
788: hr_utility.set_location(l_proc, 50);
789: --
790: -- Call After Process User Hook
791: --
792: begin

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

800: (p_module_name => 'DELETE_PAYMENT_DETAIL'
801: ,p_hook_type => 'AP'
802: );
803: end;
804: hr_utility.set_location(l_proc, 60);
805: --
806: -- When in validation only mode raise the Validate_Enabled exception
807: --
808: if p_validate then

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

811: --
812: -- Set all output arguments
813: --
814: --
815: hr_utility.set_location(' Leaving:'||l_proc, 70);
816: exception
817: when hr_api.validate_enabled then
818: --
819: -- As the Validate_Enabled exception has been raised

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

824: -- Only set output warning arguments
825: -- (Any key or derived arguments must be set to null
826: -- when validation only mode is being used.)
827: --
828: hr_utility.set_location(' Leaving:'||l_proc, 80);
829: when others then
830: --
831: -- A validation or unexpected error has occured
832: --

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

830: --
831: -- A validation or unexpected error has occured
832: --
833: rollback to DELETE_PAYMENT_DETAIL;
834: hr_utility.set_location(' Leaving:'||l_proc, 90);
835: raise;
836: end DELETE_PAYMENT_DETAIL;
837:
838: end PER_BF_PAYMENT_DETAILS_API;