DBA Data[Home] [Help]

APPS.ASO_CREDIT_CHECK_PVT dependencies on ASO_UTILITY_PVT

Line 153: aso_debug_pub.add('Before ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');

149: -- get quote information
150:
151: BEGIN
152: IF aso_debug_pub.g_debug_flag = 'Y' THEN
153: aso_debug_pub.add('Before ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');
154: END IF;
155:
156: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
157: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 156: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);

152: IF aso_debug_pub.g_debug_flag = 'Y' THEN
153: aso_debug_pub.add('Before ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');
154: END IF;
155:
156: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
157: IF aso_debug_pub.g_debug_flag = 'Y' THEN
158: aso_debug_pub.add('After ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');
159: END IF;
160: EXCEPTION

Line 158: aso_debug_pub.add('After ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');

154: END IF;
155:
156: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
157: IF aso_debug_pub.g_debug_flag = 'Y' THEN
158: aso_debug_pub.add('After ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');
159: END IF;
160: EXCEPTION
161: WHEN OTHERS THEN
162: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 163: aso_debug_pub.add('Exception ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');

159: END IF;
160: EXCEPTION
161: WHEN OTHERS THEN
162: IF aso_debug_pub.g_debug_flag = 'Y' THEN
163: aso_debug_pub.add('Exception ASO_UTILITY_PVT.Query_Header_Row... ', 1, 'Y');
164: END IF;
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
166: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
167: FND_MESSAGE.Set_Token('COLUMN', 'Quote_header_id', FALSE);

Line 401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

397: );
398:
399: EXCEPTION
400: WHEN FND_API.G_EXC_ERROR THEN
401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
406: ,P_SQLCODE => SQLCODE
407: ,P_SQLERRM => SQLERRM
408: ,X_MSG_COUNT => X_MSG_COUNT
409: ,X_MSG_DATA => X_MSG_DATA

Line 413: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

409: ,X_MSG_DATA => X_MSG_DATA
410: ,X_RETURN_STATUS => X_RETURN_STATUS);
411:
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME
415: ,P_PKG_NAME => G_PKG_NAME
416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
417: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 417: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

413: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME
415: ,P_PKG_NAME => G_PKG_NAME
416: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
417: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
418: ,P_SQLCODE => SQLCODE
419: ,P_SQLERRM => SQLERRM
420: ,X_MSG_COUNT => X_MSG_COUNT
421: ,X_MSG_DATA => X_MSG_DATA

Line 425: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

421: ,X_MSG_DATA => X_MSG_DATA
422: ,X_RETURN_STATUS => X_RETURN_STATUS);
423:
424: WHEN OTHERS THEN
425: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
429: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 428: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

424: WHEN OTHERS THEN
425: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
429: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
430: ,P_SQLCODE => SQLCODE
431: ,P_SQLERRM => SQLERRM
432: ,X_MSG_COUNT => X_MSG_COUNT

Line 429: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

425: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
429: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
430: ,P_SQLCODE => SQLCODE
431: ,P_SQLERRM => SQLERRM
432: ,X_MSG_COUNT => X_MSG_COUNT
433: ,X_MSG_DATA => X_MSG_DATA