102:
103: -- Initialize message list if p_init_msg_list is set to TRUE.
104: IF FND_API.to_Boolean( p_init_msg_list )
105: THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108:
109: -- Debug Message
110: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
319: -- Debug Message
320: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
321:
322: -- Standard call to get message count and if count is 1, get message info.
323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO Log_interaction;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: -- Standard call to get message count and if count=1, get the message
334: FND_MSG_PUB.Count_And_Get (
335: p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data
338: );
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO Log_interaction;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: -- Standard call to get message count and if count=1, get the message
344: FND_MSG_PUB.Count_And_Get (
345: p_encoded => FND_API.G_FALSE,
346: p_count => x_msg_count,
347: p_data => x_msg_data
348: );
349:
350: WHEN OTHERS THEN
351: ROLLBACK TO Log_interaction;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
356: END IF;
357: -- Standard call to get message count and if count=1, get the message
351: ROLLBACK TO Log_interaction;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
356: END IF;
357: -- Standard call to get message count and if count=1, get the message
358: FND_MSG_PUB.Count_And_Get (
359: p_encoded => FND_API.G_FALSE,
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
356: END IF;
357: -- Standard call to get message count and if count=1, get the message
358: FND_MSG_PUB.Count_And_Get (
359: p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count,
361: p_data => x_msg_data
362: );
390: p_commit := FND_API.G_FALSE;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )
393: THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:
397: -- Debug Message
398: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO Log_redirect;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: ROLLBACK TO Log_redirect;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475:
476: WHEN OTHERS THEN
477: ROLLBACK TO Log_redirect;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
477: ROLLBACK TO Log_redirect;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );
545: p_init_msg_list := FND_API.G_FALSE;
546: p_commit := FND_API.G_FALSE;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:
613: ROLLBACK TO weblite_log;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_ERROR');
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
624: ROLLBACK TO weblite_log;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_UNEXPECTED_ERROR');
627: -- Standard call to get message count and if count=1, get the message
628: FND_MSG_PUB.Count_And_Get (
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,
631: p_data => x_msg_data
632: );
634: WHEN OTHERS THEN
635: ROLLBACK TO weblite_log;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: --insert_log_mesg('amsvtrkb:weblitelog:OTHERS');
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: --insert_log_mesg('amsvtrkb:weblitelog:OTHERS');
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );