DBA Data[Home] [Help]

APPS.GMIVDX dependencies on GMIGUTL

Line 356: IF (NOT GMIGUTL.SETUP(FND_GLOBAL.USER_NAME)) THEN

352: x_return_status :=FND_API.G_RET_STS_SUCCESS;
353:
354: --this call will set up the profiles needed by the create lot engine
355: --and transaction engine in OPM.
356: IF (NOT GMIGUTL.SETUP(FND_GLOBAL.USER_NAME)) THEN
357: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
358: log_msg('Failed call to GMIGUTL.SETUP');
359: END IF;
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 358: log_msg('Failed call to GMIGUTL.SETUP');

354: --this call will set up the profiles needed by the create lot engine
355: --and transaction engine in OPM.
356: IF (NOT GMIGUTL.SETUP(FND_GLOBAL.USER_NAME)) THEN
357: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
358: log_msg('Failed call to GMIGUTL.SETUP');
359: END IF;
360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: END IF;
362:

Line 887: IF (nvl(p_line_rec_tbl(i).opm_location,GMIGUTL.IC$DEFAULT_LOCT) <> GMIGUTL.IC$DEFAULT_LOCT) THEN

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
889: log_msg('Failed while validating OPM location. Item and/or warehouse are not location controlled');
890: END IF;
891: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');

Line 898: p_line_rec_tbl(i).opm_location := GMIGUTL.IC$DEFAULT_LOCT;

894: FND_MESSAGE.SET_TOKEN('WHSE_CODE',p_line_rec_tbl(i).opm_whse_code);
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

Line 906: AND location <> GMIGUTL.IC$DEFAULT_LOCT;

902: SELECT count(1) INTO l_count
903: FROM ic_loct_inv -- Bug 8359386
904: WHERE whse_code = p_line_rec_tbl(i).opm_whse_code
905: AND location = p_line_rec_tbl(i).opm_location
906: AND location <> GMIGUTL.IC$DEFAULT_LOCT;
907:
908: IF (l_count = 0) THEN
909: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
910: log_msg('Failed while validating OPM location. Item and warehouse are validated location controlled');

Line 926: AND location <> GMIGUTL.IC$DEFAULT_LOCT;

922: SELECT count(1) INTO l_count
923: FROM ic_loct_inv
924: WHERE whse_code = p_line_rec_tbl(i).opm_whse_code
925: AND location = p_line_rec_tbl(i).opm_location
926: AND location <> GMIGUTL.IC$DEFAULT_LOCT;
927:
928: --we could have non validated locations in OPM when transfer is from discrete to process.
929: IF (l_count = 0) AND (p_hdr_rec.transfer_type = 0) THEN
930: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN