APPS.IGS_PE_CONTACT_DTLS_PKG dependencies on IGS_SC_GEN_001

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

556: x_last_update_login => x_last_update_login
557: );
558:
559: IF (x_mode = 'S') THEN
560: igs_sc_gen_001.set_ctx('R');
561: END IF;
562: INSERT INTO igs_pe_contact_dtls (
563: phone_line_type
564: ,contact_point_id

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

648: ,x_program_application_id
649: ,x_program_update_date
650: );
651: IF (x_mode = 'S') THEN
652: igs_sc_gen_001.unset_ctx('R');
653: END IF;
654:
655:
656: OPEN c;

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

672: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
673: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
674: fnd_message.set_token ('ERR_CD', SQLCODE);
675: igs_ge_msg_stack.add;
676: igs_sc_gen_001.unset_ctx('R');
677: app_exception.raise_exception;
678: ELSE
679: igs_sc_gen_001.unset_ctx('R');
680: RAISE;

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

675: igs_ge_msg_stack.add;
676: igs_sc_gen_001.unset_ctx('R');
677: app_exception.raise_exception;
678: ELSE
679: igs_sc_gen_001.unset_ctx('R');
680: RAISE;
681: END IF;
682: END insert_row;
683:

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

1021: END IF;
1022: END IF;
1023:
1024: IF (x_mode = 'S') THEN
1025: igs_sc_gen_001.set_ctx('R');
1026: END IF;
1027: UPDATE igs_pe_contact_dtls SET
1028: phone_line_type = new_references.phone_line_type,
1029: location_venue_addr_id = new_references.location_venue_addr_id,

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

1069:
1070: IF (SQL%NOTFOUND) THEN
1071: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1072: igs_ge_msg_stack.add;
1073: igs_sc_gen_001.unset_ctx('R');
1074: app_exception.raise_exception;
1075: END IF;
1076: IF (x_mode = 'S') THEN
1077: igs_sc_gen_001.unset_ctx('R');

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

1073: igs_sc_gen_001.unset_ctx('R');
1074: app_exception.raise_exception;
1075: END IF;
1076: IF (x_mode = 'S') THEN
1077: igs_sc_gen_001.unset_ctx('R');
1078: END IF;
1079:
1080:
1081: after_dml (

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

1089: IF (SQLCODE = (-28115)) THEN
1090: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1091: fnd_message.set_token ('ERR_CD', SQLCODE);
1092: igs_ge_msg_stack.add;
1093: igs_sc_gen_001.unset_ctx('R');
1094: app_exception.raise_exception;
1095: ELSE
1096: igs_sc_gen_001.unset_ctx('R');
1097: RAISE;

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

1092: igs_ge_msg_stack.add;
1093: igs_sc_gen_001.unset_ctx('R');
1094: app_exception.raise_exception;
1095: ELSE
1096: igs_sc_gen_001.unset_ctx('R');
1097: RAISE;
1098: END IF;
1099: END update_row;
1100:

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

1259: x_rowid => X_ROWID
1260: );
1261:
1262: IF (x_mode = 'S') THEN
1263: igs_sc_gen_001.set_ctx('R');
1264: END IF;
1265: DELETE FROM igs_pe_contact_dtls
1266: WHERE ROWID = x_rowid;
1267:

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

1267:
1268: IF (SQL%NOTFOUND) THEN
1269: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1270: igs_ge_msg_stack.add;
1271: igs_sc_gen_001.unset_ctx('R');
1272: app_exception.raise_exception;
1273: END IF;
1274: IF (x_mode = 'S') THEN
1275: igs_sc_gen_001.unset_ctx('R');

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

1271: igs_sc_gen_001.unset_ctx('R');
1272: app_exception.raise_exception;
1273: END IF;
1274: IF (x_mode = 'S') THEN
1275: igs_sc_gen_001.unset_ctx('R');
1276: END IF;
1277:
1278:
1279: after_dml (