DBA Data[Home] [Help]

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

98: new_references.athletic_prg_code,
99: new_references.start_date
100: )
101: ) THEN
102: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
103: igs_ge_msg_stack.add;
104: app_exception.raise_exception;
105: END IF;
106:

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

127: ELSIF NOT IGS_LOOKUPS_view_Pkg.Get_PK_For_Validation (
128: 'PE_ATH_PRG_TYPE',
129: new_references.athletic_prg_code
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:

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

138: NULL;
139: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
140: new_references.person_id
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:

Line 249: fnd_message.set_name ('IGS', 'IGS_PE_PAP_ADCC_FK');

245: OPEN cur_rowid;
246: FETCH cur_rowid INTO lv_rowid;
247: IF (cur_rowid%FOUND) THEN
248: CLOSE cur_rowid;
249: fnd_message.set_name ('IGS', 'IGS_PE_PAP_ADCC_FK');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: RETURN;
253: END IF;

Line 284: fnd_message.set_name ('IGS', 'IGS_PE_PAP_HZ_FK');

280: OPEN cur_rowid;
281: FETCH cur_rowid INTO lv_rowid;
282: IF (cur_rowid%FOUND) THEN
283: CLOSE cur_rowid;
284: fnd_message.set_name ('IGS', 'IGS_PE_PAP_HZ_FK');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: RETURN;
288: END IF;

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

345: IF ( get_pk_for_validation(
346: new_references.athletic_prg_id
347: )
348: ) THEN
349: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353: check_uniqueness;

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

361: IF ( get_pk_for_validation (
362: new_references.athletic_prg_id
363: )
364: ) THEN
365: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369: check_uniqueness;

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

420: IF (x_last_update_login IS NULL) THEN
421: x_last_update_login := -1;
422: END IF;
423: ELSE
424: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
425: igs_ge_msg_stack.add;
426: app_exception.raise_exception;
427: END IF;
428:

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

499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
503: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
504: fnd_message.set_token ('ERR_CD', SQLCODE);
505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;

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

500: EXCEPTION
501: WHEN OTHERS THEN
502: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
503: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
504: fnd_message.set_token ('ERR_CD', SQLCODE);
505: igs_ge_msg_stack.add;
506: igs_sc_gen_001.unset_ctx('R');
507: app_exception.raise_exception;
508: ELSE

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

553:
554: OPEN c1;
555: FETCH c1 INTO tlinfo;
556: IF (c1%notfound) THEN
557: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
558: igs_ge_msg_stack.add;
559: CLOSE c1;
560: app_exception.raise_exception;
561: RETURN;

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

573: AND ((tlinfo.last_update_dt = x_last_update_dt) OR ((tlinfo.last_update_dt IS NULL) AND (X_last_update_dt IS NULL)))
574: ) THEN
575: NULL;
576: ELSE
577: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
578: igs_ge_msg_stack.add;
579: app_exception.raise_exception;
580: END IF;
581:

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

625: IF (x_last_update_login IS NULL) THEN
626: x_last_update_login := -1;
627: END IF;
628: ELSE
629: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
630: igs_ge_msg_stack.add;
631: app_exception.raise_exception;
632: END IF;
633:

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

668: last_update_login = x_last_update_login
669: WHERE rowid = x_rowid;
670:
671: IF (SQL%NOTFOUND) THEN
672: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
673: igs_ge_msg_stack.add;
674: igs_sc_gen_001.unset_ctx('R');
675: app_exception.raise_exception;
676: END IF;

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

682:
683: EXCEPTION
684: WHEN OTHERS THEN
685: IF (SQLCODE = (-28115)) THEN
686: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
687: fnd_message.set_token ('ERR_CD', SQLCODE);
688: igs_ge_msg_stack.add;
689: igs_sc_gen_001.unset_ctx('R');
690: app_exception.raise_exception;

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

683: EXCEPTION
684: WHEN OTHERS THEN
685: IF (SQLCODE = (-28115)) THEN
686: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
687: fnd_message.set_token ('ERR_CD', SQLCODE);
688: igs_ge_msg_stack.add;
689: igs_sc_gen_001.unset_ctx('R');
690: app_exception.raise_exception;
691: ELSE

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

789: DELETE FROM igs_pe_athletic_prg
790: WHERE rowid = x_rowid;
791:
792: IF (SQL%NOTFOUND) THEN
793: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
794: igs_ge_msg_stack.add;
795: igs_sc_gen_001.unset_ctx('R');
796: app_exception.raise_exception;
797: END IF;