DBA Data[Home] [Help]

APPS.QP_LIMITS_UTIL dependencies on OE_MSG_PUB

Line 1289: OE_MSG_PUB.Add_Exc_Msg

1285: ,null
1286: ,p_LIMITS_rec.limit_id
1287: ,null);
1288: IF x_retcode = 2 THEN
1289: OE_MSG_PUB.Add_Exc_Msg
1290: ( G_PKG_NAME
1291: , 'UPDATE_BALANCES'
1292: );
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1300:
1301: WHEN OTHERS THEN
1302:
1303:
1304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1305: THEN
1306: OE_MSG_PUB.Add_Exc_Msg
1307: ( G_PKG_NAME
1308: , 'Update_Row'

Line 1306: OE_MSG_PUB.Add_Exc_Msg

1302:
1303:
1304: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1305: THEN
1306: OE_MSG_PUB.Add_Exc_Msg
1307: ( G_PKG_NAME
1308: , 'Update_Row'
1309: );
1310: END IF;

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

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

Line 1463: OE_MSG_PUB.Add_Exc_Msg

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

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

1495: EXCEPTION
1496:
1497: WHEN OTHERS THEN
1498:
1499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1500: THEN
1501: OE_MSG_PUB.Add_Exc_Msg
1502: ( G_PKG_NAME
1503: , 'Delete_Row'

Line 1501: OE_MSG_PUB.Add_Exc_Msg

1497: WHEN OTHERS THEN
1498:
1499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1500: THEN
1501: OE_MSG_PUB.Add_Exc_Msg
1502: ( G_PKG_NAME
1503: , 'Delete_Row'
1504: );
1505: END IF;

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

1615: RETURN l_LIMITS_rec;
1616:
1617: WHEN OTHERS THEN
1618:
1619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: OE_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME
1623: , 'Query_Row'

Line 1621: OE_MSG_PUB.Add_Exc_Msg

1617: WHEN OTHERS THEN
1618:
1619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1620: THEN
1621: OE_MSG_PUB.Add_Exc_Msg
1622: ( G_PKG_NAME
1623: , 'Query_Row'
1624: );
1625: END IF;

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

1835:
1836: x_return_status := FND_API.G_RET_STS_ERROR;
1837: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1838:
1839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1840: THEN
1841:
1842: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1843: OE_MSG_PUB.Add;

Line 1843: OE_MSG_PUB.Add;

1839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1840: THEN
1841:
1842: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1843: OE_MSG_PUB.Add;
1844:
1845: END IF;
1846:
1847: END IF;

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

1852:
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1857: THEN
1858:
1859: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1860: OE_MSG_PUB.Add;

Line 1860: OE_MSG_PUB.Add;

1856: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1857: THEN
1858:
1859: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1860: OE_MSG_PUB.Add;
1861:
1862: END IF;
1863: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1864:

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

1864:
1865: x_return_status := FND_API.G_RET_STS_ERROR;
1866: x_LIMITS_rec.return_status := FND_API.G_RET_STS_ERROR;
1867:
1868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1869: THEN
1870:
1871: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1872: OE_MSG_PUB.Add;

Line 1872: OE_MSG_PUB.Add;

1868: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1869: THEN
1870:
1871: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1872: OE_MSG_PUB.Add;
1873:
1874: END IF;
1875: WHEN OTHERS THEN
1876:

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

1876:
1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1878: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879:
1880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1881: THEN
1882: OE_MSG_PUB.Add_Exc_Msg
1883: ( G_PKG_NAME
1884: , 'Lock_Row'

Line 1882: OE_MSG_PUB.Add_Exc_Msg

1878: x_LIMITS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1879:
1880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1881: THEN
1882: OE_MSG_PUB.Add_Exc_Msg
1883: ( G_PKG_NAME
1884: , 'Lock_Row'
1885: );
1886: END IF;

Line 1992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

1988: IF p_LIMITS_rec.limit_exceed_action_code <> FND_API.G_MISS_CHAR THEN
1989:
1990: l_LIMITS_rec.limit_exceed_action_code := p_LIMITS_rec.limit_exceed_action_code;
1991:
1992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1993: THEN
1994:
1995: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');

Line 1997: OE_MSG_PUB.Add;

1993: THEN
1994:
1995: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1996: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_exceed_action');
1997: OE_MSG_PUB.Add;
1998:
1999: END IF;
2000:
2001: ELSE

Line 2022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2018: IF p_LIMITS_rec.limit_id <> FND_API.G_MISS_NUM THEN
2019:
2020: l_LIMITS_rec.limit_id := p_LIMITS_rec.limit_id;
2021:
2022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2023: THEN
2024:
2025: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');

Line 2027: OE_MSG_PUB.Add;

2023: THEN
2024:
2025: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit');
2027: OE_MSG_PUB.Add;
2028:
2029: END IF;
2030:
2031: ELSE

Line 2052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2048: IF p_LIMITS_rec.limit_level_code <> FND_API.G_MISS_CHAR THEN
2049:
2050: l_LIMITS_rec.limit_level_code := p_LIMITS_rec.limit_level_code;
2051:
2052: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2053: THEN
2054:
2055: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');

Line 2057: OE_MSG_PUB.Add;

2053: THEN
2054:
2055: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','limit_level');
2057: OE_MSG_PUB.Add;
2058:
2059: END IF;
2060:
2061: ELSE

Line 2082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2078: IF p_LIMITS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2079:
2080: l_LIMITS_rec.list_header_id := p_LIMITS_rec.list_header_id;
2081:
2082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2083: THEN
2084:
2085: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 2087: OE_MSG_PUB.Add;

2083: THEN
2084:
2085: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2087: OE_MSG_PUB.Add;
2088:
2089: END IF;
2090:
2091: ELSE

Line 2112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2108: IF p_LIMITS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2109:
2110: l_LIMITS_rec.list_line_id := p_LIMITS_rec.list_line_id;
2111:
2112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2113: THEN
2114:
2115: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 2117: OE_MSG_PUB.Add;

2113: THEN
2114:
2115: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2117: OE_MSG_PUB.Add;
2118:
2119: END IF;
2120:
2121: ELSE

Line 2142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2138: IF p_LIMITS_rec.organization_flag <> FND_API.G_MISS_CHAR THEN
2139:
2140: l_LIMITS_rec.organization_flag := p_LIMITS_rec.organization_flag;
2141:
2142: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2143: THEN
2144:
2145: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 2147: OE_MSG_PUB.Add;

2143: THEN
2144:
2145: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
2147: OE_MSG_PUB.Add;
2148:
2149: END IF;
2150:
2151: ELSE

Line 2202: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2198: RAISE;
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200: RAISE;
2201: WHEN OTHERS THEN
2202: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2203: THEN
2204: oe_msg_pub.Add_Exc_Msg
2205: ( G_PKG_NAME
2206: , 'Pre_Write_Process'

Line 2204: oe_msg_pub.Add_Exc_Msg

2200: RAISE;
2201: WHEN OTHERS THEN
2202: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2203: THEN
2204: oe_msg_pub.Add_Exc_Msg
2205: ( G_PKG_NAME
2206: , 'Pre_Write_Process'
2207: );
2208: END IF;