eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_VALIDATE_ALLOCATION_PVT dependencies on IC_ITEM_MST

Line 18: | x_ic_item_mst_rec OUT ic_item_mst%ROWTYPE |

14: | Used to ensure that mandatory input parameters have been supplied |
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 |

Line 32: , x_ic_item_mst_rec OUT NOCOPY ic_item_mst%ROWTYPE

28: Proc end of comments
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

Line 46: CURSOR ic_item_mst_c1 IS

42: l_msg_count NUMBER :=0;
43: l_msg_data VARCHAR2(2000);
44: l_return_status VARCHAR2(1);
45:
46: CURSOR ic_item_mst_c1 IS
47: SELECT *
48: FROM
49: ic_item_mst
50: WHERE

Line 49: ic_item_mst

45:
46: CURSOR ic_item_mst_c1 IS
47: SELECT *
48: FROM
49: ic_item_mst
50: WHERE
51: item_no = p_allocation_rec.item_no;
52:
53:

Line 145: OPEN ic_item_mst_c1;

141: END IF;
142:
143: /* Retrieve item attributes
144: ==========================*/
145: OPEN ic_item_mst_c1;
146: FETCH ic_item_mst_c1 INTO x_ic_item_mst_rec;
147: IF (ic_item_mst_c1%NOTFOUND)
148: THEN
149: CLOSE ic_item_mst_c1;

Line 146: FETCH ic_item_mst_c1 INTO x_ic_item_mst_rec;

142:
143: /* Retrieve item attributes
144: ==========================*/
145: OPEN ic_item_mst_c1;
146: FETCH ic_item_mst_c1 INTO x_ic_item_mst_rec;
147: IF (ic_item_mst_c1%NOTFOUND)
148: THEN
149: CLOSE ic_item_mst_c1;
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 147: IF (ic_item_mst_c1%NOTFOUND)

143: /* Retrieve item attributes
144: ==========================*/
145: OPEN ic_item_mst_c1;
146: FETCH ic_item_mst_c1 INTO x_ic_item_mst_rec;
147: IF (ic_item_mst_c1%NOTFOUND)
148: THEN
149: CLOSE ic_item_mst_c1;
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSE

Line 149: CLOSE ic_item_mst_c1;

145: OPEN ic_item_mst_c1;
146: FETCH ic_item_mst_c1 INTO x_ic_item_mst_rec;
147: IF (ic_item_mst_c1%NOTFOUND)
148: THEN
149: CLOSE ic_item_mst_c1;
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSE
152: CLOSE ic_item_mst_c1;
153: END IF;

Line 152: CLOSE ic_item_mst_c1;

148: THEN
149: CLOSE ic_item_mst_c1;
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: ELSE
152: CLOSE ic_item_mst_c1;
153: END IF;
154:
155: /*If errors found, then raise exception
156: ======================================*/

Line 157: IF (x_ic_item_mst_rec.item_id = 0) OR

153: END IF;
154:
155: /*If errors found, then raise exception
156: ======================================*/
157: IF (x_ic_item_mst_rec.item_id = 0) OR
158: (x_ic_item_mst_rec.delete_mark = 1)
159: THEN
160: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
161: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

Line 158: (x_ic_item_mst_rec.delete_mark = 1)

154:
155: /*If errors found, then raise exception
156: ======================================*/
157: IF (x_ic_item_mst_rec.item_id = 0) OR
158: (x_ic_item_mst_rec.delete_mark = 1)
159: THEN
160: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
161: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
162: FND_MSG_PUB.Add;

Line 164: ELSIF (x_ic_item_mst_rec.noninv_ind = 1)

160: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
161: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
162: FND_MSG_PUB.Add;
163: RAISE FND_API.G_EXC_ERROR;
164: ELSIF (x_ic_item_mst_rec.noninv_ind = 1)
165: THEN
166: oe_debug_pub.add('KYH ALLOCATION - noninv item',1);
167: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
168: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

Line 171: ELSIF (x_ic_item_mst_rec.inactive_ind = 1)

167: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
168: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
169: FND_MSG_PUB.Add;
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (x_ic_item_mst_rec.inactive_ind = 1)
172: THEN
173: oe_debug_pub.add('KYH ALLOCATION - inactive item',1);
174: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
175: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

Line 178: ELSIF (x_ic_item_mst_rec.alloc_class IS NULL)

174: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
175: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
176: FND_MSG_PUB.Add;
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF (x_ic_item_mst_rec.alloc_class IS NULL)
179: THEN
180: oe_debug_pub.add('KYH ALLOCATION - missing allocation class',1);
181: FND_MESSAGE.SET_NAME('GML','GML_API_MISSING_ALLOC_CLASS');
182: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

Line 241: IF x_ic_item_mst_rec.dualum_ind in (1,2,3) AND

237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239:
240: /* Check order_qty2 */
241: IF x_ic_item_mst_rec.dualum_ind in (1,2,3) AND
242: (p_allocation_rec.order_qty2 <= 0 OR p_allocation_rec.order_qty2 IS NULL)
243: THEN
244: oe_debug_pub.add('KYH ALLOCATION - missing order qty2',1);
245: FND_MESSAGE.SET_NAME('GML','GML_ORDER_QTY2_REQUIRED');

Line 261: IF x_ic_item_mst_rec.dualum_ind in (1,2,3) AND

257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: /* Check order_um2 */
261: IF x_ic_item_mst_rec.dualum_ind in (1,2,3) AND
262: (p_allocation_rec.order_um2 = ' ' OR p_allocation_rec.order_um2 IS NULL)
263: THEN
264: oe_debug_pub.add('KYH ALLOCATION - missing order UM2',1);
265: FND_MESSAGE.SET_NAME('GML','GML_ORDER_UM2_REQUIRED');