[Home] [Help]
87: and p.action_param_id in (21,31,41, 61)
88: and a.ctd_id = p_webcontent_id;
89:
90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT Log_interaction ;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
90: BEGIN
91: -- Standard Start of API savepoint
92: SAVEPOINT Log_interaction ;
93:
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
96: p_api_version_number,
97: l_api_name,
98: G_PKG_NAME)
309: IF l_return_status <> FND_API.g_ret_sts_success THEN
310: RAISE FND_API.g_exc_error;
311: END IF;
312:
313: -- Standard check for p_commit
314: IF FND_API.to_Boolean( p_commit )
315: THEN
316: COMMIT WORK;
317: END IF;
318:
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: );
329:
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
339:
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
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,
360: p_count => x_msg_count,
361: p_data => x_msg_data
383: l_interaction_id NUMBER := null;
384: l_action_parameter_code VARCHAR2(2000) := null;
385: l_redirect_url VARCHAR2(2000) := null;
386: BEGIN
387: -- Standard Start of API savepoint
388: SAVEPOINT Log_redirect;
389: p_init_msg_list := FND_API.G_FALSE;
390: p_commit := FND_API.G_FALSE;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
442: x_action_parameter_code := l_action_parameter_code;
443:
444: -- End of API body.
445:
446: -- Standard check for p_commit
447: IF FND_API.to_Boolean( p_commit ) THEN
448: COMMIT WORK;
449: END IF;
450:
455:
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
465:
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
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,
486: p_count => x_msg_count,
487: p_data => x_msg_data
537: BEGIN
538:
539: --insert_log_mesg('Very first statement of weblite log');
540:
541: -- Standard Start of API savepoint
542: SAVEPOINT weblite_log;
543: -- Debug Message
544: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
545: p_init_msg_list := FND_API.G_FALSE;
597: x_msource := l_code_id;
598:
599: -- End of API body.
600:
601: -- Standard check for p_commit
602: IF FND_API.to_Boolean( p_commit ) THEN
603: COMMIT WORK;
604: END IF;
605:
612: WHEN FND_API.G_EXC_ERROR THEN
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
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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
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,
645: p_count => x_msg_count,
646: p_data => x_msg_data