APPS.JTM_MASTER_CONC_PROG_PUB dependencies on JTM_CON_QUERY_REQUEST_PKG

Line 149: IF (upper(l_api_status) = upper(JTM_CON_QUERY_REQUEST_PKG.G_ERROR) ) THEN

145: dynamic_stmt := 'BEGIN ' || l_full_procedure_name || '(:1,:2); END; ';
146: EXECUTE IMMEDIATE dynamic_stmt
147: using out l_api_status, out l_status_message;
148: l_api_end := sysdate;
149: IF (upper(l_api_status) = upper(JTM_CON_QUERY_REQUEST_PKG.G_ERROR) ) THEN
150: retcode := -1;
151: IF (l_conc_message = l_successful_msg) THEN
152: l_conc_message:= 'Error message from ' || l_full_procedure_name
153: || ': ' || l_status_message;

Line 168: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_FINE;

164: IF (sqlcode = -6537 OR sqlcode = -6550) THEN
165: BEGIN
166: dynamic_stmt := 'BEGIN ' || l_full_procedure_name || '; END; ';
167: EXECUTE IMMEDIATE dynamic_stmt;
168: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_FINE;
169: l_status_message := 'No message from '|| l_full_procedure_name
170: || '. Assume all are fine.';
171: l_api_end := sysdate;
172: EXCEPTION

Line 188: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;

184: end if;
185: retcode := -1;
186:
187: l_api_end := sysdate;
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(

Line 207: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;

203: end if;
204: retcode := -1;
205:
206: l_api_end := sysdate;
207: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;
208: l_status_message := SQLERRM;
209: END IF;
210: END;
211:

Line 232: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_FINE;

228:
229: END LOOP;
230:
231: if (retcode = 0) then
232: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_FINE;
233: else
234: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;
235: end if;
236: if (errbuf = 'OK') then

Line 234: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;

230:
231: if (retcode = 0) then
232: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_FINE;
233: else
234: l_api_status := JTM_CON_QUERY_REQUEST_PKG.G_ERROR;
235: end if;
236: if (errbuf = 'OK') then
237: errbuf := l_conc_message;
238: end if;

Line 266: ,v_status => JTM_CON_QUERY_REQUEST_PKG.G_ERROR

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
266: ,v_status => JTM_CON_QUERY_REQUEST_PKG.G_ERROR
267: ,v_message => errbuf
268: ,x_status => l_status
269: ,x_msg_data => l_message);
270: