DBA Data[Home] [Help]

APPS.PAY_BALANCE_TYPES_API dependencies on HR_UTILITY

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

60: l_object_version_number pay_balance_types.object_version_number%type;
61: l_default_currency_code pay_balance_types.currency_code%type;
62: l_proc varchar2(72) := g_package||'create_bal_type';
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Issue a savepoint
67: --
68: savepoint CREATE_BAL_TYPE;

Line 79: hr_utility.set_location('Entering:'|| l_proc, 20);

75: -- Validation in addition to Row Handlers
76: --
77: -- assign default value to currency
78:
79: hr_utility.set_location('Entering:'|| l_proc, 20);
80:
81: if (p_balance_uom = 'M' and p_currency_code is null) then
82: -- Get the default currency based on the legislation
83: --

Line 102: hr_utility.set_location('Entering:'|| l_proc, 30);

98: else
99: l_default_currency_code := p_currency_code;
100: end if;
101: --
102: hr_utility.set_location('Entering:'|| l_proc, 30);
103: --
104: -- Call Before Process User Hook
105: --
106: begin

Line 154: hr_utility.set_location('Entering:'|| l_proc, 40);

150: ,p_hook_type => 'BP'
151: );
152: end;
153: --
154: hr_utility.set_location('Entering:'|| l_proc, 40);
155: --
156: -- Process Logic
157: --
158: pay_blt_ins.ins

Line 199: hr_utility.set_location('Entering:'|| l_proc, 50);

195: ,p_balance_type_id => l_balance_type_id
196: ,p_object_version_number => l_object_version_number
197: );
198: --
199: hr_utility.set_location('Entering:'|| l_proc, 50);
200: --
201: -- Create default entries in pay_balance_types_tl table
202: --
203: pay_btt_ins.ins_tl

Line 213: hr_utility.set_location('Entering:'|| l_proc, 60);

209: --
210: -- Call After Process User Hook
211: --
212: --
213: hr_utility.set_location('Entering:'|| l_proc, 60);
214: --
215: begin
216: PAY_BALANCE_TYPES_BK1.create_bal_type_a
217: (p_effective_date => l_effective_date

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

273: p_balance_type_id := l_balance_type_id;
274: p_object_version_number := l_object_version_number;
275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278: exception
279: when hr_api.validate_enabled then
280: --
281: -- As the Validate_Enabled exception has been raised

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

289: --
290: p_balance_type_id := null;
291: p_object_version_number := null;
292:
293: hr_utility.set_location(' Leaving:'||l_proc, 80);
294: when others then
295: --
296: -- A validation or unexpected error has occured
297: --

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

302: --
303: p_balance_type_id := null;
304: p_object_version_number := null;
305:
306: hr_utility.set_location(' Leaving:'||l_proc, 90);
307: raise;
308: end CREATE_BAL_TYPE;
309: --
310: -- ----------------------------------------------------------------------------

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

367: l_balance_name_warning number;
368: l_effective_date date;
369: l_proc varchar2(72) := g_package||'UPDATE_BAL_TYPE';
370: begin
371: hr_utility.set_location('Entering:'|| l_proc, 10);
372: --
373: -- Issue a savepoint
374: --
375: savepoint UPDATE_BAL_TYPE;

Line 387: hr_utility.set_location('Entering:'|| l_proc, 20);

383: --
384: l_effective_date := trunc(p_effective_date);
385: --
386: --
387: hr_utility.set_location('Entering:'|| l_proc, 20);
388: --
389: --
390: -- Call Before Process User Hook
391: --

Line 440: hr_utility.set_location('Entering:'|| l_proc, 30);

436: --
437: -- Validation in addition to Row Handlers
438: --
439: --
440: hr_utility.set_location('Entering:'|| l_proc, 30);
441: --
442: --
443: open csr_derived_values;
444: fetch csr_derived_values into l_business_group_id,l_legislation_code,

Line 449: hr_utility.set_location('Entering:'|| l_proc, 40);

445: l_legislation_subgroup;
446: close csr_derived_values;
447: --
448: --
449: hr_utility.set_location('Entering:'|| l_proc, 40);
450: --
451: -- assign default value to currency
452: if (p_balance_uom = 'M' and p_currency_code is null) then
453: -- Get the default currency based on the legislation

Line 472: hr_utility.set_location('Entering:'|| l_proc, 50);

468: else
469: l_default_currency_code := p_currency_code;
470: end if;
471: --
472: hr_utility.set_location('Entering:'|| l_proc, 50);
473: --
474: --
475: -- Process Logic
476: --

Line 517: hr_utility.set_location('Entering:'|| l_proc, 60);

513: ,p_input_value_id => p_input_value_id
514: ,p_balance_name_warning => l_balance_name_warning
515: );
516: --
517: hr_utility.set_location('Entering:'|| l_proc, 60);
518: --
519: --
520: -- Update the translation table values
521: --

Line 531: hr_utility.set_location('Entering:'|| l_proc, 70);

527: );
528:
529: --
530: --
531: hr_utility.set_location('Entering:'|| l_proc, 70);
532: --
533: --
534: -- Call After Process User Hook
535: --

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

590: p_object_version_number := l_object_version_number;
591: p_balance_name_warning := l_balance_name_warning;
592:
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 80);
595: exception
596: when hr_api.validate_enabled then
597: --
598: -- As the Validate_Enabled exception has been raised

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

605: -- when validation only mode is being used.)
606: --
607: p_object_version_number := null;
608: p_balance_name_warning := l_balance_name_warning;
609: hr_utility.set_location(' Leaving:'||l_proc, 90);
610: when others then
611: --
612: -- A validation or unexpected error has occured
613: --

Line 622: hr_utility.set_location(' Leaving:'||l_proc, 100);

618: --
619:
620: p_object_version_number := null;
621: p_balance_name_warning := null;
622: hr_utility.set_location(' Leaving:'||l_proc, 100);
623: raise;
624: end UPDATE_BAL_TYPE;
625: --
626: -- ----------------------------------------------------------------------------

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

637: --
638: l_object_version_number number;
639: l_proc varchar2(72) := g_package||'DELETE_BAL_TYPE';
640: begin
641: hr_utility.set_location('Entering:'|| l_proc, 10);
642: --
643: -- Issue a savepoint
644: --
645: savepoint DELETE_BAL_TYPE;

Line 652: hr_utility.set_location('Entering:'|| l_proc, 20);

648: --
649: l_object_version_number := p_object_version_number;
650:
651: --
652: hr_utility.set_location('Entering:'|| l_proc, 20);
653: --
654: --
655: -- Call Before Process User Hook
656: --

Line 673: hr_utility.set_location('Entering:'|| l_proc, 30);

669: --
670: -- Validation in addition to Row Handlers
671: --
672: --
673: hr_utility.set_location('Entering:'|| l_proc, 30);
674: --
675: --
676: -- Process Logic
677: --

Line 686: hr_utility.set_location('Entering:'|| l_proc, 40);

682: --
683: -- delete from translation table
684: --
685: --
686: hr_utility.set_location('Entering:'|| l_proc, 40);
687: --
688: pay_btt_del.del_tl
689: (p_balance_type_id => p_balance_type_id
690: ,p_associated_column1 => null

Line 694: hr_utility.set_location('Entering:'|| l_proc, 50);

690: ,p_associated_column1 => null
691: );
692: --
693: --
694: hr_utility.set_location('Entering:'|| l_proc, 50);
695: --
696: --
697: -- Call After Process User Hook
698: --

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

718: -- Set all IN OUT and OUT parameters with out values
719: --
720: p_object_version_number := l_object_version_number;
721: --
722: hr_utility.set_location(' Leaving:'||l_proc, 70);
723: exception
724: when hr_api.validate_enabled then
725: --
726: -- As the Validate_Enabled exception has been raised

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

732: -- (Any key or derived arguments must be set to null
733: -- when validation only mode is being used.)
734: --
735: p_object_version_number := null;
736: hr_utility.set_location(' Leaving:'||l_proc, 80);
737: when others then
738: --
739: -- A validation or unexpected error has occured
740: --

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

744: -- OUT parameters, including warnings, to null
745: --
746:
747: p_object_version_number := null;
748: hr_utility.set_location(' Leaving:'||l_proc, 90);
749: raise;
750: end DELETE_BAL_TYPE;
751: --
752: end PAY_BALANCE_TYPES_API;