DBA Data[Home] [Help]

APPS.GMI_VALIDATE_ALLOCATION_PVT dependencies on FND_MESSAGE

Line 80: FND_MESSAGE.SET_NAME('GML','GML_USER_ID_REQUIRED');

76: IF NOT GMI_VALIDATE_ALLOCATION_PVT.Validate_who(p_allocation_rec.user_id
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:

Line 98: FND_MESSAGE.SET_NAME('GMI','SY_API_INVALID_USER_NAME');

94: --IF l_user_id = 0 /* 0 user_id is a valid value */
95:
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;

Line 99: FND_MESSAGE.SET_TOKEN('USER_NAME',p_allocation_rec.user_name);

95:
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

Line 115: FND_MESSAGE.SET_NAME('GML','GML_DOC_ID_REQUIRED');

111: /* dbms_output.put_line('Now do doc_id'); */
112: IF (p_allocation_rec.doc_id IS NULL)
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;

Line 116: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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

Line 127: FND_MESSAGE.SET_NAME('GML','GML_LINE_ID_REQUIRED');

123: /* dbms_output.put_line('Now check line_id'); */
124: IF (p_allocation_rec.line_id IS NULL)
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;

Line 128: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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

Line 138: FND_MESSAGE.SET_NAME('GML','SO_E_ITM_REQUIRED');

134: ===============*/
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:

Line 160: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');

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;
163: RAISE FND_API.G_EXC_ERROR;
164: ELSIF (x_ic_item_mst_rec.noninv_ind = 1)

Line 161: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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;
163: RAISE FND_API.G_EXC_ERROR;
164: ELSIF (x_ic_item_mst_rec.noninv_ind = 1)
165: THEN

Line 167: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');

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);
169: FND_MSG_PUB.Add;
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (x_ic_item_mst_rec.inactive_ind = 1)

Line 168: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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);
169: FND_MSG_PUB.Add;
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (x_ic_item_mst_rec.inactive_ind = 1)
172: THEN

Line 174: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

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);
176: FND_MSG_PUB.Add;
177: RAISE FND_API.G_EXC_ERROR;
178: ELSIF (x_ic_item_mst_rec.alloc_class IS NULL)

Line 175: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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

Line 181: FND_MESSAGE.SET_NAME('GML','GML_API_MISSING_ALLOC_CLASS');

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

Line 182: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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

Line 193: FND_MESSAGE.SET_NAME('GML','SO_E_WHSE_REQUIRED');

189: =================*/
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:

Line 205: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');

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;
209: ELSE

Line 206: FND_MESSAGE.SET_TOKEN('WHSE_CODE', p_allocation_rec.whse_code);

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

Line 217: FND_MESSAGE.SET_NAME('GML','GML_CO_CODE_REQUIRED');

213: /* Check co_code */
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:

Line 226: FND_MESSAGE.SET_NAME('GML','SO_E_CUST_NO_REQUIRED');

222: /* not needed for bug 2245351 Check cust_no */
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:

Line 235: FND_MESSAGE.SET_NAME('GML','PO_NONZERO_VAL');

231: /* Check order_qty */
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:

Line 245: FND_MESSAGE.SET_NAME('GML','GML_ORDER_QTY2_REQUIRED');

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

Line 246: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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

Line 255: FND_MESSAGE.SET_NAME('GML','SO_E_UOM1_REQUIRED');

251: /* Check order_um1 */
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:

Line 265: FND_MESSAGE.SET_NAME('GML','GML_ORDER_UM2_REQUIRED');

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

Line 266: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);

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

Line 275: FND_MESSAGE.SET_NAME('GML','SO_E_DATE_REQUIRED');

271: /* Check Trans_date */
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: