DBA Data[Home] [Help]

APPS.IGS_DA_REQ_FTRS_PKG dependencies on FND_MESSAGE

Line 45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

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;

Line 90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

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:

Line 160: fnd_message.set_name ('IGS', 'IGS_DA_FTR_REQ_FTR_FK');

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;

Line 194: fnd_message.set_name ('IGS', 'IGS_DA_RQST_FTR_FK');

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;

Line 248: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

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;

Line 263: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

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;

Line 311: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

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;

Line 312: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.INSERT_ROW');

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:

Line 376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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,

Line 377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);

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,

Line 420: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

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;

Line 433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

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:

Line 464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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,

Line 465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);

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,

Line 514: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

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;

Line 515: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_FTRS_PKG.UPDATE_ROW');

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:

Line 570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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,

Line 571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);

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,

Line 697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

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,

Line 698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);

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,