[Home] [Help]
55:
56: -- Initialize message list if p_init_msg_list is set to TRUE.
57: IF FND_API.to_Boolean( p_init_msg_list )
58: THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Initialize API return status to SUCCESS
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
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
110: ( p_count => x_msg_count,
111: p_data => x_msg_data
112: );
113:
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
121: ,X_MSG_COUNT => X_MSG_COUNT
122: ,X_MSG_DATA => X_MSG_DATA
123: ,X_RETURN_STATUS => X_RETURN_STATUS);
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
131: ,X_MSG_COUNT => X_MSG_COUNT
132: ,X_MSG_DATA => X_MSG_DATA
133: ,X_RETURN_STATUS => X_RETURN_STATUS);
192:
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198:
199: -- Initialize API return status to SUCCESS
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
203: -- API body
204: --
205:
206: IF ( P_Qte_Line_Id IS NULL OR P_Qte_Line_Id = FND_API.G_MISS_NUM ) THEN
207: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
208: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
209: FND_MESSAGE.Set_Token('COLUMN', 'P_Qte_Line_Id', FALSE);
210: FND_MSG_PUB.ADD;
211: END IF;
206: IF ( P_Qte_Line_Id IS NULL OR P_Qte_Line_Id = FND_API.G_MISS_NUM ) THEN
207: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
208: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
209: FND_MESSAGE.Set_Token('COLUMN', 'P_Qte_Line_Id', FALSE);
210: FND_MSG_PUB.ADD;
211: END IF;
212: raise FND_API.G_EXC_ERROR;
213: End if;
214:
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
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
320: ( p_count => x_msg_count,
321: p_data => x_msg_data
322: );
323:
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
331: ,X_MSG_COUNT => X_MSG_COUNT
332: ,X_MSG_DATA => X_MSG_DATA
333: ,X_RETURN_STATUS => X_RETURN_STATUS);
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
341: ,X_MSG_COUNT => X_MSG_COUNT
342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);