APPS.BSC_UTILITY dependencies on BSC_MESSAGE

Line 220: BSC_MESSAGE.add(x_message => l_debug_msg,

216: Begin
217: IF debug_flag THEN
218: l_debug_msg := x_calling_fn || ': ' || x_debug_msg;
219:
220: BSC_MESSAGE.add(x_message => l_debug_msg,
221: x_source => x_calling_fn,
222: x_type => 4,
223: x_mode => x_mode
224: );

Line 279: BSC_MESSAGE.add(

275: END IF;
276:
277: EXCEPTION
278: WHEN OTHERS THEN
279: BSC_MESSAGE.add(
280: x_message => sqlerrm,
281: x_source => 'BSC_UTILITY.Close_Cursor'
282: );
283:

Line 311: BSC_MESSAGE.add(x_message => sqlerrm,

307:
308: Exception
309: When Others Then
310:
311: BSC_MESSAGE.add(x_message => sqlerrm,
312: x_source => x_calling_fn,
313: x_type => 0,
314: x_mode => 'I'
315: );

Line 335: -- Insert error messages into bsc_message_logs table.

331:
332: -- Rollback uncommitted transactions.
333: rollback;
334:
335: -- Insert error messages into bsc_message_logs table.
336: bsc_message.flush;
337:
338: -- commit rows in bsc_message_logs table.
339: -- commit work;

Line 336: bsc_message.flush;

332: -- Rollback uncommitted transactions.
333: rollback;
334:
335: -- Insert error messages into bsc_message_logs table.
336: bsc_message.flush;
337:
338: -- commit rows in bsc_message_logs table.
339: -- commit work;
340:

Line 338: -- commit rows in bsc_message_logs table.

334:
335: -- Insert error messages into bsc_message_logs table.
336: bsc_message.flush;
337:
338: -- commit rows in bsc_message_logs table.
339: -- commit work;
340:
341: End Do_Rollback;
342:

Line 411: bsc_message.add(

407: --dbms_output.put_line('EDW_TIME_M synonym created');
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: bsc_message.add(
412: x_message => 'create_synonym_for_edw_time_m: '||SQLERRM,
413: x_source => l_call_proc,
414: x_mode => 'I' );
415:

Line 566: bsc_message.add(

562: END IF;
563:
564: EXCEPTION
565: WHEN OTHERS THEN
566: bsc_message.add(
567: x_message => l_message,
568: x_source => l_call_proc,
569: x_type => 1,
570: x_mode => 'I' );

Line 645: bsc_message.add(

641: l_message := 'Error: '||l_edw_obj_name||' view not found.';
642:
643: --dbms_output.put_line(l_message);
644:
645: bsc_message.add(
646: x_message => 'update_edw_flag(ENABLE): '||l_message,
647: x_source => l_call_proc,
648: x_type => 1,
649: x_mode => 'I' );

Line 671: bsc_message.add(

667: WHEN NO_DATA_FOUND THEN
668:
669: l_message := 'Warning: No dimensions exist.';
670:
671: bsc_message.add(
672: x_message => 'update_edw_flag(ENABLE): '||l_message,
673: x_source => l_call_proc,
674: x_type => 1,
675: x_mode => 'I' );

Line 705: bsc_message.add(

701: l_message := 'Error: '||l_bsc_obj_name||' view not found.';
702:
703: --dbms_output.put_line(l_message);
704:
705: bsc_message.add(
706: x_message => 'update_edw_flag(ENABLE): '||l_message,
707: x_source => l_call_proc,
708: x_type => 1,
709: x_mode => 'I' );

Line 729: bsc_message.add(

725: WHEN OTHERS THEN
726:
727: --dbms_output.put_line(SQLERRM);
728:
729: bsc_message.add(
730: x_message => 'update_edw_flag(ENABLE): '||SQLERRM,
731: x_source => l_call_proc,
732: x_type => 1,
733: x_mode => 'I' );

Line 774: bsc_message.add(

770: WHEN OTHERS THEN
771:
772: --dbms_output.put_line(SQLERRM);
773:
774: bsc_message.add(
775: x_message => 'update_edw_flag(DISABLE): '||SQLERRM,
776: x_source => l_call_proc,
777: x_type => 1,
778: x_mode => 'I' );

Line 802: bsc_message.add(

798: WHEN OTHERS THEN
799:
800: --dbms_output.put_line(SQLERRM);
801:
802: bsc_message.add(
803: x_message => 'update_edw_flag(ENABLE): '||SQLERRM,
804: x_source => l_call_proc,
805: x_type => 1,
806: x_mode => 'I' );

Line 816: bsc_message.add(

812: l_message := BSC_UPDATE_UTIL.Get_Message('BSC_EDW_DISABLE');
813:
814: --dbms_output.put_line(l_message);
815:
816: bsc_message.add(
817: x_message => l_message,
818: x_source => l_call_proc,
819: x_type => 0,
820: x_mode => 'I' );

Line 832: bsc_message.add(

828: l_message := 'ERROR: Invalid mode ('||h_mode||') passed.';
829:
830: --dbms_output.put_line(l_message);
831:
832: bsc_message.add(
833: x_message => 'update_edw_flag(): '||l_message,
834: x_source => l_call_proc,
835: x_mode => 'I' );
836:

Line 844: bsc_message.add(

840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: --dbms_output.put_line(SQLERRM);
844: bsc_message.add(
845: x_message => 'update_edw_flag: '||SQLERRM,
846: x_source => l_call_proc,
847: x_mode => 'I' );
848:

Line 1028: from BSC_MESSAGE_LOGS

1024: from dual;
1025:
1026: select count(message)
1027: into l_count
1028: from BSC_MESSAGE_LOGS
1029: where type = 0
1030: and upper(source) = 'BSC_SECURITY.CHECK_SYSTEM_LOCK'
1031: and last_update_login = l_session_id;
1032:

Line 1038: from BSC_MESSAGE_LOGS

1034: return 'N';
1035: else
1036: select message
1037: into l_message
1038: from BSC_MESSAGE_LOGS
1039: where type = 0
1040: and upper(source) = 'BSC_SECURITY.CHECK_SYSTEM_LOCK'
1041: and last_update_login = l_session_id;
1042: