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_DISC_LINE_PVT dependencies on OZF_DISC_LINE_PVT

Line 1: PACKAGE BODY OZF_Disc_Line_PVT as

1: PACKAGE BODY OZF_Disc_Line_PVT as
2: /* $Header: ozfvodlb.pls 120.4.12020000.2 2012/12/28 08:22:42 apyadav ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_Disc_Line_PVT

2: /* $Header: ozfvodlb.pls 120.4.12020000.2 2012/12/28 08:22:42 apyadav ship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_Disc_Line_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';

28: -- Wed Oct 26 2005:5/47 PM RSSHARMA Fixed bug # 4673434. Disable duplicate validation exclusions
29: -- Thu Apr 06 2006:4/41 PM RSSHARMA Fixed bug # 5142859. Added Null Currency validation. DOnt allow amount discount if currency is null
30: -- Fri Dec 28 2012 APYADAV Bug 14113514 - DESCRIPTIVE FLEXFIELD FOR NET ACCRUAL OFFER DISCOUNT LINES NOT SAVING
31: -- ===============================================================
32: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
33: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
34: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
35: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
36: --

Line 155: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;

151: x_return_status := FND_API.g_ret_sts_error;
152: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
153:
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: -- Standard call to get message count and if count=1, get the message
158: FND_MSG_PUB.Count_And_Get (
159: p_encoded => FND_API.G_FALSE,

Line 165: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;

161: p_data => x_msg_data
162: );
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: -- Standard call to get message count and if count=1, get the message
168: FND_MSG_PUB.Count_And_Get (
169: p_encoded => FND_API.G_FALSE,

Line 175: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;

171: p_data => x_msg_data
172: );
173:
174: WHEN OTHERS THEN
175: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 972: SAVEPOINT create_ozf_disc_line_pvt;

968: FROM OZF_OFFER_DISCOUNT_LINES
969: WHERE offer_discount_line_id = l_id;
970: BEGIN
971: -- Standard Start of API savepoint
972: SAVEPOINT create_ozf_disc_line_pvt;
973:
974: -- Standard call to check for call compatibility.
975: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
976: p_api_version_number,

Line 1134: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;

1130: x_return_status := FND_API.g_ret_sts_error;
1131: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1132:
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: -- Standard call to get message count and if count=1, get the message
1137: FND_MSG_PUB.Count_And_Get (
1138: p_encoded => FND_API.G_FALSE,

Line 1144: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;

1140: p_data => x_msg_data
1141: );
1142:
1143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1144: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: -- Standard call to get message count and if count=1, get the message
1147: FND_MSG_PUB.Count_And_Get (
1148: p_encoded => FND_API.G_FALSE,

Line 1154: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;

1150: p_data => x_msg_data
1151: );
1152:
1153: WHEN OTHERS THEN
1154: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1157: THEN
1158: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1236: SAVEPOINT update_ozf_disc_line_pvt;

1232: l_rowid ROWID;
1233:
1234: BEGIN
1235: -- Standard Start of API savepoint
1236: SAVEPOINT update_ozf_disc_line_pvt;
1237:
1238: -- Standard call to check for call compatibility.
1239: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1240: p_api_version_number,

Line 1392: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;

1388: x_return_status := FND_API.g_ret_sts_error;
1389: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1390:
1391: WHEN FND_API.G_EXC_ERROR THEN
1392: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1393: x_return_status := FND_API.G_RET_STS_ERROR;
1394: -- Standard call to get message count and if count=1, get the message
1395: FND_MSG_PUB.Count_And_Get (
1396: p_encoded => FND_API.G_FALSE,

Line 1402: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;

1398: p_data => x_msg_data
1399: );
1400:
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: -- Standard call to get message count and if count=1, get the message
1405: FND_MSG_PUB.Count_And_Get (
1406: p_encoded => FND_API.G_FALSE,

Line 1412: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;

1408: p_data => x_msg_data
1409: );
1410:
1411: WHEN OTHERS THEN
1412: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;
1413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1414: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1415: THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1480: SAVEPOINT delete_ozf_disc_line_pvt;

1476: l_object_version_number NUMBER;
1477:
1478: BEGIN
1479: -- Standard Start of API savepoint
1480: SAVEPOINT delete_ozf_disc_line_pvt;
1481:
1482: -- Standard call to check for call compatibility.
1483: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1484: p_api_version_number,

Line 1545: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;

1541: x_return_status := FND_API.g_ret_sts_error;
1542: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1543:
1544: WHEN FND_API.G_EXC_ERROR THEN
1545: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: -- Standard call to get message count and if count=1, get the message
1548: FND_MSG_PUB.Count_And_Get (
1549: p_encoded => FND_API.G_FALSE,

Line 1555: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;

1551: p_data => x_msg_data
1552: );
1553:
1554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1555: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: -- Standard call to get message count and if count=1, get the message
1558: FND_MSG_PUB.Count_And_Get (
1559: p_encoded => FND_API.G_FALSE,

Line 1565: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;

1561: p_data => x_msg_data
1562: );
1563:
1564: WHEN OTHERS THEN
1565: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1568: THEN
1569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 7048: END OZF_Disc_Line_PVT;

7044: );
7045: END Delete_Tier_line;
7046:
7047: --=================End Complete Methods ==================================================
7048: END OZF_Disc_Line_PVT;