257: end if;
258: close C_Sel2;
259: -- if all approver types are allowed for the current transaction ,then return
260: if l_config_value = 'no' then
261: fnd_message.set_name('PER','AME_400618_INV_APG_MEM_TXNTYP');
262: fnd_message.raise_error;
263: end if;
264: end loop;
265: end if;
258: close C_Sel2;
259: -- if all approver types are allowed for the current transaction ,then return
260: if l_config_value = 'no' then
261: fnd_message.set_name('PER','AME_400618_INV_APG_MEM_TXNTYP');
262: fnd_message.raise_error;
263: end if;
264: end loop;
265: end if;
266: hr_utility.set_location(' Leaving:'||l_proc,30);
334: open C_Sel1;
335: fetch C_Sel1 into l_count;
336: close C_Sel1;
337: if l_count = 0 then
338: fnd_message.set_name('PER','AME_400557_INVALID_APG_ID');
339: fnd_message.raise_error;
340: end if;
341: -- Check if the approval_group exists and has is_static = 'Y'
342: open C_Sel2;
335: fetch C_Sel1 into l_count;
336: close C_Sel1;
337: if l_count = 0 then
338: fnd_message.set_name('PER','AME_400557_INVALID_APG_ID');
339: fnd_message.raise_error;
340: end if;
341: -- Check if the approval_group exists and has is_static = 'Y'
342: open C_Sel2;
343: fetch C_Sel2 into l_count;
342: open C_Sel2;
343: fetch C_Sel2 into l_count;
344: close C_Sel2;
345: if l_count = 0 then
346: fnd_message.set_name('PER','AME_400801_INV_STATIC_APG');
347: fnd_message.raise_error;
348: end if;
349: hr_utility.set_location(' Leaving:'||l_proc,30);
350: exception
343: fetch C_Sel2 into l_count;
344: close C_Sel2;
345: if l_count = 0 then
346: fnd_message.set_name('PER','AME_400801_INV_STATIC_APG');
347: fnd_message.raise_error;
348: end if;
349: hr_utility.set_location(' Leaving:'||l_proc,30);
350: exception
351: when app_exception.application_exception then
397: ,p_argument_value => p_parameter_name
398: );
399: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
400: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
401: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
402: fnd_message.raise_error;
403: end if;
404: hr_utility.set_location(' Leaving:'||l_proc,30);
405: exception
398: );
399: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')
400: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
401: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
402: fnd_message.raise_error;
403: end if;
404: hr_utility.set_location(' Leaving:'||l_proc,30);
405: exception
406: when app_exception.application_exception then
486: open C_Sel1;
487: fetch C_Sel1 into l_count;
488: close C_Sel1;
489: if (l_count = 0) then
490: fnd_message.set_name('PER','AME_400568_INV_APG_ITM_PARAM');
491: fnd_message.raise_error;
492: end if;
493: /*get_allowed_nested_groups
494: (
487: fetch C_Sel1 into l_count;
488: close C_Sel1;
489: if (l_count = 0) then
490: fnd_message.set_name('PER','AME_400568_INV_APG_ITM_PARAM');
491: fnd_message.raise_error;
492: end if;
493: /*get_allowed_nested_groups
494: (
495: p_approval_group_id => p_approval_group_id
506: end if;
507: end loop;
508: if l_parameter_allowed = false then
509: hr_utility.set_location('Leaving:'|| l_proc, 20);
510: fnd_message.set_name('AME','NESTED_GROUP_INVALID');
511: fnd_message.raise_error;
512: end if;
513: */
514: if not ( is_nesting_allowed(p_group => p_approval_group_id
507: end loop;
508: if l_parameter_allowed = false then
509: hr_utility.set_location('Leaving:'|| l_proc, 20);
510: fnd_message.set_name('AME','NESTED_GROUP_INVALID');
511: fnd_message.raise_error;
512: end if;
513: */
514: if not ( is_nesting_allowed(p_group => p_approval_group_id
515: ,p_nest => to_number(p_parameter)
515: ,p_nest => to_number(p_parameter)
516: )
517: ) then
518: hr_utility.set_location('Leaving:'|| l_proc, 20);
519: fnd_message.set_name('PER','AME_400569_NEST_APG_NOT_ALLOW');
520: fnd_message.raise_error;
521: end if;
522:
523: elsif p_parameter_name = 'wf_roles_name' then
516: )
517: ) then
518: hr_utility.set_location('Leaving:'|| l_proc, 20);
519: fnd_message.set_name('PER','AME_400569_NEST_APG_NOT_ALLOW');
520: fnd_message.raise_error;
521: end if;
522:
523: elsif p_parameter_name = 'wf_roles_name' then
524: open C_Sel2;
524: open C_Sel2;
525: fetch C_Sel2 into l_count;
526: close C_Sel2;
527: if (l_count = 0) then
528: fnd_message.set_name('PER','AME_400568_INV_APG_ITM_PARAM');
529: fnd_message.raise_error;
530: end if;
531: end if;
532: hr_utility.set_location(' Leaving:'||l_proc,30);
525: fetch C_Sel2 into l_count;
526: close C_Sel2;
527: if (l_count = 0) then
528: fnd_message.set_name('PER','AME_400568_INV_APG_ITM_PARAM');
529: fnd_message.raise_error;
530: end if;
531: end if;
532: hr_utility.set_location(' Leaving:'||l_proc,30);
533: exception
578: );
579: -- check if order_number is negative
580: --
581: if p_order_number <=0 then
582: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
583: fnd_message.raise_error;
584: end if;
585: hr_utility.set_location(' Leaving:'||l_proc,30);
586: exception
579: -- check if order_number is negative
580: --
581: if p_order_number <=0 then
582: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
583: fnd_message.raise_error;
584: end if;
585: hr_utility.set_location(' Leaving:'||l_proc,30);
586: exception
587: when app_exception.application_exception then
657: open C_Sel1;
658: fetch C_Sel1 into l_count;
659: close C_Sel1;
660: if (l_count <> 0) then
661: fnd_message.set_name('PER','AME_400570_APG_ITM_NON_UNIQ');
662: fnd_message.raise_error;
663: end if;
664: hr_utility.set_location(' Leaving:'||l_proc,30);
665: exception
658: fetch C_Sel1 into l_count;
659: close C_Sel1;
660: if (l_count <> 0) then
661: fnd_message.set_name('PER','AME_400570_APG_ITM_NON_UNIQ');
662: fnd_message.raise_error;
663: end if;
664: hr_utility.set_location(' Leaving:'||l_proc,30);
665: exception
666: when app_exception.application_exception then
725: (p_approval_group_item_id => p_rec.approval_group_item_id
726: ,p_effective_date => p_effective_date
727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
726: ,p_effective_date => p_effective_date
727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
734: --
727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
734: --
735: -- EDIT_HERE: Add checks to ensure non-updateable args have
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
734: --
735: -- EDIT_HERE: Add checks to ensure non-updateable args have
736: -- not been updated.
858: --
859: -- An unhandled or unexpected error has occurred which
860: -- we must report
861: --
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', l_proc);
864: fnd_message.set_token('STEP','15');
865: fnd_message.raise_error;
866: End dt_update_validate;
859: -- An unhandled or unexpected error has occurred which
860: -- we must report
861: --
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', l_proc);
864: fnd_message.set_token('STEP','15');
865: fnd_message.raise_error;
866: End dt_update_validate;
867: --
860: -- we must report
861: --
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', l_proc);
864: fnd_message.set_token('STEP','15');
865: fnd_message.raise_error;
866: End dt_update_validate;
867: --
868: -- ----------------------------------------------------------------------------
861: --
862: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
863: fnd_message.set_token('PROCEDURE', l_proc);
864: fnd_message.set_token('STEP','15');
865: fnd_message.raise_error;
866: End dt_update_validate;
867: --
868: -- ----------------------------------------------------------------------------
869: -- |--------------------------< dt_delete_validate >--------------------------|
955: --
956: -- An unhandled or unexpected error has occurred which
957: -- we must report
958: --
959: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
960: fnd_message.set_token('PROCEDURE', l_proc);
961: fnd_message.set_token('STEP','15');
962: fnd_message.raise_error;
963: --
956: -- An unhandled or unexpected error has occurred which
957: -- we must report
958: --
959: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
960: fnd_message.set_token('PROCEDURE', l_proc);
961: fnd_message.set_token('STEP','15');
962: fnd_message.raise_error;
963: --
964: End dt_delete_validate;
957: -- we must report
958: --
959: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
960: fnd_message.set_token('PROCEDURE', l_proc);
961: fnd_message.set_token('STEP','15');
962: fnd_message.raise_error;
963: --
964: End dt_delete_validate;
965: --
958: --
959: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
960: fnd_message.set_token('PROCEDURE', l_proc);
961: fnd_message.set_token('STEP','15');
962: fnd_message.raise_error;
963: --
964: End dt_delete_validate;
965: --
966: -- ----------------------------------------------------------------------------