627:
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: IF (X_CHANGE_TYPE_LOOKUP_CODE = 'AMEND') THEN
631: fnd_message.set_name('PN', 'PN_DUP_LEASE_CHANGE_NUMBER');
632: fnd_message.set_token('LEASE_CHANGE_NUMBER', x_lease_change_number);
633: fnd_message.set_token('LEASE_NAME', l_leaseName);
634: ELSE
635: fnd_message.set_name ('PN', 'PN_DUP_EDIT_NUMBER');
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
630: IF (X_CHANGE_TYPE_LOOKUP_CODE = 'AMEND') THEN
631: fnd_message.set_name('PN', 'PN_DUP_LEASE_CHANGE_NUMBER');
632: fnd_message.set_token('LEASE_CHANGE_NUMBER', x_lease_change_number);
633: fnd_message.set_token('LEASE_NAME', l_leaseName);
634: ELSE
635: fnd_message.set_name ('PN', 'PN_DUP_EDIT_NUMBER');
636: fnd_message.set_token('EDIT_NUMBER', x_lease_change_number);
629: WHEN NO_DATA_FOUND THEN
630: IF (X_CHANGE_TYPE_LOOKUP_CODE = 'AMEND') THEN
631: fnd_message.set_name('PN', 'PN_DUP_LEASE_CHANGE_NUMBER');
632: fnd_message.set_token('LEASE_CHANGE_NUMBER', x_lease_change_number);
633: fnd_message.set_token('LEASE_NAME', l_leaseName);
634: ELSE
635: fnd_message.set_name ('PN', 'PN_DUP_EDIT_NUMBER');
636: fnd_message.set_token('EDIT_NUMBER', x_lease_change_number);
637: fnd_message.set_token('LEASE_NAME', l_leaseName);
631: fnd_message.set_name('PN', 'PN_DUP_LEASE_CHANGE_NUMBER');
632: fnd_message.set_token('LEASE_CHANGE_NUMBER', x_lease_change_number);
633: fnd_message.set_token('LEASE_NAME', l_leaseName);
634: ELSE
635: fnd_message.set_name ('PN', 'PN_DUP_EDIT_NUMBER');
636: fnd_message.set_token('EDIT_NUMBER', x_lease_change_number);
637: fnd_message.set_token('LEASE_NAME', l_leaseName);
638: END IF;
639: x_return_status := 'E';
632: fnd_message.set_token('LEASE_CHANGE_NUMBER', x_lease_change_number);
633: fnd_message.set_token('LEASE_NAME', l_leaseName);
634: ELSE
635: fnd_message.set_name ('PN', 'PN_DUP_EDIT_NUMBER');
636: fnd_message.set_token('EDIT_NUMBER', x_lease_change_number);
637: fnd_message.set_token('LEASE_NAME', l_leaseName);
638: END IF;
639: x_return_status := 'E';
640: END;
633: fnd_message.set_token('LEASE_NAME', l_leaseName);
634: ELSE
635: fnd_message.set_name ('PN', 'PN_DUP_EDIT_NUMBER');
636: fnd_message.set_token('EDIT_NUMBER', x_lease_change_number);
637: fnd_message.set_token('LEASE_NAME', l_leaseName);
638: END IF;
639: x_return_status := 'E';
640: END;
641: ELSE