APPS.POS_MERGE_SUPPLIER_PKG dependencies on POS_PRODUCT_SERVICE_UTL_PKG

Line 300: pos_product_service_utl_pkg.add_new_ps_req(p_vendor_id => p_vendor_prodsrv_rec.vendor_id,

296: BEGIN
297: x_return_status := fnd_api.g_ret_sts_success;
298:
299: -- Insert the data into the pos_product_service_requests table using the follwing API
300: pos_product_service_utl_pkg.add_new_ps_req(p_vendor_id => p_vendor_prodsrv_rec.vendor_id,
301: p_segment1 => p_vendor_prodsrv_rec.segment1,
302: p_segment2 => p_vendor_prodsrv_rec.segment2,
303: p_segment3 => p_vendor_prodsrv_rec.segment3,
304: p_segment4 => p_vendor_prodsrv_rec.segment4,

Line 330: ' From pos_product_service_utl_pkg.add_new_ps_req API.');

326: IF x_return_status <> fnd_api.g_ret_sts_success THEN
327: fnd_file.put_line(fnd_file.log,
328: 'No. of Messages: ' || l_msg_count || ', Message: ' ||
329: l_msg_data ||
330: ' From pos_product_service_utl_pkg.add_new_ps_req API.');
331: RETURN;
332: END IF;
333:
334: -- If the request_status is "APPROVED" then do the following

Line 344: pos_product_service_utl_pkg.initialize(x_status => l_status,

340: FROM pos_supplier_mappings
341: WHERE vendor_id = p_vendor_prodsrv_rec.vendor_id
342: AND party_id = p_party_id;
343:
344: pos_product_service_utl_pkg.initialize(x_status => l_status,
345: x_error_message => l_error_message);
346:
347: SELECT rtrim(nvl2(p_vendor_prodsrv_rec.segment1,
348: p_vendor_prodsrv_rec.segment1 || '.',

Line 411: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_concat,

407: '.')
408: INTO l_segment_concat
409: FROM dual;
410:
411: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_concat,
412: x_mapp_id => l_mapping_id);
413:
414: -- Using the request_id make a call to the following Api to approve the data and insert it into the
415: -- pos_sup_products_services table