APPS.CSM_ORDERS_PKG dependencies on CSP_TRANSACTIONS_PUB

Line 68: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;

64: where line.line_id = p_line_id
65: and line.header_id = hdr.header_id
66: and rownum 67:
68: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
69: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
70:
71: r_part_line c_part_line%rowtype;
72: l_msg_count NUMBER:=0;

Line 69: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;

65: and line.header_id = hdr.header_id
66: and rownum 67:
68: l_trans_items_rec_type CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
69: l_null_trans_rec CSP_TRANSACTIONS_PUB.Trans_Items_Rec_Type;
70:
71: r_part_line c_part_line%rowtype;
72: l_msg_count NUMBER:=0;
73: l_msg_data VARCHAR2(4000);

Line 106: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for PK '||p_line_id ,

102: l_trans_items_rec_type.SHIPMENT_NUMBER := r_part_line.shipment_number;
103: l_trans_items_rec_type.SHIPMENT_LINE_ID := r_part_line.shipment_line_id;
104:
105: CSM_UTIL_PKG.LOG
106: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for PK '||p_line_id ,
107: 'CSM_ORDERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_STATEMENT ); -- put PK column here
108:
109: CSP_TRANSACTIONS_PUB.receive_requirement_trans (
110: p_trans_header_id => r_part_line.header_id,

Line 109: CSP_TRANSACTIONS_PUB.receive_requirement_trans (

105: CSM_UTIL_PKG.LOG
106: ( 'Calling API CSP_TRANSACTIONS_PUB.receive_requirement_trans for PK '||p_line_id ,
107: 'CSM_ORDERS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_STATEMENT ); -- put PK column here
108:
109: CSP_TRANSACTIONS_PUB.receive_requirement_trans (
110: p_trans_header_id => r_part_line.header_id,
111: p_trans_line_id => r_part_line.line_id,
112: p_trans_record => l_trans_items_rec_type,
113: p_trans_type => r_part_line.source_type,

Line 124: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;

120:
121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS OR l_msg_data IS NOT NULL OR l_msg_count<>0 THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: l_msg_data := replace(fnd_msg_pub.get(l_msg_count,'F'),fnd_global.local_chr(10), ' ');
124: x_error_message := 'Error in CSP_TRANSACTIONS_PUB.receive_requirement_trans' || ' for PK : ' || r_part_line.line_id || ' Details:' || l_msg_data ;
125: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
126: RETURN ;
127: END IF;
128: