APPS.GL_ENT_FUNC_BAL_UPGRADE_PKG dependencies on AD_CONC_UTILS_PKG

Line 944: -- AD_CONC_UTILS_PKG.submit_subrequests sets request data

940: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
941: g_api || '.' || fn_name,
942: 'x_num_workers = ' || x_num_workers);
943:
944: -- AD_CONC_UTILS_PKG.submit_subrequests sets request data
945: l_req_data := FND_CONC_GLOBAL.request_data;
946:
947: IF (l_req_data IS NULL) THEN -- First time
948: -- if the balances upgrade were done, no need to submit requests

Line 993: AD_CONC_UTILS_PKG.submit_subrequests(

989: g_table_name,
990: g_script_name);
991:
992: -- Submit child requests to upgrade balances
993: AD_CONC_UTILS_PKG.submit_subrequests(
994: X_errbuf => x_errbuf,
995: X_retcode => x_retcode,
996: X_workerconc_app_shortname => 'SQLGL',
997: X_workerconc_progname => 'GLEFBAL',

Line 1014: x_retcode := AD_CONC_UTILS_PKG.CONC_WARNING;

1010: ELSE
1011: GL_MESSAGE.WRITE_LOG(msg_name => 'EFCB0001',
1012: log_level => FND_LOG.LEVEL_PROCEDURE,
1013: module => g_api || '.' || fn_name);
1014: x_retcode := AD_CONC_UTILS_PKG.CONC_WARNING;
1015: END IF;
1016:
1017: ELSE -- Restart case
1018: -- check status of all subrequests (including the move/merge one, since

Line 1024: AD_CONC_UTILS_PKG.submit_subrequests(

1020: -- * If we want to produce an execution report, it may be more effecient
1021: -- not to use the API since that would mean we are getting
1022: -- sub-requests and loop through them twice.
1023:
1024: AD_CONC_UTILS_PKG.submit_subrequests(
1025: X_errbuf => x_errbuf,
1026: X_retcode => x_retcode,
1027: -- for restart, the rest of the parameters are not really used
1028: X_workerconc_app_shortname => 'SQLGL',

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

1030: X_batch_size => x_batch_size,
1031: X_num_workers => x_num_workers - 1,
1032: X_argument4 => l_gl_schema);
1033:
1034: IF (x_retcode = AD_CONC_UTILS_PKG.CONC_SUCCESS) THEN
1035: UPDATE GL_SYSTEM_USAGES
1036: SET efb_upgrade_flag = 'Y',
1037: last_update_date = sysdate,
1038: last_updated_by = 1,

Line 1047: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

1043: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
1044: g_api || '.' || fn_name);
1045: EXCEPTION
1046: WHEN SUBMIT_REQ_ERROR THEN
1047: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1048: GL_MESSAGE.WRITE_LOG(msg_name => 'SHRD0055',
1049: token_num => 1,
1050: t1 => 'ROUTINE',
1051: v1 => fn_name,

Line 1058: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

1054: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
1055: g_api || '.' || fn_name);
1056: RAISE;
1057: WHEN OTHERS THEN
1058: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1059: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1060: g_api || '.' || fn_name,
1061: SUBSTR(SQLERRM, 1, 4000));
1062: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

Line 1148: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

1144: FALSE);
1145:
1146: end loop;
1147:
1148: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1149:
1150: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
1151: g_api || '.' || fn_name);
1152: EXCEPTION

Line 1155: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

1151: g_api || '.' || fn_name);
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: x_errbuf := SUBSTR(SQLERRM, 1, 240);
1155: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1156: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1157: g_api || '.' || fn_name,
1158: SUBSTR(SQLERRM, 1, 4000));
1159: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

Line 1248: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;

1244: FND_CONCURRENT.AF_COMMIT;
1245: END LOOP;
1246: END LOOP;
1247:
1248: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
1249:
1250: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
1251: g_api || '.' || fn_name);
1252: EXCEPTION

Line 1255: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;

1251: g_api || '.' || fn_name);
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_errbuf := SUBSTR(SQLERRM, 1, 240);
1255: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
1256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
1257: g_api || '.' || fn_name,
1258: SUBSTR(SQLERRM, 1, 4000));
1259: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,