[Home] [Help]
174: l_return_status VARCHAR2(1);
175: l_pvt_schedule_rec AMS_Camp_Schedule_PVT.schedule_rec_type ;
176: l_pub_schedule_rec schedule_rec_type := p_schedule_rec;
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT CREATE_Camp_Schedule_PUB;
180:
181: -- Initialize message list if p_init_msg_list is set to TRUE.
182: IF FND_API.to_Boolean( p_init_msg_list )
282: END IF;
283: END IF;
284:
285:
286: -- Standard check for p_commit
287: IF FND_API.to_Boolean( p_commit )
288: THEN
289: COMMIT WORK;
290: END IF;
292:
293: -- Debug Message
294: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
295:
296: -- Standard call to get message count and if count is 1, get message info.
297: FND_MSG_PUB.Count_And_Get
298: (p_count => x_msg_count,
299: p_data => x_msg_data
300: );
309:
310: WHEN FND_API.G_EXC_ERROR THEN
311: ROLLBACK TO CREATE_Camp_Schedule_PUB;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: -- Standard call to get message count and if count=1, get the message
314: FND_MSG_PUB.Count_And_Get (
315: p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data
319:
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: ROLLBACK TO CREATE_Camp_Schedule_PUB;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: -- Standard call to get message count and if count=1, get the message
324: FND_MSG_PUB.Count_And_Get (
325: p_encoded => FND_API.G_FALSE,
326: p_count => x_msg_count,
327: p_data => x_msg_data
333: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
334: THEN
335: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
336: END IF;
337: -- Standard call to get message count and if count=1, get the message
338: FND_MSG_PUB.Count_And_Get (
339: p_encoded => FND_API.G_FALSE,
340: p_count => x_msg_count,
341: p_data => x_msg_data
363: l_return_status VARCHAR2(1);
364: l_pvt_schedule_rec AMS_Camp_Schedule_PVT.schedule_rec_type;
365: l_pub_schedule_rec schedule_rec_type := p_schedule_rec;
366: BEGIN
367: -- Standard Start of API savepoint
368: SAVEPOINT UPDATE_Camp_Schedule_PUB;
369:
370:
371: -- Initialize message list if p_init_msg_list is set to TRUE.
467: RAISE FND_API.g_exc_unexpected_error;
468: END IF;
469: END IF;
470:
471: -- Standard check for p_commit
472: IF FND_API.to_Boolean( p_commit )
473: THEN
474: COMMIT WORK;
475: END IF;
477:
478: -- Debug Message
479: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
480:
481: -- Standard call to get message count and if count is 1, get message info.
482: FND_MSG_PUB.Count_And_Get
483: (p_count => x_msg_count,
484: p_data => x_msg_data
485: );
494:
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO UPDATE_Camp_Schedule_PUB;
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: ROLLBACK TO UPDATE_Camp_Schedule_PUB;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
518: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
521: END IF;
522: -- Standard call to get message count and if count=1, get the message
523: FND_MSG_PUB.Count_And_Get (
524: p_encoded => FND_API.G_FALSE,
525: p_count => x_msg_count,
526: p_data => x_msg_data
548: l_return_status VARCHAR2(1);
549:
550: l_pvt_schedule_rec AMS_Camp_Schedule_PVT.schedule_rec_type;
551: BEGIN
552: -- Standard Start of API savepoint
553: SAVEPOINT DELETE_Camp_Schedule_PUB;
554:
555: -- Initialize message list if p_init_msg_list is set to TRUE.
556: IF FND_API.to_Boolean( p_init_msg_list )
650: END IF;
651:
652:
653:
654: -- Standard check for p_commit
655: IF FND_API.to_Boolean( p_commit )
656: THEN
657: COMMIT WORK;
658: END IF;
660:
661: -- Debug Message
662: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
663:
664: -- Standard call to get message count and if count is 1, get message info.
665: FND_MSG_PUB.Count_And_Get
666: (p_count => x_msg_count,
667: p_data => x_msg_data
668: );
677:
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO DELETE_Camp_Schedule_PUB;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
687:
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: ROLLBACK TO DELETE_Camp_Schedule_PUB;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: -- Standard call to get message count and if count=1, get the message
692: FND_MSG_PUB.Count_And_Get (
693: p_encoded => FND_API.G_FALSE,
694: p_count => x_msg_count,
695: p_data => x_msg_data
701: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
704: END IF;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,
709: p_data => x_msg_data
832:
833: -- Debug Message
834: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
835:
836: -- Standard call to get message count and if count is 1, get message info.
837: FND_MSG_PUB.Count_And_Get
838: (p_count => x_msg_count,
839: p_data => x_msg_data
840: );
897: l_SCHEDULE_ID NUMBER := p_schedule_id;
898: l_return_status VARCHAR2(1);
899: BEGIN
900:
901: -- Standard call to check for call compatibility.
902: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
903: p_api_version_number,
904: l_api_name,
905: G_PKG_NAME)
1022:
1023: WHEN FND_API.G_EXC_ERROR THEN
1024: ROLLBACK TO LOCK_Camp_Schedule_PUB;
1025: x_return_status := FND_API.G_RET_STS_ERROR;
1026: -- Standard call to get message count and if count=1, get the message
1027: FND_MSG_PUB.Count_And_Get (
1028: p_encoded => FND_API.G_FALSE,
1029: p_count => x_msg_count,
1030: p_data => x_msg_data
1032:
1033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1034: ROLLBACK TO LOCK_Camp_Schedule_PUB;
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: -- Standard call to get message count and if count=1, get the message
1037: FND_MSG_PUB.Count_And_Get (
1038: p_encoded => FND_API.G_FALSE,
1039: p_count => x_msg_count,
1040: p_data => x_msg_data
1046: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1047: THEN
1048: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1049: END IF;
1050: -- Standard call to get message count and if count=1, get the message
1051: FND_MSG_PUB.Count_And_Get (
1052: p_encoded => FND_API.G_FALSE,
1053: p_count => x_msg_count,
1054: p_data => x_msg_data
1134:
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: ROLLBACK TO COPY_Camp_Schedule_PUB;
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: FND_MSG_PUB.Count_And_Get (
1140: p_encoded => FND_API.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1144:
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: ROLLBACK TO COPY_Camp_Schedule_PUB;
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: -- Standard call to get message count and if count=1, get the message
1149: FND_MSG_PUB.Count_And_Get (
1150: p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1158: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1161: END IF;
1162: -- Standard call to get message count and if count=1, get the message
1163: FND_MSG_PUB.Count_And_Get (
1164: p_encoded => FND_API.G_FALSE,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data