APPS.IGS_AS_SC_ATMPT_NOTE_PKG dependencies on IGS_SC_GEN_001

Line 342: igs_sc_gen_001.set_ctx('R');

338: x_last_updated_by=>X_LAST_UPDATED_BY,
339: x_last_update_login=>X_LAST_UPDATE_LOGIN
340: );
341: IF (x_mode = 'S') THEN
342: igs_sc_gen_001.set_ctx('R');
343: END IF;
344: insert into IGS_AS_SC_ATMPT_NOTE (
345: PERSON_ID,
346: COURSE_CD,

Line 366: igs_sc_gen_001.unset_ctx('R');

362: X_LAST_UPDATED_BY,
363: X_LAST_UPDATE_LOGIN
364: );
365: IF (x_mode = 'S') THEN
366: igs_sc_gen_001.unset_ctx('R');
367: END IF;
368:
369: open c;
370: fetch c into X_ROWID;

Line 383: igs_sc_gen_001.unset_ctx('R');

379: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
380: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
381: fnd_message.set_token ('ERR_CD', SQLCODE);
382: igs_ge_msg_stack.add;
383: igs_sc_gen_001.unset_ctx('R');
384: app_exception.raise_exception;
385: ELSE
386: igs_sc_gen_001.unset_ctx('R');
387: RAISE;

Line 386: igs_sc_gen_001.unset_ctx('R');

382: igs_ge_msg_stack.add;
383: igs_sc_gen_001.unset_ctx('R');
384: app_exception.raise_exception;
385: ELSE
386: igs_sc_gen_001.unset_ctx('R');
387: RAISE;
388: END IF;
389:
390: end INSERT_ROW;

Line 468: igs_sc_gen_001.set_ctx('R');

464: x_last_updated_by=>X_LAST_UPDATED_BY,
465: x_last_update_login=>X_LAST_UPDATE_LOGIN
466: );
467: IF (x_mode = 'S') THEN
468: igs_sc_gen_001.set_ctx('R');
469: END IF;
470: update IGS_AS_SC_ATMPT_NOTE set
471: ENR_NOTE_TYPE = NEW_REFERENCES.ENR_NOTE_TYPE,
472: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 479: igs_sc_gen_001.unset_ctx('R');

475: where ROWID = X_ROWID;
476: if (sql%notfound) then
477: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
478: igs_ge_msg_stack.add;
479: igs_sc_gen_001.unset_ctx('R');
480: app_exception.raise_exception;
481: end if;
482: IF (x_mode = 'S') THEN
483: igs_sc_gen_001.unset_ctx('R');

Line 483: igs_sc_gen_001.unset_ctx('R');

479: igs_sc_gen_001.unset_ctx('R');
480: app_exception.raise_exception;
481: end if;
482: IF (x_mode = 'S') THEN
483: igs_sc_gen_001.unset_ctx('R');
484: END IF;
485:
486:
487: EXCEPTION

Line 493: igs_sc_gen_001.unset_ctx('R');

489: IF (SQLCODE = (-28115)) THEN
490: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
491: fnd_message.set_token ('ERR_CD', SQLCODE);
492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;
495: ELSE
496: igs_sc_gen_001.unset_ctx('R');
497: RAISE;

Line 496: igs_sc_gen_001.unset_ctx('R');

492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;
495: ELSE
496: igs_sc_gen_001.unset_ctx('R');
497: RAISE;
498: END IF;
499:
500: end UPDATE_ROW;

Line 546: igs_sc_gen_001.set_ctx('R');

542: p_action => 'DELETE',
543: x_rowid => X_ROWID
544: );
545: IF (x_mode = 'S') THEN
546: igs_sc_gen_001.set_ctx('R');
547: END IF;
548: delete from IGS_AS_SC_ATMPT_NOTE
549: where ROWID = X_ROWID;
550: if (sql%notfound) then

Line 553: igs_sc_gen_001.unset_ctx('R');

549: where ROWID = X_ROWID;
550: if (sql%notfound) then
551: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
552: igs_ge_msg_stack.add;
553: igs_sc_gen_001.unset_ctx('R');
554: app_exception.raise_exception;
555: end if;
556: IF (x_mode = 'S') THEN
557: igs_sc_gen_001.unset_ctx('R');

Line 557: igs_sc_gen_001.unset_ctx('R');

553: igs_sc_gen_001.unset_ctx('R');
554: app_exception.raise_exception;
555: end if;
556: IF (x_mode = 'S') THEN
557: igs_sc_gen_001.unset_ctx('R');
558: END IF;
559:
560:
561: end DELETE_ROW;