[Home] [Help]
43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
90: new_references.reference_cd_type,
91: new_references.reference_code
92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
132: new_references.reference_cd_type,
133: new_references.reference_code
134: ) THEN
135: CLOSE cur_reference_cd_chk;
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140: END IF;
146: NULL;
147: ELSIF NOT igs_ge_ref_cd_type_pkg.get_pk_for_validation (
148: new_references.reference_cd_type
149: ) THEN
150: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
151: igs_ge_msg_stack.add;
152: app_exception.raise_exception;
153: END IF;
154:
157: NULL;
158: ELSIF NOT igs_ps_usec_ref_pkg.get_pk_for_validation (
159: new_references.unit_section_reference_id
160: ) THEN
161: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165:
266: OPEN cur_rowid;
267: FETCH cur_rowid INTO lv_rowid;
268: IF (cur_rowid%FOUND) THEN
269: CLOSE cur_rowid;
270: fnd_message.set_name ('IGS', 'IGS_PS_RC_USRRC_FK1');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: RETURN;
274: END IF;
301: OPEN cur_rowid;
302: FETCH cur_rowid INTO lv_rowid;
303: IF (cur_rowid%FOUND) THEN
304: CLOSE cur_rowid;
305: fnd_message.set_name ('IGS', 'IGS_PS_RCT_USRRC_FK2');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: RETURN;
309: END IF;
336: OPEN cur_rowid;
337: FETCH cur_rowid INTO lv_rowid;
338: IF (cur_rowid%FOUND) THEN
339: CLOSE cur_rowid;
340: fnd_message.set_name ('IGS', 'IGS_PS_USR_USRRC_FK3');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: RETURN;
344: END IF;
393: IF ( get_pk_for_validation(
394: new_references.unit_section_req_ref_cd_id
395: )
396: ) THEN
397: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
398: igs_ge_msg_stack.add;
399: app_exception.raise_exception;
400: END IF;
401: check_uniqueness;
409: IF ( get_pk_for_validation (
410: new_references.unit_section_req_ref_cd_id
411: )
412: ) THEN
413: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
414: igs_ge_msg_stack.add;
415: app_exception.raise_exception;
416: END IF;
417: check_uniqueness;
466: IF (x_last_update_login IS NULL) THEN
467: x_last_update_login := -1;
468: END IF;
469: ELSE
470: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: END IF;
474:
559:
560: OPEN c1;
561: FETCH c1 INTO tlinfo;
562: IF (c1%notfound) THEN
563: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
564: igs_ge_msg_stack.add;
565: CLOSE c1;
566: app_exception.raise_exception;
567: RETURN;
579: AND (x_reference_code_desc IS NULL)))
580: ) THEN
581: NULL;
582: ELSE
583: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:
627: IF (x_last_update_login IS NULL) THEN
628: x_last_update_login := -1;
629: END IF;
630: ELSE
631: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
632: igs_ge_msg_stack.add;
633: app_exception.raise_exception;
634: END IF;
635: