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

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 11: -- Insert a row into WSH_CC_SERVICE_SETUPS entity

7: /* Insert_Row Procedure */
8: /*----------------------------------------------------------*/
9: /* --
10: -- Purpose
11: -- Insert a row into WSH_CC_SERVICE_SETUPS entity
12: --
13: -- Input Parameters
14: -- p_api_version
15: -- API version number (current version is 1.0)

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 99: select wsh_cc_service_setups_s.nextval into l_CC_Service_Sequence_ID from dual;

95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97: --dbms_output.put_line('begin api-2');
98:
99: select wsh_cc_service_setups_s.nextval into l_CC_Service_Sequence_ID from dual;
100: /* Validate input parameters if any */
101:
102: -- Insert a row into wsh_cc_service_setups entity with all detail information
103: INSERT INTO Wsh_cc_Service_Setups

Line 102: -- Insert a row into wsh_cc_service_setups entity with all detail information

98:
99: select wsh_cc_service_setups_s.nextval into l_CC_Service_Sequence_ID from dual;
100: /* Validate input parameters if any */
101:
102: -- Insert a row into wsh_cc_service_setups entity with all detail information
103: INSERT INTO Wsh_cc_Service_Setups
104: ( CC_SERVICE_SEQUENCE_ID
105: ,APPLICATION_ID
106: ,MASTER_ORGANIZATION_ID

Line 103: INSERT INTO Wsh_cc_Service_Setups

99: select wsh_cc_service_setups_s.nextval into l_CC_Service_Sequence_ID from dual;
100: /* Validate input parameters if any */
101:
102: -- Insert a row into wsh_cc_service_setups entity with all detail information
103: INSERT INTO Wsh_cc_Service_Setups
104: ( CC_SERVICE_SEQUENCE_ID
105: ,APPLICATION_ID
106: ,MASTER_ORGANIZATION_ID
107: ,ORGANIZATION_ID

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 214: -- Update a row into WSH_CC_service_setups entity

210: /* Update_Row Procedure */
211: /*----------------------------------------------------------*/
212: /* --
213: -- Purpose
214: -- Update a row into WSH_CC_service_setups entity
215: -- for the given cc service seq id
216: --
217: -- Input Parameters
218: -- p_api_version

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 304: update wsh_cc_service_setups

300:
301: -- Update a row into wsh_cc_users entity with all detail information
302: -- for the given cc seq id
303:
304: update wsh_cc_service_setups
305: SET
306: MASTER_ORGANIZATION_ID = p_MASTER_ORGANIZATION_ID
307: ,APPLICATION_ID = p_APPLICATION_ID
308: ,ORGANIZATION_ID = decode(p_ORGANIZATION_ID,fnd_api.g_miss_num,

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 392: -- Delete a row from WSH_CC_Service_Setups entity

388: /* Delete_Row Procedure */
389: /*----------------------------------------------------------*/
390: /* --
391: -- Purpose
392: -- Delete a row from WSH_CC_Service_Setups entity
393: -- for the given service seq id
394: --
395: -- Input Parameters
396: -- p_api_version

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 461: -- Delete a row from wsh_cc_service_setups entity

457: END IF;
458: -- Initialize API return status to success
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: -- Delete a row from wsh_cc_service_setups entity
462: -- for the given service seq id
463:
464: DELETE from wsh_cc_service_setups
465: WHERE cc_service_sequence_id = p_cc_service_sequence_id ;

Line 464: DELETE from wsh_cc_service_setups

460:
461: -- Delete a row from wsh_cc_service_setups entity
462: -- for the given service seq id
463:
464: DELETE from wsh_cc_service_setups
465: WHERE cc_service_sequence_id = p_cc_service_sequence_id ;
466: IF SQL%NOTFOUND THEN
467: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
468: FND_MSG_PUB.ADD;

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 528: -- Check Lock a row of WSH_CC_SERVICE_SETUPS entity

524: /* Lock_Row Procedure */
525: /*----------------------------------------------------------*/
526: /* --
527: -- Purpose
528: -- Check Lock a row of WSH_CC_SERVICE_SETUPS entity
529: -- for the given service seq id
530: --
531: -- Input Parameters
532: -- p_api_version

Line 594: FROM wsh_cc_service_setups

590: )
591: IS
592: CURSOR lock_row IS
593: SELECT *
594: FROM wsh_cc_service_setups
595: WHERE rowid = p_rowid
596: FOR UPDATE OF CC_SERVICE_SEQUENCE_ID NOWAIT;
597:
598: Recinfo lock_row%ROWTYPE;

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 623: -- Check Lock a row of wsh_cc_service_setups

619: END IF;
620: -- Initialize API return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: -- Check Lock a row of wsh_cc_service_setups
624: OPEN lock_row;
625: FETCH lock_row into Recinfo;
626:
627: IF (lock_row%NOTFOUND) THEN

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;