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 2878: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (lp_qte_header_rec.quote_header_id);

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

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

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

Line 3173: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3177: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 3185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3189: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 3197: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3200: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 3201: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

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

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

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

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

Line 3515: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3519: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 3527: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3531: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 3539: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3542: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 3543: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 4919: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4923: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 4931: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4935: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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

Line 4943: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4946: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 4947: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

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