DBA Data[Home] [Help]

APPS.IGS_PE_CONTACT_DTLS_PKG dependencies on FND_MESSAGE

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

73: FETCH cur_old_ref_values INTO old_references;
74:
75: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
76: CLOSE cur_old_ref_values;
77: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
78: igs_ge_msg_stack.add;
79: app_exception.raise_exception;
80: RETURN;
81: END IF;

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

174: NULL;
175: ELSIF NOT igs_ad_locvenue_addr_pkg.get_pk_for_validation (
176: new_references.location_venue_addr_id
177: ) THEN
178: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182:

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

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

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

353: -- Call all the procedures related to Before Insert.
354: Null;
355: IF (get_pk_for_validation(
356: new_references.contact_point_id)) THEN
357: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
358: igs_ge_msg_stack.add;
359: app_exception.raise_exception;
360: END IF;
361: check_constraints;

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

371: ELSIF (p_action = 'VALIDATE_INSERT') THEN
372: -- Call all the procedures related to Before Insert.
373: IF (get_pk_for_validation (
374: new_references.contact_point_id)) THEN
375: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: check_constraints;

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

503: ELSE
504: x_program_update_date := SYSDATE;
505: END IF;
506: ELSE
507: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: END IF;
511:

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

669:
670: EXCEPTION
671: WHEN OTHERS THEN
672: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
673: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
674: fnd_message.set_token ('ERR_CD', SQLCODE);
675: igs_ge_msg_stack.add;
676: igs_sc_gen_001.unset_ctx('R');
677: app_exception.raise_exception;

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

670: EXCEPTION
671: WHEN OTHERS THEN
672: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
673: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
674: fnd_message.set_token ('ERR_CD', SQLCODE);
675: igs_ge_msg_stack.add;
676: igs_sc_gen_001.unset_ctx('R');
677: app_exception.raise_exception;
678: ELSE

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

772: OPEN c1;
773: FETCH c1 INTO tlinfo;
774:
775: IF (c1%notfound) THEN
776: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
777: igs_ge_msg_stack.add;
778: CLOSE c1;
779: app_exception.raise_exception;
780: RETURN;

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

877: AND (X_ATTRIBUTE20 is null)))
878: ) THEN
879: NULL;
880: ELSE
881: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
882: igs_ge_msg_stack.add;
883: app_exception.raise_exception;
884: END IF;
885:

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

957: IF (x_last_update_login IS NULL) THEN
958: x_last_update_login := -1;
959: END IF;
960: ELSE
961: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
962: igs_ge_msg_stack.add;
963: app_exception.raise_exception;
964: END IF;
965:

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

1067: program_update_date = x_program_update_date
1068: WHERE ROWID = x_rowid;
1069:
1070: IF (SQL%NOTFOUND) THEN
1071: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1072: igs_ge_msg_stack.add;
1073: igs_sc_gen_001.unset_ctx('R');
1074: app_exception.raise_exception;
1075: END IF;

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

1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: IF (SQLCODE = (-28115)) THEN
1090: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1091: fnd_message.set_token ('ERR_CD', SQLCODE);
1092: igs_ge_msg_stack.add;
1093: igs_sc_gen_001.unset_ctx('R');
1094: app_exception.raise_exception;

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

1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: IF (SQLCODE = (-28115)) THEN
1090: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1091: fnd_message.set_token ('ERR_CD', SQLCODE);
1092: igs_ge_msg_stack.add;
1093: igs_sc_gen_001.unset_ctx('R');
1094: app_exception.raise_exception;
1095: ELSE

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

1265: DELETE FROM igs_pe_contact_dtls
1266: WHERE ROWID = x_rowid;
1267:
1268: IF (SQL%NOTFOUND) THEN
1269: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1270: igs_ge_msg_stack.add;
1271: igs_sc_gen_001.unset_ctx('R');
1272: app_exception.raise_exception;
1273: END IF;