138: where lookup_type = 'OAM_DASHBOARD_METRIC_STATUS'
139: and lookup_code = v_third_portion;
140: end if;
141:
142: fnd_message.clear;
143: fnd_message.set_name('FND','OAM_DASHBOARD_NAME_VALUE');
144: fnd_message.set_token('NAME',v_name);
145: fnd_message.set_token('VALUE',v_value);
146: v_name_value_pair := fnd_message.get;
139: and lookup_code = v_third_portion;
140: end if;
141:
142: fnd_message.clear;
143: fnd_message.set_name('FND','OAM_DASHBOARD_NAME_VALUE');
144: fnd_message.set_token('NAME',v_name);
145: fnd_message.set_token('VALUE',v_value);
146: v_name_value_pair := fnd_message.get;
147: end if;
140: end if;
141:
142: fnd_message.clear;
143: fnd_message.set_name('FND','OAM_DASHBOARD_NAME_VALUE');
144: fnd_message.set_token('NAME',v_name);
145: fnd_message.set_token('VALUE',v_value);
146: v_name_value_pair := fnd_message.get;
147: end if;
148:
141:
142: fnd_message.clear;
143: fnd_message.set_name('FND','OAM_DASHBOARD_NAME_VALUE');
144: fnd_message.set_token('NAME',v_name);
145: fnd_message.set_token('VALUE',v_value);
146: v_name_value_pair := fnd_message.get;
147: end if;
148:
149:
142: fnd_message.clear;
143: fnd_message.set_name('FND','OAM_DASHBOARD_NAME_VALUE');
144: fnd_message.set_token('NAME',v_name);
145: fnd_message.set_token('VALUE',v_value);
146: v_name_value_pair := fnd_message.get;
147: end if;
148:
149:
150: