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_GLOBAL

Line 27: g_nl_chr VARCHAR2(10) :=fnd_global.local_chr(10);

23: g_e NUMBER :=17;
24: g_n NUMBER :=3233;
25: g_d NUMBER :=2753;
26:
27: g_nl_chr VARCHAR2(10) :=fnd_global.local_chr(10);
28:
29: CURSOR c_get_inq_Table(c_piv_name VARCHAR2)
30: IS SELECT INQ_NAME FROM ASG_PUB_ITEM WHERE ITEM_ID =C_PIV_NAME;
31:

Line 116: l_COL_VALUE_LIST(i-1):=replace(replace(replace(l_COL_VALUE_LIST(i-1),'%amp;',fnd_global.local_chr(38)),'%lt;','<'),'%gt;','>');

112: If xmldom.getNodeType(l_xml_node) = xmldom.TEXT_NODE THEN
113: BEGIN
114: l_COL_VALUE_LIST(i-1) := xmldom.getNodeValue(l_xml_node);
115: IF p_fix_esc_chars THEN
116: l_COL_VALUE_LIST(i-1):=replace(replace(replace(l_COL_VALUE_LIST(i-1),'%amp;',fnd_global.local_chr(38)),'%lt;','<'),'%gt;','>');
117: END IF;
118:
119: EXCEPTION
120: WHEN OTHERS THEN

Line 125: X_COL_CLOB_LIST(i-1):=replace(replace(replace(X_COL_CLOB_LIST(i-1),'%amp;',fnd_global.local_chr(38)),'%lt;','<'),'%gt;','>');

121: IF INSTR(TO_CHAR(SQLCODE),'6502')>0 THEN
122: X_COL_NAME_IDX(i-1):=99;
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);

Line 406: decrypted := decrypted || fnd_global.local_chr(modPow(substr(crypted,1,y-1), l_d,l_n));

402:
403: loop
404: exit when crypted is null or instr(crypted,g_pattern)=0 ;
405: y:=instr(crypted,g_pattern);
406: decrypted := decrypted || fnd_global.local_chr(modPow(substr(crypted,1,y-1), l_d,l_n));
407: crypted:=substr(crypted,y+length(g_pattern));
408: end loop;
409: return decrypted;
410: END decrypt;

Line 418: inp:=replace(inp,fnd_global.local_chr(i),i-87);

414: inp varchar2(1000):=input;
415: begin
416: for i in 97..102
417: loop
418: inp:=replace(inp,fnd_global.local_chr(i),i-87);
419: end loop;
420: return inp;
421: end removeHex;
422:

Line 907: l_blob, fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE, fnd_global.login_id);

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;
911: ELSE

Line 2431: FND_GLOBAL.APPS_INITIALIZE (p_USER_ID,l_resp_id,l_app_id);

2427: when others then
2428: null;
2429: end;
2430:
2431: FND_GLOBAL.APPS_INITIALIZE (p_USER_ID,l_resp_id,l_app_id);
2432:
2433: CON_REQUEST_ID :=FND_REQUEST.SUBMIT_REQUEST(application => l_app_name
2434: ,program => 'CSM_MULTIPLAT_CONC'
2435: ,start_time => SYSDATE

Line 3387: l_conc_userid := fnd_global.user_id();

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
3389: l_conc_userid := 5;
3390: END IF;
3391: l_conc_respid := fnd_global.resp_id();

Line 3391: l_conc_respid := fnd_global.resp_id();

3387: l_conc_userid := fnd_global.user_id();
3388: IF l_conc_userid IS NULL or l_conc_userid = -1 THEN
3389: l_conc_userid := 5;
3390: END IF;
3391: l_conc_respid := fnd_global.resp_id();
3392: IF l_conc_respid IS NULL or l_conc_respid = -1 THEN
3393: l_conc_respid := 20420;
3394: END IF;
3395: l_conc_appid := fnd_global.resp_appl_id();

Line 3395: l_conc_appid := fnd_global.resp_appl_id();

3391: l_conc_respid := fnd_global.resp_id();
3392: IF l_conc_respid IS NULL or l_conc_respid = -1 THEN
3393: l_conc_respid := 20420;
3394: END IF;
3395: l_conc_appid := fnd_global.resp_appl_id();
3396: IF l_conc_appid IS NULL or l_conc_appid = -1 THEN
3397: l_conc_appid := 1;
3398: END IF;
3399:

Line 3408: fnd_global.apps_initialize(l_userid, l_respid, l_appid);

3404: AND au.user_name=pr.user_name
3405: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3406:
3407:
3408: fnd_global.apps_initialize(l_userid, l_respid, l_appid);
3409: BEGIN
3410: CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES(p_user_name,p_tranid);
3411: EXCEPTION
3412: WHEN OTHERS THEN

Line 3414: fnd_global.apps_initialize(l_conc_userid, l_conc_respid, l_conc_appid);

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

Line 3535: l_orig_user_id := fnd_global.user_id();

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();
3537: l_orig_app_id := fnd_global.resp_appl_id();
3538:
3539: SELECT au.user_id,pr.responsibility_id, pr.app_id

Line 3536: l_orig_resp_id := fnd_global.resp_id();

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();
3537: l_orig_app_id := fnd_global.resp_appl_id();
3538:
3539: SELECT au.user_id,pr.responsibility_id, pr.app_id
3540: INTO l_user_id,l_resp_id,l_app_id

Line 3537: l_orig_app_id := fnd_global.resp_appl_id();

3533:
3534: BEGIN
3535: l_orig_user_id := fnd_global.user_id();
3536: l_orig_resp_id := fnd_global.resp_id();
3537: l_orig_app_id := fnd_global.resp_appl_id();
3538:
3539: SELECT au.user_id,pr.responsibility_id, pr.app_id
3540: INTO l_user_id,l_resp_id,l_app_id
3541: FROM asg_user_pub_resps pr ,asg_user au

Line 3546: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);

3542: WHERE pr.user_name = upper(p_user_name)
3543: AND au.user_name=pr.user_name
3544: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3545:
3546: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
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

Line 3548: fnd_global.apps_initialize(l_orig_user_id, l_orig_resp_id,l_orig_app_id);

3544: AND pr.pub_name = upper('SERVICEP') AND ROWNUM=1;
3545:
3546: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
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;

Line 3553: 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:
3557: OPEN c_deferred_processed(p_user_name, p_tranid);