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

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

1279: EXCEPTION
1280:
1281: WHEN OTHERS THEN
1282:
1283: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1284: THEN
1285: oe_msg_pub.Add_Exc_Msg
1286: ( G_PKG_NAME
1287: , 'Update_Row'

Line 1285: oe_msg_pub.Add_Exc_Msg

1281: WHEN OTHERS THEN
1282:
1283: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1284: THEN
1285: oe_msg_pub.Add_Exc_Msg
1286: ( G_PKG_NAME
1287: , 'Update_Row'
1288: );
1289: END IF;

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

1438: EXCEPTION
1439:
1440: WHEN OTHERS THEN
1441:
1442: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1443: THEN
1444: oe_msg_pub.Add_Exc_Msg
1445: ( G_PKG_NAME
1446: , 'Insert_Row'

Line 1444: oe_msg_pub.Add_Exc_Msg

1440: WHEN OTHERS THEN
1441:
1442: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1443: THEN
1444: oe_msg_pub.Add_Exc_Msg
1445: ( G_PKG_NAME
1446: , 'Insert_Row'
1447: );
1448: END IF;

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

1644: EXCEPTION
1645:
1646: WHEN OTHERS THEN
1647:
1648: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1649: THEN
1650: oe_msg_pub.Add_Exc_Msg
1651: ( G_PKG_NAME
1652: , 'Delete_Row'

Line 1650: oe_msg_pub.Add_Exc_Msg

1646: WHEN OTHERS THEN
1647:
1648: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1649: THEN
1650: oe_msg_pub.Add_Exc_Msg
1651: ( G_PKG_NAME
1652: , 'Delete_Row'
1653: );
1654: END IF;

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

1828: (p_line_id IS NOT NULL
1829: AND
1830: p_line_id <> FND_API.G_MISS_NUM)
1831: THEN
1832: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: oe_msg_pub.Add_Exc_Msg
1835: ( G_PKG_NAME
1836: , 'Query Rows'

Line 1834: oe_msg_pub.Add_Exc_Msg

1830: p_line_id <> FND_API.G_MISS_NUM)
1831: THEN
1832: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: oe_msg_pub.Add_Exc_Msg
1835: ( G_PKG_NAME
1836: , 'Query Rows'
1837: , 'Keys are mutually exclusive: sales_credit_id = '|| p_sales_credit_id || ', line_id = '|| p_line_id
1838: );

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

1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945:
1946: WHEN OTHERS THEN
1947:
1948: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1949: THEN
1950: oe_msg_pub.Add_Exc_Msg
1951: ( G_PKG_NAME
1952: , 'Query_Rows'

Line 1950: oe_msg_pub.Add_Exc_Msg

1946: WHEN OTHERS THEN
1947:
1948: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1949: THEN
1950: oe_msg_pub.Add_Exc_Msg
1951: ( G_PKG_NAME
1952: , 'Query_Rows'
1953: );
1954: END IF;

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

2036:
2037: x_return_status := FND_API.G_RET_STS_ERROR;
2038: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2039:
2040: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2041: THEN
2042:
2043: -- Release the lock
2044: ROLLBACK TO Lock_Row;

Line 2047: oe_msg_pub.Add;

2043: -- Release the lock
2044: ROLLBACK TO Lock_Row;
2045:
2046: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_CHANGED');
2047: oe_msg_pub.Add;
2048:
2049: END IF;
2050:
2051: END IF;

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

2060:
2061: x_return_status := FND_API.G_RET_STS_ERROR;
2062: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2063:
2064: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2065: THEN
2066:
2067: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
2068: oe_msg_pub.Add;

Line 2068: oe_msg_pub.Add;

2064: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2065: THEN
2066:
2067: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
2068: oe_msg_pub.Add;
2069:
2070: END IF;
2071: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2072:

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

2072:
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_ERROR;
2075:
2076: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2077: THEN
2078:
2079: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2080: oe_msg_pub.Add;

Line 2080: oe_msg_pub.Add;

2076: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2077: THEN
2078:
2079: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2080: oe_msg_pub.Add;
2081:
2082: END IF;
2083: WHEN OTHERS THEN
2084:

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

2084:
2085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2086: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2087:
2088: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2089: THEN
2090: oe_msg_pub.Add_Exc_Msg
2091: ( G_PKG_NAME
2092: , 'Lock_Row'

Line 2090: oe_msg_pub.Add_Exc_Msg

2086: p_x_Line_Scredit_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2087:
2088: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2089: THEN
2090: oe_msg_pub.Add_Exc_Msg
2091: ( G_PKG_NAME
2092: , 'Lock_Row'
2093: );
2094: END IF;

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

2125: p_sales_credit_id <> FND_API.G_MISS_NUM) AND
2126: (p_line_id IS NOT NULL AND
2127: p_line_id <> FND_API.G_MISS_NUM)
2128: THEN
2129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2130: THEN
2131: OE_MSG_PUB.Add_Exc_Msg
2132: ( G_PKG_NAME
2133: , 'Lock Rows'

Line 2131: OE_MSG_PUB.Add_Exc_Msg

2127: p_line_id <> FND_API.G_MISS_NUM)
2128: THEN
2129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2130: THEN
2131: OE_MSG_PUB.Add_Exc_Msg
2132: ( G_PKG_NAME
2133: , 'Lock Rows'
2134: , 'Keys are mutually exclusive: sales_credit_id = '||
2135: p_sales_credit_id || ', line_id = '|| p_line_id );

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

2197: WHEN NO_DATA_FOUND THEN
2198:
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200:
2201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2202: THEN
2203: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
2204: OE_MSG_PUB.Add;
2205: END IF;

Line 2204: OE_MSG_PUB.Add;

2200:
2201: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2202: THEN
2203: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
2204: OE_MSG_PUB.Add;
2205: END IF;
2206:
2207: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2208:

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

2206:
2207: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2208:
2209: x_return_status := FND_API.G_RET_STS_ERROR;
2210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2211: THEN
2212: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2213: OE_MSG_PUB.Add;
2214: END IF;

Line 2213: OE_MSG_PUB.Add;

2209: x_return_status := FND_API.G_RET_STS_ERROR;
2210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2211: THEN
2212: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2213: OE_MSG_PUB.Add;
2214: END IF;
2215:
2216: WHEN OTHERS THEN
2217:

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

2216: WHEN OTHERS THEN
2217:
2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219:
2220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2221: THEN
2222: OE_MSG_PUB.Add_Exc_Msg
2223: ( G_PKG_NAME
2224: , 'Lock_Rows'

Line 2222: OE_MSG_PUB.Add_Exc_Msg

2218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2219:
2220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2221: THEN
2222: OE_MSG_PUB.Add_Exc_Msg
2223: ( G_PKG_NAME
2224: , 'Lock_Rows'
2225: );
2226: END IF;

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

2298: THEN
2299:
2300: IF p_x_Line_Scredit_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2301:
2302: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2303: THEN
2304:
2305: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 2307: oe_msg_pub.Add;

2303: THEN
2304:
2305: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2307: oe_msg_pub.Add;
2308:
2309: END IF;
2310:
2311: ELSE

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

2326: THEN
2327:
2328: IF p_x_Line_Scredit_rec.sales_credit_type_id <> FND_API.G_MISS_NUM THEN
2329:
2330: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2331: THEN
2332:
2333: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');

Line 2335: oe_msg_pub.Add;

2331: THEN
2332:
2333: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_credit_type');
2335: oe_msg_pub.Add;
2336:
2337: END IF;
2338:
2339: ELSE

Line 2479: OE_MSG_PUB.Add;

2475:
2476: if l_sales_credits_count > 1 then
2477:
2478: fnd_message.set_name('ONT','OE_TOO_MANY_LSCREDIT');
2479: OE_MSG_PUB.Add;
2480: RAISE FND_API.G_EXC_ERROR;
2481:
2482: elsif l_sales_credits_count = 1 then -- update with new salesrep
2483:

Line 2642: OE_MSG_PUB.Add;

2638: -- jolin end
2639:
2640: if l_sales_credits_count = 1 then -- issue message update with new salesrep
2641: fnd_message.set_name('ONT','OE_OE_UPDATED_LINE_CREDIT');
2642: OE_MSG_PUB.Add;
2643: end if;
2644:
2645: END IF; -- if l_create_flag or l_update_flag
2646:

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

2651:
2652: EXCEPTION
2653:
2654: WHEN OTHERS THEN
2655: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2656: THEN
2657: OE_MSG_PUB.Add_Exc_Msg
2658: ( G_PKG_NAME ,
2659: 'Create_Credits'

Line 2657: OE_MSG_PUB.Add_Exc_Msg

2653:
2654: WHEN OTHERS THEN
2655: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2656: THEN
2657: OE_MSG_PUB.Add_Exc_Msg
2658: ( G_PKG_NAME ,
2659: 'Create_Credits'
2660: );
2661: END IF;

Line 2730: oe_msg_pub.add;

2726: oe_debug_pub.add( 'Reason code for change is missing or invalid ' , 1 ) ;
2727: END IF;
2728: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
2729: fnd_message.set_token('OBJECT','LINE SALES CREDIT');
2730: oe_msg_pub.add;
2731: raise FND_API.G_EXC_ERROR;
2732: END IF;
2733: END IF;
2734: END IF;