[Home] [Help]
103: l_pvt_resource_rec AMS_ActResource_PVT.Act_Resource_rec_type ;
104: l_pub_resource_rec Act_Resource_rec_type := p_act_Resource_rec;
105:
106: BEGIN
107: -- Standard Start of API savepoint
108: SAVEPOINT Create_Act_Resource_PUB;
109:
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF FND_API.to_Boolean( p_init_msg_list )
211: END IF;
212: END IF;
213:
214:
215: -- Standard check for p_commit
216: IF FND_API.to_Boolean( p_commit )
217: THEN
218: COMMIT WORK;
219: END IF;
221:
222: -- Debug Message
223: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
224:
225: -- Standard call to get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get
227: (p_count => x_msg_count,
228: p_data => x_msg_data
229: );
238:
239: WHEN FND_API.G_EXC_ERROR THEN
240: ROLLBACK TO Create_Act_Resource_PUB;
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: -- Standard call to get message count and if count=1, get the message
243: FND_MSG_PUB.Count_And_Get (
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO Create_Act_Resource_PUB;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: -- Standard call to get message count and if count=1, get the message
253: FND_MSG_PUB.Count_And_Get (
254: p_encoded => FND_API.G_FALSE,
255: p_count => x_msg_count,
256: p_data => x_msg_data
262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
265: END IF;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data
304: l_pvt_resource_rec AMS_ActResource_PVT.Act_Resource_rec_type ;
305: l_pub_resource_rec Act_Resource_rec_type := p_act_Resource_rec;
306:
307: BEGIN
308: -- Standard Start of API savepoint
309: SAVEPOINT Update_Act_Resource_PUB;
310:
311: -- Initialize message list if p_init_msg_list is set to TRUE.
312: IF FND_API.to_Boolean( p_init_msg_list )
405: RAISE FND_API.g_exc_unexpected_error;
406: END IF;
407: END IF;
408:
409: -- Standard check for p_commit
410: IF FND_API.to_Boolean( p_commit )
411: THEN
412: COMMIT WORK;
413: END IF;
415:
416: -- Debug Message
417: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
418:
419: -- Standard call to get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get
421: (p_count => x_msg_count,
422: p_data => x_msg_data
423: );
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO Update_Act_Resource_PUB;
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data
443:
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO Update_Act_Resource_PUB;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
457: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
458: THEN
459: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
460: END IF;
461: -- Standard call to get message count and if count=1, get the message
462: FND_MSG_PUB.Count_And_Get (
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data
499: l_object_version NUMBER := p_object_version;
500: l_return_status VARCHAR2(1);
501:
502: BEGIN
503: -- Standard Start of API savepoint
504: SAVEPOINT Delete_Act_Resource_PUB;
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE.
507: IF FND_API.to_Boolean( p_init_msg_list )
602: RAISE FND_API.g_exc_unexpected_error;
603: END IF;
604: END IF;
605:
606: -- Standard check for p_commit
607: IF FND_API.to_Boolean( p_commit )
608: THEN
609: COMMIT WORK;
610: END IF;
612:
613: -- Debug Message
614: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
615:
616: -- Standard call to get message count and if count is 1, get message info.
617: FND_MSG_PUB.Count_And_Get
618: (p_count => x_msg_count,
619: p_data => x_msg_data
620: );
630:
631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO Delete_Act_Resource_PUB;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: -- Standard call to get message count and if count=1, get the message
635: FND_MSG_PUB.Count_And_Get (
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO Delete_Act_Resource_PUB;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_msg_count,
648: p_data => x_msg_data
654: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
655: THEN
656: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
657: END IF;
658: -- Standard call to get message count and if count=1, get the message
659: FND_MSG_PUB.Count_And_Get (
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_msg_count,
662: p_data => x_msg_data
699: l_return_status VARCHAR2(1);
700:
701: BEGIN
702:
703: -- Standard call to check for call compatibility.
704: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
705: p_api_version,
706: l_api_name,
707: G_PACKAGE_NAME)
823:
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO LOCK_Act_Resource_PUB;
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: -- Standard call to get message count and if count=1, get the message
828: FND_MSG_PUB.Count_And_Get (
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: ROLLBACK TO LOCK_Act_Resource_PUB;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: -- Standard call to get message count and if count=1, get the message
838: FND_MSG_PUB.Count_And_Get (
839: p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,
841: p_data => x_msg_data
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PACKAGE_NAME,l_api_name);
850: END IF;
851: -- Standard call to get message count and if count=1, get the message
852: FND_MSG_PUB.Count_And_Get (
853: p_encoded => FND_API.G_FALSE,
854: p_count => x_msg_count,
855: p_data => x_msg_data
976:
977: -- Debug Message
978: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
979:
980: -- Standard call to get message count and if count is 1, get message info.
981: FND_MSG_PUB.Count_And_Get
982: (p_count => x_msg_count,
983: p_data => x_msg_data
984: );