DBA Data[Home] [Help]

APPS.AMS_IMP_DOC_PVT dependencies on STANDARD

Line 50: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

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: --

Line 97: -- Standard Start of API savepoint

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,

Line 100: -- Standard call to check for call compatibility.

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)

Line 219: -- Standard check for p_commit

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;

Line 233: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 247: -- Standard call to get message count and if count=1, get the message

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

Line 257: -- Standard call to get message count and if count=1, get the message

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

Line 271: -- Standard call to get message count and if count=1, get the message

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

Line 303: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

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: --

Line 347: -- Standard Start of API savepoint

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,

Line 350: -- Standard call to check for call compatibility.

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)

Line 468: -- Standard check for p_commit

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;

Line 482: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 496: -- Standard call to get message count and if count=1, get the message

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

Line 506: -- Standard call to get message count and if count=1, get the message

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

Line 520: -- Standard call to get message count and if count=1, get the message

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

Line 553: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

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: --

Line 581: -- Standard Start of API savepoint

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,

Line 584: -- Standard call to check for call compatibility.

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)

Line 630: -- Standard check for p_commit

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;

Line 644: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 658: -- Standard call to get message count and if count=1, get the message

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

Line 668: -- Standard call to get message count and if count=1, get the message

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

Line 682: -- Standard call to get message count and if count=1, get the message

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

Line 716: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

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: --

Line 768: -- Standard call to check for call compatibility.

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)

Line 825: -- Standard call to get message count and if count=1, get the message

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

Line 835: -- Standard call to get message count and if count=1, get the message

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

Line 849: -- Standard call to get message count and if count=1, get the message

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

Line 1302: -- Standard Start of API savepoint

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,

Line 1305: -- Standard call to check for call compatibility.

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)

Line 1383: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1397: -- Standard call to get message count and if count=1, get the message

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

Line 1407: -- Standard call to get message count and if count=1, get the message

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

Line 1421: -- Standard call to get message count and if count=1, get the message

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

Line 1461: -- Standard call to get message count and if count is 1, get message info.

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: );