DBA Data[Home] [Help]

APPS.AMS_WEBMARKETING_PVT dependencies on STANDARD

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

39: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
40:
41: BEGIN
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)

Line 52: -- Standard Start of API savepoint

48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: -- Standard Start of API savepoint
53:
54: SAVEPOINT WEBMARKETING_PLCE_CONTENT_TYPE;
55:
56: EXCEPTION

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

62:
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: -- Standard call to get message count and if count=1, get the message
67:
68: FND_MSG_PUB.Count_And_Get (
69: p_encoded => FND_API.G_FALSE,
70: p_count => x_msg_count,

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

74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: -- Standard call to get message count and if count=1, get the message
79: FND_MSG_PUB.Count_And_Get (
80: p_encoded => FND_API.G_FALSE,
81: p_count => x_msg_count,
82: p_data => x_msg_data

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

88: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
91: END IF;
92: -- Standard call to get message count and if count=1, get the message
93: FND_MSG_PUB.Count_And_Get (
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data

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

174: citem_rec c_plce_citems%rowtype;
175:
176: BEGIN
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
180: p_api_version_number,
181: l_api_name,
182: G_PKG_NAME)

Line 187: -- Standard Start of API savepoint

183: THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: -- Standard Start of API savepoint
188:
189: SAVEPOINT webmarketing_plce_citems_pvt;
190:
191: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 349: -- Standard check for p_commit

345: END IF;
346:
347:
348:
349: -- Standard check for p_commit
350: IF FND_API.to_Boolean( p_commit )
351: THEN
352: COMMIT WORK;
353: END IF;

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

369: IF (AMS_DEBUG_HIGH_ON) THEN
370: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
371: END IF;
372:
373: -- Standard call to get message count and if count is 1, get message info.
374: FND_MSG_PUB.Count_And_Get
375: (p_count => x_msg_count,
376: p_data => x_msg_data
377: );

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

382:
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO webmarketing_plce_citems_pvt;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data

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

392:
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO webmarketing_plce_citems_pvt;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data

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

406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get (
412: p_encoded => FND_API.G_FALSE,
413: p_count => x_msg_count,
414: p_data => x_msg_data

Line 474: -- Standard Start of API savepoint

470: FROM AMS_CAMPAIGN_SCHEDULES_B
471: WHERE SCHEDULE_ID = l_id;
472:
473: BEGIN
474: -- Standard Start of API savepoint
475: SAVEPOINT VALIDATE_WEB_PLCE_ASSOC_PVT;
476:
477: -- Standard call to check for call compatibility.
478: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

473: BEGIN
474: -- Standard Start of API savepoint
475: SAVEPOINT VALIDATE_WEB_PLCE_ASSOC_PVT;
476:
477: -- Standard call to check for call compatibility.
478: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
479: p_api_version_number,
480: l_api_name,
481: G_PKG_NAME)

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

545: IF (AMS_DEBUG_HIGH_ON) THEN
546: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
547: END IF;
548:
549: -- Standard call to get message count and if count is 1, get message info.
550: FND_MSG_PUB.Count_And_Get
551: (p_count => x_msg_count,
552: p_data => x_msg_data
553: );

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

559: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Standard call to get message count and if count=1, get the message
564: FND_MSG_PUB.Count_And_Get (
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data

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

571: IF (AMS_DEBUG_HIGH_ON) THEN
572: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);
573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data

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

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

Line 718: -- Standard Start of API savepoint

714:
715:
716: BEGIN
717:
718: -- Standard Start of API savepoint
719: SAVEPOINT CREATE_WEB_PLCE_ASSOC;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

717:
718: -- Standard Start of API savepoint
719: SAVEPOINT CREATE_WEB_PLCE_ASSOC;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
723: p_api_version_number,
724: l_api_name,
725: G_PKG_NAME)

Line 891: -- Standard check for p_commit ( This shud be romved after testing - Actual Commit is done by the calling program )

887: END IF;
888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: -- Standard check for p_commit ( This shud be romved after testing - Actual Commit is done by the calling program )
892: IF FND_API.to_Boolean( p_commit) THEN
893: COMMIT WORK;
894: END IF;
895:

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

897: -- IF (AMS_DEBUG_HIGH_ON) THEN
898: -- AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
899: -- END IF;
900:
901: -- Standard call to get message count and if count is 1, get message info.
902: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
903: p_data => x_msg_data
904: );
905:

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

923:
924: WHEN FND_API.G_EXC_ERROR THEN
925: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: -- Standard call to get message count and if count=1, get the message
928:
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,

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

935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938:
939: -- Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count,
943: p_data => x_msg_data

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

949: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
952: END IF;
953: -- Standard call to get message count and if count=1, get the message
954:
955: FND_MSG_PUB.Count_And_Get (
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,

Line 1013: -- Standard Start of API savepoint

1009:
1010:
1011: BEGIN
1012:
1013: -- Standard Start of API savepoint
1014: SAVEPOINT webmarketing_plce_content_type ;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1012:
1013: -- Standard Start of API savepoint
1014: SAVEPOINT webmarketing_plce_content_type ;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1018: p_api_version_number,
1019: l_api_name,
1020: G_PKG_NAME)

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

1059:
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO webmarketing_plce_content_type;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (
1065: p_encoded => FND_API.G_FALSE,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data

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

1069:
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: ROLLBACK TO webmarketing_plce_content_type;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (
1075: p_encoded => FND_API.G_FALSE,
1076: p_count => x_msg_count,
1077: p_data => x_msg_data

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

1083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1084: THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1086: END IF;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data

Line 1148: -- Standard Start of API savepoint

1144:
1145:
1146: BEGIN
1147:
1148: -- Standard Start of API savepoint
1149: SAVEPOINT WEBMARKETING_CONTENT_STATUS_S ;
1150:
1151: -- Standard call to check for call compatibility.
1152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1147:
1148: -- Standard Start of API savepoint
1149: SAVEPOINT WEBMARKETING_CONTENT_STATUS_S ;
1150:
1151: -- Standard call to check for call compatibility.
1152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1153: p_api_version_number,
1154: l_api_name,
1155: G_PKG_NAME)

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

1244:
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data

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

1254:
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: -- Standard call to get message count and if count=1, get the message
1259: FND_MSG_PUB.Count_And_Get (
1260: p_encoded => FND_API.G_FALSE,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data

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

1268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data