107: l_phone_extension HZ_CONTACT_POINTS.phone_extension%type;
108: l_profile_id number;
109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
114:
115: X_Return_Status VARCHAR2 (20);
108: l_profile_id number;
109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
114:
115: X_Return_Status VARCHAR2 (20);
116: X_Msg_Count NUMBER;
109:
110:
111: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
112: l_email_rec HZ_CONTACT_POINT_V2PUB.EMAIL_REC_TYPE;
113: l_phone_rec HZ_CONTACT_POINT_V2PUB.PHONE_REC_TYPE;
114:
115: X_Return_Status VARCHAR2 (20);
116: X_Msg_Count NUMBER;
117: X_Msg_data VARCHAR2 (300);
149: l_email_rec.email_format := l_email_format;
150:
151:
152:
153: HZ_CONTACT_POINT_V2PUB.create_contact_point (
154: p_contact_point_rec => l_contact_point_rec,
155: p_email_rec => l_email_rec,
156: x_contact_point_id => l_contact_point_id,
157: x_return_status => X_Return_Status,
182: l_phone_rec.phone_country_code := l_country_code;
183: l_phone_rec.phone_extension := l_phone_extension;
184: l_phone_rec.phone_line_type := 'GEN';
185:
186: HZ_CONTACT_POINT_V2PUB.create_contact_point (
187: p_contact_point_rec => l_contact_point_rec,
188: p_phone_rec => l_phone_rec,
189: x_contact_point_id => l_contact_point_id,
190: x_return_status => X_Return_Status,