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: --
93: FROM AMS_IMP_DOCUMENTS
94: WHERE imp_document_id = l_id;
95:
96: BEGIN
97: -- Standard Start of API savepoint
98: SAVEPOINT create_imp_doc_pvt;
99:
100: -- Standard call to check for call compatibility.
101: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
96: BEGIN
97: -- Standard Start of API savepoint
98: SAVEPOINT create_imp_doc_pvt;
99:
100: -- Standard call to check for call compatibility.
101: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
102: p_api_version_number,
103: l_api_name,
104: G_PKG_NAME)
215: --
216: -- End of API body
217: --
218:
219: -- Standard check for p_commit
220: IF FND_API.to_Boolean( p_commit )
221: THEN
222: COMMIT WORK;
223: END IF;
229: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
230: END IF;
231:
232:
233: -- Standard call to get message count and if count is 1, get message info.
234: FND_MSG_PUB.Count_And_Get
235: (p_count => x_msg_count,
236: p_data => x_msg_data
237: );
243:
244: WHEN FND_API.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Imp_Doc_PVT;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
253:
254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
255: ROLLBACK TO CREATE_Imp_Doc_PVT;
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
267: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
268: THEN
269: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
270: END IF;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
299: -- x_return_status OUT VARCHAR2
300: -- x_msg_count OUT NUMBER
301: -- x_msg_data OUT VARCHAR2
302: -- Version : Current version 1.0
303: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
304: -- and basic operation, developer must manually add parameters and business logic as necessary.
305: --
306: -- History
307: --
343: l_tar_imp_doc_rec imp_doc_rec_type := P_imp_doc_rec;
344: l_rowid ROWID;
345:
346: BEGIN
347: -- Standard Start of API savepoint
348: SAVEPOINT update_imp_doc_pvt;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
346: BEGIN
347: -- Standard Start of API savepoint
348: SAVEPOINT update_imp_doc_pvt;
349:
350: -- Standard call to check for call compatibility.
351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
352: p_api_version_number,
353: l_api_name,
354: G_PKG_NAME)
464: --
465: -- End of API body.
466: --
467:
468: -- Standard check for p_commit
469: IF FND_API.to_Boolean( p_commit )
470: THEN
471: COMMIT WORK;
472: END IF;
478: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
479: END IF;
480:
481:
482: -- Standard call to get message count and if count is 1, get message info.
483: FND_MSG_PUB.Count_And_Get
484: (p_count => x_msg_count,
485: p_data => x_msg_data
486: );
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO UPDATE_Imp_Doc_PVT;
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: -- Standard call to get message count and if count=1, get the message
497: FND_MSG_PUB.Count_And_Get (
498: p_encoded => FND_API.G_FALSE,
499: p_count => x_msg_count,
500: p_data => x_msg_data
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO UPDATE_Imp_Doc_PVT;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: -- Standard call to get message count and if count=1, get the message
507: FND_MSG_PUB.Count_And_Get (
508: p_encoded => FND_API.G_FALSE,
509: p_count => x_msg_count,
510: p_data => x_msg_data
516: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
517: THEN
518: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
519: END IF;
520: -- Standard call to get message count and if count=1, get the message
521: FND_MSG_PUB.Count_And_Get (
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data
549: -- x_return_status OUT VARCHAR2
550: -- x_msg_count OUT NUMBER
551: -- x_msg_data OUT VARCHAR2
552: -- Version : Current version 1.0
553: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
554: -- and basic operation, developer must manually add parameters and business logic as necessary.
555: --
556: -- History
557: --
577: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
578: l_object_version_number NUMBER;
579:
580: BEGIN
581: -- Standard Start of API savepoint
582: SAVEPOINT delete_imp_doc_pvt;
583:
584: -- Standard call to check for call compatibility.
585: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: BEGIN
581: -- Standard Start of API savepoint
582: SAVEPOINT delete_imp_doc_pvt;
583:
584: -- Standard call to check for call compatibility.
585: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
586: p_api_version_number,
587: l_api_name,
588: G_PKG_NAME)
626: --
627: -- End of API body
628: --
629:
630: -- Standard check for p_commit
631: IF FND_API.to_Boolean( p_commit )
632: THEN
633: COMMIT WORK;
634: END IF;
640: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
641: END IF;
642:
643:
644: -- Standard call to get message count and if count is 1, get message info.
645: FND_MSG_PUB.Count_And_Get
646: (p_count => x_msg_count,
647: p_data => x_msg_data
648: );
654:
655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO DELETE_Imp_Doc_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
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
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO DELETE_Imp_Doc_PVT;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: -- Standard call to get message count and if count=1, get the message
669: FND_MSG_PUB.Count_And_Get (
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_msg_count,
672: p_data => x_msg_data
678: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
679: THEN
680: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
681: END IF;
682: -- Standard call to get message count and if count=1, get the message
683: FND_MSG_PUB.Count_And_Get (
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_msg_count,
686: p_data => x_msg_data
712: -- x_return_status OUT VARCHAR2
713: -- x_msg_count OUT NUMBER
714: -- x_msg_data OUT VARCHAR2
715: -- Version : Current version 1.0
716: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
717: -- and basic operation, developer must manually add parameters and business logic as necessary.
718: --
719: -- History
720: --
764: END IF;
765:
766:
767:
768: -- Standard call to check for call compatibility.
769: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
770: p_api_version_number,
771: l_api_name,
772: G_PKG_NAME)
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823: ROLLBACK TO LOCK_Imp_Doc_PVT;
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: -- Standard call to get message count and if count=1, get the message
826: FND_MSG_PUB.Count_And_Get (
827: p_encoded => FND_API.G_FALSE,
828: p_count => x_msg_count,
829: p_data => x_msg_data
831:
832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
833: ROLLBACK TO LOCK_Imp_Doc_PVT;
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: -- Standard call to get message count and if count=1, get the message
836: FND_MSG_PUB.Count_And_Get (
837: p_encoded => FND_API.G_FALSE,
838: p_count => x_msg_count,
839: p_data => x_msg_data
845: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
846: THEN
847: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
848: END IF;
849: -- Standard call to get message count and if count=1, get the message
850: FND_MSG_PUB.Count_And_Get (
851: p_encoded => FND_API.G_FALSE,
852: p_count => x_msg_count,
853: p_data => x_msg_data
1298: l_object_version_number NUMBER;
1299: l_imp_doc_rec imp_doc_rec_type;
1300:
1301: BEGIN
1302: -- Standard Start of API savepoint
1303: SAVEPOINT validate_imp_doc_;
1304:
1305: -- Standard call to check for call compatibility.
1306: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1301: BEGIN
1302: -- Standard Start of API savepoint
1303: SAVEPOINT validate_imp_doc_;
1304:
1305: -- Standard call to check for call compatibility.
1306: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1307: p_api_version_number,
1308: l_api_name,
1309: G_PKG_NAME)
1379: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1380: END IF;
1381:
1382:
1383: -- Standard call to get message count and if count is 1, get message info.
1384: FND_MSG_PUB.Count_And_Get
1385: (p_count => x_msg_count,
1386: p_data => x_msg_data
1387: );
1393:
1394: WHEN FND_API.G_EXC_ERROR THEN
1395: ROLLBACK TO VALIDATE_Imp_Doc_;
1396: x_return_status := FND_API.G_RET_STS_ERROR;
1397: -- Standard call to get message count and if count=1, get the message
1398: FND_MSG_PUB.Count_And_Get (
1399: p_encoded => FND_API.G_FALSE,
1400: p_count => x_msg_count,
1401: p_data => x_msg_data
1403:
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405: ROLLBACK TO VALIDATE_Imp_Doc_;
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1407: -- Standard call to get message count and if count=1, get the message
1408: FND_MSG_PUB.Count_And_Get (
1409: p_encoded => FND_API.G_FALSE,
1410: p_count => x_msg_count,
1411: p_data => x_msg_data
1417: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1418: THEN
1419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1420: END IF;
1421: -- Standard call to get message count and if count=1, get the message
1422: FND_MSG_PUB.Count_And_Get (
1423: p_encoded => FND_API.G_FALSE,
1424: p_count => x_msg_count,
1425: p_data => x_msg_data
1457: IF (AMS_DEBUG_HIGH_ON) THEN
1458:
1459: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1460: END IF;
1461: -- Standard call to get message count and if count is 1, get message info.
1462: FND_MSG_PUB.Count_And_Get
1463: (p_count => x_msg_count,
1464: p_data => x_msg_data
1465: );