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.CS_SERVICEREQUEST_PVT dependencies on CS_SERVICEREQUEST_PVT

Line 1: PACKAGE BODY CS_ServiceRequest_PVT AS

1: PACKAGE BODY CS_ServiceRequest_PVT AS
2: /* $Header: csvsrb.pls 120.93.12020000.11 2013/05/30 22:05:55 siahmed ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_PVT';
5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';

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

1: PACKAGE BODY CS_ServiceRequest_PVT AS
2: /* $Header: csvsrb.pls 120.93.12020000.11 2013/05/30 22:05:55 siahmed ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_PVT';
5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';
6: G_SR_SUBTYPE CONSTANT VARCHAR2(5) := 'INC';
7: G_API_REVISION CONSTANT NUMBER := 1.0;
8: G_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_B';

Line 162: l_log_module := 'cs.plsql.' || 'CS_SERVICEREQUEST_PVT.get_default_contract' || '.';

158: l_log_module VARCHAR2(255);
159: --Changes for 9648141
160: l_default_coverage_template_id NUMBER;
161: BEGIN
162: l_log_module := 'cs.plsql.' || 'CS_SERVICEREQUEST_PVT.get_default_contract' || '.';
163: px_inp_rec.contract_number := NULL;
164: px_inp_rec.contract_number_modifier := NULL;
165: px_inp_rec.service_line_id := NULL;
166: px_inp_rec.party_id := p_customer_id;

Line 419: l_api_name := 'CS_SERVICEREQUEST_PVT.vldt_sr_rec';

415: --siahmed 12.1.2 project
416: l_request_date DATE;
417: -- end of addition by siahmed
418: BEGIN
419: l_api_name := 'CS_SERVICEREQUEST_PVT.vldt_sr_rec';
420: l_log_module := 'cs.plsql.' || l_api_name || '.';
421: l_contract_service_id_valid := 'Y';
422: l_contract_defaulted := 'N';
423: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 596: CS_SERVICEREQUEST_PVT.get_default_contract

592: l_request_date := p_sr_rec.request_date;
593: END IF;
594: -- end of addition siahmed and added the value in the api call below before it was passing p_sr_rec.request_date directly.
595:
596: CS_SERVICEREQUEST_PVT.get_default_contract
597: ( p_business_process_id => p_sr_related_data.business_process_id
598: , p_customer_id => p_sr_rec.customer_id
599: , p_install_site_use_id => p_sr_rec.install_site_use_id
600: , p_account_id => p_sr_rec.account_id

Line 1099: CS_ServiceRequest_PVT.Create_ServiceRequest

1095:
1096: -- Initialize API return status to success
1097: x_return_status := FND_API.G_RET_STS_SUCCESS;
1098:
1099: CS_ServiceRequest_PVT.Create_ServiceRequest
1100: ( p_api_version => 4.0,
1101: p_init_msg_list => fnd_api.g_false ,
1102: p_commit => p_commit,
1103: p_validation_level => p_validation_level,

Line 1562: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'

1558: THEN
1559: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
1560: FND_MESSAGE.set_token
1561: ( 'API_NAME'
1562: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1563: );
1564: FND_MSG_PUB.ADD_DETAIL
1565: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1566: );

Line 1621: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'

1617: THEN
1618: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
1619: FND_MESSAGE.set_token
1620: ( 'API_NAME'
1621: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1622: );
1623: FND_MSG_PUB.ADD_DETAIL
1624: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
1625: );

Line 1661: CS_SERVICEREQUEST_PVT.get_incident_type_details

1657: -- if type attributes are needed for some other purpose then the if condition
1658: -- can be modified accordingly
1659: IF p_default_contract_sla_ind = 'Y'
1660: THEN
1661: CS_SERVICEREQUEST_PVT.get_incident_type_details
1662: ( p_incident_type_id => p_service_request_rec.type_id
1663: , x_business_process_id => l_sr_related_data.business_process_id
1664: , x_autolaunch_workflow_flag => l_sr_related_data.autolaunch_workflow_flag
1665: , x_abort_workflow_close_flag => l_sr_related_data.abort_workflow_close_flag

Line 1696: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

1692: -- Make the preprocessing call to the user hooks
1693: --
1694: -- Pre call to the Customer Type User Hook
1695: --
1696: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
1697: 'Create_ServiceRequest',
1698: 'B', 'C') THEN
1699:
1700: -- hardcoded the version 2.0 shijain nov 27 2002

Line 1753: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

1749: END IF;
1750:
1751: -- Pre call to the Vertical Type User Hook
1752: --
1753: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
1754: 'Create_ServiceRequest',
1755: 'B', 'V') THEN
1756:
1757: -- hardcoded the version 2.0 shijain nov 27 2002

Line 1868: CS_ServiceRequest_PVT.Create_SR_Validation

1864: -- use hook return value if it is not null otherwise use p_request_number
1865: if l_hook_request_number is null then
1866: l_hook_request_number:=p_request_number;
1867: end if;
1868: CS_ServiceRequest_PVT.Create_SR_Validation
1869: ( p_api_name => l_api_name_full,
1870: p_service_request_rec => p_service_request_rec,
1871: p_contacts => p_contacts,
1872: p_resp_id => p_resp_id,

Line 2930: CS_ServiceRequest_PVT.Create_Audit_Record (

2926: --siahmed 12.2+ end of project related attributes
2927:
2928: --siahmed added for disabling aduit when invocation_mode is set to REPLAY
2929: IF (p_invocation_mode <> 'REPLAY' ) THEN
2930: CS_ServiceRequest_PVT.Create_Audit_Record (
2931: p_api_version => 2.0,
2932: x_return_status => l_return_status,
2933: x_msg_count => x_msg_count,
2934: x_msg_data => x_msg_data,

Line 3137: IF (JTF_USR_HKS.Ok_To_Execute('CS_ServiceRequest_PVT', 'Create_ServiceRequest',

3133:
3134:
3135: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #8');
3136: -- Launching the workflow (HOOK)
3137: IF (JTF_USR_HKS.Ok_To_Execute('CS_ServiceRequest_PVT', 'Create_ServiceRequest',
3138: 'W', 'W')) THEN
3139:
3140: IF (cs_servicerequest_cuhk.Ok_To_Launch_Workflow(p_request_id => l_request_id,
3141: p_service_request_rec=>l_service_request_rec)) THEN

Line 3182: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

3178: -- Make the post processing call to the user hooks
3179: --
3180: -- Post call to the Customer Type User Hook
3181: --
3182: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
3183: 'Create_ServiceRequest',
3184: 'A', 'C') THEN
3185:
3186: -- hardcoded the version 2.0 shijain nov 27 2002

Line 3222: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

3218:
3219:
3220: -- Post call to the Vertical Type User Hook
3221: --
3222: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
3223: 'Create_ServiceRequest',
3224: 'A', 'V') THEN
3225:
3226: -- hardcoded the version 2.0 shijain nov 27 2002

Line 3312: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

3308: x_sr_create_out_rec.request_id := l_request_id;
3309: x_sr_create_out_rec.request_number := l_request_number;
3310:
3311: -- Standard call for message generation
3312: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
3313: 'Create_ServiceRequest',
3314: 'M', 'M') THEN
3315:
3316: IF (cs_servicerequest_cuhk.Ok_To_Generate_Msg(p_request_id => l_request_id,

Line 3609: CS_ServiceRequest_PVT.Update_ServiceRequest

3605: -- Initialize API return status to success
3606: x_return_status := FND_API.G_RET_STS_SUCCESS;
3607:
3608: -- Call 11.5.10 version of the Update SR API
3609: CS_ServiceRequest_PVT.Update_ServiceRequest
3610: ( p_api_version => 4.0,
3611: p_init_msg_list => FND_API.G_FALSE,
3612: p_commit => p_commit,
3613: p_validation_level => p_validation_level,

Line 3734: -- CS_SERVICEREQUEST_PVT.get_default_contract call

3730: -- if new status has pending approval flag as 'Y' then raise
3731: -- error because SR cannot be updated to an status needing
3732: -- approval
3733: -- Added new parameters to procedure
3734: -- CS_SERVICEREQUEST_PVT.get_default_contract call
3735: -- Moved SR Audit creation after ERES processing
3736: -- If SR status needs approval then Call ERES apporval
3737: -- CS_ERES_INT_PKG.start_approval_process procedure.
3738: -- if this procedure return NO_ACTION then do the following

Line 4348: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'

4344: THEN
4345: FND_MESSAGE.set_name ('CS', 'CS_SR_ITEM_SERIAL_OBSOLETE');
4346: FND_MESSAGE.set_token
4347: ( 'API_NAME'
4348: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4349: );
4350: FND_MSG_PUB.ADD_DETAIL
4351: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
4352: );

Line 4365: CS_SERVICEREQUEST_PVT.get_incident_type_details

4361: THEN
4362: l_service_request_rec.status_id := l_old_servicerequest_rec.incident_status_id;
4363: END IF;
4364:
4365: CS_SERVICEREQUEST_PVT.get_incident_type_details
4366: ( p_incident_type_id => l_service_request_rec.type_id
4367: , x_business_process_id => l_sr_related_data.business_process_id
4368: , x_autolaunch_workflow_flag => l_sr_related_data.autolaunch_workflow_flag
4369: , x_abort_workflow_close_flag => l_sr_related_data.abort_workflow_close_flag

Line 4500: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'

4496: THEN
4497: FND_MESSAGE.set_name ('CS', 'CS_SR_MAINT_ORG_NOT_ALLOWED');
4498: FND_MESSAGE.set_token
4499: ( 'API_NAME'
4500: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4501: );
4502: FND_MSG_PUB.ADD_DETAIL
4503: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
4504: );

Line 4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'

4640: THEN
4641: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
4642: FND_MESSAGE.set_token
4643: ( 'API_NAME'
4644: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4645: );
4646: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4647: FND_MSG_PUB.ADD_DETAIL
4648: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'

Line 4687: CS_SERVICEREQUEST_PVT.initialize_rec(l_service_request_rec);

4683: );
4684: RETURN;
4685: ELSE
4686: l_last_updated_by_temp := l_service_request_rec.last_updated_by;
4687: CS_SERVICEREQUEST_PVT.initialize_rec(l_service_request_rec);
4688: -- we need to copy back intermediate status because this case will happen only if
4689: -- input status has intermediate status
4690: l_service_request_rec.status_id := l_sr_related_data.intermediate_status_id;
4691: l_service_request_rec.last_updated_by := p_service_request_rec.last_updated_by;

Line 4713: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

4709: -- Make the preprocessing call to the user hooks
4710: --
4711: -- Pre call to the Customer Type User Hook
4712:
4713: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
4714: 'Update_ServiceRequest',
4715: 'B', 'C') THEN
4716:
4717: -- hardcoded the version 2.0 shijain nov 27 2002

Line 4752: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

4748: END IF;
4749:
4750: -- Pre call to the Vertical Type User Hook
4751: --
4752: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
4753: 'Update_ServiceRequest',
4754: 'B', 'V') THEN
4755:
4756: -- hardcoded the version 2.0 shijain nov 27 2002

Line 4947: CS_Servicerequest_PVT.Update_Status

4943: END if;
4944: --End of changes for bug 11699979
4945:
4946:
4947: CS_Servicerequest_PVT.Update_Status
4948: ( p_api_version => 2.0,
4949: p_init_msg_list => fnd_api.g_false ,
4950: p_resp_id => p_resp_id,
4951: p_validation_level => fnd_api.g_valid_level_full,

Line 6294: IF (JTF_USR_HKS.Ok_To_Execute('CS_ServiceRequest_PVT', 'Update_ServiceRequest',

6290: l_note_index := p_notes.NEXT(l_note_index);
6291: END LOOP;
6292:
6293: -- Launching the workflow (HOOK)
6294: IF (JTF_USR_HKS.Ok_To_Execute('CS_ServiceRequest_PVT', 'Update_ServiceRequest',
6295: 'W', 'W')) THEN
6296:
6297: IF (cs_servicerequest_cuhk.Ok_To_Launch_Workflow
6298: (p_request_id => p_request_id,

Line 6344: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

6340: --
6341: -- Post call to the Customer Type User Hook
6342: -- hardcoded the version 2.0 shijain nov 27 2002
6343:
6344: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
6345: 'Update_ServiceRequest',
6346: 'A', 'C') THEN
6347: cs_servicerequest_cuhk.Update_ServiceRequest_Post
6348: ( p_api_version => 2.0,

Line 6381: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

6377:
6378:
6379: -- Post call to the Vertical Type User Hook
6380: --
6381: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
6382: 'Update_ServiceRequest',
6383: 'A', 'V') THEN
6384:
6385: -- hardcoded the version 2.0 shijain nov 27 2002

Line 6452: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',

6448: END IF; /* only status update flag check */
6449:
6450:
6451: -- Standard call for message generation
6452: IF jtf_usr_hks.Ok_To_Execute('CS_ServiceRequest_PVT',
6453: 'Create_ServiceRequest',
6454: 'M', 'M') THEN
6455:
6456: IF (cs_servicerequest_cuhk.Ok_To_Generate_Msg(p_request_id => p_request_id,

Line 6600: ( p_api_name => 'CS_SERVICEREQUEST_PVT.update_servicerequest'

6596: IF l_approval_status = 'NO_ACTION'
6597: THEN
6598: -- validated orginal target status
6599: CS_ServiceRequest_UTIL.Validate_Updated_Status
6600: ( p_api_name => 'CS_SERVICEREQUEST_PVT.update_servicerequest'
6601: , p_parameter_name => 'p_status_id'
6602: , p_resp_id => p_resp_id
6603: , p_new_status_id => l_sr_related_data.target_status_id
6604: , p_old_status_id => l_old_servicerequest_rec.incident_status_id

Line 6834: CS_ServiceRequest_PVT.Create_Audit_Record

6830:
6831:
6832: --siahmed added for disabling audit when invocation_mode is of replay
6833: IF (p_invocation_mode <> 'REPLAY' ) THEN
6834: CS_ServiceRequest_PVT.Create_Audit_Record
6835: ( p_api_version => 2.0
6836: , x_return_status => l_return_status
6837: , x_msg_count => x_msg_count
6838: , x_msg_data => x_msg_data

Line 7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');

7612: (l_sr_related_data.old_disallow_request_update = 'Y') THEN
7613: FND_MESSAGE.set_name('CS','CS_ERES_SR_FROZEN_STATUS');
7614: FND_MSG_PUB.ADD;
7615: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
7616: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
7617: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
7618: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
7619: RAISE FND_API.G_EXC_ERROR;
7620: END IF; -- l_pending approval flag is Y

Line 7643: , 'CS_SERVICEREQUEST_PVT.update_status'

7639: IF l_sr_related_data.pending_approval_flag = 'Y' THEN
7640: FND_MESSAGE.set_name ('CS', 'CS_SR_INTERMEDIATE_STATUS');
7641: FND_MESSAGE.set_token
7642: ( 'API_NAME'
7643: , 'CS_SERVICEREQUEST_PVT.update_status'
7644: );
7645: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
7646: FND_MSG_PUB.ADD_DETAIL
7647: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'

Line 7655: CS_ServiceRequest_PVT.Update_ServiceRequest

7651: */
7652: IF l_sr_related_data.intermediate_status_id IS NOT NULL
7653: THEN
7654:
7655: CS_ServiceRequest_PVT.Update_ServiceRequest
7656: ( p_api_version => 4.0
7657: , p_init_msg_list => p_init_msg_list
7658: , p_commit => p_commit
7659: , p_validation_level => p_validation_level

Line 20939: CS_ServiceRequest_PVT.Create_ServiceRequest

20935:
20936: -- Initialize API return status to success
20937: x_return_status := FND_API.G_RET_STS_SUCCESS;
20938:
20939: CS_ServiceRequest_PVT.Create_ServiceRequest
20940: ( p_api_version => 3.0,
20941: p_init_msg_list => p_init_msg_list,
20942: p_commit => p_commit,
20943: p_validation_level => p_validation_level,

Line 21479: -- cs_servicerequest_pvt.process_sr_ext_attrs

21475: -- IN :
21476: -- OUT :
21477: --
21478: -- Description : This is a wrapper for procedure
21479: -- cs_servicerequest_pvt.process_sr_ext_attrs
21480: --
21481: -- Modification History:
21482: -- Date Name Desc
21483: -- -------- -------- -----------------------------------------------------------

Line 22863: END CS_ServiceRequest_PVT;

22859:
22860: ----------------------------------------------------------------------------------------------
22861:
22862:
22863: END CS_ServiceRequest_PVT;