64: close csr_application_id;
65: hr_utility.set_location(' Leaving:'||l_proc,30);
66: exception
67: when app_exception.application_exception then
68: if hr_multi_message.exception_add
69: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID'
70: ) then
71: hr_utility.set_location(' Leaving:'||l_proc, 40);
72: raise;
131: close csr_item_class_id;
132: hr_utility.set_location(' Leaving:'||l_proc,30);
133: exception
134: when app_exception.application_exception then
135: if hr_multi_message.exception_add
136: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID'
137: ) then
138: hr_utility.set_location(' Leaving:'||l_proc, 40);
139: raise;
196: close csr_item_class_usage;
197: hr_utility.set_location(' Leaving:'||l_proc,30);
198: exception
199: when app_exception.application_exception then
200: if hr_multi_message.exception_add
201: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID'
202: ) then
203: hr_utility.set_location(' Leaving:'||l_proc, 40);
204: raise;
239: l_proc varchar2(72) := g_package || 'CHK_MANDATORY_ARGS';
240: --
241: Begin
242: hr_utility.set_location(' Entering:'||l_proc,10);
243: if hr_multi_message.no_all_inclusive_error
244: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
245: hr_multi_message.no_all_inclusive_error
246: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
247: hr_api.mandatory_arg_error(p_api_name => l_proc
241: Begin
242: hr_utility.set_location(' Entering:'||l_proc,10);
243: if hr_multi_message.no_all_inclusive_error
244: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
245: hr_multi_message.no_all_inclusive_error
246: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
247: hr_api.mandatory_arg_error(p_api_name => l_proc
248: ,p_argument => 'ITEM_ID_QUERY'
249: ,p_argument_value => p_rec.item_id_query
302: l_query_validation varchar2(1000);
303: --
304: Begin
305: hr_utility.set_location(' Entering:'||l_proc,10);
306: if hr_multi_message.no_all_inclusive_error
307: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
308: hr_multi_message.no_all_inclusive_error
309: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
310: if nvl(p_item_id_query, hr_api.g_varchar2) <> hr_api.g_varchar2 then
304: Begin
305: hr_utility.set_location(' Entering:'||l_proc,10);
306: if hr_multi_message.no_all_inclusive_error
307: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
308: hr_multi_message.no_all_inclusive_error
309: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
310: if nvl(p_item_id_query, hr_api.g_varchar2) <> hr_api.g_varchar2 then
311: -- Check for special characters in item_id_query
312: if(instrb(p_item_id_query, ';', 1, 1) > 0) or
345: end if;
346: hr_utility.set_location(' Leaving:'||l_proc,30);
347: exception
348: when app_exception.application_exception then
349: if hr_multi_message.exception_add
350: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_ID_QUERY'
351: ) then
352: hr_utility.set_location(' Leaving:'||l_proc, 40);
353: raise;
387: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_PAR_MODE';
388: --
389: Begin
390: hr_utility.set_location(' Entering:'||l_proc,10);
391: if hr_multi_message.no_all_inclusive_error
392: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
393: hr_multi_message.no_all_inclusive_error
394: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
395: if nvl(p_item_class_par_mode, hr_api.g_varchar2) <> hr_api.g_varchar2 and
389: Begin
390: hr_utility.set_location(' Entering:'||l_proc,10);
391: if hr_multi_message.no_all_inclusive_error
392: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
393: hr_multi_message.no_all_inclusive_error
394: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
395: if nvl(p_item_class_par_mode, hr_api.g_varchar2) <> hr_api.g_varchar2 and
396: p_item_class_par_mode not in (ame_util.serialItems,
397: ame_util.parallelItems
402: end if;
403: hr_utility.set_location(' Leaving:'||l_proc,30);
404: exception
405: when app_exception.application_exception then
406: if hr_multi_message.exception_add
407: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_PAR_MODE'
408: ) then
409: hr_utility.set_location(' Leaving:'||l_proc, 40);
410: raise;
444: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_SUBLIST_MODE';
445: --
446: Begin
447: hr_utility.set_location(' Entering:'||l_proc,10);
448: if hr_multi_message.no_all_inclusive_error
449: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
450: hr_multi_message.no_all_inclusive_error
451: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
452: if nvl(p_item_class_sublist_mode, hr_api.g_varchar2) <>
446: Begin
447: hr_utility.set_location(' Entering:'||l_proc,10);
448: if hr_multi_message.no_all_inclusive_error
449: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.APPLICATION_ID') and
450: hr_multi_message.no_all_inclusive_error
451: (p_check_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ID') then
452: if nvl(p_item_class_sublist_mode, hr_api.g_varchar2) <>
453: hr_api.g_varchar2 and
454: p_item_class_sublist_mode not in (ame_util.serialSublists
462: end if;
463: hr_utility.set_location(' Leaving:'||l_proc,30);
464: exception
465: when app_exception.application_exception then
466: if hr_multi_message.exception_add
467: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_SUBLIST_MODE'
468: ) then
469: hr_utility.set_location(' Leaving:'||l_proc, 40);
470: raise;
515: end if;
516: hr_utility.set_location(' Leaving:'||l_proc,30);
517: exception
518: when app_exception.application_exception then
519: if hr_multi_message.exception_add
520: (p_associated_column1 => 'AME_ITEM_CLASS_USAGES.ITEM_CLASS_ORDER_NUMBER'
521: ) then
522: hr_utility.set_location(' Leaving:'||l_proc, 40);
523: raise;
597: begin
598: null;
599: exception
600: when app_exception.application_exception then
601: if hr_multi_message.exception_add
602: (p_associated_column1 => 'ITEM_CLASS_ID') then
603: hr_utility.set_location(' Leaving:'|| l_proc, 50);
604: raise;
605: end if;