APPS.IGS_PE_HLTH_INS_PKG dependencies on IGS_SC_GEN_001

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

720: x_last_updated_by =>X_LAST_UPDATED_BY,
721: x_last_update_login =>X_LAST_UPDATE_LOGIN,
722: x_insurance_cd => X_INSURANCE_CD);
723: IF (x_mode = 'S') THEN
724: igs_sc_gen_001.set_ctx('R');
725: END IF;
726: insert into IGS_PE_HLTH_INS_ALL (
727: HEALTH_INS_ID
728: ,PERSON_ID

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

794: ,X_LAST_UPDATE_LOGIN
795: ,NEW_REFERENCES.INSURANCE_CD
796: );
797: IF (x_mode = 'S') THEN
798: igs_sc_gen_001.unset_ctx('R');
799: END IF;
800:
801: open c;
802: fetch c into X_ROWID;

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

813: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
814: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
815: fnd_message.set_token ('ERR_CD', SQLCODE);
816: igs_ge_msg_stack.add;
817: igs_sc_gen_001.unset_ctx('R');
818: app_exception.raise_exception;
819: ELSE
820: igs_sc_gen_001.unset_ctx('R');
821: RAISE;

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

816: igs_ge_msg_stack.add;
817: igs_sc_gen_001.unset_ctx('R');
818: app_exception.raise_exception;
819: ELSE
820: igs_sc_gen_001.unset_ctx('R');
821: RAISE;
822: END IF;
823:
824: end INSERT_ROW;

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

1100: x_last_updated_by=>X_LAST_UPDATED_BY,
1101: x_last_update_login=>X_LAST_UPDATE_LOGIN,
1102: x_insurance_cd=>X_INSURANCE_CD );
1103: IF (x_mode = 'S') THEN
1104: igs_sc_gen_001.set_ctx('R');
1105: END IF;
1106: update IGS_PE_HLTH_INS_ALL set
1107: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1108: INSURANCE_PROVIDER = NEW_REFERENCES.INSURANCE_PROVIDER,

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

1137: where ROWID = X_ROWID;
1138: if (sql%notfound) then
1139: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1140: igs_ge_msg_stack.add;
1141: igs_sc_gen_001.unset_ctx('R');
1142: app_exception.raise_exception;
1143: end if;
1144: IF (x_mode = 'S') THEN
1145: igs_sc_gen_001.unset_ctx('R');

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

1141: igs_sc_gen_001.unset_ctx('R');
1142: app_exception.raise_exception;
1143: end if;
1144: IF (x_mode = 'S') THEN
1145: igs_sc_gen_001.unset_ctx('R');
1146: END IF;
1147:
1148:
1149: After_DML (

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

1155: IF (SQLCODE = (-28115)) THEN
1156: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1157: fnd_message.set_token ('ERR_CD', SQLCODE);
1158: igs_ge_msg_stack.add;
1159: igs_sc_gen_001.unset_ctx('R');
1160: app_exception.raise_exception;
1161: ELSE
1162: igs_sc_gen_001.unset_ctx('R');
1163: RAISE;

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

1158: igs_ge_msg_stack.add;
1159: igs_sc_gen_001.unset_ctx('R');
1160: app_exception.raise_exception;
1161: ELSE
1162: igs_sc_gen_001.unset_ctx('R');
1163: RAISE;
1164: END IF;
1165:
1166: end UPDATE_ROW;

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

1313: p_action => 'DELETE',
1314: x_rowid => X_ROWID
1315: );
1316: IF (x_mode = 'S') THEN
1317: igs_sc_gen_001.set_ctx('R');
1318: END IF;
1319: delete from IGS_PE_HLTH_INS_ALL
1320: where ROWID = X_ROWID;
1321: if (sql%notfound) then

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

1320: where ROWID = X_ROWID;
1321: if (sql%notfound) then
1322: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1323: igs_ge_msg_stack.add;
1324: igs_sc_gen_001.unset_ctx('R');
1325: app_exception.raise_exception;
1326: end if;
1327: IF (x_mode = 'S') THEN
1328: igs_sc_gen_001.unset_ctx('R');

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

1324: igs_sc_gen_001.unset_ctx('R');
1325: app_exception.raise_exception;
1326: end if;
1327: IF (x_mode = 'S') THEN
1328: igs_sc_gen_001.unset_ctx('R');
1329: END IF;
1330:
1331: After_DML (
1332: p_action => 'DELETE',