APPS.GMIVDX dependencies on GMIVDBL

Line 499: IF ( GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row) ) THEN

495:
496: /* All lines need an item. Make sure we have one which can be used */
497: x_ic_item_mst_row.item_no := NULL;
498: x_ic_item_mst_row.item_id := p_line_rec_tbl(i).opm_item_id;
499: IF ( GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row) ) THEN
500: IF (x_ic_item_mst_row.noninv_ind = 1) THEN
501: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
502: FND_MESSAGE.SET_TOKEN('ITEM_NO',x_ic_item_mst_row.item_no);
503: FND_MSG_PUB.Add;

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 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 1086: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN

1082:
1083:
1084:
1085: --{
1086: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN
1087: --store quantities in opm item UOM and ODM item UOM
1088:
1089: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1090: l_return_val := GMICUOM.uom_conversion

Line 1318: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN

1314: x_ic_loct_inv_row.location := p_line_rec_tbl(i).opm_location;
1315: x_ic_loct_inv_row.item_id := p_line_rec_tbl(i).opm_item_id;
1316: x_ic_loct_inv_row.lot_id := p_lot_rec_tbl(j).opm_lot_id;
1317:
1318: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN
1319: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1320: ELSE
1321: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1322: log_msg('Failed call to GMIVDBL.ic_loct_inv_select when transfer type is 1. Not an error.');

Line 1322: log_msg('Failed call to GMIVDBL.ic_loct_inv_select when transfer type is 1. Not an error.');

1318: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN
1319: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1320: ELSE
1321: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1322: log_msg('Failed call to GMIVDBL.ic_loct_inv_select when transfer type is 1. Not an error.');
1323: END IF;
1324: END IF;
1325:
1326: END IF;