DBA Data[Home] [Help]

APPS.CSD_REPAIRS_GRP SQL Statements

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

Line: 301

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,
   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: 394

  SAVEPOINT UPDATE_REPAIR_ORDER_GRP;
Line: 407

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

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

  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: 502

    ROLLBACK TO UPDATE_REPAIR_ORDER_GRP;
Line: 553

End Update_Repair_Order;
Line: 556

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: 577

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

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

  SAVEPOINT UPDATE_APPROVAL_STATUS_GRP;
Line: 639

            'Calling CSD_REPAIRS_PVT.Update_Repair_Order ');
Line: 641

  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: 655

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

    ROLLBACK TO UPDATE_APPROVAL_STATUS_GRP;
Line: 667

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

   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: 777

    ROLLBACK TO UPDATE_APPROVAL_STATUS_GRP;
Line: 825

END Update_Approval_Status;
Line: 827

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: 849

  SAVEPOINT UPDATE_STATUS_GRP;
Line: 901

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

  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: 915

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

    ROLLBACK TO UPDATE_STATUS_GRP;
Line: 931

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

   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: 1006

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

    ROLLBACK TO UPDATE_STATUS_GRP;
Line: 1058

END Update_Status;
Line: 1061

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: 1104

  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: 1122

   SAVEPOINT UPDATE_GRP_APPV_STATUS;
Line: 1203

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

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

        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: 1226

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

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

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

            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: 1312

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

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

           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: 1341

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

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

        ROLLBACK TO UPDATE_GRP_APPV_STATUS;
Line: 1388

        ROLLBACK TO UPDATE_GRP_APPV_STATUS;
Line: 1394

        ROLLBACK TO UPDATE_GRP_APPV_STATUS;
Line: 1406

END Update_Group_Approval_Status;
Line: 1409

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: 1452

  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: 1470

   SAVEPOINT UPDATE_GRP_REJT_STATUS;
Line: 1551

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

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

        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: 1574

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

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

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

            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: 1660

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

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

           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: 1689

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

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

        ROLLBACK TO UPDATE_GRP_REJT_STATUS;
Line: 1737

        ROLLBACK TO UPDATE_GRP_REJT_STATUS;
Line: 1743

        ROLLBACK TO UPDATE_GRP_REJT_STATUS;
Line: 1756

END Update_Group_Reject_Status;