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_USERS_PKG dependencies on WSH_CC_USERS_PKG

Line 1: PACKAGE BODY WSH_CC_USERS_PKG AS

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

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

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

Line 73: SAVEPOINT WSH_CC_USERS_PKG;

69: l_api_version number := 1.0;
70: begin
71: --dbms_output.put_line('begin api');
72: -- Standard Start of API savepoint
73: SAVEPOINT WSH_CC_USERS_PKG;
74: -- Standard call to check for call compatibility.
75: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
76: p_api_version ,
77: l_api_name ,

Line 147: ROLLBACK TO WSH_CC_USERS_PKG;

143: );
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: ROLLBACK TO WSH_CC_USERS_PKG;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count,
151: p_data => x_msg_data

Line 154: ROLLBACK TO WSH_CC_USERS_PKG;

150: ( p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO WSH_CC_USERS_PKG;
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: FND_MSG_PUB.Count_And_Get
157: ( p_count => x_msg_count,
158: p_data => x_msg_data

Line 161: ROLLBACK TO WSH_CC_USERS_PKG;

157: ( p_count => x_msg_count,
158: p_data => x_msg_data
159: );
160: WHEN OTHERS THEN
161: ROLLBACK TO WSH_CC_USERS_PKG;
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
163: IF FND_MSG_PUB.Check_Msg_Level
164: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: THEN

Line 243: SAVEPOINT WSH_CC_USERS_PKG;

239: l_api_version number := 1.0;
240: BEGIN
241: --dbms_output.put_line('begin');
242: -- Standard Start of API savepoint
243: SAVEPOINT WSH_CC_USERS_PKG;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
246: p_api_version ,
247: l_api_name ,

Line 302: ROLLBACK TO WSH_CC_USERS_PKG;

298:
299: EXCEPTION
300: WHEN FND_API.G_EXC_ERROR THEN
301: --dbms_output.put_line(sqlerrm);
302: ROLLBACK TO WSH_CC_USERS_PKG;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: FND_MSG_PUB.Count_And_Get
305: ( p_count => x_msg_count,
306: p_data => x_msg_data

Line 310: ROLLBACK TO WSH_CC_USERS_PKG;

306: p_data => x_msg_data
307: );
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
309: --dbms_output.put_line(sqlerrm);
310: ROLLBACK TO WSH_CC_USERS_PKG;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count,
314: p_data => x_msg_data

Line 318: ROLLBACK TO WSH_CC_USERS_PKG;

314: p_data => x_msg_data
315: );
316: WHEN OTHERS THEN
317: --dbms_output.put_line(sqlerrm);
318: ROLLBACK TO WSH_CC_USERS_PKG;
319: x_return_status := 'W';
320: IF FND_MSG_PUB.Check_Msg_Level
321: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
322: THEN

Line 389: SAVEPOINT WSH_CC_USERS_PKG;

385: l_api_version number := 1.0;
386: BEGIN
387: --dbms_output.put_line('begin');
388: -- Standard Start of API savepoint
389: SAVEPOINT WSH_CC_USERS_PKG;
390: -- Standard call to check for call compatibility.
391: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
392: p_api_version ,
393: l_api_name ,

Line 436: ROLLBACK TO WSH_CC_USERS_PKG;

432:
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: --dbms_output.put_line(sqlerrm);
436: ROLLBACK TO WSH_CC_USERS_PKG;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: FND_MSG_PUB.Count_And_Get
439: ( p_count => x_msg_count,
440: p_data => x_msg_data

Line 444: ROLLBACK TO WSH_CC_USERS_PKG;

440: p_data => x_msg_data
441: );
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443: --dbms_output.put_line(sqlerrm);
444: ROLLBACK TO WSH_CC_USERS_PKG;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data

Line 452: ROLLBACK TO WSH_CC_USERS_PKG;

448: p_data => x_msg_data
449: );
450: WHEN OTHERS THEN
451: --dbms_output.put_line(sqlerrm);
452: ROLLBACK TO WSH_CC_USERS_PKG;
453: x_return_status := 'W';
454: IF FND_MSG_PUB.Check_Msg_Level
455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN

Line 545: SAVEPOINT WSH_CC_USERS_PKG;

541: l_api_version number := 1.0;
542: BEGIN
543: --dbms_output.put_line('begin');
544: -- Standard Start of API savepoint
545: SAVEPOINT WSH_CC_USERS_PKG;
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
548: p_api_version ,
549: l_api_name ,

Line 607: END WSH_CC_USERS_PKG;

603: IF (lock_row%ISOPEN) then
604: close lock_row;
605: End if;
606: End Lock_Row;
607: END WSH_CC_USERS_PKG;