46: OPEN cur_old_ref_values;
47: FETCH cur_old_ref_values INTO old_references;
48: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
49: CLOSE cur_old_ref_values;
50: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
51: igs_ge_msg_stack.add;
52: app_exception.raise_exception;
53: RETURN;
54: END IF;
101: ELSE
102: Open cur_rowid;
103: Fetch cur_rowid INTO lv_rowid;
104: IF (cur_rowid%NOTFOUND) THEN
105: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: Close cur_rowid;
169: OPEN cur_rowid;
170: FETCH cur_rowid INTO lv_rowid;
171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
231: IF ( get_pk_for_validation(
232: new_references.hz_emp_dtl_id
233: )
234: ) THEN
235: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: check_parent_existance;
250: IF ( get_pk_for_validation (
251: new_references.hz_emp_dtl_id
252: )
253: ) THEN
254: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;
305: IF (x_last_update_login IS NULL) THEN
306: x_last_update_login := -1;
307: END IF;
308: ELSE
309: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:
378:
379: EXCEPTION
380: WHEN OTHERS THEN
381: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
383: fnd_message.set_token ('ERR_CD', SQLCODE);
384: igs_ge_msg_stack.add;
385: igs_sc_gen_001.unset_ctx('R');
386: app_exception.raise_exception;
379: EXCEPTION
380: WHEN OTHERS THEN
381: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
383: fnd_message.set_token ('ERR_CD', SQLCODE);
384: igs_ge_msg_stack.add;
385: igs_sc_gen_001.unset_ctx('R');
386: app_exception.raise_exception;
387: ELSE
431:
432: OPEN c1;
433: FETCH c1 INTO tlinfo;
434: IF (c1%notfound) THEN
435: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
436: igs_ge_msg_stack.add;
437: CLOSE c1;
438: app_exception.raise_exception;
439: RETURN;
446: AND ((tlinfo.occupational_title_code = x_occupational_title_code) OR ((tlinfo.occupational_title_code IS NULL) AND (X_occupational_title_code IS NULL)))
447: ) THEN
448: NULL;
449: ELSE
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: END IF;
454:
497: IF (x_last_update_login IS NULL) THEN
498: x_last_update_login := -1;
499: END IF;
500: ELSE
501: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
502: igs_ge_msg_stack.add;
503: app_exception.raise_exception;
504: END IF;
505:
539: last_update_login = x_last_update_login
540: WHERE rowid = x_rowid;
541:
542: IF (SQL%NOTFOUND) THEN
543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
544: igs_ge_msg_stack.add;
545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: END IF;
553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF (SQLCODE = (-28115)) THEN
557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF (SQLCODE = (-28115)) THEN
557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE
659: DELETE FROM igs_ad_hz_emp_dtl
660: WHERE rowid = x_rowid;
661:
662: IF (SQL%NOTFOUND) THEN
663: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
664: igs_ge_msg_stack.add;
665: igs_sc_gen_001.unset_ctx('R');
666: app_exception.raise_exception;
667: END IF;