709: select name into v_dup_price_list from qp_list_headers_vl where
710: list_header_id = (select list_header_id from qp_list_lines
711: where list_line_id = v_dup_list_line_id);
712:
713: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
714: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
715: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
716: l_status_text:= FND_MESSAGE.GET;
717: -- end fix bug 2746019
710: list_header_id = (select list_header_id from qp_list_lines
711: where list_line_id = v_dup_list_line_id);
712:
713: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
714: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
715: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
716: l_status_text:= FND_MESSAGE.GET;
717: -- end fix bug 2746019
718:
711: where list_line_id = v_dup_list_line_id);
712:
713: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
714: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
715: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
716: l_status_text:= FND_MESSAGE.GET;
717: -- end fix bug 2746019
718:
719: Update_Invalid_List_Lines(i.INCOMPATABILITY_GRP_CODE,i.line_index,p_pricing_phase_id,
712:
713: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
714: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
715: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
716: l_status_text:= FND_MESSAGE.GET;
717: -- end fix bug 2746019
718:
719: Update_Invalid_List_Lines(i.INCOMPATABILITY_GRP_CODE,i.line_index,p_pricing_phase_id,
720: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,l_status_text, v_return_status,
943: select name into v_dup_price_list from qp_list_headers_vl where
944: list_header_id = (select list_header_id from qp_list_lines
945: where list_line_id = v_dup_list_line_id);
946:
947: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
948: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
949: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
950: l_status_text:= FND_MESSAGE.GET;
951: -- end fix bug 2746019
944: list_header_id = (select list_header_id from qp_list_lines
945: where list_line_id = v_dup_list_line_id);
946:
947: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
948: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
949: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
950: l_status_text:= FND_MESSAGE.GET;
951: -- end fix bug 2746019
952:
945: where list_line_id = v_dup_list_line_id);
946:
947: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
948: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
949: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
950: l_status_text:= FND_MESSAGE.GET;
951: -- end fix bug 2746019
952:
953: Update_Invalid_List_Lines(i.INCOMPATABILITY_GRP_CODE,i.line_index,p_pricing_phase_id,
946:
947: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_PRICE_LIST');
948: FND_MESSAGE.SET_TOKEN('LIST_LINE_ID', v_price_list);
949: FND_MESSAGE.SET_TOKEN('DUP_LIST_LINE_ID', v_dup_price_list);
950: l_status_text:= FND_MESSAGE.GET;
951: -- end fix bug 2746019
952:
953: Update_Invalid_List_Lines(i.INCOMPATABILITY_GRP_CODE,i.line_index,p_pricing_phase_id,
954: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,l_status_text, v_return_status,