DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on BSC_MESSAGE

Line 228: BSC_MESSAGE.Add(x_message => 'Deleted measure: ' || l_arr_short_name(i) || ' : Successfully',

224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: BEGIN
228: BSC_MESSAGE.Add(x_message => 'Deleted measure: ' || l_arr_short_name(i) || ' : Successfully',
229: x_source => 'BSCUPGRB.delete_bsc_measures_from_pmf',
230: x_mode => 'I');
231: EXCEPTION
232: WHEN OTHERS THEN

Line 242: BSC_MESSAGE.Add(x_message => 'Could not delete measure: ' || l_err,

238: l_err := l_arr_short_name(i) ;
239: IF (l_error_tbl.COUNT > 0) THEN
240: l_err := l_err || ' : ' || l_error_tbl(1).Error_Description;
241: END IF;
242: BSC_MESSAGE.Add(x_message => 'Could not delete measure: ' || l_err,
243: x_source => 'BSCUPGRB.delete_bsc_measures_from_pmf',
244: x_mode => 'I');
245: END;
246: END LOOP;

Line 256: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,

252: IF(c_s2e_kpis%ISOPEN) THEN
253: CLOSE c_s2e_kpis;
254: END IF;
255: l_err := SQLERRM;
256: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,
257: x_source => 'BSCUPGRB.delete_bsc_measures_from_pmf',
258: x_mode => 'I');
259: END delete_bsc_measures_from_pmf;
260: --

Line 358: BSC_MESSAGE.Add (

354: );
355: END IF;
356: EXCEPTION
357: WHEN OTHERS THEN
358: BSC_MESSAGE.Add (
359: x_message => SQLERRM || ' - ERROR ADDING COL : ' || l_Measure_Col
360: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'
361: , x_mode => 'I'
362: );

Line 383: BSC_MESSAGE.Add(x_message => 'Synchronized measure: ' || icr.measure_short_name || ' : ' || 'Successfully',

379: WHERE indicator_id = icr.measure_id;
380: END IF;
381:
382: BEGIN
383: BSC_MESSAGE.Add(x_message => 'Synchronized measure: ' || icr.measure_short_name || ' : ' || 'Successfully',
384: x_source => 'BSCUPGRB.sync_measures_pmf_to_bsc',
385: x_mode => 'I');
386: EXCEPTION
387: WHEN OTHERS THEN

Line 408: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),

404: END LOOP;
405:
406: BEGIN
407: FOR i IN 1..l_num LOOP
408: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),
409: x_source => 'BSCUPGRB.sync_measures_pmf_to_bsc',
410: x_mode => 'I');
411: END LOOP;
412: EXCEPTION

Line 421: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,

417: COMMIT;
418: EXCEPTION
419: WHEN OTHERS THEN
420: l_err := SQLERRM;
421: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,
422: x_source => 'BSCUPGRB.sync_measures_pmf_to_bsc',
423: x_mode => 'I');
424: END sync_measures_pmf_to_bsc;
425: --

Line 498: BSC_MESSAGE.Add(x_message => 'Synchronized measure: ' || l_measure_rec.Measure_short_name || ' : ' || 'Successfully',

494: SET short_name = l_measure_rec.Measure_Short_Name
495: WHERE measure_id = cr.measure_id;
496:
497: BEGIN
498: BSC_MESSAGE.Add(x_message => 'Synchronized measure: ' || l_measure_rec.Measure_short_name || ' : ' || 'Successfully',
499: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf_51',
500: x_mode => 'I');
501: EXCEPTION
502: WHEN OTHERS THEN

Line 521: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),

517: END LOOP;
518:
519: BEGIN
520: FOR i IN 1..l_num LOOP
521: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),
522: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf_51',
523: x_mode => 'I');
524: END LOOP;
525: EXCEPTION

Line 534: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,

530: COMMIT;
531: EXCEPTION
532: WHEN OTHERS THEN
533: l_err := SQLERRM;
534: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,
535: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf_51',
536: x_mode => 'I');
537: END sync_measures_bsc_to_pmf_51;
538:

Line 594: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),

590: END LOOP;
591: --LOG THE Measures which were failed
592: BEGIN
593: FOR i IN 1..l_num LOOP
594: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),
595: x_source => 'BSCUPGRB.synch_measures_cds_to_pmf',
596: x_mode => 'I');
597: END LOOP;
598: EXCEPTION

Line 608: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,

604: COMMIT;
605: EXCEPTION
606: WHEN OTHERS THEN
607: l_err := SQLERRM;
608: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,
609: x_source => 'BSCUPGRB.synch_measures_cds_to_pmf',
610: x_mode => 'I');
611:
612: END synch_measures_cds_to_pmf;

Line 704: BSC_MESSAGE.Add(x_message => 'Custom KPI: ' || cr.Short_Name || ' : ' || 'Failed to get PMF Metadata',

700: -- enable to report
701: l_measure_rec.Enable_Link := 'Y';
702: EXCEPTION
703: WHEN OTHERS THEN
704: BSC_MESSAGE.Add(x_message => 'Custom KPI: ' || cr.Short_Name || ' : ' || 'Failed to get PMF Metadata',
705: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf',
706: x_mode => 'I');
707: END;
708: END IF;

Line 727: BSC_MESSAGE.Add(x_message => 'Synchronized measure: ' || cr.Short_Name || ' : ' || 'Successfully',

723: WHERE measure_id = cr.measure_id;
724: END IF;
725:
726: BEGIN
727: BSC_MESSAGE.Add(x_message => 'Synchronized measure: ' || cr.Short_Name || ' : ' || 'Successfully',
728: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf',
729: x_mode => 'I');
730: EXCEPTION
731: WHEN OTHERS THEN

Line 750: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),

746: END LOOP;
747:
748: BEGIN
749: FOR i IN 1..l_num LOOP
750: BSC_MESSAGE.Add(x_message => 'Failed measure: ' || l_arr_short_name(i),
751: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf',
752: x_mode => 'I');
753: END LOOP;
754: EXCEPTION

Line 763: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,

759: COMMIT;
760: EXCEPTION
761: WHEN OTHERS THEN
762: l_err := SQLERRM;
763: BSC_MESSAGE.Add(x_message => 'Failed: ' || l_err,
764: x_source => 'BSCUPGRB.sync_measures_bsc_to_pmf',
765: x_mode => 'I');
766: END sync_measures_bsc_to_pmf;
767: --

Line 831: BSC_MESSAGE.Add (

827: COMMIT;
828: EXCEPTION
829: WHEN OTHERS THEN
830: ROLLBACK TO SP_UPDATE_SHORT_NAME;
831: BSC_MESSAGE.Add (
832: x_message => SQLERRM
833: , x_source => 'Update short names in bsc_sys_measures'
834: , x_mode => 'I'
835: );

Line 2647: BSC_MESSAGE.Add (

2643: --x_error_msg := SQLERRM;
2644: IF (l_Msg_Data IS NULL) THEN
2645: l_Msg_Data := SQLERRM;
2646: END IF;
2647: BSC_MESSAGE.Add (
2648: x_message => l_Msg_Data
2649: , x_source => 'Refresh_Measure_Col_Names'
2650: , x_mode => 'I'
2651: );

Line 2708: BSC_MESSAGE.Add (

2704: , x_Help => cPMFM.MEASURE_COL
2705: );
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: BSC_MESSAGE.Add (
2709: x_message => SQLERRM || ' - ERROR ADDING COL : ' || cPMFM.MEASURE_COL
2710: , x_source => 'BSC_DB_MEASURE_COLS_PKG.INSERT_ROW'
2711: , x_mode => 'I'
2712: );

Line 2723: BSC_MESSAGE.Add (

2719: ROLLBACK TO SP_GEN_EXISTING;
2720: IF (l_Msg_Data IS NULL) THEN
2721: l_Msg_Data := SQLERRM;
2722: END IF;
2723: BSC_MESSAGE.Add (
2724: x_message => l_Msg_Data
2725: , x_source => 'Gen_Existing_Measure_Cols'
2726: , x_mode => 'I'
2727: );