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 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149:
150: -- If there is no new modifier list at header level, this should
151: -- have been caught in entity validation hence raise unexp error.
152: IF l_modifier_list_id IS NULL THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: END IF;
157:

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

174: -----------------------------------------------------------
175: -- Set up the list line record
176: -----------------------------------------------------------
177: --for bug 3229225
178: IF (l_request_rec.param1 IS NULL OR l_request_rec.param1=FND_API.G_MISS_NUM)
179: AND (l_request_rec.param2 IS NULL OR l_request_rec.param2=FND_API.G_MISS_NUM)
180: THEN
181: IF l_debug_level > 0
182: THEN

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

175: -- Set up the list line record
176: -----------------------------------------------------------
177: --for bug 3229225
178: IF (l_request_rec.param1 IS NULL OR l_request_rec.param1=FND_API.G_MISS_NUM)
179: AND (l_request_rec.param2 IS NULL OR l_request_rec.param2=FND_API.G_MISS_NUM)
180: THEN
181: IF l_debug_level > 0
182: THEN
183: oe_debug_pub.add('Skip for null values');

Line 260: , p_init_msg_list => FND_API.G_FALSE

256: l_control_rec.called_from_ui := 'N';
257:
258: QP_Modifiers_GRP.Process_Modifiers
259: ( p_api_version_number => 1.0
260: , p_init_msg_list => FND_API.G_FALSE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , x_return_status => l_return_status
264: , x_msg_count => l_msg_count

Line 261: , p_return_values => FND_API.G_FALSE

257:
258: QP_Modifiers_GRP.Process_Modifiers
259: ( p_api_version_number => 1.0
260: , p_init_msg_list => FND_API.G_FALSE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , x_return_status => l_return_status
264: , x_msg_count => l_msg_count
265: , x_msg_data => l_msg_data

Line 262: , p_commit => FND_API.G_FALSE

258: QP_Modifiers_GRP.Process_Modifiers
259: ( p_api_version_number => 1.0
260: , p_init_msg_list => FND_API.G_FALSE
261: , p_return_values => FND_API.G_FALSE
262: , p_commit => FND_API.G_FALSE
263: , x_return_status => l_return_status
264: , x_msg_count => l_msg_count
265: , x_msg_data => l_msg_data
266: , p_control_rec => l_control_rec

Line 281: if l_return_status = fnd_api.g_ret_sts_error then

277: , x_pricing_attr_tbl => l_x_pricing_attr_tbl
278: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
279: );
280:
281: if l_return_status = fnd_api.g_ret_sts_error then
282: raise fnd_api.g_exc_error;
283: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
284: raise fnd_api.g_exc_unexpected_error;
285: end if;

Line 282: raise fnd_api.g_exc_error;

278: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
279: );
280:
281: if l_return_status = fnd_api.g_ret_sts_error then
282: raise fnd_api.g_exc_error;
283: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
284: raise fnd_api.g_exc_unexpected_error;
285: end if;
286:

Line 283: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

279: );
280:
281: if l_return_status = fnd_api.g_ret_sts_error then
282: raise fnd_api.g_exc_error;
283: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
284: raise fnd_api.g_exc_unexpected_error;
285: end if;
286:
287: -- As line level qualifiers cannot be created without list line IDs,

Line 284: raise fnd_api.g_exc_unexpected_error;

280:
281: if l_return_status = fnd_api.g_ret_sts_error then
282: raise fnd_api.g_exc_error;
283: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
284: raise fnd_api.g_exc_unexpected_error;
285: end if;
286:
287: -- As line level qualifiers cannot be created without list line IDs,
288: -- modifier list lines must be created in previous call to qp_modifiers_grp.

Line 328: , p_init_msg_list => FND_API.G_FALSE

324: END LOOP;
325:
326: QP_Qualifier_Rules_PUB.Process_Qualifier_Rules
327: ( p_api_version_number => 1.0
328: , p_init_msg_list => FND_API.G_FALSE
329: , p_return_values => FND_API.G_FALSE
330: , p_commit => FND_API.G_FALSE
331: , x_return_status => l_return_status
332: , x_msg_count => l_msg_count

Line 329: , p_return_values => FND_API.G_FALSE

325:
326: QP_Qualifier_Rules_PUB.Process_Qualifier_Rules
327: ( p_api_version_number => 1.0
328: , p_init_msg_list => FND_API.G_FALSE
329: , p_return_values => FND_API.G_FALSE
330: , p_commit => FND_API.G_FALSE
331: , x_return_status => l_return_status
332: , x_msg_count => l_msg_count
333: , x_msg_data => l_msg_data

Line 330: , p_commit => FND_API.G_FALSE

326: QP_Qualifier_Rules_PUB.Process_Qualifier_Rules
327: ( p_api_version_number => 1.0
328: , p_init_msg_list => FND_API.G_FALSE
329: , p_return_values => FND_API.G_FALSE
330: , p_commit => FND_API.G_FALSE
331: , x_return_status => l_return_status
332: , x_msg_count => l_msg_count
333: , x_msg_data => l_msg_data
334: , p_qualifiers_tbl => l_qualifiers_tbl

Line 343: if l_return_status = fnd_api.g_ret_sts_error then

339: );
340:
341: end if;
342:
343: if l_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;

Line 344: raise fnd_api.g_exc_error;

340:
341: end if;
342:
343: if l_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;
348:

Line 345: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

341: end if;
342:
343: if l_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;
348:
349: -------------------------------------------------------------------

Line 346: raise fnd_api.g_exc_unexpected_error;

342:
343: if l_return_status = fnd_api.g_ret_sts_error then
344: raise fnd_api.g_exc_error;
345: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;
348:
349: -------------------------------------------------------------------
350: -- Update modifier IDs on blanket tables

Line 413: WHEN FND_API.G_EXC_ERROR THEN

409: if l_debug_level > 0 then
410: oe_debug_pub.add('Exit Create_Modifiers',1);
411: end if;
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := fnd_api.g_ret_sts_error;
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: WHEN OTHERS THEN

Line 414: x_return_status := fnd_api.g_ret_sts_error;

410: oe_debug_pub.add('Exit Create_Modifiers',1);
411: end if;
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := fnd_api.g_ret_sts_error;
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: end if;
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := fnd_api.g_ret_sts_error;
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 416: x_return_status := fnd_api.g_ret_sts_unexp_error;

412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := fnd_api.g_ret_sts_error;
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
420: THEN

Line 418: x_return_status := fnd_api.g_ret_sts_unexp_error;

414: x_return_status := fnd_api.g_ret_sts_error;
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: WHEN OTHERS THEN
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
420: THEN
421: OE_MSG_PUB.Add_Exc_Msg
422: (G_PKG_NAME

Line 471: , p_init_msg_list => FND_API.G_FALSE

467: END IF;
468:
469: QP_PRICE_LIST_GRP.Process_Price_List
470: ( p_api_version_number => 1
471: , p_init_msg_list => FND_API.G_FALSE
472: , p_return_values => FND_API.G_FALSE
473: , p_commit => FND_API.G_FALSE
474: , x_return_status => x_return_status
475: , x_msg_count => gpr_msg_count

Line 472: , p_return_values => FND_API.G_FALSE

468:
469: QP_PRICE_LIST_GRP.Process_Price_List
470: ( p_api_version_number => 1
471: , p_init_msg_list => FND_API.G_FALSE
472: , p_return_values => FND_API.G_FALSE
473: , p_commit => FND_API.G_FALSE
474: , x_return_status => x_return_status
475: , x_msg_count => gpr_msg_count
476: , x_msg_data => gpr_msg_data

Line 473: , p_commit => FND_API.G_FALSE

469: QP_PRICE_LIST_GRP.Process_Price_List
470: ( p_api_version_number => 1
471: , p_init_msg_list => FND_API.G_FALSE
472: , p_return_values => FND_API.G_FALSE
473: , p_commit => FND_API.G_FALSE
474: , x_return_status => x_return_status
475: , x_msg_count => gpr_msg_count
476: , x_msg_data => gpr_msg_data
477: , p_PRICE_LIST_rec => gpr_price_list_rec

Line 494: WHEN FND_API.G_EXC_ERROR THEN

490: oe_debug_pub.add('Exit Deactivate_Price_List');
491: end if;
492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: x_return_status := fnd_api.g_ret_sts_error;
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN

Line 495: x_return_status := fnd_api.g_ret_sts_error;

491: end if;
492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: x_return_status := fnd_api.g_ret_sts_error;
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

492:
493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: x_return_status := fnd_api.g_ret_sts_error;
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 497: x_return_status := fnd_api.g_ret_sts_unexp_error;

493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: x_return_status := fnd_api.g_ret_sts_error;
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501: THEN

Line 499: x_return_status := fnd_api.g_ret_sts_unexp_error;

495: x_return_status := fnd_api.g_ret_sts_error;
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: x_return_status := fnd_api.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := fnd_api.g_ret_sts_unexp_error;
500: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501: THEN
502: OE_MSG_PUB.Add_Exc_Msg
503: (G_PKG_NAME

Line 559: , p_init_msg_list => FND_API.G_FALSE

555: l_control_rec.called_from_ui := 'N';
556:
557: QP_Modifiers_GRP.Process_Modifiers
558: ( p_api_version_number => 1.0
559: , p_init_msg_list => FND_API.G_FALSE
560: , p_return_values => FND_API.G_FALSE
561: , p_commit => FND_API.G_FALSE
562: , x_return_status => l_return_status
563: , x_msg_count => l_msg_count

Line 560: , p_return_values => FND_API.G_FALSE

556:
557: QP_Modifiers_GRP.Process_Modifiers
558: ( p_api_version_number => 1.0
559: , p_init_msg_list => FND_API.G_FALSE
560: , p_return_values => FND_API.G_FALSE
561: , p_commit => FND_API.G_FALSE
562: , x_return_status => l_return_status
563: , x_msg_count => l_msg_count
564: , x_msg_data => l_msg_data

Line 561: , p_commit => FND_API.G_FALSE

557: QP_Modifiers_GRP.Process_Modifiers
558: ( p_api_version_number => 1.0
559: , p_init_msg_list => FND_API.G_FALSE
560: , p_return_values => FND_API.G_FALSE
561: , p_commit => FND_API.G_FALSE
562: , x_return_status => l_return_status
563: , x_msg_count => l_msg_count
564: , x_msg_data => l_msg_data
565: , p_control_rec => l_control_rec

Line 578: if l_return_status = fnd_api.g_ret_sts_error then

574: , x_pricing_attr_tbl => l_x_pricing_attr_tbl
575: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
576: );
577:
578: if l_return_status = fnd_api.g_ret_sts_error then
579: raise fnd_api.g_exc_error;
580: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
581: raise fnd_api.g_exc_unexpected_error;
582: end if;

Line 579: raise fnd_api.g_exc_error;

575: , x_pricing_attr_val_tbl => l_x_pricing_attr_val_tbl
576: );
577:
578: if l_return_status = fnd_api.g_ret_sts_error then
579: raise fnd_api.g_exc_error;
580: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
581: raise fnd_api.g_exc_unexpected_error;
582: end if;
583:

Line 580: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

576: );
577:
578: if l_return_status = fnd_api.g_ret_sts_error then
579: raise fnd_api.g_exc_error;
580: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
581: raise fnd_api.g_exc_unexpected_error;
582: end if;
583:
584: if l_debug_level > 0 then

Line 581: raise fnd_api.g_exc_unexpected_error;

577:
578: if l_return_status = fnd_api.g_ret_sts_error then
579: raise fnd_api.g_exc_error;
580: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
581: raise fnd_api.g_exc_unexpected_error;
582: end if;
583:
584: if l_debug_level > 0 then
585: oe_debug_pub.add('Exit Deactivate_Modifier');

Line 589: WHEN FND_API.G_EXC_ERROR THEN

585: oe_debug_pub.add('Exit Deactivate_Modifier');
586: end if;
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := fnd_api.g_ret_sts_error;
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: WHEN OTHERS THEN

Line 590: x_return_status := fnd_api.g_ret_sts_error;

586: end if;
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := fnd_api.g_ret_sts_error;
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := fnd_api.g_ret_sts_error;
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 592: x_return_status := fnd_api.g_ret_sts_unexp_error;

588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := fnd_api.g_ret_sts_error;
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN

Line 594: x_return_status := fnd_api.g_ret_sts_unexp_error;

590: x_return_status := fnd_api.g_ret_sts_error;
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: WHEN OTHERS THEN
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: OE_MSG_PUB.Add_Exc_Msg
598: (G_PKG_NAME

Line 629: x_return_status := fnd_api.g_ret_sts_success;

625: oe_debug_pub.add('p_blanket_header_id :'||p_blanket_header_id);
626: oe_debug_pub.add('p_blanket_line_id :'||p_blanket_line_id);
627: end if;
628:
629: x_return_status := fnd_api.g_ret_sts_success;
630:
631: IF p_blanket_line_id IS NOT NULL THEN
632:
633: SELECT qp_list_line_id, modifier_list_line_id

Line 655: if l_return_status = fnd_api.g_ret_sts_error then

651: Deactivate_Price_List
652: (p_list_line_id => l_qp_list_line_id
653: ,x_return_status => l_return_status
654: );
655: if l_return_status = fnd_api.g_ret_sts_error then
656: raise fnd_api.g_exc_error;
657: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
658: raise fnd_api.g_exc_unexpected_error;
659: end if;

Line 656: raise fnd_api.g_exc_error;

652: (p_list_line_id => l_qp_list_line_id
653: ,x_return_status => l_return_status
654: );
655: if l_return_status = fnd_api.g_ret_sts_error then
656: raise fnd_api.g_exc_error;
657: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
658: raise fnd_api.g_exc_unexpected_error;
659: end if;
660: END IF;

Line 657: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

653: ,x_return_status => l_return_status
654: );
655: if l_return_status = fnd_api.g_ret_sts_error then
656: raise fnd_api.g_exc_error;
657: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
658: raise fnd_api.g_exc_unexpected_error;
659: end if;
660: END IF;
661:

Line 658: raise fnd_api.g_exc_unexpected_error;

654: );
655: if l_return_status = fnd_api.g_ret_sts_error then
656: raise fnd_api.g_exc_error;
657: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
658: raise fnd_api.g_exc_unexpected_error;
659: end if;
660: END IF;
661:
662: IF l_mod_list_line_id IS NOT NULL THEN

Line 667: if l_return_status = fnd_api.g_ret_sts_error then

663: Deactivate_Modifier
664: (p_list_line_id => l_mod_list_line_id
665: ,x_return_status => l_return_status
666: );
667: if l_return_status = fnd_api.g_ret_sts_error then
668: raise fnd_api.g_exc_error;
669: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
670: raise fnd_api.g_exc_unexpected_error;
671: end if;

Line 668: raise fnd_api.g_exc_error;

664: (p_list_line_id => l_mod_list_line_id
665: ,x_return_status => l_return_status
666: );
667: if l_return_status = fnd_api.g_ret_sts_error then
668: raise fnd_api.g_exc_error;
669: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
670: raise fnd_api.g_exc_unexpected_error;
671: end if;
672: END IF;

Line 669: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then

665: ,x_return_status => l_return_status
666: );
667: if l_return_status = fnd_api.g_ret_sts_error then
668: raise fnd_api.g_exc_error;
669: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
670: raise fnd_api.g_exc_unexpected_error;
671: end if;
672: END IF;
673:

Line 670: raise fnd_api.g_exc_unexpected_error;

666: );
667: if l_return_status = fnd_api.g_ret_sts_error then
668: raise fnd_api.g_exc_error;
669: elsif l_return_status = fnd_api.g_ret_sts_unexp_error then
670: raise fnd_api.g_exc_unexpected_error;
671: end if;
672: END IF;
673:
674: ELSIF p_blanket_header_id IS NOT NULL THEN

Line 706: WHEN FND_API.G_EXC_ERROR THEN

702: oe_debug_pub.add('Exit Deactivate_Pricing');
703: end if;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: WHEN OTHERS THEN

Line 707: x_return_status := fnd_api.g_ret_sts_error;

703: end if;
704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: WHEN OTHERS THEN
711: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

704:
705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: WHEN OTHERS THEN
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 709: x_return_status := fnd_api.g_ret_sts_unexp_error;

705: EXCEPTION
706: WHEN FND_API.G_EXC_ERROR THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: WHEN OTHERS THEN
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN

Line 711: x_return_status := fnd_api.g_ret_sts_unexp_error;

707: x_return_status := fnd_api.g_ret_sts_error;
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: WHEN OTHERS THEN
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: OE_MSG_PUB.Add_Exc_Msg
715: (G_PKG_NAME

Line 737: AND p_blanket_number <> FND_API.G_MISS_NUM

733: oe_debug_pub.add('Blanket num :'||p_blanket_number);
734: end if;
735:
736: IF p_blanket_number IS NOT NULL
737: AND p_blanket_number <> FND_API.G_MISS_NUM
738: THEN
739: select /* MOAC_SQL_CHANGE */ header_id
740: into l_blanket_header_id
741: from oe_blanket_headers_all

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: ( G_PKG_NAME
766: , 'Get_Blanket_Header_ID'
767: );
768: END IF;
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END Get_Blanket_Header_ID;
771:
772: FUNCTION Get_Blanket_Line_ID
773: ( p_blanket_number IN NUMBER

Line 821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

817: ( G_PKG_NAME
818: , 'Get_Blanket_Line_ID'
819: );
820: END IF;
821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
822: END Get_Blanket_Line_ID;
823:
824: FUNCTION Get_List_Line_ID
825: ( p_blanket_number IN NUMBER

Line 870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

866: ( G_PKG_NAME
867: , 'Get_List_Line_ID'
868: );
869: END IF;
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871: END Get_List_Line_ID;
872:
873: FUNCTION Get_Blanket_Rel_Amt
874: ( p_blanket_number IN NUMBER

Line 956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

952: ( G_PKG_NAME
953: , 'Get_Blanket_Rel_Amt'
954: );
955: END IF;
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: END Get_Blanket_Rel_Amt;
958:
959:
960: FUNCTION Get_Bl_Line_Rel_Amt

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: ( G_PKG_NAME
1034: , 'Get_Bl_Line_Rel_Amt'
1035: );
1036: END IF;
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END Get_Bl_Line_Rel_Amt;
1039:
1040: FUNCTION Get_Bl_Line_Rel_Qty
1041: ( p_blanket_number IN NUMBER

Line 1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1116: ( G_PKG_NAME
1117: , 'Get_Bl_Line_Rel_Qty'
1118: );
1119: END IF;
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END Get_Bl_Line_Rel_Qty;
1122:
1123: END OE_Blanket_Pricing_Util;