[Home] [Help]
38: OPEN cur_old_ref_values;
39: FETCH cur_old_ref_values INTO old_references;
40: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
41: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
42: igs_ge_msg_stack.add;
43: app_exception.raise_exception;
44: CLOSE cur_old_ref_values;
45: RETURN;
46: END IF;
80: NULL;
81: ELSE
82: IF NOT igs_lookups_view_pkg.get_pk_for_validation('TRACKING_TYPE',new_references.s_tracking_type)THEN
83: fnd_message.set_name('FND','FORM_RECORD_DELETED');
84: igs_ge_msg_stack.add;
85: app_exception.raise_exception;
86: END IF;
87: END IF;
88:
130: FETCH cur_rowid INTO lv_rowid;
131: IF (cur_rowid%FOUND) THEN
132: CLOSE cur_rowid;
133: fnd_message.set_name ('IGS', 'IGS_TR_TRT_STT_FK');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: RETURN;
137: END IF;
138: CLOSE cur_rowid;
166: --kumma, 2702342, Increased the value of constant from 999 to 9999
167: IF UPPER(column_name) = 'TARGET_DAYS' OR column_name IS NULL THEN
168: IF (new_references.target_days < 0 OR new_references.target_days > 9999 )THEN
169: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173: END IF;
174:
174:
175: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN
176: IF new_references.business_days_ind NOT IN ('Y','N') THEN
177: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: END IF;
182:
182:
183: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN
184: IF new_references.closed_ind NOT IN ('Y','N') THEN
185: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
186: igs_ge_msg_stack.add;
187: app_exception.raise_exception;
188: END IF;
189: END IF;
190:
190:
191: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN
192: IF new_references.sequence_ind NOT IN ('Y','N') THEN
193: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: END IF;
197: END IF;
198:
198:
199: IF UPPER(column_name) = 'BUSINESS_DAYS_IND' OR column_name IS NULL THEN
200: IF new_references.business_days_ind <> UPPER(new_references.business_days_ind) THEN
201: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: END IF;
205: END IF;
206:
206:
207: IF UPPER(column_name) = 'CLOSED_IND' OR column_name IS NULL THEN
208: IF new_references.closed_ind <> UPPER(new_references.closed_ind) THEN
209: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213: END IF;
214:
214:
215: IF UPPER(column_name) = 'SEQUENCE_IND' OR column_name IS NULL THEN
216: IF new_references.sequence_ind <> UPPER(new_references.sequence_ind) THEN
217: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: END IF;
222:
222:
223: IF UPPER(column_name) = 'S_TRACKING_TYPE' OR column_name IS NULL THEN
224: IF new_references.s_tracking_type <> UPPER(new_references.s_tracking_type) THEN
225: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229: END IF;
230:
230:
231: IF UPPER(column_name) = 'TRACKING_TYPE' OR column_name IS NULL THEN
232: IF new_references.tracking_type <> UPPER(new_references.tracking_type) THEN
233: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: END IF;
237: END IF;
238:
238:
239: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
240: IF new_references.publish_ind NOT IN ('Y','N') THEN
241: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: END IF;
245: END IF;
246:
246:
247: IF UPPER(column_name) = 'PUBLISH_IND' OR column_name IS NULL THEN
248: IF new_references.publish_ind <> UPPER(new_references.publish_ind) THEN
249: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: END IF;
253: END IF;
254: END check_constraints;
299: NULL;
300:
301: IF get_pk_for_validation( new_references.tracking_type )THEN
302: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
303: igs_ge_msg_stack.add;
304: app_exception.raise_exception;
305: END IF;
306: check_constraints;
307: check_parent_existance;
315: ELSIF (p_action = 'VALIDATE_INSERT') THEN
316: -- Call all the procedures related to Before Delete.
317: IF get_pk_for_validation( new_references.tracking_type)THEN
318: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: END IF;
322: check_constraints;
323:
381: END IF;
382:
383: ELSE
384: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: before_dml(
477: OPEN c1;
478: FETCH c1 INTO tlinfo;
479: IF (c1%NOTFOUND) THEN
480: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: CLOSE c1;
484: RETURN;
485: END IF;
497: ) THEN
498: NULL;
499: ELSE
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504: RETURN;
505: END lock_row;
536: x_last_update_login := -1;
537: END IF;
538: ELSE
539: fnd_message.set_name('FND', 'SYSTEM-INVALID ARGS');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543:
544: before_dml(p_action =>'UPDATE',