DBA Data[Home] [Help]

APPS.IGS_DA_REQ_WIF_PKG dependencies on FND_MESSAGE

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

52: OPEN cur_old_ref_values;
53: FETCH cur_old_ref_values INTO old_references;
54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;

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

107: NULL;
108: ELSIF NOT igs_da_rqst_pkg.get_pk_for_validation (
109: new_references.batch_id
110: ) THEN
111: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
112: igs_ge_msg_stack.add;
113: app_exception.raise_exception;
114: END IF;
115: IF (((old_references.program_code = new_references.program_code)) OR

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

117: NULL;
118: ELSIF NOT igs_ps_course_pkg.get_pk_for_validation (
119: new_references.program_code
120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: IF (((old_references.catalog_cal_type = new_references.catalog_cal_type) AND

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

130: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
131: new_references.catalog_cal_type,
132: new_references.catalog_ci_seq_num
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:

Line 224: fnd_message.set_name ('IGS', 'IGS_DA_RQST_WIF_FK');

220: OPEN cur_rowid;
221: FETCH cur_rowid INTO lv_rowid;
222: IF (cur_rowid%FOUND) THEN
223: CLOSE cur_rowid;
224: fnd_message.set_name ('IGS', 'IGS_DA_RQST_WIF_FK');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: RETURN;
228: END IF;

Line 259: fnd_message.set_name ('IGS', 'IGS_DA_PS_WIF_FK');

255: OPEN cur_rowid;
256: FETCH cur_rowid INTO lv_rowid;
257: IF (cur_rowid%FOUND) THEN
258: CLOSE cur_rowid;
259: fnd_message.set_name ('IGS', 'IGS_DA_PS_WIF_FK');
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: RETURN;
263: END IF;

Line 296: fnd_message.set_name ('IGS', 'IGS_DA_CA_WIF_FK');

292: OPEN cur_rowid;
293: FETCH cur_rowid INTO lv_rowid;
294: IF (cur_rowid%FOUND) THEN
295: CLOSE cur_rowid;
296: fnd_message.set_name ('IGS', 'IGS_DA_CA_WIF_FK');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;

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

366: new_references.batch_id,
367: new_references.wif_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: check_parent_existance;

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

384: new_references.batch_id,
385: new_references.wif_id
386: )
387: ) THEN
388: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392: ELSIF (p_action = 'VALIDATE_DELETE') THEN

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

446: IF (x_last_update_login IS NULL) THEN
447: x_last_update_login := -1;
448: END IF;
449: ELSE
450: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;

Line 451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');

447: x_last_update_login := -1;
448: END IF;
449: ELSE
450: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;
455: before_dml(

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

541: p_data => X_MSG_DATA);
542: RETURN;
543: WHEN OTHERS THEN
544: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
546: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,

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

542: RETURN;
543: WHEN OTHERS THEN
544: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
546: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
547: FND_MSG_PUB.ADD;
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_MSG_COUNT,

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

607: FND_MSG_PUB.initialize;
608: OPEN c1;
609: FETCH c1 INTO tlinfo;
610: IF (c1%notfound) THEN
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
612: igs_ge_msg_stack.add;
613: CLOSE c1;
614: app_exception.raise_exception;
615: RETURN;

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

631: AND ((tlinfo.track_unit_set_cd3 = x_track_unit_set_cd3) OR ((tlinfo.track_unit_set_cd3 IS NULL) AND (X_track_unit_set_cd3 IS NULL)))
632: ) THEN
633: NULL;
634: ELSE
635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
636: igs_ge_msg_stack.add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:

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

662: p_data => X_MSG_DATA);
663: RETURN;
664: WHEN OTHERS THEN
665: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
667: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(
670: p_encoded => FND_API.G_FALSE,

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

663: RETURN;
664: WHEN OTHERS THEN
665: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
666: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
667: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(
670: p_encoded => FND_API.G_FALSE,
671: p_count => x_MSG_COUNT,

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

725: IF (x_last_update_login IS NULL) THEN
726: x_last_update_login := -1;
727: END IF;
728: ELSE
729: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');
731: igs_ge_msg_stack.add;
732: app_exception.raise_exception;
733: END IF;

Line 730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');

726: x_last_update_login := -1;
727: END IF;
728: ELSE
729: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');
731: igs_ge_msg_stack.add;
732: app_exception.raise_exception;
733: END IF;
734:

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

803: p_data => X_MSG_DATA);
804: RETURN;
805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
808: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,

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

804: RETURN;
805: WHEN OTHERS THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
807: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
808: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
809: FND_MSG_PUB.ADD;
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_MSG_COUNT,

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

961: p_data => X_MSG_DATA);
962: RETURN;
963: WHEN OTHERS THEN
964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
966: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(
969: p_encoded => FND_API.G_FALSE,

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

962: RETURN;
963: WHEN OTHERS THEN
964: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
966: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_MSG_COUNT,