508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: END IF;
511:
512: SELECT igs_pe_contact_dtls_s.nextval INTO x_contact_point_id
513: FROM dual;
514:
515: before_dml(
516: p_action => 'INSERT',
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,
1030: contact_point_type = new_references.contact_point_type,
1031: status = new_references.status,