[Home] [Help]
42: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Performance';
43: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
44: l_pvt_performance_rec AMS_DMPerformance_PVT.performance_rec_type;
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT Create_Performance_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT Create_Performance_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
103: --
104: -- End of API body.
105: --
106:
107: -- Standard check for p_commit
108: IF FND_API.to_Boolean( p_commit )
109: THEN
110: COMMIT WORK;
111: END IF;
113:
114: -- Debug Message
115: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
116:
117: -- Standard call to get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: (p_count => x_msg_count,
120: p_data => x_msg_data
121: );
130:
131: WHEN FND_API.G_EXC_ERROR THEN
132: ROLLBACK TO Create_Performance_PUB;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: -- Standard call to get message count and if count=1, get the message
135: FND_MSG_PUB.Count_And_Get (
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data
140:
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: ROLLBACK TO Create_Performance_PUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: -- Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,
147: p_count => x_msg_count,
148: p_data => x_msg_data
154: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
155: THEN
156: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
157: END IF;
158: -- Standard call to get message count and if count=1, get the message
159: FND_MSG_PUB.Count_And_Get (
160: p_encoded => FND_API.G_FALSE,
161: p_count => x_msg_count,
162: p_data => x_msg_data
181: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
182: l_object_version_number NUMBER;
183: l_pvt_performance_rec AMS_DMPerformance_PVT.performance_rec_type;
184: BEGIN
185: -- Standard Start of API savepoint
186: SAVEPOINT Update_Performance_PUB;
187:
188: -- Standard call to check for call compatibility.
189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
184: BEGIN
185: -- Standard Start of API savepoint
186: SAVEPOINT Update_Performance_PUB;
187:
188: -- Standard call to check for call compatibility.
189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
190: p_api_version_number,
191: l_api_name,
192: G_PKG_NAME)
242: --
243: -- End of API body
244: --
245:
246: -- Standard check for p_commit
247: IF FND_API.to_Boolean( p_commit )
248: THEN
249: COMMIT WORK;
250: END IF;
252:
253: -- Debug Message
254: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
255:
256: -- Standard call to get message count and if count is 1, get message info.
257: FND_MSG_PUB.Count_And_Get
258: (p_count => x_msg_count,
259: p_data => x_msg_data
260: );
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO Update_Performance_PUB;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: -- Standard call to get message count and if count=1, get the message
274: FND_MSG_PUB.Count_And_Get (
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO Update_Performance_PUB;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_MSG_PUB.Count_And_Get (
285: p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
293: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
294: THEN
295: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
296: END IF;
297: -- Standard call to get message count and if count=1, get the message
298: FND_MSG_PUB.Count_And_Get (
299: p_encoded => FND_API.G_FALSE,
300: p_count => x_msg_count,
301: p_data => x_msg_data
317: IS
318: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Performance';
319: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
320: BEGIN
321: -- Standard Start of API savepoint
322: SAVEPOINT Delete_Performance_PUB;
323:
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
320: BEGIN
321: -- Standard Start of API savepoint
322: SAVEPOINT Delete_Performance_PUB;
323:
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
326: p_api_version_number,
327: l_api_name,
328: G_PKG_NAME)
368: --
369: -- End of API body
370: --
371:
372: -- Standard check for p_commit
373: IF FND_API.to_Boolean( p_commit )
374: THEN
375: COMMIT WORK;
376: END IF;
378:
379: -- Debug Message
380: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
381:
382: -- Standard call to get message count and if count is 1, get message info.
383: FND_MSG_PUB.Count_And_Get
384: (p_count => x_msg_count,
385: p_data => x_msg_data
386: );
395:
396: WHEN FND_API.G_EXC_ERROR THEN
397: ROLLBACK TO Delete_Performance_PUB;
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: -- Standard call to get message count and if count=1, get the message
400: FND_MSG_PUB.Count_And_Get (
401: p_encoded => FND_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ROLLBACK TO Delete_Performance_PUB;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: -- Standard call to get message count and if count=1, get the message
410: FND_MSG_PUB.Count_And_Get (
411: p_encoded => FND_API.G_FALSE,
412: p_count => x_msg_count,
413: p_data => x_msg_data
419: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
420: THEN
421: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
422: END IF;
423: -- Standard call to get message count and if count=1, get the message
424: FND_MSG_PUB.Count_And_Get (
425: p_encoded => FND_API.G_FALSE,
426: p_count => x_msg_count,
427: p_data => x_msg_data
443: L_API_NAME CONSTANT VARCHAR2(30) := 'Lock_Performance';
444: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
445: BEGIN
446:
447: -- Standard call to check for call compatibility.
448: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
449: p_api_version_number,
450: l_api_name,
451: G_PKG_NAME)
504: END IF;
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: -- Standard call to get message count and if count=1, get the message
509: FND_MSG_PUB.Count_And_Get (
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
514:
515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: -- Standard call to get message count and if count=1, get the message
518: FND_MSG_PUB.Count_And_Get (
519: p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data
526: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
527: THEN
528: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
529: END IF;
530: -- Standard call to get message count and if count=1, get the message
531: FND_MSG_PUB.Count_And_Get (
532: p_encoded => FND_API.G_FALSE,
533: p_count => x_msg_count,
534: p_data => x_msg_data