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.BSC_SECURITY dependencies on BSC_APPS

Line 130: h_message := bsc_apps.get_message('BSC_INV_USER_NAME');

126: END IF;
127: dbms_sql.close_cursor(l_curr);
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: h_message := bsc_apps.get_message('BSC_INV_USER_NAME');
131: RAISE h_undefined_user;
132: END;
133:
134: IF (h_st_dt_chk < 0 OR h_end_dt_chk > 0) THEN

Line 135: h_message := bsc_apps.get_message('BSC_LOGIN_EXPIRED');

131: RAISE h_undefined_user;
132: END;
133:
134: IF (h_st_dt_chk < 0 OR h_end_dt_chk > 0) THEN
135: h_message := bsc_apps.get_message('BSC_LOGIN_EXPIRED');
136: RAISE h_login_expired;
137:
138: END IF;
139:

Line 170: h_message := bsc_apps.get_message('BSC_INV_OBSC');

166: END IF;
167: dbms_sql.close_cursor(l_curr);
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN
170: h_message := bsc_apps.get_message('BSC_INV_OBSC');
171: RAISE h_undefined_obsc_user;
172: END;
173:
174: -- Get UBSC username and encrypted password

Line 203: h_message := bsc_apps.get_message('BSC_INV_UBSC');

199: END IF;
200: dbms_sql.close_cursor(l_curr);
201: EXCEPTION
202: WHEN NO_DATA_FOUND THEN
203: h_message := bsc_apps.get_message('BSC_INV_UBSC');
204: RAISE h_undefined_ubsc_user;
205: END;
206: INSERT INTO bsc_user_info(
207: SID,

Line 427: -- Initialize BSC/APPS global variables

423:
424: l_count NUMBER;
425:
426: Begin
427: -- Initialize BSC/APPS global variables
428: BSC_APPS.Init_Bsc_Apps;
429:
430: BSC_MESSAGE.Init(X_Debug_Flag => x_debug_flag);
431:

Line 428: BSC_APPS.Init_Bsc_Apps;

424: l_count NUMBER;
425:
426: Begin
427: -- Initialize BSC/APPS global variables
428: BSC_APPS.Init_Bsc_Apps;
429:
430: BSC_MESSAGE.Init(X_Debug_Flag => x_debug_flag);
431:
432: l_calling_fn := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';

Line 433: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SYSTEM');

429:
430: BSC_MESSAGE.Init(X_Debug_Flag => x_debug_flag);
431:
432: l_calling_fn := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
433: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SYSTEM');
434: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
435: h_components(-101) := h_components(-100); -- Loader concurrent program
436: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
437: h_components(-201) := h_components(-200); --Generate documentation

Line 434: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI

430: BSC_MESSAGE.Init(X_Debug_Flag => x_debug_flag);
431:
432: l_calling_fn := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
433: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SYSTEM');
434: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
435: h_components(-101) := h_components(-100); -- Loader concurrent program
436: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
437: h_components(-201) := h_components(-200); --Generate documentation
438: h_components(-202) := h_components(-200); --Rename input tables

Line 436: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');

432: l_calling_fn := 'BSC_SECURITY.CHECK_SYSTEM_LOCK';
433: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SYSTEM');
434: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
435: h_components(-101) := h_components(-100); -- Loader concurrent program
436: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
437: h_components(-201) := h_components(-200); --Generate documentation
438: h_components(-202) := h_components(-200); --Rename input tables
439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');

Line 439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');

435: h_components(-101) := h_components(-100); -- Loader concurrent program
436: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
437: h_components(-201) := h_components(-200); --Generate documentation
438: h_components(-202) := h_components(-200); --Rename input tables
439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');

Line 440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');

436: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
437: h_components(-201) := h_components(-200); --Generate documentation
438: h_components(-202) := h_components(-200); --Rename input tables
439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
444: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION'); -- Migration Backend Target

Line 441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');

437: h_components(-201) := h_components(-200); --Generate documentation
438: h_components(-202) := h_components(-200); --Rename input tables
439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
444: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION'); -- Migration Backend Target
445: h_components(-801) := h_components(-800); -- Migration UI

Line 442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');

438: h_components(-202) := h_components(-200); --Rename input tables
439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
444: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION'); -- Migration Backend Target
445: h_components(-801) := h_components(-800); -- Migration UI
446: h_components(-802) := h_components(-800); -- Migration Backend Source

Line 443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');

439: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
444: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION'); -- Migration Backend Target
445: h_components(-801) := h_components(-800); -- Migration UI
446: h_components(-802) := h_components(-800); -- Migration Backend Source
447:

Line 444: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION'); -- Migration Backend Target

440: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
441: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
442: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
443: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
444: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION'); -- Migration Backend Target
445: h_components(-801) := h_components(-800); -- Migration UI
446: h_components(-802) := h_components(-800); -- Migration Backend Source
447:
448: -- Ref: bug#3482442 In corner cases this query can return more than one

Line 452: h_user_id := BSC_APPS.fnd_global_user_id;

448: -- Ref: bug#3482442 In corner cases this query can return more than one
449: -- row and it will fail. AUDSID is not PK. After meeting with
450: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
451: h_session_id := USERENV('SESSIONID');
452: h_user_id := BSC_APPS.fnd_global_user_id;
453:
454: -- Clean BSC_MESSAGE_LOGS for the current session
455: DELETE bsc_message_logs
456: WHERE last_update_login = h_session_id;

Line 507: -- IF BSC_APPS.APPS_ENV THEN

503: -- kill the session for any reason. What we can do is to delete the record
504: -- from BSC_CURRENT_SESSIONS table.
505: --
506: --IF x_program_id <> -600 THEN
507: -- IF BSC_APPS.APPS_ENV THEN
508: -- OPEN c_ksessions;
509: -- FETCH c_ksessions INTO h_ksession;
510: -- WHILE c_ksessions%FOUND LOOP
511: -- DELETE BSC_CURRENT_SESSIONS

Line 536: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

532:
533: -- fixed the following SQLS for the literals bug
534:
535: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
536: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
537: ' WHERE c.session_id = s.audsid'||
538: ' AND c.program_id in (-700, -800)'||
539: ' AND c.session_id <> :1 '||
540: ' AND c.user_id = u.user_id (+)';

Line 548: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

544: -- Several instances can run at the same time.
545: -- It can run at the same time with iViewer, Metadata Optimizer(Generate Documentation or Rename input tables)
546: -- They cannot run at the same time with Loader or Metadata(Configure Indicators), Upgrade or Migration.
547: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
548: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
549: ' WHERE c.session_id = s.audsid'||
550: ' AND c.program_id in (-100, -101, -200, -700, -800, -802)'||
551: ' AND c.session_id <> :1 '||
552: ' AND c.user_id = u.user_id (+)';

Line 561: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

557: -- They can run at the same time with iViewer, Security and Metadata Optimizer (Rename input tables)
558: -- They cannot run at the same time with Loader, Metadata(Configure Indicators),
559: -- Metadata Optmizer(Generate documention), Upgrade or Migration.
560: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
561: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
562: ' WHERE c.session_id = s.audsid'||
563: ' AND c.program_id in (-100, -101, -200, -201, -700, -800, -802)'||
564: ' AND c.session_id <> :1 '||
565: ' AND c.user_id = u.user_id (+)';

Line 572: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

568: -- Loader UI
569: -- Only one instance at the same time.
570: -- It cannot run at the same time with any other tool but IViewer and Metadata Optmizer(Generate documentation).
571: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
572: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
573: ' WHERE c.session_id = s.audsid'||
574: ' AND c.program_id in (-100, -101, -200, -202, -300, -400, -500, -700, -800, -802)'||
575: ' AND c.session_id <> :1'||
576: ' AND c.user_id = u.user_id (+)';

Line 584: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

580: -- Only one instance at the same time.
581: -- It cannot run at the same time with any other tool but IViewer and Metadata Optmizer(Generate documentation).
582: -- It cannot run with other Loader Concurrent program but It can run with a Loader UI.
583: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
584: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
585: ' WHERE c.session_id = s.audsid'||
586: ' AND c.program_id in (-101, -200, -202, -300, -400, -500, -700, -800, -802)'||
587: ' AND c.session_id <> :1'||
588: ' AND c.user_id = u.user_id (+)';

Line 597: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

593: -- Only one instance at the same time.
594: -- It can run at the same time with: IViewer (Bug 3731337)
595: -- It cannot run at the same time with any other tool.
596: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
597: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
598: ' WHERE c.session_id = s.audsid'||
599: ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -700, -800, -802)'||
600: ' AND c.session_id <> :1 '||
601: ' AND c.user_id = u.user_id (+)';

Line 611: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

607: -- It can run at the same time with: Loader, Security and Viewer
608: -- It cannot run at the same time with: Metadata Optimizer(Configure Indicators or Rename input tables),
609: -- Builder, Designer, Upgrade or Migration
610: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
611: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
612: ' WHERE c.session_id = s.audsid'||
613: ' AND c.program_id in (-200, -202, -400, -500, -700, -800, -802)'||
614: ' AND c.session_id <> :1 '||
615: ' AND c.user_id = u.user_id (+)';

Line 623: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

619: -- It can run at the same time with: Security, Designer, Builder and Viewer
620: -- It cannot run at the same time with: Metadata Optimizer(Configure Indicators or Rename input tables
621: -- or Generate Documentation), Loader, Upgrade or Migration
622: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
623: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
624: ' WHERE c.session_id = s.audsid'||
625: ' AND c.program_id in (-100, -101, -200, -201, -202, -700, -800, -802)'||
626: ' AND c.session_id <> :1 '||
627: ' AND c.user_id = u.user_id (+)';

Line 633: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

629: ELSIF x_program_id = -801 THEN
630: -- Migration ui
631: -- It cannot run if there is any other user in migration UI or migration CON req is running
632: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
633: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
634: ' WHERE c.session_id = s.audsid'||
635: ' AND c.program_id in (-700, -800, -801, -802)'||
636: ' AND c.session_id <> :1 '||
637: ' AND c.user_id = u.user_id (+)';

Line 643: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

639: ELSIF x_program_id = -802 THEN
640: -- Migration backend (source)
641: -- iViewer can run with Migration backend (source)
642: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
643: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
644: ' WHERE c.session_id = s.audsid'||
645: ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -700, -800, -801)'||
646: ' AND c.session_id <> :1 '||
647: ' AND c.user_id = u.user_id (+)';

Line 655: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||

651: -- Only one instance at the same time.
652: -- It cannot run at the same time with any other tool.
653: -- code -801 added for migration UI. migration process can not run if any user is there in UI
654: h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
655: ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
656: ' WHERE c.session_id = s.audsid'||
657: ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -600, -700, -800, -801, -802)'||
658: ' AND c.session_id <> :1 '||
659: ' AND c.user_id = u.user_id (+)';

Line 679: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));

675: DBMS_SQL.COLUMN_VALUE(h_cursor, 3, h_machine);
676: DBMS_SQL.COLUMN_VALUE(h_cursor, 4, h_terminal);
677:
678: l_message := l_lock_msg;
679: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));
680: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);
681:
682: --------------------------------------------------------------
683: -- Jui Wang Apr/05/2001

Line 680: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);

676: DBMS_SQL.COLUMN_VALUE(h_cursor, 4, h_terminal);
677:
678: l_message := l_lock_msg;
679: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));
680: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);
681:
682: --------------------------------------------------------------
683: -- Jui Wang Apr/05/2001
684: -- Delete the invisible char, trailing CHR(0), from h_machine

Line 688: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine2);

684: -- Delete the invisible char, trailing CHR(0), from h_machine
685: -- Also close the cursor before raise BSC_Lock_Error
686: --------------------------------------------------------------
687: h_machine2 := REPLACE(h_machine, CHR(0));
688: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine2);
689: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);
690: DBMS_SQL.CLOSE_CURSOR(h_cursor);
691: raise BSC_Lock_Error;
692: END IF;

Line 689: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);

685: -- Also close the cursor before raise BSC_Lock_Error
686: --------------------------------------------------------------
687: h_machine2 := REPLACE(h_machine, CHR(0));
688: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine2);
689: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);
690: DBMS_SQL.CLOSE_CURSOR(h_cursor);
691: raise BSC_Lock_Error;
692: END IF;
693: DBMS_SQL.CLOSE_CURSOR(h_cursor);

Line 793: IF BSC_APPS.APPS_ENV THEN

789: -- WHERE PHASE_CODE = 'C');
790:
791: -- Kill IViewer Sessions that have been INACTIVE more than 20 minutes
792: IF p_program_id <> -600 THEN
793: IF BSC_APPS.APPS_ENV THEN
794: DELETE BSC_CURRENT_SESSIONS
795: WHERE PROGRAM_ID = -600
796: AND SESSION_ID IN (
797: SELECT s.audsid

Line 854: -- Initialize BSC/APPS global variables

850:
851: h_components t_array_of_varchar2;
852:
853: Begin
854: -- Initialize BSC/APPS global variables
855: BSC_APPS.Init_Bsc_Apps;
856:
857: BSC_MESSAGE.Init(X_Debug_Flag => X_Debug_Flag);
858:

Line 855: BSC_APPS.Init_Bsc_Apps;

851: h_components t_array_of_varchar2;
852:
853: Begin
854: -- Initialize BSC/APPS global variables
855: BSC_APPS.Init_Bsc_Apps;
856:
857: BSC_MESSAGE.Init(X_Debug_Flag => X_Debug_Flag);
858:
859: l_calling_fn := 'BSC_SECURITY.CHECK_SOURCE_SYSTEM_LOCK';

Line 860: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SRC_SYSTEM');

856:
857: BSC_MESSAGE.Init(X_Debug_Flag => X_Debug_Flag);
858:
859: l_calling_fn := 'BSC_SECURITY.CHECK_SOURCE_SYSTEM_LOCK';
860: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SRC_SYSTEM');
861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation

Line 861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI

857: BSC_MESSAGE.Init(X_Debug_Flag => X_Debug_Flag);
858:
859: l_calling_fn := 'BSC_SECURITY.CHECK_SOURCE_SYSTEM_LOCK';
860: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SRC_SYSTEM');
861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables

Line 862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program

858:
859: l_calling_fn := 'BSC_SECURITY.CHECK_SOURCE_SYSTEM_LOCK';
860: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SRC_SYSTEM');
861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');

Line 863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');

859: l_calling_fn := 'BSC_SECURITY.CHECK_SOURCE_SYSTEM_LOCK';
860: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SRC_SYSTEM');
861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');

Line 864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation

860: l_lock_msg := bsc_apps.get_message('BSC_SEC_LOCKED_SRC_SYSTEM');
861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');

Line 865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables

861: h_components(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');

Line 866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');

862: h_components(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader Concurrent program
863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');

Line 867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');

863: h_components(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
871: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION');

Line 868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');

864: h_components(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Generate documentation
865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
871: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION');
872:

Line 869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');

865: h_components(-202) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); -- Rename input tables
866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
871: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION');
872:
873: -- Get the session id in the source system

Line 870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');

866: h_components(-300) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_ADMINISTRATOR');
867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
871: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION');
872:
873: -- Get the session id in the source system
874: /* changed to fixed bug 2669465

Line 871: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION');

867: h_components(-400) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'KPI_DESIGNER');
868: h_components(-500) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_BUILDER');
869: h_components(-600) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'OBSC_VIEWER');
870: h_components(-700) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'UPGRADE');
871: h_components(-800) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'SYSTEM_MIGRATION');
872:
873: -- Get the session id in the source system
874: /* changed to fixed bug 2669465
875: h_sql := 'select s.user#, s.audsid'||

Line 902: h_user_id := BSC_APPS.fnd_global_user_id;

898: -- Ref: bug#3482442 In corner cases this query can return more than one
899: -- row and it will fail. AUDSID is not PK. After meeting with
900: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
901: h_session_id := USERENV('SESSIONID');
902: h_user_id := BSC_APPS.fnd_global_user_id;
903:
904: -- Clean BSC_MESSAGE_LOGS for the current session
905: DELETE bsc_message_logs
906: WHERE last_update_login = h_session_id;

Line 912: BSC_APPS.Execute_Immediate(h_sql);

908:
909: -- Clean BSC_CURRENT_SESSIONS in the source system to leave only current sessions
910: h_sql := 'Delete bsc_current_sessions@'||c_src_db_link||
911: ' Where session_id Not In (Select audsid From V$Session@'||c_src_db_link||')';
912: BSC_APPS.Execute_Immediate(h_sql);
913:
914: commit;
915:
916: -- Delete KILLED sessions from bsc_current_sessions

Line 920: BSC_APPS.Execute_Immediate(h_sql);

916: -- Delete KILLED sessions from bsc_current_sessions
917: h_sql := 'Delete bsc_current_sessions@'||c_src_db_link||
918: ' Where session_id In (Select audsid From V$Session@'||c_src_db_link||
919: ' Where status = ''KILLED'')';
920: BSC_APPS.Execute_Immediate(h_sql);
921:
922: commit;
923:
924: -- Make the query to validate if the application can run or not.

Line 951: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));

947: DBMS_SQL.COLUMN_VALUE(h_cursor, 3, h_machine);
948: DBMS_SQL.COLUMN_VALUE(h_cursor, 4, h_terminal);
949:
950: l_message := l_lock_msg;
951: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));
952: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);
953: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine);
954: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);
955:

Line 952: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);

948: DBMS_SQL.COLUMN_VALUE(h_cursor, 4, h_terminal);
949:
950: l_message := l_lock_msg;
951: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));
952: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);
953: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine);
954: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);
955:
956: raise BSC_Lock_Error;

Line 953: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine);

949:
950: l_message := l_lock_msg;
951: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));
952: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);
953: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine);
954: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);
955:
956: raise BSC_Lock_Error;
957: END IF;

Line 954: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);

950: l_message := l_lock_msg;
951: l_message := bsc_apps.replace_token(l_message, 'COMPONENT', h_components(h_program_id));
952: l_message := bsc_apps.replace_token(l_message, 'USERNAME', h_username);
953: l_message := bsc_apps.replace_token(l_message, 'MACHINE', h_machine);
954: l_message := bsc_apps.replace_token(l_message, 'TERMINAL', h_terminal);
955:
956: raise BSC_Lock_Error;
957: END IF;
958: DBMS_SQL.CLOSE_CURSOR(h_cursor);

Line 965: BSC_APPS.Execute_Immediate(h_sql);

961: h_sql := 'Insert Into bsc_current_sessions@'||c_src_db_link||
962: ' (SESSION_ID,PROGRAM_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)'||
963: ' Values ('||h_src_session_id||', -800, '||h_src_user_id||', SYSDATE, '||
964: h_src_user_id||', SYSDATE, '||h_src_session_id||')';
965: BSC_APPS.Execute_Immediate(h_sql);
966:
967: COMMIT;
968:
969: Exception

Line 1085: return user_has_lock(X_SID,BSC_APPS.get_user_schema);

1081: h_cursor t_cursor;
1082:
1083: begin
1084:
1085: return user_has_lock(X_SID,BSC_APPS.get_user_schema);
1086: /*yes_no :='N';
1087: -- bug fix 3008243
1088:
1089: h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||

Line 1090: ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%'' AND SESSION_ID = :1';

1086: /*yes_no :='N';
1087: -- bug fix 3008243
1088:
1089: h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||
1090: ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%'' AND SESSION_ID = :1';
1091:
1092: OPEN h_cursor FOR h_sql USING X_SID;
1093: FETCH h_cursor INTO l_count;
1094: IF h_cursor%NOTFOUND THEN

Line 1173: ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%''';

1169: yes_no :='Y';
1170: -- bug fix 3008243
1171:
1172: h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||
1173: ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%''';
1174:
1175: OPEN h_cursor FOR h_sql;
1176: FETCH h_cursor INTO l_count;
1177: IF h_cursor%NOTFOUND THEN

Line 1208: h_sql :='SELECT COUNT(*) FROM BSC_CURRENT_SESSIONS C, V$SESSION S, V$SESSION_WAIT W, BSC_APPS_USERS_V U ';

1204: h_cursor t_cursor;
1205:
1206: begin
1207:
1208: h_sql :='SELECT COUNT(*) FROM BSC_CURRENT_SESSIONS C, V$SESSION S, V$SESSION_WAIT W, BSC_APPS_USERS_V U ';
1209: h_sql := h_sql || 'WHERE C.SESSION_ID = S.AUDSID AND S.SID = W.SID AND S.STATUS <> ''KILLED'' AND U.USER_ID = C.USER_ID AND C.PROGRAM_ID = -200';
1210:
1211: yes_no :='N';
1212: -- bug fix 3008243

Line 1215: ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%''';

1211: yes_no :='N';
1212: -- bug fix 3008243
1213:
1214: h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||
1215: ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%''';
1216:
1217: OPEN h_cursor FOR h_sql;
1218: FETCH h_cursor INTO l_count;
1219: IF h_cursor%NOTFOUND THEN