[Home] [Help]
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;
92: new_references.calculation_date,
93: new_references.person_id
94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
124: IF upper(column_name) = 'PROBABILITY_VALUE' OR column_name is null Then
125:
126: IF new_references.probability_value < 0 Then
127:
128: Fnd_Message.Set_Name ('IGS', 'IGS_AD_PROB_VAL');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131:
132: END IF;
153: NULL;
154: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
155: new_references.person_id
156: ) THEN
157: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
158: igs_ge_msg_stack.add;
159: app_exception.raise_exception;
160: END IF;
161:
166: new_references.probability_type_code_id ,
167: 'PROB_TYPE',
168: 'N'
169: ) THEN
170: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174:
179: new_references.probability_source_code_id ,
180: 'PROB_SOURCE',
181: 'N'
182: ) THEN
183: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
184: igs_ge_msg_stack.add;
185: app_exception.raise_exception;
186: END IF;
187:
286: OPEN cur_rowid;
287: FETCH cur_rowid INTO lv_rowid;
288: IF (cur_rowid%FOUND) THEN
289: CLOSE cur_rowid;
290: fnd_message.set_name ('IGS', 'IGS_AD_IARP_PE_FK');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: RETURN;
294: END IF;
322: OPEN cur_rowid;
323: FETCH cur_rowid INTO lv_rowid;
324: IF (cur_rowid%FOUND) THEN
325: CLOSE cur_rowid;
326: fnd_message.set_name ('IGS', 'IGS_AD_IARP_ADCC_FK');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: RETURN;
330: END IF;
381: IF ( get_pk_for_validation(
382: new_references.probability_index_id
383: )
384: ) THEN
385: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389: check_uniqueness;
399: IF ( get_pk_for_validation (
400: new_references.probability_index_id
401: )
402: ) THEN
403: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407: check_uniqueness;
457: IF (x_last_update_login IS NULL) THEN
458: x_last_update_login := -1;
459: END IF;
460: ELSE
461: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
462: igs_ge_msg_stack.add;
463: app_exception.raise_exception;
464: END IF;
465:
552:
553: OPEN c1;
554: FETCH c1 INTO tlinfo;
555: IF (c1%notfound) THEN
556: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
557: igs_ge_msg_stack.add;
558: CLOSE c1;
559: app_exception.raise_exception;
560: RETURN;
569: AND ((tlinfo.probability_source_code_id = x_probability_source_code_id) OR ((tlinfo.probability_source_code_id IS NULL) AND (X_probability_source_code_id IS NULL)))
570: ) THEN
571: NULL;
572: ELSE
573: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577:
618: IF (x_last_update_login IS NULL) THEN
619: x_last_update_login := -1;
620: END IF;
621: ELSE
622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
623: igs_ge_msg_stack.add;
624: app_exception.raise_exception;
625: END IF;
626: