[Home] [Help]
3024: AND action_used_by_id = p_object_id
3025: ORDER BY order_number
3026: ;
3027: BEGIN
3028: -- Standard Start of API savepoint
3029: SAVEPOINT copy_list_select_actions_pvt;
3030:
3031: -- Standard call to check for call compatibility.
3032: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3027: BEGIN
3028: -- Standard Start of API savepoint
3029: SAVEPOINT copy_list_select_actions_pvt;
3030:
3031: -- Standard call to check for call compatibility.
3032: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3033: p_api_version,
3034: l_api_name,
3035: G_PKG_NAME)
3087: --
3088: -- End of API body.
3089: --
3090:
3091: -- Standard check for p_commit
3092: IF FND_API.to_Boolean( p_commit ) THEN
3093: COMMIT WORK;
3094: END IF;
3095:
3099:
3100: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3101: END IF;
3102:
3103: -- Standard call to get message count and if count is 1, get message info.
3104: FND_MSG_PUB.Count_And_Get (
3105: p_count => x_msg_count,
3106: p_data => x_msg_data
3107: );
3108: EXCEPTION
3109: WHEN FND_API.G_EXC_ERROR THEN
3110: ROLLBACK TO copy_list_select_actions_pvt;
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112: -- Standard call to get message count and if count=1, get the message
3113: FND_MSG_PUB.Count_And_Get (
3114: p_encoded => FND_API.G_FALSE,
3115: p_count => x_msg_count,
3116: p_data => x_msg_data
3117: );
3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3119: ROLLBACK TO copy_list_select_actions_pvt;
3120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3121: -- Standard call to get message count and if count=1, get the message
3122: FND_MSG_PUB.Count_And_Get (
3123: p_encoded => FND_API.G_FALSE,
3124: p_count => x_msg_count,
3125: p_data => x_msg_data
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3131: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3132: END IF;
3133: -- Standard call to get message count and if count=1, get the message
3134: FND_MSG_PUB.Count_And_Get (
3135: p_encoded => FND_API.G_FALSE,
3136: p_count => x_msg_count,
3137: p_data => x_msg_data
3428: l_schedule_rec AMS_Camp_Schedule_PVT.schedule_rec_type ;
3429:
3430:
3431: BEGIN
3432: -- Standard Start of API savepoint
3433: SAVEPOINT Copy_Act_Schedule;
3434:
3435: -- Debug Message
3436: IF (AMS_DEBUG_HIGH_ON) THEN
3572:
3573: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
3574: END IF;
3575:
3576: -- Standard call to get message count and if count is 1, get message info.
3577: FND_MSG_PUB.Count_And_Get
3578: (p_count => x_msg_count,
3579: p_data => x_msg_data
3580: );
3592: IF c_schedule_det%ISOPEN THEN
3593: CLOSE c_schedule_det ;
3594: END IF ;
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: -- Standard call to get message count and if count=1, get the message
3597: FND_MSG_PUB.Count_And_Get (
3598: p_encoded => FND_API.G_FALSE,
3599: p_count => x_msg_count,
3600: p_data => x_msg_data
3605: IF c_schedule_det%ISOPEN THEN
3606: CLOSE c_schedule_det ;
3607: END IF ;
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3609: -- Standard call to get message count and if count=1, get the message
3610: FND_MSG_PUB.Count_And_Get (
3611: p_encoded => FND_API.G_FALSE,
3612: p_count => x_msg_count,
3613: p_data => x_msg_data
3622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3623: THEN
3624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3625: END IF;
3626: -- Standard call to get message count and if count=1, get the message
3627: FND_MSG_PUB.Count_And_Get (
3628: p_encoded => FND_API.G_FALSE,
3629: p_count => x_msg_count,
3630: p_data => x_msg_data
3702: l_reference_event_rec fetch_event_details%ROWTYPE;
3703:
3704:
3705: BEGIN
3706: -- Standard Start of API savepoint
3707: SAVEPOINT Copy_Act_Schedule;
3708:
3709: -- Debug Message
3710: IF (AMS_DEBUG_HIGH_ON) THEN
4060:
4061: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
4062: END IF;
4063:
4064: -- Standard call to get message count and if count is 1, get message info.
4065: FND_MSG_PUB.Count_And_Get
4066: (p_count => x_msg_count,
4067: p_data => x_msg_data
4068: );
4080: IF c_schedule_details%ISOPEN THEN
4081: CLOSE c_schedule_details ;
4082: END IF ;
4083: x_return_status := FND_API.G_RET_STS_ERROR;
4084: -- Standard call to get message count and if count=1, get the message
4085: FND_MSG_PUB.Count_And_Get (
4086: p_encoded => FND_API.G_FALSE,
4087: p_count => x_msg_count,
4088: p_data => x_msg_data
4093: IF c_schedule_details%ISOPEN THEN
4094: CLOSE c_schedule_details ;
4095: END IF ;
4096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4097: -- Standard call to get message count and if count=1, get the message
4098: FND_MSG_PUB.Count_And_Get (
4099: p_encoded => FND_API.G_FALSE,
4100: p_count => x_msg_count,
4101: p_data => x_msg_data
4110: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4111: THEN
4112: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4113: END IF;
4114: -- Standard call to get message count and if count=1, get the message
4115: FND_MSG_PUB.Count_And_Get (
4116: p_encoded => FND_API.G_FALSE,
4117: p_count => x_msg_count,
4118: p_data => x_msg_data