APPS.IGS_PE_CONTACT_DTLS_PKG dependencies on IGS_GE_MSG_STACK

Line 78: igs_ge_msg_stack.add;

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;
82:

Line 179: igs_ge_msg_stack.add;

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:
183: END check_parent_existance;

Line 246: igs_ge_msg_stack.add;

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;
250: CLOSE cur_rowid;

Line 358: igs_ge_msg_stack.add;

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;
362: check_parent_existance;

Line 376: igs_ge_msg_stack.add;

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;
380: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 508: igs_ge_msg_stack.add;

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:
512: SELECT igs_pe_contact_dtls_s.nextval INTO x_contact_point_id

Line 675: igs_ge_msg_stack.add;

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
679: igs_sc_gen_001.unset_ctx('R');

Line 777: igs_ge_msg_stack.add;

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;
781: END IF;

Line 882: igs_ge_msg_stack.add;

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:
886: RETURN;

Line 962: igs_ge_msg_stack.add;

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:
966: before_dml(

Line 1072: igs_ge_msg_stack.add;

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;
1076: IF (x_mode = 'S') THEN

Line 1092: igs_ge_msg_stack.add;

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
1096: igs_sc_gen_001.unset_ctx('R');

Line 1270: igs_ge_msg_stack.add;

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;
1274: IF (x_mode = 'S') THEN