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_METADATA_OPTIMIZER_PKG dependencies on BSC_LOCKS_PUB

Line 927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');

923: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN
927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');
928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);
929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');
930: EXCEPTION when others then
931: g_retcode := 1;

Line 928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);

924: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN
927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');
928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);
929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');
930: EXCEPTION when others then
931: g_retcode := 1;
932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

Line 929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');

925: bsc_mo_helper_pkg.writeTmp(' ', FND_LOG.LEVEL_STATEMENT, true);
926: BEGIN
927: logProgress('MISC', 'Calling BSC_LOCKS_PUB.SYNCHRONIZE');
928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);
929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');
930: EXCEPTION when others then
931: g_retcode := 1;
932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
933: END;

Line 932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

928: BSC_LOCKS_PUB.SYNCHRONIZE (-200, BSC_APPS.apps_user_id, x_return_status, x_msg_count, x_msg_data);
929: logProgress('MISC', 'Completed BSC_LOCKS_PUB.SYNCHRONIZE');
930: EXCEPTION when others then
931: g_retcode := 1;
932: bsc_mo_helper_pkg.writeTmp('WARNING: EXCEPTION in Call OUT BSC_LOCKS_PUB.SYNCHRONIZE : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
933: END;
934: bsc_mo_helper_pkg.writeTmp('Completed Wrapup', FND_LOG.LEVEL_PROCEDURE, true);
935: EXCEPTION when others then
936: logProgress('ALL', 'Exception in wrapup:'||sqlerrm);

Line 950: bsc_locks_pub.REMOVE_SYSTEM_LOCK;

946: ELSE
947: bsc_mo_helper_pkg.writeTmp('Initalize did not succeed :'||g_errbuf);
948: END IF;
949: --bsc_security.Delete_Bsc_Session;
950: bsc_locks_pub.REMOVE_SYSTEM_LOCK;
951: IF (g_retcode = 0) THEN
952: logProgress('ALL', 'Completed GenerateActualization');
953: Wrapup;
954: logProgress('ALL', 'Completed Wrapup, retcode='||g_retcode);

Line 981: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (-200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);

977: BEGIN
978: l_logging_flag := g_log;
979: g_log := false;
980: FND_MSG_PUB.Initialize;
981: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (-200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
982: IF (gGAA_RUN_MODE = 0) THEN -- whole system
983: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock entire system ', fnd_log.level_statement, true);
984: BSC_LOCKS_PUB.GET_SYSTEM_LOCK ('OBJECTIVE', 'W', sysdate, -200,
985: BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);

Line 984: BSC_LOCKS_PUB.GET_SYSTEM_LOCK ('OBJECTIVE', 'W', sysdate, -200,

980: FND_MSG_PUB.Initialize;
981: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (-200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
982: IF (gGAA_RUN_MODE = 0) THEN -- whole system
983: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock entire system ', fnd_log.level_statement, true);
984: BSC_LOCKS_PUB.GET_SYSTEM_LOCK ('OBJECTIVE', 'W', sysdate, -200,
985: BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
986: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
987: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||
988: x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);

Line 998: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (

994: ELSE--selected or inter-related
995: FOR i IN (select indicator from bsc_tmp_opt_ui_kpis where process_id = g_processID) LOOP
996: logProgress('LOCK', 'Locking '||i.indicator);
997: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock objective '||i.indicator, fnd_log.level_statement, true);
998: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (
999: i.indicator, 'OBJECTIVE', 'W', sysdate, -200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
1000: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
1001: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||
1002: x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);

Line 1041: bsc_locks_pub.remove_system_lock;

1037: logProgress('ALL', 'Failed to Generate Database, user_defined error:'||sqlerrm);
1038: retcode := g_retcode;
1039: errbuf := g_errbuf;
1040: --bsc_security.Delete_Bsc_Session;
1041: bsc_locks_pub.remove_system_lock;
1042: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1043: fnd_file.release_names(g_filename||'.log', g_filename||'.OUT');
1044: when others then -- general failure, dump the stack
1045: logProgress('ALL', 'Failed to Generate Database, general failure, dumping stack');

Line 1049: bsc_locks_pub.remove_system_lock;

1045: logProgress('ALL', 'Failed to Generate Database, general failure, dumping stack');
1046: retcode := g_retcode;
1047: errbuf := g_errbuf;
1048: --bsc_security.Delete_Bsc_Session;
1049: bsc_locks_pub.remove_system_lock;
1050: bsc_mo_helper_pkg.writeTmp('EXCEPTION in run_metadata_optimizer : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1051: bsc_mo_helper_pkg.writeTmp('gTables is ', FND_LOG.LEVEL_UNEXPECTED, true);
1052: bsc_mo_helper_pkg.write_this(gTables, FND_LOG.LEVEL_ERROR, true);
1053: bsc_mo_helper_pkg.dump_stack;

Line 1070: BSC_LOCKS_PUB.GET_SYSTEM_LOCK(-201,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);

1066: -- modified call to include user_id so that session management module can recognise the
1067: -- session lock #bug 3593694
1068: --bsc_security.Check_System_Lock(-201,NULL,BSC_APPS.apps_user_id);
1069: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock for documentation ', fnd_log.level_statement, true);
1070: BSC_LOCKS_PUB.GET_SYSTEM_LOCK(-201,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);
1071: IF (x_return_status<> FND_API.G_RET_STS_SUCCESS) THEN
1072: bsc_mo_helper_pkg.writeTmp('EXCEPTION while trying to Lock in Initialize : '||x_msg_data, FND_LOG.LEVEL_UNEXPECTED, true);
1073: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);
1074: fnd_message.set_name('BSC', 'BSC_MUSERS_LOCKED_SYSTEM');

Line 1081: bsc_locks_pub.remove_system_lock;

1077: END IF;
1078:
1079: BSC_MO_DOC_PKG.Documentation(2);
1080: -- bsc_security.Delete_Bsc_Session;
1081: bsc_locks_pub.remove_system_lock;
1082: EXCEPTION WHEN OTHERS THEN
1083: --bsc_security.Delete_Bsc_Session;
1084: bsc_locks_pub.remove_system_lock;
1085: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Documentation : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

Line 1084: bsc_locks_pub.remove_system_lock;

1080: -- bsc_security.Delete_Bsc_Session;
1081: bsc_locks_pub.remove_system_lock;
1082: EXCEPTION WHEN OTHERS THEN
1083: --bsc_security.Delete_Bsc_Session;
1084: bsc_locks_pub.remove_system_lock;
1085: bsc_mo_helper_pkg.writeTmp('EXCEPTION in Documentation : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1086: raise;
1087: END;
1088: END BSC_METADATA_OPTIMIZER_PKG;