APPS.OTA_TAV_API_BUSINESS_RULES dependencies on APP_EXCEPTION

Line 116: when app_exception.application_exception then

112: --
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);

Line 142: when app_exception.application_exception then

138: --
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);

Line 177: when app_exception.application_exception then

173: --
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'

Line 215: when app_exception.application_exception then

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

Line 244: when app_exception.application_exception then

240: --
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);

Line 756: when app_exception.application_exception then

752: hr_utility.set_location(' Leaving:'|| v_proc, 10);
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

Line 1046: when app_exception.application_exception then

1042: End IF;
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

Line 2091: when app_exception.application_exception then

2087: end if;
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);

Line 2232: when app_exception.application_exception then

2228:
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);

Line 2291: when app_exception.application_exception then

2287: hr_utility.set_location('Leaving:'||l_proc, 20);
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);