58: fetch c_name into l_check;
59: if c_name%found
60: then
61: close c_name;
62: fnd_message.set_name('CSR','PARS_PROM_NAME_NOT_UNIQUE');
63: fnd_message.set_token('NAME',p_name);
64: app_exception.raise_exception;
65: end if;
66: close c_name;
59: if c_name%found
60: then
61: close c_name;
62: fnd_message.set_name('CSR','PARS_PROM_NAME_NOT_UNIQUE');
63: fnd_message.set_token('NAME',p_name);
64: app_exception.raise_exception;
65: end if;
66: close c_name;
67:
69: fetch c_time into l_check;
70: if c_time%found
71: then
72: close c_time;
73: fnd_message.set_name('CSR','PARS_PROM_TIME_NOT_UNIQUE');
74: fnd_message.set_token('START',to_char(p_start_time,'hh24:mi'));
75: fnd_message.set_token('END' ,to_char(p_end_time,'hh24:mi'));
76: app_exception.raise_exception;
77: end if;
70: if c_time%found
71: then
72: close c_time;
73: fnd_message.set_name('CSR','PARS_PROM_TIME_NOT_UNIQUE');
74: fnd_message.set_token('START',to_char(p_start_time,'hh24:mi'));
75: fnd_message.set_token('END' ,to_char(p_end_time,'hh24:mi'));
76: app_exception.raise_exception;
77: end if;
78: close c_time;
71: then
72: close c_time;
73: fnd_message.set_name('CSR','PARS_PROM_TIME_NOT_UNIQUE');
74: fnd_message.set_token('START',to_char(p_start_time,'hh24:mi'));
75: fnd_message.set_token('END' ,to_char(p_end_time,'hh24:mi'));
76: app_exception.raise_exception;
77: end if;
78: close c_time;
79: end check_unique;
282:
283: if c_prom%notfound
284: then
285: close c_prom;
286: fnd_message.set_name('FND','FORM_RECORD_DELETED');
287: app_exception.raise_exception;
288: end if;
289: close c_prom;
290:
309: or not csr_utilities.compare_values(rtrim(p_attribute15),l_rec.attribute15)
310: or not csr_utilities.compare_values(rtrim(p_attribute_category),
311: l_rec.attribute_category)
312: then
313: fnd_message.set_name('FND','FORM_RECORD_CHANGED');
314: app_exception.raise_exception;
315: end if;
316: end lock_row;
317: