952: l_party_id NUMBER;
953: l_party_number NUMBER;
954: l_contact_point_id NUMBER;
955: l_old_relationship_id NUMBER;
956: l_contact_point_rec HZ_CONTACT_POINT_v2pub.CONTACT_POINT_REC_TYPE;
957: l_edi_rec HZ_CONTACT_POINT_v2pub.EDI_REC_TYPE;
958: l_email_rec HZ_CONTACT_POINT_v2pub.EMAIL_REC_TYPE;
959: l_phone_rec HZ_CONTACT_POINT_v2pub.PHONE_REC_TYPE;
960: l_telex_rec HZ_CONTACT_POINT_v2pub.TELEX_REC_TYPE;
953: l_party_number NUMBER;
954: l_contact_point_id NUMBER;
955: l_old_relationship_id NUMBER;
956: l_contact_point_rec HZ_CONTACT_POINT_v2pub.CONTACT_POINT_REC_TYPE;
957: l_edi_rec HZ_CONTACT_POINT_v2pub.EDI_REC_TYPE;
958: l_email_rec HZ_CONTACT_POINT_v2pub.EMAIL_REC_TYPE;
959: l_phone_rec HZ_CONTACT_POINT_v2pub.PHONE_REC_TYPE;
960: l_telex_rec HZ_CONTACT_POINT_v2pub.TELEX_REC_TYPE;
961: l_web_rec HZ_CONTACT_POINT_v2pub.WEB_REC_TYPE;
954: l_contact_point_id NUMBER;
955: l_old_relationship_id NUMBER;
956: l_contact_point_rec HZ_CONTACT_POINT_v2pub.CONTACT_POINT_REC_TYPE;
957: l_edi_rec HZ_CONTACT_POINT_v2pub.EDI_REC_TYPE;
958: l_email_rec HZ_CONTACT_POINT_v2pub.EMAIL_REC_TYPE;
959: l_phone_rec HZ_CONTACT_POINT_v2pub.PHONE_REC_TYPE;
960: l_telex_rec HZ_CONTACT_POINT_v2pub.TELEX_REC_TYPE;
961: l_web_rec HZ_CONTACT_POINT_v2pub.WEB_REC_TYPE;
962: l_object_version_number NUMBER;
955: l_old_relationship_id NUMBER;
956: l_contact_point_rec HZ_CONTACT_POINT_v2pub.CONTACT_POINT_REC_TYPE;
957: l_edi_rec HZ_CONTACT_POINT_v2pub.EDI_REC_TYPE;
958: l_email_rec HZ_CONTACT_POINT_v2pub.EMAIL_REC_TYPE;
959: l_phone_rec HZ_CONTACT_POINT_v2pub.PHONE_REC_TYPE;
960: l_telex_rec HZ_CONTACT_POINT_v2pub.TELEX_REC_TYPE;
961: l_web_rec HZ_CONTACT_POINT_v2pub.WEB_REC_TYPE;
962: l_object_version_number NUMBER;
963: l_party_object_version_number NUMBER;
956: l_contact_point_rec HZ_CONTACT_POINT_v2pub.CONTACT_POINT_REC_TYPE;
957: l_edi_rec HZ_CONTACT_POINT_v2pub.EDI_REC_TYPE;
958: l_email_rec HZ_CONTACT_POINT_v2pub.EMAIL_REC_TYPE;
959: l_phone_rec HZ_CONTACT_POINT_v2pub.PHONE_REC_TYPE;
960: l_telex_rec HZ_CONTACT_POINT_v2pub.TELEX_REC_TYPE;
961: l_web_rec HZ_CONTACT_POINT_v2pub.WEB_REC_TYPE;
962: l_object_version_number NUMBER;
963: l_party_object_version_number NUMBER;
964: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
957: l_edi_rec HZ_CONTACT_POINT_v2pub.EDI_REC_TYPE;
958: l_email_rec HZ_CONTACT_POINT_v2pub.EMAIL_REC_TYPE;
959: l_phone_rec HZ_CONTACT_POINT_v2pub.PHONE_REC_TYPE;
960: l_telex_rec HZ_CONTACT_POINT_v2pub.TELEX_REC_TYPE;
961: l_web_rec HZ_CONTACT_POINT_v2pub.WEB_REC_TYPE;
962: l_object_version_number NUMBER;
963: l_party_object_version_number NUMBER;
964: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
965: l_org_contact_id NUMBER;
1298: l_contact_point_rec.owner_table_id := l_party_id;
1299: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
1300:
1301: -- Creation of new contact points with new party_id
1302: hz_contact_point_v2pub.Create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,
1303: l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,
1304: x_return_status,x_msg_count,x_msg_data);
1305: FND_FILE.Put_Line(FND_FILE.Log,'x_return_status: '||x_return_status);
1306:
1550: l_contact_point_rec.owner_table_id := p_to_party_site_id;
1551: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
1552:
1553: -- Creation of new contact points with new party_site_id
1554: hz_contact_point_v2pub.Create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,
1555: l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,
1556: x_return_status,x_msg_count,x_msg_data);
1557: FND_FILE.Put_Line(FND_FILE.Log,'x_return_status: '||x_return_status);
1558: