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