eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_PARTY_V2PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 40: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

36: Procedure Create_Individual_User(
37: p_username IN VARCHAR2,
38: p_password IN VARCHAR2,
39: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
40: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
41: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
42: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
43: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
44: p_contact_preference IN VARCHAR2,

Line 41: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

37: p_username IN VARCHAR2,
38: p_password IN VARCHAR2,
39: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
40: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
41: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
42: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
43: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
44: p_contact_preference IN VARCHAR2,
45: x_person_party_id OUT NOCOPY NUMBER,

Line 42: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

38: p_password IN VARCHAR2,
39: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
40: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
41: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
42: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
43: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
44: p_contact_preference IN VARCHAR2,
45: x_person_party_id OUT NOCOPY NUMBER,
46: x_user_id OUT NOCOPY NUMBER,

Line 43: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

39: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
40: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
41: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
42: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
43: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
44: p_contact_preference IN VARCHAR2,
45: x_person_party_id OUT NOCOPY NUMBER,
46: x_user_id OUT NOCOPY NUMBER,
47: x_return_status OUT NOCOPY VARCHAR2,

Line 275: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

271: p_password IN VARCHAR2,
272: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
273: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
274: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
275: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

Line 276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

272: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
273: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
274: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
275: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
280: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

Line 277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

273: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
274: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
275: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
280: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
281: p_rel_contact_preference IN VARCHAR2,

Line 278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

274: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
275: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
280: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
281: p_rel_contact_preference IN VARCHAR2,
282: x_person_party_id OUT NOCOPY NUMBER,

Line 279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

275: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
280: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
281: p_rel_contact_preference IN VARCHAR2,
282: x_person_party_id OUT NOCOPY NUMBER,
283: x_rel_party_id OUT NOCOPY NUMBER,

Line 280: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

276: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
277: p_rel_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
278: p_rel_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
279: p_rel_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
280: p_rel_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
281: p_rel_contact_preference IN VARCHAR2,
282: x_person_party_id OUT NOCOPY NUMBER,
283: x_rel_party_id OUT NOCOPY NUMBER,
284: x_org_party_id OUT NOCOPY NUMBER,

Line 610: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

606: Procedure Create_Org_Contact(
607: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
608: p_relationship_type IN VARCHAR2, -- 'EMPLOYEE_OF' or 'CONTACT_OF'
609: p_org_party_id IN NUMBER,
610: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
611: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
612: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
613: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
614: p_created_by_module IN VARCHAR2,

Line 611: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

607: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
608: p_relationship_type IN VARCHAR2, -- 'EMPLOYEE_OF' or 'CONTACT_OF'
609: p_org_party_id IN NUMBER,
610: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
611: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
612: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
613: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
614: p_created_by_module IN VARCHAR2,
615: x_person_party_id OUT NOCOPY NUMBER,

Line 612: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

608: p_relationship_type IN VARCHAR2, -- 'EMPLOYEE_OF' or 'CONTACT_OF'
609: p_org_party_id IN NUMBER,
610: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
611: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
612: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
613: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
614: p_created_by_module IN VARCHAR2,
615: x_person_party_id OUT NOCOPY NUMBER,
616: x_rel_party_id OUT NOCOPY NUMBER,

Line 613: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

609: p_org_party_id IN NUMBER,
610: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
611: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
612: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
613: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
614: p_created_by_module IN VARCHAR2,
615: x_person_party_id OUT NOCOPY NUMBER,
616: x_rel_party_id OUT NOCOPY NUMBER,
617: x_return_status OUT NOCOPY VARCHAR2,

Line 871: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

867: | - Create_Contact_Points
868: |======================================================================*/
869: Procedure Create_Person(
870: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
871: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
872: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
873: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
874: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
875: p_created_by_module IN VARCHAR2,

Line 872: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

868: |======================================================================*/
869: Procedure Create_Person(
870: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
871: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
872: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
873: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
874: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
875: p_created_by_module IN VARCHAR2,
876: p_account IN VARCHAR2 ,

Line 873: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

869: Procedure Create_Person(
870: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
871: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
872: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
873: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
874: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
875: p_created_by_module IN VARCHAR2,
876: p_account IN VARCHAR2 ,
877: x_person_party_id OUT NOCOPY NUMBER,

Line 874: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

870: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
871: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
872: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
873: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
874: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
875: p_created_by_module IN VARCHAR2,
876: p_account IN VARCHAR2 ,
877: x_person_party_id OUT NOCOPY NUMBER,
878: x_account_id OUT NOCOPY NUMBER,

Line 891: l_home_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;

887: l_account_number NUMBER;
888: l_account_id NUMBER;
889: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
890:
891: l_home_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
892: l_work_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
893: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
894: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := null;
895: BEGIN

Line 892: l_work_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;

888: l_account_id NUMBER;
889: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
890:
891: l_home_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
892: l_work_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
893: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
894: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := null;
895: BEGIN
896: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 893: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;

889: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
890:
891: l_home_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
892: l_work_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
893: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
894: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := null;
895: BEGIN
896: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
897: IBE_UTIL.debug('enter ibe_party_v2pvt.create_person');

Line 894: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := null;

890:
891: l_home_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
892: l_work_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
893: l_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
894: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type := null;
895: BEGIN
896: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
897: IBE_UTIL.debug('enter ibe_party_v2pvt.create_person');
898: END IF;

Line 1111: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1107: | - Create_Account id p_account is true
1108: +======================================================================*/
1109: Procedure Create_Organization(
1110: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
1111: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1112: /* p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1113: */
1114: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1115: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,

Line 1112: /* p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1108: +======================================================================*/
1109: Procedure Create_Organization(
1110: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
1111: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1112: /* p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1113: */
1114: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1115: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
1116: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.party_site_rec_type,

Line 1114: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1110: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
1111: p_org_workphone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1112: /* p_org_homephone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1113: */
1114: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1115: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
1116: p_party_site_rec IN HZ_PARTY_SITE_V2PUB.party_site_rec_type,
1117: p_primary_billto IN VARCHAR2 := FND_API.G_FALSE,
1118: p_primary_shipto IN VARCHAR2 := FND_API.G_FALSE,

Line 1141: l_org_workphone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;

1137: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
1138: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
1139: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1140:
1141: l_org_workphone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
1142: /*l_org_homephone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;*/
1143: l_org_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;
1144:
1145:

Line 1142: /l_org_homephone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;/

1138: l_party_site_rec HZ_PARTY_SITE_V2PUB.party_site_rec_type;
1139: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1140:
1141: l_org_workphone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
1142: /*l_org_homephone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;*/
1143: l_org_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;
1144:
1145:
1146: --l_account_id NUMBER;

Line 1143: l_org_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;

1139: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
1140:
1141: l_org_workphone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type := null;
1142: /*l_org_homephone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;*/
1143: l_org_fax_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type:= null;
1144:
1145:
1146: --l_account_id NUMBER;
1147: BEGIN

Line 1411: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1407: | - HZ_CONTACT_POINTS_V2PUB.Create_Contact_Points
1408: +======================================================================*/
1409: Procedure Create_Contact_Points(
1410: p_owner_table_id IN NUMBER,
1411: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1412: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1413: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1414: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1415: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose

Line 1412: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1408: +======================================================================*/
1409: Procedure Create_Contact_Points(
1410: p_owner_table_id IN NUMBER,
1411: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1412: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1413: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1414: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1415: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
1416: p_created_by_module IN VARCHAR2,

Line 1413: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1409: Procedure Create_Contact_Points(
1410: p_owner_table_id IN NUMBER,
1411: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1412: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1413: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1414: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1415: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
1416: p_created_by_module IN VARCHAR2,
1417: x_return_status OUT NOCOPY VARCHAR2,

Line 1414: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

1410: p_owner_table_id IN NUMBER,
1411: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1412: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1413: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1414: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1415: p_contact_point_purpose IN BOOLEAN, --indicates whether to populate contact_point_purpose
1416: p_created_by_module IN VARCHAR2,
1417: x_return_status OUT NOCOPY VARCHAR2,
1418: x_msg_count OUT NOCOPY NUMBER,

Line 1424: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;

1420:
1421:
1422: l_contact_point_id NUMBER;
1423:
1424: l_contact_point_rec HZ_CONTACT_POINT_V2PUB.CONTACT_POINT_REC_TYPE;
1425:
1426: BEGIN
1427: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1428: IBE_UTIL.debug('enter ibe_party_v2pvt.create_contact_points');

Line 1451: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_email_contact_point API');

1447: l_contact_point_rec.contact_point_type := null;
1448: if (p_email_rec.email_address is not NULL) then
1449:
1450: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1451: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_email_contact_point API');
1452: END IF;
1453: l_contact_point_rec.contact_point_type := 'EMAIL';
1454:
1455: -- calling TCA API to create_email_contact_points

Line 1457: HZ_CONTACT_POINT_V2PUB.create_email_contact_point (

1453: l_contact_point_rec.contact_point_type := 'EMAIL';
1454:
1455: -- calling TCA API to create_email_contact_points
1456:
1457: HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
1458: p_contact_point_rec => l_contact_point_rec,
1459: p_email_rec => p_email_rec,
1460: x_contact_point_id => l_contact_point_id,
1461: x_return_status => x_return_status,

Line 1465: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point l_contact_point_id : '|| l_contact_point_id);

1461: x_return_status => x_return_status,
1462: x_msg_count => x_msg_count,
1463: x_msg_data => x_msg_data);
1464: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1465: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point l_contact_point_id : '|| l_contact_point_id);
1466: END IF;
1467: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469: end if;

Line 1486: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');

1482: if (p_contact_point_purpose) then
1483: l_contact_point_rec.contact_point_purpose := 'BUSINESS';
1484: end if;
1485: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1486: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');
1487: END IF;
1488: --l_contact_point_rec.primary_flag := 'Y';
1489: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
1490: p_contact_point_rec => l_contact_point_rec,

Line 1489: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

1485: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1486: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');
1487: END IF;
1488: --l_contact_point_rec.primary_flag := 'Y';
1489: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
1490: p_contact_point_rec => l_contact_point_rec,
1491: p_phone_rec => p_work_phone_rec,
1492: x_contact_point_id => l_contact_point_id,
1493: x_return_status => x_return_status,

Line 1497: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_phone_contact_point(work) - l_contact_point_id : '|| l_contact_point_id);

1493: x_return_status => x_return_status,
1494: x_msg_count => x_msg_count,
1495: x_msg_data => x_msg_data );
1496: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1497: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_phone_contact_point(work) - l_contact_point_id : '|| l_contact_point_id);
1498: END IF;
1499: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: end if;

Line 1520: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');

1516: --if (p_work_phone_rec.phone_number is null) then
1517: --l_contact_point_rec.primary_flag := 'Y';
1518: --end if;
1519: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1520: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');
1521: END IF;
1522: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
1523: p_contact_point_rec => l_contact_point_rec,
1524: p_phone_rec => p_home_phone_rec,

Line 1522: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

1518: --end if;
1519: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1520: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');
1521: END IF;
1522: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
1523: p_contact_point_rec => l_contact_point_rec,
1524: p_phone_rec => p_home_phone_rec,
1525: x_contact_point_id => l_contact_point_id,
1526: x_return_status => x_return_status,

Line 1530: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (home)- l_contact_point_id : '|| l_contact_point_id);

1526: x_return_status => x_return_status,
1527: x_msg_count => x_msg_count,
1528: x_msg_data => x_msg_data );
1529: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1530: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (home)- l_contact_point_id : '|| l_contact_point_id);
1531: END IF;
1532: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: end if;

Line 1551: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');

1547: --if (p_work_phone_rec.phone_number is null) and (p_home_phone_rec.phone_number is null) then
1548: --l_contact_point_rec.primary_flag := 'Y';
1549: --end if;
1550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1551: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');
1552: END IF;
1553: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
1554: p_contact_point_rec => l_contact_point_rec,
1555: p_phone_rec => p_fax_rec,

Line 1553: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

1549: --end if;
1550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1551: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_phone_contact_point API');
1552: END IF;
1553: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
1554: p_contact_point_rec => l_contact_point_rec,
1555: p_phone_rec => p_fax_rec,
1556: x_contact_point_id => l_contact_point_id,
1557: x_return_status => x_return_status,

Line 1561: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (fax)- l_contact_point_id : '|| l_contact_point_id);

1557: x_return_status => x_return_status,
1558: x_msg_count => x_msg_count,
1559: x_msg_data => x_msg_data );
1560: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1561: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (fax)- l_contact_point_id : '|| l_contact_point_id);
1562: END IF;
1563: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1565: end if;

Line 2224: | - Hz_contact_point_v2pub.update_contact_point

2220: | - Hz_party_contact_v2pub.update_org_contact
2221: | - Hz_party_v2pub.update_organization
2222: | - Hz_cust_account_v2pub.update_cust_account
2223: | - Hz_cust_account_role_v2pub.update_cust_account_role
2224: | - Hz_contact_point_v2pub.update_contact_point
2225: | - Hz_party_site_v2pub.update_party_site
2226: | - HZ_.update_contact_preferences
2227: +======================================================================*/
2228: Procedure Update_Party_Status(

Line 2242: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;

2238: l_person_rec hz_party_v2pub.person_rec_type;
2239: l_org_rec hz_party_v2pub.organization_rec_type;
2240: l_org_contact_rec hz_party_contact_v2pub.org_contact_rec_type;
2241: l_account_rec hz_cust_account_v2pub.cust_account_rec_type;
2242: l_contact_point_rec hz_contact_point_v2pub.contact_point_rec_type;
2243: l_party_site_rec hz_party_site_v2pub.party_site_rec_type;
2244: l_custacct_role_rec hz_cust_account_role_v2pub.cust_account_role_rec_type;
2245: l_cntct_pref_rec hz_contact_preference_v2pub.contact_preference_rec_type;
2246:

Line 2450: hz_contact_point_v2pub.update_contact_point

2446: IBE_UTIL.debug('Update Contact_Point Id'||rec_contact_point.contact_point_id);
2447: END IF;
2448: l_contact_point_rec.contact_point_id := rec_contact_point.contact_point_id;
2449: l_contact_point_rec.status := p_party_status;
2450: hz_contact_point_v2pub.update_contact_point
2451: (p_contact_point_rec => l_contact_point_rec,
2452: p_object_version_number => rec_contact_point.object_version_number,
2453: x_return_status => x_return_status,
2454: x_msg_count => x_msg_count,

Line 2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (

2704: | HZ_PARTY_SITE_V2PUB.create_party_site()
2705: | HZ_PARTY_CONTACT_V2PUB.create_org_contact()
2706: | HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()
2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
2711: | HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
2712: |

Line 2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (

2705: | HZ_PARTY_CONTACT_V2PUB.create_org_contact()
2706: | HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()
2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
2711: | HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
2712: |
2713: +======================================================================*/

Line 2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

2706: | HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()
2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
2711: | HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
2712: |
2713: +======================================================================*/
2714: Procedure Save_Tca_Entities(

Line 2711: | HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

2707: | HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
2708: | HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
2709: | HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
2710: | HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
2711: | HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
2712: |
2713: +======================================================================*/
2714: Procedure Save_Tca_Entities(
2715: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,

Line 2717: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,

2713: +======================================================================*/
2714: Procedure Save_Tca_Entities(
2715: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
2716: p_person_object_version_number IN NUMBER,
2717: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2718: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2719: p_email_object_version_number IN NUMBER,
2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

Line 2718: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

2714: Procedure Save_Tca_Entities(
2715: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
2716: p_person_object_version_number IN NUMBER,
2717: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2718: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2719: p_email_object_version_number IN NUMBER,
2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2722: p_workph_object_version_number IN NUMBER,

Line 2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,

2716: p_person_object_version_number IN NUMBER,
2717: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2718: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2719: p_email_object_version_number IN NUMBER,
2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2722: p_workph_object_version_number IN NUMBER,
2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

Line 2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

2717: p_email_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2718: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2719: p_email_object_version_number IN NUMBER,
2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2722: p_workph_object_version_number IN NUMBER,
2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2725: p_homeph_object_version_number IN NUMBER,

Line 2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,

2719: p_email_object_version_number IN NUMBER,
2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2722: p_workph_object_version_number IN NUMBER,
2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2725: p_homeph_object_version_number IN NUMBER,
2726: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2727: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

Line 2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

2720: p_workph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2721: p_work_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2722: p_workph_object_version_number IN NUMBER,
2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2725: p_homeph_object_version_number IN NUMBER,
2726: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2727: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2728: p_fax_object_version_number IN NUMBER,

Line 2726: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,

2722: p_workph_object_version_number IN NUMBER,
2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2725: p_homeph_object_version_number IN NUMBER,
2726: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2727: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2728: p_fax_object_version_number IN NUMBER,
2729: p_contact_pref_rec IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,
2730: p_cntct_pref_object_ver_num IN NUMBER,

Line 2727: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

2723: p_homeph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2724: p_home_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2725: p_homeph_object_version_number IN NUMBER,
2726: p_fax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2727: p_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2728: p_fax_object_version_number IN NUMBER,
2729: p_contact_pref_rec IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,
2730: p_cntct_pref_object_ver_num IN NUMBER,
2731: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,

Line 2735: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,

2731: p_organization_rec IN HZ_PARTY_V2PUB.organization_rec_type,
2732: p_org_object_version_number IN NUMBER,
2733: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
2734: p_loc_object_version_number IN NUMBER,
2735: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2736: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2737: p_orgph_object_version_number IN NUMBER,
2738: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2739: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

Line 2736: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

2732: p_org_object_version_number IN NUMBER,
2733: p_location_rec IN HZ_LOCATION_V2PUB.location_rec_type,
2734: p_loc_object_version_number IN NUMBER,
2735: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2736: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2737: p_orgph_object_version_number IN NUMBER,
2738: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2739: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2740: p_orgfax_object_version_number IN NUMBER,

Line 2738: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,

2734: p_loc_object_version_number IN NUMBER,
2735: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2736: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2737: p_orgph_object_version_number IN NUMBER,
2738: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2739: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2740: p_orgfax_object_version_number IN NUMBER,
2741: p_create_party_rel IN VARCHAR2,
2742: p_created_by_module IN VARCHAR2,

Line 2739: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

2735: p_orgph_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2736: p_org_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2737: p_orgph_object_version_number IN NUMBER,
2738: p_orgfax_contact_point_rec IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
2739: p_org_fax_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2740: p_orgfax_object_version_number IN NUMBER,
2741: p_create_party_rel IN VARCHAR2,
2742: p_created_by_module IN VARCHAR2,
2743: x_person_party_id OUT NOCOPY NUMBER,

Line 2802: l_email_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_email_contact_point_rec;

2798: l_loc_object_version_number NUMBER := p_loc_object_version_number;
2799: l_orgph_object_version_number NUMBER := p_orgph_object_version_number;
2800: l_orgfax_object_version_number NUMBER := p_orgfax_object_version_number;
2801:
2802: l_email_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_email_contact_point_rec;
2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;
2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;
2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;

Line 2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;

2799: l_orgph_object_version_number NUMBER := p_orgph_object_version_number;
2800: l_orgfax_object_version_number NUMBER := p_orgfax_object_version_number;
2801:
2802: l_email_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_email_contact_point_rec;
2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;
2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;
2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;
2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;

Line 2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;

2800: l_orgfax_object_version_number NUMBER := p_orgfax_object_version_number;
2801:
2802: l_email_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_email_contact_point_rec;
2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;
2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;
2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;
2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;
2808:

Line 2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;

2801:
2802: l_email_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_email_contact_point_rec;
2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;
2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;
2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;
2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;
2808:
2809: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;

Line 2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;

2802: l_email_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_email_contact_point_rec;
2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;
2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;
2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;
2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;
2808:
2809: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
2810:

Line 2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;

2803: l_workph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_workph_contact_point_rec;
2804: l_homeph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_homeph_contact_point_rec;
2805: l_fax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_fax_contact_point_rec;
2806: l_orgph_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgph_contact_point_rec;
2807: l_orgfax_contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type := p_orgfax_contact_point_rec;
2808:
2809: l_org_name HZ_PARTIES.PARTY_NAME%TYPE := null;
2810:
2811: l_person_party_id NUMBER := l_person_rec.party_rec.party_id;

Line 3205: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_email_contact_point API');

3201: END IF;
3202: -- calling TCA API to create_email_contact_points
3203: IF (l_email_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or l_email_contact_point_rec.contact_point_id is NULL) THEN
3204: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3205: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_email_contact_point API');
3206: END IF;
3207:
3208: l_email_contact_point_rec.status := 'A';
3209: l_email_contact_point_rec.owner_table_name := 'HZ_PARTIES';

Line 3219: HZ_CONTACT_POINT_V2PUB.create_email_contact_point (

3215: IF ( l_email_contact_point_rec.owner_table_id = FND_API.G_MISS_NUM or l_email_contact_point_rec.owner_table_id is null) THEN
3216: l_email_contact_point_rec.owner_table_id := l_party_id;
3217: END IF;
3218:
3219: HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
3220: p_contact_point_rec => l_email_contact_point_rec,
3221: p_email_rec => p_email_rec,
3222: x_contact_point_id => l_email_contact_point_id,
3223: x_return_status => x_return_status,

Line 3228: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point');

3224: x_msg_count => x_msg_count,
3225: x_msg_data => x_msg_data);
3226:
3227: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3228: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
3229: END IF;
3230:
3231: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3232: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_return_status : '|| x_return_status);

Line 3232: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_return_status : '|| x_return_status);

3228: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point');
3229: END IF;
3230:
3231: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3232: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_return_status : '|| x_return_status);
3233: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_count : '|| x_msg_count);
3234: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_data :' || x_msg_data);
3235: END IF;
3236: ELSIF ( l_email_object_version_number <> FND_API.G_MISS_NUM ) THEN

Line 3233: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_count : '|| x_msg_count);

3229: END IF;
3230:
3231: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3232: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_return_status : '|| x_return_status);
3233: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_count : '|| x_msg_count);
3234: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_data :' || x_msg_data);
3235: END IF;
3236: ELSIF ( l_email_object_version_number <> FND_API.G_MISS_NUM ) THEN
3237: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3234: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_data :' || x_msg_data);

3230:
3231: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3232: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_return_status : '|| x_return_status);
3233: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_count : '|| x_msg_count);
3234: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_data :' || x_msg_data);
3235: END IF;
3236: ELSIF ( l_email_object_version_number <> FND_API.G_MISS_NUM ) THEN
3237: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3238: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_email_contact_point API');

Line 3238: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_email_contact_point API');

3234: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_email_contact_point - x_msg_data :' || x_msg_data);
3235: END IF;
3236: ELSIF ( l_email_object_version_number <> FND_API.G_MISS_NUM ) THEN
3237: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3238: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_email_contact_point API');
3239: END IF;
3240: IBE_UTIL.debug('Email Object Version Number' || l_email_object_version_number);
3241: HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
3242: p_contact_point_rec => l_email_contact_point_rec,

Line 3241: HZ_CONTACT_POINT_V2PUB.update_email_contact_point (

3237: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3238: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_email_contact_point API');
3239: END IF;
3240: IBE_UTIL.debug('Email Object Version Number' || l_email_object_version_number);
3241: HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
3242: p_contact_point_rec => l_email_contact_point_rec,
3243: p_email_rec => p_email_rec,
3244: p_object_version_number => l_email_object_version_number,
3245: x_return_status => x_return_status,

Line 3250: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point');

3246: x_msg_count => x_msg_count,
3247: x_msg_data => x_msg_data);
3248:
3249: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3250: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point');
3251: END IF;
3252:
3253: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3254: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_return_status : '|| x_return_status);

Line 3254: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_return_status : '|| x_return_status);

3250: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point');
3251: END IF;
3252:
3253: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3254: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_return_status : '|| x_return_status);
3255: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_count : '|| x_msg_count);
3256: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_data :' || x_msg_data);
3257: END IF;
3258: END IF;

Line 3255: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_count : '|| x_msg_count);

3251: END IF;
3252:
3253: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3254: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_return_status : '|| x_return_status);
3255: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_count : '|| x_msg_count);
3256: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_data :' || x_msg_data);
3257: END IF;
3258: END IF;
3259:

Line 3256: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_data :' || x_msg_data);

3252:
3253: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3254: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_return_status : '|| x_return_status);
3255: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_count : '|| x_msg_count);
3256: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_email_contact_point - x_msg_data :' || x_msg_data);
3257: END IF;
3258: END IF;
3259:
3260: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3278: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_workph_contact_point API');

3274: END IF;
3275:
3276: IF (l_workph_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or l_workph_contact_point_rec.contact_point_id is NULL) THEN
3277: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3278: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_workph_contact_point API');
3279: END IF;
3280:
3281: l_workph_contact_point_rec.status := 'A';
3282: l_workph_contact_point_rec.owner_table_name := 'HZ_PARTIES';

Line 3292: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

3288: IF ( l_workph_contact_point_rec.owner_table_id= FND_API.G_MISS_NUM or l_workph_contact_point_rec.owner_table_id is null) THEN
3289: l_workph_contact_point_rec.owner_table_id := l_party_id;
3290: END IF;
3291:
3292: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3293: p_contact_point_rec => l_workph_contact_point_rec,
3294: p_phone_rec => p_work_phone_rec,
3295: x_contact_point_id => l_workph_contact_point_id,
3296: x_return_status => x_return_status,

Line 3301: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point');

3297: x_msg_count => x_msg_count,
3298: x_msg_data => x_msg_data);
3299:
3300: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3301: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point');
3302: END IF;
3303:
3304: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3305: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_return_status : '|| x_return_status);

Line 3305: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_return_status : '|| x_return_status);

3301: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point');
3302: END IF;
3303:
3304: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3305: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_return_status : '|| x_return_status);
3306: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_count : '|| x_msg_count);
3307: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_data :' || x_msg_data);
3308: END IF;
3309: ELSIF ( l_workph_object_version_number <> FND_API.G_MISS_NUM ) THEN

Line 3306: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_count : '|| x_msg_count);

3302: END IF;
3303:
3304: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3305: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_return_status : '|| x_return_status);
3306: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_count : '|| x_msg_count);
3307: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_data :' || x_msg_data);
3308: END IF;
3309: ELSIF ( l_workph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3310: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3307: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_data :' || x_msg_data);

3303:
3304: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3305: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_return_status : '|| x_return_status);
3306: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_count : '|| x_msg_count);
3307: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_data :' || x_msg_data);
3308: END IF;
3309: ELSIF ( l_workph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3310: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3311: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_workph_contact_point API');

Line 3311: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_workph_contact_point API');

3307: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_workph_contact_point - x_msg_data :' || x_msg_data);
3308: END IF;
3309: ELSIF ( l_workph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3310: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3311: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_workph_contact_point API');
3312: END IF;
3313:
3314: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3315: p_contact_point_rec => l_workph_contact_point_rec,

Line 3314: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

3310: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3311: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_workph_contact_point API');
3312: END IF;
3313:
3314: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3315: p_contact_point_rec => l_workph_contact_point_rec,
3316: p_phone_rec => p_work_phone_rec,
3317: p_object_version_number => l_workph_object_version_number,
3318: x_return_status => x_return_status,

Line 3323: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point');

3319: x_msg_count => x_msg_count,
3320: x_msg_data => x_msg_data);
3321:
3322: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3323: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point');
3324: END IF;
3325:
3326: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3327: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_return_status : '|| x_return_status);

Line 3327: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_return_status : '|| x_return_status);

3323: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point');
3324: END IF;
3325:
3326: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3327: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_return_status : '|| x_return_status);
3328: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_count : '|| x_msg_count);
3329: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_data :' || x_msg_data);
3330: END IF;
3331: END IF;

Line 3328: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_count : '|| x_msg_count);

3324: END IF;
3325:
3326: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3327: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_return_status : '|| x_return_status);
3328: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_count : '|| x_msg_count);
3329: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_data :' || x_msg_data);
3330: END IF;
3331: END IF;
3332:

Line 3329: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_data :' || x_msg_data);

3325:
3326: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3327: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_return_status : '|| x_return_status);
3328: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_count : '|| x_msg_count);
3329: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_workph_contact_point - x_msg_data :' || x_msg_data);
3330: END IF;
3331: END IF;
3332:
3333: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3351: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point API');

3347: END IF;
3348:
3349: IF (l_homeph_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or l_homeph_contact_point_rec.contact_point_id is NULL) THEN
3350: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3351: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point API');
3352: END IF;
3353:
3354: l_homeph_contact_point_rec.status := 'A';
3355: l_homeph_contact_point_rec.owner_table_name := 'HZ_PARTIES';

Line 3365: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

3361: IF ( l_homeph_contact_point_rec.owner_table_id = FND_API.G_MISS_NUM or l_homeph_contact_point_rec.owner_table_id is null) THEN
3362: l_homeph_contact_point_rec.owner_table_id := l_party_id;
3363: END IF;
3364:
3365: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3366: p_contact_point_rec => l_homeph_contact_point_rec,
3367: p_phone_rec => p_home_phone_rec,
3368: x_contact_point_id => l_homeph_contact_point_id,
3369: x_return_status => x_return_status,

Line 3374: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point');

3370: x_msg_count => x_msg_count,
3371: x_msg_data => x_msg_data);
3372:
3373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3374: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point');
3375: END IF;
3376:
3377: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3378: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_return_status : '|| x_return_status);

Line 3378: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_return_status : '|| x_return_status);

3374: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point');
3375: END IF;
3376:
3377: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3378: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_return_status : '|| x_return_status);
3379: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_count : '|| x_msg_count);
3380: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_data :' || x_msg_data);
3381: END IF;
3382: ELSIF ( l_homeph_object_version_number <> FND_API.G_MISS_NUM ) THEN

Line 3379: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_count : '|| x_msg_count);

3375: END IF;
3376:
3377: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3378: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_return_status : '|| x_return_status);
3379: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_count : '|| x_msg_count);
3380: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_data :' || x_msg_data);
3381: END IF;
3382: ELSIF ( l_homeph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3380: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_data :' || x_msg_data);

3376:
3377: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3378: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_return_status : '|| x_return_status);
3379: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_count : '|| x_msg_count);
3380: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_data :' || x_msg_data);
3381: END IF;
3382: ELSIF ( l_homeph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3384: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point API');

Line 3384: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point API');

3380: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_homeph_contact_point - x_msg_data :' || x_msg_data);
3381: END IF;
3382: ELSIF ( l_homeph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3384: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point API');
3385: END IF;
3386:
3387: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3388: p_contact_point_rec => l_homeph_contact_point_rec,

Line 3387: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

3383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3384: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point API');
3385: END IF;
3386:
3387: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3388: p_contact_point_rec => l_homeph_contact_point_rec,
3389: p_phone_rec => p_home_phone_rec,
3390: p_object_version_number => l_homeph_object_version_number,
3391: x_return_status => x_return_status,

Line 3396: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point');

3392: x_msg_count => x_msg_count,
3393: x_msg_data => x_msg_data);
3394:
3395: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3396: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point');
3397: END IF;
3398:
3399: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3400: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_return_status : '|| x_return_status);

Line 3400: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_return_status : '|| x_return_status);

3396: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point');
3397: END IF;
3398:
3399: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3400: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_return_status : '|| x_return_status);
3401: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_count : '|| x_msg_count);
3402: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_data :' || x_msg_data);
3403: END IF;
3404: END IF;

Line 3401: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_count : '|| x_msg_count);

3397: END IF;
3398:
3399: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3400: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_return_status : '|| x_return_status);
3401: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_count : '|| x_msg_count);
3402: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_data :' || x_msg_data);
3403: END IF;
3404: END IF;
3405:

Line 3402: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_data :' || x_msg_data);

3398:
3399: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3400: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_return_status : '|| x_return_status);
3401: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_count : '|| x_msg_count);
3402: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point - x_msg_data :' || x_msg_data);
3403: END IF;
3404: END IF;
3405:
3406: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3423: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_fax_contact_point API');

3419: END IF;
3420:
3421: IF (l_fax_contact_point_rec.contact_point_id = FND_API.G_MISS_NUM or l_fax_contact_point_rec.contact_point_id is NULL) THEN
3422: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3423: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_fax_contact_point API');
3424: END IF;
3425:
3426: l_fax_contact_point_rec.status := 'A';
3427: l_fax_contact_point_rec.owner_table_name := 'HZ_PARTIES';

Line 3437: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

3433: IF ( l_fax_contact_point_rec.owner_table_id = FND_API.G_MISS_NUM or l_fax_contact_point_rec.owner_table_id is null) THEN
3434: l_fax_contact_point_rec.owner_table_id := l_party_id;
3435: END IF;
3436:
3437: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3438: p_contact_point_rec => l_fax_contact_point_rec,
3439: p_phone_rec => p_fax_rec,
3440: x_contact_point_id => l_fax_contact_point_id,
3441: x_return_status => x_return_status,

Line 3446: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point');

3442: x_msg_count => x_msg_count,
3443: x_msg_data => x_msg_data);
3444:
3445: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3446: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point');
3447: END IF;
3448:
3449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3450: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_return_status : '|| x_return_status);

Line 3450: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_return_status : '|| x_return_status);

3446: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point');
3447: END IF;
3448:
3449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3450: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_return_status : '|| x_return_status);
3451: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_count : '|| x_msg_count);
3452: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_data :' || x_msg_data);
3453: END IF;
3454: ELSIF ( l_fax_object_version_number <> FND_API.G_MISS_NUM ) THEN

Line 3451: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_count : '|| x_msg_count);

3447: END IF;
3448:
3449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3450: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_return_status : '|| x_return_status);
3451: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_count : '|| x_msg_count);
3452: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_data :' || x_msg_data);
3453: END IF;
3454: ELSIF ( l_fax_object_version_number <> FND_API.G_MISS_NUM ) THEN
3455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 3452: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_data :' || x_msg_data);

3448:
3449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3450: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_return_status : '|| x_return_status);
3451: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_count : '|| x_msg_count);
3452: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_data :' || x_msg_data);
3453: END IF;
3454: ELSIF ( l_fax_object_version_number <> FND_API.G_MISS_NUM ) THEN
3455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3456: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_fax_contact_point API');

Line 3456: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_fax_contact_point API');

3452: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_fax_contact_point - x_msg_data :' || x_msg_data);
3453: END IF;
3454: ELSIF ( l_fax_object_version_number <> FND_API.G_MISS_NUM ) THEN
3455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3456: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_fax_contact_point API');
3457: END IF;
3458:
3459: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3460: p_contact_point_rec => l_fax_contact_point_rec,

Line 3459: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

3455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3456: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_fax_contact_point API');
3457: END IF;
3458:
3459: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3460: p_contact_point_rec => l_fax_contact_point_rec,
3461: p_phone_rec => p_fax_rec,
3462: p_object_version_number => l_fax_object_version_number,
3463: x_return_status => x_return_status,

Line 3468: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point');

3464: x_msg_count => x_msg_count,
3465: x_msg_data => x_msg_data);
3466:
3467: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3468: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point');
3469: END IF;
3470:
3471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3472: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_return_status : '|| x_return_status);

Line 3472: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_return_status : '|| x_return_status);

3468: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point');
3469: END IF;
3470:
3471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3472: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_return_status : '|| x_return_status);
3473: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_count : '|| x_msg_count);
3474: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_data :' || x_msg_data);
3475: END IF;
3476: END IF;

Line 3473: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_count : '|| x_msg_count);

3469: END IF;
3470:
3471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3472: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_return_status : '|| x_return_status);
3473: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_count : '|| x_msg_count);
3474: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_data :' || x_msg_data);
3475: END IF;
3476: END IF;
3477:

Line 3474: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_data :' || x_msg_data);

3470:
3471: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3472: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_return_status : '|| x_return_status);
3473: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_count : '|| x_msg_count);
3474: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_fax_contact_point - x_msg_data :' || x_msg_data);
3475: END IF;
3476: END IF;
3477:
3478: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3511: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point API');

3507: l_orgph_contact_point_rec.owner_table_id := l_org_party_id;
3508: END IF;
3509:
3510: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3511: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point API');
3512: END IF;
3513:
3514: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3515: p_contact_point_rec => l_orgph_contact_point_rec,

Line 3514: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

3510: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3511: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point API');
3512: END IF;
3513:
3514: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3515: p_contact_point_rec => l_orgph_contact_point_rec,
3516: p_phone_rec => p_org_phone_rec,
3517: x_contact_point_id => l_orgph_contact_point_id,
3518: x_return_status => x_return_status,

Line 3523: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point');

3519: x_msg_count => x_msg_count,
3520: x_msg_data => x_msg_data);
3521:
3522: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3523: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point');
3524: END IF;
3525:
3526: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3527: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_return_status : '|| x_return_status);

Line 3527: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_return_status : '|| x_return_status);

3523: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point');
3524: END IF;
3525:
3526: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3527: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_return_status : '|| x_return_status);
3528: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_count : '|| x_msg_count);
3529: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_data :' || x_msg_data);
3530: END IF;
3531: END IF;

Line 3528: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_count : '|| x_msg_count);

3524: END IF;
3525:
3526: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3527: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_return_status : '|| x_return_status);
3528: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_count : '|| x_msg_count);
3529: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_data :' || x_msg_data);
3530: END IF;
3531: END IF;
3532: ELSIF ( l_orgph_contact_point_rec.contact_point_id <> FND_API.G_MISS_NUM or l_orgph_contact_point_rec.contact_point_id is not NULL

Line 3529: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_data :' || x_msg_data);

3525:
3526: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3527: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_return_status : '|| x_return_status);
3528: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_count : '|| x_msg_count);
3529: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgPh_contact_point - x_msg_data :' || x_msg_data);
3530: END IF;
3531: END IF;
3532: ELSIF ( l_orgph_contact_point_rec.contact_point_id <> FND_API.G_MISS_NUM or l_orgph_contact_point_rec.contact_point_id is not NULL
3533: AND l_orgph_object_version_number <> FND_API.G_MISS_NUM ) THEN

Line 3535: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point API');

3531: END IF;
3532: ELSIF ( l_orgph_contact_point_rec.contact_point_id <> FND_API.G_MISS_NUM or l_orgph_contact_point_rec.contact_point_id is not NULL
3533: AND l_orgph_object_version_number <> FND_API.G_MISS_NUM ) THEN
3534: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3535: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point API');
3536: END IF;
3537:
3538: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3539: p_contact_point_rec => l_orgph_contact_point_rec,

Line 3538: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

3534: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3535: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point API');
3536: END IF;
3537:
3538: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3539: p_contact_point_rec => l_orgph_contact_point_rec,
3540: p_phone_rec => p_org_phone_rec,
3541: p_object_version_number => l_orgph_object_version_number,
3542: x_return_status => x_return_status,

Line 3547: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point');

3543: x_msg_count => x_msg_count,
3544: x_msg_data => x_msg_data);
3545:
3546: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3547: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point');
3548: END IF;
3549:
3550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3551: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_return_status : '|| x_return_status);

Line 3551: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_return_status : '|| x_return_status);

3547: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point');
3548: END IF;
3549:
3550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3551: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_return_status : '|| x_return_status);
3552: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_count : '|| x_msg_count);
3553: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_data :' || x_msg_data);
3554: END IF;
3555: END IF;

Line 3552: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_count : '|| x_msg_count);

3548: END IF;
3549:
3550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3551: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_return_status : '|| x_return_status);
3552: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_count : '|| x_msg_count);
3553: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_data :' || x_msg_data);
3554: END IF;
3555: END IF;
3556:

Line 3553: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_data :' || x_msg_data);

3549:
3550: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3551: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_return_status : '|| x_return_status);
3552: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_count : '|| x_msg_count);
3553: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point - x_msg_data :' || x_msg_data);
3554: END IF;
3555: END IF;
3556:
3557: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3589: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point API');

3585: l_orgfax_contact_point_rec.owner_table_id := l_org_party_id;
3586: END IF;
3587:
3588: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3589: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point API');
3590: END IF;
3591:
3592: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3593: p_contact_point_rec => l_orgfax_contact_point_rec,

Line 3592: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (

3588: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3589: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point API');
3590: END IF;
3591:
3592: HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
3593: p_contact_point_rec => l_orgfax_contact_point_rec,
3594: p_phone_rec => p_org_fax_rec,
3595: x_contact_point_id => l_orgfax_contact_point_id,
3596: x_return_status => x_return_status,

Line 3601: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point');

3597: x_msg_count => x_msg_count,
3598: x_msg_data => x_msg_data);
3599:
3600: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3601: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point');
3602: END IF;
3603:
3604: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3605: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_return_status : '|| x_return_status);

Line 3605: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_return_status : '|| x_return_status);

3601: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point');
3602: END IF;
3603:
3604: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3605: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_return_status : '|| x_return_status);
3606: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_count : '|| x_msg_count);
3607: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_data :' || x_msg_data);
3608: END IF;
3609: END IF;

Line 3606: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_count : '|| x_msg_count);

3602: END IF;
3603:
3604: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3605: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_return_status : '|| x_return_status);
3606: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_count : '|| x_msg_count);
3607: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_data :' || x_msg_data);
3608: END IF;
3609: END IF;
3610: ELSIF ( l_orgfax_contact_point_rec.owner_table_id <> FND_API.G_MISS_NUM AND l_orgfax_contact_point_rec.owner_table_id is not null

Line 3607: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_data :' || x_msg_data);

3603:
3604: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3605: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_return_status : '|| x_return_status);
3606: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_count : '|| x_msg_count);
3607: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.create_orgFax_contact_point - x_msg_data :' || x_msg_data);
3608: END IF;
3609: END IF;
3610: ELSIF ( l_orgfax_contact_point_rec.owner_table_id <> FND_API.G_MISS_NUM AND l_orgfax_contact_point_rec.owner_table_id is not null
3611: AND l_orgfax_object_version_number <> FND_API.G_MISS_NUM ) THEN

Line 3613: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point API');

3609: END IF;
3610: ELSIF ( l_orgfax_contact_point_rec.owner_table_id <> FND_API.G_MISS_NUM AND l_orgfax_contact_point_rec.owner_table_id is not null
3611: AND l_orgfax_object_version_number <> FND_API.G_MISS_NUM ) THEN
3612: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3613: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point API');
3614: END IF;
3615:
3616: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3617: p_contact_point_rec => l_orgfax_contact_point_rec,

Line 3616: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (

3612: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3613: IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point API');
3614: END IF;
3615:
3616: HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
3617: p_contact_point_rec => l_orgfax_contact_point_rec,
3618: p_phone_rec => p_org_fax_rec,
3619: p_object_version_number => l_orgfax_object_version_number,
3620: x_return_status => x_return_status,

Line 3625: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point');

3621: x_msg_count => x_msg_count,
3622: x_msg_data => x_msg_data);
3623:
3624: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3625: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point');
3626: END IF;
3627:
3628: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3629: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_return_status : '|| x_return_status);

Line 3629: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_return_status : '|| x_return_status);

3625: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point');
3626: END IF;
3627:
3628: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3629: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_return_status : '|| x_return_status);
3630: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_count : '|| x_msg_count);
3631: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_data :' || x_msg_data);
3632: END IF;
3633: END IF;

Line 3630: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_count : '|| x_msg_count);

3626: END IF;
3627:
3628: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3629: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_return_status : '|| x_return_status);
3630: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_count : '|| x_msg_count);
3631: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_data :' || x_msg_data);
3632: END IF;
3633: END IF;
3634:

Line 3631: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_data :' || x_msg_data);

3627:
3628: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3629: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_return_status : '|| x_return_status);
3630: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_count : '|| x_msg_count);
3631: IBE_UTIL.debug('After call to HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point - x_msg_data :' || x_msg_data);
3632: END IF;
3633: END IF;
3634:
3635: if x_return_status <> FND_API.G_RET_STS_SUCCESS then