APPS.IGS_PE_ACAD_HONORS_PKG dependencies on IGS_SC_GEN_001

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

420:
421:
422:
423: IF (x_mode = 'S') THEN
424: igs_sc_gen_001.set_ctx('R');
425: END IF;
426: insert into igs_pe_acad_honors (
427: ACAD_HONOR_ID
428: ,PERSON_ID

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

454: ,X_PROGRAM_UPDATE_DATE
455: ,NEW_REFERENCES.ACAD_HONOR_TYPE
456: );
457: IF (x_mode = 'S') THEN
458: igs_sc_gen_001.unset_ctx('R');
459: END IF;
460:
461: open c;
462: fetch c into X_ROWID;

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

474: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
475: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
476: fnd_message.set_token ('ERR_CD', SQLCODE);
477: igs_ge_msg_stack.add;
478: igs_sc_gen_001.unset_ctx('R');
479: app_exception.raise_exception;
480: ELSE
481: igs_sc_gen_001.unset_ctx('R');
482: RAISE;

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

477: igs_ge_msg_stack.add;
478: igs_sc_gen_001.unset_ctx('R');
479: app_exception.raise_exception;
480: ELSE
481: igs_sc_gen_001.unset_ctx('R');
482: RAISE;
483: END IF;
484:
485: end INSERT_ROW;

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

614: end if;
615: end if;
616:
617: IF (x_mode = 'S') THEN
618: igs_sc_gen_001.set_ctx('R');
619: END IF;
620: update igs_pe_acad_honors set
621: PERSON_ID = NEW_REFERENCES.PERSON_ID,
622: ACAD_HONOR_TYPE = NEW_REFERENCES.ACAD_HONOR_TYPE,--CHANGED HERE

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

632: where ROWID = X_ROWID;
633: if (sql%notfound) then
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
635: igs_ge_msg_stack.add;
636: igs_sc_gen_001.unset_ctx('R');
637: app_exception.raise_exception;
638: end if;
639: IF (x_mode = 'S') THEN
640: igs_sc_gen_001.unset_ctx('R');

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

636: igs_sc_gen_001.unset_ctx('R');
637: app_exception.raise_exception;
638: end if;
639: IF (x_mode = 'S') THEN
640: igs_sc_gen_001.unset_ctx('R');
641: END IF;
642:
643:
644: After_DML (

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

650: IF (SQLCODE = (-28115)) THEN
651: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
652: fnd_message.set_token ('ERR_CD', SQLCODE);
653: igs_ge_msg_stack.add;
654: igs_sc_gen_001.unset_ctx('R');
655: app_exception.raise_exception;
656: ELSE
657: igs_sc_gen_001.unset_ctx('R');
658: RAISE;

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

653: igs_ge_msg_stack.add;
654: igs_sc_gen_001.unset_ctx('R');
655: app_exception.raise_exception;
656: ELSE
657: igs_sc_gen_001.unset_ctx('R');
658: RAISE;
659: END IF;
660:
661: end UPDATE_ROW;

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

727: p_action => 'DELETE',
728: x_rowid => X_ROWID,
729: );*/
730: IF (x_mode = 'S') THEN
731: igs_sc_gen_001.set_ctx('R');
732: END IF;
733: delete from igs_pe_acad_honors
734: where ROWID = X_ROWID;
735: if (sql%notfound) then

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

734: where ROWID = X_ROWID;
735: if (sql%notfound) then
736: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
737: igs_ge_msg_stack.add;
738: igs_sc_gen_001.unset_ctx('R');
739: app_exception.raise_exception;
740: end if;
741: IF (x_mode = 'S') THEN
742: igs_sc_gen_001.unset_ctx('R');

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

738: igs_sc_gen_001.unset_ctx('R');
739: app_exception.raise_exception;
740: end if;
741: IF (x_mode = 'S') THEN
742: igs_sc_gen_001.unset_ctx('R');
743: END IF;
744:
745: After_DML (
746: p_action => 'DELETE',