232: cln_debug_pub.Add('-------- Entering procedure GET_TP_DETAILS ------', 2);
233: cln_debug_pub.Add('p_tp_hdr_id : ' || p_tp_hdr_id, 2);
234: END IF;
235:
236: g_exception_tracking_msg := 'Querying ecx_tp_headers for Trading Partner Details';
237:
238: SELECT party_id,party_site_id
239: INTO x_party_id,x_party_site_id
240: FROM ecx_tp_headers
236: g_exception_tracking_msg := 'Querying ecx_tp_headers for Trading Partner Details';
237:
238: SELECT party_id,party_site_id
239: INTO x_party_id,x_party_site_id
240: FROM ecx_tp_headers
241: WHERE tp_header_id = p_tp_hdr_id;
242:
243: IF (g_debug_level <= 2) THEN
244: cln_debug_pub.Add('------- Exiting procedure GET_TP_DETAILS ------ ', 2);