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.MSC_RELEASE_PK dependencies on FND_FILE

Line 547: fnd_file.put_line(FND_FILE.LOG, var_buf);

543: fnd_message.set_name('MSC', 'MSC_AUTO_RELEASE_WARN');
544: fnd_message.set_token('A2M_DBLINK',v_dblink);
545: fnd_message.set_token('SOURCE_INSTANCE',var_instance_code);
546: var_buf:= fnd_message.get;
547: fnd_file.put_line(FND_FILE.LOG, var_buf);
548:
549:
550: retcode := 1;
551: errbuf := var_buf;

Line 569: fnd_file.put_line(FND_FILE.LOG, var_buf);

565: EXCEPTION
566: WHEN OTHERS THEN
567: fnd_message.set_name('MRP', 'UNSUCCESSFUL PLAN VALIDATION');
568: var_buf:= fnd_message.get;
569: fnd_file.put_line(FND_FILE.LOG, var_buf);
570:
571: retcode := 2;
572: errbuf := var_buf;
573: RETURN;

Line 647: fnd_file.put_line(FND_FILE.LOG, var_buf);

643: AND mp.plan_id = arg_plan_id;
644:
645: IF var_debug THEN
646: var_buf := '+++++++++++++++++';
647: fnd_file.put_line(FND_FILE.LOG, var_buf);
648: var_buf := 'User ID : '||var_user_id;
649: fnd_file.put_line(FND_FILE.LOG, var_buf);
650: var_buf := 'Owning org : '||arg_org_id;
651: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 649: fnd_file.put_line(FND_FILE.LOG, var_buf);

645: IF var_debug THEN
646: var_buf := '+++++++++++++++++';
647: fnd_file.put_line(FND_FILE.LOG, var_buf);
648: var_buf := 'User ID : '||var_user_id;
649: fnd_file.put_line(FND_FILE.LOG, var_buf);
650: var_buf := 'Owning org : '||arg_org_id;
651: fnd_file.put_line(FND_FILE.LOG, var_buf);
652: var_buf := 'Plan Name : '||lv_plan_name;
653: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 651: fnd_file.put_line(FND_FILE.LOG, var_buf);

647: fnd_file.put_line(FND_FILE.LOG, var_buf);
648: var_buf := 'User ID : '||var_user_id;
649: fnd_file.put_line(FND_FILE.LOG, var_buf);
650: var_buf := 'Owning org : '||arg_org_id;
651: fnd_file.put_line(FND_FILE.LOG, var_buf);
652: var_buf := 'Plan Name : '||lv_plan_name;
653: fnd_file.put_line(FND_FILE.LOG, var_buf);
654: var_buf := 'Plan type : '||var_plan_type;
655: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 653: fnd_file.put_line(FND_FILE.LOG, var_buf);

649: fnd_file.put_line(FND_FILE.LOG, var_buf);
650: var_buf := 'Owning org : '||arg_org_id;
651: fnd_file.put_line(FND_FILE.LOG, var_buf);
652: var_buf := 'Plan Name : '||lv_plan_name;
653: fnd_file.put_line(FND_FILE.LOG, var_buf);
654: var_buf := 'Plan type : '||var_plan_type;
655: fnd_file.put_line(FND_FILE.LOG, var_buf);
656: var_buf := 'Use start date : '||arg_use_start_date;
657: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 655: fnd_file.put_line(FND_FILE.LOG, var_buf);

651: fnd_file.put_line(FND_FILE.LOG, var_buf);
652: var_buf := 'Plan Name : '||lv_plan_name;
653: fnd_file.put_line(FND_FILE.LOG, var_buf);
654: var_buf := 'Plan type : '||var_plan_type;
655: fnd_file.put_line(FND_FILE.LOG, var_buf);
656: var_buf := 'Use start date : '||arg_use_start_date;
657: fnd_file.put_line(FND_FILE.LOG, var_buf);
658: var_buf := 'Start date : '||var_start_date;
659: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 657: fnd_file.put_line(FND_FILE.LOG, var_buf);

653: fnd_file.put_line(FND_FILE.LOG, var_buf);
654: var_buf := 'Plan type : '||var_plan_type;
655: fnd_file.put_line(FND_FILE.LOG, var_buf);
656: var_buf := 'Use start date : '||arg_use_start_date;
657: fnd_file.put_line(FND_FILE.LOG, var_buf);
658: var_buf := 'Start date : '||var_start_date;
659: fnd_file.put_line(FND_FILE.LOG, var_buf);
660: var_buf := 'WIP default job prefix : '||var_default_job_prefix;
661: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 659: fnd_file.put_line(FND_FILE.LOG, var_buf);

655: fnd_file.put_line(FND_FILE.LOG, var_buf);
656: var_buf := 'Use start date : '||arg_use_start_date;
657: fnd_file.put_line(FND_FILE.LOG, var_buf);
658: var_buf := 'Start date : '||var_start_date;
659: fnd_file.put_line(FND_FILE.LOG, var_buf);
660: var_buf := 'WIP default job prefix : '||var_default_job_prefix;
661: fnd_file.put_line(FND_FILE.LOG, var_buf);
662: var_buf := 'WIP group ID : '||var_wip_group_id;
663: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 661: fnd_file.put_line(FND_FILE.LOG, var_buf);

657: fnd_file.put_line(FND_FILE.LOG, var_buf);
658: var_buf := 'Start date : '||var_start_date;
659: fnd_file.put_line(FND_FILE.LOG, var_buf);
660: var_buf := 'WIP default job prefix : '||var_default_job_prefix;
661: fnd_file.put_line(FND_FILE.LOG, var_buf);
662: var_buf := 'WIP group ID : '||var_wip_group_id;
663: fnd_file.put_line(FND_FILE.LOG, var_buf);
664: var_buf := 'PO group by : '||var_po_group_by;
665: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 663: fnd_file.put_line(FND_FILE.LOG, var_buf);

659: fnd_file.put_line(FND_FILE.LOG, var_buf);
660: var_buf := 'WIP default job prefix : '||var_default_job_prefix;
661: fnd_file.put_line(FND_FILE.LOG, var_buf);
662: var_buf := 'WIP group ID : '||var_wip_group_id;
663: fnd_file.put_line(FND_FILE.LOG, var_buf);
664: var_buf := 'PO group by : '||var_po_group_by;
665: fnd_file.put_line(FND_FILE.LOG, var_buf);
666: var_buf := 'PO batch number : '||var_po_batch_number;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 665: fnd_file.put_line(FND_FILE.LOG, var_buf);

661: fnd_file.put_line(FND_FILE.LOG, var_buf);
662: var_buf := 'WIP group ID : '||var_wip_group_id;
663: fnd_file.put_line(FND_FILE.LOG, var_buf);
664: var_buf := 'PO group by : '||var_po_group_by;
665: fnd_file.put_line(FND_FILE.LOG, var_buf);
666: var_buf := 'PO batch number : '||var_po_batch_number;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
668: var_buf := 'Demand Class : '||var_demand_class;
669: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 667: fnd_file.put_line(FND_FILE.LOG, var_buf);

663: fnd_file.put_line(FND_FILE.LOG, var_buf);
664: var_buf := 'PO group by : '||var_po_group_by;
665: fnd_file.put_line(FND_FILE.LOG, var_buf);
666: var_buf := 'PO batch number : '||var_po_batch_number;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
668: var_buf := 'Demand Class : '||var_demand_class;
669: fnd_file.put_line(FND_FILE.LOG, var_buf);
670: END IF;
671:

Line 669: fnd_file.put_line(FND_FILE.LOG, var_buf);

665: fnd_file.put_line(FND_FILE.LOG, var_buf);
666: var_buf := 'PO batch number : '||var_po_batch_number;
667: fnd_file.put_line(FND_FILE.LOG, var_buf);
668: var_buf := 'Demand Class : '||var_demand_class;
669: fnd_file.put_line(FND_FILE.LOG, var_buf);
670: END IF;
671:
672: begin
673: -- populating batch_id from destination side seq.

Line 678: fnd_file.put_line(FND_FILE.LOG, sqlerrm);

674: Execute immediate 'select mrp_workbench_query_s.nextval
675: FROM DUAL '
676: into MSC_Rel_Plan_PUB.g_batch_id;
677: exception when others then
678: fnd_file.put_line(FND_FILE.LOG, sqlerrm);
679: end;
680:
681: fnd_file.put_line(FND_FILE.LOG, MSC_Rel_Plan_PUB.g_batch_id);
682: -- ------------------------------------------------------------------------

Line 681: fnd_file.put_line(FND_FILE.LOG, MSC_Rel_Plan_PUB.g_batch_id);

677: exception when others then
678: fnd_file.put_line(FND_FILE.LOG, sqlerrm);
679: end;
680:
681: fnd_file.put_line(FND_FILE.LOG, MSC_Rel_Plan_PUB.g_batch_id);
682: -- ------------------------------------------------------------------------
683: -- Get planned orders and reschedules that meet the auto-release criteria
684: -- ------------------------------------------------------------------------
685: var_entity := 'Planned Orders';

Line 758: fnd_file.put_line(FND_FILE.LOG, var_buf);

754: WHEN NO_DATA_FOUND THEN
755: var_location_id := NULL;
756: WHEN OTHERS THEN
757: var_buf := var_entity||': '||sqlerrm;
758: fnd_file.put_line(FND_FILE.LOG, var_buf);
759:
760: ROLLBACK;
761:
762: CLOSE planned_orders_and_reschedules;

Line 771: fnd_file.put_line(FND_FILE.LOG, var_buf);

767: END;
768:
769: IF var_debug THEN
770: var_buf := '=================';
771: fnd_file.put_line(FND_FILE.LOG, var_buf);
772: var_buf := 'Organization ID : '||var_org_id;
773: fnd_file.put_line(FND_FILE.LOG, var_buf);
774: var_buf := 'Location ID : '||var_location_id;
775: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 773: fnd_file.put_line(FND_FILE.LOG, var_buf);

769: IF var_debug THEN
770: var_buf := '=================';
771: fnd_file.put_line(FND_FILE.LOG, var_buf);
772: var_buf := 'Organization ID : '||var_org_id;
773: fnd_file.put_line(FND_FILE.LOG, var_buf);
774: var_buf := 'Location ID : '||var_location_id;
775: fnd_file.put_line(FND_FILE.LOG, var_buf);
776: END IF;
777: END IF; /* Org ID */

Line 775: fnd_file.put_line(FND_FILE.LOG, var_buf);

771: fnd_file.put_line(FND_FILE.LOG, var_buf);
772: var_buf := 'Organization ID : '||var_org_id;
773: fnd_file.put_line(FND_FILE.LOG, var_buf);
774: var_buf := 'Location ID : '||var_location_id;
775: fnd_file.put_line(FND_FILE.LOG, var_buf);
776: END IF;
777: END IF; /* Org ID */
778:
779: -- ----------------------------------------------------------------------

Line 827: fnd_file.put_line(FND_FILE.LOG, var_buf);

823: WHEN NO_DATA_FOUND THEN
824: var_wip_class_code := NULL;
825: WHEN OTHERS THEN
826: var_buf := var_entity||': '||sqlerrm;
827: fnd_file.put_line(FND_FILE.LOG, var_buf);
828:
829: ROLLBACK;
830: CLOSE planned_orders_and_reschedules;
831: retcode := 2;

Line 880: fnd_file.put_line(FND_FILE.LOG, var_buf);

876: -- END IF;
877:
878: IF var_debug THEN
879: var_buf := '----------------- ';
880: fnd_file.put_line(FND_FILE.LOG, var_buf);
881: var_buf := 'Item ID : '||var_inventory_item_id;
882: fnd_file.put_line(FND_FILE.LOG, var_buf);
883: var_buf := 'Item Make/Buy : '||var_make_buy_code;
884: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 882: fnd_file.put_line(FND_FILE.LOG, var_buf);

878: IF var_debug THEN
879: var_buf := '----------------- ';
880: fnd_file.put_line(FND_FILE.LOG, var_buf);
881: var_buf := 'Item ID : '||var_inventory_item_id;
882: fnd_file.put_line(FND_FILE.LOG, var_buf);
883: var_buf := 'Item Make/Buy : '||var_make_buy_code;
884: fnd_file.put_line(FND_FILE.LOG, var_buf);
885: var_buf := 'WIP class code : '||var_wip_class_code;
886: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 884: fnd_file.put_line(FND_FILE.LOG, var_buf);

880: fnd_file.put_line(FND_FILE.LOG, var_buf);
881: var_buf := 'Item ID : '||var_inventory_item_id;
882: fnd_file.put_line(FND_FILE.LOG, var_buf);
883: var_buf := 'Item Make/Buy : '||var_make_buy_code;
884: fnd_file.put_line(FND_FILE.LOG, var_buf);
885: var_buf := 'WIP class code : '||var_wip_class_code;
886: fnd_file.put_line(FND_FILE.LOG, var_buf);
887: var_buf := 'Date : '||var_new_schedule_date;
888: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 886: fnd_file.put_line(FND_FILE.LOG, var_buf);

882: fnd_file.put_line(FND_FILE.LOG, var_buf);
883: var_buf := 'Item Make/Buy : '||var_make_buy_code;
884: fnd_file.put_line(FND_FILE.LOG, var_buf);
885: var_buf := 'WIP class code : '||var_wip_class_code;
886: fnd_file.put_line(FND_FILE.LOG, var_buf);
887: var_buf := 'Date : '||var_new_schedule_date;
888: fnd_file.put_line(FND_FILE.LOG, var_buf);
889: var_buf := 'Quantity : '||var_new_order_quantity;
890: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 888: fnd_file.put_line(FND_FILE.LOG, var_buf);

884: fnd_file.put_line(FND_FILE.LOG, var_buf);
885: var_buf := 'WIP class code : '||var_wip_class_code;
886: fnd_file.put_line(FND_FILE.LOG, var_buf);
887: var_buf := 'Date : '||var_new_schedule_date;
888: fnd_file.put_line(FND_FILE.LOG, var_buf);
889: var_buf := 'Quantity : '||var_new_order_quantity;
890: fnd_file.put_line(FND_FILE.LOG, var_buf);
891: var_buf := 'Planner emp ID : '||var_planner_employee_id;
892: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 890: fnd_file.put_line(FND_FILE.LOG, var_buf);

886: fnd_file.put_line(FND_FILE.LOG, var_buf);
887: var_buf := 'Date : '||var_new_schedule_date;
888: fnd_file.put_line(FND_FILE.LOG, var_buf);
889: var_buf := 'Quantity : '||var_new_order_quantity;
890: fnd_file.put_line(FND_FILE.LOG, var_buf);
891: var_buf := 'Planner emp ID : '||var_planner_employee_id;
892: fnd_file.put_line(FND_FILE.LOG, var_buf);
893: var_buf := 'WIP job status : '||var_impl_status_code;
894: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 892: fnd_file.put_line(FND_FILE.LOG, var_buf);

888: fnd_file.put_line(FND_FILE.LOG, var_buf);
889: var_buf := 'Quantity : '||var_new_order_quantity;
890: fnd_file.put_line(FND_FILE.LOG, var_buf);
891: var_buf := 'Planner emp ID : '||var_planner_employee_id;
892: fnd_file.put_line(FND_FILE.LOG, var_buf);
893: var_buf := 'WIP job status : '||var_impl_status_code;
894: fnd_file.put_line(FND_FILE.LOG, var_buf);
895: var_buf := 'WIP job prefix : '||var_job_prefix;
896: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 894: fnd_file.put_line(FND_FILE.LOG, var_buf);

890: fnd_file.put_line(FND_FILE.LOG, var_buf);
891: var_buf := 'Planner emp ID : '||var_planner_employee_id;
892: fnd_file.put_line(FND_FILE.LOG, var_buf);
893: var_buf := 'WIP job status : '||var_impl_status_code;
894: fnd_file.put_line(FND_FILE.LOG, var_buf);
895: var_buf := 'WIP job prefix : '||var_job_prefix;
896: fnd_file.put_line(FND_FILE.LOG, var_buf);
897: var_buf := 'Order Type : '||var_order_type;
898: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 896: fnd_file.put_line(FND_FILE.LOG, var_buf);

892: fnd_file.put_line(FND_FILE.LOG, var_buf);
893: var_buf := 'WIP job status : '||var_impl_status_code;
894: fnd_file.put_line(FND_FILE.LOG, var_buf);
895: var_buf := 'WIP job prefix : '||var_job_prefix;
896: fnd_file.put_line(FND_FILE.LOG, var_buf);
897: var_buf := 'Order Type : '||var_order_type;
898: fnd_file.put_line(FND_FILE.LOG, var_buf);
899: END IF;
900:

Line 898: fnd_file.put_line(FND_FILE.LOG, var_buf);

894: fnd_file.put_line(FND_FILE.LOG, var_buf);
895: var_buf := 'WIP job prefix : '||var_job_prefix;
896: fnd_file.put_line(FND_FILE.LOG, var_buf);
897: var_buf := 'Order Type : '||var_order_type;
898: fnd_file.put_line(FND_FILE.LOG, var_buf);
899: END IF;
900:
901: -- --------------------------------------------------------------------
902: -- -- Update WIP Jobs planned orders and reschedules

Line 994: fnd_file.put_line(FND_FILE.LOG, var_buf);

990: AND current_employee_flag= 1;
991:
992: IF var_debug THEN
993: var_buf := '----------------- ';
994: fnd_file.put_line(FND_FILE.LOG, var_buf);
995: var_buf := 'Item ID : '||var_inventory_item_id;
996: fnd_file.put_line(FND_FILE.LOG, var_buf);
997: var_buf := 'Item Make/Buy : '||var_make_buy_code;
998: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 996: fnd_file.put_line(FND_FILE.LOG, var_buf);

992: IF var_debug THEN
993: var_buf := '----------------- ';
994: fnd_file.put_line(FND_FILE.LOG, var_buf);
995: var_buf := 'Item ID : '||var_inventory_item_id;
996: fnd_file.put_line(FND_FILE.LOG, var_buf);
997: var_buf := 'Item Make/Buy : '||var_make_buy_code;
998: fnd_file.put_line(FND_FILE.LOG, var_buf);
999: var_buf := 'Date : '||var_new_schedule_date;
1000: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 998: fnd_file.put_line(FND_FILE.LOG, var_buf);

994: fnd_file.put_line(FND_FILE.LOG, var_buf);
995: var_buf := 'Item ID : '||var_inventory_item_id;
996: fnd_file.put_line(FND_FILE.LOG, var_buf);
997: var_buf := 'Item Make/Buy : '||var_make_buy_code;
998: fnd_file.put_line(FND_FILE.LOG, var_buf);
999: var_buf := 'Date : '||var_new_schedule_date;
1000: fnd_file.put_line(FND_FILE.LOG, var_buf);
1001: var_buf := 'Quantity : '||var_new_order_quantity;
1002: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 1000: fnd_file.put_line(FND_FILE.LOG, var_buf);

996: fnd_file.put_line(FND_FILE.LOG, var_buf);
997: var_buf := 'Item Make/Buy : '||var_make_buy_code;
998: fnd_file.put_line(FND_FILE.LOG, var_buf);
999: var_buf := 'Date : '||var_new_schedule_date;
1000: fnd_file.put_line(FND_FILE.LOG, var_buf);
1001: var_buf := 'Quantity : '||var_new_order_quantity;
1002: fnd_file.put_line(FND_FILE.LOG, var_buf);
1003: var_buf := 'Planner emp ID : '||var_planner_employee_id;
1004: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 1002: fnd_file.put_line(FND_FILE.LOG, var_buf);

998: fnd_file.put_line(FND_FILE.LOG, var_buf);
999: var_buf := 'Date : '||var_new_schedule_date;
1000: fnd_file.put_line(FND_FILE.LOG, var_buf);
1001: var_buf := 'Quantity : '||var_new_order_quantity;
1002: fnd_file.put_line(FND_FILE.LOG, var_buf);
1003: var_buf := 'Planner emp ID : '||var_planner_employee_id;
1004: fnd_file.put_line(FND_FILE.LOG, var_buf);
1005: var_buf := 'Active employee : '||var_count;
1006: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 1004: fnd_file.put_line(FND_FILE.LOG, var_buf);

1000: fnd_file.put_line(FND_FILE.LOG, var_buf);
1001: var_buf := 'Quantity : '||var_new_order_quantity;
1002: fnd_file.put_line(FND_FILE.LOG, var_buf);
1003: var_buf := 'Planner emp ID : '||var_planner_employee_id;
1004: fnd_file.put_line(FND_FILE.LOG, var_buf);
1005: var_buf := 'Active employee : '||var_count;
1006: fnd_file.put_line(FND_FILE.LOG, var_buf);
1007: var_buf := 'Order Type : '||var_order_type;
1008: fnd_file.put_line(FND_FILE.LOG, var_buf);

Line 1006: fnd_file.put_line(FND_FILE.LOG, var_buf);

1002: fnd_file.put_line(FND_FILE.LOG, var_buf);
1003: var_buf := 'Planner emp ID : '||var_planner_employee_id;
1004: fnd_file.put_line(FND_FILE.LOG, var_buf);
1005: var_buf := 'Active employee : '||var_count;
1006: fnd_file.put_line(FND_FILE.LOG, var_buf);
1007: var_buf := 'Order Type : '||var_order_type;
1008: fnd_file.put_line(FND_FILE.LOG, var_buf);
1009: END IF;
1010:

Line 1008: fnd_file.put_line(FND_FILE.LOG, var_buf);

1004: fnd_file.put_line(FND_FILE.LOG, var_buf);
1005: var_buf := 'Active employee : '||var_count;
1006: fnd_file.put_line(FND_FILE.LOG, var_buf);
1007: var_buf := 'Order Type : '||var_order_type;
1008: fnd_file.put_line(FND_FILE.LOG, var_buf);
1009: END IF;
1010:
1011: IF (var_count = 0) THEN
1012:

Line 1041: fnd_file.put_line(FND_FILE.LOG, var_buf);

1037:
1038: retcode := 1;
1039:
1040: var_buf := '................. ';
1041: fnd_file.put_line(FND_FILE.LOG, var_buf);
1042:
1043: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:

Line 1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1040: var_buf := '................. ';
1041: fnd_file.put_line(FND_FILE.LOG, var_buf);
1042:
1043: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER1');
1044: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1045:
1046: fnd_message.set_name('MRP', 'MRP_UNRELEASED_ORDER2');
1047: fnd_message.set_token('PLANNER_VALUE', var_planner_code);
1048: fnd_message.set_token('ORG_VALUE', var_org_code);

Line 1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1048: fnd_message.set_token('ORG_VALUE', var_org_code);
1049: fnd_message.set_token('ITEM_VALUE', var_item);
1050: fnd_message.set_token('DATE_VALUE', to_char(var_new_schedule_date));
1051: fnd_message.set_token('QTY_VALUE', to_char(var_new_order_quantity));
1052: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1053:
1054: ELSE
1055:
1056: -- ------------------------------------------------------------------

Line 1213: fnd_file.put_line(FND_FILE.LOG, var_buf);

1209: WHERE plan_id=arg_plan_id;
1210: commit;
1211:
1212: var_buf := '+++++++++++++++++ ';
1213: fnd_file.put_line(FND_FILE.LOG, var_buf);
1214:
1215: var_released_instance_count:= var_released_instance_id.count;
1216:
1217: DECLARE

Line 1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1228: where instance_id= var_released_instance_id(i);
1229:
1230: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1231: fnd_message.set_token('INSTANCE', lv_instance_code);
1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1232: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1233:
1234: fnd_message.set_name('MRP', 'LOADED_WIP');
1235: fnd_message.set_token('VALUE', to_char(var_loaded_jobs(i)));
1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1236: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1237:
1238: fnd_message.set_name('MRP', 'LOADED_WIP');
1239: fnd_message.set_token('VALUE', to_char(var_loaded_lot_jobs(i))||' lot Jobs');
1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1240: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1241:
1242: fnd_message.set_name('MRP', 'LOADED_PO');
1243: fnd_message.set_token('VALUE', to_char(var_loaded_reqs(i)));
1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1244: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1245:
1246: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1247: fnd_message.set_token('VALUE', to_char(var_wip_req_id(i)));
1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1248: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1249:
1250: fnd_message.set_name('MRP', 'LOAD_WIP_REQUEST_ID');
1251: fnd_message.set_token('VALUE', to_char(var_osfm_req_id(i))||' OSFM Request Id');
1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1252: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1253:
1254: fnd_message.set_name('MRP', 'LOAD_PO_REQUEST_ID');
1255: fnd_message.set_token('VALUE', to_char(var_req_load_id(i)));
1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1256: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1257:
1258: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_JOB');
1259: fnd_message.set_token('VALUE', to_char(var_resched_jobs(i)));
1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1260: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1261:
1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1265:
1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1268:

Line 1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));

1262: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_REQS');
1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1265:
1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1268:
1269: /* Bug 2595278 - added Null condition */
1270: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN

Line 1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));

1263: fnd_message.set_token('VALUE', to_char(var_resched_reqs(i)));
1264: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1265:
1266: fnd_file.put_line(FND_FILE.LOG, 'Loaded internal repair order :'|| var_loaded_int_repair_orders(i));
1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1268:
1269: /* Bug 2595278 - added Null condition */
1270: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1271: fnd_file.new_line(FND_FILE.LOG, 1);

Line 1271: fnd_file.new_line(FND_FILE.LOG, 1);

1267: fnd_file.put_line(FND_FILE.LOG, 'Loaded external repair order :'|| var_loaded_ext_repair_orders(i));
1268:
1269: /* Bug 2595278 - added Null condition */
1270: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1271: fnd_file.new_line(FND_FILE.LOG, 1);
1272: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1273: var_buf := fnd_message.get;
1274: fnd_file.put_line(FND_FILE.LOG, var_buf);
1275:

Line 1274: fnd_file.put_line(FND_FILE.LOG, var_buf);

1270: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1271: fnd_file.new_line(FND_FILE.LOG, 1);
1272: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1273: var_buf := fnd_message.get;
1274: fnd_file.put_line(FND_FILE.LOG, var_buf);
1275:
1276: retcode := 2;
1277: errbuf := var_buf;
1278: END IF;

Line 1282: fnd_file.new_line(FND_FILE.LOG, 1);

1278: END IF;
1279:
1280:
1281: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1282: fnd_file.new_line(FND_FILE.LOG, 1);
1283: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1284: var_buf := fnd_message.get;
1285: fnd_file.put_line(FND_FILE.LOG, var_buf);
1286:

Line 1285: fnd_file.put_line(FND_FILE.LOG, var_buf);

1281: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1282: fnd_file.new_line(FND_FILE.LOG, 1);
1283: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1284: var_buf := fnd_message.get;
1285: fnd_file.put_line(FND_FILE.LOG, var_buf);
1286:
1287: retcode := 2;
1288: errbuf := var_buf;
1289: END IF;

Line 1292: fnd_file.new_line(FND_FILE.LOG, 1);

1288: errbuf := var_buf;
1289: END IF;
1290:
1291: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1292: fnd_file.new_line(FND_FILE.LOG, 1);
1293: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1294: var_buf := fnd_message.get;
1295: fnd_file.put_line(FND_FILE.LOG, var_buf);
1296:

Line 1295: fnd_file.put_line(FND_FILE.LOG, var_buf);

1291: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1292: fnd_file.new_line(FND_FILE.LOG, 1);
1293: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1294: var_buf := fnd_message.get;
1295: fnd_file.put_line(FND_FILE.LOG, var_buf);
1296:
1297: retcode := 2;
1298: errbuf := var_buf;
1299: END IF;

Line 1303: fnd_file.put_line(FND_FILE.LOG, var_buf);

1299: END IF;
1300:
1301: IF ((var_loaded_int_repair_orders(i) > 0) AND (var_int_repair_orders_id(i) = 0)) THEN
1302: var_buf:= 'cannot submit the internal repair order request';
1303: fnd_file.put_line(FND_FILE.LOG, var_buf);
1304:
1305: retcode := 2;
1306: errbuf := var_buf;
1307: END IF;

Line 1311: fnd_file.put_line(FND_FILE.LOG, var_buf);

1307: END IF;
1308:
1309: IF ((var_loaded_ext_repair_orders(i) > 0) AND (var_ext_repair_orders_id(i) = 0)) THEN
1310: var_buf:= 'cannot submit the external repair order request';
1311: fnd_file.put_line(FND_FILE.LOG, var_buf);
1312:
1313: retcode := 2;
1314: errbuf := var_buf;
1315: END IF;

Line 1320: fnd_file.put_line(FND_FILE.LOG, var_buf);

1316:
1317: END LOOP;
1318:
1319: var_buf := '++++++++++';
1320: fnd_file.put_line(FND_FILE.LOG, var_buf);
1321: var_buf := 'PO reschedules';
1322: fnd_file.put_line(FND_FILE.LOG, var_buf);
1323:
1324: FOR i IN 1..var_count_po LOOP

Line 1322: fnd_file.put_line(FND_FILE.LOG, var_buf);

1318:
1319: var_buf := '++++++++++';
1320: fnd_file.put_line(FND_FILE.LOG, var_buf);
1321: var_buf := 'PO reschedules';
1322: fnd_file.put_line(FND_FILE.LOG, var_buf);
1323:
1324: FOR i IN 1..var_count_po LOOP
1325: select instance_code
1326: into lv_instance_code

Line 1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1328: where instance_id= var_released_instance(i);
1329:
1330: fnd_message.set_name('MSC', 'MSC_AR_LOADED_INSTANCE');
1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1336: END LOOP;

Line 1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

1331: fnd_message.set_token('INSTANCE', lv_instance_code);
1332: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1333: fnd_message.set_name('MSC', 'LOADED_RESCHEDULED_PO');
1334: fnd_message.set_token('VALUE', to_char(var_po_res_count(i)));
1335: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
1336: END LOOP;
1337:
1338: END;
1339: RETURN;

Line 1347: fnd_file.put_line(FND_FILE.LOG, var_buf);

1343:
1344: IF planned_orders_and_reschedules%ISOPEN THEN CLOSE planned_orders_and_reschedules; END IF;
1345:
1346: var_buf := var_entity||': '||sqlerrm;
1347: fnd_file.put_line(FND_FILE.LOG, var_buf);
1348:
1349: ROLLBACK;
1350: retcode := 2;
1351: errbuf := var_buf;

Line 1455: fnd_file.new_line(FND_FILE.LOG, 1);

1451:
1452:
1453: /* Bug 2595278 - added Null condition */
1454: IF ((var_loaded_jobs(i) > 0) AND ((var_wip_req_id(i) = 0) OR (var_wip_req_id(i) IS NULL))) THEN
1455: fnd_file.new_line(FND_FILE.LOG, 1);
1456: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-JOBS');
1457: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1458: RETCODE := MSC_UTIL.G_ERROR;
1459: END IF;

Line 1463: fnd_file.new_line(FND_FILE.LOG, 1);

1459: END IF;
1460:
1461:
1462: IF ((var_loaded_lot_jobs(i) > 0) AND (var_osfm_req_id(i) = 0)) THEN
1463: fnd_file.new_line(FND_FILE.LOG, 1);
1464: fnd_message.set_name('MRP', 'CANNOT SUBMIT LOT-JOBS INTERFACE');
1465: ERRMSG := ERRMSG || ' ' || fnd_message.get;
1466: RETCODE := MSC_UTIL.G_ERROR;
1467: END IF;

Line 1470: fnd_file.new_line(FND_FILE.LOG, 1);

1466: RETCODE := MSC_UTIL.G_ERROR;
1467: END IF;
1468:
1469: IF ((var_loaded_reqs(i) > 0) AND (var_req_load_id(i) = 0)) THEN
1470: fnd_file.new_line(FND_FILE.LOG, 1);
1471: fnd_message.set_name('MRP', 'CANNOT SUBMIT REQUEST-REQS');
1472: ERRMSG := ERRMSG || ' ' ||fnd_message.get;
1473: RETCODE := MSC_UTIL.G_ERROR;
1474: END IF;