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.OE_BLANKET_PRICING_UTIL dependencies on FND_API

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: if l_debug_level > 0 then
91: oe_debug_pub.add('Enter Create_Modifiers',1);
92: end if;
93:
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: l_request_rec := oe_delayed_requests_pvt.g_delayed_requests(p_index);
97:
98: IF l_request_rec.request_type = 'CREATE_MODIFIER_LIST' THEN

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170:
171: -- If there is no new modifier list at header level, this should
172: -- have been caught in entity validation hence raise unexp error.
173: IF l_modifier_list_id IS NULL THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: END IF;
178:

Line 199: IF (l_request_rec.param1 IS NULL OR l_request_rec.param1=FND_API.G_MISS_NUM)

195: -----------------------------------------------------------
196: -- Set up the list line record
197: -----------------------------------------------------------
198: --for bug 3229225
199: IF (l_request_rec.param1 IS NULL OR l_request_rec.param1=FND_API.G_MISS_NUM)
200: AND (l_request_rec.param2 IS NULL OR l_request_rec.param2=FND_API.G_MISS_NUM)
201: THEN
202: IF l_debug_level > 0
203: THEN

Line 200: AND (l_request_rec.param2 IS NULL OR l_request_rec.param2=FND_API.G_MISS_NUM)

196: -- Set up the list line record
197: -----------------------------------------------------------
198: --for bug 3229225
199: IF (l_request_rec.param1 IS NULL OR l_request_rec.param1=FND_API.G_MISS_NUM)
200: AND (l_request_rec.param2 IS NULL OR l_request_rec.param2=FND_API.G_MISS_NUM)
201: THEN
202: IF l_debug_level > 0
203: THEN
204: oe_debug_pub.add('Skip for null values');

Line 281: , p_init_msg_list => FND_API.G_FALSE

277: l_control_rec.called_from_ui := 'N';
278:
279: QP_Modifiers_GRP.Process_Modifiers
280: ( p_api_version_number => 1.0
281: , p_init_msg_list => FND_API.G_FALSE
282: , p_return_values => FND_API.G_FALSE
283: , p_commit => FND_API.G_FALSE
284: , x_return_status => l_return_status
285: , x_msg_count => l_msg_count

Line 282: , p_return_values => FND_API.G_FALSE

278:
279: QP_Modifiers_GRP.Process_Modifiers
280: ( p_api_version_number => 1.0
281: , p_init_msg_list => FND_API.G_FALSE
282: , p_return_values => FND_API.G_FALSE
283: , p_commit => FND_API.G_FALSE
284: , x_return_status => l_return_status
285: , x_msg_count => l_msg_count
286: , x_msg_data => l_msg_data

Line 283: , p_commit => FND_API.G_FALSE

279: QP_Modifiers_GRP.Process_Modifiers
280: ( p_api_version_number => 1.0
281: , p_init_msg_list => FND_API.G_FALSE
282: , p_return_values => FND_API.G_FALSE
283: , p_commit => FND_API.G_FALSE
284: , x_return_status => l_return_status
285: , x_msg_count => l_msg_count
286: , x_msg_data => l_msg_data
287: , p_control_rec => l_control_rec

Line 302: if l_return_status = fnd_api.g_ret_sts_error then

298: , x_pricing_attr_tbl => l_x_pricing_attr_tbl
299: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
300: );
301:
302: if l_return_status = fnd_api.g_ret_sts_error then
303: raise fnd_api.g_exc_error;
304: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
305: raise fnd_api.g_exc_unexpected_error;
306: end if;

Line 303: raise fnd_api.g_exc_error;

299: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
300: );
301:
302: if l_return_status = fnd_api.g_ret_sts_error then
303: raise fnd_api.g_exc_error;
304: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
305: raise fnd_api.g_exc_unexpected_error;
306: end if;
307:

Line 304: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

300: );
301:
302: if l_return_status = fnd_api.g_ret_sts_error then
303: raise fnd_api.g_exc_error;
304: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
305: raise fnd_api.g_exc_unexpected_error;
306: end if;
307:
308: -- As line level qualifiers cannot be created without list line IDs,

Line 305: raise fnd_api.g_exc_unexpected_error;

301:
302: if l_return_status = fnd_api.g_ret_sts_error then
303: raise fnd_api.g_exc_error;
304: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
305: raise fnd_api.g_exc_unexpected_error;
306: end if;
307:
308: -- As line level qualifiers cannot be created without list line IDs,
309: -- modifier list lines must be created in previous call to qp_modifiers_grp.

Line 349: , p_init_msg_list => FND_API.G_FALSE

345: END LOOP;
346:
347: QP_Qualifier_Rules_PUB.Process_Qualifier_Rules
348: ( p_api_version_number => 1.0
349: , p_init_msg_list => FND_API.G_FALSE
350: , p_return_values => FND_API.G_FALSE
351: , p_commit => FND_API.G_FALSE
352: , x_return_status => l_return_status
353: , x_msg_count => l_msg_count

Line 350: , p_return_values => FND_API.G_FALSE

346:
347: QP_Qualifier_Rules_PUB.Process_Qualifier_Rules
348: ( p_api_version_number => 1.0
349: , p_init_msg_list => FND_API.G_FALSE
350: , p_return_values => FND_API.G_FALSE
351: , p_commit => FND_API.G_FALSE
352: , x_return_status => l_return_status
353: , x_msg_count => l_msg_count
354: , x_msg_data => l_msg_data

Line 351: , p_commit => FND_API.G_FALSE

347: QP_Qualifier_Rules_PUB.Process_Qualifier_Rules
348: ( p_api_version_number => 1.0
349: , p_init_msg_list => FND_API.G_FALSE
350: , p_return_values => FND_API.G_FALSE
351: , p_commit => FND_API.G_FALSE
352: , x_return_status => l_return_status
353: , x_msg_count => l_msg_count
354: , x_msg_data => l_msg_data
355: , p_qualifiers_tbl => l_qualifiers_tbl

Line 364: if l_return_status = fnd_api.g_ret_sts_error then

360: );
361:
362: end if;
363:
364: if l_return_status = fnd_api.g_ret_sts_error then
365: raise fnd_api.g_exc_error;
366: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
367: raise fnd_api.g_exc_unexpected_error;
368: end if;

Line 365: raise fnd_api.g_exc_error;

361:
362: end if;
363:
364: if l_return_status = fnd_api.g_ret_sts_error then
365: raise fnd_api.g_exc_error;
366: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
367: raise fnd_api.g_exc_unexpected_error;
368: end if;
369:

Line 366: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

362: end if;
363:
364: if l_return_status = fnd_api.g_ret_sts_error then
365: raise fnd_api.g_exc_error;
366: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
367: raise fnd_api.g_exc_unexpected_error;
368: end if;
369:
370: -------------------------------------------------------------------

Line 367: raise fnd_api.g_exc_unexpected_error;

363:
364: if l_return_status = fnd_api.g_ret_sts_error then
365: raise fnd_api.g_exc_error;
366: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
367: raise fnd_api.g_exc_unexpected_error;
368: end if;
369:
370: -------------------------------------------------------------------
371: -- Update modifier IDs on blanket tables

Line 434: WHEN FND_API.G_EXC_ERROR THEN

430: if l_debug_level > 0 then
431: oe_debug_pub.add('Exit Create_Modifiers',1);
432: end if;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := fnd_api.g_ret_sts_error;
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := fnd_api.g_ret_sts_unexp_error;
438: WHEN OTHERS THEN

Line 435: x_return_status := fnd_api.g_ret_sts_error;

431: oe_debug_pub.add('Exit Create_Modifiers',1);
432: end if;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := fnd_api.g_ret_sts_error;
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := fnd_api.g_ret_sts_unexp_error;
438: WHEN OTHERS THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

432: end if;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := fnd_api.g_ret_sts_error;
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := fnd_api.g_ret_sts_unexp_error;
438: WHEN OTHERS THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 437: x_return_status := fnd_api.g_ret_sts_unexp_error;

433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: x_return_status := fnd_api.g_ret_sts_error;
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := fnd_api.g_ret_sts_unexp_error;
438: WHEN OTHERS THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: x_return_status := fnd_api.g_ret_sts_error;
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status := fnd_api.g_ret_sts_unexp_error;
438: WHEN OTHERS THEN
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: OE_MSG_PUB.Add_Exc_Msg
443: (G_PKG_NAME

Line 492: , p_init_msg_list => FND_API.G_FALSE

488: END IF;
489:
490: QP_PRICE_LIST_GRP.Process_Price_List
491: ( p_api_version_number => 1
492: , p_init_msg_list => FND_API.G_FALSE
493: , p_return_values => FND_API.G_FALSE
494: , p_commit => FND_API.G_FALSE
495: , x_return_status => x_return_status
496: , x_msg_count => gpr_msg_count

Line 493: , p_return_values => FND_API.G_FALSE

489:
490: QP_PRICE_LIST_GRP.Process_Price_List
491: ( p_api_version_number => 1
492: , p_init_msg_list => FND_API.G_FALSE
493: , p_return_values => FND_API.G_FALSE
494: , p_commit => FND_API.G_FALSE
495: , x_return_status => x_return_status
496: , x_msg_count => gpr_msg_count
497: , x_msg_data => gpr_msg_data

Line 494: , p_commit => FND_API.G_FALSE

490: QP_PRICE_LIST_GRP.Process_Price_List
491: ( p_api_version_number => 1
492: , p_init_msg_list => FND_API.G_FALSE
493: , p_return_values => FND_API.G_FALSE
494: , p_commit => FND_API.G_FALSE
495: , x_return_status => x_return_status
496: , x_msg_count => gpr_msg_count
497: , x_msg_data => gpr_msg_data
498: , p_PRICE_LIST_rec => gpr_price_list_rec

Line 515: WHEN FND_API.G_EXC_ERROR THEN

511: oe_debug_pub.add('Exit Deactivate_Price_List');
512: end if;
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: WHEN OTHERS THEN

Line 516: x_return_status := fnd_api.g_ret_sts_error;

512: end if;
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 518: x_return_status := fnd_api.g_ret_sts_unexp_error;

514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN

Line 520: x_return_status := fnd_api.g_ret_sts_unexp_error;

516: x_return_status := fnd_api.g_ret_sts_error;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: OE_MSG_PUB.Add_Exc_Msg
524: (G_PKG_NAME

Line 580: , p_init_msg_list => FND_API.G_FALSE

576: l_control_rec.called_from_ui := 'N';
577:
578: QP_Modifiers_GRP.Process_Modifiers
579: ( p_api_version_number => 1.0
580: , p_init_msg_list => FND_API.G_FALSE
581: , p_return_values => FND_API.G_FALSE
582: , p_commit => FND_API.G_FALSE
583: , x_return_status => l_return_status
584: , x_msg_count => l_msg_count

Line 581: , p_return_values => FND_API.G_FALSE

577:
578: QP_Modifiers_GRP.Process_Modifiers
579: ( p_api_version_number => 1.0
580: , p_init_msg_list => FND_API.G_FALSE
581: , p_return_values => FND_API.G_FALSE
582: , p_commit => FND_API.G_FALSE
583: , x_return_status => l_return_status
584: , x_msg_count => l_msg_count
585: , x_msg_data => l_msg_data

Line 582: , p_commit => FND_API.G_FALSE

578: QP_Modifiers_GRP.Process_Modifiers
579: ( p_api_version_number => 1.0
580: , p_init_msg_list => FND_API.G_FALSE
581: , p_return_values => FND_API.G_FALSE
582: , p_commit => FND_API.G_FALSE
583: , x_return_status => l_return_status
584: , x_msg_count => l_msg_count
585: , x_msg_data => l_msg_data
586: , p_control_rec => l_control_rec

Line 599: if l_return_status = fnd_api.g_ret_sts_error then

595: , x_pricing_attr_tbl => l_x_pricing_attr_tbl
596: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
597: );
598:
599: if l_return_status = fnd_api.g_ret_sts_error then
600: raise fnd_api.g_exc_error;
601: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
602: raise fnd_api.g_exc_unexpected_error;
603: end if;

Line 600: raise fnd_api.g_exc_error;

596: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
597: );
598:
599: if l_return_status = fnd_api.g_ret_sts_error then
600: raise fnd_api.g_exc_error;
601: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
602: raise fnd_api.g_exc_unexpected_error;
603: end if;
604:

Line 601: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

597: );
598:
599: if l_return_status = fnd_api.g_ret_sts_error then
600: raise fnd_api.g_exc_error;
601: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
602: raise fnd_api.g_exc_unexpected_error;
603: end if;
604:
605: if l_debug_level > 0 then

Line 602: raise fnd_api.g_exc_unexpected_error;

598:
599: if l_return_status = fnd_api.g_ret_sts_error then
600: raise fnd_api.g_exc_error;
601: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
602: raise fnd_api.g_exc_unexpected_error;
603: end if;
604:
605: if l_debug_level > 0 then
606: oe_debug_pub.add('Exit Deactivate_Modifier');

Line 610: WHEN FND_API.G_EXC_ERROR THEN

606: oe_debug_pub.add('Exit Deactivate_Modifier');
607: end if;
608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: WHEN OTHERS THEN

Line 611: x_return_status := fnd_api.g_ret_sts_error;

607: end if;
608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 613: x_return_status := fnd_api.g_ret_sts_unexp_error;

609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN

Line 615: x_return_status := fnd_api.g_ret_sts_unexp_error;

611: x_return_status := fnd_api.g_ret_sts_error;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: x_return_status := fnd_api.g_ret_sts_unexp_error;
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: OE_MSG_PUB.Add_Exc_Msg
619: (G_PKG_NAME

Line 650: x_return_status := fnd_api.g_ret_sts_success;

646: oe_debug_pub.add('p_blanket_header_id :'||p_blanket_header_id);
647: oe_debug_pub.add('p_blanket_line_id :'||p_blanket_line_id);
648: end if;
649:
650: x_return_status := fnd_api.g_ret_sts_success;
651:
652: IF p_blanket_line_id IS NOT NULL THEN
653:
654: SELECT qp_list_line_id, modifier_list_line_id

Line 676: if l_return_status = fnd_api.g_ret_sts_error then

672: Deactivate_Price_List
673: (p_list_line_id => l_qp_list_line_id
674: ,x_return_status => l_return_status
675: );
676: if l_return_status = fnd_api.g_ret_sts_error then
677: raise fnd_api.g_exc_error;
678: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
679: raise fnd_api.g_exc_unexpected_error;
680: end if;

Line 677: raise fnd_api.g_exc_error;

673: (p_list_line_id => l_qp_list_line_id
674: ,x_return_status => l_return_status
675: );
676: if l_return_status = fnd_api.g_ret_sts_error then
677: raise fnd_api.g_exc_error;
678: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
679: raise fnd_api.g_exc_unexpected_error;
680: end if;
681: END IF;

Line 678: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

674: ,x_return_status => l_return_status
675: );
676: if l_return_status = fnd_api.g_ret_sts_error then
677: raise fnd_api.g_exc_error;
678: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
679: raise fnd_api.g_exc_unexpected_error;
680: end if;
681: END IF;
682:

Line 679: raise fnd_api.g_exc_unexpected_error;

675: );
676: if l_return_status = fnd_api.g_ret_sts_error then
677: raise fnd_api.g_exc_error;
678: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
679: raise fnd_api.g_exc_unexpected_error;
680: end if;
681: END IF;
682:
683: IF l_mod_list_line_id IS NOT NULL THEN

Line 688: if l_return_status = fnd_api.g_ret_sts_error then

684: Deactivate_Modifier
685: (p_list_line_id => l_mod_list_line_id
686: ,x_return_status => l_return_status
687: );
688: if l_return_status = fnd_api.g_ret_sts_error then
689: raise fnd_api.g_exc_error;
690: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
691: raise fnd_api.g_exc_unexpected_error;
692: end if;

Line 689: raise fnd_api.g_exc_error;

685: (p_list_line_id => l_mod_list_line_id
686: ,x_return_status => l_return_status
687: );
688: if l_return_status = fnd_api.g_ret_sts_error then
689: raise fnd_api.g_exc_error;
690: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
691: raise fnd_api.g_exc_unexpected_error;
692: end if;
693: END IF;

Line 690: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

686: ,x_return_status => l_return_status
687: );
688: if l_return_status = fnd_api.g_ret_sts_error then
689: raise fnd_api.g_exc_error;
690: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
691: raise fnd_api.g_exc_unexpected_error;
692: end if;
693: END IF;
694:

Line 691: raise fnd_api.g_exc_unexpected_error;

687: );
688: if l_return_status = fnd_api.g_ret_sts_error then
689: raise fnd_api.g_exc_error;
690: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
691: raise fnd_api.g_exc_unexpected_error;
692: end if;
693: END IF;
694:
695: ELSIF p_blanket_header_id IS NOT NULL THEN

Line 727: WHEN FND_API.G_EXC_ERROR THEN

723: oe_debug_pub.add('Exit Deactivate_Pricing');
724: end if;
725:
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: x_return_status := fnd_api.g_ret_sts_error;
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := fnd_api.g_ret_sts_unexp_error;
731: WHEN OTHERS THEN

Line 728: x_return_status := fnd_api.g_ret_sts_error;

724: end if;
725:
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: x_return_status := fnd_api.g_ret_sts_error;
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := fnd_api.g_ret_sts_unexp_error;
731: WHEN OTHERS THEN
732: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

725:
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: x_return_status := fnd_api.g_ret_sts_error;
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := fnd_api.g_ret_sts_unexp_error;
731: WHEN OTHERS THEN
732: x_return_status := fnd_api.g_ret_sts_unexp_error;
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 730: x_return_status := fnd_api.g_ret_sts_unexp_error;

726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: x_return_status := fnd_api.g_ret_sts_error;
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := fnd_api.g_ret_sts_unexp_error;
731: WHEN OTHERS THEN
732: x_return_status := fnd_api.g_ret_sts_unexp_error;
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN

Line 732: x_return_status := fnd_api.g_ret_sts_unexp_error;

728: x_return_status := fnd_api.g_ret_sts_error;
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: x_return_status := fnd_api.g_ret_sts_unexp_error;
731: WHEN OTHERS THEN
732: x_return_status := fnd_api.g_ret_sts_unexp_error;
733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: OE_MSG_PUB.Add_Exc_Msg
736: (G_PKG_NAME

Line 758: AND p_blanket_number <> FND_API.G_MISS_NUM

754: oe_debug_pub.add('Blanket num :'||p_blanket_number);
755: end if;
756:
757: IF p_blanket_number IS NOT NULL
758: AND p_blanket_number <> FND_API.G_MISS_NUM
759: THEN
760: select /* MOAC_SQL_CHANGE */ header_id
761: into l_blanket_header_id
762: from oe_blanket_headers_all

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: ( G_PKG_NAME
787: , 'Get_Blanket_Header_ID'
788: );
789: END IF;
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: END Get_Blanket_Header_ID;
792:
793: FUNCTION Get_Blanket_Line_ID
794: ( p_blanket_number IN NUMBER

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: ( G_PKG_NAME
839: , 'Get_Blanket_Line_ID'
840: );
841: END IF;
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: END Get_Blanket_Line_ID;
844:
845: FUNCTION Get_List_Line_ID
846: ( p_blanket_number IN NUMBER

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

887: ( G_PKG_NAME
888: , 'Get_List_Line_ID'
889: );
890: END IF;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END Get_List_Line_ID;
893:
894: FUNCTION Get_Blanket_Rel_Amt
895: ( p_blanket_number IN NUMBER

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: ( G_PKG_NAME
976: , 'Get_Blanket_Rel_Amt'
977: );
978: END IF;
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END Get_Blanket_Rel_Amt;
981:
982:
983: FUNCTION Get_Bl_Line_Rel_Amt

Line 1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1058: ( G_PKG_NAME
1059: , 'Get_Bl_Line_Rel_Amt'
1060: );
1061: END IF;
1062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END Get_Bl_Line_Rel_Amt;
1064:
1065: FUNCTION Get_Bl_Line_Rel_Qty
1066: ( p_blanket_number IN NUMBER

Line 1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1143: ( G_PKG_NAME
1144: , 'Get_Bl_Line_Rel_Qty'
1145: );
1146: END IF;
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: END Get_Bl_Line_Rel_Qty;
1149:
1150: END OE_Blanket_Pricing_Util;