DBA Data[Home] [Help]

APPS.AMS_IMP_DOC_CON_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 98: -- Standard Start of API savepoint

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,

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

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)

Line 216: -- Standard check for p_commit

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;

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

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

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

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

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

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

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

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

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

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

Line 344: -- Standard Start of API savepoint

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,

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

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)

Line 462: -- Standard check for p_commit

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;

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

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

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

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

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

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

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

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

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

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

Line 575: -- Standard Start of API savepoint

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,

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

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)

Line 624: -- Standard check for p_commit

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;

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

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

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

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

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

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

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

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

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

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

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

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)

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

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

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

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

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

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

Line 1256: -- Standard Start of API savepoint

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,

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

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)

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

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

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

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

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

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

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

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

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

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