[Home] [Help]
36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------
96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_res_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_res_bus.g_cagr_entitlement_result_id := p_cagr_entitlement_result_id;
142: per_res_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------
198: --
199: -- Checks to ensure non-updateable args have
200: -- not been updated.
201: --
202: hr_utility.set_location(l_proc, 30);
203: --
204: if nvl(p_rec.assignment_id, hr_api.g_number) <>
205: nvl(per_res_shd.g_old_rec.assignment_id
206: ,hr_api.g_number) then
460: --
461:
462: Begin
463: --
464: hr_utility.set_location('Entering:'|| l_proc, 1);
465: --
466: hr_api.mandatory_arg_error
467: (p_api_name => l_proc
468: ,p_argument => 'effective_date'
470: );
471: --
472: if p_chosen_flag is not null then
473: --
474: hr_utility.set_location(l_proc, 5);
475: -- Only proceed with validation if :
476: -- Updating and the value for chosen_flag has changed
477: --
478: if ((p_cagr_entitlement_result_id is not null) and
484: ,p_lookup_code => p_chosen_flag
485: )
486: then
487: --
488: hr_utility.set_message(800, 'HR_XXXXXX_CAGR_INV_CHOSEN');
489: hr_utility.raise_error;
490: --
491: end if;
492: end if;
485: )
486: then
487: --
488: hr_utility.set_message(800, 'HR_XXXXXX_CAGR_INV_CHOSEN');
489: hr_utility.raise_error;
490: --
491: end if;
492: end if;
493: end if;
492: end if;
493: end if;
494:
495: --
496: hr_utility.set_location(' Leaving:'|| l_proc, 20);
497: --
498: End chk_chosen_flag;
499:
500: --
550: --
551: l_proc varchar2(72) := g_package||'insert_validate';
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: -- Error out - this rowhandler should not be used to insert data as only
557: -- per_cagr_engine_pkg may write records to the per_cagr_entitlement_results table.
558: --
555: --
556: -- Error out - this rowhandler should not be used to insert data as only
557: -- per_cagr_engine_pkg may write records to the per_cagr_entitlement_results table.
558: --
559: hr_utility.set_message(800, 'HR_XXXXX_CAGR_INV_RES_INS');
560: hr_utility.raise_error;
561: --
562: --
563: --
556: -- Error out - this rowhandler should not be used to insert data as only
557: -- per_cagr_engine_pkg may write records to the per_cagr_entitlement_results table.
558: --
559: hr_utility.set_message(800, 'HR_XXXXX_CAGR_INV_RES_INS');
560: hr_utility.raise_error;
561: --
562: --
563: --
564: --
561: --
562: --
563: --
564: --
565: hr_utility.set_location(' Leaving:'||l_proc, 10);
566: End insert_validate;
567: --
568: -- ----------------------------------------------------------------------------
569: -- |---------------------------< update_validate >----------------------------|
575: --
576: l_proc varchar2(72) := g_package||'update_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call all supporting business operations
582: --
583: --
593: ,p_chosen_flag => p_rec.chosen_flag
594: ,p_effective_date => p_effective_date);
595: --
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598: End update_validate;
599: --
600: -- ----------------------------------------------------------------------------
601: -- |---------------------------< delete_validate >----------------------------|
606: --
607: l_proc varchar2(72) := g_package||'delete_validate';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: --
613: chk_startup_action(false
614: ,per_res_shd.g_old_rec.business_group_id
620: END IF;
621: --
622: -- Call all supporting business operations
623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: End delete_validate;
626: --
627: end per_res_bus;