DBA Data[Home] [Help]

APPS.HZ_BANK_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

555: | MODIFICATION HISTORY |
556: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
557: +=======================================================================*/
558: PROCEDURE validate_edi_contact_point (
559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
561: x_return_status IN OUT NOCOPY VARCHAR2
562: ) IS
563: -- cursor used to determine uniqueness of the EDI contact point across

Line 560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,

556: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
557: +=======================================================================*/
558: PROCEDURE validate_edi_contact_point (
559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
561: x_return_status IN OUT NOCOPY VARCHAR2
562: ) IS
563: -- cursor used to determine uniqueness of the EDI contact point across
564: -- bank parties.

Line 636: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

632: BEGIN
633: hz_dyn_validation.validate_contact_point(
634: x_contact_point => p_contact_point_rec,
635: x_edi_contact => p_edi_rec,
636: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
637: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
638: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
639: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
640: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 637: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

633: hz_dyn_validation.validate_contact_point(
634: x_contact_point => p_contact_point_rec,
635: x_edi_contact => p_edi_rec,
636: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
637: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
638: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
639: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
640: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
641: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 638: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

634: x_contact_point => p_contact_point_rec,
635: x_edi_contact => p_edi_rec,
636: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
637: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
638: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
639: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
640: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
641: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
642: );

Line 639: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

635: x_edi_contact => p_edi_rec,
636: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
637: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
638: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
639: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
640: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
641: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
642: );
643: EXCEPTION

Line 640: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

636: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
637: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
638: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
639: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
640: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
641: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
642: );
643: EXCEPTION
644: WHEN hz_dyn_validation.null_profile_value THEN

Line 682: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

678: | MODIFICATION HISTORY |
679: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
680: +=======================================================================*/
681: PROCEDURE validate_eft_contact_point (
682: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
683: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
684: x_return_status IN OUT NOCOPY VARCHAR2
685: ) IS
686: l_debug_prefix VARCHAR2(30) := '';

Line 683: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,

679: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
680: +=======================================================================*/
681: PROCEDURE validate_eft_contact_point (
682: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
683: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
684: x_return_status IN OUT NOCOPY VARCHAR2
685: ) IS
686: l_debug_prefix VARCHAR2(30) := '';
687: BEGIN

Line 698: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

694:
695: BEGIN
696: hz_dyn_validation.validate_contact_point(
697: x_contact_point => p_contact_point_rec,
698: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
699: x_eft_contact => p_eft_rec,
700: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
701: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
702: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 700: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

696: hz_dyn_validation.validate_contact_point(
697: x_contact_point => p_contact_point_rec,
698: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
699: x_eft_contact => p_eft_rec,
700: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
701: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
702: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
703: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
704: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 701: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

697: x_contact_point => p_contact_point_rec,
698: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
699: x_eft_contact => p_eft_rec,
700: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
701: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
702: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
703: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
704: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
705: );

Line 702: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

698: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
699: x_eft_contact => p_eft_rec,
700: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
701: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
702: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
703: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
704: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
705: );
706: EXCEPTION

Line 703: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

699: x_eft_contact => p_eft_rec,
700: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
701: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
702: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
703: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
704: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
705: );
706: EXCEPTION
707: WHEN hz_dyn_validation.null_profile_value THEN

Line 745: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

741: | MODIFICATION HISTORY |
742: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
743: +=======================================================================*/
744: PROCEDURE validate_web_contact_point (
745: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
746: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
747: x_return_status IN OUT NOCOPY VARCHAR2
748: ) IS
749: l_debug_prefix VARCHAR2(30) := '';

Line 746: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

742: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
743: +=======================================================================*/
744: PROCEDURE validate_web_contact_point (
745: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
746: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
747: x_return_status IN OUT NOCOPY VARCHAR2
748: ) IS
749: l_debug_prefix VARCHAR2(30) := '';
750: BEGIN

Line 761: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

757:
758: BEGIN
759: hz_dyn_validation.validate_contact_point(
760: x_contact_point => p_contact_point_rec,
761: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
762: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
763: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
764: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
765: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 762: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

758: BEGIN
759: hz_dyn_validation.validate_contact_point(
760: x_contact_point => p_contact_point_rec,
761: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
762: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
763: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
764: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
765: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
766: x_web_contact => p_web_rec,

Line 763: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

759: hz_dyn_validation.validate_contact_point(
760: x_contact_point => p_contact_point_rec,
761: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
762: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
763: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
764: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
765: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
766: x_web_contact => p_web_rec,
767: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 764: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

760: x_contact_point => p_contact_point_rec,
761: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
762: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
763: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
764: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
765: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
766: x_web_contact => p_web_rec,
767: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
768: );

Line 765: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

761: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
762: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
763: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
764: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
765: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
766: x_web_contact => p_web_rec,
767: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
768: );
769: EXCEPTION

Line 809: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

805: | MODIFICATION HISTORY |
806: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
807: +=======================================================================*/
808: PROCEDURE validate_phone_contact_point (
809: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
810: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
811: x_return_status IN OUT NOCOPY VARCHAR2
812: ) IS
813: l_debug_prefix VARCHAR2(30) := '';

Line 810: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,

806: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
807: +=======================================================================*/
808: PROCEDURE validate_phone_contact_point (
809: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
810: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
811: x_return_status IN OUT NOCOPY VARCHAR2
812: ) IS
813: l_debug_prefix VARCHAR2(30) := '';
814: BEGIN

Line 825: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

821:
822: BEGIN
823: hz_dyn_validation.validate_contact_point(
824: x_contact_point => p_contact_point_rec,
825: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
826: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
827: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
828: x_phone_contact => p_phone_rec,
829: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 826: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

822: BEGIN
823: hz_dyn_validation.validate_contact_point(
824: x_contact_point => p_contact_point_rec,
825: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
826: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
827: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
828: x_phone_contact => p_phone_rec,
829: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
830: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 827: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

823: hz_dyn_validation.validate_contact_point(
824: x_contact_point => p_contact_point_rec,
825: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
826: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
827: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
828: x_phone_contact => p_phone_rec,
829: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
830: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
831: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 829: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

825: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
826: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
827: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
828: x_phone_contact => p_phone_rec,
829: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
830: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
831: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
832: );
833: EXCEPTION

Line 830: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

826: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
827: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
828: x_phone_contact => p_phone_rec,
829: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
830: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
831: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
832: );
833: EXCEPTION
834: WHEN hz_dyn_validation.null_profile_value THEN

Line 873: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

869: | MODIFICATION HISTORY |
870: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
871: +=======================================================================*/
872: PROCEDURE validate_email_contact_point (
873: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
874: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
875: x_return_status IN OUT NOCOPY VARCHAR2
876: ) IS
877: l_debug_prefix VARCHAR2(30) := '';

Line 874: p_email_rec IN hz_contact_point_v2pub.email_rec_type,

870: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
871: +=======================================================================*/
872: PROCEDURE validate_email_contact_point (
873: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
874: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
875: x_return_status IN OUT NOCOPY VARCHAR2
876: ) IS
877: l_debug_prefix VARCHAR2(30) := '';
878: BEGIN

Line 889: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

885:
886: BEGIN
887: hz_dyn_validation.validate_contact_point(
888: x_contact_point => p_contact_point_rec,
889: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
890: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
891: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
892: x_email_contact => p_email_rec,
893: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 890: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

886: BEGIN
887: hz_dyn_validation.validate_contact_point(
888: x_contact_point => p_contact_point_rec,
889: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
890: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
891: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
892: x_email_contact => p_email_rec,
893: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
894: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 891: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

887: hz_dyn_validation.validate_contact_point(
888: x_contact_point => p_contact_point_rec,
889: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
890: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
891: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
892: x_email_contact => p_email_rec,
893: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
894: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
895: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 893: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

889: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
890: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
891: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
892: x_email_contact => p_email_rec,
893: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
894: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
895: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
896: );
897: EXCEPTION

Line 894: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

890: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
891: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
892: x_email_contact => p_email_rec,
893: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
894: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
895: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
896: );
897: EXCEPTION
898: WHEN hz_dyn_validation.null_profile_value THEN

Line 936: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

932: | MODIFICATION HISTORY |
933: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
934: +=======================================================================*/
935: PROCEDURE validate_telex_contact_point (
936: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
937: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
938: x_return_status IN OUT NOCOPY VARCHAR2
939: ) IS
940: l_debug_prefix VARCHAR2(30) := '';

Line 937: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,

933: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
934: +=======================================================================*/
935: PROCEDURE validate_telex_contact_point (
936: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
937: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
938: x_return_status IN OUT NOCOPY VARCHAR2
939: ) IS
940: l_debug_prefix VARCHAR2(30) := '';
941: BEGIN

Line 952: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

948:
949: BEGIN
950: hz_dyn_validation.validate_contact_point(
951: x_contact_point => p_contact_point_rec,
952: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
953: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
954: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
955: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
956: x_telex_contact => p_telex_rec,

Line 953: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

949: BEGIN
950: hz_dyn_validation.validate_contact_point(
951: x_contact_point => p_contact_point_rec,
952: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
953: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
954: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
955: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
956: x_telex_contact => p_telex_rec,
957: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 954: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

950: hz_dyn_validation.validate_contact_point(
951: x_contact_point => p_contact_point_rec,
952: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
953: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
954: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
955: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
956: x_telex_contact => p_telex_rec,
957: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
958: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 955: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

951: x_contact_point => p_contact_point_rec,
952: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
953: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
954: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
955: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
956: x_telex_contact => p_telex_rec,
957: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
958: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
959: );

Line 957: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

953: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
954: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
955: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
956: x_telex_contact => p_telex_rec,
957: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
958: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
959: );
960: EXCEPTION
961: WHEN hz_dyn_validation.null_profile_value THEN

Line 5016: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5012: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5013: +=======================================================================*/
5014: PROCEDURE create_edi_contact_point (
5015: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5016: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5017: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5018: := hz_contact_point_v2pub.g_miss_edi_rec,
5019: x_contact_point_id OUT NOCOPY NUMBER,
5020: x_return_status OUT NOCOPY VARCHAR2,

Line 5017: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type

5013: +=======================================================================*/
5014: PROCEDURE create_edi_contact_point (
5015: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5016: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5017: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5018: := hz_contact_point_v2pub.g_miss_edi_rec,
5019: x_contact_point_id OUT NOCOPY NUMBER,
5020: x_return_status OUT NOCOPY VARCHAR2,
5021: x_msg_count OUT NOCOPY NUMBER,

Line 5018: := hz_contact_point_v2pub.g_miss_edi_rec,

5014: PROCEDURE create_edi_contact_point (
5015: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5016: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5017: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5018: := hz_contact_point_v2pub.g_miss_edi_rec,
5019: x_contact_point_id OUT NOCOPY NUMBER,
5020: x_return_status OUT NOCOPY VARCHAR2,
5021: x_msg_count OUT NOCOPY NUMBER,
5022: x_msg_data OUT NOCOPY VARCHAR2

Line 5057: hz_contact_point_v2pub.create_edi_contact_point(

5053: RAISE fnd_api.g_exc_error;
5054: END IF;
5055:
5056: -- create the EDI contact point
5057: hz_contact_point_v2pub.create_edi_contact_point(
5058: p_init_msg_list => fnd_api.g_false,
5059: p_contact_point_rec => p_contact_point_rec,
5060: p_edi_rec => p_edi_rec,
5061: x_contact_point_id => x_contact_point_id,

Line 5188: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5184: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5185: +=======================================================================*/
5186: PROCEDURE update_edi_contact_point (
5187: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5188: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5189: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5190: := hz_contact_point_v2pub.g_miss_edi_rec,
5191: p_object_version_number IN OUT NOCOPY NUMBER,
5192: x_return_status OUT NOCOPY VARCHAR2,

Line 5189: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type

5185: +=======================================================================*/
5186: PROCEDURE update_edi_contact_point (
5187: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5188: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5189: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5190: := hz_contact_point_v2pub.g_miss_edi_rec,
5191: p_object_version_number IN OUT NOCOPY NUMBER,
5192: x_return_status OUT NOCOPY VARCHAR2,
5193: x_msg_count OUT NOCOPY NUMBER,

Line 5190: := hz_contact_point_v2pub.g_miss_edi_rec,

5186: PROCEDURE update_edi_contact_point (
5187: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5188: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5189: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5190: := hz_contact_point_v2pub.g_miss_edi_rec,
5191: p_object_version_number IN OUT NOCOPY NUMBER,
5192: x_return_status OUT NOCOPY VARCHAR2,
5193: x_msg_count OUT NOCOPY NUMBER,
5194: x_msg_data OUT NOCOPY VARCHAR2

Line 5229: hz_contact_point_v2pub.update_edi_contact_point(

5225: RAISE fnd_api.g_exc_error;
5226: END IF;
5227:
5228: -- update the EDI contact point
5229: hz_contact_point_v2pub.update_edi_contact_point(
5230: p_init_msg_list => fnd_api.g_false,
5231: p_contact_point_rec => p_contact_point_rec,
5232: p_edi_rec => p_edi_rec,
5233: p_object_version_number => p_object_version_number,

Line 5360: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5356: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5357: +=======================================================================*/
5358: PROCEDURE create_eft_contact_point (
5359: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5360: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5361: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5362: := hz_contact_point_v2pub.g_miss_eft_rec,
5363: x_contact_point_id OUT NOCOPY NUMBER,
5364: x_return_status OUT NOCOPY VARCHAR2,

Line 5361: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type

5357: +=======================================================================*/
5358: PROCEDURE create_eft_contact_point (
5359: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5360: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5361: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5362: := hz_contact_point_v2pub.g_miss_eft_rec,
5363: x_contact_point_id OUT NOCOPY NUMBER,
5364: x_return_status OUT NOCOPY VARCHAR2,
5365: x_msg_count OUT NOCOPY NUMBER,

Line 5362: := hz_contact_point_v2pub.g_miss_eft_rec,

5358: PROCEDURE create_eft_contact_point (
5359: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5360: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5361: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5362: := hz_contact_point_v2pub.g_miss_eft_rec,
5363: x_contact_point_id OUT NOCOPY NUMBER,
5364: x_return_status OUT NOCOPY VARCHAR2,
5365: x_msg_count OUT NOCOPY NUMBER,
5366: x_msg_data OUT NOCOPY VARCHAR2

Line 5401: hz_contact_point_v2pub.create_eft_contact_point(

5397: RAISE fnd_api.g_exc_error;
5398: END IF;
5399:
5400: -- create the EFT contact point
5401: hz_contact_point_v2pub.create_eft_contact_point(
5402: p_init_msg_list => fnd_api.g_false,
5403: p_contact_point_rec => p_contact_point_rec,
5404: p_eft_rec => p_eft_rec,
5405: x_contact_point_id => x_contact_point_id,

Line 5532: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5528: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5529: +=======================================================================*/
5530: PROCEDURE update_eft_contact_point (
5531: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5532: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5533: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5534: := hz_contact_point_v2pub.g_miss_eft_rec,
5535: p_object_version_number IN OUT NOCOPY NUMBER,
5536: x_return_status OUT NOCOPY VARCHAR2,

Line 5533: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type

5529: +=======================================================================*/
5530: PROCEDURE update_eft_contact_point (
5531: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5532: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5533: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5534: := hz_contact_point_v2pub.g_miss_eft_rec,
5535: p_object_version_number IN OUT NOCOPY NUMBER,
5536: x_return_status OUT NOCOPY VARCHAR2,
5537: x_msg_count OUT NOCOPY NUMBER,

Line 5534: := hz_contact_point_v2pub.g_miss_eft_rec,

5530: PROCEDURE update_eft_contact_point (
5531: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5532: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5533: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5534: := hz_contact_point_v2pub.g_miss_eft_rec,
5535: p_object_version_number IN OUT NOCOPY NUMBER,
5536: x_return_status OUT NOCOPY VARCHAR2,
5537: x_msg_count OUT NOCOPY NUMBER,
5538: x_msg_data OUT NOCOPY VARCHAR2

Line 5573: hz_contact_point_v2pub.update_eft_contact_point(

5569: RAISE fnd_api.g_exc_error;
5570: END IF;
5571:
5572: -- update the EFT contact point
5573: hz_contact_point_v2pub.update_eft_contact_point(
5574: p_init_msg_list => fnd_api.g_false,
5575: p_contact_point_rec => p_contact_point_rec,
5576: p_eft_rec => p_eft_rec,
5577: p_object_version_number => p_object_version_number,

Line 5704: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5700: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5701: +=======================================================================*/
5702: PROCEDURE create_web_contact_point (
5703: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5704: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5705: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5706: := hz_contact_point_v2pub.g_miss_web_rec,
5707: x_contact_point_id OUT NOCOPY NUMBER,
5708: x_return_status OUT NOCOPY VARCHAR2,

Line 5705: p_web_rec IN hz_contact_point_v2pub.web_rec_type

5701: +=======================================================================*/
5702: PROCEDURE create_web_contact_point (
5703: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5704: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5705: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5706: := hz_contact_point_v2pub.g_miss_web_rec,
5707: x_contact_point_id OUT NOCOPY NUMBER,
5708: x_return_status OUT NOCOPY VARCHAR2,
5709: x_msg_count OUT NOCOPY NUMBER,

Line 5706: := hz_contact_point_v2pub.g_miss_web_rec,

5702: PROCEDURE create_web_contact_point (
5703: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5704: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5705: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5706: := hz_contact_point_v2pub.g_miss_web_rec,
5707: x_contact_point_id OUT NOCOPY NUMBER,
5708: x_return_status OUT NOCOPY VARCHAR2,
5709: x_msg_count OUT NOCOPY NUMBER,
5710: x_msg_data OUT NOCOPY VARCHAR2

Line 5745: hz_contact_point_v2pub.create_web_contact_point(

5741: RAISE fnd_api.g_exc_error;
5742: END IF;
5743:
5744: -- create the WEB contact point
5745: hz_contact_point_v2pub.create_web_contact_point(
5746: p_init_msg_list => fnd_api.g_false,
5747: p_contact_point_rec => p_contact_point_rec,
5748: p_web_rec => p_web_rec,
5749: x_contact_point_id => x_contact_point_id,

Line 5876: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5872: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5873: +=======================================================================*/
5874: PROCEDURE update_web_contact_point (
5875: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5876: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5877: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5878: := hz_contact_point_v2pub.g_miss_web_rec,
5879: p_object_version_number IN OUT NOCOPY NUMBER,
5880: x_return_status OUT NOCOPY VARCHAR2,

Line 5877: p_web_rec IN hz_contact_point_v2pub.web_rec_type

5873: +=======================================================================*/
5874: PROCEDURE update_web_contact_point (
5875: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5876: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5877: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5878: := hz_contact_point_v2pub.g_miss_web_rec,
5879: p_object_version_number IN OUT NOCOPY NUMBER,
5880: x_return_status OUT NOCOPY VARCHAR2,
5881: x_msg_count OUT NOCOPY NUMBER,

Line 5878: := hz_contact_point_v2pub.g_miss_web_rec,

5874: PROCEDURE update_web_contact_point (
5875: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5876: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5877: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5878: := hz_contact_point_v2pub.g_miss_web_rec,
5879: p_object_version_number IN OUT NOCOPY NUMBER,
5880: x_return_status OUT NOCOPY VARCHAR2,
5881: x_msg_count OUT NOCOPY NUMBER,
5882: x_msg_data OUT NOCOPY VARCHAR2

Line 5917: hz_contact_point_v2pub.update_web_contact_point(

5913: RAISE fnd_api.g_exc_error;
5914: END IF;
5915:
5916: -- update the WEB contact point
5917: hz_contact_point_v2pub.update_web_contact_point(
5918: p_init_msg_list => fnd_api.g_false,
5919: p_contact_point_rec => p_contact_point_rec,
5920: p_web_rec => p_web_rec,
5921: p_object_version_number => p_object_version_number,

Line 6048: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6044: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6045: +=======================================================================*/
6046: PROCEDURE create_phone_contact_point (
6047: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6048: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6049: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6050: := hz_contact_point_v2pub.g_miss_phone_rec,
6051: x_contact_point_id OUT NOCOPY NUMBER,
6052: x_return_status OUT NOCOPY VARCHAR2,

Line 6049: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type

6045: +=======================================================================*/
6046: PROCEDURE create_phone_contact_point (
6047: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6048: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6049: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6050: := hz_contact_point_v2pub.g_miss_phone_rec,
6051: x_contact_point_id OUT NOCOPY NUMBER,
6052: x_return_status OUT NOCOPY VARCHAR2,
6053: x_msg_count OUT NOCOPY NUMBER,

Line 6050: := hz_contact_point_v2pub.g_miss_phone_rec,

6046: PROCEDURE create_phone_contact_point (
6047: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6048: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6049: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6050: := hz_contact_point_v2pub.g_miss_phone_rec,
6051: x_contact_point_id OUT NOCOPY NUMBER,
6052: x_return_status OUT NOCOPY VARCHAR2,
6053: x_msg_count OUT NOCOPY NUMBER,
6054: x_msg_data OUT NOCOPY VARCHAR2

Line 6089: hz_contact_point_v2pub.create_phone_contact_point(

6085: RAISE fnd_api.g_exc_error;
6086: END IF;
6087:
6088: -- create the Phone contact point
6089: hz_contact_point_v2pub.create_phone_contact_point(
6090: p_init_msg_list => fnd_api.g_false,
6091: p_contact_point_rec => p_contact_point_rec,
6092: p_phone_rec => p_phone_rec,
6093: x_contact_point_id => x_contact_point_id,

Line 6220: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6216: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6217: +=======================================================================*/
6218: PROCEDURE update_phone_contact_point (
6219: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6220: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6221: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6222: := hz_contact_point_v2pub.g_miss_phone_rec,
6223: p_object_version_number IN OUT NOCOPY NUMBER,
6224: x_return_status OUT NOCOPY VARCHAR2,

Line 6221: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type

6217: +=======================================================================*/
6218: PROCEDURE update_phone_contact_point (
6219: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6220: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6221: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6222: := hz_contact_point_v2pub.g_miss_phone_rec,
6223: p_object_version_number IN OUT NOCOPY NUMBER,
6224: x_return_status OUT NOCOPY VARCHAR2,
6225: x_msg_count OUT NOCOPY NUMBER,

Line 6222: := hz_contact_point_v2pub.g_miss_phone_rec,

6218: PROCEDURE update_phone_contact_point (
6219: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6220: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6221: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6222: := hz_contact_point_v2pub.g_miss_phone_rec,
6223: p_object_version_number IN OUT NOCOPY NUMBER,
6224: x_return_status OUT NOCOPY VARCHAR2,
6225: x_msg_count OUT NOCOPY NUMBER,
6226: x_msg_data OUT NOCOPY VARCHAR2

Line 6261: hz_contact_point_v2pub.update_phone_contact_point(

6257: RAISE fnd_api.g_exc_error;
6258: END IF;
6259:
6260: -- update the Phone contact point
6261: hz_contact_point_v2pub.update_phone_contact_point(
6262: p_init_msg_list => fnd_api.g_false,
6263: p_contact_point_rec => p_contact_point_rec,
6264: p_phone_rec => p_phone_rec,
6265: p_object_version_number => p_object_version_number,

Line 6392: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6388: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6389: +=======================================================================*/
6390: PROCEDURE create_email_contact_point (
6391: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6392: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6393: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6394: := hz_contact_point_v2pub.g_miss_email_rec,
6395: x_contact_point_id OUT NOCOPY NUMBER,
6396: x_return_status OUT NOCOPY VARCHAR2,

Line 6393: p_email_rec IN hz_contact_point_v2pub.email_rec_type

6389: +=======================================================================*/
6390: PROCEDURE create_email_contact_point (
6391: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6392: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6393: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6394: := hz_contact_point_v2pub.g_miss_email_rec,
6395: x_contact_point_id OUT NOCOPY NUMBER,
6396: x_return_status OUT NOCOPY VARCHAR2,
6397: x_msg_count OUT NOCOPY NUMBER,

Line 6394: := hz_contact_point_v2pub.g_miss_email_rec,

6390: PROCEDURE create_email_contact_point (
6391: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6392: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6393: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6394: := hz_contact_point_v2pub.g_miss_email_rec,
6395: x_contact_point_id OUT NOCOPY NUMBER,
6396: x_return_status OUT NOCOPY VARCHAR2,
6397: x_msg_count OUT NOCOPY NUMBER,
6398: x_msg_data OUT NOCOPY VARCHAR2

Line 6433: hz_contact_point_v2pub.create_email_contact_point(

6429: RAISE fnd_api.g_exc_error;
6430: END IF;
6431:
6432: -- create the Email contact point
6433: hz_contact_point_v2pub.create_email_contact_point(
6434: p_init_msg_list => fnd_api.g_false,
6435: p_contact_point_rec => p_contact_point_rec,
6436: p_email_rec => p_email_rec,
6437: x_contact_point_id => x_contact_point_id,

Line 6564: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6560: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6561: +=======================================================================*/
6562: PROCEDURE update_email_contact_point (
6563: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6564: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6565: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6566: := hz_contact_point_v2pub.g_miss_email_rec,
6567: p_object_version_number IN OUT NOCOPY NUMBER,
6568: x_return_status OUT NOCOPY VARCHAR2,

Line 6565: p_email_rec IN hz_contact_point_v2pub.email_rec_type

6561: +=======================================================================*/
6562: PROCEDURE update_email_contact_point (
6563: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6564: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6565: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6566: := hz_contact_point_v2pub.g_miss_email_rec,
6567: p_object_version_number IN OUT NOCOPY NUMBER,
6568: x_return_status OUT NOCOPY VARCHAR2,
6569: x_msg_count OUT NOCOPY NUMBER,

Line 6566: := hz_contact_point_v2pub.g_miss_email_rec,

6562: PROCEDURE update_email_contact_point (
6563: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6564: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6565: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6566: := hz_contact_point_v2pub.g_miss_email_rec,
6567: p_object_version_number IN OUT NOCOPY NUMBER,
6568: x_return_status OUT NOCOPY VARCHAR2,
6569: x_msg_count OUT NOCOPY NUMBER,
6570: x_msg_data OUT NOCOPY VARCHAR2

Line 6605: hz_contact_point_v2pub.update_email_contact_point(

6601: RAISE fnd_api.g_exc_error;
6602: END IF;
6603:
6604: -- update the Email contact point
6605: hz_contact_point_v2pub.update_email_contact_point(
6606: p_init_msg_list => fnd_api.g_false,
6607: p_contact_point_rec => p_contact_point_rec,
6608: p_email_rec => p_email_rec,
6609: p_object_version_number => p_object_version_number,

Line 6736: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6732: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6733: +=======================================================================*/
6734: PROCEDURE create_telex_contact_point (
6735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6736: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6737: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6738: := hz_contact_point_v2pub.g_miss_telex_rec,
6739: x_contact_point_id OUT NOCOPY NUMBER,
6740: x_return_status OUT NOCOPY VARCHAR2,

Line 6737: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type

6733: +=======================================================================*/
6734: PROCEDURE create_telex_contact_point (
6735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6736: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6737: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6738: := hz_contact_point_v2pub.g_miss_telex_rec,
6739: x_contact_point_id OUT NOCOPY NUMBER,
6740: x_return_status OUT NOCOPY VARCHAR2,
6741: x_msg_count OUT NOCOPY NUMBER,

Line 6738: := hz_contact_point_v2pub.g_miss_telex_rec,

6734: PROCEDURE create_telex_contact_point (
6735: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6736: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6737: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6738: := hz_contact_point_v2pub.g_miss_telex_rec,
6739: x_contact_point_id OUT NOCOPY NUMBER,
6740: x_return_status OUT NOCOPY VARCHAR2,
6741: x_msg_count OUT NOCOPY NUMBER,
6742: x_msg_data OUT NOCOPY VARCHAR2

Line 6777: hz_contact_point_v2pub.create_telex_contact_point(

6773: RAISE fnd_api.g_exc_error;
6774: END IF;
6775:
6776: -- create the Telex contact point
6777: hz_contact_point_v2pub.create_telex_contact_point(
6778: p_init_msg_list => fnd_api.g_false,
6779: p_contact_point_rec => p_contact_point_rec,
6780: p_telex_rec => p_telex_rec,
6781: x_contact_point_id => x_contact_point_id,

Line 6908: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6904: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6905: +=======================================================================*/
6906: PROCEDURE update_telex_contact_point (
6907: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6908: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6909: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6910: := hz_contact_point_v2pub.g_miss_telex_rec,
6911: p_object_version_number IN OUT NOCOPY NUMBER,
6912: x_return_status OUT NOCOPY VARCHAR2,

Line 6909: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type

6905: +=======================================================================*/
6906: PROCEDURE update_telex_contact_point (
6907: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6908: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6909: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6910: := hz_contact_point_v2pub.g_miss_telex_rec,
6911: p_object_version_number IN OUT NOCOPY NUMBER,
6912: x_return_status OUT NOCOPY VARCHAR2,
6913: x_msg_count OUT NOCOPY NUMBER,

Line 6910: := hz_contact_point_v2pub.g_miss_telex_rec,

6906: PROCEDURE update_telex_contact_point (
6907: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6908: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6909: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6910: := hz_contact_point_v2pub.g_miss_telex_rec,
6911: p_object_version_number IN OUT NOCOPY NUMBER,
6912: x_return_status OUT NOCOPY VARCHAR2,
6913: x_msg_count OUT NOCOPY NUMBER,
6914: x_msg_data OUT NOCOPY VARCHAR2

Line 6950: hz_contact_point_v2pub.update_telex_contact_point(

6946: RAISE fnd_api.g_exc_error;
6947: END IF;
6948:
6949: -- update the Telex contact point
6950: hz_contact_point_v2pub.update_telex_contact_point(
6951: p_init_msg_list => fnd_api.g_false,
6952: p_contact_point_rec => p_contact_point_rec,
6953: p_telex_rec => p_telex_rec,
6954: p_object_version_number => p_object_version_number,