358: +==========================================================================+
359: */
360: PROCEDURE Validate_item
361: ( p_api_version IN NUMBER
362: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL
363: , p_item_rec IN GMIGAPI.item_rec_typ
364: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
365: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
366: , x_return_status OUT NOCOPY VARCHAR2
378: l_api_name VARCHAR2(30) := 'Validate Item';
379: BEGIN
380:
381: /* Standard call to check for call compatibility. */
382: IF NOT FND_API.Compatible_API_CALL
383: (GMIGUTL.API_VERSION, p_api_version, 'Validate_Item', G_PKG_NAME)
384: THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
381: /* Standard call to check for call compatibility. */
382: IF NOT FND_API.Compatible_API_CALL
383: (GMIGUTL.API_VERSION, p_api_version, 'Validate_Item', G_PKG_NAME)
384: THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:
388: /* Validate input record and setup output rows */
389:
890: );
891: IF x_msg_count > 0
892: THEN
893: /* dbms_output.put_line(x_msg_data); */
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896:
897: /* Jalaj Srivastava Bug 3158806
898: Replace check for CPG_INSTALL with lot control */
904: x_ic_item_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
905: x_ic_item_cpg_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
906: END IF;
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
907:
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
914: , p_data => x_msg_data
915: );
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
914: , p_data => x_msg_data
915: );
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
914: , p_data => x_msg_data
915: );
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917:
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
920: , p_data => x_msg_data
914: , p_data => x_msg_data
915: );
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917:
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
920: , p_data => x_msg_data
921: );
922: WHEN OTHERS THEN
919: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
920: , p_data => x_msg_data
921: );
922: WHEN OTHERS THEN
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: /* IF FND_MSG_PUB.check_msg_level */
925: /* (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) */
926: /* THEN */
927: