eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CC_REQUEST_SETUPS_PKG dependencies on WSH_CC_REQUEST_SETUPS_PKG

Line 1: PACKAGE BODY WSH_CC_REQUEST_SETUPS_PKG AS

1: PACKAGE BODY WSH_CC_REQUEST_SETUPS_PKG AS
2: /* $Header: WSHRSTHB.pls 115.4 2002/06/03 12:31:57 pkm ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CC_REQUEST_SETUPS_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CC_REQUEST_SETUPS_PKG';

1: PACKAGE BODY WSH_CC_REQUEST_SETUPS_PKG AS
2: /* $Header: WSHRSTHB.pls 115.4 2002/06/03 12:31:57 pkm ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CC_REQUEST_SETUPS_PKG';
5:
6: /*----------------------------------------------------------*/
7: /* Insert_Row Procedure */
8: /*----------------------------------------------------------*/

Line 77: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;

73: l_api_version number := 1.0;
74: begin
75: --dbms_output.put_line('begin api');
76: -- Standard Start of API savepoint
77: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
80: p_api_version ,
81: l_api_name ,

Line 171: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

167: );
168:
169: EXCEPTION
170: WHEN FND_API.G_EXC_ERROR THEN
171: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get
174: ( p_count => x_msg_count,
175: p_data => x_msg_data

Line 178: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

174: ( p_count => x_msg_count,
175: p_data => x_msg_data
176: );
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MSG_PUB.Count_And_Get
181: ( p_count => x_msg_count,
182: p_data => x_msg_data

Line 185: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184: WHEN OTHERS THEN
185: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
187: IF FND_MSG_PUB.Check_Msg_Level
188: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN

Line 271: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;

267: l_api_version number := 1.0;
268: BEGIN
269: --dbms_output.put_line('begin');
270: -- Standard Start of API savepoint
271: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
274: p_api_version ,
275: l_api_name ,

Line 340: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

336:
337: EXCEPTION
338: WHEN FND_API.G_EXC_ERROR THEN
339: --dbms_output.put_line(sqlerrm);
340: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data

Line 348: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

344: p_data => x_msg_data
345: );
346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
347: --dbms_output.put_line(sqlerrm);
348: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data

Line 356: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

352: p_data => x_msg_data
353: );
354: WHEN OTHERS THEN
355: --dbms_output.put_line(sqlerrm);
356: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
357: x_return_status := 'W';
358: IF FND_MSG_PUB.Check_Msg_Level
359: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
360: THEN

Line 428: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;

424: l_api_version number := 1.0;
425: BEGIN
426: --dbms_output.put_line('begin');
427: -- Standard Start of API savepoint
428: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
429: -- Standard call to check for call compatibility.
430: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
431: p_api_version ,
432: l_api_name ,

Line 475: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

471:
472: EXCEPTION
473: WHEN FND_API.G_EXC_ERROR THEN
474: --dbms_output.put_line(sqlerrm);
475: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.Count_And_Get
478: ( p_count => x_msg_count,
479: p_data => x_msg_data

Line 483: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

479: p_data => x_msg_data
480: );
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: --dbms_output.put_line(sqlerrm);
483: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: FND_MSG_PUB.Count_And_Get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data

Line 491: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;

487: p_data => x_msg_data
488: );
489: WHEN OTHERS THEN
490: --dbms_output.put_line(sqlerrm);
491: ROLLBACK TO WSH_CC_REQUEST_SETUPS_PKG;
492: x_return_status := 'W';
493: IF FND_MSG_PUB.Check_Msg_Level
494: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN

Line 587: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;

583: l_api_version number := 1.0;
584: BEGIN
585: --dbms_output.put_line('begin');
586: -- Standard Start of API savepoint
587: SAVEPOINT WSH_CC_REQUEST_SETUPS_PKG;
588: -- Standard call to check for call compatibility.
589: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
590: p_api_version ,
591: l_api_name ,

Line 685: END WSH_CC_REQUEST_SETUPS_PKG;

681: IF (lock_row%ISOPEN) then
682: close lock_row;
683: End if;
684: End Lock_Row;
685: END WSH_CC_REQUEST_SETUPS_PKG;