[Home] [Help]
55: FROM AMS_TEMPL_RESPONSIBILITY
56: WHERE TEMPL_RESPONSIBILITY_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_template_res_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_template_res_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
64: p_api_version_number,
65: l_api_name,
66: G_PKG_NAME)
163: --
164: -- End of API body
165: --
166:
167: -- Standard check for p_commit
168: IF FND_API.to_Boolean( p_commit )
169: THEN
170: COMMIT WORK;
171: END IF;
176:
177: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
178: END IF;
179:
180: -- Standard call to get message count and if count is 1, get message info.
181: FND_MSG_PUB.Count_And_Get
182: (p_count => x_msg_count,
183: p_data => x_msg_data
184: );
190:
191: WHEN FND_API.G_EXC_ERROR THEN
192: ROLLBACK TO CREATE_template_res_PVT;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: -- Standard call to get message count and if count=1, get the message
195: FND_MSG_PUB.Count_And_Get (
196: p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data
200:
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: ROLLBACK TO CREATE_template_res_PVT;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: -- Standard call to get message count and if count=1, get the message
205: FND_MSG_PUB.Count_And_Get (
206: p_encoded => FND_API.G_FALSE,
207: p_count => x_msg_count,
208: p_data => x_msg_data
214: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
217: END IF;
218: -- Standard call to get message count and if count=1, get the message
219: FND_MSG_PUB.Count_And_Get (
220: p_encoded => FND_API.G_FALSE,
221: p_count => x_msg_count,
222: p_data => x_msg_data
254: l_tar_template_res_rec AMS_template_res_PVT.template_res_rec_type := P_template_res_rec;
255: l_rowid ROWID;
256:
257: BEGIN
258: -- Standard Start of API savepoint
259: SAVEPOINT UPDATE_template_res_PVT;
260:
261: -- Standard call to check for call compatibility.
262: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
257: BEGIN
258: -- Standard Start of API savepoint
259: SAVEPOINT UPDATE_template_res_PVT;
260:
261: -- Standard call to check for call compatibility.
262: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
263: p_api_version_number,
264: l_api_name,
265: G_PKG_NAME)
365: --
366: -- End of API body.
367: --
368:
369: -- Standard check for p_commit
370: IF FND_API.to_Boolean( p_commit )
371: THEN
372: COMMIT WORK;
373: END IF;
378:
379: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
380: END IF;
381:
382: -- Standard call to get message count and if count is 1, get message info.
383: FND_MSG_PUB.Count_And_Get
384: (p_count => x_msg_count,
385: p_data => x_msg_data
386: );
392:
393: WHEN FND_API.G_EXC_ERROR THEN
394: ROLLBACK TO UPDATE_template_res_PVT;
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: ROLLBACK TO UPDATE_template_res_PVT;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: -- Standard call to get message count and if count=1, get the message
407: FND_MSG_PUB.Count_And_Get (
408: p_encoded => FND_API.G_FALSE,
409: p_count => x_msg_count,
410: p_data => x_msg_data
416: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
417: THEN
418: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
419: END IF;
420: -- Standard call to get message count and if count=1, get the message
421: FND_MSG_PUB.Count_And_Get (
422: p_encoded => FND_API.G_FALSE,
423: p_count => x_msg_count,
424: p_data => x_msg_data
443: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
444: l_object_version_number NUMBER;
445:
446: BEGIN
447: -- Standard Start of API savepoint
448: SAVEPOINT DELETE_template_res_PVT;
449:
450: -- Standard call to check for call compatibility.
451: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
446: BEGIN
447: -- Standard Start of API savepoint
448: SAVEPOINT DELETE_template_res_PVT;
449:
450: -- Standard call to check for call compatibility.
451: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
452: p_api_version_number,
453: l_api_name,
454: G_PKG_NAME)
478: If (SQL%NOTFOUND) then
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
480: End If;
481:
482: -- Standard check for p_commit
483: IF FND_API.to_Boolean( p_commit )
484: THEN
485: COMMIT WORK;
486: END IF;
491:
492: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
493: END IF;
494:
495: -- Standard call to get message count and if count is 1, get message info.
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count,
498: p_data => x_msg_data
499: );
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO DELETE_template_res_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: -- Standard call to get message count and if count=1, get the message
510: FND_MSG_PUB.Count_And_Get (
511: p_encoded => FND_API.G_FALSE,
512: p_count => x_msg_count,
513: p_data => x_msg_data
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO DELETE_template_res_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: -- Standard call to get message count and if count=1, get the message
520: FND_MSG_PUB.Count_And_Get (
521: p_encoded => FND_API.G_FALSE,
522: p_count => x_msg_count,
523: p_data => x_msg_data
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:
583: -- Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
585: p_api_version_number,
586: l_api_name,
587: G_PKG_NAME)
635:
636: WHEN FND_API.G_EXC_ERROR THEN
637: ROLLBACK TO LOCK_template_res_PVT;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: -- Standard call to get message count and if count=1, get the message
640: FND_MSG_PUB.Count_And_Get (
641: p_encoded => FND_API.G_FALSE,
642: p_count => x_msg_count,
643: p_data => x_msg_data
645:
646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: ROLLBACK TO LOCK_template_res_PVT;
648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
649: -- Standard call to get message count and if count=1, get the message
650: FND_MSG_PUB.Count_And_Get (
651: p_encoded => FND_API.G_FALSE,
652: p_count => x_msg_count,
653: p_data => x_msg_data
659: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
660: THEN
661: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
662: END IF;
663: -- Standard call to get message count and if count=1, get the message
664: FND_MSG_PUB.Count_And_Get (
665: p_encoded => FND_API.G_FALSE,
666: p_count => x_msg_count,
667: p_data => x_msg_data
913: l_object_version_number NUMBER;
914: l_template_res_rec AMS_template_res_PVT.template_res_rec_type;
915:
916: BEGIN
917: -- Standard Start of API savepoint
918: SAVEPOINT VALIDATE_template_res_;
919:
920: -- Standard call to check for call compatibility.
921: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
916: BEGIN
917: -- Standard Start of API savepoint
918: SAVEPOINT VALIDATE_template_res_;
919:
920: -- Standard call to check for call compatibility.
921: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
922: p_api_version_number,
923: l_api_name,
924: G_PKG_NAME)
983:
984: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
985: END IF;
986:
987: -- Standard call to get message count and if count is 1, get message info.
988: FND_MSG_PUB.Count_And_Get
989: (p_count => x_msg_count,
990: p_data => x_msg_data
991: );
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO VALIDATE_template_res_;
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: -- Standard call to get message count and if count=1, get the message
1002: FND_MSG_PUB.Count_And_Get (
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO VALIDATE_template_res_;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1021: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1024: END IF;
1025: -- Standard call to get message count and if count=1, get the message
1026: FND_MSG_PUB.Count_And_Get (
1027: p_encoded => FND_API.G_FALSE,
1028: p_count => x_msg_count,
1029: p_data => x_msg_data
1059: IF (AMS_DEBUG_HIGH_ON) THEN
1060:
1061: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1062: END IF;
1063: -- Standard call to get message count and if count is 1, get message info.
1064: FND_MSG_PUB.Count_And_Get
1065: (p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );