DBA Data[Home] [Help]

APPS.QP_SEG_UTIL dependencies on OE_MSG_PUB

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

1193: EXCEPTION
1194:
1195: WHEN OTHERS THEN
1196:
1197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: OE_MSG_PUB.Add_Exc_Msg
1200: ( G_PKG_NAME
1201: , 'Update_Row'

Line 1199: OE_MSG_PUB.Add_Exc_Msg

1195: WHEN OTHERS THEN
1196:
1197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1198: THEN
1199: OE_MSG_PUB.Add_Exc_Msg
1200: ( G_PKG_NAME
1201: , 'Update_Row'
1202: );
1203: END IF;

Line 1243: OE_MSG_PUB.Add;

1239:
1240: --l_return_status := FND_API.G_RET_STS_ERROR;
1241: FND_MESSAGE.SET_NAME('QP','QP_ATTR_EXISTS_IN_FF');
1242: --FND_MESSAGE.SET_TOKEN('PTE_CODE', l_pte_code);
1243: OE_MSG_PUB.Add;
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: exception
1246: when no_data_found then
1247: null;

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

1413: EXCEPTION
1414:
1415: WHEN OTHERS THEN
1416:
1417: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1418: THEN
1419: OE_MSG_PUB.Add_Exc_Msg
1420: ( G_PKG_NAME
1421: , 'Insert_Row'

Line 1419: OE_MSG_PUB.Add_Exc_Msg

1415: WHEN OTHERS THEN
1416:
1417: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1418: THEN
1419: OE_MSG_PUB.Add_Exc_Msg
1420: ( G_PKG_NAME
1421: , 'Insert_Row'
1422: );
1423: END IF;

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

1474: EXCEPTION
1475:
1476: WHEN OTHERS THEN
1477:
1478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1479: THEN
1480: OE_MSG_PUB.Add_Exc_Msg
1481: ( G_PKG_NAME
1482: , 'Delete_Row'

Line 1480: OE_MSG_PUB.Add_Exc_Msg

1476: WHEN OTHERS THEN
1477:
1478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1479: THEN
1480: OE_MSG_PUB.Add_Exc_Msg
1481: ( G_PKG_NAME
1482: , 'Delete_Row'
1483: );
1484: END IF;

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

1575: (p_prc_context_id IS NOT NULL
1576: AND
1577: p_prc_context_id <> FND_API.G_MISS_NUM)
1578: THEN
1579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1580: THEN
1581: OE_MSG_PUB.Add_Exc_Msg
1582: ( G_PKG_NAME
1583: , 'Query Rows'

Line 1581: OE_MSG_PUB.Add_Exc_Msg

1577: p_prc_context_id <> FND_API.G_MISS_NUM)
1578: THEN
1579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1580: THEN
1581: OE_MSG_PUB.Add_Exc_Msg
1582: ( G_PKG_NAME
1583: , 'Query Rows'
1584: , 'Keys are mutually exclusive: segment_id = '|| p_segment_id || ', prc_context_id = '|| p_prc_context_id
1585: );

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

1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:
1669: WHEN OTHERS THEN
1670:
1671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: OE_MSG_PUB.Add_Exc_Msg
1674: ( G_PKG_NAME
1675: , 'Query_Rows'

Line 1673: OE_MSG_PUB.Add_Exc_Msg

1669: WHEN OTHERS THEN
1670:
1671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1672: THEN
1673: OE_MSG_PUB.Add_Exc_Msg
1674: ( G_PKG_NAME
1675: , 'Query_Rows'
1676: );
1677: END IF;

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

1888:
1889: x_return_status := FND_API.G_RET_STS_ERROR;
1890: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1891:
1892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1893: THEN
1894:
1895: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED_abhi6');
1896: OE_MSG_PUB.Add;

Line 1896: OE_MSG_PUB.Add;

1892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1893: THEN
1894:
1895: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED_abhi6');
1896: OE_MSG_PUB.Add;
1897:
1898: END IF;
1899:
1900: END IF;

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

1905:
1906: x_return_status := FND_API.G_RET_STS_ERROR;
1907: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1908:
1909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN
1911:
1912: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1913: OE_MSG_PUB.Add;

Line 1913: OE_MSG_PUB.Add;

1909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN
1911:
1912: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1913: OE_MSG_PUB.Add;
1914:
1915: END IF;
1916: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1917:

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

1917:
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1922: THEN
1923:
1924: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1925: OE_MSG_PUB.Add;

Line 1925: OE_MSG_PUB.Add;

1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1922: THEN
1923:
1924: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1925: OE_MSG_PUB.Add;
1926:
1927: END IF;
1928: WHEN OTHERS THEN
1929:

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

1929:
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1931: x_SEG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932:
1933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1934: THEN
1935: OE_MSG_PUB.Add_Exc_Msg
1936: ( G_PKG_NAME
1937: , 'Lock_Row'

Line 1935: OE_MSG_PUB.Add_Exc_Msg

1931: x_SEG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932:
1933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1934: THEN
1935: OE_MSG_PUB.Add_Exc_Msg
1936: ( G_PKG_NAME
1937: , 'Lock_Row'
1938: );
1939: END IF;

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

2029: IF p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM THEN
2030:
2031: l_SEG_rec.prc_context_id := p_SEG_rec.prc_context_id;
2032:
2033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2034: THEN
2035:
2036: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');

Line 2038: OE_MSG_PUB.Add;

2034: THEN
2035:
2036: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2037: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prc_context');
2038: OE_MSG_PUB.Add;
2039:
2040: END IF;
2041:
2042: ELSE

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

2059: IF p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
2060:
2061: l_SEG_rec.seeded_flag := p_SEG_rec.seeded_flag;
2062:
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2064: THEN
2065:
2066: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');

Line 2068: OE_MSG_PUB.Add;

2064: THEN
2065:
2066: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');
2068: OE_MSG_PUB.Add;
2069:
2070: END IF;
2071:
2072: ELSE

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

2089: IF p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM THEN
2090:
2091: l_SEG_rec.seeded_valueset_id := p_SEG_rec.seeded_valueset_id;
2092:
2093: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2094: THEN
2095:
2096: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2097: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset');

Line 2098: OE_MSG_PUB.Add;

2094: THEN
2095:
2096: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2097: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded_valueset');
2098: OE_MSG_PUB.Add;
2099:
2100: END IF;
2101:
2102: ELSE

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

2119: IF p_SEG_rec.segment_id <> FND_API.G_MISS_NUM THEN
2120:
2121: l_SEG_rec.segment_id := p_SEG_rec.segment_id;
2122:
2123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2124: THEN
2125:
2126: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');

Line 2128: OE_MSG_PUB.Add;

2124: THEN
2125:
2126: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2127: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');
2128: OE_MSG_PUB.Add;
2129:
2130: END IF;
2131:
2132: ELSE

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

2149: IF p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM THEN
2150:
2151: l_SEG_rec.user_valueset_id := p_SEG_rec.user_valueset_id;
2152:
2153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2154: THEN
2155:
2156: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset');

Line 2158: OE_MSG_PUB.Add;

2154: THEN
2155:
2156: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2157: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','user_valueset');
2158: OE_MSG_PUB.Add;
2159:
2160: END IF;
2161:
2162: ELSE