550: x_last_update_login => x_last_update_login
551: );
552:
553: IF (x_mode = 'S') THEN
554: igs_sc_gen_001.set_ctx('R');
555: END IF;
556: INSERT INTO igs_as_sua_ai_group (
557: sua_ass_item_group_id,
558: person_id,
594: x_last_updated_by,
595: x_last_update_login
596: ) RETURNING ROWID, sua_ass_item_group_id INTO x_rowid, x_sua_ass_item_group_id;
597: IF (x_mode = 'S') THEN
598: igs_sc_gen_001.unset_ctx('R');
599: END IF;
600:
601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
605: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
606: IF (x_mode = 'S') THEN
607: igs_sc_gen_001.unset_ctx('R');
608: END IF;
609:
610: fnd_message.set_token ('ERR_CD', SQLCODE);
611: igs_ge_msg_stack.add;
608: END IF;
609:
610: fnd_message.set_token ('ERR_CD', SQLCODE);
611: igs_ge_msg_stack.add;
612: igs_sc_gen_001.unset_ctx('R');
613: app_exception.raise_exception;
614: ELSE
615: igs_sc_gen_001.unset_ctx('R');
616: RAISE;
611: igs_ge_msg_stack.add;
612: igs_sc_gen_001.unset_ctx('R');
613: app_exception.raise_exception;
614: ELSE
615: igs_sc_gen_001.unset_ctx('R');
616: RAISE;
617: END IF;
618: END insert_row;
619:
782: x_last_update_login => x_last_update_login
783: );
784:
785: IF (x_mode = 'S') THEN
786: igs_sc_gen_001.set_ctx('R');
787: END IF;
788: UPDATE igs_as_sua_ai_group
789: SET
790: person_id = new_references.person_id,
807:
808: IF (SQL%NOTFOUND) THEN
809: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
810: igs_ge_msg_stack.add;
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: END IF;
814: IF (x_mode = 'S') THEN
815: igs_sc_gen_001.unset_ctx('R');
811: igs_sc_gen_001.unset_ctx('R');
812: app_exception.raise_exception;
813: END IF;
814: IF (x_mode = 'S') THEN
815: igs_sc_gen_001.unset_ctx('R');
816: END IF;
817:
818:
819:
822: IF (SQLCODE = (-28115)) THEN
823: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
824: fnd_message.set_token ('ERR_CD', SQLCODE);
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
829: igs_sc_gen_001.unset_ctx('R');
830: RAISE;
825: igs_ge_msg_stack.add;
826: igs_sc_gen_001.unset_ctx('R');
827: app_exception.raise_exception;
828: ELSE
829: igs_sc_gen_001.unset_ctx('R');
830: RAISE;
831: END IF;
832: END update_row;
833:
935: x_rowid => x_rowid
936: );
937:
938: IF (x_mode = 'S') THEN
939: igs_sc_gen_001.set_ctx('R');
940: END IF;
941: DELETE FROM igs_as_sua_ai_group
942: WHERE rowid = x_rowid;
943:
943:
944: IF (SQL%NOTFOUND) THEN
945: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
946: igs_ge_msg_stack.add;
947: igs_sc_gen_001.unset_ctx('R');
948: app_exception.raise_exception;
949: END IF;
950: IF (x_mode = 'S') THEN
951: igs_sc_gen_001.unset_ctx('R');
947: igs_sc_gen_001.unset_ctx('R');
948: app_exception.raise_exception;
949: END IF;
950: IF (x_mode = 'S') THEN
951: igs_sc_gen_001.unset_ctx('R');
952: END IF;
953:
954:
955: END delete_row;