DBA Data[Home] [Help]

APPS.PER_BF_BALANCE_AMOUNTS_API dependencies on HR_UTILITY

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

54: -- The UOM is Money, so need to ensure the currency is the same
55: --
56: IF p_currency_code IS NULL THEN
57: -- Need to error, as if the type is money, as currency is required
58: hr_utility.set_message(800,'HR_50401_NEED_CURR_CODE');
59: hr_utility.raise_error;
60: END IF;
61: IF l_currency <> p_currency_code THEN
62: -- The currency being passed in is different than the currency

Line 59: hr_utility.raise_error;

55: --
56: IF p_currency_code IS NULL THEN
57: -- Need to error, as if the type is money, as currency is required
58: hr_utility.set_message(800,'HR_50401_NEED_CURR_CODE');
59: hr_utility.raise_error;
60: END IF;
61: IF l_currency <> p_currency_code THEN
62: -- The currency being passed in is different than the currency
63: -- that the business group is expecting, so error!

Line 65: hr_utility.set_message(800,'HR_50402_WRONG_CURR_CODE');

61: IF l_currency <> p_currency_code THEN
62: -- The currency being passed in is different than the currency
63: -- that the business group is expecting, so error!
64: --
65: hr_utility.set_message(800,'HR_50402_WRONG_CURR_CODE');
66: hr_utility.raise_error;
67: --
68: END IF;
69: END IF;

Line 66: hr_utility.raise_error;

62: -- The currency being passed in is different than the currency
63: -- that the business group is expecting, so error!
64: --
65: hr_utility.set_message(800,'HR_50402_WRONG_CURR_CODE');
66: hr_utility.raise_error;
67: --
68: END IF;
69: END IF;
70: --

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

147: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
148: --
149: l_proc varchar2(72) := g_package||'create_balance_amount';
150: begin
151: hr_utility.set_location('Entering:'|| l_proc, 10);
152: --
153: -- Issue a savepoint
154: --
155: savepoint create_balance_amount;

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

152: --
153: -- Issue a savepoint
154: --
155: savepoint create_balance_amount;
156: hr_utility.set_location(l_proc, 20);
157: --
158: -- Truncate the time portion from all IN date parameters
159: --
160: --

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

214: (p_module_name => 'CREATE_BALANCE_AMOUNT'
215: ,p_hook_type => 'BP'
216: );
217: end;
218: hr_utility.set_location(l_proc, 30);
219: --
220: -- Validation in addition to Row Handlers
221: --
222: -- check to ensure that the currency code of the values being passed in

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

230: , l_processed_assignment_ovn;
231: --
232: IF csr_get_pa_id_ovn%NOTFOUND THEN
233: --
234: hr_utility.set_location(l_proc, 35);
235: --
236: -- This is the first balance to be associated with this assignment and
237: -- payroll run, so a new row needs to be created in the table
238: -- PER_BF_PROCESSED_ASSIGNMENTS.

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

248: );
249: --
250: ELSE
251: --
252: hr_utility.set_location(l_proc, 36);
253: --
254: -- A row exists in PER_BF_PROCESSED_ASSIGNMENTS for this payroll run and
255: -- assignment combination, so no need to do anything as the values
256: -- for the processed_assignment_id and object_version number are

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

260: --
261: END IF;
262: --
263: --
264: hr_utility.set_location(l_proc, 40);
265: --
266: -- Process Logic
267: --
268: per_bba_ins.ins

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

313:
314: );
315: --
316: --
317: hr_utility.set_location(l_proc, 50);
318: --
319: -- Call After Process User Hook
320: --
321: begin

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

374: (p_module_name => 'CREATE_BALANCE_AMOUNT'
375: ,p_hook_type => 'AP'
376: );
377: end;
378: hr_utility.set_location(l_proc, 60);
379: --
380: -- When in validation only mode raise the Validate_Enabled exception
381: --
382: if p_validate then

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

389: p_balance_amount_ovn := l_balance_amount_ovn;
390: p_processed_assignment_id := l_processed_assignment_id;
391: p_processed_assignment_ovn:= l_processed_assignment_ovn;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: exception
395: when hr_api.validate_enabled then
396: --
397: -- As the Validate_Enabled exception has been raised

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

407: p_balance_amount_ovn := null;
408: p_processed_assignment_id := null;
409: p_processed_assignment_ovn:= null;
410: --
411: hr_utility.set_location(' Leaving:'||l_proc, 80);
412: when others then
413: --
414: -- A validation or unexpected error has occured
415: --

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

419: p_balance_amount_id := null;
420: p_balance_amount_ovn := null;
421: p_processed_assignment_id := null;
422: p_processed_assignment_ovn:= null;
423: hr_utility.set_location(' Leaving:'||l_proc, 90);
424: raise;
425: end CREATE_BALANCE_AMOUNT;
426: --
427: --

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

488: PER_BF_BALANCE_AMOUNTS.object_version_number%TYPE;
489: --
490: l_proc varchar2(72) := g_package||'update_balance_amount';
491: begin
492: hr_utility.set_location('Entering:'|| l_proc, 10);
493: --
494: -- Issue a savepoint
495: --
496: savepoint update_balance_amount;

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

493: --
494: -- Issue a savepoint
495: --
496: savepoint update_balance_amount;
497: hr_utility.set_location(l_proc, 20);
498: --
499: -- Truncate the time portion from all IN date parameters
500: --
501: --

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

553: (p_module_name => 'UPDATE_BALANCE_AMOUNT'
554: ,p_hook_type => 'BP'
555: );
556: end;
557: hr_utility.set_location(l_proc, 30);
558: --
559: -- Validation in addition to Row Handlers
560: --
561: OPEN csr_get_bbt;

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

568: ,p_balance_type_id => l_balance_type_id
569: ,p_effective_date => p_effective_date);
570: --
571: --
572: hr_utility.set_location(l_proc, 40);
573: --
574: -- Process Logic
575: --
576: l_balance_amount_ovn := p_balance_amount_ovn;

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

619: ,p_object_version_number => l_balance_amount_ovn
620: );
621: --
622: --
623: hr_utility.set_location(l_proc, 50);
624: --
625: -- Call After Process User Hook
626: --
627: begin

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

674: (p_module_name => 'UPDATE_BALANCE_AMOUNT'
675: ,p_hook_type => 'AP'
676: );
677: end;
678: hr_utility.set_location(l_proc, 60);
679: --
680: -- When in validation only mode raise the Validate_Enabled exception
681: --
682: if p_validate then

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

686: -- Set all output arguments
687: --
688: p_balance_amount_ovn := l_balance_amount_ovn;
689: --
690: hr_utility.set_location(' Leaving:'||l_proc, 70);
691: exception
692: when hr_api.validate_enabled then
693: --
694: -- As the Validate_Enabled exception has been raised

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

701: -- when validation only mode is being used.)
702: --
703: p_balance_amount_ovn := null;
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 80);
706: when others then
707: --
708: -- A validation or unexpected error has occured
709: --

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

709: --
710: rollback to update_balance_amount;
711: -- set out variable
712: p_balance_amount_ovn := null;
713: hr_utility.set_location(' Leaving:'||l_proc, 90);
714: raise;
715: end UPDATE_BALANCE_AMOUNT;
716: --
717: -- ----------------------------------------------------------------------------

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

750: l_temp VARCHAR2(1);
751: l_delete_pa_row BOOLEAN;
752: l_proc varchar2(72) := g_package||'delete_balance_amount';
753: begin
754: hr_utility.set_location('Entering:'|| l_proc, 10);
755: --
756: -- Issue a savepoint
757: --
758: savepoint delete_balance_amount;

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

755: --
756: -- Issue a savepoint
757: --
758: savepoint delete_balance_amount;
759: hr_utility.set_location(l_proc, 20);
760: --
761: -- Truncate the time portion from all IN date parameters
762: --
763: --

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

777: (p_module_name => 'DELETE_BALANCE_AMOUNT'
778: ,p_hook_type => 'BP'
779: );
780: end;
781: hr_utility.set_location(l_proc, 30);
782: --
783: -- Validation in addition to Row Handlers
784: --
785: --

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

782: --
783: -- Validation in addition to Row Handlers
784: --
785: --
786: hr_utility.set_location(l_proc, 40);
787: --
788: -- Process Logic
789: --
790: --

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

842: );
843: --
844: END IF;
845: --
846: hr_utility.set_location(l_proc, 50);
847: --
848: -- Call After Process User Hook
849: --
850: begin

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

859: (p_module_name => 'DELETE_BALANCE_AMOUNT'
860: ,p_hook_type => 'AP'
861: );
862: end;
863: hr_utility.set_location(l_proc, 60);
864: --
865: -- When in validation only mode raise the Validate_Enabled exception
866: --
867: if p_validate then

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

869: end if;
870: --
871: -- Set all output arguments
872: --
873: hr_utility.set_location(' Leaving:'||l_proc, 70);
874: exception
875: when hr_api.validate_enabled then
876: --
877: -- As the Validate_Enabled exception has been raised

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

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

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

888: --
889: -- A validation or unexpected error has occured
890: --
891: rollback to delete_balance_amount;
892: hr_utility.set_location(' Leaving:'||l_proc, 90);
893: raise;
894: end DELETE_BALANCE_AMOUNT;
895: --
896: end PER_BF_BALANCE_AMOUNTS_API;