[Home] [Help]
42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
85: IF ( get_uk_for_validation (
86: new_references.uoo_id,
87: new_references.s_rule_call_cd)
88: ) THEN
89: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
111: NULL;
112: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
113: new_references.uoo_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
122: NULL;
123: ELSIF NOT igs_ru_call_pkg.get_pk_for_validation (
124: new_references.s_rule_call_cd
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
133: NULL;
134: ELSIF NOT igs_ru_rule_pkg.get_pk_for_validation (
135: new_references.rul_sequence_number
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
237: OPEN cur_rowid;
238: FETCH cur_rowid INTO lv_rowid;
239: IF (cur_rowid%FOUND) THEN
240: CLOSE cur_rowid;
241: fnd_message.set_name ('IGS', 'IGS_PS_PURU_UOO_FK');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: RETURN;
245: END IF;
272: OPEN cur_rowid;
273: FETCH cur_rowid INTO lv_rowid;
274: IF (cur_rowid%FOUND) THEN
275: CLOSE cur_rowid;
276: fnd_message.set_name ('IGS', 'IGS_PS_PURU_SRC_FK');
277: igs_ge_msg_stack.add;
278: app_exception.raise_exception;
279: RETURN;
280: END IF;
307: OPEN cur_rowid;
308: FETCH cur_rowid INTO lv_rowid;
309: IF (cur_rowid%FOUND) THEN
310: CLOSE cur_rowid;
311: fnd_message.set_name ('IGS', 'IGS_PS_PURU_RUL_FK');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: RETURN;
315: END IF;
362: IF ( get_pk_for_validation(
363: new_references.usecru_id
364: )
365: ) THEN
366: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370: check_uniqueness;
378: IF ( get_pk_for_validation (
379: new_references.usecru_id
380: )
381: ) THEN
382: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: check_uniqueness;
432: IF (x_last_update_login IS NULL) THEN
433: x_last_update_login := -1;
434: END IF;
435: ELSE
436: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
520:
521: OPEN c1;
522: FETCH c1 INTO tlinfo;
523: IF (c1%notfound) THEN
524: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
525: igs_ge_msg_stack.add;
526: CLOSE c1;
527: app_exception.raise_exception;
528: RETURN;
535: AND (tlinfo.rul_sequence_number = x_rul_sequence_number)
536: ) THEN
537: NULL;
538: ELSE
539: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543:
582: IF (x_last_update_login IS NULL) THEN
583: x_last_update_login := -1;
584: END IF;
585: ELSE
586: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
587: igs_ge_msg_stack.add;
588: app_exception.raise_exception;
589: END IF;
590: