APPS.IGS_PE_SN_CONTACT_PKG dependencies on IGS_SC_GEN_001

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

376: x_last_update_login => x_last_update_login
377: );
378:
379: IF (x_mode = 'S') THEN
380: igs_sc_gen_001.set_ctx('R');
381: END IF;
382: INSERT INTO igs_pe_sn_contact (
383: sn_contact_id,
384: disability_id,

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

402: x_last_updated_by,
403: x_last_update_login
404: );
405: IF (x_mode = 'S') THEN
406: igs_sc_gen_001.unset_ctx('R');
407: END IF;
408:
409:
410: OPEN c;

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

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

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

424: igs_ge_msg_stack.add;
425: igs_sc_gen_001.unset_ctx('R');
426: app_exception.raise_exception;
427: ELSE
428: igs_sc_gen_001.unset_ctx('R');
429: RAISE;
430: END IF;
431: END insert_row;
432:

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

549: x_last_update_login => x_last_update_login
550: );
551:
552: IF (x_mode = 'S') THEN
553: igs_sc_gen_001.set_ctx('R');
554: END IF;
555: UPDATE igs_pe_sn_contact
556: SET
557: disability_id = new_references.disability_id,

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

565:
566: IF (SQL%NOTFOUND) THEN
567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
568: igs_ge_msg_stack.add;
569: igs_sc_gen_001.unset_ctx('R');
570: app_exception.raise_exception;
571: END IF;
572: IF (x_mode = 'S') THEN
573: igs_sc_gen_001.unset_ctx('R');

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

569: igs_sc_gen_001.unset_ctx('R');
570: app_exception.raise_exception;
571: END IF;
572: IF (x_mode = 'S') THEN
573: igs_sc_gen_001.unset_ctx('R');
574: END IF;
575:
576:
577:

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

580: IF (SQLCODE = (-28115)) THEN
581: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
582: fnd_message.set_token ('ERR_CD', SQLCODE);
583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: ELSE
587: igs_sc_gen_001.unset_ctx('R');
588: RAISE;

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

583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: ELSE
587: igs_sc_gen_001.unset_ctx('R');
588: RAISE;
589: END IF;
590: END update_row;
591:

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

666: x_rowid => x_rowid
667: );
668:
669: IF (x_mode = 'S') THEN
670: igs_sc_gen_001.set_ctx('R');
671: END IF;
672: DELETE FROM igs_pe_sn_contact
673: WHERE rowid = x_rowid;
674:

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

674:
675: IF (SQL%NOTFOUND) THEN
676: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
677: igs_ge_msg_stack.add;
678: igs_sc_gen_001.unset_ctx('R');
679: app_exception.raise_exception;
680: END IF;
681: IF (x_mode = 'S') THEN
682: igs_sc_gen_001.unset_ctx('R');

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

678: igs_sc_gen_001.unset_ctx('R');
679: app_exception.raise_exception;
680: END IF;
681: IF (x_mode = 'S') THEN
682: igs_sc_gen_001.unset_ctx('R');
683: END IF;
684:
685:
686: END delete_row;