DBA Data[Home] [Help]

APPS.OE_ACKNOWLEDGMENT_PUB dependencies on FND_FILE

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

2939: -----------------------------------------------------------
2940: -- Log Output file
2941: -----------------------------------------------------------
2942:
2943: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2944: fnd_file.put_line(FND_FILE.OUTPUT, '');
2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);

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

2940: -- Log Output file
2941: -----------------------------------------------------------
2942:
2943: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2944: fnd_file.put_line(FND_FILE.OUTPUT, '');
2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);

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

2941: -----------------------------------------------------------
2942:
2943: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2944: fnd_file.put_line(FND_FILE.OUTPUT, '');
2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);

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

2942:
2943: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2944: fnd_file.put_line(FND_FILE.OUTPUT, '');
2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);

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

2943: fnd_file.put_line(FND_FILE.OUTPUT, 'Show Sales Order Concurrent Program');
2944: fnd_file.put_line(FND_FILE.OUTPUT, '');
2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);

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

2944: fnd_file.put_line(FND_FILE.OUTPUT, '');
2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);

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

2945: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);

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

2946: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer id for Trading Partner : '|| p_customer_id);
2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);

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

2947: fnd_file.put_line(FND_FILE.OUTPUT, 'Open Orders Only: '|| p_open_orders_only);
2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2955: fnd_file.put_line(FND_FILE.OUTPUT, '');

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

2948: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number From: '||p_so_number_from);
2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2955: fnd_file.put_line(FND_FILE.OUTPUT, '');
2956: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);

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

2949: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Number To: '||p_so_number_to);
2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2955: fnd_file.put_line(FND_FILE.OUTPUT, '');
2956: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2957:

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

2950: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date From: '||p_so_date_from);
2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2955: fnd_file.put_line(FND_FILE.OUTPUT, '');
2956: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2957:
2958: -----------------------------------------------------------

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

2951: fnd_file.put_line(FND_FILE.OUTPUT, 'Sales Order Date To: '||p_so_date_to);
2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2955: fnd_file.put_line(FND_FILE.OUTPUT, '');
2956: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2957:
2958: -----------------------------------------------------------
2959: -- Setting Debug Mode and File

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

2952: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO number From: '||p_customer_po_no_from);
2953: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer PO Number To: '||p_customer_po_no_to);
2954: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
2955: fnd_file.put_line(FND_FILE.OUTPUT, '');
2956: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
2957:
2958: -----------------------------------------------------------
2959: -- Setting Debug Mode and File
2960: -----------------------------------------------------------

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

2960: -----------------------------------------------------------
2961:
2962: If nvl(l_debug_level, 1) > 0 Then
2963: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2964: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2965: fnd_file.put_line(FND_FILE.OUTPUT, '');
2966: END IF;
2967: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
2968:

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

2961:
2962: If nvl(l_debug_level, 1) > 0 Then
2963: l_filename := oe_debug_pub.set_debug_mode ('FILE');
2964: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
2965: fnd_file.put_line(FND_FILE.OUTPUT, '');
2966: END IF;
2967: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
2968:
2969: -----------------------------------------------------------

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

2976: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2977: IF l_debug_level > 0 THEN
2978: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
2979: END IF;
2980: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
2981:
2982: OPEN c_order_for_customer;
2983: FETCH c_order_for_customer BULK COLLECT
2984: INTO l_order_rec.header_id

Line 3024: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);

3020: x_return_status => l_return_status
3021: );
3022: If l_return_status <> FND_API.G_RET_STS_SUCCESS
3023: Or l_is_delivery_required = 'N' Then
3024: fnd_file.put_line(FND_FILE.OUTPUT,'Show SO not enabled for TP: ' || p_customer_id);
3025: If l_debug_level > 0 THEN
3026: oe_debug_pub.add( 'CONC PGM NOT RAISING SSO EVENT FOR TP: '|| p_customer_id);
3027: End If;
3028: Else

Line 3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));

3043: oe_debug_pub.add( 'AFTER OE_ACKNOWLEDGMENT_PUB.RAISE_EVENT_SHOWSO API: RETURN STATUS:'||L_RETURN_STATUS , 2 ) ;
3044: END IF;
3045:
3046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
3048: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
3049: l_return_status := FND_API.G_RET_STS_SUCCESS;
3050: ELSE
3051: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));

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

3044: END IF;
3045:
3046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
3048: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
3049: l_return_status := FND_API.G_RET_STS_SUCCESS;
3050: ELSE
3051: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
3052: END IF;

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

3047: fnd_file.put_line(FND_FILE.OUTPUT,'Not able to raise the event for Document Number : ' || l_order_rec.orig_sys_document_ref(i));
3048: fnd_file.put_line(FND_FILE.OUTPUT,'Error : ' || sqlerrm);
3049: l_return_status := FND_API.G_RET_STS_SUCCESS;
3050: ELSE
3051: fnd_file.put_line(FND_FILE.OUTPUT,'Successfully raised the event for Document Number : ' ||l_order_rec.orig_sys_document_ref(i));
3052: END IF;
3053:
3054: End If;
3055: END LOOP;