APPS.GMIVDX dependencies on IC_WHSE_MST

Line 228: x_ic_whse_mst_row ic_whse_mst%ROWTYPE;

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

Line 274: ic_whse_mst w,

270:
271: Cursor Cur_get_opm_fiscal_details (Vwhse_code VARCHAR2) IS
272: SELECT p.co_code, p.sob_id, w.orgn_code, p.base_currency_code
273: FROM gl_plcy_mst p,
274: ic_whse_mst w,
275: sy_orgn_mst o
276: WHERE w.whse_code = Vwhse_code
277: AND o.orgn_code = w.orgn_code
278: AND p.co_code = o.co_code;

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

621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623:
624: --lets see if the OPM warehouse is valid
625: x_ic_whse_mst_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
626: IF ( GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row) ) THEN
627: NULL;
628: ELSE
629: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_WHSE_CODE_NOT_FOUND');

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

622: END IF;
623:
624: --lets see if the OPM warehouse is valid
625: x_ic_whse_mst_row.whse_code := p_line_rec_tbl(i).opm_whse_code;
626: IF ( GMIVDBL.ic_whse_mst_select(x_ic_whse_mst_row, x_ic_whse_mst_row) ) THEN
627: NULL;
628: ELSE
629: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_WHSE_CODE_NOT_FOUND');
630: FND_MESSAGE.SET_TOKEN('WHSE_CODE',p_line_rec_tbl(i).opm_whse_code);

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

873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:
876: --Lets Validate the locations in OPM
877: IF ( (x_ic_whse_mst_row.loct_ctl = 0)
878: OR (x_ic_item_mst_row.loct_ctl = 0)
879: ) THEN
880: IF (nvl(p_line_rec_tbl(i).opm_location,GMIGUTL.IC$DEFAULT_LOCT) <> GMIGUTL.IC$DEFAULT_LOCT) THEN
881: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

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

888: FND_MSG_PUB.Add;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891: p_line_rec_tbl(i).opm_location := GMIGUTL.IC$DEFAULT_LOCT;
892: ELSIF ( (x_ic_whse_mst_row.loct_ctl = 1)
893: AND (x_ic_item_mst_row.loct_ctl = 1)
894: ) THEN
895: SELECT count(1) INTO l_count
896: FROM ic_loct_mst

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

908: FND_MESSAGE.SET_TOKEN('WHSE_CODE',p_line_rec_tbl(i).opm_whse_code);
909: FND_MSG_PUB.Add;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: ELSIF ( (x_ic_whse_mst_row.loct_ctl = 2)
913: OR (x_ic_item_mst_row.loct_ctl = 2)
914: ) THEN
915: SELECT count(1) INTO l_count
916: FROM ic_loct_inv