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 229: OE_MSG_PUB.set_msg_context(

225:
226:
227: -- Header booking validation
228:
229: OE_MSG_PUB.set_msg_context(
230: p_entity_code => 'HEADER'
231: ,p_entity_id => l_header_rec.header_id
232: ,p_header_id => l_header_rec.header_id
233: ,p_line_id => null

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

243: (p_header_rec => l_header_rec
244: ,x_return_status => l_return_status
245: );
246:
247: OE_MSG_PUB.reset_msg_context('HEADER');
248:
249: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- if unexpected error, then do NOT validate lines.

Line 373: OE_MSG_PUB.set_msg_context(

369: l_line_tbl(l_index).last_update_login := FND_GLOBAL.LOGIN_ID;
370: l_line_tbl(l_index).last_update_date := SYSDATE;
371: l_line_tbl(l_index).lock_control := l_line_tbl(l_index).lock_control + 1;
372:
373: OE_MSG_PUB.set_msg_context(
374: p_entity_code => 'LINE'
375: ,p_entity_id => l_line_tbl(l_index).line_id
376: ,p_header_id => p_header_id
377: ,p_line_id => l_line_tbl(l_index).line_id

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

389: ,p_old_line_rec => l_old_line_tbl(l_index)
390: ,x_return_status => l_return_status
391: );
392:
393: OE_MSG_PUB.reset_msg_context('LINE');
394:
395: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 776: OE_MSG_PUB.Add_Exc_Msg

772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level
774: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: OE_MSG_PUB.Add_Exc_Msg
777: ( G_PKG_NAME
778: , 'Update_Booked_Flag'
779: );
780: END IF;

Line 818: OE_MSG_PUB.Add_Exc_Msg

814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
815: IF FND_MSG_PUB.Check_Msg_Level
816: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg
819: ( G_PKG_NAME
820: , 'Verify_Payment_AT_Booking'
821: );
822: END IF;

Line 934: OE_MSG_PUB.Add_Exc_Msg

930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: IF FND_MSG_PUB.Check_Msg_Level
932: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
933: THEN
934: OE_MSG_PUB.Add_Exc_Msg
935: ( G_PKG_NAME
936: , 'Validate_Sales_Credits'
937: );
938: END IF;

Line 986: OE_MSG_PUB.ADD;

982: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
983: l_check_holds_result = FND_API.G_TRUE )
984: THEN
985: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
986: OE_MSG_PUB.ADD;
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: /* Changes for bug#2673236:Begin */
989: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS AND
990: l_check_holds_result = FND_API.G_FALSE )

Line 1025: OE_MSG_PUB.ADD;

1021: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND
1022: p_hold_rec.x_result_out = FND_API.G_TRUE )
1023: THEN
1024: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
1025: OE_MSG_PUB.ADD;
1026: x_return_status := FND_API.G_RET_STS_ERROR;
1027: END IF;
1028: END IF;
1029: EXCEPTION

Line 1046: OE_MSG_PUB.Add_Exc_Msg

1042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1043: IF FND_MSG_PUB.Check_Msg_Level
1044: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg
1047: ( G_PKG_NAME
1048: , 'Check_Booking_Holds'
1049: );
1050: END IF;

Line 1107: OE_MSG_PUB.initialize;

1103:
1104: -- Initialize message list.
1105:
1106: IF FND_API.to_Boolean(p_init_msg_list) THEN
1107: OE_MSG_PUB.initialize;
1108: END IF;
1109:
1110:
1111: -- Validate if revenue sales credits on the header and on each line

Line 1313: OE_MSG_PUB.Count_And_Get

1309: OE_GLOBALS.G_PAYMENT_PROCESSED := 'O';
1310: END IF;
1311: END IF; -- Bug 7367433
1312:
1313: OE_MSG_PUB.Count_And_Get
1314: ( p_count => x_msg_count
1315: , p_data => x_msg_data
1316: );
1317:

Line 1335: OE_MSG_PUB.Count_And_Get

1331: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1335: OE_MSG_PUB.Count_And_Get
1336: ( p_count => x_msg_count
1337: , p_data => x_msg_data
1338: );
1339: ROLLBACK TO BOOK_ORDER;

Line 1346: OE_MSG_PUB.Count_And_Get

1342: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1343: END IF;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1346: OE_MSG_PUB.Count_And_Get
1347: ( p_count => x_msg_count
1348: , p_data => x_msg_data
1349: );
1350: ROLLBACK TO BOOK_ORDER;

Line 1360: OE_MSG_PUB.Add_Exc_Msg

1356: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1357: IF FND_MSG_PUB.Check_Msg_Level
1358: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1359: THEN
1360: OE_MSG_PUB.Add_Exc_Msg
1361: ( G_PKG_NAME
1362: , l_api_name
1363: );
1364: END IF;

Line 1365: OE_MSG_PUB.Count_And_Get

1361: ( G_PKG_NAME
1362: , l_api_name
1363: );
1364: END IF;
1365: OE_MSG_PUB.Count_And_Get
1366: ( p_count => x_msg_count
1367: , p_data => x_msg_data
1368: );
1369: ROLLBACK TO BOOK_ORDER;

Line 1449: OE_MSG_PUB.initialize;

1445:
1446: -- Initialize message list.
1447:
1448: IF FND_API.to_Boolean(p_init_msg_list) THEN
1449: OE_MSG_PUB.initialize;
1450: END IF;
1451:
1452: SELECT order_source_id, orig_sys_document_ref, change_sequence, source_document_type_id, source_document_id
1453: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id

Line 1457: OE_MSG_PUB.set_msg_context(

1453: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence, l_source_document_type_id, l_source_document_id
1454: FROM OE_ORDER_HEADERS_ALL
1455: WHERE HEADER_ID = p_header_id;
1456:
1457: OE_MSG_PUB.set_msg_context(
1458: p_entity_code => 'HEADER'
1459: ,p_entity_id => p_header_id
1460: ,p_header_id => p_header_id
1461: ,p_line_id => null

Line 1493: OE_MSG_PUB.Count_And_Get

1489:
1490: IF BookingIsDeferred(l_itemkey)
1491: THEN
1492:
1493: OE_MSG_PUB.Count_And_Get
1494: ( p_count => x_msg_count
1495: , p_data => x_msg_data
1496: );
1497: CLOSE book_eligible;

Line 1506: OE_MSG_PUB.ADD;

1502: FETCH booking_errored INTO l_booking_errored_flag;
1503: IF (booking_errored%FOUND)
1504: THEN
1505: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_ERRORED');
1506: OE_MSG_PUB.ADD;
1507: RAISE FND_API.G_EXC_ERROR;
1508: -- Else the order is NOT eligible for booking: raise an error.
1509: ELSE
1510: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_NOT_BOOK_ELIGIBLE');

Line 1511: OE_MSG_PUB.ADD;

1507: RAISE FND_API.G_EXC_ERROR;
1508: -- Else the order is NOT eligible for booking: raise an error.
1509: ELSE
1510: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_NOT_BOOK_ELIGIBLE');
1511: OE_MSG_PUB.ADD;
1512: RAISE FND_API.G_EXC_ERROR;
1513: END IF;
1514: CLOSE booking_errored;
1515: END IF;

Line 1562: OE_MSG_PUB.set_msg_context(

1558: INTO l_booked_flag
1559: FROM OE_ORDER_HEADERS_ALL
1560: WHERE HEADER_ID = p_header_id;
1561:
1562: OE_MSG_PUB.set_msg_context(
1563: p_entity_code => 'HEADER'
1564: ,p_entity_id => p_header_id
1565: ,p_header_id => p_header_id
1566: ,p_line_id => null

Line 1580: OE_MSG_PUB.ADD;

1576:
1577: IF l_booked_flag = 'Y' THEN
1578:
1579: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOKED');
1580: OE_MSG_PUB.ADD;
1581:
1582: -- if order has NOT been booked, then check if booking has been deferred
1583:
1584: ELSE

Line 1614: OE_MSG_PUB.Count_And_Get

1610: END IF;
1611:
1612: END IF;
1613:
1614: OE_MSG_PUB.Count_And_Get
1615: ( p_count => x_msg_count
1616: , p_data => x_msg_data
1617: );
1618:

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

1615: ( p_count => x_msg_count
1616: , p_data => x_msg_data
1617: );
1618:
1619: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1620:
1621: IF l_debug_level > 0 THEN
1622: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1623: END IF;

Line 1631: OE_MSG_PUB.Count_And_Get

1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: IF (book_eligible%ISOPEN) THEN
1629: CLOSE book_eligible;
1630: END IF;
1631: OE_MSG_PUB.Count_And_Get
1632: ( p_count => x_msg_count
1633: , p_data => x_msg_data
1634: );
1635: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

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

1631: OE_MSG_PUB.Count_And_Get
1632: ( p_count => x_msg_count
1633: , p_data => x_msg_data
1634: );
1635: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: IF (book_eligible%ISOPEN) THEN
1639: CLOSE book_eligible;

Line 1641: OE_MSG_PUB.Count_And_Get

1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: IF (book_eligible%ISOPEN) THEN
1639: CLOSE book_eligible;
1640: END IF;
1641: OE_MSG_PUB.Count_And_Get
1642: ( p_count => x_msg_count
1643: , p_data => x_msg_data
1644: );
1645: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

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

1641: OE_MSG_PUB.Count_And_Get
1642: ( p_count => x_msg_count
1643: , p_data => x_msg_data
1644: );
1645: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1646: WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF (book_eligible%ISOPEN) THEN
1649: CLOSE book_eligible;

Line 1651: IF OE_MSG_PUB.Check_Msg_Level

1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: IF (book_eligible%ISOPEN) THEN
1649: CLOSE book_eligible;
1650: END IF;
1651: IF OE_MSG_PUB.Check_Msg_Level
1652: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: OE_MSG_PUB.Add_Exc_Msg
1655: ( G_PKG_NAME

Line 1652: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1648: IF (book_eligible%ISOPEN) THEN
1649: CLOSE book_eligible;
1650: END IF;
1651: IF OE_MSG_PUB.Check_Msg_Level
1652: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: OE_MSG_PUB.Add_Exc_Msg
1655: ( G_PKG_NAME
1656: , l_api_name

Line 1654: OE_MSG_PUB.Add_Exc_Msg

1650: END IF;
1651: IF OE_MSG_PUB.Check_Msg_Level
1652: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1653: THEN
1654: OE_MSG_PUB.Add_Exc_Msg
1655: ( G_PKG_NAME
1656: , l_api_name
1657: );
1658: END IF;

Line 1659: OE_MSG_PUB.Count_And_Get

1655: ( G_PKG_NAME
1656: , l_api_name
1657: );
1658: END IF;
1659: OE_MSG_PUB.Count_And_Get
1660: ( p_count => x_msg_count
1661: , p_data => x_msg_data
1662: );
1663: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');

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

1659: OE_MSG_PUB.Count_And_Get
1660: ( p_count => x_msg_count
1661: , p_data => x_msg_data
1662: );
1663: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1664:
1665: END Complete_Book_Eligible;
1666:
1667:

Line 1734: OE_MSG_PUB.initialize;

1730:
1731: -- Initialize message list.
1732:
1733: IF FND_API.to_Boolean(p_init_msg_list) THEN
1734: OE_MSG_PUB.initialize;
1735: END IF;
1736: initial := 1;
1737: FOR I IN 1..p_header_count LOOP
1738:

Line 1803: OE_MSG_PUB.Count_And_Get

1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: OE_MSG_PUB.Count_And_Get
1804: ( p_count => x_msg_count
1805: , p_data => x_msg_data
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1809: OE_MSG_PUB.Count_And_Get

1805: , p_data => x_msg_data
1806: );
1807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: OE_MSG_PUB.Count_And_Get
1810: ( p_count => x_msg_count
1811: , p_data => x_msg_data
1812: );
1813: WHEN OTHERS THEN

Line 1815: IF OE_MSG_PUB.Check_Msg_Level

1811: , p_data => x_msg_data
1812: );
1813: WHEN OTHERS THEN
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF OE_MSG_PUB.Check_Msg_Level
1816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: OE_MSG_PUB.Add_Exc_Msg
1819: ( G_PKG_NAME

Line 1816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1812: );
1813: WHEN OTHERS THEN
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF OE_MSG_PUB.Check_Msg_Level
1816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: OE_MSG_PUB.Add_Exc_Msg
1819: ( G_PKG_NAME
1820: , l_api_name

Line 1818: OE_MSG_PUB.Add_Exc_Msg

1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: IF OE_MSG_PUB.Check_Msg_Level
1816: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: OE_MSG_PUB.Add_Exc_Msg
1819: ( G_PKG_NAME
1820: , l_api_name
1821: );
1822: END IF;

Line 1823: OE_MSG_PUB.Count_And_Get

1819: ( G_PKG_NAME
1820: , l_api_name
1821: );
1822: END IF;
1823: OE_MSG_PUB.Count_And_Get
1824: ( p_count => x_msg_count
1825: , p_data => x_msg_data
1826: );
1827:

Line 1910: OE_MSG_PUB.initialize;

1906:
1907: -- Initialize message list.
1908:
1909: IF FND_API.to_Boolean(p_init_msg_list) THEN
1910: OE_MSG_PUB.initialize;
1911: END IF;
1912:
1913: --initialize PL/SQL tables
1914: l_header_id_tbl.DELETE;

Line 2046: OE_MSG_PUB.Count_And_Get

2042:
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: OE_MSG_PUB.Count_And_Get
2047: ( p_count => x_msg_count
2048: , p_data => x_msg_data
2049: );
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2052: OE_MSG_PUB.Count_And_Get

2048: , p_data => x_msg_data
2049: );
2050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2052: OE_MSG_PUB.Count_And_Get
2053: ( p_count => x_msg_count
2054: , p_data => x_msg_data
2055: );
2056: WHEN OTHERS THEN

Line 2058: IF OE_MSG_PUB.Check_Msg_Level

2054: , p_data => x_msg_data
2055: );
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: IF OE_MSG_PUB.Check_Msg_Level
2059: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2060: THEN
2061: OE_MSG_PUB.Add_Exc_Msg
2062: ( G_PKG_NAME

Line 2059: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2055: );
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: IF OE_MSG_PUB.Check_Msg_Level
2059: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2060: THEN
2061: OE_MSG_PUB.Add_Exc_Msg
2062: ( G_PKG_NAME
2063: , l_api_name

Line 2061: OE_MSG_PUB.Add_Exc_Msg

2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: IF OE_MSG_PUB.Check_Msg_Level
2059: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2060: THEN
2061: OE_MSG_PUB.Add_Exc_Msg
2062: ( G_PKG_NAME
2063: , l_api_name
2064: );
2065: END IF;

Line 2066: OE_MSG_PUB.Count_And_Get

2062: ( G_PKG_NAME
2063: , l_api_name
2064: );
2065: END IF;
2066: OE_MSG_PUB.Count_And_Get
2067: ( p_count => x_msg_count
2068: , p_data => x_msg_data
2069: );
2070: