DBA Data[Home] [Help]

APPS.CZ_MODEL_CONVERT dependencies on CZ_DB_LOGS

Line 66: --procedure to log debug messages to conc request output file / cz_db_logs

62: next_id_to_use NUMBER := 0;
63: CZ_SEQUENCE_INCREMENT number :=20;
64:
65:
66: --procedure to log debug messages to conc request output file / cz_db_logs
67: PROCEDURE log_msg(p_caller IN VARCHAR2, p_ndebug IN NUMBER, p_msg IN VARCHAR2, p_level IN NUMBER) IS
68: l_msg varchar2(2000):=NULL;
69: l_api_name constant VARCHAR2(30) := 'log_msg';
70: BEGIN

Line 81: --procedure to log messages to cz_db_logs for use by the model conversion xml publisher report

77: log_msg(l_api_name, v_ndebug, l_msg, fnd_log.level_unexpected);
78: RAISE;
79: END log_msg;
80:
81: --procedure to log messages to cz_db_logs for use by the model conversion xml publisher report
82: PROCEDURE displayMessage(p_urgency In NUMBER,p_model_id IN NUMBER, p_object_type IN VARCHAR2 ,p_object_id IN NUMBER
83: ,p_caller IN VARCHAR2,msg VARCHAR2
84: ,token1 IN VARCHAR2 DEFAULT NULL, value1 IN VARCHAR2 DEFAULT NULL
85: ,token2 IN VARCHAR2 DEFAULT NULL, value2 IN VARCHAR2 DEFAULT NULL

Line 107: INSERT INTO CZ_DB_LOGS (LOGTIME, LOGUSER, URGENCY, CALLER , MESSAGE, MODEL_ID , OBJECT_TYPE ,OBJECT_ID,MODEL_CONVERSION_SET_ID,ELEMENT_ID,ELEMENT_TYPE)

103: END IF;
104: END IF;
105: END IF;
106:
107: INSERT INTO CZ_DB_LOGS (LOGTIME, LOGUSER, URGENCY, CALLER , MESSAGE, MODEL_ID , OBJECT_TYPE ,OBJECT_ID,MODEL_CONVERSION_SET_ID,ELEMENT_ID,ELEMENT_TYPE)
108: VALUES(SYSDATE, USER , p_urgency, p_caller, l_msg , p_model_id , p_object_type ,p_object_id,v_model_conversion_set_id,p_element_id,p_element_type);
109:
110: END IF;
111: /*log_msg(p_caller , v_ndebug, l_msg, 1 );*/