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 117: -- Standard Start of API savepoint

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

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

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

Line 349: -- Standard check for p_commit

345: --
346: -- End of API body
347: --
348:
349: -- Standard check for p_commit
350: IF FND_API.to_Boolean( p_commit )
351: THEN
352: COMMIT WORK;
353: END IF;

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

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

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

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

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

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

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

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

Line 736: -- Standard Start of API savepoint

732: l_start_date_o DATE;
733: l_start_date DATE;
734:
735: BEGIN
736: -- Standard Start of API savepoint
737: SAVEPOINT UPDATE_Offers_PVT;
738:
739: -- Standard call to check for call compatibility.
740: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

735: BEGIN
736: -- Standard Start of API savepoint
737: SAVEPOINT UPDATE_Offers_PVT;
738:
739: -- Standard call to check for call compatibility.
740: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
741: p_api_version_number,
742: l_api_name,
743: G_PKG_NAME)

Line 918: -- Standard check for p_commit

914: --
915: -- End of API body.
916: --
917:
918: -- Standard check for p_commit
919: IF FND_API.to_Boolean( p_commit )
920: THEN
921: COMMIT WORK;
922: END IF;

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

920: THEN
921: COMMIT WORK;
922: END IF;
923:
924: -- Standard call to get message count and if count is 1, get message info.
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data,
928: p_encoded => FND_API.G_FALSE

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

935:
936: WHEN FND_API.G_EXC_ERROR THEN
937: ROLLBACK TO UPDATE_Offers_PVT;
938: x_return_status := FND_API.G_RET_STS_ERROR;
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 949: -- Standard call to get message count and if count=1, get the message

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

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

959: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
960: THEN
961: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
962: END IF;
963: -- Standard call to get message count and if count=1, get the message
964: FND_MSG_PUB.Count_And_Get (
965: p_encoded => FND_API.G_FALSE,
966: p_count => x_msg_count,
967: p_data => x_msg_data

Line 991: -- Standard Start of API savepoint

987: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
988: l_object_version_number NUMBER;
989:
990: BEGIN
991: -- Standard Start of API savepoint
992: SAVEPOINT DELETE_Offers_PVT;
993:
994: -- Standard call to check for call compatibility.
995: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

990: BEGIN
991: -- Standard Start of API savepoint
992: SAVEPOINT DELETE_Offers_PVT;
993:
994: -- Standard call to check for call compatibility.
995: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
996: p_api_version_number,
997: l_api_name,
998: G_PKG_NAME)

Line 1023: -- Standard check for p_commit

1019: --
1020: -- End of API body
1021: --
1022:
1023: -- Standard check for p_commit
1024: IF FND_API.to_Boolean( p_commit )
1025: THEN
1026: COMMIT WORK;
1027: END IF;

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

1025: THEN
1026: COMMIT WORK;
1027: END IF;
1028:
1029: -- Standard call to get message count and if count is 1, get message info.
1030: FND_MSG_PUB.Count_And_Get
1031: (p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );

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

1039:
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: ROLLBACK TO DELETE_Offers_PVT;
1042: x_return_status := FND_API.G_RET_STS_ERROR;
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 1053: -- Standard call to get message count and if count=1, get the message

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

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

1063: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1064: THEN
1065: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1066: END IF;
1067: -- Standard call to get message count and if count=1, get the message
1068: FND_MSG_PUB.Count_And_Get (
1069: p_encoded => FND_API.G_FALSE,
1070: p_count => x_msg_count,
1071: p_data => x_msg_data

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

1107: THEN
1108: FND_MSG_PUB.initialize;
1109: END IF;
1110:
1111: -- Standard call to check for call compatibility.
1112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1113: p_api_version_number,
1114: l_api_name,
1115: G_PKG_NAME)

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

1153:
1154: WHEN FND_API.G_EXC_ERROR THEN
1155: ROLLBACK TO LOCK_Offers_PVT;
1156: x_return_status := FND_API.G_RET_STS_ERROR;
1157: -- Standard call to get message count and if count=1, get the message
1158: FND_MSG_PUB.Count_And_Get (
1159: p_encoded => FND_API.G_FALSE,
1160: p_count => x_msg_count,
1161: p_data => x_msg_data

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

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

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

1177: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1178: THEN
1179: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1180: END IF;
1181: -- Standard call to get message count and if count=1, get the message
1182: FND_MSG_PUB.Count_And_Get (
1183: p_encoded => FND_API.G_FALSE,
1184: p_count => x_msg_count,
1185: p_data => x_msg_data

Line 1791: -- Standard Start of API savepoint

1787: l_offers_rec OZF_Promotional_Offers_PVT.offers_rec_type;
1788:
1789:
1790: BEGIN
1791: -- Standard Start of API savepoint
1792: SAVEPOINT VALIDATE_Offers_;
1793:
1794: -- Standard call to check for call compatibility.
1795: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1790: BEGIN
1791: -- Standard Start of API savepoint
1792: SAVEPOINT VALIDATE_Offers_;
1793:
1794: -- Standard call to check for call compatibility.
1795: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1796: p_api_version_number,
1797: l_api_name,
1798: G_PKG_NAME)

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

1845:
1846: -- Initialize API return status to SUCCESS
1847: x_return_status := FND_API.G_RET_STS_SUCCESS;
1848:
1849: -- Standard call to get message count and if count is 1, get message info.
1850: FND_MSG_PUB.Count_And_Get
1851: (p_count => x_msg_count,
1852: p_data => x_msg_data
1853: );

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

1860:
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: ROLLBACK TO VALIDATE_Offers_;
1863: x_return_status := FND_API.G_RET_STS_ERROR;
1864: -- Standard call to get message count and if count=1, get the message
1865: FND_MSG_PUB.Count_And_Get (
1866: p_encoded => FND_API.G_FALSE,
1867: p_count => x_msg_count,
1868: p_data => x_msg_data

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

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

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

1884: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1885: THEN
1886: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1887: END IF;
1888: -- Standard call to get message count and if count=1, get the message
1889: FND_MSG_PUB.Count_And_Get (
1890: p_encoded => FND_API.G_FALSE,
1891: p_count => x_msg_count,
1892: p_data => x_msg_data

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

1919: -- If data not valid
1920: -- THEN
1921: -- x_return_status := FND_API.G_RET_STS_ERROR;
1922:
1923: -- Standard call to get message count and if count is 1, get message info.
1924: FND_MSG_PUB.Count_And_Get
1925: (p_count => x_msg_count,
1926: p_data => x_msg_data
1927: );