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_PARAMETER_SETUPS_PKG dependencies on WSH_ITM_PARAMETER_SETUPS_PKG

Line 1: package body WSH_ITM_PARAMETER_SETUPS_PKG as

1: package body WSH_ITM_PARAMETER_SETUPS_PKG as
2: /* $Header: WSHITTHB.pls 115.6 2002/12/12 12:06:27 bradha ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_PARAMETER_SETUPS_PKG';
5:

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

1: package body WSH_ITM_PARAMETER_SETUPS_PKG as
2: /* $Header: WSHITTHB.pls 115.6 2002/12/12 12:06:27 bradha ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_ITM_PARAMETER_SETUPS_PKG';
5:
6: /*----------------------------------------------------------*/
7: /* Insert_Row Procedure */
8: /*----------------------------------------------------------*/

Line 75: SAVEPOINT WSH_ITM_PARAMETER_SETUPS_PKG;

71: begin
72:
73: --dbms_output.put_line('begin api');
74: -- Standard Start of API savepoint
75: SAVEPOINT WSH_ITM_PARAMETER_SETUPS_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 196: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

192: );
193:
194: EXCEPTION
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get
199: ( p_count => x_msg_count,
200: p_data => x_msg_data

Line 203: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

199: ( p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.Count_And_Get
206: ( p_count => x_msg_count,
207: p_data => x_msg_data

Line 210: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

206: ( p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209: WHEN OTHERS THEN
210: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: IF FND_MSG_PUB.Check_Msg_Level
213: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214: THEN

Line 382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');

378: if (c%ISOPEN) then
379: close c;
380: end if;
381: FND_MESSAGE.SET_NAME('WSH','WSH_UNEXP_ERROR');
382: FND_MESSAGE.Set_Token('PACKAGE', 'WSH_ITM_PARAMETER_SETUPS_PKG.LOCK_ROW');
383: FND_MESSAGE.Set_Token('ORA_ERROR',sqlcode);
384: FND_MESSAGE.Set_Token('ORA_TEXT',sqlerrm);
385:
386: RAISE;

Line 460: SAVEPOINT WSH_ITM_PARAMETER_SETUPS_PKG;

456: begin
457:
458: --dbms_output.put_line('begin');
459: -- Standard Start of API savepoint
460: SAVEPOINT WSH_ITM_PARAMETER_SETUPS_PKG;
461: -- Standard call to check for call compatibility.
462: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
463: p_api_version ,
464: l_api_name ,

Line 543: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

539:
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN
542: --dbms_output.put_line(sqlerrm);
543: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: FND_MSG_PUB.Count_And_Get
546: ( p_count => x_msg_count,
547: p_data => x_msg_data

Line 551: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

547: p_data => x_msg_data
548: );
549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
550: --dbms_output.put_line(sqlerrm);
551: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: FND_MSG_PUB.Count_And_Get
554: ( p_count => x_msg_count,
555: p_data => x_msg_data

Line 559: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

555: p_data => x_msg_data
556: );
557: WHEN OTHERS THEN
558: --dbms_output.put_line(sqlerrm);
559: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
560: x_return_status := 'W';
561: IF FND_MSG_PUB.Check_Msg_Level
562: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN

Line 634: SAVEPOINT WSH_ITM_PARAMETER_SETUPS_PKG;

630: begin
631:
632: --dbms_output.put_line('begin');
633: -- Standard Start of API savepoint
634: SAVEPOINT WSH_ITM_PARAMETER_SETUPS_PKG;
635: -- Standard call to check for call compatibility.
636: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
637: p_api_version ,
638: l_api_name ,

Line 707: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

703:
704: EXCEPTION
705: WHEN FND_API.G_EXC_ERROR THEN
706: --dbms_output.put_line(sqlerrm);
707: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: FND_MSG_PUB.Count_And_Get
710: ( p_count => x_msg_count,
711: p_data => x_msg_data

Line 715: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

711: p_data => x_msg_data
712: );
713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
714: --dbms_output.put_line(sqlerrm);
715: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => x_msg_count,
719: p_data => x_msg_data

Line 723: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;

719: p_data => x_msg_data
720: );
721: WHEN OTHERS THEN
722: --dbms_output.put_line(sqlerrm);
723: ROLLBACK TO WSH_ITM_PARAMETER_SETUPS_PKG;
724: x_return_status := 'W';
725: IF FND_MSG_PUB.Check_Msg_Level
726: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
727: THEN

Line 942: end WSH_ITM_PARAMETER_SETUPS_PKG;

938: END;
939: commit;
940: END load_row;
941:
942: end WSH_ITM_PARAMETER_SETUPS_PKG;