668: BEGIN
669: l_text := p_text;
670:
671: IF l_text IS NULL THEN
672: l_text := FND_MESSAGE.GET;
673: END IF;
674:
675: IF l_text IS NOT NULL THEN
676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_text);
787: IF l_count_sm_inc > 0 THEN
788: l_completion_status := 'WARNING';
789: END IF;
790:
791: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_COUNTS');
792: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
793: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
794: print_output;
795:
788: l_completion_status := 'WARNING';
789: END IF;
790:
791: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_COUNTS');
792: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
793: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
794: print_output;
795:
796: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
789: END IF;
790:
791: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_COUNTS');
792: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
793: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
794: print_output;
795:
796: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
797: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
792: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
793: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
794: print_output;
795:
796: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
797: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
798: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
799: print_output;
800:
793: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
794: print_output;
795:
796: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
797: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
798: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
799: print_output;
800:
801: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
794: print_output;
795:
796: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
797: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
798: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
799: print_output;
800:
801: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
802: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
797: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
798: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
799: print_output;
800:
801: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
802: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
803: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
804: print_output;
805:
798: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
799: print_output;
800:
801: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
802: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
803: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
804: print_output;
805:
806: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
799: print_output;
800:
801: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
802: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
803: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
804: print_output;
805:
806: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
807: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
802: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
803: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
804: print_output;
805:
806: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
807: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
808: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dds_nu);
809: print_output;
810:
803: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
804: print_output;
805:
806: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
807: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
808: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dds_nu);
809: print_output;
810:
811: EXCEPTION
804: print_output;
805:
806: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
807: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
808: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dds_nu);
809: print_output;
810:
811: EXCEPTION
812: WHEN OTHERS THEN
826: ROLLBACK;
827: END;
828:
829: IF l_completion_status IN ('WARNING', 'ERROR') THEN
830: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRY_AGAIN');
831: print_output;
832: END IF;
833:
834: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,