1099: -- timezone from fnd_timezones_vl view.
1100:
1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1100:
1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1101: PROCEDURE validate_contact_point_main (
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1102: p_create_update_flag IN VARCHAR2,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1103: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1111: x_return_status IN OUT NOCOPY VARCHAR2
1104: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1111: x_return_status IN OUT NOCOPY VARCHAR2
1112: ) IS
1105: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
1106: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
1107: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
1108: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
1109: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
1110: p_rowid IN ROWID,
1111: x_return_status IN OUT NOCOPY VARCHAR2
1112: ) IS
1113: l_debug_prefix VARCHAR2(30) := ''; --'validate_contact_point'
14457: -- backward compatibility.
14458: --
14459: PROCEDURE validate_contact_point (
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14458: --
14459: PROCEDURE validate_contact_point (
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14459: PROCEDURE validate_contact_point (
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14460: p_create_update_flag IN VARCHAR2,
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14468: x_return_status IN OUT NOCOPY VARCHAR2
14461: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14468: x_return_status IN OUT NOCOPY VARCHAR2
14469: ) IS
14462: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14463: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14464: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14465: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14466: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14467: p_rowid IN ROWID,
14468: x_return_status IN OUT NOCOPY VARCHAR2
14469: ) IS
14470: l_debug_prefix VARCHAR2(30) := '';
14535: -- backward compatibility.
14536: --
14537: PROCEDURE validate_edi_contact_point (
14538: p_create_update_flag IN VARCHAR2,
14539: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14540: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14541: p_rowid IN ROWID,
14542: x_return_status IN OUT NOCOPY VARCHAR2
14543: ) IS
14536: --
14537: PROCEDURE validate_edi_contact_point (
14538: p_create_update_flag IN VARCHAR2,
14539: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14540: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14541: p_rowid IN ROWID,
14542: x_return_status IN OUT NOCOPY VARCHAR2
14543: ) IS
14544: l_debug_prefix VARCHAR2(30) := '';
14605: -- backward compatibility.
14606: --
14607: PROCEDURE validate_eft_contact_point (
14608: p_create_update_flag IN VARCHAR2,
14609: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14610: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14611: p_rowid IN ROWID,
14612: x_return_status IN OUT NOCOPY VARCHAR2
14613: ) IS
14606: --
14607: PROCEDURE validate_eft_contact_point (
14608: p_create_update_flag IN VARCHAR2,
14609: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14610: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14611: p_rowid IN ROWID,
14612: x_return_status IN OUT NOCOPY VARCHAR2
14613: ) IS
14614: l_debug_prefix VARCHAR2(30) := '';
14675: -- backward compatibility.
14676: --
14677: PROCEDURE validate_web_contact_point (
14678: p_create_update_flag IN VARCHAR2,
14679: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14681: p_rowid IN ROWID,
14682: x_return_status IN OUT NOCOPY VARCHAR2
14683: ) IS
14676: --
14677: PROCEDURE validate_web_contact_point (
14678: p_create_update_flag IN VARCHAR2,
14679: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14680: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14681: p_rowid IN ROWID,
14682: x_return_status IN OUT NOCOPY VARCHAR2
14683: ) IS
14684: l_debug_prefix VARCHAR2(30) := '';
14746: -- backward compatibility.
14747: --
14748: PROCEDURE validate_phone_contact_point (
14749: p_create_update_flag IN VARCHAR2,
14750: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14751: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14752: p_rowid IN ROWID,
14753: x_return_status IN OUT NOCOPY VARCHAR2
14754: ) IS
14747: --
14748: PROCEDURE validate_phone_contact_point (
14749: p_create_update_flag IN VARCHAR2,
14750: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14751: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14752: p_rowid IN ROWID,
14753: x_return_status IN OUT NOCOPY VARCHAR2
14754: ) IS
14755: l_debug_prefix VARCHAR2(30) := '';
14816: -- backward compatibility.
14817: --
14818: PROCEDURE validate_telex_contact_point (
14819: p_create_update_flag IN VARCHAR2,
14820: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14821: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14822: p_rowid IN ROWID,
14823: x_return_status IN OUT NOCOPY VARCHAR2
14824: ) IS
14817: --
14818: PROCEDURE validate_telex_contact_point (
14819: p_create_update_flag IN VARCHAR2,
14820: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14821: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14822: p_rowid IN ROWID,
14823: x_return_status IN OUT NOCOPY VARCHAR2
14824: ) IS
14825: l_debug_prefix VARCHAR2(30) := '';
14886: -- backward compatibility.
14887: --
14888: PROCEDURE validate_email_contact_point (
14889: p_create_update_flag IN VARCHAR2,
14890: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14891: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14892: p_rowid IN ROWID,
14893: x_return_status IN OUT NOCOPY VARCHAR2
14894: ) IS
14887: --
14888: PROCEDURE validate_email_contact_point (
14889: p_create_update_flag IN VARCHAR2,
14890: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14891: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14892: p_rowid IN ROWID,
14893: x_return_status IN OUT NOCOPY VARCHAR2
14894: ) IS
14895: l_debug_prefix VARCHAR2(30) := '';