DBA Data[Home] [Help]

APPS.AMS_VENUE_RATES_PUB dependencies on FND_MSG_PUB

Line 54: FND_MSG_PUB.initialize;

50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.to_Boolean( p_init_msg_list )
53: THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: -- Debug Message
58: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 102: FND_MSG_PUB.Count_And_Get

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: );
106: EXCEPTION

Line 116: FND_MSG_PUB.Count_And_Get (

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
120: );

Line 126: FND_MSG_PUB.Count_And_Get (

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
130: );

Line 135: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

131:
132: WHEN OTHERS THEN
133: ROLLBACK TO CREATE_Venue_Rates_PUB;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

133: ROLLBACK TO CREATE_Venue_Rates_PUB;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 140: FND_MSG_PUB.Count_And_Get (

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
144: );

Line 182: FND_MSG_PUB.initialize;

178:
179: -- Initialize message list if p_init_msg_list is set to TRUE.
180: IF FND_API.to_Boolean( p_init_msg_list )
181: THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Debug Message
186: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 228: FND_MSG_PUB.Count_And_Get

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: );
232: EXCEPTION

Line 242: FND_MSG_PUB.Count_And_Get (

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
246: );

Line 252: FND_MSG_PUB.Count_And_Get (

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
256: );

Line 261: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

257:
258: WHEN OTHERS THEN
259: ROLLBACK TO UPDATE_Venue_Rates_PUB;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

259: ROLLBACK TO UPDATE_Venue_Rates_PUB;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 266: FND_MSG_PUB.Count_And_Get (

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
270: );

Line 307: FND_MSG_PUB.initialize;

303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:
310: -- Debug Message
311: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 353: FND_MSG_PUB.Count_And_Get

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: );
357: EXCEPTION

Line 367: FND_MSG_PUB.Count_And_Get (

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
371: );

Line 377: FND_MSG_PUB.Count_And_Get (

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
381: );

Line 386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

382:
383: WHEN OTHERS THEN
384: ROLLBACK TO DELETE_Venue_Rates_PUB;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

384: ROLLBACK TO DELETE_Venue_Rates_PUB;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 391: FND_MSG_PUB.Count_And_Get (

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
395: );

Line 428: FND_MSG_PUB.initialize;

424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )
427: THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Debug Message
432: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 476: FND_MSG_PUB.Count_And_Get (

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
480: );

Line 486: FND_MSG_PUB.Count_And_Get (

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
490: );

Line 495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

491:
492: WHEN OTHERS THEN
493: ROLLBACK TO LOCK_Venue_Rates_PUB;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

493: ROLLBACK TO LOCK_Venue_Rates_PUB;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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,

Line 500: FND_MSG_PUB.Count_And_Get (

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
504: );