50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:
107: )
108: ) THEN
109: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_uniqueness;
115:
133: new_references.fund_code
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: IF (((old_references.person_id = new_references.person_id) AND
141: (old_references.encumbrance_type = new_references.encumbrance_type) AND
159: new_references.pee_sequence_number
160: ) THEN
161: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
162: igs_ge_msg_stack.add;
163: app_exception.raise_exception;
164: END IF;
165:
166: END check_parent_existance;
167:
276: IF (cur_rowid%FOUND) THEN
277: CLOSE cur_rowid;
278: fnd_message.set_name ('IGS', 'IGS_PE_FCAT_PEE_FK');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: RETURN;
282: END IF;
283: CLOSE cur_rowid;
284:
321: IF (cur_rowid%FOUND) THEN
322: CLOSE cur_rowid;
323: fnd_message.set_name ('IGS', 'IGS_PE_PFE_PEE_FK');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: RETURN;
327: END IF;
328: CLOSE cur_rowid;
329:
347: new_references.pfe_start_dt,
348: l_message_name) = FALSE THEN
349: FND_MESSAGE.SET_NAME('IGS', l_message_name);
350: IGS_GE_MSG_STACK.ADD;
351: APP_EXCEPTION.RAISE_EXCEPTION;
352: END IF;
353: END IF;
354:
355: -- Validate that start date is not less than the parent IGS_PE_PERSON
360: new_references.pfe_start_dt,
361: l_message_name) = FALSE THEN
362: FND_MESSAGE.SET_NAME('IGS', l_message_name);
363: IGS_GE_MSG_STACK.ADD;
364: APP_EXCEPTION.RAISE_EXCEPTION;
365: END IF;
366: END IF;
367:
368: -- Validate that if expiry date is specified, then expiry date is not
377: new_references.expiry_dt,
378: l_message_name) = FALSE THEN
379: FND_MESSAGE.SET_NAME('IGS', l_message_name);
380: IGS_GE_MSG_STACK.ADD;
381: APP_EXCEPTION.RAISE_EXCEPTION;
382: END IF;
383:
384: IF igs_en_val_pce.enrp_val_encmb_dt (
385: new_references.expiry_dt,
385: new_references.expiry_dt,
386: l_message_name) = FALSE THEN
387: FND_MESSAGE.SET_NAME('IGS', l_message_name);
388: IGS_GE_MSG_STACK.ADD;
389: APP_EXCEPTION.RAISE_EXCEPTION;
390: END IF;
391: END IF;
392:
393:
396: IF p_inserting THEN
397: IF new_references.s_encmb_effect_type NOT IN ('EX_AWD','EX_DISB','EX_SP_AWD','EX_SP_DISB') THEN
398: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_CANT_CREATE_REC_ENCUMB');
399: IGS_GE_MSG_STACK.ADD;
400: APP_EXCEPTION.RAISE_EXCEPTION;
401: END IF;
402: END IF;
403:
404: END BeforeRowInsertUpdate;
429: IF fund_exclusion_cur%FOUND THEN
430: CLOSE fund_exclusion_cur;
431: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_FUND_EXCL_OPEN');
432: IGS_GE_MSG_STACK.ADD;
433: APP_EXCEPTION.RAISE_EXCEPTION;
434: END IF;
435: CLOSE fund_exclusion_cur;
436:
437: END AfterRowInsertUpdateDelete;
500: )
501: ) THEN
502: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
503: igs_ge_msg_stack.add;
504: app_exception.raise_exception;
505: END IF;
506: check_uniqueness;
507: check_parent_existance;
508: ELSIF (p_action = 'UPDATE') THEN
526: )
527: ) THEN
528: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
529: igs_ge_msg_stack.add;
530: app_exception.raise_exception;
531: END IF;
532: check_uniqueness;
533: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
534:
615: END IF;
616: ELSE
617: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621:
622: before_dml(
623: p_action => 'INSERT',
730: IF (c1%notfound) THEN
731: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
732: igs_ge_msg_stack.add;
733: CLOSE c1;
734: app_exception.raise_exception;
735: RETURN;
736: END IF;
737: CLOSE c1;
738:
750: NULL;
751: ELSE
752: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
753: igs_ge_msg_stack.add;
754: app_exception.raise_exception;
755: END IF;
756:
757: RETURN;
758:
803: END IF;
804: ELSE
805: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
806: igs_ge_msg_stack.add;
807: app_exception.raise_exception;
808: END IF;
809:
810: before_dml(
811: p_action => 'UPDATE',