DBA Data[Home] [Help]

APPS.AMS_TEMPLATE_ATTR_PVT dependencies on STANDARD

Line 59: -- Standard Start of API savepoint

55: FROM AMS_PROD_TEMPLATE_ATTR
56: WHERE TEMPLATE_ATTRIBUTE_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_Template_Attr_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_Template_Attr_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
64: p_api_version_number,
65: l_api_name,
66: G_PKG_NAME)

Line 176: -- Standard check for p_commit

172: --
173: -- End of API body
174: --
175:
176: -- Standard check for p_commit
177: IF FND_API.to_Boolean( p_commit )
178: THEN
179: COMMIT WORK;
180: END IF;

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

185:
186: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
187: END IF;
188:
189: -- Standard call to get message count and if count is 1, get message info.
190: FND_MSG_PUB.Count_And_Get
191: (p_count => x_msg_count,
192: p_data => x_msg_data
193: );

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

199:
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO CREATE_Template_Attr_PVT;
202: x_return_status := FND_API.G_RET_STS_ERROR;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data

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

209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO CREATE_Template_Attr_PVT;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: -- Standard call to get message count and if count=1, get the message
214: FND_MSG_PUB.Count_And_Get (
215: p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data

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

223: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
226: END IF;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,
231: p_data => x_msg_data

Line 269: -- Standard Start of API savepoint

265:
266: l_template_attr_rec template_attr_rec_Type := p_template_attr_rec;
267:
268: BEGIN
269: -- Standard Start of API savepoint
270: SAVEPOINT UPDATE_Template_Attr_PVT;
271:
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

268: BEGIN
269: -- Standard Start of API savepoint
270: SAVEPOINT UPDATE_Template_Attr_PVT;
271:
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
274: p_api_version_number,
275: l_api_name,
276: G_PKG_NAME)

Line 420: -- standard who columns should be also modified ,so that the changes

416: l_template_attr_rec.parent_select_all := 'N';
417: END IF;
418:
419: -- bug 3544835 fix start
420: -- standard who columns should be also modified ,so that the changes
421: -- in the seeded template done by the user,doesn't gets overwritten by the ldts
422:
423: UPDATE ams_prod_template_attr
424: SET parent_select_all = l_template_attr_rec.parent_select_all

Line 447: -- Standard check for p_commit

443: --
444: -- End of API body.
445: --
446:
447: -- Standard check for p_commit
448: IF FND_API.to_Boolean( p_commit )
449: THEN
450: COMMIT WORK;
451: END IF;

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

456:
457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
458: END IF;
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data
464: );

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

470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO UPDATE_Template_Attr_PVT;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data

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

480:
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO UPDATE_Template_Attr_PVT;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data

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

494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data

Line 525: -- Standard Start of API savepoint

521: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
522: l_object_version_number NUMBER;
523:
524: BEGIN
525: -- Standard Start of API savepoint
526: SAVEPOINT DELETE_Template_Attr_PVT;
527:
528: -- Standard call to check for call compatibility.
529: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

524: BEGIN
525: -- Standard Start of API savepoint
526: SAVEPOINT DELETE_Template_Attr_PVT;
527:
528: -- Standard call to check for call compatibility.
529: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
530: p_api_version_number,
531: l_api_name,
532: G_PKG_NAME)

Line 561: -- Standard check for p_commit

557: If (SQL%NOTFOUND) then
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: End If;
560:
561: -- Standard check for p_commit
562: IF FND_API.to_Boolean( p_commit )
563: THEN
564: COMMIT WORK;
565: END IF;

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

570:
571: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
572: END IF;
573:
574: -- Standard call to get message count and if count is 1, get message info.
575: FND_MSG_PUB.Count_And_Get
576: (p_count => x_msg_count,
577: p_data => x_msg_data
578: );

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

584:
585: WHEN FND_API.G_EXC_ERROR THEN
586: ROLLBACK TO DELETE_Template_Attr_PVT;
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data

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

594:
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO DELETE_Template_Attr_PVT;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: -- Standard call to get message count and if count=1, get the message
599: FND_MSG_PUB.Count_And_Get (
600: p_encoded => FND_API.G_FALSE,
601: p_count => x_msg_count,
602: p_data => x_msg_data

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

608: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
609: THEN
610: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
611: END IF;
612: -- Standard call to get message count and if count=1, get the message
613: FND_MSG_PUB.Count_And_Get (
614: p_encoded => FND_API.G_FALSE,
615: p_count => x_msg_count,
616: p_data => x_msg_data

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

658: THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Standard call to check for call compatibility.
663: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
664: p_api_version_number,
665: l_api_name,
666: G_PKG_NAME)

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

714:
715: WHEN FND_API.G_EXC_ERROR THEN
716: ROLLBACK TO LOCK_Template_Attr_PVT;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: -- Standard call to get message count and if count=1, get the message
719: FND_MSG_PUB.Count_And_Get (
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_msg_count,
722: p_data => x_msg_data

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

724:
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: ROLLBACK TO LOCK_Template_Attr_PVT;
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: -- Standard call to get message count and if count=1, get the message
729: FND_MSG_PUB.Count_And_Get (
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data

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

738: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
741: END IF;
742: -- Standard call to get message count and if count=1, get the message
743: FND_MSG_PUB.Count_And_Get (
744: p_encoded => FND_API.G_FALSE,
745: p_count => x_msg_count,
746: p_data => x_msg_data

Line 1030: -- Standard Start of API savepoint

1026:
1027: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1028: END IF;
1029:
1030: -- Standard Start of API savepoint
1031: SAVEPOINT VALIDATE_Template_Attr_;
1032:
1033: -- Standard call to check for call compatibility.
1034: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1029:
1030: -- Standard Start of API savepoint
1031: SAVEPOINT VALIDATE_Template_Attr_;
1032:
1033: -- Standard call to check for call compatibility.
1034: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1035: p_api_version_number,
1036: l_api_name,
1037: G_PKG_NAME)

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

1085:
1086: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end and the return status is '||x_return_status);
1087: END IF;
1088:
1089: -- Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get
1091: (p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );

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

1099:
1100: WHEN FND_API.G_EXC_ERROR THEN
1101: ROLLBACK TO VALIDATE_Template_Attr_;
1102: x_return_status := FND_API.G_RET_STS_ERROR;
1103: -- Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data

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

1109:
1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1111: ROLLBACK TO VALIDATE_Template_Attr_;
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1113: -- Standard call to get message count and if count=1, get the message
1114: FND_MSG_PUB.Count_And_Get (
1115: p_encoded => FND_API.G_FALSE,
1116: p_count => x_msg_count,
1117: p_data => x_msg_data

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

1123: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1124: THEN
1125: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1126: END IF;
1127: -- Standard call to get message count and if count=1, get the message
1128: FND_MSG_PUB.Count_And_Get (
1129: p_encoded => FND_API.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data

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

1161: IF (AMS_DEBUG_HIGH_ON) THEN
1162:
1163: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1164: END IF;
1165: -- Standard call to get message count and if count is 1, get message info.
1166: FND_MSG_PUB.Count_And_Get
1167: (p_count => x_msg_count,
1168: p_data => x_msg_data
1169: );