[Home] [Help]
1924: -- IF block added for validation based on location type --anmukher -- 08/18/03
1925: If p_incident_location_type = 'HZ_LOCATION' Then
1926:
1927: SELECT country INTO x_incident_country
1928: FROM hz_locations
1929: WHERE location_id = p_incident_location_id;
1930: Elsif p_incident_location_type = 'HZ_PARTY_SITE' Then
1931:
1932: SELECT b.country INTO x_incident_country
1930: Elsif p_incident_location_type = 'HZ_PARTY_SITE' Then
1931:
1932: SELECT b.country INTO x_incident_country
1933: FROM hz_party_sites a,
1934: hz_locations b
1935: WHERE party_site_id = p_incident_location_id
1936: AND a.location_id = b.location_id;
1937:
1938: Else
2473: x_return_status := FND_API.G_RET_STS_SUCCESS;
2474:
2475: -- Changes made by shijain dec 4th 2002, added the check if the profile
2476: -- value of cs_sr_restrict_ib is yes then check for hz_party_sites and
2477: -- hz_locations else don't need to check anything
2478:
2479: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2480: SELECT a.inventory_item_id
2481: INTO p_inventory_item_id
2486: --AND a.owner_party_id = p_customer_id
2487: AND cip.party_id = p_customer_id
2488: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
2489: AND TRUNC(NVL(a.active_end_date, SYSDATE))
2490: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
2491: AND a.owner_party_source_table = 'HZ_PARTIES'
2492: AND a.instance_id = cip.instance_id
2493: AND cip.party_source_table = 'HZ_PARTIES'
2494: AND a.inventory_item_id = b.inventory_item_id
2588: ( p_customer_product_id <> FND_API.G_MISS_NUM ) THEN
2589:
2590: -- Changes made by shijain dec 4th 2002, added the check if the profile
2591: -- value of cs_sr_restrict_ib is yes then check for hz_party_sites and
2592: -- hz_locations else don't need to check anything
2593:
2594: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2595:
2596: SELECT 'x' INTO l_dummy
2607: -- Added contract_item_type_code condition
2608: -- For ER 3701924
2609: -- AND contract_item_type_code IS NULL
2610: -- Added for Bug# 2167129,2175917
2611: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
2612: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
2613: AND TRUNC(NVL(a.active_end_date, SYSDATE))
2614: AND b.inventory_item_id = a.inventory_item_id
2615: AND b.organization_id = p_inventory_org_id
3243: AND cip.party_id = p_customer_id
3244: AND a.instance_id = cip.instance_id
3245: AND cip.party_source_table = 'HZ_PARTIES'
3246: AND b.serv_req_enabled_code = 'E'
3247: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
3248: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
3249: AND TRUNC(NVL(a.active_end_date, SYSDATE))
3250: AND b.inventory_item_id = a.inventory_item_id
3251: AND b.organization_id = p_inventory_org_id
3287: AND b.inventory_item_id = a.inventory_item_id
3288: AND cip.party_id = p_customer_id
3289: AND a.instance_id = cip.instance_id
3290: AND a.external_reference = p_external_reference
3291: AND a.location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS')
3292: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(a.active_start_date,SYSDATE))
3293: AND TRUNC(NVL(a.active_end_date, SYSDATE))
3294: AND rownum < 2;
3295:
9634: RAISE FND_API.G_EXC_ERROR;
9635: END IF;
9636: --
9637: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9638: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);
9642: FND_MESSAGE.set_token('CP_ID',TO_CHAR(p_customer_product_id));