DBA Data[Home] [Help]

APPS.AMS_PROD_TEMPLATE_PVT dependencies on STANDARD

Line 85: -- Standard Start of API savepoint

81:
82: l_get_service_attr c_get_service_attr%ROWTYPE;
83:
84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT CREATE_Prod_Template_PVT;
87:
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT CREATE_Prod_Template_PVT;
87:
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
90: p_api_version_number,
91: l_api_name,
92: G_PKG_NAME)

Line 332: -- Standard check for p_commit

328: --
329: -- End of API body
330: --
331:
332: -- Standard check for p_commit
333: IF FND_API.to_Boolean( p_commit )
334: THEN
335: COMMIT WORK;
336: END IF;

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

341:
342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_MSG_PUB.Count_And_Get
347: (p_count => x_msg_count,
348: p_data => x_msg_data
349: );

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

355:
356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO CREATE_Prod_Template_PVT;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: -- Standard call to get message count and if count=1, get the message
360: FND_MSG_PUB.Count_And_Get (
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_msg_count,
363: p_data => x_msg_data

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

365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO CREATE_Prod_Template_PVT;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: -- Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data

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

379: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
382: END IF;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data

Line 423: -- Standard Start of API savepoint

419: l_tar_prod_template_rec AMS_Prod_Template_PVT.prod_template_rec_type := P_prod_template_rec;
420: l_rowid ROWID;
421:
422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT UPDATE_Prod_Template_PVT;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT UPDATE_Prod_Template_PVT;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
428: p_api_version_number,
429: l_api_name,
430: G_PKG_NAME)

Line 545: -- Standard check for p_commit

541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: End If;
543:
544:
545: -- Standard check for p_commit
546: IF FND_API.to_Boolean( p_commit )
547: THEN
548: COMMIT WORK;
549: END IF;

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

554:
555: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
556: END IF;
557:
558: -- Standard call to get message count and if count is 1, get message info.
559: FND_MSG_PUB.Count_And_Get
560: (p_count => x_msg_count,
561: p_data => x_msg_data
562: );

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

568:
569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO UPDATE_Prod_Template_PVT;
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: -- Standard call to get message count and if count=1, get the message
573: FND_MSG_PUB.Count_And_Get (
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_msg_count,
576: p_data => x_msg_data

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

578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580: ROLLBACK TO UPDATE_Prod_Template_PVT;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data

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

592: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
595: END IF;
596: -- Standard call to get message count and if count=1, get the message
597: FND_MSG_PUB.Count_And_Get (
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_msg_count,
600: p_data => x_msg_data

Line 623: -- Standard Start of API savepoint

619: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
620: l_object_version_number NUMBER;
621:
622: BEGIN
623: -- Standard Start of API savepoint
624: SAVEPOINT DELETE_Prod_Template_PVT;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

622: BEGIN
623: -- Standard Start of API savepoint
624: SAVEPOINT DELETE_Prod_Template_PVT;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
628: p_api_version_number,
629: l_api_name,
630: G_PKG_NAME)

Line 708: -- Standard check for p_commit

704: --
705: -- End of API body
706: --
707:
708: -- Standard check for p_commit
709: IF FND_API.to_Boolean( p_commit )
710: THEN
711: COMMIT WORK;
712: END IF;

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

717:
718: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
719: END IF;
720:
721: -- Standard call to get message count and if count is 1, get message info.
722: FND_MSG_PUB.Count_And_Get
723: (p_count => x_msg_count,
724: p_data => x_msg_data
725: );

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

731:
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO DELETE_Prod_Template_PVT;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: -- Standard call to get message count and if count=1, get the message
736: FND_MSG_PUB.Count_And_Get (
737: p_encoded => FND_API.G_FALSE,
738: p_count => x_msg_count,
739: p_data => x_msg_data

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

741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO DELETE_Prod_Template_PVT;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: -- Standard call to get message count and if count=1, get the message
746: FND_MSG_PUB.Count_And_Get (
747: p_encoded => FND_API.G_FALSE,
748: p_count => x_msg_count,
749: p_data => x_msg_data

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

755: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
758: END IF;
759: -- Standard call to get message count and if count=1, get the message
760: FND_MSG_PUB.Count_And_Get (
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_msg_count,
763: p_data => x_msg_data

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

805: THEN
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
811: p_api_version_number,
812: l_api_name,
813: G_PKG_NAME)

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

861:
862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO LOCK_Prod_Template_PVT;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: -- Standard call to get message count and if count=1, get the message
866: FND_MSG_PUB.Count_And_Get (
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data

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

871:
872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
873: ROLLBACK TO LOCK_Prod_Template_PVT;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: -- Standard call to get message count and if count=1, get the message
876: FND_MSG_PUB.Count_And_Get (
877: p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,
879: p_data => x_msg_data

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

885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message
890: FND_MSG_PUB.Count_And_Get (
891: p_encoded => FND_API.G_FALSE,
892: p_count => x_msg_count,
893: p_data => x_msg_data

Line 1172: -- Standard Start of API savepoint

1168: l_object_version_number NUMBER;
1169: l_prod_template_rec AMS_Prod_Template_PVT.prod_template_rec_type;
1170:
1171: BEGIN
1172: -- Standard Start of API savepoint
1173: SAVEPOINT VALIDATE_Prod_Template_;
1174:
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1171: BEGIN
1172: -- Standard Start of API savepoint
1173: SAVEPOINT VALIDATE_Prod_Template_;
1174:
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1177: p_api_version_number,
1178: l_api_name,
1179: G_PKG_NAME)

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

1238:
1239: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get
1244: (p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );

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

1252:
1253: WHEN FND_API.G_EXC_ERROR THEN
1254: ROLLBACK TO VALIDATE_Prod_Template_;
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: -- Standard call to get message count and if count=1, get the message
1257: FND_MSG_PUB.Count_And_Get (
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data

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

1262:
1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: ROLLBACK TO VALIDATE_Prod_Template_;
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: -- Standard call to get message count and if count=1, get the message
1267: FND_MSG_PUB.Count_And_Get (
1268: p_encoded => FND_API.G_FALSE,
1269: p_count => x_msg_count,
1270: p_data => x_msg_data

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

1276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1279: END IF;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1284: p_data => x_msg_data

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

1314: IF (AMS_DEBUG_HIGH_ON) THEN
1315:
1316: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1317: END IF;
1318: -- Standard call to get message count and if count is 1, get message info.
1319: FND_MSG_PUB.Count_And_Get
1320: (p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );