eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_BC_XLA_PVT dependencies on PSA_UTILS

Line 59: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_PVT version = '||l_file_info);

55: BEGIN
56: l_path_name := g_path_name || '.init';
57: l_file_info :=
58: '$Header: psavbcxb.pls 120.57 2011/06/13 11:13:02 yanasing ship $';
59: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_PVT version = '||l_file_info);
60: END;
61:
62: PROCEDURE psa_xla_error_cleanup
63: (

Line 245: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure copy_xla_error ' );

241: l_count NUMBER;
242: BEGIN
243: l_path_name := g_path_name || '.copy_xla_error';
244: p_error_found := 'N';
245: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure copy_xla_error ' );
246: FOR error_rec IN (SELECT e.entity_id,
247: e.event_id,
248: e.application_id,
249: er.message_number,

Line 308: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure try_to_interpret_xla_error ' );

304: l_path_name VARCHAR2(500);
305: l_count NUMBER;
306: BEGIN
307: l_path_name := g_path_name || '.try_to_interpret_xla_error';
308: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure try_to_interpret_xla_error ' );
309:
310: psa_utils.debug_other_string(g_state_level,l_path_name, 'Checking for Invalid AAD' );
311: FOR xla_rec IN (SELECT ru.compile_status_code,
312: e.entity_id,

Line 310: psa_utils.debug_other_string(g_state_level,l_path_name, 'Checking for Invalid AAD' );

306: BEGIN
307: l_path_name := g_path_name || '.try_to_interpret_xla_error';
308: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure try_to_interpret_xla_error ' );
309:
310: psa_utils.debug_other_string(g_state_level,l_path_name, 'Checking for Invalid AAD' );
311: FOR xla_rec IN (SELECT ru.compile_status_code,
312: e.entity_id,
313: e.event_id,
314: ru.name product_rule_name,

Line 335: psa_utils.debug_other_string(g_state_level,l_path_name, 'compile_status_code='||xla_rec.compile_status_code);

331: AND r.application_id = t.application_id
332: AND r.product_rule_code = ru.product_rule_code
333: AND r.product_rule_type_code = ru.product_rule_type_code
334: AND e.event_date BETWEEN r.start_date_active AND NVL(r.end_date_active, e.event_date+1)) LOOP
335: psa_utils.debug_other_string(g_state_level,l_path_name, 'compile_status_code='||xla_rec.compile_status_code);
336: IF xla_rec.compile_status_code <> 'Y' THEN
337: fnd_message.set_name ('XLA','XLA_AP_PAD_INACTIVE');
338: fnd_message.set_token ('PAD_NAME', xla_rec.product_rule_name);
339: fnd_message.set_token ('OWNER', xla_lookups_pkg.get_meaning('XLA_OWNER_TYPE',xla_rec.product_rule_owner));

Line 344: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');

340: fnd_message.set_token ('SUBLEDGER_ACCTG_METHOD', xla_accounting_cache_pkg.GetSessionValueChar
341: (p_source_code => 'XLA_ACCOUNTING_METHOD_NAME'
342: ,p_target_ledger_id => xla_rec.ledger_id));
343:
344: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');
345: psa_xla_error
346: (
347: p_message_code => 'XLA_AP_PAD_INACTIVE',
348: p_event_id => xla_rec.event_id

Line 354: psa_utils.debug_other_string(g_state_level,l_path_name, 'Error:'||SQLERRM);

350: END IF;
351: END LOOP;
352: EXCEPTION
353: WHEN OTHERS THEN
354: psa_utils.debug_other_string(g_state_level,l_path_name, 'Error:'||SQLERRM);
355: RAISE;
356: END;
357:
358:

Line 374: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure psa_acctg_errors_insert');

370: l_path_name VARCHAR2(500);
371: BEGIN
372: l_path_name := g_path_name||'.psa_acctg_errors_insert';
373:
374: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure psa_acctg_errors_insert');
375:
376: FORALL i in 1..psa_events.COUNT
377: DELETE FROM psa_bc_accounting_errors
378: WHERE event_id = psa_events(i);

Line 379: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);

375:
376: FORALL i in 1..psa_events.COUNT
377: DELETE FROM psa_bc_accounting_errors
378: WHERE event_id = psa_events(i);
379: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
380:
381: FORALL j in 1..psa_acctg_errors.COUNT
382: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
383: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);

Line 383: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);

379: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows deleted from psa_bc_accounting_erros: '||SQL%ROWCOUNT);
380:
381: FORALL j in 1..psa_acctg_errors.COUNT
382: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
383: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);
384:
385: COMMIT;
386: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');
387:

Line 386: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');

382: INSERT INTO psa_bc_accounting_errors VALUES psa_acctg_errors(j);
383: psa_utils.debug_other_string(g_state_level,l_path_name,'No of rows inserted into psa_bc_accounting_erros: '||SQL%ROWCOUNT);
384:
385: COMMIT;
386: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure psa_acctg_errors_insert');
387:
388: END psa_acctg_errors_insert;
389:
390:

Line 565: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure budgetary_control ' );

561: --
562: -- Start of the budgetary control
563: --
564: l_path_name := g_path_name || '.Budgetary_Control';
565: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure budgetary_control ' );
566:
567: --
568: -- Get the parameters values
569: --

Line 570: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);

566:
567: --
568: -- Get the parameters values
569: --
570: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
571: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);

Line 571: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);

567: --
568: -- Get the parameters values
569: --
570: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
571: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
575:

Line 572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);

568: -- Get the parameters values
569: --
570: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
571: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
575:
576: IF (FND_API.to_boolean(p_init_msg_list)) THEN

Line 573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);

569: --
570: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
571: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
575:
576: IF (FND_API.to_boolean(p_init_msg_list)) THEN
577: FND_MSG_PUB.initialize;

Line 574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);

570: psa_utils.debug_other_string(g_state_level,l_path_name, 'Application Id = ' ||p_application_id);
571: psa_utils.debug_other_string(g_state_level,l_path_name, 'Budgetary Control Mode = ' ||p_bc_mode);
572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
575:
576: IF (FND_API.to_boolean(p_init_msg_list)) THEN
577: FND_MSG_PUB.initialize;
578: END IF;

Line 588: psa_utils.debug_other_string(g_state_level,l_path_name,'Start of Parameter Validation');

584: l_bc_mode := p_bc_mode;
585: l_override_flag := p_override_flag;
586: l_application_id:= p_application_id;
587: l_xla_error := 'N';
588: psa_utils.debug_other_string(g_state_level,l_path_name,'Start of Parameter Validation');
589:
590: --
591: -- parameter validations
592: --

Line 611: psa_utils.debug_other_msg(p_level => g_error_level,

607: IF (l_bc_mode NOT IN (C_FUNDS_CHECK,C_FUNDS_CHK_FULL,C_FUNDS_RESERVE,C_FUNDS_PARTIAL,C_FUNDS_FORCE_PASS,C_FUNDS_ADVISORY)) THEN
608: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
609: Fnd_Message.Set_Token('PARAM_NAME','Funds Mode');
610: Fnd_Msg_Pub.ADD;
611: psa_utils.debug_other_msg(p_level => g_error_level,
612: p_full_path => l_path_name,
613: p_remove_from_stack => FALSE);
614: Fnd_file.put_line(fnd_file.log, fnd_message.get);
615: RAISE Fnd_Api.G_Exc_Error;

Line 626: psa_utils.debug_other_msg(p_level => g_error_level,

622: IF (l_override_flag NOT IN (C_YES,C_NO)) THEN
623: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
624: Fnd_Message.Set_Token('PARAM_NAME','Override Flag');
625: Fnd_Msg_Pub.ADD;
626: psa_utils.debug_other_msg(p_level => g_error_level,
627: p_full_path => l_path_name,
628: p_remove_from_stack => FALSE);
629: Fnd_file.put_line(fnd_file.log, fnd_message.get);
630:

Line 635: psa_utils.debug_other_string(g_state_level,l_path_name,'End of Parameter Validation');

631: RAISE Fnd_Api.G_Exc_Error;
632: END IF;
633: END IF;
634:
635: psa_utils.debug_other_string(g_state_level,l_path_name,'End of Parameter Validation');
636: --
637: -- Assign the wf parameters to global varibales.
638: -- These variables are used by accounitng engine while calling the funds checker
639: --

Line 651: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_CHECK');

647: -- Assign the parameters required for calling SLA Accounting engine
648: --
649: IF l_bc_mode IN (C_FUNDS_CHECK,C_FUNDS_CHK_FULL) THEN -- check funds draft mode
650: l_accounting_mode := 'FUNDS_CHECK';
651: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_CHECK');
652: ELSE
653: l_accounting_mode := 'FUNDS_RESERVE'; -- Reserve Funds in final mode
654: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_RESERVE');
655: END IF;

Line 654: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_RESERVE');

650: l_accounting_mode := 'FUNDS_CHECK';
651: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_CHECK');
652: ELSE
653: l_accounting_mode := 'FUNDS_RESERVE'; -- Reserve Funds in final mode
654: psa_utils.debug_other_string(g_state_level,l_path_name,'Accounting Mode is FUNDS_RESERVE');
655: END IF;
656:
657: l_accounting_flag := 'Y'; -- Accounting required
658: l_transfer_flag := 'N'; -- No transfer to GL

Line 687: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API ' || l_count );

683: END IF;
684: return;
685: END IF;
686:
687: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API ' || l_count );
688: psa_xla_error_cleanup;
689:
690:
691: BEGIN

Line 727: psa_utils.debug_other_string(g_state_level,l_path_name, 'Now invoking the PA_GMS_INTEGRATION_API' );

723: ---------------------------------------------------------------
724: -- Calling PA/GMS INTEGRATION API PRIOR TO SLA ONLINE
725: ---------------------------------------------------------------
726:
727: psa_utils.debug_other_string(g_state_level,l_path_name, 'Now invoking the PA_GMS_INTEGRATION_API' );
728: pa_gms_integration_api;
729:
730: SELECT count(*) INTO l_count
731: FROM psa_bc_xla_events_gt;

Line 733: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );

729:
730: SELECT count(*) INTO l_count
731: FROM psa_bc_xla_events_gt;
732:
733: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );
734:
735: IF l_count < 1 THEN
736:
737: x_status_code := 'FATAL';

Line 750: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

746: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
747: --
748: UPDATE psa_bc_xla_events_gt
749: SET result_code = 'XLA_UNPROCESSED';
750: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
751:
752:
753:
754:

Line 764: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );

760: psa_cleanup_gt;
761:
762: /* ---- 7460759 ---------------------------------------------------------------------------
763: DELETE from XLA_ACCT_PROG_EVENTS_GT;
764: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
765: DELETE from xla_ae_headers_gt;
766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
767: DELETE from xla_ae_lines_gt;
768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);

Line 766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);

762: /* ---- 7460759 ---------------------------------------------------------------------------
763: DELETE from XLA_ACCT_PROG_EVENTS_GT;
764: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
765: DELETE from xla_ae_headers_gt;
766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
767: DELETE from xla_ae_lines_gt;
768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
769: DELETE from xla_validation_lines_gt;
770: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);

Line 768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);

764: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from XLA_ACCT_PROG_EVENTS_GT table before insertion: ' || SQL%ROWCOUNT );
765: DELETE from xla_ae_headers_gt;
766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
767: DELETE from xla_ae_lines_gt;
768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
769: DELETE from xla_validation_lines_gt;
770: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);
771: DELETE from xla_evt_class_orders_gt;
772: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);

Line 770: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);

766: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_headers_gt table before insertion: ' || SQL%ROWCOUNT);
767: DELETE from xla_ae_lines_gt;
768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
769: DELETE from xla_validation_lines_gt;
770: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);
771: DELETE from xla_evt_class_orders_gt;
772: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);
773: */
774: DELETE from psa_option_details_gt;

Line 772: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);

768: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_ae_lines_gt table before insertion: ' || SQL%ROWCOUNT);
769: DELETE from xla_validation_lines_gt;
770: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_validation_lines_gt table before insertion: ' || SQL%ROWCOUNT);
771: DELETE from xla_evt_class_orders_gt;
772: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);
773: */
774: DELETE from psa_option_details_gt;
775: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
776: DELETE from psa_bc_alloc_gt;

Line 775: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);

771: DELETE from xla_evt_class_orders_gt;
772: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from xla_evt_class_orders_gt; table before insertion: ' || SQL%ROWCOUNT);
773: */
774: DELETE from psa_option_details_gt;
775: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
776: DELETE from psa_bc_alloc_gt;
777: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
778: ------------------------------------------------------------------------------------- *
779:

Line 777: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);

773: */
774: DELETE from psa_option_details_gt;
775: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_option_details_gt table before insertion: ' || SQL%ROWCOUNT);
776: DELETE from psa_bc_alloc_gt;
777: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
778: ------------------------------------------------------------------------------------- *
779:
780: -- Insert rows to XLA Events GT table and Call Accounting Engine
781: -----------------------------------------------------------------

Line 785: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );

781: -----------------------------------------------------------------
782:
783: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
784: SELECT event_id FROM psa_bc_xla_events_gt;
785: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );
786:
787: l_accounting_events := TRUE;
788: l_accounting_batch_id := NULL;
789: l_errbuf := NULL;

Line 793: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');

789: l_errbuf := NULL;
790: l_retcode := NULL;
791: l_request_id := NULL;
792:
793: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
794: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
795:
796: FOR x in c_get_bc_xla_events_gt
797: LOOP

Line 794: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');

790: l_retcode := NULL;
791: l_request_id := NULL;
792:
793: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
794: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
795:
796: FOR x in c_get_bc_xla_events_gt
797: LOOP
798: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);

Line 798: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);

794: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
795:
796: FOR x in c_get_bc_xla_events_gt
797: LOOP
798: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);
799: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);
800: END LOOP;
801:
802: ----------------------------------------------------------------

Line 799: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);

795:
796: FOR x in c_get_bc_xla_events_gt
797: LOOP
798: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);
799: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);
800: END LOOP;
801:
802: ----------------------------------------------------------------
803: -- Calling SLA online accounting engine API

Line 805: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling API xla_accounting_pub_pkg.accounting_program_events');

801:
802: ----------------------------------------------------------------
803: -- Calling SLA online accounting engine API
804: ----------------------------------------------------------------
805: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling API xla_accounting_pub_pkg.accounting_program_events');
806: xla_accounting_pub_pkg.accounting_program_events
807: ( p_application_id => P_application_id
808: ,p_accounting_mode => l_accounting_mode
809: ,p_gl_posting_flag => l_gl_posting_flag

Line 815: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);

811: ,p_errbuf => l_errbuf
812: ,p_retcode => l_retcode
813: );
814:
815: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
816: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
817: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
818:
819: -- Get psa_bc_xla_events_gt events

Line 816: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );

812: ,p_retcode => l_retcode
813: );
814:
815: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
816: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
817: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
818:
819: -- Get psa_bc_xla_events_gt events
820: OPEN c_get_psa_events;

Line 817: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );

813: );
814:
815: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
816: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
817: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
818:
819: -- Get psa_bc_xla_events_gt events
820: OPEN c_get_psa_events;
821: FETCH c_get_psa_events BULK COLLECT INTO l_psa_events;

Line 833: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');

829: -- Delete/Save errors records from/into PSA BC accounting errors table
830: psa_acctg_errors_insert(l_psa_events,l_psa_acctg_errors);
831:
832: IF l_retcode = 2 THEN
833: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');
834: l_overall_success := FALSE;
835: --Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
836: --Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
837: --Fnd_Msg_Pub.ADD;

Line 842: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

838: -- update the psa_bc_xla_events_gt event records to
839: -- XLA_ERROR status
840: UPDATE psa_bc_xla_events_gt
841: SET result_code = 'XLA_ERROR';
842: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
843: -- set the status code
844: x_status_code := 'XLA_ERROR';
845: copy_xla_error (l_error_found);
846: IF (l_error_found = 'N') THEN

Line 850: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');

846: IF (l_error_found = 'N') THEN
847: try_to_interpret_xla_error;
848: END IF;
849: ELSE
850: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');
851:
852: --
853: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_NO_JOURNAL' status
854: -- for events that remain in XLA_UNPROCESSED status

Line 861: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

857: IF l_retcode = 0 THEN
858: UPDATE psa_bc_xla_events_gt
859: SET result_code = 'XLA_NO_JOURNAL'
860: WHERE result_code = 'XLA_UNPROCESSED';
861: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
862: END IF;
863:
864: IF l_retcode = 1 THEN
865: copy_xla_error (l_error_found);

Line 875: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

871: x_status_code := 'XLA_ERROR';
872:
873: UPDATE psa_bc_xla_events_gt
874: SET result_code = 'XLA_ERROR';
875: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
876: END IF;
877: END IF;
878:
879: -- Intialize status code to Success

Line 883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');

879: -- Intialize status code to Success
880: x_status_code := 'SUCCESS';
881:
882: --dumping the psa_bc_xla_events_gt eventid/result_code
883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');
884: FOR x IN (SELECT * FROM psa_bc_xla_events_gt) LOOP
885: psa_utils.debug_other_string(g_state_level,l_path_name,
886: 'PSA gt event_id'|| x.event_id || 'PSA gt result_code' || x.result_code);
887: END LOOP;

Line 885: psa_utils.debug_other_string(g_state_level,l_path_name,

881:
882: --dumping the psa_bc_xla_events_gt eventid/result_code
883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');
884: FOR x IN (SELECT * FROM psa_bc_xla_events_gt) LOOP
885: psa_utils.debug_other_string(g_state_level,l_path_name,
886: 'PSA gt event_id'|| x.event_id || 'PSA gt result_code' || x.result_code);
887: END LOOP;
888:
889: -- set the status code of the gt table

Line 907: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');

903: FOR event_list_rec IN (SELECT *
904: FROM PSA_BC_XLA_EVENTS_GT
905: WHERE upper(result_code) = 'XLA_NO_JOURNAL') LOOP
906: fnd_message.set_name ('PSA','PSA_XLA_NO_JOURNAL');
907: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');
908: psa_xla_error
909: (
910: p_message_code => 'PSA_XLA_NO_JOURNAL',
911: p_event_id => event_list_rec.event_id

Line 936: psa_utils.debug_other_string(g_state_level,l_path_name, 'Status Code= '||x_status_code);

932: END IF; -- advisory
933:
934:
935: END IF;
936: psa_utils.debug_other_string(g_state_level,l_path_name, 'Status Code= '||x_status_code);
937: ----------------------------------------------------
938: -- packet id will returned from gl_bc_packets
939: -- if more than one event per call of BC API
940: -- first packet id will be returned

Line 965: psa_utils.debug_other_string(g_state_level,l_path_name, 'CBC Installed');

961: -- fails in reserve mode, SBC funds check changes
962: -- will also be rolled back.
963: -----------------------------------------------------
964: IF p_application_id = 201 AND IGI_GEN.is_req_installed('CBC') = TRUE THEN
965: psa_utils.debug_other_string(g_state_level,l_path_name, 'CBC Installed');
966:
967: BEGIN
968: -- Bug 12352531
969: l_prepare_stmt := 'BEGIN :1 := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => :2, p_conc_proc => :3); END;';

Line 970: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> ' || l_prepare_stmt );

966:
967: BEGIN
968: -- Bug 12352531
969: l_prepare_stmt := 'BEGIN :1 := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => :2, p_conc_proc => :3); END;';
970: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> ' || l_prepare_stmt );
971: IF (x_status_code IN('SUCCESS','ADVISORY')) THEN
972: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN p_bc_mode, IN FND_API.G_FALSE;
973: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );
974:

Line 973: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );

969: l_prepare_stmt := 'BEGIN :1 := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => :2, p_conc_proc => :3); END;';
970: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> ' || l_prepare_stmt );
971: IF (x_status_code IN('SUCCESS','ADVISORY')) THEN
972: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN p_bc_mode, IN FND_API.G_FALSE;
973: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );
974:
975: IF x_return_status <> 1 THEN
976: IF x_return_status = -1 THEN
977: x_status_code := 'XLA_ERROR';

Line 986: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );

982: END IF;
983:
984: ELSIF x_status_code IN('FAIL','PARTIAL') THEN
985: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN 'M', IN FND_API.G_FALSE;
986: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );
987: END IF;
988: EXCEPTION
989: WHEN OTHERS THEN
990: psa_utils.debug_other_string(g_excep_level,l_path_name,'CBC EXCEPTION: '|| SQLERRM(sqlcode));

Line 990: psa_utils.debug_other_string(g_excep_level,l_path_name,'CBC EXCEPTION: '|| SQLERRM(sqlcode));

986: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );
987: END IF;
988: EXCEPTION
989: WHEN OTHERS THEN
990: psa_utils.debug_other_string(g_excep_level,l_path_name,'CBC EXCEPTION: '|| SQLERRM(sqlcode));
991: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );
992: RAISE;
993: END;
994:

Line 991: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );

987: END IF;
988: EXCEPTION
989: WHEN OTHERS THEN
990: psa_utils.debug_other_string(g_excep_level,l_path_name,'CBC EXCEPTION: '|| SQLERRM(sqlcode));
991: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );
992: RAISE;
993: END;
994:
995: END IF;

Line 1002: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling pa_gms_tieback_api');

998: -- Calling PA/GMS Tieback API's in case of Errors
999: ------------------------------------------------------
1000:
1001: IF (x_status_code IN('FATAL','XLA_ERROR', 'XLA_NO_JOURNAL')) THEN
1002: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling pa_gms_tieback_api');
1003: pa_gms_tieback_api;
1004: END IF;
1005: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );
1006:

Line 1005: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );

1001: IF (x_status_code IN('FATAL','XLA_ERROR', 'XLA_NO_JOURNAL')) THEN
1002: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling pa_gms_tieback_api');
1003: pa_gms_tieback_api;
1004: END IF;
1005: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );
1006:
1007: EXCEPTION
1008:
1009: WHEN FND_API.G_EXC_ERROR THEN

Line 1014: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

1010: x_return_status := FND_API.G_RET_STS_ERROR ;
1011: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1015: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
1016: pa_gms_tieback_api;
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1015: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );

1011: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1015: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
1016: pa_gms_tieback_api;
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1020: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);

1016: pa_gms_tieback_api;
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
1021: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1022: ,p_count => x_msg_count
1023: ,p_data => x_msg_data);
1024:

Line 1025: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );

1021: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1022: ,p_count => x_msg_count
1023: ,p_data => x_msg_data);
1024:
1025: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );
1026: pa_gms_tieback_api;
1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1032: psa_utils.debug_unexpected_msg(G_PKG_NAME);

1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1030: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'PSA_BC_XLA_PVT');
1031: END IF;
1032: psa_utils.debug_unexpected_msg(G_PKG_NAME);
1033: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1034: ,p_count => x_msg_count
1035: ,p_data => x_msg_data);
1036: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

Line 1036: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

1032: psa_utils.debug_unexpected_msg(G_PKG_NAME);
1033: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1034: ,p_count => x_msg_count
1035: ,p_data => x_msg_data);
1036: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1037: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );
1038: pa_gms_tieback_api;
1039:
1040: END Budgetary_Control;

Line 1037: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );

1033: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1034: ,p_count => x_msg_count
1035: ,p_data => x_msg_data);
1036: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1037: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );
1038: pa_gms_tieback_api;
1039:
1040: END Budgetary_Control;
1041:

Line 1138: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );

1134: ORDER BY xe.event_id DESC;
1135: BEGIN
1136:
1137: l_path_name := g_path_name || '.get_sla_notupgraded_flag';
1138: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );
1139:
1140: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');
1141:
1142: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value

Line 1140: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');

1136:
1137: l_path_name := g_path_name || '.get_sla_notupgraded_flag';
1138: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of function get_sla_notupgraded_flag' );
1139:
1140: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch PSA: R12 Upgrade Date profile value');
1141:
1142: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
1143:
1144: IF l_r12_upgrade_date IS NULL THEN

Line 1145: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');

1141:
1142: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
1143:
1144: IF l_r12_upgrade_date IS NULL THEN
1145: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
1146: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
1147: RAISE Fnd_Api.G_Exc_Error;
1148: END IF;
1149:

Line 1146: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');

1142: l_r12_upgrade_date :=to_date( Fnd_Profile.Value_Wnps('PSA_R12_UPGRADE_DATE'), 'MM/DD/YYYY HH24:MI:SS'); -- fetch the profile value
1143:
1144: IF l_r12_upgrade_date IS NULL THEN
1145: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
1146: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
1147: RAISE Fnd_Api.G_Exc_Error;
1148: END IF;
1149:
1150: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));

Line 1150: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));

1146: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
1147: RAISE Fnd_Api.G_Exc_Error;
1148: END IF;
1149:
1150: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
1151:
1152: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
1153:
1154: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN

Line 1152: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);

1148: END IF;
1149:
1150: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
1151:
1152: psa_utils.debug_other_string(g_state_level,l_path_name,'Fetch CREATION_DATE of the Distribution '|| p_distribution_id);
1153:
1154: IF p_dist_link_type = 'PO_REQ_DISTRIBUTIONS_ALL' THEN
1155: SELECT min(creation_date) INTO l_dist_creation_date
1156: FROM po_req_distributions_all

Line 1167: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);

1163: SELECT min(creation_date) INTO l_dist_creation_date
1164: FROM ap_invoice_distributions_all
1165: WHERE invoice_distribution_id = p_distribution_id;
1166: ELSE
1167: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);
1168: RAISE Fnd_Api.G_Exc_Error;
1169: END IF;
1170:
1171: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));

Line 1171: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));

1167: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);
1168: RAISE Fnd_Api.G_Exc_Error;
1169: END IF;
1170:
1171: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));
1172:
1173: IF (p_dist_link_type <> 'PO_DISTRIBUTIONS_ALL') then
1174: if (l_dist_creation_date > l_r12_upgrade_date) OR (l_dist_creation_date IS NULL) THEN
1175: l_return_val := 'N';

Line 1187: psa_utils.debug_other_string(g_state_level,l_path_name,'l_check_variable = ' || l_check_variable);

1183: p_dist_link_type,
1184: p_distribution_id);
1185: FETCH c_check INTO l_check_variable;
1186: CLOSE c_check;
1187: psa_utils.debug_other_string(g_state_level,l_path_name,'l_check_variable = ' || l_check_variable);
1188: IF l_check_variable ='1' THEN
1189: -- Following IF added for Bug 7598349
1190: IF (p_dist_link_type = 'PO_DISTRIBUTIONS_ALL' ) THEN
1191: OPEN c_po_upg_chk(p_application_id,

Line 1198: psa_utils.debug_other_string(g_state_level,l_path_name,'l_acctd_dr = ' || l_acctd_dr

1194: p_dist_link_type,
1195: p_distribution_id);
1196: FETCH c_po_upg_chk into l_acctd_dr, l_acctd_cr, l_event_type_code;
1197: CLOSE c_po_upg_chk;
1198: psa_utils.debug_other_string(g_state_level,l_path_name,'l_acctd_dr = ' || l_acctd_dr
1199: || 'l_acctd_cr = ' || l_acctd_cr
1200: || 'l_event_type_code = ' || l_event_type_code
1201: );
1202: IF (l_acctd_dr = 0) AND (l_acctd_cr = 0) AND (l_event_type_code = 'PO_PA_FINAL_CLOSED')then

Line 1219: psa_utils.debug_other_string(g_state_level,l_path_name,'Return Value = ' || l_return_val);

1215: END IF;
1216: END IF; -- if l_check_variable
1217: END IF; -- if P_dist_link_type outer
1218:
1219: psa_utils.debug_other_string(g_state_level,l_path_name,'Return Value = ' || l_return_val);
1220: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);
1221: RETURN l_return_val;
1222: EXCEPTION
1223: WHEN others THEN

Line 1220: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);

1216: END IF; -- if l_check_variable
1217: END IF; -- if P_dist_link_type outer
1218:
1219: psa_utils.debug_other_string(g_state_level,l_path_name,'Return Value = ' || l_return_val);
1220: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);
1221: RETURN l_return_val;
1222: EXCEPTION
1223: WHEN others THEN
1224: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );

Line 1224: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );

1220: psa_utils.debug_other_string(g_state_level,l_path_name,'END of function get_sla_notupgraded_flag' || l_path_name);
1221: RETURN l_return_val;
1222: EXCEPTION
1223: WHEN others THEN
1224: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: END get_sla_notupgraded_flag;
1227:
1228: -- PA_GMS_INTEGRATION_API

Line 1253: psa_utils.debug_other_string(g_state_level,l_path_name, 'pa_gms_integration_api invoked');

1249: BEGIN
1250:
1251: l_path_name := g_path_name||'.pa_gms_integration_api';
1252:
1253: psa_utils.debug_other_string(g_state_level,l_path_name, 'pa_gms_integration_api invoked');
1254: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Integration API if PA is enabled');
1255:
1256: IF g_bc_mode ='C' THEN
1257: l_partial_resv_flag := 'Y';

Line 1254: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Integration API if PA is enabled');

1250:
1251: l_path_name := g_path_name||'.pa_gms_integration_api';
1252:
1253: psa_utils.debug_other_string(g_state_level,l_path_name, 'pa_gms_integration_api invoked');
1254: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Integration API if PA is enabled');
1255:
1256: IF g_bc_mode ='C' THEN
1257: l_partial_resv_flag := 'Y';
1258: l_bc_mode := 'C';

Line 1267: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_partial_resv_flag -> '||l_partial_resv_flag);

1263: l_bc_mode := g_bc_mode;
1264: l_partial_resv_flag := 'N';
1265: END IF;
1266:
1267: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_partial_resv_flag -> '||l_partial_resv_flag);
1268:
1269: BEGIN
1270: l_industry := NULL;
1271: l_prepare_stmt := NULL;

Line 1281: psa_utils.debug_other_string(g_state_level,l_path_name, ' Statement prepared -> '||l_prepare_stmt);

1277:
1278: l_pa_enabled := 0;
1279: l_prepare_stmt := 'BEGIN IF PA_BUDGET_FUND_PKG.IS_PA_BC_ENABLED() THEN'||' :1 := 1; END IF; END;';
1280:
1281: psa_utils.debug_other_string(g_state_level,l_path_name, ' Statement prepared -> '||l_prepare_stmt);
1282:
1283: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
1284:
1285: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

Line 1285: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

1281: psa_utils.debug_other_string(g_state_level,l_path_name, ' Statement prepared -> '||l_prepare_stmt);
1282:
1283: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
1284:
1285: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1286:
1287: IF l_pa_enabled = 1 THEN
1288:
1289: l_prepare_stmt := ' BEGIN '||

Line 1299: psa_utils.debug_other_string(g_error_level,l_path_name, 'PA Integration API Failed');

1295: IN l_partial_resv_flag,
1296: IN l_bc_mode,
1297: OUT l_ret_code;
1298: IF (l_ret_code = 'F') THEN
1299: psa_utils.debug_other_string(g_error_level,l_path_name, 'PA Integration API Failed');
1300: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSE

Line 1304: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Integration API Successful');

1300: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSE
1304: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Integration API Successful');
1305: END IF;
1306:
1307: END IF;
1308: END IF;

Line 1313: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Integration API if GMS is enabled');

1309: END IF;
1310:
1311: END;
1312:
1313: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Integration API if GMS is enabled');
1314: l_ret_code := NULL;
1315:
1316: BEGIN
1317: l_industry := NULL;

Line 1328: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1324:
1325: l_gms_enabled := 0;
1326: l_prepare_stmt := 'BEGIN IF GMS_INSTALL.ENABLED() THEN'||' :1 := 1; END IF; END;';
1327:
1328: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1329:
1330: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
1331:
1332: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

Line 1332: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

1328: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1329:
1330: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
1331:
1332: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);
1333:
1334: IF l_gms_enabled = 1 THEN
1335:
1336: l_prepare_stmt := ' BEGIN '||

Line 1340: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1336: l_prepare_stmt := ' BEGIN '||
1337: ' GMS_FUNDS_CONTROL_PKG.COPY_GL_PKT_TO_GMS_PKT ( '||
1338: ' :application_id, :mode, :partial_resv_flag, :ret_code); '||
1339: ' END; ';
1340: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1341: EXECUTE IMMEDIATE l_prepare_stmt USING IN g_application_id,
1342: IN l_bc_mode,
1343: IN l_partial_resv_flag,
1344: OUT l_ret_code;

Line 1346: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Failed');

1342: IN l_bc_mode,
1343: IN l_partial_resv_flag,
1344: OUT l_ret_code;
1345: IF (l_ret_code = 'F') THEN
1346: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Failed');
1347: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');
1348: FND_MSG_PUB.ADD;
1349: RAISE FND_API.G_EXC_ERROR;
1350: ELSE

Line 1351: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Successful');

1347: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');
1348: FND_MSG_PUB.ADD;
1349: RAISE FND_API.G_EXC_ERROR;
1350: ELSE
1351: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Successful');
1352: END IF;
1353:
1354: END IF;
1355: END IF;

Line 1361: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_integration_api' );

1357:
1358: END;
1359: EXCEPTION
1360: WHEN others THEN
1361: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_integration_api' );
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363:
1364: END pa_gms_integration_api;
1365:

Line 1379: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA_GMS_TIEBACK_API Invoked');

1375: l_bc_mode VARCHAR2(1);
1376:
1377: BEGIN
1378: l_path_name := g_path_name||'.pa_gms_tieback_api';
1379: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA_GMS_TIEBACK_API Invoked');
1380:
1381: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Tieback API if PA is enabled');
1382:
1383: IF g_bc_mode = 'C' THEN

Line 1381: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Tieback API if PA is enabled');

1377: BEGIN
1378: l_path_name := g_path_name||'.pa_gms_tieback_api';
1379: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA_GMS_TIEBACK_API Invoked');
1380:
1381: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke PA Tieback API if PA is enabled');
1382:
1383: IF g_bc_mode = 'C' THEN
1384: l_bc_mode := 'C';
1385: ELSIF g_bc_mode ='P' THEN

Line 1403: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1399:
1400: l_pa_enabled := 0;
1401: l_prepare_stmt := 'BEGIN IF PA_BUDGET_FUND_PKG.IS_PA_BC_ENABLED() THEN'||' :1 := 1; END IF; END;';
1402:
1403: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1404:
1405: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
1406:
1407: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

Line 1407: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

1403: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1404:
1405: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_pa_enabled;
1406:
1407: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1408:
1409: IF l_pa_enabled = 1 THEN
1410:
1411: l_prepare_stmt := ' BEGIN '||

Line 1414: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);

1410:
1411: l_prepare_stmt := ' BEGIN '||
1412: ' PA_FUNDS_CONTROL_PKG1.TIEBACK_FAILED_ACCT_STATUS( '||':bc_mode );'||
1413: ' END; ';
1414: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1415: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1416:
1417: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Tieback API Successful');
1418:

Line 1417: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Tieback API Successful');

1413: ' END; ';
1414: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_pa_enabled -> '||l_pa_enabled);
1415: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1416:
1417: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Tieback API Successful');
1418:
1419: END IF;
1420: END IF;
1421: END IF;

Line 1425: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Tieback API if GMS is enabled');

1421: END IF;
1422:
1423: END;
1424:
1425: psa_utils.debug_other_string(g_state_level,l_path_name, 'Invoke GMS Tieback API if GMS is enabled');
1426:
1427: BEGIN
1428: l_industry := NULL;
1429: l_prepare_stmt := NULL;

Line 1439: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1435:
1436: l_gms_enabled := 0;
1437: l_prepare_stmt := 'BEGIN IF GMS_INSTALL.ENABLED() THEN'||' :1 := 1; END IF; END;';
1438:
1439: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1440:
1441: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
1442:
1443: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

Line 1443: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);

1439: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1440:
1441: EXECUTE IMMEDIATE l_prepare_stmt USING OUT l_gms_enabled;
1442:
1443: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_gms_enabled -> '||l_gms_enabled);
1444:
1445: IF l_gms_enabled = 1 THEN
1446:
1447: l_prepare_stmt := ' BEGIN '||

Line 1450: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);

1446:
1447: l_prepare_stmt := ' BEGIN '||
1448: ' GMS_FUNDS_CONTROL_PKG.TIEBACK_FAILED_ACCT_STATUS( '||':bc_mode );'||
1449: ' END; ';
1450: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1451: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1452:
1453: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Tieback API Successful');
1454:

Line 1453: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Tieback API Successful');

1449: ' END; ';
1450: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> '||l_prepare_stmt);
1451: EXECUTE IMMEDIATE l_prepare_stmt USING IN l_bc_mode;
1452:
1453: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Tieback API Successful');
1454:
1455: END IF;
1456: END IF;
1457: END IF;

Line 1462: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_tieback_api' );

1458:
1459: END;
1460: EXCEPTION
1461: WHEN others THEN
1462: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_tieback_api' );
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464:
1465: END pa_gms_tieback_api;
1466:

Line 1474: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');

1470: l_path_name varchar2(300) ;
1471: BEGIN
1472: l_path_name := g_path_name || '.psa_cleanup_gt';
1473:
1474: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1475: DELETE FROM XLA_AE_HEADERS_GT;
1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1477: DELETE FROM XLA_AE_LINES_GT;
1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1472: l_path_name := g_path_name || '.psa_cleanup_gt';
1473:
1474: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1475: DELETE FROM XLA_AE_HEADERS_GT;
1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1477: DELETE FROM XLA_AE_LINES_GT;
1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1479: DELETE FROM XLA_VALIDATION_HDRS_GT;
1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1474: psa_utils.debug_other_string(g_state_level,l_path_name,'Cleaning up xla GT Tables');
1475: DELETE FROM XLA_AE_HEADERS_GT;
1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1477: DELETE FROM XLA_AE_LINES_GT;
1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1479: DELETE FROM XLA_VALIDATION_HDRS_GT;
1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1481: DELETE FROM XLA_VALIDATION_LINES_GT;
1482: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1476: psa_utils.debug_other_string(g_state_level,l_path_name, '1 XLA_AE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1477: DELETE FROM XLA_AE_LINES_GT;
1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1479: DELETE FROM XLA_VALIDATION_HDRS_GT;
1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1481: DELETE FROM XLA_VALIDATION_LINES_GT;
1482: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1483: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1484: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1482: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1478: psa_utils.debug_other_string(g_state_level,l_path_name, '2 XLA_AE_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1479: DELETE FROM XLA_VALIDATION_HDRS_GT;
1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1481: DELETE FROM XLA_VALIDATION_LINES_GT;
1482: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1483: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1484: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1485: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1486: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1484: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1480: psa_utils.debug_other_string(g_state_level,l_path_name, '3 XLA_VALIDATION_HDRS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1481: DELETE FROM XLA_VALIDATION_LINES_GT;
1482: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1483: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1484: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1485: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1486: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1487: DELETE FROM XLA_BAL_RECREATE_GT;
1488: psa_utils.debug_other_string(g_state_level,l_path_name, '7 XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1486: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1482: psa_utils.debug_other_string(g_state_level,l_path_name, '4 XLA_VALIDATION_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1483: DELETE FROM XLA_BAL_CTRL_CTRBS_GT;
1484: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1485: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1486: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1487: DELETE FROM XLA_BAL_RECREATE_GT;
1488: psa_utils.debug_other_string(g_state_level,l_path_name, '7 XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1489: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1490: psa_utils.debug_other_string(g_state_level,l_path_name, '8 XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1488: psa_utils.debug_other_string(g_state_level,l_path_name, '7 XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);

1484: psa_utils.debug_other_string(g_state_level,l_path_name, '5 XLA_BAL_CTRL_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1485: DELETE FROM XLA_BAL_PERIOD_STATS_GT;
1486: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1487: DELETE FROM XLA_BAL_RECREATE_GT;
1488: psa_utils.debug_other_string(g_state_level,l_path_name, '7 XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1489: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1490: psa_utils.debug_other_string(g_state_level,l_path_name, '8 XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1491: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1492: psa_utils.debug_other_string(g_state_level,l_path_name, '9 XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1490: psa_utils.debug_other_string(g_state_level,l_path_name, '8 XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1486: psa_utils.debug_other_string(g_state_level,l_path_name, '6 XLA_BAL_PERIOD_STATS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1487: DELETE FROM XLA_BAL_RECREATE_GT;
1488: psa_utils.debug_other_string(g_state_level,l_path_name, '7 XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1489: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1490: psa_utils.debug_other_string(g_state_level,l_path_name, '8 XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1491: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1492: psa_utils.debug_other_string(g_state_level,l_path_name, '9 XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1493: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1494: psa_utils.debug_other_string(g_state_level,l_path_name, '10 XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1492: psa_utils.debug_other_string(g_state_level,l_path_name, '9 XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1488: psa_utils.debug_other_string(g_state_level,l_path_name, '7 XLA_BAL_RECREATE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1489: DELETE FROM XLA_BAL_ANACRI_LINES_GT;
1490: psa_utils.debug_other_string(g_state_level,l_path_name, '8 XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1491: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1492: psa_utils.debug_other_string(g_state_level,l_path_name, '9 XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1493: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1494: psa_utils.debug_other_string(g_state_level,l_path_name, '10 XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1495: DELETE FROM XLA_BAL_STATUSES_GT;
1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1494: psa_utils.debug_other_string(g_state_level,l_path_name, '10 XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);

1490: psa_utils.debug_other_string(g_state_level,l_path_name, '8 XLA_BAL_ANACRI_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1491: DELETE FROM XLA_BAL_ANACRI_CTRBS_GT;
1492: psa_utils.debug_other_string(g_state_level,l_path_name, '9 XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1493: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1494: psa_utils.debug_other_string(g_state_level,l_path_name, '10 XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1495: DELETE FROM XLA_BAL_STATUSES_GT;
1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1497: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1492: psa_utils.debug_other_string(g_state_level,l_path_name, '9 XLA_BAL_ANACRI_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1493: DELETE FROM XLA_BAL_SYNCHRONIZE_GT;
1494: psa_utils.debug_other_string(g_state_level,l_path_name, '10 XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1495: DELETE FROM XLA_BAL_STATUSES_GT;
1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1497: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1499: DELETE FROM XLA_EVENTS_GT;
1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1494: psa_utils.debug_other_string(g_state_level,l_path_name, '10 XLA_BAL_SYNCHRONIZE_GT : Deleted Row count :'||SQL%ROWCOUNT);
1495: DELETE FROM XLA_BAL_STATUSES_GT;
1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1497: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1499: DELETE FROM XLA_EVENTS_GT;
1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1501: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1497: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1499: DELETE FROM XLA_EVENTS_GT;
1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1501: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1503: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1499: DELETE FROM XLA_EVENTS_GT;
1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1501: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1503: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1505: DELETE FROM XLA_TAB_ERRORS_GT;
1506: psa_utils.debug_other_string(g_state_level,l_path_name, '16 XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1501: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1503: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1505: DELETE FROM XLA_TAB_ERRORS_GT;
1506: psa_utils.debug_other_string(g_state_level,l_path_name, '16 XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1507: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1508: psa_utils.debug_other_string(g_state_level,l_path_name, '17 XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1506: psa_utils.debug_other_string(g_state_level,l_path_name, '16 XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1503: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1505: DELETE FROM XLA_TAB_ERRORS_GT;
1506: psa_utils.debug_other_string(g_state_level,l_path_name, '16 XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1507: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1508: psa_utils.debug_other_string(g_state_level,l_path_name, '17 XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1509: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1510: psa_utils.debug_other_string(g_state_level,l_path_name, '18 XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1508: psa_utils.debug_other_string(g_state_level,l_path_name, '17 XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1505: DELETE FROM XLA_TAB_ERRORS_GT;
1506: psa_utils.debug_other_string(g_state_level,l_path_name, '16 XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1507: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1508: psa_utils.debug_other_string(g_state_level,l_path_name, '17 XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1509: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1510: psa_utils.debug_other_string(g_state_level,l_path_name, '18 XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1511: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1512: psa_utils.debug_other_string(g_state_level,l_path_name, '19 XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1510: psa_utils.debug_other_string(g_state_level,l_path_name, '18 XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1506: psa_utils.debug_other_string(g_state_level,l_path_name, '16 XLA_TAB_ERRORS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1507: DELETE FROM XLA_SEQ_JE_HEADERS_GT;
1508: psa_utils.debug_other_string(g_state_level,l_path_name, '17 XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1509: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1510: psa_utils.debug_other_string(g_state_level,l_path_name, '18 XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1511: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1512: psa_utils.debug_other_string(g_state_level,l_path_name, '19 XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1513: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1514: psa_utils.debug_other_string(g_state_level,l_path_name, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1512: psa_utils.debug_other_string(g_state_level,l_path_name, '19 XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1508: psa_utils.debug_other_string(g_state_level,l_path_name, '17 XLA_SEQ_JE_HEADERS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1509: DELETE FROM XLA_TAB_NEW_CCIDS_GT;
1510: psa_utils.debug_other_string(g_state_level,l_path_name, '18 XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1511: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1512: psa_utils.debug_other_string(g_state_level,l_path_name, '19 XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1513: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1514: psa_utils.debug_other_string(g_state_level,l_path_name, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1515: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1516: psa_utils.debug_other_string(g_state_level,l_path_name, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1514: psa_utils.debug_other_string(g_state_level,l_path_name, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1510: psa_utils.debug_other_string(g_state_level,l_path_name, '18 XLA_TAB_NEW_CCIDS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1511: DELETE FROM XLA_EXTRACT_OBJECTS_GT;
1512: psa_utils.debug_other_string(g_state_level,l_path_name, '19 XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1513: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1514: psa_utils.debug_other_string(g_state_level,l_path_name, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1515: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1516: psa_utils.debug_other_string(g_state_level,l_path_name, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1517: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1516: psa_utils.debug_other_string(g_state_level,l_path_name, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1512: psa_utils.debug_other_string(g_state_level,l_path_name, '19 XLA_EXTRACT_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1513: DELETE FROM XLA_REFERENCE_OBJECTS_GT;
1514: psa_utils.debug_other_string(g_state_level,l_path_name, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1515: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1516: psa_utils.debug_other_string(g_state_level,l_path_name, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1517: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1519: DELETE FROM XLA_TRIAL_BALANCES_GT;
1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);

1514: psa_utils.debug_other_string(g_state_level,l_path_name, '20 XLA_REFERENCE_OBJECTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1515: DELETE FROM XLA_TRANSACTION_ACCTS_GT;
1516: psa_utils.debug_other_string(g_state_level,l_path_name, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1517: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1519: DELETE FROM XLA_TRIAL_BALANCES_GT;
1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1522: DELETE FROM XLA_ACCT_PROG_DOCS_GT;

Line 1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1516: psa_utils.debug_other_string(g_state_level,l_path_name, '21 XLA_TRANSACTION_ACCTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1517: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1519: DELETE FROM XLA_TRIAL_BALANCES_GT;
1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1522: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1524: DELETE FROM XLA_MERGE_SEG_MAPS_GT;

Line 1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1517: DELETE FROM XLA_UPG_LINE_CRITERIA_GT;
1518: psa_utils.debug_other_string(g_state_level,l_path_name, '22 XLA_UPG_LINE_CRITERIA_GT : Deleted Row count :'||SQL%ROWCOUNT);
1519: DELETE FROM XLA_TRIAL_BALANCES_GT;
1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1522: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1524: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1519: DELETE FROM XLA_TRIAL_BALANCES_GT;
1520: psa_utils.debug_other_string(g_state_level,l_path_name, '23 XLA_TRIAL_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1522: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1524: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1526: DELETE FROM XLA_EVENTS_INT_GT;
1527: psa_utils.debug_other_string(g_state_level,l_path_name, '27 XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1521: DELETE FROM XLA_ACCT_PROG_EVENTS_GT; psa_utils.debug_other_string(g_state_level,l_path_name, '24 XLA_ACCT_PROG_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1522: DELETE FROM XLA_ACCT_PROG_DOCS_GT;
1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1524: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1526: DELETE FROM XLA_EVENTS_INT_GT;
1527: psa_utils.debug_other_string(g_state_level,l_path_name, '27 XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);
1528: DELETE FROM XLA_REPORT_BALANCES_GT;
1529: psa_utils.debug_other_string(g_state_level,l_path_name, '28 XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1527: psa_utils.debug_other_string(g_state_level,l_path_name, '27 XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);

1523: psa_utils.debug_other_string(g_state_level,l_path_name, '25 XLA_ACCT_PROG_DOCS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1524: DELETE FROM XLA_MERGE_SEG_MAPS_GT;
1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1526: DELETE FROM XLA_EVENTS_INT_GT;
1527: psa_utils.debug_other_string(g_state_level,l_path_name, '27 XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);
1528: DELETE FROM XLA_REPORT_BALANCES_GT;
1529: psa_utils.debug_other_string(g_state_level,l_path_name, '28 XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1530: DELETE FROM XLA_TB_BALANCES_GT;
1531: psa_utils.debug_other_string(g_state_level,l_path_name, '29 XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1529: psa_utils.debug_other_string(g_state_level,l_path_name, '28 XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1525: psa_utils.debug_other_string(g_state_level,l_path_name, '26 XLA_MERGE_SEG_MAPS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1526: DELETE FROM XLA_EVENTS_INT_GT;
1527: psa_utils.debug_other_string(g_state_level,l_path_name, '27 XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);
1528: DELETE FROM XLA_REPORT_BALANCES_GT;
1529: psa_utils.debug_other_string(g_state_level,l_path_name, '28 XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1530: DELETE FROM XLA_TB_BALANCES_GT;
1531: psa_utils.debug_other_string(g_state_level,l_path_name, '29 XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1532: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1533: psa_utils.debug_other_string(g_state_level,l_path_name, '30 XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

Line 1531: psa_utils.debug_other_string(g_state_level,l_path_name, '29 XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);

1527: psa_utils.debug_other_string(g_state_level,l_path_name, '27 XLA_EVENTS_INT_GT : Deleted Row count :'||SQL%ROWCOUNT);
1528: DELETE FROM XLA_REPORT_BALANCES_GT;
1529: psa_utils.debug_other_string(g_state_level,l_path_name, '28 XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1530: DELETE FROM XLA_TB_BALANCES_GT;
1531: psa_utils.debug_other_string(g_state_level,l_path_name, '29 XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1532: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1533: psa_utils.debug_other_string(g_state_level,l_path_name, '30 XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1534: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');
1535: END psa_cleanup_gt;

Line 1533: psa_utils.debug_other_string(g_state_level,l_path_name, '30 XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1529: psa_utils.debug_other_string(g_state_level,l_path_name, '28 XLA_REPORT_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1530: DELETE FROM XLA_TB_BALANCES_GT;
1531: psa_utils.debug_other_string(g_state_level,l_path_name, '29 XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1532: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1533: psa_utils.debug_other_string(g_state_level,l_path_name, '30 XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1534: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');
1535: END psa_cleanup_gt;
1536:
1537:

Line 1534: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');

1530: DELETE FROM XLA_TB_BALANCES_GT;
1531: psa_utils.debug_other_string(g_state_level,l_path_name, '29 XLA_TB_BALANCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1532: DELETE FROM XLA_BAL_AC_CTRBS_GT;
1533: psa_utils.debug_other_string(g_state_level,l_path_name, '30 XLA_BAL_AC_CTRBS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1534: psa_utils.debug_other_string(g_state_level,l_path_name,'clean_xla_gt -');
1535: END psa_cleanup_gt;
1536:
1537:
1538: ----------------------------------------------------- --------------------------------------------------