[Home] [Help]
585:
586: -- Select the nextval from sequence for contact point
587: Select hz_contact_points_s.nextval
588: Into l_contact_points_rec.contact_point_id
589: From dual;
590:
591: If p_contact_point_type = 'EMAIL' Then
592:
593: l_email_rec.email_address := p_email;
2734: -- { Start of duplicate check for contact
2735: -- concatenate to get name of contact
2736: Select contact_rec.person_last_name || DECODE(contact_rec.person_first_name, NULL, NULL, ', '|| contact_rec.PERSON_FIRST_NAME) || DECODE(contact_rec.Person_Name_Suffix, NULL, NULL, ', '||contact_rec.Person_Name_Suffix)
2737: Into l_contact_name
2738: From Dual;
2739:
2740: -- { Start of If for duplicate contact check
2741: If l_type_of_contact = 'SOLD_TO' Then
2742: l_sold_to_contact := Oe_Value_To_Id.Sold_To_Contact(
2867: oe_debug_pub.add( 'BEFORE SELECTING NEXTVAL FROM PARTY SEQUENCE' ) ;
2868: END IF;
2869: Select hz_party_number_s.nextval
2870: Into l_party_rec.party_number
2871: From Dual;
2872: IF l_debug_level > 0 THEN
2873: oe_debug_pub.add( 'AFTER SELECTING NEW PARTY SEQUENCE ' || L_PARTY_REC.PARTY_NUMBER ) ;
2874: END IF;
2875: End If; -- If G_AUTO_PARTY_NUMBERING
2924: oe_debug_pub.add( 'BEFORE SELECTING NEXTVAL FROM PARTY SEQUENCE FOR ORG' ) ;
2925: END IF;
2926: Select hz_party_number_s.nextval
2927: Into l_org_contact_rec.party_rel_rec.party_rec.party_number
2928: From Dual;
2929: IF l_debug_level > 0 THEN
2930: oe_debug_pub.add( 'AFTER SELECTING NEW PARTY SEQUENCE ' || L_ORG_CONTACT_REC.PARTY_REL_REC.PARTY_REC.PARTY_NUMBER ) ;
2931: END IF;
2932: End If; -- If G_AUTO_PARTY_NUMBERING
2954: oe_debug_pub.add( 'BEFORE SELECTING NEXTVAL FROM CONTACT SEQ' ) ;
2955: END IF;
2956: Select hz_contact_numbers_s.nextval
2957: Into l_org_contact_rec.contact_number
2958: From Dual;
2959: IF l_debug_level > 0 THEN
2960: oe_debug_pub.add( 'AFTER SELECTING NEW CONTACT SEQUENCE ' || L_ORG_CONTACT_REC.CONTACT_NUMBER ) ;
2961: END IF;
2962: End If; -- If G_AUTO_CONTACT_NUMBERING