74: -- Initialize message list if p_init_msg_list is set to TRUE
75: --
76: IF FND_API.To_Boolean(p_init_msg_list)
77: THEN
78: FND_MSG_PUB.Initialize;
79: END IF;
80:
81: --
82: -- Initialize API return status to success
227:
228: --
229: -- Standard call to get message count and if count is 1, get message info
230: --
231: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
232: , p_data => x_msg_data
233: );
234:
235: EXCEPTION
236: WHEN FND_API.G_EXC_ERROR
237: THEN
238: ROLLBACK TO Create_BRMRule_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
241: , p_data => x_msg_data
242: );
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
244: THEN
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
244: THEN
245: ROLLBACK TO Create_BRMRule_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
248: , p_data => x_msg_data
249: );
250: WHEN OTHERS
251: THEN
250: WHEN OTHERS
251: THEN
252: ROLLBACK TO Create_BRMRule_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
257: , l_api_name
258: );
252: ROLLBACK TO Create_BRMRule_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: THEN
256: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
257: , l_api_name
258: );
259: END IF;
260: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
256: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME
257: , l_api_name
258: );
259: END IF;
260: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
261: , p_data => x_msg_data
262: );
263:
264: END Create_BRMRule;
329: -- Initialize message list if p_init_msg_list is set to TRUE
330: --
331: IF FND_API.To_Boolean(p_init_msg_list)
332: THEN
333: FND_MSG_PUB.Initialize;
334: END IF;
335:
336: --
337: -- Initialize API return status to success
414:
415: --
416: -- Standard call to get message count and if count is 1, get message info
417: --
418: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
419: , p_data => x_msg_data
420: );
421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR
424: THEN
425: ROLLBACK TO Update_BRMRule_PVT;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
432: THEN
433: ROLLBACK TO Update_BRMRule_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
436: , p_data => x_msg_data
437: );
438:
439: WHEN OTHERS
439: WHEN OTHERS
440: THEN
441: ROLLBACK TO Update_BRMRule_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
446: , l_api_name
447: );
441: ROLLBACK TO Update_BRMRule_PVT;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
446: , l_api_name
447: );
448: END IF;
449: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
445: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
446: , l_api_name
447: );
448: END IF;
449: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
450: , p_data => x_msg_data
451: );
452:
453: END Update_BRMRule;
517: -- Initialize message list if requested
518: --
519: IF FND_API.to_Boolean( p_init_msg_list )
520: THEN
521: FND_MSG_PUB.initialize;
522: END IF;
523:
524: --
525: -- Initialize return status to SUCCESS
552: THEN
553: COMMIT WORK;
554: END IF;
555:
556: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
557: , p_data => X_MSG_DATA
558: );
559:
560: EXCEPTION
561: WHEN FND_API.G_EXC_ERROR
562: THEN
563: ROLLBACK TO Delete_BRMRule_PVT;
564: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
565: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
566: , p_data => X_MSG_DATA
567: );
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
570: THEN
571: ROLLBACK TO Delete_BRMRule_PVT;
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
574: , p_data => X_MSG_DATA
575: );
576:
577: WHEN OTHERS
577: WHEN OTHERS
578: THEN
579: ROLLBACK TO Delete_BRMRule_PVT;
580: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
584: , l_api_name
585: );
579: ROLLBACK TO Delete_BRMRule_PVT;
580: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
584: , l_api_name
585: );
586: END IF;
587: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
584: , l_api_name
585: );
586: END IF;
587: FND_MSG_PUB.Count_And_Get( p_count => X_MSG_COUNT
588: , p_data => X_MSG_DATA
589: );
590:
591: END Delete_BRMRule;