DBA Data[Home] [Help]

APPS.IGS_PE_FELONY_DTLS_PKG dependencies on FND_MESSAGE

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

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

Line 114: FND_MESSAGE.SET_NAME('IGS','IGS_PE_INT_DT_LT_BRDT');

110: OPEN validate_cr_dt;
111: FETCH validate_cr_dt INTO l_birth_dt;
112: CLOSE validate_cr_dt;
113: IF l_birth_dt IS NOT NULL AND l_birth_dt > new_references.crime_date THEN
114: FND_MESSAGE.SET_NAME('IGS','IGS_PE_INT_DT_LT_BRDT');
115: IGS_GE_MSG_STACK.ADD;
116: APP_EXCEPTION.RAISE_EXCEPTION;
117: END IF;
118: END IF;

Line 124: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');

120: IF new_references.crime_date > TRUNC(SYSDATE) THEN
121: OPEN mes_token;
122: FETCH mes_token INTO l_meaning;
123: CLOSE mes_token;
124: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');
125: FND_MESSAGE.SET_TOKEN('NAME',l_meaning);
126: IGS_GE_MSG_STACK.ADD;
127: APP_EXCEPTION.RAISE_EXCEPTION;
128: END IF;

Line 125: FND_MESSAGE.SET_TOKEN('NAME',l_meaning);

121: OPEN mes_token;
122: FETCH mes_token INTO l_meaning;
123: CLOSE mes_token;
124: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE');
125: FND_MESSAGE.SET_TOKEN('NAME',l_meaning);
126: IGS_GE_MSG_STACK.ADD;
127: APP_EXCEPTION.RAISE_EXCEPTION;
128: END IF;
129: END BeforeRowInsertUpdate1;

Line 163: fnd_message.set_name('IGS','IGS_PE_SS_NO_CRMNL_CONVICT');

159: CLOSE felony_convicted_flag_cur;
160: IF p_inserting THEN
161: IF x_felony_convicted_flag IS NOT NULL THEN
162: IF new_references.convict_ind = 'Y' AND x_felony_convicted_flag = 'N' THEN
163: fnd_message.set_name('IGS','IGS_PE_SS_NO_CRMNL_CONVICT');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167: ELSIF x_felony_convicted_flag IS NULL THEN

Line 168: fnd_message.set_name('IGS','IGS_PE_SS_FLNY_CANT_INSERT');

164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167: ELSIF x_felony_convicted_flag IS NULL THEN
168: fnd_message.set_name('IGS','IGS_PE_SS_FLNY_CANT_INSERT');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172: ELSIF p_updating THEN

Line 174: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SS_NO_CRMNL_CONVICT');

170: app_exception.raise_exception;
171: END IF;
172: ELSIF p_updating THEN
173: IF new_references.convict_ind = 'Y' AND x_felony_convicted_flag <> 'Y' THEN
174: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SS_NO_CRMNL_CONVICT');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178: END IF;

Line 201: fnd_message.set_name ('IGS', 'IGS_PE_FLNY_DUP_EXISTS');

197: new_references.crime_nature,
198: new_references.crime_date
199: )
200: ) THEN
201: fnd_message.set_name ('IGS', 'IGS_PE_FLNY_DUP_EXISTS');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: END IF;
205:

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

223: NULL;
224: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
225: new_references.person_id
226: ) THEN
227: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: END IF;
231:

Line 334: fnd_message.set_name ('IGS', 'IGS_PE_PEFD_HZ_FK');

330: OPEN cur_rowid;
331: FETCH cur_rowid INTO lv_rowid;
332: IF (cur_rowid%FOUND) THEN
333: CLOSE cur_rowid;
334: fnd_message.set_name ('IGS', 'IGS_PE_PEFD_HZ_FK');
335: igs_ge_msg_stack.add;
336: app_exception.raise_exception;
337: RETURN;
338: END IF;

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

392: IF ( get_pk_for_validation(
393: new_references.felony_details_id
394: )
395: ) THEN
396: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400: check_uniqueness;

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

415: IF ( get_pk_for_validation (
416: new_references.felony_details_id
417: )
418: ) THEN
419: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
420: igs_ge_msg_stack.add;
421: app_exception.raise_exception;
422: END IF;
423: check_uniqueness;

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

472: IF (x_last_update_login IS NULL) THEN
473: x_last_update_login := -1;
474: END IF;
475: ELSE
476: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
477: igs_ge_msg_stack.add;
478: app_exception.raise_exception;
479: END IF;
480:

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

542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
546: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
547: fnd_message.set_token ('ERR_CD', SQLCODE);
548: igs_ge_msg_stack.add;
549: igs_sc_gen_001.unset_ctx('R');
550: app_exception.raise_exception;

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

543: EXCEPTION
544: WHEN OTHERS THEN
545: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
546: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
547: fnd_message.set_token ('ERR_CD', SQLCODE);
548: igs_ge_msg_stack.add;
549: igs_sc_gen_001.unset_ctx('R');
550: app_exception.raise_exception;
551: ELSE

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

591:
592: OPEN c1;
593: FETCH c1 INTO tlinfo;
594: IF (c1%notfound) THEN
595: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
596: igs_ge_msg_stack.add;
597: CLOSE c1;
598: app_exception.raise_exception;
599: RETURN;

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

613:
614: ) THEN
615: NULL;
616: ELSE
617: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621:

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

662: IF (x_last_update_login IS NULL) THEN
663: x_last_update_login := -1;
664: END IF;
665: ELSE
666: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
667: igs_ge_msg_stack.add;
668: app_exception.raise_exception;
669: END IF;
670:

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

699: last_update_login = x_last_update_login
700: WHERE rowid = x_rowid;
701:
702: IF (SQL%NOTFOUND) THEN
703: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
704: igs_ge_msg_stack.add;
705: igs_sc_gen_001.unset_ctx('R');
706: app_exception.raise_exception;
707: END IF;

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

713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: IF (SQLCODE = (-28115)) THEN
717: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
718: fnd_message.set_token ('ERR_CD', SQLCODE);
719: igs_ge_msg_stack.add;
720: igs_sc_gen_001.unset_ctx('R');
721: app_exception.raise_exception;

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

714: EXCEPTION
715: WHEN OTHERS THEN
716: IF (SQLCODE = (-28115)) THEN
717: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
718: fnd_message.set_token ('ERR_CD', SQLCODE);
719: igs_ge_msg_stack.add;
720: igs_sc_gen_001.unset_ctx('R');
721: app_exception.raise_exception;
722: ELSE

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

812: DELETE FROM igs_pe_felony_dtls
813: WHERE rowid = x_rowid;
814:
815: IF (SQL%NOTFOUND) THEN
816: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
817: igs_ge_msg_stack.add;
818: igs_sc_gen_001.unset_ctx('R');
819: app_exception.raise_exception;
820: END IF;