DBA Data[Home] [Help]

APPS.ASO_PRICING_CALLBACK_PVT dependencies on ASO_UTILITY_PVT

Line 417: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

413: WHEN FND_API.G_EXC_ERROR THEN
414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
415: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:After inside EXCEPTION return status'||x_return_status, 1, 'N');
416: END IF;
417: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
418: P_API_NAME => L_API_NAME
419: ,P_PKG_NAME => G_PKG_NAME
420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
421: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 421: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

417: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
418: P_API_NAME => L_API_NAME
419: ,P_PKG_NAME => G_PKG_NAME
420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
421: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
422: ,P_SQLCODE => SQLCODE
423: ,P_SQLERRM => SQLERRM
424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA

Line 429: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME
431: ,P_PKG_NAME => G_PKG_NAME
432: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
433: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 433: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

429: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
430: P_API_NAME => L_API_NAME
431: ,P_PKG_NAME => G_PKG_NAME
432: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
433: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
434: ,P_SQLCODE => SQLCODE
435: ,P_SQLERRM => SQLERRM
436: ,X_MSG_COUNT => X_MSG_COUNT
437: ,X_MSG_DATA => X_MSG_DATA

Line 441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

437: ,X_MSG_DATA => X_MSG_DATA
438: ,X_RETURN_STATUS => X_RETURN_STATUS);
439:
440: WHEN OTHERS THEN
441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
442: P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 444: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

440: WHEN OTHERS THEN
441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
442: P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
446: ,P_SQLCODE => SQLCODE
447: ,P_SQLERRM => SQLERRM
448: ,X_MSG_COUNT => X_MSG_COUNT

Line 445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
442: P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
446: ,P_SQLCODE => SQLCODE
447: ,P_SQLERRM => SQLERRM
448: ,X_MSG_COUNT => X_MSG_COUNT
449: ,X_MSG_DATA => X_MSG_DATA

Line 547: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

543: x_return_status := FND_API.G_RET_STS_SUCCESS;
544: l_request_type := p_control_rec.request_type;
545: l_pricing_event := p_control_rec.pricing_event;
546:
547: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
548: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);
549: IF l_shipment_tbl.count = 1 THEN
550: l_shipment_rec := l_shipment_tbl(1);
551: END IF;

Line 548: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);

544: l_request_type := p_control_rec.request_type;
545: l_pricing_event := p_control_rec.pricing_event;
546:
547: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
548: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);
549: IF l_shipment_tbl.count = 1 THEN
550: l_shipment_rec := l_shipment_tbl(1);
551: END IF;
552: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);

Line 552: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);

548: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);
549: IF l_shipment_tbl.count = 1 THEN
550: l_shipment_rec := l_shipment_tbl(1);
551: END IF;
552: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);
553: ASO_PRICING_CALLBACK_PVT.Config_Callback_Pricing_Order(
554: P_Api_Version_Number => 1.0,
555: P_Init_Msg_List => FND_API.G_FALSE,
556: P_Commit => FND_API.G_FALSE,

Line 589: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

585: );
586:
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
593: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 593: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

589: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
590: P_API_NAME => L_API_NAME
591: ,P_PKG_NAME => G_PKG_NAME
592: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
593: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
594: ,P_SQLCODE => SQLCODE
595: ,P_SQLERRM => SQLERRM
596: ,X_MSG_COUNT => X_MSG_COUNT
597: ,X_MSG_DATA => X_MSG_DATA

Line 601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

597: ,X_MSG_DATA => X_MSG_DATA
598: ,X_RETURN_STATUS => X_RETURN_STATUS);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
605: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 605: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
605: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
606: ,P_SQLCODE => SQLCODE
607: ,P_SQLERRM => SQLERRM
608: ,X_MSG_COUNT => X_MSG_COUNT
609: ,X_MSG_DATA => X_MSG_DATA

Line 613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

609: ,X_MSG_DATA => X_MSG_DATA
610: ,X_RETURN_STATUS => X_RETURN_STATUS);
611:
612: WHEN OTHERS THEN
613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
614: P_API_NAME => L_API_NAME
615: ,P_PKG_NAME => G_PKG_NAME
616: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
617: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 616: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

612: WHEN OTHERS THEN
613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
614: P_API_NAME => L_API_NAME
615: ,P_PKG_NAME => G_PKG_NAME
616: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
617: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
618: ,P_SQLCODE => SQLCODE
619: ,P_SQLERRM => SQLERRM
620: ,X_MSG_COUNT => X_MSG_COUNT

Line 617: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
614: P_API_NAME => L_API_NAME
615: ,P_PKG_NAME => G_PKG_NAME
616: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
617: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
618: ,P_SQLCODE => SQLCODE
619: ,P_SQLERRM => SQLERRM
620: ,X_MSG_COUNT => X_MSG_COUNT
621: ,X_MSG_DATA => X_MSG_DATA