192: p_data => x_msg_data );
193:
194: EXCEPTION
195: WHEN FND_API.G_EXC_ERROR THEN
196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
197: P_API_NAME => L_API_NAME
198: ,P_PKG_NAME => G_PKG_NAME
199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
200: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
197: P_API_NAME => L_API_NAME
198: ,P_PKG_NAME => G_PKG_NAME
199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
200: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
201: ,X_MSG_COUNT => X_MSG_COUNT
202: ,X_MSG_DATA => X_MSG_DATA
203: ,X_RETURN_STATUS => X_RETURN_STATUS);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ,X_MSG_COUNT => X_MSG_COUNT
202: ,X_MSG_DATA => X_MSG_DATA
203: ,X_RETURN_STATUS => X_RETURN_STATUS);
204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
210: ,X_MSG_COUNT => X_MSG_COUNT
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);
213:
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);
213:
214: WHEN OTHERS THEN
215: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
219: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
214: WHEN OTHERS THEN
215: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
219: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
215: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
216: P_API_NAME => L_API_NAME
217: ,P_PKG_NAME => G_PKG_NAME
218: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
219: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
220: ,X_MSG_COUNT => X_MSG_COUNT
221: ,X_MSG_DATA => X_MSG_DATA
222: ,X_RETURN_STATUS => X_RETURN_STATUS);
223: END create_reservation;
327: ( p_count => x_msg_count,
328: p_data => x_msg_data );
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
344: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
344: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
345: ,X_MSG_COUNT => X_MSG_COUNT
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);
348:
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);
348:
349: WHEN OTHERS THEN
350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
354: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
349: WHEN OTHERS THEN
350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
354: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
355: ,X_MSG_COUNT => X_MSG_COUNT
356: ,X_MSG_DATA => X_MSG_DATA
357: ,X_RETURN_STATUS => X_RETURN_STATUS);
350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
354: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
355: ,X_MSG_COUNT => X_MSG_COUNT
356: ,X_MSG_DATA => X_MSG_DATA
357: ,X_RETURN_STATUS => X_RETURN_STATUS);
358: END update_reservation ;
447: ( p_count => x_msg_count,
448: p_data => x_msg_data );
449: EXCEPTION
450: WHEN FND_API.G_EXC_ERROR THEN
451: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_API_NAME => L_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
455: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
451: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_API_NAME => L_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
455: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
461: P_API_NAME => L_API_NAME
462: ,P_PKG_NAME => G_PKG_NAME
463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
461: P_API_NAME => L_API_NAME
462: ,P_PKG_NAME => G_PKG_NAME
463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
465: ,X_MSG_COUNT => X_MSG_COUNT
466: ,X_MSG_DATA => X_MSG_DATA
467: ,X_RETURN_STATUS => X_RETURN_STATUS);
468:
466: ,X_MSG_DATA => X_MSG_DATA
467: ,X_RETURN_STATUS => X_RETURN_STATUS);
468:
469: WHEN OTHERS THEN
470: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
474: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
469: WHEN OTHERS THEN
470: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
474: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
475: ,X_MSG_COUNT => X_MSG_COUNT
476: ,X_MSG_DATA => X_MSG_DATA
477: ,X_RETURN_STATUS => X_RETURN_STATUS);
470: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
471: P_API_NAME => L_API_NAME
472: ,P_PKG_NAME => G_PKG_NAME
473: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
474: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
475: ,X_MSG_COUNT => X_MSG_COUNT
476: ,X_MSG_DATA => X_MSG_DATA
477: ,X_RETURN_STATUS => X_RETURN_STATUS);
478: END delete_reservation;
584: ( p_count => x_msg_count,
585: p_data => x_msg_data );
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
589: P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME
591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
592: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
588: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
589: P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME
591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
592: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
593: ,X_MSG_COUNT => X_MSG_COUNT
594: ,X_MSG_DATA => X_MSG_DATA
595: ,X_RETURN_STATUS => X_RETURN_STATUS);
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ,X_MSG_COUNT => X_MSG_COUNT
594: ,X_MSG_DATA => X_MSG_DATA
595: ,X_RETURN_STATUS => X_RETURN_STATUS);
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
601: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
597: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
601: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
602: ,X_MSG_COUNT => X_MSG_COUNT
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);
605:
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);
605:
606: WHEN OTHERS THEN
607: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
608: P_API_NAME => L_API_NAME
609: ,P_PKG_NAME => G_PKG_NAME
610: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
611: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
606: WHEN OTHERS THEN
607: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
608: P_API_NAME => L_API_NAME
609: ,P_PKG_NAME => G_PKG_NAME
610: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
611: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
612: ,X_MSG_COUNT => X_MSG_COUNT
613: ,X_MSG_DATA => X_MSG_DATA
614: ,X_RETURN_STATUS => X_RETURN_STATUS);
607: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
608: P_API_NAME => L_API_NAME
609: ,P_PKG_NAME => G_PKG_NAME
610: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
611: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
612: ,X_MSG_COUNT => X_MSG_COUNT
613: ,X_MSG_DATA => X_MSG_DATA
614: ,X_RETURN_STATUS => X_RETURN_STATUS);
615: END Transfer_Reservation ;