53: l_proc varchar2(72) := g_package || 'chk_nonupdateable_variable_values';
54: l_oldVal ame_config_vars.variable_value%TYPE;
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc,10);
58: --
59: if(p_variable_name = 'allowAllApproverTypes' or p_variable_name = 'allowAllItemClassRules' or p_variable_name = 'allowFyiNotifications') then
60: open csr_variable_value(p_application_id,p_variable_name);
61: fetch csr_variable_value into l_oldVal;
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
90: when app_exception.application_exception then
91: if hr_multi_message.exception_add
92: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
90: when app_exception.application_exception then
91: if hr_multi_message.exception_add
92: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
93: ) then
94: hr_utility.set_location(' Leaving:'||l_proc, 40);
95: raise;
96: end if;
97: hr_utility.set_location(' Leaving:'||l_proc,50);
98: End chk_nonupd_variable_values;
93: ) then
94: hr_utility.set_location(' Leaving:'||l_proc, 40);
95: raise;
96: end if;
97: hr_utility.set_location(' Leaving:'||l_proc,50);
98: End chk_nonupd_variable_values;
99: --
100:
101: --
140: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';
141: l_key number;
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc,10);
145: --
146: if(p_application_id <> ame_utility_pkg.defaultAmeAppId) then
147: open csr_application;
148: fetch csr_application into l_key;
151: fnd_message.raise_error;
152: end if;
153: close csr_application;
154: end if;
155: hr_utility.set_location(' Leaving:'||l_proc,30);
156: exception
157: when app_exception.application_exception then
158: if hr_multi_message.exception_add
159: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
157: when app_exception.application_exception then
158: if hr_multi_message.exception_add
159: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
160: ) then
161: hr_utility.set_location(' Leaving:'||l_proc, 40);
162: raise;
163: end if;
164: hr_utility.set_location(' Leaving:'||l_proc,50);
165: End chk_application_id;
160: ) then
161: hr_utility.set_location(' Leaving:'||l_proc, 40);
162: raise;
163: end if;
164: hr_utility.set_location(' Leaving:'||l_proc,50);
165: End chk_application_id;
166: --
167: --
168: -- ----------------------------------------------------------------------------
201: --
202: l_proc varchar2(72) := g_package || 'CHK_DEFAULT_CONFIG_VAR';
203: --
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;
212: when app_exception.application_exception then
213: if hr_multi_message.exception_add
214: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_ID'
215: ) then
216: hr_utility.set_location(' Leaving:'||l_proc, 40);
217: raise;
218: end if;
219: hr_utility.set_location(' Leaving:'||l_proc,50);
220: End chk_default_config_var;
215: ) then
216: hr_utility.set_location(' Leaving:'||l_proc, 40);
217: raise;
218: end if;
219: hr_utility.set_location(' Leaving:'||l_proc,50);
220: End chk_default_config_var;
221: --
222:
223: --
256: l_proc varchar2(72) := g_package || 'CHK_VARIABLE_NAME';
257: l_key varchar2(1);
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc,10);
261: hr_api.mandatory_arg_error(p_api_name => l_proc
262: ,p_argument => 'VARIABLE_NAME'
263: ,p_argument_value => p_variable_name
264: );
273: fnd_message.raise_error;
274: else
275: close csr_var_name;
276: end if;
277: hr_utility.set_location(' Leaving:'||l_proc,30);
278: exception
279: when app_exception.application_exception then
280: if hr_multi_message.exception_add
281: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME'
279: when app_exception.application_exception then
280: if hr_multi_message.exception_add
281: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME'
282: ) then
283: hr_utility.set_location(' Leaving:'||l_proc, 40);
284: raise;
285: end if;
286: hr_utility.set_location(' Leaving:'||l_proc,50);
287: End chk_variable_name;
282: ) then
283: hr_utility.set_location(' Leaving:'||l_proc, 40);
284: raise;
285: end if;
286: hr_utility.set_location(' Leaving:'||l_proc,50);
287: End chk_variable_name;
288: --
289: --
290: -- ----------------------------------------------------------------------------
340: return isFound;
341: end;
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc,10);
345: --
346: -- Populate the Profile Value Tables.
347: --
348: AME_FWD_PRV_SAME_CHAIN(1) := 'REMAND';
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
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONFIG_VARS.FORWARDING_BEHAVIOUR'
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
431: end if;
432: hr_utility.set_location(' Leaving:'||l_proc,50);
433: return false;
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;
431: end if;
432: hr_utility.set_location(' Leaving:'||l_proc,50);
433: return false;
434: End isValid_Forwarding_Behaviour;
435: --
436: --
470: l_count number :=0;
471: l_priority varchar2(20);
472: --
473: Begin
474: hr_utility.set_location('Entering:'||l_proc,10);
475: --
476: -- Split the incoming values into 8 subparts.
477: --
478: loop
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
515: when app_exception.application_exception then
516: if hr_multi_message.exception_add
515: when app_exception.application_exception then
516: if hr_multi_message.exception_add
517: (p_associated_column1 => 'AME_CONFIG_VARS.PRIORITY_MODE'
518: ) then
519: hr_utility.set_location(' Leaving:'||l_proc, 40);
520: raise;
521: end if;
522: hr_utility.set_location(' Leaving:'||l_proc,50);
523: return false;
518: ) then
519: hr_utility.set_location(' Leaving:'||l_proc, 40);
520: raise;
521: end if;
522: hr_utility.set_location(' Leaving:'||l_proc,50);
523: return false;
524: End isValid_Rule_Priority_Mode;
525: --
526: --
564: l_proc varchar2(72) := g_package || 'CHK_VARIABLE_VALUE';
565: l_key varchar2(1);
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: hr_api.mandatory_arg_error(p_api_name => l_proc
570: ,p_argument => 'VARIABLE_VALUE'
571: ,p_argument_value => p_variable_value
572: );
654: fnd_message.raise_error;
655: end if;
656: end if;
657: end if;
658: hr_utility.set_location(' Leaving:'||l_proc,30);
659: exception
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_VALUE'
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'AME_CONFIG_VARS.VARIABLE_VALUE'
663: ) then
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665: raise;
666: end if;
667: hr_utility.set_location(' Leaving:'||l_proc,50);
668: End chk_variable_value;
663: ) then
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665: raise;
666: end if;
667: hr_utility.set_location(' Leaving:'||l_proc,50);
668: End chk_variable_value;
669: --
670: --
671: -- ----------------------------------------------------------------------------
713: l_proc varchar2(72) := g_package || 'CHK_VARIABLE_NAME';
714: l_key varchar2(1);
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc,10);
718: if (hr_multi_message.no_all_inclusive_error
719: (p_check_column1 => 'AME_CONFIG_VARS.VARIABLE_NAME')
720: and hr_multi_message.no_all_inclusive_error
721: (p_check_column1 => 'AME_CONFIG_VARS.APPLICATION_ID')) then
757: close csr_var_name;
758: end if;
759: end if;
760: end if;
761: hr_utility.set_location(' Leaving:'||l_proc,30);
762: exception
763: when app_exception.application_exception then
764: if hr_multi_message.exception_add
765: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_VARIABLE_NAME'
763: when app_exception.application_exception then
764: if hr_multi_message.exception_add
765: (p_associated_column1 => 'AME_CONFIG_VARS.APPLICATION_VARIABLE_NAME'
766: ) then
767: hr_utility.set_location(' Leaving:'||l_proc, 40);
768: raise;
769: end if;
770: hr_utility.set_location(' Leaving:'||l_proc,50);
771: End chk_application_variable_name;
766: ) then
767: hr_utility.set_location(' Leaving:'||l_proc, 40);
768: raise;
769: end if;
770: hr_utility.set_location(' Leaving:'||l_proc,50);
771: End chk_application_variable_name;
772: --
773: -- ----------------------------------------------------------------------------
774: -- |-----------------------< chk_non_updateable_args >------------------------|
1013: --
1014: l_proc varchar2(72) := g_package||'insert_validate';
1015: --
1016: Begin
1017: hr_utility.set_location('Entering:'||l_proc, 5);
1018: --
1019: -- Validate Dependent Attributes
1020: --
1021: chk_application_id(p_application_id => p_rec.application_id
1034: ,p_variable_name => p_rec.variable_name
1035: ,p_variable_value => p_rec.variable_value
1036: );
1037: --
1038: hr_utility.set_location(' Leaving:'||l_proc, 10);
1039: End insert_validate;
1040: --
1041: -- ----------------------------------------------------------------------------
1042: -- |---------------------------< update_validate >----------------------------|
1051: --
1052: l_proc varchar2(72) := g_package||'update_validate';
1053: --
1054: Begin
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: --
1057: -- Validate Dependent Attributes
1058: --
1059: -- Call the datetrack update integrity operation
1083: ,p_variable_name => p_rec.variable_name
1084: ,p_variable_value => p_rec.variable_value
1085: );
1086: --
1087: hr_utility.set_location(' Leaving:'||l_proc, 10);
1088: End update_validate;
1089: --
1090: -- ----------------------------------------------------------------------------
1091: -- |---------------------------< delete_validate >----------------------------|
1101: l_proc varchar2(72) := g_package||'delete_validate';
1102: l_call_stack varchar2(4096);
1103: --
1104: Begin
1105: hr_utility.set_location('Entering:'||l_proc, 5);
1106: --
1107: -- Call all supporting business operations
1108: --
1109: dt_delete_validate
1125: chk_default_config_var
1126: (p_application_id => p_rec.application_id
1127: ,p_effective_date => p_effective_date);
1128: --
1129: hr_utility.set_location(' Leaving:'||l_proc, 10);
1130: End delete_validate;
1131: --
1132: end ame_cfv_bus;