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

Line 1: package body WSH_CC_PARAMETER_SETUPS_PKG as

1: package body WSH_CC_PARAMETER_SETUPS_PKG as
2: /* $Header: WSHCCTHB.pls 115.2 2002/06/03 12:30:23 pkm ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CC_PARAMETER_SETUPS_PKG';
5:

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

1: package body WSH_CC_PARAMETER_SETUPS_PKG as
2: /* $Header: WSHCCTHB.pls 115.2 2002/06/03 12:30:23 pkm ship $ */
3: -- Global constant holding the package name
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CC_PARAMETER_SETUPS_PKG';
5:
6: /*----------------------------------------------------------*/
7: /* Insert_Row Procedure */
8: /*----------------------------------------------------------*/

Line 76: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;

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

Line 197: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

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

Line 204: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

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

Line 211: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

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

Line 315: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;

311: begin
312:
313: --dbms_output.put_line('begin');
314: -- Standard Start of API savepoint
315: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
318: p_api_version ,
319: l_api_name ,

Line 454: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;

450: begin
451:
452: --dbms_output.put_line('begin');
453: -- Standard Start of API savepoint
454: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;
455: -- Standard call to check for call compatibility.
456: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
457: p_api_version ,
458: l_api_name ,

Line 537: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

533:
534: EXCEPTION
535: WHEN FND_API.G_EXC_ERROR THEN
536: --dbms_output.put_line(sqlerrm);
537: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: ( p_count => x_msg_count,
541: p_data => x_msg_data

Line 545: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

541: p_data => x_msg_data
542: );
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: --dbms_output.put_line(sqlerrm);
545: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data

Line 553: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

549: p_data => x_msg_data
550: );
551: WHEN OTHERS THEN
552: --dbms_output.put_line(sqlerrm);
553: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
554: x_return_status := 'W';
555: IF FND_MSG_PUB.Check_Msg_Level
556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN

Line 628: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;

624: begin
625:
626: --dbms_output.put_line('begin');
627: -- Standard Start of API savepoint
628: SAVEPOINT WSH_CC_PARAMETER_SETUPS_PKG;
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
631: p_api_version ,
632: l_api_name ,

Line 701: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

697:
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: --dbms_output.put_line(sqlerrm);
701: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get
704: ( p_count => x_msg_count,
705: p_data => x_msg_data

Line 709: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

705: p_data => x_msg_data
706: );
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: --dbms_output.put_line(sqlerrm);
709: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.Count_And_Get
712: ( p_count => x_msg_count,
713: p_data => x_msg_data

Line 717: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;

713: p_data => x_msg_data
714: );
715: WHEN OTHERS THEN
716: --dbms_output.put_line(sqlerrm);
717: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
718: x_return_status := 'W';
719: IF FND_MSG_PUB.Check_Msg_Level
720: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN

Line 936: end WSH_CC_PARAMETER_SETUPS_PKG;

932: END;
933: commit;
934: END load_row;
935:
936: end WSH_CC_PARAMETER_SETUPS_PKG;