2823: -----------------------------------------------------------
2824: -- Log Output file
2825: -----------------------------------------------------------
2826:
2827: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2828: fnd_file.put_line(FND_FILE.OUTPUT, '');
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2824: -- Log Output file
2825: -----------------------------------------------------------
2826:
2827: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2828: fnd_file.put_line(FND_FILE.OUTPUT, '');
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2825: -----------------------------------------------------------
2826:
2827: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2828: fnd_file.put_line(FND_FILE.OUTPUT, '');
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2826:
2827: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2828: fnd_file.put_line(FND_FILE.OUTPUT, '');
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2827: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2828: fnd_file.put_line(FND_FILE.OUTPUT, '');
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2828: fnd_file.put_line(FND_FILE.OUTPUT, '');
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2839: fnd_file.put_line(FND_FILE.OUTPUT, '');
2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2839: fnd_file.put_line(FND_FILE.OUTPUT, '');
2840: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2839: fnd_file.put_line(FND_FILE.OUTPUT, '');
2840: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2841:
2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2839: fnd_file.put_line(FND_FILE.OUTPUT, '');
2840: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2841:
2842: -----------------------------------------------------------
2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2839: fnd_file.put_line(FND_FILE.OUTPUT, '');
2840: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2841:
2842: -----------------------------------------------------------
2843: -- Setting Debug Mode and File
2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2839: fnd_file.put_line(FND_FILE.OUTPUT, '');
2840: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2841:
2842: -----------------------------------------------------------
2843: -- Setting Debug Mode and File
2844: -----------------------------------------------------------
2844: -----------------------------------------------------------
2845:
2846: If nvl(l_debug_level, 1) > 0 Then
2847: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2848: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2849: fnd_file.put_line(FND_FILE.OUTPUT, '');
2850: END IF;
2851: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
2852:
2845:
2846: If nvl(l_debug_level, 1) > 0 Then
2847: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2848: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2849: fnd_file.put_line(FND_FILE.OUTPUT, '');
2850: END IF;
2851: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
2852:
2853: -----------------------------------------------------------
2860: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2861: IF l_debug_level > 0 THEN
2862: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
2863: END IF;
2864: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
2865:
2866: OPEN c_order_for_customer;
2867: FETCH c_order_for_customer BULK COLLECT
2868: INTO l_order_rec.header_id
2904: x_return_status => l_return_status
2905: );
2906: If l_return_status <> FND_API.G_RET_STS_SUCCESS
2907: Or l_is_delivery_required = 'N' Then
2908: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);
2909: If l_debug_level > 0 THEN
2910: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);
2911: End If;
2912: Else
2927: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;
2928: END IF;
2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
2932: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
2933: l_return_status := FND_API.G_RET_STS_SUCCESS;
2934: ELSE
2935: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
2928: END IF;
2929:
2930: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2931: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
2932: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
2933: l_return_status := FND_API.G_RET_STS_SUCCESS;
2934: ELSE
2935: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
2936: END IF;
2931: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
2932: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
2933: l_return_status := FND_API.G_RET_STS_SUCCESS;
2934: ELSE
2935: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
2936: END IF;
2937:
2938: End If;
2939: END LOOP;