DBA Data[Home] [Help]

APPS.IBY_VALIDATIONSETS_CALLS_PUB SQL Statements

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

Line: 90

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 108

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 123

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 129

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 193

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 199

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 268

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 274

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 338

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 353

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 359

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 423

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 438

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 444

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 508

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 523

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 537

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 555

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 561

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 625

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 646

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 653

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 717

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 723

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 787

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 812

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 822

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 886

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 898

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 969

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 993

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1004

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1074

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1081

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1147

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1162

   	       IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1176

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1191

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1205

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1222

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1237

   	       IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1251

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1266

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
               l_docErrorRec, l_docErrorTab);
Line: 1281

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1302

              IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1318

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1327

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 1391

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1406

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1412

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 1474

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1481

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 1545

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1565

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1575

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 1641

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1656

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1671

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1686

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1700

                 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1718

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1735

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1755

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1768

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 1832

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1850

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1865

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1871

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 1935

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 1941

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2005

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2023

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2037

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2043

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2107

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2113

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2177

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2195

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2209

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2215

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2277

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2283

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2347

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2365

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2379

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2385

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2449

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2467

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2473

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2558

            IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2572

            IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2587

            IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2601

            IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2607

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2671

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2681

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 2742

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2748

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2812

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2826

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2832

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2896

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2902

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 2964

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2979

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 2994

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3001

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3065

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3080

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3095

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3101

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3163

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3170

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3234

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3249

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3264

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3288

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3294

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3358

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3364

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3426

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3433

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3497

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3515

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3521

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3585

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3591

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3653

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3660

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3724

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3751

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3757

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3821

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3827

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 3897

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3904

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 3968

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3983

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 3998

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4062

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4068

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4130

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4137

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4201

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4216

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4281

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4287

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4349

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4356

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4420

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4435

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4453

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4468

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4476

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4538

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4553

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4568

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4575

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4639

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4645

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4709

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4724

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4751

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4766

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4772

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 4834

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4849

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4856

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 4935

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4953

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 4959

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5038

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5050

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5114

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec,l_docErrorTab);
Line: 5120

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5184

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5199

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5205

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5269

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec,l_docErrorTab);
Line: 5283

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec,l_docErrorTab);
Line: 5290

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5352

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5359

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 5433

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5440

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5514

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5539

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5555

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5560

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5576

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5582

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5653

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5668

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5675

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 5749

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5756

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5830

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5855

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 5862

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5919

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 5990

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6005

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6012

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 6086

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6093

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6167

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6192

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6199

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6256

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6321

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6335

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6351

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6357

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6421

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6427

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6490

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6504

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6512

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 6576

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6582

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6646

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6661

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6676

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6690

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6704

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6719

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6725

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6789

         IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6795

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 6857

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6872

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6879

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 6954

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6969

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 6975

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7039

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7045

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7109

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7115

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7179

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7185

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7249

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7255

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7319

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7334

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7348

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7357

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7421

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7427

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7489

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7504

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7511

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 7575

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7581

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7645

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7651

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7715

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7721

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7791

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7798

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 7889

            insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 7896

      * Insert errors into IBY_TRANSACTION_ERRORS
      */
     IF (l_valid = 1) THEN
        IBY_VALIDATIONSETS_PUB.
            insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 7976

         SELECT
             abb.BANK_BRANCH_TYPE,
             edi.EDI_ID_NUMBER,
             abb.BANK_NAME,
             abb.BANK_BRANCH_NAME
         INTO
             l_bank_branch_type,
             l_bank_edi_id_number,
             l_bank_name,
             l_bank_branch_name
         FROM
             IBY_DOCS_PAYABLE_ALL doc,
             CE_BANK_BRANCHES_V   abb,
             CE_BANK_ACCOUNTS     cba,
             HZ_CONTACT_POINTS    edi
         WHERE
             doc.document_payable_id      = p_document_id
         AND doc.internal_bank_account_id = cba.bank_account_id
         AND cba.bank_branch_id           = abb.branch_party_id
         AND edi.owner_table_id           = abb.branch_party_id
         AND edi.owner_table_name         = 'HZ_PARTIES'
         AND edi.contact_point_type       = 'EFT'
         ;
Line: 8044

            insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8051

      * Insert errors into IBY_TRANSACTION_ERRORS
      */
     IF (l_valid = 1) THEN
        IBY_VALIDATIONSETS_PUB.
            insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 8131

         SELECT
             cbb.bank_branch_type
         INTO
             l_bank_branch_type
         FROM
             IBY_DOCS_PAYABLE_ALL    doc,
             IBY_EXT_BANK_ACCOUNTS_V eba,
             CE_BANK_BRANCHES_V      cbb
         WHERE
             doc.document_payable_id      = p_document_id
         AND doc.external_bank_account_id = eba.ext_bank_account_id(+)
         AND eba.bank_party_id            = cbb.bank_party_id(+)
         AND eba.branch_party_id          = cbb.branch_party_id(+)
         ;
Line: 8188

            insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8201

         SELECT
             ep.bank_instruction2_code
         INTO
             l_trxn_handling
         FROM
             IBY_DOCS_PAYABLE_ALL    doc,
             IBY_EXTERNAL_PAYEES_ALL ep
         WHERE
             doc.document_payable_id  = p_document_id
         AND doc.ext_payee_id         = ep.ext_payee_id
         ;
Line: 8254

            insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8271

             SELECT
                 ep.bank_instruction1_code
             INTO
                 l_edi_pmt_format
             FROM
                 IBY_DOCS_PAYABLE_ALL    doc,
                 IBY_EXTERNAL_PAYEES_ALL ep
             WHERE
                 doc.document_payable_id  = p_document_id
             AND doc.ext_payee_id         = ep.ext_payee_id
             ;
Line: 8331

                insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8340

      * Insert errors into IBY_TRANSACTION_ERRORS
      */
     IF (l_valid = 1) THEN
        IBY_VALIDATIONSETS_PUB.
            insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 8462

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8467

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 8578

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8583

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 8708

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8722

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8727

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 8838

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8843

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 8974

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 8979

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9098

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9103

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9222

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9227

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9346

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9351

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9470

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9475

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9594

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9599

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9718

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9723

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9842

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9847

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 9966

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 9971

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 10090

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 10095

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 10214

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 10219

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 10338

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 10343

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 10462

      IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 10467

      IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 10537

 SELECT
     val.val_param_varchar2_value
 FROM
     IBY_VALIDATION_VALUES     val,
     IBY_VALIDATION_PARAMS_VL  names,
     IBY_VALIDATION_SETS_VL    valsets,
     IBY_VAL_ASSIGNMENTS       asgns
 WHERE
     valsets.validation_set_code = p_val_set_id
 AND
     val.validation_set_code = valsets.validation_set_code
 AND
     names.validation_parameter_code = p_charlist_type
 AND
     val.validation_parameter_code = names.validation_parameter_code
 AND
     asgns.validation_assignment_id = p_validation_assign_id
 AND
     val.validation_assignment_id = asgns.validation_assignment_id;
Line: 10871

      * Insert errors into IBY_TRANSACTION_ERRORS table.
      */
     IF (l_docErrorTab.COUNT > 0) THEN

         l_valid := 1;
Line: 10876

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(
             p_is_online_val, l_docErrorTab);
Line: 11018

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11024

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11089

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11095

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11160

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11166

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11228

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11234

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11296

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11311

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11325

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11339

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11345

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11405

	SELECT lpad(v_kid_nr,v_kid_lengde,0)
          INTO v_kid
          FROM dual;
Line: 11565

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11571

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11646

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11648

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11719

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11725

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11800

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11802

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11880

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11882

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 11958

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 11960

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12059

            SELECT
            IBY_TRANSACTION_ERRORS_S.NEXTVAL
            INTO
              l_transaction_error_id
           FROM
              DUAL
           ;
Line: 12069

           INSERT INTO IBY_TRXN_ERROR_TOKENS
            (TRANSACTION_ERROR_ID, TOKEN_NAME, TOKEN_VALUE, LOOKUP_TYPE_SOURCE,
           CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)
           VALUES
            (l_transaction_error_id, 'ERR_OBJECT', 'URI_CHECK_DIGIT', 'IBY_VALIDATION_FIELDS',
           fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
           fnd_global.user_id, 1);
Line: 12079

	   IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12081

           IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12096

            SELECT
            IBY_TRANSACTION_ERRORS_S.NEXTVAL
            INTO
              l_transaction_error_id
           FROM
              DUAL
           ;
Line: 12106

           INSERT INTO IBY_TRXN_ERROR_TOKENS
            (TRANSACTION_ERROR_ID, TOKEN_NAME, TOKEN_VALUE, LOOKUP_TYPE_SOURCE,
           CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
             LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)
           VALUES
            (l_transaction_error_id, 'ERR_OBJECT', 'URI_CHECK_DIGIT', 'IBY_VALIDATION_FIELDS',
           fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
           fnd_global.user_id, 1);
Line: 12116

	   IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12118

           IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12136

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12138

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12155

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12157

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12173

        IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12175

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12197

         SELECT
            IBY_TRANSACTION_ERRORS_S.NEXTVAL
        INTO
            l_transaction_error_id
        FROM
            DUAL
        ;
Line: 12207

        INSERT INTO IBY_TRXN_ERROR_TOKENS
        (TRANSACTION_ERROR_ID, TOKEN_NAME, TOKEN_VALUE, LOOKUP_TYPE_SOURCE,
         CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
         LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)
        VALUES
        (l_transaction_error_id, 'ERR_OBJECT', 'URI_CHECK_DIGIT', 'IBY_VALIDATION_FIELDS',
         fnd_global.user_id, sysdate, fnd_global.user_id, sysdate,
         fnd_global.user_id, 1);
Line: 12217

	 IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12219

         IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);
Line: 12322

  SELECT IBY_COMPLETED_PMTS_GROUP_S.NEXTVAL
  INTO l_completion_id
  FROM DUAL;
Line: 12327

  UPDATE IBY_PAYMENTS_ALL pmt
  SET pmt.completed_pmts_group_id = l_completion_id
  WHERE pmt.payment_status       IN ('INSTRUCTION_CREATED')
  AND pmt.payment_instruction_id  = p_instruction_id
  AND pmt.payment_id         IN
  (SELECT doc.payment_id
   FROM IBY_DOCS_PAYABLE_ALL doc
   WHERE doc.payment_id   = pmt.payment_id
   AND doc.calling_app_id = 200
  );
Line: 12338

  /*UPDATE IBY_DOCS_PAYABLE_ALL
  SET completed_pmts_group_id = l_completion_id
  WHERE payment_id           IN
    (SELECT payment_id
    FROM IBY_PAYMENTS_ALL
    WHERE payment_status        IN ('INSTRUCTION_CREATED')
    AND payment_instruction_id = p_instruction_id)
  AND document_status <> 'REMOVED';*/
Line: 12360

  UPDATE IBY_PAYMENTS_ALL pmt
  SET pmt.completed_pmts_group_id = NULL
  WHERE pmt.payment_status IN ('INSTRUCTION_CREATED')
  AND pmt.payment_instruction_id = p_instruction_id
  AND pmt.payment_id         IN
  (SELECT doc.payment_id
   FROM IBY_DOCS_PAYABLE_ALL doc
   WHERE doc.payment_id   = pmt.payment_id
   AND doc.calling_app_id = 200
  );
Line: 12371

  /*UPDATE IBY_DOCS_PAYABLE_ALL
  SET completed_pmts_group_id = NULL
  WHERE payment_id           IN
    (SELECT payment_id
    FROM IBY_PAYMENTS_ALL
    WHERE payment_status        IN ('INSTRUCTION_CREATED')
    AND payment_instruction_id = p_instruction_id);*/
Line: 12384

    IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12391

    IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N',l_docErrorTab);
Line: 12490

           IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12546

             IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(l_docErrorRec, l_docErrorTab);
Line: 12553

        IBY_VALIDATIONSETS_PUB.insert_transaction_errors(p_is_online_val,l_docErrorTab);