eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MAKE_TO_ORDER_PVT dependencies on FND_FILE

Line 203: FND_FILE.Put_Line(FND_FILE.LOG, 'start OPM processing ');

199: END IF;
200:
201: /* Standard begin of API savepoint
202: ===========================================*/
203: FND_FILE.Put_Line(FND_FILE.LOG, 'start OPM processing ');
204: SAVEPOINT create_batch_for_so_line_SP;
205:
206: /*Standard call to check for call compatibility.
207: ==============================================*/

Line 220: FND_FILE.Put_Line(FND_FILE.LOG, ' compatible OK ');

216: END IF;
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: FND_FILE.Put_Line(FND_FILE.LOG, ' compatible OK ');
221: /* Check p_init_msg_list
222: =========================================*/
223: IF FND_API.to_boolean(p_init_msg_list)
224: THEN

Line 228: FND_FILE.Put_Line(FND_FILE.LOG, 'After Initialize ');

224: THEN
225: FND_MSG_PUB.initialize;
226: END IF;
227:
228: FND_FILE.Put_Line(FND_FILE.LOG, 'After Initialize ');
229: IF (g_debug <= gme_debug.g_log_statement) THEN
230: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' begin processing ');
231: END IF;
232:

Line 262: FND_FILE.Put_Line(FND_FILE.LOG,' No existing reservations against PRODUCTION supply'); -- Bug 13359707

258: END IF;
259: OPEN cur_prod_reservations(p_so_line_id);
260: FETCH cur_prod_reservations INTO l_count;
261: IF (cur_prod_reservations%NOTFOUND) or (l_count=0) THEN
262: FND_FILE.Put_Line(FND_FILE.LOG,' No existing reservations against PRODUCTION supply'); -- Bug 13359707
263:
264: IF g_debug <= gme_debug.g_log_procedure THEN
265: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' No existing reservations against PRODUCTION supply');
266: END IF;

Line 270: FND_FILE.Put_Line(FND_FILE.LOG,'Reservations already against PRODUCTION supply so terminate here'); -- Bug 13359707

266: END IF;
267: CLOSE cur_prod_reservations;
268: ELSE
269:
270: FND_FILE.Put_Line(FND_FILE.LOG,'Reservations already against PRODUCTION supply so terminate here'); -- Bug 13359707
271: IF g_debug <= gme_debug.g_log_procedure THEN
272: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Reservations already against PRODUCTION supply so terminate here');
273: END IF;
274: CLOSE cur_prod_reservations;

Line 304: FND_FILE.Put_Line(FND_FILE.LOG,'Failure to retrieve inventory item'); -- Bug 13359707

300: OPEN cur_item (l_so_line_rec.ship_from_org_id, l_so_line_rec.inventory_item_id);
301: FETCH cur_item INTO l_item_rec;
302: IF(cur_item%NOTFOUND) THEN
303: CLOSE cur_item;
304: FND_FILE.Put_Line(FND_FILE.LOG,'Failure to retrieve inventory item'); -- Bug 13359707
305: IF (g_debug <= gme_debug.g_log_statement) THEN
306: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'Failure to retrieve inventory item ');
307: END IF;
308: RAISE FND_API.G_EXC_ERROR;

Line 338: FND_FILE.Put_Line(FND_FILE.LOG,' Failure to Get_Rule so terminate processing for order '||l_order_no); -- Bug 13359707

334: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Rule being honored is '||l_mto_rules_rec.rule_name);
335: END IF;
336:
337: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
338: FND_FILE.Put_Line(FND_FILE.LOG,' Failure to Get_Rule so terminate processing for order '||l_order_no); -- Bug 13359707
339: FND_FILE.Put_Line(FND_FILE.LOG,' Failure to Get_Rule so terminate processing for line '||l_so_line_no); -- Bug 13359707
340: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure to Get_Rule so terminate processing for line '||p_so_line_id);
341: FND_MESSAGE.Set_Name('GMI','Missing');
342: FND_MESSAGE.Set_Token('MISSING', 'rule_id');

Line 339: FND_FILE.Put_Line(FND_FILE.LOG,' Failure to Get_Rule so terminate processing for line '||l_so_line_no); -- Bug 13359707

335: END IF;
336:
337: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
338: FND_FILE.Put_Line(FND_FILE.LOG,' Failure to Get_Rule so terminate processing for order '||l_order_no); -- Bug 13359707
339: FND_FILE.Put_Line(FND_FILE.LOG,' Failure to Get_Rule so terminate processing for line '||l_so_line_no); -- Bug 13359707
340: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Failure to Get_Rule so terminate processing for line '||p_so_line_id);
341: FND_MESSAGE.Set_Name('GMI','Missing');
342: FND_MESSAGE.Set_Token('MISSING', 'rule_id');
343: FND_MSG_PUB.Add;

Line 348: FND_FILE.Put_Line(FND_FILE.LOG,' No MAKE to ORDER rule exists to cover order '||l_order_no); -- Bug 13359707

344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: IF (NVL(l_mto_rules_rec.rule_id,0) = 0) THEN
348: FND_FILE.Put_Line(FND_FILE.LOG,' No MAKE to ORDER rule exists to cover order '||l_order_no); -- Bug 13359707
349: FND_FILE.Put_Line(FND_FILE.LOG,' No MAKE to ORDER rule exists to cover order line '||l_so_line_no); -- Bug 13359707
350: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No MAKE to ORDER rule exists to cover order line '||p_so_line_id);
351: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No Further Processing Required for order line '||p_so_line_id);
352: RETURN;

Line 349: FND_FILE.Put_Line(FND_FILE.LOG,' No MAKE to ORDER rule exists to cover order line '||l_so_line_no); -- Bug 13359707

345: END IF;
346:
347: IF (NVL(l_mto_rules_rec.rule_id,0) = 0) THEN
348: FND_FILE.Put_Line(FND_FILE.LOG,' No MAKE to ORDER rule exists to cover order '||l_order_no); -- Bug 13359707
349: FND_FILE.Put_Line(FND_FILE.LOG,' No MAKE to ORDER rule exists to cover order line '||l_so_line_no); -- Bug 13359707
350: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No MAKE to ORDER rule exists to cover order line '||p_so_line_id);
351: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'No Further Processing Required for order line '||p_so_line_id);
352: RETURN;
353: END IF;

Line 589: FND_FILE.Put_Line(FND_FILE.LOG,' Stock is available to meet the demand so batch creation not necessary for order '||l_order_no); -- Bug 13359707

585: END IF;
586: IF l_atr >= l_batch_qty THEN
587: /* Stock is available to reserve to meet the sales quantity so no further
588: * action required */
589: FND_FILE.Put_Line(FND_FILE.LOG,' Stock is available to meet the demand so batch creation not necessary for order '||l_order_no); -- Bug 13359707
590: FND_FILE.Put_Line(FND_FILE.LOG,' Stock is available to meet the demand so batch creation not necessary for order line ' ||l_so_line_no); -- Bug 13359707
591:
592: gme_debug.put_line('Stock is available to meet the demand so batch creation not necessary ');
593: END IF;

Line 590: FND_FILE.Put_Line(FND_FILE.LOG,' Stock is available to meet the demand so batch creation not necessary for order line ' ||l_so_line_no); -- Bug 13359707

586: IF l_atr >= l_batch_qty THEN
587: /* Stock is available to reserve to meet the sales quantity so no further
588: * action required */
589: FND_FILE.Put_Line(FND_FILE.LOG,' Stock is available to meet the demand so batch creation not necessary for order '||l_order_no); -- Bug 13359707
590: FND_FILE.Put_Line(FND_FILE.LOG,' Stock is available to meet the demand so batch creation not necessary for order line ' ||l_so_line_no); -- Bug 13359707
591:
592: gme_debug.put_line('Stock is available to meet the demand so batch creation not necessary ');
593: END IF;
594: l_batch_qty := l_batch_qty - l_atr;

Line 597: FND_FILE.Put_Line(FND_FILE.LOG, 'END of section for MUST check availability ');

593: END IF;
594: l_batch_qty := l_batch_qty - l_atr;
595: END IF; -- End of check availability
596:
597: FND_FILE.Put_Line(FND_FILE.LOG, 'END of section for MUST check availability ');
598: FND_FILE.Put_Line(FND_FILE.LOG, ' batch qty now stands at '||l_batch_qty );
599: IF (g_debug <= gme_debug.g_log_statement) THEN
600: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' End of availability checking and batch qty now '||l_batch_qty);
601: END IF;

Line 598: FND_FILE.Put_Line(FND_FILE.LOG, ' batch qty now stands at '||l_batch_qty );

594: l_batch_qty := l_batch_qty - l_atr;
595: END IF; -- End of check availability
596:
597: FND_FILE.Put_Line(FND_FILE.LOG, 'END of section for MUST check availability ');
598: FND_FILE.Put_Line(FND_FILE.LOG, ' batch qty now stands at '||l_batch_qty );
599: IF (g_debug <= gme_debug.g_log_statement) THEN
600: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' End of availability checking and batch qty now '||l_batch_qty);
601: END IF;
602: /* Now set up data and invoke create_batch

Line 670: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch/FPO API ');

666: END IF;
667: END IF;
668:
669: gme_debug.put_line('Calling Create Batch API');
670: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch/FPO API ');
671: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch/FPO qty needed is '||l_batch_qty);
672: IF (g_debug <= gme_debug.g_log_statement) THEN
673: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);

Line 671: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch/FPO qty needed is '||l_batch_qty);

667: END IF;
668:
669: gme_debug.put_line('Calling Create Batch API');
670: FND_FILE.Put_Line(FND_FILE.LOG, 'call Create Batch/FPO API ');
671: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch/FPO qty needed is '||l_batch_qty);
672: IF (g_debug <= gme_debug.g_log_statement) THEN
673: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoke Create_Batch API here');
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch qty required is '||l_batch_qty);
675: gme_debug.put_line ('before create batch FND_GLOBAL.USER_ID '||FND_GLOBAL.USER_ID);

Line 706: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_batch for order '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707

702: p_use_least_cost_validity_rule => fnd_api.g_false,
703: x_exception_material_tbl => l_exception_material_tbl
704: );
705:
706: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_batch for order '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
707: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from Create_Batch API is '||l_return_status); -- Bug 13359707
708: FND_FILE.Put_Line(FND_FILE.LOG,' Message from Create_Batch API is '||l_msg_data); -- Bug 13359707
709:
710:

Line 707: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from Create_Batch API is '||l_return_status); -- Bug 13359707

703: x_exception_material_tbl => l_exception_material_tbl
704: );
705:
706: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_batch for order '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
707: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from Create_Batch API is '||l_return_status); -- Bug 13359707
708: FND_FILE.Put_Line(FND_FILE.LOG,' Message from Create_Batch API is '||l_msg_data); -- Bug 13359707
709:
710:
711: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 708: FND_FILE.Put_Line(FND_FILE.LOG,' Message from Create_Batch API is '||l_msg_data); -- Bug 13359707

704: );
705:
706: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_batch for order '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
707: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from Create_Batch API is '||l_return_status); -- Bug 13359707
708: FND_FILE.Put_Line(FND_FILE.LOG,' Message from Create_Batch API is '||l_msg_data); -- Bug 13359707
709:
710:
711: IF (g_debug <= gme_debug.g_log_statement) THEN
712: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Return Status from Create_Batch API is '||l_return_status);

Line 817: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_pending_product_lot for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707

813: ,x_pending_product_lots_rec => l_out_pending_product_lots_rec);
814:
815: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
816:
817: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_pending_product_lot for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
818: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from create_pending_product_lot is '||l_return_status); -- Bug 13359707
819: FND_FILE.Put_Line(FND_FILE.LOG,' FAILURE to generate pending lot'); -- Bug 13359707
820:
821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FAILURE to generate pending lot ');

Line 818: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from create_pending_product_lot is '||l_return_status); -- Bug 13359707

814:
815: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
816:
817: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_pending_product_lot for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
818: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from create_pending_product_lot is '||l_return_status); -- Bug 13359707
819: FND_FILE.Put_Line(FND_FILE.LOG,' FAILURE to generate pending lot'); -- Bug 13359707
820:
821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FAILURE to generate pending lot ');
822: END IF;

Line 819: FND_FILE.Put_Line(FND_FILE.LOG,' FAILURE to generate pending lot'); -- Bug 13359707

815: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
816:
817: FND_FILE.Put_Line(FND_FILE.LOG,' After calling GME_API_PUB.create_pending_product_lot for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
818: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from create_pending_product_lot is '||l_return_status); -- Bug 13359707
819: FND_FILE.Put_Line(FND_FILE.LOG,' FAILURE to generate pending lot'); -- Bug 13359707
820:
821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FAILURE to generate pending lot ');
822: END IF;
823: END IF; -- End of pending lot generation

Line 828: FND_FILE.Put_Line(FND_FILE.LOG, ' start of Reservation Processing ');

824:
825: gme_debug.put_line('Reserve the batch Quantity to this order line');
826: /* Establish a reservation between the order line (demand) and batch product (supply)
827: ====================================================================================*/
828: FND_FILE.Put_Line(FND_FILE.LOG, ' start of Reservation Processing ');
829: l_rsv_rec:= NULL;
830: l_rsv_rec.requirement_date := l_so_line_rec.request_date;
831: l_rsv_rec.organization_id := l_so_line_rec.ship_from_org_id;
832: l_rsv_rec.inventory_item_id := l_so_line_rec.inventory_item_id;

Line 877: FND_FILE.Put_Line(FND_FILE.LOG,' inv_reservation_pub.create_reservation for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707

873: ,x_quantity_reserved => l_reserved_qty
874: ,x_reservation_id => l_reservation_id
875: ,p_partial_rsv_exists => TRUE);
876:
877: FND_FILE.Put_Line(FND_FILE.LOG,' inv_reservation_pub.create_reservation for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
878: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from inv_reservation_pub.create_reservation is '||l_return_status); -- Bug 13359707
879:
880: IF (g_debug <= gme_debug.g_log_statement) THEN
881: gme_debug.put_line ( g_pkg_name

Line 878: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from inv_reservation_pub.create_reservation is '||l_return_status); -- Bug 13359707

874: ,x_reservation_id => l_reservation_id
875: ,p_partial_rsv_exists => TRUE);
876:
877: FND_FILE.Put_Line(FND_FILE.LOG,' inv_reservation_pub.create_reservation for '||l_order_no || 'and line_no ' || l_so_line_no); -- Bug 13359707
878: FND_FILE.Put_Line(FND_FILE.LOG,' Return Status from inv_reservation_pub.create_reservation is '||l_return_status); -- Bug 13359707
879:
880: IF (g_debug <= gme_debug.g_log_statement) THEN
881: gme_debug.put_line ( g_pkg_name
882: || '.'

Line 899: FND_FILE.Put_Line(FND_FILE.LOG,' Calling Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id); -- Bug 13359707

895: END IF;
896:
897: /* Notify the customer sales representative of the batch creation
898: ===============================================================*/
899: FND_FILE.Put_Line(FND_FILE.LOG,' Calling Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id); -- Bug 13359707
900:
901: IF (g_debug <= gme_debug.g_log_statement) THEN
902: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_id'||l_rsv_rec.supply_source_header_id);
903: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Notify_CSR for batch_line_id'||l_rsv_rec.supply_source_line_id);

Line 918: FND_FILE.Put_Line(FND_FILE.LOG,' Return status from GME_SUPPLY_RES_PVT.notify_CSR is '||l_return_status); -- Bug 13359707

914: , X_return_status => l_return_status
915: , X_msg_cont => l_msg_count
916: , X_msg_data => l_msg_data );
917:
918: FND_FILE.Put_Line(FND_FILE.LOG,' Return status from GME_SUPPLY_RES_PVT.notify_CSR is '||l_return_status); -- Bug 13359707
919:
920: IF g_debug <= gme_debug.g_log_procedure THEN
921: gme_debug.put_line ( g_pkg_name || '.'
922: || l_api_name

Line 954: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');

950: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');
951: END IF;
952: END IF;
953: CLOSE Get_order_info; */
954: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');
955: -- Bug 12400843
956: IF (l_batch_header_rec.batch_type = 10) THEN
957: FND_FILE.Put_Line(FND_FILE.LOG, 'FPO '||l_out_batch_header_rec.batch_no ||' created for order ' ||
958: l_order_no ||' line number '||l_so_line_no ||

Line 957: FND_FILE.Put_Line(FND_FILE.LOG, 'FPO '||l_out_batch_header_rec.batch_no ||' created for order ' ||

953: CLOSE Get_order_info; */
954: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');
955: -- Bug 12400843
956: IF (l_batch_header_rec.batch_type = 10) THEN
957: FND_FILE.Put_Line(FND_FILE.LOG, 'FPO '||l_out_batch_header_rec.batch_no ||' created for order ' ||
958: l_order_no ||' line number '||l_so_line_no ||
959: ' item is '|| l_item_no ||' reservation id is '||l_reservation_id);
960: ELSE
961: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch '||l_out_batch_header_rec.batch_no ||' created for order ' ||

Line 961: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch '||l_out_batch_header_rec.batch_no ||' created for order ' ||

957: FND_FILE.Put_Line(FND_FILE.LOG, 'FPO '||l_out_batch_header_rec.batch_no ||' created for order ' ||
958: l_order_no ||' line number '||l_so_line_no ||
959: ' item is '|| l_item_no ||' reservation id is '||l_reservation_id);
960: ELSE
961: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch '||l_out_batch_header_rec.batch_no ||' created for order ' ||
962: l_order_no ||' line number '||l_so_line_no ||
963: ' item is '|| l_item_no ||' reservation id is '||l_reservation_id);
964: END IF;
965: FND_FILE.Put_Line(FND_FILE.LOG,'Make to Order implemented for rule '||l_mto_rules_rec.rule_name);

Line 965: FND_FILE.Put_Line(FND_FILE.LOG,'Make to Order implemented for rule '||l_mto_rules_rec.rule_name);

961: FND_FILE.Put_Line(FND_FILE.LOG, 'Batch '||l_out_batch_header_rec.batch_no ||' created for order ' ||
962: l_order_no ||' line number '||l_so_line_no ||
963: ' item is '|| l_item_no ||' reservation id is '||l_reservation_id);
964: END IF;
965: FND_FILE.Put_Line(FND_FILE.LOG,'Make to Order implemented for rule '||l_mto_rules_rec.rule_name);
966: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');
967:
968: /* EXCEPTION HANDLING
969: ====================*/

Line 966: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');

962: l_order_no ||' line number '||l_so_line_no ||
963: ' item is '|| l_item_no ||' reservation id is '||l_reservation_id);
964: END IF;
965: FND_FILE.Put_Line(FND_FILE.LOG,'Make to Order implemented for rule '||l_mto_rules_rec.rule_name);
966: FND_FILE.Put_Line(FND_FILE.LOG, '***************************************************************************************** ');
967:
968: /* EXCEPTION HANDLING
969: ====================*/
970: EXCEPTION