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 CSP_TRANSACTIONS_PUB

Line 472: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;

468: cnt number :=1;
469: iCnt number:=0;
470: l_dummy boolean :=false;
471:
472: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
473: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
474: r_part_line c_part_line%rowtype;
475:
476: l_result CLOB :='';

Line 473: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;

469: iCnt number:=0;
470: l_dummy boolean :=false;
471:
472: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
473: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
474: r_part_line c_part_line%rowtype;
475:
476: l_result CLOB :='';
477: l_tag VARCHAR2(1000);

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

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 (
556: p_trans_header_id => r_part_line.header_id,

Line 555: CSP_TRANSACTIONS_PUB.receive_requirement_trans (

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 (
556: p_trans_header_id => r_part_line.header_id,
557: p_trans_line_id => r_part_line.line_id,
558: p_trans_record => l_trans_items_rec_type,
559: p_trans_type => r_part_line.source_type,

Line 569: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || 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
573: CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND(r_part_line.destination_organization_id,r_part_line.destination_subinventory

Line 737: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;

733: iCnt number:=0;
734: l_found boolean:=false;
735: l_dummy boolean:=false;
736:
737: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
738: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
739: r_part_line c_part_line%rowtype;
740:
741: l_result CLOB :='';

Line 738: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;

734: l_found boolean:=false;
735: l_dummy boolean:=false;
736:
737: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
738: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
739: r_part_line c_part_line%rowtype;
740:
741: l_result CLOB :='';
742: l_tag VARCHAR2(1000);

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

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 (
825: p_trans_header_id => r_part_line.header_id,

Line 824: CSP_TRANSACTIONS_PUB.receive_requirement_trans (

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 (
825: p_trans_header_id => r_part_line.header_id,
826: p_trans_line_id => r_part_line.line_id,
827: p_trans_record => l_trans_items_rec_type,
828: p_trans_type => r_part_line.source_type,

Line 838: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || 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)||'';
842: ELSE