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 FND_API

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: BEGIN
61:
62: /*Initialize API return status to sucess
63: =======================================*/
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: /* Move input rec to local variable
67: ==================================*/
68: x_allocation_rec := p_allocation_rec;

Line 82: RAISE FND_API.G_EXC_ERROR;

78: THEN
79: oe_debug_pub.add('OPM ALLOCATION - Validation fail on user',1);
80: FND_MESSAGE.SET_NAME('GML','GML_USER_ID_REQUIRED');
81: FND_MSG_PUB.Add;
82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84:
85: /*If USER_ID not supplied, retrieve it
86: =====================================*/

Line 101: RAISE FND_API.G_EXC_ERROR;

97: THEN
98: FND_MESSAGE.SET_NAME('GMI','SY_API_INVALID_USER_NAME');
99: FND_MESSAGE.SET_TOKEN('USER_NAME',p_allocation_rec.user_name);
100: FND_MSG_PUB.Add;
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103: ELSE
104: l_user_id := p_allocation_rec.user_id;
105: END IF;

Line 118: RAISE FND_API.G_EXC_ERROR;

114: oe_debug_pub.add('KYH ALLOCATION - Validation fail on doc id',1);
115: FND_MESSAGE.SET_NAME('GML','GML_DOC_ID_REQUIRED');
116: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
117: FND_MSG_PUB.Add;
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121: /* Check line_id
122: ===============*/

Line 130: RAISE FND_API.G_EXC_ERROR;

126: oe_debug_pub.add('KYH ALLOCATION - Validation fail on line id',1);
127: FND_MESSAGE.SET_NAME('GML','GML_LINE_ID_REQUIRED');
128: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
129: FND_MSG_PUB.Add;
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:
133: /* Check item_no
134: ===============*/

Line 140: RAISE FND_API.G_EXC_ERROR;

136: THEN
137: oe_debug_pub.add('KYH ALLOCATION - Validation fail on item',1);
138: FND_MESSAGE.SET_NAME('GML','SO_E_ITM_REQUIRED');
139: FND_MSG_PUB.Add;
140: RAISE FND_API.G_EXC_ERROR;
141: END IF;
142:
143: /* Retrieve item attributes
144: ==========================*/

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
154:

Line 163: RAISE FND_API.G_EXC_ERROR;

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;
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');

Line 170: RAISE FND_API.G_EXC_ERROR;

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);
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');

Line 177: RAISE FND_API.G_EXC_ERROR;

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);
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');

Line 184: RAISE FND_API.G_EXC_ERROR;

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);
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187:
188: /* Check whse_code

Line 195: RAISE FND_API.G_EXC_ERROR;

191: THEN
192: oe_debug_pub.add('KYH ALLOCATION - missing whse code',1);
193: FND_MESSAGE.SET_NAME('GML','SO_E_WHSE_REQUIRED');
194: FND_MSG_PUB.Add;
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: /*Retrieve warehouse attributes
199: ==============================*/

Line 208: RAISE FND_API.G_EXC_ERROR;

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;
209: ELSE
210: CLOSE ic_whse_mst_c1;
211: END IF;
212:

Line 219: RAISE FND_API.G_EXC_ERROR;

215: THEN
216: oe_debug_pub.add('KYH ALLOCATION - missing CO CODE',1);
217: FND_MESSAGE.SET_NAME('GML','GML_CO_CODE_REQUIRED');
218: FND_MSG_PUB.Add;
219: RAISE FND_API.G_EXC_ERROR;
220: END IF;
221:
222: /* not needed for bug 2245351 Check cust_no */
223: /*IF (p_allocation_rec.cust_no = ' ' OR p_allocation_rec.cust_no IS NULL)

Line 228: RAISE FND_API.G_EXC_ERROR;

224: THEN
225: oe_debug_pub.add('KYH ALLOCATION - missing CUST NO',1);
226: FND_MESSAGE.SET_NAME('GML','SO_E_CUST_NO_REQUIRED');
227: FND_MSG_PUB.Add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF; */
230:
231: /* Check order_qty */
232: IF (p_allocation_rec.order_qty1 <= 0 OR p_allocation_rec.order_qty1 IS NULL)

Line 237: RAISE FND_API.G_EXC_ERROR;

233: THEN
234: oe_debug_pub.add('KYH ALLOCATION - missing order qty',1);
235: FND_MESSAGE.SET_NAME('GML','PO_NONZERO_VAL');
236: FND_MSG_PUB.Add;
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

Line 248: RAISE FND_API.G_EXC_ERROR;

244: oe_debug_pub.add('KYH ALLOCATION - missing order qty2',1);
245: FND_MESSAGE.SET_NAME('GML','GML_ORDER_QTY2_REQUIRED');
246: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: /* Check order_um1 */
252: IF (p_allocation_rec.order_um1 = ' ' OR p_allocation_rec.order_um1 IS NULL)

Line 257: RAISE FND_API.G_EXC_ERROR;

253: THEN
254: oe_debug_pub.add('KYH ALLOCATION - missing order UM',1);
255: FND_MESSAGE.SET_NAME('GML','SO_E_UOM1_REQUIRED');
256: FND_MSG_PUB.Add;
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

Line 268: RAISE FND_API.G_EXC_ERROR;

264: oe_debug_pub.add('KYH ALLOCATION - missing order UM2',1);
265: FND_MESSAGE.SET_NAME('GML','GML_ORDER_UM2_REQUIRED');
266: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
267: FND_MSG_PUB.Add;
268: RAISE FND_API.G_EXC_ERROR;
269: END IF;
270:
271: /* Check Trans_date */
272: IF (p_allocation_rec.trans_date IS NULL)

Line 277: RAISE FND_API.G_EXC_ERROR;

273: THEN
274: oe_debug_pub.add('KYH ALLOCATION - missing trans date',1);
275: FND_MESSAGE.SET_NAME('GML','SO_E_DATE_REQUIRED');
276: FND_MSG_PUB.Add;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280:
281: /* Validation OK */

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283:
284: /* Exception Handling */
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
290: , p_data => x_msg_data
291: );

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284: /* Exception Handling */
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
290: , p_data => x_msg_data
291: );
292:

Line 293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

289: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
290: , p_data => x_msg_data
291: );
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
296: , p_data => x_msg_data
297: );

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: , p_data => x_msg_data
291: );
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298: WHEN OTHERS THEN

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

295: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298: WHEN OTHERS THEN
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
301: , l_api_name
302: );
303: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count