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_PURCHASE_RELEASE_PVT dependencies on FND_API

Line 124: IF NOT FND_API.Compatible_API_Call

120: IF l_debug_level > 0 THEN
121: oe_debug_pub.add('Entering Purchase Release' , 1 ) ;
122: END IF;
123:
124: IF NOT FND_API.Compatible_API_Call
125: ( l_api_version_number
126: , p_api_version_number
127: , l_api_name
128: , G_PKG_NAME

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: , l_api_name
128: , G_PKG_NAME
129: )
130: THEN
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133:
134: l_drop_ship_tbl := p_drop_ship_tbl;
135:

Line 202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add('Freeze ret status '||l_return_status,5);
200: END IF;
201:
202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE Purchase_Release_Incomplete;
204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

200: END IF;
201:
202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE Purchase_Release_Incomplete;
204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207: END IF;
208:

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201:
202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE Purchase_Release_Incomplete;
204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207: END IF;
208:
209: END IF;

Line 244: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

240: p_msg_data => l_msg_data);
241:
242: l_invoke_verify_payment := 'N';
243:
244: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add('Exception: verify payment returns failure',1);
247: END IF;
248: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857

Line 250: IF l_return_status = FND_API.G_RET_STS_ERROR then

246: oe_debug_pub.add('Exception: verify payment returns failure',1);
247: END IF;
248: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857
249: OE_MSG_PUB.Save_API_Messages; --bug4683857
250: IF l_return_status = FND_API.G_RET_STS_ERROR then
251: RAISE Purchase_Release_Incomplete;
252: ELSE
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: OE_MSG_PUB.Save_API_Messages; --bug4683857
250: IF l_return_status = FND_API.G_RET_STS_ERROR then
251: RAISE Purchase_Release_Incomplete;
252: ELSE
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255: END IF;
256: END IF;
257: --END IF; -- for 2412678

Line 271: ,p_init_msg_list => FND_API.G_FALSE

267: oe_debug_pub.add('Calling check holds including activity based holds',5);
268: END IF;
269: OE_Holds_PUB.Check_Holds
270: ( p_api_version => 1.0
271: ,p_init_msg_list => FND_API.G_FALSE
272: ,p_commit => FND_API.G_FALSE
273: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
274: ,x_return_status => l_return_status
275: ,x_msg_count => l_msg_count

Line 272: ,p_commit => FND_API.G_FALSE

268: END IF;
269: OE_Holds_PUB.Check_Holds
270: ( p_api_version => 1.0
271: ,p_init_msg_list => FND_API.G_FALSE
272: ,p_commit => FND_API.G_FALSE
273: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
274: ,x_return_status => l_return_status
275: ,x_msg_count => l_msg_count
276: ,x_msg_data => l_msg_data

Line 273: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

269: OE_Holds_PUB.Check_Holds
270: ( p_api_version => 1.0
271: ,p_init_msg_list => FND_API.G_FALSE
272: ,p_commit => FND_API.G_FALSE
273: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
274: ,x_return_status => l_return_status
275: ,x_msg_count => l_msg_count
276: ,x_msg_data => l_msg_data
277: ,p_line_id => l_drop_ship_line_rec.line_id

Line 292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

288: IF l_debug_level > 0 THEN
289: oe_debug_pub.add('Return result => '||l_result,1);
290: END IF;
291:
292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
293:
294: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857
295: OE_MSG_PUB.Save_API_Messages; --bug4683857
296: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 296: IF l_return_status = FND_API.G_RET_STS_ERROR then

292: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
293:
294: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857
295: OE_MSG_PUB.Save_API_Messages; --bug4683857
296: IF l_return_status = FND_API.G_RET_STS_ERROR then
297: RAISE Purchase_Release_Incomplete;
298: ELSE
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: OE_MSG_PUB.Save_API_Messages; --bug4683857
296: IF l_return_status = FND_API.G_RET_STS_ERROR then
297: RAISE Purchase_Release_Incomplete;
298: ELSE
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301: END IF;
302:
303: IF (l_result = FND_API.G_TRUE) then

Line 303: IF (l_result = FND_API.G_TRUE) then

299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301: END IF;
302:
303: IF (l_result = FND_API.G_TRUE) then
304: FND_MESSAGE.SET_NAME('ONT','OE_II_HOLD_FOUND');
305: OE_MSG_PUB.Add;
306: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_ONHOLD;
307: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 307: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;

303: IF (l_result = FND_API.G_TRUE) then
304: FND_MESSAGE.SET_NAME('ONT','OE_II_HOLD_FOUND');
305: OE_MSG_PUB.Add;
306: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_ONHOLD;
307: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
308: RAISE Purchase_Release_Incomplete;
309: END IF;
310: END IF;/* If line is not a service line */
311:

Line 315: l_return_status := FND_API.G_RET_STS_ERROR;

311:
312: IF l_drop_ship_line_rec.deliver_to_location_id is null THEN
313: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
314: OE_MSG_PUB.Add;
315: l_return_status := FND_API.G_RET_STS_ERROR;
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('Exception, Deliver to Location is not setup correctly',1);
318: END IF;
319: RAISE Purchase_Release_Incomplete;

Line 439: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;

435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add('Wrong source type '|| l_drop_ship_line_rec.line_id,3);
437: END IF;
438: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
439: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
440: goto end_of_for_loop;
441: ELSE
442: SELECT shippable_flag
443: INTO l_shippable_flag

Line 452: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;

448: IF l_debug_level > 0 THEN
449: oe_debug_pub.add('Non shippable!! '|| l_drop_ship_line_rec.line_id,3);
450: END IF;
451: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
452: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
453: goto end_of_for_loop;
454: END IF;
455:
456: --Fix for bug#2678070-Begin

Line 504: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

500: oe_debug_pub.add('Now calling Process Order from OEXVDSPB',1);
501: END IF;
502:
503: OE_ORDER_PVT.Lines
504: (p_validation_level => FND_API.G_VALID_LEVEL_NONE
505: ,p_control_rec => l_control_rec
506: ,p_x_line_tbl => l_line_tbl
507: ,p_x_old_line_tbl => l_old_line_tbl
508: ,x_return_status => l_return_status);

Line 519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

515: -- Bug# 4189838 Start
516: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
517: -- Bug# 4189838 End
518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
517: -- Bug# 4189838 End
518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:

Line 521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

517: -- Bug# 4189838 End
518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: IF l_debug_level > 0 THEN

Line 522: RAISE FND_API.G_EXC_ERROR;

518:
519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524:
525: IF l_debug_level > 0 THEN
526: OE_DEBUG_PUB.add('Calling Process Request and Notify',1);

Line 536: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

532: ,x_return_status => l_return_status
533: ,p_line_tbl => l_line_tbl
534: ,p_old_line_tbl => l_old_line_tbl);
535:
536: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;

Line 537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

533: ,p_line_tbl => l_line_tbl
534: ,p_old_line_tbl => l_old_line_tbl);
535:
536: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541:

Line 538: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

534: ,p_old_line_tbl => l_old_line_tbl);
535:
536: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541:
542: END IF; /* If schedule_ship_date is null */

Line 539: RAISE FND_API.G_EXC_ERROR;

535:
536: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
538: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541:
542: END IF; /* If schedule_ship_date is null */
543: --Fix for bug#2678070-End

Line 584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add('After inserting ',1);
582: END IF;
583:
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
585: IF l_return_status = FND_API.G_RET_STS_ERROR then
586: RAISE FND_API.G_EXC_ERROR;
587: ELSE
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 585: IF l_return_status = FND_API.G_RET_STS_ERROR then

581: oe_debug_pub.add('After inserting ',1);
582: END IF;
583:
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
585: IF l_return_status = FND_API.G_RET_STS_ERROR then
586: RAISE FND_API.G_EXC_ERROR;
587: ELSE
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;

Line 586: RAISE FND_API.G_EXC_ERROR;

582: END IF;
583:
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
585: IF l_return_status = FND_API.G_RET_STS_ERROR then
586: RAISE FND_API.G_EXC_ERROR;
587: ELSE
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590: END IF;

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
585: IF l_return_status = FND_API.G_RET_STS_ERROR then
586: RAISE FND_API.G_EXC_ERROR;
587: ELSE
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590: END IF;
591:
592: /* insert into oe_drop_ship_sources table */

Line 613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add('Inserted into Dropship Source Record', 1);
611: END IF;
612:
613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
614: IF l_return_status = FND_API.G_RET_STS_ERROR then
615: RAISE FND_API.G_EXC_ERROR;
616: ELSE
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 614: IF l_return_status = FND_API.G_RET_STS_ERROR then

610: oe_debug_pub.add('Inserted into Dropship Source Record', 1);
611: END IF;
612:
613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
614: IF l_return_status = FND_API.G_RET_STS_ERROR then
615: RAISE FND_API.G_EXC_ERROR;
616: ELSE
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;

Line 615: RAISE FND_API.G_EXC_ERROR;

611: END IF;
612:
613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
614: IF l_return_status = FND_API.G_RET_STS_ERROR then
615: RAISE FND_API.G_EXC_ERROR;
616: ELSE
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: END IF;

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
614: IF l_return_status = FND_API.G_RET_STS_ERROR then
615: RAISE FND_API.G_EXC_ERROR;
616: ELSE
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: END IF;
620: end if; --added for bug 7433481
621: END IF;

Line 623: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;

619: END IF;
620: end if; --added for bug 7433481
621: END IF;
622:
623: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
624: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_COMPLETE;
625:
626: EXCEPTION
627: WHEN Purchase_Release_Incomplete THEN

Line 632: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;

628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add('Exception Purchase Release Incomplete',1);
630: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);
631: END IF;
632: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
633: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
634: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
635: END IF;
636: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857

Line 637: WHEN FND_API.G_EXC_ERROR THEN

633: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
634: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
635: END IF;
636: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857
637: WHEN FND_API.G_EXC_ERROR THEN
638: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: -- Changes for Bug - 2352589
640: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
641: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;

Line 638: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
635: END IF;
636: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857
637: WHEN FND_API.G_EXC_ERROR THEN
638: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: -- Changes for Bug - 2352589
640: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
641: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
642: END IF;

Line 647: RAISE FND_API.G_EXC_ERROR; -- bug 4683857

643: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
644: IF l_debug_level > 0 THEN
645: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
646: END IF;
647: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: IF l_debug_level > 0 THEN

Line 648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

644: IF l_debug_level > 0 THEN
645: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
646: END IF;
647: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646: END IF;
647: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
648: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
649: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
653: END IF;
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
653: END IF;
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: WHEN OTHERS THEN
656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
657: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Purchase_Release');
658: END IF;

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: END IF;
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;
661: END IF;
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END;
664: <>
665: l_x_drop_ship_tbl(I) := l_drop_ship_line_rec;
666: l_old_header_id := l_drop_ship_line_rec.header_id;

Line 675: WHEN FND_API.G_EXC_ERROR THEN

671: END IF;
672:
673: EXCEPTION
674:
675: WHEN FND_API.G_EXC_ERROR THEN
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
678: END IF; --bug 5030428
679: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

Line 682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

678: END IF; --bug 5030428
679: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428
680: RAISE;
681:
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
685: END IF; --bug 5030428
686: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

Line 734: p_drop_ship_line_rec.project_id <> FND_API.G_MISS_NUM AND

730: oe_debug_pub.add( 'BEFORE INSERTING RECORDS INTO PO REQUISITIONS INTERFACE ' , 1 ) ;
731: END IF;
732:
733: IF p_drop_ship_line_rec.project_id is not null AND
734: p_drop_ship_line_rec.project_id <> FND_API.G_MISS_NUM AND
735: p_drop_ship_line_rec.project_id <> -1 THEN
736: l_project_accounting_context := 'Y';
737: ELSE
738: l_project_accounting_context := null;

Line 927: x_return_status := FND_API.G_RET_STS_SUCCESS;

923:
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add( 'END OF INSERT_INTO_PO_REQ_INTERFACE' , 1 ) ;
926: END IF;
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928:
929: EXCEPTION
930:
931: WHEN OTHERS THEN

Line 941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

937: , 'Insert_Into_Po_Req_Interface'
938: );
939: END IF;
940:
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942:
943: END Insert_Into_Po_Req_Interface;
944:
945: /*-----------------------------------------------------------------

Line 1001: x_return_status := FND_API.G_RET_STS_SUCCESS;

997: IF l_debug_level > 0 THEN
998: oe_debug_pub.add( 'END OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;
999: END IF;
1000:
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002:
1003: EXCEPTION
1004:
1005: WHEN OTHERS THEN

Line 1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1011: , 'Insert_Drop_Ship_Source'
1012: );
1013: END IF;
1014:
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: END Insert_Drop_Ship_Source;
1017:
1018: /*-----------------------------------------------------------------
1019: PROCEDURE : Associate_address

Line 1038: x_return_status := FND_API.G_RET_STS_ERROR;

1034: l_drop_ship_line_rec := p_drop_ship_line_rec;
1035:
1036: x_drop_ship_line_rec := l_drop_ship_line_rec;
1037: IF l_drop_ship_line_rec.deliver_to_location_id = -1 THEN
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1040: OE_MSG_PUB.Add;
1041: ELSE
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1042: x_return_status := FND_API.G_RET_STS_SUCCESS;

1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1040: OE_MSG_PUB.Add;
1041: ELSE
1042: x_return_status := FND_API.G_RET_STS_SUCCESS;
1043: END IF;
1044: END Associate_address;
1045:
1046: /*-----------------------------------------------------------------

Line 1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1176: , 'Get_Eligible_lines'
1177: );
1178: END IF;
1179:
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181:
1182: END Get_Eligible_lines;
1183:
1184: FUNCTION Get_Shipto_Location_Id

Line 1586: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1582: , p_mode => 'GET_STATUS'
1583: , x_po_status_rec => l_po_status_rec
1584: , x_return_status => l_return_status);
1585:
1586: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1587: l_autorization_status := l_po_status_rec.authorization_status(1);
1588:
1589: IF l_debug_level > 0 THEN
1590: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);

Line 1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1589: IF l_debug_level > 0 THEN
1590: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1591: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1592: END IF;
1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1590: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1591: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1592: END IF;
1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;
1598:

Line 1595: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1591: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1592: END IF;
1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;
1598:
1599: --IF (INSTR(nvl(l_po_status,'z'), 'APPROVED') <> 0 ) THEN

Line 1596: RAISE FND_API.G_EXC_ERROR;

1592: END IF;
1593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1596: RAISE FND_API.G_EXC_ERROR;
1597: END IF;
1598:
1599: --IF (INSTR(nvl(l_po_status,'z'), 'APPROVED') <> 0 ) THEN
1600: IF(nvl(l_autorization_status,'z')= 'APPROVED') THEN

Line 1680: RAISE FND_API.G_EXC_ERROR;

1676: ELSIF l_process_flag is NOT NULL THEN
1677: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_PROCESS');
1678: FND_MESSAGE.SET_TOKEN('LINE_NUM',l_line_num);
1679: OE_MSG_PUB.Add;
1680: RAISE FND_API.G_EXC_ERROR;
1681: END IF;
1682:
1683: END IF;
1684:

Line 1767: RAISE FND_API.G_EXC_ERROR;

1763: ELSIF l_process_flag is NOT NULL THEN
1764: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_PROCESS');
1765: FND_MESSAGE.SET_TOKEN('LINE_NUM',l_line_num);
1766: OE_MSG_PUB.Add;
1767: RAISE FND_API.G_EXC_ERROR;
1768: END IF;
1769:
1770: ELSE
1771: oe_debug_pub.add('assigning values to cancel records', 1);

Line 1826: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1822: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1823: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1824: END IF;
1825:
1826: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1827: OE_MSG_PUB.Transfer_Msg_Stack;
1828: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1825:
1826: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1827: OE_MSG_PUB.Transfer_Msg_Stack;
1828: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1831:
1832: OE_MSG_PUB.Transfer_Msg_Stack;
1833: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

Line 1830: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1826: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1827: OE_MSG_PUB.Transfer_Msg_Stack;
1828: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1831:
1832: OE_MSG_PUB.Transfer_Msg_Stack;
1833: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1834: FOR I in 1..l_msg_count LOOP

Line 1841: RAISE FND_API.G_EXC_ERROR;

1837: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;
1838: END IF;
1839: END LOOP;
1840:
1841: RAISE FND_API.G_EXC_ERROR;
1842: END IF;
1843:
1844: END IF;
1845:

Line 1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1882: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1883: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1884: END IF;
1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: OE_MSG_PUB.Transfer_Msg_Stack;
1888: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: OE_MSG_PUB.Transfer_Msg_Stack;
1888: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1891:
1892: OE_MSG_PUB.Transfer_Msg_Stack;
1893: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

Line 1890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: OE_MSG_PUB.Transfer_Msg_Stack;
1888: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1891:
1892: OE_MSG_PUB.Transfer_Msg_Stack;
1893: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1894: FOR I in 1..l_msg_count LOOP

Line 1909: RAISE FND_API.G_EXC_ERROR;

1905: -- bug 5358405
1906: FND_MESSAGE.set_name('ONT','OE_CANCEL_FAILED');
1907: OE_MSG_PUB.Add;
1908:
1909: RAISE FND_API.G_EXC_ERROR;
1910: END IF;
1911:
1912: END IF;
1913:

Line 1917: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1913:
1914:
1915: -- Error during updates, mark the requests as NOT processed
1916:
1917: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1918:
1919: I := p_request_tbl.FIRST;
1920: WHILE I IS NOT NULL LOOP
1921: IF p_request_tbl(I).request_type = 'DROPSHIP_CMS' THEN

Line 1935: WHEN FND_API.G_EXC_ERROR THEN

1931:
1932: x_return_status := l_return_status;
1933:
1934: EXCEPTION
1935: WHEN FND_API.G_EXC_ERROR THEN
1936: IF l_debug_level > 0 THEN
1937: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1938: END IF;
1939:

Line 1940: x_return_status := FND_API.G_RET_STS_ERROR;

1936: IF l_debug_level > 0 THEN
1937: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1938: END IF;
1939:
1940: x_return_status := FND_API.G_RET_STS_ERROR;
1941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1942: IF l_debug_level > 0 THEN
1943: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1944: END IF;

Line 1941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1937: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1938: END IF;
1939:
1940: x_return_status := FND_API.G_RET_STS_ERROR;
1941: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1942: IF l_debug_level > 0 THEN
1943: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1944: END IF;
1945:

Line 1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1942: IF l_debug_level > 0 THEN
1943: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1944: END IF;
1945:
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: WHEN OTHERS THEN
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949:
1950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1944: END IF;
1945:
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: WHEN OTHERS THEN
1948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1949:
1950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1951: THEN
1952: OE_MSG_PUB.Add_Exc_Msg