46: -- x_return_status OUT VARCHAR2
47: -- x_msg_count OUT NUMBER
48: -- x_msg_data OUT VARCHAR2
49: -- Version : Current version 1.0
50: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
51: -- and basic operation, developer must manually add parameters and business logic as necessary.
52: --
53: -- History
54: --
94: FROM ams_imp_doc_content
95: WHERE imp_doc_content_id = l_id;
96:
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT create_imp_doc_pvt;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT create_imp_doc_pvt;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
103: p_api_version_number,
104: l_api_name,
105: G_PKG_NAME)
212: --
213: -- End of API body
214: --
215:
216: -- Standard check for p_commit
217: IF FND_API.to_Boolean( p_commit )
218: THEN
219: COMMIT WORK;
220: END IF;
226: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
227: END IF;
228:
229:
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get
232: (p_count => x_msg_count,
233: p_data => x_msg_data
234: );
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_Imp_Doc_PVT;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO CREATE_Imp_Doc_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: -- Standard call to get message count and if count=1, get the message
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => x_msg_count,
258: p_data => x_msg_data
264: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
267: END IF;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
296: -- x_return_status OUT VARCHAR2
297: -- x_msg_count OUT NUMBER
298: -- x_msg_data OUT VARCHAR2
299: -- Version : Current version 1.0
300: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
301: -- and basic operation, developer must manually add parameters and business logic as necessary.
302: --
303: -- History
304: --
340: l_tar_imp_doc_rec imp_doccon_rec_type := P_imp_doc_rec;
341: l_rowid ROWID;
342:
343: BEGIN
344: -- Standard Start of API savepoint
345: SAVEPOINT update_imp_doc_pvt;
346:
347: -- Standard call to check for call compatibility.
348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
343: BEGIN
344: -- Standard Start of API savepoint
345: SAVEPOINT update_imp_doc_pvt;
346:
347: -- Standard call to check for call compatibility.
348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
349: p_api_version_number,
350: l_api_name,
351: G_PKG_NAME)
458: --
459: -- End of API body.
460: --
461:
462: -- Standard check for p_commit
463: IF FND_API.to_Boolean( p_commit )
464: THEN
465: COMMIT WORK;
466: END IF;
472: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
473: END IF;
474:
475:
476: -- Standard call to get message count and if count is 1, get message info.
477: FND_MSG_PUB.Count_And_Get
478: (p_count => x_msg_count,
479: p_data => x_msg_data
480: );
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Imp_Doc_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ROLLBACK TO UPDATE_Imp_Doc_PVT;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
510: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
511: THEN
512: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
513: END IF;
514: -- Standard call to get message count and if count=1, get the message
515: FND_MSG_PUB.Count_And_Get (
516: p_encoded => FND_API.G_FALSE,
517: p_count => x_msg_count,
518: p_data => x_msg_data
543: -- x_return_status OUT VARCHAR2
544: -- x_msg_count OUT NUMBER
545: -- x_msg_data OUT VARCHAR2
546: -- Version : Current version 1.0
547: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
548: -- and basic operation, developer must manually add parameters and business logic as necessary.
549: --
550: -- History
551: --
571: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
572: l_object_version_number NUMBER;
573:
574: BEGIN
575: -- Standard Start of API savepoint
576: SAVEPOINT delete_imp_doc_pvt;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
574: BEGIN
575: -- Standard Start of API savepoint
576: SAVEPOINT delete_imp_doc_pvt;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
620: --
621: -- End of API body
622: --
623:
624: -- Standard check for p_commit
625: IF FND_API.to_Boolean( p_commit )
626: THEN
627: COMMIT WORK;
628: END IF;
634: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
635: END IF;
636:
637:
638: -- Standard call to get message count and if count is 1, get message info.
639: FND_MSG_PUB.Count_And_Get
640: (p_count => x_msg_count,
641: p_data => x_msg_data
642: );
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Imp_Doc_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: -- Standard call to get message count and if count=1, get the message
653: FND_MSG_PUB.Count_And_Get (
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
658:
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO DELETE_Imp_Doc_PVT;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
672: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
675: END IF;
676: -- Standard call to get message count and if count=1, get the message
677: FND_MSG_PUB.Count_And_Get (
678: p_encoded => FND_API.G_FALSE,
679: p_count => x_msg_count,
680: p_data => x_msg_data
706: -- x_return_status OUT VARCHAR2
707: -- x_msg_count OUT NUMBER
708: -- x_msg_data OUT VARCHAR2
709: -- Version : Current version 1.0
710: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
711: -- and basic operation, developer must manually add parameters and business logic as necessary.
712: --
713: -- History
714: --
758: END IF;
759:
760:
761:
762: -- Standard call to check for call compatibility.
763: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
764: p_api_version_number,
765: l_api_name,
766: G_PKG_NAME)
815:
816: WHEN FND_API.G_EXC_ERROR THEN
817: ROLLBACK TO LOCK_Imp_Doc_PVT;
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: -- Standard call to get message count and if count=1, get the message
820: FND_MSG_PUB.Count_And_Get (
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827: ROLLBACK TO LOCK_Imp_Doc_PVT;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: -- Standard call to get message count and if count=1, get the message
830: FND_MSG_PUB.Count_And_Get (
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data
839: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
842: END IF;
843: -- Standard call to get message count and if count=1, get the message
844: FND_MSG_PUB.Count_And_Get (
845: p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => x_msg_data
1252: l_object_version_number NUMBER;
1253: l_imp_doc_rec imp_doccon_rec_type;
1254:
1255: BEGIN
1256: -- Standard Start of API savepoint
1257: SAVEPOINT validate_imp_doc_;
1258:
1259: -- Standard call to check for call compatibility.
1260: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1255: BEGIN
1256: -- Standard Start of API savepoint
1257: SAVEPOINT validate_imp_doc_;
1258:
1259: -- Standard call to check for call compatibility.
1260: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1261: p_api_version_number,
1262: l_api_name,
1263: G_PKG_NAME)
1333: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1334: END IF;
1335:
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get
1339: (p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_Imp_Doc_;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1357:
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: ROLLBACK TO VALIDATE_Imp_Doc_;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- Standard call to get message count and if count=1, get the message
1362: FND_MSG_PUB.Count_And_Get (
1363: p_encoded => FND_API.G_FALSE,
1364: p_count => x_msg_count,
1365: p_data => x_msg_data
1371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message
1376: FND_MSG_PUB.Count_And_Get (
1377: p_encoded => FND_API.G_FALSE,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data
1411: IF (AMS_DEBUG_HIGH_ON) THEN
1412:
1413: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1414: END IF;
1415: -- Standard call to get message count and if count is 1, get message info.
1416: FND_MSG_PUB.Count_And_Get
1417: (p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );