DBA Data[Home] [Help]

APPS.HZ_BANK_PUB dependencies on HZ_CONTACT_POINT_V2PUB

Line 571: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

567: | MODIFICATION HISTORY |
568: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
569: +=======================================================================*/
570: PROCEDURE validate_edi_contact_point (
571: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
572: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
573: x_return_status IN OUT NOCOPY VARCHAR2
574: ) IS
575: -- cursor used to determine uniqueness of the EDI contact point across

Line 572: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,

568: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
569: +=======================================================================*/
570: PROCEDURE validate_edi_contact_point (
571: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
572: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type,
573: x_return_status IN OUT NOCOPY VARCHAR2
574: ) IS
575: -- cursor used to determine uniqueness of the EDI contact point across
576: -- bank parties.

Line 648: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

644: BEGIN
645: hz_dyn_validation.validate_contact_point(
646: x_contact_point => p_contact_point_rec,
647: x_edi_contact => p_edi_rec,
648: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
649: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
650: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
651: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
652: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 649: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

645: hz_dyn_validation.validate_contact_point(
646: x_contact_point => p_contact_point_rec,
647: x_edi_contact => p_edi_rec,
648: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
649: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
650: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
651: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
652: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
653: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 650: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

646: x_contact_point => p_contact_point_rec,
647: x_edi_contact => p_edi_rec,
648: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
649: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
650: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
651: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
652: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
653: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
654: );

Line 651: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

647: x_edi_contact => p_edi_rec,
648: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
649: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
650: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
651: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
652: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
653: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
654: );
655: EXCEPTION

Line 652: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

648: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
649: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
650: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
651: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
652: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
653: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
654: );
655: EXCEPTION
656: WHEN hz_dyn_validation.null_profile_value THEN

Line 694: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

690: | MODIFICATION HISTORY |
691: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
692: +=======================================================================*/
693: PROCEDURE validate_eft_contact_point (
694: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
695: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
696: x_return_status IN OUT NOCOPY VARCHAR2
697: ) IS
698: l_debug_prefix VARCHAR2(30) := '';

Line 695: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,

691: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
692: +=======================================================================*/
693: PROCEDURE validate_eft_contact_point (
694: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
695: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type,
696: x_return_status IN OUT NOCOPY VARCHAR2
697: ) IS
698: l_debug_prefix VARCHAR2(30) := '';
699: BEGIN

Line 710: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

706:
707: BEGIN
708: hz_dyn_validation.validate_contact_point(
709: x_contact_point => p_contact_point_rec,
710: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
711: x_eft_contact => p_eft_rec,
712: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
713: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
714: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 712: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

708: hz_dyn_validation.validate_contact_point(
709: x_contact_point => p_contact_point_rec,
710: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
711: x_eft_contact => p_eft_rec,
712: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
713: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
714: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
715: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
716: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 713: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

709: x_contact_point => p_contact_point_rec,
710: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
711: x_eft_contact => p_eft_rec,
712: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
713: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
714: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
715: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
716: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
717: );

Line 714: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

710: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
711: x_eft_contact => p_eft_rec,
712: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
713: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
714: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
715: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
716: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
717: );
718: EXCEPTION

Line 715: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

711: x_eft_contact => p_eft_rec,
712: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
713: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
714: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
715: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
716: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
717: );
718: EXCEPTION
719: WHEN hz_dyn_validation.null_profile_value THEN

Line 757: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

753: | MODIFICATION HISTORY |
754: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
755: +=======================================================================*/
756: PROCEDURE validate_web_contact_point (
757: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
758: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
759: x_return_status IN OUT NOCOPY VARCHAR2
760: ) IS
761: l_debug_prefix VARCHAR2(30) := '';

Line 758: p_web_rec IN hz_contact_point_v2pub.web_rec_type,

754: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
755: +=======================================================================*/
756: PROCEDURE validate_web_contact_point (
757: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
758: p_web_rec IN hz_contact_point_v2pub.web_rec_type,
759: x_return_status IN OUT NOCOPY VARCHAR2
760: ) IS
761: l_debug_prefix VARCHAR2(30) := '';
762: BEGIN

Line 773: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

769:
770: BEGIN
771: hz_dyn_validation.validate_contact_point(
772: x_contact_point => p_contact_point_rec,
773: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
774: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
775: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
776: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
777: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 774: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

770: BEGIN
771: hz_dyn_validation.validate_contact_point(
772: x_contact_point => p_contact_point_rec,
773: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
774: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
775: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
776: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
777: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
778: x_web_contact => p_web_rec,

Line 775: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

771: hz_dyn_validation.validate_contact_point(
772: x_contact_point => p_contact_point_rec,
773: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
774: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
775: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
776: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
777: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
778: x_web_contact => p_web_rec,
779: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 776: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

772: x_contact_point => p_contact_point_rec,
773: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
774: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
775: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
776: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
777: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
778: x_web_contact => p_web_rec,
779: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
780: );

Line 777: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

773: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
774: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
775: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
776: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
777: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
778: x_web_contact => p_web_rec,
779: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
780: );
781: EXCEPTION

Line 821: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

817: | MODIFICATION HISTORY |
818: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
819: +=======================================================================*/
820: PROCEDURE validate_phone_contact_point (
821: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
822: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
823: x_return_status IN OUT NOCOPY VARCHAR2
824: ) IS
825: l_debug_prefix VARCHAR2(30) := '';

Line 822: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,

818: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
819: +=======================================================================*/
820: PROCEDURE validate_phone_contact_point (
821: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
822: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type,
823: x_return_status IN OUT NOCOPY VARCHAR2
824: ) IS
825: l_debug_prefix VARCHAR2(30) := '';
826: BEGIN

Line 837: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

833:
834: BEGIN
835: hz_dyn_validation.validate_contact_point(
836: x_contact_point => p_contact_point_rec,
837: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
838: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
839: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
840: x_phone_contact => p_phone_rec,
841: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 838: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

834: BEGIN
835: hz_dyn_validation.validate_contact_point(
836: x_contact_point => p_contact_point_rec,
837: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
838: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
839: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
840: x_phone_contact => p_phone_rec,
841: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
842: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 839: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

835: hz_dyn_validation.validate_contact_point(
836: x_contact_point => p_contact_point_rec,
837: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
838: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
839: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
840: x_phone_contact => p_phone_rec,
841: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
842: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
843: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 841: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

837: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
838: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
839: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
840: x_phone_contact => p_phone_rec,
841: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
842: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
843: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
844: );
845: EXCEPTION

Line 842: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

838: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
839: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
840: x_phone_contact => p_phone_rec,
841: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
842: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
843: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
844: );
845: EXCEPTION
846: WHEN hz_dyn_validation.null_profile_value THEN

Line 885: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

881: | MODIFICATION HISTORY |
882: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
883: +=======================================================================*/
884: PROCEDURE validate_email_contact_point (
885: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
886: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
887: x_return_status IN OUT NOCOPY VARCHAR2
888: ) IS
889: l_debug_prefix VARCHAR2(30) := '';

Line 886: p_email_rec IN hz_contact_point_v2pub.email_rec_type,

882: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
883: +=======================================================================*/
884: PROCEDURE validate_email_contact_point (
885: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
886: p_email_rec IN hz_contact_point_v2pub.email_rec_type,
887: x_return_status IN OUT NOCOPY VARCHAR2
888: ) IS
889: l_debug_prefix VARCHAR2(30) := '';
890: BEGIN

Line 901: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

897:
898: BEGIN
899: hz_dyn_validation.validate_contact_point(
900: x_contact_point => p_contact_point_rec,
901: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
902: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
903: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
904: x_email_contact => p_email_rec,
905: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

Line 902: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

898: BEGIN
899: hz_dyn_validation.validate_contact_point(
900: x_contact_point => p_contact_point_rec,
901: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
902: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
903: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
904: x_email_contact => p_email_rec,
905: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
906: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 903: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

899: hz_dyn_validation.validate_contact_point(
900: x_contact_point => p_contact_point_rec,
901: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
902: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
903: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
904: x_email_contact => p_email_rec,
905: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
906: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
907: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 905: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,

901: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
902: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
903: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
904: x_email_contact => p_email_rec,
905: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
906: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
907: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
908: );
909: EXCEPTION

Line 906: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

902: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
903: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
904: x_email_contact => p_email_rec,
905: x_telex_contact => hz_contact_point_v2pub.g_miss_telex_rec,
906: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
907: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
908: );
909: EXCEPTION
910: WHEN hz_dyn_validation.null_profile_value THEN

Line 948: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

944: | MODIFICATION HISTORY |
945: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
946: +=======================================================================*/
947: PROCEDURE validate_telex_contact_point (
948: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
949: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
950: x_return_status IN OUT NOCOPY VARCHAR2
951: ) IS
952: l_debug_prefix VARCHAR2(30) := '';

Line 949: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,

945: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
946: +=======================================================================*/
947: PROCEDURE validate_telex_contact_point (
948: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
949: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type,
950: x_return_status IN OUT NOCOPY VARCHAR2
951: ) IS
952: l_debug_prefix VARCHAR2(30) := '';
953: BEGIN

Line 964: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,

960:
961: BEGIN
962: hz_dyn_validation.validate_contact_point(
963: x_contact_point => p_contact_point_rec,
964: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
965: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
966: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
967: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
968: x_telex_contact => p_telex_rec,

Line 965: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,

961: BEGIN
962: hz_dyn_validation.validate_contact_point(
963: x_contact_point => p_contact_point_rec,
964: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
965: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
966: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
967: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
968: x_telex_contact => p_telex_rec,
969: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

Line 966: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,

962: hz_dyn_validation.validate_contact_point(
963: x_contact_point => p_contact_point_rec,
964: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
965: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
966: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
967: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
968: x_telex_contact => p_telex_rec,
969: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
970: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'

Line 967: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,

963: x_contact_point => p_contact_point_rec,
964: x_edi_contact => hz_contact_point_v2pub.g_miss_edi_rec,
965: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
966: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
967: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
968: x_telex_contact => p_telex_rec,
969: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
970: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
971: );

Line 969: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,

965: x_eft_contact => hz_contact_point_v2pub.g_miss_eft_rec,
966: x_phone_contact => hz_contact_point_v2pub.g_miss_phone_rec,
967: x_email_contact => hz_contact_point_v2pub.g_miss_email_rec,
968: x_telex_contact => p_telex_rec,
969: x_web_contact => hz_contact_point_v2pub.g_miss_web_rec,
970: x_validation_profile => 'HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE'
971: );
972: EXCEPTION
973: WHEN hz_dyn_validation.null_profile_value THEN

Line 5039: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5035: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5036: +=======================================================================*/
5037: PROCEDURE create_edi_contact_point (
5038: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5039: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5040: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5041: := hz_contact_point_v2pub.g_miss_edi_rec,
5042: x_contact_point_id OUT NOCOPY NUMBER,
5043: x_return_status OUT NOCOPY VARCHAR2,

Line 5040: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type

5036: +=======================================================================*/
5037: PROCEDURE create_edi_contact_point (
5038: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5039: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5040: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5041: := hz_contact_point_v2pub.g_miss_edi_rec,
5042: x_contact_point_id OUT NOCOPY NUMBER,
5043: x_return_status OUT NOCOPY VARCHAR2,
5044: x_msg_count OUT NOCOPY NUMBER,

Line 5041: := hz_contact_point_v2pub.g_miss_edi_rec,

5037: PROCEDURE create_edi_contact_point (
5038: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5039: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5040: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5041: := hz_contact_point_v2pub.g_miss_edi_rec,
5042: x_contact_point_id OUT NOCOPY NUMBER,
5043: x_return_status OUT NOCOPY VARCHAR2,
5044: x_msg_count OUT NOCOPY NUMBER,
5045: x_msg_data OUT NOCOPY VARCHAR2

Line 5080: hz_contact_point_v2pub.create_edi_contact_point(

5076: RAISE fnd_api.g_exc_error;
5077: END IF;
5078:
5079: -- create the EDI contact point
5080: hz_contact_point_v2pub.create_edi_contact_point(
5081: p_init_msg_list => fnd_api.g_false,
5082: p_contact_point_rec => p_contact_point_rec,
5083: p_edi_rec => p_edi_rec,
5084: x_contact_point_id => x_contact_point_id,

Line 5211: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5207: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5208: +=======================================================================*/
5209: PROCEDURE update_edi_contact_point (
5210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5211: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5212: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5213: := hz_contact_point_v2pub.g_miss_edi_rec,
5214: p_object_version_number IN OUT NOCOPY NUMBER,
5215: x_return_status OUT NOCOPY VARCHAR2,

Line 5212: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type

5208: +=======================================================================*/
5209: PROCEDURE update_edi_contact_point (
5210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5211: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5212: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5213: := hz_contact_point_v2pub.g_miss_edi_rec,
5214: p_object_version_number IN OUT NOCOPY NUMBER,
5215: x_return_status OUT NOCOPY VARCHAR2,
5216: x_msg_count OUT NOCOPY NUMBER,

Line 5213: := hz_contact_point_v2pub.g_miss_edi_rec,

5209: PROCEDURE update_edi_contact_point (
5210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5211: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5212: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type
5213: := hz_contact_point_v2pub.g_miss_edi_rec,
5214: p_object_version_number IN OUT NOCOPY NUMBER,
5215: x_return_status OUT NOCOPY VARCHAR2,
5216: x_msg_count OUT NOCOPY NUMBER,
5217: x_msg_data OUT NOCOPY VARCHAR2

Line 5252: hz_contact_point_v2pub.update_edi_contact_point(

5248: RAISE fnd_api.g_exc_error;
5249: END IF;
5250:
5251: -- update the EDI contact point
5252: hz_contact_point_v2pub.update_edi_contact_point(
5253: p_init_msg_list => fnd_api.g_false,
5254: p_contact_point_rec => p_contact_point_rec,
5255: p_edi_rec => p_edi_rec,
5256: p_object_version_number => p_object_version_number,

Line 5383: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5379: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5380: +=======================================================================*/
5381: PROCEDURE create_eft_contact_point (
5382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5383: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5384: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5385: := hz_contact_point_v2pub.g_miss_eft_rec,
5386: x_contact_point_id OUT NOCOPY NUMBER,
5387: x_return_status OUT NOCOPY VARCHAR2,

Line 5384: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type

5380: +=======================================================================*/
5381: PROCEDURE create_eft_contact_point (
5382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5383: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5384: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5385: := hz_contact_point_v2pub.g_miss_eft_rec,
5386: x_contact_point_id OUT NOCOPY NUMBER,
5387: x_return_status OUT NOCOPY VARCHAR2,
5388: x_msg_count OUT NOCOPY NUMBER,

Line 5385: := hz_contact_point_v2pub.g_miss_eft_rec,

5381: PROCEDURE create_eft_contact_point (
5382: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5383: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5384: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5385: := hz_contact_point_v2pub.g_miss_eft_rec,
5386: x_contact_point_id OUT NOCOPY NUMBER,
5387: x_return_status OUT NOCOPY VARCHAR2,
5388: x_msg_count OUT NOCOPY NUMBER,
5389: x_msg_data OUT NOCOPY VARCHAR2

Line 5424: hz_contact_point_v2pub.create_eft_contact_point(

5420: RAISE fnd_api.g_exc_error;
5421: END IF;
5422:
5423: -- create the EFT contact point
5424: hz_contact_point_v2pub.create_eft_contact_point(
5425: p_init_msg_list => fnd_api.g_false,
5426: p_contact_point_rec => p_contact_point_rec,
5427: p_eft_rec => p_eft_rec,
5428: x_contact_point_id => x_contact_point_id,

Line 5555: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5551: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5552: +=======================================================================*/
5553: PROCEDURE update_eft_contact_point (
5554: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5555: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5556: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5557: := hz_contact_point_v2pub.g_miss_eft_rec,
5558: p_object_version_number IN OUT NOCOPY NUMBER,
5559: x_return_status OUT NOCOPY VARCHAR2,

Line 5556: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type

5552: +=======================================================================*/
5553: PROCEDURE update_eft_contact_point (
5554: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5555: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5556: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5557: := hz_contact_point_v2pub.g_miss_eft_rec,
5558: p_object_version_number IN OUT NOCOPY NUMBER,
5559: x_return_status OUT NOCOPY VARCHAR2,
5560: x_msg_count OUT NOCOPY NUMBER,

Line 5557: := hz_contact_point_v2pub.g_miss_eft_rec,

5553: PROCEDURE update_eft_contact_point (
5554: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5555: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5556: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type
5557: := hz_contact_point_v2pub.g_miss_eft_rec,
5558: p_object_version_number IN OUT NOCOPY NUMBER,
5559: x_return_status OUT NOCOPY VARCHAR2,
5560: x_msg_count OUT NOCOPY NUMBER,
5561: x_msg_data OUT NOCOPY VARCHAR2

Line 5596: hz_contact_point_v2pub.update_eft_contact_point(

5592: RAISE fnd_api.g_exc_error;
5593: END IF;
5594:
5595: -- update the EFT contact point
5596: hz_contact_point_v2pub.update_eft_contact_point(
5597: p_init_msg_list => fnd_api.g_false,
5598: p_contact_point_rec => p_contact_point_rec,
5599: p_eft_rec => p_eft_rec,
5600: p_object_version_number => p_object_version_number,

Line 5727: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5723: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5724: +=======================================================================*/
5725: PROCEDURE create_web_contact_point (
5726: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5727: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5728: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5729: := hz_contact_point_v2pub.g_miss_web_rec,
5730: x_contact_point_id OUT NOCOPY NUMBER,
5731: x_return_status OUT NOCOPY VARCHAR2,

Line 5728: p_web_rec IN hz_contact_point_v2pub.web_rec_type

5724: +=======================================================================*/
5725: PROCEDURE create_web_contact_point (
5726: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5727: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5728: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5729: := hz_contact_point_v2pub.g_miss_web_rec,
5730: x_contact_point_id OUT NOCOPY NUMBER,
5731: x_return_status OUT NOCOPY VARCHAR2,
5732: x_msg_count OUT NOCOPY NUMBER,

Line 5729: := hz_contact_point_v2pub.g_miss_web_rec,

5725: PROCEDURE create_web_contact_point (
5726: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5727: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5728: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5729: := hz_contact_point_v2pub.g_miss_web_rec,
5730: x_contact_point_id OUT NOCOPY NUMBER,
5731: x_return_status OUT NOCOPY VARCHAR2,
5732: x_msg_count OUT NOCOPY NUMBER,
5733: x_msg_data OUT NOCOPY VARCHAR2

Line 5768: hz_contact_point_v2pub.create_web_contact_point(

5764: RAISE fnd_api.g_exc_error;
5765: END IF;
5766:
5767: -- create the WEB contact point
5768: hz_contact_point_v2pub.create_web_contact_point(
5769: p_init_msg_list => fnd_api.g_false,
5770: p_contact_point_rec => p_contact_point_rec,
5771: p_web_rec => p_web_rec,
5772: x_contact_point_id => x_contact_point_id,

Line 5899: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

5895: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
5896: +=======================================================================*/
5897: PROCEDURE update_web_contact_point (
5898: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5899: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5900: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5901: := hz_contact_point_v2pub.g_miss_web_rec,
5902: p_object_version_number IN OUT NOCOPY NUMBER,
5903: x_return_status OUT NOCOPY VARCHAR2,

Line 5900: p_web_rec IN hz_contact_point_v2pub.web_rec_type

5896: +=======================================================================*/
5897: PROCEDURE update_web_contact_point (
5898: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5899: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5900: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5901: := hz_contact_point_v2pub.g_miss_web_rec,
5902: p_object_version_number IN OUT NOCOPY NUMBER,
5903: x_return_status OUT NOCOPY VARCHAR2,
5904: x_msg_count OUT NOCOPY NUMBER,

Line 5901: := hz_contact_point_v2pub.g_miss_web_rec,

5897: PROCEDURE update_web_contact_point (
5898: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
5899: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
5900: p_web_rec IN hz_contact_point_v2pub.web_rec_type
5901: := hz_contact_point_v2pub.g_miss_web_rec,
5902: p_object_version_number IN OUT NOCOPY NUMBER,
5903: x_return_status OUT NOCOPY VARCHAR2,
5904: x_msg_count OUT NOCOPY NUMBER,
5905: x_msg_data OUT NOCOPY VARCHAR2

Line 5940: hz_contact_point_v2pub.update_web_contact_point(

5936: RAISE fnd_api.g_exc_error;
5937: END IF;
5938:
5939: -- update the WEB contact point
5940: hz_contact_point_v2pub.update_web_contact_point(
5941: p_init_msg_list => fnd_api.g_false,
5942: p_contact_point_rec => p_contact_point_rec,
5943: p_web_rec => p_web_rec,
5944: p_object_version_number => p_object_version_number,

Line 6071: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6067: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6068: +=======================================================================*/
6069: PROCEDURE create_phone_contact_point (
6070: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6071: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6072: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6073: := hz_contact_point_v2pub.g_miss_phone_rec,
6074: x_contact_point_id OUT NOCOPY NUMBER,
6075: x_return_status OUT NOCOPY VARCHAR2,

Line 6072: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type

6068: +=======================================================================*/
6069: PROCEDURE create_phone_contact_point (
6070: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6071: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6072: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6073: := hz_contact_point_v2pub.g_miss_phone_rec,
6074: x_contact_point_id OUT NOCOPY NUMBER,
6075: x_return_status OUT NOCOPY VARCHAR2,
6076: x_msg_count OUT NOCOPY NUMBER,

Line 6073: := hz_contact_point_v2pub.g_miss_phone_rec,

6069: PROCEDURE create_phone_contact_point (
6070: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6071: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6072: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6073: := hz_contact_point_v2pub.g_miss_phone_rec,
6074: x_contact_point_id OUT NOCOPY NUMBER,
6075: x_return_status OUT NOCOPY VARCHAR2,
6076: x_msg_count OUT NOCOPY NUMBER,
6077: x_msg_data OUT NOCOPY VARCHAR2

Line 6112: hz_contact_point_v2pub.create_phone_contact_point(

6108: RAISE fnd_api.g_exc_error;
6109: END IF;
6110:
6111: -- create the Phone contact point
6112: hz_contact_point_v2pub.create_phone_contact_point(
6113: p_init_msg_list => fnd_api.g_false,
6114: p_contact_point_rec => p_contact_point_rec,
6115: p_phone_rec => p_phone_rec,
6116: x_contact_point_id => x_contact_point_id,

Line 6243: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6239: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6240: +=======================================================================*/
6241: PROCEDURE update_phone_contact_point (
6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6243: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6244: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6245: := hz_contact_point_v2pub.g_miss_phone_rec,
6246: p_object_version_number IN OUT NOCOPY NUMBER,
6247: x_return_status OUT NOCOPY VARCHAR2,

Line 6244: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type

6240: +=======================================================================*/
6241: PROCEDURE update_phone_contact_point (
6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6243: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6244: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6245: := hz_contact_point_v2pub.g_miss_phone_rec,
6246: p_object_version_number IN OUT NOCOPY NUMBER,
6247: x_return_status OUT NOCOPY VARCHAR2,
6248: x_msg_count OUT NOCOPY NUMBER,

Line 6245: := hz_contact_point_v2pub.g_miss_phone_rec,

6241: PROCEDURE update_phone_contact_point (
6242: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6243: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6244: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type
6245: := hz_contact_point_v2pub.g_miss_phone_rec,
6246: p_object_version_number IN OUT NOCOPY NUMBER,
6247: x_return_status OUT NOCOPY VARCHAR2,
6248: x_msg_count OUT NOCOPY NUMBER,
6249: x_msg_data OUT NOCOPY VARCHAR2

Line 6284: hz_contact_point_v2pub.update_phone_contact_point(

6280: RAISE fnd_api.g_exc_error;
6281: END IF;
6282:
6283: -- update the Phone contact point
6284: hz_contact_point_v2pub.update_phone_contact_point(
6285: p_init_msg_list => fnd_api.g_false,
6286: p_contact_point_rec => p_contact_point_rec,
6287: p_phone_rec => p_phone_rec,
6288: p_object_version_number => p_object_version_number,

Line 6415: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6411: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6412: +=======================================================================*/
6413: PROCEDURE create_email_contact_point (
6414: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6415: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6416: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6417: := hz_contact_point_v2pub.g_miss_email_rec,
6418: x_contact_point_id OUT NOCOPY NUMBER,
6419: x_return_status OUT NOCOPY VARCHAR2,

Line 6416: p_email_rec IN hz_contact_point_v2pub.email_rec_type

6412: +=======================================================================*/
6413: PROCEDURE create_email_contact_point (
6414: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6415: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6416: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6417: := hz_contact_point_v2pub.g_miss_email_rec,
6418: x_contact_point_id OUT NOCOPY NUMBER,
6419: x_return_status OUT NOCOPY VARCHAR2,
6420: x_msg_count OUT NOCOPY NUMBER,

Line 6417: := hz_contact_point_v2pub.g_miss_email_rec,

6413: PROCEDURE create_email_contact_point (
6414: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6415: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6416: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6417: := hz_contact_point_v2pub.g_miss_email_rec,
6418: x_contact_point_id OUT NOCOPY NUMBER,
6419: x_return_status OUT NOCOPY VARCHAR2,
6420: x_msg_count OUT NOCOPY NUMBER,
6421: x_msg_data OUT NOCOPY VARCHAR2

Line 6456: hz_contact_point_v2pub.create_email_contact_point(

6452: RAISE fnd_api.g_exc_error;
6453: END IF;
6454:
6455: -- create the Email contact point
6456: hz_contact_point_v2pub.create_email_contact_point(
6457: p_init_msg_list => fnd_api.g_false,
6458: p_contact_point_rec => p_contact_point_rec,
6459: p_email_rec => p_email_rec,
6460: x_contact_point_id => x_contact_point_id,

Line 6587: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6583: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6584: +=======================================================================*/
6585: PROCEDURE update_email_contact_point (
6586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6587: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6588: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6589: := hz_contact_point_v2pub.g_miss_email_rec,
6590: p_object_version_number IN OUT NOCOPY NUMBER,
6591: x_return_status OUT NOCOPY VARCHAR2,

Line 6588: p_email_rec IN hz_contact_point_v2pub.email_rec_type

6584: +=======================================================================*/
6585: PROCEDURE update_email_contact_point (
6586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6587: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6588: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6589: := hz_contact_point_v2pub.g_miss_email_rec,
6590: p_object_version_number IN OUT NOCOPY NUMBER,
6591: x_return_status OUT NOCOPY VARCHAR2,
6592: x_msg_count OUT NOCOPY NUMBER,

Line 6589: := hz_contact_point_v2pub.g_miss_email_rec,

6585: PROCEDURE update_email_contact_point (
6586: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6587: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6588: p_email_rec IN hz_contact_point_v2pub.email_rec_type
6589: := hz_contact_point_v2pub.g_miss_email_rec,
6590: p_object_version_number IN OUT NOCOPY NUMBER,
6591: x_return_status OUT NOCOPY VARCHAR2,
6592: x_msg_count OUT NOCOPY NUMBER,
6593: x_msg_data OUT NOCOPY VARCHAR2

Line 6628: hz_contact_point_v2pub.update_email_contact_point(

6624: RAISE fnd_api.g_exc_error;
6625: END IF;
6626:
6627: -- update the Email contact point
6628: hz_contact_point_v2pub.update_email_contact_point(
6629: p_init_msg_list => fnd_api.g_false,
6630: p_contact_point_rec => p_contact_point_rec,
6631: p_email_rec => p_email_rec,
6632: p_object_version_number => p_object_version_number,

Line 6759: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6755: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6756: +=======================================================================*/
6757: PROCEDURE create_telex_contact_point (
6758: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6759: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6760: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6761: := hz_contact_point_v2pub.g_miss_telex_rec,
6762: x_contact_point_id OUT NOCOPY NUMBER,
6763: x_return_status OUT NOCOPY VARCHAR2,

Line 6760: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type

6756: +=======================================================================*/
6757: PROCEDURE create_telex_contact_point (
6758: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6759: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6760: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6761: := hz_contact_point_v2pub.g_miss_telex_rec,
6762: x_contact_point_id OUT NOCOPY NUMBER,
6763: x_return_status OUT NOCOPY VARCHAR2,
6764: x_msg_count OUT NOCOPY NUMBER,

Line 6761: := hz_contact_point_v2pub.g_miss_telex_rec,

6757: PROCEDURE create_telex_contact_point (
6758: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6759: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6760: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6761: := hz_contact_point_v2pub.g_miss_telex_rec,
6762: x_contact_point_id OUT NOCOPY NUMBER,
6763: x_return_status OUT NOCOPY VARCHAR2,
6764: x_msg_count OUT NOCOPY NUMBER,
6765: x_msg_data OUT NOCOPY VARCHAR2

Line 6800: hz_contact_point_v2pub.create_telex_contact_point(

6796: RAISE fnd_api.g_exc_error;
6797: END IF;
6798:
6799: -- create the Telex contact point
6800: hz_contact_point_v2pub.create_telex_contact_point(
6801: p_init_msg_list => fnd_api.g_false,
6802: p_contact_point_rec => p_contact_point_rec,
6803: p_telex_rec => p_telex_rec,
6804: x_contact_point_id => x_contact_point_id,

Line 6931: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,

6927: | 27-APR-2002 J. del Callar Bug 2238144: Created. |
6928: +=======================================================================*/
6929: PROCEDURE update_telex_contact_point (
6930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6931: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6932: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6933: := hz_contact_point_v2pub.g_miss_telex_rec,
6934: p_object_version_number IN OUT NOCOPY NUMBER,
6935: x_return_status OUT NOCOPY VARCHAR2,

Line 6932: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type

6928: +=======================================================================*/
6929: PROCEDURE update_telex_contact_point (
6930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6931: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6932: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6933: := hz_contact_point_v2pub.g_miss_telex_rec,
6934: p_object_version_number IN OUT NOCOPY NUMBER,
6935: x_return_status OUT NOCOPY VARCHAR2,
6936: x_msg_count OUT NOCOPY NUMBER,

Line 6933: := hz_contact_point_v2pub.g_miss_telex_rec,

6929: PROCEDURE update_telex_contact_point (
6930: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6931: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
6932: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type
6933: := hz_contact_point_v2pub.g_miss_telex_rec,
6934: p_object_version_number IN OUT NOCOPY NUMBER,
6935: x_return_status OUT NOCOPY VARCHAR2,
6936: x_msg_count OUT NOCOPY NUMBER,
6937: x_msg_data OUT NOCOPY VARCHAR2

Line 6973: hz_contact_point_v2pub.update_telex_contact_point(

6969: RAISE fnd_api.g_exc_error;
6970: END IF;
6971:
6972: -- update the Telex contact point
6973: hz_contact_point_v2pub.update_telex_contact_point(
6974: p_init_msg_list => fnd_api.g_false,
6975: p_contact_point_rec => p_contact_point_rec,
6976: p_telex_rec => p_telex_rec,
6977: p_object_version_number => p_object_version_number,