[Home] [Help]
374: x_last_update_login => x_last_update_login
375: );
376:
377: IF (x_mode = 'S') THEN
378: igs_sc_gen_001.set_ctx('R');
379: END IF;
380:
381: INSERT INTO igs_pe_acad_intents (
382: acad_intent_id,
406:
407: new_references.acad_intent_id := x_acad_intent_id;
408:
409: IF (x_mode = 'S') THEN
410: igs_sc_gen_001.unset_ctx('R');
411: END IF;
412:
413:
414: After_DML(
420: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
421: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
422: fnd_message.set_token ('ERR_CD', SQLCODE);
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: ELSE
427: igs_sc_gen_001.unset_ctx('R');
428: RAISE;
423: igs_ge_msg_stack.add;
424: igs_sc_gen_001.unset_ctx('R');
425: app_exception.raise_exception;
426: ELSE
427: igs_sc_gen_001.unset_ctx('R');
428: RAISE;
429: END IF;
430: END insert_row;
431:
554: x_last_update_login => x_last_update_login
555: );
556:
557: IF (x_mode = 'S') THEN
558: igs_sc_gen_001.set_ctx('R');
559: END IF;
560:
561: UPDATE igs_pe_acad_intents
562: SET
572:
573: if (sql%notfound) then
574: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
575: igs_ge_msg_stack.add;
576: igs_sc_gen_001.unset_ctx('R');
577: app_exception.raise_exception;
578: end if;
579: IF (x_mode = 'S') THEN
580: igs_sc_gen_001.unset_ctx('R');
576: igs_sc_gen_001.unset_ctx('R');
577: app_exception.raise_exception;
578: end if;
579: IF (x_mode = 'S') THEN
580: igs_sc_gen_001.unset_ctx('R');
581: END IF;
582:
583: After_DML(
584: p_action => 'UPDATE',
590: IF (SQLCODE = (-28115)) THEN
591: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
592: fnd_message.set_token ('ERR_CD', SQLCODE);
593: igs_ge_msg_stack.add;
594: igs_sc_gen_001.unset_ctx('R');
595: app_exception.raise_exception;
596: ELSE
597: igs_sc_gen_001.unset_ctx('R');
598: RAISE;
593: igs_ge_msg_stack.add;
594: igs_sc_gen_001.unset_ctx('R');
595: app_exception.raise_exception;
596: ELSE
597: igs_sc_gen_001.unset_ctx('R');
598: RAISE;
599: END IF;
600: END update_row;
601:
679: x_rowid => x_rowid
680: );
681:
682: IF (x_mode = 'S') THEN
683: igs_sc_gen_001.set_ctx('R');
684: END IF;
685: DELETE FROM igs_pe_acad_intents
686: WHERE rowid = x_rowid;
687:
687:
688: if (sql%notfound) then
689: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
690: igs_ge_msg_stack.add;
691: igs_sc_gen_001.unset_ctx('R');
692: app_exception.raise_exception;
693: end if;
694: IF (x_mode = 'S') THEN
695: igs_sc_gen_001.unset_ctx('R');
691: igs_sc_gen_001.unset_ctx('R');
692: app_exception.raise_exception;
693: end if;
694: IF (x_mode = 'S') THEN
695: igs_sc_gen_001.unset_ctx('R');
696: END IF;
697:
698: END delete_row;
699: