APPS.GMIVDX dependencies on IC_WHSE_MST

Line 235: x_ic_whse_mst_row ic_whse_mst%ROWTYPE;

231: l_api_name CONSTANT VARCHAR2(30) := 'Validate_transfer' ;
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;

Line 281: ic_whse_mst w,

277:
278: Cursor Cur_get_opm_fiscal_details (Vwhse_code VARCHAR2) IS
279: SELECT p.co_code, p.sob_id, w.orgn_code, p.base_currency_code
280: FROM gl_plcy_mst p,
281: ic_whse_mst w,
282: sy_orgn_mst o
283: WHERE w.whse_code = Vwhse_code
284: AND o.orgn_code = w.orgn_code
285: AND p.co_code = o.co_code;

Line 632: x_ic_whse_mst_row.whse_code := p_line_rec_tbl(i).opm_whse_code;

628: RAISE FND_API.G_EXC_ERROR;
629: END IF;
630:
631: --lets see if the OPM warehouse is valid
632: x_ic_whse_mst_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
633: IF ( GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row) ) THEN
634: NULL;
635: ELSE
636: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_WHSE_CODE_NOT_FOUND');

Line 633: IF ( GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row) ) THEN

629: END IF;
630:
631: --lets see if the OPM warehouse is valid
632: x_ic_whse_mst_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
633: IF ( GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row) ) THEN
634: NULL;
635: ELSE
636: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_WHSE_CODE_NOT_FOUND');
637: FND_MESSAGE.SET_TOKEN('WHSE_CODE',p_line_rec_tbl(i).opm_whse_code);

Line 884: IF ( (x_ic_whse_mst_row.loct_ctl = 0)

880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882:
883: --Lets Validate the locations in OPM
884: IF ( (x_ic_whse_mst_row.loct_ctl = 0)
885: OR (x_ic_item_mst_row.loct_ctl = 0)
886: ) THEN
887: IF (nvl(p_line_rec_tbl(i).opm_location,GMIGUTL.IC$DEFAULT_LOCT) <> GMIGUTL.IC$DEFAULT_LOCT) THEN
888: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 899: ELSIF ( (x_ic_whse_mst_row.loct_ctl = 1)

895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898: p_line_rec_tbl(i).opm_location := GMIGUTL.IC$DEFAULT_LOCT;
899: ELSIF ( (x_ic_whse_mst_row.loct_ctl = 1)
900: AND (x_ic_item_mst_row.loct_ctl = 1)
901: ) THEN
902: SELECT count(1) INTO l_count
903: FROM ic_loct_inv -- Bug 8359386

Line 919: ELSIF ( (x_ic_whse_mst_row.loct_ctl = 2)

915: FND_MESSAGE.SET_TOKEN('WHSE_CODE',p_line_rec_tbl(i).opm_whse_code);
916: FND_MSG_PUB.Add;
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919: ELSIF ( (x_ic_whse_mst_row.loct_ctl = 2)
920: OR (x_ic_item_mst_row.loct_ctl = 2)
921: ) THEN
922: SELECT count(1) INTO l_count
923: FROM ic_loct_inv