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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 115


   	IBE_UTIL.debug('Before call to Update_Contact_Preference');

Line: 118


	Update_Contact_Preference(p_party_id => x_person_party_id,
					p_preference => l_preference,
                    		p_object_version_number => null,
					p_created_by_module => G_CREATED_BY_MODULE,
					x_return_status => x_return_status,
					x_msg_count => x_msg_count,
					x_msg_data => x_msg_data);

Line: 127


       	IBE_UTIL.debug('After call to Update_Contact_Preference - x_return_status : '|| x_return_status);

Line: 128


   	IBE_UTIL.debug('After call to Update_Contact_Preference - x_msg_count : '|| x_msg_count);

Line: 129


   	IBE_UTIL.debug('After call to Update_Contact_Preference  - x_msg_data : '|| x_msg_data);

Line: 139


       IBE_UTIL.debug('After call to Update_Contact_Preference - x_contact_preference_id : ' || l_contact_preference_id);

Line: 264


|     - Update_Contact_Preference
|     - Create_User
|
+=======================================================================*/

Procedure Create_Business_User(
		p_username    	       	IN	VARCHAR2,
		p_password         	IN	VARCHAR2,
		p_person_rec 	    	IN	HZ_PARTY_V2PUB.person_rec_type,
     	p_organization_rec    	IN	HZ_PARTY_V2PUB.organization_rec_type,
     	p_location_rec         	IN	HZ_LOCATION_V2PUB.location_rec_type,
     	p_org_phone_rec     	IN	HZ_CONTACT_POINT_V2PUB.phone_rec_type,
     	p_org_fax_rec  		IN	HZ_CONTACT_POINT_V2PUB.phone_rec_type,
		p_rel_workphone_rec 	IN	HZ_CONTACT_POINT_V2PUB.phone_rec_type,
     	p_rel_homephone_rec 	IN	HZ_CONTACT_POINT_V2PUB.phone_rec_type,
     	p_rel_fax_rec	     	IN	HZ_CONTACT_POINT_V2PUB.phone_rec_type,
		p_rel_email_rec	    	IN	HZ_CONTACT_POINT_V2PUB.email_rec_type,
		p_rel_contact_preference 	IN	VARCHAR2,
		x_person_party_id     	OUT NOCOPY	NUMBER,
     	x_rel_party_id       	OUT NOCOPY	NUMBER,
     	x_org_party_id        	OUT NOCOPY	NUMBER,
		x_user_id               OUT NOCOPY	NUMBER,
     	x_return_status      	OUT NOCOPY	VARCHAR2,
     	x_msg_count    		OUT NOCOPY	NUMBER,
     	x_msg_data       	OUT NOCOPY	VARCHAR2) is

     	l_preference	VARCHAR2(30);

Line: 462


      IBE_UTIL.debug('Before Update_Contact_Preference');

Line: 464


    Update_Contact_Preference(
                p_party_id => x_rel_party_id ,
                p_preference => l_preference,
                p_object_version_number => null,
                p_created_by_module => G_CREATED_BY_MODULE,
                x_return_status => x_return_status,
                x_msg_count      =>  x_msg_count,
                x_msg_data  =>  x_msg_data)  ;

Line: 478


   	 IBE_UTIL.debug('After call to Update_Contact_Preference - x_return_status : '|| x_return_status);

Line: 479


   	IBE_UTIL.debug('After call to Update_Contact_Preference - x_msg_count : '|| x_msg_count);

Line: 480


   	IBE_UTIL.debug('After call to Update_Contact_Preference  - x_msg_data : '|| x_msg_data);

Line: 705


	     select hz_party_number_s.nextval into l_rel_party_number from dual;

Line: 923


      select hz_party_number_s.nextval into l_party_number from dual;

Line: 1176


	   select hz_party_number_s.nextval into l_party_number from dual;

Line: 1642


|    Update_Contact_Preference
|
| DESCRIPTION
|    This API is called By Create_Individual_User,
|                          Creat_Business_User
|
|
| USAGE
|
|    -     Create Contact Prefernece in HZ_CONTACT_PREFERNECE_V2PUB
|
|
|  REFERENCED APIS
|     This API calls the following APIs
|    -  HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference if no row exists
|    -  HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference if row exists
+=============================================================================*/
PROCEDURE Update_Contact_Preference(
    p_party_id           IN    NUMBER,
    p_preference         IN    VARCHAR2,
    p_object_version_number IN NUMBER,
    p_created_by_module  IN    VARCHAR2,
    x_return_status      OUT NOCOPY  VARCHAR2,
    x_msg_count          OUT NOCOPY  NUMBER,
    x_msg_data           OUT NOCOPY  VARCHAR2

   )
IS
    l_contact_preference_rec                hz_contact_preference_v2pub.contact_preference_rec_type;

Line: 1679


        IBE_UTIL.debug('enter ibe_party_v2pvt.update_contact_preference');

Line: 1687


      SELECT contact_preference_id, object_version_number
      INTO   l_id , l_object_version_number
      From   hz_contact_preferences
      WHERE  contact_level_table='HZ_PARTIES'
      AND    contact_level_table_id=p_party_id;

Line: 1700


         IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

Line: 1702


      HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
            FND_API.G_FALSE,
            l_contact_preference_rec,
            l_object_version_number,
            x_return_status,
            x_msg_count,
            x_msg_data
        );

Line: 1711


   	IBE_UTIL.debug('After Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

Line: 1716


   	       IBE_UTIL.debug('Got No Data Found Exception in update_contact_preference');

Line: 1823


END Update_Contact_Preference;

Line: 1827


|    Update_Person_Language
|
| DESCRIPTION
|  If the API finds a language preference for the given party then it updates
|  the primary indicator to 'N' then it sets the new language as the primary
|  language. If it does not find any language preference for the party then
|  it creates a new one and makrs it primary
|
| USAGE
|
|    -     Create Person Language preference in HZ_PERSON_INFO_V2PUB
|
|
|  REFERENCED APIS
|     This API calls the following APIs
|    -  HZ_PERSON_INFO_V2PUB.create_person_language if no row exists
|    -  HZ_PERSON_INFO_V2PUB.update_person_language if row exists
+======================================================================*/
PROCEDURE Update_Person_Language(
    p_party_id		     IN    NUMBER,
    p_language_name      IN    VARCHAR2,
    p_created_by_module  IN    VARCHAR2,
    x_return_status      OUT NOCOPY  VARCHAR2,
    x_msg_count          OUT NOCOPY  NUMBER,
    x_msg_data           OUT NOCOPY  VARCHAR2
    )
IS
    l_per_language_rec   hz_person_info_v2pub.person_language_rec_type;

Line: 1863


   	IBE_UTIL.debug('enter ibe_party_v2pvt.update_person_language');

Line: 1871


    SELECT language_use_reference_id, object_version_number
    INTO   l_id, l_object_version_number
    FROM   hz_person_language
    WHERE  party_id=p_party_id and primary_language_indicator='Y';

Line: 1880


       IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary');

Line: 1882


    hz_person_info_v2pub.update_person_language(
            p_person_language_rec => l_per_language_rec,
            p_object_version_number => l_object_version_number,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data);

Line: 1889


       IBE_UTIL.debug(' After Call HZ_PERSON_INFO_V2PUB.update_person_language APIto unset primary');

Line: 1898


      SELECT language_use_reference_id, object_version_number
      INTO   l_id, l_object_version_number
      FROM   hz_person_language
      WHERE  party_id=p_party_id
      AND    language_name=p_language_name
      AND   nvl(status,'A') = 'A';

Line: 1910


        IBE_UTIL.debug('Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');

Line: 1912


     hz_person_info_v2pub.update_person_language(
            p_person_language_rec => l_per_language_rec2,
            p_object_version_number => l_object_version_number,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data);

Line: 1920


         IBE_UTIL.debug('After Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary');

Line: 2009


END update_person_language;

Line: 2078


        SELECT hz_account_num_s.nextval INTO l_account_number
        FROM dual;

Line: 2082


        SELECT COUNT(*) INTO l_count
        FROM hz_cust_accounts
        WHERE account_number = l_account_number;

Line: 2209


|    Update_Party_Status
|
| DESCRIPTION
|    This API is used to update party and all party_related TCA entity status
|
| USAGE
|    - Activate Party and Inactivate Party
|
|  REFERENCED APIS
|     This API calls the following APIs to update the TCA Entity Status
|       - Hz_party_v2pub.update_person
|       - Hz_party_contact_v2pub.update_org_contact
|       - Hz_party_v2pub.update_organization
|       - Hz_cust_account_v2pub.update_cust_account
|       - Hz_cust_account_role_v2pub.update_cust_account_role
|       - Hz_contact_point_v2pub.update_contact_point
|       - Hz_party_site_v2pub.update_party_site
|       - HZ_.update_contact_preferences
+======================================================================*/
Procedure Update_Party_Status(
         p_party_id	        IN	NUMBER,
         p_party_status         IN      VARCHAR2,
         p_change_org_status    IN      VARCHAR2 := FND_API.G_FALSE,
         p_commit               IN      VARCHAR2 := FND_API.G_FALSE,
         x_return_status        OUT     NOCOPY	VARCHAR2,
         x_msg_count            OUT     NOCOPY    NUMBER,
         x_msg_data             OUT     NOCOPY    VARCHAR2) is

    --TCA Records for updation
    l_person_rec        hz_party_v2pub.person_rec_type;

Line: 2258


      select p.party_type, p.status, p.object_version_number,
             rel.relationship_id,rel.object_version_number rel_object_version_number,
             oc.org_contact_id,oc.object_version_number cont_object_version_number,
             a.cust_account_id,a.object_version_number acct_object_version_number
      from   hz_parties p, hz_relationships rel,hz_cust_accounts a,hz_org_contacts oc
      where  p.party_id = l_party_id and rel.party_id(+) = p.party_id and a.party_id(+) = p.party_id
             and oc.party_relationship_id(+) = rel.relationship_id and rownum <2;

Line: 2268


     select contact_point_id,object_version_number
     from hz_contact_points
     where owner_table_id = l_party_id
     and owner_table_name = 'HZ_PARTIES';

Line: 2275


     select party_site_id,location_id,object_version_number
     from hz_party_sites
     where party_id = l_party_id;

Line: 2281


     select subject_id,object_id from hz_relationships
     where party_id = l_party_id and subject_type = 'ORGANIZATION';

Line: 2285


     select cust_account_role_id,object_version_number
     from hz_cust_account_roles
     where party_id = l_party_id;

Line: 2291


     select contact_preference_id,object_version_number
     from hz_contact_preferences
     where contact_level_table_id = l_party_id;

Line: 2298


      IBE_UTIL.debug('Begin ibe_party_v2pvt.update_party_status');

Line: 2324


         IBE_UTIL.debug('DB Party Status and Input Party_Status are not equal,Begin Update');

Line: 2328


           IBE_UTIL.debug('Update Person Rec');

Line: 2332


        hz_party_v2pub.update_person
         (p_person_rec => l_person_rec,
          p_party_object_version_number => rec_party_info.object_version_number,
          x_profile_id => l_person_profile_id,
          x_return_status => x_return_status,
          x_msg_count => x_msg_count,
          x_msg_data     => x_msg_data
         );

Line: 2341


           IBE_UTIL.debug('x_msg_count from update_person'||x_msg_count);

Line: 2342


           IBE_UTIL.debug('x_msg_data from update_person'||x_msg_data);

Line: 2347


           IBE_UTIL.debug('Update OrgContact with Party Rel');

Line: 2354


        hz_party_contact_v2pub.update_org_contact
         (p_org_contact_rec => l_org_contact_rec,
          p_cont_object_version_number => rec_party_info.cont_object_version_number,
          p_rel_object_version_number => rec_party_info.rel_object_version_number,
          p_party_object_version_number => rec_party_info.object_version_number,
          x_return_status => x_return_status,
          x_msg_count => x_msg_count,
          x_msg_data  => x_msg_data
        );

Line: 2364


           IBE_UTIL.debug('x_msg_count from update_org_contact'||x_msg_count);

Line: 2365


           IBE_UTIL.debug('x_msg_data from update_org_contact'||x_msg_data);

Line: 2374


              IBE_UTIL.debug('update person_party_id'||l_person_party_id);

Line: 2376


           update_party_status(l_person_party_id,p_party_status,FND_API.G_FALSE,FND_API.G_FALSE,x_return_status,x_msg_count,x_msg_data);

Line: 2379


                IBE_UTIL.debug('change_org_status = True, update org_id'||l_org_id);

Line: 2381


             update_party_status(l_org_id,p_party_status,FND_API.G_FALSE,FND_API.G_FALSE,x_return_status,x_msg_count,x_msg_data);

Line: 2387


           IBE_UTIL.debug('Update Organization');

Line: 2391


        hz_party_v2pub.update_organization
         (p_organization_rec => l_org_rec,
          p_party_object_version_number => rec_party_info.object_version_number,
          x_profile_id => l_person_profile_id,
          x_return_status => x_return_status,
          x_msg_count => x_msg_count,
          x_msg_data     => x_msg_data
         );

Line: 2400


           IBE_UTIL.debug('x_msg_count from update_org'||x_msg_count);

Line: 2401


           IBE_UTIL.debug('x_msg_data from update_org'||x_msg_data);

Line: 2407


           IBE_UTIL.debug('Update Account Id'||rec_party_info.cust_account_id);

Line: 2411


        hz_cust_account_v2pub.update_cust_account
         (p_cust_account_rec => l_account_rec,
          p_object_version_number => rec_party_info.acct_object_version_number,
          x_return_status => x_return_status,
          x_msg_count => x_msg_count,
          x_msg_data => x_msg_data
         );

Line: 2419


            IBE_UTIL.debug('x_msg_count from update_cust_account'||x_msg_count);

Line: 2420


            IBE_UTIL.debug('x_msg_data from update_cust_account'||x_msg_data);

Line: 2427


            IBE_UTIL.debug('Update AcctRole Id'||rec_custAcct_role.cust_account_role_id);

Line: 2431


         hz_cust_account_role_v2pub.update_cust_account_role
          (p_cust_account_role_rec => l_custacct_role_rec,
           p_object_version_number => rec_custAcct_role.object_version_number,
           x_return_status => x_return_status,
           x_msg_count => x_msg_count,
           x_msg_data  => x_msg_data
          );

Line: 2439


            IBE_UTIL.debug('x_msg_count from update_cust_account_role'||x_msg_count);

Line: 2440


            IBE_UTIL.debug('x_msg_data from update_cust_account_role'||x_msg_data);

Line: 2446


            IBE_UTIL.debug('Update Contact_Point Id'||rec_contact_point.contact_point_id);

Line: 2450


         hz_contact_point_v2pub.update_contact_point
          (p_contact_point_rec => l_contact_point_rec,
           p_object_version_number => rec_contact_point.object_version_number,
           x_return_status => x_return_status,
           x_msg_count => x_msg_count,
           x_msg_data => x_msg_data
          );

Line: 2458


             IBE_UTIL.debug('x_msg_count from update_contact_point'||x_msg_count);

Line: 2459


             IBE_UTIL.debug('x_msg_data from update_contact_point'||x_msg_data);

Line: 2467


            IBE_UTIL.debug('Update PartySite Id'||rec_party_site.party_site_id);

Line: 2471


         hz_party_site_v2pub.update_party_site
          (p_party_site_rec => l_party_site_rec,
           p_object_version_number => rec_party_site.object_version_number,
           x_return_status => x_return_status,
           x_msg_count => x_msg_count,
           x_msg_data => x_msg_data
          );

Line: 2479


             IBE_UTIL.debug('x_msg_count from update_party_site'||x_msg_count);

Line: 2480


             IBE_UTIL.debug('x_msg_data from update_party_site'||x_msg_data);

Line: 2488


            IBE_UTIL.debug('Update Preference Id'||rec_cntct_pref.contact_preference_id);

Line: 2492


         hz_contact_preference_v2pub.update_contact_preference
          (p_contact_preference_rec => l_cntct_pref_rec,
           p_object_version_number => rec_cntct_pref.object_version_number,
           x_return_status => x_return_status,
           x_msg_count => x_msg_count,
           x_msg_data => x_msg_data
          );

Line: 2500


            IBE_UTIL.debug('x_msg_count from update_contact_preference'||x_msg_count);

Line: 2501


            IBE_UTIL.debug('x_msg_data from update_contact_preference'||x_msg_data);

Line: 2568


END Update_Party_Status;

Line: 2593


   select party_id, party_name, party_number from hz_parties where party_name = x_org_name;

Line: 2595


   select party_id, party_name, party_number from hz_parties where party_number = x_org_num;

Line: 2597


   select party_id, party_name, party_number from hz_parties where party_id = x_org_id;

Line: 2699


|   HZ_PARTY_V2PUB.update_person()
|   HZ_PARTY_V2PUB.create_organization()
|   HZ_PARTY_V2PUB.update_organization()
|   HZ_LOCATION_V2PUB.create_location()
|   HZ_LOCATION_V2PUB.update_location()
|   HZ_PARTY_SITE_V2PUB.create_party_site()
|   HZ_PARTY_CONTACT_V2PUB.create_org_contact()
|   HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference()
|   HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference()
|   HZ_CONTACT_POINT_V2PUB.create_email_contact_point (
|   HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
|   HZ_CONTACT_POINT_V2PUB.create_phone_contact_point (
|   HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
|
+======================================================================*/
Procedure Save_Tca_Entities(
    p_person_rec                           IN HZ_PARTY_V2PUB.person_rec_type,
    p_person_object_version_number         IN NUMBER,
    p_email_contact_point_rec              IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
    p_email_rec                            IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
    p_email_object_version_number          IN NUMBER,
    p_workph_contact_point_rec             IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
    p_work_phone_rec                       IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
    p_workph_object_version_number         IN NUMBER,
    p_homeph_contact_point_rec             IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
    p_home_phone_rec                       IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
    p_homeph_object_version_number         IN NUMBER,
    p_fax_contact_point_rec                IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
    p_fax_rec                              IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
    p_fax_object_version_number            IN NUMBER,
    p_contact_pref_rec                     IN HZ_CONTACT_PREFERENCE_V2PUB.contact_preference_rec_type,
    p_cntct_pref_object_ver_num            IN NUMBER,
    p_organization_rec                     IN HZ_PARTY_V2PUB.organization_rec_type,
    p_org_object_version_number            IN NUMBER,
    p_location_rec                         IN HZ_LOCATION_V2PUB.location_rec_type,
    p_loc_object_version_number            IN NUMBER,
    p_orgph_contact_point_rec              IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
    p_org_phone_rec                        IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
    p_orgph_object_version_number          IN NUMBER,
    p_orgfax_contact_point_rec             IN HZ_CONTACT_POINT_V2PUB.contact_point_rec_type,
    p_org_fax_rec                          IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
    p_orgfax_object_version_number         IN NUMBER,
    p_create_party_rel                     IN VARCHAR2,
    p_created_by_module                    IN VARCHAR2,
    x_person_party_id                      OUT NOCOPY     NUMBER,
    x_rel_party_id                         OUT NOCOPY     NUMBER,
    x_org_party_id                         OUT NOCOPY     NUMBER,
    x_return_status                        OUT NOCOPY     VARCHAR2,
    x_msg_count                            OUT NOCOPY     NUMBER,
    x_msg_data                             OUT NOCOPY     VARCHAR2
)
as

    cursor c_get_party_relationship (c_subject_id NUMBER, c_object_id NUMBER) is
       SELECT party_id FROM hz_relationships
       WHERE subject_id = c_subject_id and subject_type = 'PERSON'
             and object_id = c_object_id and object_type = 'ORGANIZATION';

Line: 2758


       SELECT contact_preference_id,object_version_number FROM hz_contact_preferences
       WHERE contact_level_table_id = c_party_id and contact_level_table = c_table_name
	        and contact_type = 'ALL';

Line: 2845


            IBE_UTIL.debug('Call HZ_PARTY_V2PUB.update_person () API');

Line: 2855


       HZ_PARTY_V2PUB.Update_Person(
              p_person_rec                  =>  l_person_rec,
              p_party_object_version_number =>  l_person_object_version_number,
              x_return_status               =>  x_return_status,
              x_profile_id                  =>  l_person_profile_id,
              x_msg_count                   =>  x_msg_count,
              x_msg_data                    =>  x_msg_data);

Line: 2864


            IBE_UTIL.debug('Completed Call HZ_PARTY_V2PUB.update_person () API');

Line: 2869


       IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update person - x_return_status : '|| x_return_status);

Line: 2870


       IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update person - x_msg_count : '|| x_msg_count);

Line: 2871


       IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update person - x_msg_data :' || x_msg_data);

Line: 2902


              IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update organization - x_return_status : '|| x_return_status);

Line: 2903


              IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update organization - x_msg_count : '|| x_msg_count);

Line: 2904


             IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update organization - x_msg_data :' || x_msg_data);

Line: 2909


            IBE_UTIL.debug('Call HZ_PARTY_V2PUB.update_organization () API');

Line: 2915


       HZ_PARTY_V2PUB.Update_Organization (
                p_organization_rec             =>  l_organization_rec,
              p_party_object_version_number  =>  l_org_object_version_number,
              x_profile_id                   =>  l_org_profile_id,
              x_return_status                =>  x_return_status,
              x_msg_count                    =>  x_msg_count,
              x_msg_data                     =>  x_msg_data);

Line: 2926


            IBE_UTIL.debug('Completed Call HZ_PARTY_V2PUB.update_organization () API');

Line: 2930


          IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update organization - x_return_status : '|| x_return_status);

Line: 2931


          IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update organization - x_msg_count : '|| x_msg_count);

Line: 2932


          IBE_UTIL.debug('After call to HZ_PARTY_V2PUB.create/update organization - x_msg_data :' || x_msg_data);

Line: 3017


                IBE_UTIL.debug('Call HZ_LOCATION_V2PUB.update_location () API');

Line: 3020


            HZ_LOCATION_V2PUB.update_location (
                     p_location_rec  => l_location_rec,
                     p_object_version_number => l_loc_object_version_number,
                   x_return_status => x_return_status,
                     x_msg_count     => x_msg_count,
                 x_msg_data      => x_msg_data);

Line: 3028


                IBE_UTIL.debug('After Call to HZ_LOCATION_V2PUB.update_location API');

Line: 3032


                  IBE_UTIL.debug('After call to HZ_LOCATION_V2PUB.update_location - x_return_status : '|| x_return_status);

Line: 3033


                IBE_UTIL.debug('After call to HZ_LOCATION_V2PUB.update_location - x_msg_count : '|| x_msg_count);

Line: 3034


                IBE_UTIL.debug('After call to HZ_LOCATION_V2PUB.update_location - x_msg_data :' || x_msg_data);

Line: 3175


            IBE_UTIL.debug('Call HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

Line: 3178


        HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference(
                   p_contact_preference_rec => l_contact_pref_rec,
                   p_object_version_number  => l_cntct_pref_object_ver_num,
                   x_return_status   =>  x_return_status,
                   x_msg_count       =>  x_msg_count,
                           x_msg_data        =>  x_msg_data);

Line: 3185


            IBE_UTIL.debug('After Call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference API');

Line: 3188


           IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_return_status : '|| x_return_status);

Line: 3189


           IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_count : '|| x_msg_count);

Line: 3190


           IBE_UTIL.debug('After call to HZ_CONTACT_PREFERENCE_V2PUB.update_contact_preference - x_msg_data :' || x_msg_data);

Line: 3238


             IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_email_contact_point API');

Line: 3241


         HZ_CONTACT_POINT_V2PUB.update_email_contact_point (
                           p_contact_point_rec => l_email_contact_point_rec,
                          p_email_rec => p_email_rec,
                       p_object_version_number => l_email_object_version_number,
                          x_return_status => x_return_status,
                          x_msg_count => x_msg_count,
                            x_msg_data => x_msg_data);

Line: 3250


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

Line: 3254


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

Line: 3255


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

Line: 3256


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

Line: 3311


              IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_workph_contact_point API');

Line: 3314


          HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
                           p_contact_point_rec => l_workph_contact_point_rec,
                          p_phone_rec => p_work_phone_rec,
                       p_object_version_number => l_workph_object_version_number,
                          x_return_status => x_return_status,
                          x_msg_count => x_msg_count,
                            x_msg_data => x_msg_data);

Line: 3323


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

Line: 3327


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

Line: 3328


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

Line: 3329


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

Line: 3384


              IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_homeph_contact_point API');

Line: 3387


          HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
                           p_contact_point_rec => l_homeph_contact_point_rec,
                          p_phone_rec => p_home_phone_rec,
                       p_object_version_number => l_homeph_object_version_number,
                          x_return_status => x_return_status,
                          x_msg_count => x_msg_count,
                            x_msg_data => x_msg_data);

Line: 3396


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

Line: 3400


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

Line: 3401


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

Line: 3402


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

Line: 3456


              IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_fax_contact_point API');

Line: 3459


          HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
                           p_contact_point_rec => l_fax_contact_point_rec,
                          p_phone_rec => p_fax_rec,
                       p_object_version_number => l_fax_object_version_number,
                          x_return_status => x_return_status,
                          x_msg_count => x_msg_count,
                            x_msg_data => x_msg_data);

Line: 3468


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

Line: 3472


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

Line: 3473


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

Line: 3474


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

Line: 3535


              IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgPh_contact_point API');

Line: 3538


          HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
                           p_contact_point_rec => l_orgph_contact_point_rec,
                          p_phone_rec => p_org_phone_rec,
                       p_object_version_number => l_orgph_object_version_number,
                          x_return_status => x_return_status,
                          x_msg_count => x_msg_count,
                            x_msg_data => x_msg_data);

Line: 3547


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

Line: 3551


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

Line: 3552


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

Line: 3553


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

Line: 3613


              IBE_UTIL.debug('Call HZ_CONTACT_POINT_V2PUB.update_orgFax_contact_point API');

Line: 3616


          HZ_CONTACT_POINT_V2PUB.update_phone_contact_point (
                           p_contact_point_rec => l_orgfax_contact_point_rec,
                          p_phone_rec => p_org_fax_rec,
                       p_object_version_number => l_orgfax_object_version_number,
                          x_return_status => x_return_status,
                          x_msg_count => x_msg_count,
                            x_msg_data => x_msg_data);

Line: 3625


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

Line: 3629


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

Line: 3630


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

Line: 3631


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