DBA Data[Home] [Help]

APPS.MTH_EVENT_GEN_PKG dependencies on MTH_UTIL_PKG

Line 386: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT start', mth_util_pkg.G_DBG_PROC_FUN_START);

382: l_sql_stmt VARCHAR2(1000);
383: l_ret_code NUMBER;
384: BEGIN
385: l_ret_code := 0;
386: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT start', mth_util_pkg.G_DBG_PROC_FUN_START);
387: p_ret_code := l_ret_code;
388: -- Initialize default parameters
389: v_log_to_date := sysdate;
390: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 390: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

386: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT start', mth_util_pkg.G_DBG_PROC_FUN_START);
387: p_ret_code := l_ret_code;
388: -- Initialize default parameters
389: v_log_to_date := sysdate;
390: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
391:
392: IF p_mode = 'INIT' THEN
393: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INITIAL',NULL,0,v_log_to_date);
394:

Line 393: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INITIAL',NULL,0,v_log_to_date);

389: v_log_to_date := sysdate;
390: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
391:
392: IF p_mode = 'INIT' THEN
393: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INITIAL',NULL,0,v_log_to_date);
394:
395: ELSE
396: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
397:

Line 396: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

392: IF p_mode = 'INIT' THEN
393: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INITIAL',NULL,0,v_log_to_date);
394:
395: ELSE
396: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
397:
398: END IF;
399: -- Call mth_run_log_pre_load
400: --mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,NULL,NULL,0,v_log_to_date);

Line 400: --mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,NULL,NULL,0,v_log_to_date);

396: mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
397:
398: END IF;
399: -- Call mth_run_log_pre_load
400: --mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,NULL,NULL,0,v_log_to_date);
401:
402: -- Call GET_RUN_LOG_DATES
403: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EVENT_RULE_TABLES',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
404:

Line 403: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EVENT_RULE_TABLES',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

399: -- Call mth_run_log_pre_load
400: --mth_util_pkg.mth_run_log_pre_load('MTH_EVENT_RULE_TABLES',v_unassigned_val,NULL,NULL,0,v_log_to_date);
401:
402: -- Call GET_RUN_LOG_DATES
403: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EVENT_RULE_TABLES',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
404:
405: MTH_GEN_EQP_DOWN_W_RZ_EVENT(v_log_from_date);
406: MTH_GEN_EQP_IDLE_PRD_EVENT (v_log_from_date) ;
407: MTH_GEN_EQP_DWN_PRD_EVENT (v_log_from_date);

Line 422: mth_util_pkg.log_msg('Exception while calling custom hook - ' || v_desc, mth_util_pkg.G_DBG_EXCEPTION);

418: EXECUTE IMMEDIATE l_sql_stmt;
419: END IF;
420: EXCEPTION
421: WHEN OTHERS THEN
422: mth_util_pkg.log_msg('Exception while calling custom hook - ' || v_desc, mth_util_pkg.G_DBG_EXCEPTION);
423: END;
424: END IF;
425:
426: mth_util_pkg.mth_run_log_post_load('MTH_EVENT_RULE_TABLES',v_unassigned_val);

Line 426: mth_util_pkg.mth_run_log_post_load('MTH_EVENT_RULE_TABLES',v_unassigned_val);

422: mth_util_pkg.log_msg('Exception while calling custom hook - ' || v_desc, mth_util_pkg.G_DBG_EXCEPTION);
423: END;
424: END IF;
425:
426: mth_util_pkg.mth_run_log_post_load('MTH_EVENT_RULE_TABLES',v_unassigned_val);
427: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT end', mth_util_pkg.G_DBG_PROC_FUN_END);
428: EXCEPTION
429: WHEN OTHERS THEN
430: l_ret_code := 2;

Line 427: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT end', mth_util_pkg.G_DBG_PROC_FUN_END);

423: END;
424: END IF;
425:
426: mth_util_pkg.mth_run_log_post_load('MTH_EVENT_RULE_TABLES',v_unassigned_val);
427: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT end', mth_util_pkg.G_DBG_PROC_FUN_END);
428: EXCEPTION
429: WHEN OTHERS THEN
430: l_ret_code := 2;
431: mth_util_pkg.log_msg('Exception OTHERS in GEN_HDL_EVENTS_FROM_STS_OUTPUT', mth_util_pkg.G_DBG_EXCEPTION);

Line 431: mth_util_pkg.log_msg('Exception OTHERS in GEN_HDL_EVENTS_FROM_STS_OUTPUT', mth_util_pkg.G_DBG_EXCEPTION);

427: mth_util_pkg.log_msg('GEN_HDL_EVENTS_FROM_STS_OUTPUT end', mth_util_pkg.G_DBG_PROC_FUN_END);
428: EXCEPTION
429: WHEN OTHERS THEN
430: l_ret_code := 2;
431: mth_util_pkg.log_msg('Exception OTHERS in GEN_HDL_EVENTS_FROM_STS_OUTPUT', mth_util_pkg.G_DBG_EXCEPTION);
432: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
433: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
434: RAISE;
435: END MTH_GEN_HDL_EVTS_FROM_STS_OUT ;

Line 432: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

428: EXCEPTION
429: WHEN OTHERS THEN
430: l_ret_code := 2;
431: mth_util_pkg.log_msg('Exception OTHERS in GEN_HDL_EVENTS_FROM_STS_OUTPUT', mth_util_pkg.G_DBG_EXCEPTION);
432: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
433: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
434: RAISE;
435: END MTH_GEN_HDL_EVTS_FROM_STS_OUT ;
436: END MTH_EVENT_GEN_PKG;

Line 433: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

429: WHEN OTHERS THEN
430: l_ret_code := 2;
431: mth_util_pkg.log_msg('Exception OTHERS in GEN_HDL_EVENTS_FROM_STS_OUTPUT', mth_util_pkg.G_DBG_EXCEPTION);
432: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
433: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
434: RAISE;
435: END MTH_GEN_HDL_EVTS_FROM_STS_OUT ;
436: END MTH_EVENT_GEN_PKG;