[Home] [Help]
1109: IF (SQL%ROWCOUNT > 0) THEN
1110: x_result_type := po_validations.c_result_type_failure;
1111: END IF;
1112:
1113: -- if item id is not null, it has to exist in mtl_system_items table
1114: FORALL i IN 1 .. p_id_tbl.COUNT
1115: INSERT INTO po_validation_results_gt
1116: (result_set_id,
1117: result_type,
1140: AND p_line_type_id_tbl(i) = plt.line_type_id
1141: AND plt.outside_operation_flag IS NOT NULL
1142: AND NOT EXISTS(
1143: SELECT 1
1144: FROM mtl_system_items msi
1145: WHERE msi.inventory_item_id = p_item_id_tbl(i)
1146: AND msi.organization_id = p_inventory_org_id
1147: AND msi.enabled_flag = 'Y'
1148: AND msi.purchasing_item_flag = 'Y'
1200: po_log.proc_begin(d_mod, 'p_inventory_org_id', p_inventory_org_id);
1201: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1202: END IF;
1203:
1204: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1205: x_result_type := po_validations.c_result_type_success;
1206: FORALL i IN 1 .. p_id_tbl.COUNT
1207: INSERT INTO po_validation_results_gt
1208: (result_set_id,
1231: OR ( p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1232: AND p_item_id_tbl(i) IS NOT NULL
1233: AND EXISTS(
1234: SELECT 1 FROM
1235: mtl_system_items msi,mtl_system_items_tl mtl
1236: where msi.inventory_item_id = p_item_id_tbl(i) AND
1237: mtl.inventory_item_id = msi.inventory_item_id
1238: AND msi.organization_id = p_inventory_org_id
1239: AND mtl.organization_id = msi.organization_id
2866: WHERE p_item_id_tbl(i) IS NOT NULL
2867: AND p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
2868: AND EXISTS(
2869: SELECT 1
2870: FROM mtl_system_items msi
2871: WHERE msi.inventory_item_id = p_item_id_tbl(i)
2872: AND msi.organization_id = p_inventory_org_id
2873: AND msi.bom_item_type IN(1, 2));
2874:
3433: x_result_type := po_validations.c_result_type_failure;
3434: END IF;
3435: END LOOP;
3436:
3437: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
3438:
3439:
3440: FORALL i IN 1 .. p_id_tbl.COUNT
3441: INSERT INTO po_validation_results_gt
3461: PO_VAL_CONSTANTS.c_item_desc_update_unupdatable
3462: FROM DUAL
3463: WHERE EXISTS(
3464: SELECT 1
3465: FROM mtl_system_items msi,
3466: po_lines_all pol,
3467: mtl_system_items_tl mtl
3468: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3469: p_item_id_tbl(i) IS NOT NULL AND
3463: WHERE EXISTS(
3464: SELECT 1
3465: FROM mtl_system_items msi,
3466: po_lines_all pol,
3467: mtl_system_items_tl mtl
3468: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3469: p_item_id_tbl(i) IS NOT NULL AND
3470: pol.po_header_id = nvl(p_po_header_id_tbl(i),pol.po_header_id) AND
3471: pol.po_line_id = p_po_line_id_tbl(i) AND
3478: (p_item_description_tbl(i) <> mtl.description OR
3479: p_item_description_tbl(i) <> pol.item_description))
3480: OR EXISTS(
3481: SELECT 1
3482: FROM mtl_system_items msi,
3483: mtl_system_items_tl mtl
3484: WHERE p_po_line_id_tbl(i) IS NULL AND
3485: p_item_id_tbl(i) IS NOT NULL AND
3486: msi.inventory_item_id = p_item_id_tbl(i) AND
3479: p_item_description_tbl(i) <> pol.item_description))
3480: OR EXISTS(
3481: SELECT 1
3482: FROM mtl_system_items msi,
3483: mtl_system_items_tl mtl
3484: WHERE p_po_line_id_tbl(i) IS NULL AND
3485: p_item_id_tbl(i) IS NOT NULL AND
3486: msi.inventory_item_id = p_item_id_tbl(i) AND
3487: mtl.inventory_item_id = msi.inventory_item_id AND
4240: concat_segments => p_item,
4241: resp_appl_id => x_resp_appl_id,
4242: resp_id => x_resp_id,
4243: user_id => x_user_id,
4244: select_comb_from_view => 'MTL_SYSTEM_ITEMS_VL',
4245: where_clause_msg => 'APPL=PO;NAME=PO_RI_INVALID_ITEM_ID') ;
4246: END IF;
4247:
4248: IF (validateSegments) THEN
4282: x_resp_id NUMBER;
4283: x_resp_appl_id NUMBER;
4284: x_user_id NUMBER;
4285: x_org_id NUMBER;
4286: x_item mtl_system_items_vl.Concatenated_Segments%type;
4287:
4288: BEGIN
4289:
4290: IF PO_LOG.d_proc THEN
4344: GET_COLUMNS=>NULL,
4345: RESP_APPL_ID=>x_resp_appl_id,
4346: RESP_ID=>x_resp_id,
4347: USER_ID=>x_user_id,
4348: select_comb_from_view=>'MTL_SYSTEM_ITEMS_VL'
4349: );
4350:
4351: -- Valid item should pass through
4352: -- both validate_ccid and validate_segs
4353: IF (v_item) THEN
4354:
4355: Select msi.Concatenated_Segments
4356: into x_item
4357: From mtl_system_items_vl msi
4358: where msi.inventory_item_id = p_item_id_tbl(i)
4359: AND MSI.ORGANIZATION_ID=x_org_id;
4360:
4361: v_item := fnd_flex_keyval.validate_segs(operation => 'CHECK_SEGMENTS',
4365: concat_segments => x_item,
4366: resp_appl_id => x_resp_appl_id,
4367: resp_id => x_resp_id,
4368: user_id => x_user_id,
4369: select_comb_from_view => 'MTL_SYSTEM_ITEMS_VL',
4370: where_clause_msg => 'APPL=PO;NAME=PO_RI_INVALID_ITEM_ID') ;
4371: END IF;
4372: END IF;
4373: IF NOT (v_item) THEN