[Home] [Help]
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
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:
2472: -- Initialize the return status.
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
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
2587: IF ( p_customer_product_id IS NOT NULL ) AND
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:
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:
3510: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
3511:
3512: CURSOR Bill_To_Site IS
3513: SELECT su.party_site_use_id
3514: FROM Hz_Party_Sites s,
3515: Hz_Party_Site_Uses su
3516: WHERE s.party_site_id = su.party_site_id
3517: AND s.party_site_id = p_bill_to_site_id
3518: AND s.party_id = p_bill_to_party_id
3574: -- Fix to bug # 2529361.included keyword distinct in select clause.
3575: -- # 2615775 - removed reference to hz_party_site_uses..
3576:
3577: SELECT DISTINCT s.party_id INTO l_install_customer_id
3578: FROM Hz_Party_Sites s
3579: WHERE s.party_site_id = p_install_site_id
3580: AND s.status = 'A'
3581: -- Belongs to SR Customer
3582: AND ( s.party_id = p_customer_id
6160: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
6161:
6162: CURSOR Site_Site_Use IS
6163: SELECT s.status
6164: FROM Hz_Party_Sites s,
6165: Hz_Party_Site_Uses su
6166: WHERE s.party_site_id = su.party_site_id
6167: AND s.party_site_id = p_site_id
6168: AND s.party_id = p_party_id
6224: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
6225:
6226: CURSOR Bill_To_Site_Use IS
6227: SELECT s.party_site_id
6228: FROM Hz_Party_Sites s,
6229: Hz_Party_Site_Uses su
6230: WHERE s.party_site_id = su.party_site_id
6231: AND su.party_site_use_id = p_site_use_id
6232: AND s.party_id = p_party_id
6387:
6388: x_return_status := FND_API.G_RET_STS_SUCCESS;
6389: -- Changes made for bug 9061438 by Sanjana Rao on 08-jan-2010.As per new logic we will
6390: --do the install site validation only when instance has a valid install site type
6391: -- of type 'HZ_PARTY_SITES'
6392: SELECT a.install_location_id,a.install_location_type_code
6393: INTO l_install_site_id,l_install_site_type
6394: FROM csi_item_instances a
6395: WHERE a.instance_id = p_customer_product_id;
6392: SELECT a.install_location_id,a.install_location_type_code
6393: INTO l_install_site_id,l_install_site_type
6394: FROM csi_item_instances a
6395: WHERE a.instance_id = p_customer_product_id;
6396: -- If instance has install party sites of type HZ_PARTY_SITES
6397: -- then validate that
6398: IF l_install_site_type='HZ_PARTY_SITES' THEN
6399: IF l_install_site_id <> p_install_site_id THEN
6400: x_return_status := FND_API.G_RET_STS_ERROR;
6394: FROM csi_item_instances a
6395: WHERE a.instance_id = p_customer_product_id;
6396: -- If instance has install party sites of type HZ_PARTY_SITES
6397: -- then validate that
6398: IF l_install_site_type='HZ_PARTY_SITES' THEN
6399: IF l_install_site_id <> p_install_site_id THEN
6400: x_return_status := FND_API.G_RET_STS_ERROR;
6401: fnd_message.set_name ('CS', 'CS_INVALID_INSTALL_SITE');
6402: fnd_message.set_token('INSTALL_SITE_ID', p_install_site_id);
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));