DBA Data[Home] [Help]

APPS.GMI_VALIDATE_ALLOCATION_PVT dependencies on OE_DEBUG_PUB

Line 79: oe_debug_pub.add('OPM ALLOCATION - Validation fail on user',1);

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

Line 114: oe_debug_pub.add('KYH ALLOCATION - Validation fail on doc id',1);

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

Line 126: oe_debug_pub.add('KYH ALLOCATION - Validation fail on line id',1);

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

Line 137: oe_debug_pub.add('KYH ALLOCATION - Validation fail on item',1);

133: /* Check item_no
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;

Line 166: oe_debug_pub.add('KYH ALLOCATION - noninv item',1);

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);
169: FND_MSG_PUB.Add;
170: RAISE FND_API.G_EXC_ERROR;

Line 173: oe_debug_pub.add('KYH ALLOCATION - inactive item',1);

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);
176: FND_MSG_PUB.Add;
177: RAISE FND_API.G_EXC_ERROR;

Line 180: oe_debug_pub.add('KYH ALLOCATION - missing allocation class',1);

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

Line 192: oe_debug_pub.add('KYH ALLOCATION - missing whse code',1);

188: /* Check whse_code
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;

Line 216: oe_debug_pub.add('KYH ALLOCATION - missing CO CODE',1);

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

Line 225: oe_debug_pub.add('KYH ALLOCATION - missing CUST NO',1);

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

Line 234: oe_debug_pub.add('KYH ALLOCATION - missing order qty',1);

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

Line 244: oe_debug_pub.add('KYH ALLOCATION - missing order qty2',1);

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');
246: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;

Line 254: oe_debug_pub.add('KYH ALLOCATION - missing order UM',1);

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

Line 264: oe_debug_pub.add('KYH ALLOCATION - missing order UM2',1);

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');
266: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_allocation_rec.item_no);
267: FND_MSG_PUB.Add;
268: RAISE FND_API.G_EXC_ERROR;

Line 274: oe_debug_pub.add('KYH ALLOCATION - missing trans date',1);

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