41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
86: NULL;
87: ELSIF NOT igs_da_ftr_val_map_pkg.get_pk_for_validation (
88: new_references.feature_code
89: ) THEN
90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
156: OPEN cur_rowid;
157: FETCH cur_rowid INTO lv_rowid;
158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGS', 'IGS_DA_FTR_REQ_FTR_FK');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;
190: OPEN cur_rowid;
191: FETCH cur_rowid INTO lv_rowid;
192: IF (cur_rowid%FOUND) THEN
193: CLOSE cur_rowid;
194: fnd_message.set_name ('IGS', 'IGS_DA_RQST_FTR_FK');
195: igs_ge_msg_stack.add;
196: app_exception.raise_exception;
197: RETURN;
198: END IF;
244: new_references.batch_id,
245: new_references.feature_code
246: )
247: ) THEN
248: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
249: igs_ge_msg_stack.add;
250: RAISE FND_API.G_EXC_ERROR;
251: END IF;
252: check_parent_existance;
259: new_references.batch_id,
260: new_references.feature_code
261: )
262: ) THEN
263: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
264: igs_ge_msg_stack.add;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267: END IF;
307: IF (x_last_update_login IS NULL) THEN
308: x_last_update_login := -1;
309: END IF;
310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.INSERT_ROW');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
308: x_last_update_login := -1;
309: END IF;
310: ELSE
311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
312: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.INSERT_ROW');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
316:
372: p_data => X_MSG_DATA);
373: RETURN;
374: WHEN OTHERS THEN
375: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
378: FND_MSG_PUB.ADD;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
373: RETURN;
374: WHEN OTHERS THEN
375: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
378: FND_MSG_PUB.ADD;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_MSG_COUNT,
416: FND_MSG_PUB.initialize;
417: OPEN c1;
418: FETCH c1 INTO tlinfo;
419: IF (c1%notfound) THEN
420: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
421: igs_ge_msg_stack.add;
422: CLOSE c1;
423: app_exception.raise_exception;
424: RETURN;
429: ((tlinfo.feature_value = x_feature_value) OR ((tlinfo.feature_value IS NULL) AND (X_feature_value IS NULL)))
430: ) THEN
431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: igs_ge_msg_stack.add;
435: RAISE FND_API.G_EXC_ERROR;
436: END IF;
437:
460: p_data => X_MSG_DATA);
461: RETURN;
462: WHEN OTHERS THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_And_Get(
468: p_encoded => FND_API.G_FALSE,
461: RETURN;
462: WHEN OTHERS THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_And_Get(
468: p_encoded => FND_API.G_FALSE,
469: p_count => x_MSG_COUNT,
510: IF (x_last_update_login IS NULL) THEN
511: x_last_update_login := -1;
512: END IF;
513: ELSE
514: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
515: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.UPDATE_ROW');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
511: x_last_update_login := -1;
512: END IF;
513: ELSE
514: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
515: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.UPDATE_ROW');
516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:
566: p_data => X_MSG_DATA);
567: RETURN;
568: WHEN OTHERS THEN
569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
572: FND_MSG_PUB.ADD;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
567: RETURN;
568: WHEN OTHERS THEN
569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
572: FND_MSG_PUB.ADD;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);
694: RETURN;
695: WHEN OTHERS THEN
696: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,
694: RETURN;
695: WHEN OTHERS THEN
696: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_MSG_COUNT,