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

Line 4048: BSC_LOCKS_PUB.Get_System_Lock (

4044: --IF h_count > 0 THEN
4045: -- RAISE e_system_lock;
4046: --END IF;
4047: --LOCKING: Call this api for backward compatibility
4048: BSC_LOCKS_PUB.Get_System_Lock (
4049: p_program_id => -101,
4050: p_user_id => BSC_APPS.apps_user_id,
4051: p_icx_session_id => null,
4052: x_return_status => h_return_status,

Line 4088: BSC_LOCKS_PUB.Remove_System_Lock;

4084: RAISE e_warning;
4085: END IF;
4086:
4087: -- LOCKING
4088: BSC_LOCKS_PUB.Remove_System_Lock;
4089:
4090: EXCEPTION
4091: WHEN e_system_lock THEN
4092: --LOCKING: h_msg_data has the error message

Line 4107: BSC_LOCKS_PUB.Remove_System_Lock;

4103: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4104: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4105:
4106: -- LOCKING
4107: BSC_LOCKS_PUB.Remove_System_Lock;
4108:
4109: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4110: RETCODE := 2; -- Request completed with errors
4111:

Line 4114: BSC_LOCKS_PUB.Remove_System_Lock;

4110: RETCODE := 2; -- Request completed with errors
4111:
4112: WHEN e_update_error THEN
4113: -- LOCKING
4114: BSC_LOCKS_PUB.Remove_System_Lock;
4115:
4116: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4117: RETCODE := 2; -- Request completed with errors
4118:

Line 4121: BSC_LOCKS_PUB.Remove_System_Lock;

4117: RETCODE := 2; -- Request completed with errors
4118:
4119: WHEN e_warning THEN
4120: -- LOCKING
4121: BSC_LOCKS_PUB.Remove_System_Lock;
4122:
4123: ERRBUF := '';
4124: RETCODE := 1; -- Request completed with warning
4125:

Line 4140: BSC_LOCKS_PUB.Remove_System_Lock;

4136: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4137: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4138:
4139: -- LOCKING
4140: BSC_LOCKS_PUB.Remove_System_Lock;
4141:
4142: ERRBUF := SQLERRM;
4143: RETCODE := 2; -- Request completed with errors
4144:

Line 4233: BSC_LOCKS_PUB.Get_System_Lock (

4229: --IF h_count > 0 THEN
4230: -- RAISE e_system_lock;
4231: --END IF;
4232: --LOCKING: Call this api for backward compatibility
4233: BSC_LOCKS_PUB.Get_System_Lock (
4234: p_program_id => -101,
4235: p_user_id => BSC_APPS.apps_user_id,
4236: p_icx_session_id => null,
4237: x_return_status => h_return_status,

Line 4270: BSC_LOCKS_PUB.Get_System_Lock (

4266: if RETCODE='2' or RETCODE=2 then
4267: raise e_update_error;
4268: end if;
4269: --LOCKING: lock again since Load_Indicators_Dims removed the lock
4270: BSC_LOCKS_PUB.Get_System_Lock (
4271: p_program_id => -101,
4272: p_user_id => BSC_APPS.apps_user_id,
4273: p_icx_session_id => null,
4274: x_return_status => h_return_status,

Line 4334: BSC_LOCKS_PUB.Remove_System_Lock;

4330: RAISE e_warning;
4331: END IF;
4332:
4333: -- LOCKING
4334: BSC_LOCKS_PUB.Remove_System_Lock;
4335:
4336: EXCEPTION
4337: WHEN e_system_lock THEN
4338: --LOCKING: h_msg_data has the error message

Line 4353: BSC_LOCKS_PUB.Remove_System_Lock;

4349: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4350: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4351:
4352: -- LOCKING
4353: BSC_LOCKS_PUB.Remove_System_Lock;
4354:
4355: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4356: RETCODE := 2; -- Request completed with errors
4357:

Line 4360: BSC_LOCKS_PUB.Remove_System_Lock;

4356: RETCODE := 2; -- Request completed with errors
4357:
4358: WHEN e_update_error THEN
4359: -- LOCKING
4360: BSC_LOCKS_PUB.Remove_System_Lock;
4361:
4362: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4363: RETCODE := 2; -- Request completed with errors
4364:

Line 4367: BSC_LOCKS_PUB.Remove_System_Lock;

4363: RETCODE := 2; -- Request completed with errors
4364:
4365: WHEN e_warning THEN
4366: -- LOCKING
4367: BSC_LOCKS_PUB.Remove_System_Lock;
4368:
4369: ERRBUF := '';
4370: RETCODE := 1; -- Request completed with warning
4371:

Line 4386: BSC_LOCKS_PUB.Remove_System_Lock;

4382: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4383: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4384:
4385: -- LOCKING
4386: BSC_LOCKS_PUB.Remove_System_Lock;
4387:
4388: ERRBUF := SQLERRM;
4389: RETCODE := 2; -- Request completed with errors
4390:

Line 4448: BSC_LOCKS_PUB.Get_System_Lock (

4444: --IF h_count > 0 THEN
4445: -- RAISE e_system_lock;
4446: --END IF;
4447: --LOCKING: Call this api for backward compatibility
4448: BSC_LOCKS_PUB.Get_System_Lock (
4449: p_program_id => -101,
4450: p_user_id => BSC_APPS.apps_user_id,
4451: p_icx_session_id => null,
4452: x_return_status => h_return_status,

Line 4506: BSC_LOCKS_PUB.Remove_System_Lock;

4502: RAISE e_warning;
4503: END IF;
4504:
4505: -- LOCKING
4506: BSC_LOCKS_PUB.Remove_System_Lock;
4507:
4508: EXCEPTION
4509: WHEN e_system_lock THEN
4510: --LOCKING: h_msg_data has the error message

Line 4525: BSC_LOCKS_PUB.Remove_System_Lock;

4521: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4522: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4523:
4524: -- LOCKING
4525: BSC_LOCKS_PUB.Remove_System_Lock;
4526:
4527: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4528: RETCODE := 2; -- Request completed with errors
4529:

Line 4532: BSC_LOCKS_PUB.Remove_System_Lock;

4528: RETCODE := 2; -- Request completed with errors
4529:
4530: WHEN e_update_error THEN
4531: -- LOCKING
4532: BSC_LOCKS_PUB.Remove_System_Lock;
4533:
4534: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4535: RETCODE := 2; -- Request completed with errors
4536:

Line 4539: BSC_LOCKS_PUB.Remove_System_Lock;

4535: RETCODE := 2; -- Request completed with errors
4536:
4537: WHEN e_warning THEN
4538: -- LOCKING
4539: BSC_LOCKS_PUB.Remove_System_Lock;
4540:
4541: ERRBUF := '';
4542: RETCODE := 1; -- Request completed with warning
4543:

Line 4558: BSC_LOCKS_PUB.Remove_System_Lock;

4554: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4555: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4556:
4557: -- LOCKING
4558: BSC_LOCKS_PUB.Remove_System_Lock;
4559:
4560: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4561: RETCODE := 2; -- Request completed with errors
4562:

Line 4626: BSC_LOCKS_PUB.Get_System_Lock (

4622: --IF h_count > 0 THEN
4623: -- RAISE e_system_lock;
4624: --END IF;
4625: --LOCKING: Call this api for backward compatibility
4626: BSC_LOCKS_PUB.Get_System_Lock (
4627: p_program_id => -101,
4628: p_user_id => BSC_APPS.apps_user_id,
4629: p_icx_session_id => null,
4630: x_return_status => h_return_status,

Line 4653: BSC_LOCKS_PUB.Remove_System_Lock;

4649: RAISE e_update_error;
4650: END IF;
4651:
4652: -- LOCKING
4653: BSC_LOCKS_PUB.Remove_System_Lock;
4654:
4655: EXCEPTION
4656: WHEN e_system_lock THEN
4657: --LOCKING: h_msg_data has the error message

Line 4672: BSC_LOCKS_PUB.Remove_System_Lock;

4668: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4669: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4670:
4671: -- LOCKING
4672: BSC_LOCKS_PUB.Remove_System_Lock;
4673:
4674: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4675: RETCODE := 2; -- Request completed with errors
4676:

Line 4679: BSC_LOCKS_PUB.Remove_System_Lock;

4675: RETCODE := 2; -- Request completed with errors
4676:
4677: WHEN e_update_error THEN
4678: -- LOCKING
4679: BSC_LOCKS_PUB.Remove_System_Lock;
4680:
4681: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4682: RETCODE := 2; -- Request completed with errors
4683:

Line 4698: BSC_LOCKS_PUB.Remove_System_Lock;

4694: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4695: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4696:
4697: -- LOCKING
4698: BSC_LOCKS_PUB.Remove_System_Lock;
4699:
4700: ERRBUF := SQLERRM;
4701: RETCODE := 2; -- Request completed with errors
4702:

Line 4807: BSC_LOCKS_PUB.Get_System_Lock (

4803: --IF h_count > 0 THEN
4804: -- RAISE e_system_lock;
4805: --END IF;
4806: --LOCKING: Call this api for backward compatibility
4807: BSC_LOCKS_PUB.Get_System_Lock (
4808: p_program_id => -101,
4809: p_user_id => BSC_APPS.apps_user_id,
4810: p_icx_session_id => null,
4811: x_return_status => h_return_status,

Line 4827: BSC_LOCKS_PUB.Remove_System_Lock;

4823:
4824: IF h_num_indicators = 0 THEN
4825: -- No indicators to be processed
4826: -- LOCKING
4827: BSC_LOCKS_PUB.Remove_System_Lock;
4828: RETURN;
4829: END IF;
4830:
4831: --Fix bug#3923207: import dbi plans was moved to execute_update_process

Line 4869: BSC_LOCKS_PUB.Remove_System_Lock;

4865:
4866: IF h_num_input_tables = 0 THEN
4867: -- No input tables to load
4868: -- LOCKING
4869: BSC_LOCKS_PUB.Remove_System_Lock;
4870: IF g_warning THEN
4871: ERRBUF := '';
4872: RETCODE := 1; -- Request completed with warning
4873: END IF;

Line 4933: BSC_LOCKS_PUB.Remove_System_Lock;

4929: RAISE e_warning;
4930: END IF;
4931:
4932: -- LOCKING
4933: BSC_LOCKS_PUB.Remove_System_Lock;
4934:
4935: EXCEPTION
4936: WHEN e_system_lock THEN
4937: --LOCKING: h_msg_data has the error message

Line 4952: BSC_LOCKS_PUB.Remove_System_Lock;

4948: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4949: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4950:
4951: -- LOCKING
4952: BSC_LOCKS_PUB.Remove_System_Lock;
4953:
4954: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4955: RETCODE := 2; -- Request completed with errors
4956:

Line 4959: BSC_LOCKS_PUB.Remove_System_Lock;

4955: RETCODE := 2; -- Request completed with errors
4956:
4957: WHEN e_update_error THEN
4958: -- LOCKING
4959: BSC_LOCKS_PUB.Remove_System_Lock;
4960:
4961: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
4962: RETCODE := 2; -- Request completed with errors
4963:

Line 4966: BSC_LOCKS_PUB.Remove_System_Lock;

4962: RETCODE := 2; -- Request completed with errors
4963:
4964: WHEN e_warning THEN
4965: -- LOCKING
4966: BSC_LOCKS_PUB.Remove_System_Lock;
4967:
4968: ERRBUF := '';
4969: RETCODE := 1; -- Request completed with warning
4970:

Line 4980: BSC_LOCKS_PUB.Remove_System_Lock;

4976: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4977: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
4978:
4979: -- LOCKING
4980: BSC_LOCKS_PUB.Remove_System_Lock;
4981:
4982: ERRBUF := SQLERRM;
4983: RETCODE := 2; -- Request completed with errors
4984:

Line 5002: BSC_LOCKS_PUB.Remove_System_Lock;

4998: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
4999: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5000:
5001: -- LOCKING
5002: BSC_LOCKS_PUB.Remove_System_Lock;
5003:
5004: ERRBUF := SQLERRM;
5005: RETCODE := 2; -- Request completed with errors
5006:

Line 5095: BSC_LOCKS_PUB.Get_System_Lock (

5091: --IF h_count > 0 THEN
5092: -- RAISE e_system_lock;
5093: --END IF;
5094: --LOCKING: Call this api for backward compatibility
5095: BSC_LOCKS_PUB.Get_System_Lock (
5096: p_program_id => -101,
5097: p_user_id => BSC_APPS.apps_user_id,
5098: p_icx_session_id => null,
5099: x_return_status => h_return_status,

Line 5115: BSC_LOCKS_PUB.Remove_System_Lock;

5111:
5112: IF h_num_indicators = 0 THEN
5113: -- No indicators to be processed
5114: -- LOCKING
5115: BSC_LOCKS_PUB.Remove_System_Lock;
5116: RETURN;
5117: END IF;
5118:
5119: if x_load_dim_affected_indicators is not null and x_load_dim_affected_indicators='Y' then

Line 5250: BSC_LOCKS_PUB.Remove_System_Lock;

5246: RAISE e_warning;
5247: END IF;
5248:
5249: -- LOCKING
5250: BSC_LOCKS_PUB.Remove_System_Lock;
5251:
5252: EXCEPTION
5253: WHEN e_system_lock THEN
5254: --LOCKING: h_msg_data has the error message

Line 5269: BSC_LOCKS_PUB.Remove_System_Lock;

5265: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5266: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5267:
5268: -- LOCKING
5269: BSC_LOCKS_PUB.Remove_System_Lock;
5270:
5271: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5272: RETCODE := 2; -- Request completed with errors
5273:

Line 5276: BSC_LOCKS_PUB.Remove_System_Lock;

5272: RETCODE := 2; -- Request completed with errors
5273:
5274: WHEN e_update_error THEN
5275: -- LOCKING
5276: BSC_LOCKS_PUB.Remove_System_Lock;
5277: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5278: RETCODE := 2; -- Request completed with errors
5279:
5280: WHEN e_warning THEN

Line 5282: BSC_LOCKS_PUB.Remove_System_Lock;

5278: RETCODE := 2; -- Request completed with errors
5279:
5280: WHEN e_warning THEN
5281: -- LOCKING
5282: BSC_LOCKS_PUB.Remove_System_Lock;
5283: ERRBUF := '';
5284: RETCODE := 1; -- Request completed with warning
5285:
5286: WHEN e_unexpected_error THEN

Line 5295: BSC_LOCKS_PUB.Remove_System_Lock;

5291: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5292: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5293:
5294: -- LOCKING
5295: BSC_LOCKS_PUB.Remove_System_Lock;
5296: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5297: RETCODE := 2; -- Request completed with errors
5298:
5299: WHEN OTHERS THEN

Line 5313: BSC_LOCKS_PUB.Remove_System_Lock;

5309: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5310: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5311:
5312: -- LOCKING
5313: BSC_LOCKS_PUB.Remove_System_Lock;
5314: ERRBUF := SQLERRM;
5315: RETCODE := 2; -- Request completed with errors
5316:
5317: END Load_Indicators_Dims;

Line 5385: BSC_LOCKS_PUB.Get_System_Lock (

5381: --IF h_count > 0 THEN
5382: -- RAISE e_system_lock;
5383: --END IF;
5384: --LOCKING: Call this api for backward compatibility
5385: BSC_LOCKS_PUB.Get_System_Lock (
5386: p_program_id => -101,
5387: p_user_id => BSC_APPS.apps_user_id,
5388: p_icx_session_id => null,
5389: x_return_status => h_return_status,

Line 5415: BSC_LOCKS_PUB.Remove_System_Lock;

5411:
5412: IF h_num_indicators = 0 THEN
5413: -- No indicators to be processed
5414: -- LOCKING
5415: BSC_LOCKS_PUB.Remove_System_Lock;
5416: RETURN;
5417: END IF;
5418:
5419: -- LOCKING: get the sequence next val here and then use it

Line 5455: BSC_LOCKS_PUB.Remove_System_Lock;

5451: RAISE e_update_error;
5452: END IF;
5453:
5454: -- LOCKING
5455: BSC_LOCKS_PUB.Remove_System_Lock;
5456:
5457: EXCEPTION
5458: WHEN e_system_lock THEN
5459: --LOCKING: h_msg_data has the error message

Line 5474: BSC_LOCKS_PUB.Remove_System_Lock;

5470: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5471: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5472:
5473: -- LOCKING
5474: BSC_LOCKS_PUB.Remove_System_Lock;
5475:
5476: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5477: RETCODE := 2; -- Request completed with errors
5478:

Line 5481: BSC_LOCKS_PUB.Remove_System_Lock;

5477: RETCODE := 2; -- Request completed with errors
5478:
5479: WHEN e_update_error THEN
5480: -- LOCKING
5481: BSC_LOCKS_PUB.Remove_System_Lock;
5482: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
5483: RETCODE := 2; -- Request completed with errors
5484:
5485: WHEN OTHERS THEN

Line 5499: BSC_LOCKS_PUB.Remove_System_Lock;

5495: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_UPDATE_LOG.OUTPUT);
5496: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_UPDATE_LOG.OUTPUT);
5497:
5498: -- LOCKING
5499: BSC_LOCKS_PUB.Remove_System_Lock;
5500:
5501: ERRBUF := SQLERRM;
5502: RETCODE := 2; -- Request completed with errors
5503: