DBA Data[Home] [Help]

APPS.IBE_MSITE_INFORMATION_MGR_PVT dependencies on FND_MSG_PUB

Line 89: FND_MSG_PUB.initialize;

85: END IF;
86:
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean(p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: -- Initialize API return status to success
93: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 159: FND_MSG_PUB.Add;

155: );
156:
157: IF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_UNEXP_ERROR) THEN
158: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');
159: FND_MSG_PUB.Add;
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
162: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');
163: FND_MSG_PUB.Add;

Line 163: FND_MSG_PUB.Add;

159: FND_MSG_PUB.Add;
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
162: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');
163: FND_MSG_PUB.Add;
164: RAISE FND_API.G_EXC_ERROR;
165: END IF;
166:
167: ELSIF (p_operation_flags(i) = 'U') THEN

Line 220: FND_MSG_PUB.Add;

216: );
217:
218: IF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_UNEXP_ERROR) THEN
219: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
223: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
224: FND_MSG_PUB.Add;

Line 224: FND_MSG_PUB.Add;

220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
223: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
224: FND_MSG_PUB.Add;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: x_msite_information_ids(i) := p_msite_information_ids(i);

Line 246: FND_MSG_PUB.Add;

242: );
243:
244: IF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_UNEXP_ERROR) THEN
245: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
249: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
250: FND_MSG_PUB.Add;

Line 250: FND_MSG_PUB.Add;

246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
249: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253:
254: x_msite_information_ids(i) := p_msite_information_ids(i);

Line 262: FND_MSG_PUB.Add;

258: x_msite_information_ids(i) := p_msite_information_ids(i);
259: ELSE
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_OP_FLAG');
261: FND_MESSAGE.Set_Token('FLAG', p_operation_flags(i));
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: END LOOP; -- end for i

Line 277: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

273: COMMIT WORK;
274: END IF;
275:
276: -- Standard call to get message count and if count is 1, get message info.
277: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
278: p_data => x_msg_data,
279: p_encoded => 'F');
280:
281: EXCEPTION

Line 286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

282:
283: WHEN FND_API.G_EXC_ERROR THEN
284: ROLLBACK TO Change_Msite_Info_Pvt;
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
287: p_data => x_msg_data,
288: p_encoded => 'F');
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: ROLLBACK TO Change_Msite_Info_Pvt;
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
294: p_data => x_msg_data,
295: p_encoded => 'F');
296:
297: WHEN OTHERS THEN

Line 303: FND_MSG_PUB.Add;

299: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
300: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
301: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
302: FND_MESSAGE.Set_Token('REASON', SQLERRM);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN

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

302: FND_MESSAGE.Set_Token('REASON', SQLERRM);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
309: END IF;
310:

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

304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
309: END IF;
310:
311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
312: p_data => x_msg_data,

Line 311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

307: THEN
308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
309: END IF;
310:
311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
312: p_data => x_msg_data,
313: p_encoded => 'F');
314:
315: END Change_Msite_Info;

Line 343: FND_MSG_PUB.initialize;

339: BEGIN
340:
341: -- Initialize message list if p_init_msg_list is set to TRUE.
342: IF FND_API.to_Boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345:
346: -- Initialize API return status to success
347: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 375: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

371: EXCEPTION
372:
373: WHEN FND_API.G_EXC_ERROR THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
376: p_data => x_msg_data,
377: p_encoded => 'F');
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

377: p_encoded => 'F');
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => 'F');
384:
385: WHEN OTHERS THEN

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

384:
385: WHEN OTHERS THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
389: THEN
390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
391: END IF;
392:

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

386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
389: THEN
390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
391: END IF;
392:
393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
394: p_data => x_msg_data,

Line 393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

389: THEN
390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
391: END IF;
392:
393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
394: p_data => x_msg_data,
395: p_encoded => 'F');
396:
397: END Load_MsiteInformation;

Line 532: FND_MSG_PUB.initialize;

528: G_PKG_NAME) THEN
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530: END IF;
531: IF FND_API.to_Boolean(p_init_msg_list) THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534: -- Initialize API return status to SUCCESS
535: x_return_status := FND_API.G_RET_STS_SUCCESS;
536:

Line 737: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

733: IF (l_debug = 'Y') THEN
734: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
735: 'Change_Msite_Info');
736: for i in 1..l_msg_count loop
737: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
738: IBE_UTIL.debug(l_msg_data);
739: end loop;
740: END IF;
741: RAISE FND_API.G_EXC_ERROR;

Line 747: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);

743: IF (l_debug = 'Y') THEN
744: IBE_UTIL.debug('Error in IBE_MSITE_INFORMATION_MGR_PVT.'||
745: 'Change_Msite_Info');
746: for i in 1..l_msg_count loop
747: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
748: IBE_UTIL.debug(l_msg_data);
749: end loop;
750: END IF;
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 760: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

756: END IF;
757: IF (FND_API.To_Boolean(p_commit)) THEN
758: COMMIT WORK;
759: END IF;
760: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
761: p_data => x_msg_data,
762: p_encoded => 'F');
763: IF (l_debug = 'Y') THEN
764: IBE_UTIL.debug('duplicate_msite Ends +');

Line 770: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

766: EXCEPTION
767: WHEN FND_API.G_EXC_ERROR THEN
768: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
771: p_data => x_msg_data,
772: p_encoded => 'F');
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;

Line 776: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

772: p_encoded => 'F');
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
777: p_data => x_msg_data,
778: p_encoded => 'F');
779: WHEN OTHERS THEN
780: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;

Line 785: FND_MSG_PUB.Add;

781: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
782: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;
786: IF (l_debug = 'Y') THEN
787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
789: END IF;

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

787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
789: END IF;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
793: END IF;
794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
795: p_data => x_msg_data,

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

788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
789: END IF;
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
793: END IF;
794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
795: p_data => x_msg_data,
796: p_encoded => 'F');

Line 794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
792: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
793: END IF;
794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
795: p_data => x_msg_data,
796: p_encoded => 'F');
797: END duplicate_msite_info;
798: