42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
88: new_references.fund_source_code,
89: new_references.sys_fund_code
90: )
91: ) THEN
92: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
215: IF ( get_pk_for_validation(
216: new_references.fund_order_num
217: )
218: ) THEN
219: fnd_message.set_name('IGF','IGF_AW_PRTY_EXIST');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: END IF;
223: check_uniqueness;
229: IF ( get_pk_for_validation (
230: new_references.fund_order_num
231: )
232: ) THEN
233: fnd_message.set_name('IGF','IGF_AW_PRTY_EXIST');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: END IF;
237: check_uniqueness;
279: IF (x_last_update_login IS NULL) THEN
280: x_last_update_login := -1;
281: END IF;
282: ELSE
283: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
284: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.INSERT_ROW');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
280: x_last_update_login := -1;
281: END IF;
282: ELSE
283: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
284: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.INSERT_ROW');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288:
358:
359: OPEN c1;
360: FETCH c1 INTO tlinfo;
361: IF (c1%notfound) THEN
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: igs_ge_msg_stack.add;
364: CLOSE c1;
365: app_exception.raise_exception;
366: RETURN;
373: AND (tlinfo.sys_fund_code = x_sys_fund_code)
374: ) THEN
375: NULL;
376: ELSE
377: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381:
420: IF (x_last_update_login IS NULL) THEN
421: x_last_update_login := -1;
422: END IF;
423: ELSE
424: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
425: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.UPDATE_ROW');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
421: x_last_update_login := -1;
422: END IF;
423: ELSE
424: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
425: fnd_message.set_token ('ROUTINE', 'IGF_AW_REPKG_PRTY_PKG.UPDATE_ROW');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429: