DBA Data[Home] [Help]

APPS.IGS_DA_RQST_PKG dependencies on FND_MESSAGE

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

70: OPEN cur_old_ref_values;
71: FETCH cur_old_ref_values INTO old_references;
72: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
73: CLOSE cur_old_ref_values;
74: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
75: igs_ge_msg_stack.add;
76: app_exception.raise_exception;
77: RETURN;
78: END IF;

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

144: NULL;
145: ELSIF NOT igs_da_cnfg_req_typ_pkg.get_pk_for_validation (
146: new_references.request_type_id
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:

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

155: NULL;
156: ELSIF NOT igs_pe_persid_group_pkg.get_pk_for_validation (
157: new_references.person_id_group_id
158: ) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: END IF;
163:

Line 250: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_RQST_FK');

246: OPEN cur_rowid;
247: FETCH cur_rowid INTO lv_rowid;
248: IF (cur_rowid%FOUND) THEN
249: CLOSE cur_rowid;
250: fnd_message.set_name ('IGS', 'IGS_DA_CNFG_RQST_FK');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: RETURN;
254: END IF;

Line 285: fnd_message.set_name ('IGS', 'IGS_DA_PERSON_RQST_FK');

281: OPEN cur_rowid;
282: FETCH cur_rowid INTO lv_rowid;
283: IF (cur_rowid%FOUND) THEN
284: CLOSE cur_rowid;
285: fnd_message.set_name ('IGS', 'IGS_DA_PERSON_RQST_FK');
286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: RETURN;
289: END IF;

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

390: IF ( get_pk_for_validation(
391: new_references.batch_id
392: )
393: ) THEN
394: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398: check_parent_existance;

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

407: IF ( get_pk_for_validation (
408: new_references.batch_id
409: )
410: ) THEN
411: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
412: igs_ge_msg_stack.add;
413: app_exception.raise_exception;
414: END IF;
415: ELSIF (p_action = 'VALIDATE_DELETE') THEN

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

486: IF (x_last_update_login IS NULL) THEN
487: x_last_update_login := -1;
488: END IF;
489: ELSE
490: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;

Line 491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');

487: x_last_update_login := -1;
488: END IF;
489: ELSE
490: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
491: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.INSERT_ROW');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495: -- x_batch_id := NULL;

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

638: p_data => X_MSG_DATA);
639: RETURN;
640: WHEN OTHERS THEN
641: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
643: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get(
646: p_encoded => FND_API.G_FALSE,

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

639: RETURN;
640: WHEN OTHERS THEN
641: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
643: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
644: FND_MSG_PUB.ADD;
645: FND_MSG_PUB.Count_And_Get(
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_MSG_COUNT,

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

742: FND_MSG_PUB.initialize;
743: OPEN c1;
744: FETCH c1 INTO tlinfo;
745: IF (c1%notfound) THEN
746: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
747: igs_ge_msg_stack.add;
748: CLOSE c1;
749: app_exception.raise_exception;
750: RETURN;

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

785: AND ((tlinfo.attribute20 = x_attribute20) OR ((tlinfo.attribute20 IS NULL) AND (X_attribute20 IS NULL)))
786: ) THEN
787: NULL;
788: ELSE
789: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
790: igs_ge_msg_stack.add;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:

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

816: p_data => X_MSG_DATA);
817: RETURN;
818: WHEN OTHERS THEN
819: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
821: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.Count_And_Get(
824: p_encoded => FND_API.G_FALSE,

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

817: RETURN;
818: WHEN OTHERS THEN
819: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
821: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
822: FND_MSG_PUB.ADD;
823: FND_MSG_PUB.Count_And_Get(
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_MSG_COUNT,

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

896: IF (x_last_update_login IS NULL) THEN
897: x_last_update_login := -1;
898: END IF;
899: ELSE
900: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');
902: igs_ge_msg_stack.add;
903: app_exception.raise_exception;
904: END IF;

Line 901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');

897: x_last_update_login := -1;
898: END IF;
899: ELSE
900: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
901: fnd_message.set_token ('ROUTINE', 'IGS_DA_RQST_PKG.UPDATE_ROW');
902: igs_ge_msg_stack.add;
903: app_exception.raise_exception;
904: END IF;
905:

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

1014: p_data => X_MSG_DATA);
1015: RETURN;
1016: WHEN OTHERS THEN
1017: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1019: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_And_Get(
1022: p_encoded => FND_API.G_FALSE,

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

1015: RETURN;
1016: WHEN OTHERS THEN
1017: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1019: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
1020: FND_MSG_PUB.ADD;
1021: FND_MSG_PUB.Count_And_Get(
1022: p_encoded => FND_API.G_FALSE,
1023: p_count => x_MSG_COUNT,

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

1226: p_data => X_MSG_DATA);
1227: RETURN;
1228: WHEN OTHERS THEN
1229: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1230: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1231: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1232: FND_MSG_PUB.ADD;
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,

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

1227: RETURN;
1228: WHEN OTHERS THEN
1229: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1230: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1231: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
1232: FND_MSG_PUB.ADD;
1233: FND_MSG_PUB.Count_And_Get(
1234: p_encoded => FND_API.G_FALSE,
1235: p_count => x_MSG_COUNT,