[Home] [Help]
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.To_Boolean(p_init_msg_list) THEN
87: FND_Msg_Pub.initialize;
88: END IF;
89:
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
142: COMMIT WORK;
143: END IF;
144:
145: -- Standard call to get message count and if count is 1, get message info.
146: FND_Msg_Pub.Count_And_Get(
147: p_encoded => FND_API.G_FALSE,
148: p_count => x_msg_count ,
149: p_data => x_msg_data
150: );
153: WHEN FND_API.G_EXC_ERROR THEN
154: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
155: P_API_NAME => L_API_NAME,
156: P_PKG_NAME => G_PKG_NAME,
157: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
158: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
159: P_SQLCODE => SQLCODE,
160: P_SQLERRM => SQLERRM,
161: X_MSG_COUNT => X_MSG_COUNT,
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
168: P_API_NAME => L_API_NAME,
169: P_PKG_NAME => G_PKG_NAME,
170: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
171: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
172: P_SQLCODE => SQLCODE,
173: P_SQLERRM => SQLERRM,
174: X_MSG_COUNT => X_MSG_COUNT,
260: END IF;
261:
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: IF FND_API.To_Boolean(p_init_msg_list) THEN
264: FND_Msg_Pub.initialize;
265: END IF;
266:
267: -- Initialize API return status to success
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: COMMIT WORK;
320: END IF;
321:
322: -- Standard call to get message count and if count is 1, get message info.
323: FND_Msg_Pub.Count_And_Get(
324: p_encoded => FND_API.G_FALSE,
325: p_count => x_msg_count ,
326: p_data => x_msg_data
327: );
330: WHEN FND_API.G_EXC_ERROR THEN
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME,
333: P_PKG_NAME => G_PKG_NAME,
334: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
335: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
336: P_SQLCODE => SQLCODE,
337: P_SQLERRM => SQLERRM,
338: X_MSG_COUNT => X_MSG_COUNT,
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
345: P_API_NAME => L_API_NAME,
346: P_PKG_NAME => G_PKG_NAME,
347: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
348: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
349: P_SQLCODE => SQLCODE,
350: P_SQLERRM => SQLERRM,
351: X_MSG_COUNT => X_MSG_COUNT,
449: END IF;
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.To_Boolean(p_init_msg_list) THEN
453: FND_Msg_Pub.initialize;
454: END IF;
455:
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
539: COMMIT WORK;
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.
543: FND_Msg_Pub.Count_And_Get(
544: p_encoded => FND_API.G_FALSE,
545: p_count => x_msg_count ,
546: p_data => x_msg_data
547: );
550: WHEN FND_API.G_EXC_ERROR THEN
551: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
552: P_API_NAME => L_API_NAME,
553: P_PKG_NAME => G_PKG_NAME,
554: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
555: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
556: P_SQLCODE => SQLCODE,
557: P_SQLERRM => SQLERRM,
558: X_MSG_COUNT => X_MSG_COUNT,
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
565: P_API_NAME => L_API_NAME,
566: P_PKG_NAME => G_PKG_NAME,
567: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
568: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
569: P_SQLCODE => SQLCODE,
570: P_SQLERRM => SQLERRM,
571: X_MSG_COUNT => X_MSG_COUNT,