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 1040: when app_exception.application_exception then

1036: End IF;
1037: --
1038: hr_utility.set_location(' Leaving:' || l_proc,10);
1039: Exception
1040: when app_exception.application_exception then
1041: IF hr_multi_message.exception_add
1042: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1043: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1044: ) THEN

Line 2085: when app_exception.application_exception then

2081: end if;
2082: hr_utility.set_location(' Leaving:'|| l_proc, 35);
2083: --
2084: exception
2085: when app_exception.application_exception then
2086: if hr_multi_message.exception_add
2087: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2088: ) then
2089: hr_utility.set_location(' Leaving:'|| l_proc,70);

Line 2226: when app_exception.application_exception then

2222:
2223: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2224: --
2225: exception
2226: when app_exception.application_exception then
2227: if hr_multi_message.exception_add
2228: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.INVENTORY_ITEM_ID'
2229: ) then
2230: hr_utility.set_location(' Leaving:'|| l_proc,70);

Line 2285: when app_exception.application_exception then

2281: hr_utility.set_location('Leaving:'||l_proc, 20);
2282: end if;
2283: end if;
2284: exception
2285: when app_exception.application_exception then
2286: if hr_multi_message.exception_add
2287: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.RCO_ID'
2288: ) then
2289: hr_utility.set_location(' Leaving:'|| l_proc,70);