[Home] [Help]
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;
53: CLOSE cur_old_ref_values;
54:
100: FETCH cur_rowid INTO lv_rowid;
101: IF (cur_rowid%NOTFOUND) THEN
102: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: CLOSE cur_rowid;
107:
108: END IF;
115: new_references.activity_source_cd
116: )THEN
117: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
118: IGS_GE_MSG_STACK.ADD;
119: App_Exception.Raise_Exception;
120: END IF;
121:
122: END check_parent_existance;
123:
181: IF (cur_rowid%FOUND) THEN
182: CLOSE cur_rowid;
183: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
184: igs_ge_msg_stack.ADD;
185: app_exception.raise_exception;
186: RETURN;
187: END IF;
188: CLOSE cur_rowid;
189:
240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.ADD;
244: app_exception.raise_exception;
245: END IF;
246: check_constraints;
247: check_parent_existance;
248: ELSIF (p_action = 'UPDATE') THEN
260: )
261: ) THEN
262: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: igs_ge_msg_stack.ADD;
264: app_exception.raise_exception;
265: END IF;
266: check_constraints;
267: END IF;
268:
329: END IF;
330: ELSE
331: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
332: igs_ge_msg_stack.ADD;
333: app_exception.raise_exception;
334: END IF;
335:
336: X_HZ_EXTRACURR_ACT_ID := -1;
337: before_dml(
406: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
407: fnd_message.set_token ('ERR_CD', SQLCODE);
408: igs_ge_msg_stack.add;
409: igs_sc_gen_001.unset_ctx('R');
410: app_exception.raise_exception;
411: ELSE
412: igs_sc_gen_001.unset_ctx('R');
413: RAISE;
414: END IF;
454: IF (c1%NOTFOUND) THEN
455: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
456: igs_ge_msg_stack.ADD;
457: CLOSE c1;
458: app_exception.raise_exception;
459: RETURN;
460: END IF;
461: CLOSE c1;
462:
471: NULL;
472: ELSE
473: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
474: igs_ge_msg_stack.ADD;
475: app_exception.raise_exception;
476: END IF;
477:
478: RETURN;
479:
539: END IF;
540: ELSE
541: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
542: igs_ge_msg_stack.ADD;
543: app_exception.raise_exception;
544: END IF;
545:
546: before_dml(
547: p_action => 'UPDATE',
582: IF (SQL%NOTFOUND) THEN
583: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
584: igs_ge_msg_stack.add;
585: igs_sc_gen_001.unset_ctx('R');
586: app_exception.raise_exception;
587: END IF;
588: IF (x_mode = 'S') THEN
589: igs_sc_gen_001.unset_ctx('R');
590: END IF;
597: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
598: fnd_message.set_token ('ERR_CD', SQLCODE);
599: igs_ge_msg_stack.add;
600: igs_sc_gen_001.unset_ctx('R');
601: app_exception.raise_exception;
602: ELSE
603: igs_sc_gen_001.unset_ctx('R');
604: RAISE;
605: END IF;
694: IF (SQL%NOTFOUND) THEN
695: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
696: igs_ge_msg_stack.add;
697: igs_sc_gen_001.unset_ctx('R');
698: app_exception.raise_exception;
699: END IF;
700: IF (x_mode = 'S') THEN
701: igs_sc_gen_001.unset_ctx('R');
702: END IF;
742: IF NOT (new_references.hours_per_week >= 0
743: AND new_references.hours_per_week <= 168 ) THEN
744: Fnd_Message.Set_Name('IGS','IGS_AD_HRS_PER_WEEK');
745: IGS_GE_MSG_STACK.ADD;
746: App_Exception.Raise_Exception;
747: END IF;
748: END IF;
749:
750: -- The following code checks for check constraints on the Columns.
753: IF NOT (new_references.weeks_per_year >= 0
754: AND new_references.weeks_per_year <= 52 ) THEN
755: Fnd_Message.Set_Name('IGS','IGS_AD_WKS_PER_YEAR');
756: IGS_GE_MSG_STACK.ADD;
757: App_Exception.Raise_Exception;
758: END IF;
759: END IF;
760:
761: END Check_Constraints;