[Home] [Help]
148: l_pvt_deliv_rec AMS_deliverable_PVT.deliv_rec_type ;
149: l_pub_deliv_rec deliv_rec_type := p_deliv_rec;
150:
151: BEGIN
152: -- Standard Start of API savepoint
153: SAVEPOINT CREATE_deliv_PUB;
154:
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list )
190: --
191: -- End of API body.
192: --
193:
194: -- Standard check for p_commit
195: IF FND_API.to_Boolean( p_commit )
196: THEN
197: COMMIT WORK;
198: END IF;
202: IF (AMS_DEBUG_HIGH_ON) THEN
203: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
204: END IF;
205:
206: -- Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: (p_count => x_msg_count,
209: p_data => x_msg_data
210: );
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK TO CREATE_deliv_PUB;
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
230:
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO CREATE_deliv_PUB;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data
244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data
283: BEGIN
284:
285: SAVEPOINT CREATE_Deliverable_PUB;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
289: p_api_version_number,
290: l_api_name,
291: G_PKG_NAME)
399: END IF;
400: END IF;
401: ------------------------------------------
402:
403: -- Standard check for p_commit
404: IF FND_API.to_Boolean( p_commit )
405: THEN
406: COMMIT WORK;
407: END IF;
411: IF (AMS_DEBUG_HIGH_ON) THEN
412: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
413: END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.
416: FND_MSG_PUB.Count_And_Get
417: (p_count => x_msg_count,
418: p_data => x_msg_data
419: );
429:
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_Deliverable_PUB;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data
439:
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_Deliverable_PUB;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: -- Standard call to get message count and if count=1, get the message
444: FND_MSG_PUB.Count_And_Get (
445: p_encoded => FND_API.G_FALSE,
446: p_count => x_msg_count,
447: p_data => x_msg_data
453: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
460: p_count => x_msg_count,
461: p_data => x_msg_data
483: l_pub_deliv_rec deliv_rec_type := p_deliv_rec;
484:
485: BEGIN
486:
487: -- Standard Start of API savepoint
488: SAVEPOINT UPDATE_Deliv_PUB;
489:
490: -- Standard call to check for call compatibility.
491: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
486:
487: -- Standard Start of API savepoint
488: SAVEPOINT UPDATE_Deliv_PUB;
489:
490: -- Standard call to check for call compatibility.
491: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
492: p_api_version_number,
493: l_api_name,
494: G_PKG_NAME)
540: IF (AMS_DEBUG_HIGH_ON) THEN
541: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
542: END IF;
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count,
547: p_data => x_msg_data
548: );
554:
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO UPDATE_Deliv_PUB;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
564:
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO UPDATE_Deliv_PUB;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data
609: l_pvt_deliv_rec AMS_Deliverable_PVT.deliv_rec_type := p_deliv_rec;
610:
611: BEGIN
612:
613: -- Standard Start of API savepoint
614: SAVEPOINT UPDATE_Deliverable_PUB;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
612:
613: -- Standard Start of API savepoint
614: SAVEPOINT UPDATE_Deliverable_PUB;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
618: p_api_version_number,
619: l_api_name,
620: G_PKG_NAME)
688: END IF;
689: --
690: -- End of API body
691: --
692: -- Standard check for p_commit
693: IF FND_API.to_Boolean( p_commit )
694: THEN
695: COMMIT WORK;
696: END IF;
728: IF (AMS_DEBUG_HIGH_ON) THEN
729: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
730: END IF;
731:
732: -- Standard call to get message count and if count is 1, get message info.
733: FND_MSG_PUB.Count_And_Get
734: (p_count => x_msg_count,
735: p_data => x_msg_data
736: );
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO UPDATE_Deliverable_PUB;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data
752:
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: ROLLBACK TO UPDATE_Deliverable_PUB;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: -- Standard call to get message count and if count=1, get the message
757: FND_MSG_PUB.Count_And_Get (
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data
766: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message
771: FND_MSG_PUB.Count_And_Get (
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_msg_count,
774: p_data => x_msg_data
800: l_return_status VARCHAR2(1);
801:
802:
803: BEGIN
804: -- Standard Start of API savepoint
805: SAVEPOINT DELETE_Deliverable_PUB;
806:
807: -- Standard call to check for call compatibility.
808: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
803: BEGIN
804: -- Standard Start of API savepoint
805: SAVEPOINT DELETE_Deliverable_PUB;
806:
807: -- Standard call to check for call compatibility.
808: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
809: p_api_version_number,
810: l_api_name,
811: G_PKG_NAME)
918: END IF;
919: -------------------------------------------------------
920:
921:
922: -- Standard check for p_commit
923: IF FND_API.to_Boolean( p_commit )
924: THEN
925: COMMIT WORK;
926: END IF;
930: IF (AMS_DEBUG_HIGH_ON) THEN
931: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
932: END IF;
933:
934: -- Standard call to get message count and if count is 1, get message info.
935: FND_MSG_PUB.Count_And_Get
936: (p_count => x_msg_count,
937: p_data => x_msg_data
938: );
944:
945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO DELETE_Deliverable_PUB;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: -- Standard call to get message count and if count=1, get the message
949: FND_MSG_PUB.Count_And_Get (
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data
954:
955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: ROLLBACK TO DELETE_Deliverable_PUB;
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data
968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message
973: FND_MSG_PUB.Count_And_Get (
974: p_encoded => FND_API.G_FALSE,
975: p_count => x_msg_count,
976: p_data => x_msg_data
1096:
1097: -- Debug Message
1098: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1099:
1100: -- Standard call to get message count and if count is 1, get message info.
1101: FND_MSG_PUB.Count_And_Get
1102: (p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );
1164: l_return_status VARCHAR2(1);
1165:
1166: BEGIN
1167:
1168: -- Standard call to check for call compatibility.
1169: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1170: p_api_version_number,
1171: l_api_name,
1172: G_PKG_NAME)
1287:
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO LOCK_Deliverable_PUB;
1290: x_return_status := FND_API.G_RET_STS_ERROR;
1291: -- Standard call to get message count and if count=1, get the message
1292: FND_MSG_PUB.Count_And_Get (
1293: p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data
1297:
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: ROLLBACK TO LOCK_Deliverable_PUB;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: -- Standard call to get message count and if count=1, get the message
1302: FND_MSG_PUB.Count_And_Get (
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data
1311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => x_msg_count,
1319: p_data => x_msg_data