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

Line 1155: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1151: EXCEPTION
1152:
1153: WHEN OTHERS THEN
1154:
1155: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: oe_msg_pub.Add_Exc_Msg
1158: ( G_PKG_NAME
1159: , 'Update_Row'

Line 1157: oe_msg_pub.Add_Exc_Msg

1153: WHEN OTHERS THEN
1154:
1155: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: oe_msg_pub.Add_Exc_Msg
1158: ( G_PKG_NAME
1159: , 'Update_Row'
1160: );
1161: END IF;

Line 1305: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1301: EXCEPTION
1302:
1303: WHEN OTHERS THEN
1304:
1305: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1306: THEN
1307: oe_msg_pub.Add_Exc_Msg
1308: ( G_PKG_NAME
1309: , 'Insert_Row'

Line 1307: oe_msg_pub.Add_Exc_Msg

1303: WHEN OTHERS THEN
1304:
1305: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1306: THEN
1307: oe_msg_pub.Add_Exc_Msg
1308: ( G_PKG_NAME
1309: , 'Insert_Row'
1310: );
1311: END IF;

Line 1461: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1457: EXCEPTION
1458:
1459: WHEN OTHERS THEN
1460:
1461: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1462: THEN
1463: oe_msg_pub.Add_Exc_Msg
1464: ( G_PKG_NAME
1465: , 'Delete_Row'

Line 1463: oe_msg_pub.Add_Exc_Msg

1459: WHEN OTHERS THEN
1460:
1461: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1462: THEN
1463: oe_msg_pub.Add_Exc_Msg
1464: ( G_PKG_NAME
1465: , 'Delete_Row'
1466: );
1467: END IF;

Line 1603: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1599: (p_header_id IS NOT NULL
1600: AND
1601: p_header_id <> FND_API.G_MISS_NUM)
1602: THEN
1603: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1604: THEN
1605: oe_msg_pub.Add_Exc_Msg
1606: ( G_PKG_NAME
1607: , 'Query Rows'

Line 1605: oe_msg_pub.Add_Exc_Msg

1601: p_header_id <> FND_API.G_MISS_NUM)
1602: THEN
1603: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1604: THEN
1605: oe_msg_pub.Add_Exc_Msg
1606: ( G_PKG_NAME
1607: , 'Query Rows'
1608: , 'Keys are mutually exclusive: sales_credit_id = '|| p_sales_credit_id || ', header_id = '|| p_header_id
1609: );

Line 1705: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702:
1703: WHEN OTHERS THEN
1704:
1705: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1706: THEN
1707: oe_msg_pub.Add_Exc_Msg
1708: ( G_PKG_NAME
1709: , 'Query_Rows'

Line 1707: oe_msg_pub.Add_Exc_Msg

1703: WHEN OTHERS THEN
1704:
1705: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1706: THEN
1707: oe_msg_pub.Add_Exc_Msg
1708: ( G_PKG_NAME
1709: , 'Query_Rows'
1710: );
1711: END IF;

Line 1802: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1798:
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1801:
1802: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1803: THEN
1804:
1805: -- Release the lock
1806: ROLLBACK TO Lock_Row;

Line 1809: oe_msg_pub.Add;

1805: -- Release the lock
1806: ROLLBACK TO Lock_Row;
1807:
1808: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_CHANGED');
1809: oe_msg_pub.Add;
1810:
1811: END IF;
1812:
1813: END IF;

Line 1822: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1818:
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1821:
1822: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1823: THEN
1824:
1825: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
1826: oe_msg_pub.Add;

Line 1826: oe_msg_pub.Add;

1822: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1823: THEN
1824:
1825: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
1826: oe_msg_pub.Add;
1827:
1828: END IF;
1829: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1830:

Line 1834: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1830:
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
1833:
1834: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1835: THEN
1836:
1837: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1838: oe_msg_pub.Add;

Line 1838: oe_msg_pub.Add;

1834: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1835: THEN
1836:
1837: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1838: oe_msg_pub.Add;
1839:
1840: END IF;
1841: WHEN OTHERS THEN
1842:

Line 1846: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1842:
1843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845:
1846: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1847: THEN
1848: oe_msg_pub.Add_Exc_Msg
1849: ( G_PKG_NAME
1850: , 'Lock_Row'

Line 1848: oe_msg_pub.Add_Exc_Msg

1844: p_x_Header_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845:
1846: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1847: THEN
1848: oe_msg_pub.Add_Exc_Msg
1849: ( G_PKG_NAME
1850: , 'Lock_Row'
1851: );
1852: END IF;

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

1882: p_sales_credit_id <> FND_API.G_MISS_NUM) AND
1883: (p_header_id IS NOT NULL AND
1884: p_header_id <> FND_API.G_MISS_NUM)
1885: THEN
1886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1887: THEN
1888: OE_MSG_PUB.Add_Exc_Msg
1889: ( G_PKG_NAME
1890: , 'Lock Rows'

Line 1888: OE_MSG_PUB.Add_Exc_Msg

1884: p_header_id <> FND_API.G_MISS_NUM)
1885: THEN
1886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1887: THEN
1888: OE_MSG_PUB.Add_Exc_Msg
1889: ( G_PKG_NAME
1890: , 'Lock Rows'
1891: , 'Keys are mutually exclusive: sales_credit_id = '||
1892: p_sales_credit_id || ', header_id = '|| p_header_id );

Line 1958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1954: WHEN NO_DATA_FOUND THEN
1955:
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957:
1958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1959: THEN
1960: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
1961: OE_MSG_PUB.Add;
1962: END IF;

Line 1961: OE_MSG_PUB.Add;

1957:
1958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1959: THEN
1960: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
1961: OE_MSG_PUB.Add;
1962: END IF;
1963:
1964: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1965:

Line 1967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1963:
1964: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1965:
1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1968: THEN
1969: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1970: OE_MSG_PUB.Add;
1971: END IF;

Line 1970: OE_MSG_PUB.Add;

1966: x_return_status := FND_API.G_RET_STS_ERROR;
1967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1968: THEN
1969: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
1970: OE_MSG_PUB.Add;
1971: END IF;
1972:
1973: WHEN OTHERS THEN
1974:

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

1973: WHEN OTHERS THEN
1974:
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976:
1977: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1978: THEN
1979: OE_MSG_PUB.Add_Exc_Msg
1980: ( G_PKG_NAME
1981: , 'Lock_Rows'

Line 1979: OE_MSG_PUB.Add_Exc_Msg

1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1976:
1977: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1978: THEN
1979: OE_MSG_PUB.Add_Exc_Msg
1980: ( G_PKG_NAME
1981: , 'Lock_Rows'
1982: );
1983: END IF;

Line 2075: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2071: IF p_x_Header_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2072:
2073:
2074:
2075: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2076: THEN
2077:
2078: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2079: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 2080: oe_msg_pub.Add;

2076: THEN
2077:
2078: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2079: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2080: oe_msg_pub.Add;
2081:
2082: END IF;
2083:
2084: ELSE

Line 2104: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

2100:
2101: IF p_x_Header_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2102:
2103:
2104: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2105: THEN
2106:
2107: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');

Line 2109: oe_msg_pub.Add;

2105: THEN
2106:
2107: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2109: oe_msg_pub.Add;
2110:
2111: END IF;
2112:
2113: ELSE

Line 2195: oe_msg_pub.add;

2191: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
2192: END IF;
2193: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
2194: fnd_message.set_token('OBJECT','ORDER SALES CREDIT');
2195: oe_msg_pub.add;
2196: raise FND_API.G_EXC_ERROR;
2197: END IF;
2198: END IF;
2199: END IF;

Line 2359: OE_MSG_PUB.Add;

2355: -- Commented to fix bug 1589196 Begin
2356: /* IF l_sales_credits_count > 1 THEN
2357:
2358: fnd_message.set_name('ONT','OE_TOO_MANY_HSCREDIT');
2359: OE_MSG_PUB.Add;
2360: RAISE FND_API.G_EXC_ERROR;
2361:
2362: ELSIF l_sales_credits_count = 1 THEN */
2363: -- update with new salesrep

Line 2489: OE_MSG_PUB.Add;

2485: */
2486:
2487: IF l_sales_credits_count = 1 THEN -- issue message update with new salesrep
2488: fnd_message.set_name('ONT','OE_OE_UPDATED_ORDER_CREDIT');
2489: OE_MSG_PUB.Add;
2490: END IF;
2491:
2492: IF l_debug_level > 0 THEN
2493: oe_debug_pub.add( 'EXITING OE_HEADER_SCREDIT_UTIL.DFLT_HSCREDIT_PRIMARY_SREP' , 1 ) ;

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

2506: WHEN OTHERS THEN
2507:
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509:
2510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2511: THEN
2512: OE_MSG_PUB.Add_Exc_Msg
2513: ( G_PKG_NAME
2514: , 'DFLT_Hscredit_Primary_Srep'

Line 2512: OE_MSG_PUB.Add_Exc_Msg

2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509:
2510: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2511: THEN
2512: OE_MSG_PUB.Add_Exc_Msg
2513: ( G_PKG_NAME
2514: , 'DFLT_Hscredit_Primary_Srep'
2515: );
2516: END IF;