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_ITM_USERS_PKG dependencies on WSH_ITM_USERS_PKG

Line 1: PACKAGE BODY WSH_ITM_USERS_PKG AS

1: PACKAGE BODY WSH_ITM_USERS_PKG AS
2: /* $Header: WSHITUTB.pls 115.6 2002/12/12 12:07:21 bradha ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_USERS_PKG';
5:

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

1: PACKAGE BODY WSH_ITM_USERS_PKG AS
2: /* $Header: WSHITUTB.pls 115.6 2002/12/12 12:07:21 bradha ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_USERS_PKG';
5:
6: /*----------------------------------------------------------*/
7: /* Insert_Row Procedure */
8: /*----------------------------------------------------------*/

Line 75: SAVEPOINT WSH_ITM_USERS_PKG;

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

Line 151: ROLLBACK TO WSH_ITM_USERS_PKG;

147: );
148:
149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO WSH_ITM_USERS_PKG;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data

Line 158: ROLLBACK TO WSH_ITM_USERS_PKG;

154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO WSH_ITM_USERS_PKG;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_And_Get
161: ( p_count => x_msg_count,
162: p_data => x_msg_data

Line 165: ROLLBACK TO WSH_ITM_USERS_PKG;

161: ( p_count => x_msg_count,
162: p_data => x_msg_data
163: );
164: WHEN OTHERS THEN
165: ROLLBACK TO WSH_ITM_USERS_PKG;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: IF FND_MSG_PUB.Check_Msg_Level
168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN

Line 252: SAVEPOINT WSH_ITM_USERS_PKG;

248:
249: BEGIN
250: --dbms_output.put_line('begin');
251: -- Standard Start of API savepoint
252: SAVEPOINT WSH_ITM_USERS_PKG;
253: -- Standard call to check for call compatibility.
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,
256: l_api_name ,

Line 317: ROLLBACK TO WSH_ITM_USERS_PKG;

313: );
314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO WSH_ITM_USERS_PKG;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,
321: p_data => x_msg_data

Line 325: ROLLBACK TO WSH_ITM_USERS_PKG;

321: p_data => x_msg_data
322: );
323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO WSH_ITM_USERS_PKG;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data

Line 333: ROLLBACK TO WSH_ITM_USERS_PKG;

329: p_data => x_msg_data
330: );
331:
332: WHEN OTHERS THEN
333: ROLLBACK TO WSH_ITM_USERS_PKG;
334: x_return_status := 'W';
335: IF FND_MSG_PUB.Check_Msg_Level
336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN

Line 406: SAVEPOINT WSH_ITM_USERS_PKG;

402: l_api_version number := 1.0;
403: BEGIN
404: --dbms_output.put_line('begin');
405: -- Standard Start of API savepoint
406: SAVEPOINT WSH_ITM_USERS_PKG;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
409: p_api_version ,
410: l_api_name ,

Line 453: ROLLBACK TO WSH_ITM_USERS_PKG;

449:
450: EXCEPTION
451: WHEN FND_API.G_EXC_ERROR THEN
452: --dbms_output.put_line(sqlerrm);
453: ROLLBACK TO WSH_ITM_USERS_PKG;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data

Line 461: ROLLBACK TO WSH_ITM_USERS_PKG;

457: p_data => x_msg_data
458: );
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: --dbms_output.put_line(sqlerrm);
461: ROLLBACK TO WSH_ITM_USERS_PKG;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data

Line 469: ROLLBACK TO WSH_ITM_USERS_PKG;

465: p_data => x_msg_data
466: );
467: WHEN OTHERS THEN
468: --dbms_output.put_line(sqlerrm);
469: ROLLBACK TO WSH_ITM_USERS_PKG;
470: x_return_status := 'W';
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN

Line 565: SAVEPOINT WSH_ITM_USERS_PKG;

561:
562: BEGIN
563:
564: -- Standard Start of API savepoint
565: SAVEPOINT WSH_ITM_USERS_PKG;
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
568: p_api_version ,
569: l_api_name ,

Line 635: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_USERS_PKG.LOCK_ROW');

631: if (lock_row%ISOPEN) then
632: close lock_row;
633: end if;
634: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
635: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_USERS_PKG.LOCK_ROW');
636: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
637: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
638:
639: RAISE;

Line 643: END WSH_ITM_USERS_PKG;

639: RAISE;
640:
641:
642: End Lock_Row;
643: END WSH_ITM_USERS_PKG;