DBA Data[Home] [Help]

APPS.OE_DUAL_UOM_UTIL dependencies on FND_API

Line 170: RAISE FND_API.G_EXC_ERROR;

166: WHEN NO_DATA_FOUND THEN
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add(' gfb: NoDataFound Error ' ||sqlerrm);
169: END IF;
170: RAISE FND_API.G_EXC_ERROR;
171:
172: WHEN OTHERS THEN
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add(' gfb: Other Error ' ||sqlerrm);

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172: WHEN OTHERS THEN
173: IF l_debug_level > 0 THEN
174: oe_debug_pub.add(' gfb: Other Error ' ||sqlerrm);
175: END IF;
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177:
178: End ;
179: ------------------------------------------------------------------------------------------------------
180:

Line 254: RAISE FND_API.G_EXC_ERROR;

250: oe_debug_pub.add('derive_fulfillment_base: INVALID ITEM WAREHOUSE COMBINATION',3);
251: END IF;
252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ITEM_WHSE');
253: OE_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_ERROR;
255: END ;
256:
257:
258:

Line 327: RAISE FND_API.G_EXC_ERROR;

323: oe_debug_pub.add('derive_fulfillment_base: get_fulfillment_base hook returned invlaid status ' ||l_fulfillment_base);
324: END IF;
325: fnd_message.set_name('ONT',' OE_FB_HOOK_ERROR ');
326: OE_MSG_PUB.Add;
327: RAISE FND_API.G_EXC_ERROR;
328: ELSIF l_fulfillment_base IS NOT NULL THEN
329: RETURN l_fulfillment_base;
330: END IF;
331:

Line 392: RAISE FND_API.G_EXC_ERROR;

388: WHEN NO_DATA_FOUND THEN
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add(' DeriveFB: NoDataFound Error ' ||sqlerrm);
391: END IF;
392: RAISE FND_API.G_EXC_ERROR;
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add(' DeriveFB: G_EXC_ERROR ' ||sqlerrm);
396: END IF;

Line 393: WHEN FND_API.G_EXC_ERROR THEN

389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add(' DeriveFB: NoDataFound Error ' ||sqlerrm);
391: END IF;
392: RAISE FND_API.G_EXC_ERROR;
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add(' DeriveFB: G_EXC_ERROR ' ||sqlerrm);
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;

Line 397: RAISE FND_API.G_EXC_ERROR;

393: WHEN FND_API.G_EXC_ERROR THEN
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add(' DeriveFB: G_EXC_ERROR ' ||sqlerrm);
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;
398:
399: WHEN OTHERS THEN
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add(' DeriveFB: Error in derive_fulfillment_base API: ' ||sqlerrm);

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: ( 'OE_DUAL_UOM_UTIL'
406: , 'derive_fulfillment_base'
407: );
408: END IF;
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END derive_fulfillment_base ;
411:
412: ------------------------------------------------------------------------------------------------------
413: ---------------------------------------------------------------------

Line 469: RAISE FND_API.G_EXC_ERROR;

465:
466: IF Nvl (l_pick_status,'X') = 'Y' THEN
467: fnd_message.set_name('ONT','OE_CANNOT_UPD_FB');
468: OE_MSG_PUB.Add;
469: RAISE FND_API.G_EXC_ERROR;
470: END IF;
471:
472: --- 2 VALIDATION. If an Open refernce line exists against current line and have non null and different value of FB , then cannot change FB on original line.
473: /*

Line 516: RAISE FND_API.G_EXC_ERROR;

512:
513: IF Nvl (l_ret_exists,'X') = 'Y' THEN
514: fnd_message.set_name('ONT','OE_CANNOT_UPD_RET_FB');
515: OE_MSG_PUB.Add;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
518:
519: ---3 VALIDATION. G_VALIDATE_LINE_SET request is also logged in oe_line_util.pre_write for p_line_rec.operation = oe_globals.g_opr_update
520: -- to ensure that fulfillment base is same on a line set...---Below condtion added for bug 16731675

Line 529: p_line_rec.split_action_code <> FND_API.G_MISS_CHAR) AND

525: END IF;
526:
527: IF (p_line_rec.operation = oe_globals.g_opr_create) AND
528: NOT (p_line_rec.split_action_code IS NOT NULL AND
529: p_line_rec.split_action_code <> FND_API.G_MISS_CHAR) AND
530: (p_line_rec.line_set_id IS NOT NULL AND
531: p_line_rec.line_set_id <> FND_API.G_MISS_NUM) THEN
532:
533: IF l_debug_level > 0 THEN

Line 531: p_line_rec.line_set_id <> FND_API.G_MISS_NUM) THEN

527: IF (p_line_rec.operation = oe_globals.g_opr_create) AND
528: NOT (p_line_rec.split_action_code IS NOT NULL AND
529: p_line_rec.split_action_code <> FND_API.G_MISS_CHAR) AND
530: (p_line_rec.line_set_id IS NOT NULL AND
531: p_line_rec.line_set_id <> FND_API.G_MISS_NUM) THEN
532:
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.ADD('Validating FB: logging G_VALIDATE_LINE_SET ',1);
535: END IF;