APPS.JTM_MASTER_CONC_PROG_PUB dependencies on JTM_MESSAGE_LOG_PKG

Line 80: JTM_MESSAGE_LOG_PKG.log_msg(

76: retcode := 0;
77: errbuf := 'OK';
78: l_proc_start := sysdate;
79:
80: JTM_MESSAGE_LOG_PKG.log_msg(
81: v_object_id => L_API_NAME,
82: v_object_name => G_PKG_NAME,
83: v_message => 'Category = ' || Category_Type,
84: v_level_id => JTM_HOOK_UTIL_PKG.g_debug_level_sql,

Line 106: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

102: || ' with argument = ' || Category_Type;
103: return;
104: END IF;
105:
106: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
107: (v_package_name => G_PKG_NAME
108: ,v_procedure_name => L_API_NAME
109: ,v_con_query_id => NULL
110: ,v_query_stmt => Category_Type

Line 120: RAISE JTM_MESSAGE_LOG_PKG.G_EXC_ERROR;

116: ,x_status => l_status
117: ,x_msg_data => l_message);
118:
119: IF (l_status = 'E') THEN
120: RAISE JTM_MESSAGE_LOG_PKG.G_EXC_ERROR;
121: END IF;
122:
123: FOR x_request IN X_TO_BE_RUN_REQUEST(Category_Type) LOOP
124: l_api_start := sysdate;

Line 131: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

127: l_full_procedure_name := x_request.PACKAGE_NAME || '.' ||
128: x_request.PROCEDURE_NAME;
129:
130: /* Add run time status into JTM concurrent prog log table */
131: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
132: (v_package_name => x_request.PACKAGE_NAME
133: ,v_procedure_name => x_request.PROCEDURE_NAME
134: ,v_con_query_id => NULL
135: ,v_query_stmt => Category_Type

Line 174: JTM_MESSAGE_LOG_PKG.log_msg(

170: || '. Assume all are fine.';
171: l_api_end := sysdate;
172: EXCEPTION
173: WHEN OTHERS THEN
174: JTM_MESSAGE_LOG_PKG.log_msg(
175: v_object_id => x_request.PROCEDURE_NAME,
176: v_object_name => x_request.PACKAGE_NAME,
177: v_message => 'Error ocurrs on execution',
178: v_level_id => JTM_HOOK_UTIL_PKG.g_debug_level_error,

Line 192: JTM_MESSAGE_LOG_PKG.log_msg(

188: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;
189: l_status_message := SQLERRM;
190: END;
191: ELSE
192: JTM_MESSAGE_LOG_PKG.log_msg(
193: v_object_id => x_request.PROCEDURE_NAME,
194: v_object_name => x_request.PACKAGE_NAME,
195: v_message => 'Error ocurrs on exection',
196: v_level_id => JTM_HOOK_UTIL_PKG.g_debug_level_error,

Line 219: JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG

215:
216: EXECUTE IMMEDIATE dynamic_stmt USING l_api_start, l_api_end,l_status_message,
217: l_api_status, x_request.PACKAGE_NAME,x_request.PROCEDURE_NAME;
218:
219: JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG
220: (v_log_id =>l_log_id
221: ,v_query_stmt => Category_Type
222: ,v_start_time => l_api_start
223: ,v_end_time => l_api_end

Line 239: JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG

235: end if;
236: if (errbuf = 'OK') then
237: errbuf := l_conc_message;
238: end if;
239: JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG
240: (v_log_id =>l_start_log_id
241: ,v_query_stmt => Category_Type
242: ,v_start_time => l_proc_start
243: ,v_end_time => sysdate

Line 251: JTM_MESSAGE_LOG_PKG.log_msg(

247: ,x_msg_data => l_message);
248:
249: Exception
250: When others then
251: JTM_MESSAGE_LOG_PKG.log_msg(
252: v_object_id => L_API_NAME,
253: v_object_name => G_PKG_NAME,
254: v_message => 'Exception occurs.',
255: v_level_id => JTM_HOOK_UTIL_PKG.g_debug_level_error,

Line 261: JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG

257:
258: errbuf := 'Exception in '||G_PKG_NAME ||'.'|| L_API_NAME ||': '||sqlerrm;
259: retcode := -1;
260:
261: JTM_MESSAGE_LOG_PKG.UPDATE_CONC_STATUS_LOG
262: (v_log_id =>l_start_log_id
263: ,v_query_stmt => Category_Type
264: ,v_start_time => l_proc_start
265: ,v_end_time => sysdate