899: EXCEPTION
900:
901: WHEN OTHERS THEN
902:
903: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
904: THEN
905: OE_MSG_PUB.Add_Exc_Msg
906: ( G_PKG_NAME
907: , 'Update_Row'
901: WHEN OTHERS THEN
902:
903: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
904: THEN
905: OE_MSG_PUB.Add_Exc_Msg
906: ( G_PKG_NAME
907: , 'Update_Row'
908: );
909: END IF;
1095: EXCEPTION
1096:
1097: WHEN OTHERS THEN
1098:
1099: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: THEN
1101: OE_MSG_PUB.Add_Exc_Msg
1102: ( G_PKG_NAME
1103: , 'Insert_Row'
1097: WHEN OTHERS THEN
1098:
1099: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1100: THEN
1101: OE_MSG_PUB.Add_Exc_Msg
1102: ( G_PKG_NAME
1103: , 'Insert_Row'
1104: );
1105: END IF;
1129: EXCEPTION
1130:
1131: WHEN OTHERS THEN
1132:
1133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1134: THEN
1135: OE_MSG_PUB.Add_Exc_Msg
1136: ( G_PKG_NAME
1137: , 'Delete_Row'
1131: WHEN OTHERS THEN
1132:
1133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1134: THEN
1135: OE_MSG_PUB.Add_Exc_Msg
1136: ( G_PKG_NAME
1137: , 'Delete_Row'
1138: );
1139: END IF;
1221: (p_lookup_code IS NOT NULL
1222: AND
1223: p_lookup_code <> FND_API.G_MISS_CHAR)
1224: THEN
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg
1228: ( G_PKG_NAME
1229: , 'Query Rows'
1223: p_lookup_code <> FND_API.G_MISS_CHAR)
1224: THEN
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg
1228: ( G_PKG_NAME
1229: , 'Query Rows'
1230: , 'Keys are mutually exclusive: request_type_code = '|| p_request_type_code || ', lookup_code = '|| p_lookup_code
1231: );
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304:
1305: WHEN OTHERS THEN
1306:
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1308: THEN
1309: OE_MSG_PUB.Add_Exc_Msg
1310: ( G_PKG_NAME
1311: , 'Query_Rows'
1305: WHEN OTHERS THEN
1306:
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1308: THEN
1309: OE_MSG_PUB.Add_Exc_Msg
1310: ( G_PKG_NAME
1311: , 'Query_Rows'
1312: );
1313: END IF;
1483:
1484: x_return_status := FND_API.G_RET_STS_ERROR;
1485: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1486:
1487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1488: THEN
1489:
1490: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1491: OE_MSG_PUB.Add;
1487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1488: THEN
1489:
1490: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1491: OE_MSG_PUB.Add;
1492:
1493: END IF;
1494:
1495: END IF;
1500:
1501: x_return_status := FND_API.G_RET_STS_ERROR;
1502: x_RQT_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('QP','OE_LOCK_ROW_DELETED');
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('QP','OE_LOCK_ROW_DELETED');
1508: OE_MSG_PUB.Add;
1509:
1510: END IF;
1511: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1512:
1512:
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: x_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
1515:
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1517: THEN
1518:
1519: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1520: OE_MSG_PUB.Add;
1516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1517: THEN
1518:
1519: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1520: OE_MSG_PUB.Add;
1521:
1522: END IF;
1523: WHEN OTHERS THEN
1524:
1524:
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: x_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: OE_MSG_PUB.Add_Exc_Msg
1531: ( G_PKG_NAME
1532: , 'Lock_Row'
1526: x_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: OE_MSG_PUB.Add_Exc_Msg
1531: ( G_PKG_NAME
1532: , 'Lock_Row'
1533: );
1534: END IF;
1614: IF p_RQT_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1615:
1616: l_RQT_rec.enabled_flag := p_RQT_rec.enabled_flag;
1617:
1618: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1619: THEN
1620:
1621: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1619: THEN
1620:
1621: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
1623: OE_MSG_PUB.Add;
1624:
1625: END IF;
1626:
1627: ELSE
1644: IF p_RQT_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1645:
1646: l_RQT_rec.pte_code := p_RQT_rec.pte_code;
1647:
1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1649: THEN
1650:
1651: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
1649: THEN
1650:
1651: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pte');
1653: OE_MSG_PUB.Add;
1654:
1655: END IF;
1656:
1657: ELSE
1674: IF p_RQT_rec.request_type_code <> FND_API.G_MISS_CHAR THEN
1675:
1676: l_RQT_rec.request_type_code := p_RQT_rec.request_type_code;
1677:
1678: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1679: THEN
1680:
1681: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
1679: THEN
1680:
1681: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','request_type');
1683: OE_MSG_PUB.Add;
1684:
1685: END IF;
1686:
1687: ELSE
1704: IF p_RQT_rec.row_id <> FND_API.G_MISS_CHAR THEN
1705:
1706: l_RQT_rec.row_id := p_RQT_rec.row_id;
1707:
1708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1709: THEN
1710:
1711: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1709: THEN
1710:
1711: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1712: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','row');
1713: OE_MSG_PUB.Add;
1714:
1715: END IF;
1716:
1717: ELSE