DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL_MOD dependencies on FND_MSG_PUB

Line 993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

989: EXCEPTION
990:
991: WHEN OTHERS THEN
992:
993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
994: THEN
995: FND_MSG_PUB.Add_Exc_Msg
996: ( G_PKG_NAME
997: , 'Update_Row'

Line 995: FND_MSG_PUB.Add_Exc_Msg

991: WHEN OTHERS THEN
992:
993: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
994: THEN
995: FND_MSG_PUB.Add_Exc_Msg
996: ( G_PKG_NAME
997: , 'Update_Row'
998: );
999: END IF;

Line 1121: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1117: EXCEPTION
1118:
1119: WHEN OTHERS THEN
1120:
1121: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1122: THEN
1123: FND_MSG_PUB.Add_Exc_Msg
1124: ( G_PKG_NAME
1125: , 'Insert_Row'

Line 1123: FND_MSG_PUB.Add_Exc_Msg

1119: WHEN OTHERS THEN
1120:
1121: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1122: THEN
1123: FND_MSG_PUB.Add_Exc_Msg
1124: ( G_PKG_NAME
1125: , 'Insert_Row'
1126: );
1127: END IF;

Line 1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1145: EXCEPTION
1146:
1147: WHEN OTHERS THEN
1148:
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1150: THEN
1151: FND_MSG_PUB.Add_Exc_Msg
1152: ( G_PKG_NAME
1153: , 'Delete_Row'

Line 1151: FND_MSG_PUB.Add_Exc_Msg

1147: WHEN OTHERS THEN
1148:
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1150: THEN
1151: FND_MSG_PUB.Add_Exc_Msg
1152: ( G_PKG_NAME
1153: , 'Delete_Row'
1154: );
1155: END IF;

Line 1256: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1252: (p_list_header_id IS NOT NULL
1253: AND
1254: p_list_header_id <> FND_API.G_MISS_NUM)
1255: THEN
1256: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: FND_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'Query Rows'

Line 1258: FND_MSG_PUB.Add_Exc_Msg

1254: p_list_header_id <> FND_API.G_MISS_NUM)
1255: THEN
1256: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1257: THEN
1258: FND_MSG_PUB.Add_Exc_Msg
1259: ( G_PKG_NAME
1260: , 'Query Rows'
1261: , 'Keys are mutually exclusive: qualifier_id = '|| p_qualifier_id || ', list_header_id = '|| p_list_header_id
1262: );

Line 1356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1353:
1354: WHEN OTHERS THEN
1355:
1356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: FND_MSG_PUB.Add_Exc_Msg
1359: ( G_PKG_NAME
1360: , 'Query_Rows'

Line 1358: FND_MSG_PUB.Add_Exc_Msg

1354: WHEN OTHERS THEN
1355:
1356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: FND_MSG_PUB.Add_Exc_Msg
1359: ( G_PKG_NAME
1360: , 'Query_Rows'
1361: );
1362: END IF;

Line 1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1552:
1553: x_return_status := FND_API.G_RET_STS_ERROR;
1554: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1555:
1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1557: THEN
1558:
1559: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1560: FND_MSG_PUB.Add;

Line 1560: FND_MSG_PUB.Add;

1556: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1557: THEN
1558:
1559: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1560: FND_MSG_PUB.Add;
1561:
1562: END IF;
1563:
1564: END IF;

Line 1573: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1569:
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1572:
1573: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1574: THEN
1575:
1576: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1577: FND_MSG_PUB.Add;

Line 1577: FND_MSG_PUB.Add;

1573: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1574: THEN
1575:
1576: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
1577: FND_MSG_PUB.Add;
1578:
1579: END IF;
1580: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1581:

Line 1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1581:
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1586: THEN
1587:
1588: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1589: FND_MSG_PUB.Add;

Line 1589: FND_MSG_PUB.Add;

1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1586: THEN
1587:
1588: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
1589: FND_MSG_PUB.Add;
1590:
1591: END IF;
1592: WHEN OTHERS THEN
1593:

Line 1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1593:
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596:
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1598: THEN
1599: FND_MSG_PUB.Add_Exc_Msg
1600: ( G_PKG_NAME
1601: , 'Lock_Row'

Line 1599: FND_MSG_PUB.Add_Exc_Msg

1595: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596:
1597: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1598: THEN
1599: FND_MSG_PUB.Add_Exc_Msg
1600: ( G_PKG_NAME
1601: , 'Lock_Row'
1602: );
1603: END IF;

Line 1717: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1713: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
1714:
1715: l_QUALIFIERS_rec.comparison_operator_code := p_QUALIFIERS_rec.comparison_operator_code;
1716:
1717: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1718: THEN
1719:
1720: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1721: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');

Line 1722: FND_MSG_PUB.Add;

1718: THEN
1719:
1720: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1721: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
1722: FND_MSG_PUB.Add;
1723:
1724: END IF;
1725:
1726: ELSE

Line 1747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1743: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
1744:
1745: l_QUALIFIERS_rec.created_from_rule_id := p_QUALIFIERS_rec.created_from_rule_id;
1746:
1747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1748: THEN
1749:
1750: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');

Line 1752: FND_MSG_PUB.Add;

1748: THEN
1749:
1750: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');
1752: FND_MSG_PUB.Add;
1753:
1754: END IF;
1755:
1756: ELSE

Line 1777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1773: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
1774:
1775: l_QUALIFIERS_rec.excluder_flag := p_QUALIFIERS_rec.excluder_flag;
1776:
1777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1778: THEN
1779:
1780: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');

Line 1782: FND_MSG_PUB.Add;

1778: THEN
1779:
1780: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
1782: FND_MSG_PUB.Add;
1783:
1784: END IF;
1785:
1786: ELSE

Line 1807: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1803: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
1804:
1805: l_QUALIFIERS_rec.list_header_id := p_QUALIFIERS_rec.list_header_id;
1806:
1807: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1808: THEN
1809:
1810: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 1812: FND_MSG_PUB.Add;

1808: THEN
1809:
1810: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
1812: FND_MSG_PUB.Add;
1813:
1814: END IF;
1815:
1816: ELSE

Line 1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1833: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
1834:
1835: l_QUALIFIERS_rec.list_line_id := p_QUALIFIERS_rec.list_line_id;
1836:
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1838: THEN
1839:
1840: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1841: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 1842: FND_MSG_PUB.Add;

1838: THEN
1839:
1840: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1841: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
1842: FND_MSG_PUB.Add;
1843:
1844: END IF;
1845:
1846: ELSE

Line 1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1863: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
1864:
1865: l_QUALIFIERS_rec.qualifier_id := p_QUALIFIERS_rec.qualifier_id;
1866:
1867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1868: THEN
1869:
1870: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1871: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');

Line 1872: FND_MSG_PUB.Add;

1868: THEN
1869:
1870: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1871: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');
1872: FND_MSG_PUB.Add;
1873:
1874: END IF;
1875:
1876: ELSE

Line 1897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

1893: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
1894:
1895: l_QUALIFIERS_rec.qualifier_rule_id := p_QUALIFIERS_rec.qualifier_rule_id;
1896:
1897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1898: THEN
1899:
1900: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');

Line 1902: FND_MSG_PUB.Add;

1898: THEN
1899:
1900: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
1901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
1902: FND_MSG_PUB.Add;
1903:
1904: END IF;
1905:
1906: ELSE