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'
14477: -- backward compatibility.
14478: --
14479: PROCEDURE validate_contact_point (
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14478: --
14479: PROCEDURE validate_contact_point (
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14479: PROCEDURE validate_contact_point (
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14480: p_create_update_flag IN VARCHAR2,
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14488: x_return_status IN OUT NOCOPY VARCHAR2
14481: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14488: x_return_status IN OUT NOCOPY VARCHAR2
14489: ) IS
14482: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14483: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14484: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14485: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14486: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14487: p_rowid IN ROWID,
14488: x_return_status IN OUT NOCOPY VARCHAR2
14489: ) IS
14490: l_debug_prefix VARCHAR2(30) := '';
14555: -- backward compatibility.
14556: --
14557: PROCEDURE validate_edi_contact_point (
14558: p_create_update_flag IN VARCHAR2,
14559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14561: p_rowid IN ROWID,
14562: x_return_status IN OUT NOCOPY VARCHAR2
14563: ) IS
14556: --
14557: PROCEDURE validate_edi_contact_point (
14558: p_create_update_flag IN VARCHAR2,
14559: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14560: p_edi_rec IN hz_contact_point_v2pub.edi_rec_type := hz_contact_point_v2pub.g_miss_edi_rec,
14561: p_rowid IN ROWID,
14562: x_return_status IN OUT NOCOPY VARCHAR2
14563: ) IS
14564: l_debug_prefix VARCHAR2(30) := '';
14625: -- backward compatibility.
14626: --
14627: PROCEDURE validate_eft_contact_point (
14628: p_create_update_flag IN VARCHAR2,
14629: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14630: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14631: p_rowid IN ROWID,
14632: x_return_status IN OUT NOCOPY VARCHAR2
14633: ) IS
14626: --
14627: PROCEDURE validate_eft_contact_point (
14628: p_create_update_flag IN VARCHAR2,
14629: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14630: p_eft_rec IN hz_contact_point_v2pub.eft_rec_type := hz_contact_point_v2pub.g_miss_eft_rec,
14631: p_rowid IN ROWID,
14632: x_return_status IN OUT NOCOPY VARCHAR2
14633: ) IS
14634: l_debug_prefix VARCHAR2(30) := '';
14695: -- backward compatibility.
14696: --
14697: PROCEDURE validate_web_contact_point (
14698: p_create_update_flag IN VARCHAR2,
14699: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14700: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14701: p_rowid IN ROWID,
14702: x_return_status IN OUT NOCOPY VARCHAR2
14703: ) IS
14696: --
14697: PROCEDURE validate_web_contact_point (
14698: p_create_update_flag IN VARCHAR2,
14699: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14700: p_web_rec IN hz_contact_point_v2pub.web_rec_type := hz_contact_point_v2pub.g_miss_web_rec,
14701: p_rowid IN ROWID,
14702: x_return_status IN OUT NOCOPY VARCHAR2
14703: ) IS
14704: l_debug_prefix VARCHAR2(30) := '';
14766: -- backward compatibility.
14767: --
14768: PROCEDURE validate_phone_contact_point (
14769: p_create_update_flag IN VARCHAR2,
14770: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14771: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14772: p_rowid IN ROWID,
14773: x_return_status IN OUT NOCOPY VARCHAR2
14774: ) IS
14767: --
14768: PROCEDURE validate_phone_contact_point (
14769: p_create_update_flag IN VARCHAR2,
14770: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14771: p_phone_rec IN hz_contact_point_v2pub.phone_rec_type := hz_contact_point_v2pub.g_miss_phone_rec,
14772: p_rowid IN ROWID,
14773: x_return_status IN OUT NOCOPY VARCHAR2
14774: ) IS
14775: l_debug_prefix VARCHAR2(30) := '';
14836: -- backward compatibility.
14837: --
14838: PROCEDURE validate_telex_contact_point (
14839: p_create_update_flag IN VARCHAR2,
14840: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14841: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14842: p_rowid IN ROWID,
14843: x_return_status IN OUT NOCOPY VARCHAR2
14844: ) IS
14837: --
14838: PROCEDURE validate_telex_contact_point (
14839: p_create_update_flag IN VARCHAR2,
14840: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14841: p_telex_rec IN hz_contact_point_v2pub.telex_rec_type := hz_contact_point_v2pub.g_miss_telex_rec,
14842: p_rowid IN ROWID,
14843: x_return_status IN OUT NOCOPY VARCHAR2
14844: ) IS
14845: l_debug_prefix VARCHAR2(30) := '';
14906: -- backward compatibility.
14907: --
14908: PROCEDURE validate_email_contact_point (
14909: p_create_update_flag IN VARCHAR2,
14910: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14911: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14912: p_rowid IN ROWID,
14913: x_return_status IN OUT NOCOPY VARCHAR2
14914: ) IS
14907: --
14908: PROCEDURE validate_email_contact_point (
14909: p_create_update_flag IN VARCHAR2,
14910: p_contact_point_rec IN hz_contact_point_v2pub.contact_point_rec_type,
14911: p_email_rec IN hz_contact_point_v2pub.email_rec_type := hz_contact_point_v2pub.g_miss_email_rec,
14912: p_rowid IN ROWID,
14913: x_return_status IN OUT NOCOPY VARCHAR2
14914: ) IS
14915: l_debug_prefix VARCHAR2(30) := '';