753: null,
754: null);
755: END IF;
756: IF ((lower_limit = -99999) OR (upper_limit = -99999)) THEN
757: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
758: fnd_message.set_token('ENTITY1', l_spec_char_uom);
759: fnd_message.set_token('ENTITY2', l_plan_char_uom);
760: fnd_msg_pub.add();
761: END IF;
754: null);
755: END IF;
756: IF ((lower_limit = -99999) OR (upper_limit = -99999)) THEN
757: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
758: fnd_message.set_token('ENTITY1', l_spec_char_uom);
759: fnd_message.set_token('ENTITY2', l_plan_char_uom);
760: fnd_msg_pub.add();
761: END IF;
762: END IF;
755: END IF;
756: IF ((lower_limit = -99999) OR (upper_limit = -99999)) THEN
757: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
758: fnd_message.set_token('ENTITY1', l_spec_char_uom);
759: fnd_message.set_token('ENTITY2', l_plan_char_uom);
760: fnd_msg_pub.add();
761: END IF;
762: END IF;
763: ELSE
807: null,
808: null);
809: END IF;
810: IF ((lower_limit = -99999) OR (upper_limit = -99999)) THEN
811: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
812: fnd_message.set_token('ENTITY1', l_spec_char_uom);
813: fnd_message.set_token('ENTITY2', l_plan_char_uom);
814: fnd_msg_pub.add();
815: END IF;
808: null);
809: END IF;
810: IF ((lower_limit = -99999) OR (upper_limit = -99999)) THEN
811: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
812: fnd_message.set_token('ENTITY1', l_spec_char_uom);
813: fnd_message.set_token('ENTITY2', l_plan_char_uom);
814: fnd_msg_pub.add();
815: END IF;
816: END IF;
809: END IF;
810: IF ((lower_limit = -99999) OR (upper_limit = -99999)) THEN
811: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
812: fnd_message.set_token('ENTITY1', l_spec_char_uom);
813: fnd_message.set_token('ENTITY2', l_plan_char_uom);
814: fnd_msg_pub.add();
815: END IF;
816: END IF;
817: ELSE
939: null,
940: null);
941: END IF;
942: IF ((x_low_value = -99999) OR (x_high_value = -99999)) THEN
943: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
944: fnd_message.set_token('ENTITY1', l_spec_char_uom);
945: fnd_message.set_token('ENTITY2', l_plan_char_uom);
946: fnd_msg_pub.add();
947: END IF;
940: null);
941: END IF;
942: IF ((x_low_value = -99999) OR (x_high_value = -99999)) THEN
943: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
944: fnd_message.set_token('ENTITY1', l_spec_char_uom);
945: fnd_message.set_token('ENTITY2', l_plan_char_uom);
946: fnd_msg_pub.add();
947: END IF;
948: END IF;
941: END IF;
942: IF ((x_low_value = -99999) OR (x_high_value = -99999)) THEN
943: fnd_message.set_name('QA', 'QA_INCONVERTIBLE_UOM');
944: fnd_message.set_token('ENTITY1', l_spec_char_uom);
945: fnd_message.set_token('ENTITY2', l_plan_char_uom);
946: fnd_msg_pub.add();
947: END IF;
948: END IF;
949: END get_low_high_values;
3354:
3355: x_item_id := qa_flex_util.get_item_id(x_org_id, x_item_name);
3356:
3357: -- Undoing Bug 3364660. Not needed after sync up with Bug 3773298
3358: -- l_trans_string := fnd_message.get_string('QA','QA_MOBILE_SERIAL_LOV_TXT');
3359: --
3360: -- Bug 3773298
3361: -- Sync up the SQL to be the same with forms.
3362: -- bso Tue Jul 20 16:12:06 PDT 2004