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_UTIL dependencies on CS_SERVICEREQUEST_UTIL

Line 1: PACKAGE BODY CS_ServiceRequest_UTIL AS

1: PACKAGE BODY CS_ServiceRequest_UTIL AS
2: /* $Header: csusrb.pls 120.30 2008/01/09 11:58:04 nveerara ship $ */
3:
4: G_ACTION_SUBTYPE CONSTANT VARCHAR2(5) := 'ACT';
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_UTIL';

1: PACKAGE BODY CS_ServiceRequest_UTIL AS
2: /* $Header: csusrb.pls 120.30 2008/01/09 11:58:04 nveerara ship $ */
3:
4: G_ACTION_SUBTYPE CONSTANT VARCHAR2(5) := 'ACT';
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_UTIL';
6: G_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_B';
7: G_TL_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_TL';
8:
9: -- -----------------------------------------------------------------------------

Line 55: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.get_org_details'||'-'||SQLERRM);

51: --
52: EXCEPTION
53: WHEN OTHERS THEN
54: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
55: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.get_org_details'||'-'||SQLERRM);
56: FND_MSG_PUB.ADD;
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58: END get_org_details;
59: -- -----------------------------------------------------------------------------

Line 132: FND_MESSAGE.set_token ('P_TEXT','CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM);

128: WHEN NO_DATA_FOUND THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: WHEN OTHERS THEN
131: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
132: FND_MESSAGE.set_token ('P_TEXT','CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM);
133: FND_MSG_PUB.ADD;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: END get_status_details;
136: -- -----------------------------------------------------------------------------

Line 3540: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

3536: END IF;
3537: CLOSE bill_to_site ;
3538: EXCEPTION
3539: WHEN NO_DATA_FOUND THEN
3540: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
3541: ( p_token_an => l_api_name_full,
3542: p_token_v => TO_CHAR(p_bill_to_site_id),
3543: p_token_p => p_parameter_name,
3544: p_table_name => G_TABLE_NAME ,

Line 6191: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

6187: END IF;
6188: CLOSE site_site_use ;
6189: EXCEPTION
6190: WHEN NO_DATA_FOUND THEN
6191: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
6192: (p_token_an => l_api_name_full,
6193: p_token_v => 'site_id:='||to_char(p_site_id)||' or site_use_id:='||to_char(p_site_use_id),
6194: p_token_p => p_parameter_name );
6195:

Line 6255: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

6251: CLOSE bill_to_site_use ;
6252:
6253: EXCEPTION
6254: WHEN NO_DATA_FOUND THEN
6255: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
6256: p_token_an => l_api_name_full,
6257: p_token_v => to_char(p_site_use_id),
6258: p_token_p => p_parameter_name );
6259:

Line 6734: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

6730: EXCEPTION
6731: WHEN NO_DATA_FOUND THEN
6732: -- For bug 3324210 and 3324179
6733: x_return_status := FND_API.G_RET_STS_ERROR;
6734: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
6735: p_token_an => l_api_name_full,
6736: -- p_token_v => to_char(p_cp_component_id), --3815710
6737: p_token_v => to_char(p_inv_component_id),
6738: p_token_p => p_parameter_name );

Line 6776: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

6772: EXCEPTION
6773: WHEN NO_DATA_FOUND THEN
6774: -- For bug 3324210 and 3324179
6775: x_return_status := FND_API.G_RET_STS_ERROR;
6776: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
6777: p_token_an => l_api_name_full,
6778: p_token_v => to_char(p_cp_subcomponent_id),
6779: p_token_p => p_parameter_name );
6780:

Line 7206: CS_ServiceRequest_UTIL.Validate_Inventory_Org

7202: -- Start the cross validation checks and call outs
7203: -- this is done to inv_org_master_org_flag for further validation
7204: IF l_inv_org_id IS NOT NULL
7205: THEN
7206: CS_ServiceRequest_UTIL.Validate_Inventory_Org
7207: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.servicerequest_cross_val'
7208: , p_parameter_name => 'Inventory Organization'
7209: , p_inv_org_id => l_inv_org_id
7210: , x_inv_org_master_org_flag => l_inv_org_master_org_flag

Line 7207: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.servicerequest_cross_val'

7203: -- this is done to inv_org_master_org_flag for further validation
7204: IF l_inv_org_id IS NOT NULL
7205: THEN
7206: CS_ServiceRequest_UTIL.Validate_Inventory_Org
7207: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.servicerequest_cross_val'
7208: , p_parameter_name => 'Inventory Organization'
7209: , p_inv_org_id => l_inv_org_id
7210: , x_inv_org_master_org_flag => l_inv_org_master_org_flag
7211: , x_return_status => lx_return_status

Line 7235: CS_ServiceRequest_UTIL.Validate_Owning_department

7231: IF l_owning_dept_id IS NOT NULL AND
7232: (l_owning_dept_id <> NVL(p_old_sr_rec.owning_department_id ,-9) OR
7233: NVL(l_maint_organization_id,-9) <> NVL(p_old_sr_rec.maint_organization_id,-9))
7234: THEN
7235: CS_ServiceRequest_UTIL.Validate_Owning_department
7236: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.validate_owning_department',
7237: p_parameter_name => 'Owning Department',
7238: p_inv_org_id => l_maint_organization_id,
7239: p_owning_dept_id => l_owning_dept_id,

Line 7236: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.validate_owning_department',

7232: (l_owning_dept_id <> NVL(p_old_sr_rec.owning_department_id ,-9) OR
7233: NVL(l_maint_organization_id,-9) <> NVL(p_old_sr_rec.maint_organization_id,-9))
7234: THEN
7235: CS_ServiceRequest_UTIL.Validate_Owning_department
7236: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.validate_owning_department',
7237: p_parameter_name => 'Owning Department',
7238: p_inv_org_id => l_maint_organization_id,
7239: p_owning_dept_id => l_owning_dept_id,
7240: p_maintenance_flag => l_maint_flag,

Line 7693: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Id(

7689: THEN
7690:
7691: if ( l_inv_subcomp_id IS NOT NULL and l_inv_subcomp_id <> FND_API.G_MISS_NUM ) then
7692:
7693: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Id(
7694: p_api_name => NULL,
7695: p_parameter_name => 'p_inv_subcomponent_id',
7696: p_inventory_org_id => l_inv_org_id,
7697: p_inv_subcomponent_id => l_inv_subcomp_id,

Line 8655: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use

8651: ELSIF ( ( l_bto_site_use <> FND_API.G_MISS_NUM AND l_bto_site_use IS NOT NULL ) AND
8652: ( l_bto_site_id IS NULL OR l_bto_site_id = FND_API.G_MISS_NUM )
8653: ) THEN
8654: -- this call is made when site use is availabel but site id is not available
8655: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use
8656: ( p_api_name => null,
8657: -- p_parameter_name => 'Ship_To Site Use ', /* Modified during 3702517 fix */
8658: p_parameter_name => 'BILL TO SITE USE',
8659: p_site_use_id => l_bto_site_use,

Line 8675: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site

8671: ELSIF ( ( l_bto_site_id <> FND_API.G_MISS_NUM AND l_bto_site_id IS NOT NULL ) AND
8672: ( l_bto_site_use IS NULL OR l_bto_site_use = FND_API.G_MISS_NUM )
8673: ) THEN
8674: -- this call is made when site use is not available but site id is available
8675: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
8676: ( p_api_name => null,
8677: -- p_parameter_name => 'Ship_To Site ', /* Modified during 3702517 fix */
8678: p_parameter_name => 'SHIP TO SITE',
8679: p_bill_to_site_id => l_bto_site_id,

Line 9161: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

9157: FETCH l_ServiceRequest_csr INTO x_audit_vals_rec;
9158:
9159: IF ( l_ServiceRequest_csr%NOTFOUND ) THEN
9160:
9161: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
9162: ( p_token_an => l_api_name,
9163: p_token_v => TO_CHAR(p_request_id),
9164: p_token_p => 'p_request_id',
9165: p_table_name => 'CS_INCIDENTS_ALL_B',

Line 9243: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);

9239: resp_appl_id => p_resp_appl_id,
9240: resp_id => p_resp_id
9241: ) THEN
9242: l_error_message := FND_FLEX_DESCVAL.Error_Message;
9243: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
9244: p_return_status := FND_API.G_RET_STS_ERROR;
9245: END IF;
9246: END IF;
9247:

Line 9291: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');

9287: IF c_party_role % NOTFOUND
9288: THEN
9289: x_return_status := FND_API.G_RET_STS_ERROR;
9290: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9291: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9292: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9293: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9294: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9295: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR

Line 9300: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');

9296: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9297: THEN
9298: x_return_status := FND_API.G_RET_STS_ERROR;
9299: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9300: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9301: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9302: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9303: END IF;
9304: CLOSE c_party_role;

Line 9314: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);

9310: THEN
9311: CLOSE c_party_role;
9312: END IF;
9313: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9314: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);
9315: FND_MSG_PUB.ADD;
9316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9317: END validate_party_role_code;
9318: -- -----------------------------------------------------------------------------

Line 9359: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');

9355: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9356: l_sys_dt > NVL(l_dt_to , l_sys_dt)
9357: THEN
9358: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9359: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9360: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9361: FND_MSG_PUB.ADD;
9362: x_return_status := FND_API.G_RET_STS_ERROR;
9363: END IF;

Line 9368: ( p_token_an => 'cs_servicerequest_util.validate_org_id'

9364: EXCEPTION
9365: WHEN NO_DATA_FOUND THEN
9366: x_return_status := FND_API.G_RET_STS_ERROR;
9367: Add_Invalid_Argument_Msg
9368: ( p_token_an => 'cs_servicerequest_util.validate_org_id'
9369: , p_token_v => TO_CHAR(p_org_id)
9370: , p_token_p => 'p_org_id'
9371: , p_table_name => G_TABLE_NAME
9372: , p_column_name => 'ORG_ID'

Line 9376: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);

9372: , p_column_name => 'ORG_ID'
9373: );
9374: WHEN OTHERS THEN
9375: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9376: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);
9377: fnd_msg_pub.ADD;
9378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9379: END validate_org_id;
9380: -- -----------------------------------------------------------------------------

Line 9555: l_proc_name := 'CS_SERVICEREQUEST_UTIL.validate_customer_product_id';

9551: l_dummy NUMBER;
9552: l_proc_name VARCHAR2(61);
9553: BEGIN
9554: l_sys_dt := SYSDATE;
9555: l_proc_name := 'CS_SERVICEREQUEST_UTIL.validate_customer_product_id';
9556: get_customer_product_details
9557: ( p_customer_product_id => p_customer_product_id
9558: , x_party_source_table => l_source_table
9559: , x_party_id => l_party_id

Line 9854: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM

9850: WHEN OTHERS THEN
9851: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9852: FND_MESSAGE.set_token
9853: ( 'P_TEXT'
9854: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9855: );
9856: FND_MSG_PUB.ADD;
9857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9858: END get_reacted_resolved_dates;

Line 9905: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM

9901: WHEN OTHERS THEN
9902: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9903: fnd_message.set_token
9904: ( 'P_TEXT'
9905: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9906: );
9907: fnd_msg_pub.ADD;
9908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9909:

Line 9987: , 'CS_SERVICEREQUEST_UTIL.update_task_address'

9983: THEN
9984: FND_MESSAGE.set_name ('CS', 'CS_SR_OPEN_FS_TASKS');
9985: FND_MESSAGE.set_token
9986: ( 'API_NAME'
9987: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
9988: );
9989: FND_MSG_PUB.ADD_DETAIL
9990: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_location_id'
9991: );

Line 10274: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);

10270: resp_appl_id => p_resp_appl_id,
10271: resp_id => p_resp_id
10272: ) THEN
10273: l_error_message := FND_FLEX_DESCVAL.Error_Message;
10274: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
10275: p_return_status := FND_API.G_RET_STS_ERROR;
10276: END IF;
10277: END IF;
10278:

Line 10367: END CS_ServiceRequest_UTIL;

10363:
10364: END BOOLEAN_TO_NUMBER;
10365:
10366:
10367: END CS_ServiceRequest_UTIL;