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 52: -- Standard begin of API savepoint

48: l_msg_data VARCHAR2(2000);
49: l_msg_count number;
50:
51: BEGIN
52: -- Standard begin of API savepoint
53: SAVEPOINT Validate_trans_PVT;
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call (
56: l_api_version,

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

50:
51: BEGIN
52: -- Standard begin of API savepoint
53: SAVEPOINT Validate_trans_PVT;
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call (
56: l_api_version,
57: p_api_version,
58: l_api_name,

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

140: -- Debug Message
141: IF OZF_DEBUG_LOW_ON THEN
142: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
143: END IF;
144: --Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data

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

150: EXCEPTION
151: WHEN FND_API.G_EXC_ERROR THEN
152: ROLLBACK TO Validate_trans_PVT;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: -- Standard call to get message count and if count=1, get the message
155: FND_MSG_PUB.Count_And_Get (
156: p_encoded => FND_API.G_FALSE,
157: p_count => x_msg_count,
158: p_data => x_msg_data

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

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

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

172: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
175: END IF;
176: -- Standard call to get message count and if count=1, get the message
177: FND_MSG_PUB.Count_And_Get (
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data

Line 249: -- Standard begin of API savepoint

245: l_rate NUMBER;
246: l_vol_offr_apply_discount NUMBER;
247: l_sales_trans NUMBER;
248: BEGIN
249: -- Standard begin of API savepoint
250: SAVEPOINT CREATE_TRANSACTION;
251: -- Standard call to check for call compatibility.
252: IF NOT FND_API.Compatible_API_Call (
253: l_api_version,

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

247: l_sales_trans NUMBER;
248: BEGIN
249: -- Standard begin of API savepoint
250: SAVEPOINT CREATE_TRANSACTION;
251: -- Standard call to check for call compatibility.
252: IF NOT FND_API.Compatible_API_Call (
253: l_api_version,
254: p_api_version,
255: l_api_name,

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

585: -- Debug Message
586: IF OZF_DEBUG_LOW_ON THEN
587: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
588: END IF;
589: --Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data

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

596: EXCEPTION
597: WHEN FND_API.G_EXC_ERROR THEN
598: ROLLBACK TO CREATE_TRANSACTION;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data

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

606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO CREATE_TRANSACTION;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609:
610: -- Standard call to get message count and if count=1, get the message
611: FND_MSG_PUB.Count_And_Get (
612: p_encoded => FND_API.G_FALSE,
613: p_count => x_msg_count,
614: p_data => x_msg_data

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

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

Line 669: -- Standard begin of API savepoint

665: FROM ozf_inventory_tmp_t;
666: l_total_primary_quantity NUMBER;
667: -- 6511302 end
668: BEGIN
669: -- Standard begin of API savepoint
670: SAVEPOINT INIT_INVEN_TMP;
671: -- Standard call to check for call compatibility.
672: IF NOT FND_API.Compatible_API_Call (
673: l_api_version,

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

667: -- 6511302 end
668: BEGIN
669: -- Standard begin of API savepoint
670: SAVEPOINT INIT_INVEN_TMP;
671: -- Standard call to check for call compatibility.
672: IF NOT FND_API.Compatible_API_Call (
673: l_api_version,
674: p_api_version,
675: l_api_name,

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

917: -- Debug Message
918: IF OZF_DEBUG_LOW_ON THEN
919: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
920: END IF;
921: --Standard call to get message count and if count=1, get the message
922: FND_MSG_PUB.Count_And_Get (
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,
925: p_data => x_msg_data

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

928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: ROLLBACK TO INIT_INVEN_TMP;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: -- Standard call to get message count and if count=1, get the message
933: FND_MSG_PUB.Count_And_Get (
934: p_encoded => FND_API.G_FALSE,
935: p_count => x_msg_count,
936: p_data => x_msg_data

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

938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: ROLLBACK TO INIT_INVEN_TMP;
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941:
942: -- Standard call to get message count and if count=1, get the message
943: FND_MSG_PUB.Count_And_Get (
944: p_encoded => FND_API.G_FALSE,
945: p_count => x_msg_count,
946: p_data => x_msg_data

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

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

Line 999: -- Standard begin of API savepoint

995: l_inventory_item_id number;
996: l_party_id number;
997:
998: BEGIN
999: -- Standard begin of API savepoint
1000: SAVEPOINT UPD_INVEN_TMP;
1001: -- Standard call to check for call compatibility.
1002: IF NOT FND_API.Compatible_API_Call (
1003: l_api_version,

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

997:
998: BEGIN
999: -- Standard begin of API savepoint
1000: SAVEPOINT UPD_INVEN_TMP;
1001: -- Standard call to check for call compatibility.
1002: IF NOT FND_API.Compatible_API_Call (
1003: l_api_version,
1004: p_api_version,
1005: l_api_name,

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

1039: -- Debug Message
1040: IF OZF_DEBUG_LOW_ON THEN
1041: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1042: END IF;
1043: --Standard call to get message count and if count=1, get the message
1044: FND_MSG_PUB.Count_And_Get (
1045: p_encoded => FND_API.G_FALSE,
1046: p_count => x_msg_count,
1047: p_data => x_msg_data

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

1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: ROLLBACK TO UPD_INVEN_TMP;
1053: x_return_status := FND_API.G_RET_STS_ERROR;
1054: -- Standard call to get message count and if count=1, get the message
1055: FND_MSG_PUB.Count_And_Get (
1056: p_encoded => FND_API.G_FALSE,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data

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

1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: ROLLBACK TO UPD_INVEN_TMP;
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063:
1064: -- Standard call to get message count and if count=1, get the message
1065: FND_MSG_PUB.Count_And_Get (
1066: p_encoded => FND_API.G_FALSE,
1067: p_count => x_msg_count,
1068: p_data => x_msg_data

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

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

Line 1164: -- Standard begin of API savepoint

1160: FROM ozf_inventory_tmp_t;
1161: l_total_primary_quantity NUMBER;
1162: -- 6511302 end
1163: BEGIN
1164: -- Standard begin of API savepoint
1165: SAVEPOINT VALID_INV_LVL;
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call (
1168: l_api_version,

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

1162: -- 6511302 end
1163: BEGIN
1164: -- Standard begin of API savepoint
1165: SAVEPOINT VALID_INV_LVL;
1166: -- Standard call to check for call compatibility.
1167: IF NOT FND_API.Compatible_API_Call (
1168: l_api_version,
1169: p_api_version,
1170: l_api_name,

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

1318: -- Debug Message
1319: IF OZF_DEBUG_LOW_ON THEN
1320: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1321: END IF;
1322: --Standard call to get message count and if count=1, get the message
1323: FND_MSG_PUB.Count_And_Get (
1324: p_encoded => FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data

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

1330: EXCEPTION
1331: WHEN FND_API.G_EXC_ERROR THEN
1332: ROLLBACK TO VALID_INV_LVL;
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: -- Standard call to get message count and if count=1, get the message
1335: FND_MSG_PUB.Count_And_Get (
1336: p_encoded => FND_API.G_FALSE,
1337: p_count => x_msg_count,
1338: p_data => x_msg_data

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

1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: ROLLBACK TO VALID_INV_LVL;
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343:
1344: -- Standard call to get message count and if count=1, get the message
1345: FND_MSG_PUB.Count_And_Get (
1346: p_encoded => FND_API.G_FALSE,
1347: p_count => x_msg_count,
1348: p_data => x_msg_data

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

1350: WHEN OTHERS THEN
1351: ROLLBACK TO VALID_INV_LVL;
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353:
1354: -- Standard call to get message count and if count=1, get the message
1355: FND_MSG_PUB.Count_And_Get (
1356: p_encoded => FND_API.G_FALSE,
1357: p_count => x_msg_count,
1358: p_data => x_msg_data

Line 1441: -- Standard begin of API savepoint

1437: AND a.transaction_date< p_order_date
1438: ORDER BY a.transaction_date DESC;
1439:
1440: BEGIN
1441: -- Standard begin of API savepoint
1442: SAVEPOINT GET_WAC;
1443: -- Standard call to check for call compatibility.
1444: IF NOT FND_API.Compatible_API_Call (
1445: l_api_version,

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

1439:
1440: BEGIN
1441: -- Standard begin of API savepoint
1442: SAVEPOINT GET_WAC;
1443: -- Standard call to check for call compatibility.
1444: IF NOT FND_API.Compatible_API_Call (
1445: l_api_version,
1446: p_api_version,
1447: l_api_name,

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

1577: -- Debug Message
1578: IF OZF_DEBUG_LOW_ON THEN
1579: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1580: END IF;
1581: --Standard call to get message count and if count=1, get the message
1582: FND_MSG_PUB.Count_And_Get (
1583: p_encoded => FND_API.G_FALSE,
1584: p_count => x_msg_count,
1585: p_data => x_msg_data

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

1589: EXCEPTION
1590: WHEN FND_API.G_EXC_ERROR THEN
1591: ROLLBACK TO GET_WAC;
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: -- Standard call to get message count and if count=1, get the message
1594: FND_MSG_PUB.Count_And_Get (
1595: p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data

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

1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO GET_WAC;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602:
1603: -- Standard call to get message count and if count=1, get the message
1604: FND_MSG_PUB.Count_And_Get (
1605: p_encoded => FND_API.G_FALSE,
1606: p_count => x_msg_count,
1607: p_data => x_msg_data

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

1609: WHEN OTHERS THEN
1610: ROLLBACK TO GET_WAC;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612:
1613: -- Standard call to get message count and if count=1, get the message
1614: FND_MSG_PUB.Count_And_Get (
1615: p_encoded => FND_API.G_FALSE,
1616: p_count => x_msg_count,
1617: p_data => x_msg_data