272:
273: -- Initialize message list if p_init_msg_list is set to TRUE.
274: IF FND_API.to_Boolean( p_init_msg_list )
275: THEN
276: FND_MSG_PUB.initialize;
277: END IF;
278:
279: -- Initialize API return status to SUCCESS
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
312: COMMIT WORK;
313: END IF;
314:
315: -- Standard call to get message count and if count is 1, get message info.
316: FND_MSG_PUB.Count_And_Get
317: ( p_count => x_msg_count,
318: p_data => x_msg_data );
319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
323: P_API_NAME => L_API_NAME,
324: P_PKG_NAME => G_PKG_NAME,
325: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
326: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
327: X_MSG_COUNT => X_MSG_COUNT,
328: X_MSG_DATA => X_MSG_DATA,
329: X_RETURN_STATUS => X_RETURN_STATUS);
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
334: P_API_NAME => L_API_NAME,
335: P_PKG_NAME => G_PKG_NAME,
336: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
337: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
338: X_MSG_COUNT => X_MSG_COUNT,
339: X_MSG_DATA => X_MSG_DATA,
340: X_RETURN_STATUS => X_RETURN_STATUS);
469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list )
472: THEN
473: FND_MSG_PUB.initialize;
474: END IF;
475:
476: -- Initialize API return status to SUCCESS
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
506: COMMIT WORK;
507: END IF;
508:
509: -- Standard call to get message count and if count is 1, get message info.
510: FND_MSG_PUB.Count_And_Get
511: ( p_count => x_msg_count,
512: p_data => x_msg_data );
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
517: P_API_NAME => L_API_NAME,
518: P_PKG_NAME => G_PKG_NAME,
519: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
520: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
521: X_MSG_COUNT => X_MSG_COUNT,
522: X_MSG_DATA => X_MSG_DATA,
523: X_RETURN_STATUS => X_RETURN_STATUS);
526: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
527: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
528: P_API_NAME => L_API_NAME,
529: P_PKG_NAME => G_PKG_NAME,
530: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
531: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
532: X_MSG_COUNT => X_MSG_COUNT,
533: X_MSG_DATA => X_MSG_DATA,
534: X_RETURN_STATUS => X_RETURN_STATUS);
579:
580: -- Initialize message list if p_init_msg_list is set to TRUE.
581: IF FND_API.to_Boolean( p_init_msg_list )
582: THEN
583: FND_MSG_PUB.initialize;
584: END IF;
585:
586: -- Initialize API return status to SUCCESS
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
609: COMMIT WORK;
610: END IF;
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get
614: ( p_count => x_msg_count,
615: p_data => x_msg_data );
616:
617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN
619: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
620: P_API_NAME => L_API_NAME,
621: P_PKG_NAME => G_PKG_NAME,
622: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
623: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
624: X_MSG_COUNT => X_MSG_COUNT,
625: X_MSG_DATA => X_MSG_DATA,
626: X_RETURN_STATUS => X_RETURN_STATUS);
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
631: P_API_NAME => L_API_NAME,
632: P_PKG_NAME => G_PKG_NAME,
633: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
634: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
635: X_MSG_COUNT => X_MSG_COUNT,
636: X_MSG_DATA => X_MSG_DATA,
637: X_RETURN_STATUS => X_RETURN_STATUS);