DBA Data[Home] [Help]

APPS.CSD_REPAIRS_GRP SQL Statements

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

Line: 303

PROCEDURE Update_Repair_Order(
   p_Init_Msg_List            IN         VARCHAR2 := 'F',
   p_Commit                   IN         VARCHAR2 := 'F',
   p_REPAIR_LINE_ID           IN         NUMBER,
   p_REPAIR_NUMBER            IN         VARCHAR2,
   p_INCIDENT_ID              IN         NUMBER,
   p_INVENTORY_ITEM_ID        IN         NUMBER,
   p_CUSTOMER_PRODUCT_ID      IN         NUMBER,
   p_UNIT_OF_MEASURE          IN         VARCHAR2,
   p_REPAIR_TYPE_ID           IN         NUMBER,
-- RESOURCE_GROUP Added by Vijay 10/28/2004
   p_RESOURCE_GROUP           IN         NUMBER,
   p_RESOURCE_ID              IN         NUMBER,
   p_PROJECT_ID               IN         NUMBER,
   p_TASK_ID                  IN         NUMBER,
   p_UNIT_NUMBER              IN         VARCHAR2, -- rfieldma, prj integration
   p_CONTRACT_LINE_ID         IN         NUMBER,
   p_AUTO_PROCESS_RMA         IN         VARCHAR2,
   p_REPAIR_MODE              IN         VARCHAR2,
   p_OBJECT_VERSION_NUMBER    IN         NUMBER,
   p_ITEM_REVISION            IN         VARCHAR2,
   p_INSTANCE_ID              IN         NUMBER,
   p_STATUS                   IN         VARCHAR2,
   p_STATUS_REASON_CODE       IN         VARCHAR2,
   p_DATE_CLOSED              IN         DATE,
   p_APPROVAL_REQUIRED_FLAG   IN         VARCHAR2,
   p_APPROVAL_STATUS          IN         VARCHAR2,
   p_SERIAL_NUMBER            IN         VARCHAR2,
   p_PROMISE_DATE             IN         DATE,
   p_ATTRIBUTE_CATEGORY       IN         VARCHAR2,
   p_ATTRIBUTE1               IN         VARCHAR2,
   p_ATTRIBUTE2               IN         VARCHAR2,
   p_ATTRIBUTE3               IN         VARCHAR2,
   p_ATTRIBUTE4               IN         VARCHAR2,
   p_ATTRIBUTE5               IN         VARCHAR2,
   p_ATTRIBUTE6               IN         VARCHAR2,
   p_ATTRIBUTE7               IN         VARCHAR2,
   p_ATTRIBUTE8               IN         VARCHAR2,
   p_ATTRIBUTE9               IN         VARCHAR2,
   p_ATTRIBUTE10              IN         VARCHAR2,
   p_ATTRIBUTE11              IN         VARCHAR2,
   p_ATTRIBUTE12              IN         VARCHAR2,
   p_ATTRIBUTE13              IN         VARCHAR2,
   p_ATTRIBUTE14              IN         VARCHAR2,
   p_ATTRIBUTE15              IN         VARCHAR2,
   -- additional DFF attributes, subhat(bug#7497907).
   P_ATTRIBUTE16               IN      VARCHAR2 ,
   P_ATTRIBUTE17               IN      VARCHAR2 ,
   P_ATTRIBUTE18               IN      VARCHAR2 ,
   P_ATTRIBUTE19               IN      VARCHAR2 ,
   P_ATTRIBUTE20               IN      VARCHAR2 ,
   P_ATTRIBUTE21               IN      VARCHAR2 ,
   P_ATTRIBUTE22               IN      VARCHAR2 ,
   P_ATTRIBUTE23               IN      VARCHAR2 ,
   P_ATTRIBUTE24               IN      VARCHAR2 ,
   P_ATTRIBUTE25               IN      VARCHAR2 ,
   P_ATTRIBUTE26               IN      VARCHAR2 ,
   P_ATTRIBUTE27               IN      VARCHAR2 ,
   P_ATTRIBUTE28               IN      VARCHAR2 ,
   P_ATTRIBUTE29               IN      VARCHAR2 ,
   P_ATTRIBUTE30               IN      VARCHAR2 ,
   p_QUANTITY                 IN         NUMBER,
   p_QUANTITY_IN_WIP          IN         NUMBER,
   p_QUANTITY_RCVD            IN         NUMBER,
   p_QUANTITY_SHIPPED         IN         NUMBER,
   p_CURRENCY_CODE            IN         VARCHAR2,
   p_DEFAULT_PO_NUM           IN         VARCHAR2 := null,
   p_REPAIR_GROUP_ID          IN         NUMBER,
   p_RO_TXN_STATUS            IN         VARCHAR2,
   p_ORDER_LINE_ID              IN       NUMBER,
   p_ORIGINAL_SOURCE_REFERENCE  IN       VARCHAR2,
   p_ORIGINAL_SOURCE_HEADER_ID  IN       NUMBER,
   p_ORIGINAL_SOURCE_LINE_ID    IN       NUMBER,
   p_PRICE_LIST_HEADER_ID       IN       NUMBER,
   p_PROBLEM_DESCRIPTION        IN       VARCHAR2, -- swai: bug 4666344
   p_RO_PRIORITY_CODE           IN       VARCHAR2, -- swai: R12
   -- g_miss_date means keep field in table handler
   -- null means clear field in table handler
   p_RESOLVE_BY_DATE	       IN       DATE, -- rfieldma, bug 5355051, defaulted to g_miss_date in spec
   p_BULLETIN_CHECK_DATE        IN       DATE, -- := FND_API.G_MISS_DATE,
   p_ESCALATION_CODE            IN       VARCHAR2, -- := FND_API.G_MISS_CHAR,
   p_RO_WARRANTY_STATUS_CODE    IN       VARCHAR2,
   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_Repair_Order';
Line: 397

  SAVEPOINT UPDATE_REPAIR_ORDER_GRP;
Line: 410

  csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order  before CSD_REPAIRS_UTIL.Convert_to_Repln_Rec_Type');
Line: 491

  csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Repair_Order  before CSD_REPAIRS_PUB.Update_Repair_Order');
Line: 493

  CSD_REPAIRS_PUB.Update_Repair_Order
  (p_API_version_number => 1.0,
   p_init_msg_list => p_init_msg_list,
   p_commit => p_commit,
   p_repair_line_id => p_repair_line_id,
   p_Repln_Rec => l_Repln_Rec,
   x_return_status => x_return_status,
   x_msg_count => x_msg_count,
   x_msg_data => x_msg_data
  );
Line: 506

    ROLLBACK TO UPDATE_REPAIR_ORDER_GRP;
Line: 557

End Update_Repair_Order;
Line: 560

Procedure Update_Approval_Status(
        p_repair_line_id       IN   NUMBER,
        p_new_approval_status  IN   VARCHAR2,
        p_old_approval_status  IN   VARCHAR2,
        p_quantity             IN   NUMBER,
        p_org_contact_id       IN   NUMBER,
        p_reason               IN   VARCHAR2,
        p_object_version_number IN OUT NOCOPY   NUMBER,
        x_return_status        OUT NOCOPY  VARCHAR2,
        x_msg_count            OUT NOCOPY  NUMBER,
        x_msg_data             OUT NOCOPY  VARCHAR2
        )
IS
-- CONSTANTS --
 lc_debug_level           CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
Line: 581

 lc_mod_name              CONSTANT VARCHAR2(100)  := 'csd.plsql.csd_repairs_grp.update_approval_status';
Line: 583

  l_api_name                        CONSTANT VARCHAR2(30) := 'Update_Approval_Status';
Line: 597

  SAVEPOINT UPDATE_APPROVAL_STATUS_GRP;
Line: 643

            'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');
Line: 645

  CSD_REPAIRS_PVT.Update_Repair_Order
  (p_API_version_number => 1.0,
   p_init_msg_list => FND_API.G_TRUE,
   p_commit => FND_API.G_FALSE,
   p_validation_level => null,
   p_repair_line_id => p_repair_line_id,
   p_Repln_Rec => l_Repln_Rec,
   x_return_status => x_return_status,
   x_msg_count => x_msg_count,
   x_msg_data => x_msg_data
  );
Line: 659

            'Returned from CSD_REPAIRS_PVT.Update_Repair_Order. x_return_status='|| x_return_status);
Line: 664

    ROLLBACK TO UPDATE_APPROVAL_STATUS_GRP;
Line: 671

csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Approval_Status before api CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write call');
Line: 713

   p_PROGRAM_UPDATE_DATE   => null,
   p_CREATED_BY    => FND_GLOBAL.USER_ID,
   p_CREATION_DATE => sysdate,
   p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
   p_LAST_UPDATE_DATE => sysdate,
   p_repair_line_id => p_repair_line_id,
   p_EVENT_CODE => l_event_code,
   p_EVENT_DATE => sysdate,
   p_QUANTITY  => p_quantity,
   p_PARAMN1     =>  p_org_contact_id,
   p_PARAMN2    =>   l_estimate_total,
   p_PARAMN3    => null,
   p_PARAMN4    => null,
   p_PARAMN5    => null,
   p_PARAMN6    => null,
   p_PARAMN7    => null,
   p_PARAMN8    => null,
   p_PARAMN9    => null,
   p_PARAMN10   => FND_GLOBAL.USER_ID,
   p_PARAMC1    => p_new_approval_status,
   p_PARAMC2    => p_old_approval_status,
   p_PARAMC3    => p_reason,
   p_PARAMC4    => null,
   p_PARAMC5    => null ,
   p_PARAMC6    => null,
   p_PARAMC7    => null,
   p_PARAMC8    => null,
   p_PARAMC9    => null,
   p_PARAMC10   => null,
   p_PARAMD1    => null,
   p_PARAMD2    => null,
   p_PARAMD3    => null,
   p_PARAMD4    => null,
   p_PARAMD5    => null,
   p_PARAMD6    => null,
   p_PARAMD7    => null,
   p_PARAMD8    => null,
   p_PARAMD9    => null,
   p_PARAMD10   => null,
   p_ATTRIBUTE_CATEGORY  => null,
   p_ATTRIBUTE1    => null,
   p_ATTRIBUTE2    => null,
   p_ATTRIBUTE3    => null,
   p_ATTRIBUTE4    => null,
   p_ATTRIBUTE5    => null,
   p_ATTRIBUTE6    => null,
   p_ATTRIBUTE7    => null,
   p_ATTRIBUTE8   => null,
   p_ATTRIBUTE9   => null,
   p_ATTRIBUTE10    => null,
   p_ATTRIBUTE11    => null,
   p_ATTRIBUTE12    =>null,
   p_ATTRIBUTE13    => null,
   p_ATTRIBUTE14    => null,
   p_ATTRIBUTE15    => null,
   p_LAST_UPDATE_LOGIN    => FND_GLOBAL.CONC_LOGIN_ID,
   X_Return_Status              => x_return_status,
   X_Msg_Count                  => x_msg_count,
   X_Msg_Data                   => x_msg_data
  );
Line: 781

    ROLLBACK TO UPDATE_APPROVAL_STATUS_GRP;
Line: 829

END Update_Approval_Status;
Line: 831

Procedure Update_Status(
        p_repair_line_id   IN   NUMBER,
        p_new_status       IN   VARCHAR2,
        p_old_status       IN   VARCHAR2,
        p_quantity         IN   NUMBER,
        p_reason           IN   VARCHAR2,
          p_status_reason_code IN         VARCHAR2,
        p_object_version_number 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) := 'Update_Status';
Line: 853

  SAVEPOINT UPDATE_STATUS_GRP;
Line: 905

csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_REPAIRS_PVT.Update_Repair_Order');
Line: 907

  CSD_REPAIRS_PVT.Update_Repair_Order
  (p_API_version_number => 1.0,
   p_init_msg_list => FND_API.G_TRUE,
   p_commit => FND_API.G_FALSE,
   p_validation_level => null,
   p_repair_line_id => p_repair_line_id,
   p_Repln_Rec => l_Repln_Rec,
   x_return_status => x_return_status,
   x_msg_count => x_msg_count,
   x_msg_data => x_msg_data
  );
Line: 919

csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status after CSD_REPAIRS_PVT.Update_Repair_Order status : '||x_return_status);
Line: 924

    ROLLBACK TO UPDATE_STATUS_GRP;
Line: 935

  csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write');
Line: 949

   p_PROGRAM_UPDATE_DATE   => null,
   p_CREATED_BY    => FND_GLOBAL.USER_ID,
   p_CREATION_DATE => sysdate,
   p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
   p_LAST_UPDATE_DATE => sysdate,
   p_repair_line_id => p_repair_line_id,
   p_EVENT_CODE => 'SC',
   p_EVENT_DATE => sysdate,
   p_QUANTITY  => p_quantity,
   p_PARAMN1     =>   null,
   p_PARAMN2    =>    null,
   p_PARAMN3    => null,
   p_PARAMN4    => null,
   p_PARAMN5    => null,
   p_PARAMN6    => null,
   p_PARAMN7    => null,
   p_PARAMN8    => null,
   p_PARAMN9    => null,
   p_PARAMN10   => FND_GLOBAL.USER_ID,
   p_PARAMC1    => p_new_status,
   p_PARAMC2    => p_old_status,
   p_PARAMC3    => p_reason,
   p_PARAMC4    => null,
   p_PARAMC5    => null,
   p_PARAMC6    => null,
   p_PARAMC7    => null,
   p_PARAMC8    => null,
   p_PARAMC9    => null,
   p_PARAMC10   => null,
   p_PARAMD1    => null,
   p_PARAMD2    => null,
   p_PARAMD3    => null,
   p_PARAMD4    => null,
   p_PARAMD5    => null,
   p_PARAMD6    => null,
   p_PARAMD7    => null,
   p_PARAMD8    => null,
   p_PARAMD9    => null,
   p_PARAMD10   => null,
   p_ATTRIBUTE_CATEGORY  => null,
   p_ATTRIBUTE1    => null,
   p_ATTRIBUTE2    => null,
   p_ATTRIBUTE3    => null,
   p_ATTRIBUTE4    => null,
   p_ATTRIBUTE5    => null,
   p_ATTRIBUTE6    => null,
   p_ATTRIBUTE7    => null,
   p_ATTRIBUTE8   => null,
   p_ATTRIBUTE9   => null,
   p_ATTRIBUTE10    => null,
   p_ATTRIBUTE11    => null,
   p_ATTRIBUTE12    =>null,
   p_ATTRIBUTE13    => null,
   p_ATTRIBUTE14    => null,
   p_ATTRIBUTE15    => null,
   p_LAST_UPDATE_LOGIN    => FND_GLOBAL.CONC_LOGIN_ID,
   X_Return_Status              => x_return_status,
   X_Msg_Count                  => x_msg_count,
   X_Msg_Data                   => x_msg_data
  );
Line: 1010

  csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Status before CSD_TO_FORM_REPAIR_HISTORY.Validate_And_Write status : '||x_return_status);
Line: 1016

    ROLLBACK TO UPDATE_STATUS_GRP;
Line: 1062

END Update_Status;
Line: 1065

Procedure Update_Group_Approval_Status(
  p_api_version               IN       NUMBER,
  p_commit                    IN       VARCHAR2  := fnd_api.g_false,
  p_init_msg_list             IN       VARCHAR2  := fnd_api.g_false,
  p_validation_level          IN       NUMBER    := fnd_api.g_valid_level_full,
  p_repair_group_id           IN       NUMBER,
  p_object_version_number     IN OUT NOCOPY   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) := 'Update_Group_Approval_Status';
Line: 1108

  Select  rep.repair_line_id
        , rep.approval_status
        , rep.quantity
        , rep.object_version_number rep_ovn
        , est.repair_estimate_id
        , est.object_version_number est_ovn
    from  csd_repairs rep
        , csd_repair_estimate est
   where  rep.repair_group_id = p_repair_group_id
     and  rep.repair_line_id  = est.repair_line_id
     and  est.estimate_status = 'BID';
Line: 1126

   SAVEPOINT UPDATE_GRP_APPV_STATUS;
Line: 1207

        csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status convert repairs rec call');
Line: 1215

        csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update repairs call');
Line: 1217

        CSD_REPAIRS_PVT.Update_Repair_Order
        (p_API_version_number    => 1.0,
         p_init_msg_list         => FND_API.G_TRUE,
         p_commit                => FND_API.G_FALSE,
       p_validation_level      => null,
         p_repair_line_id        => l_repair_line_id,
         p_Repln_Rec             => l_rep_ord_rec,
         x_return_status         => x_return_status,
         x_msg_count             => x_msg_count,
         x_msg_data              => x_msg_data
        );
Line: 1230

       csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update_Repair_Order :'||x_return_status);
Line: 1235

         csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
Line: 1242

         csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO hist call');
Line: 1255

            p_PROGRAM_UPDATE_DATE    => null,
            p_CREATED_BY             => FND_GLOBAL.USER_ID,
            p_CREATION_DATE          => sysdate,
            p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID,
            p_LAST_UPDATE_DATE       => sysdate,
            p_repair_line_id         => l_repair_line_id,
            p_EVENT_CODE             => l_event_code,
            p_EVENT_DATE             => sysdate,
            p_QUANTITY               => l_rep_quantity,
            p_PARAMN1                => null,
            p_PARAMN2                => null,
            p_PARAMN3                => null,
            p_PARAMN4                => null,
            p_PARAMN5                => null,
            p_PARAMN6                => null,
            p_PARAMN7                => null,
            p_PARAMN8                => null,
            p_PARAMN9                => null,
            p_PARAMN10               => FND_GLOBAL.USER_ID,
            p_PARAMC1                => l_approval_status,                -- new status
            p_PARAMC2                => l_rep_approval_status,            -- old status
            p_PARAMC3                => 'Repair Group Estimate Approval', -- travi new
            p_PARAMC4                => null,
            p_PARAMC5                => null ,
            p_PARAMC6                => null,
            p_PARAMC7                => null,
            p_PARAMC8                => null,
            p_PARAMC9                => null,
            p_PARAMC10               => null,
            p_PARAMD1                => null,
            p_PARAMD2                => null,
            p_PARAMD3                => null,
            p_PARAMD4                => null,
            p_PARAMD5                => null,
            p_PARAMD6                => null,
            p_PARAMD7                => null,
            p_PARAMD8                => null,
            p_PARAMD9                => null,
            p_PARAMD10               => null,
            p_ATTRIBUTE_CATEGORY     => null,
            p_ATTRIBUTE1             => null,
            p_ATTRIBUTE2             => null,
            p_ATTRIBUTE3             => null,
            p_ATTRIBUTE4             => null,
            p_ATTRIBUTE5             => null,
            p_ATTRIBUTE6             => null,
            p_ATTRIBUTE7             => null,
            p_ATTRIBUTE8             => null,
            p_ATTRIBUTE9             => null,
            p_ATTRIBUTE10            => null,
            p_ATTRIBUTE11            => null,
            p_ATTRIBUTE12            =>null,
            p_ATTRIBUTE13            => null,
            p_ATTRIBUTE14            => null,
            p_ATTRIBUTE15            => null,
            p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID,
            X_Return_Status          => x_return_status,
            X_Msg_Count              => x_msg_count,
            X_Msg_Data               => x_msg_data
           );
Line: 1316

         csd_gen_utility_pvt.add('Update_Group_Approval_Status Validate_And_Write :'||x_return_status);
Line: 1333

          csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status Update RO estimate call');
Line: 1335

           csd_repair_estimate_pvt.update_repair_estimate
           (p_api_version      => 1.0,
            p_commit           => 'F',
            p_init_msg_list    => 'T',
            p_validation_level => fnd_api.g_valid_level_full,
            x_estimate_rec     => l_rep_est_rec,
            x_return_status    => x_return_status,
            x_msg_count        => l_msg_count,
            x_msg_data         => l_msg_data);
Line: 1345

          csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Approval_Status update_repair_estimate :'||x_return_status);
Line: 1350

        csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
Line: 1386

        ROLLBACK TO UPDATE_GRP_APPV_STATUS;
Line: 1392

        ROLLBACK TO UPDATE_GRP_APPV_STATUS;
Line: 1398

        ROLLBACK TO UPDATE_GRP_APPV_STATUS;
Line: 1410

END Update_Group_Approval_Status;
Line: 1413

Procedure Update_Group_Reject_Status(
  p_api_version               IN       NUMBER,
  p_commit                    IN       VARCHAR2  := fnd_api.g_false,
  p_init_msg_list             IN       VARCHAR2  := fnd_api.g_false,
  p_validation_level          IN       NUMBER    := fnd_api.g_valid_level_full,
  p_repair_group_id           IN       NUMBER,
  p_object_version_number     IN OUT NOCOPY   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) := 'Update_Group_Reject_Status';
Line: 1456

  Select  rep.repair_line_id
        , rep.approval_status
        , rep.quantity
        , rep.object_version_number rep_ovn
        , est.repair_estimate_id
        , est.object_version_number est_ovn
    from  csd_repairs rep
        , csd_repair_estimate est
   where  rep.repair_group_id = p_repair_group_id
     and  rep.repair_line_id  = est.repair_line_id;
Line: 1474

   SAVEPOINT UPDATE_GRP_REJT_STATUS;
Line: 1555

      csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status convert repairs rec call');
Line: 1563

        csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update repairs call');
Line: 1565

        CSD_REPAIRS_PVT.Update_Repair_Order
        (p_API_version_number    => 1.0,
         p_init_msg_list         => FND_API.G_TRUE,
         p_commit                => FND_API.G_FALSE,
       p_validation_level      => null,
         p_repair_line_id        => l_repair_line_id,
         p_Repln_Rec             => l_rep_ord_rec,
         x_return_status         => x_return_status,
         x_msg_count             => x_msg_count,
         x_msg_data              => x_msg_data
        );
Line: 1578

       csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update_Repair_Order :'||x_return_status);
Line: 1583

    csd_gen_utility_pvt.ADD('CSD_REPAIRS_PVT.Update_Repair_Order failed ');
Line: 1590

         csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO hist call');
Line: 1603

            p_PROGRAM_UPDATE_DATE    => null,
            p_CREATED_BY             => FND_GLOBAL.USER_ID,
            p_CREATION_DATE          => sysdate,
            p_LAST_UPDATED_BY        => FND_GLOBAL.USER_ID,
            p_LAST_UPDATE_DATE       => sysdate,
            p_repair_line_id         => l_repair_line_id,
            p_EVENT_CODE             => l_event_code,
            p_EVENT_DATE             => sysdate,
            p_QUANTITY               => l_rep_quantity,
            p_PARAMN1                => null,
            p_PARAMN2                => null,
            p_PARAMN3                => null,
            p_PARAMN4                => null,
            p_PARAMN5                => null,
            p_PARAMN6                => null,
            p_PARAMN7                => null,
            p_PARAMN8                => null,
            p_PARAMN9                => null,
            p_PARAMN10               => FND_GLOBAL.USER_ID,
            p_PARAMC1                => l_Reject_status,                -- new status
            p_PARAMC2                => l_rep_Reject_status,            -- old status
            p_PARAMC3                => 'Repair Group Estimate Reject', -- travi new
            p_PARAMC4                => null,
            p_PARAMC5                => null ,
            p_PARAMC6                => null,
            p_PARAMC7                => null,
            p_PARAMC8                => null,
            p_PARAMC9                => null,
            p_PARAMC10               => null,
            p_PARAMD1                => null,
            p_PARAMD2                => null,
            p_PARAMD3                => null,
            p_PARAMD4                => null,
            p_PARAMD5                => null,
            p_PARAMD6                => null,
            p_PARAMD7                => null,
            p_PARAMD8                => null,
            p_PARAMD9                => null,
            p_PARAMD10               => null,
            p_ATTRIBUTE_CATEGORY     => null,
            p_ATTRIBUTE1             => null,
            p_ATTRIBUTE2             => null,
            p_ATTRIBUTE3             => null,
            p_ATTRIBUTE4             => null,
            p_ATTRIBUTE5             => null,
            p_ATTRIBUTE6             => null,
            p_ATTRIBUTE7             => null,
            p_ATTRIBUTE8             => null,
            p_ATTRIBUTE9             => null,
            p_ATTRIBUTE10            => null,
            p_ATTRIBUTE11            => null,
            p_ATTRIBUTE12            =>null,
            p_ATTRIBUTE13            => null,
            p_ATTRIBUTE14            => null,
            p_ATTRIBUTE15            => null,
            p_LAST_UPDATE_LOGIN      => FND_GLOBAL.CONC_LOGIN_ID,
            X_Return_Status          => x_return_status,
            X_Msg_Count              => x_msg_count,
            X_Msg_Data               => x_msg_data
           );
Line: 1664

         csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Validate_And_Write :'||x_return_status);
Line: 1681

          csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status Update RO estimate call');
Line: 1683

           csd_repair_estimate_pvt.update_repair_estimate
           (p_api_version      => 1.0,
            p_commit           => 'F',
            p_init_msg_list    => 'T',
            p_validation_level => fnd_api.g_valid_level_full,
            x_estimate_rec     => l_rep_est_rec,
            x_return_status    => x_return_status,
            x_msg_count        => l_msg_count,
            x_msg_data         => l_msg_data);
Line: 1693

          csd_gen_utility_pvt.add('CSD_REPAIRS_GRP.Update_Group_Reject_Status update_repair_estimate :'||x_return_status);
Line: 1698

    csd_gen_utility_pvt.ADD('csd_repair_estimate_pvt.update_repair_estimate failed ');
Line: 1735

        ROLLBACK TO UPDATE_GRP_REJT_STATUS;
Line: 1741

        ROLLBACK TO UPDATE_GRP_REJT_STATUS;
Line: 1747

        ROLLBACK TO UPDATE_GRP_REJT_STATUS;
Line: 1760

END Update_Group_Reject_Status;