DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on DBMS_UTILITY

Line 383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error in WRITE_ERROR_SUMM_LOG: '||dbms_utility.format_error_stack );

379: END IF;
380:
381: EXCEPTION
382: when others then
383: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error in WRITE_ERROR_SUMM_LOG: '||dbms_utility.format_error_stack );
384:
385: END;
386:
387: --

Line 1786: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'CREATE_INDEXES: '||dbms_utility.format_error_stack );

1782: END IF;
1783:
1784: EXCEPTION
1785: when others then
1786: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'CREATE_INDEXES: '||dbms_utility.format_error_stack );
1787: END CREATE_INDEXES;
1788:
1789: -- ===== DROP_INDEXES================
1790: PROCEDURE DROP_INDEXES IS

Line 52916: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

52912:
52913: EXCEPTION
52914:
52915: WHEN EX_PIPE_RCV THEN
52916: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
52917:
52918: ROLLBACK;
52919:
52920: FND_MESSAGE.SET_NAME('MSC', 'MSC_MSG_RCV_FAIL');

Line 52936: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

52932: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
52933: END IF;
52934:
52935: WHEN EX_PIPE_SND THEN
52936: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
52937:
52938: ROLLBACK;
52939:
52940: FND_MESSAGE.SET_NAME('MSC', 'MSC_MSG_SEND_FAIL');

Line 52956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

52952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
52953: END IF;
52954:
52955: WHEN EX_PROCESS_TIME_OUT THEN
52956: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
52957:
52958: ROLLBACK;
52959:
52960: FND_MESSAGE.SET_NAME('MSC', 'MSC_TIMEOUT');

Line 52975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

52971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,FND_MESSAGE.GET);
52972: END IF;
52973:
52974: WHEN OTHERS THEN
52975: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
52976: ROLLBACK;
52977:
52978: ERRBUF := SQLERRM;
52979: RETCODE := G_ERROR;

Line 53574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

53570:
53571: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_LAUNCH_WORKER_FAIL');
53572: ERRBUF:= FND_MESSAGE.GET;
53573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,ERRBUF);
53574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
53575: RETCODE := G_ERROR;
53576:
53577: COMMIT;
53578: RETURN;

Line 54578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

54574:
54575: EXCEPTION -- LAUNCH_MONITOR
54576:
54577: WHEN EX_PIPE_RCV THEN
54578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
54579: ROLLBACK;
54580:
54581: IF lv_check_point> 1 THEN
54582: IF SET_ST_STATUS( ERRBUF, RETCODE, p_instance_id, G_ST_READY) THEN

Line 54604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

54600:
54601: COMMIT;
54602:
54603: WHEN EX_PIPE_SND THEN
54604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
54605: ROLLBACK;
54606:
54607: IF lv_check_point> 1 THEN
54608: IF SET_ST_STATUS( ERRBUF, RETCODE, p_instance_id, G_ST_READY) THEN

Line 54629: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

54625:
54626: COMMIT;
54627:
54628: WHEN EX_PROCESS_TIME_OUT THEN
54629: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
54630: ROLLBACK;
54631:
54632: IF lv_check_point> 1 THEN
54633: IF SET_ST_STATUS( ERRBUF, RETCODE, p_instance_id, G_ST_READY) THEN

Line 54654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);

54650: COMMIT;
54651:
54652:
54653: WHEN others THEN
54654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,dbms_utility.format_error_stack);
54655: ROLLBACK;
54656:
54657: IF lv_check_point> 1 THEN
54658: IF SET_ST_STATUS( ERRBUF, RETCODE, p_instance_id, G_ST_READY) THEN