APPS.GMIVDX dependencies on SY_REAS_CDS

Line 229: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;

225: l_api_version CONSTANT NUMBER := 1.0 ;
226: l_return_val NUMBER;
227: x_ic_item_mst_row ic_item_mst%ROWTYPE;
228: x_ic_whse_mst_row ic_whse_mst%ROWTYPE;
229: x_sy_reas_cds_row sy_reas_cds%ROWTYPE;
230: x_ic_lots_mst_row ic_lots_mst%ROWTYPE;
231: x_ic_loct_inv_row ic_loct_inv%ROWTYPE;
232: l_check_qty NUMBER;
233: l_org INV_Validate.org;

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

791: END IF;
792: END IF;
793:
794: --validate the reason code for the transfer
795: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;
796: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN
797: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
798: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
799: FND_MSG_PUB.Add;

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

792: END IF;
793:
794: --validate the reason code for the transfer
795: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;
796: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN
797: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
798: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
799: FND_MSG_PUB.Add;
800: RAISE FND_API.G_EXC_ERROR;

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

793:
794: --validate the reason code for the transfer
795: x_sy_reas_cds_row.reason_code := p_line_rec_tbl(i).opm_reason_code;
796: IF GMIVDBL.sy_reas_cds_select(x_sy_reas_cds_row, x_sy_reas_cds_row) THEN
797: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
798: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
799: FND_MSG_PUB.Add;
800: RAISE FND_API.G_EXC_ERROR;
801: ELSIF (x_sy_reas_cds_row.reason_type = 2 AND p_hdr_rec.transfer_type = 1) THEN

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

797: IF (x_sy_reas_cds_row.reason_type = 1 AND p_hdr_rec.transfer_type = 0) THEN
798: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEINCREASE');
799: FND_MSG_PUB.Add;
800: RAISE FND_API.G_EXC_ERROR;
801: ELSIF (x_sy_reas_cds_row.reason_type = 2 AND p_hdr_rec.transfer_type = 1) THEN
802: FND_MESSAGE.SET_NAME('GMI','IC_REASONTYPEDECREASE');
803: FND_MSG_PUB.Add;
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;