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_MESSAGE

Line 233: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

229: dual
230: );
231: EXCEPTION
232: WHEN h_undefined_user THEN
233: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
234: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
235:
236: WHEN h_login_expired THEN
237: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

Line 234: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

230: );
231: EXCEPTION
232: WHEN h_undefined_user THEN
233: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
234: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
235:
236: WHEN h_login_expired THEN
237: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
238: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

Line 237: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

233: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
234: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
235:
236: WHEN h_login_expired THEN
237: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
238: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
239:
240: WHEN h_undefined_obsc_user THEN
241: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

Line 238: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

234: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
235:
236: WHEN h_login_expired THEN
237: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
238: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
239:
240: WHEN h_undefined_obsc_user THEN
241: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
242: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

Line 241: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

237: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
238: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
239:
240: WHEN h_undefined_obsc_user THEN
241: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
242: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
243:
244: WHEN h_undefined_ubsc_user THEN
245: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

Line 242: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

238: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
239:
240: WHEN h_undefined_obsc_user THEN
241: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
242: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
243:
244: WHEN h_undefined_ubsc_user THEN
245: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
246: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

Line 245: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');

241: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
242: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
243:
244: WHEN h_undefined_ubsc_user THEN
245: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
246: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
247:
248: WHEN OTHERS THEN
249: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');

Line 246: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');

242: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
243:
244: WHEN h_undefined_ubsc_user THEN
245: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
246: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
247:
248: WHEN OTHERS THEN
249: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');
250: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');

Line 249: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');

245: bsc_message.add('ERROR-', x_calling_fn, APP_ERR_MSG, 'I');
246: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
247:
248: WHEN OTHERS THEN
249: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');
250: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');
251:
252: END get_user_info;
253:

Line 250: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');

246: bsc_message.add(h_message, h_current_fn, APP_ERR_MSG, 'I');
247:
248: WHEN OTHERS THEN
249: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');
250: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');
251:
252: END get_user_info;
253:
254: --

Line 309: FROM bsc_message_logs

305: h_current_fn);
306:
307: SELECT COUNT(*)
308: INTO h_count
309: FROM bsc_message_logs
310: WHERE
311: type IN (DB_ERR_MSG, APP_ERR_MSG)
312: AND source = h_current_fn
313: AND Last_Update_Login = h_session_id;

Line 346: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');

342:
343: EXCEPTION
344: WHEN OTHERS THEN
345: x_status := FALSE;
346: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');
347: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');
348:
349: END get_user_info;
350:

Line 347: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');

343: EXCEPTION
344: WHEN OTHERS THEN
345: x_status := FALSE;
346: bsc_message.add('ERROR-', x_calling_fn, DB_ERR_MSG, 'I');
347: bsc_message.add(SQLERRM, h_current_fn, DB_ERR_MSG, 'I');
348:
349: END get_user_info;
350:
351:

Line 430: BSC_MESSAGE.Init(X_Debug_Flag => x_debug_flag);

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

Line 454: -- Clean BSC_MESSAGE_LOGS for the current session

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;
457: commit;
458:

Line 455: DELETE bsc_message_logs

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;
457: commit;
458:
459: BSC_SECURITY.Refresh_System_Lock(x_program_id);

Line 716: BSC_MESSAGE.Add(

712: COMMIT;
713:
714: Exception
715: WHEN BSC_Lock_Error THEN
716: BSC_MESSAGE.Add(
717: X_Message => l_message,
718: X_Source => l_calling_fn,
719: X_Mode => 'I');
720:

Line 722: BSC_MESSAGE.Add(

718: X_Source => l_calling_fn,
719: X_Mode => 'I');
720:
721: WHEN Others THEN
722: BSC_MESSAGE.Add(
723: X_Message => SQLERRM,
724: X_Source => l_calling_fn,
725: X_Mode => 'I');
726:

Line 857: BSC_MESSAGE.Init(X_Debug_Flag => X_Debug_Flag);

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

Line 904: -- Clean BSC_MESSAGE_LOGS for the current session

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;
907: commit;
908:

Line 905: DELETE bsc_message_logs

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;
907: commit;
908:
909: -- Clean BSC_CURRENT_SESSIONS in the source system to leave only current sessions

Line 971: BSC_MESSAGE.Add(

967: COMMIT;
968:
969: Exception
970: WHEN BSC_Lock_Error THEN
971: BSC_MESSAGE.Add(
972: X_Message => l_message,
973: X_Source => l_calling_fn,
974: X_Mode => 'I');
975:

Line 977: BSC_MESSAGE.Add(

973: X_Source => l_calling_fn,
974: X_Mode => 'I');
975:
976: WHEN Others THEN
977: BSC_MESSAGE.Add(
978: X_Message => SQLERRM,
979: X_Source => l_calling_fn,
980: X_Mode => 'I');
981:

Line 1008: BSC_MESSAGE.Add(

1004: COMMIT;
1005:
1006: Exception
1007: WHEN BSC_Lock_Error THEN
1008: BSC_MESSAGE.Add(
1009: X_Message => l_message,
1010: X_Source => l_calling_fn,
1011: X_Mode => 'I');
1012:

Line 1014: BSC_MESSAGE.Add(

1010: X_Source => l_calling_fn,
1011: X_Mode => 'I');
1012:
1013: WHEN Others THEN
1014: BSC_MESSAGE.Add(
1015: X_Message => SQLERRM,
1016: X_Source => l_calling_fn,
1017: X_Mode => 'I');
1018:

Line 1051: BSC_MESSAGE.Add(

1047: END IF;
1048:
1049: EXCEPTION
1050: WHEN BSC_Lock_Error THEN
1051: BSC_MESSAGE.Add(
1052: X_Message => l_message,
1053: X_Source => l_calling_fn,
1054: X_Mode => 'I');
1055:

Line 1057: BSC_MESSAGE.Add(

1053: X_Source => l_calling_fn,
1054: X_Mode => 'I');
1055:
1056: WHEN Others THEN
1057: BSC_MESSAGE.Add(
1058: X_Message => SQLERRM,
1059: X_Source => l_calling_fn,
1060: X_Mode => 'I');
1061: