[Home] [Help]
35: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Venue_Rates';
36: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
37: l_pvt_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_Venue_Rates_PUB;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_Venue_Rates_PUB;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
87: --
88: -- End of API body.
89: --
90:
91: -- Standard check for p_commit
92: IF FND_API.to_Boolean( p_commit )
93: THEN
94: COMMIT WORK;
95: END IF;
97:
98: -- Debug Message
99: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
100:
101: -- Standard call to get message count and if count is 1, get message info.
102: FND_MSG_PUB.Count_And_Get
103: (p_count => x_msg_count,
104: p_data => x_msg_data
105: );
111:
112: WHEN FND_API.G_EXC_ERROR THEN
113: ROLLBACK TO CREATE_Venue_Rates_PUB;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: -- Standard call to get message count and if count=1, get the message
116: FND_MSG_PUB.Count_And_Get (
117: p_encoded => FND_API.G_FALSE,
118: p_count => x_msg_count,
119: p_data => x_msg_data
121:
122: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
123: ROLLBACK TO CREATE_Venue_Rates_PUB;
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
125: -- Standard call to get message count and if count=1, get the message
126: FND_MSG_PUB.Count_And_Get (
127: p_encoded => FND_API.G_FALSE,
128: p_count => x_msg_count,
129: p_data => x_msg_data
135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
138: END IF;
139: -- Standard call to get message count and if count=1, get the message
140: FND_MSG_PUB.Count_And_Get (
141: p_encoded => FND_API.G_FALSE,
142: p_count => x_msg_count,
143: p_data => x_msg_data
163: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
164: l_object_version_number NUMBER;
165: l_pvt_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;
166: BEGIN
167: -- Standard Start of API savepoint
168: SAVEPOINT UPDATE_Venue_Rates_PUB;
169:
170: -- Standard call to check for call compatibility.
171: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
166: BEGIN
167: -- Standard Start of API savepoint
168: SAVEPOINT UPDATE_Venue_Rates_PUB;
169:
170: -- Standard call to check for call compatibility.
171: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
172: p_api_version_number,
173: l_api_name,
174: G_PKG_NAME)
213: --
214: -- End of API body
215: --
216:
217: -- Standard check for p_commit
218: IF FND_API.to_Boolean( p_commit )
219: THEN
220: COMMIT WORK;
221: END IF;
223:
224: -- Debug Message
225: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
226:
227: -- Standard call to get message count and if count is 1, get message info.
228: FND_MSG_PUB.Count_And_Get
229: (p_count => x_msg_count,
230: p_data => x_msg_data
231: );
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO UPDATE_Venue_Rates_PUB;
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: -- Standard call to get message count and if count=1, get the message
242: FND_MSG_PUB.Count_And_Get (
243: p_encoded => FND_API.G_FALSE,
244: p_count => x_msg_count,
245: p_data => x_msg_data
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: ROLLBACK TO UPDATE_Venue_Rates_PUB;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data
261: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
264: END IF;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
288: l_RATE_ID NUMBER := p_RATE_ID;
289: l_object_version_number NUMBER := p_object_version_number;
290: l_pvt_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT DELETE_Venue_Rates_PUB;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT DELETE_Venue_Rates_PUB;
294:
295: -- Standard call to check for call compatibility.
296: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
297: p_api_version_number,
298: l_api_name,
299: G_PKG_NAME)
338: --
339: -- End of API body
340: --
341:
342: -- Standard check for p_commit
343: IF FND_API.to_Boolean( p_commit )
344: THEN
345: COMMIT WORK;
346: END IF;
348:
349: -- Debug Message
350: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
351:
352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get
354: (p_count => x_msg_count,
355: p_data => x_msg_data
356: );
362:
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO DELETE_Venue_Rates_PUB;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: -- Standard call to get message count and if count=1, get the message
367: FND_MSG_PUB.Count_And_Get (
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: ROLLBACK TO DELETE_Venue_Rates_PUB;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: -- Standard call to get message count and if count=1, get the message
377: FND_MSG_PUB.Count_And_Get (
378: p_encoded => FND_API.G_FALSE,
379: p_count => x_msg_count,
380: p_data => x_msg_data
386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
389: END IF;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
412: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
413: l_pvt_venue_rates_rec AMS_Venue_Rates_PVT.venue_rates_rec_type;
414: BEGIN
415:
416: -- Standard call to check for call compatibility.
417: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
418: p_api_version_number,
419: l_api_name,
420: G_PKG_NAME)
471:
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO LOCK_Venue_Rates_PUB;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO LOCK_Venue_Rates_PUB;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data