DBA Data[Home] [Help]

APPS.IGS_AS_SUA_SES_ATTS_PKG dependencies on FND_MESSAGE

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

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

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

87: IF NOT igs_as_usec_sessns_pkg.get_pk_for_validation (
88: x_session_name => new_references.session_name,
89: x_uoo_id => new_references.uoo_id
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:

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

96: IF NOT igs_en_su_Attempt_pkg.get_pk_for_validation(x_person_id => new_references.person_id ,
97: x_course_cd => new_references.course_cd,
98: x_uoo_id => new_references.uoo_id)
99: THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:

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

195: new_references.uoo_id,
196: new_references.session_name
197: )
198: ) THEN
199: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
200: igs_ge_msg_stack.add;
201: app_exception.raise_exception;
202: END IF;
203: check_parent_existance;

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

209: new_references.uoo_id,
210: new_references.session_name
211: )
212: ) THEN
213: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
214: igs_ge_msg_stack.add;
215: app_exception.raise_exception;
216: END IF;
217: ELSIF (p_action = 'UPDATE') THEN

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

263: IF (x_last_update_login IS NULL) THEN
264: x_last_update_login := -1;
265: END IF;
266: ELSE
267: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
268: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.INSERT_ROW');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;

Line 268: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.INSERT_ROW');

264: x_last_update_login := -1;
265: END IF;
266: ELSE
267: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
268: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.INSERT_ROW');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272:

Line 348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');

344: RETURN;
345: WHEN OTHERS THEN
346: igs_sc_gen_001.unset_ctx('R');
347: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
349: fnd_message.set_token ('ERR_CD', SQLCODE);
350: FND_MSG_PUB.ADD;
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,

Line 349: fnd_message.set_token ('ERR_CD', SQLCODE);

345: WHEN OTHERS THEN
346: igs_sc_gen_001.unset_ctx('R');
347: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
348: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
349: fnd_message.set_token ('ERR_CD', SQLCODE);
350: FND_MSG_PUB.ADD;
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_MSG_COUNT,

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

353: p_count => x_MSG_COUNT,
354: p_data => X_MSG_DATA);
355: ELSE
356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
358: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
359: FND_MSG_PUB.ADD;
360: FND_MSG_PUB.Count_And_Get(
361: p_encoded => FND_API.G_FALSE,

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

354: p_data => X_MSG_DATA);
355: ELSE
356: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
358: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
359: FND_MSG_PUB.ADD;
360: FND_MSG_PUB.Count_And_Get(
361: p_encoded => FND_API.G_FALSE,
362: 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 417: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

413: (tlinfo.attendance_flag = x_attendance_flag)
414: ) THEN
415: NULL;
416: ELSE
417: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
418: igs_ge_msg_stack.add;
419: app_exception.raise_exception;
420: END IF;
421:

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

444: p_data => X_MSG_DATA);
445: RETURN;
446: WHEN OTHERS THEN
447: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);
450: FND_MSG_PUB.ADD;
451: FND_MSG_PUB.Count_And_Get(
452: p_encoded => FND_API.G_FALSE,

Line 449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);

445: RETURN;
446: WHEN OTHERS THEN
447: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
449: FND_MESSAGE.SET_TOKEN('NAME','lock_row : '||SQLERRM);
450: FND_MSG_PUB.ADD;
451: FND_MSG_PUB.Count_And_Get(
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_MSG_COUNT,

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

499: IF (x_last_update_login IS NULL) THEN
500: x_last_update_login := -1;
501: END IF;
502: ELSE
503: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
504: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.UPDATE_ROW');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;

Line 504: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.UPDATE_ROW');

500: x_last_update_login := -1;
501: END IF;
502: ELSE
503: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
504: fnd_message.set_token ('ROUTINE', 'IGS_AS_SUA_SES_ATTS_PKG.UPDATE_ROW');
505: igs_ge_msg_stack.add;
506: app_exception.raise_exception;
507: END IF;
508:

Line 536: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

532: last_update_login = x_last_update_login
533: WHERE rowid = x_rowid;
534:
535: IF (SQL%NOTFOUND) THEN
536: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
537: igs_ge_msg_stack.add;
538: igs_sc_gen_001.unset_ctx('R');
539: app_exception.raise_exception;
540: END IF;

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

569: RETURN;
570: WHEN OTHERS THEN
571: igs_sc_gen_001.unset_ctx('R');
572: IF (SQLCODE = (-28115)) THEN
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
574: fnd_message.set_token ('ERR_CD', SQLCODE);
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 ('ERR_CD', SQLCODE);

570: WHEN OTHERS THEN
571: igs_sc_gen_001.unset_ctx('R');
572: IF (SQLCODE = (-28115)) THEN
573: FND_MESSAGE.SET_NAME('IGS', 'IGS_SC_POLICY_EXCEPTION');
574: fnd_message.set_token ('ERR_CD', SQLCODE);
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 582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

578: p_count => x_MSG_COUNT,
579: p_data => X_MSG_DATA);
580: ELSE
581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
584: FND_MSG_PUB.ADD;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,

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

579: p_data => X_MSG_DATA);
580: ELSE
581: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
582: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
584: FND_MSG_PUB.ADD;
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,

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

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

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

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

Line 731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

727: DELETE FROM igs_as_sua_ses_atts
728: WHERE rowid = x_rowid;
729:
730: IF (SQL%NOTFOUND) THEN
731: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
732: igs_ge_msg_stack.add;
733: igs_sc_gen_001.unset_ctx('R');
734: app_exception.raise_exception;
735: END IF;

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

763: p_data => X_MSG_DATA);
764: RETURN;
765: WHEN OTHERS THEN
766: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
768: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
769: FND_MSG_PUB.ADD;
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,

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

764: RETURN;
765: WHEN OTHERS THEN
766: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
768: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
769: FND_MSG_PUB.ADD;
770: FND_MSG_PUB.Count_And_Get(
771: p_encoded => FND_API.G_FALSE,
772: p_count => x_MSG_COUNT,

Line 804: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SES_ATTS_USEC_SESS_FK');

800:
801: OPEN cur_rowid;
802: FETCH cur_rowid INTO lv_rowid;
803: IF (cur_rowid%FOUND) THEN
804: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SES_ATTS_USEC_SESS_FK');
805: IGS_GE_MSG_STACK.ADD;
806: CLOSE cur_rowid;
807: APP_EXCEPTION.RAISE_EXCEPTION;
808: RETURN;

Line 843: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SES_ATTS_SUA_FK');

839:
840: OPEN cur_rowid;
841: FETCH cur_rowid INTO lv_rowid;
842: IF (cur_rowid%FOUND) THEN
843: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SES_ATTS_SUA_FK');
844: IGS_GE_MSG_STACK.ADD;
845: CLOSE cur_rowid;
846: APP_EXCEPTION.RAISE_EXCEPTION;
847: RETURN;