DBA Data[Home] [Help]

APPS.QP_RQT_UTIL dependencies on OE_MSG_PUB

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

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'

Line 905: OE_MSG_PUB.Add_Exc_Msg

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;

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

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'

Line 1101: OE_MSG_PUB.Add_Exc_Msg

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;

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

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'

Line 1135: OE_MSG_PUB.Add_Exc_Msg

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;

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

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'

Line 1227: OE_MSG_PUB.Add_Exc_Msg

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: );

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

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'

Line 1309: OE_MSG_PUB.Add_Exc_Msg

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;

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

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;

Line 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;

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_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;

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('QP','OE_LOCK_ROW_DELETED');
1508: OE_MSG_PUB.Add;
1509:
1510: END IF;
1511: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1512:

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

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;

Line 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:

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

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'

Line 1530: OE_MSG_PUB.Add_Exc_Msg

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;

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

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');

Line 1623: OE_MSG_PUB.Add;

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

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

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');

Line 1653: OE_MSG_PUB.Add;

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

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

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');

Line 1683: OE_MSG_PUB.Add;

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

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

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');

Line 1713: OE_MSG_PUB.Add;

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