101: END IF;
102:
103:
104: -- Debug Message
105: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
106:
107:
108: -- Standard call to get message count and if count is 1, get message info.
109: FND_MSG_PUB.Count_And_Get
112: );
113:
114: EXCEPTION
115: WHEN FND_API.G_EXC_ERROR THEN
116: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
117: P_API_NAME => L_API_NAME
118: ,P_PKG_NAME => G_PKG_NAME
119: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
120: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
116: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
117: P_API_NAME => L_API_NAME
118: ,P_PKG_NAME => G_PKG_NAME
119: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
120: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
121: ,X_MSG_COUNT => X_MSG_COUNT
122: ,X_MSG_DATA => X_MSG_DATA
123: ,X_RETURN_STATUS => X_RETURN_STATUS);
124:
122: ,X_MSG_DATA => X_MSG_DATA
123: ,X_RETURN_STATUS => X_RETURN_STATUS);
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
127: P_API_NAME => L_API_NAME
128: ,P_PKG_NAME => G_PKG_NAME
129: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
130: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
126: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
127: P_API_NAME => L_API_NAME
128: ,P_PKG_NAME => G_PKG_NAME
129: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
130: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
131: ,X_MSG_COUNT => X_MSG_COUNT
132: ,X_MSG_DATA => X_MSG_DATA
133: ,X_RETURN_STATUS => X_RETURN_STATUS);
134:
132: ,X_MSG_DATA => X_MSG_DATA
133: ,X_RETURN_STATUS => X_RETURN_STATUS);
134:
135: WHEN OTHERS THEN
136: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
137: P_API_NAME => L_API_NAME
138: ,P_PKG_NAME => G_PKG_NAME
139: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
140: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
135: WHEN OTHERS THEN
136: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
137: P_API_NAME => L_API_NAME
138: ,P_PKG_NAME => G_PKG_NAME
139: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
140: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
141: ,X_MSG_COUNT => X_MSG_COUNT
142: ,X_MSG_DATA => X_MSG_DATA
143: ,X_RETURN_STATUS => X_RETURN_STATUS);
136: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
137: P_API_NAME => L_API_NAME
138: ,P_PKG_NAME => G_PKG_NAME
139: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
140: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
141: ,X_MSG_COUNT => X_MSG_COUNT
142: ,X_MSG_DATA => X_MSG_DATA
143: ,X_RETURN_STATUS => X_RETURN_STATUS);
144:
311: END IF;
312:
313:
314: -- Debug Message
315: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
316:
317:
318: -- Standard call to get message count and if count is 1, get message info.
319: FND_MSG_PUB.Count_And_Get
322: );
323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
327: P_API_NAME => L_API_NAME
328: ,P_PKG_NAME => G_PKG_NAME
329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
327: P_API_NAME => L_API_NAME
328: ,P_PKG_NAME => G_PKG_NAME
329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
331: ,X_MSG_COUNT => X_MSG_COUNT
332: ,X_MSG_DATA => X_MSG_DATA
333: ,X_RETURN_STATUS => X_RETURN_STATUS);
334:
332: ,X_MSG_DATA => X_MSG_DATA
333: ,X_RETURN_STATUS => X_RETURN_STATUS);
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
337: P_API_NAME => L_API_NAME
338: ,P_PKG_NAME => G_PKG_NAME
339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
337: P_API_NAME => L_API_NAME
338: ,P_PKG_NAME => G_PKG_NAME
339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
341: ,X_MSG_COUNT => X_MSG_COUNT
342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);
344:
342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);
344:
345: WHEN OTHERS THEN
346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
345: WHEN OTHERS THEN
346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
351: ,X_MSG_COUNT => X_MSG_COUNT
352: ,X_MSG_DATA => X_MSG_DATA
353: ,X_RETURN_STATUS => X_RETURN_STATUS);
346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
351: ,X_MSG_COUNT => X_MSG_COUNT
352: ,X_MSG_DATA => X_MSG_DATA
353: ,X_RETURN_STATUS => X_RETURN_STATUS);
354:
396: OPEN c_get_header_id(X_Qte_Line_Id);
397: Fetch c_get_header_id INTO l_header_id;
398: Close c_get_header_id;
399:
400: X_Qte_Header_Rec := ASO_UTILITY_PVT.Query_Header_Row(l_header_id);
401:
402: END IF;
403:
404: END Copy_Line;