DBA Data[Home] [Help]

APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_APPS

Line 797: bsc_apps.init_bsc_apps;

793: PROCEDURE Setup IS
794: l_error VARCHAR2(4000);
795: BEGIN
796:
797: bsc_apps.init_bsc_apps;
798: g_bsc_apps_initialized := true;
799: bsc_apps.Init_Big_In_Cond_Table;
800: logProgress('INIT', 'Starting Setup');
801: g_dir := null;

Line 798: g_bsc_apps_initialized := true;

794: l_error VARCHAR2(4000);
795: BEGIN
796:
797: bsc_apps.init_bsc_apps;
798: g_bsc_apps_initialized := true;
799: bsc_apps.Init_Big_In_Cond_Table;
800: logProgress('INIT', 'Starting Setup');
801: g_dir := null;
802: g_dir:=fnd_profile.value('UTL_FILE_LOG');

Line 799: bsc_apps.Init_Big_In_Cond_Table;

795: BEGIN
796:
797: bsc_apps.init_bsc_apps;
798: g_bsc_apps_initialized := true;
799: bsc_apps.Init_Big_In_Cond_Table;
800: logProgress('INIT', 'Starting Setup');
801: g_dir := null;
802: g_dir:=fnd_profile.value('UTL_FILE_LOG');
803: IF g_dir is null THEN

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 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 985: BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);

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);
989: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);

Line 999: i.indicator, 'OBJECTIVE', 'W', sysdate, -200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);

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);
1003: bsc_mo_helper_pkg.TerminateWithMsg(x_msg_data);

Line 1068: --bsc_security.Check_System_Lock(-201,NULL,BSC_APPS.apps_user_id);

1064: gBSCSchema := BSC_MO_HELPER_PKG.getBSCSchema;
1065: gApplsysSchema := BSC_MO_HELPER_PKG.getApplsysSchema;
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);

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');