APPS.GMI_OM_ALLOC_API_PUB dependencies on IC_LOCT_MST

Line 196: CURSOR ic_loct_mst_cur(p_location IN VARCHAR2

192: ,rejected_ind
193: FROM ic_lots_sts
194: WHERE lot_status = p_lot_status;
195:
196: CURSOR ic_loct_mst_cur(p_location IN VARCHAR2
197: ,p_whse_code IN VARCHAR2) IS
198: SELECT delete_mark
199: FROM ic_loct_mst
200: WHERE location = p_location

Line 199: FROM ic_loct_mst

195:
196: CURSOR ic_loct_mst_cur(p_location IN VARCHAR2
197: ,p_whse_code IN VARCHAR2) IS
198: SELECT delete_mark
199: FROM ic_loct_mst
200: WHERE location = p_location
201: AND whse_code = p_whse_code;
202:
203: CURSOR get_commited_qty_cur IS

Line 854: OPEN ic_loct_mst_cur( l_tran_rec.location,l_ic_whse_mst_rec.whse_code);

850: THEN
851: /* In not non validated location */
852: /* Check that the location is active */
853:
854: OPEN ic_loct_mst_cur( l_tran_rec.location,l_ic_whse_mst_rec.whse_code);
855: FETCH ic_loct_mst_cur INTO l_loc_inactive;
856:
857: IF ic_loct_mst_cur%NOTFOUND
858: THEN

Line 855: FETCH ic_loct_mst_cur INTO l_loc_inactive;

851: /* In not non validated location */
852: /* Check that the location is active */
853:
854: OPEN ic_loct_mst_cur( l_tran_rec.location,l_ic_whse_mst_rec.whse_code);
855: FETCH ic_loct_mst_cur INTO l_loc_inactive;
856:
857: IF ic_loct_mst_cur%NOTFOUND
858: THEN
859: close ic_loct_mst_cur;

Line 857: IF ic_loct_mst_cur%NOTFOUND

853:
854: OPEN ic_loct_mst_cur( l_tran_rec.location,l_ic_whse_mst_rec.whse_code);
855: FETCH ic_loct_mst_cur INTO l_loc_inactive;
856:
857: IF ic_loct_mst_cur%NOTFOUND
858: THEN
859: close ic_loct_mst_cur;
860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);
861: l_error_flag := FND_API.G_TRUE;

Line 859: close ic_loct_mst_cur;

855: FETCH ic_loct_mst_cur INTO l_loc_inactive;
856:
857: IF ic_loct_mst_cur%NOTFOUND
858: THEN
859: close ic_loct_mst_cur;
860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);
861: l_error_flag := FND_API.G_TRUE;
862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');
863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);

Line 860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);

856:
857: IF ic_loct_mst_cur%NOTFOUND
858: THEN
859: close ic_loct_mst_cur;
860: PrintMsg('ic_loct_mst_cur%NOTFOUND - Location is not found : '|| l_tran_rec.location);
861: l_error_flag := FND_API.G_TRUE;
862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');
863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
864: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);