DBA Data[Home] [Help]

APPS.AMS_SCORERESULT_PUB dependencies on FND_MSG_PUB

Line 57: FND_MSG_PUB.initialize;

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

Line 111: FND_MSG_PUB.Count_And_Get

107: -- Debug Message
108: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
109:
110: -- Standard call to get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get
112: (p_count => x_msg_count,
113: p_data => x_msg_data
114: );
115: EXCEPTION

Line 125: FND_MSG_PUB.Count_And_Get (

121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO CREATE_Scoreresult_PUB;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data
129: );

Line 135: FND_MSG_PUB.Count_And_Get (

131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_Scoreresult_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: -- Standard call to get message count and if count=1, get the message
135: FND_MSG_PUB.Count_And_Get (
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data
139: );

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

140:
141: WHEN OTHERS THEN
142: ROLLBACK TO CREATE_Scoreresult_PUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message

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

142: ROLLBACK TO CREATE_Scoreresult_PUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,

Line 149: FND_MSG_PUB.Count_And_Get (

145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data
153: );

Line 190: FND_MSG_PUB.initialize;

186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.to_Boolean( p_init_msg_list )
189: THEN
190: FND_MSG_PUB.initialize;
191: END IF;
192:
193: -- Debug Message
194: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 244: FND_MSG_PUB.Count_And_Get

240: -- Debug Message
241: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
242:
243: -- Standard call to get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get
245: (p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: EXCEPTION

Line 258: FND_MSG_PUB.Count_And_Get (

254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO UPDATE_Scoreresult_PUB;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
262: );

Line 268: FND_MSG_PUB.Count_And_Get (

264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO UPDATE_Scoreresult_PUB;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: -- Standard call to get message count and if count=1, get the message
268: FND_MSG_PUB.Count_And_Get (
269: p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count,
271: p_data => x_msg_data
272: );

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

273:
274: WHEN OTHERS THEN
275: ROLLBACK TO UPDATE_Scoreresult_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
280: END IF;
281: -- Standard call to get message count and if count=1, get the message

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

275: ROLLBACK TO UPDATE_Scoreresult_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
278: THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
280: END IF;
281: -- Standard call to get message count and if count=1, get the message
282: FND_MSG_PUB.Count_And_Get (
283: p_encoded => FND_API.G_FALSE,

Line 282: FND_MSG_PUB.Count_And_Get (

278: THEN
279: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
280: END IF;
281: -- Standard call to get message count and if count=1, get the message
282: FND_MSG_PUB.Count_And_Get (
283: p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data
286: );

Line 319: FND_MSG_PUB.initialize;

315:
316: -- Initialize message list if p_init_msg_list is set to TRUE.
317: IF FND_API.to_Boolean( p_init_msg_list )
318: THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321:
322: -- Debug Message
323: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 363: FND_MSG_PUB.Count_And_Get

359: -- Debug Message
360: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
361:
362: -- Standard call to get message count and if count is 1, get message info.
363: FND_MSG_PUB.Count_And_Get
364: (p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367: EXCEPTION

Line 377: FND_MSG_PUB.Count_And_Get (

373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO DELETE_Scoreresult_PUB;
375: x_return_status := FND_API.G_RET_STS_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 387: FND_MSG_PUB.Count_And_Get (

383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: ROLLBACK TO DELETE_Scoreresult_PUB;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );

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

392:
393: WHEN OTHERS THEN
394: ROLLBACK TO DELETE_Scoreresult_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
399: END IF;
400: -- Standard call to get message count and if count=1, get the message

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

394: ROLLBACK TO DELETE_Scoreresult_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
397: THEN
398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
399: END IF;
400: -- Standard call to get message count and if count=1, get the message
401: FND_MSG_PUB.Count_And_Get (
402: p_encoded => FND_API.G_FALSE,

Line 401: FND_MSG_PUB.Count_And_Get (

397: THEN
398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
399: END IF;
400: -- Standard call to get message count and if count=1, get the message
401: FND_MSG_PUB.Count_And_Get (
402: p_encoded => FND_API.G_FALSE,
403: p_count => x_msg_count,
404: p_data => x_msg_data
405: );

Line 436: FND_MSG_PUB.initialize;

432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean( p_init_msg_list )
435: THEN
436: FND_MSG_PUB.initialize;
437: END IF;
438:
439: -- Debug Message
440: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

Line 483: FND_MSG_PUB.Count_And_Get (

479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO LOCK_Scoreresult_PUB;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: -- Standard call to get message count and if count=1, get the message
483: FND_MSG_PUB.Count_And_Get (
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data
487: );

Line 493: FND_MSG_PUB.Count_And_Get (

489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
490: ROLLBACK TO LOCK_Scoreresult_PUB;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data
497: );

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

498:
499: WHEN OTHERS THEN
500: ROLLBACK TO LOCK_Scoreresult_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
505: END IF;
506: -- Standard call to get message count and if count=1, get the message

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

500: ROLLBACK TO LOCK_Scoreresult_PUB;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
502: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
503: THEN
504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
505: END IF;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,

Line 507: FND_MSG_PUB.Count_And_Get (

503: THEN
504: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
505: END IF;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
511: );

Line 622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: WHEN OTHERS THEN
620: ROLLBACK TO CREATE_Scoreresult_PUB;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
623: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
624: END IF;
625: END Create_ScoreResult;
626:

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

619: WHEN OTHERS THEN
620: ROLLBACK TO CREATE_Scoreresult_PUB;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
623: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
624: END IF;
625: END Create_ScoreResult;
626:
627: