DBA Data[Home] [Help]

APPS.AME_ITU_BUS dependencies on HR_MULTI_MESSAGE

Line 68: if hr_multi_message.exception_add

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;

Line 135: if hr_multi_message.exception_add

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;

Line 200: if hr_multi_message.exception_add

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;

Line 243: if hr_multi_message.no_all_inclusive_error

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

Line 245: hr_multi_message.no_all_inclusive_error

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

Line 306: if hr_multi_message.no_all_inclusive_error

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

Line 308: hr_multi_message.no_all_inclusive_error

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

Line 349: if hr_multi_message.exception_add

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;

Line 391: if hr_multi_message.no_all_inclusive_error

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

Line 393: hr_multi_message.no_all_inclusive_error

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

Line 406: if hr_multi_message.exception_add

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;

Line 448: if hr_multi_message.no_all_inclusive_error

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

Line 450: hr_multi_message.no_all_inclusive_error

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

Line 466: if hr_multi_message.exception_add

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;

Line 519: if hr_multi_message.exception_add

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;

Line 601: if hr_multi_message.exception_add

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;