DBA Data[Home] [Help]

APPS.AMS_PS_STRATS_PUB dependencies on STANDARD

Line 41: -- Standard Start of API savepoint

37: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Ps_Strats';
38: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
39: l_pvt_ps_strats_rec AMS_Ps_Strats_PVT.ps_strats_rec_type;
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_Ps_Strats_PUB;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_Ps_Strats_PUB;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)

Line 96: -- Standard check for p_commit

92: --
93: -- End of API body.
94: --
95:
96: -- Standard check for p_commit
97: IF FND_API.to_Boolean( p_commit )
98: THEN
99: COMMIT WORK;
100: END IF;

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

105:
106: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
107: END IF;
108:
109: -- Standard call to get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get
111: (p_count => x_msg_count,
112: p_data => x_msg_data
113: );

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

119:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO CREATE_Ps_Strats_PUB;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- Standard call to get message count and if count=1, get the message
124: FND_MSG_PUB.Count_And_Get (
125: p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data

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

129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO CREATE_Ps_Strats_PUB;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data

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

143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147: -- Standard call to get message count and if count=1, get the message
148: FND_MSG_PUB.Count_And_Get (
149: p_encoded => FND_API.G_FALSE,
150: p_count => x_msg_count,
151: p_data => x_msg_data

Line 175: -- Standard Start of API savepoint

171: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
172: l_object_version_number NUMBER;
173: l_pvt_ps_strats_rec AMS_Ps_Strats_PVT.ps_strats_rec_type;
174: BEGIN
175: -- Standard Start of API savepoint
176: SAVEPOINT UPDATE_Ps_Strats_PUB;
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

174: BEGIN
175: -- Standard Start of API savepoint
176: SAVEPOINT UPDATE_Ps_Strats_PUB;
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 228: -- Standard check for p_commit

224: --
225: -- End of API body
226: --
227:
228: -- Standard check for p_commit
229: IF FND_API.to_Boolean( p_commit )
230: THEN
231: COMMIT WORK;
232: END IF;

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

237:
238: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
239: END IF;
240:
241: -- Standard call to get message count and if count is 1, get message info.
242: FND_MSG_PUB.Count_And_Get
243: (p_count => x_msg_count,
244: p_data => x_msg_data
245: );

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

251:
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UPDATE_Ps_Strats_PUB;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data

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

261:
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UPDATE_Ps_Strats_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data

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

275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
278: END IF;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,
283: p_data => x_msg_data

Line 306: -- Standard Start of API savepoint

302: l_STRATEGY_ID NUMBER := p_STRATEGY_ID;
303: l_object_version_number NUMBER := p_object_version_number;
304: l_pvt_ps_strats_rec AMS_Ps_Strats_PVT.ps_strats_rec_type;
305: BEGIN
306: -- Standard Start of API savepoint
307: SAVEPOINT DELETE_Ps_Strats_PUB;
308:
309: -- Standard call to check for call compatibility.
310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

305: BEGIN
306: -- Standard Start of API savepoint
307: SAVEPOINT DELETE_Ps_Strats_PUB;
308:
309: -- Standard call to check for call compatibility.
310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
311: p_api_version_number,
312: l_api_name,
313: G_PKG_NAME)

Line 359: -- Standard check for p_commit

355: --
356: -- End of API body
357: --
358:
359: -- Standard check for p_commit
360: IF FND_API.to_Boolean( p_commit )
361: THEN
362: COMMIT WORK;
363: END IF;

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

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

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 DELETE_Ps_Strats_PUB;
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 DELETE_Ps_Strats_PUB;
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 436: -- Standard call to check for call compatibility.

432: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
433: l_pvt_ps_strats_rec AMS_Ps_Strats_PVT.ps_strats_rec_type;
434: BEGIN
435:
436: -- Standard call to check for call compatibility.
437: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
438: p_api_version_number,
439: l_api_name,
440: G_PKG_NAME)

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

497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: ROLLBACK TO LOCK_Ps_Strats_PUB;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_msg_count,
505: p_data => x_msg_data

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

507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO LOCK_Ps_Strats_PUB;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data

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

521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
524: END IF;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data