DBA Data[Home] [Help]

APPS.QP_SOU_UTIL dependencies on OE_MSG_PUB

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

898: EXCEPTION
899:
900: WHEN OTHERS THEN
901:
902: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
903: THEN
904: OE_MSG_PUB.Add_Exc_Msg
905: ( G_PKG_NAME
906: , 'Update_Row'

Line 904: OE_MSG_PUB.Add_Exc_Msg

900: WHEN OTHERS THEN
901:
902: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
903: THEN
904: OE_MSG_PUB.Add_Exc_Msg
905: ( G_PKG_NAME
906: , 'Update_Row'
907: );
908: END IF;

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

997: EXCEPTION
998:
999: WHEN OTHERS THEN
1000:
1001: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: OE_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME
1005: , 'Insert_Row'

Line 1003: OE_MSG_PUB.Add_Exc_Msg

999: WHEN OTHERS THEN
1000:
1001: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: OE_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME
1005: , 'Insert_Row'
1006: );
1007: END IF;

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

1025: EXCEPTION
1026:
1027: WHEN OTHERS THEN
1028:
1029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1030: THEN
1031: OE_MSG_PUB.Add_Exc_Msg
1032: ( G_PKG_NAME
1033: , 'Delete_Row'

Line 1031: OE_MSG_PUB.Add_Exc_Msg

1027: WHEN OTHERS THEN
1028:
1029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1030: THEN
1031: OE_MSG_PUB.Add_Exc_Msg
1032: ( G_PKG_NAME
1033: , 'Delete_Row'
1034: );
1035: END IF;

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

1118: (p_segment_pte_id IS NOT NULL
1119: AND
1120: p_segment_pte_id <> FND_API.G_MISS_NUM)
1121: THEN
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: OE_MSG_PUB.Add_Exc_Msg
1125: ( G_PKG_NAME
1126: , 'Query Rows'

Line 1124: OE_MSG_PUB.Add_Exc_Msg

1120: p_segment_pte_id <> FND_API.G_MISS_NUM)
1121: THEN
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: OE_MSG_PUB.Add_Exc_Msg
1125: ( G_PKG_NAME
1126: , 'Query Rows'
1127: , 'Keys are mutually exclusive: attribute_sourcing_id = '|| p_attribute_sourcing_id || ', segment_pte_id = '|| p_segment_pte_id
1128: );

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

1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203:
1204: WHEN OTHERS THEN
1205:
1206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1207: THEN
1208: OE_MSG_PUB.Add_Exc_Msg
1209: ( G_PKG_NAME
1210: , 'Query_Rows'

Line 1208: OE_MSG_PUB.Add_Exc_Msg

1204: WHEN OTHERS THEN
1205:
1206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1207: THEN
1208: OE_MSG_PUB.Add_Exc_Msg
1209: ( G_PKG_NAME
1210: , 'Query_Rows'
1211: );
1212: END IF;

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

1390:
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN
1396:
1397: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1398: OE_MSG_PUB.Add;

Line 1398: OE_MSG_PUB.Add;

1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN
1396:
1397: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1398: OE_MSG_PUB.Add;
1399:
1400: END IF;
1401:
1402: END IF;

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

1407:
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1410:
1411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1412: THEN
1413:
1414: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1415: OE_MSG_PUB.Add;

Line 1415: OE_MSG_PUB.Add;

1411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1412: THEN
1413:
1414: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1415: OE_MSG_PUB.Add;
1416:
1417: END IF;
1418: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1419:

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

1419:
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1422:
1423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1424: THEN
1425:
1426: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1427: OE_MSG_PUB.Add;

Line 1427: OE_MSG_PUB.Add;

1423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1424: THEN
1425:
1426: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1427: OE_MSG_PUB.Add;
1428:
1429: END IF;
1430: WHEN OTHERS THEN
1431:

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

1431:
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: x_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434:
1435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: OE_MSG_PUB.Add_Exc_Msg
1438: ( G_PKG_NAME
1439: , 'Lock_Row'

Line 1437: OE_MSG_PUB.Add_Exc_Msg

1433: x_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434:
1435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: OE_MSG_PUB.Add_Exc_Msg
1438: ( G_PKG_NAME
1439: , 'Lock_Row'
1440: );
1441: END IF;

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

1531: IF p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM THEN
1532:
1533: l_SOU_rec.attribute_sourcing_id := p_SOU_rec.attribute_sourcing_id;
1534:
1535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1536: THEN
1537:
1538: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute_sourcing');

Line 1540: OE_MSG_PUB.Add;

1536: THEN
1537:
1538: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute_sourcing');
1540: OE_MSG_PUB.Add;
1541:
1542: END IF;
1543:
1544: ELSE

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

1561: IF p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1562:
1563: l_SOU_rec.enabled_flag := p_SOU_rec.enabled_flag;
1564:
1565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1566: THEN
1567:
1568: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');

Line 1570: OE_MSG_PUB.Add;

1566: THEN
1567:
1568: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1570: OE_MSG_PUB.Add;
1571:
1572: END IF;
1573:
1574: ELSE

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

1591: IF p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR THEN
1592:
1593: l_SOU_rec.request_type_code := p_SOU_rec.request_type_code;
1594:
1595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1596: THEN
1597:
1598: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');

Line 1600: OE_MSG_PUB.Add;

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

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

1621: IF p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1622:
1623: l_SOU_rec.seeded_flag := p_SOU_rec.seeded_flag;
1624:
1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1626: THEN
1627:
1628: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','seeded');

Line 1630: OE_MSG_PUB.Add;

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

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

1651: IF p_SOU_rec.segment_id <> FND_API.G_MISS_NUM THEN
1652:
1653: l_SOU_rec.segment_id := p_SOU_rec.segment_id;
1654:
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1656: THEN
1657:
1658: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','segment');

Line 1660: OE_MSG_PUB.Add;

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