DBA Data[Home] [Help]

APPS.AME_ITU_BUS dependencies on HR_UTILITY

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

47: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_ID';
48: l_dummy varchar2(1);
49: --
50: Begin
51: hr_utility.set_location(' Entering:'||l_proc,10);
52:
53: hr_api.mandatory_arg_error(p_api_name => l_proc
54: ,p_argument => 'APPLICATION_ID'
55: ,p_argument_value => p_application_id

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

61: fnd_message.set_name('PER','AME_400732_INV_APPLICATION_ID');
62: fnd_message.raise_error;
63: end if;
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'

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

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;
73: end if;
74: hr_utility.set_location(' Leaving:'||l_proc,50);
75: End chk_application_id;

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

70: ) then
71: hr_utility.set_location(' Leaving:'||l_proc, 40);
72: raise;
73: end if;
74: hr_utility.set_location(' Leaving:'||l_proc,50);
75: End chk_application_id;
76: -- ----------------------------------------------------------------------------
77: -- |-------------------------< CHK_ITEM_CLASS_ID >----------------------------|
78: -- ----------------------------------------------------------------------------

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

114: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_ID';
115: l_dummy varchar2(1);
116: --
117: Begin
118: hr_utility.set_location(' Entering:'||l_proc,10);
119:
120: hr_api.mandatory_arg_error(p_api_name => l_proc
121: ,p_argument => 'ITEM_CLASS_ID'
122: ,p_argument_value => p_item_class_id

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

128: fnd_message.set_name('PER','AME_400740_INV_ITEM_CLASS_ID');
129: fnd_message.raise_error;
130: end if;
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'

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

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;
140: end if;
141: hr_utility.set_location(' Leaving:'||l_proc,50);
142: End chk_item_class_id;

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

137: ) then
138: hr_utility.set_location(' Leaving:'||l_proc, 40);
139: raise;
140: end if;
141: hr_utility.set_location(' Leaving:'||l_proc,50);
142: End chk_item_class_id;
143: -- ----------------------------------------------------------------------------
144: -- |-------------------------< CHK_ITEM_CLASS_USAGE >----------------------------|
145: -- ----------------------------------------------------------------------------

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

184: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_USAGE';
185: l_dummy varchar2(1);
186: --
187: Begin
188: hr_utility.set_location(' Entering:'||l_proc,10);
189: open csr_item_class_usage;
190: fetch csr_item_class_usage into l_dummy;
191: if(csr_item_class_usage%found) then
192: close csr_item_class_usage;

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

193: fnd_message.set_name('PER','AME_400745_ITC_NAME_NOT_UNQ');
194: fnd_message.raise_error;
195: end if;
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'

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

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;
205: end if;
206: hr_utility.set_location(' Leaving:'||l_proc,50);
207: End chk_item_class_usage;

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

202: ) then
203: hr_utility.set_location(' Leaving:'||l_proc, 40);
204: raise;
205: end if;
206: hr_utility.set_location(' Leaving:'||l_proc,50);
207: End chk_item_class_usage;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |-------------------------< CHK_MANDATORY_ARGS >-----------------------------|

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

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

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

260: ,p_argument => 'ITEM_CLASS_SUBLIST_MODE'
261: ,p_argument_value => p_rec.item_class_sublist_mode
262: );
263: end if;
264: hr_utility.set_location(' Leaving:'||l_proc,30);
265: End chk_mandatory_args;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |-------------------------< CHK_ITEM_ID_QUERY >-----------------------------|

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

301: l_upper_trans_id_placeholder ame_util.stringType;
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

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

342: fnd_message.raise_error;
343: end if;
344: end if;
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'

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

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;
354: end if;
355: hr_utility.set_location(' Leaving:'||l_proc,50);
356: End chk_item_id_query;

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

351: ) then
352: hr_utility.set_location(' Leaving:'||l_proc, 40);
353: raise;
354: end if;
355: hr_utility.set_location(' Leaving:'||l_proc,50);
356: End chk_item_id_query;
357: --
358: -- ----------------------------------------------------------------------------
359: -- |-------------------------< CHK_ITEM_CLASS_PAR_MODE >-----------------------------|

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

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

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

399: fnd_message.set_name('PER','AME_400766_INV_PARAM_MODE');
400: fnd_message.raise_error;
401: end if;
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'

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

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;
411: end if;
412: hr_utility.set_location(' Leaving:'||l_proc,50);
413: End chk_item_class_par_mode;

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

408: ) then
409: hr_utility.set_location(' Leaving:'||l_proc, 40);
410: raise;
411: end if;
412: hr_utility.set_location(' Leaving:'||l_proc,50);
413: End chk_item_class_par_mode;
414: -- ----------------------------------------------------------------------------
415: -- |-------------------------< CHK_ITEM_CLASS_SUBLIST_MODE >-----------------------------|
416: -- ----------------------------------------------------------------------------

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

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

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

459: fnd_message.set_name('PER','AME_400767_INV_SUBLIST_MODE');
460: fnd_message.raise_error;
461: end if;
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'

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

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;
471: end if;
472: hr_utility.set_location(' Leaving:'||l_proc,50);
473: End chk_item_class_sublist_mode;

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

468: ) then
469: hr_utility.set_location(' Leaving:'||l_proc, 40);
470: raise;
471: end if;
472: hr_utility.set_location(' Leaving:'||l_proc,50);
473: End chk_item_class_sublist_mode;
474: -- ----------------------------------------------------------------------------
475: -- |-------------------------< CHK_ORDER_NUMBER>---------------------------|
476: -- ----------------------------------------------------------------------------

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

501: ) IS
502: --
503: l_proc varchar2(72) := g_package || 'CHK_ORDER_NUMBER';
504: Begin
505: hr_utility.set_location('Entering:'||l_proc,10);
506: hr_api.mandatory_arg_error(p_api_name => l_proc
507: ,p_argument => 'ORDER_NUMBER'
508: ,p_argument_value => p_order_number
509: );

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

512: if p_order_number <=0 then
513: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
514: fnd_message.raise_error;
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'

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

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;
524: end if;
525: hr_utility.set_location( ' Leaving:'||l_proc,50 );
526: End chk_order_number;

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

521: ) then
522: hr_utility.set_location(' Leaving:'||l_proc, 40);
523: raise;
524: end if;
525: hr_utility.set_location( ' Leaving:'||l_proc,50 );
526: End chk_order_number;
527: --
528: -- ----------------------------------------------------------------------------
529: -- |-----------------------< chk_non_updateable_args >------------------------|

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

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;
606: hr_utility.set_location(' Leaving:'|| l_proc, 60);
607: end chk_delete;

Line 606: hr_utility.set_location(' Leaving:'|| l_proc, 60);

602: (p_associated_column1 => 'ITEM_CLASS_ID') then
603: hr_utility.set_location(' Leaving:'|| l_proc, 50);
604: raise;
605: end if;
606: hr_utility.set_location(' Leaving:'|| l_proc, 60);
607: end chk_delete;
608:
609:
610: --

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

809: --
810: l_proc varchar2(72) := g_package||'insert_validate';
811: --
812: Begin
813: hr_utility.set_location('Entering:'||l_proc, 5);
814: --
815: -- Validate Dependent Attributes
816: --
817: ame_itu_bus.chk_application_id(p_application_id => p_rec.application_id

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

837: );
838: ame_itu_bus.chk_order_number(p_order_number => p_rec.item_class_order_number);
839:
840: --
841: hr_utility.set_location(' Leaving:'||l_proc, 10);
842: End insert_validate;
843: --
844: -- ----------------------------------------------------------------------------
845: -- |---------------------------< update_validate >----------------------------|

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

854: --
855: l_proc varchar2(72) := g_package||'update_validate';
856: --
857: Begin
858: hr_utility.set_location('Entering:'||l_proc, 5);
859: --
860: -- Validate Dependent Attributes
861: --
862: -- Call the datetrack update integrity operation

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

883: );
884: ame_itu_bus.chk_order_number(p_order_number => p_rec.item_class_order_number);
885: --
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 10);
888: End update_validate;
889: --
890: -- ----------------------------------------------------------------------------
891: -- |---------------------------< delete_validate >----------------------------|

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

900: --
901: l_proc varchar2(72) := g_package||'delete_validate';
902: --
903: Begin
904: hr_utility.set_location('Entering:'||l_proc, 5);
905: --
906: -- Call all supporting business operations
907: --
908: dt_delete_validate

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

916: chk_delete(p_item_class_id => p_rec.item_class_id
917: ,p_application_id => p_rec.application_id
918: );
919: --
920: hr_utility.set_location(' Leaving:'||l_proc, 10);
921: End delete_validate;
922: --
923: end ame_itu_bus;