DBA Data[Home] [Help]

APPS.PER_BPR_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

66: hr_api.set_security_group_id
67: (p_security_group_id => l_security_group_id
68: );
69: --
70: hr_utility.set_location(' Leaving:'|| l_proc, 20);
71: --
72: end set_security_group_id;
73: --
74: -- ---------------------------------------------------------------------------

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

93: l_proc varchar2(72) := g_package||'return_legislation_code';
94: --
95: begin
96: --
97: hr_utility.set_location('Entering:'|| l_proc, 10);
98: --
99: -- Ensure that all the mandatory parameter are not null
100: --
101: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

108: -- call to this function. Just return the value in the global
109: -- variable.
110: --
111: l_legislation_code := g_legislation_code;
112: hr_utility.set_location(l_proc, 20);
113: else
114: --
115: -- The ID is different to the last call to this function
116: -- or this is the first call to this function.

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

125: close csr_leg_code;
126: fnd_message.set_name('PER','HR_7220_INVALID_PRIMARY_KEY');
127: fnd_message.raise_error;
128: end if;
129: hr_utility.set_location(l_proc,30);
130: --
131: -- Set the global variables so the values are
132: -- available for the next call to this function.
133: --

Line 138: hr_utility.set_location(' Leaving:'|| l_proc, 40);

134: close csr_leg_code;
135: g_payroll_run_id := p_payroll_run_id;
136: g_legislation_code := l_legislation_code;
137: end if;
138: hr_utility.set_location(' Leaving:'|| l_proc, 40);
139: return l_legislation_code;
140: end return_legislation_code;
141: --
142: -- ----------------------------------------------------------------------------

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

173: --
174: l_proc varchar2(72) := g_package || 'chk_df';
175: --
176: begin
177: hr_utility.set_location('Entering:'||l_proc,10);
178: --
179: if ((p_rec.payroll_run_id is not null) and (
180: nvl(per_bpr_shd.g_old_rec.bpr_attribute_category, hr_api.g_varchar2) <>
181: nvl(p_rec.bpr_attribute_category, hr_api.g_varchar2) or

Line 316: hr_utility.set_location(' Leaving:'||l_proc,20);

312: ,p_attribute30_value => p_rec.bpr_attribute30
313: );
314: end if;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc,20);
317: end chk_df;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |----------------------< check_non_updateable_args >-----------------------|

Line 353: hr_utility.set_location('Entering:'||l_proc,5);

349: l_error EXCEPTION;
350: l_argument varchar2(30);
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc,5);
354: --
355: -- Only proceed with the validation if a row exists for the current
356: -- record in the HR Schema.
357: --

Line 362: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

358: IF NOT per_bpr_shd.api_updating
359: (p_payroll_run_id => p_rec.payroll_run_id
360: ,p_object_version_number => p_rec.object_version_number
361: ) THEN
362: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
363: hr_utility.set_message_token('PROCEDURE ', l_proc);
364: hr_utility.set_message_token('STEP ', '5');
365: END IF;
366: --

Line 363: hr_utility.set_message_token('PROCEDURE ', l_proc);

359: (p_payroll_run_id => p_rec.payroll_run_id
360: ,p_object_version_number => p_rec.object_version_number
361: ) THEN
362: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
363: hr_utility.set_message_token('PROCEDURE ', l_proc);
364: hr_utility.set_message_token('STEP ', '5');
365: END IF;
366: --
367: hr_utility.set_location(l_proc,10);

Line 364: hr_utility.set_message_token('STEP ', '5');

360: ,p_object_version_number => p_rec.object_version_number
361: ) THEN
362: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
363: hr_utility.set_message_token('PROCEDURE ', l_proc);
364: hr_utility.set_message_token('STEP ', '5');
365: END IF;
366: --
367: hr_utility.set_location(l_proc,10);
368: --

Line 367: hr_utility.set_location(l_proc,10);

363: hr_utility.set_message_token('PROCEDURE ', l_proc);
364: hr_utility.set_message_token('STEP ', '5');
365: END IF;
366: --
367: hr_utility.set_location(l_proc,10);
368: --
369: IF nvl(p_rec.payroll_id, hr_api.g_number) <>
370: per_bpr_shd.g_old_rec.payroll_id then
371: l_argument:='payroll_id';

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

370: per_bpr_shd.g_old_rec.payroll_id then
371: l_argument:='payroll_id';
372: raise l_error;
373: END IF;
374: hr_utility.set_location(l_proc,20);
375: --
376: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
377: per_bpr_shd.g_old_rec.business_group_id then
378: l_argument:='business_group_id';

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

377: per_bpr_shd.g_old_rec.business_group_id then
378: l_argument:='business_group_id';
379: raise l_error;
380: END IF;
381: hr_utility.set_location(l_proc,30);
382: --
383: --
384: EXCEPTION
385: WHEN l_error THEN

Line 391: hr_utility.set_location(' Leaving:'||l_proc,20);

387: (p_api_name => l_proc
388: ,p_argument => l_argument);
389: WHEN OTHERS THEN
390: RAISE;
391: hr_utility.set_location(' Leaving:'||l_proc,20);
392: End chk_non_updateable_args;
393: --
394: -- ----------------------------------------------------------------------------
395: -- |---------------------------< chk_identifier >-----------------------------|

Line 431: hr_utility.set_location ('Entering:'|| l_proc, 1);

427: AND business_group_id = p_business_group_id ;
428: --
429: l_temp VARCHAR2(1);
430: begin
431: hr_utility.set_location ('Entering:'|| l_proc, 1);
432: --
433: --
434: -- Check that the business_group_id is not null.
435: --

Line 500: hr_utility.set_location('Entering:'||l_proc, 5);

496: l_processing_date DATE;
497: l_api_updating BOOLEAN;
498: --
499: BEGIN
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: l_api_updating := per_bpr_shd.api_updating
503: (p_payroll_run_id => p_payroll_run_id
504: ,p_object_version_number => p_object_version_number

Line 534: hr_utility.set_message(800,'HR_52932_ALL_DATES_NULL');

530: --
531: -- All the dates are Null, so raise an error as at least one must be
532: -- set.
533: --
534: hr_utility.set_message(800,'HR_52932_ALL_DATES_NULL');
535: hr_utility.raise_error;
536: END IF;
537: END IF;
538: END IF;

Line 535: hr_utility.raise_error;

531: -- All the dates are Null, so raise an error as at least one must be
532: -- set.
533: --
534: hr_utility.set_message(800,'HR_52932_ALL_DATES_NULL');
535: hr_utility.raise_error;
536: END IF;
537: END IF;
538: END IF;
539: --

Line 585: hr_utility.set_message(800,'HR_52608_PROC_DATE_PROB');

581: --
582: IF l_start_date > l_processing_date THEN
583: --
584: -- The start date is greater than the processing date
585: hr_utility.set_message(800,'HR_52608_PROC_DATE_PROB');
586: hr_utility.raise_error;
587: --
588: END IF;
589: END IF;

Line 586: hr_utility.raise_error;

582: IF l_start_date > l_processing_date THEN
583: --
584: -- The start date is greater than the processing date
585: hr_utility.set_message(800,'HR_52608_PROC_DATE_PROB');
586: hr_utility.raise_error;
587: --
588: END IF;
589: END IF;
590: --

Line 675: hr_utility.set_message (800,'HR_52933_DATE_START_END');

671: -- error
672: IF ((l_start_date IS NOT NULL) and (l_end_date IS NOT NULL)
673: AND (l_start_date > l_end_date)) THEN
674: --
675: hr_utility.set_message (800,'HR_52933_DATE_START_END');
676: hr_utility.raise_error;
677: --
678: END IF;
679: --

Line 676: hr_utility.raise_error;

672: IF ((l_start_date IS NOT NULL) and (l_end_date IS NOT NULL)
673: AND (l_start_date > l_end_date)) THEN
674: --
675: hr_utility.set_message (800,'HR_52933_DATE_START_END');
676: hr_utility.raise_error;
677: --
678: END IF;
679: --
680: IF ((l_start_date IS NULL) and (l_end_date IS NOT NULL))

Line 683: hr_utility.set_message (800,'HR_52607_DATE_START_NULL_END');

679: --
680: IF ((l_start_date IS NULL) and (l_end_date IS NOT NULL))
681: THEN
682: --
683: hr_utility.set_message (800,'HR_52607_DATE_START_NULL_END');
684: hr_utility.raise_error;
685: --
686: END IF;
687: END IF;

Line 684: hr_utility.raise_error;

680: IF ((l_start_date IS NULL) and (l_end_date IS NOT NULL))
681: THEN
682: --
683: hr_utility.set_message (800,'HR_52607_DATE_START_NULL_END');
684: hr_utility.raise_error;
685: --
686: END IF;
687: END IF;
688: END chk_date_start_end;

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

706: from per_bf_processed_assignments bpa
707: where bpa.payroll_run_id = p_payroll_run_id;
708: --
709: begin
710: hr_utility.set_location('Entering: '||l_proc, 10);
711: --
712: if p_payroll_run_id is not null then
713: open csr_payroll_exists;
714: fetch csr_payroll_exists into l_exists;

Line 735: hr_utility.set_location('Entering:'||l_proc, 5);

731: --
732: l_proc varchar2(72) := g_package||'insert_validate';
733: --
734: Begin
735: hr_utility.set_location('Entering:'||l_proc, 5);
736: --
737: -- Call all supporting business operations.
738: --
739: --

Line 767: hr_utility.set_location(' Leaving:'||l_proc, 10);

763: -- Validate flexfields
764: -- ===================
765: chk_df(p_rec => p_rec);
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 10);
768: End insert_validate;
769: --
770: -- ----------------------------------------------------------------------------
771: -- |---------------------------< update_validate >----------------------------|

Line 780: hr_utility.set_location('Entering:'||l_proc, 5);

776: --
777: l_proc varchar2(72) := g_package||'update_validate';
778: --
779: Begin
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: -- Call all supporting business operations
783: --
784: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 818: hr_utility.set_location(' Leaving:'||l_proc, 10);

814: -- Validate flexfields
815: -- ===================
816: chk_df(p_rec => p_rec);
817: --
818: hr_utility.set_location(' Leaving:'||l_proc, 10);
819: End update_validate;
820: --
821: -- ----------------------------------------------------------------------------
822: -- |---------------------------< delete_validate >----------------------------|

Line 829: hr_utility.set_location('Entering:'||l_proc, 5);

825: --
826: l_proc varchar2(72) := g_package||'delete_validate';
827: --
828: Begin
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: -- Call all supporting business operations
832: --
833: chk_row_exists(p_payroll_run_id => p_rec.payroll_run_id);

Line 835: hr_utility.set_location(' Leaving:'||l_proc, 10);

831: -- Call all supporting business operations
832: --
833: chk_row_exists(p_payroll_run_id => p_rec.payroll_run_id);
834: --
835: hr_utility.set_location(' Leaving:'||l_proc, 10);
836: End delete_validate;
837: --
838: end per_bpr_bus;