DBA Data[Home] [Help]

APPS.WSH_AUTO_MANIFEST dependencies on FND_FILE

Line 675: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

671: l_autopack :='Yes';
672: END IF;
673:
674: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_PARM');
675: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
676: FND_FILE.put_line(FND_FILE.output,'==========');
677:
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DOC_TYPE');
679: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));

Line 676: FND_FILE.put_line(FND_FILE.output,'==========');

672: END IF;
673:
674: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_PARM');
675: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
676: FND_FILE.put_line(FND_FILE.output,'==========');
677:
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DOC_TYPE');
679: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));
680: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 680: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

676: FND_FILE.put_line(FND_FILE.output,'==========');
677:
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DOC_TYPE');
679: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));
680: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
681:
682: FND_MESSAGE.SET_NAME('WSH', 'WSH_SHIP_TYPE');
683: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));
684: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 684: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

680: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
681:
682: FND_MESSAGE.SET_NAME('WSH', 'WSH_SHIP_TYPE');
683: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));
684: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
685:
686: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ORG');
687: FND_MESSAGE.SET_TOKEN('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
688: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 688: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

684: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
685:
686: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ORG');
687: FND_MESSAGE.SET_TOKEN('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
688: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
689:
690: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORDER_FROM');
691: FND_MESSAGE.SET_TOKEN('ORDER',p_src_header_num_from );
692: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 692: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

688: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
689:
690: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORDER_FROM');
691: FND_MESSAGE.SET_TOKEN('ORDER',p_src_header_num_from );
692: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
693:
694: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORDER_TO');
695: FND_MESSAGE.SET_TOKEN('ORDER',p_src_header_num_to );
696: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 696: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

692: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
693:
694: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORDER_TO');
695: FND_MESSAGE.SET_TOKEN('ORDER',p_src_header_num_to );
696: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
697:
698: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_CARRIER');
699: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
700: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 700: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

696: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
697:
698: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_CARRIER');
699: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
700: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
701:
702: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_CUSTOMER');
703: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_customer_name);
704: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 704: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

700: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
701:
702: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_CUSTOMER');
703: FND_MESSAGE.SET_TOKEN('CUSTOMER_NAME', l_customer_name);
704: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
705:
706: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SHIP_TO');
707: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_location);
708: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 708: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

704: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
705:
706: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SHIP_TO');
707: FND_MESSAGE.SET_TOKEN('SHIP_TO', l_location);
708: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
709:
710: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SCH_FROM');
711: FND_MESSAGE.SET_TOKEN('SCH_FROM_DATE', p_scheduled_from_date);
712: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 712: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

708: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
709:
710: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SCH_FROM');
711: FND_MESSAGE.SET_TOKEN('SCH_FROM_DATE', p_scheduled_from_date);
712: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
713:
714: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SCH_TO');
715: FND_MESSAGE.SET_TOKEN('SCH_TO_DATE', p_scheduled_to_date);
716: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 716: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

712: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
713:
714: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SCH_TO');
715: FND_MESSAGE.SET_TOKEN('SCH_TO_DATE', p_scheduled_to_date);
716: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
717:
718: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_AUTOPACK');
719: FND_MESSAGE.SET_TOKEN('AUTOPACK', l_autopack);
720: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 720: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

716: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
717:
718: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_AUTOPACK');
719: FND_MESSAGE.SET_TOKEN('AUTOPACK', l_autopack);
720: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
721:
722: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_LOG_LEVEL');
723: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_log_level));
724: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 724: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

720: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
721:
722: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_LOG_LEVEL');
723: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_log_level));
724: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
725:
726: IF (l_delivery_count < 1 ) THEN
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: FND_FILE.put_line(FND_FILE.output,' ');

Line 728: FND_FILE.put_line(FND_FILE.output,' ');

724: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
725:
726: IF (l_delivery_count < 1 ) THEN
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: FND_FILE.put_line(FND_FILE.output,' ');
729: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DEL_FOR_PARAMETERS');
730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
731: IF l_debug_on THEN
732: wsh_debug_sv.log(l_module_name,l_msg_summary);

Line 730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

726: IF (l_delivery_count < 1 ) THEN
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: FND_FILE.put_line(FND_FILE.output,' ');
729: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DEL_FOR_PARAMETERS');
730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
731: IF l_debug_on THEN
732: wsh_debug_sv.log(l_module_name,l_msg_summary);
733: END IF;
734:

Line 736: FND_FILE.put_line(FND_FILE.output,' ');

732: wsh_debug_sv.log(l_module_name,l_msg_summary);
733: END IF;
734:
735: ELSE
736: FND_FILE.put_line(FND_FILE.output,' ');
737: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SUMMARY');
738: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
739:
740: FND_FILE.put_line(FND_FILE.output,'==============');

Line 738: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

734:
735: ELSE
736: FND_FILE.put_line(FND_FILE.output,' ');
737: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SUMMARY');
738: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
739:
740: FND_FILE.put_line(FND_FILE.output,'==============');
741: IF l_debug_on THEN
742: wsh_debug_sv.log (l_module_name,'All Deliveries: ',l_delivery_count);

Line 740: FND_FILE.put_line(FND_FILE.output,'==============');

736: FND_FILE.put_line(FND_FILE.output,' ');
737: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SUMMARY');
738: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
739:
740: FND_FILE.put_line(FND_FILE.output,'==============');
741: IF l_debug_on THEN
742: wsh_debug_sv.log (l_module_name,'All Deliveries: ',l_delivery_count);
743: END IF;
744: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ALL_DLVY');

Line 746: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

742: wsh_debug_sv.log (l_module_name,'All Deliveries: ',l_delivery_count);
743: END IF;
744: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ALL_DLVY');
745: FND_MESSAGE.SET_TOKEN('ALL_DLVY', to_char(l_delivery_count));
746: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
747:
748: IF l_debug_on THEN
749: wsh_debug_sv.log (l_module_name,'Success Deliveries: ',l_success_count);
750: END IF;

Line 753: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

749: wsh_debug_sv.log (l_module_name,'Success Deliveries: ',l_success_count);
750: END IF;
751: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_SUC_DLVY');
752: FND_MESSAGE.SET_TOKEN('SUC_DLVY', to_char(l_success_count));
753: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
754:
755: IF l_debug_on THEN
756: wsh_debug_sv.log (l_module_name,'Warning Deliveries: ',l_warning_count);
757: END IF;

Line 760: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

756: wsh_debug_sv.log (l_module_name,'Warning Deliveries: ',l_warning_count);
757: END IF;
758: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_WAR_DLVY');
759: FND_MESSAGE.SET_TOKEN('WAR_DLVY', to_char(l_warning_count));
760: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
761:
762: IF l_debug_on THEN
763: wsh_debug_sv.log (l_module_name,'Error Deliveries: ',l_error_count);
764: END IF;

Line 767: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

763: wsh_debug_sv.log (l_module_name,'Error Deliveries: ',l_error_count);
764: END IF;
765: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ERR_DLVY');
766: FND_MESSAGE.SET_TOKEN('ERR_DLVY', to_char(l_error_count));
767: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
768:
769: FND_FILE.put_line(FND_FILE.output,' ');
770: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HS_DLVY');
771: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

Line 769: FND_FILE.put_line(FND_FILE.output,' ');

765: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ERR_DLVY');
766: FND_MESSAGE.SET_TOKEN('ERR_DLVY', to_char(l_error_count));
767: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
768:
769: FND_FILE.put_line(FND_FILE.output,' ');
770: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HS_DLVY');
771: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
772:
773: IF l_debug_on THEN

Line 771: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

767: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
768:
769: FND_FILE.put_line(FND_FILE.output,' ');
770: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HS_DLVY');
771: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
772:
773: IF l_debug_on THEN
774: wsh_debug_sv.log(l_module_name,'Success Deliveries');
775: END IF;

Line 778: FND_FILE.put(FND_FILE.output,',');

774: wsh_debug_sv.log(l_module_name,'Success Deliveries');
775: END IF;
776: FOR s_count IN 1..l_success_count LOOP
777: IF (s_count <> 1) THEN
778: FND_FILE.put(FND_FILE.output,',');
779: IF l_debug_on THEN
780: wsh_debug_sv.log(l_module_name,',');
781: END IF;
782: END IF;

Line 783: FND_FILE.put(FND_FILE.output,l_success_delivery(s_count).delivery_name);

779: IF l_debug_on THEN
780: wsh_debug_sv.log(l_module_name,',');
781: END IF;
782: END IF;
783: FND_FILE.put(FND_FILE.output,l_success_delivery(s_count).delivery_name);
784: IF l_debug_on THEN
785: wsh_debug_sv.log (l_module_name,' ',l_success_delivery(s_count).delivery_name);
786: END IF;
787: END LOOP;

Line 792: FND_FILE.put_line(FND_FILE.output,' ');

788:
789: IF l_debug_on THEN
790: wsh_debug_sv.log(l_module_name,'Warning Deliveries');
791: END IF;
792: FND_FILE.put_line(FND_FILE.output,' ');
793: FND_FILE.put_line(FND_FILE.output,' ');
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HW_DLVY');
795: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
796:

Line 793: FND_FILE.put_line(FND_FILE.output,' ');

789: IF l_debug_on THEN
790: wsh_debug_sv.log(l_module_name,'Warning Deliveries');
791: END IF;
792: FND_FILE.put_line(FND_FILE.output,' ');
793: FND_FILE.put_line(FND_FILE.output,' ');
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HW_DLVY');
795: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
796:
797: FOR w_count IN 1..l_warning_count LOOP

Line 795: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

791: END IF;
792: FND_FILE.put_line(FND_FILE.output,' ');
793: FND_FILE.put_line(FND_FILE.output,' ');
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HW_DLVY');
795: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
796:
797: FOR w_count IN 1..l_warning_count LOOP
798: IF l_debug_on THEN
799: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).delivery_name||': '||

Line 802: FND_FILE.put_line(FND_FILE.output,l_warning_delivery(w_count).delivery_name||': '

798: IF l_debug_on THEN
799: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).delivery_name||': '||
800: l_warning_delivery(w_count).msg_summary);
801: END IF;
802: FND_FILE.put_line(FND_FILE.output,l_warning_delivery(w_count).delivery_name||': '
803: ||l_warning_delivery(w_count).msg_summary);
804:
805: IF (l_warning_delivery(w_count).msg_details IS NOT NULL ) THEN
806: IF l_debug_on THEN

Line 809: FND_FILE.put_line(FND_FILE.output,' '||l_warning_delivery(w_count).msg_details);

805: IF (l_warning_delivery(w_count).msg_details IS NOT NULL ) THEN
806: IF l_debug_on THEN
807: wsh_debug_sv.log(l_module_name,l_warning_delivery(w_count).msg_details);
808: END IF;
809: FND_FILE.put_line(FND_FILE.output,' '||l_warning_delivery(w_count).msg_details);
810: END IF;
811: END LOOP;
812:
813: IF l_debug_on THEN

Line 816: FND_FILE.put_line(FND_FILE.output,' ');

812:
813: IF l_debug_on THEN
814: wsh_debug_sv.log(l_module_name,'Error Deliveries');
815: END IF;
816: FND_FILE.put_line(FND_FILE.output,' ');
817: FND_FILE.put_line(FND_FILE.output,' ');
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HE_DLVY');
819: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
820:

Line 817: FND_FILE.put_line(FND_FILE.output,' ');

813: IF l_debug_on THEN
814: wsh_debug_sv.log(l_module_name,'Error Deliveries');
815: END IF;
816: FND_FILE.put_line(FND_FILE.output,' ');
817: FND_FILE.put_line(FND_FILE.output,' ');
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HE_DLVY');
819: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
820:
821: FOR e_count IN 1..l_error_count LOOP

Line 819: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);

815: END IF;
816: FND_FILE.put_line(FND_FILE.output,' ');
817: FND_FILE.put_line(FND_FILE.output,' ');
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_HE_DLVY');
819: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
820:
821: FOR e_count IN 1..l_error_count LOOP
822: IF l_debug_on THEN
823: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).delivery_name||': '||

Line 826: FND_FILE.put_line(FND_FILE.output,l_error_delivery(e_count).delivery_name||': '

822: IF l_debug_on THEN
823: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).delivery_name||': '||
824: l_error_delivery(e_count).msg_summary);
825: END IF;
826: FND_FILE.put_line(FND_FILE.output,l_error_delivery(e_count).delivery_name||': '
827: ||l_error_delivery(e_count).msg_summary);
828:
829: IF (l_error_delivery(e_count).msg_details IS NOT NULL) THEN
830: IF l_debug_on THEN

Line 833: FND_FILE.put_line(FND_FILE.output,' '||l_error_delivery(e_count).msg_details);

829: IF (l_error_delivery(e_count).msg_details IS NOT NULL) THEN
830: IF l_debug_on THEN
831: wsh_debug_sv.log(l_module_name,l_error_delivery(e_count).msg_details);
832: END IF;
833: FND_FILE.put_line(FND_FILE.output,' '||l_error_delivery(e_count).msg_details);
834: END IF;
835: END LOOP;
836:
837: END IF;