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_LOG

Line 127: CSM_UTIL_PKG.LOG('Found clob data in column: '||l_COL_NAME_LIST(i-1), 'CSM_HTML5_PKG.PARSE_XML',FND_LOG.LEVEL_PROCEDURE);

123: X_COL_CLOB_LIST(i-1):=xmldom.getNodeValue(l_xml_node);
124: IF p_fix_esc_chars THEN
125: X_COL_CLOB_LIST(i-1):=replace(replace(replace(X_COL_CLOB_LIST(i-1),'%amp;',fnd_global.local_chr(38)),'%lt;','<'),'%gt;','>');
126: END IF;
127: CSM_UTIL_PKG.LOG('Found clob data in column: '||l_COL_NAME_LIST(i-1), 'CSM_HTML5_PKG.PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
128: ELSE
129: CSM_UTIL_PKG.LOG('Exception with error code :'||TO_CHAR(SQLCODE)||' and message:'||substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
130: RAISE;
131: END IF;

Line 129: CSM_UTIL_PKG.LOG('Exception with error code :'||TO_CHAR(SQLCODE)||' and message:'||substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.PARSE_XML',FND_LOG.LEVEL_PROCEDURE);

125: X_COL_CLOB_LIST(i-1):=replace(replace(replace(X_COL_CLOB_LIST(i-1),'%amp;',fnd_global.local_chr(38)),'%lt;','<'),'%gt;','>');
126: END IF;
127: CSM_UTIL_PKG.LOG('Found clob data in column: '||l_COL_NAME_LIST(i-1), 'CSM_HTML5_PKG.PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
128: ELSE
129: CSM_UTIL_PKG.LOG('Exception with error code :'||TO_CHAR(SQLCODE)||' and message:'||substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
130: RAISE;
131: END IF;
132: END;
133: ELSE

Line 143: CSM_UTIL_PKG.LOG('Exception :'||substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.PARSE_XML', FND_LOG.LEVEL_PROCEDURE);

139: X_COL_VALUE_LIST := L_COL_VALUE_LIST;
140:
141:
142: EXCEPTION WHEN OTHERS THEN
143: CSM_UTIL_PKG.LOG('Exception :'||substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.PARSE_XML', FND_LOG.LEVEL_PROCEDURE);
144: RAISE;
145: END PARSE_XML;
146:
147:

Line 183: CSM_UTIL_PKG.LOG('Exception for Query:'||l_QUERY_TEXT1, 'CSM_HTML5_PKG.GET_XML_PAYLOAD', FND_LOG.LEVEL_PROCEDURE);

179: dbms_xmlgen.closeContext(qrycontext);
180: x_XML_PAYLOAD := l_xml;
181:
182: EXCEPTION WHEN OTHERS THEN
183: CSM_UTIL_PKG.LOG('Exception for Query:'||l_QUERY_TEXT1, 'CSM_HTML5_PKG.GET_XML_PAYLOAD', FND_LOG.LEVEL_PROCEDURE);
184: raise;
185: END GET_XML_PAYLOAD;
186:
187: -----------------START CACHE APIS---------------------------

Line 204: CSM_UTIL_PKG.LOG('Unique index violation(Race): for user:'||P_U ||' in session:'||G_SESSION_ID, 'CSM_HTML5_PKG.GET_XML_PAYLOAD', FND_LOG.LEVEL_PROCEDURE);

200: END IF;
201: COMMIT;
202: EXCEPTION
203: WHEN OTHERS THEN --unique index violation can happen for DDL cache when processed concurrently and it is insignificant
204: CSM_UTIL_PKG.LOG('Unique index violation(Race): for user:'||P_U ||' in session:'||G_SESSION_ID, 'CSM_HTML5_PKG.GET_XML_PAYLOAD', FND_LOG.LEVEL_PROCEDURE);
205: ROLLBACK;
206: IF(P_U<>'CSM_CACHE_PVT') THEN
207: RAISE;
208: END IF;

Line 233: CSM_UTIL_PKG.LOG(pi||' hit in '||p_u||' cache', 'CSM_HTML5_PKG.GET_CACHED', FND_LOG.LEVEL_PROCEDURE);

229: RETURN FALSE;
230: END IF;
231:
232: SELECT DATA,REC_CNT INTO X_DATA,X_CNT FROM CSM_HTML5_CACHE WHERE USER_NAME=P_U AND PI_NAME=PI;
233: CSM_UTIL_PKG.LOG(pi||' hit in '||p_u||' cache', 'CSM_HTML5_PKG.GET_CACHED', FND_LOG.LEVEL_PROCEDURE);
234: RETURN TRUE;
235: EXCEPTION
236: WHEN OTHERS THEN
237: RETURN FALSE;

Line 361: --CSM_UTIL_PKG.LOG('vault get:'||l_str, 'CSM_HTML5_PKG.set_rsa_keys', FND_LOG.LEVEL_PROCEDURE);

357: BEGIN
358:
359: IF p_in_prof='RSA_KEY' THEN
360: l_str:=handle_vault('GET','RSA_KEY_'||asg_base.get_user_id(p_user_name));
361: --CSM_UTIL_PKG.LOG('vault get:'||l_str, 'CSM_HTML5_PKG.set_rsa_keys', FND_LOG.LEVEL_PROCEDURE);
362: ELSE
363: select prf_value into l_str from csm_html5_clients_info where user_name=p_user_name and prf_name=p_in_prof;
364: END IF;
365:

Line 497: --CSM_UTIL_PKG.LOG('vault put:'||x, 'CSM_HTML5_PKG.set_user_profile', FND_LOG.LEVEL_PROCEDURE);

493: begin
494:
495: IF pname='RSA_KEY' THEN
496: x:=handle_vault('PUT','RSA_KEY_'||asg_base.get_user_id(p_uname),pvalue); --key size max is 30
497: --CSM_UTIL_PKG.LOG('vault put:'||x, 'CSM_HTML5_PKG.set_user_profile', FND_LOG.LEVEL_PROCEDURE);
498: ELSE
499: UPDATE csm_html5_clients_info SET PRF_VALUE=pvalue
500: WHERE PRF_NAME=pname AND USER_NAME=p_uname;
501:

Line 547: CSM_UTIL_PKG.LOG('No more space to MARK_ERROR' , 'CSM_HTML5_PKG.MARK_ERROR', FND_LOG.LEVEL_PROCEDURE);

543: UPDATE csm_html5_clients_info
544: SET PRF_VALUE=l_temp||'.'
545: WHERE USER_NAME=p_user_name
546: AND PRF_NAME='XML_ERROR';
547: CSM_UTIL_PKG.LOG('No more space to MARK_ERROR' , 'CSM_HTML5_PKG.MARK_ERROR', FND_LOG.LEVEL_PROCEDURE);
548: RETURN;
549: END IF;
550:
551: l_t1 := INSTR(l_temp,p_PI_NAME);

Line 593: CSM_UTIL_PKG.LOG('Exception occurred in MARK_ERROR: ' || substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.MARK_ERROR', FND_LOG.LEVEL_PROCEDURE);

589: INSERT INTO csm_html5_clients_info(USER_NAME,PRF_NAME,PRF_VALUE) VALUES(p_user_name,'XML_ERROR',p_PI_NAME||':'||p_pk_value||';');
590: END;
591: EXCEPTION
592: WHEN OTHERS THEN
593: CSM_UTIL_PKG.LOG('Exception occurred in MARK_ERROR: ' || substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.MARK_ERROR', FND_LOG.LEVEL_PROCEDURE);
594: END MARK_ERROR;
595:
596:
597: PROCEDURE set_indx_ref(p_idx IN VARCHAR2)

Line 833: CSM_UTIL_PKG.LOG('Exception occurred in create_table_js: ' || substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.create_table_js', FND_LOG.LEVEL_PROCEDURE);

829: return l_stmt;
830:
831: EXCEPTION
832: WHEN others THEN
833: CSM_UTIL_PKG.LOG('Exception occurred in create_table_js: ' || substr(sqlerrm,0,2000), 'CSM_HTML5_PKG.create_table_js', FND_LOG.LEVEL_PROCEDURE);
834: raise;
835: END create_table_js;
836:
837: procedure query_get_schema_js(p_result OUT nocopy CLOB,

Line 853: CSM_UTIL_PKG.LOG('Processing schema of '||rec.item_id,'CSM_HTML5_PKG.query_get_schema_js',FND_LOG.LEVEL_ERROR);

849:
850: for rec in (select item_id,query1 from asg_pub_item where pub_name='SERVICEP' and enabled='Y'
851: and nvl(html5_offline,'N')='Y')
852: loop
853: CSM_UTIL_PKG.LOG('Processing schema of '||rec.item_id,'CSM_HTML5_PKG.query_get_schema_js',FND_LOG.LEVEL_ERROR);
854: l_stmt := l_stmt||create_table_js(rec.item_id);
855: end loop;
856:
857: l_stmt := l_stmt||'}'||g_nl_chr;

Line 863: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_get_schema_js', FND_LOG.LEVEL_PROCEDURE);

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:
866: procedure query_schema_js( p_user_name IN VARCHAR2,
867: p_result OUT nocopy CLOB,

Line 888: CSM_UTIL_PKG.LOG('Schema Reused from instance:'||instId, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);

884: SELECT to_number(PRF_VALUE) into instId FROM csm_html5_clients_info WHERE USER_NAME='APPLICATION' AND PRF_NAME='SCHEMA_REUSE';
885:
886: select result into l_blob from csm_query_results_acc where instance_id = instId and query_id=5;
887: p_result:=blob_to_clob(l_blob);
888: CSM_UTIL_PKG.LOG('Schema Reused from instance:'||instId, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);
889: RETURN;
890: EXCEPTION
891: WHEN Others THEN
892: instId:=-1;

Line 897: CSM_UTIL_PKG.LOG('Instance Insert Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);

893: END;
894:
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:

Line 912: CSM_UTIL_PKG.LOG(m, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);

908:
909: set_user_profile('APPLICATION','SCHEMA_REUSE',to_char(instId));
910: RETURN;
911: ELSE
912: CSM_UTIL_PKG.LOG(m, 'CSM_HTML5_PKG.query_schema_js', FND_LOG.LEVEL_PROCEDURE);
913: END IF;
914: END IF;
915:
916: x_return_status:=ret;

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

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);
1041: l_final:=l_final||'reEnableSyncFunction("Sorry, '''||p_user_name||''' is not authorized to use this app."); ';
1042: l_response := 'query_validate_user: Not a mobile user';
1043: ELSE
1044: IF (authenticate(p_user_name,p_password)) THEN

Line 1045: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||'-s password is valid', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);

1041: l_final:=l_final||'reEnableSyncFunction("Sorry, '''||p_user_name||''' is not authorized to use this app."); ';
1042: l_response := 'query_validate_user: Not a mobile user';
1043: ELSE
1044: IF (authenticate(p_user_name,p_password)) THEN
1045: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||'-s password is valid', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);
1046: l_final:=l_final||'setupMetaData();';
1047: l_response:='query_validate_user: Valid password';
1048: ELSE
1049: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||'-s password is incorrect', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);

Line 1049: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||'-s password is incorrect', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);

1045: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||'-s password is valid', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);
1046: l_final:=l_final||'setupMetaData();';
1047: l_response:='query_validate_user: Valid password';
1048: ELSE
1049: CSM_UTIL_PKG.LOG('Reporting that '||p_user_name||'-s password is incorrect', 'CSM_HTML5_PKG.query_validate_user', FND_LOG.LEVEL_PROCEDURE);
1050: l_final:=l_final||'reEnableSyncFunction("Sorry, the password entered is incorrect."); ';
1051: l_response:='query_validate_user: Invalid password';
1052: END IF;
1053: END IF;

Line 1083: CSM_UTIL_PKG.LOG('Creating base object '||l_temp_tab, 'CSM_HTML5_PKG.get_base_object', FND_LOG.LEVEL_PROCEDURE);

1079: BEGIN
1080: EXECUTE IMMEDIATE 'SELECT count(1) FROM '||l_temp_tab||' WHERE ROWNUM=1' INTO l_exists;
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: CSM_UTIL_PKG.LOG('Creating base object '||l_temp_tab, 'CSM_HTML5_PKG.get_base_object', FND_LOG.LEVEL_PROCEDURE);
1084: execute immediate 'CREATE GLOBAL TEMPORARY TABLE '||l_temp_tab||' ON COMMIT DELETE ROWS AS SELECT * FROM '||piv;
1085: END;
1086: COMMIT;
1087: RETURN l_temp_tab;

Line 1098: CSM_UTIL_PKG.LOG('Processing from Temporary table:'||l_temp_object, 'CSM_HTML5_PKG.set_base_object', FND_LOG.LEVEL_PROCEDURE);

1094: IF(pi<>'CSM_MTL_SEC_INVENTORIES') THEN
1095: RETURN piv;
1096: END IF;
1097: l_temp_object:=get_base_object(pi,piv);
1098: CSM_UTIL_PKG.LOG('Processing from Temporary table:'||l_temp_object, 'CSM_HTML5_PKG.set_base_object', FND_LOG.LEVEL_PROCEDURE);
1099: execute immediate 'INSERT INTO '||l_temp_object||' SELECT * FROM '||piv;
1100: return l_temp_object;
1101: END set_base_object;
1102:

Line 1147: CSM_UTIL_PKG.LOG('Quitting...since '||p_user_name||' is not an HTML5 user', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1143:
1144: l_final := l_final ||'function mfs_synch_data(){ '||g_nl_chr;
1145:
1146: IF (NOT p_bypass_auth) AND (NOT isHTML5User(p_user_name)) THEN
1147: CSM_UTIL_PKG.LOG('Quitting...since '||p_user_name||' is not an HTML5 user', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1148: l_final:=l_final||' display_alert(''csm_mfs_error'',10); '||g_nl_chr||'}'||g_nl_chr;
1149: p_result:=l_final||g_nl_chr||' $("#mfs_sync").click(function(){ '||g_nl_chr
1150: || ' mfs_synch_data();'||g_nl_chr
1151: || ' var d=document.getElementById("mfs_sync_script"); var head= document.getElementsByTagName("head")[0]; '||g_nl_chr

Line 1176: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

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;
1180: END IF;

Line 1194: CSM_UTIL_PKG.LOG('Beginning PI download', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1190: --Config data setup -- end
1191:
1192: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT=''RRRR-MM-DD HH24:MI:SS''';
1193:
1194: CSM_UTIL_PKG.LOG('Beginning PI download', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1195:
1196: select useR_name,language,resource_id,useR_id,responsibility_id,app_id,lasT_synch_date_end
1197: into l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date from asg_user where user_name=upper(p_user_name);
1198: asg_base.init_debug(l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date);

Line 1205: CSM_UTIL_PKG.LOG('Processing PI :'||rec.item_id, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1201: for rec in (select item_id,base_objecT_name from asg_pub_item where pub_name='SERVICEP' and enabled='Y'
1202: and nvl(html5_offline,'N')='Y' order by item_id)
1203: LOOP
1204:
1205: CSM_UTIL_PKG.LOG('Processing PI :'||rec.item_id, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1206:
1207: l_final:=l_final ||'appsdb.delete_record("DELETE FROM '||rec.item_id||'");'||g_nl_chr;
1208:
1209: DELETE FROM ASG_SYSTEM_DIRTY_QUEUE WHERE CLIENT_ID=p_user_name AND PUB_ITEM=rec.item_id; --clear SDQ records here, so that new records inserted into sdq during this process

Line 1288: CSM_UTIL_PKG.LOG('GET_XML_PAYLOAD failed.', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1284: l_final:=l_final||l_stmt||g_nl_chr;
1285: l_cache:=l_cache||l_stmt||g_nl_chr;
1286: EXCEPTION
1287: WHEN Others THEN
1288: CSM_UTIL_PKG.LOG('GET_XML_PAYLOAD failed.', 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1289: MARK_ERROR(p_user_name,rec.item_id,l_pk_value);
1290: l_warning:=true;
1291: l_rec_count:=l_rec_count-1;
1292: l_total_r_count:=l_total_r_count-1;

Line 1352: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

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);
1355: END query_sync_data_js;
1356:

Line 1390: CSM_UTIL_PKG.LOG('Processing Complete refresh of PI :'||p_pi, 'CSM_HTML5_PKG.complete_refresh', FND_LOG.LEVEL_PROCEDURE);

1386: l_cache CLOB;
1387: l_base_object VARCHAR2(500);
1388: BEGIN
1389:
1390: CSM_UTIL_PKG.LOG('Processing Complete refresh of PI :'||p_pi, 'CSM_HTML5_PKG.complete_refresh', FND_LOG.LEVEL_PROCEDURE);
1391:
1392:
1393: --This api processes only one pi at a time though in loop: name=p_pi picks up one record
1394: for rec in (select item_id,base_objecT_name from asg_pub_item where pub_name='SERVICEP' and enabled='Y'

Line 1477: CSM_UTIL_PKG.LOG('GET_XML_PAYLOAD failed.', 'CSM_HTML5_PKG.complete_refresh', FND_LOG.LEVEL_PROCEDURE);

1473: l_final:=l_final||l_stmt||g_nl_chr;
1474: l_cache:=l_cache||l_stmt||g_nl_chr;
1475: EXCEPTION
1476: WHEN Others THEN
1477: CSM_UTIL_PKG.LOG('GET_XML_PAYLOAD failed.', 'CSM_HTML5_PKG.complete_refresh', FND_LOG.LEVEL_PROCEDURE);
1478: MARK_ERROR(p_user_name,rec.item_id,l_pk_value);
1479: l_rec_count:=l_rec_count-1;
1480: p_warning:=true;
1481: END;

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

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);
1564: l_final :=g_nl_chr||'function mfs_synch_data(){ '||g_nl_chr;
1565: l_final:=l_final||' display_alert(''csm_mfs_error'',10); '||g_nl_chr||'}'||g_nl_chr;
1566: p_result:=l_final||g_nl_chr||' $("#mfs_sync").click(function(){ '||g_nl_chr
1567: || ' mfs_synch_data();'||g_nl_chr

Line 1581: CSM_UTIL_PKG.LOG(p_user_name||' has been dropped and recreated. Kicking off Full Refresh', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1577:
1578: l_session_id:=CREATE_SESSION(p_user_name,'DOWNLOAD');
1579:
1580: IF IS_FIRST_SYNC(p_user_name) THEN
1581: CSM_UTIL_PKG.LOG(p_user_name||' has been dropped and recreated. Kicking off Full Refresh', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1582: UPDATE asg_purge_sdq set TRANSACTION_ID=NVL(l_session_id,1) WHERE user_name = p_user_name; --first sync over
1583: UPDATE asg_complete_refresh set synch_completed='Y' WHERE user_name = p_user_name;
1584: l_refresh_all:=TRUE;
1585: END IF;

Line 1646: CSM_UTIL_PKG.LOG('Refresh All is set', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1642: G_SESSION_ID := l_session_id;
1643: REMOVE_DIRTY_CACHE; --here bcoz it shd be after old SDQ records are cleared
1644:
1645: IF l_refresh_all THEN
1646: CSM_UTIL_PKG.LOG('Refresh All is set', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1647: for pi in (SELECT NAME FROM ASG_PUB_ITEM WHERE nvl(html5_offline,'N')='Y')
1648: loop
1649: set_comp_ref(p_user_name,pi.name);
1650: end loop;

Line 1700: CSM_UTIL_PKG.LOG('Found/Processing PI -'||rec.pub_item||' with access_id:'||rec.access_id, 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1696: where b.pub_item=a.item_id
1697: order by b.pub_item)
1698: LOOP
1699:
1700: CSM_UTIL_PKG.LOG('Found/Processing PI -'||rec.pub_item||' with access_id:'||rec.access_id, 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1701:
1702: IF(l_last_pi IS NULL OR l_last_pi <> rec.pub_item) THEN
1703: IF(l_last_pi IS NOT NULL) AND NOT l_comp_ref_list.exists(rec.pub_item) THEN
1704: UPDATE_SESSION_DETAILS(l_session_id,l_last_pi,l_rec_count,l_dummy);

Line 1713: CSM_UTIL_PKG.LOG('Complete refresh is set for '||p_user_name||'-'||rec.pub_item, 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1709: END IF;
1710:
1711:
1712: IF l_comp_ref_list.exists(rec.pub_item) THEN
1713: CSM_UTIL_PKG.LOG('Complete refresh is set for '||p_user_name||'-'||rec.pub_item, 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1714: ELSE
1715: l_rec_count:= l_rec_count+1;
1716: l_total_r_count:=l_total_r_count+1;
1717:

Line 1726: CSM_UTIL_PKG.LOG('GET_XML_PAYLOAD failed.', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);

1722: BEGIN
1723: GET_XML_PAYLOAD(rec.base_objecT_name,'ACCESS_ID',rec.ACCESS_ID,l_stmt);
1724: EXCEPTION
1725: WHEN Others THEN
1726: CSM_UTIL_PKG.LOG('GET_XML_PAYLOAD failed.', 'CSM_HTML5_PKG.q_inc_sync_data_js', FND_LOG.LEVEL_PROCEDURE);
1727: MARK_ERROR(p_user_name,rec.pub_item,rec.ACCESS_ID);
1728: l_rec_count:= l_rec_count-1;
1729: l_total_r_count:=l_total_r_count-1;
1730: l_stmt := NULL;

Line 1915: CSM_UTIL_PKG.LOG( x_error_message,'CSM_HTML5_PKG.q_inc_sync_data_js',FND_LOG.LEVEL_PROCEDURE);

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';
1918: END IF;
1919: END_SESSION(l_session_id,'ERROR',x_error_message);

Line 2015: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_HTML5_PKG.PURGE_HTML5_DATA',FND_LOG.LEVEL_EVENT);

2011: l_sqlerrno := TO_CHAR(SQLCODE);
2012: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
2013: ROLLBACK;
2014: l_error_msg := ' Exception in PURGE_HTML5_DATA:' || l_sqlerrno || ':' || l_sqlerrmsg;
2015: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_HTML5_PKG.PURGE_HTML5_DATA',FND_LOG.LEVEL_EVENT);
2016: p_status := 'ERROR';
2017: p_message := 'Error in CSM_HTML5_PKG.PURGE_HTML5_DATA: ' || l_error_msg;
2018: END PURGE_HTML5_DATA;
2019:

Line 2075: CSM_UTIL_PKG.log ('Updated sequence for user: ' || p_user_name ||'\n sequence: ' || l_seq_name || '\n Seq value: ' || l_curr_val, 'CSM_HTML5_PKG.process_sequences',FND_LOG.LEVEL_PROCEDURE);

2071: WHERE CLIENTID = p_user_name
2072: AND name = l_seq_name
2073: AND curr_val < l_curr_val;
2074:
2075: CSM_UTIL_PKG.log ('Updated sequence for user: ' || p_user_name ||'\n sequence: ' || l_seq_name || '\n Seq value: ' || l_curr_val, 'CSM_HTML5_PKG.process_sequences',FND_LOG.LEVEL_PROCEDURE);
2076: ELSE
2077: CSM_UTIL_PKG.log('Users sequence mismatch! Sequence Name: ' || l_seq_name
2078: ||' \nSequence Value: ' ||l_curr_val || '\n Client_Number: ' || l_client_num, 'CSM_HTML5_PKG.process_sequences',FND_LOG.LEVEL_PROCEDURE);
2079: END IF;

Line 2078: ||' \nSequence Value: ' ||l_curr_val || '\n Client_Number: ' || l_client_num, 'CSM_HTML5_PKG.process_sequences',FND_LOG.LEVEL_PROCEDURE);

2074:
2075: CSM_UTIL_PKG.log ('Updated sequence for user: ' || p_user_name ||'\n sequence: ' || l_seq_name || '\n Seq value: ' || l_curr_val, 'CSM_HTML5_PKG.process_sequences',FND_LOG.LEVEL_PROCEDURE);
2076: ELSE
2077: CSM_UTIL_PKG.log('Users sequence mismatch! Sequence Name: ' || l_seq_name
2078: ||' \nSequence Value: ' ||l_curr_val || '\n Client_Number: ' || l_client_num, 'CSM_HTML5_PKG.process_sequences',FND_LOG.LEVEL_PROCEDURE);
2079: END IF;
2080: end loop;
2081: END process_sequences;
2082:

Line 2134: ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);

2130:
2131: l_conf_count := SQL%ROWCOUNT;
2132:
2133: CSM_UTIL_PKG.LOG('Number of possible conflicts: ' || l_conf_count
2134: ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2135:
2136: IF (l_conf_count = 0) THEN
2137: CSM_UTIL_PKG.LOG('Leaving as No conflicts exist.' ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2138: RETURN;

Line 2137: CSM_UTIL_PKG.LOG('Leaving as No conflicts exist.' ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);

2133: CSM_UTIL_PKG.LOG('Number of possible conflicts: ' || l_conf_count
2134: ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2135:
2136: IF (l_conf_count = 0) THEN
2137: CSM_UTIL_PKG.LOG('Leaving as No conflicts exist.' ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2138: RETURN;
2139: END IF;
2140:
2141: -- Ready to call the pubitem callback

Line 2149: CSM_UTIL_PKG.LOG('SQL Command: ' || replace(l_query_string,'''','''''') ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);

2145: l_sequence := ccr.sequence;
2146:
2147: l_query_string := 'SELECT ' || l_conflict_callout ||'(:1,:2,:3) from dual';
2148:
2149: CSM_UTIL_PKG.LOG('SQL Command: ' || replace(l_query_string,'''','''''') ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2150:
2151: BEGIN
2152: l_conf_resolution := l_client_wins;
2153: EXECUTE IMMEDIATE l_query_string INTO l_conf_resolution USING p_user_name,p_upload_tranid,l_sequence ;

Line 2156: CSM_UTIL_PKG.LOG('Exception in pub item level callback. ' || sqlerrm ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);

2152: l_conf_resolution := l_client_wins;
2153: EXECUTE IMMEDIATE l_query_string INTO l_conf_resolution USING p_user_name,p_upload_tranid,l_sequence ;
2154: EXCEPTION
2155: WHEN OTHERS THEN
2156: CSM_UTIL_PKG.LOG('Exception in pub item level callback. ' || sqlerrm ,'CSM_HTML5_PKG.process_pubitem_conflicts', FND_LOG.LEVEL_PROCEDURE);
2157: END;
2158: IF (l_conf_resolution = l_server_wins) THEN
2159: UPDATE asg_conf_info
2160: SET resolution = l_conf_resolution

Line 2190: CSM_UTIL_PKG.LOG('Entered Process Conflicts for tranid: '||p_upload_tran_id, 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);

2186: PROCEDURE process_conflicts(p_user_name IN VARCHAR2,p_upload_tran_id IN NUMBER)
2187: IS
2188: BEGIN
2189:
2190: CSM_UTIL_PKG.LOG('Entered Process Conflicts for tranid: '||p_upload_tran_id, 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2191:
2192: FOR rec IN (SELECT api.item_id
2193: FROM csm_html5_inq ci, asg_pub_item api
2194: WHERE ci.user_name = p_user_name

Line 2199: CSM_UTIL_PKG.LOG('Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);

2195: AND ci.sync_id = p_upload_tran_id
2196: AND ci.pi_name = api.name
2197: AND api.detect_conflict = 'Y')
2198: LOOP
2199: CSM_UTIL_PKG.LOG('Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2200:
2201: process_pubitem_conflicts(p_user_name, p_upload_tran_id, rec.item_id);
2202:
2203: CSM_UTIL_PKG.LOG('Done Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);

Line 2203: CSM_UTIL_PKG.LOG('Done Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);

2199: CSM_UTIL_PKG.LOG('Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2200:
2201: process_pubitem_conflicts(p_user_name, p_upload_tran_id, rec.item_id);
2202:
2203: CSM_UTIL_PKG.LOG('Done Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2204: END LOOP;
2205:
2206: CSM_UTIL_PKG.LOG('Leaving Process Conflicts ', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2207: EXCEPTION

Line 2206: CSM_UTIL_PKG.LOG('Leaving Process Conflicts ', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);

2202:
2203: CSM_UTIL_PKG.LOG('Done Processing ' ||rec.item_id || ' for conflicts.', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2204: END LOOP;
2205:
2206: CSM_UTIL_PKG.LOG('Leaving Process Conflicts ', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: CSM_UTIL_PKG.LOG('Exception when processing for conflicts. '|| substr(sqlerrm,1,2000), 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2210:

Line 2209: CSM_UTIL_PKG.LOG('Exception when processing for conflicts. '|| substr(sqlerrm,1,2000), 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);

2205:
2206: CSM_UTIL_PKG.LOG('Leaving Process Conflicts ', 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: CSM_UTIL_PKG.LOG('Exception when processing for conflicts. '|| substr(sqlerrm,1,2000), 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2210:
2211: END process_conflicts;
2212:
2213: --queryId=16

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

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',

Line 2255: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_HTML5_PKG.query_parse_upload', FND_LOG.LEVEL_PROCEDURE);

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);
2258: END query_parse_upload;
2259:

Line 2288: CSM_UTIL_PKG.LOG('Quitting...since '||p_user_name||' is not an HTML5 user', 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2284:
2285: l_final := empty_clob();
2286:
2287: IF NOT isHTML5User(p_user_name) THEN
2288: CSM_UTIL_PKG.LOG('Quitting...since '||p_user_name||' is not an HTML5 user', 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2289: CREATE_AJAX_SESSION(p_user_name,'csm_mfs_error: Not authorized HTML5 user');
2290: l_final := 'display_alert("csm_mfs_error")';
2291: p_result :=l_final;
2292: RETURN -1;

Line 2296: CSM_UTIL_PKG.LOG('Auth failed for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2292: RETURN -1;
2293: END IF;
2294:
2295: IF NOT authenticate(p_user_name,p_password) THEN
2296: CSM_UTIL_PKG.LOG('Auth failed for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2297: CREATE_AJAX_SESSION(p_user_name,'csm_auth_error: Invalid password');
2298: l_final := 'display_alert("csm_pass_chg");';
2299: p_result :=l_final;
2300: RETURN -1;

Line 2303: CSM_UTIL_PKG.LOG('Dumping Uploaded data for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2299: p_result :=l_final;
2300: RETURN -1;
2301: END IF;
2302:
2303: CSM_UTIL_PKG.LOG('Dumping Uploaded data for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2304:
2305:
2306: SELECT USER_ID,RESPONSIBILITY_ID,APP_ID INTO l_user_id,l_resp_id,l_app_id FROM ASG_USER WHERE USER_NAME=p_user_name;
2307:

Line 2325: ||' with error:'||substr(l_err,1,1000),'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

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,
2328: LAST_UPDATED_BY = 1,
2329: STATUS = 'PARSE_ERROR',

Line 2359: CSM_UTIL_PKG.LOG('Synchronous Upload set for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2355: END_SESSION(l_session_id,'SUCCESS');
2356: RETURN -1;
2357: END IF;
2358:
2359: CSM_UTIL_PKG.LOG('Synchronous Upload set for USER: ' || p_user_name,'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2360:
2361: l_id.extend(2);l_ch.extend(2);l_dt.extend(2);
2362: l_id(1):=1; l_ch(1):=p_user_name;
2363:

Line 2369: CSM_UTIL_PKG.LOG('Created Instance -:'||instId, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

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:
2373: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 16, instId);

Line 2375: CSM_UTIL_PKG.LOG('Sorry, this user -'||p_user_name||' does not have the responsibility/request group to submit request', 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2371: UPDATE csm_html5_sync_info SET Q_INSTANCE_ID=instId WHERE SESSION_ID=l_session_id;
2372:
2373: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 16, instId);
2374: IF req_id=0 THEN
2375: CSM_UTIL_PKG.LOG('Sorry, this user -'||p_user_name||' does not have the responsibility/request group to submit request', 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2376: p_result:= 'sync.logSyncSession('||to_char(l_session_id)||',true);sync.upload_complete(true,"e:no_resp_to_submit_req");';
2377: END_SESSION(l_session_id,'SUCCESS_W');
2378: RETURN -1;
2379: END IF;

Line 2381: CSM_UTIL_PKG.LOG('Create Instance failed - Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2377: END_SESSION(l_session_id,'SUCCESS_W');
2378: RETURN -1;
2379: END IF;
2380: ELSE
2381: CSM_UTIL_PKG.LOG('Create Instance failed - Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2382: p_result:= 'sync.logSyncSession('||to_char(l_session_id)||',true);sync.upload_complete(true,"e:instance_create_failed");';
2383: END_SESSION(l_session_id,'SUCCESS_W');
2384: RETURN -1;
2385: END IF;

Line 2395: CSM_UTIL_PKG.LOG(l_final, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);

2391: EXCEPTION
2392: WHEN others THEN
2393: ROLLBACK;
2394: l_final := 'Exception occurred in uploadData: ' || substr(sqlerrm,1,3900);
2395: CSM_UTIL_PKG.LOG(l_final, 'CSM_HTML5_PKG.uploadData', FND_LOG.LEVEL_PROCEDURE);
2396: END_SESSION(l_session_id,'ERROR',l_final);
2397: p_result := 'handle_sync_exception("'||translateString(l_final)||'");';
2398: RETURN -1;
2399: END uploadData;

Line 2581: CSM_UTIL_PKG.LOG('Unable to set reusable since the authentication failed', 'CSM_HTML5_PKG.SET_REUSABLE', FND_LOG.LEVEL_PROCEDURE);

2577: delete from csm_html5_clients_info where user_name=p_user_name and prf_name='REUSE_AUTH_'||p_QUERY_ID;
2578: set_user_profile(p_USER_NAME,'REUSABLE_'||p_QUERY_ID,to_char(p_INSTANCE_ID));
2579: EXCEPTION
2580: WHEN OTHERS THEN
2581: CSM_UTIL_PKG.LOG('Unable to set reusable since the authentication failed', 'CSM_HTML5_PKG.SET_REUSABLE', FND_LOG.LEVEL_PROCEDURE);
2582: RETURN;
2583: END;
2584: END SET_REUSABLE;
2585:

Line 2600: CSM_UTIL_PKG.LOG('Created Instance -:'||instId, 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);

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);
2604: ELSE

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

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);
2604: ELSE
2605: set_user_profile(p_user_name,'USER_CREATION_DATA',to_char(instId));
2606: END IF;
2607: ELSE

Line 2608: CSM_UTIL_PKG.LOG('Create Instance failed - Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);

2604: ELSE
2605: set_user_profile(p_user_name,'USER_CREATION_DATA',to_char(instId));
2606: END IF;
2607: ELSE
2608: CSM_UTIL_PKG.LOG('Create Instance failed - Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);
2609: END IF;
2610: exception when others then
2611: CSM_UTIL_PKG.LOG('Exception occurred in generate_html5_data: ' || substr(sqlerrm,1,3900), 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);
2612: end generate_html5_data;

Line 2611: CSM_UTIL_PKG.LOG('Exception occurred in generate_html5_data: ' || substr(sqlerrm,1,3900), 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);

2607: ELSE
2608: CSM_UTIL_PKG.LOG('Create Instance failed - Status:'||instId||':'||ret||':'||m, 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);
2609: END IF;
2610: exception when others then
2611: CSM_UTIL_PKG.LOG('Exception occurred in generate_html5_data: ' || substr(sqlerrm,1,3900), 'CSM_HTML5_PKG.generate_html5_data', FND_LOG.LEVEL_PROCEDURE);
2612: end generate_html5_data;
2613:
2614: procedure query_generate_html5_data( p_user_name IN VARCHAR2,p_result OUT nocopy CLOB, x_return_status OUT nocopy VARCHAR2,
2615: x_error_message OUT nocopy VARCHAR2)

Line 2665: --CSM_UTIL_PKG.LOG( l_stmt ,'CSM_HTML5_PKG.GET_INQ_INS_ST',FND_LOG.LEVEL_PROCEDURE);

2661: l_stmt:=l_stmt|| SUBSTR(l_part,2)||')';
2662:
2663: p_result:=l_stmt;
2664:
2665: --CSM_UTIL_PKG.LOG( l_stmt ,'CSM_HTML5_PKG.GET_INQ_INS_ST',FND_LOG.LEVEL_PROCEDURE);
2666: END GET_INQ_INS_ST;
2667:
2668: PROCEDURE HTML5_PARSE_XML(p_SYNC_ID IN NUMBER,X_RETURN_STATUS OUT NOCOPY VARCHAR2,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
2669: IS

Line 2729: CSM_UTIL_PKG.LOG( 'Entering PARSE_XML for SYNC ID : ' || p_SYNC_ID ,'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_PROCEDURE);

2725: l_df VARCHAR2(100);
2726: l_htm5_df VARCHAR2(100):='RRRR-MM-DD HH24:MI:SS';
2727: l_changed_df boolean:=false;
2728: BEGIN
2729: CSM_UTIL_PKG.LOG( 'Entering PARSE_XML for SYNC ID : ' || p_SYNC_ID ,'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
2730:
2731: OPEN c_date_f;
2732: FETCH c_date_f INTO l_df;
2733: CLOSE c_date_f;

Line 2746: CSM_UTIL_PKG.LOG ( 'No data found in SYNC ID : ' || p_SYNC_ID, 'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_EXCEPTION);

2742: FETCH c_get_sync_data INTO l_xml_clob_payload;
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;

Line 2801: CSM_UTIL_PKG.LOG( 'Parse xml failed for ' || p_SYNC_ID ||': Payload saved in :'||L_PAYLOAD_ID ,'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_PROCEDURE);

2797: l_COL_NAME_IDX.DELETE;l_COL_CLOB_LIST.DELETE;
2798: PARSE_XML(part_xml,l_COL_NAME_LIST,L_COL_VALUE_LIST,l_COL_NAME_IDX,l_COL_CLOB_LIST,true);
2799: EXCEPTION
2800: WHEN OTHERS THEN
2801: CSM_UTIL_PKG.LOG( 'Parse xml failed for ' || p_SYNC_ID ||': Payload saved in :'||L_PAYLOAD_ID ,'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
2802: RAISE_APPLICATION_ERROR(-20994, 'PARSE_XML Failed:'||SUBSTR(SQLERRM,1,3000));
2803: END;
2804:
2805: IF L_INQ_TABLE_NAME is null THEN

Line 2806: CSM_UTIL_PKG.LOG( 'INQ TABLE NAME is null for ' || p_SYNC_ID ||': Payload saved in :'||L_PAYLOAD_ID ,'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_PROCEDURE);

2802: RAISE_APPLICATION_ERROR(-20994, 'PARSE_XML Failed:'||SUBSTR(SQLERRM,1,3000));
2803: END;
2804:
2805: IF L_INQ_TABLE_NAME is null THEN
2806: CSM_UTIL_PKG.LOG( 'INQ TABLE NAME is null for ' || p_SYNC_ID ||': Payload saved in :'||L_PAYLOAD_ID ,'CSM_HTML5_PKG.HTML5_PARSE_XML',FND_LOG.LEVEL_PROCEDURE);
2807: RAISE_APPLICATION_ERROR(-20994, 'INQ TABLE NAME is null for ' || p_SYNC_ID||': Payload saved in :'||L_PAYLOAD_ID);
2808: END IF;
2809:
2810: GET_INQ_INS_ST(L_INQ_TABLE_NAME,l_COL_NAME_LIST,L_COL_VALUE_LIST,l_COL_NAME_IDX,l_result);

Line 2862: FND_LOG.LEVEL_PROCEDURE);

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);
2863:
2864: IF l_changed_df THEN
2865: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT='''||l_df||'''';
2866: END If;

Line 2873: FND_LOG.LEVEL_EXCEPTION);

2869: EXCEPTION WHEN OTHERS THEN
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||'''';

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

2922: OPEN c_resource_id(p_user_name);
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:

Line 3089: CSM_UTIL_PKG.log('Deferring unprocessed records in publication item: ' || curr_pubitem, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);

3085: OPEN C_GET_INQ_TABLE(curr_pubitem);
3086: FETCH C_GET_INQ_TABLE INTO inq_tbl_name;
3087: CLOSE C_GET_INQ_TABLE;
3088:
3089: CSM_UTIL_PKG.log('Deferring unprocessed records in publication item: ' || curr_pubitem, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3090:
3091: OPEN c_resource_id(p_user_name);
3092: FETCH c_resource_id INTO l_resource_id;
3093: IF c_resource_id%NOTFOUND THEN

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

3091: OPEN c_resource_id(p_user_name);
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;

Line 3151: CSM_UTIL_PKG.log('Number of rows deferred as unprocessed: ' || SQL%ROWCOUNT, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);

3147: curr_pubitem, p_user_name,
3148: p_tranid, p_user_name, p_tranid, curr_pubitem;
3149:
3150: IF SQL%ROWCOUNT >0 THEN
3151: CSM_UTIL_PKG.log('Number of rows deferred as unprocessed: ' || SQL%ROWCOUNT, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3152: l_deferred_trans := TRUE;
3153: END IF;
3154: EXCEPTION
3155: WHEN OTHERS THEN

Line 3156: CSM_UTIL_PKG.log('Exception executing the SQL Command ' ||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);

3152: l_deferred_trans := TRUE;
3153: END IF;
3154: EXCEPTION
3155: WHEN OTHERS THEN
3156: CSM_UTIL_PKG.log('Exception executing the SQL Command ' ||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3157: END;
3158:
3159: DELETE FROM CSM_HTML5_INQ WHERE USER_NAME=p_user_name AND SYNC_ID=p_tranid AND PI_NAME=curr_pubitem;
3160:

Line 3244: CSM_UTIL_PKG.log('Purging tranid: ' || curr_tranid, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);

3240: -- Process one tranid at a time.
3241: IF counter >1 THEN
3242: FOR curr_index in 1..l_tranid_tbl.count LOOP
3243: curr_tranid := l_tranid_tbl(curr_index);
3244: CSM_UTIL_PKG.log('Purging tranid: ' || curr_tranid, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3245: purge_pubitems(p_user_name, curr_tranid, x_return_status);
3246:
3247: --Purge xml upload dump tables
3248: DELETE FROM CSM_HTML5_PARSED_DATA a

Line 3327: csm_util_pkg.log('No new tranids', 'CSM_HTML5_PKG.get_first_tranid',FND_LOG.LEVEL_PROCEDURE);

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;
3331: CLOSE c_first_tran;

Line 3332: csm_util_pkg.log('Returning UserName: ' || p_user_name ||' TranID: ' || x_tranid, 'CSM_HTML5_PKG.get_first_tranid',FND_LOG.LEVEL_PROCEDURE);

3328: CLOSE c_first_tran;
3329: RETURN;
3330: END IF;
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

Line 3361: csm_util_pkg.log('No new tranids', 'CSM_HTML5_PKG.get_next_tranid',FND_LOG.LEVEL_PROCEDURE);

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;
3365: CLOSE c_next_tran;

Line 3368: ||'\n Next TranID: ' || x_tranid, 'CSM_HTML5_PKG.get_next_tranid',FND_LOG.LEVEL_PROCEDURE);

3364: END IF;
3365: CLOSE c_next_tran;
3366:
3367: csm_util_pkg.log('Returning UserName: ' || p_user_name ||'\n Current TranID: ' || p_curr_tranid
3368: ||'\n Next TranID: ' || x_tranid, 'CSM_HTML5_PKG.get_next_tranid',FND_LOG.LEVEL_PROCEDURE);
3369:
3370: END get_next_tranid;
3371:
3372:

Line 3413: CSM_UTIL_PKG.LOG( 'Exception occurred in process_user:'||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.process_user',FND_LOG.LEVEL_EXCEPTION);

3409: BEGIN
3410: CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES(p_user_name,p_tranid);
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;

Line 3425: csm_util_pkg.log('Processing upload for user: '|| curr_user, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);

3421: curr_tranid NUMBER;
3422: next_tranid NUMBER;
3423: l_return_status VARCHAR2(1);
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);

Line 3429: csm_util_pkg.log('Processing tranid: ' || curr_tranid, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);

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
3433: -- This means if upload processing for one transaction failed

Line 3444: csm_util_pkg.log('Return status from end_client_apply: ' ||l_return_status, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);

3440: END LOOP;
3441:
3442: end_client_apply(p_user_name => curr_user, x_return_status => l_return_status);
3443:
3444: csm_util_pkg.log('Return status from end_client_apply: ' ||l_return_status, 'CSM_HTML5_PKG.process_upload',FND_LOG.LEVEL_PROCEDURE);
3445:
3446: END process_upload;
3447:
3448:

Line 3523: CSM_UTIL_PKG.LOG( 'Reapply started for user:'||p_user_name ||' tranid:'||p_tranid, 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);

3519: deferred_tran_id = p_tranid AND
3520: status <> 0;
3521: BEGIN
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);

Line 3527: CSM_UTIL_PKG.LOG( 'Leaving since tranid is not deferred', 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);

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;
3531:

Line 3551: CSM_UTIL_PKG.LOG( 'Exception occurred in reapply_transaction:'||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_EXCEPTION);

3547: CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES(p_user_name,p_tranid);
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;

Line 3572: CSM_UTIL_PKG.LOG( 'Reapply Completed', 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);

3568: IF p_commit_flag THEN
3569: COMMIT;
3570: END IF;
3571:
3572: CSM_UTIL_PKG.LOG( 'Reapply Completed', 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);
3573: END reapply_transaction;
3574:
3575: PROCEDURE CONC_PROCESS_UPLOAD(errbuf OUT NOCOPY VARCHAR2,RETCODE OUT NOCOPY VARCHAR2)
3576: IS

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

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,
3592: LAST_UPDATED_BY = 1,

Line 3629: CSM_UTIL_PKG.LOG('Local Login set to :'||p_v||' for user:'||p_user_name, 'CSM_HTML5_PKG.setForceLocalLogin', FND_LOG.LEVEL_PROCEDURE);

3625:
3626: PROCEDURE setForceLocalLogin(p_user_name IN VARCHAR2,p_v IN VARCHAR2)
3627: IS
3628: BEGIN
3629: CSM_UTIL_PKG.LOG('Local Login set to :'||p_v||' for user:'||p_user_name, 'CSM_HTML5_PKG.setForceLocalLogin', FND_LOG.LEVEL_PROCEDURE);
3630: IF p_v<>'Y' THEN
3631: DELETE FROM csm_html5_clients_info WHERE PRF_NAME='FORCE_LOCAL_LOGIN' AND USER_NAME=p_user_name;
3632: ELSE
3633: set_user_profile(p_user_name,'FORCE_LOCAL_LOGIN','Y');

Line 3686: CSM_UTIL_PKG.LOG('Exception:'||' for user_id:'||p_user_id||' with msg:'||substr(sqlerrm,1,2000), 'CSM_HTML5_PKG.delete_user_vault', FND_LOG.LEVEL_PROCEDURE);

3682: fnd_vault.del('CSM','RSA_KEY_'||p_user_id);
3683: set_context('CSM5_VAULT_NS', 'VAULT', 'N');
3684: exception
3685: when others then
3686: CSM_UTIL_PKG.LOG('Exception:'||' for user_id:'||p_user_id||' with msg:'||substr(sqlerrm,1,2000), 'CSM_HTML5_PKG.delete_user_vault', FND_LOG.LEVEL_PROCEDURE);
3687: end delete_user_vault;
3688:
3689: PROCEDURE DROP_USER(p_user_id IN NUMBER)
3690: IS BEGIN