APPS.GL_ADD_RECON_UPGRADE_PKG dependencies on AD_CONC_UTILS_PKG

Line 125: -- AD_CONC_UTILS_PKG.submit_subrequests sets request data

121: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
122: g_api || '.' || fn_name,
123: 'x_num_workers = ' || x_num_workers);
124: END IF;
125: -- AD_CONC_UTILS_PKG.submit_subrequests sets request data
126: l_req_data := FND_CONC_GLOBAL.request_data;
127: --
128: IF (l_req_data IS NULL) THEN -- First time
129: -- get schema name for GL and FND

Line 155: AD_CONC_UTILS_PKG.submit_subrequests(

151: g_table_name,
152: g_script_name);
153: --
154: -- Submit child requests to update gl_je_lines_recon
155: AD_CONC_UTILS_PKG.submit_subrequests(
156: X_errbuf => x_errbuf,
157: X_retcode => x_retcode,
158: X_workerconc_app_shortname => 'SQLGL',
159: X_workerconc_progname => 'GLRCNINS',

Line 178: AD_CONC_UTILS_PKG.submit_subrequests(

174: -- * If we want to produce an execution report, it may be more effecient
175: -- not to use the API since that would mean we are getting
176: -- sub-requests and loop through them twice.
177: --
178: AD_CONC_UTILS_PKG.submit_subrequests(
179: X_errbuf => x_errbuf,
180: X_retcode => x_retcode,
181: -- for restart, the rest of the parameters are not really used
182: X_workerconc_app_shortname => 'SQLGL',

Line 188: IF (x_retcode = AD_CONC_UTILS_PKG.CONC_SUCCESS) THEN

184: X_batch_size => x_batch_size,
185: X_num_workers => x_num_workers,
186: X_argument4 => l_gl_schema);
187: --
188: IF (x_retcode = AD_CONC_UTILS_PKG.CONC_SUCCESS) THEN
189: UPDATE GL_SYSTEM_USAGES
190: SET reconciliation_upg_flag = 'Y',
191: last_update_date = sysdate,
192: last_updated_by = 1,

Line 205: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

201: END IF;
202: --
203: EXCEPTION
204: WHEN SUBMIT_REQ_ERROR THEN
205: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
206: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
207: GL_MESSAGE.WRITE_LOG(msg_name => 'SHRD0055',
208: token_num => 1,
209: t1 => 'ROUTINE',

Line 218: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

214: g_api || '.' || fn_name);
215: END IF;
216: RAISE;
217: WHEN OTHERS THEN
218: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
220: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
221: g_api || '.' || fn_name,
222: SUBSTR(SQLERRM, 1, 4000));

Line 302: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

298: FALSE);
299: --
300: end loop;
301: --
302: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
304: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
305: g_api || '.' || fn_name);
306: END IF;

Line 310: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

306: END IF;
307: EXCEPTION
308: WHEN OTHERS THEN
309: x_errbuf := SUBSTR(SQLERRM, 1, 240);
310: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
312: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
313: g_api || '.' || fn_name,
314: SUBSTR(SQLERRM, 1, 4000));