DBA Data[Home] [Help]

APPS.OE_PRICE_BREAK_UTIL dependencies on OE_MSG_PUB

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

827: EXCEPTION
828:
829: WHEN OTHERS THEN
830:
831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: OE_MSG_PUB.Add_Exc_Msg
834: ( G_PKG_NAME
835: , 'Update_Row'

Line 833: OE_MSG_PUB.Add_Exc_Msg

829: WHEN OTHERS THEN
830:
831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
832: THEN
833: OE_MSG_PUB.Add_Exc_Msg
834: ( G_PKG_NAME
835: , 'Update_Row'
836: );
837: END IF;

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

926: EXCEPTION
927:
928: WHEN OTHERS THEN
929:
930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: OE_MSG_PUB.Add_Exc_Msg
933: ( G_PKG_NAME
934: , 'Insert_Row'

Line 932: OE_MSG_PUB.Add_Exc_Msg

928: WHEN OTHERS THEN
929:
930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: OE_MSG_PUB.Add_Exc_Msg
933: ( G_PKG_NAME
934: , 'Insert_Row'
935: );
936: END IF;

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

960: EXCEPTION
961:
962: WHEN OTHERS THEN
963:
964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: OE_MSG_PUB.Add_Exc_Msg
967: ( G_PKG_NAME
968: , 'Delete_Row'

Line 966: OE_MSG_PUB.Add_Exc_Msg

962: WHEN OTHERS THEN
963:
964: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: OE_MSG_PUB.Add_Exc_Msg
967: ( G_PKG_NAME
968: , 'Delete_Row'
969: );
970: END IF;

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

1074: (p_price_break_low IS NOT NULL
1075: AND
1076: p_price_break_low <> FND_API.G_MISS_NUM)
1077: THEN
1078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: OE_MSG_PUB.Add_Exc_Msg
1081: ( G_PKG_NAME
1082: , 'Query Rows'

Line 1080: OE_MSG_PUB.Add_Exc_Msg

1076: p_price_break_low <> FND_API.G_MISS_NUM)
1077: THEN
1078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: OE_MSG_PUB.Add_Exc_Msg
1081: ( G_PKG_NAME
1082: , 'Query Rows'
1083: , 'Keys are mutually exclusive: discount_line_id = '||
1084: p_discount_line_id ||

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

1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176:
1177: WHEN OTHERS THEN
1178:
1179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1180: THEN
1181: OE_MSG_PUB.Add_Exc_Msg
1182: ( G_PKG_NAME
1183: , 'Query_Rows'

Line 1181: OE_MSG_PUB.Add_Exc_Msg

1177: WHEN OTHERS THEN
1178:
1179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1180: THEN
1181: OE_MSG_PUB.Add_Exc_Msg
1182: ( G_PKG_NAME
1183: , 'Query_Rows'
1184: );
1185: END IF;

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

1471:
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1474:
1475: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1476: THEN
1477:
1478: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
1479: OE_MSG_PUB.Add;

Line 1479: OE_MSG_PUB.Add;

1475: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1476: THEN
1477:
1478: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
1479: OE_MSG_PUB.Add;
1480:
1481: END IF;
1482:
1483: END IF;

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

1488:
1489: x_return_status := FND_API.G_RET_STS_ERROR;
1490: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1493: THEN
1494:
1495: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1496: OE_MSG_PUB.Add;

Line 1496: OE_MSG_PUB.Add;

1492: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1493: THEN
1494:
1495: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
1496: OE_MSG_PUB.Add;
1497:
1498: END IF;
1499: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1500:

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

1500:
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: x_Price_Break_rec.return_status := FND_API.G_RET_STS_ERROR;
1503:
1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506:
1507: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1508: OE_MSG_PUB.Add;

Line 1508: OE_MSG_PUB.Add;

1504: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1505: THEN
1506:
1507: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
1508: OE_MSG_PUB.Add;
1509:
1510: END IF;
1511: WHEN OTHERS THEN
1512:

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

1512:
1513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1514: x_Price_Break_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1517: THEN
1518: OE_MSG_PUB.Add_Exc_Msg
1519: ( G_PKG_NAME
1520: , 'Lock_Row'

Line 1518: OE_MSG_PUB.Add_Exc_Msg

1514: x_Price_Break_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1517: THEN
1518: OE_MSG_PUB.Add_Exc_Msg
1519: ( G_PKG_NAME
1520: , 'Lock_Row'
1521: );
1522: END IF;

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

1592: IF p_Price_Break_rec.discount_line_id <> FND_API.G_MISS_NUM THEN
1593:
1594: l_Price_Break_rec.discount_line_id := p_Price_Break_rec.discount_line_id;
1595:
1596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1597: THEN
1598:
1599: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_line');

Line 1601: OE_MSG_PUB.Add;

1597: THEN
1598:
1599: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_line');
1601: OE_MSG_PUB.Add;
1602:
1603: END IF;
1604:
1605: ELSE

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

1622: IF p_Price_Break_rec.method_type_code <> FND_API.G_MISS_CHAR THEN
1623:
1624: l_Price_Break_rec.method_type_code := p_Price_Break_rec.method_type_code;
1625:
1626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1627: THEN
1628:
1629: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type');

Line 1631: OE_MSG_PUB.Add;

1627: THEN
1628:
1629: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method_type');
1631: OE_MSG_PUB.Add;
1632:
1633: END IF;
1634:
1635: ELSE

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

1652: IF p_Price_Break_rec.unit_code <> FND_API.G_MISS_CHAR THEN
1653:
1654: l_Price_Break_rec.unit_code := p_Price_Break_rec.unit_code;
1655:
1656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1657: THEN
1658:
1659: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');

Line 1661: OE_MSG_PUB.Add;

1657: THEN
1658:
1659: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
1660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');
1661: OE_MSG_PUB.Add;
1662:
1663: END IF;
1664:
1665: ELSE