636: else
637: x_return_code := 'F';
638: x_return_msg := fnd_msg_pub.get(l_ret_count,'F');
639: end if;
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: exception when others then
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateSerialRange:'||sqlerrm;
639: end if;
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641:
642: exception when others then
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateSerialRange:'||sqlerrm;
645: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
646: END ValidateSerialRange;
647:
710: end loop;
711: x_return_msg := l_error_msg;
712: end if;
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715: exception when others then
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateLpn:'||sqlerrm;
718: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
712: end if;
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715: exception when others then
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateLpn:'||sqlerrm;
718: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
719: END ValidateLpn;
720:
833:
834:
835: l_ans := inv_rcv_integration_apis.validate_lot_number(
836: p_api_version => 1
837: , p_init_msg_lst => fnd_api.g_false
838: , x_return_status => l_return_status
839: , x_msg_count => l_msg_count
840: , x_msg_data => l_msg_data
841: , x_is_new_lot => x_is_new_lot
881: x_return_code := 'F';
882: x_return_msg := fnd_msg_pub.get(l_msg_count,'F');
883: end if;
884:
885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886: EXCEPTION WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateLot:'||sqlerrm;
889: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
883: end if;
884:
885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886: EXCEPTION WHEN OTHERS THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: x_return_msg := 'Unexpected Error at POSVASNB.pls.ValidateLot:'||sqlerrm;
889: LOG(FND_LOG.LEVEL_UNEXPECTED,l_api_name,l_progress||':'||sqlerrm);
890: END ValidateLot;
891:
1535: WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom (
1536: p_api_version_number => p_api_version_number,
1537: p_init_msg_list => p_init_msg_list,
1538: p_in_rec => l_wsh_in_rec,
1539: p_commit => fnd_api.g_false,
1540: x_return_status => x_return_status,
1541: x_out_rec => l_wsh_out_rec ,
1542: x_msg_count => l_msg_count,
1543: x_msg_data => l_msg_data );
1558: FOR l_index IN 1.. l_msg_count LOOP
1559:
1560: x_out_invalid_tbl.extend;
1561: x_out_invalid_tbl(x_out_invalid_tbl.last) :=
1562: fnd_msg_pub.get( p_encoded => FND_API.G_FALSE, p_msg_index => l_index );
1563: END LOOP;
1564:
1565: END IF;
1566: