[Home] [Help]
2218: IS
2219: cnt number:=0;
2220: trnid VARCHAR2(4000):='';
2221: BEGIN
2222: For rec IN (select a.session_id from csm_html5_upload_data a, csm_html5_sync_info c
2223: where a.status<>'PARSED' and a.session_id=c.session_id
2224: and c.useR_name=p_user_name order by session_id asc)
2225: loop
2226: CSM_HTML5_PKG.HTML5_PARSE_XML(rec.SESSION_ID,x_return_status,x_error_message);
2227: IF x_return_status=FND_API.G_RET_STS_ERROR THEN
2228: cnt:=cnt+1;
2229: trnid:=rec.session_id;
2230: CSM_UTIL_PKG.LOG( 'Exception while parsing upload data in tran_id:'||rec.session_id||' for user:'||p_user_name||' with error:'||substr(x_error_message,1,1000),'CSM_HTML5_PKG.query_parse_upload', FND_LOG.LEVEL_PROCEDURE);
2231: UPDATE CSM_HTML5_UPLOAD_DATA
2232: SET LAST_UPDATE_DATE = SYSDATE,
2233: LAST_UPDATED_BY = 1,
2234: STATUS = 'PARSE_ERROR',
2235: COMMENTS = x_error_message
2314: IF p_seq_data IS NOT NULL THEN
2315: process_sequences(p_user_name,p_seq_data);
2316: END IF;
2317:
2318: INSERT INTO CSM_HTML5_UPLOAD_DATA(SESSION_ID,STATUS,COMMENTS,UPLOADED_PAYLOAD,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
2319: VALUES(l_session_id,'RECEIVED','Sync successfully dumped the data',p_sync_data,l_user_id,SYSDATE,l_user_id,SYSDATE);
2320:
2321: --Bug 16456574
2322: CSM_HTML5_PKG.HTML5_PARSE_XML(l_session_id,l_ret,l_err);
2322: CSM_HTML5_PKG.HTML5_PARSE_XML(l_session_id,l_ret,l_err);
2323: IF l_ret=FND_API.G_RET_STS_ERROR THEN
2324: CSM_UTIL_PKG.LOG( 'Exception while parsing upload data in tran_id:'||l_session_id||' for user:'||p_user_name
2325: ||' with error:'||substr(l_err,1,1000),'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2326: UPDATE CSM_HTML5_UPLOAD_DATA
2327: SET LAST_UPDATE_DATE = SYSDATE,
2328: LAST_UPDATED_BY = 1,
2329: STATUS = 'PARSE_ERROR',
2330: COMMENTS = l_err
2670:
2671: CURSOR c_get_sync_data(sync_id NUMBER)
2672: IS
2673: SELECT UPLOADED_PAYLOAD
2674: FROM CSM_HTML5_UPLOAD_DATA
2675: WHERE SESSION_ID = sync_id
2676: AND STATUS<>'PARSED';
2677:
2678: CURSOR c_get_sync_uname(sync_id NUMBER)
2844: END;
2845: l_seq:=l_seq+1;
2846: END LOOP;
2847:
2848: UPDATE CSM_HTML5_UPLOAD_DATA
2849: SET LAST_UPDATE_DATE = SYSDATE,
2850: LAST_UPDATED_BY = 1,
2851: STATUS = 'PARSED',
2852: COMMENTS = 'Uploaded Data Parsed Successfully'
3253: AND a.sequence=b.sequence); --reject record requires the data if deferred
3254: END LOOP;
3255: END IF;
3256:
3257: DELETE FROM CSM_HTML5_UPLOAD_DATA b
3258: WHERE SESSION_ID <= g_current_tranid
3259: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_PARSED_DATA a WHERE a.SESSION_ID=b.SESSION_ID);
3260: END purge_pubitems;
3261:
3576: IS
3577: l_uname VARCHAR2(500):=NULL;
3578: l_list VARCHAR2(4000):=NULL;
3579: BEGIN
3580: FOR rec IN (select a.session_id,c.user_name from csm_html5_upload_data a,asg_user b, csm_html5_sync_info c
3581: where a.status<>'PARSED' and a.session_id=c.session_id
3582: and nvl(fnd_profile.value_specific('ASG_SYNCHRONOUS_UPLOAD',b.user_id,b.responsibility_id,b.app_id),'N')='N'
3583: and b.user_name=c.user_name and b.multi_platform='Y' and b.enabled='Y' ORDER BY c.USER_NAME,a.SESSION_ID ASC)
3584: LOOP
3586: CSM_HTML5_PKG.HTML5_PARSE_XML(rec.SESSION_ID,RETCODE,errbuf);
3587: IF RETCODE=FND_API.G_RET_STS_ERROR THEN
3588: CSM_UTIL_PKG.LOG( 'Exception while parsing upload data in tran_id:'||rec.session_id||' for user:'||rec.USER_NAME||' with error:'||substr(errbuf,1,1000), 'CSM_HTML5_PKG.CONC_PROCESS_UPLOAD',FND_LOG.LEVEL_EXCEPTION);
3589:
3590: UPDATE CSM_HTML5_UPLOAD_DATA
3591: SET LAST_UPDATE_DATE = SYSDATE,
3592: LAST_UPDATED_BY = 1,
3593: STATUS = 'PARSE_ERROR',
3594: COMMENTS = errbuf