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_SALES_TRANSACTIONS_PVT dependencies on STANDARD

Line 61: -- Standard begin of API savepoint

57: WHERE line_id = p_line_id;
58:
59: l_ship_to_site_use_id NUMBER;
60: BEGIN
61: -- Standard begin of API savepoint
62: SAVEPOINT Validate_trans_PVT;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (
65: l_api_version,

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

59: l_ship_to_site_use_id NUMBER;
60: BEGIN
61: -- Standard begin of API savepoint
62: SAVEPOINT Validate_trans_PVT;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (
65: l_api_version,
66: p_api_version,
67: l_api_name,

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

158: -- Debug Message
159: IF OZF_DEBUG_LOW_ON THEN
160: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
161: END IF;
162: --Standard call to get message count and if count=1, get the message
163: FND_MSG_PUB.Count_And_Get (
164: p_encoded => FND_API.G_FALSE,
165: p_count => x_msg_count,
166: p_data => x_msg_data

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

168: EXCEPTION
169: WHEN FND_API.G_EXC_ERROR THEN
170: ROLLBACK TO Validate_trans_PVT;
171: x_return_status := FND_API.G_RET_STS_ERROR;
172: -- Standard call to get message count and if count=1, get the message
173: FND_MSG_PUB.Count_And_Get (
174: p_encoded => FND_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data

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

177: );
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO Validate_trans_PVT;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: -- Standard call to get message count and if count=1, get the message
182: FND_MSG_PUB.Count_And_Get (
183: p_encoded => FND_API.G_FALSE,
184: p_count => x_msg_count,
185: p_data => x_msg_data

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

190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
193: END IF;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data

Line 267: -- Standard begin of API savepoint

263: l_rate NUMBER;
264: l_vol_offr_apply_discount NUMBER;
265: l_sales_trans NUMBER;
266: BEGIN
267: -- Standard begin of API savepoint
268: SAVEPOINT CREATE_TRANSACTION;
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (
271: l_api_version,

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

265: l_sales_trans NUMBER;
266: BEGIN
267: -- Standard begin of API savepoint
268: SAVEPOINT CREATE_TRANSACTION;
269: -- Standard call to check for call compatibility.
270: IF NOT FND_API.Compatible_API_Call (
271: l_api_version,
272: p_api_version,
273: l_api_name,

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

603: -- Debug Message
604: IF OZF_DEBUG_LOW_ON THEN
605: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
606: END IF;
607: --Standard call to get message count and if count=1, get the message
608: FND_MSG_PUB.Count_And_Get (
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data

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

614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO CREATE_TRANSACTION;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data

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

624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: ROLLBACK TO CREATE_TRANSACTION;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627:
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data

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

634: WHEN OTHERS THEN
635: ROLLBACK TO CREATE_TRANSACTION;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637:
638: -- Standard call to get message count and if count=1, get the message
639: FND_MSG_PUB.Count_And_Get (
640: p_encoded => FND_API.G_FALSE,
641: p_count => x_msg_count,
642: p_data => x_msg_data

Line 687: -- Standard begin of API savepoint

683: FROM ozf_inventory_tmp_t;
684: l_total_primary_quantity NUMBER;
685: -- 6511302 end
686: BEGIN
687: -- Standard begin of API savepoint
688: SAVEPOINT INIT_INVEN_TMP;
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call (
691: l_api_version,

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

685: -- 6511302 end
686: BEGIN
687: -- Standard begin of API savepoint
688: SAVEPOINT INIT_INVEN_TMP;
689: -- Standard call to check for call compatibility.
690: IF NOT FND_API.Compatible_API_Call (
691: l_api_version,
692: p_api_version,
693: l_api_name,

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

935: -- Debug Message
936: IF OZF_DEBUG_LOW_ON THEN
937: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
938: END IF;
939: --Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count,
943: p_data => x_msg_data

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

946: EXCEPTION
947: WHEN FND_API.G_EXC_ERROR THEN
948: ROLLBACK TO INIT_INVEN_TMP;
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: -- Standard call to get message count and if count=1, get the message
951: FND_MSG_PUB.Count_And_Get (
952: p_encoded => FND_API.G_FALSE,
953: p_count => x_msg_count,
954: p_data => x_msg_data

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

956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: ROLLBACK TO INIT_INVEN_TMP;
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: -- Standard call to get message count and if count=1, get the message
961: FND_MSG_PUB.Count_And_Get (
962: p_encoded => FND_API.G_FALSE,
963: p_count => x_msg_count,
964: p_data => x_msg_data

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

966: WHEN OTHERS THEN
967: ROLLBACK TO INIT_INVEN_TMP;
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: -- Standard call to get message count and if count=1, get the message
971: FND_MSG_PUB.Count_And_Get (
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,
974: p_data => x_msg_data

Line 1017: -- Standard begin of API savepoint

1013: l_inventory_item_id number;
1014: l_party_id number;
1015:
1016: BEGIN
1017: -- Standard begin of API savepoint
1018: SAVEPOINT UPD_INVEN_TMP;
1019: -- Standard call to check for call compatibility.
1020: IF NOT FND_API.Compatible_API_Call (
1021: l_api_version,

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

1015:
1016: BEGIN
1017: -- Standard begin of API savepoint
1018: SAVEPOINT UPD_INVEN_TMP;
1019: -- Standard call to check for call compatibility.
1020: IF NOT FND_API.Compatible_API_Call (
1021: l_api_version,
1022: p_api_version,
1023: l_api_name,

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

1057: -- Debug Message
1058: IF OZF_DEBUG_LOW_ON THEN
1059: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1060: END IF;
1061: --Standard call to get message count and if count=1, get the message
1062: FND_MSG_PUB.Count_And_Get (
1063: p_encoded => FND_API.G_FALSE,
1064: p_count => x_msg_count,
1065: p_data => x_msg_data

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

1068: EXCEPTION
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: ROLLBACK TO UPD_INVEN_TMP;
1071: x_return_status := FND_API.G_RET_STS_ERROR;
1072: -- Standard call to get message count and if count=1, get the message
1073: FND_MSG_PUB.Count_And_Get (
1074: p_encoded => FND_API.G_FALSE,
1075: p_count => x_msg_count,
1076: p_data => x_msg_data

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

1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079: ROLLBACK TO UPD_INVEN_TMP;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081:
1082: -- Standard call to get message count and if count=1, get the message
1083: FND_MSG_PUB.Count_And_Get (
1084: p_encoded => FND_API.G_FALSE,
1085: p_count => x_msg_count,
1086: p_data => x_msg_data

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

1088: WHEN OTHERS THEN
1089: ROLLBACK TO UPD_INVEN_TMP;
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1091:
1092: -- Standard call to get message count and if count=1, get the message
1093: FND_MSG_PUB.Count_And_Get (
1094: p_encoded => FND_API.G_FALSE,
1095: p_count => x_msg_count,
1096: p_data => x_msg_data

Line 1182: -- Standard begin of API savepoint

1178: FROM ozf_inventory_tmp_t;
1179: l_total_primary_quantity NUMBER;
1180: -- 6511302 end
1181: BEGIN
1182: -- Standard begin of API savepoint
1183: SAVEPOINT VALID_INV_LVL;
1184: -- Standard call to check for call compatibility.
1185: IF NOT FND_API.Compatible_API_Call (
1186: l_api_version,

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

1180: -- 6511302 end
1181: BEGIN
1182: -- Standard begin of API savepoint
1183: SAVEPOINT VALID_INV_LVL;
1184: -- Standard call to check for call compatibility.
1185: IF NOT FND_API.Compatible_API_Call (
1186: l_api_version,
1187: p_api_version,
1188: l_api_name,

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

1342: -- Debug Message
1343: IF OZF_DEBUG_LOW_ON THEN
1344: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1345: END IF;
1346: --Standard call to get message count and if count=1, get the message
1347: FND_MSG_PUB.Count_And_Get (
1348: p_encoded => FND_API.G_FALSE,
1349: p_count => x_msg_count,
1350: p_data => x_msg_data

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

1354: EXCEPTION
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO VALID_INV_LVL;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: -- Standard call to get message count and if count=1, get the message
1359: FND_MSG_PUB.Count_And_Get (
1360: p_encoded => FND_API.G_FALSE,
1361: p_count => x_msg_count,
1362: p_data => x_msg_data

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

1364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1365: ROLLBACK TO VALID_INV_LVL;
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1367:
1368: -- Standard call to get message count and if count=1, get the message
1369: FND_MSG_PUB.Count_And_Get (
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,
1372: p_data => x_msg_data

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

1374: WHEN OTHERS THEN
1375: ROLLBACK TO VALID_INV_LVL;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377:
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data

Line 1465: -- Standard begin of API savepoint

1461: AND a.transaction_date< p_order_date
1462: ORDER BY a.transaction_date DESC;
1463:
1464: BEGIN
1465: -- Standard begin of API savepoint
1466: SAVEPOINT GET_WAC;
1467: -- Standard call to check for call compatibility.
1468: IF NOT FND_API.Compatible_API_Call (
1469: l_api_version,

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

1463:
1464: BEGIN
1465: -- Standard begin of API savepoint
1466: SAVEPOINT GET_WAC;
1467: -- Standard call to check for call compatibility.
1468: IF NOT FND_API.Compatible_API_Call (
1469: l_api_version,
1470: p_api_version,
1471: l_api_name,

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

1601: -- Debug Message
1602: IF OZF_DEBUG_LOW_ON THEN
1603: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1604: END IF;
1605: --Standard call to get message count and if count=1, get the message
1606: FND_MSG_PUB.Count_And_Get (
1607: p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data

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

1613: EXCEPTION
1614: WHEN FND_API.G_EXC_ERROR THEN
1615: ROLLBACK TO GET_WAC;
1616: x_return_status := FND_API.G_RET_STS_ERROR;
1617: -- Standard call to get message count and if count=1, get the message
1618: FND_MSG_PUB.Count_And_Get (
1619: p_encoded => FND_API.G_FALSE,
1620: p_count => x_msg_count,
1621: p_data => x_msg_data

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

1623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1624: ROLLBACK TO GET_WAC;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626:
1627: -- Standard call to get message count and if count=1, get the message
1628: FND_MSG_PUB.Count_And_Get (
1629: p_encoded => FND_API.G_FALSE,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data

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

1633: WHEN OTHERS THEN
1634: ROLLBACK TO GET_WAC;
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1636:
1637: -- Standard call to get message count and if count=1, get the message
1638: FND_MSG_PUB.Count_And_Get (
1639: p_encoded => FND_API.G_FALSE,
1640: p_count => x_msg_count,
1641: p_data => x_msg_data