DBA Data[Home] [Help]

APPS.AME_CFV_BUS dependencies on HR_UTILITY

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

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;

Line 88: hr_utility.set_location(' Leaving:'||l_proc,30);

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'

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

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;

Line 97: hr_utility.set_location(' Leaving:'||l_proc,50);

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: --

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

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;

Line 155: hr_utility.set_location(' Leaving:'||l_proc,30);

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'

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

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;

Line 164: hr_utility.set_location(' Leaving:'||l_proc,50);

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: -- ----------------------------------------------------------------------------

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

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;

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

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;

Line 219: hr_utility.set_location(' Leaving:'||l_proc,50);

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: --

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

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: );

Line 277: hr_utility.set_location(' Leaving:'||l_proc,30);

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'

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

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;

Line 286: hr_utility.set_location(' Leaving:'||l_proc,50);

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: -- ----------------------------------------------------------------------------

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

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';

Line 422: hr_utility.set_location(' Leaving:'||l_proc,30);

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

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

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;

Line 432: hr_utility.set_location(' Leaving:'||l_proc,50);

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: --

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

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

Line 512: hr_utility.set_location(' Leaving:'||l_proc,30);

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

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

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;

Line 522: hr_utility.set_location(' Leaving:'||l_proc,50);

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: --

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

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: );

Line 658: hr_utility.set_location(' Leaving:'||l_proc,30);

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'

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

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;

Line 667: hr_utility.set_location(' Leaving:'||l_proc,50);

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: -- ----------------------------------------------------------------------------

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

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

Line 761: hr_utility.set_location(' Leaving:'||l_proc,30);

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'

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

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;

Line 770: hr_utility.set_location(' Leaving:'||l_proc,50);

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 >------------------------|

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

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

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

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 >----------------------------|

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

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

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

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 >----------------------------|

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

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

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

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;