88: */
89: l_msg_data VARCHAR2(2000);
90: l_msg_count NUMBER;
91:
92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
89: l_msg_data VARCHAR2(2000);
90: l_msg_count NUMBER;
91:
92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;
90: l_msg_count NUMBER;
91:
92: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
93: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
94: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
95: l_return_status VARCHAR2(25);
96: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
97: l_chk_email hz_parties.email_address%TYPE;
98:
131: IF l_chk_email IS NULL THEN
132: -- new e-mail needs to be created
133: p_contact_points_rec.primary_flag := NULL;
134:
135: HZ_CONTACT_POINT_V2PUB.create_contact_point(
136: p_init_msg_list => FND_API.G_FALSE,
137: p_contact_point_rec => p_contact_points_rec,
138: p_email_rec => p_email_rec,
139: p_phone_rec => p_phone_rec,
177: */
178: l_msg_data VARCHAR2(2000);
179: l_msg_count NUMBER;
180:
181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
178: l_msg_data VARCHAR2(2000);
179: l_msg_count NUMBER;
180:
181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
186: BEGIN
179: l_msg_count NUMBER;
180:
181: p_contact_points_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
182: p_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := NULL;
183: p_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
184: l_return_status VARCHAR2(25);
185: l_contact_point_id hz_contact_points.contact_point_id%TYPE := NULL;
186: BEGIN
187:
197: p_contact_points_rec.primary_flag := NULL;
198: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
199: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_profile_matching_pkg.create_email_address.debug','Before creating Email Address' );
200: END IF;
201: HZ_CONTACT_POINT_V2PUB.create_contact_point(
202: p_init_msg_list => FND_API.G_FALSE,
203: p_contact_point_rec => p_contact_points_rec,
204: p_email_rec => p_email_rec,
205: p_phone_rec => p_phone_rec,