132: OE_DEBUG_PUB.Debug_Off;
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);
135: */
136: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
137: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
138:
139: fnd_file.put_line(FND_FILE.LOG, 'p_org_id = '|| p_org_id);
140:
133: OE_DEBUG_PUB.Debug_On;
134: oe_Debug_pub.setdebuglevel(5);
135: */
136: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
137: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
138:
139: fnd_file.put_line(FND_FILE.LOG, 'p_org_id = '|| p_org_id);
140:
141: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
135: */
136: fnd_file.put_line(FND_FILE.LOG, 'Debug File: ' || l_file_val);
137: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
138:
139: fnd_file.put_line(FND_FILE.LOG, 'p_org_id = '|| p_org_id);
140:
141: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
142: p_order_number_low);
143: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
137: fnd_file.put_line(FND_FILE.LOG, 'Parameters:');
138:
139: fnd_file.put_line(FND_FILE.LOG, 'p_org_id = '|| p_org_id);
140:
141: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
142: p_order_number_low);
143: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
144: p_order_number_high);
145: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
139: fnd_file.put_line(FND_FILE.LOG, 'p_org_id = '|| p_org_id);
140:
141: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
142: p_order_number_low);
143: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
144: p_order_number_high);
145: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
146: p_order_type);
147: fnd_file.put_line(FND_FILE.LOG, ' sold_to_ord = '||
141: fnd_file.put_line(FND_FILE.LOG, ' order_number_low = '||
142: p_order_number_low);
143: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
144: p_order_number_high);
145: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
146: p_order_type);
147: fnd_file.put_line(FND_FILE.LOG, ' sold_to_ord = '||
148: p_customer);
149: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
143: fnd_file.put_line(FND_FILE.LOG, ' order_number_high = '||
144: p_order_number_high);
145: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
146: p_order_type);
147: fnd_file.put_line(FND_FILE.LOG, ' sold_to_ord = '||
148: p_customer);
149: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
150: p_request_date_low);
151: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
145: fnd_file.put_line(FND_FILE.LOG, ' order_type = '||
146: p_order_type);
147: fnd_file.put_line(FND_FILE.LOG, ' sold_to_ord = '||
148: p_customer);
149: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
150: p_request_date_low);
151: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
152: p_request_date_high);
153: fnd_file.put_line(FND_FILE.LOG, ' cust_po_number = '||
147: fnd_file.put_line(FND_FILE.LOG, ' sold_to_ord = '||
148: p_customer);
149: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
150: p_request_date_low);
151: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
152: p_request_date_high);
153: fnd_file.put_line(FND_FILE.LOG, ' cust_po_number = '||
154: p_customer_po_number);
155: fnd_file.put_line(FND_FILE.LOG, ' item = '||
149: fnd_file.put_line(FND_FILE.LOG, ' request_date_low = '||
150: p_request_date_low);
151: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
152: p_request_date_high);
153: fnd_file.put_line(FND_FILE.LOG, ' cust_po_number = '||
154: p_customer_po_number);
155: fnd_file.put_line(FND_FILE.LOG, ' item = '||
156: p_item);
157: fnd_file.put_line(FND_FILE.LOG, ' warehouse = '||
151: fnd_file.put_line(FND_FILE.LOG, ' request_date_high = '||
152: p_request_date_high);
153: fnd_file.put_line(FND_FILE.LOG, ' cust_po_number = '||
154: p_customer_po_number);
155: fnd_file.put_line(FND_FILE.LOG, ' item = '||
156: p_item);
157: fnd_file.put_line(FND_FILE.LOG, ' warehouse = '||
158: p_ship_from_org_id);
159:
153: fnd_file.put_line(FND_FILE.LOG, ' cust_po_number = '||
154: p_customer_po_number);
155: fnd_file.put_line(FND_FILE.LOG, ' item = '||
156: p_item);
157: fnd_file.put_line(FND_FILE.LOG, ' warehouse = '||
158: p_ship_from_org_id);
159:
160: l_request_date_low := fnd_date.canonical_to_date(p_request_date_low); -- Added for Bug 10213020
161: fnd_file.put_line(FND_FILE.LOG, ' l_request_date_low = '|| l_request_date_low); -- Added for Bug 10213020
157: fnd_file.put_line(FND_FILE.LOG, ' warehouse = '||
158: p_ship_from_org_id);
159:
160: l_request_date_low := fnd_date.canonical_to_date(p_request_date_low); -- Added for Bug 10213020
161: fnd_file.put_line(FND_FILE.LOG, ' l_request_date_low = '|| l_request_date_low); -- Added for Bug 10213020
162: l_request_date_high := fnd_date.canonical_to_date(p_request_date_high); -- Added for Bug 10213020
163: fnd_file.put_line(FND_FILE.LOG, ' l_request_date_high = '|| l_request_date_high); -- Added for Bug 10213020
164:
165: -- Moac Start
159:
160: l_request_date_low := fnd_date.canonical_to_date(p_request_date_low); -- Added for Bug 10213020
161: fnd_file.put_line(FND_FILE.LOG, ' l_request_date_low = '|| l_request_date_low); -- Added for Bug 10213020
162: l_request_date_high := fnd_date.canonical_to_date(p_request_date_high); -- Added for Bug 10213020
163: fnd_file.put_line(FND_FILE.LOG, ' l_request_date_high = '|| l_request_date_high); -- Added for Bug 10213020
164:
165: -- Moac Start
166: IF MO_GLOBAL.get_access_mode = 'S' THEN
167: l_single_org := TRUE;
257: END IF ; -- 'IF' for Bug 10213020
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: fnd_file.put_line(FND_FILE.LOG,
262: 'Error executing Inventory Interface, Exception:G_EXC_ERROR');
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: fnd_file.put_line(FND_FILE.LOG,
261: fnd_file.put_line(FND_FILE.LOG,
262: 'Error executing Inventory Interface, Exception:G_EXC_ERROR');
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: fnd_file.put_line(FND_FILE.LOG,
266: 'Error executing Inventory Interface, Exception:G_EXC_UNEXPECTED_ERROR');
267: WHEN OTHERS THEN
268: fnd_file.put_line(FND_FILE.LOG,
269: 'Error executing Inventory Interface');
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: fnd_file.put_line(FND_FILE.LOG,
266: 'Error executing Inventory Interface, Exception:G_EXC_UNEXPECTED_ERROR');
267: WHEN OTHERS THEN
268: fnd_file.put_line(FND_FILE.LOG,
269: 'Error executing Inventory Interface');
270:
271: END Request;
272: