APPS.IGS_PE_SN_SERVICE_PKG dependencies on IGS_SC_GEN_001

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

402: x_last_update_login => x_last_update_login
403: );
404:
405: IF (x_mode = 'S') THEN
406: igs_sc_gen_001.set_ctx('R');
407: END IF;
408: INSERT INTO igs_pe_sn_service (
409: sn_service_id,
410: disability_id,

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

430: x_last_updated_by,
431: x_last_update_login
432: );
433: IF (x_mode = 'S') THEN
434: igs_sc_gen_001.unset_ctx('R');
435: END IF;
436:
437:
438: OPEN c;

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

449: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
450: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
451: fnd_message.set_token ('ERR_CD', SQLCODE);
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: ELSE
456: igs_sc_gen_001.unset_ctx('R');
457: RAISE;

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

452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: ELSE
456: igs_sc_gen_001.unset_ctx('R');
457: RAISE;
458: END IF;
459: END insert_row;
460:

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

592: x_last_update_login => x_last_update_login
593: );
594:
595: IF (x_mode = 'S') THEN
596: igs_sc_gen_001.set_ctx('R');
597: END IF;
598: UPDATE igs_pe_sn_service
599: SET
600: disability_id = new_references.disability_id,

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

609:
610: IF (SQL%NOTFOUND) THEN
611: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
612: igs_ge_msg_stack.add;
613: igs_sc_gen_001.unset_ctx('R');
614: app_exception.raise_exception;
615: END IF;
616: IF (x_mode = 'S') THEN
617: igs_sc_gen_001.unset_ctx('R');

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

613: igs_sc_gen_001.unset_ctx('R');
614: app_exception.raise_exception;
615: END IF;
616: IF (x_mode = 'S') THEN
617: igs_sc_gen_001.unset_ctx('R');
618: END IF;
619:
620:
621:

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

624: IF (SQLCODE = (-28115)) THEN
625: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
626: fnd_message.set_token ('ERR_CD', SQLCODE);
627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: ELSE
631: igs_sc_gen_001.unset_ctx('R');
632: RAISE;

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

627: igs_ge_msg_stack.add;
628: igs_sc_gen_001.unset_ctx('R');
629: app_exception.raise_exception;
630: ELSE
631: igs_sc_gen_001.unset_ctx('R');
632: RAISE;
633: END IF;
634: END update_row;
635:

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

713: x_rowid => x_rowid
714: );
715:
716: IF (x_mode = 'S') THEN
717: igs_sc_gen_001.set_ctx('R');
718: END IF;
719: DELETE FROM igs_pe_sn_service
720: WHERE rowid = x_rowid;
721:

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

721:
722: IF (SQL%NOTFOUND) THEN
723: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
724: igs_ge_msg_stack.add;
725: igs_sc_gen_001.unset_ctx('R');
726: app_exception.raise_exception;
727: END IF;
728: IF (x_mode = 'S') THEN
729: igs_sc_gen_001.unset_ctx('R');

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

725: igs_sc_gen_001.unset_ctx('R');
726: app_exception.raise_exception;
727: END IF;
728: IF (x_mode = 'S') THEN
729: igs_sc_gen_001.unset_ctx('R');
730: END IF;
731:
732:
733: END delete_row;