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_SERVICE_SETUPS_PKG dependencies on WSH_CC_SERVICE_SETUPS_PKG

Line 1: PACKAGE BODY WSH_CC_SERVICE_SETUPS_PKG AS

1: PACKAGE BODY WSH_CC_SERVICE_SETUPS_PKG AS
2: /* $Header: WSHSSTHB.pls 115.3 2002/06/03 12:32:05 pkm ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CC_SERVICE_SETUPS_PKG';
5:

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

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

Line 80: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;

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

Line 180: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

176: );
177:
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: FND_MSG_PUB.Count_And_Get
183: ( p_count => x_msg_count,
184: p_data => x_msg_data

Line 187: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: FND_MSG_PUB.Count_And_Get
190: ( p_count => x_msg_count,
191: p_data => x_msg_data

Line 194: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

190: ( p_count => x_msg_count,
191: p_data => x_msg_data
192: );
193: WHEN OTHERS THEN
194: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level
197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN

Line 283: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;

279: l_api_version number := 1.0;
280: BEGIN
281: --dbms_output.put_line('begin');
282: -- Standard Start of API savepoint
283: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
286: p_api_version ,
287: l_api_name ,

Line 355: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_ERROR THEN
354: --dbms_output.put_line(sqlerrm);
355: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data

Line 363: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

359: p_data => x_msg_data
360: );
361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362: --dbms_output.put_line(sqlerrm);
363: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_And_Get
366: ( p_count => x_msg_count,
367: p_data => x_msg_data

Line 371: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

367: p_data => x_msg_data
368: );
369: WHEN OTHERS THEN
370: --dbms_output.put_line(sqlerrm);
371: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
372: x_return_status := 'W';
373: IF FND_MSG_PUB.Check_Msg_Level
374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN

Line 443: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;

439: l_api_version number := 1.0;
440: BEGIN
441: --dbms_output.put_line('begin');
442: -- Standard Start of API savepoint
443: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
444: -- Standard call to check for call compatibility.
445: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
446: p_api_version ,
447: l_api_name ,

Line 490: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

486:
487: EXCEPTION
488: WHEN FND_API.G_EXC_ERROR THEN
489: --dbms_output.put_line(sqlerrm);
490: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get
493: ( p_count => x_msg_count,
494: p_data => x_msg_data

Line 498: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

494: p_data => x_msg_data
495: );
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: --dbms_output.put_line(sqlerrm);
498: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500: FND_MSG_PUB.Count_And_Get
501: ( p_count => x_msg_count,
502: p_data => x_msg_data

Line 506: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;

502: p_data => x_msg_data
503: );
504: WHEN OTHERS THEN
505: --dbms_output.put_line(sqlerrm);
506: ROLLBACK TO WSH_CC_SERVICE_SETUPS_PKG;
507: x_return_status := 'W';
508: IF FND_MSG_PUB.Check_Msg_Level
509: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN

Line 605: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;

601: l_api_version number := 1.0;
602: BEGIN
603: --dbms_output.put_line('begin');
604: -- Standard Start of API savepoint
605: SAVEPOINT WSH_CC_SERVICE_SETUPS_PKG;
606: -- Standard call to check for call compatibility.
607: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
608: p_api_version ,
609: l_api_name ,

Line 706: END WSH_CC_SERVICE_SETUPS_PKG;

702: IF (lock_row%ISOPEN) then
703: close lock_row;
704: End if;
705: End Lock_Row;
706: END WSH_CC_SERVICE_SETUPS_PKG;