[Home] [Help]
270: l_product_category_id := nvl(p_probcode_criteria_rec.product_category_id,0);
271: l_inventory_item_id := nvl(p_probcode_criteria_rec.inventory_item_id,0);
272: l_organization_id := nvl(p_probcode_criteria_rec.organization_id,0);
273: l_problem_code := p_problem_code;
274: l_category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');
275:
276: IF (l_service_request_type_id = FND_API.G_MISS_NUM) THEN
277: l_service_request_type_id := 0;
278: END IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: IF (l_inventory_item_id <> 0 and l_organization_id = 0) THEN
293: l_organization_id := FND_PROFILE.value('CS_INV_VALIDATION_ORG');
294: END IF;
295:
296: /* Validation Checks on the problem code:
297: #1) Check if the problem code exists in the unmapped problem code list or
621: CLOSE c_sr_criteria_exists_csr;
622:
623: /* Validation check #5 */
624: IF(l_product_category_id <> 0 AND
625: FND_PROFILE.Value('CS_SR_DEFAULT_CATEGORY_SET') is not null) THEN
626: /* If the input category does not belong to the default category set, throw an exception */
627: l_product_category_set := FND_PROFILE.Value('CS_SR_DEFAULT_CATEGORY_SET');
628: OPEN c_sr_prod_cat_valid_csr;
629: FETCH c_sr_prod_cat_valid_csr into l_temp;
623: /* Validation check #5 */
624: IF(l_product_category_id <> 0 AND
625: FND_PROFILE.Value('CS_SR_DEFAULT_CATEGORY_SET') is not null) THEN
626: /* If the input category does not belong to the default category set, throw an exception */
627: l_product_category_set := FND_PROFILE.Value('CS_SR_DEFAULT_CATEGORY_SET');
628: OPEN c_sr_prod_cat_valid_csr;
629: FETCH c_sr_prod_cat_valid_csr into l_temp;
630: IF (c_sr_prod_cat_valid_csr%NOTFOUND) THEN
631: RAISE fnd_api.g_exc_unexpected_error;