DBA Data[Home] [Help]

APPS.IGS_PE_NONIMG_STAT_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 231: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

227: IF ( get_uk_for_validation ( new_references.nonimg_form_id,
228: new_references.action_type,
229: new_references.action_date
230: ) ) THEN
231: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235:

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

251: IF (((old_references.nonimg_form_id = new_references.nonimg_form_id)) OR
252: ((new_references.nonimg_form_id IS NULL))) THEN
253: NULL;
254: ELSIF NOT igs_pe_nonimg_form_pkg.get_pk_for_validation ( new_references.nonimg_form_id ) THEN
255: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: END IF;
259:

Line 357: fnd_message.set_name ('IGS', 'IGS_PE_PENST_PENIF_FK');

353: OPEN cur_rowid;
354: FETCH cur_rowid INTO lv_rowid;
355: IF (cur_rowid%FOUND) THEN
356: CLOSE cur_rowid;
357: fnd_message.set_name ('IGS', 'IGS_PE_PENST_PENIF_FK');
358: igs_ge_msg_stack.add;
359: app_exception.raise_exception;
360: RETURN;
361: END IF;

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

417:
418: IF (p_action = 'INSERT') THEN
419: -- Call all the procedures related to Before Insert.
420: IF ( get_pk_for_validation( new_references.nonimg_stat_id ) ) THEN
421: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
422: igs_ge_msg_stack.add;
423: app_exception.raise_exception;
424: END IF;
425: check_uniqueness;

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

430: check_parent_existance;
431: ELSIF (p_action = 'VALIDATE_INSERT') THEN
432: -- Call all the procedures related to Before Insert.
433: IF ( get_pk_for_validation ( new_references.nonimg_stat_id ) ) THEN
434: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: check_uniqueness;

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: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494:

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

560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
564: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
565: fnd_message.set_token ('ERR_CD', SQLCODE);
566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;

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

561: EXCEPTION
562: WHEN OTHERS THEN
563: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
564: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
565: fnd_message.set_token ('ERR_CD', SQLCODE);
566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE

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

615:
616: OPEN c1;
617: FETCH c1 INTO tlinfo;
618: IF (c1%notfound) THEN
619: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
620: igs_ge_msg_stack.add;
621: CLOSE c1;
622: app_exception.raise_exception;
623: RETURN;

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

636: AND ((tlinfo.cancel_flag = x_cancel_flag) OR ((tlinfo.cancel_flag IS NULL) AND (X_cancel_flag IS NULL)))
637: ) THEN
638: NULL;
639: ELSE
640: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644:

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

689: IF (x_last_update_login IS NULL) THEN
690: x_last_update_login := -1;
691: END IF;
692: ELSE
693: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
694: igs_ge_msg_stack.add;
695: app_exception.raise_exception;
696: END IF;
697:

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

734: cancel_flag = x_cancel_flag
735: WHERE rowid = x_rowid;
736:
737: IF (SQL%NOTFOUND) THEN
738: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
739: igs_ge_msg_stack.add;
740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: END IF;

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

748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: IF (SQLCODE = (-28115)) THEN
752: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
753: fnd_message.set_token ('ERR_CD', SQLCODE);
754: igs_ge_msg_stack.add;
755: igs_sc_gen_001.unset_ctx('R');
756: app_exception.raise_exception;

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

749: EXCEPTION
750: WHEN OTHERS THEN
751: IF (SQLCODE = (-28115)) THEN
752: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
753: fnd_message.set_token ('ERR_CD', SQLCODE);
754: igs_ge_msg_stack.add;
755: igs_sc_gen_001.unset_ctx('R');
756: app_exception.raise_exception;
757: ELSE

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

856: DELETE FROM igs_pe_nonimg_stat
857: WHERE rowid = x_rowid;
858:
859: IF (SQL%NOTFOUND) THEN
860: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
861: igs_ge_msg_stack.add;
862: igs_sc_gen_001.unset_ctx('R');
863: app_exception.raise_exception;
864: END IF;