APPS.GMIVDX dependencies on SY_REAS_CDS

Line 236: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;

232: l_api_version CONSTANT NUMBER := 1.0 ;
233: l_return_val NUMBER;
234: x_ic_item_mst_row ic_item_mst%ROWTYPE;
235: x_ic_whse_mst_row ic_whse_mst%ROWTYPE;
236: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;
237: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
238: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
239: l_check_qty NUMBER;
240: l_org INV_Validate.org;

Line 802: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;

798: END IF;
799: END IF;
800:
801: --validate the reason code for the transfer
802: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;
803: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN
804: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
805: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
806: FND_MSG_PUB.Add;

Line 803: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN

799: END IF;
800:
801: --validate the reason code for the transfer
802: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;
803: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN
804: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
805: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;

Line 804: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN

800:
801: --validate the reason code for the transfer
802: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;
803: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN
804: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
805: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: ELSIF (x_sy_reas_cds_row.reason_type = 2 AND p_hdr_rec.transfer_type = 1) THEN

Line 808: ELSIF (x_sy_reas_cds_row.reason_type = 2 AND p_hdr_rec.transfer_type = 1) THEN

804: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
805: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: ELSIF (x_sy_reas_cds_row.reason_type = 2 AND p_hdr_rec.transfer_type = 1) THEN
809: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEDECREASE');
810: FND_MSG_PUB.Add;
811: RAISE FND_API.G_EXC_ERROR;
812: END IF;