DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PUB SQL Statements

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

Line: 6

 * It contains routines to Create and Update Counter Grouping,
 * Counter Template, Item Associations, Derived Filters,
 * Counter Relationships
 * @rep:scope public
 * @rep:product CSI
 * @rep:displayname Manage Counter Template
 * @rep:lifecycle active
 * @rep:compatibility S
 * @rep:category BUSINESS_ENTITY CSI_COUNTER
*/
-- --------------------------------------------------------
-- Define global variables
-- --------------------------------------------------------

-- G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_TEMPLATE_PUB';
Line: 2023

 * This procedure is used to update counter group
 * In this process, it also update/create counter item associations
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_counter_groups_rec  Counter Group Record structure
 * @param p_ctr_item_associations_tbl Counter Item Associations Table structure
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Counter Group
 */


PROCEDURE update_counter_group
  (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_groups_rec        IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
    ,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
    ,x_return_status                OUT    NOCOPY VARCHAR2
    ,x_msg_count                    OUT    NOCOPY NUMBER
    ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_COUNTER_GROUP';
Line: 2065

    SELECT counter_id
    FROM   csi_ctr_item_associations
    WHERE  nvl(associated_to_group,'N') = 'Y'
    AND    counter_id IS NOT NULL
    AND    group_id = p_counter_group_id
    AND    inventory_item_id = p_inventory_item_id; --Modified for 6112648
Line: 2073

   SAVEPOINT  update_counter_group;
Line: 2104

      csi_ctr_gen_utility_pvt.put_line( 'update_counter_group');
Line: 2109

      csi_ctr_gen_utility_pvt.put_line( 'update_counter_group'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );
Line: 2118

      CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_counter_groups_rec   => p_counter_groups_rec
               ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 2138

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre API ');
Line: 2149

      CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_counter_groups_rec  => p_counter_groups_rec
               ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 2169

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre API ');
Line: 2178

   csi_counter_template_pvt.update_counter_group
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_counter_groups_rec => p_counter_groups_rec
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 2198

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_GROUP');
Line: 2209

         csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post ..');
Line: 2210

         CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_counter_groups_rec   => p_counter_groups_rec
             ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 2230

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post API ');
Line: 2249

        csi_ctr_gen_utility_pvt.put_line('Calling  CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post ..');
Line: 2250

        CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_counter_groups_rec   => p_counter_groups_rec
             ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 2270

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post API ');
Line: 2356

  	         update_item_association
	           (p_api_version      => p_api_version
 	            ,p_commit           => fnd_api.g_false
	            ,p_init_msg_list    => p_init_msg_list
	            ,p_validation_level => p_validation_level
	            ,p_ctr_item_associations_rec => p_ctr_item_associations_tbl(tab_row)
	            ,x_return_status    => x_return_status
	            ,x_msg_count        => x_msg_count
	            ,x_msg_data         => x_msg_data
	            );
Line: 2374

	               csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
Line: 2396

      ROLLBACK TO update_counter_group;
Line: 2404

      ROLLBACK TO update_counter_group;
Line: 2411

      ROLLBACK TO update_counter_group;
Line: 2424

END update_counter_group;
Line: 2434

 * This procedure is used to update counter item associations
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_ctr_item_associations_rec Counter Item Associations Record structure
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Item Association
 */

PROCEDURE update_item_association
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
    ,x_return_status                OUT    NOCOPY VARCHAR2
    ,x_msg_count                    OUT    NOCOPY NUMBER
    ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_ITEM_ASSOCIATION';
Line: 2473

   SAVEPOINT  update_item_association;
Line: 2504

      csi_ctr_gen_utility_pvt.put_line( 'update_item_association');
Line: 2509

      csi_ctr_gen_utility_pvt.put_line( 'update_item_association'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );
Line: 2518

      CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_item_associations_rec   => p_ctr_item_associations_rec
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 2537

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre API ');
Line: 2548

      CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_item_associations_rec  => p_ctr_item_associations_rec
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 2567

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre API ');
Line: 2576

   csi_counter_template_pvt.update_item_association
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_ctr_item_associations_rec => p_ctr_item_associations_rec
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 2596

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ITEM_ASSOCIATION');
Line: 2607

         csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post ..');
Line: 2608

         CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_item_associations_rec => p_ctr_item_associations_rec
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 2627

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post API ');
Line: 2646

        csi_ctr_gen_utility_pvt.put_line('Calling         CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post ..');
Line: 2647

        CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_item_associations_rec => p_ctr_item_associations_rec
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 2666

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM         CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post API ');
Line: 2691

      ROLLBACK TO update_item_association;
Line: 2699

      ROLLBACK TO update_item_association;
Line: 2706

      ROLLBACK TO update_item_association;
Line: 2719

END update_item_association;
Line: 2727

 * This procedure is used to update counter template.
 * This will also create/update Item Association, Properties
 * derived filters, relationships.
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_counter_template_rec Counter Template Record structure
 * @param p_ctr_item_associations_tbl Counter Item Associations Table structure
 * @param p_ctr_property_template_tbl Counter property template Table structure
 * @param p_counter_relationships_tbl Counter relationships Table structure
 * @param p_ctr_derived_filters_tbl Counter Derived Filters Table structure
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Counter Template
 */

PROCEDURE update_counter_template
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_template_rec      IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
    ,p_ctr_item_associations_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
    ,p_ctr_property_template_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
    ,p_counter_relationships_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
    ,p_ctr_derived_filters_tbl   IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
    ,x_return_status                OUT NOCOPY VARCHAR2
    ,x_msg_count                    OUT NOCOPY NUMBER
    ,x_msg_data                     OUT NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_COUNTER_TEMPLATE';
Line: 2776

   SAVEPOINT  update_counter_template ;
Line: 2807

      csi_ctr_gen_utility_pvt.put_line( 'update_counter_template');
Line: 2812

      csi_ctr_gen_utility_pvt.put_line( 'update_counter_template'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );
Line: 2821

      CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
               ,p_counter_template_rec => p_counter_template_rec
               ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
               ,p_ctr_property_template_tbl => p_ctr_property_template_tbl
               ,p_counter_relationships_tbl => p_counter_relationships_tbl
               ,p_ctr_derived_filters_tbl   => p_ctr_derived_filters_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 2844

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre API ');
Line: 2855

      CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
               ,p_counter_template_rec => p_counter_template_rec
               ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
               ,p_ctr_property_template_tbl => p_ctr_property_template_tbl
               ,p_counter_relationships_tbl => p_counter_relationships_tbl
               ,p_ctr_derived_filters_tbl   => p_ctr_derived_filters_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 2878

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre API ');
Line: 2887

   csi_counter_template_pvt.update_counter_template
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_counter_template_rec => p_counter_template_rec
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 2909

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_TEMPLATE');
Line: 2920

         csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post ..');
Line: 2921

         CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
             ,p_counter_template_rec => p_counter_template_rec
             ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
             ,p_ctr_property_template_tbl => p_ctr_property_template_tbl
             ,p_counter_relationships_tbl => p_counter_relationships_tbl
             ,p_ctr_derived_filters_tbl   => p_ctr_derived_filters_tbl
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 2944

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post API ');
Line: 2963

        csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post ..');
Line: 2964

        CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
             ,p_counter_template_rec => p_counter_template_rec
             ,p_ctr_item_associations_tbl => p_ctr_item_associations_tbl
             ,p_ctr_property_template_tbl => p_ctr_property_template_tbl
             ,p_counter_relationships_tbl => p_counter_relationships_tbl
             ,p_ctr_derived_filters_tbl   => p_ctr_derived_filters_tbl
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 2987

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post API ');
Line: 3039

               update_item_association
                 (
                 p_api_version      => p_api_version
                 ,p_commit          => fnd_api.g_false
                 ,p_init_msg_list   => p_init_msg_list
                 ,p_validation_level => p_validation_level
                 ,p_ctr_item_associations_rec => p_ctr_item_associations_tbl(tab_row)
                 ,x_return_status    => x_return_status
                 ,x_msg_count        => x_msg_count
                 ,x_msg_data         => x_msg_data
                 );
Line: 3057

                    csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
Line: 3104

	         update_ctr_property_template
 	           (p_api_version      => p_api_version
	            ,p_commit           => fnd_api.g_false
	            ,p_init_msg_list    => p_init_msg_list
	            ,p_validation_level => p_validation_level
	            ,p_ctr_property_template_rec => p_ctr_property_template_tbl(tab_row)
	            ,x_return_status    => x_return_status
	            ,x_msg_count        => x_msg_count
	            ,x_msg_data         => x_msg_data
	           );
Line: 3122

	               csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_CTR_PROPERTY_TEMPLATE');
Line: 3179

	      update_counter_relationship
	        (
	          p_api_version      => p_api_version
	         ,p_commit           => fnd_api.g_false
	         ,p_init_msg_list    => p_init_msg_list
	         ,p_validation_level => p_validation_level
	         ,p_counter_relationships_rec => p_counter_relationships_tbl(tab_row)
	         ,x_return_status    => x_return_status
	         ,x_msg_count        => x_msg_count
	         ,x_msg_data         => x_msg_data
	        );
Line: 3198

	             csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_COUNTER_RELATIONSHIP');
Line: 3218

	      update_derived_filters
	        (
	          p_api_version      => p_api_version
	         ,p_commit           => fnd_api.g_false
	         ,p_init_msg_list    => p_init_msg_list
	         ,p_validation_level => p_validation_level
                 ,p_ctr_derived_filters_tbl => p_ctr_derived_filters_tbl
	         ,x_return_status    => x_return_status
	         ,x_msg_count        => x_msg_count
	         ,x_msg_data         => x_msg_data
	        );
Line: 3237

	             csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_DERIVED_FILTERS');
Line: 3256

      ROLLBACK TO update_counter_template;
Line: 3264

      ROLLBACK TO update_counter_template;
Line: 3271

      ROLLBACK TO update_counter_template;
Line: 3284

END update_counter_template;
Line: 3293

 * This procedure is used to update counter property template.
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_ctr_property_template_rec Counter property template record structure
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Counter Property Template
 */

PROCEDURE update_ctr_property_template
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
    ,x_return_status                OUT    NOCOPY VARCHAR2
    ,x_msg_count                    OUT    NOCOPY NUMBER
    ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_CTR_PROPERTY_TEMPLATE';
Line: 3332

   SAVEPOINT  update_ctr_property_template;
Line: 3363

      csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template');
Line: 3368

      csi_ctr_gen_utility_pvt.put_line( 'update_ctr_property_template'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );
Line: 3377

      CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_property_template_rec   => p_ctr_property_template_rec
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 3396

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre API ');
Line: 3407

      CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_property_template_rec  => p_ctr_property_template_rec
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 3426

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre API ');
Line: 3435

   csi_counter_template_pvt.update_ctr_property_template
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_ctr_property_template_rec => p_ctr_property_template_rec
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 3455

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_CTR_PROPERTY_TEMPLATE');
Line: 3466

         csi_ctr_gen_utility_pvt.put_line('Calling  CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post ..');
Line: 3467

         CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_property_template_rec   => p_ctr_property_template_rec
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 3486

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post API ');
Line: 3505

        csi_ctr_gen_utility_pvt.put_line('Calling  CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post ..');
Line: 3506

        CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_property_template_rec   => p_ctr_property_template_rec
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 3525

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post API ');
Line: 3551

      ROLLBACK TO update_ctr_property_template;
Line: 3559

      ROLLBACK TO update_ctr_property_template;
Line: 3566

      ROLLBACK TO update_ctr_property_template;
Line: 3579

END update_ctr_property_template;
Line: 3587

 * This procedure is used to update counter relationship.
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_counter_relationships_rec Counter relationships Record structure
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Counter Relationship
 */

PROCEDURE update_counter_relationship
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
    ,x_return_status                OUT    NOCOPY VARCHAR2
    ,x_msg_count                    OUT    NOCOPY NUMBER
    ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_COUNTER_RELATIONSHIP';
Line: 3626

   SAVEPOINT  update_counter_relationship;
Line: 3657

      csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship');
Line: 3662

      csi_ctr_gen_utility_pvt.put_line( 'update_counter_relationship'     ||
                                     p_api_version         ||'-'||
                                     p_commit              ||'-'||
                                     p_init_msg_list       ||'-'||
                                     p_validation_level );
Line: 3671

      CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_counter_relationships_rec   => p_counter_relationships_rec
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 3690

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre API ');
Line: 3701

      CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_counter_relationships_rec  => p_counter_relationships_rec
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 3720

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre API ');
Line: 3729

   csi_counter_template_pvt.update_counter_relationship
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_counter_relationships_rec => p_counter_relationships_rec
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 3749

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP');
Line: 3760

         csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post ..');
Line: 3761

         CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_counter_relationships_rec => p_counter_relationships_rec
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 3780

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post API ');
Line: 3799

        csi_ctr_gen_utility_pvt.put_line('Calling  CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post ..');
Line: 3800

        CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_counter_relationships_rec => p_counter_relationships_rec
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 3819

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post API ');
Line: 3844

      ROLLBACK TO update_counter_relationship;
Line: 3852

      ROLLBACK TO update_counter_relationship;
Line: 3859

      ROLLBACK TO update_counter_relationship;
Line: 3872

END update_counter_relationship;
Line: 3880

 * This procedure is used to update derived filters
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_ctr_derived_filters_rec Counter Derived Filters Record structure
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Derived Filters
 */

PROCEDURE update_derived_filters
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
    ,x_return_status                OUT    NOCOPY VARCHAR2
    ,x_msg_count                    OUT    NOCOPY NUMBER
    ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_DERIVED_FILTERS';
Line: 3919

   SAVEPOINT  update_derived_filters;
Line: 3950

      csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters');
Line: 3955

      csi_ctr_gen_utility_pvt.put_line( 'update_derived_filters'   ||
					p_api_version         ||'-'||
					p_commit              ||'-'||
					p_init_msg_list       ||'-'||
					p_validation_level );
Line: 3964

      CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_derived_filters_tbl    => p_ctr_derived_filters_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 3983

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');
Line: 3994

      CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_pre
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_derived_filters_tbl   => p_ctr_derived_filters_tbl
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 4013

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');
Line: 4023

   csi_counter_template_pvt.update_derived_filters
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_ctr_derived_filters_tbl => p_ctr_derived_filters_tbl
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 4043

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS');
Line: 4054

         csi_ctr_gen_utility_pvt.put_line('Calling  CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post ..');
Line: 4055

         CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_derived_filters_tbl  => p_ctr_derived_filters_tbl
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 4074

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post API ');
Line: 4093

        csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post ..');
Line: 4094

        CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_derived_filters_tbl  => p_ctr_derived_filters_tbl
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 4113

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post API ');
Line: 4139

      ROLLBACK TO update_derived_filters;
Line: 4147

      ROLLBACK TO update_derived_filters;
Line: 4155

      ROLLBACK TO update_derived_filters;
Line: 4168

END update_derived_filters;
Line: 4457

 * This procedure is used to update estimation method
 * @param p_api_version Current API version
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @param p_ctr_estimation_rec Counter Estimation Record structure
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Update Estimation Method
 */
PROCEDURE Update_Estimation_Method
(
    p_api_version                IN      NUMBER
    ,p_init_msg_list             IN      VARCHAR2
    ,p_commit                    IN      VARCHAR2
    ,p_validation_level          IN      NUMBER
    ,x_return_status                 OUT NOCOPY  VARCHAR2
    ,x_msg_count                     OUT NOCOPY  NUMBER
    ,x_msg_data                      OUT NOCOPY  VARCHAR2
    ,p_ctr_estimation_rec        IN  OUT NOCOPY  CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
) IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'UPDATE_ESTIMATION_METHOD';
Line: 4494

   SAVEPOINT  update_estimation_method;
Line: 4525

      csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method');
Line: 4530

      csi_ctr_gen_utility_pvt.put_line( 'update_estimation_method '   ||
					p_api_version         ||'-'||
					p_commit              ||'-'||
					p_init_msg_list       ||'-'||
					p_validation_level );
Line: 4539

      CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre
             (
		p_api_version          => p_api_version
               ,p_init_msg_list        => p_init_msg_list
	       ,p_commit               => p_commit
	       ,p_validation_level     => p_validation_level
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
               ,p_ctr_estimation_rec   => p_ctr_estimation_rec
            );
Line: 4558

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
Line: 4569

      CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_pre
             (
		p_api_version          => p_api_version
               ,p_init_msg_list        => p_init_msg_list
	       ,p_commit               => p_commit
	       ,p_validation_level     => p_validation_level
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
               ,p_ctr_estimation_rec   => p_ctr_estimation_rec
            );
Line: 4588

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');
Line: 4598

   csi_counter_template_pvt.update_estimation_method
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_ctr_estimation_rec => p_ctr_estimation_rec
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 4618

             csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ESTIMATION_METHOD');
Line: 4629

         csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');
Line: 4630

         CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post
           (
		p_api_version          => p_api_version
               ,p_init_msg_list        => p_init_msg_list
	       ,p_commit               => p_commit
	       ,p_validation_level     => p_validation_level
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
               ,p_ctr_estimation_rec   => p_ctr_estimation_rec
	  );
Line: 4649

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post API ');
Line: 4668

        csi_ctr_gen_utility_pvt.put_line('Calling CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post ..');
Line: 4669

        CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post
           (
		p_api_version          => p_api_version
               ,p_init_msg_list        => p_init_msg_list
	       ,p_commit               => p_commit
	       ,p_validation_level     => p_validation_level
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
               ,p_ctr_estimation_rec   => p_ctr_estimation_rec
	  );
Line: 4688

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post API ');
Line: 4713

      ROLLBACK TO update_estimation_method;
Line: 4721

      ROLLBACK TO update_estimation_method;
Line: 4729

      ROLLBACK TO update_estimation_method;
Line: 4741

END update_estimation_method;
Line: 4781

   SELECT cia.counter_id, cia.group_id, cia.associated_to_group,
          ctr.counter_type, cia.primary_failure_flag
   FROM   csi_ctr_item_associations cia, csi_counter_template_b ctr
   WHERE  cia.counter_id = ctr.counter_id
   AND    inventory_item_id = p_source_object_id_template
   AND    nvl(cia.associated_to_group,'N') = 'N'
   AND    nvl (cia.end_date_active, sysdate+1) > sysdate
   ORDER BY counter_type DESC;
Line: 4791

   SELECT cia.counter_id, cia.group_id,
          cia.associated_to_group, cia.primary_failure_flag
   FROM   csi_ctr_item_associations cia, cs_csi_counter_groups cg
   WHERE  cia.group_id = cg.counter_group_id
   AND    cia.inventory_item_id = p_source_object_id_template
   AND    cia.counter_id IS NULL
   AND    nvl (cia.end_date_active, sysdate+1) > sysdate
   AND    nvl(cia.associated_to_group,'N') = 'Y';
Line: 4945

      SELECT COMMS_NL_TRACKABLE_FLAG,
	     concatenated_segments
      INTO   l_COMMS_NL_TRACKABLE_FLAG,
	     l_item
      FROM  mtl_system_items_kfv
      WHERE inventory_item_id = p_source_object_id_template
      AND   organization_id = p_organization_id     --cs_std.get_item_valdn_orgzn_id
      AND   (NVL(COMMS_NL_TRACKABLE_FLAG,'N') = 'Y' or NVL(service_item_flag,'N') = 'Y');
Line: 4966

      SELECT eam_item_type
      INTO   l_eam_item_type
      FROM   mtl_system_items_b
      WHERE  inventory_item_id = p_source_object_id_template
      AND    organization_id = p_organization_id;
Line: 4980

         SELECT maint_organization_id
         INTO   l_curr_maint_org_id
         FROM   mtl_parameters
         WHERE  organization_id = p_organization_id;
Line: 4999

      SELECT counter_id
      INTO   l_counter_id
      FROM   csi_ctr_item_associations
      WHERE  inventory_item_id = p_source_object_id_template;
Line: 5604

 * This procedure is used to delete item associations
 * @param p_api_version Current API version
 * @param p_commit API commits if set to fnd_api.g_true
 * @param p_init_msg_list Initializes the message stack if set to fnd_api.g_true
 * @param p_validation_level API validation level
 * @param p_ctr_association_id Item Associations Unique ID
 * @param x_return_status API Return Status
 * @param x_msg_count Message count
 * @param x_msg_data Message Data
 * @rep:scope public
 * @rep:lifecycle active
 * @rep:displayname Delete Item Association
 */

PROCEDURE delete_item_association
 (
     p_api_version               IN     NUMBER
    ,p_commit                    IN     VARCHAR2
    ,p_init_msg_list             IN     VARCHAR2
    ,p_validation_level          IN     NUMBER
    ,p_ctr_associations_id       IN     NUMBER
    ,x_return_status                OUT    NOCOPY VARCHAR2
    ,x_msg_count                    OUT    NOCOPY NUMBER
    ,x_msg_data                     OUT    NOCOPY VARCHAR2
 )
IS
    l_api_name                      CONSTANT VARCHAR2(30)   := 'DELETE_ITEM_ASSOCIATION';
Line: 5643

   SAVEPOINT  delete_item_association;
Line: 5670

      csi_ctr_gen_utility_pvt.put_line( 'delete_item_association');
Line: 5675

      csi_ctr_gen_utility_pvt.put_line('delete_item_association'     ||
                                        p_api_version         ||'-'||
                                        p_commit              ||'-'||
                                        p_init_msg_list       ||'-'||
                                        p_validation_level );
Line: 5684

      CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_associations_id   => p_ctr_associations_id
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 5703

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
Line: 5714

      CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE
             (
		p_api_version          => p_api_version
	       ,p_commit               => p_commit
	       ,p_init_msg_list        => p_init_msg_list
	       ,p_validation_level     => p_validation_level
	       ,p_ctr_associations_id  => p_ctr_associations_id
	       ,x_return_status        => x_return_status
	       ,x_msg_count            => x_msg_count
	       ,x_msg_data             => x_msg_data
            );
Line: 5733

            csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE API ');
Line: 5742

   csi_counter_template_pvt.delete_item_association
       (
        p_api_version        => p_api_version
       ,p_commit             => fnd_api.g_false
       ,p_init_msg_list      => p_init_msg_list
       ,p_validation_level   => p_validation_level
       ,p_ctr_associations_id => p_ctr_associations_id
       ,x_return_status      => x_return_status
       ,x_msg_count          => x_msg_count
       ,x_msg_data           => x_msg_data
       );
Line: 5762

             csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.DELETE_ITEM_ASSOCIATION');
Line: 5773

         csi_ctr_gen_utility_pvt.put_line('Calling  CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post ..');
Line: 5774

         CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_associations_id      => p_ctr_associations_id
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 5793

              csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post API ');
Line: 5813

        CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post
           (
	      p_api_version              => 1.0
	     ,p_commit                   => fnd_api.g_false
	     ,p_init_msg_list            => fnd_api.g_false
	     ,p_validation_level         => fnd_api.g_valid_level_full
	     ,p_ctr_associations_id      => p_ctr_associations_id
	     ,x_return_status            => x_return_status
	     ,x_msg_count                => x_msg_count
	     ,x_msg_data                 => x_msg_data
	  );
Line: 5832

               csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post API ');
Line: 5858

      ROLLBACK TO delete_item_association;
Line: 5866

      ROLLBACK TO delete_item_association;
Line: 5873

      ROLLBACK TO delete_item_association;
Line: 5886

END delete_item_association;