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 ASG_BASE

Line 360: l_str:=handle_vault('GET','RSA_KEY_'||asg_base.get_user_id(p_user_name));

356: l_t2 NUMBER;
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;

Line 496: x:=handle_vault('PUT','RSA_KEY_'||asg_base.get_user_id(p_uname),pvalue); --key size max is 30

492: x varchar2(100);
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;

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

891: WHEN Others THEN
892: instId:=-1;
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

Line 906: VALUES (CSM_QUERY_RESULTS_ACC_S.NEXTVAL, asg_base.get_user_id(p_user_name), 5, instId, 1,

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,
907: l_blob, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);
908:
909: set_user_profile('APPLICATION','SCHEMA_REUSE',to_char(instId));
910: RETURN;

Line 1198: asg_base.init_debug(l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date);

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);
1199:
1200:
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)

Line 1657: asg_base.init_debug(l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date);

1653: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT=''RRRR-MM-DD HH24:MI:SS''';
1654:
1655: select useR_name,language,resource_id,useR_id,responsibility_id,app_id,lasT_synch_date_end
1656: 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);
1657: asg_base.init_debug(l_uname,l_lang,lrid,l_uid,l_respid,l_app_id,l_synch_date);
1658:
1659:
1660: /*****COMPLETE REFRESH***********/
1661: for pi in (SELECT a.NAME FROM ASG_PUB_ITEM a,CSM_HTML5_CLIENTS_INFO b

Line 2109: l_client_wins := asg_base.G_CLIENT_WINS;

2105:
2106: SELECT conflict_callout INTO l_conflict_callout
2107: FROM asg_pub_item WHERE name = p_pubitem;
2108:
2109: l_client_wins := asg_base.G_CLIENT_WINS;
2110: l_server_wins := asg_base.G_SERVER_WINS;
2111:
2112: -- Get the access_id of updated DMLs
2113: insert into asg_conf_info (user_name,

Line 2110: l_server_wins := asg_base.G_SERVER_WINS;

2106: SELECT conflict_callout INTO l_conflict_callout
2107: FROM asg_pub_item WHERE name = p_pubitem;
2108:
2109: l_client_wins := asg_base.G_CLIENT_WINS;
2110: l_server_wins := asg_base.G_SERVER_WINS;
2111:
2112: -- Get the access_id of updated DMLs
2113: insert into asg_conf_info (user_name,
2114: pub_item,

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

2362: l_id(1):=1; l_ch(1):=p_user_name;
2363:
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:

Line 2373: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 16, instId);

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

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

2593: begin
2594: l_id.extend(1);l_ch.extend(1);l_dt.extend(1);
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);

Line 2601: req_id:=SUBMIT_CON_QUERY(asg_base.get_user_id(p_user_name), 12, instId);

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
2605: set_user_profile(p_user_name,'USER_CREATION_DATA',to_char(instId));