DBA Data[Home] [Help]

APPS.IGS_AS_USEC_SESSNS_PKG dependencies on FND_MESSAGE

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

47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;

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

130: IF new_references.uoo_id IS NOT NULL THEN
131: IF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation (
132: x_uoo_id => new_references.uoo_id )
133: THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: FND_MSG_PUB.ADD;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138: END IF;

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

139: IF new_references.UNIT_SECTION_OCCURRENCE_ID IS NOT NULL THEN
140: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation(x_unit_section_occurrence_id =>
141: new_references.UNIT_SECTION_OCCURRENCE_ID)
142: THEN
143: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:

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

200: new_references.session_name,
201: new_references.uoo_id
202: )
203: ) THEN
204: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207: END IF;
208: check_parent_existance;

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

212: new_references.session_name,
213: new_references.uoo_id
214: )
215: ) THEN
216: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: END IF;
220:

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

269: IF (x_last_update_login IS NULL) THEN
270: x_last_update_login := -1;
271: END IF;
272: ELSE
273: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
274: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.INSERT_ROW');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;

Line 274: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.INSERT_ROW');

270: x_last_update_login := -1;
271: END IF;
272: ELSE
273: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
274: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.INSERT_ROW');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;
278:

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

346: p_data => X_MSG_DATA);
347: RETURN;
348: WHEN OTHERS THEN
349: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
351: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(
354: p_encoded => FND_API.G_FALSE,

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

347: RETURN;
348: WHEN OTHERS THEN
349: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
351: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(
354: p_encoded => FND_API.G_FALSE,
355: p_count => x_MSG_COUNT,

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

400:
401: OPEN c1;
402: FETCH c1 INTO tlinfo;
403: IF (c1%notfound) THEN
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: igs_ge_msg_stack.add;
406: CLOSE c1;
407: app_exception.raise_exception;
408: RETURN;

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

417: AND ((tlinfo.session_location_desc = x_session_location_desc) OR ((tlinfo.session_location_desc IS NULL) AND (X_session_location_desc IS NULL)))
418: ) THEN
419: NULL;
420: ELSE
421: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
422: igs_ge_msg_stack.add;
423: app_exception.raise_exception;
424: END IF;
425:

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

448: p_data => X_MSG_DATA);
449: RETURN;
450: WHEN OTHERS THEN
451: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
452: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
453: FND_MESSAGE.SET_TOKEN('NAME','Sessions_Lock_Row : '||SQLERRM);
454: FND_MSG_PUB.ADD;
455: FND_MSG_PUB.Count_And_Get(
456: p_encoded => FND_API.G_FALSE,

Line 453: FND_MESSAGE.SET_TOKEN('NAME','Sessions_Lock_Row : '||SQLERRM);

449: RETURN;
450: WHEN OTHERS THEN
451: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
452: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
453: FND_MESSAGE.SET_TOKEN('NAME','Sessions_Lock_Row : '||SQLERRM);
454: FND_MSG_PUB.ADD;
455: FND_MSG_PUB.Count_And_Get(
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_MSG_COUNT,

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

504: IF (x_last_update_login IS NULL) THEN
505: x_last_update_login := -1;
506: END IF;
507: ELSE
508: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
509: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.UPDATE_ROW');
510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;

Line 509: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.UPDATE_ROW');

505: x_last_update_login := -1;
506: END IF;
507: ELSE
508: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
509: fnd_message.set_token ('ROUTINE', 'IGS_AS_USEC_SESSNS_PKG.UPDATE_ROW');
510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;
513:

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

569: p_data => X_MSG_DATA);
570: RETURN;
571: WHEN OTHERS THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
574: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,

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

570: RETURN;
571: WHEN OTHERS THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
574: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
575: FND_MSG_PUB.ADD;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_MSG_COUNT,

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

681: p_data => X_MSG_DATA);
682: RETURN;
683: WHEN OTHERS THEN
684: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
685: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
686: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);
687: FND_MSG_PUB.ADD;
688: FND_MSG_PUB.Count_And_Get(
689: p_encoded => FND_API.G_FALSE,

Line 686: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);

682: RETURN;
683: WHEN OTHERS THEN
684: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
685: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
686: FND_MESSAGE.SET_TOKEN('NAME','Add_Row : '||SQLERRM);
687: FND_MSG_PUB.ADD;
688: FND_MSG_PUB.Count_And_Get(
689: p_encoded => FND_API.G_FALSE,
690: p_count => x_MSG_COUNT,

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

774: p_data => X_MSG_DATA);
775: RETURN;
776: WHEN OTHERS THEN
777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);
780: FND_MSG_PUB.ADD;
781: FND_MSG_PUB.Count_And_Get(
782: p_encoded => FND_API.G_FALSE,

Line 779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);

775: RETURN;
776: WHEN OTHERS THEN
777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
779: FND_MESSAGE.SET_TOKEN('NAME','delete_Row : '||SQLERRM);
780: FND_MSG_PUB.ADD;
781: FND_MSG_PUB.Count_And_Get(
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_MSG_COUNT,

Line 815: Fnd_Message.Set_Name ('IGS', 'IGS_AS_USEC_ATT_OCCURS_FK');

811:
812: OPEN cur_rowid;
813: FETCH cur_rowid INTO lv_rowid;
814: IF (cur_rowid%FOUND) THEN
815: Fnd_Message.Set_Name ('IGS', 'IGS_AS_USEC_ATT_OCCURS_FK');
816: IGS_GE_MSG_STACK.ADD;
817: CLOSE cur_rowid;
818: APP_EXCEPTION.RAISE_EXCEPTION;
819: RETURN;

Line 850: Fnd_Message.Set_Name ('IGS', 'IGS_AS_USEC_ATT_OFR_OPT_FK');

846:
847: OPEN cur_rowid;
848: FETCH cur_rowid INTO lv_rowid;
849: IF (cur_rowid%FOUND) THEN
850: Fnd_Message.Set_Name ('IGS', 'IGS_AS_USEC_ATT_OFR_OPT_FK');
851: IGS_GE_MSG_STACK.ADD;
852: CLOSE cur_rowid;
853: APP_EXCEPTION.RAISE_EXCEPTION;
854: RETURN;