DBA Data[Home] [Help]

APPS.IGS_PE_ATHLETIC_DTL_PKG dependencies on FND_MESSAGE

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

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

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

94: IF ( get_uk_for_validation (
95: new_references.person_id
96: )
97: ) THEN
98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:

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

123: ELSIF NOT IGS_LOOKUPS_view_Pkg.Get_PK_For_Validation(
124: 'PE_ATH_ELG_STATUS',
125: new_references.eligibility_status_cd
126: ) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130:
131: END IF;

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

135: NULL;
136: ELSIF NOT igs_pe_hz_parties_pkg.get_pk_for_validation (
137: new_references.person_id
138: ) THEN
139: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143:

Line 242: fnd_message.set_name ('IGS', 'IGS_PE_PAD_ADCC_FK');

238: OPEN cur_rowid;
239: FETCH cur_rowid INTO lv_rowid;
240: IF (cur_rowid%FOUND) THEN
241: CLOSE cur_rowid;
242: fnd_message.set_name ('IGS', 'IGS_PE_PAD_ADCC_FK');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: RETURN;
246: END IF;

Line 277: fnd_message.set_name ('IGS', 'IGS_PE_PAD_HZ_FK');

273: OPEN cur_rowid;
274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('IGS', 'IGS_PE_PAD_HZ_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;

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

336: IF ( get_pk_for_validation(
337: new_references.athletic_details_id
338: )
339: ) THEN
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344: check_uniqueness;

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

352: IF ( get_pk_for_validation (
353: new_references.athletic_details_id
354: )
355: ) THEN
356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: END IF;
360: check_uniqueness;

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

410: IF (x_last_update_login IS NULL) THEN
411: x_last_update_login := -1;
412: END IF;
413: ELSE
414: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418:

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

486:
487: EXCEPTION
488: WHEN OTHERS THEN
489: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
490: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
491: fnd_message.set_token ('ERR_CD', SQLCODE);
492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;

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

487: EXCEPTION
488: WHEN OTHERS THEN
489: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
490: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
491: fnd_message.set_token ('ERR_CD', SQLCODE);
492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;
495: ELSE

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

538:
539: OPEN c1;
540: FETCH c1 INTO tlinfo;
541: IF (c1%notfound) THEN
542: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
543: igs_ge_msg_stack.add;
544: CLOSE c1;
545: app_exception.raise_exception;
546: RETURN;

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

557: AND ((tlinfo.comments = x_comments) OR ((tlinfo.comments IS NULL) AND (X_comments IS NULL)))
558: ) THEN
559: NULL;
560: ELSE
561: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
562: igs_ge_msg_stack.add;
563: app_exception.raise_exception;
564: END IF;
565:

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

608: IF (x_last_update_login IS NULL) THEN
609: x_last_update_login := -1;
610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: igs_ge_msg_stack.add;
614: app_exception.raise_exception;
615: END IF;
616:

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

649: last_update_login = x_last_update_login
650: WHERE rowid = x_rowid;
651:
652: IF (SQL%NOTFOUND) THEN
653: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
654: igs_ge_msg_stack.add;
655: igs_sc_gen_001.unset_ctx('R');
656: app_exception.raise_exception;
657: END IF;

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

663:
664: EXCEPTION
665: WHEN OTHERS THEN
666: IF (SQLCODE = (-28115)) THEN
667: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
668: fnd_message.set_token ('ERR_CD', SQLCODE);
669: igs_ge_msg_stack.add;
670: igs_sc_gen_001.unset_ctx('R');
671: app_exception.raise_exception;

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

664: EXCEPTION
665: WHEN OTHERS THEN
666: IF (SQLCODE = (-28115)) THEN
667: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
668: fnd_message.set_token ('ERR_CD', SQLCODE);
669: igs_ge_msg_stack.add;
670: igs_sc_gen_001.unset_ctx('R');
671: app_exception.raise_exception;
672: ELSE

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

767: DELETE FROM igs_pe_athletic_dtl
768: WHERE rowid = x_rowid;
769:
770: IF (SQL%NOTFOUND) THEN
771: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
772: igs_ge_msg_stack.add;
773: igs_sc_gen_001.unset_ctx('R');
774: app_exception.raise_exception;
775: END IF;