eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_VALIDATE_PVT dependencies on ASO_UTILITY_PVT

Line 2881: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (lp_qte_header_rec.quote_header_id);

2877: aso_debug_pub.add('Validate_ItemTcaBsc: lp_shipment_rec.shipment_id: ' || lp_shipment_rec.shipment_id,1,'N');
2878: END IF;
2879:
2880: IF (p_application_type_code = 'QUOTING HTML' AND p_operation_code = 'UPDATE') THEN
2881: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (lp_qte_header_rec.quote_header_id);
2882:
2883: IF lp_qte_header_rec.party_id = FND_API.G_MISS_NUM THEN
2884: lp_qte_header_rec.party_id := l_qte_header_rec.party_id;
2885: END IF;

Line 2925: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (lp_shipment_rec.shipment_id);

2921: END IF;
2922:
2923: IF lp_shipment_rec.operation_code = 'UPDATE' THEN
2924: IF lp_shipment_rec.shipment_id IS NOT NULL AND lp_shipment_rec.shipment_id <> FND_API.G_MISS_NUM THEN
2925: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (lp_shipment_rec.shipment_id);
2926: IF lp_shipment_rec.ship_to_cust_party_id = FND_API.G_MISS_NUM THEN
2927: lp_shipment_rec.ship_to_cust_party_id := l_shipment_rec.ship_to_cust_party_id;
2928: END IF;
2929: IF lp_shipment_rec.ship_to_cust_account_id = FND_API.G_MISS_NUM THEN

Line 3176: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3172: );
3173:
3174: EXCEPTION
3175: WHEN FND_API.G_EXC_ERROR THEN
3176: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3177: P_API_NAME => L_API_NAME
3178: ,P_PKG_NAME => G_PKG_NAME
3179: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3180: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3180: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3176: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3177: P_API_NAME => L_API_NAME
3178: ,P_PKG_NAME => G_PKG_NAME
3179: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3180: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3181: ,P_SQLCODE => SQLCODE
3182: ,P_SQLERRM => SQLERRM
3183: ,X_MSG_COUNT => X_MSG_COUNT
3184: ,X_MSG_DATA => X_MSG_DATA

Line 3188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3184: ,X_MSG_DATA => X_MSG_DATA
3185: ,X_RETURN_STATUS => X_RETURN_STATUS);
3186:
3187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3189: P_API_NAME => L_API_NAME
3190: ,P_PKG_NAME => G_PKG_NAME
3191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3192: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3192: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3188: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3189: P_API_NAME => L_API_NAME
3190: ,P_PKG_NAME => G_PKG_NAME
3191: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3192: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3193: ,P_SQLCODE => SQLCODE
3194: ,P_SQLERRM => SQLERRM
3195: ,X_MSG_COUNT => X_MSG_COUNT
3196: ,X_MSG_DATA => X_MSG_DATA

Line 3200: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3196: ,X_MSG_DATA => X_MSG_DATA
3197: ,X_RETURN_STATUS => X_RETURN_STATUS);
3198:
3199: WHEN OTHERS THEN
3200: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3201: P_API_NAME => L_API_NAME
3202: ,P_PKG_NAME => G_PKG_NAME
3203: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3204: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3203: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3199: WHEN OTHERS THEN
3200: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3201: P_API_NAME => L_API_NAME
3202: ,P_PKG_NAME => G_PKG_NAME
3203: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3204: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3205: ,P_SQLCODE => SQLCODE
3206: ,P_SQLERRM => SQLERRM
3207: ,X_MSG_COUNT => X_MSG_COUNT

Line 3204: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3200: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3201: P_API_NAME => L_API_NAME
3202: ,P_PKG_NAME => G_PKG_NAME
3203: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3204: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3205: ,P_SQLCODE => SQLCODE
3206: ,P_SQLERRM => SQLERRM
3207: ,X_MSG_COUNT => X_MSG_COUNT
3208: ,X_MSG_DATA => X_MSG_DATA

Line 3263: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (lp_qte_header_rec.quote_header_id);

3259: aso_debug_pub.add('Validate_ItemTcaCrs: lp_shipment_rec.shipment_id: ' || lp_shipment_rec.shipment_id,1,'N');
3260: END IF;
3261:
3262: IF (p_application_type_code = 'QUOTING HTML' AND p_operation_code = 'UPDATE') THEN
3263: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (lp_qte_header_rec.quote_header_id);
3264:
3265: IF lp_qte_header_rec.party_id = FND_API.G_MISS_NUM THEN
3266: lp_qte_header_rec.party_id := l_qte_header_rec.party_id;
3267: END IF;

Line 3307: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (lp_shipment_rec.shipment_id);

3303: END IF;
3304:
3305: IF lp_shipment_rec.operation_code = 'UPDATE' THEN
3306: IF lp_shipment_rec.shipment_id IS NOT NULL AND lp_shipment_rec.shipment_id <> FND_API.G_MISS_NUM THEN
3307: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (lp_shipment_rec.shipment_id);
3308: IF lp_shipment_rec.ship_to_cust_party_id = FND_API.G_MISS_NUM THEN
3309: lp_shipment_rec.ship_to_cust_party_id := l_shipment_rec.ship_to_cust_party_id;
3310: END IF;
3311: IF lp_shipment_rec.ship_to_cust_account_id = FND_API.G_MISS_NUM THEN

Line 3518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3514: );
3515:
3516: EXCEPTION
3517: WHEN FND_API.G_EXC_ERROR THEN
3518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3519: P_API_NAME => L_API_NAME
3520: ,P_PKG_NAME => G_PKG_NAME
3521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3519: P_API_NAME => L_API_NAME
3520: ,P_PKG_NAME => G_PKG_NAME
3521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3523: ,P_SQLCODE => SQLCODE
3524: ,P_SQLERRM => SQLERRM
3525: ,X_MSG_COUNT => X_MSG_COUNT
3526: ,X_MSG_DATA => X_MSG_DATA

Line 3530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3526: ,X_MSG_DATA => X_MSG_DATA
3527: ,X_RETURN_STATUS => X_RETURN_STATUS);
3528:
3529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3531: P_API_NAME => L_API_NAME
3532: ,P_PKG_NAME => G_PKG_NAME
3533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3531: P_API_NAME => L_API_NAME
3532: ,P_PKG_NAME => G_PKG_NAME
3533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3535: ,P_SQLCODE => SQLCODE
3536: ,P_SQLERRM => SQLERRM
3537: ,X_MSG_COUNT => X_MSG_COUNT
3538: ,X_MSG_DATA => X_MSG_DATA

Line 3542: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3538: ,X_MSG_DATA => X_MSG_DATA
3539: ,X_RETURN_STATUS => X_RETURN_STATUS);
3540:
3541: WHEN OTHERS THEN
3542: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3543: P_API_NAME => L_API_NAME
3544: ,P_PKG_NAME => G_PKG_NAME
3545: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3546: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3545: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3541: WHEN OTHERS THEN
3542: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3543: P_API_NAME => L_API_NAME
3544: ,P_PKG_NAME => G_PKG_NAME
3545: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3546: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3547: ,P_SQLCODE => SQLCODE
3548: ,P_SQLERRM => SQLERRM
3549: ,X_MSG_COUNT => X_MSG_COUNT

Line 3546: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3542: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3543: P_API_NAME => L_API_NAME
3544: ,P_PKG_NAME => G_PKG_NAME
3545: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3546: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3547: ,P_SQLCODE => SQLCODE
3548: ,P_SQLERRM => SQLERRM
3549: ,X_MSG_COUNT => X_MSG_COUNT
3550: ,X_MSG_DATA => X_MSG_DATA

Line 4922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4918: WHEN FND_API.G_EXC_ERROR THEN
4919: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4920: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
4921: END IF;
4922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4923: P_API_NAME => L_API_NAME
4924: ,P_PKG_NAME => G_PKG_NAME
4925: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4926: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4926: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4923: P_API_NAME => L_API_NAME
4924: ,P_PKG_NAME => G_PKG_NAME
4925: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4926: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4927: ,P_SQLCODE => SQLCODE
4928: ,P_SQLERRM => SQLERRM
4929: ,X_MSG_COUNT => X_MSG_COUNT
4930: ,X_MSG_DATA => X_MSG_DATA

Line 4934: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4930: ,X_MSG_DATA => X_MSG_DATA
4931: ,X_RETURN_STATUS => X_RETURN_STATUS);
4932:
4933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4934: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4935: P_API_NAME => L_API_NAME
4936: ,P_PKG_NAME => G_PKG_NAME
4937: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4938: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4938: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4934: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4935: P_API_NAME => L_API_NAME
4936: ,P_PKG_NAME => G_PKG_NAME
4937: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4938: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4939: ,P_SQLCODE => SQLCODE
4940: ,P_SQLERRM => SQLERRM
4941: ,X_MSG_COUNT => X_MSG_COUNT
4942: ,X_MSG_DATA => X_MSG_DATA

Line 4946: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4942: ,X_MSG_DATA => X_MSG_DATA
4943: ,X_RETURN_STATUS => X_RETURN_STATUS);
4944:
4945: WHEN OTHERS THEN
4946: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4947: P_API_NAME => L_API_NAME
4948: ,P_PKG_NAME => G_PKG_NAME
4949: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4950: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4949: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

4945: WHEN OTHERS THEN
4946: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4947: P_API_NAME => L_API_NAME
4948: ,P_PKG_NAME => G_PKG_NAME
4949: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4950: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4951: ,P_SQLCODE => SQLCODE
4952: ,P_SQLERRM => SQLERRM
4953: ,X_MSG_COUNT => X_MSG_COUNT

Line 4950: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4946: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4947: P_API_NAME => L_API_NAME
4948: ,P_PKG_NAME => G_PKG_NAME
4949: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4950: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4951: ,P_SQLCODE => SQLCODE
4952: ,P_SQLERRM => SQLERRM
4953: ,X_MSG_COUNT => X_MSG_COUNT
4954: ,X_MSG_DATA => X_MSG_DATA