DBA Data[Home] [Help]

APPS.OTA_TAV_API_BUSINESS_RULES dependencies on HR_MULTI_MESSAGE

Line 117: if hr_multi_message.exception_add

113: hr_utility.set_location(' Leaving:'|| v_proc, 10);
114: --
115: exception
116: when app_exception.application_exception then
117: if hr_multi_message.exception_add
118: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
119: ) then
120: hr_utility.set_location(' Leaving:'|| v_proc,70);
121: raise;

Line 143: if hr_multi_message.exception_add

139: hr_utility.set_location(' Leaving:'|| v_proc, 10);
140: --
141: exception
142: when app_exception.application_exception then
143: if hr_multi_message.exception_add
144: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.VENDOR_ID'
145: ) then
146: hr_utility.set_location(' Leaving:'|| v_proc,70);
147: raise;

Line 178: if hr_multi_message.exception_add

174: hr_utility.set_location(' Leaving:'|| v_proc, 10);
175: --
176: exception
177: when app_exception.application_exception then
178: if hr_multi_message.exception_add
179: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CURRENCY_CODE'
180: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.BUDGET_COST'
181: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.ACTUAL_COST'
182: ) then

Line 216: if hr_multi_message.exception_add

212: hr_utility.set_location(' Leaving:'|| v_proc, 10);
213: --
214: exception
215: when app_exception.application_exception then
216: if hr_multi_message.exception_add
217: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDITS'
218: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
219: ) then
220: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 245: if hr_multi_message.exception_add

241: hr_utility.set_location(' Leaving:'|| v_proc, 10);
242: --
243: exception
244: when app_exception.application_exception then
245: if hr_multi_message.exception_add
246: (p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.PROFESSIONAL_CREDIT_TYPE'
247: ) then
248: hr_utility.set_location(' Leaving:'|| v_proc,70);
249: raise;

Line 706: if hr_multi_message.no_error_message

702: from ota_resource_usages rud
703: where rud.activity_version_id = p_activity_version_id;
704: --
705: Begin
706: if hr_multi_message.no_error_message
707: (p_check_message_name1 => 'OTA_13312_GEN_DATE_ORDER'
708: ) then
709: --
710: hr_utility.set_location('Entering:'|| v_proc, 5);

Line 757: if hr_multi_message.exception_add

753: --
754: end if;
755: exception
756: when app_exception.application_exception then
757: if hr_multi_message.exception_add
758: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
759: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
760: ) then
761: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1019: IF hr_multi_message.no_exclusive_error

1015:
1016: Begin
1017: hr_utility.set_location(' Entering:' || l_proc,10);
1018: --
1019: IF hr_multi_message.no_exclusive_error
1020: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1021: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1022: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1023: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

Line 1047: IF hr_multi_message.exception_add

1043: --
1044: hr_utility.set_location(' Leaving:' || l_proc,10);
1045: Exception
1046: when app_exception.application_exception then
1047: IF hr_multi_message.exception_add
1048: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1049: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1050: ) THEN
1051: hr_utility.set_location(' Leaving:'|| l_proc,20);

Line 2092: if hr_multi_message.exception_add

2088: hr_utility.set_location(' Leaving:'|| l_proc, 35);
2089: --
2090: exception
2091: when app_exception.application_exception then
2092: if hr_multi_message.exception_add
2093: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2094: ) then
2095: hr_utility.set_location(' Leaving:'|| l_proc,70);
2096: raise;

Line 2233: if hr_multi_message.exception_add

2229: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2230: --
2231: exception
2232: when app_exception.application_exception then
2233: if hr_multi_message.exception_add
2234: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2235: ) then
2236: hr_utility.set_location(' Leaving:'|| l_proc,70);
2237: raise;

Line 2292: if hr_multi_message.exception_add

2288: end if;
2289: end if;
2290: exception
2291: when app_exception.application_exception then
2292: if hr_multi_message.exception_add
2293: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.RCO_ID'
2294: ) then
2295: hr_utility.set_location(' Leaving:'|| l_proc,70);
2296: raise;

Line 2342: IF hr_multi_message.no_exclusive_error

2338:
2339: Begin
2340:
2341: hr_utility.set_location('Entering:'||l_proc, 5);
2342: IF hr_multi_message.no_exclusive_error
2343: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2344: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2345: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2346: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN

Line 2531: IF hr_multi_message.no_exclusive_error

2527:
2528: Begin
2529:
2530: hr_utility.set_location('Entering:'||l_proc, 5);
2531: IF hr_multi_message.no_exclusive_error
2532: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2533: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2534: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2535: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN