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 1013: IF hr_multi_message.no_exclusive_error

1009:
1010: Begin
1011: hr_utility.set_location(' Entering:' || l_proc,10);
1012: --
1013: IF hr_multi_message.no_exclusive_error
1014: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1015: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1016: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1017: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

Line 1041: IF hr_multi_message.exception_add

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

Line 2086: if hr_multi_message.exception_add

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);
2090: raise;

Line 2227: if hr_multi_message.exception_add

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);
2231: raise;

Line 2286: if hr_multi_message.exception_add

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);
2290: raise;

Line 2336: IF hr_multi_message.no_exclusive_error

2332:
2333: Begin
2334:
2335: hr_utility.set_location('Entering:'||l_proc, 5);
2336: IF hr_multi_message.no_exclusive_error
2337: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2338: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2339: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2340: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN

Line 2525: IF hr_multi_message.no_exclusive_error

2521:
2522: Begin
2523:
2524: hr_utility.set_location('Entering:'||l_proc, 5);
2525: IF hr_multi_message.no_exclusive_error
2526: (p_check_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2527: ,p_check_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
2528: ,p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
2529: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE' ) THEN