eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_HTML5_PKG dependencies on FND_API

Line 845: x_return_status:=fnd_api.g_ret_sts_success;

841: l_stmt CLOB:=g_nl_chr;
842:
843: BEGIN
844:
845: x_return_status:=fnd_api.g_ret_sts_success;
846: x_error_message:='Success';
847:
848: l_stmt := l_stmt ||'function create_mfs_schema(){ '||g_nl_chr;
849:

Line 861: x_return_status := fnd_api.g_ret_sts_error;

857: l_stmt := l_stmt||'}'||g_nl_chr;
858: p_result:=l_stmt;
859: EXCEPTION
860: WHEN others THEN
861: x_return_status := fnd_api.g_ret_sts_error;
862: x_error_message := 'Exception occurred in query_get_schema_js: ' || substr(sqlerrm,0,2000);
863: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_get_schema_js', FND_LOG.LEVEL_PROCEDURE);
864: END query_get_schema_js;
865:

Line 880: x_return_status:=fnd_api.g_ret_sts_success;

876: l_blob BLOB:=empty_blob();
877:
878: BEGIN
879:
880: x_return_status:=fnd_api.g_ret_sts_success;
881: x_error_message:='Success';
882:
883: BEGIN
884: SELECT to_number(PRF_VALUE) into instId FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';

Line 899: IF (ret=fnd_api.g_ret_sts_success) THEN

895: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 5, NULL, 'REUSABLE_SCHEMA', l_id, l_ch, l_dt,NULL, instId, ret, m);
896:
897: CSM_UTIL_PKG.LOG('Instance Insert Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);
898:
899: IF (ret=fnd_api.g_ret_sts_success) THEN
900: query_get_schema_js(p_result,ret,m);
901:
902: IF (ret=fnd_api.g_ret_sts_success) THEN
903: l_blob:=clob_to_blob(p_result);

Line 902: IF (ret=fnd_api.g_ret_sts_success) THEN

898:
899: IF (ret=fnd_api.g_ret_sts_success) THEN
900: query_get_schema_js(p_result,ret,m);
901:
902: IF (ret=fnd_api.g_ret_sts_success) THEN
903: l_blob:=clob_to_blob(p_result);
904: INSERT INTO CSM_QUERY_RESULTS_ACC(ACCESS_ID , USER_ID , QUERY_ID , INSTANCE_ID , LINE_ID,
905: RESULT ,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY, LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
906: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, asg_base.get_user_id(p_user_name), 5, instId, 1,

Line 1036: x_return_status:=fnd_api.g_ret_sts_success;

1032: l_response VARCHAR2(200);
1033: l_str VARCHAR2(100);
1034: BEGIN
1035:
1036: x_return_status:=fnd_api.g_ret_sts_success;
1037: x_error_message:='Success';
1038:
1039: IF NOT isHTML5User(p_user_name) THEN
1040: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||' is not a HTML5 user', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);

Line 1141: x_return_status:=fnd_api.g_ret_sts_success;

1137: l_dummy boolean:=true;
1138: l_e NUMBER;l_d NUMBER;l_n NUMBER;
1139: l_base_object VARCHAR2(500);
1140: BEGIN
1141: x_return_status:=fnd_api.g_ret_sts_success;
1142: x_error_message:='Success';
1143:
1144: l_final := l_final ||'function mfs_synch_data(){ '||g_nl_chr;
1145:

Line 1175: IF(x_return_status = fnd_api.g_ret_sts_error) THEN

1171: REMOVE_DIRTY_CACHE;
1172:
1173: query_schema_js(p_user_name,l_stmt,x_return_status,x_error_message);
1174:
1175: IF(x_return_status = fnd_api.g_ret_sts_error) THEN
1176: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1177: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';
1178: END_SESSION(l_session_id,'ERROR',x_error_message);
1179: RETURN;

Line 1350: x_return_status := fnd_api.g_ret_sts_error;

1346: END IF;
1347:
1348: EXCEPTION
1349: WHEN others THEN
1350: x_return_status := fnd_api.g_ret_sts_error;
1351: x_error_message := 'Exception occurred in query_sync_data_js: ' || substr(sqlerrm,1,3900);
1352: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1353: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_6';
1354: END_SESSION(l_session_id,'ERROR',x_error_message);

Line 1559: x_return_status:=fnd_api.g_ret_sts_success;

1555: l_str VARCHAR2(100);
1556: l_more_avl BOOLEAN:=false;
1557: l_refresh_all BOOLEAN :=p_refresh_all;
1558: BEGIN
1559: x_return_status:=fnd_api.g_ret_sts_success;
1560: x_error_message:='Success';
1561:
1562: IF NOT isHTML5User(p_user_name) THEN
1563: CSM_UTIL_PKG.LOG('Quitting...since '||p_user_name||' is not an HTML5 user', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

Line 1913: x_return_status := fnd_api.g_ret_sts_error;

1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN others THEN
1913: x_return_status := fnd_api.g_ret_sts_error;
1914: x_error_message := 'Exception occurred in q_inc_sync_data_js: '||length(l_final)||'::'|| substr(sqlerrm,0,2000);
1915: CSM_UTIL_PKG.LOG( x_error_message,'CSM_HTML5_PKG.q_inc_sync_data_js',FND_LOG.LEVEL_PROCEDURE);
1916: IF l_refresh_all THEN
1917: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_9';

Line 2227: IF x_return_status=FND_API.G_RET_STS_ERROR THEN

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

Line 2250: x_return_status := fnd_api.g_ret_sts_success;

2246: ELSE
2247: p_result := 'sync.upload_complete(true,"s");';
2248: END_SESSION(p_session_id,'SUCCESS');
2249: END IF ;
2250: x_return_status := fnd_api.g_ret_sts_success;
2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: x_return_status := fnd_api.g_ret_sts_error;
2254: x_error_message := 'Exception occurred in query_parse_upload: ' || substr(sqlerrm,1,3900);

Line 2253: x_return_status := fnd_api.g_ret_sts_error;

2249: END IF ;
2250: x_return_status := fnd_api.g_ret_sts_success;
2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: x_return_status := fnd_api.g_ret_sts_error;
2254: x_error_message := 'Exception occurred in query_parse_upload: ' || substr(sqlerrm,1,3900);
2255: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_parse_upload', FND_LOG.LEVEL_PROCEDURE);
2256: p_result := 'handle_sync_exception("'||translateString(x_error_message)||'");';
2257: END_SESSION(p_session_id,'ERROR',x_error_message);

Line 2323: IF l_ret=FND_API.G_RET_STS_ERROR THEN

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);
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,

Line 2368: IF (ret=fnd_api.g_ret_sts_success) THEN

2364: l_id(2):=2; l_ch(2):=l_session_id;
2365:
2366: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 16, NULL, 'SYNCHRONOUS_UPLOAD', l_id, l_ch, l_dt,NULL, instId, ret, m);
2367:
2368: IF (ret=fnd_api.g_ret_sts_success) THEN
2369: CSM_UTIL_PKG.LOG('Created Instance -:'||instId, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2370:
2371: UPDATE csm_html5_sync_info SET Q_INSTANCE_ID=instId WHERE SESSION_ID=l_session_id;
2372:

Line 2599: IF (ret=fnd_api.g_ret_sts_success) THEN

2595: l_id(1):=1;
2596: l_ch(1):=p_user_name;
2597: CSM_QUERY_PKG.INSERT_INSTANCE(asg_base.get_user_id(p_user_name), 12, NULL, 'GENERATE_USER_DATA', l_id, l_ch, l_dt,NULL, instId, ret, m);
2598:
2599: IF (ret=fnd_api.g_ret_sts_success) THEN
2600: CSM_UTIL_PKG.LOG('Created Instance -:'||instId, 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);
2601: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 12, instId);
2602: IF req_id=0 THEN
2603: CSM_UTIL_PKG.LOG('Sorry, this user -'||p_user_name||' does not have the responsibility/request group to submit request', 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);

Line 2747: x_return_status := FND_API.G_RET_STS_ERROR;

2743: CLOSE c_get_sync_data;
2744:
2745: IF l_xml_clob_payload IS NULL THEN
2746: CSM_UTIL_PKG.LOG ( 'No data found in SYNC ID : ' || p_SYNC_ID, 'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_EXCEPTION);
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748: x_error_message := 'Either Synch has uploaded no Data Or Is already parsed' ;
2749: RETURN;
2750: END IF;
2751:

Line 2858: x_return_status := FND_API.G_RET_STS_SUCCESS;

2854:
2855: setup_inq_info(L_SYNC_USER_NAME,P_SYNC_ID,X_RETURN_STATUS);
2856: UPDATE asg_user SET hwm_tranid = P_SYNC_ID WHERE user_name = L_SYNC_USER_NAME;
2857:
2858: x_return_status := FND_API.G_RET_STS_SUCCESS;
2859: x_error_message := 'XML Parsing Successfully completed ';
2860: CSM_UTIL_PKG.LOG
2861: ( 'Leaving PARSE_XML for SYNC ID after successfully Executing : ' || p_SYNC_ID , 'CSM_HTML5_PKG.HTML5_PARSE_XML',
2862: FND_LOG.LEVEL_PROCEDURE);

Line 2874: x_return_status := FND_API.G_RET_STS_ERROR;

2870: /*** catch and log exceptions ***/
2871: CSM_UTIL_PKG.LOG
2872: ( 'Exception occurred in PARSE_XML for SYNC ID : ' || p_SYNC_ID || SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.HTML5_PARSE_XML',
2873: FND_LOG.LEVEL_EXCEPTION);
2874: x_return_status := FND_API.G_RET_STS_ERROR;
2875: X_ERROR_MESSAGE := 'XML Retrieve Failed With Message : ' || SUBSTR(SQLERRM,1,3000) ;
2876: IF l_changed_df THEN
2877: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT='''||l_df||'''';
2878: END If;

Line 2907: x_return_status := FND_API.G_RET_STS_SUCCESS;

2903: SELECT resource_id
2904: FROM asg_user
2905: WHERE user_name = p_user_name;
2906: BEGIN
2907: x_return_status := FND_API.G_RET_STS_SUCCESS;
2908: curr_tranid := p_tranid;
2909:
2910: l_select_inqcnt_sqlstring :=
2911: 'SELECT count(*) FROM CSM_HTML5_INQ ci ' ||

Line 2927: x_return_status := FND_API.G_RET_STS_ERROR;

2923: FETCH c_resource_id into l_resource_id;
2924: CLOSE c_resource_id;
2925: IF l_resource_id IS NULL THEN
2926: csm_util_pkg.log('Did not find the user: '|| p_user_name || ' in asg_user table', 'CSM_HTML5_PKG.setup_inq_info',FND_LOG.LEVEL_PROCEDURE);
2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: return;
2929: END IF;
2930:
2931: INSERT INTO asg_users_inqinfo (device_user_name,

Line 3072: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

3068: IS --currently only one pk col supported
3069: select primary_key_column from asg_pub_item where item_id=b_pi and instr(primary_key_column,',')=0;
3070:
3071: BEGIN
3072: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3073: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
3074: (p_pubitems_tbl IS NULL) THEN
3075: x_return_status := FND_API.G_RET_STS_ERROR;
3076: return;

Line 3073: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR

3069: select primary_key_column from asg_pub_item where item_id=b_pi and instr(primary_key_column,',')=0;
3070:
3071: BEGIN
3072: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3073: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
3074: (p_pubitems_tbl IS NULL) THEN
3075: x_return_status := FND_API.G_RET_STS_ERROR;
3076: return;
3077: END IF;

Line 3075: x_return_status := FND_API.G_RET_STS_ERROR;

3071: BEGIN
3072: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3073: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) OR
3074: (p_pubitems_tbl IS NULL) THEN
3075: x_return_status := FND_API.G_RET_STS_ERROR;
3076: return;
3077: END IF;
3078:
3079: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3079: x_return_status := FND_API.G_RET_STS_SUCCESS;

3075: x_return_status := FND_API.G_RET_STS_ERROR;
3076: return;
3077: END IF;
3078:
3079: x_return_status := FND_API.G_RET_STS_SUCCESS;
3080: num_pubitems := p_pubitems_tbl.count;
3081: FOR curr_index in 1..num_pubitems LOOP
3082: curr_pubitem := p_pubitems_tbl(curr_index);
3083: -- Change to _inq once that synonym exists

Line 3096: x_return_status := FND_API.G_RET_STS_ERROR;

3092: FETCH c_resource_id INTO l_resource_id;
3093: IF c_resource_id%NOTFOUND THEN
3094: CLOSE c_resource_id;
3095: CSM_UTIL_PKG.log('purge_pubitems: User: ' ||p_user_name||' not found in asg_user table', 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3096: x_return_status := FND_API.G_RET_STS_ERROR;
3097: return;
3098: END IF;
3099: CLOSE c_resource_id;
3100:

Line 3183: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR

3179: l_pubitems_tbl asg_apply.vc2_tbl_type;
3180: CURSOR l_c IS SELECT PI_NAME FROM CSM_HTML5_INQ WHERE USER_NAME=p_user_name AND SYNC_ID=p_tranid;
3181: BEGIN
3182:
3183: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3184: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
3185: x_return_status := FND_API.G_RET_STS_ERROR;
3186: return;
3187: END IF;

Line 3184: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN

3180: CURSOR l_c IS SELECT PI_NAME FROM CSM_HTML5_INQ WHERE USER_NAME=p_user_name AND SYNC_ID=p_tranid;
3181: BEGIN
3182:
3183: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3184: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
3185: x_return_status := FND_API.G_RET_STS_ERROR;
3186: return;
3187: END IF;
3188:

Line 3185: x_return_status := FND_API.G_RET_STS_ERROR;

3181: BEGIN
3182:
3183: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3184: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
3185: x_return_status := FND_API.G_RET_STS_ERROR;
3186: return;
3187: END IF;
3188:
3189: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3189: x_return_status := FND_API.G_RET_STS_SUCCESS;

3185: x_return_status := FND_API.G_RET_STS_ERROR;
3186: return;
3187: END IF;
3188:
3189: x_return_status := FND_API.G_RET_STS_SUCCESS;
3190: OPEN l_c;
3191: FETCH l_c BULK COLLECT INTO l_pubitems_tbl;
3192: CLOSE l_c;
3193:

Line 3227: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

3223: SELECT tranid FROM asg_users_inqinfo
3224: WHERE device_user_name = p_user_name AND
3225: tranid <= p_max_tranid;
3226: BEGIN
3227: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229: return;
3230: END IF;
3231:

Line 3228: x_return_status := FND_API.G_RET_STS_ERROR;

3224: WHERE device_user_name = p_user_name AND
3225: tranid <= p_max_tranid;
3226: BEGIN
3227: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
3228: x_return_status := FND_API.G_RET_STS_ERROR;
3229: return;
3230: END IF;
3231:
3232: counter :=1;

Line 3233: x_return_status := FND_API.G_RET_STS_SUCCESS;

3229: return;
3230: END IF;
3231:
3232: counter :=1;
3233: x_return_status := FND_API.G_RET_STS_SUCCESS;
3234: -- Get all the tranids for this user
3235: FOR cti in c_tranids(p_user_name, g_current_tranid) LOOP
3236: l_tranid_tbl(counter) := cti.tranid;
3237: counter := counter+1;

Line 3275: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

3271: FROM asg_users_inqinfo
3272: WHERE device_user_name = p_user_name;
3273: BEGIN
3274:
3275: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277: return;
3278: END IF;
3279:

Line 3276: x_return_status := FND_API.G_RET_STS_ERROR;

3272: WHERE device_user_name = p_user_name;
3273: BEGIN
3274:
3275: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277: return;
3278: END IF;
3279:
3280: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3280: x_return_status := FND_API.G_RET_STS_SUCCESS;

3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277: return;
3278: END IF;
3279:
3280: x_return_status := FND_API.G_RET_STS_SUCCESS;
3281:
3282: purge_pubitems(p_user_name, x_return_status);
3283:
3284: FOR caau in c_archive_asg_users(p_user_name) LOOP

Line 3321: x_return_status := FND_API.G_RET_STS_SUCCESS;

3317: WHERE user_name=a.device_user_name);
3318:
3319: BEGIN
3320:
3321: x_return_status := FND_API.G_RET_STS_SUCCESS;
3322:
3323: OPEN c_first_tran(p_user_name);
3324: FETCH c_first_tran into x_tranid;
3325: IF c_first_tran%NOTFOUND OR x_tranid is NULL THEN

Line 3326: x_return_status := FND_API.G_RET_STS_ERROR;

3322:
3323: OPEN c_first_tran(p_user_name);
3324: FETCH c_first_tran into x_tranid;
3325: IF c_first_tran%NOTFOUND OR x_tranid is NULL THEN
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: csm_util_pkg.log('No new tranids', 'CSM_HTML5_PKG.get_first_tranid',FND_LOG.LEVEL_PROCEDURE);
3328: CLOSE c_first_tran;
3329: RETURN;
3330: END IF;

Line 3335: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists

3331: CLOSE c_first_tran;
3332: csm_util_pkg.log('Returning UserName: ' || p_user_name ||' TranID: ' || x_tranid, 'CSM_HTML5_PKG.get_first_tranid',FND_LOG.LEVEL_PROCEDURE);
3333: END get_first_tranid;
3334:
3335: -- Will set x_return_status to FND_API.G_RET_STS_ERROR if no tranid exists
3336: -- Returns both dirty and deferred tranids
3337: PROCEDURE get_next_tranid(p_user_name IN VARCHAR2,
3338: p_curr_tranid IN NUMBER,
3339: x_tranid OUT NOCOPY NUMBER,

Line 3352: x_return_status := FND_API.G_RET_STS_SUCCESS;

3348: FROM asg_user WHERE user_name=a.device_user_name);
3349:
3350: BEGIN
3351:
3352: x_return_status := FND_API.G_RET_STS_SUCCESS;
3353:
3354: OPEN c_next_tran(p_user_name, p_curr_tranid);
3355: FETCH c_next_tran into x_tranid;
3356: IF c_next_tran%NOTFOUND OR x_tranid IS NULL THEN

Line 3360: x_return_status := FND_API.G_RET_STS_ERROR;

3356: IF c_next_tran%NOTFOUND OR x_tranid IS NULL THEN
3357: -- When the current tranid is the last one, set the next tranid
3358: -- also to the last one.
3359: x_tranid := p_curr_tranid;
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: csm_util_pkg.log('No new tranids', 'CSM_HTML5_PKG.get_next_tranid',FND_LOG.LEVEL_PROCEDURE);
3362: CLOSE c_next_tran;
3363: RETURN;
3364: END IF;

Line 3384: x_return_status := FND_API.G_RET_STS_SUCCESS;

3380: l_conc_userid NUMBER;
3381: l_conc_respid NUMBER;
3382: l_conc_appid NUMBER;
3383: BEGIN
3384: x_return_status := FND_API.G_RET_STS_SUCCESS;
3385:
3386: -- Get the conc program's user id, respid and appid
3387: l_conc_userid := fnd_global.user_id();
3388: IF l_conc_userid IS NULL or l_conc_userid = -1 THEN

Line 3415: --x_return_status := FND_API.G_RET_STS_ERROR; --in asg_apply returns as SUCCESS always

3411: EXCEPTION
3412: WHEN OTHERS THEN
3413: CSM_UTIL_PKG.LOG( 'Exception occurred in process_user:'||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.process_user',FND_LOG.LEVEL_EXCEPTION);
3414: fnd_global.apps_initialize(l_conc_userid, l_conc_respid, l_conc_appid);
3415: --x_return_status := FND_API.G_RET_STS_ERROR; --in asg_apply returns as SUCCESS always
3416: END;
3417: END process_user;
3418:
3419: PROCEDURE process_upload(curr_user IN VARCHAR2)

Line 3428: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP

3424: BEGIN
3425: csm_util_pkg.log('Processing upload for user: '|| curr_user, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);
3426: get_first_tranid(p_user_name => curr_user,x_tranid => curr_tranid,x_return_status => l_return_status);
3427: g_current_tranid:=curr_tranid;
3428: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP
3429: csm_util_pkg.log('Processing tranid: ' || curr_tranid, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);
3430: process_user(p_user_name => curr_user,p_tranid => curr_tranid, x_return_status => l_return_status);
3431: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3432: -- Make the call to get the next tranid

Line 3431: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

3427: g_current_tranid:=curr_tranid;
3428: WHILE l_return_status = FND_API.G_RET_STS_SUCCESS LOOP
3429: csm_util_pkg.log('Processing tranid: ' || curr_tranid, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);
3430: process_user(p_user_name => curr_user,p_tranid => curr_tranid, x_return_status => l_return_status);
3431: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3432: -- Make the call to get the next tranid
3433: -- This means if upload processing for one transaction failed
3434: -- upload processing for the rest of the transactions is stopped.
3435: get_next_tranid(p_user_name => curr_user,p_curr_tranid => curr_tranid,x_tranid => next_tranid,x_return_status => l_return_status);

Line 3467: x_return_status := FND_API.G_RET_STS_SUCCESS;

3463: l_dummy boolean:=false;
3464: l_n NUMBER;
3465: BEGIN
3466:
3467: x_return_status := FND_API.G_RET_STS_SUCCESS;
3468:
3469: OPEN l_cursor1;
3470: FETCH l_cursor1 BULK COLLECT INTO x_pubitems_tbl;
3471: CLOSE l_cursor1;

Line 3526: IF l_def_trans = FND_API.G_FALSE THEN

3522:
3523: CSM_UTIL_PKG.LOG( 'Reapply started for user:'||p_user_name ||' tranid:'||p_tranid, 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);
3524: -- Check if this transaction is deferred
3525: l_def_trans := asg_defer.is_deferred(p_user_name, p_tranid);
3526: IF l_def_trans = FND_API.G_FALSE THEN
3527: CSM_UTIL_PKG.LOG( 'Leaving since tranid is not deferred', 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return;
3530: END IF;

Line 3528: x_return_status := FND_API.G_RET_STS_ERROR;

3524: -- Check if this transaction is deferred
3525: l_def_trans := asg_defer.is_deferred(p_user_name, p_tranid);
3526: IF l_def_trans = FND_API.G_FALSE THEN
3527: CSM_UTIL_PKG.LOG( 'Leaving since tranid is not deferred', 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return;
3530: END IF;
3531:
3532: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3532: x_return_status := FND_API.G_RET_STS_SUCCESS;

3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return;
3530: END IF;
3531:
3532: x_return_status := FND_API.G_RET_STS_SUCCESS;
3533:
3534: BEGIN
3535: l_orig_user_id := fnd_global.user_id();
3536: l_orig_resp_id := fnd_global.resp_id();

Line 3552: x_return_status := FND_API.G_RET_STS_SUCCESS;

3548: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,l_orig_app_id);
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: CSM_UTIL_PKG.LOG( 'Exception occurred in reapply_transaction:'||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_EXCEPTION);
3552: x_return_status := FND_API.G_RET_STS_SUCCESS;
3553: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,l_orig_app_id);
3554: return;
3555: END;
3556:

Line 3587: IF RETCODE=FND_API.G_RET_STS_ERROR THEN

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
3585: IF(l_uname IS NULL OR l_uname<>rec.USER_NAME) THEN
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,

Line 3611: retcode := FND_API.G_RET_STS_SUCCESS;

3607: CSM_HTML5_PKG.process_upload(rec.USER_NAME);
3608: END LOOP;
3609:
3610: IF l_uname is null THEN
3611: retcode := FND_API.G_RET_STS_SUCCESS;
3612: errbuf:='Success';
3613: ELSE
3614: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
3615: errbuf:='Issue with parsing xml data of users:'||l_list;

Line 3614: retcode := FND_API.G_RET_STS_UNEXP_ERROR;

3610: IF l_uname is null THEN
3611: retcode := FND_API.G_RET_STS_SUCCESS;
3612: errbuf:='Success';
3613: ELSE
3614: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
3615: errbuf:='Issue with parsing xml data of users:'||l_list;
3616: END IF;
3617: END CONC_PROCESS_UPLOAD;
3618: