APPS.GMIVDX dependencies on GMIVDBL

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

502:
503: /* All lines need an item. Make sure we have one which can be used */
504: x_ic_item_mst_row.item_no := NULL;
505: x_ic_item_mst_row.item_id := p_line_rec_tbl(i).opm_item_id;
506: IF ( GMIVDBL.ic_item_mst_select(x_ic_item_mst_row, x_ic_item_mst_row) ) THEN
507: IF (x_ic_item_mst_row.noninv_ind = 1) THEN
508: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
509: FND_MESSAGE.SET_TOKEN('ITEM_NO',x_ic_item_mst_row.item_no);
510: FND_MSG_PUB.Add;

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

1089:
1090:
1091:
1092: --{
1093: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN
1094: --store quantities in opm item UOM and ODM item UOM
1095:
1096: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1097: l_return_val := GMICUOM.uom_conversion

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

1321: x_ic_loct_inv_row.location := p_line_rec_tbl(i).opm_location;
1322: x_ic_loct_inv_row.item_id := p_line_rec_tbl(i).opm_item_id;
1323: x_ic_loct_inv_row.lot_id := p_lot_rec_tbl(j).opm_lot_id;
1324:
1325: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN
1326: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1327: ELSE
1328: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1329: log_msg('Failed call to GMIVDBL.ic_loct_inv_select when transfer type is 1. Not an error.');

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

1325: IF GMIVDBL.ic_loct_inv_select(x_ic_loct_inv_row, x_ic_loct_inv_row) THEN
1326: p_lot_rec_tbl(j).opm_lot_status := x_ic_loct_inv_row.lot_status;
1327: ELSE
1328: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
1329: log_msg('Failed call to GMIVDBL.ic_loct_inv_select when transfer type is 1. Not an error.');
1330: END IF;
1331: END IF;
1332:
1333: END IF;