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.41.12020000.4 2013/05/30 22:08:36 siahmed 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.41.12020000.4 2013/05/30 22:08:36 siahmed 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 3542: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

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

Line 6193: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

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

Line 6257: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

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

Line 6750: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

6746: EXCEPTION
6747: WHEN NO_DATA_FOUND THEN
6748: -- For bug 3324210 and 3324179
6749: x_return_status := FND_API.G_RET_STS_ERROR;
6750: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
6751: p_token_an => l_api_name_full,
6752: -- p_token_v => to_char(p_cp_component_id), --3815710
6753: p_token_v => to_char(p_inv_component_id),
6754: p_token_p => p_parameter_name );

Line 6792: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(

6788: EXCEPTION
6789: WHEN NO_DATA_FOUND THEN
6790: -- For bug 3324210 and 3324179
6791: x_return_status := FND_API.G_RET_STS_ERROR;
6792: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
6793: p_token_an => l_api_name_full,
6794: p_token_v => to_char(p_cp_subcomponent_id),
6795: p_token_p => p_parameter_name );
6796:

Line 7222: CS_ServiceRequest_UTIL.Validate_Inventory_Org

7218: -- Start the cross validation checks and call outs
7219: -- this is done to inv_org_master_org_flag for further validation
7220: IF l_inv_org_id IS NOT NULL
7221: THEN
7222: CS_ServiceRequest_UTIL.Validate_Inventory_Org
7223: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.servicerequest_cross_val'
7224: , p_parameter_name => 'Inventory Organization'
7225: , p_inv_org_id => l_inv_org_id
7226: , x_inv_org_master_org_flag => l_inv_org_master_org_flag

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

7219: -- this is done to inv_org_master_org_flag for further validation
7220: IF l_inv_org_id IS NOT NULL
7221: THEN
7222: CS_ServiceRequest_UTIL.Validate_Inventory_Org
7223: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.servicerequest_cross_val'
7224: , p_parameter_name => 'Inventory Organization'
7225: , p_inv_org_id => l_inv_org_id
7226: , x_inv_org_master_org_flag => l_inv_org_master_org_flag
7227: , x_return_status => lx_return_status

Line 7251: CS_ServiceRequest_UTIL.Validate_Owning_department

7247: IF l_owning_dept_id IS NOT NULL AND
7248: (l_owning_dept_id <> NVL(p_old_sr_rec.owning_department_id ,-9) OR
7249: NVL(l_maint_organization_id,-9) <> NVL(p_old_sr_rec.maint_organization_id,-9))
7250: THEN
7251: CS_ServiceRequest_UTIL.Validate_Owning_department
7252: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.validate_owning_department',
7253: p_parameter_name => 'Owning Department',
7254: p_inv_org_id => l_maint_organization_id,
7255: p_owning_dept_id => l_owning_dept_id,

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

7248: (l_owning_dept_id <> NVL(p_old_sr_rec.owning_department_id ,-9) OR
7249: NVL(l_maint_organization_id,-9) <> NVL(p_old_sr_rec.maint_organization_id,-9))
7250: THEN
7251: CS_ServiceRequest_UTIL.Validate_Owning_department
7252: ( p_api_name => 'CS_SERVICEREQUEST_UTIL.validate_owning_department',
7253: p_parameter_name => 'Owning Department',
7254: p_inv_org_id => l_maint_organization_id,
7255: p_owning_dept_id => l_owning_dept_id,
7256: p_maintenance_flag => l_maint_flag,

Line 7709: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Id(

7705: THEN
7706:
7707: if ( l_inv_subcomp_id IS NOT NULL and l_inv_subcomp_id <> FND_API.G_MISS_NUM ) then
7708:
7709: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Id(
7710: p_api_name => NULL,
7711: p_parameter_name => 'p_inv_subcomponent_id',
7712: p_inventory_org_id => l_inv_org_id,
7713: p_inv_subcomponent_id => l_inv_subcomp_id,

Line 8671: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use

8667: ELSIF ( ( l_bto_site_use <> FND_API.G_MISS_NUM AND l_bto_site_use IS NOT NULL ) AND
8668: ( l_bto_site_id IS NULL OR l_bto_site_id = FND_API.G_MISS_NUM )
8669: ) THEN
8670: -- this call is made when site use is availabel but site id is not available
8671: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use
8672: ( p_api_name => null,
8673: -- p_parameter_name => 'Ship_To Site Use ', /* Modified during 3702517 fix */
8674: p_parameter_name => 'BILL TO SITE USE',
8675: p_site_use_id => l_bto_site_use,

Line 8691: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site

8687: ELSIF ( ( l_bto_site_id <> FND_API.G_MISS_NUM AND l_bto_site_id IS NOT NULL ) AND
8688: ( l_bto_site_use IS NULL OR l_bto_site_use = FND_API.G_MISS_NUM )
8689: ) THEN
8690: -- this call is made when site use is not available but site id is available
8691: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
8692: ( p_api_name => null,
8693: -- p_parameter_name => 'Ship_To Site ', /* Modified during 3702517 fix */
8694: p_parameter_name => 'SHIP TO SITE',
8695: p_bill_to_site_id => l_bto_site_id,

Line 9213: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg

9209: FETCH l_ServiceRequest_csr INTO x_audit_vals_rec;
9210:
9211: IF ( l_ServiceRequest_csr%NOTFOUND ) THEN
9212:
9213: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
9214: ( p_token_an => l_api_name,
9215: p_token_v => TO_CHAR(p_request_id),
9216: p_token_p => 'p_request_id',
9217: p_table_name => 'CS_INCIDENTS_ALL_B',

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

9291: resp_appl_id => p_resp_appl_id,
9292: resp_id => p_resp_id
9293: ) THEN
9294: l_error_message := FND_FLEX_DESCVAL.Error_Message;
9295: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
9296: p_return_status := FND_API.G_RET_STS_ERROR;
9297: END IF;
9298: END IF;
9299:

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

9339: IF c_party_role % NOTFOUND
9340: THEN
9341: x_return_status := FND_API.G_RET_STS_ERROR;
9342: FND_MESSAGE.set_name('CS','CS_SR_PARTY_ROLE_NE');
9343: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9344: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9345: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9346: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1 => l_associated_col1);
9347: ELSIF l_sys_dt < NVL(l_start_dt, l_sys_dt) OR

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

9348: l_sys_dt > NVL(l_end_dt , l_sys_dt)
9349: THEN
9350: x_return_status := FND_API.G_RET_STS_ERROR;
9351: FND_MESSAGE.set_name('CS','CS_SR_PARTYROLE_INACTIVE');
9352: FND_MESSAGE.set_token('API_NAME','cs_servicerequest_util.validate_party_role_code');
9353: FND_MESSAGE.set_token('PARTY_ROLE_CODE',p_party_role_code);
9354: FND_MSG_PUB.add_detail(p_associated_column1 => 'cs_hz_sr_contact_points.party_role_code');
9355: END IF;
9356: CLOSE c_party_role;

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

9362: THEN
9363: CLOSE c_party_role;
9364: END IF;
9365: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9366: FND_MESSAGE.set_token('P_TEXT','CS_SERVICEREQUEST_UTIL.validate_party_role_code'||'-'||SQLERRM);
9367: FND_MSG_PUB.ADD;
9368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9369: END validate_party_role_code;
9370: -- -----------------------------------------------------------------------------

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

9407: IF l_sys_dt < NVL(l_dt_from, l_sys_dt) OR
9408: l_sys_dt > NVL(l_dt_to , l_sys_dt)
9409: THEN
9410: FND_MESSAGE.set_name ('CS', 'CS_SR_ORG_ID_INACTIVE');
9411: FND_MESSAGE.set_token ('API_NAME', 'CS_SERVICEREQUEST_UTIL.validate_org_id');
9412: FND_MESSAGE.set_token ('ORG_ID', p_org_id);
9413: FND_MSG_PUB.ADD;
9414: x_return_status := FND_API.G_RET_STS_ERROR;
9415: END IF;

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

9416: EXCEPTION
9417: WHEN NO_DATA_FOUND THEN
9418: x_return_status := FND_API.G_RET_STS_ERROR;
9419: Add_Invalid_Argument_Msg
9420: ( p_token_an => 'cs_servicerequest_util.validate_org_id'
9421: , p_token_v => TO_CHAR(p_org_id)
9422: , p_token_p => 'p_org_id'
9423: , p_table_name => G_TABLE_NAME
9424: , p_column_name => 'ORG_ID'

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

9424: , p_column_name => 'ORG_ID'
9425: );
9426: WHEN OTHERS THEN
9427: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9428: fnd_message.set_token ('P_TEXT','cs_servicerequest_util.validate_org_id'||'-'||SQLERRM);
9429: fnd_msg_pub.ADD;
9430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9431: END validate_org_id;
9432: -- -----------------------------------------------------------------------------

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

9603: l_dummy NUMBER;
9604: l_proc_name VARCHAR2(61);
9605: BEGIN
9606: l_sys_dt := SYSDATE;
9607: l_proc_name := 'CS_SERVICEREQUEST_UTIL.validate_customer_product_id';
9608: get_customer_product_details
9609: ( p_customer_product_id => p_customer_product_id
9610: , x_party_source_table => l_source_table
9611: , x_party_id => l_party_id

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

9913: WHEN OTHERS THEN
9914: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9915: FND_MESSAGE.set_token
9916: ( 'P_TEXT'
9917: , 'CS_SERVICEREQUEST_UTIL.get_status_details'||'-'||SQLERRM
9918: );
9919: FND_MSG_PUB.ADD;
9920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9921: END get_reacted_resolved_dates;

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

9964: WHEN OTHERS THEN
9965: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
9966: fnd_message.set_token
9967: ( 'P_TEXT'
9968: , 'CS_SERVICEREQUEST_UTIL.get_party_detail:'||'-'||SQLERRM
9969: );
9970: fnd_msg_pub.ADD;
9971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9972:

Line 10065: , 'CS_SERVICEREQUEST_UTIL.update_task_address'

10061: THEN
10062: FND_MESSAGE.set_name ('CS', 'CS_SR_OPEN_FS_TASKS');
10063: FND_MESSAGE.set_token
10064: ( 'API_NAME'
10065: , 'CS_SERVICEREQUEST_UTIL.update_task_address'
10066: );
10067: FND_MSG_PUB.ADD_DETAIL
10068: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_location_id'
10069: );

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

10350: resp_appl_id => p_resp_appl_id,
10351: resp_id => p_resp_id
10352: ) THEN
10353: l_error_message := FND_FLEX_DESCVAL.Error_Message;
10354: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
10355: p_return_status := FND_API.G_RET_STS_ERROR;
10356: END IF;
10357: END IF;
10358:

Line 10655: END CS_ServiceRequest_UTIL;

10651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10652: END VALIDATE_PRICE_LIST_HEADER;
10653:
10654:
10655: END CS_ServiceRequest_UTIL;