1 Reply Latest reply: Nov 20, 2013 2:31 AM by vinod2303 RSS

    Data Uploaded successfully not coming in database, please help

    935522

      I have a created a package and used in the integrator. While using with 1 API the data is uploading successfully in database and in frontend also.

      While using 3 API's it is not getting.

       

      CREATE OR REPLACE PACKAGE BODY APPS.web_adi1

      AS

         PROCEDURE xx_xx_test_web1 (

            ln_start_date                 IN              DATE,

            ln_business_group_id          IN              NUMBER,

            ln_contact_type               IN              VARCHAR2,

            ln_last_name                  IN              VARCHAR2,

            ln_first_name                 IN              VARCHAR2,

            ln_personal_flag              IN              VARCHAR2,

            ln_effective_date             IN              DATE,

            ln_person_id                  IN              NUMBER,

            ln_primary_flag               IN              VARCHAR2,

            ln_dependent_flag             IN              VARCHAR2,

            ln_style                      IN              VARCHAR2,

            ln_date_from                  IN              DATE,

            ln_address_line1              IN              VARCHAR2,

            ln_address_line2              IN              VARCHAR2,

            ln_town_or_city               IN              VARCHAR2,

            ln_region_1                   IN              VARCHAR2,

            ln_region_2                   IN              VARCHAR2,

            ln_postal_code                IN              VARCHAR2,

            ln_country                    IN              VARCHAR2,

            ln_address_id                 OUT             NUMBER,

            ln_phone_id                   OUT             NUMBER,

            ln_phone_type                 IN              VARCHAR2,

            ln_phone_number               IN              VARCHAR2,

            ln_contact_rel_id             OUT             per_contact_relationships.contact_relationship_id%TYPE,

            ln_ctr_object_ver_num         OUT             per_contact_relationships.object_version_number%TYPE,

            ln_contact_person             OUT             per_all_people_f.person_id%TYPE,

            ln_object_version_number      OUT             per_contact_relationships.object_version_number%TYPE,

            ld_per_effective_start_date   OUT NOCOPY      DATE,

            ld_per_effective_end_date     OUT NOCOPY      DATE,

            lc_full_name                  OUT             per_all_people_f.full_name%TYPE,

            ln_per_comment_id             OUT             per_all_people_f.comment_id%TYPE,

            lb_name_comb_warning          OUT NOCOPY      BOOLEAN,

            lb_orig_hire_warning          OUT NOCOPY      BOOLEAN

         )

         IS

            a   NUMBER;

         BEGIN

            a := ln_person_id;

            hr_contact_rel_api.create_contact

                        (p_start_date                     => ln_start_date,

                         p_business_group_id              => ln_business_group_id,

                         p_person_id                      => a,

                         p_contact_type                   => ln_contact_type,

                         p_date_start                     => ' ',

                         p_last_name                      => ln_last_name,

                         p_first_name                     => ln_first_name,

                         p_personal_flag                  => ln_personal_flag,

                         p_dependent_flag                 => ln_dependent_flag,

                         p_contact_relationship_id        => ln_contact_rel_id,

                         p_ctr_object_version_number      => ln_ctr_object_ver_num,

                         p_per_person_id                  => ln_contact_person,

                         p_per_object_version_number      => ln_object_version_number,

                         p_per_effective_start_date       => ld_per_effective_start_date,

                         p_per_effective_end_date         => ld_per_effective_end_date,

                         p_full_name                      => lc_full_name,

                         p_per_comment_id                 => ln_per_comment_id,

                         p_name_combination_warning       => lb_name_comb_warning,

                         p_orig_hire_warning              => lb_orig_hire_warning

                        );

            hr_person_address_api.create_person_address

                                (p_effective_date             => ln_effective_date,

                                 p_person_id                  => a,

                                 p_primary_flag               => ln_primary_flag,

                                 p_style                      => ln_style,

                                 p_date_from                  => ln_date_from,

                                 p_address_line1              => ln_address_line1,

                                 p_address_line2              => ln_address_line2,

                                 p_town_or_city               => ln_town_or_city,

                                 p_region_1                   => ln_region_1,

                                 p_region_2                   => ln_region_2,

                                 p_postal_code                => ln_postal_code,

                                 p_country                    => ln_country,

                                 p_address_id                 => ln_address_id,

                                 p_object_version_number      => ln_object_version_number

                                );

            hr_phone_api.create_or_update_phone

                                (p_date_from                  => ln_date_from,

                                 p_phone_type                 => ln_phone_type,

                                 p_phone_number               => ln_phone_number,

                                 p_parent_id                  => a,

                                 p_parent_table               => 'PER_ALL_PEOPLE_F',

                                 p_effective_date             => ln_effective_date,

                                 p_phone_id                   => ln_phone_id,

                                 p_object_version_number      => ln_object_version_number

                                );

            COMMIT;

         EXCEPTION

            WHEN OTHERS

            THEN

               ROLLBACK;

               DBMS_OUTPUT.put_line (SQLERRM);

         END;

      END web_adi1;

      /

      This is my package and it is showing green smilie but data is not coming in database