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_ORDER_BOOK_UTIL dependencies on OE_MSG_PUB

Line 47: OE_MSG_PUB.ADD;

43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'BOOKING IS DEFERRED' ) ;
45: END IF;
46: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_DEFERRED');
47: OE_MSG_PUB.ADD;
48: CLOSE book_deferred;
49: RETURN TRUE;
50: END IF;
51:

Line 236: OE_MSG_PUB.set_msg_context(

232:
233:
234: -- Header booking validation
235:
236: OE_MSG_PUB.set_msg_context(
237: p_entity_code => 'HEADER'
238: ,p_entity_id => l_header_rec.header_id
239: ,p_header_id => l_header_rec.header_id
240: ,p_line_id => null

Line 254: OE_MSG_PUB.reset_msg_context('HEADER');

250: (p_header_rec => l_header_rec
251: ,x_return_status => l_return_status
252: );
253:
254: OE_MSG_PUB.reset_msg_context('HEADER');
255:
256: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: -- if unexpected error, then do NOT validate lines.

Line 380: OE_MSG_PUB.set_msg_context(

376: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
377: l_line_tbl(l_index).last_update_date := SYSDATE;
378: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
379:
380: OE_MSG_PUB.set_msg_context(
381: p_entity_code => 'LINE'
382: ,p_entity_id => l_line_tbl(l_index).line_id
383: ,p_header_id => p_header_id
384: ,p_line_id => l_line_tbl(l_index).line_id

Line 400: OE_MSG_PUB.reset_msg_context('LINE');

396: ,p_old_line_rec => l_old_line_tbl(l_index)
397: ,x_return_status => l_return_status
398: );
399:
400: OE_MSG_PUB.reset_msg_context('LINE');
401:
402: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 842: OE_MSG_PUB.Add_Exc_Msg

838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.Check_Msg_Level
840: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
841: THEN
842: OE_MSG_PUB.Add_Exc_Msg
843: ( G_PKG_NAME
844: , 'Update_Booked_Flag'
845: );
846: END IF;

Line 884: OE_MSG_PUB.Add_Exc_Msg

880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: IF FND_MSG_PUB.Check_Msg_Level
882: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
886: , 'Verify_Payment_AT_Booking'
887: );
888: END IF;

Line 1000: OE_MSG_PUB.Add_Exc_Msg

996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_MSG_PUB.Check_Msg_Level
998: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
999: THEN
1000: OE_MSG_PUB.Add_Exc_Msg
1001: ( G_PKG_NAME
1002: , 'Validate_Sales_Credits'
1003: );
1004: END IF;

Line 1052: OE_MSG_PUB.ADD;

1048: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
1049: l_check_holds_result = FND_API.G_TRUE )
1050: THEN
1051: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
1052: OE_MSG_PUB.ADD;
1053: x_return_status := FND_API.G_RET_STS_ERROR;
1054: /* Changes for bug#2673236:Begin */
1055: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
1056: l_check_holds_result = FND_API.G_FALSE )

Line 1091: OE_MSG_PUB.ADD;

1087: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
1088: p_hold_rec.x_result_out = FND_API.G_TRUE )
1089: THEN
1090: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
1091: OE_MSG_PUB.ADD;
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: END IF;
1094: END IF;
1095: EXCEPTION

Line 1112: OE_MSG_PUB.Add_Exc_Msg

1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: IF FND_MSG_PUB.Check_Msg_Level
1110: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1111: THEN
1112: OE_MSG_PUB.Add_Exc_Msg
1113: ( G_PKG_NAME
1114: , 'Check_Booking_Holds'
1115: );
1116: END IF;

Line 1173: OE_MSG_PUB.initialize;

1169:
1170: -- Initialize message list.
1171:
1172: IF FND_API.to_Boolean(p_init_msg_list) THEN
1173: OE_MSG_PUB.initialize;
1174: END IF;
1175:
1176:
1177: -- Validate if revenue sales credits on the header and on each line

Line 1395: OE_MSG_PUB.Count_And_Get

1391: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';
1392: END IF;
1393: END IF; -- Bug 7367433
1394:
1395: OE_MSG_PUB.Count_And_Get
1396: ( p_count => x_msg_count
1397: , p_data => x_msg_data
1398: );
1399:

Line 1417: OE_MSG_PUB.Count_And_Get

1413: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1414: END IF;
1415: x_return_status := FND_API.G_RET_STS_ERROR;
1416: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1417: OE_MSG_PUB.Count_And_Get
1418: ( p_count => x_msg_count
1419: , p_data => x_msg_data
1420: );
1421: ROLLBACK TO BOOK_ORDER;

Line 1428: OE_MSG_PUB.Count_And_Get

1424: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' ,0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1425: END IF;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1428: OE_MSG_PUB.Count_And_Get
1429: ( p_count => x_msg_count
1430: , p_data => x_msg_data
1431: );
1432: ROLLBACK TO BOOK_ORDER;

Line 1442: OE_MSG_PUB.Add_Exc_Msg

1438: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1439: IF FND_MSG_PUB.Check_Msg_Level
1440: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: OE_MSG_PUB.Add_Exc_Msg
1443: ( G_PKG_NAME
1444: , l_api_name
1445: );
1446: END IF;

Line 1447: OE_MSG_PUB.Count_And_Get

1443: ( G_PKG_NAME
1444: , l_api_name
1445: );
1446: END IF;
1447: OE_MSG_PUB.Count_And_Get
1448: ( p_count => x_msg_count
1449: , p_data => x_msg_data
1450: );
1451: ROLLBACK TO BOOK_ORDER;

Line 1535: OE_MSG_PUB.initialize;

1531:
1532: -- Initialize message list.
1533:
1534: IF FND_API.to_Boolean(p_init_msg_list) THEN
1535: OE_MSG_PUB.initialize;
1536: END IF;
1537: -- modified the following query to fetch flow_status_code for 13536089
1538: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id,flow_status_code
1539: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id,l_flow_status_code

Line 1543: OE_MSG_PUB.set_msg_context(

1539: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id,l_flow_status_code
1540: FROM OE_ORDER_HEADERS_ALL
1541: WHERE HEADER_ID = p_header_id;
1542:
1543: OE_MSG_PUB.set_msg_context(
1544: p_entity_code => 'HEADER'
1545: ,p_entity_id => p_header_id
1546: ,p_header_id => p_header_id
1547: ,p_line_id => null

Line 1579: OE_MSG_PUB.Count_And_Get

1575:
1576: IF BookingIsDeferred(l_itemkey)
1577: THEN
1578:
1579: OE_MSG_PUB.Count_And_Get
1580: ( p_count => x_msg_count
1581: , p_data => x_msg_data
1582: );
1583: CLOSE book_eligible;

Line 1592: OE_MSG_PUB.ADD;

1588: FETCH booking_errored INTO l_booking_errored_flag;
1589: IF (booking_errored%FOUND)
1590: THEN
1591: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_ERRORED');
1592: OE_MSG_PUB.ADD;
1593: RAISE FND_API.G_EXC_ERROR;
1594: -- Else the order is NOT eligible for booking: raise an error.
1595: ELSE
1596: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_NOT_BOOK_ELIGIBLE');

Line 1597: OE_MSG_PUB.ADD;

1593: RAISE FND_API.G_EXC_ERROR;
1594: -- Else the order is NOT eligible for booking: raise an error.
1595: ELSE
1596: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_NOT_BOOK_ELIGIBLE');
1597: OE_MSG_PUB.ADD;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600: CLOSE booking_errored;
1601: END IF;

Line 1655: OE_MSG_PUB.set_msg_context(

1651: INTO l_booked_flag
1652: FROM OE_ORDER_HEADERS_ALL
1653: WHERE HEADER_ID = p_header_id;
1654:
1655: OE_MSG_PUB.set_msg_context(
1656: p_entity_code => 'HEADER'
1657: ,p_entity_id => p_header_id
1658: ,p_header_id => p_header_id
1659: ,p_line_id => null

Line 1673: OE_MSG_PUB.ADD;

1669:
1670: IF l_booked_flag = 'Y' THEN
1671:
1672: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOKED');
1673: OE_MSG_PUB.ADD;
1674:
1675: -- if order has NOT been booked, then check if booking has been deferred
1676:
1677: ELSE

Line 1725: OE_MSG_PUB.Count_And_Get

1721: END IF;
1722:
1723: END IF;
1724:
1725: OE_MSG_PUB.Count_And_Get
1726: ( p_count => x_msg_count
1727: , p_data => x_msg_data
1728: );
1729:

Line 1730: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

1726: ( p_count => x_msg_count
1727: , p_data => x_msg_data
1728: );
1729:
1730: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1731:
1732: IF l_debug_level > 0 THEN
1733: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1734: END IF;

Line 1742: OE_MSG_PUB.Count_And_Get

1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: IF (book_eligible%ISOPEN) THEN
1740: CLOSE book_eligible;
1741: END IF;
1742: OE_MSG_PUB.Count_And_Get
1743: ( p_count => x_msg_count
1744: , p_data => x_msg_data
1745: );
1746: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

Line 1746: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

1742: OE_MSG_PUB.Count_And_Get
1743: ( p_count => x_msg_count
1744: , p_data => x_msg_data
1745: );
1746: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1749: IF (book_eligible%ISOPEN) THEN
1750: CLOSE book_eligible;

Line 1752: OE_MSG_PUB.Count_And_Get

1748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1749: IF (book_eligible%ISOPEN) THEN
1750: CLOSE book_eligible;
1751: END IF;
1752: OE_MSG_PUB.Count_And_Get
1753: ( p_count => x_msg_count
1754: , p_data => x_msg_data
1755: );
1756: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

Line 1756: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

1752: OE_MSG_PUB.Count_And_Get
1753: ( p_count => x_msg_count
1754: , p_data => x_msg_data
1755: );
1756: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1757: WHEN OTHERS THEN
1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1759: IF (book_eligible%ISOPEN) THEN
1760: CLOSE book_eligible;

Line 1762: IF OE_MSG_PUB.Check_Msg_Level

1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1759: IF (book_eligible%ISOPEN) THEN
1760: CLOSE book_eligible;
1761: END IF;
1762: IF OE_MSG_PUB.Check_Msg_Level
1763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1764: THEN
1765: OE_MSG_PUB.Add_Exc_Msg
1766: ( G_PKG_NAME

Line 1763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1759: IF (book_eligible%ISOPEN) THEN
1760: CLOSE book_eligible;
1761: END IF;
1762: IF OE_MSG_PUB.Check_Msg_Level
1763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1764: THEN
1765: OE_MSG_PUB.Add_Exc_Msg
1766: ( G_PKG_NAME
1767: , l_api_name

Line 1765: OE_MSG_PUB.Add_Exc_Msg

1761: END IF;
1762: IF OE_MSG_PUB.Check_Msg_Level
1763: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1764: THEN
1765: OE_MSG_PUB.Add_Exc_Msg
1766: ( G_PKG_NAME
1767: , l_api_name
1768: );
1769: END IF;

Line 1770: OE_MSG_PUB.Count_And_Get

1766: ( G_PKG_NAME
1767: , l_api_name
1768: );
1769: END IF;
1770: OE_MSG_PUB.Count_And_Get
1771: ( p_count => x_msg_count
1772: , p_data => x_msg_data
1773: );
1774: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

Line 1774: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

1770: OE_MSG_PUB.Count_And_Get
1771: ( p_count => x_msg_count
1772: , p_data => x_msg_data
1773: );
1774: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1775:
1776: END Complete_Book_Eligible;
1777:
1778:

Line 1845: OE_MSG_PUB.initialize;

1841:
1842: -- Initialize message list.
1843:
1844: IF FND_API.to_Boolean(p_init_msg_list) THEN
1845: OE_MSG_PUB.initialize;
1846: END IF;
1847: initial := 1;
1848: FOR I IN 1..p_header_count LOOP
1849:

Line 1914: OE_MSG_PUB.Count_And_Get

1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: x_return_status := FND_API.G_RET_STS_ERROR;
1914: OE_MSG_PUB.Count_And_Get
1915: ( p_count => x_msg_count
1916: , p_data => x_msg_data
1917: );
1918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1920: OE_MSG_PUB.Count_And_Get

1916: , p_data => x_msg_data
1917: );
1918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1920: OE_MSG_PUB.Count_And_Get
1921: ( p_count => x_msg_count
1922: , p_data => x_msg_data
1923: );
1924: WHEN OTHERS THEN

Line 1926: IF OE_MSG_PUB.Check_Msg_Level

1922: , p_data => x_msg_data
1923: );
1924: WHEN OTHERS THEN
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: IF OE_MSG_PUB.Check_Msg_Level
1927: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: OE_MSG_PUB.Add_Exc_Msg
1930: ( G_PKG_NAME

Line 1927: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1923: );
1924: WHEN OTHERS THEN
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: IF OE_MSG_PUB.Check_Msg_Level
1927: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: OE_MSG_PUB.Add_Exc_Msg
1930: ( G_PKG_NAME
1931: , l_api_name

Line 1929: OE_MSG_PUB.Add_Exc_Msg

1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1926: IF OE_MSG_PUB.Check_Msg_Level
1927: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: OE_MSG_PUB.Add_Exc_Msg
1930: ( G_PKG_NAME
1931: , l_api_name
1932: );
1933: END IF;

Line 1934: OE_MSG_PUB.Count_And_Get

1930: ( G_PKG_NAME
1931: , l_api_name
1932: );
1933: END IF;
1934: OE_MSG_PUB.Count_And_Get
1935: ( p_count => x_msg_count
1936: , p_data => x_msg_data
1937: );
1938:

Line 2021: OE_MSG_PUB.initialize;

2017:
2018: -- Initialize message list.
2019:
2020: IF FND_API.to_Boolean(p_init_msg_list) THEN
2021: OE_MSG_PUB.initialize;
2022: END IF;
2023:
2024: --initialize PL/SQL tables
2025: l_header_id_tbl.DELETE;

Line 2157: OE_MSG_PUB.Count_And_Get

2153:
2154: EXCEPTION
2155: WHEN FND_API.G_EXC_ERROR THEN
2156: x_return_status := FND_API.G_RET_STS_ERROR;
2157: OE_MSG_PUB.Count_And_Get
2158: ( p_count => x_msg_count
2159: , p_data => x_msg_data
2160: );
2161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2163: OE_MSG_PUB.Count_And_Get

2159: , p_data => x_msg_data
2160: );
2161: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2163: OE_MSG_PUB.Count_And_Get
2164: ( p_count => x_msg_count
2165: , p_data => x_msg_data
2166: );
2167: WHEN OTHERS THEN

Line 2169: IF OE_MSG_PUB.Check_Msg_Level

2165: , p_data => x_msg_data
2166: );
2167: WHEN OTHERS THEN
2168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2169: IF OE_MSG_PUB.Check_Msg_Level
2170: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2171: THEN
2172: OE_MSG_PUB.Add_Exc_Msg
2173: ( G_PKG_NAME

Line 2170: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2166: );
2167: WHEN OTHERS THEN
2168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2169: IF OE_MSG_PUB.Check_Msg_Level
2170: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2171: THEN
2172: OE_MSG_PUB.Add_Exc_Msg
2173: ( G_PKG_NAME
2174: , l_api_name

Line 2172: OE_MSG_PUB.Add_Exc_Msg

2168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2169: IF OE_MSG_PUB.Check_Msg_Level
2170: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2171: THEN
2172: OE_MSG_PUB.Add_Exc_Msg
2173: ( G_PKG_NAME
2174: , l_api_name
2175: );
2176: END IF;

Line 2177: OE_MSG_PUB.Count_And_Get

2173: ( G_PKG_NAME
2174: , l_api_name
2175: );
2176: END IF;
2177: OE_MSG_PUB.Count_And_Get
2178: ( p_count => x_msg_count
2179: , p_data => x_msg_data
2180: );
2181: