DBA Data[Home] [Help]

APPS.GMI_VALIDATE_ALLOCATION_PVT dependencies on FND_MSG_PUB

Line 81: FND_MSG_PUB.Add;

77: ,p_allocation_rec.user_name)
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

Line 100: FND_MSG_PUB.Add;

96: IF l_user_id is NULL
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;

Line 117: FND_MSG_PUB.Add;

113: THEN
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

Line 129: FND_MSG_PUB.Add;

125: THEN
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

Line 139: FND_MSG_PUB.Add;

135: IF (p_allocation_rec.item_no = ' ' OR p_allocation_rec.item_no IS NULL)
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

Line 162: FND_MSG_PUB.Add;

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

Line 169: FND_MSG_PUB.Add;

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

Line 176: FND_MSG_PUB.Add;

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

Line 183: FND_MSG_PUB.Add;

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

Line 194: FND_MSG_PUB.Add;

190: IF (p_allocation_rec.whse_code = ' ' OR p_allocation_rec.whse_code IS NULL)
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

Line 207: FND_MSG_PUB.Add;

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

Line 218: FND_MSG_PUB.Add;

214: IF (p_allocation_rec.co_code = ' ' OR p_allocation_rec.co_code IS NULL)
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 */

Line 227: FND_MSG_PUB.Add;

223: /*IF (p_allocation_rec.cust_no = ' ' OR p_allocation_rec.cust_no IS NULL)
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 */

Line 236: FND_MSG_PUB.Add;

232: IF (p_allocation_rec.order_qty1 <= 0 OR p_allocation_rec.order_qty1 IS NULL)
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 */

Line 247: FND_MSG_PUB.Add;

243: THEN
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 */

Line 256: FND_MSG_PUB.Add;

252: IF (p_allocation_rec.order_um1 = ' ' OR p_allocation_rec.order_um1 IS NULL)
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 */

Line 267: FND_MSG_PUB.Add;

263: THEN
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 */

Line 276: FND_MSG_PUB.Add;

272: IF (p_allocation_rec.trans_date IS NULL)
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:

Line 289: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

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:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 295: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

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
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 300: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

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
304: , p_data => x_msg_data

Line 303: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

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
304: , p_data => x_msg_data
305: );
306:
307: END Validate_Input_Parms;