DBA Data[Home] [Help]

APPS.AME_CON_BUS dependencies on HR_MULTI_MESSAGE

Line 49: if hr_multi_message.exception_add

45: );
46: hr_utility.set_location(' Leaving:'||l_proc,30);
47: exception
48: when app_exception.application_exception then
49: if hr_multi_message.exception_add
50: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_ID'
51: ) then
52: hr_utility.set_location(' Leaving:'||l_proc, 40);
53: raise;

Line 106: if hr_multi_message.exception_add

102: end if;
103: hr_utility.set_location(' Leaving:'||l_proc,30);
104: exception
105: when app_exception.application_exception then
106: if hr_multi_message.exception_add
107: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
108: ) then
109: hr_utility.set_location(' Leaving:'||l_proc, 40);
110: raise;

Line 165: if hr_multi_message.no_all_inclusive_error

161: --
162: Begin
163: hr_utility.set_location(' Entering:'||l_proc,10);
164: -- Check whether any dependencies on CONDITION_KEY have failed
165: if hr_multi_message.no_all_inclusive_error
166: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE') then
167: hr_api.mandatory_arg_error(p_api_name => l_proc
168: ,p_argument => 'ATTRIBUTE_ID'
169: ,p_argument_value => p_attribute_id

Line 192: if hr_multi_message.exception_add

188: end if;
189: hr_utility.set_location(' Leaving:'||l_proc,30);
190: exception
191: when app_exception.application_exception then
192: if hr_multi_message.exception_add
193: (p_associated_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID'
194: ) then
195: hr_utility.set_location(' Leaving:'||l_proc, 40);
196: raise;

Line 254: if hr_multi_message.no_all_inclusive_error

250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc,10);
253: -- Check for dependency issues with ATTRIBUTE_ID
254: if hr_multi_message.no_all_inclusive_error
255: (p_check_column1 => 'AME_CONDITIONS.ATTRIBUTE_ID') then
256: -- Check if the attribute_type is not ame_util.stringType
257: open csr_atr_type;
258: fetch csr_atr_type into l_key;

Line 275: if hr_multi_message.exception_add

271: end if;
272: hr_utility.set_location(' Leaving:'||l_proc,30);
273: exception
274: when app_exception.application_exception then
275: if hr_multi_message.exception_add
276: (p_associated_column1 => 'AME_CONDITIONS.PARAMETER_ONE'
277: ) then
278: hr_utility.set_location(' Leaving:'||l_proc, 40);
279: raise;

Line 353: if hr_multi_message.no_all_inclusive_error

349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc,10);
352: -- Check for dependency over CONDITION_TYPE.ATTRIBUTE_ID and PARAMETER_ONE
353: if hr_multi_message.no_all_inclusive_error
354: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
355: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
356: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
357: ) then

Line 426: if hr_multi_message.exception_add

422: ----
423: hr_utility.set_location(' Leaving:'||l_proc,30);
424: exception
425: when app_exception.application_exception then
426: if hr_multi_message.exception_add
427: (p_associated_column1 => 'AME_CONDITIONS.PARAMETERS'
428: ) then
429: hr_utility.set_location(' Leaving:'||l_proc, 40);
430: raise;

Line 490: if hr_multi_message.no_all_inclusive_error

486: --
487: Begin
488: hr_utility.set_location('Entering:'||l_proc,10);
489: -- Check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
490: if hr_multi_message.no_all_inclusive_error
491: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
492: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
493: ) then
494: -- Check condition_type and attribute_type.

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_CONDITIONS.PARAMETER_THREE'
521: ) then
522: hr_utility.set_location(' Leaving:'||l_proc, 40);
523: raise;

Line 593: if hr_multi_message.no_all_inclusive_error

589: Begin
590: hr_utility.set_location('Entering:'||l_proc,10);
591: -- check for dependency over CONDITION_TYPE, ATTRIBUTE_ID
592: -- PARAMETER_ONE,PARAMETER_THREE and LIMITS
593: if hr_multi_message.no_all_inclusive_error
594: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
595: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
596: ,p_check_column3 => 'AME_CONDITIONS.PARAMETER_ONE'
597: ,p_check_column4 => 'AME_CONDITIONS.PARAMETER_THREE'

Line 617: if hr_multi_message.exception_add

613: end if;
614: hr_utility.set_location(' Leaving:'||l_proc,30);
615: exception
616: when app_exception.application_exception then
617: if hr_multi_message.exception_add
618: (p_associated_column1 => 'AME_CONDITIONS.UNIQUE'
619: ) then
620: hr_utility.set_location(' Leaving:'||l_proc, 40);
621: raise;

Line 683: if hr_multi_message.no_all_inclusive_error

679: l_key varchar2(30);
680: --
681: Begin
682: hr_utility.set_location( 'Entering:'||l_proc,10 );
683: if hr_multi_message.no_all_inclusive_error
684: (p_check_column1 => 'AME_CONDITIONS.CONDITION_TYPE'
685: ,p_check_column2 => 'AME_CONDITIONS.ATTRIBUTE_ID'
686: ,p_check_column3 => 'AME_CONDITIONS.PARAMETERS'
687: ) then

Line 734: if hr_multi_message.exception_add

730: --
731: hr_utility.set_location(' Leaving:'||l_proc,30);
732: exception
733: when app_exception.application_exception then
734: if hr_multi_message.exception_add
735: (p_associated_column1 => 'AME_CONDITIONS.LIMITS'
736: ) then
737: hr_utility.set_location(' Leaving:'||l_proc, 40);
738: raise;

Line 807: if hr_multi_message.exception_add

803: close csr_name;
804: hr_utility.set_location(' Leaving:'||l_proc,30);
805: exception
806: when app_exception.application_exception then
807: if hr_multi_message.exception_add
808: (p_associated_column1 => 'AME_CONDITIONS.CONDITION_KEY'
809: ) then
810: hr_utility.set_location(' Leaving:'||l_proc, 40);
811: raise;

Line 895: if hr_multi_message.exception_add

891:
892: hr_utility.set_location(' Leaving:'||l_proc,30);
893: exception
894: when app_exception.application_exception then
895: if hr_multi_message.exception_add
896: (p_associated_column1 => 'AME_CONDITIONS.DELETE'
897: ) then
898: hr_utility.set_location(' Leaving:'||l_proc, 40);
899: raise;