[Home] [Help]
347: END IF;
348:
349: -- Initialize message list if p_init_msg_list is set to TRUE.
350: IF FND_API.to_Boolean( p_init_msg_list ) THEN
351: FND_MSG_PUB.initialize;
352: END IF;
353:
354: -- Initialize API return status to SUCCESS
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
396: COMMIT WORK;
397: END IF;
398:
399: -- Standard call to get message count and if count is 1, get message info.
400: FND_MSG_PUB.Count_And_Get
401: ( p_encoded => FND_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data );
404:
406: WHEN FND_API.G_EXC_ERROR THEN
407: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME,
409: P_PKG_NAME => G_PKG_NAME,
410: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
411: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
412: X_MSG_COUNT => X_MSG_COUNT,
413: X_MSG_DATA => X_MSG_DATA,
414: X_RETURN_STATUS => X_RETURN_STATUS);
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
419: P_API_NAME => L_API_NAME,
420: P_PKG_NAME => G_PKG_NAME,
421: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
422: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
423: X_MSG_COUNT => X_MSG_COUNT,
424: X_MSG_DATA => X_MSG_DATA,
425: X_RETURN_STATUS => X_RETURN_STATUS);
583: END IF;
584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF FND_API.to_Boolean( p_init_msg_list ) THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: -- Initialize API return status to SUCCESS
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: COMMIT WORK;
628: END IF;
629:
630: -- Standard call to get message count and if count is 1, get message info.
631: FND_MSG_PUB.Count_And_Get
632: ( p_encoded => FND_API.G_FALSE,
633: p_count => x_msg_count,
634: p_data => x_msg_data );
635:
637: WHEN FND_API.G_EXC_ERROR THEN
638: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
639: P_API_NAME => L_API_NAME,
640: P_PKG_NAME => G_PKG_NAME,
641: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
642: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
643: X_MSG_COUNT => X_MSG_COUNT,
644: X_MSG_DATA => X_MSG_DATA,
645: X_RETURN_STATUS => X_RETURN_STATUS);
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
650: P_API_NAME => L_API_NAME,
651: P_PKG_NAME => G_PKG_NAME,
652: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
653: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
654: X_MSG_COUNT => X_MSG_COUNT,
655: X_MSG_DATA => X_MSG_DATA,
656: X_RETURN_STATUS => X_RETURN_STATUS);
696: END IF;
697:
698: -- Initialize message list if p_init_msg_list is set to TRUE.
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702:
703: -- Initialize API return status to SUCCESS
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
725: COMMIT WORK;
726: END IF;
727:
728: -- Standard call to get message count and if count is 1, get message info.
729: FND_MSG_PUB.Count_And_Get
730: ( p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data );
733:
735: WHEN FND_API.G_EXC_ERROR THEN
736: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
737: P_API_NAME => L_API_NAME,
738: P_PKG_NAME => G_PKG_NAME,
739: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
740: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
741: X_MSG_COUNT => X_MSG_COUNT,
742: X_MSG_DATA => X_MSG_DATA,
743: X_RETURN_STATUS => X_RETURN_STATUS);
745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
746: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
747: P_API_NAME => L_API_NAME,
748: P_PKG_NAME => G_PKG_NAME,
749: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
750: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PUB,
751: X_MSG_COUNT => X_MSG_COUNT,
752: X_MSG_DATA => X_MSG_DATA,
753: X_RETURN_STATUS => X_RETURN_STATUS);