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 OE_MSG_PUB

Line 248: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857

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
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

Line 249: OE_MSG_PUB.Save_API_Messages; --bug4683857

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
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;

Line 294: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);--bug4683857

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
297: RAISE Purchase_Release_Incomplete;
298: ELSE

Line 295: OE_MSG_PUB.Save_API_Messages; --bug4683857

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
297: RAISE Purchase_Release_Incomplete;
298: ELSE
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 305: OE_MSG_PUB.Add;

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;
308: RAISE Purchase_Release_Incomplete;
309: END IF;

Line 314: OE_MSG_PUB.Add;

310: END IF;/* If line is not a service line */
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;

Line 385: OE_MSG_PUB.Add;

381: IF l_debug_level > 0 THEN
382: oe_debug_pub.add('No records found for this employee id',1);
383: END IF;
384: FND_MESSAGE.SET_NAME('ONT','OE_DS_NOT_VALID_EMP');
385: OE_MSG_PUB.Add;
386: RAISE Purchase_Release_Incomplete;
387: END IF;
388:
389: -- Fix for the bug2097383 and 2201362

Line 402: OE_MSG_PUB.Add;

398: END IF;
399:
400: IF nvl(item_purchase_enabled,'N') <> 'Y' THEN
401: FND_MESSAGE.SET_NAME('PO','PO_RI_INVALID_ITEM_SRC_VEND_P');
402: OE_MSG_PUB.Add;
403: IF l_debug_level > 0 THEN
404: OE_DEBUG_PUB.add('Exception, item is not purchasing enabled',1);
405: END IF;
406: RAISE Purchase_Release_Incomplete;

Line 420: OE_MSG_PUB.Add;

416:
417: if v_request_date is null then
418: -- raise error, request date cannot be null #2003381.
419: FND_MESSAGE.SET_NAME('ONT','OE_REQUEST_DATE_FOR_PR_REQD');
420: OE_MSG_PUB.Add;
421: IF l_debug_level > 0 THEN
422: OE_DEBUG_PUB.add('Exception, Reqeust Date is either null or not valid',1);
423: END IF;
424: RAISE Purchase_Release_Incomplete;

Line 636: --OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release'); bug 4683857

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
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

Line 643: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');

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;
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

Line 649: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'Purchase_Release');

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 ) ;
653: END IF;

Line 656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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;
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;

Line 657: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Purchase_Release');

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;
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add('OTHER ERROR RAISED..'||SQLERRM , 1 ) ;
661: END IF;

Line 676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
680: RAISE;

Line 677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');

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
680: RAISE;
681:

Line 679: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

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
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

Line 683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
687: RAISE;

Line 684: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');

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
687: RAISE;
688:

Line 686: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

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
687: RAISE;
688:
689: WHEN OTHERS THEN
690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

686: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428
687: RAISE;
688:
689: WHEN OTHERS THEN
690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
691: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
692: END IF;
693: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428
694: END Purchase_Release;

Line 691: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');

687: RAISE;
688:
689: WHEN OTHERS THEN
690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
691: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
692: END IF;
693: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428
694: END Purchase_Release;
695:

Line 693: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428

689: WHEN OTHERS THEN
690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
691: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Purchase_Release');
692: END IF;
693: --OE_MSG_PUB.reset_msg_context('Purchase_Release'); 5030428
694: END Purchase_Release;
695:
696: /*-----------------------------------------------------------------
697: PROCEDURE : Insert_Into_Po_Req_Interface

Line 933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

929: EXCEPTION
930:
931: WHEN OTHERS THEN
932:
933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: OE_MSG_PUB.Add_Exc_Msg
936: ( G_PKG_NAME
937: , 'Insert_Into_Po_Req_Interface'

Line 935: OE_MSG_PUB.Add_Exc_Msg

931: WHEN OTHERS THEN
932:
933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: OE_MSG_PUB.Add_Exc_Msg
936: ( G_PKG_NAME
937: , 'Insert_Into_Po_Req_Interface'
938: );
939: END IF;

Line 1007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1003: EXCEPTION
1004:
1005: WHEN OTHERS THEN
1006:
1007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1008: THEN
1009: OE_MSG_PUB.Add_Exc_Msg
1010: ( G_PKG_NAME
1011: , 'Insert_Drop_Ship_Source'

Line 1009: OE_MSG_PUB.Add_Exc_Msg

1005: WHEN OTHERS THEN
1006:
1007: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1008: THEN
1009: OE_MSG_PUB.Add_Exc_Msg
1010: ( G_PKG_NAME
1011: , 'Insert_Drop_Ship_Source'
1012: );
1013: END IF;

Line 1040: OE_MSG_PUB.Add;

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;
1043: END IF;
1044: END Associate_address;

Line 1172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1168: EXCEPTION
1169:
1170: WHEN OTHERS THEN
1171:
1172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1173: THEN
1174: OE_MSG_PUB.Add_Exc_Msg
1175: ( G_PKG_NAME
1176: , 'Get_Eligible_lines'

Line 1174: OE_MSG_PUB.Add_Exc_Msg

1170: WHEN OTHERS THEN
1171:
1172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1173: THEN
1174: OE_MSG_PUB.Add_Exc_Msg
1175: ( G_PKG_NAME
1176: , 'Get_Eligible_lines'
1177: );
1178: END IF;

Line 1675: OE_MSG_PUB.Add;

1671:
1672: ELSIF l_process_flag = 'ERROR' THEN
1673: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');
1674: FND_MESSAGE.SET_TOKEN('LINE_NUM',l_line_num);
1675: OE_MSG_PUB.Add;
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;

Line 1679: OE_MSG_PUB.Add;

1675: OE_MSG_PUB.Add;
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;

Line 1762: OE_MSG_PUB.Add;

1758:
1759: ELSIF l_process_flag = 'ERROR' THEN
1760: FND_MESSAGE.SET_NAME('ONT','ONT_DS_LINE_IN_ERROR');
1761: FND_MESSAGE.SET_TOKEN('LINE_NUM',l_line_num);
1762: OE_MSG_PUB.Add;
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;

Line 1766: OE_MSG_PUB.Add;

1762: OE_MSG_PUB.Add;
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

Line 1827: OE_MSG_PUB.Transfer_Msg_Stack;

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
1831:

Line 1828: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

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
1831:
1832: OE_MSG_PUB.Transfer_Msg_Stack;

Line 1832: 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
1835: l_msg_data := OE_MSG_PUB.Get(I,'F');
1836: IF l_debug_level > 0 THEN

Line 1833: 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
1835: l_msg_data := OE_MSG_PUB.Get(I,'F');
1836: IF l_debug_level > 0 THEN
1837: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;

Line 1835: l_msg_data := OE_MSG_PUB.Get(I,'F');

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
1835: l_msg_data := OE_MSG_PUB.Get(I,'F');
1836: IF l_debug_level > 0 THEN
1837: oe_debug_pub.add('Messages from Update PO;'||l_msg_data,1 ) ;
1838: END IF;
1839: END LOOP;

Line 1887: OE_MSG_PUB.Transfer_Msg_Stack;

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
1891:

Line 1888: l_msg_count:=OE_MSG_PUB.COUNT_MSG;

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
1891:
1892: OE_MSG_PUB.Transfer_Msg_Stack;

Line 1892: 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
1895: l_msg_data := OE_MSG_PUB.Get(I,'F');
1896: IF l_debug_level > 0 THEN

Line 1893: 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
1895: l_msg_data := OE_MSG_PUB.Get(I,'F');
1896: IF l_debug_level > 0 THEN
1897: oe_debug_pub.add('Messages from Cancel PO;'||l_msg_data,1 ) ;

Line 1895: l_msg_data := OE_MSG_PUB.Get(I,'F');

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
1895: l_msg_data := OE_MSG_PUB.Get(I,'F');
1896: IF l_debug_level > 0 THEN
1897: oe_debug_pub.add('Messages from Cancel PO;'||l_msg_data,1 ) ;
1898: END IF;
1899: END LOOP;

Line 1907: OE_MSG_PUB.Add;

1903: END IF;
1904:
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:

Line 1950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1953: (G_PKG_NAME
1954: ,'Process_DropShip_CMS_Requests'

Line 1952: OE_MSG_PUB.Add_Exc_Msg

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
1953: (G_PKG_NAME
1954: ,'Process_DropShip_CMS_Requests'
1955: );
1956: END IF;