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_DIM dependencies on BSC_MESSAGE

Line 342: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),

338: RETURN TRUE;
339:
340: EXCEPTION
341: WHEN e_unexpected_error THEN
342: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
343: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');
344: RETURN FALSE;
345:
346: WHEN OTHERS THEN

Line 347: BSC_MESSAGE.Add(x_message => SQLERRM,

343: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');
344: RETURN FALSE;
345:
346: WHEN OTHERS THEN
347: BSC_MESSAGE.Add(x_message => SQLERRM,
348: x_source => 'BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables');
349: RETURN FALSE;
350: END Create_AW_Dim_Temp_Tables;
351:

Line 502: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),

498: RETURN TRUE;
499:
500: EXCEPTION
501: WHEN e_unexpected_error THEN
502: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
503: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');
504: RETURN FALSE;
505:
506: WHEN OTHERS THEN

Line 507: BSC_MESSAGE.Add(x_message => SQLERRM,

503: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');
504: RETURN FALSE;
505:
506: WHEN OTHERS THEN
507: BSC_MESSAGE.Add(x_message => SQLERRM,
508: x_source => 'BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables');
509: RETURN FALSE;
510: END Create_Dbi_Dim_Temp_Tables;
511:

Line 709: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMREC_DELETE_FAILED'),

705: RETURN TRUE;
706:
707: EXCEPTION
708: WHEN e_unexpected_error THEN
709: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMREC_DELETE_FAILED'),
710: x_source => 'BSC_UPDATE_BASE.Delete_Codes_Cascade');
711: RETURN FALSE;
712:
713: WHEN OTHERS THEN

Line 714: BSC_MESSAGE.Add(x_message => SQLERRM,

710: x_source => 'BSC_UPDATE_BASE.Delete_Codes_Cascade');
711: RETURN FALSE;
712:
713: WHEN OTHERS THEN
714: BSC_MESSAGE.Add(x_message => SQLERRM,
715: x_source => 'BSC_UPDATE_DIM.Delete_Codes_Cascade');
716: RETURN FALSE;
717:
718: END Delete_Codes_Cascade;

Line 813: BSC_MESSAGE.Add(x_message => SQLERRM,

809: RETURN TRUE;
810:
811: EXCEPTION
812: WHEN OTHERS THEN
813: BSC_MESSAGE.Add(x_message => SQLERRM,
814: x_source => 'BSC_UPDATE_DIM.Delete_Codes_CascadeMN');
815: RETURN FALSE;
816:
817: END Delete_Codes_CascadeMN;

Line 887: BSC_MESSAGE.Add(x_message => SQLERRM,

883: RETURN TRUE;
884:
885: EXCEPTION
886: WHEN OTHERS THEN
887: BSC_MESSAGE.Add(x_message => SQLERRM,
888: x_source => 'BSC_UPDATE_DIM.Delete_Key_Values_In_Tables');
889: RETURN FALSE;
890:
891: END Delete_Key_Values_In_Tables;

Line 1042: BSC_MESSAGE.Add(x_message => SQLERRM,

1038: RETURN TRUE;
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: BSC_MESSAGE.Add(x_message => SQLERRM,
1043: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Vbh_Cat');
1044: RETURN FALSE;
1045: END Denorm_Eni_Item_Vbh_Cat;
1046:

Line 1223: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),

1219: RETURN TRUE;
1220:
1221: EXCEPTION
1222: WHEN e_unexpected_error THEN
1223: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
1224: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');
1225: RETURN FALSE;
1226:
1227: WHEN OTHERS THEN

Line 1228: BSC_MESSAGE.Add(x_message => SQLERRM,

1224: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');
1225: RETURN FALSE;
1226:
1227: WHEN OTHERS THEN
1228: BSC_MESSAGE.Add(x_message => SQLERRM,
1229: x_source => 'BSC_UPDATE_DIM.Denorm_Eni_Item_Itm_Cat');
1230: RETURN FALSE;
1231: END Denorm_Eni_Item_Itm_Cat;
1232:

Line 1355: BSC_MESSAGE.Add(x_message => SQLERRM,

1351: RETURN TRUE;
1352:
1353: EXCEPTION
1354: WHEN OTHERS THEN
1355: BSC_MESSAGE.Add(x_message => SQLERRM,
1356: x_source => 'BSC_UPDATE_DIM.Denorm_Hri_Per_Usrdr_H');
1357: RETURN FALSE;
1358: END Denorm_Hri_Per_Usrdr_H;
1359:

Line 1530: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),

1526: RETURN TRUE;
1527:
1528: EXCEPTION
1529: WHEN e_unexpected_error THEN
1530: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
1531: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');
1532: RETURN FALSE;
1533:
1534: WHEN OTHERS THEN

Line 1535: BSC_MESSAGE.Add(x_message => SQLERRM,

1531: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');
1532: RETURN FALSE;
1533:
1534: WHEN OTHERS THEN
1535: BSC_MESSAGE.Add(x_message => SQLERRM,
1536: x_source => 'BSC_UPDATE_DIM.Denorm_Pji_Organizations');
1537: RETURN FALSE;
1538: END Denorm_Pji_Organizations;
1539:

Line 1901: BSC_MESSAGE.Add(x_message => SQLERRM,

1897: RETURN TRUE;
1898:
1899: EXCEPTION
1900: WHEN OTHERS THEN
1901: BSC_MESSAGE.Add(x_message => SQLERRM,
1902: x_source => 'BSC_UPDATE_DIM.Get_Dbi_Dims_Kpis');
1903: RETURN FALSE;
1904:
1905: END Get_Dbi_Dims_Kpis;

Line 2150: BSC_MESSAGE.Add(x_message => SQLERRM,

2146: RETURN h_new_code;
2147:
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: BSC_MESSAGE.Add(x_message => SQLERRM,
2151: x_source => 'BSC_UPDATE_BASE.Get_New_Code');
2152: RETURN -1;
2153:
2154: END Get_New_Code;

Line 3311: BSC_MESSAGE.Add(x_message => l_sql,

3307:
3308: RETURN TRUE;
3309: EXCEPTION
3310: WHEN OTHERS THEN
3311: BSC_MESSAGE.Add(x_message => l_sql,
3312: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3313: BSC_MESSAGE.Add(x_message => SQLERRM,
3314: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3315: RETURN FALSE;

Line 3313: BSC_MESSAGE.Add(x_message => SQLERRM,

3309: EXCEPTION
3310: WHEN OTHERS THEN
3311: BSC_MESSAGE.Add(x_message => l_sql,
3312: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3313: BSC_MESSAGE.Add(x_message => SQLERRM,
3314: x_source => 'BSC_UPDATE_DIM.Insert_Children_Denorm_Table');
3315: RETURN FALSE;
3316:
3317: END Insert_Children_Denorm_Table;

Line 3777: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATE_FAILED'),

3773:
3774: EXCEPTION
3775: WHEN e_unexpected_error THEN
3776: ROLLBACK;
3777: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATE_FAILED'),
3778: x_source => 'BSC_UPDATE_BASE.Load_Dim_Table');
3779: RETURN FALSE;
3780:
3781: WHEN OTHERS THEN

Line 3783: BSC_MESSAGE.Add(x_message => SQLERRM,

3779: RETURN FALSE;
3780:
3781: WHEN OTHERS THEN
3782: ROLLBACK;
3783: BSC_MESSAGE.Add(x_message => SQLERRM,
3784: x_source => 'BSC_UPDATE_BASE.Load_Dim_Table');
3785: RETURN FALSE;
3786:
3787: END Load_Dim_Table;

Line 4246: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),

4242: RETURN TRUE;
4243:
4244: EXCEPTION
4245: WHEN e_unexpected_error THEN
4246: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR'),
4247: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');
4248: RETURN FALSE;
4249:
4250: WHEN OTHERS THEN

Line 4251: BSC_MESSAGE.Add(x_message => SQLERRM,

4247: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');
4248: RETURN FALSE;
4249:
4250: WHEN OTHERS THEN
4251: BSC_MESSAGE.Add(x_message => SQLERRM,
4252: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table');
4253: RETURN FALSE;
4254:
4255: END Refresh_Dbi_Dimension_Table;

Line 4291: BSC_MESSAGE.Init('NO');

4287: -- Initialize BSC/APPS global variables
4288: BSC_APPS.Init_Bsc_Apps;
4289:
4290: -- Initialize the error message stack
4291: BSC_MESSAGE.Init('NO');
4292:
4293: --LOCKING: Lock the dimension
4294: IF NOT BSC_UPDATE_LOCK.Lock_DBI_Dimension(x_dim_short_name) THEN
4295: RAISE e_could_not_get_lock;

Line 4309: BSC_MESSAGE.flush;

4305: COMMIT;
4306:
4307: EXCEPTION
4308: WHEN e_unexpected_error THEN
4309: BSC_MESSAGE.flush;
4310: COMMIT;
4311:
4312: BSC_UPDATE_LOG.Write_Errors_To_Log;
4313:

Line 4319: BSC_MESSAGE.flush;

4315: RETCODE := 2; -- Request completed with errors
4316:
4317: --LOCKING
4318: WHEN e_could_not_get_lock THEN
4319: BSC_MESSAGE.flush;
4320: COMMIT;
4321:
4322: BSC_UPDATE_LOG.Write_Errors_To_Log;
4323:

Line 4330: BSC_MESSAGE.flush;

4326:
4327: WHEN OTHERS THEN
4328: ROLLBACK;
4329:
4330: BSC_MESSAGE.flush;
4331: BSC_MESSAGE.Add(x_message => SQLERRM,
4332: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension',
4333: x_mode => 'I');
4334: COMMIT;

Line 4331: BSC_MESSAGE.Add(x_message => SQLERRM,

4327: WHEN OTHERS THEN
4328: ROLLBACK;
4329:
4330: BSC_MESSAGE.flush;
4331: BSC_MESSAGE.Add(x_message => SQLERRM,
4332: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension',
4333: x_mode => 'I');
4334: COMMIT;
4335:

Line 4523: BSC_MESSAGE.Add(x_message => SQLERRM,

4519: RETURN TRUE;
4520:
4521: EXCEPTION
4522: WHEN OTHERS THEN
4523: BSC_MESSAGE.Add(x_message => SQLERRM,
4524: x_source => 'BSC_UPDATE_DIM.Refresh_Denorm_Table');
4525: RETURN FALSE;
4526: END Refresh_Denorm_Table;
4527:

Line 4704: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_DIM_FAILED'),

4700: RETURN TRUE;
4701:
4702: EXCEPTION
4703: WHEN e_unexpected_error THEN
4704: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_DIM_FAILED'),
4705: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');
4706: RETURN FALSE;
4707:
4708: WHEN OTHERS THEN

Line 4709: BSC_MESSAGE.Add(x_message => SQLERRM,

4705: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');
4706: RETURN FALSE;
4707:
4708: WHEN OTHERS THEN
4709: BSC_MESSAGE.Add(x_message => SQLERRM,
4710: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimension');
4711: RETURN FALSE;
4712: END Refresh_EDW_Dimension;
4713:

Line 4790: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_DIM_FAILED'),

4786: RETURN TRUE;
4787:
4788: EXCEPTION
4789: WHEN e_unexpected_error THEN
4790: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_DIM_FAILED'),
4791: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');
4792: RETURN FALSE;
4793:
4794: WHEN OTHERS THEN

Line 4795: BSC_MESSAGE.Add(x_message => SQLERRM,

4791: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');
4792: RETURN FALSE;
4793:
4794: WHEN OTHERS THEN
4795: BSC_MESSAGE.Add(x_message => SQLERRM,
4796: x_source => 'BSC_UPDATE_DIM.Refresh_EDW_Dimensions');
4797: RETURN FALSE;
4798:
4799: END Refresh_EDW_Dimensions;

Line 4868: BSC_MESSAGE.Add(x_message => SQLERRM,

4864: RETURN TRUE;
4865:
4866: EXCEPTION
4867: WHEN OTHERS THEN
4868: BSC_MESSAGE.Add(x_message => SQLERRM,
4869: x_source => 'BSC_UPDATE_DIM.Sync_Sec_Assigments');
4870: RETURN FALSE;
4871:
4872: END Sync_Sec_Assigments;

Line 5073: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ITABLE_VALID_FAILED'),

5069: RETURN NOT h_invalid;
5070:
5071: EXCEPTION
5072: WHEN e_unexpected_error THEN
5073: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ITABLE_VALID_FAILED'),
5074: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');
5075: RETURN NULL;
5076:
5077: WHEN OTHERS THEN

Line 5078: BSC_MESSAGE.Add(x_message => SQLERRM,

5074: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');
5075: RETURN NULL;
5076:
5077: WHEN OTHERS THEN
5078: BSC_MESSAGE.Add(x_message => SQLERRM,
5079: x_source => 'BSC_UPDATE_DIM.Validate_Input_Table');
5080: RETURN NULL;
5081: END Validate_Input_Table;
5082:

Line 5184: BSC_MESSAGE.Add(x_message => SQLERRM,

5180: RETURN TRUE;
5181:
5182: EXCEPTION
5183: WHEN OTHERS THEN
5184: BSC_MESSAGE.Add(x_message => SQLERRM,
5185: x_source => 'BSC_UPDATE_DIM.WriteRemovedKeyItems');
5186: RETURN FALSE;
5187:
5188: END WriteRemovedKeyItems;