656: BEGIN
657: l_text := p_text;
658:
659: IF l_text IS NULL THEN
660: l_text := FND_MESSAGE.GET;
661: END IF;
662:
663: IF l_text IS NOT NULL THEN
664: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_text);
775: IF l_count_sm_inc > 0 THEN
776: l_completion_status := 'WARNING';
777: END IF;
778:
779: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_COUNTS');
780: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
781: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
782: print_output;
783:
776: l_completion_status := 'WARNING';
777: END IF;
778:
779: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_COUNTS');
780: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
781: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
782: print_output;
783:
784: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
777: END IF;
778:
779: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_COUNTS');
780: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
781: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
782: print_output;
783:
784: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
785: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
780: FND_MESSAGE.SET_TOKEN('COUNT_PROCESSED', l_count_sm);
781: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
782: print_output;
783:
784: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
785: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
786: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
787: print_output;
788:
781: FND_MESSAGE.SET_TOKEN('COUNT_INCOMPLETE', l_count_sm_inc);
782: print_output;
783:
784: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
785: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
786: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
787: print_output;
788:
789: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
782: print_output;
783:
784: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRIP_COUNTS');
785: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
786: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
787: print_output;
788:
789: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
790: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
785: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_trips);
786: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
787: print_output;
788:
789: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
790: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
791: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
792: print_output;
793:
786: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_trips_nu);
787: print_output;
788:
789: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
790: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
791: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
792: print_output;
793:
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
787: print_output;
788:
789: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DEL_COUNTS');
790: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
791: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
792: print_output;
793:
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
795: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
790: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dels);
791: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
792: print_output;
793:
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
795: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
796: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dds_nu);
797: print_output;
798:
791: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dels_nu);
792: print_output;
793:
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
795: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
796: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dds_nu);
797: print_output;
798:
799: EXCEPTION
792: print_output;
793:
794: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_DD_COUNTS');
795: FND_MESSAGE.SET_TOKEN('COUNT_UPDATED', l_count_dds);
796: FND_MESSAGE.SET_TOKEN('COUNT_NOT_UPDATED', l_count_dds_nu);
797: print_output;
798:
799: EXCEPTION
800: WHEN OTHERS THEN
814: ROLLBACK;
815: END;
816:
817: IF l_completion_status IN ('WARNING', 'ERROR') THEN
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_SM_TRY_AGAIN');
819: print_output;
820: END IF;
821:
822: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,