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.OZF_VOLUME_OFFER_DISC_PVT dependencies on FND_MSG_PUB

Line 56: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

52: -- End of Comments
53: -- ==============================================================================
54:
55:
56: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
57: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
58: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60:

Line 57: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

53: -- ==============================================================================
54:
55:
56: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
57: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
58: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60:
61: PROCEDURE debug_message(p_message IN VARCHAR2)

Line 58: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

54:
55:
56: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
57: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
58: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
59:
60:
61: PROCEDURE debug_message(p_message IN VARCHAR2)
62: IS

Line 1337: FND_MSG_PUB.initialize;

1333: BEGIN
1334: -- Initialize message list if p_init_msg_list is set to TRUE.
1335: IF FND_API.to_Boolean( p_init_msg_list )
1336: THEN
1337: FND_MSG_PUB.initialize;
1338: END IF;
1339:
1340: -- Initialize API return status to SUCCESS
1341: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1351: FND_MSG_PUB.Count_And_Get

1347:
1348: -- Debug Message
1349: OZF_Offer_Adj_Line_PVT.debug_message('Private API: Validate_dm_model_rec');
1350: -- Standard call to get message count and if count is 1, get message info.
1351: FND_MSG_PUB.Count_And_Get
1352: (p_count => x_msg_count,
1353: p_data => x_msg_data
1354: );
1355: END Validate_vo_discounts_rec;

Line 1419: FND_MSG_PUB.initialize;

1415: END IF;
1416: -- Initialize message list if p_init_msg_list is set to TRUE.
1417: IF FND_API.to_Boolean( p_init_msg_list )
1418: THEN
1419: FND_MSG_PUB.initialize;
1420: END IF;
1421:
1422: -- Debug Message
1423: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1476: FND_MSG_PUB.Count_And_Get

1472: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
1473:
1474:
1475: -- Standard call to get message count and if count is 1, get message info.
1476: FND_MSG_PUB.Count_And_Get
1477: (p_count => x_msg_count,
1478: p_data => x_msg_data
1479: );
1480: EXCEPTION

Line 1490: FND_MSG_PUB.Count_And_Get (

1486: WHEN FND_API.G_EXC_ERROR THEN
1487: ROLLBACK TO Validate_vo_discounts_pvt;
1488: x_return_status := FND_API.G_RET_STS_ERROR;
1489: -- Standard call to get message count and if count=1, get the message
1490: FND_MSG_PUB.Count_And_Get (
1491: p_encoded => FND_API.G_FALSE,
1492: p_count => x_msg_count,
1493: p_data => x_msg_data
1494: );

Line 1500: FND_MSG_PUB.Count_And_Get (

1496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1497: ROLLBACK TO Validate_vo_discounts_pvt;
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499: -- Standard call to get message count and if count=1, get the message
1500: FND_MSG_PUB.Count_And_Get (
1501: p_encoded => FND_API.G_FALSE,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );

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

1505:
1506: WHEN OTHERS THEN
1507: ROLLBACK TO Validate_vo_discounts_pvt;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1510: THEN
1511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1512: END IF;
1513: -- Standard call to get message count and if count=1, get the message

Line 1511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1507: ROLLBACK TO Validate_vo_discounts_pvt;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1510: THEN
1511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1512: END IF;
1513: -- Standard call to get message count and if count=1, get the message
1514: FND_MSG_PUB.Count_And_Get (
1515: p_encoded => FND_API.G_FALSE,

Line 1514: FND_MSG_PUB.Count_And_Get (

1510: THEN
1511: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1512: END IF;
1513: -- Standard call to get message count and if count=1, get the message
1514: FND_MSG_PUB.Count_And_Get (
1515: p_encoded => FND_API.G_FALSE,
1516: p_count => x_msg_count,
1517: p_data => x_msg_data
1518: );

Line 1594: FND_MSG_PUB.initialize;

1590:
1591: -- Initialize message list if p_init_msg_list is set to TRUE.
1592: IF FND_API.to_Boolean( p_init_msg_list )
1593: THEN
1594: FND_MSG_PUB.initialize;
1595: END IF;
1596:
1597: -- Initialize API return status to SUCCESS
1598: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1660: FND_MSG_PUB.Count_And_Get

1656: COMMIT WORK;
1657: END IF;
1658:
1659: -- Standard call to get message count and if count is 1, get message info.
1660: FND_MSG_PUB.Count_And_Get
1661: (p_count => x_msg_count,
1662: p_data => x_msg_data
1663: );
1664: EXCEPTION

Line 1674: FND_MSG_PUB.Count_And_Get (

1670: WHEN FND_API.G_EXC_ERROR THEN
1671: ROLLBACK TO Delete_vo_discount_PVT;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: -- Standard call to get message count and if count=1, get the message
1674: FND_MSG_PUB.Count_And_Get (
1675: p_encoded => FND_API.G_FALSE,
1676: p_count => x_msg_count,
1677: p_data => x_msg_data
1678: );

Line 1684: FND_MSG_PUB.Count_And_Get (

1680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1681: ROLLBACK TO Delete_vo_discount_PVT;
1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683: -- Standard call to get message count and if count=1, get the message
1684: FND_MSG_PUB.Count_And_Get (
1685: p_encoded => FND_API.G_FALSE,
1686: p_count => x_msg_count,
1687: p_data => x_msg_data
1688: );

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

1690: WHEN OTHERS THEN
1691: ROLLBACK TO Delete_vo_discount_PVT;
1692: OZF_Offer_Adj_Line_PVT.debug_message(SUBSTR(SQLERRM, 1, 100));
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1695: THEN
1696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1697: END IF;
1698: -- Standard call to get message count and if count=1, get the message

Line 1696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1692: OZF_Offer_Adj_Line_PVT.debug_message(SUBSTR(SQLERRM, 1, 100));
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1695: THEN
1696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1697: END IF;
1698: -- Standard call to get message count and if count=1, get the message
1699: FND_MSG_PUB.Count_And_Get (
1700: p_encoded => FND_API.G_FALSE,

Line 1699: FND_MSG_PUB.Count_And_Get (

1695: THEN
1696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1697: END IF;
1698: -- Standard call to get message count and if count=1, get the message
1699: FND_MSG_PUB.Count_And_Get (
1700: p_encoded => FND_API.G_FALSE,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data
1703: );

Line 1795: FND_MSG_PUB.initialize;

1791:
1792: -- Initialize message list if p_init_msg_list is set to TRUE.
1793: IF FND_API.to_Boolean( p_init_msg_list )
1794: THEN
1795: FND_MSG_PUB.initialize;
1796: END IF;
1797:
1798: -- Debug Message
1799: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 1919: FND_MSG_PUB.Count_And_Get (

1915: WHEN FND_API.G_EXC_ERROR THEN
1916: ROLLBACK TO copy_vo_discounts_pvt;
1917: x_return_status := FND_API.G_RET_STS_ERROR;
1918: -- Standard call to get message count and if count=1, get the message
1919: FND_MSG_PUB.Count_And_Get (
1920: p_encoded => FND_API.G_FALSE,
1921: p_count => x_msg_count,
1922: p_data => x_msg_data
1923: );

Line 1929: FND_MSG_PUB.Count_And_Get (

1925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1926: ROLLBACK TO copy_vo_discounts_pvt;
1927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1928: -- Standard call to get message count and if count=1, get the message
1929: FND_MSG_PUB.Count_And_Get (
1930: p_encoded => FND_API.G_FALSE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data
1933: );

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

1934:
1935: WHEN OTHERS THEN
1936: ROLLBACK TO copy_vo_discounts_pvt;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1939: THEN
1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1941: END IF;
1942: -- Standard call to get message count and if count=1, get the message

Line 1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1936: ROLLBACK TO copy_vo_discounts_pvt;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1939: THEN
1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1941: END IF;
1942: -- Standard call to get message count and if count=1, get the message
1943: FND_MSG_PUB.Count_And_Get (
1944: p_encoded => FND_API.G_FALSE,

Line 1943: FND_MSG_PUB.Count_And_Get (

1939: THEN
1940: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1941: END IF;
1942: -- Standard call to get message count and if count=1, get the message
1943: FND_MSG_PUB.Count_And_Get (
1944: p_encoded => FND_API.G_FALSE,
1945: p_count => x_msg_count,
1946: p_data => x_msg_data
1947: );

Line 2039: FND_MSG_PUB.initialize;

2035:
2036: -- Initialize message list if p_init_msg_list is set to TRUE.
2037: IF FND_API.to_Boolean( p_init_msg_list )
2038: THEN
2039: FND_MSG_PUB.initialize;
2040: END IF;
2041:
2042: -- Debug Message
2043: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 2206: FND_MSG_PUB.Count_And_Get

2202: END IF;
2203: -- Debug Message
2204: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
2205: -- Standard call to get message count and if count is 1, get message info.
2206: FND_MSG_PUB.Count_And_Get
2207: (p_count => x_msg_count,
2208: p_data => x_msg_data
2209: );
2210: EXCEPTION

Line 2215: FND_MSG_PUB.Count_And_Get (

2211: WHEN FND_API.G_EXC_ERROR THEN
2212: ROLLBACK TO Create_vo_discount_pvt;
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214: -- Standard call to get message count and if count=1, get the message
2215: FND_MSG_PUB.Count_And_Get (
2216: p_encoded => FND_API.G_FALSE,
2217: p_count => x_msg_count,
2218: p_data => x_msg_data
2219: );

Line 2225: FND_MSG_PUB.Count_And_Get (

2221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2222: ROLLBACK TO Create_vo_discount_pvt;
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: -- Standard call to get message count and if count=1, get the message
2225: FND_MSG_PUB.Count_And_Get (
2226: p_encoded => FND_API.G_FALSE,
2227: p_count => x_msg_count,
2228: p_data => x_msg_data
2229: );

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

2230:
2231: WHEN OTHERS THEN
2232: ROLLBACK TO Create_vo_discount_pvt;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2235: THEN
2236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2237: END IF;
2238: -- Standard call to get message count and if count=1, get the message

Line 2236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2232: ROLLBACK TO Create_vo_discount_pvt;
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2235: THEN
2236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2237: END IF;
2238: -- Standard call to get message count and if count=1, get the message
2239: FND_MSG_PUB.Count_And_Get (
2240: p_encoded => FND_API.G_FALSE,

Line 2239: FND_MSG_PUB.Count_And_Get (

2235: THEN
2236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2237: END IF;
2238: -- Standard call to get message count and if count=1, get the message
2239: FND_MSG_PUB.Count_And_Get (
2240: p_encoded => FND_API.G_FALSE,
2241: p_count => x_msg_count,
2242: p_data => x_msg_data
2243: );

Line 2323: FND_MSG_PUB.initialize;

2319: END IF;
2320: -- Initialize message list if p_init_msg_list is set to TRUE.
2321: IF FND_API.to_Boolean( p_init_msg_list )
2322: THEN
2323: FND_MSG_PUB.initialize;
2324: END IF;
2325: -- Debug Message
2326: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
2327:

Line 2457: FND_MSG_PUB.Count_And_Get

2453: END IF;
2454: -- Debug Message
2455: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
2456: -- Standard call to get message count and if count is 1, get message info.
2457: FND_MSG_PUB.Count_And_Get
2458: (p_count => x_msg_count,
2459: p_data => x_msg_data
2460: );
2461: -- exception handling

Line 2472: FND_MSG_PUB.Count_And_Get (

2468: WHEN FND_API.G_EXC_ERROR THEN
2469: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
2470: x_return_status := FND_API.G_RET_STS_ERROR;
2471: -- Standard call to get message count and if count=1, get the message
2472: FND_MSG_PUB.Count_And_Get (
2473: p_encoded => FND_API.G_FALSE,
2474: p_count => x_msg_count,
2475: p_data => x_msg_data
2476: );

Line 2482: FND_MSG_PUB.Count_And_Get (

2478: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2479: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2481: -- Standard call to get message count and if count=1, get the message
2482: FND_MSG_PUB.Count_And_Get (
2483: p_encoded => FND_API.G_FALSE,
2484: p_count => x_msg_count,
2485: p_data => x_msg_data
2486: );

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

2487:
2488: WHEN OTHERS THEN
2489: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2492: THEN
2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2494: END IF;
2495: -- Standard call to get message count and if count=1, get the message

Line 2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2489: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2491: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2492: THEN
2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2494: END IF;
2495: -- Standard call to get message count and if count=1, get the message
2496: FND_MSG_PUB.Count_And_Get (
2497: p_encoded => FND_API.G_FALSE,

Line 2496: FND_MSG_PUB.Count_And_Get (

2492: THEN
2493: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2494: END IF;
2495: -- Standard call to get message count and if count=1, get the message
2496: FND_MSG_PUB.Count_And_Get (
2497: p_encoded => FND_API.G_FALSE,
2498: p_count => x_msg_count,
2499: p_data => x_msg_data
2500: );

Line 2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2829:
2830: FETCH c_uom_code_exists INTO l_uom_code_exists;
2831:
2832: IF ( c_uom_code_exists%NOTFOUND) THEN
2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2834: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2835: FND_MSG_PUB.add;
2836: x_return_status := FND_API.G_RET_STS_ERROR;
2837: END IF;

Line 2835: FND_MSG_PUB.add;

2831:
2832: IF ( c_uom_code_exists%NOTFOUND) THEN
2833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2834: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2835: FND_MSG_PUB.add;
2836: x_return_status := FND_API.G_RET_STS_ERROR;
2837: END IF;
2838: END IF;
2839: CLOSE c_uom_code_exists;

Line 2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2850: l_uom_code.uom_code,
2851: to_number(p_vo_prod_rec.product_attr_value),
2852: l_list_header_id)
2853: THEN
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2856: FND_MSG_PUB.add;
2857: x_return_status := FND_API.G_RET_STS_ERROR;
2858: END IF;

Line 2856: FND_MSG_PUB.add;

2852: l_list_header_id)
2853: THEN
2854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2856: FND_MSG_PUB.add;
2857: x_return_status := FND_API.G_RET_STS_ERROR;
2858: END IF;
2859: END IF;
2860: ELSE

Line 2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2860: ELSE
2861: OPEN c_general_uom(l_uom_code.uom_code);
2862: FETCH c_general_uom INTO l_general_uom;
2863: IF ( c_general_uom%NOTFOUND) THEN
2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2865: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2866: FND_MSG_PUB.add;
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: END IF;

Line 2866: FND_MSG_PUB.add;

2862: FETCH c_general_uom INTO l_general_uom;
2863: IF ( c_general_uom%NOTFOUND) THEN
2864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2865: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2866: FND_MSG_PUB.add;
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: END IF;
2869: END IF;
2870: CLOSE c_general_uom;

Line 2941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2937: );
2938: If (l_context_flag = 'N' AND l_error_code = 7) -- invalid context
2939: Then
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2942: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );
2943: FND_MSG_PUB.add;
2944: END IF;
2945: End If;

Line 2943: FND_MSG_PUB.add;

2939: Then
2940: x_return_status := FND_API.G_RET_STS_ERROR;
2941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2942: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_CONTEXT' );
2943: FND_MSG_PUB.add;
2944: END IF;
2945: End If;
2946:
2947: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute

Line 2950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2946:
2947: If (l_attribute_flag = 'N' AND l_error_code = 8) -- invalid attribute
2948: Then
2949: x_return_status := FND_API.G_RET_STS_ERROR;
2950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2951: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
2952: FND_MSG_PUB.add;
2953: END IF;
2954: End If;

Line 2952: FND_MSG_PUB.add;

2948: Then
2949: x_return_status := FND_API.G_RET_STS_ERROR;
2950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2951: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_ATTR' );
2952: FND_MSG_PUB.add;
2953: END IF;
2954: End If;
2955:
2956: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value

Line 2959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2955:
2956: If (l_value_flag = 'N' AND l_error_code = 9) -- invalid value
2957: Then
2958: x_return_status := FND_API.G_RET_STS_ERROR;
2959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2960: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
2961: FND_MSG_PUB.add;
2962: END IF;
2963: End If;

Line 2961: FND_MSG_PUB.add;

2957: Then
2958: x_return_status := FND_API.G_RET_STS_ERROR;
2959: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2960: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_VALUE' );
2961: FND_MSG_PUB.add;
2962: END IF;
2963: End If;
2964:
2965:

Line 3208: FND_MSG_PUB.initialize;

3204: END IF;
3205: -- Initialize message list if p_init_msg_list is set to TRUE.
3206: IF FND_API.to_Boolean( p_init_msg_list )
3207: THEN
3208: FND_MSG_PUB.initialize;
3209: END IF;
3210:
3211: -- Debug Message
3212: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 3262: FND_MSG_PUB.Count_And_Get

3258: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
3259:
3260:
3261: -- Standard call to get message count and if count is 1, get message info.
3262: FND_MSG_PUB.Count_And_Get
3263: (p_count => x_msg_count,
3264: p_data => x_msg_data
3265: );
3266: EXCEPTION

Line 3276: FND_MSG_PUB.Count_And_Get (

3272: WHEN FND_API.G_EXC_ERROR THEN
3273: ROLLBACK TO Validate_vo_products_pvt;
3274: x_return_status := FND_API.G_RET_STS_ERROR;
3275: -- Standard call to get message count and if count=1, get the message
3276: FND_MSG_PUB.Count_And_Get (
3277: p_encoded => FND_API.G_FALSE,
3278: p_count => x_msg_count,
3279: p_data => x_msg_data
3280: );

Line 3286: FND_MSG_PUB.Count_And_Get (

3282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3283: ROLLBACK TO Validate_vo_products_pvt;
3284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3285: -- Standard call to get message count and if count=1, get the message
3286: FND_MSG_PUB.Count_And_Get (
3287: p_encoded => FND_API.G_FALSE,
3288: p_count => x_msg_count,
3289: p_data => x_msg_data
3290: );

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

3291:
3292: WHEN OTHERS THEN
3293: ROLLBACK TO Validate_vo_products_pvt;
3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3295: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3296: THEN
3297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3298: END IF;
3299: -- Standard call to get message count and if count=1, get the message

Line 3297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3293: ROLLBACK TO Validate_vo_products_pvt;
3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3295: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3296: THEN
3297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3298: END IF;
3299: -- Standard call to get message count and if count=1, get the message
3300: FND_MSG_PUB.Count_And_Get (
3301: p_encoded => FND_API.G_FALSE,

Line 3300: FND_MSG_PUB.Count_And_Get (

3296: THEN
3297: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3298: END IF;
3299: -- Standard call to get message count and if count=1, get the message
3300: FND_MSG_PUB.Count_And_Get (
3301: p_encoded => FND_API.G_FALSE,
3302: p_count => x_msg_count,
3303: p_data => x_msg_data
3304: );

Line 3386: FND_MSG_PUB.initialize;

3382:
3383: -- Initialize message list if p_init_msg_list is set to TRUE.
3384: IF FND_API.to_Boolean( p_init_msg_list )
3385: THEN
3386: FND_MSG_PUB.initialize;
3387: END IF;
3388:
3389: -- Debug Message
3390: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 3478: FND_MSG_PUB.Count_And_Get (

3474: WHEN FND_API.G_EXC_ERROR THEN
3475: ROLLBACK TO Create_vo_Product_pvt;
3476: x_return_status := FND_API.G_RET_STS_ERROR;
3477: -- Standard call to get message count and if count=1, get the message
3478: FND_MSG_PUB.Count_And_Get (
3479: p_encoded => FND_API.G_FALSE,
3480: p_count => x_msg_count,
3481: p_data => x_msg_data
3482: );

Line 3488: FND_MSG_PUB.Count_And_Get (

3484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3485: ROLLBACK TO Create_vo_Product_pvt;
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3487: -- Standard call to get message count and if count=1, get the message
3488: FND_MSG_PUB.Count_And_Get (
3489: p_encoded => FND_API.G_FALSE,
3490: p_count => x_msg_count,
3491: p_data => x_msg_data
3492: );

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

3493:
3494: WHEN OTHERS THEN
3495: ROLLBACK TO Create_vo_Product_pvt;
3496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3498: THEN
3499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3500: END IF;
3501: -- Standard call to get message count and if count=1, get the message

Line 3499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3495: ROLLBACK TO Create_vo_Product_pvt;
3496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3497: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3498: THEN
3499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3500: END IF;
3501: -- Standard call to get message count and if count=1, get the message
3502: FND_MSG_PUB.Count_And_Get (
3503: p_encoded => FND_API.G_FALSE,

Line 3502: FND_MSG_PUB.Count_And_Get (

3498: THEN
3499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3500: END IF;
3501: -- Standard call to get message count and if count=1, get the message
3502: FND_MSG_PUB.Count_And_Get (
3503: p_encoded => FND_API.G_FALSE,
3504: p_count => x_msg_count,
3505: p_data => x_msg_data
3506: );

Line 3586: FND_MSG_PUB.initialize;

3582: END IF;
3583: -- Initialize message list if p_init_msg_list is set to TRUE.
3584: IF FND_API.to_Boolean( p_init_msg_list )
3585: THEN
3586: FND_MSG_PUB.initialize;
3587: END IF;
3588: -- Debug Message
3589: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
3590:

Line 3675: FND_MSG_PUB.Count_And_Get

3671: END IF;
3672: -- Debug Message
3673: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'end');
3674: -- Standard call to get message count and if count is 1, get message info.
3675: FND_MSG_PUB.Count_And_Get
3676: (p_count => x_msg_count,
3677: p_data => x_msg_data
3678: );
3679: -- exception handling

Line 3690: FND_MSG_PUB.Count_And_Get (

3686: WHEN FND_API.G_EXC_ERROR THEN
3687: ROLLBACK TO update_vo_prod_pvt;
3688: x_return_status := FND_API.G_RET_STS_ERROR;
3689: -- Standard call to get message count and if count=1, get the message
3690: FND_MSG_PUB.Count_And_Get (
3691: p_encoded => FND_API.G_FALSE,
3692: p_count => x_msg_count,
3693: p_data => x_msg_data
3694: );

Line 3700: FND_MSG_PUB.Count_And_Get (

3696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3697: ROLLBACK TO update_vo_prod_pvt;
3698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3699: -- Standard call to get message count and if count=1, get the message
3700: FND_MSG_PUB.Count_And_Get (
3701: p_encoded => FND_API.G_FALSE,
3702: p_count => x_msg_count,
3703: p_data => x_msg_data
3704: );

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

3705:
3706: WHEN OTHERS THEN
3707: ROLLBACK TO update_vo_prod_pvt;
3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3709: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3710: THEN
3711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3712: END IF;
3713: -- Standard call to get message count and if count=1, get the message

Line 3711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3707: ROLLBACK TO update_vo_prod_pvt;
3708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3709: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3710: THEN
3711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3712: END IF;
3713: -- Standard call to get message count and if count=1, get the message
3714: FND_MSG_PUB.Count_And_Get (
3715: p_encoded => FND_API.G_FALSE,

Line 3714: FND_MSG_PUB.Count_And_Get (

3710: THEN
3711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3712: END IF;
3713: -- Standard call to get message count and if count=1, get the message
3714: FND_MSG_PUB.Count_And_Get (
3715: p_encoded => FND_API.G_FALSE,
3716: p_count => x_msg_count,
3717: p_data => x_msg_data
3718: );

Line 3787: FND_MSG_PUB.initialize;

3783:
3784: -- Initialize message list if p_init_msg_list is set to TRUE.
3785: IF FND_API.to_Boolean( p_init_msg_list )
3786: THEN
3787: FND_MSG_PUB.initialize;
3788: END IF;
3789:
3790: -- Initialize API return status to SUCCESS
3791: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3815: FND_MSG_PUB.Count_And_Get

3811: COMMIT WORK;
3812: END IF;
3813:
3814: -- Standard call to get message count and if count is 1, get message info.
3815: FND_MSG_PUB.Count_And_Get
3816: (p_count => x_msg_count,
3817: p_data => x_msg_data
3818: );
3819: EXCEPTION

Line 3829: FND_MSG_PUB.Count_And_Get (

3825: WHEN FND_API.G_EXC_ERROR THEN
3826: ROLLBACK TO Delete_vo_Product_PVT;
3827: x_return_status := FND_API.G_RET_STS_ERROR;
3828: -- Standard call to get message count and if count=1, get the message
3829: FND_MSG_PUB.Count_And_Get (
3830: p_encoded => FND_API.G_FALSE,
3831: p_count => x_msg_count,
3832: p_data => x_msg_data
3833: );

Line 3839: FND_MSG_PUB.Count_And_Get (

3835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3836: ROLLBACK TO Delete_vo_Product_PVT;
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: -- Standard call to get message count and if count=1, get the message
3839: FND_MSG_PUB.Count_And_Get (
3840: p_encoded => FND_API.G_FALSE,
3841: p_count => x_msg_count,
3842: p_data => x_msg_data
3843: );

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

3844:
3845: WHEN OTHERS THEN
3846: ROLLBACK TO Delete_vo_Product_PVT;
3847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3849: THEN
3850: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3851: END IF;
3852: -- Standard call to get message count and if count=1, get the message

Line 3850: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3846: ROLLBACK TO Delete_vo_Product_PVT;
3847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3848: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3849: THEN
3850: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3851: END IF;
3852: -- Standard call to get message count and if count=1, get the message
3853: FND_MSG_PUB.Count_And_Get (
3854: p_encoded => FND_API.G_FALSE,

Line 3853: FND_MSG_PUB.Count_And_Get (

3849: THEN
3850: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3851: END IF;
3852: -- Standard call to get message count and if count=1, get the message
3853: FND_MSG_PUB.Count_And_Get (
3854: p_encoded => FND_API.G_FALSE,
3855: p_count => x_msg_count,
3856: p_data => x_msg_data
3857: );