DBA Data[Home] [Help]

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

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

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

121: NULL;
122: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
123: 'PE_SN_SERVICE',new_references.special_service_cd
124: ) THEN
125: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
126: igs_ge_msg_stack.add;
127: app_exception.raise_exception;
128: END IF;
129:

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

132: NULL;
133: ELSIF NOT igs_pe_pers_disablty_pkg.get_pk_for_validation (
134: new_references.disability_id
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:

Line 244: fnd_message.set_name ('IGS', 'IGS_PE_SNSV_PD_FK');

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

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

301: IF ( get_pk_for_validation(
302: new_references.sn_service_id
303: )
304: ) THEN
305: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309:

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

319: IF ( get_pk_for_validation (
320: new_references.sn_service_id
321: )
322: ) THEN
323: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: END IF;
327: check_uniqueness;

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

376: IF (x_last_update_login IS NULL) THEN
377: x_last_update_login := -1;
378: END IF;
379: ELSE
380: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
381: igs_ge_msg_stack.add;
382: app_exception.raise_exception;
383: END IF;
384:

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

446:
447: EXCEPTION
448: WHEN OTHERS THEN
449: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
450: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
451: fnd_message.set_token ('ERR_CD', SQLCODE);
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;

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

447: EXCEPTION
448: WHEN OTHERS THEN
449: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
450: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
451: fnd_message.set_token ('ERR_CD', SQLCODE);
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: ELSE

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

495:
496: OPEN c1;
497: FETCH c1 INTO tlinfo;
498: IF (c1%notfound) THEN
499: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
500: igs_ge_msg_stack.add;
501: CLOSE c1;
502: app_exception.raise_exception;
503: RETURN;

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

521: AND (x_end_dt is null)))
522: ) THEN
523: NULL;
524: ELSE
525: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:

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

570: IF (x_last_update_login IS NULL) THEN
571: x_last_update_login := -1;
572: END IF;
573: ELSE
574: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
578:

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

607: last_update_login = x_last_update_login
608: WHERE rowid = x_rowid;
609:
610: IF (SQL%NOTFOUND) THEN
611: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
612: igs_ge_msg_stack.add;
613: igs_sc_gen_001.unset_ctx('R');
614: app_exception.raise_exception;
615: END IF;

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

621:
622: EXCEPTION
623: WHEN OTHERS THEN
624: IF (SQLCODE = (-28115)) THEN
625: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
626: fnd_message.set_token ('ERR_CD', SQLCODE);
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;

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

622: EXCEPTION
623: WHEN OTHERS THEN
624: IF (SQLCODE = (-28115)) THEN
625: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
626: fnd_message.set_token ('ERR_CD', SQLCODE);
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: ELSE

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

719: DELETE FROM igs_pe_sn_service
720: WHERE rowid = x_rowid;
721:
722: IF (SQL%NOTFOUND) THEN
723: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
724: igs_ge_msg_stack.add;
725: igs_sc_gen_001.unset_ctx('R');
726: app_exception.raise_exception;
727: END IF;