APPS.CS_SRCONTACT_PKG dependencies on HZ_PARTIES

Line 377: -- Associate party has to exist in hz_parties only. there may

373: -- Date Name Desc
374: -------- ----------- -----------------------------------------------------------
375: -- 04/15/05 smisra Created
376: -- 08/10/05 smisra Added following validations
377: -- Associate party has to exist in hz_parties only. there may
378: -- not be any relationship with SR customer
379: -- Primary contact can not have end date value
380: -- 10/05/05 smisra Change Request: 4645490
381: -- Raise error is party_id, contact_type or party_role_code

Line 396: l_status hz_parties.status % TYPE;

392: ) IS
393: l_api_name_full VARCHAR2(61);
394: l_employee_name VARCHAR2(80);
395: l_party_type cs_hz_sr_contact_points.contact_type % TYPE;
396: l_status hz_parties.status % TYPE;
397: p_mode VARCHAR2(30);
398: l_today DATE;
399: BEGIN
400: l_api_name_full := 'CS_SRCONTACT_PKG.validate_contact';

Line 523: -- hz_parties table

519: ELSIF NVL(p_new_contact_rec.party_role_code,'CONTACT') <> 'CONTACT'
520: -- Else condition means contact type is either person, org or relationship
521: -- so if party role is CONTACT then do not validation relationship between
522: -- SR customer and contact party. contact party should merely exist in
523: -- hz_parties table
524: THEN
525: CS_SERVICEREQUEST_UTIL.get_party_details
526: ( p_party_id => p_new_contact_rec.party_id
527: , x_party_type => l_party_type