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 2006/05/04 15:25:35 julou noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- OZF_Disc_Line_PVT

2: /* $Header: ozfvodlb.pls 120.4 2006/05/04 15:25:35 julou noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- OZF_Disc_Line_PVT
7: -- Purpose
8: --
9: -- History
10: --

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

27: -- Thu Feb 26 2004:12/3 PM RSSHARMA Fixed bug # 3468608.Default Excluder_flag to N if not passed in
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: -- ===============================================================
31: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Disc_Line_PVT';
32: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvodlb.pls';
33: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
34: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
35: --

Line 154: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;

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

Line 164: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;

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

Line 174: ROLLBACK TO LOCK_Ozf_Disc_Line_PVT;

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

Line 971: SAVEPOINT create_ozf_disc_line_pvt;

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

Line 1133: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;

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

Line 1143: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;

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

Line 1153: ROLLBACK TO CREATE_Ozf_Disc_Line_PVT;

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

Line 1235: SAVEPOINT update_ozf_disc_line_pvt;

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

Line 1391: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;

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

Line 1401: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;

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

Line 1411: ROLLBACK TO UPDATE_Ozf_Disc_Line_PVT;

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

Line 1479: SAVEPOINT delete_ozf_disc_line_pvt;

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

Line 1544: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;

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

Line 1554: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;

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

Line 1564: ROLLBACK TO DELETE_Ozf_Disc_Line_PVT;

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

Line 7011: END OZF_Disc_Line_PVT;

7007: );
7008: END Delete_Tier_line;
7009:
7010: --=================End Complete Methods ==================================================
7011: END OZF_Disc_Line_PVT;