DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_DISC_PVT dependencies on STANDARD

Line 1350: -- Standard call to get message count and if count is 1, get message info.

1346: -- x_return_status := FND_API.G_RET_STS_ERROR;
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: );

Line 1405: -- Standard Start of API savepoint

1401: l_api_version_number CONSTANT NUMBER := 1.0;
1402: l_object_version_number NUMBER;
1403: l_vo_disc_rec vo_disc_rec_type;
1404: BEGIN
1405: -- Standard Start of API savepoint
1406: SAVEPOINT Validate_vo_discounts_pvt;
1407:
1408: -- Standard call to check for call compatibility.
1409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1408: -- Standard call to check for call compatibility.

1404: BEGIN
1405: -- Standard Start of API savepoint
1406: SAVEPOINT Validate_vo_discounts_pvt;
1407:
1408: -- Standard call to check for call compatibility.
1409: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1410: p_api_version_number,
1411: l_api_name,
1412: G_PKG_NAME)

Line 1475: -- Standard call to get message count and if count is 1, get message info.

1471: -- Debug Message
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: );

Line 1489: -- Standard call to get message count and if count=1, get the message

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

Line 1499: -- Standard call to get message count and if count=1, get the message

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

Line 1513: -- Standard call to get message count and if count=1, get the message

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,
1516: p_count => x_msg_count,
1517: p_data => x_msg_data

Line 1579: -- Standard Start of API savepoint

1575: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1576: l_object_version_number NUMBER;
1577: l_offr_disc_struct_name_id NUMBER;
1578: BEGIN
1579: -- Standard Start of API savepoint
1580: SAVEPOINT Delete_vo_discount_PVT;
1581:
1582: -- Standard call to check for call compatibility.
1583: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1582: -- Standard call to check for call compatibility.

1578: BEGIN
1579: -- Standard Start of API savepoint
1580: SAVEPOINT Delete_vo_discount_PVT;
1581:
1582: -- Standard call to check for call compatibility.
1583: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1584: p_api_version_number,
1585: l_api_name,
1586: G_PKG_NAME)

Line 1653: -- Standard check for p_commit

1649: --
1650: -- End of API body
1651: --
1652:
1653: -- Standard check for p_commit
1654: IF FND_API.to_Boolean( p_commit )
1655: THEN
1656: COMMIT WORK;
1657: END IF;

Line 1659: -- Standard call to get message count and if count is 1, get message info.

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

Line 1673: -- Standard call to get message count and if count=1, get the message

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

Line 1683: -- Standard call to get message count and if count=1, get the message

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

Line 1698: -- Standard call to get message count and if count=1, get the message

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,
1701: p_count => x_msg_count,
1702: p_data => x_msg_data

Line 1783: -- Standard call to check for call compatibility.

1779: BEGIN
1780:
1781: SAVEPOINT copy_vo_discounts_pvt;
1782:
1783: -- Standard call to check for call compatibility.
1784: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1785: p_api_version_number,
1786: l_api_name,
1787: G_PKG_NAME)

Line 1918: -- Standard call to get message count and if count=1, get the message

1914: EXCEPTION
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

Line 1928: -- Standard call to get message count and if count=1, get the message

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

Line 1942: -- Standard call to get message count and if count=1, get the message

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,
1945: p_count => x_msg_count,
1946: p_data => x_msg_data

Line 2024: -- Standard Start of API savepoint

2020: l_offr_disc_struct_name_id NUMBER;
2021: l_struct_dummy NUMBER;
2022: BEGIN
2023: --initialize
2024: -- Standard Start of API savepoint
2025: SAVEPOINT Create_vo_discount_pvt;
2026:
2027: -- Standard call to check for call compatibility.
2028: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2027: -- Standard call to check for call compatibility.

2023: --initialize
2024: -- Standard Start of API savepoint
2025: SAVEPOINT Create_vo_discount_pvt;
2026:
2027: -- Standard call to check for call compatibility.
2028: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2029: p_api_version_number,
2030: l_api_name,
2031: G_PKG_NAME)

Line 2198: -- Standard check for p_commit

2194: END IF;
2195: --
2196: -- End of API body
2197: --
2198: -- Standard check for p_commit
2199: IF FND_API.to_Boolean( p_commit )
2200: THEN
2201: COMMIT WORK;
2202: END IF;

Line 2205: -- Standard call to get message count and if count is 1, get message info.

2201: COMMIT WORK;
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: );

Line 2214: -- Standard call to get message count and if count=1, get the message

2210: EXCEPTION
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

Line 2224: -- Standard call to get message count and if count=1, get the message

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

Line 2238: -- Standard call to get message count and if count=1, get the message

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,
2241: p_count => x_msg_count,
2242: p_data => x_msg_data

Line 2310: -- Standard Start of API savepoint

2306: l_offr_disc_struct_name_id NUMBER;
2307: l_tier_type OZF_OFFER_DISCOUNT_LINES.TIER_TYPE%TYPE;
2308: BEGIN
2309: --initialize
2310: -- Standard Start of API savepoint
2311: SAVEPOINT update_ozf_disc_line_pvt;
2312: -- Standard call to check for call compatibility.
2313: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2314: p_api_version_number,

Line 2312: -- Standard call to check for call compatibility.

2308: BEGIN
2309: --initialize
2310: -- Standard Start of API savepoint
2311: SAVEPOINT update_ozf_disc_line_pvt;
2312: -- Standard call to check for call compatibility.
2313: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2314: p_api_version_number,
2315: l_api_name,
2316: G_PKG_NAME)

Line 2449: -- Standard check for p_commit

2445: END IF;
2446: --
2447: -- End of API body.
2448: --
2449: -- Standard check for p_commit
2450: IF FND_API.to_Boolean( p_commit )
2451: THEN
2452: COMMIT WORK;
2453: END IF;

Line 2456: -- Standard call to get message count and if count is 1, get message info.

2452: COMMIT WORK;
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: );

Line 2471: -- Standard call to get message count and if count=1, get the message

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

Line 2481: -- Standard call to get message count and if count=1, get the message

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

Line 2495: -- Standard call to get message count and if count=1, get the message

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,
2498: p_count => x_msg_count,
2499: p_data => x_msg_data

Line 3194: -- Standard Start of API savepoint

3190: l_api_version_number CONSTANT NUMBER := 1.0;
3191: l_object_version_number NUMBER;
3192: l_vo_prod_rec vo_prod_rec_type;
3193: BEGIN
3194: -- Standard Start of API savepoint
3195: SAVEPOINT Validate_vo_products_pvt;
3196:
3197: -- Standard call to check for call compatibility.
3198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3197: -- Standard call to check for call compatibility.

3193: BEGIN
3194: -- Standard Start of API savepoint
3195: SAVEPOINT Validate_vo_products_pvt;
3196:
3197: -- Standard call to check for call compatibility.
3198: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3199: p_api_version_number,
3200: l_api_name,
3201: G_PKG_NAME)

Line 3261: -- Standard call to get message count and if count is 1, get message info.

3257: -- Debug Message
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: );

Line 3275: -- Standard call to get message count and if count=1, get the message

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

Line 3285: -- Standard call to get message count and if count=1, get the message

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

Line 3299: -- Standard call to get message count and if count=1, get the message

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,
3302: p_count => x_msg_count,
3303: p_data => x_msg_data

Line 3374: -- Standard call to check for call compatibility.

3370: --initialize
3371:
3372: SAVEPOINT Create_vo_Product_pvt;
3373:
3374: -- Standard call to check for call compatibility.
3375: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3376: p_api_version_number,
3377: l_api_name,
3378: G_PKG_NAME)

Line 3477: -- Standard call to get message count and if count=1, get the message

3473: EXCEPTION
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

Line 3487: -- Standard call to get message count and if count=1, get the message

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

Line 3501: -- Standard call to get message count and if count=1, get the message

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,
3504: p_count => x_msg_count,
3505: p_data => x_msg_data

Line 3573: -- Standard Start of API savepoint

3569: l_rowid ROWID;
3570:
3571: BEGIN
3572: -- iniialize
3573: -- Standard Start of API savepoint
3574: SAVEPOINT update_vo_prod_pvt;
3575: -- Standard call to check for call compatibility.
3576: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3577: p_api_version_number,

Line 3575: -- Standard call to check for call compatibility.

3571: BEGIN
3572: -- iniialize
3573: -- Standard Start of API savepoint
3574: SAVEPOINT update_vo_prod_pvt;
3575: -- Standard call to check for call compatibility.
3576: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3577: p_api_version_number,
3578: l_api_name,
3579: G_PKG_NAME)

Line 3667: -- Standard check for p_commit

3663: );
3664: --
3665: -- End of API body.
3666: --
3667: -- Standard check for p_commit
3668: IF FND_API.to_Boolean( p_commit )
3669: THEN
3670: COMMIT WORK;
3671: END IF;

Line 3674: -- Standard call to get message count and if count is 1, get message info.

3670: COMMIT WORK;
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: );

Line 3689: -- Standard call to get message count and if count=1, get the message

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

Line 3699: -- Standard call to get message count and if count=1, get the message

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

Line 3713: -- Standard call to get message count and if count=1, get the message

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,
3716: p_count => x_msg_count,
3717: p_data => x_msg_data

Line 3772: -- Standard Start of API savepoint

3768: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_vo_Product';
3769: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
3770: l_object_version_number NUMBER;
3771: BEGIN
3772: -- Standard Start of API savepoint
3773: SAVEPOINT Delete_vo_Product_PVT;
3774:
3775: -- Standard call to check for call compatibility.
3776: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3775: -- Standard call to check for call compatibility.

3771: BEGIN
3772: -- Standard Start of API savepoint
3773: SAVEPOINT Delete_vo_Product_PVT;
3774:
3775: -- Standard call to check for call compatibility.
3776: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3777: p_api_version_number,
3778: l_api_name,
3779: G_PKG_NAME)

Line 3808: -- Standard check for p_commit

3804: --
3805: -- End of API body
3806: --
3807:
3808: -- Standard check for p_commit
3809: IF FND_API.to_Boolean( p_commit )
3810: THEN
3811: COMMIT WORK;
3812: END IF;

Line 3814: -- Standard call to get message count and if count is 1, get message info.

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

Line 3828: -- Standard call to get message count and if count=1, get the message

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

Line 3838: -- Standard call to get message count and if count=1, get the message

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

Line 3852: -- Standard call to get message count and if count=1, get the message

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,
3855: p_count => x_msg_count,
3856: p_data => x_msg_data