APPS.IGS_PR_STDNT_PR_UNIT_PKG dependencies on IGS_SC_GEN_001

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

313: x_last_update_login => X_last_update_login
314: ) ;
315:
316: IF (x_mode = 'S') THEN
317: igs_sc_gen_001.set_ctx('R');
318: END IF;
319: insert into IGS_PR_STDNT_PR_UNIT (
320: PERSON_ID,
321: COURSE_CD,

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

339: X_LAST_UPDATED_BY,
340: X_LAST_UPDATE_LOGIN
341: );
342: IF (x_mode = 'S') THEN
343: igs_sc_gen_001.unset_ctx('R');
344: END IF;
345:
346:
347: open c;

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

356: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
357: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
358: fnd_message.set_token ('ERR_CD', SQLCODE);
359: igs_ge_msg_stack.add;
360: igs_sc_gen_001.unset_ctx('R');
361: app_exception.raise_exception;
362: ELSE
363: igs_sc_gen_001.unset_ctx('R');
364: RAISE;

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

359: igs_ge_msg_stack.add;
360: igs_sc_gen_001.unset_ctx('R');
361: app_exception.raise_exception;
362: ELSE
363: igs_sc_gen_001.unset_ctx('R');
364: RAISE;
365: END IF;
366:
367: end INSERT_ROW;

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

459: x_last_updated_by => x_last_updated_by ,
460: x_last_update_login => X_last_update_login
461: ) ;
462: IF (x_mode = 'S') THEN
463: igs_sc_gen_001.set_ctx('R');
464: END IF;
465: update IGS_PR_STDNT_PR_UNIT set
466: S_UNIT_TYPE = NEW_REFERENCES.S_UNIT_TYPE,
467: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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

470: where ROWID = X_ROWID;
471: if (sql%notfound) then
472: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
473: igs_ge_msg_stack.add;
474: igs_sc_gen_001.unset_ctx('R');
475: app_exception.raise_exception;
476: end if;
477: IF (x_mode = 'S') THEN
478: igs_sc_gen_001.unset_ctx('R');

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

474: igs_sc_gen_001.unset_ctx('R');
475: app_exception.raise_exception;
476: end if;
477: IF (x_mode = 'S') THEN
478: igs_sc_gen_001.unset_ctx('R');
479: END IF;
480:
481: EXCEPTION
482: WHEN OTHERS THEN

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

483: IF (SQLCODE = (-28115)) THEN
484: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
485: fnd_message.set_token ('ERR_CD', SQLCODE);
486: igs_ge_msg_stack.add;
487: igs_sc_gen_001.unset_ctx('R');
488: app_exception.raise_exception;
489: ELSE
490: igs_sc_gen_001.unset_ctx('R');
491: RAISE;

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

486: igs_ge_msg_stack.add;
487: igs_sc_gen_001.unset_ctx('R');
488: app_exception.raise_exception;
489: ELSE
490: igs_sc_gen_001.unset_ctx('R');
491: RAISE;
492: END IF;
493:
494: end UPDATE_ROW;

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

544: x_rowid => X_ROWID
545: ) ;
546:
547: IF (x_mode = 'S') THEN
548: igs_sc_gen_001.set_ctx('R');
549: END IF;
550: delete from IGS_PR_STDNT_PR_UNIT
551: where ROWID = X_ROWID;
552: if (sql%notfound) then

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

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

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

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