APPS.IGS_PE_HEARING_DTLS_PKG dependencies on IGS_SC_GEN_001

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

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: INSERT INTO igs_pe_hearing_dtls (
381: hearing_details_id,
382: person_id,

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

406: x_last_updated_by,
407: x_last_update_login
408: );
409: IF (x_mode = 'S') THEN
410: igs_sc_gen_001.unset_ctx('R');
411: END IF;
412:
413:
414: OPEN c;

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

425: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
426: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
427: fnd_message.set_token ('ERR_CD', SQLCODE);
428: igs_ge_msg_stack.add;
429: igs_sc_gen_001.unset_ctx('R');
430: app_exception.raise_exception;
431: ELSE
432: igs_sc_gen_001.unset_ctx('R');
433: RAISE;

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

428: igs_ge_msg_stack.add;
429: igs_sc_gen_001.unset_ctx('R');
430: app_exception.raise_exception;
431: ELSE
432: igs_sc_gen_001.unset_ctx('R');
433: RAISE;
434: END IF;
435: END insert_row;
436:

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

568: x_last_update_login => x_last_update_login
569: );
570:
571: IF (x_mode = 'S') THEN
572: igs_sc_gen_001.set_ctx('R');
573: END IF;
574: UPDATE igs_pe_hearing_dtls
575: SET
576: person_id = new_references.person_id,

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

587:
588: IF (SQL%NOTFOUND) THEN
589: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
590: igs_ge_msg_stack.add;
591: igs_sc_gen_001.unset_ctx('R');
592: app_exception.raise_exception;
593: END IF;
594: IF (x_mode = 'S') THEN
595: igs_sc_gen_001.unset_ctx('R');

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

591: igs_sc_gen_001.unset_ctx('R');
592: app_exception.raise_exception;
593: END IF;
594: IF (x_mode = 'S') THEN
595: igs_sc_gen_001.unset_ctx('R');
596: END IF;
597:
598:
599:

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

602: IF (SQLCODE = (-28115)) THEN
603: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
604: fnd_message.set_token ('ERR_CD', SQLCODE);
605: igs_ge_msg_stack.add;
606: igs_sc_gen_001.unset_ctx('R');
607: app_exception.raise_exception;
608: ELSE
609: igs_sc_gen_001.unset_ctx('R');
610: RAISE;

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

605: igs_ge_msg_stack.add;
606: igs_sc_gen_001.unset_ctx('R');
607: app_exception.raise_exception;
608: ELSE
609: igs_sc_gen_001.unset_ctx('R');
610: RAISE;
611: END IF;
612: END update_row;
613:

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

697: x_rowid => x_rowid
698: );
699:
700: IF (x_mode = 'S') THEN
701: igs_sc_gen_001.set_ctx('R');
702: END IF;
703: DELETE FROM igs_pe_hearing_dtls
704: WHERE rowid = x_rowid;
705:

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

705:
706: IF (SQL%NOTFOUND) THEN
707: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
708: igs_ge_msg_stack.add;
709: igs_sc_gen_001.unset_ctx('R');
710: app_exception.raise_exception;
711: END IF;
712: IF (x_mode = 'S') THEN
713: igs_sc_gen_001.unset_ctx('R');

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

709: igs_sc_gen_001.unset_ctx('R');
710: app_exception.raise_exception;
711: END IF;
712: IF (x_mode = 'S') THEN
713: igs_sc_gen_001.unset_ctx('R');
714: END IF;
715:
716:
717: END delete_row;