150: Open cur_get_del_id(this_del_name);
151: Fetch cur_get_del_id Into this_del_id;
152:
153: if (cur_get_del_id%NOTFOUND ) Then
154: fnd_message.set_token('DELIVERY_NAME', this_del_name);
155: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
156: err_msg := fnd_message.get;
157: --dbms_output.put_line(err_msg);
158: Close cur_get_del_id;
151: Fetch cur_get_del_id Into this_del_id;
152:
153: if (cur_get_del_id%NOTFOUND ) Then
154: fnd_message.set_token('DELIVERY_NAME', this_del_name);
155: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
156: err_msg := fnd_message.get;
157: --dbms_output.put_line(err_msg);
158: Close cur_get_del_id;
159: --return;
152:
153: if (cur_get_del_id%NOTFOUND ) Then
154: fnd_message.set_token('DELIVERY_NAME', this_del_name);
155: fnd_message.set_name('OE', 'WSH_AR_INVALID_DEL_NAME');
156: err_msg := fnd_message.get;
157: --dbms_output.put_line(err_msg);
158: Close cur_get_del_id;
159: --return;
160: End if;