DBA Data[Home] [Help]

APPS.IGS_HE_AD_DTL_ALL_PKG dependencies on FND_MESSAGE

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

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

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

110: new_references.admission_appl_number,
111: new_references.nominated_course_cd,
112: new_references.sequence_number
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117:
118: END IF;

Line 189: fnd_message.set_name ('IGS', 'IGS_HE_HAD_APAI_FK');

185: OPEN cur_rowid;
186: FETCH cur_rowid INTO lv_rowid;
187: IF (cur_rowid%FOUND) THEN
188: CLOSE cur_rowid;
189: fnd_message.set_name ('IGS', 'IGS_HE_HAD_APAI_FK');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: RETURN;
193: END IF;

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

252: IF ( get_pk_for_validation(
253: new_references.hesa_ad_dtl_id
254: )
255: ) THEN
256: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260: check_parent_existance;

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

266: IF ( get_pk_for_validation (
267: new_references.hesa_ad_dtl_id
268: )
269: ) THEN
270: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: END IF;
274: END IF;

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

323: IF (x_last_update_login IS NULL) THEN
324: x_last_update_login := -1;
325: END IF;
326: ELSE
327: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331:

Line 409: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

405:
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
409: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
410: fnd_message.set_token ('ERR_CD', SQLCODE);
411: igs_ge_msg_stack.add;
412: igs_sc_gen_001.unset_ctx('R');
413: app_exception.raise_exception;

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

406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
409: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
410: fnd_message.set_token ('ERR_CD', SQLCODE);
411: igs_ge_msg_stack.add;
412: igs_sc_gen_001.unset_ctx('R');
413: app_exception.raise_exception;
414: ELSE

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

463:
464: OPEN c1;
465: FETCH c1 INTO tlinfo;
466: IF (c1%notfound) THEN
467: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
468: igs_ge_msg_stack.add;
469: CLOSE c1;
470: app_exception.raise_exception;
471: RETURN;

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

483: AND ((tlinfo.special_student_cd = x_special_student_cd) OR ((tlinfo.special_student_cd IS NULL) AND (X_special_student_cd IS NULL)))
484: ) THEN
485: NULL;
486: ELSE
487: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:

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

536: IF (x_last_update_login IS NULL) THEN
537: x_last_update_login := -1;
538: END IF;
539: ELSE
540: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:

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

580: last_update_login = x_last_update_login
581: WHERE rowid = x_rowid;
582:
583: IF (SQL%NOTFOUND) THEN
584: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
585: igs_ge_msg_stack.add;
586: igs_sc_gen_001.unset_ctx('R');
587: app_exception.raise_exception;
588: END IF;

Line 596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (SQLCODE = (-28115)) THEN
596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;

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

593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (SQLCODE = (-28115)) THEN
596: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
597: fnd_message.set_token ('ERR_CD', SQLCODE);
598: igs_ge_msg_stack.add;
599: igs_sc_gen_001.unset_ctx('R');
600: app_exception.raise_exception;
601: ELSE

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

703: DELETE FROM igs_he_ad_dtl_all
704: WHERE rowid = x_rowid;
705:
706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
708: igs_ge_msg_stack.add;
709: igs_sc_gen_001.unset_ctx('R');
710: app_exception.raise_exception;
711: END IF;