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 126: IF NOT FND_API.Compatible_API_Call

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

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 204: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 206: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 252: IF l_return_status = FND_API.G_RET_STS_ERROR then

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

Line 255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 273: ,p_init_msg_list => FND_API.G_FALSE

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

Line 274: ,p_commit => FND_API.G_FALSE

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

Line 275: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

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

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

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

Line 298: IF l_return_status = FND_API.G_RET_STS_ERROR then

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

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 317: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add('Wrong source type '|| l_drop_ship_line_rec.line_id,3);
472: END IF;
473: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
474: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
475: goto end_of_for_loop;
476: ELSE
477: SELECT shippable_flag
478: INTO l_shippable_flag

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

483: IF l_debug_level > 0 THEN
484: oe_debug_pub.add('Non shippable!! '|| l_drop_ship_line_rec.line_id,3);
485: END IF;
486: l_drop_ship_line_rec.result := G_RES_NOT_APPLICABLE;
487: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
488: goto end_of_for_loop;
489: END IF;
490:
491: --Fix for bug#2678070-Begin

Line 539: (p_validation_level => FND_API.G_VALID_LEVEL_NONE

535: oe_debug_pub.add('Now calling Process Order from OEXVDSPB',1);
536: END IF;
537:
538: OE_ORDER_PVT.Lines
539: (p_validation_level => FND_API.G_VALID_LEVEL_NONE
540: ,p_control_rec => l_control_rec
541: ,p_x_line_tbl => l_line_tbl
542: ,p_x_old_line_tbl => l_old_line_tbl
543: ,x_return_status => l_return_status);

Line 554: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

550: -- Bug# 4189838 Start
551: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
552: -- Bug# 4189838 End
553:
554: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
552: -- Bug# 4189838 End
553:
554: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:

Line 556: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

552: -- Bug# 4189838 End
553:
554: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: IF l_debug_level > 0 THEN

Line 557: RAISE FND_API.G_EXC_ERROR;

553:
554: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
557: RAISE FND_API.G_EXC_ERROR;
558: END IF;
559:
560: IF l_debug_level > 0 THEN
561: OE_DEBUG_PUB.add('Calling Process Request and Notify',1);

Line 571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

567: ,x_return_status => l_return_status
568: ,p_line_tbl => l_line_tbl
569: ,p_old_line_tbl => l_old_line_tbl);
570:
571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;

Line 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568: ,p_line_tbl => l_line_tbl
569: ,p_old_line_tbl => l_old_line_tbl);
570:
571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:

Line 573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

569: ,p_old_line_tbl => l_old_line_tbl);
570:
571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: END IF; /* If schedule_ship_date is null */

Line 574: RAISE FND_API.G_EXC_ERROR;

570:
571: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;
576:
577: END IF; /* If schedule_ship_date is null */
578: --Fix for bug#2678070-End

Line 619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

615: IF l_debug_level > 0 THEN
616: oe_debug_pub.add('After inserting ',1);
617: END IF;
618:
619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
620: IF l_return_status = FND_API.G_RET_STS_ERROR then
621: RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 620: IF l_return_status = FND_API.G_RET_STS_ERROR then

616: oe_debug_pub.add('After inserting ',1);
617: END IF;
618:
619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
620: IF l_return_status = FND_API.G_RET_STS_ERROR then
621: RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: END IF;

Line 621: RAISE FND_API.G_EXC_ERROR;

617: END IF;
618:
619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
620: IF l_return_status = FND_API.G_RET_STS_ERROR then
621: RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: END IF;
625: END IF;

Line 623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
620: IF l_return_status = FND_API.G_RET_STS_ERROR then
621: RAISE FND_API.G_EXC_ERROR;
622: ELSE
623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
624: END IF;
625: END IF;
626:
627: /* insert into oe_drop_ship_sources table */

Line 648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

644: IF l_debug_level > 0 THEN
645: oe_debug_pub.add('Inserted into Dropship Source Record', 1);
646: END IF;
647:
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
649: IF l_return_status = FND_API.G_RET_STS_ERROR then
650: RAISE FND_API.G_EXC_ERROR;
651: ELSE
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 649: IF l_return_status = FND_API.G_RET_STS_ERROR then

645: oe_debug_pub.add('Inserted into Dropship Source Record', 1);
646: END IF;
647:
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
649: IF l_return_status = FND_API.G_RET_STS_ERROR then
650: RAISE FND_API.G_EXC_ERROR;
651: ELSE
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;

Line 650: RAISE FND_API.G_EXC_ERROR;

646: END IF;
647:
648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
649: IF l_return_status = FND_API.G_RET_STS_ERROR then
650: RAISE FND_API.G_EXC_ERROR;
651: ELSE
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: END IF;

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
649: IF l_return_status = FND_API.G_RET_STS_ERROR then
650: RAISE FND_API.G_EXC_ERROR;
651: ELSE
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: END IF;
655: end if; --added for bug 7433481
656: END IF;

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

654: END IF;
655: end if; --added for bug 7433481
656: END IF;
657:
658: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
659: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_COMPLETE;
660:
661: EXCEPTION
662: WHEN Purchase_Release_Incomplete THEN

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

663: IF l_debug_level > 0 THEN
664: oe_debug_pub.add('Exception Purchase Release Incomplete',1);
665: oe_debug_pub.add('Purchase Release activity is incomplete for line ID : '||l_drop_ship_line_rec.line_id,1);
666: END IF;
667: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_ERROR;
668: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
669: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
670: END IF;
671: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
669: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
670: END IF;
671: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857
672: WHEN FND_API.G_EXC_ERROR THEN
673: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: -- Changes for Bug - 2352589
675: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
676: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;

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

669: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
670: END IF;
671: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857
672: WHEN FND_API.G_EXC_ERROR THEN
673: l_drop_ship_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: -- Changes for Bug - 2352589
675: IF l_drop_ship_line_rec.result <> OE_Purchase_Release_PVT.G_RES_ONHOLD THEN
676: l_drop_ship_line_rec.result := OE_Purchase_Release_PVT.G_RES_INCOMPLETE;
677: END IF;

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

678: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
681: END IF;
682: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF l_debug_level > 0 THEN

Line 683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

679: IF l_debug_level > 0 THEN
680: oe_debug_pub.add('AN EXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
681: END IF;
682: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

681: END IF;
682: RAISE FND_API.G_EXC_ERROR; -- bug 4683857
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
688: END IF;
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add('AN UNEXPECTED ERROR RAISED..'||SQLERRM , 1 ) ;
688: END IF;
689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
690: WHEN OTHERS THEN
691: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
692: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Purchase_Release');
693: END IF;

Line 697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

693: END IF;
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;
696: END IF;
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: END;
699: <>
700: l_x_drop_ship_tbl(I) := l_drop_ship_line_rec;
701: l_old_header_id := l_drop_ship_line_rec.header_id;

Line 710: WHEN FND_API.G_EXC_ERROR THEN

706: END IF;
707:
708: EXCEPTION
709:
710: WHEN FND_API.G_EXC_ERROR THEN
711: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
713: END IF; --bug 5030428
714: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

Line 717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

713: END IF; --bug 5030428
714: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428
715: RAISE;
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
719: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
720: END IF; --bug 5030428
721: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

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

765: oe_debug_pub.add( 'BEFORE INSERTING RECORDS INTO PO REQUISITIONS INTERFACE ' , 1 ) ;
766: END IF;
767:
768: IF p_drop_ship_line_rec.project_id is not null AND
769: p_drop_ship_line_rec.project_id <> FND_API.G_MISS_NUM AND
770: p_drop_ship_line_rec.project_id <> -1 THEN
771: l_project_accounting_context := 'Y';
772: ELSE
773: l_project_accounting_context := null;

Line 962: x_return_status := FND_API.G_RET_STS_SUCCESS;

958:
959: IF l_debug_level > 0 THEN
960: oe_debug_pub.add( 'END OF INSERT_INTO_PO_REQ_INTERFACE' , 1 ) ;
961: END IF;
962: x_return_status := FND_API.G_RET_STS_SUCCESS;
963:
964: EXCEPTION
965:
966: WHEN OTHERS THEN

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

972: , 'Insert_Into_Po_Req_Interface'
973: );
974: END IF;
975:
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
977:
978: END Insert_Into_Po_Req_Interface;
979:
980: /*-----------------------------------------------------------------

Line 1036: x_return_status := FND_API.G_RET_STS_SUCCESS;

1032: IF l_debug_level > 0 THEN
1033: oe_debug_pub.add( 'END OF INSERT_DROP_SHIP_SOURCE' , 1 ) ;
1034: END IF;
1035:
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037:
1038: EXCEPTION
1039:
1040: WHEN OTHERS THEN

Line 1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1046: , 'Insert_Drop_Ship_Source'
1047: );
1048: END IF;
1049:
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: END Insert_Drop_Ship_Source;
1052:
1053: /*-----------------------------------------------------------------
1054: PROCEDURE : Associate_address

Line 1073: x_return_status := FND_API.G_RET_STS_ERROR;

1069: l_drop_ship_line_rec := p_drop_ship_line_rec;
1070:
1071: x_drop_ship_line_rec := l_drop_ship_line_rec;
1072: IF l_drop_ship_line_rec.deliver_to_location_id = -1 THEN
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1075: OE_MSG_PUB.Add;
1076: ELSE
1077: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1077: x_return_status := FND_API.G_RET_STS_SUCCESS;

1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: FND_MESSAGE.SET_NAME('ONT','OE_DS_NO_LOC_LINK');
1075: OE_MSG_PUB.Add;
1076: ELSE
1077: x_return_status := FND_API.G_RET_STS_SUCCESS;
1078: END IF;
1079: END Associate_address;
1080:
1081: /*-----------------------------------------------------------------

Line 1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1211: , 'Get_Eligible_lines'
1212: );
1213: END IF;
1214:
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216:
1217: END Get_Eligible_lines;
1218:
1219: FUNCTION Get_Shipto_Location_Id

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

1617: , p_mode => 'GET_STATUS'
1618: , x_po_status_rec => l_po_status_rec
1619: , x_return_status => l_return_status);
1620:
1621: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1622: l_autorization_status := l_po_status_rec.authorization_status(1);
1623:
1624: IF l_debug_level > 0 THEN
1625: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);

Line 1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1624: IF l_debug_level > 0 THEN
1625: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1626: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1627: END IF;
1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;

Line 1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1625: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
1626: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1627: END IF;
1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633:

Line 1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1626: OE_DEBUG_PUB.Add('Check PO Status : '|| l_autorization_status, 2);
1627: END IF;
1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633:
1634: --IF (INSTR(nvl(l_po_status,'z'), 'APPROVED') <> 0 ) THEN

Line 1631: RAISE FND_API.G_EXC_ERROR;

1627: END IF;
1628: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633:
1634: --IF (INSTR(nvl(l_po_status,'z'), 'APPROVED') <> 0 ) THEN
1635: IF(nvl(l_autorization_status,'z')= 'APPROVED') THEN

Line 1715: RAISE FND_API.G_EXC_ERROR;

1711: ELSIF l_process_flag is NOT NULL THEN
1712: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_PROCESS');
1713: FND_MESSAGE.SET_TOKEN('LINE_NUM',l_line_num);
1714: OE_MSG_PUB.Add;
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:
1718: END IF;
1719:

Line 1802: RAISE FND_API.G_EXC_ERROR;

1798: ELSIF l_process_flag is NOT NULL THEN
1799: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_PROCESS');
1800: FND_MESSAGE.SET_TOKEN('LINE_NUM',l_line_num);
1801: OE_MSG_PUB.Add;
1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF;
1804:
1805: ELSE
1806: oe_debug_pub.add('assigning values to cancel records', 1);

Line 1861: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1857: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1858: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1859: END IF;
1860:
1861: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1862: OE_MSG_PUB.Transfer_Msg_Stack;
1863: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1860:
1861: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1862: OE_MSG_PUB.Transfer_Msg_Stack;
1863: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1866:
1867: OE_MSG_PUB.Transfer_Msg_Stack;
1868: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

Line 1865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1861: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1862: OE_MSG_PUB.Transfer_Msg_Stack;
1863: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1866:
1867: OE_MSG_PUB.Transfer_Msg_Stack;
1868: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1869: FOR I in 1..l_msg_count LOOP

Line 1876: RAISE FND_API.G_EXC_ERROR;

1872: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;
1873: END IF;
1874: END LOOP;
1875:
1876: RAISE FND_API.G_EXC_ERROR;
1877: END IF;
1878:
1879: END IF;
1880:

Line 1921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1917: OE_DEBUG_PUB.Add(' Message Count:'||l_msg_count,2) ;
1918: OE_DEBUG_PUB.Add(' Message Data:'||l_msg_data,2) ;
1919: END IF;
1920:
1921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: OE_MSG_PUB.Transfer_Msg_Stack;
1923: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1920:
1921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: OE_MSG_PUB.Transfer_Msg_Stack;
1923: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1926:
1927: OE_MSG_PUB.Transfer_Msg_Stack;
1928: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

Line 1925: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: OE_MSG_PUB.Transfer_Msg_Stack;
1923: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1925: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1926:
1927: OE_MSG_PUB.Transfer_Msg_Stack;
1928: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1929: FOR I in 1..l_msg_count LOOP

Line 1944: RAISE FND_API.G_EXC_ERROR;

1940: -- bug 5358405
1941: FND_MESSAGE.set_name('ONT','OE_CANCEL_FAILED');
1942: OE_MSG_PUB.Add;
1943:
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946:
1947: END IF;
1948:

Line 1952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1948:
1949:
1950: -- Error during updates, mark the requests as NOT processed
1951:
1952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1953:
1954: I := p_request_tbl.FIRST;
1955: WHILE I IS NOT NULL LOOP
1956: IF p_request_tbl(I).request_type = 'DROPSHIP_CMS' THEN

Line 1970: WHEN FND_API.G_EXC_ERROR THEN

1966:
1967: x_return_status := l_return_status;
1968:
1969: EXCEPTION
1970: WHEN FND_API.G_EXC_ERROR THEN
1971: IF l_debug_level > 0 THEN
1972: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1973: END IF;
1974:

Line 1975: x_return_status := FND_API.G_RET_STS_ERROR;

1971: IF l_debug_level > 0 THEN
1972: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1973: END IF;
1974:
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1977: IF l_debug_level > 0 THEN
1978: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1979: END IF;

Line 1976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1972: OE_DEBUG_PUB.Add('Expected Error in Process_DropShip_CMS_Requests...',4);
1973: END IF;
1974:
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1977: IF l_debug_level > 0 THEN
1978: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1979: END IF;
1980:

Line 1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1977: IF l_debug_level > 0 THEN
1978: OE_DEBUG_PUB.Add('UnExpected Error in Process_DropShip_CMS_Requests...'||sqlerrm,4);
1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: WHEN OTHERS THEN
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984:
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1979: END IF;
1980:
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: WHEN OTHERS THEN
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984:
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1986: THEN
1987: OE_MSG_PUB.Add_Exc_Msg