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 CSM_UTIL_PKG

Line 135: CSM_UTIL_PKG.LOG('Entering q_get_address_DFF for country style:'||p_addr_style, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);

131: l_ff_where VARCHAR2(4000);
132: l_do_loop BOOLEAN:=false;
133: l_code VARCHAR2(1000);l_meaning VARCHAR2(4000);
134: BEGIN
135: CSM_UTIL_PKG.LOG('Entering q_get_address_DFF for country style:'||p_addr_style, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);
136:
137: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
138: x_error_message := g_pass_error;
139: p_result:='E:'||x_error_message;

Line 140: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);

136:
137: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
138: x_error_message := g_pass_error;
139: p_result:='E:'||x_error_message;
140: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);
141: RETURN;
142: END IF;
143:
144: select user_id,responsibility_id,app_id

Line 183: CSM_UTIL_PKG.LOG('Leaving q_get_address_DFF ', 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);

179: l_result:=l_result||'';
180: END LOOP;
181: l_result:=l_result||'';
182:
183: CSM_UTIL_PKG.LOG('Leaving q_get_address_DFF ', 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_PROCEDURE);
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: p_result:='S:'||l_result||'';
186: EXCEPTION
187: WHEN OTHERS THEN

Line 191: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_EXCEPTION);

187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: x_error_message := 'Exception occurred in q_get_address_DFF: ' || substr(sqlerrm,0,1000);
190: p_result:='E:'||translateString(x_error_message);
191: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_get_address_DFF', FND_LOG.LEVEL_EXCEPTION);
192: END q_get_address_DFF;
193:
194: --query 25
195: procedure q_ship_methods(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_from_org_id IN NUMBER,p_to_hzloc_id IN NUMBER,

Line 217: CSM_UTIL_PKG.LOG('Entering q_ship_methods: frm_org:'||p_from_org_id||' to_hzloc:'||p_to_hzloc_id, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);

213: l_user_id NUMBER; l_resp_id NUMBER;l_app_id NUMBER;
214: l_hr_loc_id NUMBER;
215: l_language VARCHAR2(1000);
216: BEGIN
217: CSM_UTIL_PKG.LOG('Entering q_ship_methods: frm_org:'||p_from_org_id||' to_hzloc:'||p_to_hzloc_id, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
218:
219: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
220: x_error_message := g_pass_error;
221: p_result:='E:'||x_error_message;

Line 222: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);

218:
219: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
220: x_error_message := g_pass_error;
221: p_result:='E:'||x_error_message;
222: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
223: RETURN;
224: END IF;
225:
226: select user_id,responsibility_id,app_id

Line 237: CSM_UTIL_PKG.LOG('HR Location_id:'||l_hr_loc_id , 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);

233: and cas.party_site_id=p_to_hzloc_id
234: and (exists (select 1 from CSM_HZ_CUST_ACCT_SITES_ALL_ACC casa where cas.cust_acct_site_id=casa.cust_acct_site_id and casa.user_id=l_user_id)
235: or exists(select 1 from csm_po_loc_ass_all_acc poa where poa.location_id=hrl.location_id and poa.user_id=l_user_id ));
236:
237: CSM_UTIL_PKG.LOG('HR Location_id:'||l_hr_loc_id , 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
238:
239: IF l_hr_loc_id IS NULL THEN
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: p_result:='E:Passed TO Location is invalid.';

Line 264: CSM_UTIL_PKG.LOG('Leaving q_ship_methods ', 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);

260: ||''||rec.distance_uom||'';
261: l_result:=l_result||'';
262: END LOOP;
263:
264: CSM_UTIL_PKG.LOG('Leaving q_ship_methods ', 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_PROCEDURE);
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: p_result:='S:'||l_result||'';
267: EXCEPTION
268: WHEN OTHERS THEN

Line 272: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_EXCEPTION);

268: WHEN OTHERS THEN
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: x_error_message := 'Exception occurred in q_ship_methods: ' || substr(sqlerrm,0,1000);
271: p_result:='E:'||translateString(x_error_message);
272: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_ship_methods', FND_LOG.LEVEL_EXCEPTION);
273: END q_ship_methods;
274:
275: --query 23
276: procedure q_receivable_parts(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_task_id IN NUMBER,

Line 316: CSM_UTIL_PKG.LOG('Entering q_receivable_parts for '||p_task_id, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);

312:
313: l_result CLOB:='';
314: l_tag VARCHAR2(1000);
315: BEGIN
316: CSM_UTIL_PKG.LOG('Entering q_receivable_parts for '||p_task_id, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);
317:
318: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
319: x_error_message := g_pass_error;
320: p_result:='E:'||x_error_message;

Line 321: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);

317:
318: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
319: x_error_message := g_pass_error;
320: p_result:='E:'||x_error_message;
321: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);
322: RETURN;
323: END IF;
324:
325: FOR rec IN c_parts

Line 344: CSM_UTIL_PKG.LOG('Leaving q_receivable_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);

340: ||''||rec.req_line_detail_id||'';
341: l_result:=l_result||'';
342: END LOOP;
343:
344: CSM_UTIL_PKG.LOG('Leaving q_receivable_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_PROCEDURE);
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346: p_result:='S:'||l_result||'';
347: EXCEPTION
348: WHEN OTHERS THEN

Line 352: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_EXCEPTION);

348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350: x_error_message := 'Exception occurred in q_receivable_parts: ' || substr(sqlerrm,0,1000);
351: p_result:='E:'||translateString(x_error_message);
352: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receivable_parts', FND_LOG.LEVEL_EXCEPTION);
353: END q_receivable_parts;
354:
355: --query --with correct serial number --not USED
356: procedure q_receive_parts2(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_rql_dtl_id IN VARCHAR2,p_qty IN VARCHAR2,p_serials IN VARCHAR2,p_close_short IN VARCHAR2,

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 488: CSM_UTIL_PKG.LOG(x_error_message, '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;
488: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
489: RETURN;
490: END IF;
491:
492: if instr(l_str1,':,:')>0 then

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 551: CSM_UTIL_PKG.LOG

547: l_trans_items_rec_type.TO_SUBINVENTORY_CODE := r_part_line.destination_subinventory;
548: l_trans_items_rec_type.SHIPMENT_NUMBER := r_part_line.shipment_number;
549: l_trans_items_rec_type.SHIPMENT_LINE_ID := r_part_line.shipment_line_id;
550:
551: CSM_UTIL_PKG.LOG
552: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for '||r_part_line.source_type||':'||r_part_line.line_id||':'||r_part_line.serial_number ,
553: 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_STATEMENT );
554:
555: CSP_TRANSACTIONS_PUB.receive_requirement_trans (

Line 570: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);

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
573: CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND(r_part_line.destination_organization_id,r_part_line.destination_subinventory
574: ,r_part_line.INVENTORY_ITEM_ID,l_user_id);

Line 600: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);

596: END IF;
597: close c_part_line;
598: END LOOP;
599:
600: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602: p_result:='S:'||l_result||'';
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN

Line 607: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);

603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: ROLLBACK;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
608: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
609: p_result:='E:'||translateString(x_error_message);
610: WHEN OTHERS THEN
611: ROLLBACK;

Line 615: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_EXCEPTION);

611: ROLLBACK;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: x_error_message := 'Exception occurred in q_receive_parts: ' || substr(sqlerrm,0,1000);
614: p_result:='E:'||translateString(x_error_message);
615: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_EXCEPTION);
616: end q_receive_parts2;
617:
618: --query 24 --if no serial number, receive random --USED
619: procedure q_receive_parts(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_rql_dtl_id IN VARCHAR2,p_qty IN VARCHAR2,p_serials IN VARCHAR2,p_close_short IN VARCHAR2,

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 753: CSM_UTIL_PKG.LOG(x_error_message, '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;
753: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
754: RETURN;
755: END IF;
756:
757: if instr(l_str1,':,:')>0 then

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 820: CSM_UTIL_PKG.LOG

816: l_trans_items_rec_type.TO_SUBINVENTORY_CODE := r_part_line.destination_subinventory;
817: l_trans_items_rec_type.SHIPMENT_NUMBER := r_part_line.shipment_number;
818: l_trans_items_rec_type.SHIPMENT_LINE_ID := r_part_line.shipment_line_id;
819:
820: CSM_UTIL_PKG.LOG
821: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for '||r_part_line.source_type||':'||r_part_line.line_id||':'||r_part_line.serial_number ,
822: 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_STATEMENT );
823:
824: CSP_TRANSACTIONS_PUB.receive_requirement_trans (

Line 839: CSM_UTIL_PKG.LOG( x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_ERROR);

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)||'';
842: ELSE
843: l_result:=l_result||''||translateString(l_msg_data)||'';

Line 881: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);

877: END IF;
878: l_result:=l_result||'';
879: END LOOP;
880:
881: CSM_UTIL_PKG.LOG('Leaving q_receive_parts ', 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_PROCEDURE);
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883: p_result:='S:'||l_result||'';
884: EXCEPTION
885: WHEN FND_API.G_EXC_ERROR THEN

Line 888: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);

884: EXCEPTION
885: WHEN FND_API.G_EXC_ERROR THEN
886: ROLLBACK;
887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts',FND_LOG.LEVEL_PROCEDURE);
889: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
890: p_result:='E:'||translateString(x_error_message);
891: WHEN OTHERS THEN
892: ROLLBACK;

Line 896: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_EXCEPTION);

892: ROLLBACK;
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894: x_error_message := 'Exception occurred in q_receive_parts: ' || substr(sqlerrm,0,1000);
895: p_result:='E:'||translateString(x_error_message);
896: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_receive_parts', FND_LOG.LEVEL_EXCEPTION);
897: end q_receive_parts;
898:
899: procedure q_upd_rqmt_ship_to( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_REQ_HDR_ID IN VARCHAR2,P_ADDRESS_TYPE IN VARCHAR2,
900: P_SHIP_LOC_SRC IN VARCHAR2,P_SHIP_LOC_ID IN VARCHAR2,p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2)

Line 919: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);

915:
916: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
917: x_error_message := g_pass_error;
918: p_result:='E:'||x_error_message;
919: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);
920: RETURN;
921: END IF;
922: x_error_message:='Success';
923:

Line 960: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);

956: );
957:
958: IF l_return_status IS NULL THEN
959: p_result:='E:No message returned by CSP api.';
960: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);
961: RETURN;
962: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;

Line 967: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);

963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: p_result:='S:'||to_char(l_Return_status);
967: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
971: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

Line 970: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);

966: p_result:='S:'||to_char(l_Return_status);
967: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
968: EXCEPTION
969: WHEN FND_API.G_EXC_ERROR THEN
970: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to',FND_LOG.LEVEL_PROCEDURE);
971: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
972: p_result:='E:'||translateString(x_error_message);
973: WHEN OTHERS THEN
974: x_error_message := 'Exception occurred in q_upd_rqmt_ship_to: ' || substr(sqlerrm,1,3900);

Line 976: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);

972: p_result:='E:'||translateString(x_error_message);
973: WHEN OTHERS THEN
974: x_error_message := 'Exception occurred in q_upd_rqmt_ship_to: ' || substr(sqlerrm,1,3900);
975: p_result:='E:'||translateString(x_error_message);
976: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_rqmt_ship_to', FND_LOG.LEVEL_PROCEDURE);
977: END q_upd_rqmt_ship_to;
978:
979: --query 21
980: procedure q_upd_oe_shipTo(p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_REQ_HDR_ID IN VARCHAR2,P_ADDRESS_TYPE IN VARCHAR2,

Line 994: CSM_UTIL_PKG.LOG('Entering q_upd_oe_shipTo for '||P_REQ_HDR_ID||':'||P_ADDRESS_TYPE||':'||P_SHIP_LOC_ID, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);

990: l_task_id NUMBER;
991: l_err boolean:=false;
992: l_hr_loc_id NUMBER;
993: begin
994: CSM_UTIL_PKG.LOG('Entering q_upd_oe_shipTo for '||P_REQ_HDR_ID||':'||P_ADDRESS_TYPE||':'||P_SHIP_LOC_ID, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
995: x_return_status := FND_API.G_RET_STS_SUCCESS;
996:
997: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
998: x_error_message := g_pass_error;

Line 1017: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);

1013: END IF;
1014:
1015: IF l_err THEN
1016: p_result:='E:'||x_error_message;
1017: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1018: RETURN;
1019: END IF;
1020:
1021:

Line 1041: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);

1037:
1038:
1039: IF l_return_status IS NULL THEN
1040: p_result:='E:No message returned by CSP api.';
1041: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1042: RETURN;
1043: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;

Line 1047: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);

1043: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: END IF;
1046:
1047: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1048: p_result:='S:'||to_char(l_return_status);
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo',FND_LOG.LEVEL_PROCEDURE);

Line 1051: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo',FND_LOG.LEVEL_PROCEDURE);

1047: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1048: p_result:='S:'||to_char(l_return_status);
1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo',FND_LOG.LEVEL_PROCEDURE);
1052: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1053: p_result:='E:'||translateString(x_error_message);
1054: WHEN OTHERS THEN
1055: x_error_message := 'Exception occurred in q_upd_oe_shipTo: ' || substr(sqlerrm,0,1000);

Line 1057: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_EXCEPTION);

1053: p_result:='E:'||translateString(x_error_message);
1054: WHEN OTHERS THEN
1055: x_error_message := 'Exception occurred in q_upd_oe_shipTo: ' || substr(sqlerrm,0,1000);
1056: p_result:='E:'||translateString(x_error_message);
1057: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_EXCEPTION);
1058: end q_upd_oe_shipTo;
1059:
1060: --query 22
1061: procedure q_upd_oe_line_shipMethod(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_ord_line_id IN NUMBER,p_ship_mtd IN VARCHAR2,

Line 1072: CSM_UTIL_PKG.LOG('Entering q_upd_oe_line_shipMethod for '||p_ord_line_id||':'||p_ship_mtd, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);

1068: l_resp_id NUMBER;
1069: l_app_id NUMBER;
1070: l_org_id NUMBER;
1071: begin
1072: CSM_UTIL_PKG.LOG('Entering q_upd_oe_line_shipMethod for '||p_ord_line_id||':'||p_ship_mtd, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1073:
1074: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1075: x_error_message := g_pass_error;
1076: p_result:='E:'||x_error_message;

Line 1077: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);

1073:
1074: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1075: x_error_message := g_pass_error;
1076: p_result:='E:'||x_error_message;
1077: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_shipTo', FND_LOG.LEVEL_PROCEDURE);
1078: RETURN;
1079: END IF;
1080:
1081:

Line 1099: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);

1095:
1096:
1097: IF l_return_status IS NULL THEN
1098: p_result:='E:No message returned by CSP api.';
1099: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1100: RETURN;
1101: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;

Line 1105: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_line_shipMethod ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);

1101: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_line_shipMethod ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1106: p_result:='S:'||to_char(l_return_status);
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR THEN
1109: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod',FND_LOG.LEVEL_PROCEDURE);

Line 1109: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod',FND_LOG.LEVEL_PROCEDURE);

1105: CSM_UTIL_PKG.LOG('Leaving q_upd_oe_line_shipMethod ', 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_PROCEDURE);
1106: p_result:='S:'||to_char(l_return_status);
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR THEN
1109: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod',FND_LOG.LEVEL_PROCEDURE);
1110: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1111: p_result:='E:'||translateString(x_error_message);
1112: WHEN OTHERS THEN
1113: x_error_message := 'Exception occurred in q_upd_oe_line_shipMethod: ' || substr(sqlerrm,0,1000);

Line 1115: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_EXCEPTION);

1111: p_result:='E:'||translateString(x_error_message);
1112: WHEN OTHERS THEN
1113: x_error_message := 'Exception occurred in q_upd_oe_line_shipMethod: ' || substr(sqlerrm,0,1000);
1114: p_result:='E:'||translateString(x_error_message);
1115: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_oe_line_shipMethod', FND_LOG.LEVEL_EXCEPTION);
1116: end q_upd_oe_line_shipMethod;
1117:
1118:
1119: FUNCTION get_hr_location(p_user_name in varchar2,p_task_id IN NUMBER,p_party_site_id NUMBER) RETURN NUMBER

Line 1147: CSM_UTIL_PKG.LOG('Creating new loc as No HR Location found for party site id:'||p_party_site_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);

1143: IF x_loc_id IS NOT NULL THEN
1144: RETURN x_loc_id;
1145: END IF;
1146:
1147: CSM_UTIL_PKG.LOG('Creating new loc as No HR Location found for party site id:'||p_party_site_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1148:
1149: SELECT a.cust_account_id ,b.party_id,b.location_id,a.org_id
1150: INTO l_account_id,l_party_id,x_loc_id,l_org_id
1151: FROM hz_cust_acct_sites_all a, hz_party_sites b,jtf_tasks_b t,cs_incidents_all_b i

Line 1166: CSM_UTIL_PKG.LOG('Before call to CSP: hz_location_id:'||l_hz_loc_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);

1162: MO_GLOBAL.INIT ('CSM');
1163:
1164: l_hz_loc_id:=x_loc_id;
1165:
1166: CSM_UTIL_PKG.LOG('Before call to CSP: hz_location_id:'||l_hz_loc_id, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1167:
1168: csp_ship_to_address_pvt.cust_inv_loc_link
1169: ( p_api_version => 1.0
1170: ,p_Init_Msg_List => FND_API.G_FALSE

Line 1190: CSM_UTIL_PKG.LOG('After call to CSP: x_loc_id:-'||x_loc_id ||' -:-ret status:'||l_ret, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);

1186: ,p_attribute18 => null,p_attribute19 => null
1187: ,p_attribute20 => null,x_return_status => l_ret ,x_msg_count => l_msg_count ,x_msg_data => l_msg_data);
1188:
1189:
1190: CSM_UTIL_PKG.LOG('After call to CSP: x_loc_id:-'||x_loc_id ||' -:-ret status:'||l_ret, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1191:
1192: if ((l_ret IS NULL AND x_loc_id = l_hz_loc_id) OR (l_ret <> FND_API.G_RET_STS_SUCCESS)) THEN
1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1194: RAISE FND_API.G_EXC_ERROR;

Line 1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);

1189:
1190: CSM_UTIL_PKG.LOG('After call to CSP: x_loc_id:-'||x_loc_id ||' -:-ret status:'||l_ret, 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1191:
1192: if ((l_ret IS NULL AND x_loc_id = l_hz_loc_id) OR (l_ret <> FND_API.G_RET_STS_SUCCESS)) THEN
1193: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||fnd_msg_pub.get(l_msg_count,'F'), 'CSM_MULTI_MOBQRY_PKG.get_hr_location',FND_LOG.LEVEL_PROCEDURE);
1194: RAISE FND_API.G_EXC_ERROR;
1195: END IF;
1196:
1197: RETURN x_loc_id;

Line 1307: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);

1303: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1304: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1305: x_error_message := g_pass_error;
1306: p_result:='E:'||x_error_message;
1307: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1308: RETURN;
1309: END IF;
1310:
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1314: CSM_UTIL_PKG.LOG('Entering q_create_shipTo with xml '||p_address, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);

1310:
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;
1312: x_error_message:='Success';
1313:
1314: CSM_UTIL_PKG.LOG('Entering q_create_shipTo with xml '||p_address, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1315:
1316: xmlD:=''||p_address||'';
1317:
1318: PARSE_XML(xmlD,L_COL_NAME_LIST,L_COL_VALUE_LIST,true);

Line 1346: CSM_UTIL_PKG.LOG(l_adrs_line_1||','||l_adrs_line_2||','||l_adrs_line_3||','||l_adrs_line_4||','||l_city||','||l_county||','

1342: l_pincode:=L_COL_VALUE_LIST(I);
1343: END IF;
1344: END LOOP;
1345:
1346: CSM_UTIL_PKG.LOG(l_adrs_line_1||','||l_adrs_line_2||','||l_adrs_line_3||','||l_adrs_line_4||','||l_city||','||l_county||','
1347: ||l_state||','||l_province||','||l_phonetic ||','||l_country||','||l_pincode ,'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1348:
1349: create_ship_to_address(p_user_name,p_ta_id,l_adrs_line_1 ,l_adrs_line_2 ,l_adrs_line_3,l_adrs_line_4 ,l_city ,l_county
1350: ,l_state,l_province,l_phonetic,l_country,l_pincode ,x_loc_id,x_cust_id, x_ovn,l_return_status ,l_msg_count ,l_msg_data );

Line 1372: CSM_UTIL_PKG.LOG('Leaving q_create_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);

1368: --CUSTOMER_ID = x_cust_id (cust_account_id)
1369: --ADDRESS_ID =l_cust_acct_site_id (cust_acct_site_id)
1370: --LOCATION_ID = l_hr_loc_id
1371:
1372: CSM_UTIL_PKG.LOG('Leaving q_create_shipTo ', 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_PROCEDURE);
1373: p_result:='S:'||to_char(l_hz_psite_id)||':'||to_char(l_hz_loc_id)||':'||to_char(l_cust_acct_site_id)||':'||to_char(l_hr_loc_id)
1374: ||':'||to_char(l_org_id)||':'||to_char(x_cust_id);
1375: EXCEPTION
1376: WHEN FND_API.G_EXC_ERROR THEN

Line 1377: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo',FND_LOG.LEVEL_PROCEDURE);

1373: p_result:='S:'||to_char(l_hz_psite_id)||':'||to_char(l_hz_loc_id)||':'||to_char(l_cust_acct_site_id)||':'||to_char(l_hr_loc_id)
1374: ||':'||to_char(l_org_id)||':'||to_char(x_cust_id);
1375: EXCEPTION
1376: WHEN FND_API.G_EXC_ERROR THEN
1377: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo',FND_LOG.LEVEL_PROCEDURE);
1378: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1379: p_result:='E:'||translateString(x_error_message);
1380: WHEN OTHERS THEN
1381: x_error_message := 'Exception occurred in q_create_shipTo: ' || substr(sqlerrm,0,1000);

Line 1383: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_EXCEPTION);

1379: p_result:='E:'||translateString(x_error_message);
1380: WHEN OTHERS THEN
1381: x_error_message := 'Exception occurred in q_create_shipTo: ' || substr(sqlerrm,0,1000);
1382: p_result:='E:'||translateString(x_error_message);
1383: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_create_shipTo', FND_LOG.LEVEL_EXCEPTION);
1384: end q_create_shipTo;
1385:
1386: procedure q_available_parts( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_ITEM_NAME IN VARCHAR2,P_QTY IN VARCHAR2,P_WH_TYPE IN VARCHAR2,
1387: P_NEED_BY IN VARCHAR2,P_SUBSTITUTE IN VARCHAR2,P_DIST IN NUMBER,

Line 1464: CSM_UTIL_PKG.LOG('Entering q_available_parts for Item : ' ||P_ITEM_NAME, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);

1460: l_xml_tname VARCHAR2(1000);
1461:
1462: BEGIN
1463:
1464: CSM_UTIL_PKG.LOG('Entering q_available_parts for Item : ' ||P_ITEM_NAME, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1465:
1466: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',asg_base.get_user_id(p_user_name),NULL,NULL));
1467:
1468: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1483: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);

1479: END IF;
1480:
1481: IF l_err THEN
1482: p_result:='E:'||x_error_message;
1483: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1484: RETURN;
1485: END IF;
1486:
1487: x_error_message:='Success';

Line 1594: CSM_UTIL_PKG.LOG('Search Params'

1590: l_search_params_rec.to_location_id := P_LOC_ID;
1591: END IF;
1592:
1593:
1594: CSM_UTIL_PKG.LOG('***************Search Params***************'
1595: ||g_nl_chr ||'Search My inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.my_inventory)
1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)
1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)
1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)

Line 1595: ||g_nl_chr ||'Search My inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.my_inventory)

1591: END IF;
1592:
1593:
1594: CSM_UTIL_PKG.LOG('***************Search Params***************'
1595: ||g_nl_chr ||'Search My inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.my_inventory)
1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)
1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)
1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)
1599: ||g_nl_chr ||'Search Need by: '||l_search_params_rec.need_by_date

Line 1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)

1592:
1593:
1594: CSM_UTIL_PKG.LOG('***************Search Params***************'
1595: ||g_nl_chr ||'Search My inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.my_inventory)
1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)
1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)
1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)
1599: ||g_nl_chr ||'Search Need by: '||l_search_params_rec.need_by_date
1600: ||g_nl_chr ||'Search Incl Substitutes: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_alternates)

Line 1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)

1593:
1594: CSM_UTIL_PKG.LOG('***************Search Params***************'
1595: ||g_nl_chr ||'Search My inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.my_inventory)
1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)
1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)
1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)
1599: ||g_nl_chr ||'Search Need by: '||l_search_params_rec.need_by_date
1600: ||g_nl_chr ||'Search Incl Substitutes: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_alternates)
1601: ||g_nl_chr ||'Search Qty type: '||l_search_params_rec.quantity_type

Line 1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)

1594: CSM_UTIL_PKG.LOG('***************Search Params***************'
1595: ||g_nl_chr ||'Search My inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.my_inventory)
1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)
1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)
1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)
1599: ||g_nl_chr ||'Search Need by: '||l_search_params_rec.need_by_date
1600: ||g_nl_chr ||'Search Incl Substitutes: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_alternates)
1601: ||g_nl_chr ||'Search Qty type: '||l_search_params_rec.quantity_type
1602: ||g_nl_chr ||'Search Distance: '||l_search_params_rec.distance

Line 1600: ||g_nl_chr ||'Search Incl Substitutes: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_alternates)

1596: ||g_nl_chr ||'Search Tech inv: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.technicians)
1597: ||g_nl_chr ||'Search Manned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.manned_warehouses)
1598: ||g_nl_chr ||'Search Unmanned WH: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.unmanned_warehouses)
1599: ||g_nl_chr ||'Search Need by: '||l_search_params_rec.need_by_date
1600: ||g_nl_chr ||'Search Incl Substitutes: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_alternates)
1601: ||g_nl_chr ||'Search Qty type: '||l_search_params_rec.quantity_type
1602: ||g_nl_chr ||'Search Distance: '||l_search_params_rec.distance
1603: ||g_nl_chr ||'Search loc Src: '||NVL(P_LOC_SRC,'HR')
1604: ||g_nl_chr ||'Search location: '||nvl(l_search_params_rec.to_location_id,l_search_params_rec.to_hz_location_id)

Line 1605: ||g_nl_chr ||'Search Incl Closed: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_closed)

1601: ||g_nl_chr ||'Search Qty type: '||l_search_params_rec.quantity_type
1602: ||g_nl_chr ||'Search Distance: '||l_search_params_rec.distance
1603: ||g_nl_chr ||'Search loc Src: '||NVL(P_LOC_SRC,'HR')
1604: ||g_nl_chr ||'Search location: '||nvl(l_search_params_rec.to_location_id,l_search_params_rec.to_hz_location_id)
1605: ||g_nl_chr ||'Search Incl Closed: '||CSM_UTIL_PKG.bool2yn(l_search_params_rec.include_closed)
1606: , 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1607:
1608: /***************SEARCH PARAMS - End*/
1609:

Line 1616: CSM_UTIL_PKG.LOG('Checking Item : ' ||l_item_tab(I)||' with qty:'||l_qty_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);

1612: L_FAILED_RESULT:='';
1613:
1614: FOR I in 1..cnt
1615: LOOP
1616: CSM_UTIL_PKG.LOG('Checking Item : ' ||l_item_tab(I)||' with qty:'||l_qty_tab(I), 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1617: L_GIVEN_ITEM_ID:=NULL;
1618: OPEN C_GET_ITEM(l_item_tab(I), L_ORG_ID); --Get whether given item is valid or not
1619: FETCH C_GET_ITEM INTO L_GIVEN_ITEM_ID;
1620: CLOSE C_GET_ITEM;

Line 1626: CSM_UTIL_PKG.LOG( x_error_message,'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_ERROR);

1622: IF L_GIVEN_ITEM_ID IS NULL THEN
1623: x_error_message := 'The required Item:' ||l_item_tab(I) || ' is not present in the Organization:' || L_ORG_NAME;
1624: l_xml_tname:=to_xml_tag_name(l_item_tab(I));
1625: L_FAILED_RESULT:=L_FAILED_RESULT||''||x_error_message||''; --only number in tags causes issue in client
1626: CSM_UTIL_PKG.LOG( x_error_message,'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_ERROR);
1627: ELSE
1628: iCnt:=iCnt+1;
1629: l_item_name_tab(iCnt):=l_item_tab(I);
1630:

Line 1668: CSM_UTIL_PKG.LOG( x_error_message,'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_ERROR);

1664:
1665: IF L_RETURN_STATUS<> FND_API.G_RET_STS_SUCCESS THEN
1666: x_error_message := 'Part Search Api Failed with error: ' || fnd_msg_pub.get(l_msg_count,'F');
1667: p_result:='E:'||translateString(x_error_message);
1668: CSM_UTIL_PKG.LOG( x_error_message,'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_ERROR);
1669: RETURN; --this is meant for error callback
1670: ELSE
1671: FOR I IN 1..l_required_parts_tbl.COUNT
1672: LOOP

Line 1730: CSM_UTIL_PKG.LOG('Leaving q_available_parts for Item Name : ' || P_ITEM_NAME, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);

1726: END LOOP; --grping loop
1727:
1728: p_result := l_xml_result|| '';
1729:
1730: CSM_UTIL_PKG.LOG('Leaving q_available_parts for Item Name : ' || P_ITEM_NAME, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1731: COMMIT;
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: x_error_message := 'Exception occurred in q_available_parts: ' || substr(sqlerrm,0,1000);

Line 1736: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_EXCEPTION);

1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: x_error_message := 'Exception occurred in q_available_parts: ' || substr(sqlerrm,0,1000);
1735: p_result:='E:'||translateString(x_error_message);
1736: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_EXCEPTION);
1737: COMMIT;
1738: END q_available_parts;
1739:
1740:

Line 1755: CSM_UTIL_PKG.LOG('Entering q_return_item for Item: ' ||P_ITEM_NAME||' and after decode:'||l_item_name , 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);

1751: BEGIN
1752:
1753: l_item_name := replace(P_ITEM_NAME,':,:','%');
1754:
1755: CSM_UTIL_PKG.LOG('Entering q_return_item for Item: ' ||P_ITEM_NAME||' and after decode:'||l_item_name , 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);
1756:
1757: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1758: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1759: x_error_message := g_pass_error;

Line 1761: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);

1757: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1758: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1759: x_error_message := g_pass_error;
1760: p_result:='E:'||x_error_message;
1761: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);
1762: RETURN;
1763: END IF;
1764:
1765: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1845: CSM_UTIL_PKG.LOG('Leaving q_return_item for Item Name : ' || l_item_name, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);

1841: ELSE
1842: p_result := L_XML_RESULT||'';
1843: END IF;
1844:
1845: CSM_UTIL_PKG.LOG('Leaving q_return_item for Item Name : ' || l_item_name, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_PROCEDURE);
1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: x_error_message := 'Exception occurred in q_return_item: ' || substr(sqlerrm,0,1000);
1849: p_result:='E:'||translateString(x_error_message);

Line 1850: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_EXCEPTION);

1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: x_error_message := 'Exception occurred in q_return_item: ' || substr(sqlerrm,0,1000);
1849: p_result:='E:'||translateString(x_error_message);
1850: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_return_item', FND_LOG.LEVEL_EXCEPTION);
1851: END q_return_item;
1852:
1853: --Query 18
1854: procedure q_upd_task_status( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_TA_ID IN VARCHAR2, P_TA_ST_ID IN VARCHAR2

Line 1908: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status', FND_LOG.LEVEL_PROCEDURE);

1904:
1905: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN
1906: x_error_message := g_pass_error;
1907: p_result:='E:'||x_error_message;
1908: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status', FND_LOG.LEVEL_PROCEDURE);
1909: RETURN;
1910: END IF;
1911:
1912: OPEN c_get_ovn;

Line 1960: CSM_UTIL_PKG.LOG('l_debrief_header_id:' || l_debrief_header_id ||

1956: OPEN c_chk_task_status ( l_ta_id );
1957: FETCH c_chk_task_status INTO l_debrief_header_id, l_rejected_flag, l_on_hold_flag,
1958: l_cancelled_flag, l_closed_flag, l_completed_flag;
1959:
1960: CSM_UTIL_PKG.LOG('l_debrief_header_id:' || l_debrief_header_id ||
1961: 'l_rejected_flag: ' || l_rejected_flag || ' l_on_hold_flag: ' || l_on_hold_flag ||
1962: 'l_cancelled_flag : ' || l_cancelled_flag || ' l_closed_flag: ' || l_closed_flag ||
1963: ' l_completed_flag: ' || l_completed_flag
1964: ,'CSM_MULTI_MOBQRY_PKG.q_upd_task_status' , FND_LOG.LEVEL_PROCEDURE);

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

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 );
1976:
1977: END IF;

Line 1984: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);

1980: CLOSE c_chk_task_status;
1981:
1982:
1983: p_result:='S:'||to_char(l_tsk_st_id);
1984: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1985: EXCEPTION
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1988: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');

Line 1987: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);

1983: p_result:='S:'||to_char(l_tsk_st_id);
1984: CSM_UTIL_PKG.LOG('Leaving after successful execution', 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1985: EXCEPTION
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: CSM_UTIL_PKG.LOG('Exception Occurred: MSG COUNT:'||l_msg_count||' <->exception msg:'||l_msg_data, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status',FND_LOG.LEVEL_PROCEDURE);
1988: x_error_message:=fnd_msg_pub.get(l_msg_count,'F');
1989: p_result:='E:'||translateString(x_error_message);
1990: WHEN OTHERS THEN
1991: x_error_message := 'Exception occurred in q_upd_task_status: ' || substr(sqlerrm,1,3900);

Line 1993: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status', FND_LOG.LEVEL_PROCEDURE);

1989: p_result:='E:'||translateString(x_error_message);
1990: WHEN OTHERS THEN
1991: x_error_message := 'Exception occurred in q_upd_task_status: ' || substr(sqlerrm,1,3900);
1992: p_result:='E:'||translateString(x_error_message);
1993: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_MULTI_MOBQRY_PKG.q_upd_task_status', FND_LOG.LEVEL_PROCEDURE);
1994: END q_upd_task_status;
1995:
1996: end CSM_MULTI_MOBQRY_PKG;