APPS.IGS_PE_HZ_PARTIES_PKG dependencies on IGS_SC_GEN_001

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

692: x_last_update_login => x_last_update_login,
693: x_felony_convicted_flag => x_felony_convicted_flag
694: );
695: IF (x_mode = 'S') THEN
696: igs_sc_gen_001.set_ctx('R');
697: END IF;
698:
699:
700: INSERT INTO igs_pe_hz_parties (

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

800: new_references.oss_org_unit_cd,
801: new_references.felony_convicted_flag
802: );
803: IF (x_mode = 'S') THEN
804: igs_sc_gen_001.unset_ctx('R');
805: END IF;
806:
807: OPEN c;
808: FETCH c INTO x_rowid;

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

818: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
819: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
820: fnd_message.set_token ('ERR_CD', SQLCODE);
821: igs_ge_msg_stack.add;
822: igs_sc_gen_001.unset_ctx('R');
823: app_exception.raise_exception;
824: ELSE
825: igs_sc_gen_001.unset_ctx('R');
826: RAISE;

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

821: igs_ge_msg_stack.add;
822: igs_sc_gen_001.unset_ctx('R');
823: app_exception.raise_exception;
824: ELSE
825: igs_sc_gen_001.unset_ctx('R');
826: RAISE;
827: END IF;
828: END insert_row;
829:

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

1144: END IF;
1145: END IF;
1146:
1147: IF (x_mode = 'S') THEN
1148: igs_sc_gen_001.set_ctx('R');
1149: END IF;
1150: UPDATE igs_pe_hz_parties
1151: SET
1152: deceased_ind = new_references.deceased_ind,

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

1200:
1201: IF (SQL%NOTFOUND) THEN
1202: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1203: igs_ge_msg_stack.add;
1204: igs_sc_gen_001.unset_ctx('R');
1205: app_exception.raise_exception;
1206: END IF;
1207: IF (x_mode = 'S') THEN
1208: igs_sc_gen_001.unset_ctx('R');

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

1204: igs_sc_gen_001.unset_ctx('R');
1205: app_exception.raise_exception;
1206: END IF;
1207: IF (x_mode = 'S') THEN
1208: igs_sc_gen_001.unset_ctx('R');
1209: END IF;
1210:
1211:
1212:

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

1215: IF (SQLCODE = (-28115)) THEN
1216: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1217: fnd_message.set_token ('ERR_CD', SQLCODE);
1218: igs_ge_msg_stack.add;
1219: igs_sc_gen_001.unset_ctx('R');
1220: app_exception.raise_exception;
1221: ELSE
1222: igs_sc_gen_001.unset_ctx('R');
1223: RAISE;

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

1218: igs_ge_msg_stack.add;
1219: igs_sc_gen_001.unset_ctx('R');
1220: app_exception.raise_exception;
1221: ELSE
1222: igs_sc_gen_001.unset_ctx('R');
1223: RAISE;
1224: END IF;
1225: END update_row;
1226:

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

1409: x_rowid => x_rowid
1410: );
1411:
1412: IF (x_mode = 'S') THEN
1413: igs_sc_gen_001.set_ctx('R');
1414: END IF;
1415: DELETE FROM igs_pe_hz_parties
1416: WHERE rowid = x_rowid;
1417:

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

1417:
1418: IF (SQL%NOTFOUND) THEN
1419: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1420: igs_ge_msg_stack.add;
1421: igs_sc_gen_001.unset_ctx('R');
1422: app_exception.raise_exception;
1423: END IF;
1424: IF (x_mode = 'S') THEN
1425: igs_sc_gen_001.unset_ctx('R');

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

1421: igs_sc_gen_001.unset_ctx('R');
1422: app_exception.raise_exception;
1423: END IF;
1424: IF (x_mode = 'S') THEN
1425: igs_sc_gen_001.unset_ctx('R');
1426: END IF;
1427:
1428:
1429: END delete_row;