eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_LIST_PVT dependencies on OE_MSG_PUB

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

251: RAISE;
252:
253: WHEN OTHERS THEN
254:
255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: OE_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME
259: , 'Price_List'

Line 257: OE_MSG_PUB.Add_Exc_Msg

253: WHEN OTHERS THEN
254:
255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: OE_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME
259: , 'Price_List'
260: );
261: END IF;

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

517: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
519: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: OE_MSG_PUB.Add_Exc_Msg
524: ( G_PKG_NAME
525: , 'Price_List_Lines'

Line 523: OE_MSG_PUB.Add_Exc_Msg

519: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: OE_MSG_PUB.Add_Exc_Msg
524: ( G_PKG_NAME
525: , 'Price_List_Lines'
526: );
527: END IF;

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

548: RAISE;
549:
550: WHEN OTHERS THEN
551:
552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
553: THEN
554: OE_MSG_PUB.Add_Exc_Msg
555: ( G_PKG_NAME
556: , 'Price_List_Lines'

Line 554: OE_MSG_PUB.Add_Exc_Msg

550: WHEN OTHERS THEN
551:
552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
553: THEN
554: OE_MSG_PUB.Add_Exc_Msg
555: ( G_PKG_NAME
556: , 'Price_List_Lines'
557: );
558: END IF;

Line 634: OE_MSG_PUB.initialize;

630:
631: -- Initialize message list.
632:
633: IF FND_API.to_Boolean(p_init_msg_list) THEN
634: OE_MSG_PUB.initialize;
635: END IF;
636:
637: -- Init local table variables.
638:

Line 757: OE_MSG_PUB.Count_And_Get

753: END LOOP;
754:
755: -- Get message count and data
756:
757: OE_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count
759: , p_data => x_msg_data
760: );
761:

Line 771: OE_MSG_PUB.Count_And_Get

767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: -- Get message count and data
770:
771: OE_MSG_PUB.Count_And_Get
772: ( p_count => x_msg_count
773: , p_data => x_msg_data
774: );
775:

Line 782: OE_MSG_PUB.Count_And_Get

778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779:
780: -- Get message count and data
781:
782: OE_MSG_PUB.Count_And_Get
783: ( p_count => x_msg_count
784: , p_data => x_msg_data
785: );
786:

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

787: WHEN OTHERS THEN
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
792: THEN
793: OE_MSG_PUB.Add_Exc_Msg
794: ( G_PKG_NAME
795: , 'Process_Price_List'

Line 793: OE_MSG_PUB.Add_Exc_Msg

789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
792: THEN
793: OE_MSG_PUB.Add_Exc_Msg
794: ( G_PKG_NAME
795: , 'Process_Price_List'
796: );
797: END IF;

Line 801: OE_MSG_PUB.Count_And_Get

797: END IF;
798:
799: -- Get message count and data
800:
801: OE_MSG_PUB.Count_And_Get
802: ( p_count => x_msg_count
803: , p_data => x_msg_data
804: );
805:

Line 859: OE_MSG_PUB.initialize;

855:
856: -- Initialize message list.
857:
858: IF FND_API.to_Boolean(p_init_msg_list) THEN
859: OE_MSG_PUB.initialize;
860: END IF;
861:
862: -- Set Savepoint
863:

Line 915: OE_MSG_PUB.Count_And_Get

911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912:
913: -- Get message count and data
914:
915: OE_MSG_PUB.Count_And_Get
916: ( p_count => x_msg_count
917: , p_data => x_msg_data
918: );
919:

Line 929: OE_MSG_PUB.Count_And_Get

925: x_return_status := FND_API.G_RET_STS_ERROR;
926:
927: -- Get message count and data
928:
929: OE_MSG_PUB.Count_And_Get
930: ( p_count => x_msg_count
931: , p_data => x_msg_data
932: );
933:

Line 944: OE_MSG_PUB.Count_And_Get

940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941:
942: -- Get message count and data
943:
944: OE_MSG_PUB.Count_And_Get
945: ( p_count => x_msg_count
946: , p_data => x_msg_data
947: );
948:

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

953: WHEN OTHERS THEN
954:
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956:
957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
958: THEN
959: OE_MSG_PUB.Add_Exc_Msg
960: ( G_PKG_NAME
961: , 'Lock_Price_List'

Line 959: OE_MSG_PUB.Add_Exc_Msg

955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956:
957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
958: THEN
959: OE_MSG_PUB.Add_Exc_Msg
960: ( G_PKG_NAME
961: , 'Lock_Price_List'
962: );
963: END IF;

Line 967: OE_MSG_PUB.Count_And_Get

963: END IF;
964:
965: -- Get message count and data
966:
967: OE_MSG_PUB.Count_And_Get
968: ( p_count => x_msg_count
969: , p_data => x_msg_data
970: );
971:

Line 1027: OE_MSG_PUB.initialize;

1023:
1024: -- Initialize message list.
1025:
1026: IF FND_API.to_Boolean(p_init_msg_list) THEN
1027: OE_MSG_PUB.initialize;
1028: END IF;
1029:
1030: -- Get PRICE_LIST ( parent = PRICE_LIST )
1031:

Line 1056: OE_MSG_PUB.Count_And_Get

1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054: -- Get message count and data
1055:
1056: OE_MSG_PUB.Count_And_Get
1057: ( p_count => x_msg_count
1058: , p_data => x_msg_data
1059: );
1060:

Line 1070: OE_MSG_PUB.Count_And_Get

1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067:
1068: -- Get message count and data
1069:
1070: OE_MSG_PUB.Count_And_Get
1071: ( p_count => x_msg_count
1072: , p_data => x_msg_data
1073: );
1074:

Line 1081: OE_MSG_PUB.Count_And_Get

1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078:
1079: -- Get message count and data
1080:
1081: OE_MSG_PUB.Count_And_Get
1082: ( p_count => x_msg_count
1083: , p_data => x_msg_data
1084: );
1085:

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

1086: WHEN OTHERS THEN
1087:
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089:
1090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1091: THEN
1092: OE_MSG_PUB.Add_Exc_Msg
1093: ( G_PKG_NAME
1094: , 'Get_Price_List'

Line 1092: OE_MSG_PUB.Add_Exc_Msg

1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089:
1090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1091: THEN
1092: OE_MSG_PUB.Add_Exc_Msg
1093: ( G_PKG_NAME
1094: , 'Get_Price_List'
1095: );
1096: END IF;

Line 1100: OE_MSG_PUB.Count_And_Get

1096: END IF;
1097:
1098: -- Get message count and data
1099:
1100: OE_MSG_PUB.Count_And_Get
1101: ( p_count => x_msg_count
1102: , p_data => x_msg_data
1103: );
1104:

Line 1323: OE_MSG_PUB.initialize;

1319: -- Initialize message list if p_init_msg_list is set to TRUE
1320:
1321: IF FND_API.to_Boolean(p_init_msg_list) THEN
1322:
1323: OE_MSG_PUB.initialize;
1324:
1325: END IF;
1326:
1327: -- Initialize p_return_status

Line 1345: OE_MSG_PUB.Add;

1341:
1342: FND_MESSAGE.SET_NAME('OE','OE_PRC_LIST_INVALID_FETCH_ATTEMPTS');
1343: FND_MESSAGE.SET_TOKEN('PASSED_FETCH_ATTEMPTS',p_fetch_attempts);
1344: FND_MESSAGE.SET_TOKEN('MAX_FETCH_ATTEMPTS',G_PRC_LST_MAX_ATTEMPTS);
1345: OE_MSG_PUB.Add;
1346:
1347: END IF;
1348:
1349: -- Validation that can be turned off through the use of

Line 1416: OE_MSG_PUB.Add_Exc_Msg

1412:
1413: -- Debug info
1414: /*
1415:
1416: OE_MSG_PUB.Add_Exc_Msg
1417: ( p_error_text => 'pricing_attribute2 is null' );
1418: */
1419:
1420: -- Fecth driving on item_id

Line 1626: OE_MSG_PUB.Add_Exc_Msg

1622:
1623:
1624: -- Debug info
1625: /*
1626: OE_MSG_PUB.Add_Exc_Msg
1627: ( p_error_text => 'list price is not null - '||
1628: ' list_price = '||l_list_price||
1629: ' l_prc_method_code = '||l_prc_method_code_out||
1630: ' l_rounding_factor = '||l_rounding_factor

Line 1686: IF OE_MSG_PUB.Check_Msg_Level (

1682: ELSE
1683:
1684: -- Unexpected error, invalid pricing method
1685:
1686: IF OE_MSG_PUB.Check_Msg_Level (
1687: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689:
1690: OE_MSG_PUB.Add_Exc_Msg

Line 1687: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1683:
1684: -- Unexpected error, invalid pricing method
1685:
1686: IF OE_MSG_PUB.Check_Msg_Level (
1687: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689:
1690: OE_MSG_PUB.Add_Exc_Msg
1691: ( G_PKG_NAME ,

Line 1690: OE_MSG_PUB.Add_Exc_Msg

1686: IF OE_MSG_PUB.Check_Msg_Level (
1687: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689:
1690: OE_MSG_PUB.Add_Exc_Msg
1691: ( G_PKG_NAME ,
1692: l_api_name ,
1693: 'Invalid pricing method ='||l_prc_method_code_out
1694: );

Line 1716: OE_MSG_PUB.Add_Exc_Msg

1712: WHEN NO_DATA_FOUND THEN
1713:
1714: -- Debug info
1715:
1716: OE_MSG_PUB.Add_Exc_Msg
1717: ( p_error_text => 'Primary fetch not successful' );
1718:
1719:
1720: -- Check if the maximum number of attempts has been

Line 1801: OE_MSG_PUB.Add;

1797: --END IF; -- fetch_attempts > 1
1798: ELSE --After all attempts still couldn't find price list
1799: FND_MESSAGE.SET_NAME('QP','QP_PR_LIST_NOT_FOUND');
1800: FND_MESSAGE.SET_TOKEN('%',p_inventory_item_id);
1801: OE_MSG_PUB.Add;
1802:
1803:
1804:
1805: END IF;

Line 1811: IF OE_MSG_PUB.Check_Msg_Level(

1807: WHEN OTHERS THEN
1808:
1809: -- Unexpected error
1810:
1811: IF OE_MSG_PUB.Check_Msg_Level(
1812: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1813: THEN
1814:
1815: OE_MSG_PUB.Add_Exc_Msg

Line 1812: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1808:
1809: -- Unexpected error
1810:
1811: IF OE_MSG_PUB.Check_Msg_Level(
1812: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1813: THEN
1814:
1815: OE_MSG_PUB.Add_Exc_Msg
1816: ( G_PKG_NAME ,

Line 1815: OE_MSG_PUB.Add_Exc_Msg

1811: IF OE_MSG_PUB.Check_Msg_Level(
1812: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1813: THEN
1814:
1815: OE_MSG_PUB.Add_Exc_Msg
1816: ( G_PKG_NAME ,
1817: l_api_name
1818: );
1819:

Line 1838: OE_MSG_PUB.Add_Exc_Msg

1834: -- not found o the price list.
1835:
1836: -- Debug info
1837: /*
1838: OE_MSG_PUB.Add_Exc_Msg
1839: ( p_error_text => 'End of Fetch_List_Price - '||
1840: ' l_list_price = '||l_list_price||
1841: ' G_Fetch_Level = '||G_Fetch_Level
1842: );

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

1846: IF l_list_price IS NULL AND
1847: G_Fetch_Level = 1
1848: THEN
1849:
1850: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
1851: THEN
1852:
1853: FND_MESSAGE.SET_NAME('QP','OE_PRC_NO_LIST_PRICE');
1854: FND_MESSAGE.SET_TOKEN('PRICE_LIST', Get_Price_List_Name

Line 1859: OE_MSG_PUB.Add;

1855: (p_price_list_id) );
1856: FND_MESSAGE.SET_TOKEN('ITEM', Get_Item_Description
1857: (p_inventory_item_id) );
1858: FND_MESSAGE.SET_TOKEN('UNIT',Get_Unit_Name(p_unit_code ));
1859: OE_MSG_PUB.Add;
1860:
1861:
1862: END IF;
1863:

Line 1872: OE_MSG_PUB.Count_And_Get

1868: G_Fetch_Level := G_Fetch_Level - 1;
1869:
1870: -- Get message count and if 1, return message data
1871:
1872: OE_MSG_PUB.Count_And_Get
1873: ( p_count => p_msg_count ,
1874: p_data => p_msg_data
1875: );
1876:

Line 1886: OE_MSG_PUB.Count_And_Get

1882: p_return_status := FND_API.G_RET_STS_ERROR;
1883:
1884: -- Get message count and if 1, return message data
1885:
1886: OE_MSG_PUB.Count_And_Get
1887: (p_count => p_msg_count,
1888: p_data => p_msg_data
1889: );
1890:

Line 1901: OE_MSG_PUB.Count_And_Get

1897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1898:
1899: -- Get message count and if 1, return message data
1900:
1901: OE_MSG_PUB.Count_And_Get
1902: (p_count => p_msg_count,
1903: p_data => p_msg_data
1904: );
1905:

Line 1915: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1911: WHEN OTHERS THEN
1912:
1913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1914:
1915: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1916: OE_MSG_PUB.Add_Exc_Msg
1917: ( G_PKG_NAME ,
1918: l_api_name
1919: );

Line 1916: OE_MSG_PUB.Add_Exc_Msg

1912:
1913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1914:
1915: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1916: OE_MSG_PUB.Add_Exc_Msg
1917: ( G_PKG_NAME ,
1918: l_api_name
1919: );
1920: END IF;

Line 1924: OE_MSG_PUB.Count_And_Get

1920: END IF;
1921:
1922: -- Get message count and if 1, return message data
1923:
1924: OE_MSG_PUB.Count_And_Get
1925: ( p_count => p_msg_count,
1926: p_data => p_msg_data
1927: );
1928:

Line 1986: OE_MSG_PUB.Add_Exc_Msg

1982: EXCEPTION
1983:
1984: WHEN OTHERS THEN
1985:
1986: OE_MSG_PUB.Add_Exc_Msg
1987: ( G_PKG_NAME ,
1988: 'Get_Item_Description - p_item_id = '||p_item_id||
1989: ' org_id ='||l_org_id
1990: );

Line 2018: OE_MSG_PUB.Add_Exc_Msg

2014: EXCEPTION
2015:
2016: WHEN OTHERS THEN
2017:
2018: OE_MSG_PUB.Add_Exc_Msg
2019: ( G_PKG_NAME ,
2020: 'Get_Unit_Name - p_unit_code = '||p_unit_code
2021: );
2022: