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_MULTI_MOBQRY_PKG dependencies on FND_GLOBAL

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

7: -- HISTORY
8: -- 22-feb-2012 saradhak Created
9: --
10: g_pass_error VARCHAR2(500):='Invalid password passed. Please verify password using Sync.';
11: g_nl_chr VARCHAR2(10) :=fnd_global.local_chr(10);
12:
13: CURSOR c_get_hr_loc_id(b_user_id NUMBER,b_ps_id NUMBER) IS
14: SELECT max(hrl.location_id)
15: FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas

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

82: L_XML_NODE := XMLDOM.GETFIRSTCHILD(L_XML_NODE);
83: If xmldom.getNodeType(l_xml_node) = xmldom.TEXT_NODE THEN
84: l_COL_VALUE_LIST(i-1) := xmldom.getNodeValue(l_xml_node);
85: IF p_fix_esc_chars THEN
86: l_COL_VALUE_LIST(i-1):=replace(replace(replace(l_COL_VALUE_LIST(i-1),'%amp;',fnd_global.local_chr(38)),'%lt;','<'),'%gt;','>');
87: END IF;
88: ELSE
89: l_COL_VALUE_LIST(i-1) := NULL;
90: END IF;

Line 164: OPEN c_cur FOR l_ff_sql||' '||replace(l_ff_where,fnd_global.local_chr(10),' ');

160:
161: select 'SELECT '||VALUE_COLUMN_NAME ||' as code,'||NVL(MEANING_COLUMN_NAME,VALUE_COLUMN_NAME)||' as meaning FROM '||APPLICATION_TABLE_NAME,ADDITIONAL_WHERE_CLAUSE
162: INTO l_ff_sql,l_ff_where from FND_FLEX_VALIDATION_TABLES WHERE FLEX_VALUE_SET_ID=rec.ffvs;
163:
164: OPEN c_cur FOR l_ff_sql||' '||replace(l_ff_where,fnd_global.local_chr(10),' ');
165: l_do_loop:=true;
166: END IF;
167:
168: IF l_do_loop THEN

Line 482: CSM_UTIL_PKG.LOG('Entering q_receive_parts for '||p_rql_dtl_id||fnd_global.local_chr(10)

478: l_user_id NUMBER;
479: l_resp_id NUMBER;
480: l_app_id NUMBER;
481: begin
482: CSM_UTIL_PKG.LOG('Entering q_receive_parts for '||p_rql_dtl_id||fnd_global.local_chr(10)
483: ||p_qty||fnd_global.local_chr(10)||p_serials||fnd_global.local_chr(10)||p_close_short, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
484:
485: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
486: x_error_message := g_pass_error;

Line 483: ||p_qty||fnd_global.local_chr(10)||p_serials||fnd_global.local_chr(10)||p_close_short, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);

479: l_resp_id NUMBER;
480: l_app_id NUMBER;
481: begin
482: CSM_UTIL_PKG.LOG('Entering q_receive_parts for '||p_rql_dtl_id||fnd_global.local_chr(10)
483: ||p_qty||fnd_global.local_chr(10)||p_serials||fnd_global.local_chr(10)||p_close_short, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
484:
485: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
486: x_error_message := g_pass_error;
487: p_result:='E:'||x_error_message;

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

516: SELECT user_id,responsibility_id, app_id
517: INTO l_user_id,l_resp_id,l_app_id
518: FROM asg_user WHERE user_name=p_user_name;
519:
520: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
521:
522: FOR I IN 1..l_rld_tab.COUNT
523: LOOP
524:

Line 528: CSM_UTIL_PKG.LOG('Inside Loop for '||l_rld_tab(I)||' '||fnd_global.local_chr(10)

524:
525: l_tag:=to_xml_tag_name('RCV_'||l_rld_tab(I)||'_'||l_srl_tab(I));
526: l_result:=l_result||'<'||l_tag||'>';
527:
528: CSM_UTIL_PKG.LOG('Inside Loop for '||l_rld_tab(I)||' '||fnd_global.local_chr(10)
529: ||l_qty_tab(I)||' '||fnd_global.local_chr(10)||l_srl_tab(I)||' '||fnd_global.local_chr(10)||' '||l_cs_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
530:
531:
532: open c_part_line(l_rld_tab(I),l_srl_tab(I));

Line 529: ||l_qty_tab(I)||' '||fnd_global.local_chr(10)||l_srl_tab(I)||' '||fnd_global.local_chr(10)||' '||l_cs_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);

525: l_tag:=to_xml_tag_name('RCV_'||l_rld_tab(I)||'_'||l_srl_tab(I));
526: l_result:=l_result||'<'||l_tag||'>';
527:
528: CSM_UTIL_PKG.LOG('Inside Loop for '||l_rld_tab(I)||' '||fnd_global.local_chr(10)
529: ||l_qty_tab(I)||' '||fnd_global.local_chr(10)||l_srl_tab(I)||' '||fnd_global.local_chr(10)||' '||l_cs_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
530:
531:
532: open c_part_line(l_rld_tab(I),l_srl_tab(I));
533: fetch c_part_line into r_part_line;

Line 568: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');

564: x_msg_data => l_msg_data
565: );
566:
567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
568: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
569: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
570: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);
571: l_result:=l_result||''||translateString(l_msg_data)||''||'';
572: ELSE

Line 747: CSM_UTIL_PKG.LOG('Entering q_receive_parts for '||p_rql_dtl_id||fnd_global.local_chr(10)

743: l_user_id NUMBER;
744: l_resp_id NUMBER;
745: l_app_id NUMBER;
746: begin
747: CSM_UTIL_PKG.LOG('Entering q_receive_parts for '||p_rql_dtl_id||fnd_global.local_chr(10)
748: ||p_qty||fnd_global.local_chr(10)||p_serials||fnd_global.local_chr(10)||p_close_short, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
749:
750: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
751: x_error_message := g_pass_error;

Line 748: ||p_qty||fnd_global.local_chr(10)||p_serials||fnd_global.local_chr(10)||p_close_short, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);

744: l_resp_id NUMBER;
745: l_app_id NUMBER;
746: begin
747: CSM_UTIL_PKG.LOG('Entering q_receive_parts for '||p_rql_dtl_id||fnd_global.local_chr(10)
748: ||p_qty||fnd_global.local_chr(10)||p_serials||fnd_global.local_chr(10)||p_close_short, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
749:
750: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
751: x_error_message := g_pass_error;
752: p_result:='E:'||x_error_message;

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

781: SELECT user_id,responsibility_id, app_id
782: INTO l_user_id,l_resp_id,l_app_id
783: FROM asg_user WHERE user_name=p_user_name;
784:
785: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
786:
787: FOR I IN 1..l_rld_tab.COUNT
788: LOOP
789:

Line 793: CSM_UTIL_PKG.LOG('Inside Loop for '||l_rld_tab(I)||' '||fnd_global.local_chr(10)

789:
790: l_tag:=to_xml_tag_name('RCV_'||l_rld_tab(I));
791: l_result:=l_result||'<'||l_tag||'>';
792:
793: CSM_UTIL_PKG.LOG('Inside Loop for '||l_rld_tab(I)||' '||fnd_global.local_chr(10)
794: ||l_qty_tab(I)||' '||fnd_global.local_chr(10)||l_srl_tab(I)||' '||fnd_global.local_chr(10)||' '||l_cs_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
795:
796:
797: l_dummy:=false;

Line 794: ||l_qty_tab(I)||' '||fnd_global.local_chr(10)||l_srl_tab(I)||' '||fnd_global.local_chr(10)||' '||l_cs_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);

790: l_tag:=to_xml_tag_name('RCV_'||l_rld_tab(I));
791: l_result:=l_result||'<'||l_tag||'>';
792:
793: CSM_UTIL_PKG.LOG('Inside Loop for '||l_rld_tab(I)||' '||fnd_global.local_chr(10)
794: ||l_qty_tab(I)||' '||fnd_global.local_chr(10)||l_srl_tab(I)||' '||fnd_global.local_chr(10)||' '||l_cs_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
795:
796:
797: l_dummy:=false;
798: l_found:=false;

Line 837: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');

833: x_msg_data => l_msg_data
834: );
835:
836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
838: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
839: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);
840: IF(r_part_line.serial_number IS NOT NULL) THEN
841: l_result:=l_result||''||r_part_line.serial_number||''||translateString(l_msg_data)||'';

Line 942: l_rqmt_header_Rec.last_update_login := nvl(fnd_global.login_id, -1);

938: l_rqmt_header_Rec.address_type := l_header_Rec.address_type;
939: l_rqmt_header_Rec.last_update_date := sysdate;
940: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
941: l_rqmt_header_Rec.last_updated_by := asg_base.get_user_id(p_user_name);
942: l_rqmt_header_Rec.last_update_login := nvl(fnd_global.login_id, -1);
943:
944: --l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
945: --l_rqmt_header_Rec.need_by_date:= nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
946:

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

1022: SELECT user_id,responsibility_id, app_id ,org_id
1023: INTO l_user_id,l_resp_id,l_app_id,l_org_id
1024: FROM asg_user WHERE user_name=p_user_name;
1025:
1026: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1027: MO_GLOBAL.INIT ('CSM');
1028:
1029: CSP_PARTS_ORDER.upd_oe_ship_to_add (
1030: p_req_header_id =>P_REQ_HDR_ID

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

1082: SELECT user_id,responsibility_id, app_id ,org_id
1083: INTO l_user_id,l_resp_id,l_app_id,l_org_id
1084: FROM asg_user WHERE user_name=p_user_name;
1085:
1086: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1087: MO_GLOBAL.INIT ('CSM');
1088:
1089: CSP_PARTS_ORDER.upd_oe_line_ship_method (
1090: p_oe_line_id=>p_ord_line_id

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

1156: and t.sourcE_object_id=i.incident_id
1157: AND a.ORG_ID=i.org_id
1158: AND b.PARTY_SITE_ID=p_party_site_id;
1159:
1160: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1161: --mo_global.set_policy_context('S',l_org_id); also done by CSP api ..so leave it to them
1162: MO_GLOBAL.INIT ('CSM');
1163:
1164: l_hz_loc_id:=x_loc_id;

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

1219: SELECT user_id,responsibility_id, app_id ,org_id,resource_id
1220: INTO l_user_id,l_resp_id,l_app_id,l_org_id,l_rs_id
1221: FROM asg_user WHERE user_name=p_user_name;
1222:
1223: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1224: --mo_global.set_policy_context('S',l_org_id); also done by CSP api ..so leave it to them
1225: MO_GLOBAL.INIT ('CSM');
1226:
1227: csp_ship_to_address_pvt.ship_to_address_handler(

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

1921: OPEN c_audit;
1922: FETCH c_audit INTO l_old_taa;
1923: CLOSE c_audit;
1924:
1925: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
1926:
1927: csf_task_assignments_pub.update_assignment_status
1928: ( p_api_version => 1.0
1929: , p_init_msg_list => FND_API.G_TRUE

Line 1971: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id); --Bug 16192129

1967:
1968: IF ( (l_rejected_flag='Y') OR (l_on_hold_flag='Y') OR (l_cancelled_flag='Y')
1969: OR (l_closed_flag='Y') OR (l_completed_flag='Y') ) THEN
1970:
1971: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id); --Bug 16192129
1972:
1973: CSM_UTIL_PKG.LOG( 'Call debrief post program for the task assignment id: ' || l_ta_id, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status', FND_LOG.LEVEL_PROCEDURE);
1974:
1975: csf_debrief_update_pkg.form_Call (1.0, l_debrief_header_id );