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

Line 119: -- Standard Start of API savepoint

115: l_start_date DATE;
116: l_end_date DATE;
117:
118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT CREATE_Offers_PVT;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

118: BEGIN
119: -- Standard Start of API savepoint
120: SAVEPOINT CREATE_Offers_PVT;
121:
122: -- Standard call to check for call compatibility.
123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
124: p_api_version_number,
125: l_api_name,
126: G_PKG_NAME)

Line 353: -- Standard check for p_commit

349: --
350: -- End of API body
351: --
352:
353: -- Standard check for p_commit
354: IF FND_API.to_Boolean( p_commit )
355: THEN
356: COMMIT WORK;
357: END IF;

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

355: THEN
356: COMMIT WORK;
357: END IF;
358:
359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get
361: (p_count => x_msg_count,
362: p_data => x_msg_data
363: );

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

369:
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO CREATE_Offers_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: -- Standard call to get message count and if count=1, get the message
374: FND_MSG_PUB.Count_And_Get (
375: p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data

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

379:
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO CREATE_Offers_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data

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

393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
394: THEN
395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
396: END IF;
397: -- Standard call to get message count and if count=1, get the message
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data

Line 745: -- Standard Start of API savepoint

741: l_start_date_o DATE;
742: l_start_date DATE;
743:
744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT UPDATE_Offers_PVT;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

744: BEGIN
745: -- Standard Start of API savepoint
746: SAVEPOINT UPDATE_Offers_PVT;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
750: p_api_version_number,
751: l_api_name,
752: G_PKG_NAME)

Line 930: -- Standard check for p_commit

926: --
927: -- End of API body.
928: --
929:
930: -- Standard check for p_commit
931: IF FND_API.to_Boolean( p_commit )
932: THEN
933: COMMIT WORK;
934: END IF;

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

932: THEN
933: COMMIT WORK;
934: END IF;
935:
936: -- Standard call to get message count and if count is 1, get message info.
937: FND_MSG_PUB.Count_And_Get
938: (p_count => x_msg_count,
939: p_data => x_msg_data,
940: p_encoded => FND_API.G_FALSE

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

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

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

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

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

971: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
974: END IF;
975: -- Standard call to get message count and if count=1, get the message
976: FND_MSG_PUB.Count_And_Get (
977: p_encoded => FND_API.G_FALSE,
978: p_count => x_msg_count,
979: p_data => x_msg_data

Line 1003: -- Standard Start of API savepoint

999: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1000: l_object_version_number NUMBER;
1001:
1002: BEGIN
1003: -- Standard Start of API savepoint
1004: SAVEPOINT DELETE_Offers_PVT;
1005:
1006: -- Standard call to check for call compatibility.
1007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1002: BEGIN
1003: -- Standard Start of API savepoint
1004: SAVEPOINT DELETE_Offers_PVT;
1005:
1006: -- Standard call to check for call compatibility.
1007: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1008: p_api_version_number,
1009: l_api_name,
1010: G_PKG_NAME)

Line 1035: -- Standard check for p_commit

1031: --
1032: -- End of API body
1033: --
1034:
1035: -- Standard check for p_commit
1036: IF FND_API.to_Boolean( p_commit )
1037: THEN
1038: COMMIT WORK;
1039: END IF;

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

1037: THEN
1038: COMMIT WORK;
1039: END IF;
1040:
1041: -- Standard call to get message count and if count is 1, get message info.
1042: FND_MSG_PUB.Count_And_Get
1043: (p_count => x_msg_count,
1044: p_data => x_msg_data
1045: );

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

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

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

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

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

1075: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1076: THEN
1077: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1078: END IF;
1079: -- Standard call to get message count and if count=1, get the message
1080: FND_MSG_PUB.Count_And_Get (
1081: p_encoded => FND_API.G_FALSE,
1082: p_count => x_msg_count,
1083: p_data => x_msg_data

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

1119: THEN
1120: FND_MSG_PUB.initialize;
1121: END IF;
1122:
1123: -- Standard call to check for call compatibility.
1124: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1125: p_api_version_number,
1126: l_api_name,
1127: G_PKG_NAME)

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

1165:
1166: WHEN FND_API.G_EXC_ERROR THEN
1167: ROLLBACK TO LOCK_Offers_PVT;
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data

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

1175:
1176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1177: ROLLBACK TO LOCK_Offers_PVT;
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: -- Standard call to get message count and if count=1, get the message
1180: FND_MSG_PUB.Count_And_Get (
1181: p_encoded => FND_API.G_FALSE,
1182: p_count => x_msg_count,
1183: p_data => x_msg_data

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

1189: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1192: END IF;
1193: -- Standard call to get message count and if count=1, get the message
1194: FND_MSG_PUB.Count_And_Get (
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data

Line 1803: -- Standard Start of API savepoint

1799: l_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type;
1800:
1801:
1802: BEGIN
1803: -- Standard Start of API savepoint
1804: SAVEPOINT VALIDATE_Offers_;
1805:
1806: -- Standard call to check for call compatibility.
1807: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1802: BEGIN
1803: -- Standard Start of API savepoint
1804: SAVEPOINT VALIDATE_Offers_;
1805:
1806: -- Standard call to check for call compatibility.
1807: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1808: p_api_version_number,
1809: l_api_name,
1810: G_PKG_NAME)

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

1857:
1858: -- Initialize API return status to SUCCESS
1859: x_return_status := FND_API.G_RET_STS_SUCCESS;
1860:
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get
1863: (p_count => x_msg_count,
1864: p_data => x_msg_data
1865: );

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

1872:
1873: WHEN FND_API.G_EXC_ERROR THEN
1874: ROLLBACK TO VALIDATE_Offers_;
1875: x_return_status := FND_API.G_RET_STS_ERROR;
1876: -- Standard call to get message count and if count=1, get the message
1877: FND_MSG_PUB.Count_And_Get (
1878: p_encoded => FND_API.G_FALSE,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data

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

1882:
1883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1884: ROLLBACK TO VALIDATE_Offers_;
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: -- Standard call to get message count and if count=1, get the message
1887: FND_MSG_PUB.Count_And_Get (
1888: p_encoded => FND_API.G_FALSE,
1889: p_count => x_msg_count,
1890: p_data => x_msg_data

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

1896: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1897: THEN
1898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1899: END IF;
1900: -- Standard call to get message count and if count=1, get the message
1901: FND_MSG_PUB.Count_And_Get (
1902: p_encoded => FND_API.G_FALSE,
1903: p_count => x_msg_count,
1904: p_data => x_msg_data

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

1931: -- If data not valid
1932: -- THEN
1933: -- x_return_status := FND_API.G_RET_STS_ERROR;
1934:
1935: -- Standard call to get message count and if count is 1, get message info.
1936: FND_MSG_PUB.Count_And_Get
1937: (p_count => x_msg_count,
1938: p_data => x_msg_data
1939: );