DBA Data[Home] [Help]

APPS.WSH_ITM_ERROR_PKG dependencies on WSH_ITM_ERROR_PKG

Line 1: PACKAGE BODY WSH_ITM_ERROR_PKG AS

1: PACKAGE BODY WSH_ITM_ERROR_PKG AS
2: /* $Header: WSHITERB.pls 115.3 2002/12/12 12:01:46 bradha ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_ERROR_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_ERROR_PKG';

1: PACKAGE BODY WSH_ITM_ERROR_PKG AS
2: /* $Header: WSHITERB.pls 115.3 2002/12/12 12:01:46 bradha ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_ERROR_PKG';
6:
7: /*----------------------------------------------------------*/
8: /* Insert_Row Procedure */
9: /*----------------------------------------------------------*/

Line 55: SAVEPOINT WSH_ITM_ERROR_PKG;

51: l_api_version number := 1.0;
52:
53: BEGIN
54: -- Standard Start of API savepoint
55: SAVEPOINT WSH_ITM_ERROR_PKG;
56:
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
59: p_api_version ,

Line 134: ROLLBACK TO WSH_ITM_ERROR_PKG;

130: );
131:
132: EXCEPTION
133: WHEN FND_API.G_EXC_ERROR THEN
134: ROLLBACK TO WSH_ITM_ERROR_PKG;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: FND_MSG_PUB.Count_And_Get
137: ( p_count => x_msg_count,
138: p_data => x_msg_data

Line 141: ROLLBACK TO WSH_ITM_ERROR_PKG;

137: ( p_count => x_msg_count,
138: p_data => x_msg_data
139: );
140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
141: ROLLBACK TO WSH_ITM_ERROR_PKG;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count,
145: p_data => x_msg_data

Line 148: ROLLBACK TO WSH_ITM_ERROR_PKG;

144: ( p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: WHEN OTHERS THEN
148: ROLLBACK TO WSH_ITM_ERROR_PKG;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level
151: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
152: THEN

Line 230: SAVEPOINT WSH_ITM_ERROR_PKG;

226:
227: BEGIN
228:
229: -- Standard Start of API savepoint
230: SAVEPOINT WSH_ITM_ERROR_PKG;
231:
232: -- Standard call to check for call compatibility.
233: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
234: p_api_version ,

Line 290: ROLLBACK TO WSH_ITM_ERROR_PKG;

286: );
287:
288: EXCEPTION
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO WSH_ITM_ERROR_PKG;
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data

Line 297: ROLLBACK TO WSH_ITM_ERROR_PKG;

293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO WSH_ITM_ERROR_PKG;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data

Line 304: ROLLBACK TO WSH_ITM_ERROR_PKG;

300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN OTHERS THEN
304: ROLLBACK TO WSH_ITM_ERROR_PKG;
305: x_return_status := 'W';
306: IF FND_MSG_PUB.Check_Msg_Level
307: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
308: THEN

Line 377: SAVEPOINT WSH_ITM_ERROR_PKG;

373:
374: BEGIN
375:
376: -- Standard Start of API savepoint
377: SAVEPOINT WSH_ITM_ERROR_PKG;
378:
379: -- Standard call to check for call compatibility.
380: IF NOT FND_API.Compatible_API_Call
381: ( l_api_version ,

Line 429: ROLLBACK TO WSH_ITM_ERROR_PKG;

425: );
426:
427: EXCEPTION
428: WHEN FND_API.G_EXC_ERROR THEN
429: ROLLBACK TO WSH_ITM_ERROR_PKG;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get
432: ( p_count => x_msg_count,
433: p_data => x_msg_data

Line 437: ROLLBACK TO WSH_ITM_ERROR_PKG;

433: p_data => x_msg_data
434: );
435:
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO WSH_ITM_ERROR_PKG;
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MSG_PUB.Count_And_Get
440: ( p_count => x_msg_count,
441: p_data => x_msg_data

Line 445: ROLLBACK TO WSH_ITM_ERROR_PKG;

441: p_data => x_msg_data
442: );
443:
444: WHEN OTHERS THEN
445: ROLLBACK TO WSH_ITM_ERROR_PKG;
446: x_return_status := 'W';
447: IF FND_MSG_PUB.Check_Msg_Level
448: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
449: THEN

Line 537: SAVEPOINT WSH_ITM_ERROR_PKG;

533: l_api_version number := 1.0;
534: BEGIN
535:
536: -- Standard Start of API savepoint
537: SAVEPOINT WSH_ITM_ERROR_PKG;
538:
539: -- Standard call to check for call compatibility.
540: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
541: p_api_version ,

Line 588: END WSH_ITM_ERROR_PKG;

584: WHEN others THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
587: End Lock_Row;
588: END WSH_ITM_ERROR_PKG;