65: fetch csr_variable_value into l_oldVal;
66: end if;
67: close csr_variable_value;
68: if(l_oldVal = 'yes' and (p_variable_value is null or p_variable_value <> 'yes')) then
69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');
70: fnd_message.set_token('VARNAME',p_variable_name);
71: fnd_message.raise_error;
72: end if;
73: elsif(p_variable_name = 'productionFunctionality') then
66: end if;
67: close csr_variable_value;
68: if(l_oldVal = 'yes' and (p_variable_value is null or p_variable_value <> 'yes')) then
69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');
70: fnd_message.set_token('VARNAME',p_variable_name);
71: fnd_message.raise_error;
72: end if;
73: elsif(p_variable_name = 'productionFunctionality') then
74: open csr_variable_value(p_application_id,p_variable_name);
67: close csr_variable_value;
68: if(l_oldVal = 'yes' and (p_variable_value is null or p_variable_value <> 'yes')) then
69: fnd_message.set_name('PER', 'AME_400653_CFV_NONUPD_VAL_YN');
70: fnd_message.set_token('VARNAME',p_variable_name);
71: fnd_message.raise_error;
72: end if;
73: elsif(p_variable_name = 'productionFunctionality') then
74: open csr_variable_value(p_application_id,p_variable_name);
75: fetch csr_variable_value into l_oldVal;
79: fetch csr_variable_value into l_oldVal;
80: end if;
81: close csr_variable_value;
82: if(l_oldVal = 'all' and (p_variable_value is null or p_variable_value <> 'all')) then
83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');
84: fnd_message.set_token('VARNAME',p_variable_name);
85: fnd_message.raise_error;
86: end if;
87: end if;
80: end if;
81: close csr_variable_value;
82: if(l_oldVal = 'all' and (p_variable_value is null or p_variable_value <> 'all')) then
83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');
84: fnd_message.set_token('VARNAME',p_variable_name);
85: fnd_message.raise_error;
86: end if;
87: end if;
88: hr_utility.set_location(' Leaving:'||l_proc,30);
81: close csr_variable_value;
82: if(l_oldVal = 'all' and (p_variable_value is null or p_variable_value <> 'all')) then
83: fnd_message.set_name('PER', 'AME_400654_CFV_NONUPD_VAL_PF');
84: fnd_message.set_token('VARNAME',p_variable_name);
85: fnd_message.raise_error;
86: end if;
87: end if;
88: hr_utility.set_location(' Leaving:'||l_proc,30);
89: exception
146: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then
147: open csr_application;
148: fetch csr_application into l_key;
149: if(csr_application%notfound) then
150: fnd_message.set_name('PER', 'AME_400474_INV_APPLICATION_ID');
151: fnd_message.raise_error;
152: end if;
153: close csr_application;
154: end if;
147: open csr_application;
148: fetch csr_application into l_key;
149: if(csr_application%notfound) then
150: fnd_message.set_name('PER', 'AME_400474_INV_APPLICATION_ID');
151: fnd_message.raise_error;
152: end if;
153: close csr_application;
154: end if;
155: hr_utility.set_location(' Leaving:'||l_proc,30);
204: Begin
205: hr_utility.set_location('Entering:'||l_proc,10);
206: --
207: if p_application_id = 0 then
208: fnd_message.set_name('PER', 'AME_400773_DEF_CONFIG_DEL');
209: fnd_message.raise_error;
210: end if;
211: exception
212: when app_exception.application_exception then
205: hr_utility.set_location('Entering:'||l_proc,10);
206: --
207: if p_application_id = 0 then
208: fnd_message.set_name('PER', 'AME_400773_DEF_CONFIG_DEL');
209: fnd_message.raise_error;
210: end if;
211: exception
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add
268: open csr_var_name(p_variable_name);
269: fetch csr_var_name into l_key;
270: if(csr_var_name%notfound) then
271: close csr_var_name;
272: fnd_message.set_name('PER', 'AME_400657_CFV_INV_VAR_NAME');
273: fnd_message.raise_error;
274: else
275: close csr_var_name;
276: end if;
269: fetch csr_var_name into l_key;
270: if(csr_var_name%notfound) then
271: close csr_var_name;
272: fnd_message.set_name('PER', 'AME_400657_CFV_INV_VAR_NAME');
273: fnd_message.raise_error;
274: else
275: close csr_var_name;
276: end if;
277: hr_utility.set_location(' Leaving:'||l_proc,30);
372: --
373: -- If total parameter count is not 8, then error has occurred.
374: --
375: if(l_count <> 8) then
376: fnd_message.set_name('PER', 'AME_400658_CFV_INV_NUM_PRM');
377: fnd_message.raise_error;
378: end if;
379: --
380: -- Check for the values in respective profile value tables.
373: -- If total parameter count is not 8, then error has occurred.
374: --
375: if(l_count <> 8) then
376: fnd_message.set_name('PER', 'AME_400658_CFV_INV_NUM_PRM');
377: fnd_message.raise_error;
378: end if;
379: --
380: -- Check for the values in respective profile value tables.
381: --
379: --
380: -- Check for the values in respective profile value tables.
381: --
382: if not isExist(AME_BEHAVIOUR_VALUES(1),AME_FWD_PRV_SAME_CHAIN) then
383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
380: -- Check for the values in respective profile value tables.
381: --
382: if not isExist(AME_BEHAVIOUR_VALUES(1),AME_FWD_PRV_SAME_CHAIN) then
383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
381: --
382: if not isExist(AME_BEHAVIOUR_VALUES(1),AME_FWD_PRV_SAME_CHAIN) then
383: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
384: fnd_message.set_token('PARAMNUM',1);
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
385: fnd_message.raise_error;
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
386: end if;
387: if not isExist(AME_BEHAVIOUR_VALUES(2),AME_FWD_PRV_SAME_CHAIN) then
388: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
389: fnd_message.set_token('PARAMNUM',2);
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
390: fnd_message.raise_error;
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
391: end if;
392: if not isExist(AME_BEHAVIOUR_VALUES(3),AME_FWD_SUB_NOT_SAME_CHAIN) then
393: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
394: fnd_message.set_token('PARAMNUM',3);
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
395: fnd_message.raise_error;
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
396: end if;
397: if not isExist(AME_BEHAVIOUR_VALUES(4),AME_FWD_SUB_NOT_SAME_CHAIN) then
398: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
399: fnd_message.set_token('PARAMNUM',4);
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
400: fnd_message.raise_error;
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
401: end if;
402: if not isExist(AME_BEHAVIOUR_VALUES(5),AME_FWD_PRV_SAME_CHAIN) then
403: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
404: fnd_message.set_token('PARAMNUM',5);
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
405: fnd_message.raise_error;
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
406: end if;
407: if not isExist(AME_BEHAVIOUR_VALUES(6),AME_FWD_PRV_SAME_CHAIN) then
408: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
409: fnd_message.set_token('PARAMNUM',6);
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
410: fnd_message.raise_error;
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
411: end if;
412: if not isExist(AME_BEHAVIOUR_VALUES(7),AME_ADHOC_FWD) then
413: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
414: fnd_message.set_token('PARAMNUM',7);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
420: fnd_message.raise_error;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,30);
415: fnd_message.raise_error;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
420: fnd_message.raise_error;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,30);
423: return true;
416: end if;
417: if not isExist(AME_BEHAVIOUR_VALUES(8),AME_ADHOC_FWD) then
418: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
419: fnd_message.set_token('PARAMNUM',8);
420: fnd_message.raise_error;
421: end if;
422: hr_utility.set_location(' Leaving:'||l_proc,30);
423: return true;
424: exception
481: l_count := l_count+1;
482: l_priority := substr(p_value,l_location,l_index-l_location);
483: if (l_priority is null or l_priority = '' or (l_priority <> 'disabled' and
484: substr(l_priority,1,instr(l_priority,'_')) not in ('absolute_','relative_'))) then
485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
486: fnd_message.set_token('PARAMNUM',l_count);
487: fnd_message.raise_error;
488: end if;
489: if not((l_priority = 'disabled')
482: l_priority := substr(p_value,l_location,l_index-l_location);
483: if (l_priority is null or l_priority = '' or (l_priority <> 'disabled' and
484: substr(l_priority,1,instr(l_priority,'_')) not in ('absolute_','relative_'))) then
485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
486: fnd_message.set_token('PARAMNUM',l_count);
487: fnd_message.raise_error;
488: end if;
489: if not((l_priority = 'disabled')
490: or (
483: if (l_priority is null or l_priority = '' or (l_priority <> 'disabled' and
484: substr(l_priority,1,instr(l_priority,'_')) not in ('absolute_','relative_'))) then
485: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
486: fnd_message.set_token('PARAMNUM',l_count);
487: fnd_message.raise_error;
488: end if;
489: if not((l_priority = 'disabled')
490: or (
491: (substr(l_priority,1,instr(l_priority,'_')) in ('absolute_'
495: (ame_util.isANonNegativeInteger(substr(l_priority,instr(l_priority,'_')+1)))
496: and
497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
500: fnd_message.set_token('PARAMNUM',l_count);
501: fnd_message.raise_error;
502: end if;
503: l_location:=l_index+1;
496: and
497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
500: fnd_message.set_token('PARAMNUM',l_count);
501: fnd_message.raise_error;
502: end if;
503: l_location:=l_index+1;
504: end loop;
497: (substr(l_priority,instr(l_priority,'_')+1)<>'0')
498: ))then
499: fnd_message.set_name('PER', 'AME_400659_CFV_INV_PARAM');
500: fnd_message.set_token('PARAMNUM',l_count);
501: fnd_message.raise_error;
502: end if;
503: l_location:=l_index+1;
504: end loop;
505: --
505: --
506: -- If total parameter count is not 8, then error has occurred.
507: --
508: if(l_count <> 8) then
509: fnd_message.set_name('PER', 'AME_400660_CFV_INV_PRIORITY');
510: fnd_message.raise_error;
511: end if;
512: hr_utility.set_location(' Leaving:'||l_proc,30);
513: return true;
506: -- If total parameter count is not 8, then error has occurred.
507: --
508: if(l_count <> 8) then
509: fnd_message.set_name('PER', 'AME_400660_CFV_INV_PRIORITY');
510: fnd_message.raise_error;
511: end if;
512: hr_utility.set_location(' Leaving:'||l_proc,30);
513: return true;
514: exception
579: open csr_role;
580: fetch csr_role into l_key;
581: if(csr_role%notfound) then
582: close csr_role;
583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
584: fnd_message.set_token('VARNAME',p_variable_name);
585: fnd_message.raise_error;
586: else
587: close csr_role;
580: fetch csr_role into l_key;
581: if(csr_role%notfound) then
582: close csr_role;
583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
584: fnd_message.set_token('VARNAME',p_variable_name);
585: fnd_message.raise_error;
586: else
587: close csr_role;
588: end if;
581: if(csr_role%notfound) then
582: close csr_role;
583: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
584: fnd_message.set_token('VARNAME',p_variable_name);
585: fnd_message.raise_error;
586: else
587: close csr_role;
588: end if;
589:
592: or p_variable_name = 'allowFyiNotifications'
593: or p_variable_name = 'distributedEnvironment'
594: ) then
595: if(p_variable_value) not in ('yes','no') then
596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
597: fnd_message.set_token('VARNAME',p_variable_name);
598: fnd_message.raise_error;
599: end if;
600:
593: or p_variable_name = 'distributedEnvironment'
594: ) then
595: if(p_variable_value) not in ('yes','no') then
596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
597: fnd_message.set_token('VARNAME',p_variable_name);
598: fnd_message.raise_error;
599: end if;
600:
601: elsif(p_variable_name = 'currencyConversionWindow'
594: ) then
595: if(p_variable_value) not in ('yes','no') then
596: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
597: fnd_message.set_token('VARNAME',p_variable_name);
598: fnd_message.raise_error;
599: end if;
600:
601: elsif(p_variable_name = 'currencyConversionWindow'
602: or p_variable_name = 'purgeFrequency'
603: ) then
604: if (trim(p_variable_value)='0')
605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;
610: end if;
611:
604: if (trim(p_variable_value)='0')
605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;
610: end if;
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
605: or not (ame_util.isANonNegativeInteger(p_variable_value))
606: then
607: fnd_message.set_name('PER', 'AME_400662_CFV_NEG_VAL');
608: fnd_message.set_token('VARNAME',p_variable_name);
609: fnd_message.raise_error;
610: end if;
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
610: end if;
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
615: fnd_message.set_token('VARNAME',p_variable_name);
616: fnd_message.raise_error;
617: end if;
618:
611:
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
615: fnd_message.set_token('VARNAME',p_variable_name);
616: fnd_message.raise_error;
617: end if;
618:
619: /*elsif(p_variable_name = 'helpPath'
612: elsif(p_variable_name = 'forwardingBehaviors') then
613: if not isValid_Forwarding_Behaviour(p_variable_value) then
614: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
615: fnd_message.set_token('VARNAME',p_variable_name);
616: fnd_message.raise_error;
617: end if;
618:
619: /*elsif(p_variable_name = 'helpPath'
620: or p_variable_name = 'htmlPath'
627: ,'approver'
628: ,'transaction'
629: ,'all'
630: ) then
631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
632: fnd_message.set_token('VARNAME',p_variable_name);
633: fnd_message.raise_error;
634: end if;
635:
628: ,'transaction'
629: ,'all'
630: ) then
631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
632: fnd_message.set_token('VARNAME',p_variable_name);
633: fnd_message.raise_error;
634: end if;
635:
636: elsif(p_variable_name = 'repeatedApprovers') then
629: ,'all'
630: ) then
631: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
632: fnd_message.set_token('VARNAME',p_variable_name);
633: fnd_message.raise_error;
634: end if;
635:
636: elsif(p_variable_name = 'repeatedApprovers') then
637: if p_variable_value not in ('ONCE_PER_TRANSACTION'
641: ,'ONCE_PER_ACTION_TYPE'
642: ,'ONCE_PER_GROUP_OR_CHAIN'
643: ,'EACH_OCCURRENCE'
644: ) then
645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
646: fnd_message.set_token('VARNAME',p_variable_name);
647: fnd_message.raise_error;
648: end if;
649:
642: ,'ONCE_PER_GROUP_OR_CHAIN'
643: ,'EACH_OCCURRENCE'
644: ) then
645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
646: fnd_message.set_token('VARNAME',p_variable_name);
647: fnd_message.raise_error;
648: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then
643: ,'EACH_OCCURRENCE'
644: ) then
645: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
646: fnd_message.set_token('VARNAME',p_variable_name);
647: fnd_message.raise_error;
648: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
648: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
653: fnd_message.set_token('VARNAME',p_variable_name);
654: fnd_message.raise_error;
655: end if;
656: end if;
649:
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
653: fnd_message.set_token('VARNAME',p_variable_name);
654: fnd_message.raise_error;
655: end if;
656: end if;
657: end if;
650: elsif(p_variable_name = 'rulePriorityModes') then
651: if not isValid_Rule_Priority_Mode(p_variable_value) then
652: fnd_message.set_name('PER', 'AME_400661_CFV_INV_VAL');
653: fnd_message.set_token('VARNAME',p_variable_name);
654: fnd_message.raise_error;
655: end if;
656: end if;
657: end if;
658: hr_utility.set_location(' Leaving:'||l_proc,30);
731: ,'htmlPath'
732: ,'imagePath'
733: ,' portalUrl'
734: ) then
735: fnd_message.set_name('PER', 'AME_400655_INV_NO_TT_VAL');
736: fnd_message.raise_error;
737: end if;
738: open csr_var_name;
739: fetch csr_var_name into l_key;
732: ,'imagePath'
733: ,' portalUrl'
734: ) then
735: fnd_message.set_name('PER', 'AME_400655_INV_NO_TT_VAL');
736: fnd_message.raise_error;
737: end if;
738: open csr_var_name;
739: fetch csr_var_name into l_key;
740: if(csr_var_name%found) then
738: open csr_var_name;
739: fetch csr_var_name into l_key;
740: if(csr_var_name%found) then
741: close csr_var_name;
742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
743: fnd_message.set_token('VARNAME',p_variable_name);
744: fnd_message.raise_error;
745: else
746: close csr_var_name;
739: fetch csr_var_name into l_key;
740: if(csr_var_name%found) then
741: close csr_var_name;
742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
743: fnd_message.set_token('VARNAME',p_variable_name);
744: fnd_message.raise_error;
745: else
746: close csr_var_name;
747: end if;
740: if(csr_var_name%found) then
741: close csr_var_name;
742: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
743: fnd_message.set_token('VARNAME',p_variable_name);
744: fnd_message.raise_error;
745: else
746: close csr_var_name;
747: end if;
748: else
749: open csr_var_name;
750: fetch csr_var_name into l_key;
751: if(csr_var_name%found) then
752: close csr_var_name;
753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
754: fnd_message.set_token('VARNAME',p_variable_name);
755: fnd_message.raise_error;
756: else
757: close csr_var_name;
750: fetch csr_var_name into l_key;
751: if(csr_var_name%found) then
752: close csr_var_name;
753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
754: fnd_message.set_token('VARNAME',p_variable_name);
755: fnd_message.raise_error;
756: else
757: close csr_var_name;
758: end if;
751: if(csr_var_name%found) then
752: close csr_var_name;
753: fnd_message.set_name('PER', 'AME_400656_DUP_VAR_VAL');
754: fnd_message.set_token('VARNAME',p_variable_name);
755: fnd_message.raise_error;
756: else
757: close csr_var_name;
758: end if;
759: end if;
814: ,p_variable_name => p_rec.variable_name
815: ,p_effective_date => p_effective_date
816: ,p_object_version_number => p_rec.object_version_number
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
815: ,p_effective_date => p_effective_date
816: ,p_object_version_number => p_rec.object_version_number
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
823: --
816: ,p_object_version_number => p_rec.object_version_number
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
823: --
824: -- EDIT_HERE: Add checks to ensure non-updateable args have
817: ) THEN
818: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
819: fnd_message.set_token('PROCEDURE ', l_proc);
820: fnd_message.set_token('STEP ', '5');
821: fnd_message.raise_error;
822: END IF;
823: --
824: -- EDIT_HERE: Add checks to ensure non-updateable args have
825: -- not been updated.
894: --
895: -- An unhandled or unexpected error has occurred which
896: -- we must report
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
895: -- An unhandled or unexpected error has occurred which
896: -- we must report
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
903: --
896: -- we must report
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
903: --
904: -- ----------------------------------------------------------------------------
897: --
898: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
899: fnd_message.set_token('PROCEDURE', l_proc);
900: fnd_message.set_token('STEP','15');
901: fnd_message.raise_error;
902: End dt_update_validate;
903: --
904: -- ----------------------------------------------------------------------------
905: -- |--------------------------< dt_delete_validate >--------------------------|
992: --
993: -- An unhandled or unexpected error has occurred which
994: -- we must report
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
993: -- An unhandled or unexpected error has occurred which
994: -- we must report
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
1001: End dt_delete_validate;
994: -- we must report
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
1001: End dt_delete_validate;
1002: --
995: --
996: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
997: fnd_message.set_token('PROCEDURE', l_proc);
998: fnd_message.set_token('STEP','15');
999: fnd_message.raise_error;
1000: --
1001: End dt_delete_validate;
1002: --
1003: -- ----------------------------------------------------------------------------