31: l_rec l_cur%ROWTYPE;
32: l_found BOOLEAN;
33:
34: l_contact_point_id NUMBER;
35: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
36: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
37:
38: BEGIN
39:
32: l_found BOOLEAN;
33:
34: l_contact_point_id NUMBER;
35: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
36: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
37:
38: BEGIN
39:
40: OPEN l_cur;
97: l_rec.object_version_number := p_phone_object_version_number;
98: END IF;
99: --End for Bug 6620664
100:
101: hz_contact_point_v2pub.update_contact_point
102: (p_init_msg_list => fnd_api.g_false,
103: p_contact_point_rec => l_contact_points_rec,
104: p_phone_rec => l_phone_rec,
105: p_object_version_number => l_rec.object_version_number,
109: );
110:
111: pos_log.log_call_result
112: (p_module => 'POSADMB',
113: p_prefix => 'call hz_contact_point_v2pub.update_contact_point',
114: p_return_status => x_return_status,
115: p_msg_count => x_msg_count,
116: p_msg_data => x_msg_data
117: );
130: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
131: l_contact_points_rec.application_id := 177;
132: l_contact_points_rec.primary_flag := 'Y';
133:
134: hz_contact_point_v2pub.create_contact_point
135: ( p_init_msg_list => fnd_api.g_false,
136: p_contact_point_rec => l_contact_points_rec,
137: p_phone_rec => l_phone_rec,
138: x_contact_point_id => l_contact_point_id,
142: );
143:
144: pos_log.log_call_result
145: (p_module => 'POSADMB',
146: p_prefix => 'call hz_contact_point_v2pub.create_contact_point',
147: p_return_status => x_return_status,
148: p_msg_count => x_msg_count,
149: p_msg_data => x_msg_data
150: );
183: l_rec l_cur%ROWTYPE;
184: l_found BOOLEAN;
185:
186: l_contact_point_id NUMBER;
187: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
188: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
189:
190: BEGIN
191:
184: l_found BOOLEAN;
185:
186: l_contact_point_id NUMBER;
187: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
188: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
189:
190: BEGIN
191:
192: OPEN l_cur;
246: l_rec.object_version_number := p_fax_object_version_number;
247: END IF;
248: --End for Bug 6620664
249:
250: hz_contact_point_v2pub.update_contact_point
251: (p_init_msg_list => fnd_api.g_false,
252: p_contact_point_rec => l_contact_points_rec,
253: p_phone_rec => l_phone_rec,
254: p_object_version_number => l_rec.object_version_number,
270: l_contact_points_rec.owner_table_id := p_owner_table_id;
271: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
272: l_contact_points_rec.application_id := 177;
273:
274: hz_contact_point_v2pub.create_contact_point
275: ( p_init_msg_list => fnd_api.g_false,
276: p_contact_point_rec => l_contact_points_rec,
277: p_phone_rec => l_phone_rec,
278: x_contact_point_id => l_contact_point_id,
311: l_rec l_cur%ROWTYPE;
312: l_found BOOLEAN;
313:
314: l_contact_point_id NUMBER;
315: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
316: l_email_rec hz_contact_point_v2pub.email_rec_type;
317:
318: BEGIN
319: OPEN l_cur;
312: l_found BOOLEAN;
313:
314: l_contact_point_id NUMBER;
315: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
316: l_email_rec hz_contact_point_v2pub.email_rec_type;
317:
318: BEGIN
319: OPEN l_cur;
320: FETCH l_cur INTO l_rec;
352: l_rec.object_version_number := p_email_object_version_number;
353: END IF;
354: --End for Bug 6620664
355:
356: hz_contact_point_v2pub.update_contact_point
357: (p_init_msg_list => fnd_api.g_false,
358: p_contact_point_rec => l_contact_points_rec,
359: p_email_rec => l_email_rec,
360: p_object_version_number => l_rec.object_version_number,
373: l_contact_points_rec.owner_table_id := p_owner_table_id;
374: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
375: l_contact_points_rec.application_id := 177;
376:
377: hz_contact_point_v2pub.create_contact_point
378: ( p_init_msg_list => fnd_api.g_false,
379: p_contact_point_rec => l_contact_points_rec,
380: p_email_rec => l_email_rec,
381: x_contact_point_id => l_contact_point_id,
417: l_rec l_cur%ROWTYPE;
418: l_found BOOLEAN;
419:
420: l_contact_point_id NUMBER;
421: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
422: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
423:
424: BEGIN
425:
418: l_found BOOLEAN;
419:
420: l_contact_point_id NUMBER;
421: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
422: l_phone_rec hz_contact_point_v2pub.phone_rec_type;
423:
424: BEGIN
425:
426: OPEN l_cur;
480: IF p_phone_object_version_number <> fnd_api.G_NULL_NUM THEN
481: l_rec.object_version_number := p_phone_object_version_number;
482: END IF;
483:
484: hz_contact_point_v2pub.update_contact_point
485: (p_init_msg_list => fnd_api.g_false,
486: p_contact_point_rec => l_contact_points_rec,
487: p_phone_rec => l_phone_rec,
488: p_object_version_number => l_rec.object_version_number,
492: );
493:
494: pos_log.log_call_result
495: (p_module => 'POSADMB',
496: p_prefix => 'call hz_contact_point_v2pub.update_contact_point',
497: p_return_status => x_return_status,
498: p_msg_count => x_msg_count,
499: p_msg_data => x_msg_data
500: );
513: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
514: l_contact_points_rec.application_id := 177;
515: l_contact_points_rec.primary_flag := 'N';
516:
517: hz_contact_point_v2pub.create_contact_point
518: ( p_init_msg_list => fnd_api.g_false,
519: p_contact_point_rec => l_contact_points_rec,
520: p_phone_rec => l_phone_rec,
521: x_contact_point_id => l_contact_point_id,
525: );
526:
527: pos_log.log_call_result
528: (p_module => 'POSADMB',
529: p_prefix => 'call hz_contact_point_v2pub.create_contact_point',
530: p_return_status => x_return_status,
531: p_msg_count => x_msg_count,
532: p_msg_data => x_msg_data
533: );
559: l_rec l_cur%ROWTYPE;
560: l_found BOOLEAN;
561:
562: l_contact_point_id NUMBER;
563: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
564: l_url_rec hz_contact_point_v2pub.web_rec_type;
565:
566: BEGIN
567: OPEN l_cur;
560: l_found BOOLEAN;
561:
562: l_contact_point_id NUMBER;
563: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
564: l_url_rec hz_contact_point_v2pub.web_rec_type;
565:
566: BEGIN
567: OPEN l_cur;
568: FETCH l_cur INTO l_rec;
597: IF p_url_object_version_number <> fnd_api.G_NULL_NUM THEN
598: l_rec.object_version_number := p_url_object_version_number;
599: END IF;
600:
601: hz_contact_point_v2pub.update_contact_point
602: (p_init_msg_list => fnd_api.g_false,
603: p_contact_point_rec => l_contact_points_rec,
604: p_web_rec => l_url_rec,
605: p_object_version_number => l_rec.object_version_number,
617: l_contact_points_rec.owner_table_id := p_owner_table_id;
618: l_contact_points_rec.created_by_module := 'POS_SUPPLIER_MGMT';
619: l_contact_points_rec.application_id := 177;
620:
621: hz_contact_point_v2pub.create_contact_point
622: ( p_init_msg_list => fnd_api.g_false,
623: p_contact_point_rec => l_contact_points_rec,
624: p_web_rec => l_url_rec,
625: x_contact_point_id => l_contact_point_id,