57: new_references.inquiry_type_cd --Added for APC Inegration Apadegal
58:
59: )
60: ) THEN
61: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: END IF;
65:
125: OPEN cur_old_ref_values;
126: FETCH cur_old_ref_values INTO old_references;
127: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
128: CLOSE cur_old_ref_values;
129: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
130: igs_ge_msg_stack.add;
131: app_exception.raise_exception;
132: RETURN;
133: END IF;
174: NULL;
175: ELSIF NOT igs_pe_src_types_pkg.get_pk_for_validation (
176: new_references.imp_source_type_id
177: ) THEN
178: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182:
185: NULL;
186: ELSIF NOT IGR_I_PKG_ITEM_PKG.get_pk_for_validation (
187: new_references.info_type_id
188: ) THEN
189: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193:
253: OPEN cur_rowid;
254: FETCH cur_rowid INTO lv_rowid;
255: IF (cur_rowid%FOUND) THEN
256: CLOSE cur_rowid;
257: fnd_message.set_name ('IGS', 'IGR_INQSRC_INQTYP_FK');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: RETURN;
261: END IF;
288: OPEN cur_rowid;
289: FETCH cur_rowid INTO lv_rowid;
290: IF (cur_rowid%FOUND) THEN
291: CLOSE cur_rowid;
292: fnd_message.set_name ('IGS', 'IGR_ITYP_INQTYP_FK');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: RETURN;
296: END IF;
349: IF ( get_pk_for_validation(
350: new_references.inquiry_type_id
351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: check_uniqueness;
366: IF ( get_pk_for_validation (
367: new_references.inquiry_type_id
368: )
369: ) THEN
370: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374: -- code begin -- To call all procedures realted to Before delete - Apadegal- 7-March-2005
421: IF (x_last_update_login IS NULL) THEN
422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
515:
516: OPEN c1;
517: FETCH c1 INTO tlinfo;
518: IF (c1%notfound) THEN
519: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
520: igs_ge_msg_stack.add;
521: CLOSE c1;
522: app_exception.raise_exception;
523: RETURN;
533: AND ((tlinfo.configurability_func_name = x_configurability_func_name) OR ((tlinfo.configurability_func_name IS NULL) AND (X_configurability_func_name IS NULL)))
534: ) THEN
535: NULL;
536: ELSE
537: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
538: igs_ge_msg_stack.add;
539: app_exception.raise_exception;
540: END IF;
541:
583: IF (x_last_update_login IS NULL) THEN
584: x_last_update_login := -1;
585: END IF;
586: ELSE
587: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
588: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.UPDATE_ROW');
589: igs_ge_msg_stack.add;
590: app_exception.raise_exception;
591: END IF;
584: x_last_update_login := -1;
585: END IF;
586: ELSE
587: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
588: fnd_message.set_token ('ROUTINE', 'IGR_I_INQUIRY_TYPES_PKG.UPDATE_ROW');
589: igs_ge_msg_stack.add;
590: app_exception.raise_exception;
591: END IF;
592: