APPS.GMI_VALIDATE_ALLOCATION_PVT dependencies on IC_WHSE_MST

Line 19: | x_ic_whse_mst_rec OUT ic_whse_mst%ROWTYPE |

15: | |
16: | PARAMETERS |
17: | p_allocation_rec IN GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec |
18: | x_ic_item_mst_rec OUT ic_item_mst%ROWTYPE |
19: | x_ic_whse_mst_rec OUT ic_whse_mst%ROWTYPE |
20: | x_allocation_rec OUT GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec |
21: | x_return_status OUT VARCHAR2 |
22: | x_msg_count OUT NUMBER |
23: | x_msg_data OUT VARCHAR2 |

Line 33: , x_ic_whse_mst_rec OUT NOCOPY ic_whse_mst%ROWTYPE

29: */
30: PROCEDURE VALIDATE_INPUT_PARMS
31: ( p_allocation_rec IN GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
32: , x_ic_item_mst_rec OUT NOCOPY ic_item_mst%ROWTYPE
33: , x_ic_whse_mst_rec OUT NOCOPY ic_whse_mst%ROWTYPE
34: , x_allocation_rec OUT NOCOPY GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
35: , x_return_status OUT NOCOPY VARCHAR2
36: , x_msg_count OUT NOCOPY NUMBER
37: , x_msg_data OUT NOCOPY VARCHAR2

Line 54: CURSOR ic_whse_mst_c1 IS

50: WHERE
51: item_no = p_allocation_rec.item_no;
52:
53:
54: CURSOR ic_whse_mst_c1 IS
55: SELECT *
56: FROM
57: ic_whse_mst
58: WHERE

Line 57: ic_whse_mst

53:
54: CURSOR ic_whse_mst_c1 IS
55: SELECT *
56: FROM
57: ic_whse_mst
58: WHERE
59: whse_code = p_allocation_rec.whse_code and delete_mark=0;
60: BEGIN
61:

Line 200: OPEN ic_whse_mst_c1;

196: END IF;
197:
198: /*Retrieve warehouse attributes
199: ==============================*/
200: OPEN ic_whse_mst_c1;
201: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst_rec;
202: IF (ic_whse_mst_c1%NOTFOUND)
203: THEN
204: CLOSE ic_whse_mst_c1;

Line 201: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst_rec;

197:
198: /*Retrieve warehouse attributes
199: ==============================*/
200: OPEN ic_whse_mst_c1;
201: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst_rec;
202: IF (ic_whse_mst_c1%NOTFOUND)
203: THEN
204: CLOSE ic_whse_mst_c1;
205: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');

Line 202: IF (ic_whse_mst_c1%NOTFOUND)

198: /*Retrieve warehouse attributes
199: ==============================*/
200: OPEN ic_whse_mst_c1;
201: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst_rec;
202: IF (ic_whse_mst_c1%NOTFOUND)
203: THEN
204: CLOSE ic_whse_mst_c1;
205: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
206: FND_MESSAGE.SET_TOKEN('WHSE_CODE', p_allocation_rec.whse_code);

Line 204: CLOSE ic_whse_mst_c1;

200: OPEN ic_whse_mst_c1;
201: FETCH ic_whse_mst_c1 INTO x_ic_whse_mst_rec;
202: IF (ic_whse_mst_c1%NOTFOUND)
203: THEN
204: CLOSE ic_whse_mst_c1;
205: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
206: FND_MESSAGE.SET_TOKEN('WHSE_CODE', p_allocation_rec.whse_code);
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;

Line 210: CLOSE ic_whse_mst_c1;

206: FND_MESSAGE.SET_TOKEN('WHSE_CODE', p_allocation_rec.whse_code);
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: ELSE
210: CLOSE ic_whse_mst_c1;
211: END IF;
212:
213: /* Check co_code */
214: IF (p_allocation_rec.co_code = ' ' OR p_allocation_rec.co_code IS NULL)