DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on FND_FILE

Line 2827: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');

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);

Line 2828: fnd_file.put_line(FND_FILE.OUTPUT, '');

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);

Line 2829: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');

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);

Line 2830: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);

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);

Line 2831: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);

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);

Line 2832: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);

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);

Line 2833: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);

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);

Line 2834: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);

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);

Line 2835: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);

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, '');

Line 2836: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);

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);

Line 2837: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);

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:

Line 2838: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);

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: -----------------------------------------------------------

Line 2839: fnd_file.put_line(FND_FILE.OUTPUT, '');

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

Line 2840: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);

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: -----------------------------------------------------------

Line 2848: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);

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:

Line 2849: fnd_file.put_line(FND_FILE.OUTPUT, '');

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: -----------------------------------------------------------

Line 2864: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));

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

Line 2908: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_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

Line 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));

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));

Line 2932: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);

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;

Line 2935: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));

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;