124: (p_msg IN VARCHAR2
125: ,p_level IN NUMBER) IS
126: BEGIN
127: IF g_debug_flag = 'Y' THEN
128: xla_utility_pkg.trace
129: (p_msg
130: ,p_level);
131: END IF;
132: EXCEPTION
537: WHERE application_id = NVL(p_application_id,application_id);
538:
539: l_sysdate DATE;
540: BEGIN
541: xla_utility_pkg.activate('SRS_DBP', 'xla_acct_setup_pkg.perform_application_setup_cp');
542:
543: trace('> xla_acct_setup_pkg.perform_application_setup_cp', 20);
544: trace('p_application_id = '||p_application_id,20);
545:
781: p_retcode := 0;
782: p_errbuf := NULL;
783:
784: trace('< xla_acct_setup_pkg.perform_application_setup_cp', 20);
785: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
786: EXCEPTION
787: WHEN xla_exceptions_pkg.application_exception THEN
788: ----------------------------------------------------------------------------
789: -- set out variables
790: ----------------------------------------------------------------------------
791: p_retcode := 2;
792: p_errbuf := xla_messages_pkg.get_message;
793:
794: xla_utility_pkg.print_logfile(p_errbuf);
795: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
796: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
797: WHEN OTHERS THEN
798: ----------------------------------------------------------------------------
792: p_errbuf := xla_messages_pkg.get_message;
793:
794: xla_utility_pkg.print_logfile(p_errbuf);
795: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
796: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
797: WHEN OTHERS THEN
798: ----------------------------------------------------------------------------
799: -- set out variables
800: ----------------------------------------------------------------------------
800: ----------------------------------------------------------------------------
801: p_retcode := 2;
802: p_errbuf := sqlerrm;
803:
804: xla_utility_pkg.print_logfile(p_errbuf);
805: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
806: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
807: END perform_application_setup_cp;
808:
802: p_errbuf := sqlerrm;
803:
804: xla_utility_pkg.print_logfile(p_errbuf);
805: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
806: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
807: END perform_application_setup_cp;
808:
809:
810: