467: x_last_update_login=>X_LAST_UPDATE_LOGIN,
468: x_org_id=>igs_ge_gen_003.get_org_id
469: );
470: IF (x_mode = 'S') THEN
471: igs_sc_gen_001.set_ctx('R');
472: END IF;
473: insert into IGS_AV_ADV_STANDING_ALL (
474: PERSON_ID,
475: COURSE_CD,
499: X_LAST_UPDATE_LOGIN,
500: NEW_REFERENCES.ORG_ID
501: );
502: IF (x_mode = 'S') THEN
503: igs_sc_gen_001.unset_ctx('R');
504: END IF;
505:
506:
507: open c;
517: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
518: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
519: fnd_message.set_token ('ERR_CD', SQLCODE);
520: igs_ge_msg_stack.add;
521: igs_sc_gen_001.unset_ctx('R');
522: app_exception.raise_exception;
523: ELSE
524: igs_sc_gen_001.unset_ctx('R');
525: RAISE;
520: igs_ge_msg_stack.add;
521: igs_sc_gen_001.unset_ctx('R');
522: app_exception.raise_exception;
523: ELSE
524: igs_sc_gen_001.unset_ctx('R');
525: RAISE;
526: END IF;
527:
528: end INSERT_ROW;
621: x_last_updated_by=>X_LAST_UPDATED_BY,
622: x_last_update_login=>X_LAST_UPDATE_LOGIN
623: );
624: IF (x_mode = 'S') THEN
625: igs_sc_gen_001.set_ctx('R');
626: END IF;
627: update IGS_AV_ADV_STANDING_ALL set
628: TOTAL_EXMPTN_APPROVED = NEW_REFERENCES.TOTAL_EXMPTN_APPROVED,
629: TOTAL_EXMPTN_GRANTED = NEW_REFERENCES.TOTAL_EXMPTN_GRANTED,
634: where ROWID = X_ROWID ;
635: if (sql%notfound) then
636: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
637: igs_ge_msg_stack.add;
638: igs_sc_gen_001.unset_ctx('R');
639: app_exception.raise_exception;
640: end if;
641: IF (x_mode = 'S') THEN
642: igs_sc_gen_001.unset_ctx('R');
638: igs_sc_gen_001.unset_ctx('R');
639: app_exception.raise_exception;
640: end if;
641: IF (x_mode = 'S') THEN
642: igs_sc_gen_001.unset_ctx('R');
643: END IF;
644:
645:
646: EXCEPTION
648: IF (SQLCODE = (-28115)) THEN
649: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
650: fnd_message.set_token ('ERR_CD', SQLCODE);
651: igs_ge_msg_stack.add;
652: igs_sc_gen_001.unset_ctx('R');
653: app_exception.raise_exception;
654: ELSE
655: igs_sc_gen_001.unset_ctx('R');
656: RAISE;
651: igs_ge_msg_stack.add;
652: igs_sc_gen_001.unset_ctx('R');
653: app_exception.raise_exception;
654: ELSE
655: igs_sc_gen_001.unset_ctx('R');
656: RAISE;
657: END IF;
658: end UPDATE_ROW;
659:
715: );
716:
717:
718: IF (x_mode = 'S') THEN
719: igs_sc_gen_001.set_ctx('R');
720: END IF;
721: delete from IGS_AV_ADV_STANDING_ALL
722: where ROWID = X_ROWID ;
723: if (sql%notfound) then
722: where ROWID = X_ROWID ;
723: if (sql%notfound) then
724: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
725: igs_ge_msg_stack.add;
726: igs_sc_gen_001.unset_ctx('R');
727: app_exception.raise_exception;
728: end if;
729: IF (x_mode = 'S') THEN
730: igs_sc_gen_001.unset_ctx('R');
726: igs_sc_gen_001.unset_ctx('R');
727: app_exception.raise_exception;
728: end if;
729: IF (x_mode = 'S') THEN
730: igs_sc_gen_001.unset_ctx('R');
731: END IF;
732:
733:
734: end DELETE_ROW;